Tiempo de la consulta: 4.82 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.529 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-05 03:43:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:43:56')
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(138,185,214,220,224,259,261,267,318,367,450,452,529,532,556,625,681,754,843,1006,1051,1066,1182,1200,1256,1285,1286,1321,1326,1327,1331,1347,1351,1359,1371,1431,1432,1526,1540,1565,1620,1633,1655,1686,1724,1741,1754,1776,1785,1814,1839,1907,1945,2004,2013,2017,2072,2109,2142,2198,2314,2331,2338,2354,2369,2376,2384,2428,2437,2467,2473,2559,2574,2580,2628,2643,2780,2808,2825,2870,2884,2898,2939,3026,3033,3037,3074,3131,3165,3188,3193,3198,3204,3209,3215,3224,3240,3277,3281,3283,3292,3329,3346,3375,3377,3424,3442,3453,3478,3486,3512,3564,3567,3590,3593,3641,3660,3662,3705,3721,3722,3752,3779,3863,3906,3934,3961,3962,3979,4025,4026,4049,4059,4098,4136,4154,4172,4192,4238,4257,4266,4283,4359,4443,4451,4461,4468,4486,4491,4507,4510,4520,4529,4564,4566,4583,4584,4620,4622,4640,4672,4673,4674,4675,4690,4718,4741,4756,4787,4832,4834,4844,4846,4876,4880,4940,4950,4968,5021,5072,5092,5094,5170,5183,5233,5244,5247,5282,5285,5299,5301,5303,5336,5346,5410,5423,5469,5488,5495,5505,5563,5565,5622,5628,5638,5644,5648,5677,5683,5684,5685,5688,5703,5802,5827,5831,5837,5848,5872,5888,5986,6012,6014,6093,6142,6166,6176,6209,6256,6260,6290,6294,6307,6310,6335,6336,6345,6381,6501,6538,6550,6553,6606,6612,6614,6615,6690,6783,6802,6944,6950,6998,7002,7008,7024,7039,7104,7105,7139,7147,7168,7205,7230,7266,7287,7289,7382,7383,7397,7423,7428,7467,7471,7513,7533,7594,7615,7647,7681,7688,7846,7869,7881,7918,7936,7938,7993,7995,7998,8002,8027,8047,8099,8186,8189,8223,8286,8294,8315,8352,8355,8357,8391,8393,8397,8406,8449,8481,8484,8532,8536,8541,8543,8568,8571,8617,8707,8747,8773,8776,8818,8940,8947,8959,8985,9001,9051,9061,9075,9107,9109,9115,9147,9151,9155,9160,9190,9195,9197,9286,9295,9311,9392,9401,9425,9442,9559,9607,9641,9655,9684,9728,9777,9799,9800,9801,9814,9825,9855,9873,9901,9931,9932,9965,9968,9971,9987,9996,10001,10011,10068,10134,10138,10167,10172,10299,10340,10371,10405,10407,10413,10481,10501,10572,10671,10673,10790,10922,10932,10991,11207,11231,11236,11241,11281,11371,11408,11549,11626,11693,11694,11697,11814,11936,11997,12046,12117,12137,12182,12217,12221,12255,12314,12341,12358,12440,12459,12500,12614,12621,12626,12714,12835,12870,12878,12897,12902,12982,13002,13023,13067,13145,13152,13153,13263,13298,13353,13413,13431,13436,13476,13530,13534,13537,13544,13546,13557,13585,13608,13617,13626,13629,13655,13691,13729,13748,13750,13811,13846,13853,13858,13859,13922,13923,14022,14047,14088,14090,14122,14129,14135,14206,14314,14419,14435,14464,14501,14518,14577,14581,14584,14595,14688,14706,14729,14738,14773,14808,14828,14873,14879,14904,14925,14944,14974,15063,15133,15140,15144,15178,15208,15218,15238,15306,15363,15405,15608,15613,15619,15646,15654,15690,15710,15755,15776,15868,15871,15878,15903,15942,15963,15969,16003,16029,16074,16081,16088,16102,16103,16120,16135,16176,16245,16259,16293,16318,16340,16365,16416,16426,16439,16503,16507,16526,16547,16569,16594,16646,16693,16742,16743,16807,16831,16836,16840,16859,16961,17058,17090,17136,17141,17213,17238,17259,17267,17315,17367,17376,17395,17418,17440,17446,17449,17458,17483,17487,17547,17608,17662,17737,17756,17764,17769,17804,17823,17837,17839,17863,17881,17925,17947,17986,18044,18066,18075,18077,18088,18114,18203,18219,18241,18307,18311,18327,18371,18412,18488,18490,18511,18602,18652,18707,18770,18779,18807,18816,18857,18878,18965,18992,18996,19019,19025,19053,19066,19096,19137,19316,19367,19400,19463,19529,19543,19647,19706,19710,19799,19860,19874,19914,19996,20057,20095,20134,20135,20177,20188,20191,20395,20424,20448,20483,20504,20599,20704,20828,20879,20886,20921,20966,20967,20972,20997,21031,21036,21070,21085,21132,21203,21204,21205,21247,21279,21295,21315,21402,21459,21460,21473,21560,21610,21654,21688,21720,21780,21815,21835,21846,21909,22036,22038,22131,22132,22201,22280,22344,22376,22525,22541,22632,22726,22749,22779,22868,22870,22886,22990,23065,23072,23127,23196,23250,23397,23400,23401,23457,23471,23482,23509,23545,23686,23713,23728,23788,23888,23932,23961,23973,24047,24100,24135,24164,24289,24300,24309,24500,24556,24591,24594,24606,24627,24690,24731,24793,24876,24912,24920,24933,24984,24998,25030,25112,25256,25304,25307,25433,25473,25593,25626,25689,25730,25769,25835,25865,25897,25966,25995,26000,26037,26040,26043,26044,26080,26081,26082,26093,26100,26145,26148,26241,26318,26319,26374,26405,26410,26429,26447,26494,26504,26516,26601,26629,26630,26638,26652,26663,26707,26752,26760,26762,26825,26838,26897,26935,26936,26949,26982,26991,26992,27009,27023,27100,27101,27142,27144,27164,27179,27184,27206,27259,27293,27340,27344,27354,27384,27399,27440,27463,27491,27511,27522,27524,27526,27559,27571,27673,27688,27702,27805,27843,27860,27875,27898,27928,28013,28049,28129,28152,28193,28218,28334,28340,28384,28406,28548,28585,28587,28615,28616,28629,28656,28665,28671,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28817,28833,28834,28844,28847,28866,28872,28925,28931,29001,29033,29127,29201,29319,29329,29374,29389,29418,29446,29459,29468,29473,29606,29894,30138,30262,30572,30573,31401,31779,31873,32152,32286,32552,32965,33042,33044,33107,33160,33327,33503,33884,33885,33886,34011,34111,34265,34284,34403,34595,34667,34668,34669,34785,34788,34892,34902,34942,34969,35003,35051,35071,35072,35073,35088,35097,35126,35156,35165,35167,35174,35195,35206,35235,35294,35308,35326,35363,35427,35430,35472,35564,35588,35650,35657,35674,35694,35724,35931,35933,35943,36012,36040,36042,36047,36095,36111,36165,36173,36191,36194,36233,36248,36285,36308,36309,36346,36355,36463,36499,36557,36575,36587,36672,36698,36750,36760,36795,36798,36806,36848,36880,36895,36993,37065,37088,37129,37159,37208,37243,37251,37311,37411,37528,37529,37532,37759,37828,37972,38088,38092,38169,38212,38293,38340,38365,38392,38411,38417,38428,38467,38472,38503,38548,38591,38598,38651,38697,38705,38762,38763,38825,38964,39021,39036,39056,39061,39123,39142,39143,39157,39170,39299,39301,39409,39427,39529,39616,39638,39703,39839,39882,39971,39984,40016,40052,40107,40110,40119,40219,40265,40358,40434,40481,40552,40603,40608,40625,40655,40784,41063,41117,41142,41348,41353,41380,41381,41449,41520,41694,41723,41744,41753,41866,41874,42100,42116,42204,42394,42403,42404,42409,42523,42548,42686,42698,42816,42822,43064,43090,43107,43162,43353,43532,43644,43645,43652,43841,43944,43977,44078,44100,44101,44229,44679,44708,44774,44817,44850,44971,45134,45293)
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 | 1128 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.79 ms |
preparing | 0.88 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |