Tiempo de la consulta: 3.82 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.173 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 22:04:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 22:04:45')
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(11,60,61,62,63,64,65,67,68,158,160,201,214,216,220,269,272,278,281,304,331,344,350,367,377,380,385,417,450,462,491,556,586,686,697,717,754,843,844,857,908,976,978,994,1006,1007,1024,1054,1099,1168,1187,1208,1231,1305,1319,1333,1334,1351,1391,1402,1406,1429,1506,1565,1598,1630,1698,1776,1824,1829,1851,1897,2005,2013,2109,2112,2145,2183,2229,2320,2333,2354,2373,2384,2389,2394,2628,2643,2870,2898,2939,2962,3033,3074,3283,3340,3377,3457,3478,3512,3564,3567,3590,3615,3641,3696,3917,3934,3962,3982,4025,4172,4192,4257,4292,4354,4467,4468,4490,4523,4563,4587,4622,4674,4690,4718,4741,4785,4821,4834,4871,4876,5051,5072,5154,5164,5180,5233,5247,5299,5333,5495,5561,5644,5690,5697,5730,5814,5827,5837,5888,6176,6363,6392,6470,6501,6570,6675,6690,6748,6771,6950,7104,7125,7168,7296,7299,7358,7407,7428,7432,7555,7566,7589,7594,7801,7838,7839,7860,7931,7946,7965,7981,7985,7993,7995,7998,8090,8328,8353,8355,8391,8440,8531,8555,8773,8776,8940,9109,9115,9148,9201,9223,9425,9480,9493,9497,9532,9556,9716,9728,9747,9895,9944,9945,10243,10280,10299,10340,10383,10561,10673,10834,10991,11129,11299,11377,11398,11465,11482,11552,11565,11625,11626,11688,11694,11699,11711,11822,12042,12150,12238,12324,12337,12341,12424,12500,12621,12668,12684,12780,12878,12897,12902,12944,13002,13004,13152,13153,13348,13436,13454,13475,13476,13585,13608,13629,13646,13657,13748,13750,13783,13811,13816,13858,13859,13922,13924,13934,13969,14047,14103,14126,14153,14320,14398,14424,14434,14570,14596,14800,14864,14879,14895,14958,14975,15038,15063,15087,15114,15145,15183,15208,15244,15306,15359,15368,15493,15522,15577,15608,15632,15645,15669,15755,15843,15903,15957,15969,15975,16083,16088,16201,16322,16334,16340,16349,16365,16439,16446,16464,16488,16503,16507,16508,16520,16549,16556,16629,16641,16646,16684,16791,16817,16830,16831,16840,16861,16905,17090,17210,17253,17333,17362,17372,17440,17443,17446,17458,17471,17485,17487,17521,17630,17655,17662,17713,17737,17751,17761,17783,17823,17839,17863,17881,17933,17947,17992,17994,18066,18077,18088,18096,18125,18162,18193,18202,18203,18229,18231,18260,18285,18300,18311,18364,18382,18422,18467,18483,18490,18520,18547,18567,18587,18602,18644,18671,18720,18762,18770,18807,18816,18828,18881,19002,19047,19060,19067,19096,19145,19148,19170,19180,19184,19185,19253,19276,19327,19352,19367,19376,19400,19457,19460,19463,19529,19532,19554,19556,19577,19620,19633,19668,19687,19703,19720,19732,19811,19870,19908,19909,19998,20010,20027,20028,20032,20056,20057,20076,20086,20095,20134,20135,20141,20156,20160,20170,20177,20187,20188,20234,20256,20263,20271,20289,20353,20424,20449,20450,20483,20516,20535,20564,20630,20662,20714,20729,20767,20800,20866,20886,20940,20982,20997,21036,21050,21064,21068,21132,21173,21189,21198,21225,21247,21295,21314,21349,21402,21414,21422,21432,21459,21513,21545,21593,21610,21611,21620,21636,21640,21678,21694,21738,21764,21768,21854,21909,21950,21980,22100,22132,22137,22146,22229,22244,22245,22246,22297,22337,22361,22377,22525,22559,22647,22673,22712,22749,22774,22792,22868,22903,22908,22962,22980,22988,23072,23106,23127,23155,23186,23196,23250,23275,23281,23295,23374,23397,23401,23402,23434,23457,23471,23495,23555,23585,23610,23636,23686,23732,23764,23840,23845,23858,23888,23973,24028,24059,24100,24164,24194,24342,24447,24451,24489,24518,24540,24556,24586,24591,24594,24639,24653,24707,24725,24791,24804,24884,24897,24912,24952,24998,25045,25184,25264,25304,25315,25473,25576,25609,25627,25640,25702,25730,25769,25775,25834,25835,25872,25906,25995,26315,26328,26374,26473,26516,26601,26629,26638,26640,26646,26708,26760,26807,26918,26935,26936,26945,26967,27009,27086,27100,27101,27141,27143,27259,27384,27458,27491,27518,27524,27526,27559,27560,27571,27584,27673,27688,28129,28330,28336,28454,28495,28680,28870,28882,29061,29134,29412,29454,29470,29802,30740,31129,31604,32905,35234,35603,35811,36698,36750,37206,39392,41376,42502,42503,44100,44101)
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 | 697 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.18 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.01 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 |