Tiempo de la consulta: 4.40 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.316 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-04 21:58:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 21:58:32')
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(61,98,113,138,160,176,178,179,267,280,318,385,406,432,452,462,489,494,497,614,681,697,733,737,771,802,864,872,889,894,909,910,928,943,1062,1084,1087,1126,1132,1174,1190,1210,1297,1331,1355,1465,1515,1555,1563,1573,1654,1712,1743,1753,1785,1824,1907,1910,1928,1932,1971,1973,2020,2090,2092,2124,2128,2183,2331,2389,2592,2610,2617,2706,2740,2790,2927,3005,3027,3060,3082,3085,3224,3240,3244,3265,3317,3330,3346,3393,3424,3433,3444,3573,3792,3832,3855,3870,3905,3943,3969,4008,4029,4035,4076,4084,4132,4163,4165,4173,4182,4212,4224,4234,4235,4273,4313,4331,4332,4361,4362,4364,4378,4388,4391,4397,4405,4433,4434,4444,4511,4560,4572,4582,4644,4658,4668,4732,4752,4835,4855,4880,4911,4933,5000,5037,5065,5074,5101,5195,5263,5269,5288,5334,5363,5367,5390,5423,5439,5593,5648,5700,5803,5810,5820,5834,5859,5872,5924,5976,6009,6012,6112,6151,6160,6199,6233,6307,6344,6429,6451,6537,6540,6626,6758,6771,6780,6848,6872,6941,7037,7095,7227,7242,7248,7260,7278,7297,7325,7423,7424,7430,7433,7477,7492,7520,7556,7580,7581,7680,7750,7751,7771,7782,7797,7829,7936,8034,8077,8101,8105,8146,8167,8186,8224,8261,8293,8303,8306,8328,8362,8413,8417,8440,8443,8447,8512,8513,8569,8573,8661,8681,8689,8742,8779,8830,8899,8963,8999,9004,9011,9030,9038,9046,9051,9085,9107,9111,9184,9199,9211,9224,9244,9262,9263,9270,9323,9398,9426,9443,9444,9500,9516,9518,9524,9595,9637,9652,9689,9715,9734,9755,9775,9851,9858,9892,9896,9899,9964,9965,9970,10068,10140,10294,10402,10420,10467,10481,10677,10715,10745,10751,10878,10886,11038,11040,11041,11137,11159,11179,11182,11240,11279,11374,11398,11552,11669,11681,11701,11853,11859,11880,11961,12053,12054,12158,12318,12357,12439,12458,12482,12574,12640,12668,12714,12747,12895,12902,12949,12974,12997,13039,13083,13265,13290,13358,13402,13436,13454,13579,13646,13670,13688,13814,13822,13875,13895,13907,13926,13968,13969,13970,14047,14134,14159,14190,14278,14304,14337,14366,14368,14435,14448,14484,14581,14586,14598,14690,14699,14700,14719,14723,14747,14800,14834,14864,14927,14928,14941,14953,14997,15001,15047,15091,15126,15218,15261,15311,15537,15552,15561,15615,15627,15705,15732,15741,15762,15781,15859,15870,15927,15965,15985,16106,16162,16237,16246,16260,16309,16311,16313,16318,16328,16349,16365,16401,16488,16502,16505,16508,16526,16535,16545,16549,16607,16641,16667,16697,16712,16828,16879,16910,16911,16916,16924,16940,16944,16947,16950,16968,16969,17008,17054,17065,17085,17127,17137,17203,17206,17268,17346,17371,17387,17416,17419,17442,17458,17463,17485,17535,17646,17654,17661,17667,17683,17692,17698,17719,17750,17751,17781,17799,17820,17824,17900,17948,18033,18040,18073,18076,18103,18135,18138,18168,18193,18202,18231,18235,18271,18277,18292,18306,18312,18357,18382,18410,18420,18422,18509,18534,18535,18542,18564,18578,18579,18591,18599,18602,18611,18624,18644,18670,18686,18719,18734,18747,18771,18778,18803,18829,18835,18844,18851,18853,18923,18931,18934,18950,18954,18973,18974,18980,19029,19050,19076,19096,19113,19156,19172,19184,19197,19216,19242,19288,19365,19413,19430,19476,19481,19493,19562,19573,19591,19618,19641,19678,19703,19715,19716,19742,19745,19777,19778,19829,19835,19900,19920,19924,19950,19992,20027,20080,20129,20139,20160,20208,20209,20230,20235,20251,20267,20282,20295,20307,20325,20341,20351,20387,20409,20520,20570,20575,20598,20601,20641,20650,20689,20715,20733,20740,20767,20800,20807,20808,20877,20887,20897,20940,21031,21032,21042,21054,21059,21064,21066,21068,21070,21114,21146,21173,21191,21204,21205,21260,21261,21291,21308,21310,21311,21342,21356,21361,21376,21383,21408,21411,21450,21459,21502,21530,21535,21541,21559,21560,21594,21643,21647,21691,21703,21729,21759,21810,21818,21841,21842,21844,21848,21929,21964,21975,21979,21985,21986,22037,22046,22120,22131,22156,22158,22161,22201,22213,22244,22245,22246,22401,22408,22438,22549,22551,22578,22591,22606,22609,22634,22635,22741,22746,22758,22792,22816,22846,22860,22916,22948,22962,23051,23067,23084,23085,23164,23217,23257,23277,23300,23319,23379,23404,23434,23460,23561,23576,23590,23645,23687,23695,23731,23803,23842,23866,23885,23894,23903,23906,23944,23979,24011,24087,24134,24151,24155,24200,24234,24330,24387,24421,24447,24474,24502,24510,24518,24549,24575,24592,24597,24644,24699,24708,24719,24721,24725,24738,24784,24947,24990,25023,25061,25179,25260,25315,25347,25482,25609,25611,25626,25670,25695,25767,25834,25845,25865,25906,25929,25964,25979,25983,26001,26017,26019,26024,26034,26056,26080,26093,26128,26288,26328,26334,26379,26393,26448,26449,26473,26489,26530,26548,26637,26646,26734,26841,26918,26945,26967,26990,27049,27206,27312,27313,27362,27365,27399,27458,27518,27694,27757,27761,27944,27971,28139,28441,28453,28686,28687,28733,28886,28898,28999,29061,29164,29589,29765,30222,31975,34096,34160,34220,35127,35234,35428,35474,35560,35716,35776,35791,35811,35831,35862,35985,36004,36109,36151,36517,38763,38917,39570,39726,39984,39997,40112,40343,40356,40367,40502,40533,41052,41156,41559,41790,42286,42343,42483,42502,44537)
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 | 883 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.35 ms |
preparing | 0.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 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 |