Tiempo de la consulta: 5.92 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.176 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 00:12:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 00:12:19')
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(70,71,72,73,75,165,219,263,275,281,453,476,544,550,570,583,607,664,816,868,895,917,954,1155,1188,1207,1314,1316,1347,1384,1409,1410,1428,1439,1477,1502,1503,1505,1512,1519,1520,1543,1606,1619,1629,1648,1655,1694,1724,1773,1794,1795,1796,1808,1810,1820,1823,1843,1897,1930,1975,2061,2152,2197,2290,2293,2305,2472,2473,2482,2609,2613,2700,2720,2732,2746,2796,2813,2834,2835,2843,2871,2886,2887,2908,2956,3032,3090,3208,3296,3330,3344,3362,3393,3452,3515,3604,3637,3700,3794,3815,3822,3823,3848,3858,3880,3986,4031,4034,4077,4107,4114,4175,4207,4209,4233,4414,4436,4437,4459,4550,4561,4569,4570,4623,4651,4739,4766,4872,4877,4881,5024,5025,5032,5069,5123,5137,5210,5213,5249,5267,5270,5289,5306,5329,5338,5351,5368,5387,5419,5421,5451,5454,5590,5704,5762,5769,5894,5909,5912,5927,6041,6050,6066,6075,6141,6151,6193,6194,6419,6542,6543,6545,6564,6616,6737,6759,7150,7185,7385,7386,7393,7394,7412,7417,7474,7489,7521,7529,7552,7617,7623,7636,7669,7718,7725,7732,7738,7741,7817,7878,7885,7887,7915,7934,7942,7949,7950,7965,8008,8026,8027,8061,8074,8117,8159,8163,8176,8231,8255,8330,8331,8358,8363,8364,8369,8381,8387,8409,8420,8421,8424,8455,8506,8522,8599,8623,8644,8667,8671,8691,8703,8758,8802,8803,8804,8860,8869,8873,8930,8955,8977,8980,8998,9019,9041,9167,9234,9302,9325,9327,9354,9398,9400,9420,9453,9549,9640,9697,9704,9732,9773,9793,9838,9853,9886,10042,10060,10082,10120,10124,10144,10148,10172,10268,10384,10393,10473,10478,10513,10614,10628,10696,10971,10982,10998,11032,11089,11108,11124,11150,11184,11224,11275,11320,11328,11383,11436,11526,11534,11564,11679,11728,11772,11853,11883,11944,12115,12190,12214,12268,12288,12298,12307,12409,12468,12554,12834,12846,12886,13024,13052,13094,13113,13135,13172,13205,13353,13425,13582,13636,13656,13675,13741,13794,13887,13888,13971,13972,14097,14141,14211,14226,14260,14281,14306,14355,14385,14452,14458,14460,14494,14532,14572,14576,14607,14645,14681,14693,14738,14740,14824,14848,14866,14919,14944,14950,15069,15098,15126,15137,15151,15260,15270,15277,15324,15328,15364,15386,15387,15406,15411,15428,15458,15475,15487,15513,15524,15554,15578,15618,15624,15643,15741,15743,15750,15776,15784,15800,15817,15822,15823,15836,15838,15866,15871,15909,15932,15964,16002,16007,16027,16036,16039,16056,16074,16114,16137,16164,16192,16223,16254,16275,16301,16335,16351,16356,16358,16372,16373,16374,16375,16393,16396,16403,16405,16414,16475,16498,16515,16522,16563,16566,16656,16664,16683,16845,16886,16924,16962,16996,17008,17056,17085,17090,17115,17132,17152,17205,17214,17220,17234,17298,17344,17407,17412,17421,17499,17500,17523,17549,17565,17597,17618,17628,17671,17753,17813,17815,17822,17850,17852,17880,17922,17923,17925,17935,17946,17956,17984,17993,18003,18005,18018,18032,18063,18157,18161,18172,18200,18235,18246,18254,18258,18260,18281,18282,18299,18329,18334,18361,18368,18404,18436,18460,18521,18522,18562,18593,18632,18646,18655,18665,18727,18733,18742,18757,18773,18775,18793,18859,18874,18894,18902,18904,18949,18976,19018,19026,19048,19049,19051,19073,19117,19134,19177,19381,19429,19490,19508,19545,19569,19576,19584,19596,19604,19606,19641,19667,19674,19709,19713,19744,19764,19809,19825,19853,19867,19882,19937,19955,19996,20029,20051,20072,20243,20286,20291,20293,20350,20397,20398,20400,20445,20455,20464,20473,20509,20529,20534,20542,20553,20579,20606,20651,20662,20699,20707,20714,20764,20775,20819,20820,20928,20945,20957,20974,20977,21000,21008,21049,21063,21101,21138,21149,21225,21264,21274,21292,21343,21372,21419,21429,21450,21548,21584,21586,21732,21738,21739,21750,21751,21777,21814,21851,21861,21890,21898,21901,21921,21948,21972,21973,21999,22010,22026,22050,22077,22209,22279,22306,22307,22318,22333,22405,22455,22477,22530,22563,22576,22588,22640,22649,22663,22684,22688,22699,22714,22741,22803,22820,22831,22852,22854,22858,22901,22935,23041,23049,23070,23072,23100,23192,23225,23234,23243,23313,23348,23354,23366,23399,23418,23420,23433,23449,23464,23484,23492,23516,23534,23559,23573,23591,23596,23617,23635,23769,23785,23825,23926,23951,23957,23986,23992,23996,24063,24101,24144,24205,24220,24276,24313,24375,24433,24449,24475,24512,24513,24564,24639,24642,24654,24668,24681,24706,24745,24805,24806,24820,24872,24908,25020,25025,25048,25112,25134,25135,25178,25204,25243,25253,25270,25277,25293,25444,25460,25491,25561,25628,25657,25760,25787,25921,25946,25963,26056,26228,26248,26284,26301,26317,26347,26349,26352,26356,26444,26513,26542,26687,26693,26808,26826,26975,27125,27214,27218,27362,27391,27406,27410,27427,27438,27525,27593,27678,27737,27746,27809,27867,28128,28140,28185,28327,28436,28534,28630,28803,28870,28952,29014,29022,29122,29173,29235,29501,29535,29623,29715,29788,29906,29938,30284,30285,33877,34158,34335,37109,37131,37597,38458,38474,38886,39384,39542,39646,39666,39819,40484,40852,41270,41350,42316,42481)
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 | 853 | 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.66 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.06 ms |
optimizing | 0.18 ms |
statistics | 1.96 ms |
preparing | 1.00 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.51 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 |