Tiempo de la consulta: 9.12 ms Después de la última consulta: 0.93 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.220 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 23:40:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 23:40:28')
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,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,45,46,54,62,65,71,78,126,167,204,253,390,415,435,443,506,547,550,613,643,659,667,693,706,719,760,764,777,801,1059,1140,1295,1335,1458,1463,1490,1563,1567,1571,1665,1685,1755,1757,1898,1905,1929,1990,2022,2084,2144,2150,2182,2204,2209,2219,2235,2241,2242,2261,2278,2319,2353,2396,2627,2631,2666,2750,2770,2902,2909,2946,2967,3065,3166,3177,3196,3266,3346,3347,3414,3685,3743,3760,3767,3776,3790,3833,3862,3913,3960,3970,4034,4084,4090,4101,4110,4129,4148,4150,4152,4204,4230,4282,4284,4323,4327,4390,4423,4456,4548,4575,4631,4680,4701,4715,4748,4793,4842,4859,4891,4940,5033,5071,5083,5152,5219,5237,5238,5259,5269,5275,5329,5350,5387,5422,5471,5615,5691,5726,5727,5819,5909,5933,5998,6004,6020,6024,6028,6069,6095,6100,6101,6128,6185,6360,6362,6414,6440,6534,6565,6581,6649,6670,6694,6720,6797,6817,6865,6881,6888,6975,6982,6989,7077,7079,7088,7111,7124,7138,7181,7205,7216,7233,7250,7258,7265,7269,7275,7288,7293,7300,7331,7353,7364,7395,7397,7398,7444,7492,7586,7605,7610,7614,7618,7651,7724,7737,7752,7771,7784,7787,7903,7925,7935,7942,7965,7971,8004,8043,8055,8061,8152,8160,8227,8234,8247,8265,8280,8308,8311,8330,8335,8345,8346,8370,8375,8378,8396,8408,8421,8429,8452,8492,8506,8507,8546,8550,8568,8571,8611,8632,8644,8653,8656,8660,8690,8700,8740,8750,8753,8755,8761,8771,8785,8799,8813,8826,8828,8864,8866,8911,8923,8925,8954,8983,8987,9039,9042,9063,9120,9127,9130,9157,9297,9328,9334,9347,9350,9382,9390,9407,9428,9450,9477,9578,9585,9600,9604,9610,9639,9693,9694,9738,9829,9834,9838,9840,9878,9883,9904,9908,9922,9956,9973,9990,10004,10087,10108,10135,10190,10255,10265,10269,10278,10313,10342,10359,10414,10448,10460,10502,10513,10522,10617,10636,10642,10754,10756,10963,10993,11023,11041,11073,11100,11115,11121,11193,11206,11239,11250,11253,11264,11286,11338,11387,11488,11545,11581,11673,11687,11796,11875,11885,11921,12027,12057,12060,12089,12101,12104,12155,12166,12184,12186,12232,12249,12289,12434,12507,12509,12553,12632,12638,12689,12690,12997,13077,13089,13146,13158,13166,13209,13352,13356,13376,13385,13419,13458,13485,13537,13646,13702,13731,13738,13759,13760,13769,13772,13789,13830,13913,13946,13961,13996,14005,14038,14141,14157,14351,14391,14396,14413,14445,14447,14512,14513,14515,14529,14532,14534,14538,14550,14569,14600,14601,14616,14662,14683,14707,14730,14739,14767,14820,14824,14825,14863,14899,14939,14999,15006,15040,15041,15069,15071,15081,15148,15152,15153,15160,15178,15193,15253,15268,15269,15323,15326,15347,15388,15423,15439,15457,15465,15482,15487,15496,15548,15551,15570,15599,15611,15617,15628,15636,15637,15640,15721,15738,15763,15767,15771,15772,15777,15783,15862,15866,15873,15913,15938,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16248,16256,16258,16292,16314,16315,16378,16403,16507,16523,16552,16577,16747,16759,16823,16828,16873,16889,16890,16991,17024,17053,17058,17074,17102,17115,17138,17145,17160,17213,17216,17233,17386,17468,17541,17542,17562,17568,17603,17615,17633,17649,17650,17662,17688,17707,17729,17844,17855,17859,17877,17893,17926,17966,18054,18062,18122,18155,18157,18180,18190,18233,18255,18274,18292,18314,18331,18344,18362,18369,18380,18460,18503,18539,18544,18559,18564,18568,18608,18610,18673,18679,18687,18694,18702,18709,18768,18800,18801,18837,18841,18846,18859,18862,18878,18916,18922,18931,18954,18969,18975,18980,18997,19028,19034,19042,19105,19124,19128,19135,19155,19218,19225,19240,19247,19313,19366,19383,19403,19419,19478,19530,19535,19550,19561,19595,19599,19604,19634,19637,19645,19646,19652,19699,19713,19732,19852,19872,19945,19959,19971,20018,20024,20030,20036,20065,20083,20127,20140,20250,20260,20264,20290,20327,20348,20376,20393,20399,20403,20429,20444,20461,20500,20602,20609,20611,20649,20671,20678,20741,20779,20797,20813,20814,20828,20850,20888,20906,20915,20955,20959,21000,21057,21062,21106,21107,21108,21143,21161,21190,21192,21249,21259,21325,21365,21369,21381,21397,21407,21434,21435,21455,21458,21464,21489,21552,21554,21578,21590,21598,21641,21696,21707,21709,21710,21740,21744,21764,21776,21777,21851,21855,21858,21883,21894,21944,21952,21969,21973,21976,21982,22000,22009,22010,22023,22040,22063,22073,22117,22144,22160,22173,22176,22214,22230,22233,22237,22262,22267,22286,22295,22298,22313,22334,22348,22360,22388,22393,22407,22414,22419,22423,22454,22459,22461,22509,22543,22617,22644,22647,22684,22712,22733,22739,22749,22763,22785,22805,22812,22819,22834,22837,22871,22876,22889,22890,22892,22904,22957,23012,23049,23065,23067,23073,23131,23139,23185,23195,23201,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23381,23582,23678,23679,23770,23861,23890,23919,23967,23970,24075,24102,24104,24152,24191,24229,24273,24274,24275,24320,24327,24366,24371,24392,24503,24524,24528,24538,24579,24592,24603,24614,24644,24645,24727,24733,24816,24833,24837,24844,24899,24964,25072,25093,25098,25106,25107,25125,25133,25225,25253,25377,25380,25397,25488,25636,25644,25645,25672,25714,25729,25730,25771,25785,25850,25945,25993,26030,26062,26099,26103,26178,26183,26256,26273,26288,26305,26493,26501,26504,26521,26563,26575,26590,26648,26675,26901,26924,26926,26972,27002,27011,27018,27150,27170,27246,27273,27321,27418,27431,27496,27521,27545,27593,27644,27686,27704,27721,27842,27917,27931,27936,27945,28005,28033,28045,28073,28082,28104,28225,28303,28312,28367,28411,28420,28639,28653,28658,28673,28950,28989,28992,29008,29009,29152,29153,29174,29197,29319,29356,29358,29399,29417,29443,29444,29476,29505,29569,29781,29863,29905,29922,29923,29935,31389,32768,32842,35369,35548,35562,35617,35689,35878,35883,35885,35950,36060,36153,36241,36319,36333,36383,36396,36534,36639,36937,36995,37005,37455,38426,38807,38831,38836,38854,38866,38890,38945,39406,39481,39603,39681,39857,39936,39938,39995,40025,40038,40079,40083,40097,40170,40200,40708,40759,40785,40809,40867,40907,40937,40984,41059,41120,41255,41301,41325,41375,41515,42456,42875,42971,43898,43907,43980,45018,45038,45039,45040,45041,45042,45043)
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 | 1073 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.73 ms |
preparing | 5.35 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.36 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 |