Tiempo de la consulta: 5.70 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.325 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-06 00:16:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 00:16:41')
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(9,49,58,72,120,121,122,123,124,170,172,279,282,287,290,291,293,331,344,353,437,446,453,495,523,607,669,670,671,693,707,726,746,797,800,805,808,816,839,843,860,870,892,895,954,986,997,1123,1175,1207,1226,1232,1247,1304,1326,1339,1350,1486,1696,1744,1883,1917,1931,2265,2294,2365,2531,2601,2709,2713,2757,2853,2997,3005,3020,3028,3030,3045,3070,3124,3208,3209,3212,3219,3229,3412,3449,3452,3483,3531,3671,3738,3784,3831,3842,3898,3918,4120,4128,4258,4399,4625,4674,4676,4932,5279,5300,5362,5438,5471,5559,5647,5725,5792,5796,5825,6039,6131,6234,6292,6294,6452,6484,6558,6616,6688,6748,6822,6841,6895,6936,6998,7292,7325,7337,7361,7380,7387,7396,7401,7404,7412,7431,7453,7455,7457,7483,7488,7494,7532,7547,7551,7565,7581,7677,7682,7735,7779,7806,7829,7850,7867,7894,7965,7984,8027,8366,8615,8649,8780,8860,8916,8917,8932,9055,9165,9233,9318,9471,9670,9858,9909,10100,10149,10260,10305,10382,10418,10536,10611,10620,10623,10629,10659,10721,10771,10782,10894,10924,10946,10957,11083,11091,11095,11122,11127,11143,11157,11235,11309,11407,11427,11477,11486,11497,11585,11587,11612,11614,11720,11721,11727,11839,11915,11987,12010,12018,12038,12040,12091,12096,12098,12109,12121,12133,12156,12270,12299,12306,12415,12449,12581,12582,12592,12673,12735,12783,12848,12851,12895,12903,12916,12939,12942,12978,12991,13141,13198,13269,13273,13307,13309,13331,13332,13346,13373,13418,13420,13425,13515,13595,13611,13627,13672,13677,13697,13770,13819,13834,13884,13891,13902,13935,13951,13972,14073,14080,14084,14097,14103,14104,14114,14150,14163,14172,14196,14222,14227,14236,14267,14278,14334,14336,14354,14363,14372,14437,14453,14469,14478,14563,14574,14630,14632,14726,14747,14770,14799,14827,14842,14845,14846,14852,14856,14960,14983,14990,15006,15007,15053,15065,15069,15129,15146,15151,15156,15175,15206,15213,15214,15303,15335,15351,15376,15406,15424,15475,15520,15522,15565,15581,15600,15605,15631,15641,15668,15689,15700,15731,15742,15785,15790,15812,15880,15899,16014,16053,16087,16089,16095,16127,16163,16169,16208,16249,16356,16357,16384,16415,16427,16441,16442,16458,16474,16521,16551,16579,16623,16640,16645,16675,16688,16715,16751,16781,16794,16816,16827,16841,16864,16921,16964,16976,17043,17049,17059,17116,17130,17156,17188,17193,17205,17221,17227,17228,17240,17246,17263,17288,17331,17375,17387,17436,17444,17486,17488,17497,17500,17541,17561,17573,17600,17630,17679,17701,17711,17724,17736,17753,17766,17779,17822,17824,17834,17852,17862,17874,17919,17930,17936,17938,17950,17966,17967,17983,17991,18001,18044,18061,18123,18138,18143,18156,18185,18222,18227,18259,18260,18261,18274,18282,18295,18303,18311,18333,18356,18370,18382,18396,18445,18453,18455,18505,18528,18552,18564,18580,18584,18599,18609,18619,18653,18664,18668,18686,18693,18728,18749,18762,18793,18813,18829,18830,18853,18874,18876,18877,18888,18905,18951,18961,18973,18985,19015,19018,19027,19041,19105,19117,19124,19128,19140,19152,19173,19175,19185,19217,19220,19223,19242,19260,19287,19312,19315,19371,19381,19416,19417,19428,19436,19437,19453,19486,19503,19567,19571,19601,19602,19604,19607,19639,19643,19645,19646,19648,19671,19684,19701,19702,19710,19725,19728,19733,19764,19769,19780,19794,19807,19827,19829,19857,19882,19905,19923,19952,19962,20019,20053,20062,20119,20123,20127,20133,20149,20175,20218,20243,20259,20291,20298,20307,20323,20326,20367,20380,20397,20442,20444,20445,20488,20489,20517,20542,20587,20611,20629,20630,20638,20656,20659,20705,20772,20777,20797,20820,20826,20875,20884,20923,20940,20942,20959,20962,20982,20993,21005,21012,21065,21101,21117,21118,21142,21143,21165,21186,21245,21308,21312,21313,21344,21367,21398,21402,21420,21421,21457,21458,21470,21477,21498,21512,21519,21520,21522,21541,21544,21545,21554,21611,21616,21637,21663,21684,21698,21702,21741,21755,21758,21764,21776,21778,21798,21851,21882,21883,21897,21906,21917,21921,21968,21997,22023,22038,22064,22067,22084,22092,22098,22100,22106,22119,22165,22171,22178,22188,22198,22222,22237,22252,22271,22278,22285,22290,22298,22322,22337,22341,22363,22374,22408,22432,22439,22450,22460,22469,22476,22478,22480,22500,22555,22557,22570,22610,22614,22647,22725,22741,22759,22781,22794,22803,22804,22820,22840,22885,22902,22935,22944,22960,22985,23034,23038,23046,23061,23072,23093,23127,23135,23148,23188,23242,23251,23253,23279,23305,23318,23342,23367,23368,23405,23419,23423,23430,23438,23442,23463,23521,23527,23551,23553,23555,23574,23595,23615,23631,23697,23730,23746,23771,23777,23849,23852,23915,23955,23956,23961,23968,23985,24076,24082,24101,24164,24237,24279,24295,24304,24390,24433,24440,24443,24456,24458,24530,24532,24574,24577,24584,24586,24616,24632,24660,24664,24668,24690,24691,24707,24748,24752,24768,24779,24789,24805,24830,24841,24888,24907,24946,24963,24988,25037,25080,25081,25117,25123,25206,25241,25277,25297,25326,25329,25344,25374,25452,25491,25523,25676,25691,25755,25807,25888,25919,25971,25990,26042,26066,26161,26229,26256,26261,26274,26379,26563,26596,26689,26854,26873,26901,26959,26986,27001,27061,27062,27153,27158,27213,27261,27290,27314,27316,27438,27447,27472,27552,27578,27646,27707,27745,27851,27950,28066,28094,28213,28254,28264,28283,28336,28749,28807,28826,29061,29073,29250,29281,29332,29355,29476,29539,29719,29868,30723,31850,32840,35495,36147,36208,36223,38593,39642,39981,39998,40116,40145,40168,40271,40611,40984,41202,41364,43564)
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 | 929 | 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.67 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 2.23 ms |
preparing | 1.16 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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 |