Tiempo de la consulta: 4.56 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.309 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-05 21:52:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 21:52:49')
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,62,65,71,415,544,643,659,764,1335,1409,1410,1428,1563,1571,1606,1619,1648,1694,1724,1794,1795,1796,1808,1810,1843,1917,1930,1975,2061,2084,2197,2613,2909,3032,3090,3196,3266,3278,3296,3330,3515,3526,3570,3637,3685,3760,3767,3776,3815,3822,3823,3833,3838,3848,3858,3910,3913,3960,4031,4034,4077,4101,4107,4110,4129,4148,4150,4175,4204,4207,4284,4323,4327,4337,4414,4423,4436,4437,4456,4548,4550,4561,4569,4575,4623,4859,4877,4881,4940,5005,5024,5032,5123,5137,5213,5249,5259,5267,5270,5289,5306,5315,5329,5338,5368,5387,5419,5421,5422,5454,5704,5762,5909,5912,5927,6041,6100,6128,6194,6360,6362,6440,6564,6649,6714,6720,6737,6759,6865,6881,7077,7111,7216,7250,7258,7320,7331,7349,7364,7385,7386,7393,7394,7412,7444,7474,7529,7586,7605,7614,7618,7651,7664,7669,7724,7725,7732,7752,7769,7771,7784,7787,7817,7878,7885,7903,7925,7935,7942,8004,8008,8055,8117,8152,8160,8163,8176,8227,8234,8265,8270,8330,8331,8358,8363,8364,8369,8370,8378,8387,8388,8409,8421,8424,8455,8496,8506,8507,8550,8599,8607,8611,8644,8660,8664,8667,8671,8700,8703,8750,8753,8758,8799,8803,8804,8813,8826,8864,8869,8873,8925,8930,8954,8967,8977,8980,8998,9019,9063,9120,9167,9234,9295,9302,9325,9327,9328,9350,9354,9357,9363,9382,9390,9400,9420,9453,9471,9477,9578,9600,9610,9640,9670,9697,9710,9732,9738,9793,9829,9838,9878,9886,9904,9908,9922,9956,9963,10004,10042,10082,10124,10148,10172,10190,10265,10269,10313,10393,10414,10448,10473,10513,10525,10580,10614,10617,10642,10754,10756,10993,10998,11023,11031,11041,11073,11089,11121,11184,11250,11275,11286,11318,11338,11387,11436,11488,11545,11687,11728,11772,11796,11921,12214,12249,12268,12288,12298,12453,12468,12552,12553,12632,12638,12689,12690,12856,12886,12969,13094,13110,13113,13135,13146,13166,13205,13209,13300,13353,13376,13385,13502,13582,13702,13731,13738,13760,13761,13789,13794,13832,13946,13961,13996,14097,14141,14211,14260,14306,14351,14355,14396,14458,14460,14494,14512,14513,14515,14601,14607,14616,14645,14662,14686,14693,14730,14739,14820,14824,14825,14848,14866,14870,14930,14933,14939,14944,14950,14999,15006,15016,15041,15069,15081,15098,15126,15137,15148,15151,15160,15178,15193,15211,15260,15268,15270,15274,15318,15324,15326,15328,15347,15364,15387,15388,15406,15423,15428,15457,15458,15465,15482,15487,15513,15551,15570,15611,15617,15618,15624,15636,15637,15640,15738,15743,15767,15776,15783,15784,15800,15817,15822,15823,15866,15879,15909,15913,15964,16002,16007,16027,16036,16039,16042,16056,16059,16074,16082,16084,16097,16099,16114,16127,16129,16132,16137,16139,16156,16164,16181,16192,16223,16248,16254,16256,16275,16292,16301,16314,16315,16351,16358,16372,16373,16375,16380,16393,16396,16403,16405,16414,16498,16552,16563,16566,16577,16656,16683,16759,16828,16845,16886,16890,16924,16962,16991,17008,17010,17033,17053,17056,17074,17085,17102,17115,17145,17152,17160,17214,17216,17217,17233,17298,17344,17468,17499,17549,17597,17628,17633,17650,17773,17844,17855,17859,17880,17893,17923,17926,17946,17966,17984,18054,18062,18063,18122,18157,18161,18180,18233,18235,18246,18254,18255,18258,18274,18281,18292,18314,18329,18344,18361,18362,18460,18539,18544,18564,18608,18632,18646,18655,18709,18727,18742,18757,18800,18846,18862,18878,18894,18904,18916,18922,18931,18954,18975,18976,18980,19028,19034,19042,19051,19105,19124,19128,19135,19155,19177,19218,19240,19247,19313,19366,19490,19530,19550,19561,19569,19584,19604,19637,19641,19652,19674,19709,19713,19732,19852,19867,19872,19945,20018,20030,20072,20127,20250,20260,20264,20286,20293,20327,20348,20350,20376,20393,20397,20400,20429,20444,20445,20461,20464,20473,20509,20521,20529,20534,20579,20602,20606,20649,20678,20707,20741,20779,20797,20813,20828,20850,20906,20915,20928,20959,20974,21000,21008,21057,21062,21107,21108,21138,21143,21149,21161,21186,21190,21225,21249,21264,21322,21325,21369,21381,21397,21429,21434,21435,21458,21464,21489,21552,21554,21578,21590,21641,21710,21732,21738,21740,21744,21750,21764,21776,21777,21855,21858,21861,21883,21894,21898,21944,21972,21973,21976,21982,21999,22010,22026,22040,22052,22063,22160,22176,22209,22214,22237,22298,22313,22348,22407,22455,22459,22461,22477,22530,22617,22640,22647,22663,22684,22733,22739,22763,22819,22837,22889,22890,22904,22957,22987,23049,23065,23067,23131,23185,23195,23201,23234,23237,23241,23260,23277,23280,23313,23320,23325,23326,23328,23335,23339,23399,23492,23559,23582,23591,23596,23678,23679,23890,23986,24075,24101,24102,24104,24152,24191,24205,24273,24274,24313,24327,24366,24371,24392,24449,24503,24592,24642,24644,24668,24721,24727,24733,24745,24806,24816,24837,24844,24899,24964,25020,25072,25098,25107,25125,25133,25134,25178,25204,25225,25253,25293,25357,25377,25380,25418,25444,25561,25644,25645,25714,25730,25785,25787,25850,25993,26178,26183,26256,26273,26284,26347,26349,26352,26356,26444,26493,26501,26504,26521,26563,26648,26690,26808,26901,26926,26972,27002,27011,27150,27170,27246,27273,27321,27406,27410,27418,27431,27496,27521,27545,27593,27644,27686,27704,27721,27737,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28411,28639,28653,28658,28989,29008,29009,29014,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29501,29535,29781,29905,29906,29922,29923,29935,29938,30284,32768,32842,34335,35617,35689,35883,35885,38807,38831,38854,38866,39481,39603,39681,39857,40025,40038,40083,40097,40170,40200,40516,40708,40759,40783,40785,40809,40852,40907,40937,40984,41059,41255,41270,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 | 955 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.50 ms |
preparing | 0.77 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |