Tiempo de la consulta: 5.54 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.183 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-07 16:03:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:03:24')
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,23,29,39,49,58,170,172,173,287,290,291,292,293,344,353,355,437,466,495,527,528,546,593,607,693,704,790,797,843,959,977,997,1011,1123,1207,1232,1247,1308,1339,1363,1486,1720,1931,2109,2131,2223,2242,2456,2622,2647,2757,2767,2799,2856,2964,2997,3020,3028,3030,3045,3124,3152,3209,3212,3291,3353,3373,3435,3498,3570,3617,3671,3682,3700,3715,3738,3842,3974,3980,4038,4106,4114,4120,4128,4285,4306,4310,4333,4399,4531,4894,4984,5026,5187,5211,5471,5484,5530,5537,5559,5647,5849,5874,5934,5977,6039,6089,6131,6234,6338,6351,6484,6549,6588,6608,6616,6688,6782,6833,6836,6925,6933,6998,7137,7162,7163,7164,7251,7264,7302,7331,7343,7361,7436,7447,7483,7495,7510,7516,7592,7676,7677,7679,7805,7840,7847,7854,7884,7894,7954,7960,7965,8027,8045,8159,8397,8430,8441,8555,8567,8661,8719,8860,8903,8970,9198,9304,9318,9326,9440,9854,9861,9880,10033,10100,10149,10160,10163,10169,10272,10283,10382,10420,10443,10453,10484,10512,10554,10607,10623,10661,10668,10721,10771,10782,10838,10861,10957,11035,11117,11142,11417,11427,11553,11716,11792,11828,11854,12019,12270,12311,12334,12440,12581,12582,12611,12692,12851,12933,12978,13019,13307,13312,13323,13332,13334,13404,13420,13515,13551,13604,13921,13972,14077,14105,14141,14180,14182,14246,14266,14372,14375,14453,14454,14491,14511,14613,14624,14630,14632,14640,14701,14751,14760,14801,14816,14845,14852,14856,14983,15007,15048,15094,15111,15129,15156,15214,15273,15281,15334,15335,15351,15376,15406,15424,15425,15426,15475,15520,15522,15574,15581,15582,15600,15677,15689,15700,15725,15726,15742,15750,15785,15790,15812,15880,15900,15949,15953,16038,16095,16127,16214,16236,16249,16270,16301,16305,16322,16324,16357,16366,16384,16427,16430,16486,16497,16498,16521,16551,16564,16571,16623,16673,16675,16742,16781,16812,16816,16841,16903,16963,17049,17062,17066,17088,17116,17130,17138,17188,17218,17222,17240,17246,17266,17277,17288,17331,17347,17387,17406,17411,17425,17431,17444,17476,17486,17497,17561,17573,17625,17630,17706,17711,17715,17732,17736,17779,17813,17834,17846,17862,17888,17919,17930,17936,17950,17967,17983,18008,18044,18061,18075,18109,18128,18183,18222,18247,18260,18274,18295,18382,18453,18495,18516,18552,18554,18625,18656,18664,18666,18692,18693,18698,18699,18718,18728,18825,18830,18864,18877,18888,18905,18961,18985,18989,18994,19000,19001,19015,19077,19105,19124,19128,19140,19169,19173,19191,19194,19287,19315,19323,19351,19355,19363,19368,19381,19486,19504,19571,19578,19580,19607,19626,19639,19684,19705,19710,19725,19733,19794,19807,19818,19903,19918,19919,19923,19937,19945,19946,19948,19949,19951,19956,19978,20000,20018,20020,20053,20063,20089,20096,20105,20119,20174,20175,20186,20226,20234,20275,20294,20304,20312,20327,20359,20371,20388,20431,20445,20498,20513,20523,20524,20542,20596,20608,20635,20638,20659,20672,20718,20721,20768,20772,20784,20870,20906,20940,20959,21027,21074,21110,21117,21118,21135,21143,21160,21170,21231,21253,21339,21344,21367,21398,21421,21457,21468,21470,21505,21510,21512,21520,21522,21536,21663,21672,21684,21702,21733,21741,21764,21765,21776,21778,21816,21878,21883,21906,21917,21947,21968,21997,22027,22038,22067,22106,22114,22119,22122,22127,22141,22144,22178,22185,22205,22216,22227,22254,22273,22277,22278,22283,22298,22305,22312,22320,22328,22383,22430,22450,22460,22468,22476,22483,22508,22555,22562,22563,22570,22573,22605,22688,22706,22717,22759,22820,22840,22877,22902,22944,22960,23012,23034,23056,23076,23093,23112,23130,23189,23209,23242,23259,23263,23279,23304,23306,23307,23367,23368,23393,23405,23429,23430,23438,23439,23444,23456,23458,23553,23555,23568,23571,23575,23611,23689,23698,23709,23770,23778,23786,23837,23849,23883,23895,23917,23941,23955,23957,23968,23994,24020,24064,24076,24086,24114,24116,24125,24127,24164,24237,24248,24274,24282,24297,24328,24406,24423,24471,24530,24536,24559,24571,24574,24580,24584,24635,24641,24667,24684,24690,24714,24756,24779,24805,24807,24812,24822,24841,24870,24946,24958,24963,25022,25037,25069,25081,25111,25117,25176,25215,25269,25273,25274,25276,25285,25297,25329,25332,25348,25361,25376,25394,25443,25452,25477,25523,25548,25560,25580,25603,25649,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25751,25755,25799,25807,25820,25847,25884,25907,25908,25919,25935,25947,25948,25958,25967,25971,26030,26064,26133,26177,26193,26225,26229,26230,26239,26250,26259,26261,26292,26331,26409,26431,26456,26507,26508,26523,26529,26541,26543,26559,26571,26582,26596,26605,26651,26664,26678,26685,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26829,26854,26859,26860,26873,26896,26937,26959,26976,26991,27001,27025,27028,27045,27056,27060,27061,27062,27082,27097,27155,27156,27158,27248,27261,27290,27318,27348,27417,27478,27512,27544,27552,27567,27578,27589,27591,27634,27646,27707,27737,27738,27745,27763,27789,27811,27822,27851,27927,27930,27948,27950,27955,27957,27998,28006,28036,28066,28094,28135,28184,28213,28264,28283,28309,28320,28342,28360,28361,28460,28472,28620,28627,28675,28690,28702,28749,28755,28826,28852,28916,29023,29061,29073,29123,29129,29241,29249,29250,29345,29413,29438,29533,29539,29608,29618,29719,29799,29890,29904,30470,30768,32374,32718,32840,33380,34432,34451,34653,34750,34781,34782,34793,35196,35645,35871,35882,35917,35962,36033,36135,36398,36461,37426,37605,37907,38448,38451,38549,38574,38602,38666,38710,39135,39210,39286,39511,39598,39761,39816,39981,39998,40081,40168,40251,40279,40326,40518,40603,40611,40661,40727,40778,40803,40808,40829,40860,40887,40941,41106,41158,41200,41217,41299,41421,41522,41566,41622,41747,41816,41840,42021,42157,42159,42259,42331,42332,42486,42500,42652,42675,42701,42758,42852,43488,43592,43609,43653,43815,43816,44185,44224,44270,44809,44868,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 | 990 | 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.57 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 2.12 ms |
preparing | 1.30 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.48 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.11 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 |