Tiempo de la consulta: 4.22 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.213 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 17:28:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:28:27')
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(78,85,155,165,204,214,279,285,303,349,450,495,507,531,572,583,666,667,675,718,808,844,863,869,879,885,900,954,1029,1039,1059,1089,1095,1101,1102,1158,1195,1216,1232,1249,1278,1279,1337,1372,1455,1456,1497,1538,1557,1571,1634,1648,1752,1802,1818,1846,1867,1904,1935,1941,1987,2064,2103,2288,2308,2325,2328,2379,2402,2404,2426,2442,2445,2456,2563,2573,2613,2625,2646,2647,2707,2718,2776,2826,2829,2831,2842,2857,2888,2914,2916,2924,2954,3037,3038,3040,3106,3107,3111,3117,3164,3174,3207,3248,3276,3285,3342,3361,3369,3402,3409,3412,3454,3462,3577,3591,3603,3620,3663,3812,4035,4078,4114,4150,4154,4284,4315,4417,4446,4499,4503,4589,4802,4823,5396,5451,5458,5461,5478,5513,5536,5605,5634,5686,5708,5854,5857,5896,5913,5932,5953,5977,5985,6056,6105,6106,6119,6120,6178,6340,6458,6534,6561,6629,6639,6663,6685,6736,6767,6791,6804,6815,6833,6876,6906,6956,6969,6995,7019,7042,7045,7122,7246,7282,7307,7321,7412,7447,7457,7466,7478,7484,7486,7490,7544,7548,7603,7662,7700,7720,7728,7736,7752,7816,7818,7841,7897,7924,7930,7987,7992,8046,8090,8103,8116,8118,8193,8229,8370,8381,8559,8568,8598,8680,8857,8864,8880,8915,8970,9029,9036,9068,9069,9087,9194,9217,9323,9364,9415,9435,9445,9467,9505,9533,9547,9710,9744,9745,9774,9786,9834,9847,9854,10095,10124,10266,10304,10322,10419,10452,10475,10478,10508,10532,10554,10630,10661,10666,10713,10727,10740,10761,10769,10801,10819,11053,11059,11076,11116,11149,11157,11170,11262,11277,11293,11373,11414,11416,11450,11472,11537,11757,11762,11821,11872,12019,12076,12114,12139,12185,12401,12410,12440,12617,12620,12625,12637,12642,12684,12692,12708,12875,13017,13058,13115,13122,13143,13175,13188,13191,13262,13294,13298,13311,13326,13376,13434,13496,13515,13574,13659,13671,13687,13707,13733,13828,13842,13926,13975,14092,14097,14105,14141,14142,14184,14244,14271,14273,14341,14367,14408,14413,14454,14456,14525,14613,14644,14646,14671,14692,14696,14767,14987,15004,15030,15032,15037,15086,15108,15111,15137,15149,15155,15247,15330,15346,15382,15403,15424,15439,15464,15492,15497,15507,15511,15542,15562,15565,15575,15626,15635,15641,15668,15683,15717,15728,15729,16060,16062,16128,16140,16161,16168,16178,16185,16190,16206,16257,16343,16462,16497,16507,16522,16534,16543,16566,16571,16632,16652,16657,16660,16671,16810,16827,16859,16889,16924,16929,16936,17000,17042,17070,17138,17153,17184,17215,17218,17222,17347,17358,17389,17392,17401,17425,17432,17444,17484,17558,17578,17596,17623,17641,17659,17688,17702,17704,17752,17766,17793,17818,17831,17961,17999,18038,18099,18119,18150,18169,18194,18226,18228,18294,18309,18316,18326,18328,18350,18367,18384,18419,18442,18498,18518,18528,18539,18543,18555,18577,18584,18612,18682,18687,18689,18718,18739,18768,18847,18848,18891,18901,18910,18914,18923,18978,18991,19020,19022,19051,19064,19083,19086,19105,19171,19185,19193,19207,19231,19233,19247,19274,19294,19304,19366,19386,19393,19396,19442,19453,19475,19524,19567,19604,19613,19621,19650,19661,19700,19711,19756,19814,19867,19918,19920,19930,19932,19945,19991,19995,20018,20036,20049,20091,20099,20103,20124,20162,20168,20183,20216,20295,20297,20354,20361,20374,20440,20441,20463,20464,20556,20561,20578,20579,20649,20654,20655,20659,20671,20678,20680,20685,20721,20768,20784,20794,20809,20845,20852,20874,20878,21088,21157,21161,21178,21244,21252,21294,21297,21388,21391,21420,21452,21477,21500,21510,21516,21522,21531,21536,21540,21610,21637,21639,21662,21709,21739,21861,21906,21912,21949,21973,21988,22059,22063,22082,22153,22183,22193,22205,22238,22244,22245,22246,22274,22317,22347,22348,22383,22457,22500,22502,22527,22553,22561,22571,22577,22612,22640,22656,22703,22711,22717,22742,22744,22770,22775,22805,22829,22874,22883,22895,22910,22924,22942,22963,22978,23034,23049,23064,23076,23081,23124,23148,23188,23195,23218,23219,23256,23286,23300,23312,23375,23408,23469,23519,23565,23606,23612,23695,23706,23710,23759,23763,23770,23830,23839,23857,23899,23900,23919,23922,23930,23955,23962,23967,23968,23988,24072,24075,24076,24113,24117,24141,24174,24219,24264,24268,24273,24282,24348,24366,24472,24498,24528,24557,24559,24576,24618,24624,24636,24639,24683,24735,24760,24765,24817,24860,24863,24888,24903,24924,24932,24943,24968,24979,24989,25048,25100,25111,25126,25174,25245,25261,25360,25374,25397,25425,25443,25561,25567,25621,25624,25673,25677,25696,25703,25717,25756,25799,25818,25872,25946,25947,25955,26020,26026,26030,26031,26041,26052,26092,26122,26208,26273,26293,26435,26454,26533,26563,26582,26665,26684,26772,26779,26804,26808,26818,26898,26910,26939,26961,26996,27022,27024,27026,27096,27131,27151,27157,27161,27170,27174,27186,27190,27248,27272,27283,27295,27304,27318,27356,27478,27490,27497,27520,27545,27577,27738,27745,27836,27945,27950,28140,28167,28184,28250,28344,28398,28431,28452,28639,28709,28845,29099,29224,29438,29620,29715,29790,32086,32673,32935,34007,35144,35614,35659,35846,35899,35975,36093,36154,36367,36402,36490,36583,36766,36831,36897,37290,37345,37531,37762,37837,37842,38023,38226,38237,38323,38352,38624,38850,38899,38920,38984,38991,39008,39214,39269,39277,39286,39308,39558,39580,39677,39737,39761,39801,39879,39892,40007,40120,40145,40194,40211,40213,40272,40375,40436,40531,40594,40739,40773,40887,40973,40989,41122,41217,41380,41381,41475,41636,41761,41826,42337,42486,42563,42571,42591,42680,42766,42944,43330,43529,43569,43570,43571,43755,43782,43856,43972,43973,44143,44160,44469,44497,44618,44843,44933,44998)
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 | 948 | 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.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.52 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |