Tiempo de la consulta: 4.23 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.332 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 01:52:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 01:52:02')
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(137,139,154,185,259,313,315,374,416,500,593,625,668,682,697,825,842,843,1051,1066,1223,1230,1286,1319,1327,1359,1411,1418,1432,1496,1540,1556,1571,1620,1660,1686,1724,1730,1731,1748,1754,1811,1839,1870,1901,1994,2165,2230,2251,2343,2369,2423,2436,2542,2574,2643,2675,2678,2682,2699,2780,2808,2825,2884,3026,3033,3036,3037,3079,3122,3165,3188,3193,3281,3292,3294,3316,3329,3346,3375,3427,3490,3521,3593,3597,3624,3721,3722,3752,3847,3871,3899,3927,3947,4011,4025,4026,4049,4194,4227,4267,4323,4331,4344,4386,4411,4451,4461,4468,4486,4507,4510,4520,4562,4583,4584,4620,4640,4672,4674,4677,4690,4693,4760,4787,4816,4825,4832,4876,4959,5049,5053,5088,5092,5094,5138,5150,5151,5158,5170,5183,5244,5251,5282,5299,5301,5398,5399,5469,5505,5515,5659,5677,5683,5688,5703,5714,5802,5831,5840,5848,5850,6062,6071,6093,6141,6142,6154,6164,6166,6176,6256,6335,6345,6437,6467,6475,6538,6582,6606,6612,6690,6751,6763,6772,6783,6847,6872,6916,6944,6976,6998,7024,7105,7139,7276,7428,7482,7484,7513,7533,7590,7615,7640,7647,7678,7726,7745,7856,7869,7918,7966,7991,7993,7998,8002,8037,8039,8129,8141,8176,8269,8294,8393,8453,8454,8498,8532,8553,8568,8569,8667,8707,8737,8821,8834,8940,9056,9058,9061,9147,9190,9201,9223,9263,9351,9401,9559,9569,9590,9610,9641,9731,9743,9745,9754,9809,9873,9881,9932,10017,10079,10121,10177,10268,10340,10371,10407,10409,10501,10572,10612,10703,10796,10803,10805,10854,11130,11149,11207,11241,11288,11320,11324,11402,11408,11549,11670,11687,11693,11700,11722,11803,11814,12197,12218,12302,12324,12332,12377,12393,12441,12500,12601,12693,12749,12870,12880,12952,12992,13002,13012,13067,13296,13319,13353,13476,13586,13638,13731,13734,13775,13899,13913,14022,14027,14111,14129,14181,14212,14364,14380,14402,14557,14648,14808,14873,14944,14969,14974,14975,15019,15020,15032,15133,15140,15144,15227,15427,15464,15533,15594,15610,15613,15619,15646,15682,15690,15710,15712,15856,15868,15871,15878,15969,16072,16081,16102,16103,16120,16121,16176,16245,16284,16423,16450,16487,16547,16553,16569,16633,16648,16667,16742,16743,16797,16800,16847,16905,16988,16994,16997,17055,17136,17265,17276,17304,17315,17395,17427,17449,17458,17483,17508,17608,17756,17881,17901,17945,17986,18009,18035,18066,18075,18077,18088,18097,18203,18234,18241,18269,18298,18307,18311,18327,18469,18490,18591,18652,18779,18977,19019,19031,19083,19130,19137,19158,19192,19260,19270,19272,19327,19520,19586,19599,19647,19695,19706,19710,19860,19874,19996,20050,20188,20191,20237,20341,20448,20590,20599,20683,20708,20806,20838,20921,20966,20967,20997,21036,21062,21097,21112,21132,21154,21203,21214,21229,21257,21271,21279,21295,21453,21473,21500,21521,21523,21524,21560,21720,21762,21835,22015,22033,22038,22444,22478,22584,22726,22739,22779,22829,22870,22886,23065,23099,23129,23176,23344,23365,23390,23397,23400,23431,23468,23479,23482,23497,23733,23741,23788,23839,23857,23871,23932,24051,24057,24070,24077,24175,24185,24439,24690,24765,24920,24933,24989,25030,25062,25112,25115,25155,25624,25689,25910,25966,25995,26000,26037,26043,26044,26082,26100,26127,26147,26148,26241,26306,26405,26447,26504,26509,26652,26673,26675,26707,26762,26825,26897,26949,26982,26991,26997,27023,27134,27175,27301,27302,27303,27304,27305,27306,27307,27308,27309,27310,27313,27314,27315,27317,27322,27324,27325,27326,27327,27328,27329,27330,27331,27332,27333,27334,27335,27337,27338,27339,27340,27341,27343,27345,27346,27347,27348,27349,27350,27351,27353,27354,27355,27356,27357,27358,27359,27360,27361,27362,27366,27367,27370,27371,27372,27374,27375,27376,27377,27378,27379,27381,27382,27383,27384,27386,27387,27388,27389,27390,27391,27393,27395,27396,27397,27398,27399,27401,27402,27403,27404,27405,27406,27408,27410,27412,27413,27414,27415,27416,27417,27418,27419,27445,27455,27458,27480,27481,27490,27511,27522,27630,27702,27783,27806,27808,27809,27829,27843,27875,27883,28022,28055,28152,28193,28218,28334,28336,28340,28483,28545,28548,28562,28577,28615,28616,28629,28656,28665,28671,28706,28707,28725,28727,28728,28745,28763,28776,28777,28795,28799,28800,28803,28807,28829,28833,28834,28844,28847,28866,28872,28925,28931,28979,28982,28999,29077,29091,29127,29201,29214,29215,29223,29229,29293,29329,29374,29389,29418,29459,29468,29484,29894,30138,30262,30269,30330,30526,30572,30573,30849,30956,30963,30981,31401,32286,32310,32965,33107,33327,33503,34265,34499,34595,34785,34902,34942,34944,34969,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35294,35308,35326,35427,35430,35564,35574,35588,35657,35674,35684,35694,35710,35724,35754,35799,35857,35887,35895,35926,35931,36012,36021,36165,36169,36191,36264,36267,36285,36346,36353,36355,36427,36463,36575,36750,36795,36798,36806,36901,36984,37129,37251,37528,37529,37532,37722,37723,37925,37972,38212,38233,38361,38365,38392,38417,38503,38510,38598,38651,38689,38752,38825,38837,38855,38883,38906,38956,38964,39001,39007,39014,39037,39056,39061,39070,39126,39141,39170,39177,39229,39255,39299,39301,39364,39444,39452,39521,39529,39530,39540,39559,39573,39595,39606,39703,39720,39763,39764,39876,39882,39898,39916,39971,39994,40042,40052,40065,40091,40107,40110,40119,40240,40242,40275,40358,40481,40502,40514,40625,40655,40709,40735,40750,40767,40784,40822,40834,40971,40992,41063,41117,41298,41348,41353,41380,41381,41520,41723,41744,41838,41866,41874,42394,42404,42466,42547,42554,42793,42822,42823,42876,42882,43090,43107,43142,43162,43165,43257,43353,43361,43381,43412,43485,43535,43645,43661,43944,43982,44078,44100,44101,44340,44635,44727,44765,44817,45071,45072,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 | 965 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.52 ms |
preparing | 0.74 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 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 |