Tiempo de la consulta: 3.53 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.390 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 18:18:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 18:18: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(107,119,192,266,478,579,599,841,931,971,979,981,1001,1051,1111,1180,1280,1295,1342,1343,1352,1408,1447,1473,1551,1649,1806,1852,1944,2046,2098,2155,2284,2285,2301,2424,2427,2543,2556,2623,2640,2665,2694,2695,2804,2809,2941,2958,2963,2967,3001,3025,3114,3205,3321,3343,3353,3373,3410,3426,3454,3475,3481,3487,3510,3521,3663,3819,3831,3960,3984,4066,4132,4274,4300,4477,4492,4665,4699,4761,4810,4919,5229,5230,5252,5391,5480,5642,5693,5697,5714,5806,5846,5976,5985,6046,6146,6301,6311,6358,6369,6375,6414,6431,6511,6539,6580,6780,6925,6982,7162,7163,7164,7165,7166,7167,7169,7192,7287,7294,7399,7453,7650,7709,7713,7716,7731,7822,7828,7917,8019,8028,8047,8149,8206,8259,8272,8290,8319,8366,8373,8444,8458,8466,8483,8517,8607,8610,8659,8741,8778,8802,8808,8818,8842,8929,9051,9067,9069,9080,9127,9132,9171,9177,9195,9313,9329,9364,9382,9424,9469,9562,9582,9605,9621,9629,9756,9794,9806,9827,9950,9980,10039,10183,10241,10277,10383,10511,10558,10580,10650,10669,10688,10689,10697,10716,10763,10834,10838,10839,10923,11104,11141,11195,11208,11214,11353,11390,11442,11483,11497,11530,11548,11632,11666,11677,11695,11823,11933,12032,12418,12494,12499,12534,12598,12669,12785,12790,12973,13008,13063,13064,13148,13199,13240,13480,13535,13546,13557,13562,13576,13641,13719,14008,14106,14161,14270,14313,14332,14360,14376,14476,14496,14534,14595,14604,14610,14748,14761,14772,14815,14853,14932,14958,15028,15038,15041,15063,15124,15128,15160,15220,15224,15293,15367,15369,15509,15533,15568,15625,15632,15672,15738,15743,15751,15882,15897,15904,15909,15945,15981,16002,16084,16090,16193,16215,16338,16439,16618,16652,16795,16908,17053,17100,17224,17260,17394,17451,17496,17517,17555,17570,17651,17695,17775,17778,17802,17852,17873,18071,18183,18242,18309,18328,18368,18519,18589,18703,18717,18789,18884,18940,19056,19182,19196,19217,19227,19298,19335,19341,19448,19502,19653,19661,19695,19865,19867,19870,19885,19935,19953,19958,19980,20118,20144,20157,20334,20503,20525,20553,20567,20598,20634,20700,20725,20738,20785,20825,20833,20837,20875,20883,20958,21016,21051,21052,21094,21114,21130,21131,21285,21368,21441,21509,21555,21559,21599,21650,21727,21796,21825,21834,21875,21908,21962,22062,22117,22195,22241,22351,22357,22378,22384,22385,22406,22421,22446,22488,22494,22510,22513,22591,22597,22611,22626,22774,22780,22784,22808,22829,22897,22938,22987,23031,23035,23096,23105,23115,23117,23179,23221,23254,23277,23304,23345,23388,23453,23454,23593,23638,23654,23684,23724,23751,23817,23823,23998,24312,24393,24450,24455,24570,24582,24701,24769,24770,24795,24803,24819,24824,24910,25035,25131,25171,25172,25214,25244,25283,25325,25334,25351,25410,25436,25493,25506,25518,25665,25721,25874,25995,26010,26021,26033,26139,26333,26360,26410,26424,26454,26464,26471,26474,26894,26907,26947,26956,27052,27091,27137,27280,27314,27322,27360,27408,28469,28744,28965,28977,28991,29153,29187,29304,29306,29630,29710,30280,32642,32643,32644,33065,33750,33954,33955,34016,34047,34180,34189,34251,34377,34391,34483,34502,34832,34935,34959,35010,35094,35175,35185,35205,35310,35314,35392,35557,35581,35658,35718,35773,35847,35876,35902,35930,35982,36031,36066,36227,36437,36507,36508,36531,36688,36714,36828,36888,36957,37024,37116,37137,37344,37357,37365,37395,37521,37543,37544,37579,37642,37669,37693,37710,37731,37740,37767,37787,37802,37844,37852,37876,37932,37953,37999,38060,38185,38329,38346,38361,38370,38409,38430,38447,38506,38512,38520,38567,38588,38605,38623,38654,38734,38764,38779,38781,38809,38837,38851,38861,38888,38918,38956,39019,39023,39070,39160,39185,39212,39346,39415,39416,39439,39491,39582,39649,39670,39736,39757,39767,39838,39849,39932,39934,39993,40003,40072,40073,40094,40195,40302,40306,40345,40379,40431,40494,40505,40508,40638,40699,40714,40774,40897,40904,40970,40996,41023,41046,41051,41075,41078,41096,41142,41181,41190,41227,41245,41251,41254,41259,41273,41284,41297,41303,41313,41370,41373,41391,41440,41517,41660,41722,41726,41738,41739,41768,41811,41822,41851,41875,41950,41959,41972,41973,41981,41983,41997,42002,42010,42029,42113,42124,42136,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,43058,43083,43116,43143,43181,43199,43268,43312,43342,43347,43348,43434,43443,43455,43468,43471,43507,43512,43527,43612,43617,43628,43629,43647,43684,43703,43704,43730,43742,43758,43800,43836,43877,43883,43927,44003,44045,44049,44050,44070,44073,44098,44239,44259,44338,44353,44356,44379,44389,44392,44437,44455,44521,44558,44570,44586,44603,44625,44658,44683,44691,44708,44748,44842,44874,44907,44964,44989,45008,45055,45060,45147,45195,45251,45289,45301,45311)
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 | 805 | 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.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.26 ms |
preparing | 0.60 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |