Tiempo de la consulta: 3.90 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.492 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-03 19:28:09')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 19:28:09')
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,170,172,287,290,291,293,344,353,437,473,606,607,608,693,797,832,843,886,969,997,1034,1207,1231,1232,1247,1281,1326,1339,1486,1675,1701,1741,1775,1829,1931,2013,2026,2424,2588,2665,2710,2757,2789,2884,2997,3009,3020,3028,3045,3114,3124,3188,3209,3212,3267,3281,3305,3372,3373,3376,3426,3565,3593,3671,3738,3842,3870,4047,4108,4113,4120,4128,4207,4217,4399,4411,4423,4461,4469,4700,4774,4888,4977,5092,5096,5120,5244,5298,5302,5356,5471,5487,5512,5559,5647,5674,5687,5698,5705,5731,5805,5878,5879,5895,5967,5975,6039,6131,6155,6234,6319,6348,6399,6476,6477,6484,6606,6616,6675,6688,6714,6727,6751,6956,6998,7003,7272,7361,7411,7483,7489,7530,7533,7677,7777,7847,7894,7965,8027,8217,8386,8393,8454,8529,8587,8707,8988,9057,9148,9221,9223,9266,9318,9470,9689,9752,9853,10100,10149,10382,10402,10407,10519,10562,10570,10623,10673,10721,10782,10793,10817,10842,10957,10964,11016,11113,11207,11226,11320,11327,11408,11465,11549,11684,11751,11788,11814,11873,12154,12270,12321,12324,12581,12582,12839,12851,12978,12981,13152,13231,13247,13260,13264,13307,13332,13348,13420,13429,13475,13515,13851,13860,13962,13972,14126,14129,14228,14372,14403,14427,14432,14453,14569,14609,14618,14630,14812,14845,14852,14856,14865,14983,14988,15007,15009,15017,15051,15090,15122,15129,15156,15171,15214,15321,15335,15351,15376,15382,15406,15414,15424,15475,15479,15520,15522,15524,15581,15600,15613,15683,15689,15700,15710,15742,15785,15790,15812,15819,15861,15868,15871,15880,15967,15969,16095,16127,16206,16245,16249,16267,16284,16347,16357,16384,16427,16521,16551,16569,16675,16742,16743,16781,16784,16816,16841,16880,16887,17028,17049,17055,17116,17136,17188,17240,17245,17246,17288,17313,17327,17331,17387,17404,17444,17497,17500,17561,17573,17630,17662,17711,17736,17759,17779,17834,17862,17919,17930,17936,17950,17967,17983,18003,18035,18044,18061,18092,18222,18260,18295,18304,18306,18352,18382,18483,18552,18648,18664,18683,18693,18728,18830,18877,18888,18905,18960,18967,19015,19105,19124,19128,19140,19151,19173,19287,19292,19315,19381,19392,19401,19445,19486,19520,19544,19547,19570,19607,19637,19639,19684,19694,19710,19725,19733,19765,19770,19789,19794,19798,19807,19809,19844,19853,19916,19923,20059,20087,20113,20119,20175,20178,20288,20418,20445,20451,20470,20542,20638,20659,20662,20663,20772,20777,20816,20839,20864,20922,20934,20940,20951,20959,21019,21020,21036,21072,21095,21101,21117,21118,21143,21146,21214,21229,21268,21344,21345,21360,21361,21367,21398,21421,21443,21457,21470,21490,21520,21522,21552,21553,21651,21663,21675,21680,21684,21702,21703,21741,21744,21764,21769,21775,21776,21778,21779,21784,21817,21820,21828,21832,21835,21837,21883,21890,21906,21911,21917,21934,21942,21968,21997,22038,22067,22106,22119,22147,22178,22211,22249,22278,22298,22460,22476,22482,22555,22570,22671,22759,22820,22840,22854,22944,22960,23030,23034,23066,23093,23125,23161,23165,23170,23183,23213,23215,23242,23273,23279,23309,23367,23368,23405,23429,23430,23438,23509,23553,23555,23718,23849,23864,23894,23955,23968,24053,24076,24153,24163,24164,24179,24205,24225,24237,24338,24353,24360,24530,24584,24623,24690,24700,24744,24779,24805,24841,24946,24963,25037,25081,25117,25134,25297,25304,25329,25376,25452,25523,25625,25676,25772,25776,25807,25881,25912,25919,25971,26043,26078,26081,26083,26108,26125,26148,26198,26229,26261,26263,26320,26328,26361,26378,26405,26410,26471,26492,26578,26596,26613,26679,26724,26741,26803,26808,26843,26854,26866,26873,26874,26894,26899,26949,26957,26959,26985,26992,27001,27061,27062,27087,27118,27120,27138,27152,27158,27197,27207,27216,27239,27287,27290,27291,27319,27322,27325,27406,27465,27482,27502,27550,27552,27578,27646,27707,27724,27745,27750,27778,27833,27851,27882,27950,27973,28004,28066,28094,28160,28200,28213,28228,28264,28281,28283,28327,28436,28437,28521,28540,28553,28555,28634,28635,28636,28666,28668,28669,28749,28750,28764,28784,28826,28828,28838,28878,28884,28899,28930,29000,29006,29013,29061,29073,29100,29189,29374,29378,29539,29719,29840,29848,29884,30199,30540,30556,30804,31377,31827,32369,32755,32840,34089,34862,34982,35103,35269,35298,35616,35657,35685,36275,36294,36442,36489,37184,37543,37544,37647,37987,38105,38291,38437,38438,38599,38663,38741,38930,38988,39001,39149,39226,39302,39310,39333,39335,39356,39414,39480,39491,39636,39695,39696,39765,39774,39775,39782,39807,39891,39896,39897,39905,39918,39981,39998,40136,40168,40287,40290,40339,40344,40359,40482,40611,40700,40757,40925,41221,41224,41304,41585,41668,41856,41880,41955,42034,42051,42104,42106,42309,42537,42581,42603,42859,43025,43099,43105,43163,43218,43256,43259,43351,43520,43545,43603,43697,44067,44197,44226,44650,44752,44820,44833,44893,45139,45217,45236,45295)
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 | 815 | 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.43 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.26 ms |
preparing | 0.65 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.29 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |