Tiempo de la consulta: 4.33 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.354 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-08 09:43:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 09:43:24')
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(1,17,79,80,81,82,83,85,86,165,204,234,255,271,325,353,368,434,447,458,485,495,512,529,531,537,542,547,560,566,567,607,664,686,701,744,756,760,806,840,850,862,870,886,933,940,951,974,977,986,1091,1207,1226,1265,1277,1295,1347,1365,1463,1490,1600,1614,1643,1664,1698,1725,1755,1768,1893,1905,1929,2022,2144,2169,2199,2210,2217,2237,2242,2249,2256,2273,2285,2286,2299,2319,2346,2348,2386,2733,2902,3024,3034,3049,3113,3177,3409,3439,3520,3790,3852,3884,3886,3898,3940,3963,3993,4063,4084,4090,4116,4152,4153,4230,4282,4309,4409,4410,4436,4445,4453,4471,4587,4692,4715,4748,4842,4891,5001,5033,5071,5083,5085,5152,5157,5237,5238,5269,5329,5350,5515,5647,5662,5691,5819,5894,5896,5933,5998,6004,6024,6028,6069,6095,6185,6414,6448,6470,6473,6581,6598,6600,6654,6681,6752,6775,6790,6797,6806,6809,6817,6828,6916,6941,6948,6955,6971,6982,6994,7079,7088,7105,7173,7191,7212,7243,7275,7276,7312,7326,7353,7395,7397,7398,7407,7418,7462,7516,7568,7610,7730,7737,7787,7840,7965,7966,7971,8020,8027,8043,8053,8106,8247,8280,8308,8311,8330,8335,8346,8351,8375,8396,8408,8429,8445,8452,8492,8502,8506,8546,8571,8610,8632,8653,8656,8663,8690,8713,8740,8755,8761,8771,8785,8809,8864,8866,8923,8952,8983,8987,9039,9042,9127,9130,9157,9249,9253,9297,9318,9334,9347,9382,9407,9414,9432,9438,9450,9451,9473,9531,9532,9580,9585,9604,9639,9693,9694,9772,9840,9883,9973,9990,10024,10048,10050,10077,10079,10087,10108,10135,10197,10198,10266,10278,10280,10290,10299,10302,10303,10342,10350,10359,10395,10443,10486,10499,10518,10522,10557,10560,10636,10690,10731,10806,10831,10887,10912,10915,10963,11023,11031,11087,11098,11115,11182,11193,11239,11242,11253,11273,11278,11316,11345,11367,11415,11447,11494,11542,11555,11581,11640,11673,11692,11747,11840,11875,11880,12027,12060,12101,12104,12133,12155,12184,12186,12216,12232,12289,12293,12338,12363,12366,12379,12416,12434,12472,12490,12507,12509,12572,12685,12716,12745,12757,12808,12810,12917,12920,12965,12977,12983,13029,13077,13084,13089,13177,13178,13235,13278,13287,13352,13356,13388,13458,13485,13537,13550,13596,13635,13651,13658,13763,13769,13830,13836,13841,13913,13985,13996,14011,14038,14069,14108,14109,14139,14157,14205,14227,14232,14252,14350,14477,14517,14557,14569,14573,14591,14596,14610,14635,14701,14729,14774,14778,14863,14895,14899,14926,14979,15040,15065,15071,15076,15114,15144,15152,15153,15160,15242,15253,15256,15269,15297,15304,15323,15326,15441,15445,15455,15560,15626,15628,15640,15721,15741,15760,15766,15771,15772,15777,15862,15877,15892,15938,15978,16014,16053,16054,16085,16123,16125,16187,16190,16217,16258,16277,16281,16301,16325,16359,16366,16378,16392,16410,16436,16470,16476,16486,16490,16501,16543,16554,16558,16561,16606,16607,16635,16642,16675,16691,16698,16713,16717,16728,16747,16815,16823,16831,16843,16873,16964,16966,17001,17024,17043,17059,17149,17157,17189,17213,17222,17280,17341,17354,17364,17381,17386,17403,17417,17463,17500,17541,17567,17568,17596,17597,17617,17630,17650,17657,17662,17669,17688,17689,17712,17729,17753,17772,17784,17877,17907,17943,17954,17968,17990,18001,18049,18155,18158,18176,18190,18214,18217,18263,18337,18352,18361,18380,18386,18427,18438,18455,18479,18485,18486,18520,18527,18547,18565,18568,18576,18581,18586,18591,18647,18648,18665,18695,18702,18711,18716,18768,18801,18808,18809,18839,18841,18898,18905,18957,18972,18986,18997,19060,19063,19074,19120,19123,19134,19210,19217,19225,19251,19270,19303,19310,19313,19321,19331,19377,19383,19413,19416,19419,19433,19437,19440,19453,19478,19484,19494,19495,19504,19522,19552,19556,19566,19593,19604,19625,19651,19720,19730,19733,19751,19763,19766,19779,19864,19955,19959,19986,19987,19999,20007,20031,20042,20076,20086,20103,20116,20140,20146,20167,20179,20199,20225,20229,20236,20279,20332,20333,20335,20352,20362,20399,20422,20427,20479,20513,20542,20562,20563,20574,20605,20611,20671,20680,20691,20704,20724,20737,20753,20765,20769,20774,20776,20795,20799,20817,20826,20835,20888,20892,20898,20915,20947,20950,20975,20991,21017,21105,21128,21140,21152,21161,21184,21192,21242,21259,21293,21350,21366,21369,21386,21398,21407,21415,21452,21455,21465,21518,21555,21598,21606,21640,21662,21681,21696,21707,21766,21775,21849,21878,21891,21904,21969,22009,22030,22052,22061,22073,22089,22117,22126,22144,22173,22222,22225,22228,22230,22233,22248,22268,22286,22336,22350,22360,22366,22378,22382,22393,22395,22414,22417,22419,22431,22454,22530,22559,22607,22622,22666,22684,22712,22740,22749,22752,22753,22766,22785,22793,22805,22812,22820,22822,22871,22875,22892,22906,22913,22921,22933,22934,22935,22976,23002,23006,23012,23017,23050,23080,23103,23126,23139,23151,23242,23271,23279,23343,23354,23367,23380,23381,23396,23417,23438,23444,23445,23466,23477,23495,23512,23527,23559,23614,23651,23659,23665,23666,23677,23693,23716,23719,23740,23761,23768,23770,23782,23792,23806,23816,23827,23869,23874,23914,23965,23991,23998,24001,24024,24059,24060,24131,24171,24178,24212,24229,24260,24272,24299,24302,24373,24470,24524,24528,24538,24543,24573,24608,24651,24659,24672,24718,24754,24780,24790,24851,24857,24905,24927,24942,24960,24995,25090,25102,25104,25119,25141,25143,25199,25207,25222,25226,25242,25252,25260,25310,25332,25343,25345,25352,25353,25366,25384,25402,25420,25429,25434,25435,25452,25486,25502,25525,25556,25560,25573,25595,25614,25615,25616,25636,25650,25664,25676,25688,25697,25711,25729,25771,25778,25807,25820,25886,25948,26030,26062,26099,26103,26133,26193,26238,26239,26250,26292,26293,26324,26338,26389,26431,26456,26479,26513,26541,26559,26571,26575,26589,26590,26596,26605,26618,26654,26697,26709,26723,26742,26760,26776,26792,26809,26857,26859,26939,26958,26960,26985,27008,27015,27020,27024,27055,27056,27058,27070,27076,27093,27149,27247,27248,27356,27417,27420,27438,27453,27477,27544,27566,27572,27720,27822,27991,28073,28104,28169,28227,28316,28420,28499,28611,28620,28673,28690,28734,28747,28755,28774,28910,28922,29023,29123,29241,29374,29391,29435,29466,29499,29505,29584,29833,29834,29895,29909,30111,30947,32136,33932,35566,35730,35741,35803,35921,35926,35942,35989,36017,36041,36053,36235,36633,36958,37587,38800,38852,38916,38985,39049,39178,39318,39369,39385,39653,39858,39941,39998,40050,40064,40214,40503,40685,40706,41120,41337,43842)
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 | 1094 | 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.02 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.67 ms |
preparing | 0.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |