Tiempo de la consulta: 25.79 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.469 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-04 22:43:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 22:43:52')
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(14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,64,70,71,72,73,75,127,157,174,193,204,218,253,257,263,272,275,287,294,311,353,401,466,471,481,482,484,499,504,505,507,543,550,551,560,583,607,608,610,611,626,635,643,661,667,680,685,686,692,700,703,705,709,713,736,761,772,777,783,786,801,816,852,859,868,882,895,917,926,960,961,968,973,984,998,1024,1032,1034,1042,1048,1059,1078,1079,1098,1106,1124,1127,1134,1138,1142,1150,1151,1172,1183,1192,1194,1198,1204,1207,1226,1238,1255,1269,1271,1279,1280,1295,1305,1322,1347,1349,1375,1420,1421,1433,1435,1441,1444,1445,1447,1454,1455,1459,1460,1466,1476,1481,1484,1519,1527,1553,1586,1587,1594,1595,1624,1664,1670,1697,1760,1787,1795,1811,1812,1823,1824,1841,1852,1855,1870,1903,1906,1951,1967,1984,2001,2017,2018,2024,2061,2077,2125,2148,2150,2177,2181,2193,2195,2199,2290,2293,2301,2305,2317,2359,2371,2395,2408,2432,2469,2480,2482,2629,2631,2671,2691,2726,2758,2773,2797,2881,2886,2887,2888,2989,3056,3119,3144,3193,3202,3208,3267,3278,3306,3353,3355,3364,3385,3393,3442,3452,3491,3495,3513,3563,3590,3594,3604,3626,3663,3680,3696,3700,3769,3836,3837,3872,3880,3919,3960,3986,3992,4004,4075,4092,4114,4122,4132,4168,4176,4197,4209,4236,4252,4255,4271,4410,4477,4494,4506,4523,4558,4580,4585,4586,4587,4605,4631,4640,4739,4771,4794,4874,5014,5051,5079,5154,5226,5334,5351,5365,5451,5496,5507,5508,5534,5578,5634,5647,5660,5708,5726,5727,5730,5798,5821,5876,5894,5990,5991,6015,6041,6068,6133,6141,6186,6245,6270,6278,6279,6308,6323,6339,6367,6396,6397,6415,6461,6463,6468,6475,6476,6477,6497,6503,6526,6533,6534,6542,6543,6545,6548,6596,6604,6605,6606,6609,6610,6616,6643,6663,6667,6689,6707,6708,6736,6764,6783,6793,6820,6837,6842,6860,6873,6888,6889,6939,6960,6986,7018,7182,7185,7200,7237,7245,7266,7277,7368,7413,7417,7421,7435,7463,7484,7489,7492,7618,7626,7645,7672,7688,7709,7711,7718,7720,7741,7748,7756,7762,7802,7830,7837,7839,7860,7868,7870,7934,7946,7948,7950,7951,7955,7965,7980,7982,7987,7994,8026,8027,8069,8073,8074,8091,8108,8187,8206,8291,8351,8381,8400,8476,8518,8565,8566,8568,8587,8610,8689,8698,8860,8907,8925,8938,8944,9073,9108,9257,9296,9351,9359,9398,9405,9412,9417,9462,9691,9704,9734,9745,9776,9792,9819,9820,9853,9879,9945,10011,10051,10068,10120,10156,10176,10180,10216,10237,10248,10260,10268,10278,10282,10316,10369,10373,10384,10385,10414,10470,10478,10501,10541,10554,10567,10628,10636,10666,10686,10696,10709,10715,10725,10736,10775,10834,10851,10857,10888,10912,10971,10982,11006,11032,11080,11091,11108,11118,11123,11147,11150,11195,11207,11223,11224,11290,11314,11320,11328,11383,11388,11438,11462,11487,11534,11693,11694,11705,11762,11788,11796,11815,11828,11848,11854,11859,11900,11925,11944,12032,12089,12108,12115,12126,12135,12170,12186,12237,12238,12242,12248,12251,12307,12369,12415,12440,12463,12474,12493,12500,12505,12550,12553,12554,12557,12608,12672,12723,12752,12778,12808,12816,12834,12839,12868,12946,12994,13020,13078,13143,13159,13160,13172,13176,13190,13191,13202,13220,13231,13246,13258,13259,13264,13269,13272,13297,13309,13316,13344,13358,13425,13434,13437,13438,13456,13467,13480,13481,13482,13503,13525,13543,13573,13600,13609,13616,13621,13631,13646,13660,13662,13673,13674,13675,13695,13702,13707,13713,13715,13741,13797,13824,13838,13855,13860,13861,13867,13881,13896,13920,13933,13968,13972,13986,13994,14005,14062,14127,14141,14153,14177,14184,14205,14227,14273,14281,14282,14305,14309,14320,14339,14348,14364,14368,14385,14398,14408,14425,14432,14456,14471,14486,14493,14506,14546,14558,14572,14600,14624,14641,14652,14657,14684,14692,14694,14710,14733,14759,14794,14796,14815,14873,14874,14902,14927,14932,14941,14958,14980,15028,15063,15069,15074,15108,15120,15138,15147,15196,15215,15216,15229,15243,15245,15263,15266,15277,15282,15304,15312,15356,15359,15370,15402,15411,15420,15439,15447,15464,15475,15477,15485,15497,15521,15524,15543,15548,15551,15552,15562,15577,15588,15604,15632,15633,15644,15664,15703,15709,15722,15725,15728,15750,15763,15789,15804,15806,15837,15841,15848,15866,15873,15893,15955,15959,15964,15967,15969,15971,15982,16020,16037,16039,16050,16052,16059,16093,16153,16166,16216,16220,16224,16257,16258,16320,16342,16356,16369,16370,16386,16416,16418,16428,16451,16466,16481,16483,16507,16513,16515,16539,16545,16569,16578,16605,16607,16619,16629,16630,16634,16636,16644,16653,16663,16666,16674,16693,16704,16722,16742,16772,16774,16780,16791,16800,16825,16829,16845,16867,16874,16880,16903,16904,16913,16917,16969,16996,17005,17026,17048,17055,17059,17090,17115,17117,17126,17128,17131,17132,17137,17166,17194,17205,17224,17234,17243,17244,17250,17257,17277,17291,17301,17322,17337,17353,17372,17373,17374,17377,17392,17407,17420,17427,17432,17438,17464,17465,17493,17517,17527,17533,17552,17555,17557,17567,17569,17623,17626,17658,17660,17688,17730,17746,17747,17753,17766,17767,17770,17772,17775,17780,17781,17798,17799,17813,17822,17852,17857,17875,17889,17890,17892,17895,17901,17908,17912,17921,17925,17935,17942,17952,17956,17980,17987,17993,18007,18013,18018,18031,18032,18037,18038,18039,18055,18057,18068,18072,18100,18116,18121,18134,18140,18144,18150,18160,18169,18174,18181,18200,18202,18216,18239,18260,18265,18282,18283,18284,18311,18314,18316,18326,18327,18331,18355,18368,18373,18382,18384,18402,18425,18431,18436,18440,18442,18466,18476,18481,18492,18493,18514,18524,18543,18547,18548,18550,18562,18566,18569,18578,18579,18593,18601,18638,18646,18649,18659,18668,18679,18687,18733,18738,18752,18758,18764,18765,18773,18781,18793,18813,18837,18891,18893,18901,18914,18916,18927,18930,18934,18949,18951,18978,18991,19013,19018,19026,19043,19053,19059,19065,19073,19078,19083,19117,19134,19158,19168,19208,19219,19237,19271,19290,19292,19293,19304,19318,19329,19335,19343,19381,19407,19411,19415,19424,19427,19428,19429,19438,19448,19450,19457,19497,19505,19508,19519,19526,19535,19541,19542,19545,19547,19549,19553,19556,19576,19578,19595,19600,19602,19604,19606,19612,19623,19645,19646,19667,19682,19694,19699,19700,19704,19713,19720,19741,19744,19764,19773,19797,19800,19804,19809,19825,19841,19853,19882,19894,19917,19918,19953,19970,20004,20012,20016,20029,20043,20051,20076,20112,20133,20137,20142,20153,20154,20181,20202,20242,20265,20291,20295,20306,20349,20396,20398,20403,20404,20432,20455,20486,20524,20542,20543,20568,20569,20602,20621,20624,20649,20651,20666,20684,20693,20694,20707,20714,20721,20726,20738,20739,20744,20748,20764,20773,20807,20809,20820,20836,20861,20871,20880,20883,20896,20906,20933,20945,20967,20977,20980,20997,21019,21027,21031,21033,21073,21101,21115,21145,21154,21171,21189,21198,21203,21205,21206,21213,21233,21236,21248,21251,21268,21274,21283,21284,21292,21310,21322,21331,21339,21354,21356,21358,21362,21372,21388,21410,21430,21438,21450,21472,21481,21488,21536,21537,21539,21552,21576,21584,21586,21592,21593,21601,21611,21620,21645,21668,21669,21691,21709,21734,21739,21748,21763,21769,21781,21787,21805,21821,21828,21837,21851,21871,21875,21916,21921,21922,21940,21952,22010,22021,22029,22037,22038,22045,22065,22066,22087,22110,22121,22131,22153,22173,22177,22192,22200,22216,22223,22238,22244,22245,22246,22260,22289,22295,22307,22311,22318,22334,22336,22354,22371,22377,22388,22401,22402,22415,22416,22422,22426,22451,22455,22458,22476,22500,22503,22509,22543,22550,22585,22587,22602,22653,22677,22688,22702,22708,22723,22738,22741,22742,22745,22756,22800,22802,22803,22820,22831,22848,22852,22854,22864,22872,22876,22888,22891,22901,22924,22931,22935,22938,22939,22943,22954,22968,22991,23023,23028,23031,23039,23041,23063,23064,23070,23073,23077,23097,23101,23107,23114,23122,23131,23153,23173,23210,23219,23221,23236,23243,23258,23296,23299,23312,23334,23344,23350,23382,23394,23406,23424,23428,23433,23441,23449,23469,23484,23489,23518,23524,23541,23547,23567,23575,23592,23593,23613,23617,23635,23638,23649,23657,23672,23691,23708,23715,23722,23729,23747,23749,23769,23793,23811,23855,23860,23861,23864,23899,23906,23926,23954,23967,23973,23984,23987,23992,24017,24043,24052,24088,24105,24111,24135,24158,24163,24166,24170,24185,24198,24229,24273,24282,24289,24332,24375,24406,24407,24408,24433,24448,24455,24475,24479,24498,24502,24513,24524,24536,24599,24607,24612,24623,24628,24636,24642,24658,24665,24713,24722,24765,24784,24814,24819,24823,24838,24853,24869,24881,24904,24916,24924,24944,24958,25010,25030,25039,25048,25093,25130,25135,25141,25155,25172,25183,25197,25205,25268,25277,25278,25284,25292,25307,25311,25312,25317,25326,25342,25349,25365,25394,25397,25417,25421,25449,25474,25488,25528,25541,25548,25553,25557,25595,25621,25622,25625,25635,25657,25668,25693,25705,25717,25725,25750,25772,25797,25818,25847,25870,25881,25884,25896,25909,25912,25943,25946,25958,25964,25969,26003,26014,26020,26031,26043,26048,26078,26095,26108,26109,26136,26154,26159,26166,26167,26178,26179,26198,26228,26249,26255,26281,26282,26305,26317,26348,26353,26357,26362,26363,26369,26378,26399,26403,26410,26447,26448,26454,26467,26468,26475,26507,26508,26529,26530,26564,26570,26574,26590,26616,26626,26630,26636,26722,26726,26753,26779,26785,26797,26803,26804,26807,26824,26839,26852,26853,26860,26866,26909,26944,26945,26948,26950,26955,26976,27035,27046,27055,27084,27107,27109,27118,27120,27124,27125,27130,27131,27133,27161,27237,27275,27280,27287,27302,27311,27322,27353,27362,27363,27383,27418,27421,27427,27445,27450,27457,27465,27474,27482,27491,27548,27550,27574,27610,27742,27779,27833,27859,27874,27938,28005,28033,28107,28114,28128,28189,28233,28303,28306,28318,28327,28436,28559,28598,28621,28628,28630,28746,28763,28764,28771,28803,28824,28833,28834,28872,28943,28950,28951,28992,29012,29022,29047,29172,29210,29244,29357,29358,29373,29420,29423,29438,29486,29489,29509,29510,29512,29548,29625,29648,29653,29832,29846,29863,29864,30251,30285,30433,30434,30562,30810,31019,31384,31697,31890,32322,32530,32919,33270,33345,33440,33504,33505,33506,33507,33508,33509,33510,33511,33877,34174,34185,34186,34676,35000,35226,35299,35337,35360,35379,35434,35596,35660,35661,35727,35777,35780,35814,36085,36297,36751,36798,36817,36821,36889,36961,37034,37107,37116,37170,37397,37403,37439,37454,38006,38059,38103,38114,38122,38128,38315,38343,38398,38440,38446,38452,38530,38549,38674,39027,39052,39150,39163,39193,39245,39276,39283,39315,39319,39333,39347,39375,39384,39389,39464,39465,39475,39483,39492,39542,39609,39646,39666,39698,39706,39710,39722,39747,39768,39802,39819,39866,40018,40089,40110,40224,40231,40259,40276,40332,40355,40398,40436,40438,40460,40465,40490,40515,40535,40554,40555,40562,40614,40649,40651,40667,40688,40737,40774,40811,40817,40875,40959,41040,41058,41068,41069,41150,41220,41239,41246,41292,41322,41336,41350,41418,41436,41499,41570,41576,41649,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,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,44351,44400,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 | 1952 | 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.83 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.95 ms |
preparing | 1.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 19.12 ms |
end | 0.03 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
freeing items | 0.24 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 |