Tiempo de la consulta: 3.89 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.315 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-07 16:18:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:18:08')
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,9,11,46,49,57,58,62,64,73,124,130,149,155,170,172,173,177,180,186,188,189,198,202,212,214,215,220,221,244,246,248,250,253,260,287,290,291,292,293,330,337,344,353,394,417,418,419,423,427,433,437,439,452,459,481,521,524,550,551,567,583,587,595,596,597,603,604,607,612,613,628,641,647,659,662,678,686,693,699,704,779,788,797,843,845,852,902,927,938,954,997,1015,1066,1099,1100,1114,1119,1207,1218,1222,1227,1232,1247,1268,1269,1271,1272,1273,1274,1339,1357,1397,1432,1486,1512,1519,1543,1627,1740,1800,1803,1853,1904,1931,1960,2012,2048,2053,2088,2092,2122,2137,2142,2155,2189,2190,2241,2288,2389,2431,2482,2532,2551,2581,2598,2609,2687,2710,2746,2757,2811,2852,2906,2937,2997,3020,3027,3028,3031,3045,3120,3124,3130,3156,3193,3209,3212,3224,3240,3258,3373,3415,3416,3417,3418,3473,3512,3554,3557,3671,3721,3738,3748,3836,3842,4068,4120,4128,4301,4399,4490,4580,4611,4640,4767,4815,4831,4844,4846,4905,5018,5045,5055,5096,5164,5370,5471,5559,5562,5581,5647,5894,5899,6011,6039,6093,6112,6131,6234,6253,6264,6405,6484,6616,6688,6939,6998,7324,7361,7483,7491,7495,7677,7795,7847,7894,7965,8027,8080,8084,8087,8291,8512,8517,9087,9219,9282,9318,9360,9387,9460,9515,9679,9930,10046,10100,10149,10382,10483,10623,10671,10708,10720,10721,10764,10782,10957,11210,11748,11792,11846,11854,12202,12256,12270,12271,12290,12380,12427,12440,12581,12582,12806,12851,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,12978,13027,13142,13186,13246,13264,13307,13328,13332,13391,13420,13515,13702,13748,13972,14074,14114,14224,14242,14372,14453,14504,14527,14565,14571,14630,14703,14801,14845,14852,14856,14976,14977,14983,15007,15129,15154,15156,15175,15214,15235,15324,15335,15351,15376,15406,15424,15470,15473,15475,15500,15520,15522,15533,15542,15562,15580,15581,15600,15602,15604,15630,15689,15700,15707,15709,15742,15781,15785,15790,15812,15832,15880,15922,15940,15955,15985,16017,16056,16095,16127,16245,16249,16279,16297,16337,16357,16382,16384,16412,16417,16427,16435,16475,16479,16521,16551,16556,16619,16643,16675,16722,16781,16790,16791,16816,16830,16838,16841,16922,16995,17028,17049,17116,17188,17240,17246,17268,17283,17288,17293,17331,17337,17360,17387,17422,17442,17444,17458,17465,17497,17507,17561,17567,17573,17584,17630,17711,17736,17779,17806,17807,17834,17850,17856,17862,17863,17905,17918,17919,17930,17936,17950,17967,17983,18005,18044,18046,18047,18050,18061,18140,18147,18171,18194,18222,18225,18244,18260,18295,18313,18334,18357,18382,18435,18439,18460,18480,18496,18516,18524,18537,18544,18552,18588,18598,18603,18609,18629,18649,18659,18664,18665,18693,18706,18728,18754,18769,18790,18804,18825,18830,18859,18861,18868,18877,18885,18888,18894,18905,18908,18917,18930,18933,18953,18989,19005,19015,19042,19061,19073,19105,19124,19128,19140,19169,19173,19219,19237,19244,19282,19287,19293,19299,19315,19320,19322,19346,19381,19427,19452,19486,19503,19607,19639,19647,19684,19695,19710,19725,19733,19794,19796,19807,19837,19904,19923,19937,20001,20119,20147,20152,20175,20215,20306,20391,20445,20530,20542,20621,20638,20659,20661,20772,20777,20843,20910,20920,20940,20959,20963,21047,21049,21117,21118,21143,21166,21172,21313,21344,21367,21398,21421,21457,21470,21472,21508,21520,21522,21526,21578,21596,21663,21672,21684,21695,21702,21741,21757,21764,21776,21883,21906,21917,21968,21997,22038,22049,22067,22106,22119,22162,22178,22227,22278,22298,22362,22402,22427,22450,22460,22476,22511,22555,22570,22585,22651,22709,22758,22759,22820,22840,22941,22944,22960,22970,23023,23034,23093,23242,23254,23279,23281,23340,23367,23368,23405,23429,23430,23438,23469,23528,23553,23555,23571,23625,23631,23671,23675,23708,23804,23819,23849,23898,23951,23955,23968,23975,24076,24125,24153,24164,24237,24406,24426,24530,24540,24584,24585,24690,24779,24802,24805,24841,24862,24870,24946,24963,25004,25037,25081,25105,25117,25257,25269,25297,25329,25376,25401,25452,25465,25523,25548,25572,25676,25721,25807,25919,25971,26172,26229,26245,26261,26268,26523,26587,26596,26854,26873,26959,27001,27061,27062,27158,27198,27290,27307,27348,27552,27578,27646,27707,27745,27851,27927,27950,28066,28094,28213,28248,28264,28283,28402,28416,28436,28442,28458,28534,28547,28555,28575,28683,28749,28817,28826,28867,28918,29033,29061,29073,29201,29221,29312,29440,29539,29553,29719,29824,30596,30768,31114,31663,31763,31885,31896,32840,33258,33380,33416,33649,35882,37056,37210,37605,37695,37696,37702,38261,38475,39180,39186,39258,39267,39463,39469,39491,39495,39543,39750,39819,39870,39884,39933,39981,39998,40168,40207,40208,40355,40402,40572,40611,40837,40852,41241,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,44590,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 | 858 | 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.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.47 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 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 |