Tiempo de la consulta: 3.78 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.326 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 23:59:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:59:59')
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(9,45,46,49,54,62,65,71,81,91,95,100,103,112,234,353,415,523,605,607,619,643,659,723,725,764,868,940,965,974,977,1002,1045,1075,1147,1168,1223,1313,1326,1335,1367,1391,1409,1563,1571,1791,1809,1862,1904,2084,2442,2590,2729,2909,3020,3196,3266,3320,3346,3443,3637,3685,3760,3767,3776,3833,3913,3960,4002,4034,4101,4110,4111,4129,4148,4150,4204,4284,4323,4327,4390,4423,4456,4476,4548,4575,4673,4765,4859,4940,5060,5179,5259,5387,5422,5450,5479,5565,5647,5649,5676,5783,5894,5909,5962,6100,6128,6158,6257,6275,6318,6360,6362,6420,6440,6496,6572,6649,6690,6720,6865,6878,6881,7077,7111,7138,7216,7250,7258,7287,7331,7364,7444,7509,7586,7587,7605,7614,7618,7651,7724,7731,7752,7771,7784,7787,7903,7906,7925,7935,7942,8004,8055,8131,8139,8152,8160,8167,8214,8227,8234,8265,8370,8378,8391,8421,8507,8533,8550,8593,8611,8621,8644,8660,8688,8700,8732,8737,8750,8753,8799,8813,8823,8826,8864,8871,8925,8954,8970,9063,9120,9165,9328,9350,9390,9477,9568,9578,9600,9610,9738,9813,9829,9838,9878,9902,9904,9908,9922,9924,9956,10004,10124,10131,10166,10190,10265,10269,10313,10414,10448,10513,10610,10617,10642,10754,10756,10791,10993,11023,11031,11041,11073,11121,11162,11250,11286,11338,11387,11488,11545,11687,11796,11921,11934,11944,12115,12221,12249,12328,12385,12423,12459,12553,12632,12638,12689,12690,13067,13146,13166,13209,13376,13385,13566,13644,13702,13731,13738,13740,13747,13760,13789,13825,13866,13902,13917,13946,13961,13996,14141,14142,14293,14351,14386,14396,14504,14512,14513,14515,14527,14532,14537,14601,14607,14616,14645,14662,14691,14730,14739,14820,14824,14825,14844,14870,14935,14939,14950,14991,14999,15006,15039,15041,15069,15074,15079,15081,15148,15158,15160,15178,15193,15219,15224,15240,15245,15268,15325,15326,15344,15347,15388,15423,15457,15465,15482,15487,15490,15515,15541,15551,15570,15611,15617,15636,15637,15640,15738,15767,15783,15866,15913,16025,16036,16039,16040,16042,16048,16059,16082,16084,16097,16105,16127,16129,16156,16163,16181,16221,16230,16248,16256,16292,16314,16315,16339,16403,16552,16577,16651,16759,16828,16874,16890,16991,17053,17074,17102,17115,17145,17160,17216,17233,17234,17307,17334,17343,17407,17453,17468,17501,17510,17552,17633,17650,17668,17820,17844,17855,17859,17893,17926,17948,17966,18054,18062,18122,18157,18161,18179,18180,18233,18255,18274,18292,18297,18314,18344,18362,18399,18460,18468,18483,18539,18544,18564,18608,18643,18706,18709,18784,18789,18800,18826,18831,18846,18862,18864,18878,18904,18916,18922,18931,18954,18975,18980,19028,19034,19042,19104,19105,19124,19128,19135,19155,19174,19218,19240,19247,19288,19305,19313,19332,19333,19366,19530,19550,19551,19561,19604,19637,19652,19674,19702,19713,19715,19732,19736,19852,19872,19945,20003,20018,20026,20030,20127,20250,20260,20264,20287,20327,20348,20360,20376,20393,20429,20444,20461,20602,20620,20649,20661,20676,20678,20716,20741,20779,20797,20813,20828,20850,20906,20915,20944,20959,21000,21049,21057,21062,21107,21108,21143,21161,21190,21249,21309,21325,21369,21381,21397,21432,21434,21435,21436,21458,21464,21472,21489,21506,21530,21552,21554,21578,21590,21627,21641,21648,21710,21732,21740,21744,21753,21764,21776,21777,21855,21858,21883,21894,21944,21976,21982,22010,22040,22049,22063,22069,22097,22160,22171,22176,22208,22214,22234,22237,22266,22298,22313,22348,22407,22459,22461,22617,22647,22733,22735,22739,22743,22763,22819,22827,22837,22889,22890,22898,22904,22942,22957,23060,23063,23065,23067,23072,23131,23185,23195,23201,23237,23241,23260,23280,23300,23313,23320,23325,23326,23328,23339,23480,23582,23678,23679,23882,23890,24075,24102,24104,24150,24152,24191,24200,24273,24274,24327,24366,24371,24392,24433,24503,24505,24514,24592,24633,24644,24727,24733,24742,24816,24837,24842,24844,24874,24879,24899,24964,25072,25087,25098,25107,25125,25133,25142,25225,25253,25276,25377,25380,25487,25644,25645,25675,25714,25730,25738,25785,25809,25818,25850,25949,25993,26178,26183,26221,26256,26273,26288,26423,26456,26474,26493,26501,26504,26521,26533,26563,26648,26832,26840,26901,26926,26972,27002,27011,27055,27150,27170,27246,27273,27321,27418,27431,27496,27521,27545,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28411,28639,28653,28658,28912,28989,29008,29009,29152,29153,29174,29197,29319,29356,29406,29417,29443,29444,29476,29781,29905,29922,29923,29935,30282,32502,32768,32842,33349,34774,35246,35299,35617,35689,35744,35883,35885,36501,38807,38831,38854,38866,39088,39481,39603,39615,39627,39631,39667,39681,39742,39779,39857,40025,40038,40083,40097,40170,40200,40574,40708,40759,40785,40809,40907,40937,40984,41059,41093,41255,41301,41325,41350,41375,41831,41951,42094,44359)
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 | 818 | 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.39 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.28 ms |
preparing | 0.61 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.07 ms |
cleaning up | 0.02 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 |