Tiempo de la consulta: 19.15 ms Después de la última consulta: 1.09 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.424 MB Filas devueltas: 5
SELECT i.*, c.alias AS categoryalias
FROM av04h_k2_items AS i
LEFT JOIN av04h_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-04 06:42:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:42:19')
AND i.access IN(1,1,2,3,5)
AND c.access IN(1,1,2,3,5)
AND c.published = 1
AND c.trash = 0
AND i.id IN(11,60,61,62,63,64,65,67,68,79,80,81,82,83,85,86,94,109,157,165,193,194,195,218,233,239,241,257,271,272,275,278,281,286,307,311,325,331,344,350,368,380,385,401,417,434,458,466,471,482,499,519,543,560,586,608,610,635,643,661,680,685,686,692,697,700,703,709,713,717,736,744,761,772,783,786,844,857,859,868,870,891,940,960,968,974,978,984,998,1013,1024,1032,1034,1042,1048,1054,1067,1079,1091,1098,1106,1127,1129,1138,1142,1150,1151,1168,1172,1187,1192,1194,1208,1226,1242,1254,1255,1256,1257,1269,1271,1279,1280,1284,1295,1304,1305,1319,1322,1335,1349,1365,1375,1420,1421,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1506,1553,1586,1595,1614,1624,1664,1698,1804,1811,1812,1841,1851,1852,1855,1870,1903,1906,1924,1928,1984,2001,2005,2077,2112,2148,2177,2193,2199,2301,2359,2394,2408,2432,2469,2478,2480,2530,2607,2629,2631,2691,2773,2814,2894,2962,2989,3024,3034,3056,3119,3202,3278,3340,3355,3364,3439,3513,3590,3594,3663,3696,3787,3836,3872,3963,3982,3992,4075,4132,4133,4168,4176,4197,4252,4271,4378,4477,4523,4558,4563,4580,4585,4586,4605,4728,4874,5014,5079,5226,5322,5496,5507,5508,5534,5635,5649,5662,5677,5720,5730,5743,5748,5778,5814,5847,5876,5894,5896,5990,6068,6133,6308,6323,6381,6386,6461,6470,6473,6484,6533,6570,6596,6600,6654,6663,6667,6707,6746,6748,6762,6788,6842,6955,6971,7107,7125,7182,7191,7200,7237,7271,7275,7277,7287,7296,7325,7356,7374,7421,7432,7435,7567,7568,7626,7688,7709,7726,7748,7801,7802,7830,7838,7839,7860,7868,7870,7931,7946,7951,7965,7966,7981,7985,8020,8069,8091,8108,8191,8206,8400,8464,8502,8518,8531,8555,8806,8809,8907,8938,8944,8952,9029,9062,9108,9198,9462,9532,9556,9767,9879,9895,9924,9944,9945,10048,10078,10100,10196,10243,10260,10280,10299,10302,10316,10323,10373,10383,10395,10443,10501,10560,10561,10613,10725,10736,10765,10775,10834,10851,10887,10915,11098,11129,11195,11223,11235,11278,11299,11314,11367,11377,11415,11482,11555,11565,11625,11688,11705,11711,11747,11758,11822,11859,11969,12042,12089,12133,12150,12170,12238,12293,12337,12379,12416,12424,12440,12472,12572,12618,12668,12716,12780,12816,12841,12917,12944,12946,12994,13004,13010,13029,13040,13062,13078,13084,13152,13153,13160,13177,13178,13258,13272,13278,13297,13316,13344,13388,13427,13437,13438,13467,13480,13481,13482,13503,13506,13525,13550,13596,13635,13657,13658,13660,13748,13750,13763,13783,13797,13816,13824,13836,13841,13871,13924,13934,13968,13969,14009,14103,14108,14151,14153,14156,14177,14246,14293,14309,14350,14424,14432,14477,14493,14506,14542,14546,14570,14596,14602,14603,14608,14635,14641,14651,14665,14710,14727,14729,14766,14874,14895,14946,14958,14977,15038,15039,15063,15114,15138,15145,15147,15166,15181,15183,15188,15198,15216,15229,15242,15244,15304,15311,15312,15315,15333,15352,15359,15368,15420,15464,15493,15522,15543,15551,15577,15626,15632,15644,15645,15667,15669,15722,15741,15766,15843,15874,15904,15957,15975,15978,15982,16014,16052,16083,16085,16123,16190,16201,16216,16217,16258,16281,16301,16322,16325,16334,16365,16386,16392,16436,16446,16464,16466,16488,16500,16520,16556,16561,16569,16606,16607,16629,16634,16660,16684,16713,16774,16780,16791,16830,16861,16925,16927,16966,16983,17039,17091,17126,17131,17142,17151,17157,17210,17218,17224,17253,17344,17362,17431,17443,17471,17521,17555,17567,17601,17630,17655,17657,17658,17660,17669,17710,17713,17761,17780,17799,17892,17921,17933,17941,17961,17968,17994,18013,18037,18039,18049,18055,18160,18162,18174,18181,18202,18214,18229,18260,18284,18285,18300,18311,18364,18382,18438,18465,18466,18467,18509,18520,18550,18567,18639,18647,18648,18665,18671,18695,18710,18720,18723,18762,18804,18813,18825,18828,18856,18901,18916,18972,19002,19007,19043,19047,19060,19067,19082,19123,19145,19148,19154,19170,19180,19185,19210,19253,19276,19287,19310,19327,19335,19343,19352,19376,19390,19407,19457,19460,19495,19505,19532,19577,19596,19612,19620,19633,19658,19668,19687,19704,19732,19751,19771,19773,19797,19804,19811,19849,19853,19870,19903,19908,19909,19932,19986,19998,20004,20010,20028,20031,20032,20043,20051,20056,20071,20083,20086,20095,20106,20141,20142,20156,20170,20179,20187,20202,20225,20234,20242,20256,20263,20265,20271,20289,20321,20335,20353,20391,20400,20404,20408,20449,20450,20513,20516,20535,20562,20564,20568,20569,20602,20630,20639,20680,20704,20714,20729,20737,20739,20773,20783,20847,20866,20871,20898,20933,20975,20982,20991,21050,21140,21161,21173,21189,21198,21205,21225,21259,21284,21286,21314,21386,21422,21432,21438,21513,21545,21555,21601,21611,21614,21620,21635,21636,21639,21640,21678,21681,21691,21694,21738,21764,21768,21773,21779,21782,21821,21854,21868,21891,21950,21959,21980,22013,22061,22100,22137,22146,22173,22175,22222,22228,22229,22254,22297,22331,22337,22344,22348,22361,22415,22416,22430,22486,22552,22559,22647,22653,22673,22694,22695,22712,22756,22764,22774,22822,22845,22848,22864,22872,22903,22908,22980,22988,23031,23039,23077,23101,23114,23185,23186,23221,23243,23275,23281,23295,23296,23311,23336,23344,23358,23371,23374,23394,23402,23406,23451,23495,23547,23555,23559,23585,23592,23593,23610,23612,23614,23636,23638,23691,23703,23715,23721,23722,23732,23747,23764,23769,23834,23840,23845,23858,23860,23921,23954,23962,24017,24028,24052,24059,24131,24170,24194,24198,24255,24264,24342,24343,24451,24455,24489,24524,24528,24540,24579,24586,24599,24639,24651,24653,24692,24707,24767,24791,24804,24819,24822,24838,24884,24897,24963,24985,25010,25039,25045,25081,25141,25156,25172,25182,25184,25197,25222,25226,25242,25264,25278,25284,25292,25303,25315,25317,25326,25348,25525,25556,25621,25640,25671,25693,25702,25705,25717,25731,25775,25872,25881,25885,25898,25906,25922,25943,25964,25987,26109,26154,26160,26167,26221,26284,26315,26348,26353,26414,26468,26505,26530,26565,26640,26671,26708,26722,26753,26760,26771,26797,26807,26852,26909,26944,26945,26958,26985,27024,27035,27046,27076,27086,27141,27143,27188,27237,27247,27280,27311,27383,27401,27460,27491,27529,27560,27573,27610,27668,27742,27775,27779,27859,27916,27956,27969,27992,28030,28169,28189,28233,28306,28336,28447,28454,28495,28598,28628,28746,28882,29121,29174,29180,29373,29374,29391,29412,29454,29548,29802,29833,29864,29888,30293,30481,30562,30740,30947,31026,31129,31384,31604,32484,32530,32905,32919,33345,34174,34676,35226,35299,35337,35360,35379,35434,35596,35603,35780,35926,36053,36085,36297,36330,36751,36810,36817,36961,37034,37107,37116,37170,37397,37403,37439,37454,38006,38103,38114,38122,38128,38315,38343,38398,38440,38446,38452,38530,38549,38674,39027,39052,39150,39163,39193,39241,39245,39276,39285,39315,39319,39347,39375,39389,39475,39492,39609,39706,39722,39747,39768,39802,40018,40023,40089,40231,40276,40398,40436,40438,40460,40465,40503,40535,40554,40555,40562,40614,40667,40685,40688,40774,40811,40817,40959,41040,41068,41150,41220,41246,41322,41418,41436,41499,41570,41576,41649,41686,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44351,44400,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45051,45136,45157,45302,45303)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | i | NULL | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 1294 | 1.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | cms_domad_francisca.i.catid | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.57 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 1.92 ms |
preparing | 0.99 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 14.14 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.04 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:668 |
13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |