Tiempo de la consulta: 3.45 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.298 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-06 06:39:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 06:39:33')
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(49,136,140,142,143,144,145,146,178,179,271,328,393,431,489,520,686,723,774,964,972,986,1044,1047,1054,1067,1080,1121,1130,1143,1158,1198,1207,1252,1253,1256,1302,1335,1339,1373,1664,3126,3223,3301,3669,3687,4378,4765,4952,5647,5659,5814,5847,6416,6470,6538,6573,6965,6966,6968,6989,7016,7043,7075,7161,7287,7291,7380,7387,7401,7403,7414,7427,7508,7546,7730,7745,7831,7867,7957,7983,7989,8108,8356,8502,8551,8950,9091,9203,9239,9429,9791,9823,10028,10078,10120,10415,10603,10708,10777,10803,10835,10916,11091,11113,11192,11249,11260,11310,11377,11430,11620,11808,11816,11863,12042,12112,12147,12174,12204,12401,12427,12492,12579,12609,12625,12681,12709,12806,12990,13004,13036,13216,13227,13325,13387,13445,13452,13461,13476,13492,13500,13666,13696,13782,13837,13880,13922,13924,13941,14021,14116,14138,14257,14258,14289,14426,14498,14514,14663,14676,14679,14682,14939,14986,14988,15020,15086,15173,15205,15286,15332,15408,15569,15594,15672,15732,15753,15898,16030,16122,16133,16157,16180,16278,16362,16381,16417,16523,16542,16622,16657,16675,16698,16737,16865,17091,17096,17117,17142,17168,17199,17331,17335,17336,17353,17409,17410,17412,17433,17449,17530,17531,17559,17584,17590,17599,17609,17632,17635,17688,17700,17710,17712,17734,17784,17814,17826,17834,17862,17933,17941,17976,17977,18006,18022,18074,18087,18227,18301,18317,18463,18465,18473,18524,18552,18573,18582,18658,18668,18693,18750,18810,18811,18830,18846,18849,18873,18892,18894,18929,18959,18984,19003,19129,19134,19145,19211,19230,19235,19236,19245,19296,19311,19344,19381,19387,19424,19435,19460,19472,19521,19536,19572,19622,19639,19706,19733,19740,19796,19848,19915,19916,19932,19982,19984,19993,20042,20066,20068,20100,20104,20148,20163,20189,20191,20276,20286,20296,20301,20345,20376,20382,20385,20396,20474,20515,20618,20708,20750,20752,20778,20869,20913,20940,20960,20981,21075,21198,21247,21321,21350,21392,21398,21521,21577,21611,21775,21813,21863,21895,21928,21932,21961,21992,22039,22079,22207,22271,22326,22330,22332,22340,22341,22349,22363,22382,22395,22419,22430,22436,22488,22494,22615,22659,22693,22694,22695,22698,22709,22754,22761,22804,22840,22850,22851,22964,22989,23077,23083,23087,23123,23213,23229,23236,23272,23273,23279,23287,23289,23309,23364,23367,23368,23371,23397,23413,23444,23527,23535,23555,23665,23693,23709,23716,23787,23869,23881,23920,23937,23965,23969,24003,24033,24066,24090,24115,24164,24170,24270,24284,24337,24441,24460,24461,24481,24520,24650,24720,24754,24755,24775,24795,24816,24865,24951,25002,25026,25032,25049,25090,25109,25164,25182,25192,25408,25477,25484,25517,25519,25535,25548,25601,25638,25664,25672,25734,25740,25771,25987,26028,26082,26234,26289,26296,26372,26386,26421,26521,26561,26596,26720,26744,26835,26842,26843,26845,26864,26916,26933,26944,26947,27039,27076,27100,27108,27192,27212,27233,27268,27269,27270,27327,27346,27384,27487,27499,27526,27552,27595,27634,27707,27717,27786,27834,27851,27856,27911,27918,27921,27923,27924,27926,27950,27969,28059,28066,28068,28075,28094,28095,28097,28114,28120,28192,28213,28230,28243,28264,28279,28295,28372,28447,28478,29214,29219,29269,29484,29495,29611,29653,29655,30111,32331,32565,33282,33871,33874,34784,34794,35375,35444,35554,35556,35637,35956,35957,36208,36441,36584,36797,37547,37627,37644,37992,38086,38723,38728,38884,38898,38914,39079,39184,39293,39345,39376,39448,39451,40369,40636,40673,40765,40821,40885,40888,41109,41121,41149,41172,41483,41577,41612,42042,42423,42479,42809,43276,43401,43654,44109,44122,44421,44735,44848,44871,44912,45046,45057,45068,45201)
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 | 610 | 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.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.03 ms |
preparing | 0.45 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |