Tiempo de la consulta: 3.78 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.041 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-06 11:08:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 11:08:21')
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(29,39,70,71,72,73,75,165,174,219,263,275,291,355,546,550,583,607,619,667,816,868,895,917,940,954,959,974,977,1011,1078,1123,1207,1231,1276,1308,1314,1316,1347,1363,1384,1409,1444,1477,1502,1503,1505,1512,1519,1520,1543,1629,1655,1724,1773,1809,1823,1897,1941,2029,2042,2152,2223,2242,2290,2293,2305,2371,2389,2456,2473,2482,2533,2609,2647,2732,2746,2796,2803,2856,2871,2886,2887,3152,3208,3291,3361,3393,3452,3498,3604,3700,3782,3794,3880,3931,3980,3986,4038,4114,4209,4233,4333,4358,4459,4531,4651,4739,4766,4866,4872,5025,5069,5152,5187,5210,5211,5257,5351,5444,5451,5769,5882,5894,5977,6045,6050,6066,6075,6141,6151,6193,6319,6351,6419,6542,6543,6545,6616,6719,6833,6978,7145,7343,7417,7436,7489,7510,7516,7554,7566,7676,7718,7738,7741,7805,7934,7949,7950,7954,7960,7965,7978,8006,8026,8027,8035,8074,8159,8225,8231,8254,8255,8381,8390,8420,8507,8522,8585,8623,8679,8688,8691,8771,8802,8851,8858,8860,8863,8894,8955,9029,9039,9183,9398,9470,9549,9585,9604,9704,9770,9773,9853,9854,9861,9901,9987,10060,10120,10211,10222,10268,10308,10342,10347,10384,10419,10453,10478,10519,10628,10650,10668,10696,10783,10827,10971,10982,11032,11035,11108,11124,11142,11150,11153,11224,11239,11289,11320,11328,11383,11417,11534,11564,11773,11788,11827,11853,11859,11883,11944,11951,12004,12115,12307,12409,12554,12692,12718,12760,12773,12834,12846,13172,13197,13313,13404,13425,13656,13663,13675,13741,13838,13887,13888,13921,13971,13972,14077,14099,14105,14141,14180,14200,14226,14266,14281,14284,14385,14452,14454,14527,14569,14572,14609,14624,14632,14701,14738,14740,14839,14903,14919,14956,15009,15069,15111,15115,15122,15214,15273,15277,15334,15351,15378,15411,15425,15426,15475,15499,15524,15574,15582,15643,15725,15726,15750,15777,15857,15864,15866,15871,15900,15907,15932,15949,16038,16106,16112,16270,16301,16305,16324,16335,16341,16356,16359,16374,16416,16475,16498,16515,16522,16659,16686,16754,16795,16805,16841,16963,16996,17004,17062,17090,17115,17130,17132,17138,17205,17218,17222,17234,17277,17319,17359,17407,17412,17421,17425,17429,17434,17457,17486,17500,17523,17552,17565,17625,17671,17706,17715,17732,17753,17813,17822,17846,17850,17852,17925,17935,17956,17993,18005,18008,18018,18032,18102,18109,18128,18144,18155,18156,18183,18197,18200,18230,18247,18260,18274,18282,18296,18299,18334,18352,18368,18379,18380,18436,18479,18492,18495,18521,18522,18554,18562,18593,18625,18665,18692,18699,18733,18737,18739,18773,18775,18793,18859,18874,18900,18902,18915,18941,18949,18961,18998,19000,19001,19018,19026,19073,19077,19117,19134,19194,19256,19304,19323,19351,19355,19368,19381,19401,19429,19486,19508,19545,19576,19590,19591,19594,19596,19604,19606,19667,19682,19683,19710,19713,19744,19764,19807,19809,19818,19825,19853,19882,19918,19937,19946,19949,19956,19996,20000,20029,20051,20102,20131,20164,20174,20241,20243,20280,20291,20304,20327,20398,20416,20446,20455,20498,20524,20542,20553,20635,20651,20662,20701,20707,20714,20718,20764,20777,20784,20820,20870,20914,20939,20945,20957,20977,21003,21020,21049,21063,21074,21101,21152,21160,21170,21202,21219,21229,21253,21274,21292,21322,21343,21372,21373,21419,21441,21450,21468,21505,21511,21536,21584,21586,21630,21672,21733,21739,21751,21777,21820,21851,21878,21890,21906,21921,21969,21979,22010,22050,22065,22077,22094,22101,22127,22141,22168,22177,22201,22211,22216,22273,22277,22283,22294,22306,22307,22318,22320,22328,22379,22405,22455,22468,22508,22515,22546,22563,22588,22699,22706,22714,22741,22749,22787,22803,22820,22831,22852,22854,22858,22876,22877,22880,22881,22901,22935,23012,23041,23067,23070,23072,23090,23100,23130,23152,23163,23189,23192,23209,23243,23307,23313,23348,23354,23366,23375,23403,23418,23420,23433,23449,23464,23484,23516,23534,23568,23573,23575,23576,23591,23596,23611,23617,23635,23684,23698,23735,23769,23778,23786,23825,23837,23883,23895,23922,23926,23951,23954,23957,23978,23992,23994,23996,24013,24035,24059,24063,24064,24116,24144,24200,24274,24276,24282,24313,24328,24353,24375,24433,24452,24475,24512,24513,24564,24574,24641,24654,24667,24681,24698,24706,24771,24805,24908,24958,25025,25048,25069,25112,25135,25243,25274,25277,25285,25301,25379,25443,25460,25491,25532,25628,25657,25671,25724,25732,25810,25847,25862,25932,25946,25963,26056,26064,26177,26228,26248,26274,26317,26507,26573,26582,26629,26687,26693,26741,26778,26826,26829,26860,26937,26975,27101,27125,27156,27214,27319,27362,27391,27418,27427,27438,27512,27525,27593,27678,27746,27759,27809,27867,27954,28128,28140,28161,28327,28420,28436,28534,28630,28692,28702,28803,28870,29022,29122,29173,29235,29475,29623,29715,29788,29848,30285,31172,32091,32374,33081,33877,34793,35595,35617,35954,35962,36033,36135,36398,36461,37907,37913,38082,38448,38451,38549,38574,38602,38666,38903,39033,39135,39384,39413,39446,39511,39542,39544,39598,39646,39666,39816,39819,39917,40251,40279,40326,40603,40778,40803,40808,40829,40941,41299,41350,41522,41566,41622,41747,41808,41816,41840,42021,42159,42259,42331,42500,42701,42852,43488,43592,43609,43653,43815,43816,44185,44224,44270,44722,44809,44868,44903,45276)
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 | 884 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.46 ms |
preparing | 0.71 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.02 ms |
freeing items | 0.05 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 |