Tiempo de la consulta: 4.89 ms Después de la última consulta: 0.97 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.357 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-06 10:51:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 10:51:27')
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,54,61,62,65,71,80,146,385,415,452,456,459,474,489,497,583,601,602,622,633,636,643,659,672,681,720,764,771,776,796,797,802,805,808,849,858,861,864,865,889,905,924,928,955,983,1009,1021,1027,1033,1040,1062,1087,1088,1185,1205,1248,1252,1253,1335,1402,1491,1523,1563,1570,1571,1594,1612,1631,1683,1712,1717,1744,1770,1784,1842,1849,1917,1949,1964,1999,2044,2084,2102,2110,2257,2433,2434,2436,2450,2464,2542,2633,2684,2685,2739,2788,2875,2909,2918,2964,2988,3082,3085,3178,3196,3251,3259,3266,3271,3299,3399,3425,3649,3685,3760,3767,3776,3832,3833,3857,3869,3873,3904,3913,3929,3932,3946,3960,3963,3988,4034,4082,4101,4110,4129,4148,4150,4204,4223,4284,4323,4327,4355,4391,4423,4434,4456,4502,4526,4548,4560,4575,4696,4780,4801,4854,4859,4901,4940,4993,5012,5063,5136,5183,5190,5227,5259,5328,5363,5387,5422,5475,5529,5575,5593,5632,5646,5648,5694,5811,5869,5895,5904,5909,5994,6021,6068,6086,6100,6128,6360,6362,6440,6498,6501,6528,6649,6688,6710,6720,6834,6849,6857,6865,6881,6884,6908,6960,6993,7012,7053,7054,7077,7111,7172,7175,7216,7250,7258,7273,7331,7348,7364,7374,7443,7444,7551,7567,7586,7591,7595,7601,7604,7605,7614,7618,7630,7644,7651,7658,7679,7720,7722,7724,7751,7752,7771,7784,7787,7797,7903,7925,7935,7942,7980,7996,8004,8055,8148,8152,8160,8161,8170,8188,8227,8234,8265,8296,8325,8370,8378,8387,8390,8417,8421,8492,8505,8506,8507,8550,8611,8644,8660,8700,8716,8737,8750,8753,8799,8813,8826,8852,8864,8925,8954,9004,9011,9063,9120,9130,9155,9193,9252,9328,9350,9390,9477,9501,9525,9573,9578,9600,9610,9648,9708,9738,9742,9766,9829,9831,9837,9838,9840,9878,9880,9889,9904,9908,9922,9956,9994,10004,10063,10129,10172,10190,10265,10269,10276,10278,10298,10313,10364,10414,10448,10449,10494,10513,10617,10642,10754,10756,10815,10818,10900,10942,10967,10993,10994,11023,11031,11041,11073,11121,11181,11198,11250,11286,11338,11387,11488,11527,11542,11545,11672,11685,11687,11709,11796,11804,11815,11921,11956,12168,12249,12353,12387,12410,12439,12482,12509,12553,12567,12632,12637,12638,12663,12689,12690,12694,12714,12892,12913,12926,13007,13014,13079,13109,13146,13147,13166,13209,13269,13297,13317,13341,13376,13385,13436,13553,13579,13702,13720,13722,13729,13731,13738,13760,13789,13946,13959,13961,13996,14014,14134,14141,14197,14232,14290,14302,14351,14368,14396,14417,14508,14512,14513,14515,14532,14548,14601,14616,14620,14662,14688,14725,14730,14739,14769,14787,14820,14824,14825,14872,14884,14930,14939,14989,14999,15006,15041,15069,15081,15097,15148,15160,15178,15193,15223,15250,15261,15268,15326,15347,15388,15392,15423,15430,15450,15457,15465,15482,15484,15487,15551,15555,15556,15563,15566,15570,15583,15601,15611,15617,15636,15637,15640,15670,15706,15738,15767,15783,15866,15909,15913,15916,15917,15941,15999,16006,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16248,16256,16292,16311,16313,16314,16315,16323,16403,16481,16552,16555,16577,16589,16620,16642,16698,16712,16728,16759,16828,16863,16890,16891,16940,16968,16991,17053,17064,17074,17102,17115,17136,17145,17160,17169,17209,17216,17232,17233,17248,17287,17450,17468,17513,17622,17633,17650,17752,17782,17788,17808,17844,17855,17859,17883,17893,17894,17907,17926,17966,17978,17981,18004,18019,18027,18043,18054,18062,18068,18076,18122,18141,18157,18180,18203,18206,18233,18235,18255,18274,18292,18305,18314,18344,18362,18415,18447,18460,18507,18534,18539,18542,18544,18564,18587,18608,18647,18676,18709,18778,18800,18801,18835,18846,18862,18878,18879,18916,18922,18931,18946,18954,18975,18980,19028,19034,19042,19093,19105,19124,19128,19135,19155,19184,19196,19216,19218,19240,19247,19279,19302,19313,19316,19340,19366,19383,19473,19481,19514,19530,19545,19550,19561,19565,19580,19586,19587,19604,19606,19637,19652,19665,19688,19713,19732,19741,19755,19778,19779,19805,19826,19852,19864,19872,19942,19945,19973,20002,20018,20030,20076,20127,20154,20155,20204,20206,20208,20209,20250,20260,20264,20278,20303,20327,20348,20352,20366,20376,20384,20429,20444,20461,20570,20585,20591,20602,20649,20678,20741,20779,20797,20813,20828,20850,20876,20906,20915,20935,20948,20959,20991,21000,21035,21042,21057,21062,21107,21108,21143,21153,21161,21190,21200,21249,21276,21291,21302,21325,21335,21341,21361,21369,21381,21397,21412,21415,21434,21435,21458,21464,21465,21489,21528,21552,21554,21578,21583,21590,21603,21604,21622,21632,21641,21647,21652,21704,21710,21729,21740,21744,21764,21770,21776,21777,21855,21858,21883,21894,21908,21930,21944,21963,21976,21982,21986,22010,22036,22040,22055,22058,22063,22074,22160,22176,22177,22186,22214,22237,22255,22260,22298,22308,22313,22321,22327,22348,22407,22418,22428,22459,22461,22520,22542,22594,22617,22621,22623,22633,22647,22733,22739,22763,22819,22837,22889,22890,22904,22922,22927,22932,22957,22967,23004,23027,23032,23059,23065,23067,23084,23090,23102,23131,23136,23166,23174,23185,23195,23201,23215,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23352,23411,23412,23481,23503,23531,23548,23582,23587,23633,23634,23645,23652,23678,23679,23866,23890,23894,23912,23958,23980,24002,24075,24102,24104,24134,24137,24152,24154,24191,24221,24256,24273,24274,24314,24327,24366,24371,24391,24392,24442,24503,24592,24644,24679,24719,24727,24733,24816,24837,24844,24882,24898,24899,24964,24986,25033,25061,25072,25098,25107,25125,25133,25225,25253,25271,25377,25379,25380,25644,25645,25714,25730,25735,25742,25749,25768,25782,25785,25850,25993,26097,26140,26178,26183,26197,26256,26273,26323,26324,26398,26493,26501,26504,26521,26548,26563,26574,26577,26612,26637,26648,26867,26901,26909,26919,26926,26941,26954,26972,26995,27002,27011,27087,27104,27150,27170,27184,27246,27273,27321,27418,27431,27488,27496,27521,27545,27593,27644,27686,27704,27721,27842,27845,27892,27914,27917,27931,27936,28005,28033,28045,28082,28157,28169,28225,28302,28312,28411,28639,28653,28658,28925,28989,29008,29009,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29781,29905,29922,29923,29935,30404,30519,31663,31855,32768,32842,35318,35617,35689,35883,35885,36011,36178,36239,36449,36495,37098,37154,37236,37335,37604,37817,37829,38493,38807,38816,38817,38831,38833,38841,38845,38848,38854,38866,38885,38897,38987,39198,39410,39414,39481,39603,39614,39645,39681,39715,39820,39857,39972,40025,40038,40083,40097,40133,40170,40200,40371,40403,40708,40759,40785,40809,40907,40937,40984,41059,41205,41255,41301,41325,41363,41375,41793,42034,42428,44273,44577,44897,44898)
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 | 1135 | 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.56 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 | 0.89 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 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 |