Tiempo de la consulta: 5.70 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.166 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 07:01:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 07:01:28')
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,54,62,65,71,75,174,232,294,415,481,611,643,659,764,801,816,973,1078,1183,1207,1335,1563,1571,1697,2084,2150,2181,2195,2290,2371,2688,2797,2909,3196,3208,3266,3361,3491,3685,3760,3767,3776,3833,3913,3960,4034,4101,4110,4129,4148,4150,4204,4284,4323,4327,4361,4390,4423,4456,4527,4548,4575,4623,4859,4940,5087,5154,5259,5387,5422,5451,5647,5894,5909,6100,6128,6141,6278,6279,6339,6360,6362,6415,6440,6463,6475,6476,6477,6534,6548,6605,6616,6643,6649,6720,6865,6881,6888,6889,7077,7111,7185,7216,7250,7258,7331,7364,7444,7463,7492,7586,7605,7614,7618,7651,7667,7703,7718,7724,7741,7752,7771,7784,7787,7837,7886,7903,7925,7935,7942,7950,7955,7965,7987,8004,8027,8055,8152,8160,8203,8227,8234,8265,8370,8378,8421,8507,8523,8550,8565,8611,8644,8660,8688,8689,8700,8750,8753,8799,8813,8826,8864,8925,8954,9063,9073,9120,9328,9350,9351,9359,9390,9412,9457,9477,9578,9600,9610,9710,9738,9820,9829,9838,9878,9904,9908,9922,9956,10004,10096,10120,10180,10190,10218,10265,10269,10278,10313,10448,10513,10610,10617,10642,10754,10756,10971,10993,11023,11031,11041,11073,11080,11095,11121,11230,11250,11286,11328,11338,11387,11438,11488,11545,11687,11796,11848,11921,12076,12108,12148,12248,12249,12415,12553,12557,12632,12638,12672,12689,12690,12723,12808,12868,13146,13166,13209,13261,13376,13385,13543,13600,13646,13695,13702,13707,13713,13715,13731,13738,13760,13789,13838,13920,13933,13946,13961,13996,14141,14150,14282,14351,14396,14397,14471,14485,14486,14512,14513,14515,14532,14601,14616,14657,14662,14684,14694,14730,14739,14796,14820,14824,14825,14939,14980,14999,15006,15041,15069,15081,15148,15160,15178,15193,15215,15243,15245,15268,15312,15326,15347,15388,15411,15423,15457,15465,15475,15482,15487,15497,15551,15570,15588,15611,15617,15633,15636,15637,15640,15738,15767,15783,15789,15866,15893,15913,15964,16025,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16248,16256,16292,16314,16315,16320,16342,16403,16451,16507,16552,16577,16663,16759,16828,16829,16890,16991,16996,17005,17048,17053,17074,17102,17115,17132,17145,17160,17216,17233,17243,17277,17322,17392,17438,17464,17468,17476,17517,17557,17633,17650,17730,17753,17781,17844,17855,17859,17890,17893,17908,17912,17920,17926,17966,18007,18054,18062,18100,18108,18122,18134,18157,18180,18233,18239,18255,18274,18292,18311,18314,18316,18344,18355,18362,18368,18436,18446,18460,18492,18539,18544,18547,18562,18564,18569,18608,18709,18764,18765,18800,18846,18862,18878,18916,18922,18931,18951,18954,18955,18975,18980,19028,19034,19042,19055,19065,19073,19105,19124,19128,19135,19155,19208,19218,19240,19247,19261,19290,19292,19304,19313,19329,19366,19415,19429,19442,19493,19497,19530,19550,19561,19578,19596,19604,19623,19637,19652,19682,19700,19713,19720,19732,19741,19852,19872,19896,19945,19970,20018,20029,20030,20076,20127,20250,20260,20264,20327,20344,20348,20376,20393,20429,20444,20461,20543,20602,20620,20621,20633,20649,20678,20684,20741,20748,20779,20797,20809,20813,20828,20850,20906,20915,20959,21000,21057,21062,21064,21073,21107,21108,21143,21161,21171,21190,21248,21249,21310,21325,21369,21381,21388,21397,21434,21435,21458,21464,21489,21552,21554,21578,21590,21641,21645,21655,21669,21710,21740,21744,21763,21764,21776,21777,21851,21855,21858,21871,21883,21894,21922,21944,21976,21982,22010,22029,22040,22053,22060,22063,22065,22110,22160,22176,22177,22214,22223,22237,22298,22313,22336,22348,22389,22407,22422,22459,22461,22550,22617,22647,22702,22723,22733,22739,22741,22763,22819,22837,22889,22890,22904,22957,23063,23065,23067,23073,23077,23131,23150,23153,23185,23195,23201,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23382,23424,23441,23478,23518,23524,23575,23582,23672,23678,23679,23708,23749,23890,23987,24075,24102,24104,24152,24191,24273,24274,24289,24327,24332,24366,24371,24392,24475,24503,24592,24612,24636,24642,24644,24665,24727,24733,24816,24837,24844,24899,24943,24964,25039,25048,25072,25098,25107,25125,25133,25225,25253,25312,25377,25380,25394,25397,25528,25548,25644,25645,25714,25725,25730,25785,25789,25850,25901,25993,26048,26065,26178,26183,26222,26247,26255,26256,26273,26317,26456,26493,26501,26504,26521,26563,26574,26648,26824,26901,26926,26972,27002,27008,27011,27130,27150,27170,27246,27273,27321,27362,27418,27431,27482,27496,27521,27545,27593,27609,27644,27686,27704,27721,27833,27842,27917,27931,27936,27938,28005,28033,28045,28082,28225,28312,28318,28403,28411,28436,28559,28639,28653,28658,28763,28989,28992,29008,29009,29012,29152,29153,29174,29197,29244,29319,29356,29417,29443,29444,29473,29476,29486,29781,29832,29905,29922,29923,29935,32768,32842,33270,35617,35689,35883,35885,36454,36798,36821,38646,38807,38831,38854,38866,38937,38949,39283,39464,39481,39603,39681,39857,40025,40038,40083,40097,40110,40170,40200,40490,40515,40708,40759,40785,40809,40907,40937,40984,41058,41059,41069,41164,41255,41292,41301,41325,41375,42877,42878,43549)
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 | 854 | 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.56 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.35 ms |
System lock | 0.06 ms |
optimizing | 0.06 ms |
statistics | 2.01 ms |
preparing | 1.10 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.49 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 |