Tiempo de la consulta: 3.57 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.322 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 08:15:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 08:15:19')
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,21,49,58,161,170,172,287,290,291,293,344,353,437,469,593,607,693,790,797,843,997,1207,1232,1247,1339,1352,1357,1486,1781,1785,1795,1913,1931,2027,2210,2424,2689,2757,2825,2964,2997,3020,3028,3030,3045,3124,3209,3212,3353,3594,3671,3738,3842,4120,4128,4131,4166,4215,4227,4399,4493,4612,4613,4614,4615,4617,5092,5268,5471,5559,5647,5943,6039,6131,6192,6234,6268,6324,6484,6571,6586,6616,6688,6788,6977,6998,7081,7331,7361,7482,7483,7565,7624,7677,7690,7735,7745,7799,7847,7884,7894,7965,8027,8436,8437,8706,9051,9091,9142,9308,9318,9481,9757,9939,10039,10100,10149,10260,10283,10382,10400,10420,10422,10458,10510,10604,10623,10634,10721,10782,10811,10838,10861,10957,11098,11113,11323,11476,11703,11721,11722,11803,11859,12164,12270,12311,12440,12488,12541,12581,12582,12592,12650,12686,12851,12978,13154,13188,13227,13276,13307,13325,13332,13349,13352,13387,13420,13474,13515,13575,13782,13783,13941,13947,13972,14008,14021,14079,14169,14263,14357,14372,14453,14630,14640,14663,14679,14682,14713,14749,14754,14816,14832,14845,14852,14856,14906,14911,14983,14996,15007,15045,15046,15129,15156,15214,15217,15234,15304,15335,15351,15366,15376,15406,15424,15475,15520,15522,15539,15581,15594,15600,15689,15700,15742,15753,15785,15790,15796,15812,15851,15862,15880,15917,16057,16095,16120,16122,16127,16249,16346,16354,16357,16384,16422,16427,16430,16455,16521,16551,16562,16578,16675,16678,16737,16781,16816,16841,17014,17034,17049,17116,17121,17167,17168,17188,17240,17246,17288,17304,17331,17335,17347,17353,17385,17387,17412,17433,17444,17497,17561,17573,17590,17609,17630,17711,17736,17779,17834,17862,17888,17919,17930,17936,17950,17967,17983,18044,18061,18075,18222,18260,18295,18317,18320,18334,18382,18473,18552,18590,18658,18664,18693,18728,18739,18782,18830,18877,18888,18892,18905,18906,18907,18926,18929,19015,19105,19124,19128,19140,19153,19173,19204,19211,19236,19245,19287,19315,19363,19381,19387,19486,19607,19639,19684,19710,19725,19733,19794,19807,19875,19904,19916,19923,19937,19945,19967,20053,20063,20119,20175,20180,20275,20296,20301,20376,20385,20398,20445,20542,20638,20642,20659,20690,20750,20768,20772,20777,20940,20959,21117,21118,21143,21329,21344,21367,21398,21413,21421,21457,21470,21487,21520,21522,21523,21524,21566,21612,21663,21672,21684,21702,21719,21726,21741,21764,21776,21778,21787,21883,21891,21906,21917,21932,21968,21992,21997,22038,22067,22106,22119,22129,22131,22178,22227,22253,22278,22298,22341,22450,22453,22460,22476,22483,22494,22555,22570,22620,22659,22717,22739,22759,22781,22820,22840,22902,22944,22960,22964,23034,23083,23093,23104,23123,23184,23201,23229,23242,23272,23273,23279,23328,23364,23365,23367,23368,23405,23430,23438,23439,23523,23553,23555,23720,23849,23955,23968,24076,24145,24164,24237,24337,24460,24530,24584,24650,24690,24714,24766,24779,24805,24841,24946,24951,24963,25032,25037,25062,25081,25117,25165,25297,25329,25452,25505,25518,25523,25548,25554,25589,25639,25646,25648,25671,25676,25723,25727,25734,25747,25751,25757,25758,25771,25807,25817,25830,25836,25916,25919,25924,25927,25941,25942,25949,25961,25971,25990,25992,25994,25995,26000,26010,26013,26025,26028,26033,26035,26060,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26229,26234,26259,26261,26296,26337,26359,26372,26386,26596,26720,26780,26835,26842,26843,26854,26864,26873,26916,26927,26933,26944,26947,26959,26968,27001,27061,27062,27076,27100,27158,27211,27212,27240,27270,27290,27323,27327,27405,27421,27487,27499,27526,27552,27578,27583,27595,27646,27688,27707,27717,27745,27786,27851,27922,27924,27950,28019,28059,28066,28075,28094,28095,28097,28107,28114,28120,28192,28213,28230,28243,28279,28283,28749,28826,28846,28931,28943,29061,29073,29272,29495,29528,29539,29611,29616,29653,29655,29719,29724,29832,30111,30470,30804,31735,31820,31837,31853,32720,32767,32768,32840,33871,33874,33908,34784,34794,35444,35554,35556,35637,35728,35814,35835,35846,35956,36141,36208,36441,36584,36797,37544,37547,37627,37644,37677,37902,38086,38092,38330,38575,38617,38723,38799,38821,38824,38829,38877,38912,38965,38990,39155,39184,39205,39210,39290,39293,39345,39366,39376,39442,39448,39451,39559,39686,39724,39981,39998,40168,40611,40624,40885,40888,41109,41121,41149,41171,41172,41289,41483,41577,41612,42042,42110,42423,42479,42809,43003,43276,43401,43483,43654,44109,44122,44421,44735,44871,44912,45046,45057,45068,45201)
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 | 757 | 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.42 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.09 ms |
statistics | 1.35 ms |
preparing | 0.57 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |