Tiempo de la consulta: 3.96 ms Después de la última consulta: 0.97 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.178 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-05 16:46:58')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 16:46:58')
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(23,204,466,507,578,583,706,718,838,1059,1295,1455,1456,1490,1571,1634,1720,1755,1859,1904,1905,1929,1987,2022,2056,2109,2288,2308,2442,2445,2707,2767,2776,2799,2902,3177,3361,3570,3617,3682,3715,3790,3974,4084,4090,4114,4152,4230,4282,4284,4285,4306,4310,4417,4499,4715,4748,4820,4842,4891,4920,5007,5026,5033,5071,5083,5152,5237,5238,5269,5329,5350,5451,5484,5513,5530,5537,5600,5634,5691,5708,5819,5839,5849,5874,5891,5896,5933,5934,5953,5960,5985,5998,6004,6024,6028,6056,6068,6069,6095,6106,6119,6185,6340,6414,6581,6608,6767,6797,6817,6833,6925,6933,6982,7079,7088,7162,7163,7164,7246,7251,7264,7343,7353,7395,7397,7398,7436,7447,7457,7466,7484,7490,7544,7603,7610,7679,7700,7728,7737,7787,7840,7854,7930,7971,7980,8043,8045,8229,8247,8280,8308,8311,8330,8335,8346,8370,8375,8396,8397,8408,8429,8430,8441,8452,8492,8506,8546,8555,8559,8567,8568,8571,8632,8653,8656,8690,8740,8755,8761,8771,8785,8866,8903,8915,8923,8983,8987,9036,9039,9042,9127,9130,9157,9217,9297,9304,9326,9334,9347,9382,9407,9435,9450,9585,9604,9639,9693,9694,9836,9840,9883,9973,9990,10033,10087,10108,10124,10135,10160,10163,10169,10272,10278,10342,10359,10385,10419,10443,10452,10453,10484,10508,10512,10522,10554,10607,10636,10661,10771,10963,11023,11031,11076,11115,11193,11239,11253,11416,11417,11427,11450,11537,11553,11581,11673,11716,11762,11828,11875,12019,12027,12060,12101,12104,12155,12184,12186,12232,12289,12434,12507,12509,12637,12642,12692,12833,12931,12933,13019,13077,13089,13122,13143,13191,13311,13312,13323,13334,13352,13356,13434,13458,13485,13537,13551,13604,13769,13830,13913,13945,13996,14038,14141,14157,14180,14246,14266,14375,14376,14491,14569,14613,14624,14632,14684,14701,14751,14760,14767,14863,14899,15040,15048,15071,15094,15137,15152,15153,15160,15214,15253,15269,15273,15281,15323,15326,15351,15426,15464,15475,15582,15628,15677,15721,15726,15750,15771,15772,15777,15805,15837,15862,15938,15949,15953,16038,16236,16258,16305,16322,16366,16378,16430,16462,16486,16497,16564,16571,16623,16632,16673,16742,16747,16823,16873,16889,16903,16963,17024,17066,17088,17213,17266,17386,17401,17406,17411,17425,17431,17444,17541,17568,17578,17641,17662,17715,17793,17846,17877,17923,18008,18038,18099,18109,18128,18150,18155,18169,18183,18190,18228,18273,18328,18350,18453,18528,18543,18568,18584,18625,18666,18679,18687,18698,18699,18702,18718,18768,18801,18841,18864,18884,18891,18914,18978,18985,19000,19051,19090,19191,19225,19368,19478,19504,19571,19580,19613,19626,19653,19705,19807,19818,19903,19919,19934,19945,19946,19948,19951,19959,19978,19995,20018,20020,20073,20083,20089,20105,20140,20186,20226,20273,20294,20312,20349,20359,20371,20388,20399,20431,20441,20498,20513,20523,20596,20608,20611,20671,20672,20721,20725,20777,20784,20790,20852,20870,20874,20878,20880,20888,20906,21074,21110,21135,21160,21192,21231,21259,21339,21407,21455,21505,21510,21512,21536,21598,21610,21696,21707,21733,21739,21765,21816,21878,21947,21969,22009,22027,22073,22114,22117,22122,22144,22173,22183,22185,22193,22205,22216,22230,22233,22238,22254,22273,22274,22277,22286,22305,22312,22360,22383,22393,22430,22454,22566,22574,22605,22656,22684,22706,22712,22749,22775,22785,22805,22812,22871,22877,22892,23012,23076,23112,23139,23189,23209,23219,23256,23263,23306,23307,23312,23367,23381,23393,23444,23458,23606,23613,23689,23698,23709,23786,23883,23895,23899,23917,23919,23941,23957,23994,24020,24064,24086,24113,24114,24229,24297,24423,24471,24524,24528,24536,24538,24559,24571,24574,24635,24641,24683,24684,24756,24807,24812,24822,24932,25022,25111,25176,25215,25273,25274,25297,25332,25348,25361,25394,25397,25452,25477,25560,25580,25603,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25729,25755,25771,25799,25807,25820,25847,25884,25896,25907,25908,25933,25935,25947,25948,25958,25967,25971,26020,26030,26031,26062,26064,26099,26103,26133,26177,26193,26225,26230,26239,26250,26254,26292,26409,26431,26435,26456,26471,26507,26508,26529,26541,26543,26559,26563,26571,26575,26582,26590,26596,26605,26651,26664,26678,26685,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26859,26860,26896,26937,26976,26991,27022,27025,27028,27045,27056,27060,27082,27097,27155,27161,27174,27190,27248,27261,27272,27295,27304,27318,27417,27478,27497,27512,27544,27567,27577,27589,27591,27634,27737,27738,27745,27763,27789,27811,27822,27836,27930,27945,27948,27957,27998,28006,28036,28073,28104,28135,28140,28167,28184,28250,28309,28320,28342,28344,28360,28361,28398,28420,28431,28460,28472,28620,28673,28675,28690,28702,28755,28852,28916,29023,29123,29129,29224,29241,29249,29250,29413,29438,29505,29533,29608,29618,29620,29715,29790,29799,29890,29904,30093,30251,30689,32374,34007,34163,34432,34451,34653,34750,35196,35645,35871,36242,36831,37290,37426,37837,38023,38323,38624,38666,38920,38984,39008,39277,39286,39308,39761,39879,40007,40194,40211,40436,40531,40661,40727,40809,40860,40887,41120,41153,41158,41200,41217,41380,41381,41421,42486,42571,42758,43529,44618)
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 | 871 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.41 ms |
preparing | 0.69 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.05 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 |