Tiempo de la consulta: 4.02 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.314 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-08 02:46:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 02:46:06')
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(3,8,11,46,57,62,64,73,107,119,124,130,149,155,177,180,186,188,189,198,202,212,214,215,220,221,244,246,248,250,253,260,266,330,337,394,417,418,419,423,427,433,439,452,459,481,521,524,550,551,567,583,587,595,596,597,603,604,612,613,628,641,647,659,662,678,686,699,779,788,845,852,902,927,938,954,1015,1066,1099,1100,1114,1119,1180,1218,1222,1227,1268,1269,1271,1272,1273,1274,1295,1357,1397,1432,1447,1512,1519,1543,1627,1740,1800,1803,1844,1852,1853,1904,1960,2012,2048,2053,2088,2092,2122,2137,2142,2155,2189,2190,2241,2288,2301,2389,2431,2482,2497,2532,2551,2556,2581,2598,2609,2640,2687,2694,2710,2746,2804,2809,2811,2852,2906,2937,2980,3027,3031,3120,3130,3156,3161,3193,3205,3224,3240,3258,3343,3401,3415,3416,3417,3418,3469,3473,3499,3512,3554,3557,3586,3721,3739,3748,3802,3804,3806,3819,3836,3875,3938,3960,4029,4033,4068,4180,4205,4237,4280,4299,4301,4311,4334,4337,4341,4362,4419,4477,4490,4533,4541,4568,4580,4594,4611,4640,4650,4665,4685,4761,4767,4810,4815,4820,4831,4840,4844,4846,4905,4936,4940,4980,5005,5018,5045,5055,5086,5096,5115,5131,5164,5199,5210,5258,5274,5329,5337,5370,5455,5502,5504,5536,5562,5581,5598,5642,5693,5697,5704,5783,5789,5806,5825,5835,5855,5894,5899,5908,5913,5940,5941,5959,5976,5979,5985,6009,6011,6020,6051,6064,6070,6093,6112,6135,6167,6196,6253,6264,6274,6291,6294,6356,6361,6405,6431,6479,6511,6826,6881,6925,6927,6939,6980,6982,7085,7148,7165,7166,7324,7357,7394,7491,7650,7713,7731,7793,7795,7813,7822,7854,8047,8060,8080,8084,8087,8092,8116,8151,8170,8206,8272,8291,8331,8341,8366,8388,8411,8466,8470,8512,8527,8539,8595,8607,8649,8652,8687,8695,8741,8755,8765,8775,8778,8802,8842,8846,8853,8875,8882,8913,8922,8929,8953,9009,9024,9026,9067,9069,9087,9096,9127,9132,9140,9171,9177,9178,9219,9253,9275,9282,9298,9360,9365,9382,9387,9424,9460,9484,9515,9522,9547,9582,9621,9651,9679,9734,9775,9781,9827,9830,9877,9930,9973,9980,10040,10046,10133,10183,10241,10347,10483,10511,10550,10580,10650,10669,10671,10688,10697,10708,10716,10720,10763,10764,10834,10838,10845,10900,10923,10931,11104,11119,11208,11214,11321,11353,11376,11390,11442,11530,11548,11748,11823,11846,11854,11933,11942,11972,12032,12088,12110,12202,12256,12271,12380,12389,12418,12427,12467,12556,12652,12785,12806,12884,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,12973,13008,13009,13027,13063,13142,13148,13186,13199,13240,13246,13264,13328,13391,13480,13546,13557,13562,13702,13719,13748,13898,14074,14085,14106,14114,14123,14224,14242,14270,14313,14332,14376,14476,14504,14527,14565,14571,14610,14662,14703,14748,14761,14772,14815,14853,14932,14955,14958,14959,14976,14977,15028,15041,15063,15124,15132,15154,15160,15175,15191,15224,15235,15324,15367,15369,15470,15473,15500,15509,15533,15542,15562,15573,15580,15602,15604,15630,15632,15647,15672,15707,15709,15736,15738,15743,15781,15832,15882,15897,15909,15933,15940,15955,15981,15985,16002,16017,16056,16084,16090,16193,16215,16245,16279,16297,16337,16338,16382,16412,16417,16435,16475,16479,16556,16618,16619,16643,16644,16722,16790,16791,16795,16830,16838,16922,17028,17053,17075,17245,17260,17268,17283,17293,17337,17360,17394,17422,17442,17451,17458,17465,17507,17517,17555,17567,17570,17584,17651,17672,17709,17778,17806,17807,17850,17856,17863,17873,17905,17918,18005,18046,18047,18050,18140,18147,18183,18194,18225,18242,18244,18313,18328,18334,18357,18435,18439,18460,18480,18496,18524,18530,18537,18544,18588,18589,18598,18603,18609,18626,18629,18631,18649,18659,18665,18703,18706,18717,18754,18769,18804,18859,18861,18868,18884,18885,18894,18908,18930,18933,18940,18953,18989,19005,19025,19042,19061,19073,19097,19115,19196,19217,19219,19237,19267,19275,19282,19293,19298,19299,19320,19322,19335,19346,19427,19448,19452,19502,19503,19647,19653,19695,19784,19796,19837,19865,19867,19885,19904,19953,19958,20001,20144,20147,20152,20215,20255,20306,20334,20391,20525,20530,20553,20598,20621,20661,20738,20785,20843,20875,20910,20920,20958,20963,21047,21049,21051,21052,21114,21130,21131,21166,21172,21313,21375,21472,21508,21555,21559,21599,21695,21741,21757,21778,21908,22049,22069,22162,22362,22378,22385,22402,22427,22488,22511,22513,22591,22611,22651,22709,22758,22784,22941,22987,23023,23096,23105,23254,23277,23340,23384,23469,23593,23625,23638,23684,23804,23817,23819,23823,23898,23951,24153,24426,24540,24585,24681,24701,24769,24770,24802,24819,24862,24910,25004,25105,25172,25244,25257,25283,25401,25460,25465,25488,25572,25721,26172,26245,26268,26306,26471,27198,27280,27307,27314,27322,27391,28248,28402,28416,28421,28436,28442,28458,28534,28547,28555,28575,28683,28817,28867,28918,28977,28991,29033,29153,29201,29221,29304,29312,29440,29553,29710,29824,30280,30596,31114,31663,31763,31885,31896,33416,33649,35718,35732,37056,37116,37210,37695,37696,37702,38261,38475,39180,39186,39258,39267,39463,39469,39491,39495,39543,39750,39819,39870,39884,39933,40207,40208,40355,40402,40572,40774,40837,40852,41241,41254,41444,41525,41526,41541,41606,41823,41946,41960,42024,42025,42067,42132,42251,42408,42421,42425,42426,42444,42748,42824,42839,43002,43052,43060,43069,43084,43087,43388,43717,44161,44509,44749,44763)
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 | 935 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.40 ms |
preparing | 0.69 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 |