Tiempo de la consulta: 3.99 ms Después de la última consulta: 0.59 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.324 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-07 01:31:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 01:31:29')
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(8,11,44,46,50,52,57,59,83,87,89,90,92,99,124,149,165,180,181,186,188,189,190,198,212,215,219,220,221,222,224,225,226,232,237,243,244,245,246,248,249,250,253,254,257,262,276,309,325,328,330,336,337,366,370,371,394,401,412,413,414,417,418,419,423,424,427,433,439,444,445,451,468,474,488,500,512,521,524,528,548,550,553,555,563,583,595,596,597,603,641,642,646,647,648,650,651,652,654,656,662,681,684,686,706,711,730,781,800,818,823,864,884,954,955,994,1023,1066,1072,1114,1145,1212,1227,1264,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1302,1316,1325,1347,1384,1388,1389,1390,1394,1412,1462,1477,1502,1503,1504,1505,1512,1520,1543,1579,1629,1655,1724,1773,1828,1873,1945,1960,1961,1979,1999,2012,2147,2185,2355,2473,2482,2638,2732,2746,2796,2811,2852,2869,2870,2871,2875,2894,2941,3017,3103,3181,3253,3269,3389,3417,3468,3469,3473,3506,3512,3544,3557,3559,3727,3794,3845,3868,3991,4094,4140,4233,4334,4360,4457,4459,4651,4766,4834,5025,5069,5106,5210,5285,5298,5354,5357,5375,5392,5415,5417,5428,5495,5555,5582,5631,5637,5646,5678,5702,5732,5756,5759,5768,5769,5777,5779,5780,5793,5794,5795,5804,5831,5889,5899,5910,5919,5923,5942,5999,6000,6002,6016,6022,6060,6066,6075,6151,6160,6193,6194,6220,6231,6258,6261,6312,6377,6391,6401,6420,6449,6476,6477,6550,6554,6564,6587,6623,6677,6774,6795,7008,7048,7195,7258,7391,7473,7531,7546,7576,7606,7687,7697,7738,7742,7760,7788,7853,7875,8009,8064,8074,8078,8081,8178,8192,8215,8218,8231,8255,8273,8374,8420,8461,8465,8487,8495,8522,8589,8623,8637,8650,8672,8691,8802,8811,8815,8861,8895,8955,8969,9121,9174,9175,9182,9186,9237,9256,9277,9362,9380,9394,9424,9549,9572,9579,9642,9663,9697,9701,9711,9773,9781,10060,10159,10258,10478,10572,11124,11131,11281,11320,11419,11564,11853,11883,11932,12027,12130,12383,12409,12505,12703,12764,12788,12846,12936,12974,13013,13037,13062,13130,13247,13285,13459,13556,13656,13887,13888,13971,14015,14177,14226,14341,14436,14452,14651,14714,14738,14740,14914,14919,14951,14957,14969,14978,15299,15455,15490,15534,15610,15660,15667,15723,15770,15803,15866,15871,15913,15932,15973,16046,16122,16203,16262,16335,16336,16374,16381,16421,16475,16522,16588,16648,16737,16995,17170,17172,17359,17373,17380,17412,17421,17470,17500,17518,17523,17565,17629,17671,17680,17813,17850,17860,17976,17977,18005,18035,18036,18186,18253,18299,18308,18368,18413,18436,18446,18490,18491,18497,18500,18521,18522,18524,18545,18575,18603,18635,18665,18718,18751,18768,18775,18779,18802,18828,18859,18868,18874,18902,18918,19005,19038,19267,19299,19307,19310,19397,19545,19568,19587,19625,19697,19744,19824,19937,19939,19996,20017,20051,20120,20150,20176,20184,20211,20212,20213,20243,20264,20277,20307,20327,20410,20553,20566,20709,20835,20852,20853,20922,20957,21049,21176,21237,21247,21273,21292,21322,21343,21419,21466,21584,21733,21751,21777,21820,21964,22050,22077,22361,22384,22405,22447,22484,22564,22588,22688,22699,22714,22772,22854,22858,22955,23017,23072,23085,23100,23192,23348,23354,23366,23418,23420,23433,23435,23449,23464,23511,23516,23533,23534,23573,23591,23596,23617,23769,23825,23847,23901,23932,23945,23951,23957,23992,23996,24063,24127,24144,24156,24245,24276,24375,24410,24502,24512,24563,24564,24613,24654,24681,24697,24706,24805,24865,24878,24908,24967,24973,25025,25030,25112,25147,25243,25346,25453,25460,25491,25628,25963,26056,26248,26473,26588,26595,26693,26826,26875,26920,26954,26975,26999,27135,27214,27345,27391,27409,27432,27438,27461,27483,27525,27593,27746,27805,27867,27904,28128,28140,28248,28416,28436,28884,29122,29159,29172,29173,29235,29328,29354,29715,29720,29788,30298,30451,30696,30965,32339,34278,35181,35368,35798,35922,36600,38489,39917,40199,40548,41268,41494)
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 | 695 | 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.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.21 ms |
preparing | 0.67 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.43 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 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 |