Tiempo de la consulta: 4.92 ms Después de la última consulta: 1.08 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.515 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 03:50:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 03:50:17')
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(71,75,76,78,85,119,126,133,155,165,185,192,214,255,271,272,279,280,283,285,303,323,349,390,400,403,412,429,450,479,495,505,507,531,572,657,666,667,678,689,690,722,732,734,787,795,805,807,808,825,832,845,863,868,869,885,896,898,914,937,940,942,954,976,1000,1036,1042,1066,1069,1071,1101,1102,1125,1193,1207,1233,1250,1255,1278,1279,1285,1295,1329,1414,1425,1428,1458,1459,1469,1492,1509,1521,1538,1591,1638,1645,1648,1649,1660,1684,1735,1745,1771,1846,1867,1885,1887,1975,1978,2016,2054,2069,2089,2101,2254,2328,2402,2428,2517,2554,2569,2605,2647,2674,2804,2855,2954,2958,2961,2967,3001,3065,3099,3106,3107,3114,3154,3169,3174,3183,3208,3227,3249,3303,3312,3343,3346,3369,3402,3409,3412,3444,3454,3493,3569,3577,3594,3597,3604,3624,3651,3663,3702,3749,3750,3754,3832,3853,3898,3910,3983,3984,3986,4043,4216,4227,4301,4353,4381,4383,4410,4492,4503,4589,4674,4677,4718,4726,4732,4750,4810,4816,4823,4825,4905,5021,5046,5047,5053,5076,5078,5079,5093,5095,5123,5170,5215,5221,5232,5348,5396,5424,5461,5478,5513,5536,5584,5680,5687,5700,5731,5755,5846,5857,5876,5878,5913,6038,6049,6058,6094,6102,6120,6178,6208,6301,6309,6315,6331,6345,6353,6354,6363,6370,6372,6400,6469,6492,6539,6542,6543,6546,6557,6577,6593,6614,6639,6664,6670,6671,6706,6807,6808,6840,6876,6964,6997,7000,7018,7026,7062,7100,7102,7122,7246,7248,7338,7358,7478,7556,7569,7583,7596,7630,7720,7736,7749,7818,7841,7856,7897,7913,7914,7917,7924,8046,8076,8080,8088,8089,8090,8100,8116,8118,8206,8290,8327,8373,8392,8404,8530,8551,8577,8685,8740,8784,8819,8859,8864,8907,8937,8940,8943,9028,9029,9048,9056,9057,9082,9087,9114,9115,9152,9200,9314,9364,9544,9658,9756,9757,9764,9825,9836,9849,9857,9964,10006,10059,10090,10091,10156,10190,10195,10198,10273,10355,10462,10475,10478,10630,10658,10689,10801,10890,10947,10973,11022,11059,11064,11138,11195,11207,11318,11330,11410,11472,11494,11531,11532,11533,11534,11557,11618,11621,11693,11727,11834,11841,11854,11930,11937,11965,12138,12141,12152,12189,12205,12207,12244,12270,12333,12336,12401,12410,12430,12477,12479,12531,12535,12620,12625,12628,12637,12704,12708,12802,12875,12942,12954,13017,13025,13029,13086,13112,13129,13166,13188,13209,13217,13220,13268,13269,13294,13298,13352,13363,13454,13477,13524,13530,13548,13550,13567,13573,13637,13641,13671,13672,13678,13687,13707,13712,13744,13763,13798,13821,13842,13855,13860,13950,13974,13975,13980,14016,14081,14092,14105,14142,14148,14159,14188,14192,14197,14271,14273,14338,14348,14374,14428,14456,14524,14602,14646,14675,14705,14711,14737,14769,14789,14795,14856,14876,14890,14937,14938,14987,15004,15018,15030,15032,15037,15049,15074,15247,15248,15300,15323,15382,15403,15424,15439,15492,15496,15531,15542,15546,15562,15572,15575,15589,15606,15625,15717,15719,15728,15760,15834,15896,15897,15904,15943,15992,16014,16051,16108,16140,16148,16161,16178,16206,16216,16218,16246,16257,16269,16321,16325,16361,16387,16390,16398,16432,16444,16497,16521,16529,16534,16538,16543,16546,16596,16603,16604,16642,16652,16657,16698,16700,16713,16733,16734,16745,16808,16829,16850,16892,16929,16936,16977,17000,17043,17086,17087,17100,17134,17135,17138,17148,17157,17178,17189,17197,17202,17215,17309,17338,17347,17349,17358,17432,17493,17596,17617,17659,17695,17702,17753,17766,17775,17811,17818,17819,17831,17835,17842,17870,17883,17938,17961,18043,18078,18112,18113,18129,18140,18142,18166,18222,18249,18292,18295,18309,18316,18326,18358,18384,18407,18409,18419,18431,18442,18452,18456,18457,18485,18498,18521,18534,18535,18543,18555,18577,18612,18622,18669,18682,18689,18703,18717,18739,18763,18772,18781,18826,18833,18835,18847,18848,18867,18879,18893,18901,18910,18937,18991,18996,19022,19046,19083,19086,19105,19126,19133,19158,19171,19185,19207,19217,19223,19241,19247,19274,19294,19304,19308,19364,19366,19386,19396,19442,19453,19482,19514,19518,19524,19540,19541,19554,19567,19604,19649,19650,19653,19661,19693,19700,19720,19729,19776,19779,19823,19828,19855,19867,19870,19871,19873,19932,19983,19991,20002,20036,20046,20055,20082,20099,20103,20159,20162,20163,20183,20198,20216,20230,20272,20311,20323,20354,20374,20394,20402,20408,20422,20438,20440,20452,20453,20456,20464,20471,20485,20503,20533,20564,20578,20579,20649,20652,20659,20677,20698,20732,20757,20768,20774,20840,20905,20911,20915,20981,20993,21044,21060,21161,21162,21165,21178,21198,21227,21252,21284,21304,21309,21333,21335,21341,21347,21361,21369,21388,21397,21405,21415,21452,21480,21482,21498,21516,21517,21522,21536,21567,21606,21619,21622,21704,21709,21732,21750,21794,21801,21803,21815,21822,21830,21834,21840,21846,21900,21906,21912,21922,21926,21941,21962,21988,22026,22040,22057,22059,22097,22154,22180,22200,22202,22204,22229,22234,22244,22245,22246,22270,22276,22296,22351,22373,22385,22414,22422,22489,22500,22502,22527,22565,22607,22611,22692,22720,22742,22744,22774,22784,22802,22805,22818,22829,22848,22874,22889,22895,22924,22926,22960,22963,22992,23014,23016,23019,23034,23035,23040,23081,23104,23124,23145,23147,23151,23156,23178,23198,23245,23247,23256,23300,23325,23332,23343,23388,23399,23408,23453,23454,23468,23474,23485,23492,23513,23521,23565,23566,23570,23574,23647,23648,23653,23654,23676,23749,23759,23763,23807,23828,23833,23839,23857,23900,23922,23930,23935,23948,23955,23962,23967,23998,24072,24076,24119,24141,24152,24172,24174,24192,24216,24224,24228,24242,24264,24271,24277,24282,24288,24309,24312,24342,24383,24398,24427,24440,24443,24450,24451,24462,24472,24477,24479,24498,24510,24529,24535,24601,24618,24624,24625,24630,24636,24643,24685,24705,24747,24763,24826,24851,24888,24891,24924,24943,24968,24979,24989,24995,25018,25048,25090,25100,25110,25126,25133,25222,25245,25286,25334,25360,25398,25400,25413,25511,25624,25631,25673,25707,25736,25740,25787,25801,25816,25818,25860,25885,25940,25941,25955,25968,26002,26017,26034,26061,26091,26122,26123,26130,26195,26202,26261,26264,26361,26373,26378,26396,26403,26410,26439,26454,26458,26471,26534,26550,26570,26630,26637,26640,26665,26679,26758,26763,26766,26770,26772,26779,26792,26808,26866,26898,26907,26910,26939,26992,26996,27024,27026,27029,27039,27071,27105,27106,27131,27138,27144,27151,27178,27179,27183,27186,27189,27201,27203,27212,27265,27322,27337,27343,27356,27409,27475,27490,27492,27513,27520,27545,27548,27549,27738,27800,27974,28355,28391,28452,28481,28678,28706,28745,28779,28845,29107,29187,29200,29366,29464,29511,29626,30242,30393,30394,30511,30609,30801,30807,30818,30854,30881,30930,31773,32009,32048,32056,32241,32506,32583,32910,33435,33621,33645,33950,34052,34196,34415,34449,34494,34524,34525,34560,34584,34701,34733,34758,34927,34978,35144,35192,35259,35305,35321,35324,35436,35503,35609,35626,35718,35790,35836,35859,35953,35958,36014,36192,36197,36204,36238,36313,36344,36423,36515,36610,36736,36738,36819,36850,36887,36903,36966,37025,37248,38263,38658,38659,38660,38662,38779,38784,38788,38815,38818,38825,38860,38865,38905,38962,39003,39047,39078,39114,39226,39269,39296,39354,39640,39673,39729,39751,39808,39820,39823,39846,39848,40039,40111,40154,40187,40212,40213,40225,40239,40392,40521,40665,40812,40831,40886,40954,40983,41059,41146,41254,41594,42074,42262,42880,43237,43501,43763,43905,44059,44072,44085,44255,44433,44853,45191,45251)
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 | 1268 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.95 ms |
preparing | 1.01 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |