Tiempo de la consulta: 7.03 ms Después de la última consulta: 0.95 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.174 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:50:12')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 06:50:12')
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(23,29,39,70,71,72,73,75,263,275,355,466,535,546,583,607,740,816,868,895,917,918,959,977,991,1011,1123,1158,1207,1308,1363,1384,1477,1519,1720,1773,1823,1897,2109,2152,2223,2242,2282,2290,2293,2305,2456,2479,2525,2609,2647,2767,2799,2815,2843,2856,2886,2887,3152,3161,3208,3291,3393,3396,3452,3498,3570,3604,3617,3682,3700,3715,3780,3880,3974,3980,3986,4038,4114,4200,4209,4285,4306,4310,4333,4531,4580,4739,4872,5026,5187,5211,5351,5451,5479,5484,5530,5537,5616,5849,5874,5894,5934,5977,6050,6141,6351,6419,6542,6543,6545,6608,6616,6684,6833,6925,6933,7071,7162,7163,7164,7169,7181,7251,7264,7343,7417,7436,7443,7447,7489,7510,7516,7676,7679,7718,7741,7805,7825,7840,7854,7934,7949,7950,7954,7960,7965,8026,8027,8045,8074,8159,8289,8311,8381,8397,8430,8441,8555,8567,8660,8680,8860,8903,9303,9304,9326,9398,9704,9746,9853,9854,9861,10033,10120,10160,10163,10169,10268,10272,10384,10443,10453,10484,10512,10554,10607,10628,10661,10668,10696,10771,10971,10982,11032,11035,11108,11142,11150,11224,11328,11383,11417,11427,11429,11534,11553,11716,11828,11859,11944,12019,12115,12307,12554,12692,12834,12933,13019,13172,13312,13323,13334,13404,13425,13551,13604,13675,13741,13921,13972,14077,14105,14141,14180,14246,14266,14281,14375,14385,14454,14491,14572,14613,14624,14632,14701,14751,14760,14898,15015,15048,15068,15069,15074,15094,15111,15214,15273,15277,15281,15334,15351,15411,15425,15426,15475,15524,15574,15582,15643,15677,15680,15725,15726,15900,15949,15953,15973,16038,16116,16236,16270,16301,16305,16322,16324,16356,16366,16430,16486,16497,16498,16515,16564,16571,16623,16673,16742,16841,16903,16913,16963,16996,17062,17066,17088,17090,17115,17130,17132,17138,17205,17218,17222,17234,17266,17277,17406,17407,17411,17425,17427,17431,17486,17500,17605,17625,17706,17715,17732,17753,17754,17813,17822,17846,17852,17925,17935,17937,17956,17993,18008,18018,18032,18109,18128,18183,18200,18247,18260,18274,18282,18334,18453,18495,18554,18562,18593,18625,18666,18692,18698,18699,18718,18733,18773,18793,18864,18949,18961,18985,19000,19001,19018,19026,19073,19077,19117,19134,19191,19194,19323,19351,19355,19368,19381,19429,19486,19504,19508,19545,19571,19576,19580,19596,19604,19606,19626,19667,19690,19705,19713,19744,19764,19807,19809,19818,19825,19853,19882,19903,19918,19919,19934,19946,19948,19949,19951,19956,19978,20000,20018,20020,20029,20089,20105,20174,20186,20226,20291,20294,20304,20312,20327,20359,20371,20388,20398,20431,20455,20498,20513,20523,20524,20542,20596,20608,20635,20651,20662,20672,20707,20714,20718,20720,20721,20764,20777,20784,20820,20870,20906,20945,20977,21063,21074,21101,21110,21135,21160,21170,21231,21253,21274,21292,21322,21339,21372,21450,21468,21505,21510,21512,21529,21536,21584,21586,21637,21672,21733,21739,21765,21816,21851,21878,21890,21906,21921,21947,22010,22027,22114,22122,22127,22141,22144,22185,22205,22216,22254,22273,22277,22283,22305,22306,22307,22312,22318,22320,22328,22383,22430,22455,22468,22508,22563,22566,22605,22688,22706,22741,22803,22820,22831,22852,22877,22901,22935,23012,23041,23070,23076,23112,23130,23189,23209,23243,23263,23306,23307,23313,23367,23393,23433,23444,23449,23458,23484,23568,23575,23611,23617,23635,23689,23698,23709,23770,23778,23786,23837,23883,23895,23911,23917,23926,23941,23957,23992,23994,24020,24064,24086,24114,24116,24274,24282,24297,24328,24423,24433,24471,24475,24513,24536,24559,24571,24574,24623,24635,24641,24667,24684,24756,24807,24812,24822,24958,25022,25048,25069,25111,25135,25176,25215,25273,25274,25277,25285,25297,25332,25348,25361,25394,25443,25452,25477,25560,25580,25603,25621,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25717,25724,25755,25799,25807,25820,25847,25884,25907,25908,25935,25946,25947,25948,25958,25967,25971,26030,26031,26064,26133,26177,26193,26225,26228,26230,26239,26250,26292,26317,26319,26409,26431,26456,26471,26507,26508,26529,26535,26541,26543,26559,26571,26582,26596,26605,26651,26664,26678,26685,26687,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26826,26829,26840,26859,26860,26896,26937,26976,26986,26991,27025,27028,27045,27056,27060,27082,27097,27125,27155,27156,27248,27261,27318,27362,27417,27427,27478,27512,27544,27567,27589,27591,27613,27634,27678,27737,27738,27763,27789,27809,27811,27822,27930,27948,27957,27983,27998,28006,28018,28036,28135,28184,28309,28320,28327,28342,28360,28361,28460,28472,28534,28620,28630,28675,28690,28702,28755,28803,28852,28870,28916,29022,29023,29123,29129,29241,29249,29250,29345,29413,29438,29533,29560,29603,29608,29618,29623,29799,29818,29890,29904,29914,30285,31207,32374,33877,34089,34126,34163,34257,34321,34432,34451,34500,34559,34653,34750,34781,34782,34793,34804,34838,34895,35055,35103,35176,35184,35196,35359,35435,35452,35484,35492,35523,35545,35623,35645,35841,35869,35871,35872,35962,35967,35980,36033,36135,36232,36234,36281,36398,36461,36476,36583,36615,36680,36803,36815,36896,36945,37284,37353,37371,37397,37401,37426,37602,37618,37642,37717,37880,37906,37907,38079,38131,38393,38448,38451,38549,38574,38602,38666,38713,39088,39135,39183,39286,39370,39384,39411,39507,39511,39520,39542,39580,39598,39634,39646,39666,39677,39761,39816,39819,40251,40279,40311,40326,40365,40585,40594,40603,40640,40661,40720,40727,40761,40775,40778,40785,40803,40808,40829,40860,40887,40937,40941,40973,41007,41048,41140,41153,41158,41163,41200,41217,41299,41350,41421,41456,41522,41543,41566,41619,41622,41687,41695,41696,41747,41779,41816,41840,41853,41876,41911,41993,42021,42080,42159,42187,42259,42274,42331,42367,42368,42412,42486,42500,42531,42651,42676,42701,42730,42758,42789,42797,42852,42891,43068,43488,43554,43592,43609,43653,43678,43815,43816,43988,44142,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 | 989 | 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.75 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 2.65 ms |
preparing | 1.36 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.61 ms |
end | 0.01 ms |
query end | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.26 ms |
cleaning up | 0.06 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 |