Tiempo de la consulta: 4.31 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.374 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 06:34:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:34:17')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,81,87,88,89,110,111,119,125,185,188,189,190,200,205,234,246,248,249,255,263,271,272,283,308,323,325,353,362,400,403,412,415,416,420,421,422,423,424,426,427,429,431,477,484,495,496,500,501,503,531,574,575,593,604,657,686,689,722,734,785,808,815,832,845,853,862,863,868,898,937,940,986,1042,1101,1102,1207,1216,1223,1233,1250,1251,1255,1271,1294,1295,1353,1357,1434,1458,1459,1469,1479,1480,1514,1571,1623,1628,1638,1641,1670,1684,1718,1735,1745,1796,1806,1878,1887,1975,2016,2069,2072,2078,2101,2108,2134,2167,2208,2254,2272,2452,2517,2560,2605,2636,2674,2716,2777,2786,2804,2812,2825,2849,2929,2967,3001,3016,3020,3051,3065,3151,3154,3169,3183,3208,3212,3303,3312,3325,3343,3346,3493,3569,3597,3650,3682,3750,3754,3824,3983,4148,4227,4240,4310,4325,4492,4493,4558,4674,4772,4902,4905,5060,5079,5093,5095,5123,5189,5324,5381,5392,5437,5476,5513,5537,5538,5685,5798,5895,6102,6155,6208,6227,6300,6301,6307,6311,6315,6342,6354,6363,6372,6392,6400,6482,6515,6517,6542,6543,6546,6593,6602,6616,6666,6671,6776,6807,6808,6836,6840,6868,6964,6997,7017,7018,7026,7050,7056,7109,7124,7136,7138,7210,7245,7248,7252,7287,7414,7450,7485,7569,7583,7630,7692,7716,7730,7749,7782,7811,7872,7917,7933,7965,7970,7985,7993,8027,8030,8088,8100,8109,8206,8215,8444,8565,8567,8589,8602,8610,8625,8638,8740,8762,8777,8835,8856,8887,8897,8907,8937,8978,8983,9048,9056,9057,9082,9152,9200,9206,9262,9282,9286,9314,9340,9355,9411,9423,9428,9461,9472,9482,9489,9650,9658,9677,9678,9699,9764,9769,9817,9818,9825,9924,10035,10059,10132,10156,10190,10195,10273,10274,10364,10430,10462,10765,10973,11022,11195,11318,11345,11410,11418,11854,11948,11955,12020,12324,12336,12460,12566,12620,12650,12670,12685,12686,12708,12913,12973,12987,12996,13002,13014,13016,13029,13097,13129,13152,13166,13294,13348,13356,13474,13475,13524,13530,13548,13550,13573,13641,13712,13763,13821,13855,13900,13950,13971,13973,14062,14063,14081,14137,14148,14152,14159,14188,14197,14229,14293,14324,14362,14389,14428,14534,14536,14554,14675,14711,14753,14754,14769,14856,14860,14896,14897,14949,14996,15018,15038,15043,15049,15220,15221,15245,15248,15261,15293,15382,15414,15475,15476,15496,15520,15533,15574,15606,15719,15796,15818,15861,15897,15944,15945,15972,16055,16062,16071,16115,16157,16161,16176,16178,16218,16321,16325,16432,16497,16521,16526,16543,16566,16582,16603,16698,16706,16713,16733,16734,16751,16766,16788,16802,16808,16833,16848,16908,16950,16957,16976,17027,17084,17086,17100,17114,17134,17138,17155,17157,17197,17280,17334,17335,17419,17496,17528,17607,17629,17702,17721,17727,17775,17835,17857,17875,17883,17938,18043,18060,18071,18073,18112,18113,18129,18142,18220,18260,18295,18300,18309,18326,18358,18360,18409,18431,18454,18521,18544,18558,18566,18578,18717,18757,18763,18772,18819,18826,18859,18867,18937,19086,19126,19133,19158,19217,19223,19282,19381,19460,19462,19464,19551,19650,19653,19661,19668,19693,19695,19733,19772,19825,19828,19855,19871,19873,19886,19913,19923,19931,19937,19980,19983,20058,20060,20095,20163,20192,20193,20198,20213,20308,20347,20378,20439,20459,20471,20564,20567,20579,20595,20603,20616,20648,20698,20699,20700,20712,20727,20757,20802,20840,20847,20921,20993,21016,21038,21159,21165,21224,21229,21256,21257,21279,21283,21285,21288,21300,21338,21347,21368,21369,21397,21405,21464,21485,21486,21517,21518,21524,21526,21529,21606,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21732,21750,21765,21786,21800,21824,21843,21846,21850,21896,21910,21926,21954,21955,22015,22018,22026,22040,22043,22062,22077,22097,22117,22129,22163,22164,22180,22195,22204,22229,22234,22241,22252,22270,22276,22296,22302,22324,22385,22406,22414,22421,22446,22453,22489,22512,22529,22580,22603,22611,22620,22622,22626,22648,22649,22655,22658,22692,22710,22719,22720,22727,22765,22780,22784,22785,22787,22804,22829,22833,22848,22849,22851,22897,22923,22947,22960,22972,23007,23016,23024,23040,23043,23052,23062,23082,23089,23092,23124,23147,23156,23179,23198,23214,23245,23247,23307,23318,23325,23328,23388,23399,23457,23461,23468,23480,23485,23492,23521,23528,23547,23566,23647,23654,23665,23716,23718,23927,24016,24030,24119,24152,24192,24226,24242,24249,24277,24288,24293,24312,24342,24361,24366,24383,24392,24393,24398,24399,24408,24440,24450,24451,24475,24479,24497,24498,24522,24582,24601,24617,24623,24635,24643,24683,24705,24714,24717,24747,24803,24826,24891,24936,24937,24956,24993,25030,25035,25062,25069,25131,25133,25138,25171,25222,25318,25351,25406,25411,25413,25436,25448,25542,25584,25631,25646,25648,25660,25673,25709,25787,25816,25823,25898,25904,25940,25941,25968,26000,26017,26033,26034,26061,26147,26202,26221,26261,26317,26343,26360,26378,26410,26415,26424,26439,26454,26471,26474,26570,26630,26640,26651,26655,26677,26679,26686,26713,26742,26763,26766,26770,26801,26820,26845,26866,26881,26905,26907,26944,26973,26983,26992,26996,27000,27038,27071,27138,27167,27212,27220,27322,27366,27475,27513,27530,27688,27722,27846,27974,28072,28080,28339,28440,28442,28614,28615,28616,28712,28728,28779,28845,28944,29054,29093,29107,29187,29200,29460,29635,30609,30854,31773,32241,33417,33621,33725,33950,34365,34524,34584,34758,34927,35259,35305,35330,35351,35519,35676,35679,35713,35718,35744,35955,35959,36104,36153,36197,36266,36316,36360,36369,36423,36447,36610,36966,36998,37025,38001,38479,38554,38662,38784,38818,38825,38860,38865,38905,38962,38965,38986,39035,39078,39129,39192,39226,39287,39296,39398,39530,39673,39808,39823,39840,39853,40036,40202,40319,40492,40605,40812,40954,41041,41115,41254,41369,41514,41594,42074,42253,42258,42262,42544,43237,45008,45191)
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 | 1012 | 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.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.62 ms |
preparing | 0.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |