Tiempo de la consulta: 5.71 ms Después de la última consulta: 1.31 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.540 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 12:26:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 12:26:48')
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(4,5,7,9,11,14,25,28,29,39,44,45,46,47,48,49,50,51,52,53,54,55,57,58,59,60,62,63,65,71,73,81,86,87,88,89,110,111,125,149,155,164,165,174,177,188,189,190,196,200,205,221,226,234,240,244,246,248,249,255,259,262,263,271,275,276,291,299,325,331,349,353,362,366,368,391,412,415,416,420,421,422,423,424,426,427,428,429,431,445,463,472,477,481,484,496,501,503,510,520,525,530,531,546,563,574,575,583,593,607,611,613,619,659,662,663,667,674,686,697,705,723,746,758,769,785,800,802,805,808,823,832,835,853,862,868,869,873,883,895,900,910,917,923,939,940,954,958,963,969,974,977,982,983,986,999,1004,1005,1011,1021,1031,1055,1091,1095,1114,1119,1158,1182,1205,1207,1223,1231,1247,1252,1253,1255,1268,1271,1276,1285,1289,1308,1309,1319,1329,1347,1353,1357,1363,1409,1410,1428,1432,1434,1441,1444,1485,1509,1557,1566,1606,1619,1629,1648,1675,1693,1694,1718,1724,1765,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1878,1899,1918,1920,1930,1945,1960,1961,1975,1984,1994,1995,2001,2007,2008,2013,2015,2034,2035,2075,2088,2108,2133,2137,2155,2157,2161,2208,2272,2290,2293,2305,2365,2455,2527,2532,2551,2569,2586,2597,2638,2639,2643,2764,2796,2814,2824,2825,2851,2863,2883,2888,2960,3020,3027,3051,3055,3100,3107,3147,3169,3207,3212,3325,3364,3368,3369,3377,3387,3409,3412,3473,3512,3520,3523,3548,3552,3554,3564,3590,3604,3613,3648,3650,3682,3683,3689,3748,3853,3858,3872,3913,3919,3922,3962,3986,3991,4034,4050,4068,4110,4129,4310,4327,4468,4529,4532,4549,4558,4580,4616,4620,4622,4626,4666,4674,4741,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4878,4902,4905,4933,4973,4988,5055,5060,5134,5153,5160,5176,5189,5220,5324,5350,5365,5370,5392,5415,5420,5451,5469,5472,5476,5538,5559,5647,5675,5685,5730,5780,5795,5798,5865,5894,5895,5999,6127,6148,6198,6254,6270,6311,6391,6392,6393,6405,6420,6435,6442,6470,6473,6475,6476,6477,6482,6520,6542,6543,6548,6554,6573,6616,6630,6656,6666,6671,6678,6688,6723,6742,6744,6762,6776,6835,6836,6845,6855,6860,6868,6889,6895,6906,6936,6944,6958,6985,7015,7017,7022,7030,7048,7050,7056,7109,7124,7137,7138,7195,7210,7232,7242,7258,7287,7324,7343,7418,7450,7483,7491,7535,7545,7586,7588,7591,7592,7595,7621,7648,7692,7716,7730,7751,7782,7811,7819,7832,7933,7934,7950,7959,7970,7993,7997,8027,8070,8086,8109,8143,8192,8215,8291,8295,8314,8444,8508,8522,8538,8565,8589,8592,8602,8610,8634,8638,8707,8779,8801,8835,8856,8887,8895,8939,9205,9206,9237,9262,9277,9279,9282,9369,9401,9411,9428,9472,9488,9572,9618,9650,9677,9678,9924,9930,10035,10110,10176,10203,10204,10250,10273,10274,10306,10311,10572,10697,10840,10872,10951,10954,10974,11001,11015,11063,11083,11124,11173,11184,11226,11345,11374,11394,11479,11534,11555,11644,11712,11766,11857,11883,11987,12020,12141,12242,12306,12324,12398,12408,12449,12460,12545,12550,12620,12624,12625,12628,12639,12650,12667,12668,12670,12685,12686,12708,12789,12887,12894,12913,12945,12973,12974,12996,13004,13014,13016,13034,13126,13152,13225,13241,13246,13277,13294,13348,13474,13475,13508,13578,13611,13646,13718,13725,13775,13851,13855,13896,13900,13968,13971,13972,13973,13998,14048,14097,14114,14183,14205,14225,14229,14236,14293,14361,14362,14507,14534,14536,14554,14602,14666,14675,14684,14703,14714,14752,14811,14856,14860,14865,14969,14976,15038,15043,15052,15063,15087,15199,15203,15217,15235,15245,15261,15293,15304,15310,15382,15414,15427,15460,15475,15476,15520,15533,15544,15551,15574,15604,15757,15781,15796,15804,15807,15861,15866,15875,15890,15903,15913,15915,15945,15972,15973,16014,16022,16029,16055,16062,16071,16115,16122,16161,16176,16202,16224,16320,16366,16415,16431,16432,16454,16481,16497,16526,16538,16543,16566,16587,16588,16612,16645,16737,16751,16775,16791,16830,16833,16897,16908,16913,16950,16968,16976,16995,16996,17054,17055,17104,17114,17139,17140,17150,17166,17170,17177,17195,17227,17228,17242,17285,17307,17309,17326,17333,17334,17335,17372,17388,17407,17419,17421,17442,17446,17470,17488,17496,17510,17528,17592,17607,17611,17629,17634,17644,17646,17683,17695,17697,17699,17702,17721,17724,17737,17766,17785,17791,17798,17799,17806,17807,17852,17857,17862,17925,17936,17950,18026,18036,18071,18073,18074,18082,18121,18149,18191,18220,18260,18276,18286,18294,18300,18309,18311,18322,18357,18360,18383,18444,18480,18505,18532,18542,18558,18578,18657,18668,18670,18682,18695,18698,18710,18730,18733,18754,18757,18779,18791,18802,18819,18832,18846,18874,18948,19014,19015,19026,19038,19051,19064,19114,19131,19133,19168,19169,19175,19183,19187,19207,19228,19258,19269,19280,19282,19283,19288,19289,19299,19302,19303,19307,19322,19339,19349,19381,19389,19400,19402,19421,19423,19427,19444,19458,19460,19470,19477,19484,19503,19516,19532,19533,19551,19573,19650,19661,19668,19695,19720,19721,19727,19733,19772,19800,19825,19830,19886,19895,19923,19931,19937,19962,19976,19980,20028,20029,20033,20041,20044,20051,20056,20057,20060,20062,20076,20086,20089,20095,20099,20127,20142,20149,20152,20153,20158,20174,20177,20187,20188,20192,20193,20208,20213,20215,20220,20236,20256,20271,20278,20293,20305,20306,20308,20317,20372,20373,20391,20397,20437,20439,20459,20508,20530,20549,20567,20569,20587,20595,20600,20616,20629,20643,20648,20654,20662,20668,20677,20686,20699,20700,20713,20714,20727,20733,20739,20743,20760,20764,20785,20797,20804,20813,20843,20847,20851,20853,20858,20860,20871,20879,20883,20897,20920,20921,20944,20949,20954,20973,20993,20999,21016,21038,21061,21113,21159,21168,21198,21216,21217,21236,21256,21279,21280,21282,21283,21285,21287,21288,21300,21313,21338,21346,21347,21368,21402,21420,21431,21445,21464,21483,21485,21486,21524,21526,21528,21529,21538,21569,21579,21593,21618,21622,21623,21650,21661,21664,21667,21690,21695,21704,21719,21727,21760,21787,21798,21800,21820,21824,21826,21843,21846,21850,21852,21910,21950,21954,21955,21969,22003,22015,22018,22038,22049,22062,22077,22088,22098,22105,22117,22124,22150,22163,22164,22171,22195,22212,22215,22241,22266,22290,22302,22309,22324,22363,22389,22406,22421,22446,22453,22485,22512,22567,22580,22603,22620,22622,22626,22655,22658,22670,22672,22706,22710,22727,22743,22753,22765,22780,22787,22804,22827,22829,22833,22840,22847,22854,22874,22881,22897,22901,22917,22922,22923,22947,22972,22991,23007,23024,23041,23043,23046,23062,23070,23082,23089,23114,23124,23132,23138,23148,23170,23179,23202,23214,23224,23246,23253,23267,23275,23305,23325,23363,23364,23368,23383,23405,23408,23423,23480,23488,23501,23526,23528,23536,23563,23566,23569,23574,23599,23615,23617,23665,23682,23716,23730,23746,23790,23797,23816,23838,23875,23906,23926,23927,23932,23940,23978,23990,24016,24024,24025,24048,24067,24083,24104,24118,24139,24147,24153,24189,24193,24208,24219,24226,24249,24298,24356,24393,24403,24408,24411,24412,24415,24433,24440,24456,24466,24475,24484,24522,24526,24557,24582,24585,24597,24598,24609,24614,24616,24617,24682,24697,24701,24729,24732,24748,24797,24803,24830,24841,24853,24922,24937,24941,24954,24956,24960,24973,24993,25030,25035,25048,25062,25075,25080,25131,25138,25171,25287,25318,25323,25351,25386,25406,25436,25448,25452,25456,25491,25506,25534,25535,25542,25560,25561,25569,25584,25591,25598,25610,25632,25646,25657,25660,25707,25721,25888,25901,25904,25934,25990,26000,26014,26028,26033,26043,26102,26105,26136,26147,26161,26215,26221,26245,26293,26317,26343,26360,26386,26415,26424,26454,26474,26483,26488,26492,26519,26525,26554,26651,26677,26713,26742,26801,26820,26829,26845,26874,26881,26901,26905,26907,26916,26920,26944,26947,26954,26959,26973,27000,27038,27041,27074,27091,27103,27133,27135,27157,27196,27366,27397,27407,27471,27490,27518,27526,27530,27573,27688,27707,27717,27722,27726,27786,27805,27809,27846,27863,27878,27904,27949,27978,27997,28072,28078,28080,28248,28339,28402,28416,28440,28442,28614,28615,28616,28643,28712,28728,28799,28845,28910,28918,28928,28944,28960,29033,29054,29136,29281,29441,29459,29460,29473,29500,29540,29635,30284,30307,30484,30940,31010,31114,31356,31671,32097,32841,33259,33417,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34783,35330,35464,35568,35713,35744,35755,35861,35909,35955,36219,36479,36523,37408,38631,38961,39063,39216,39323,39398,39530,40036,40347,40402,40492,40605,40823,41256,41311,41430,41437,41629,41984,41985,42530,42752,42799,44396,44402,44602,44743,45008,45076)
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 | 1494 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.26 ms |
preparing | 1.25 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |