Tiempo de la consulta: 4.17 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.186 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-07 04:24:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 04:24:52')
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,45,46,49,54,58,62,65,71,170,172,226,287,290,291,293,307,344,353,391,415,437,607,643,659,693,764,797,843,977,997,1101,1104,1207,1232,1247,1335,1339,1411,1439,1486,1563,1571,1648,1820,1880,1881,1931,1956,2061,2084,2233,2287,2309,2421,2472,2587,2700,2720,2743,2757,2842,2909,2956,2997,3020,3028,3045,3124,3146,3196,3209,3212,3266,3671,3685,3738,3760,3767,3776,3833,3842,3913,3960,4034,4051,4101,4110,4120,4128,4129,4148,4150,4204,4284,4301,4323,4327,4399,4423,4456,4548,4575,4859,4940,5032,5259,5387,5422,5471,5559,5647,5854,5909,6039,6056,6100,6128,6131,6234,6360,6362,6440,6484,6616,6649,6688,6720,6865,6881,6998,7077,7111,7216,7250,7258,7331,7361,7364,7444,7483,7586,7605,7614,7618,7651,7677,7724,7752,7771,7784,7785,7787,7847,7894,7903,7925,7935,7942,7965,8004,8027,8055,8100,8152,8160,8227,8234,8265,8370,8378,8421,8507,8550,8611,8644,8660,8700,8704,8750,8753,8799,8813,8826,8831,8864,8925,8954,9063,9078,9120,9318,9328,9350,9371,9390,9477,9578,9600,9610,9738,9829,9838,9863,9878,9904,9908,9922,9956,10004,10100,10149,10190,10247,10265,10269,10313,10322,10382,10414,10448,10513,10617,10623,10642,10721,10754,10756,10782,10796,10957,10993,11023,11031,11041,11073,11121,11250,11286,11338,11387,11488,11545,11687,11796,11883,11921,12249,12270,12553,12581,12582,12632,12638,12689,12690,12851,12978,13146,13166,13209,13307,13332,13376,13385,13420,13515,13702,13731,13738,13760,13789,13946,13961,13972,13996,14141,14266,14351,14372,14396,14453,14488,14512,14513,14515,14532,14601,14616,14630,14662,14730,14739,14820,14824,14825,14845,14852,14856,14939,14983,14999,15006,15007,15041,15069,15081,15129,15148,15156,15160,15178,15193,15214,15230,15268,15326,15335,15347,15351,15371,15376,15388,15406,15423,15424,15443,15457,15465,15475,15482,15487,15520,15522,15551,15570,15581,15582,15600,15611,15617,15636,15637,15640,15689,15700,15738,15742,15767,15783,15785,15790,15812,15866,15880,15913,16022,16036,16039,16042,16059,16082,16084,16095,16097,16127,16129,16156,16181,16248,16249,16256,16261,16292,16314,16315,16357,16366,16384,16403,16427,16521,16551,16552,16577,16675,16728,16759,16778,16781,16816,16828,16841,16890,16991,17049,17053,17074,17102,17115,17116,17145,17160,17188,17216,17233,17240,17246,17288,17331,17387,17444,17464,17468,17497,17550,17561,17573,17630,17633,17650,17711,17736,17779,17834,17844,17855,17859,17862,17893,17913,17919,17926,17930,17936,17950,17966,17967,17983,18044,18045,18054,18061,18062,18081,18122,18157,18180,18183,18222,18233,18255,18260,18274,18292,18295,18314,18344,18358,18362,18382,18457,18460,18539,18544,18552,18564,18608,18664,18693,18709,18728,18730,18800,18830,18846,18862,18871,18877,18878,18888,18905,18916,18922,18931,18934,18954,18975,18980,18993,19015,19028,19034,19042,19080,19105,19124,19128,19135,19140,19155,19173,19198,19218,19240,19247,19287,19313,19315,19332,19333,19366,19381,19486,19530,19550,19561,19571,19604,19607,19637,19639,19652,19684,19710,19713,19725,19732,19733,19767,19794,19807,19838,19852,19872,19923,19945,19983,20018,20030,20119,20127,20144,20175,20250,20260,20261,20264,20304,20312,20327,20344,20346,20348,20376,20393,20429,20444,20445,20461,20464,20518,20542,20573,20593,20602,20638,20649,20659,20678,20699,20717,20721,20741,20772,20777,20779,20797,20812,20813,20828,20841,20850,20906,20915,20940,20959,21000,21057,21062,21089,21107,21108,21117,21118,21143,21161,21190,21212,21226,21240,21249,21317,21325,21344,21367,21369,21381,21397,21398,21401,21421,21434,21435,21457,21458,21464,21470,21489,21520,21522,21545,21552,21554,21578,21590,21609,21641,21663,21672,21684,21702,21710,21740,21741,21744,21764,21776,21777,21778,21855,21858,21894,21906,21917,21944,21968,21976,21982,21997,22010,22038,22040,22063,22067,22106,22119,22141,22160,22176,22178,22214,22228,22237,22269,22278,22298,22313,22348,22407,22450,22459,22460,22461,22476,22481,22509,22555,22570,22617,22647,22673,22722,22733,22739,22759,22763,22793,22819,22820,22837,22840,22889,22890,22904,22908,22944,22957,22960,23034,23065,23067,23093,23131,23133,23185,23195,23201,23237,23241,23242,23260,23279,23280,23313,23320,23325,23326,23328,23335,23339,23367,23368,23405,23425,23430,23438,23553,23555,23578,23582,23678,23679,23789,23849,23872,23890,23942,23955,23960,23968,24075,24076,24102,24104,24152,24164,24180,24191,24237,24273,24274,24327,24366,24371,24392,24422,24503,24530,24584,24592,24644,24690,24693,24727,24733,24778,24779,24805,24816,24837,24841,24844,24899,24946,24963,24964,25037,25072,25081,25098,25107,25117,25125,25128,25133,25224,25225,25253,25297,25329,25377,25380,25442,25445,25452,25523,25639,25644,25645,25676,25714,25730,25785,25807,25850,25876,25919,25971,25993,26178,26183,26229,26254,26256,26261,26273,26493,26501,26504,26521,26563,26596,26648,26717,26848,26854,26873,26901,26926,26959,26972,26977,27001,27002,27011,27021,27057,27061,27062,27122,27150,27158,27170,27210,27239,27246,27273,27290,27321,27366,27376,27404,27418,27431,27435,27496,27521,27545,27552,27556,27578,27593,27644,27646,27677,27686,27704,27707,27721,27745,27823,27842,27851,27917,27931,27936,27950,28005,28033,28045,28066,28082,28094,28213,28225,28264,28283,28312,28411,28639,28653,28658,28749,28826,28839,28921,28989,29008,29009,29034,29061,29065,29073,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29539,29682,29719,29781,29865,29895,29898,29905,29922,29923,29935,32768,32840,32842,35084,35251,35617,35689,35883,35885,38807,38831,38854,38866,38982,39481,39603,39681,39857,39981,39998,40025,40038,40083,40097,40168,40170,40200,40611,40708,40759,40785,40809,40907,40937,40984,41059,41255,41301,41325,41375)
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 | 965 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.49 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |