Tiempo de la consulta: 4.83 ms Después de la última consulta: 0.98 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-07 07:21:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 07:21: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(5,7,9,14,29,39,45,46,54,56,60,62,63,65,71,73,86,87,149,164,174,177,196,221,226,240,259,262,273,291,299,331,349,366,391,415,428,429,472,477,481,501,510,525,530,531,546,563,619,643,659,662,663,667,674,697,705,746,764,769,800,802,805,808,823,832,835,845,849,869,873,896,910,923,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1051,1055,1091,1095,1114,1119,1158,1182,1205,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1335,1347,1363,1409,1410,1428,1432,1441,1444,1485,1509,1557,1563,1571,1606,1619,1629,1648,1675,1693,1694,1724,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1919,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2084,2088,2137,2155,2157,2161,2293,2385,2455,2527,2532,2551,2553,2586,2597,2638,2643,2814,2824,2851,2883,2888,2909,2960,3027,3055,3100,3107,3144,3147,3169,3196,3207,3266,3364,3368,3369,3387,3409,3412,3473,3520,3548,3552,3554,3590,3594,3609,3623,3639,3648,3661,3683,3685,3689,3702,3703,3748,3760,3767,3774,3776,3833,3853,3858,3872,3913,3919,3921,3922,3948,3960,3962,3991,4012,4034,4050,4068,4101,4129,4148,4150,4155,4175,4204,4284,4322,4323,4327,4360,4423,4456,4468,4507,4520,4523,4529,4532,4548,4558,4575,4577,4616,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4831,4844,4846,4859,4865,4912,4933,4940,4973,5010,5055,5134,5153,5160,5220,5259,5370,5387,5415,5422,5469,5559,5577,5780,5795,5801,5909,5999,6100,6128,6148,6198,6360,6362,6391,6420,6435,6440,6442,6476,6477,6548,6649,6720,6845,6855,6865,6881,6944,6958,7022,7030,7048,7077,7111,7137,7195,7216,7242,7250,7258,7324,7329,7331,7364,7418,7444,7446,7491,7535,7586,7592,7595,7605,7614,7618,7648,7651,7724,7751,7752,7771,7784,7787,7819,7903,7925,7935,7942,8004,8055,8070,8086,8152,8160,8192,8227,8234,8265,8291,8295,8314,8370,8378,8421,8507,8538,8544,8550,8592,8602,8611,8634,8644,8660,8700,8707,8750,8753,8779,8799,8801,8813,8826,8864,8895,8925,8954,9063,9120,9237,9277,9279,9328,9350,9369,9390,9401,9477,9488,9572,9578,9600,9610,9738,9829,9838,9878,9904,9908,9922,9930,9956,10004,10190,10265,10269,10291,10313,10414,10448,10513,10572,10617,10642,10754,10756,10787,10840,10993,11001,11023,11031,11041,11073,11121,11184,11250,11286,11338,11387,11488,11545,11555,11687,11796,11921,12119,12242,12249,12398,12408,12553,12632,12638,12639,12667,12689,12690,12749,12974,12993,13034,13126,13146,13166,13209,13246,13268,13376,13385,13619,13702,13731,13738,13760,13789,13896,13946,13961,13996,14141,14351,14396,14512,14513,14515,14524,14532,14601,14616,14653,14662,14666,14703,14714,14730,14739,14752,14820,14824,14825,14865,14939,14969,14976,14999,15006,15038,15041,15063,15069,15081,15087,15148,15160,15178,15193,15203,15235,15268,15320,15326,15347,15388,15423,15457,15460,15465,15482,15487,15488,15533,15544,15551,15570,15604,15611,15617,15636,15637,15640,15738,15767,15781,15783,15804,15807,15866,15875,15910,15913,15915,15973,16036,16039,16042,16059,16082,16084,16097,16122,16127,16129,16156,16181,16199,16204,16224,16248,16256,16292,16314,16315,16403,16421,16454,16552,16577,16587,16588,16612,16737,16759,16791,16828,16830,16868,16890,16913,16991,16995,17053,17054,17055,17074,17102,17115,17123,17140,17145,17160,17166,17216,17233,17333,17372,17388,17442,17468,17592,17633,17644,17646,17650,17683,17699,17737,17791,17798,17799,17806,17807,17844,17855,17859,17893,17926,17936,17944,17966,18036,18054,18062,18122,18157,18180,18233,18255,18274,18292,18314,18344,18357,18362,18383,18444,18460,18461,18480,18539,18542,18544,18564,18608,18657,18695,18709,18733,18754,18779,18800,18802,18832,18846,18862,18878,18916,18922,18931,18954,18975,18980,19015,19028,19034,19038,19042,19105,19124,19128,19135,19155,19183,19187,19218,19228,19240,19247,19258,19269,19280,19282,19283,19289,19299,19302,19307,19313,19339,19366,19389,19400,19402,19421,19423,19427,19458,19470,19503,19530,19532,19533,19550,19561,19573,19604,19637,19652,19713,19721,19732,19800,19830,19852,19872,19937,19945,20018,20029,20030,20044,20056,20057,20062,20127,20153,20177,20188,20215,20236,20250,20260,20264,20278,20293,20306,20327,20348,20376,20391,20393,20429,20444,20461,20508,20530,20600,20602,20649,20662,20678,20713,20733,20741,20743,20764,20779,20797,20804,20813,20828,20843,20850,20851,20853,20858,20860,20871,20879,20883,20906,20915,20920,20921,20944,20949,20954,20959,20999,21000,21057,21062,21107,21108,21143,21161,21168,21190,21217,21236,21249,21282,21313,21325,21369,21381,21397,21402,21434,21435,21458,21464,21483,21489,21552,21554,21569,21578,21590,21641,21710,21740,21744,21760,21764,21776,21777,21787,21820,21855,21858,21883,21894,21944,21969,21976,21982,22010,22034,22040,22063,22105,22160,22176,22214,22237,22298,22313,22348,22407,22459,22461,22567,22603,22617,22647,22733,22739,22743,22763,22819,22837,22847,22854,22889,22890,22904,22957,23065,23067,23131,23138,23170,23185,23195,23201,23202,23224,23237,23241,23246,23260,23280,23313,23320,23325,23326,23328,23335,23339,23526,23536,23569,23582,23599,23617,23678,23679,23682,23875,23890,24067,24075,24102,24104,24152,24153,24189,24191,24208,24219,24273,24274,24327,24366,24371,24392,24415,24484,24503,24526,24585,24592,24598,24609,24614,24644,24682,24727,24733,24797,24816,24837,24844,24853,24899,24964,24973,25072,25098,25107,25125,25133,25225,25253,25323,25377,25380,25456,25534,25547,25569,25598,25610,25632,25644,25645,25714,25721,25730,25785,25850,25901,25993,26014,26178,26183,26215,26245,26256,26273,26386,26493,26501,26504,26521,26554,26563,26648,26829,26841,26872,26874,26901,26920,26926,26954,26972,27002,27011,27103,27133,27135,27150,27157,27170,27246,27273,27321,27369,27418,27431,27490,27496,27521,27545,27593,27644,27686,27704,27721,27805,27842,27863,27904,27917,27931,27936,27997,28005,28033,28045,28082,28225,28248,28312,28402,28411,28416,28639,28653,28658,28910,28918,28960,28989,29008,29009,29033,29136,29152,29153,29174,29197,29281,29319,29356,29417,29443,29444,29476,29781,29905,29922,29923,29935,30307,31114,31356,31671,32097,32768,32841,32842,33259,33430,33593,33651,33784,33993,34008,34176,34300,34425,34490,34573,34783,34943,34975,35037,35239,35351,35553,35568,35617,35689,35755,35768,35883,35885,35959,36219,36360,37408,38001,38807,38814,38831,38854,38866,39481,39488,39603,39681,39857,40025,40038,40083,40097,40170,40200,40708,40759,40785,40809,40907,40937,40984,41059,41255,41256,41301,41311,41325,41375,41430,42530,42752,42799,44396,44402,44602,44743,45076)
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 | 1145 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.75 ms |
preparing | 0.90 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |