Tiempo de la consulta: 19.39 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.239 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 09:19:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 09:19:05')
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(60,64,72,138,141,157,193,218,257,274,275,311,332,373,401,466,471,482,499,522,543,560,583,610,635,643,661,680,685,692,700,703,709,713,723,736,757,761,772,783,786,826,828,841,859,868,960,968,984,986,996,998,1024,1032,1034,1042,1048,1079,1098,1106,1127,1133,1138,1142,1150,1151,1172,1192,1194,1207,1226,1255,1269,1271,1279,1280,1295,1304,1305,1322,1323,1349,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1534,1553,1586,1587,1595,1624,1664,1666,1811,1812,1841,1852,1855,1870,1903,1906,1984,2001,2027,2077,2107,2148,2177,2193,2199,2272,2301,2359,2408,2432,2469,2480,2610,2629,2631,2691,2724,2773,2925,2971,2989,3056,3119,3161,3202,3278,3353,3354,3355,3364,3476,3513,3590,3594,3663,3795,3833,3836,3872,3938,3992,4075,4132,4168,4176,4197,4252,4271,4477,4523,4524,4525,4539,4558,4580,4585,4586,4587,4605,4665,4680,4698,4758,4795,4822,4874,4892,4919,4930,4960,5000,5014,5035,5076,5079,5143,5157,5160,5166,5192,5226,5250,5313,5435,5496,5507,5508,5525,5534,5586,5592,5625,5642,5659,5666,5700,5730,5746,5758,5809,5820,5846,5876,5894,5896,5908,5924,5936,5947,5950,5966,5968,5986,5987,5989,5990,5991,5995,6007,6012,6020,6022,6064,6068,6073,6079,6083,6097,6108,6110,6112,6132,6133,6138,6200,6202,6217,6222,6308,6319,6323,6328,6389,6396,6421,6426,6432,6439,6461,6464,6470,6498,6504,6512,6520,6531,6533,6539,6553,6575,6583,6596,6610,6611,6648,6659,6663,6667,6673,6688,6707,6730,6778,6799,6802,6842,6886,6887,6932,6942,6945,6965,7014,7052,7069,7124,7146,7156,7182,7237,7244,7277,7320,7336,7339,7340,7358,7411,7420,7421,7435,7450,7550,7556,7588,7611,7621,7624,7626,7688,7709,7719,7725,7748,7751,7765,7769,7776,7792,7795,7799,7802,7810,7824,7830,7831,7834,7837,7839,7845,7850,7860,7866,7868,7870,7878,7889,7931,7946,7951,8069,8083,8088,8089,8091,8099,8108,8206,8230,8258,8259,8261,8263,8283,8341,8354,8361,8377,8386,8400,8417,8518,8566,8580,8612,8617,8627,8647,8695,8696,8723,8756,8759,8778,8841,8860,8879,8907,8909,8938,8944,8962,9023,9040,9108,9122,9126,9132,9387,9449,9462,9515,9518,9523,9548,9552,9562,9665,9675,9690,9717,9738,9750,9801,9833,9879,9924,9956,10030,10114,10162,10228,10274,10316,10371,10373,10501,10556,10616,10725,10736,10775,10834,10851,10868,11006,11030,11057,11137,11194,11195,11223,11250,11253,11299,11314,11408,11428,11440,11441,11705,11714,11781,11795,11842,11857,11859,11868,11885,11925,12011,12077,12089,12170,12238,12265,12318,12334,12439,12440,12620,12624,12628,12670,12675,12685,12686,12708,12811,12816,12822,12922,12939,12946,12973,12994,13015,13026,13078,13091,13129,13145,13160,13224,13231,13239,13246,13248,13258,13266,13272,13297,13316,13344,13349,13428,13436,13437,13438,13452,13458,13467,13478,13479,13480,13481,13482,13502,13503,13525,13589,13597,13617,13660,13698,13701,13784,13794,13797,13824,13851,13855,13861,13900,13968,14125,14140,14153,14177,14192,14205,14224,14263,14267,14309,14385,14398,14424,14429,14432,14478,14493,14506,14516,14531,14546,14591,14601,14641,14646,14655,14708,14710,14754,14795,14864,14874,14958,14992,15002,15046,15055,15063,15080,15108,15138,15147,15216,15217,15229,15262,15287,15298,15314,15324,15347,15359,15378,15420,15440,15464,15486,15493,15543,15551,15577,15598,15606,15632,15639,15642,15644,15645,15681,15712,15714,15722,15749,15759,15876,15899,15904,15935,15952,15953,15982,16038,16052,16089,16156,16200,16216,16258,16267,16297,16303,16313,16348,16386,16390,16430,16464,16466,16497,16529,16569,16586,16607,16609,16629,16634,16648,16658,16714,16774,16780,16791,16793,16795,16813,16863,16866,16924,16928,16987,16995,17038,17039,17116,17121,17126,17131,17142,17148,17156,17177,17209,17224,17234,17270,17275,17282,17293,17344,17346,17355,17363,17381,17383,17384,17405,17420,17422,17478,17496,17555,17573,17618,17620,17627,17630,17645,17658,17660,17661,17667,17698,17699,17710,17734,17780,17799,17812,17842,17889,17892,17921,17927,18006,18013,18037,18038,18039,18055,18102,18160,18174,18181,18184,18187,18202,18229,18234,18249,18260,18284,18290,18316,18318,18347,18362,18382,18419,18421,18429,18452,18466,18494,18498,18509,18517,18540,18550,18552,18556,18588,18605,18652,18675,18678,18739,18750,18755,18778,18801,18807,18813,18816,18826,18845,18851,18856,18864,18876,18891,18892,18901,18904,18905,18906,18907,18916,18917,18929,18931,18934,18938,18940,18945,18953,18956,18988,18989,19007,19024,19027,19040,19043,19046,19056,19059,19135,19145,19163,19189,19196,19197,19217,19226,19260,19261,19282,19292,19303,19307,19335,19343,19364,19370,19383,19407,19412,19422,19427,19437,19505,19527,19548,19551,19553,19558,19589,19596,19612,19640,19655,19659,19693,19704,19773,19797,19808,19809,19816,19832,19845,19853,19857,19865,19873,19879,19883,19933,19940,19950,19972,19979,19980,20004,20006,20010,20020,20024,20033,20039,20043,20051,20056,20081,20115,20139,20142,20181,20202,20208,20215,20234,20237,20242,20254,20265,20353,20356,20394,20402,20404,20426,20436,20452,20535,20539,20559,20568,20569,20602,20677,20681,20739,20773,20803,20823,20837,20866,20871,20933,20946,20947,21007,21049,21087,21094,21095,21118,21135,21189,21194,21197,21205,21280,21284,21294,21368,21380,21384,21390,21408,21411,21422,21437,21438,21491,21520,21527,21583,21601,21611,21620,21664,21671,21691,21692,21701,21711,21727,21732,21779,21821,21833,21836,21907,21957,21998,22011,22015,22020,22030,22035,22062,22081,22117,22140,22149,22164,22173,22177,22209,22215,22222,22225,22228,22311,22324,22351,22359,22362,22365,22382,22400,22404,22415,22416,22464,22502,22543,22591,22600,22651,22653,22698,22710,22722,22756,22804,22841,22848,22850,22864,22872,22898,22919,22926,22985,22998,23014,23028,23031,23032,23039,23040,23053,23072,23089,23101,23112,23114,23139,23181,23221,23277,23284,23294,23296,23299,23304,23313,23328,23344,23369,23394,23401,23402,23406,23428,23453,23494,23511,23547,23584,23589,23592,23593,23611,23615,23633,23634,23638,23668,23691,23695,23701,23709,23715,23722,23732,23747,23769,23860,23868,23892,23912,23954,23965,24014,24017,24025,24052,24060,24127,24155,24164,24170,24190,24198,24248,24270,24280,24298,24317,24339,24356,24382,24387,24396,24415,24424,24431,24441,24447,24451,24455,24486,24523,24524,24553,24554,24573,24580,24599,24615,24650,24710,24726,24771,24774,24777,24783,24784,24785,24819,24831,24838,24856,24875,24884,24966,24977,25007,25010,25039,25049,25062,25079,25096,25099,25100,25141,25170,25172,25184,25197,25278,25281,25284,25292,25315,25317,25326,25406,25411,25420,25428,25463,25498,25526,25542,25584,25592,25609,25621,25640,25655,25693,25694,25705,25717,25752,25792,25881,25909,25943,25954,25964,26109,26154,26166,26167,26171,26190,26239,26348,26353,26360,26431,26468,26530,26531,26558,26651,26722,26753,26797,26807,26852,26875,26909,26944,26945,26947,26950,26951,27035,27046,27054,27096,27189,27208,27217,27223,27237,27249,27274,27280,27311,27364,27383,27414,27415,27422,27454,27491,27499,27518,27541,27610,27624,27628,27742,27743,27779,27846,27853,27859,28046,28189,28233,28240,28306,28328,28596,28598,28616,28628,28716,28746,28944,29231,29232,29373,29389,29548,29590,29864,30482,30562,30656,31060,31384,31623,31624,32530,32919,33303,33345,33476,34174,34676,35102,35226,35299,35337,35360,35379,35434,35574,35596,35637,35780,36027,36085,36200,36297,36751,36817,36904,36961,37034,37107,37116,37170,37219,37393,37397,37403,37439,37454,38006,38103,38114,38122,38128,38315,38343,38386,38398,38440,38446,38452,38530,38549,38674,39027,39052,39150,39163,39193,39245,39276,39315,39319,39347,39375,39389,39475,39492,39609,39625,39706,39722,39747,39768,39802,40018,40089,40231,40276,40328,40398,40404,40436,40438,40460,40465,40535,40554,40555,40562,40614,40667,40688,40774,40811,40817,40959,41040,41068,41150,41220,41246,41322,41363,41418,41436,41499,41570,41576,41649,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,41971,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44313,44318,44351,44400,44427,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45051,45136,45157,45302,45303)
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 | 1435 | 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.69 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.10 ms |
statistics | 2.09 ms |
preparing | 1.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 14.15 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.04 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 |