Tiempo de la consulta: 5.57 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.350 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 14:43:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 14:43:55')
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(5,9,45,46,54,62,65,71,107,119,266,415,643,659,764,1180,1295,1335,1447,1490,1563,1571,1755,1852,1905,1929,2022,2084,2301,2556,2640,2694,2804,2809,2902,2909,3177,3196,3205,3266,3343,3685,3760,3767,3776,3790,3819,3833,3913,3960,4034,4084,4090,4101,4110,4129,4144,4148,4150,4152,4164,4204,4230,4282,4284,4323,4327,4423,4456,4477,4548,4575,4665,4715,4748,4761,4810,4842,4859,4879,4891,4940,5033,5071,5083,5152,5237,5238,5259,5269,5329,5350,5387,5422,5642,5691,5693,5697,5806,5819,5909,5933,5976,5985,5998,6004,6024,6028,6069,6095,6100,6128,6185,6360,6362,6414,6431,6440,6511,6581,6649,6720,6797,6817,6865,6881,6925,6982,7077,7079,7088,7093,7111,7165,7166,7216,7250,7258,7331,7353,7364,7395,7397,7398,7444,7586,7605,7610,7614,7618,7650,7651,7713,7724,7731,7737,7752,7771,7784,7787,7822,7903,7925,7935,7942,7971,8004,8043,8047,8055,8152,8160,8206,8227,8234,8241,8247,8265,8272,8280,8308,8311,8330,8335,8346,8366,8370,8375,8378,8388,8396,8408,8421,8429,8452,8466,8492,8506,8507,8517,8546,8550,8571,8605,8607,8611,8632,8644,8653,8656,8660,8690,8700,8740,8741,8750,8753,8755,8761,8771,8778,8785,8799,8802,8813,8826,8842,8864,8866,8923,8925,8929,8954,8983,8987,9039,9042,9063,9067,9069,9120,9127,9130,9132,9157,9171,9177,9181,9297,9328,9334,9347,9350,9382,9390,9407,9424,9450,9477,9578,9582,9585,9600,9604,9610,9621,9639,9693,9694,9738,9827,9829,9838,9840,9878,9883,9904,9908,9922,9956,9973,9980,9990,10004,10087,10108,10135,10183,10190,10236,10241,10265,10269,10278,10313,10342,10359,10414,10448,10511,10513,10522,10531,10580,10617,10636,10642,10650,10669,10688,10697,10716,10754,10756,10763,10834,10838,10855,10923,10963,10973,10993,11023,11031,11041,11073,11104,11115,11121,11193,11208,11214,11239,11250,11253,11286,11303,11338,11353,11387,11390,11442,11488,11530,11545,11548,11581,11673,11687,11796,11823,11875,11921,11933,12027,12032,12060,12101,12104,12155,12184,12186,12232,12249,12289,12418,12434,12507,12509,12553,12632,12638,12689,12690,12785,12938,12973,13008,13063,13077,13089,13146,13148,13166,13199,13209,13240,13352,13356,13376,13385,13458,13480,13485,13536,13537,13546,13549,13557,13562,13702,13719,13731,13738,13760,13769,13789,13830,13898,13913,13946,13961,13996,14038,14106,14141,14143,14157,14223,14270,14313,14332,14351,14376,14396,14476,14512,14513,14515,14530,14532,14569,14601,14610,14616,14662,14730,14739,14748,14761,14772,14815,14820,14824,14825,14853,14863,14899,14932,14939,14958,14999,15006,15028,15040,15041,15063,15069,15071,15081,15124,15148,15152,15153,15178,15193,15224,15248,15253,15268,15269,15323,15326,15347,15367,15369,15388,15423,15457,15465,15482,15487,15509,15551,15570,15611,15617,15628,15632,15636,15637,15640,15672,15721,15738,15743,15767,15771,15772,15777,15783,15862,15866,15882,15897,15909,15913,15938,15981,16002,16036,16039,16042,16059,16082,16084,16090,16097,16127,16129,16156,16181,16193,16215,16248,16256,16258,16292,16314,16315,16338,16378,16403,16552,16577,16618,16747,16759,16795,16823,16828,16873,16890,16991,17024,17053,17074,17102,17115,17145,17160,17213,17216,17233,17260,17386,17394,17451,17468,17517,17541,17555,17563,17564,17568,17570,17633,17650,17651,17662,17778,17844,17855,17859,17873,17877,17893,17926,17966,18054,18062,18122,18155,18157,18180,18183,18190,18233,18242,18255,18274,18292,18314,18328,18344,18362,18460,18521,18539,18544,18564,18568,18589,18608,18660,18702,18703,18709,18717,18768,18800,18801,18841,18846,18862,18878,18884,18916,18922,18931,18940,18954,18975,18980,19028,19034,19042,19105,19124,19128,19135,19155,19196,19217,19218,19225,19240,19247,19298,19313,19335,19339,19366,19448,19478,19502,19530,19550,19561,19604,19637,19652,19653,19713,19732,19768,19852,19865,19867,19872,19885,19945,19953,19958,19959,20018,20030,20083,20127,20140,20144,20250,20260,20264,20327,20334,20348,20376,20393,20399,20429,20444,20445,20461,20525,20553,20579,20598,20602,20611,20649,20671,20678,20738,20741,20779,20785,20797,20813,20828,20850,20875,20888,20906,20915,20958,20959,21000,21051,21052,21057,21062,21107,21108,21114,21130,21131,21143,21149,21161,21190,21192,21249,21259,21325,21369,21381,21397,21407,21434,21435,21455,21458,21464,21489,21552,21554,21555,21559,21578,21590,21598,21599,21641,21696,21707,21710,21732,21740,21744,21764,21776,21777,21855,21858,21883,21894,21898,21908,21944,21969,21976,21982,22009,22010,22040,22063,22073,22117,22144,22160,22173,22176,22214,22230,22233,22237,22286,22298,22313,22348,22360,22378,22385,22393,22407,22454,22459,22461,22488,22513,22558,22591,22611,22617,22647,22681,22684,22712,22720,22733,22739,22749,22763,22784,22785,22805,22812,22819,22837,22871,22889,22890,22892,22904,22957,22987,23012,23065,23067,23096,23105,23131,23139,23185,23195,23201,23237,23241,23260,23277,23280,23313,23320,23325,23326,23328,23335,23339,23381,23582,23593,23638,23678,23679,23684,23770,23817,23823,23890,24075,24102,24104,24152,24191,24229,24273,24274,24327,24366,24371,24392,24480,24503,24524,24528,24531,24538,24565,24592,24644,24701,24727,24733,24769,24770,24816,24819,24837,24844,24899,24910,24964,25072,25098,25107,25125,25133,25172,25225,25244,25253,25283,25342,25377,25380,25644,25645,25714,25729,25730,25771,25785,25850,25993,26062,26099,26103,26178,26183,26256,26273,26471,26493,26501,26504,26521,26563,26575,26590,26648,26901,26926,26972,27002,27011,27150,27170,27246,27273,27280,27314,27321,27322,27418,27431,27496,27521,27545,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28033,28045,28073,28082,28104,28225,28312,28411,28420,28639,28653,28658,28673,28977,28989,28991,29008,29009,29152,29153,29174,29197,29304,29319,29356,29417,29443,29444,29476,29505,29710,29781,29802,29905,29922,29923,29935,30280,32768,32842,35617,35689,35718,35883,35885,37116,38807,38831,38854,38866,39481,39603,39681,39857,40025,40038,40083,40097,40170,40200,40309,40708,40759,40774,40785,40809,40907,40937,40984,41059,41120,41254,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 | 1025 | 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.73 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 2.20 ms |
preparing | 1.15 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 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 |