Tiempo de la consulta: 3.88 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.175 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 03:32:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:32:33')
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,643,659,740,764,905,1282,1335,1563,1571,1648,1794,2013,2084,2647,2817,2909,2954,3054,3128,3174,3182,3196,3266,3344,3363,3364,3387,3424,3454,3663,3685,3760,3767,3776,3833,3913,3960,3994,4034,4101,4110,4129,4148,4150,4204,4243,4284,4323,4327,4409,4423,4456,4548,4575,4619,4822,4823,4859,4863,4940,5028,5247,5259,5387,5396,5422,5478,5577,5686,5881,5886,5909,6056,6088,6100,6128,6232,6360,6362,6440,6465,6545,6649,6720,6865,6881,6988,7014,7077,7089,7111,7216,7246,7250,7258,7272,7276,7331,7336,7364,7432,7437,7444,7586,7605,7614,7618,7622,7651,7720,7724,7752,7771,7784,7787,7897,7903,7915,7925,7935,7942,7953,7979,8004,8055,8090,8152,8160,8227,8229,8234,8265,8314,8370,8378,8421,8457,8507,8550,8611,8644,8660,8700,8750,8753,8760,8763,8799,8813,8826,8833,8864,8925,8954,9029,9063,9087,9120,9204,9328,9350,9364,9376,9390,9429,9477,9578,9600,9610,9738,9829,9838,9878,9904,9908,9922,9924,9956,10004,10190,10265,10269,10313,10414,10448,10475,10513,10553,10614,10617,10630,10642,10694,10734,10754,10756,10850,10875,10917,10993,11023,11031,11041,11073,11081,11121,11250,11258,11286,11338,11387,11482,11488,11545,11687,11792,11796,11899,11921,11929,12040,12249,12553,12617,12620,12632,12638,12657,12689,12690,12810,12853,12901,12944,13085,13146,13166,13209,13246,13294,13298,13376,13385,13609,13610,13687,13697,13702,13731,13738,13742,13757,13760,13789,13804,13946,13948,13961,13996,14074,14117,14141,14168,14237,14351,14396,14512,14513,14515,14532,14601,14616,14646,14662,14671,14698,14730,14739,14759,14820,14824,14825,14939,14992,14999,15006,15032,15037,15041,15069,15081,15094,15148,15160,15178,15193,15268,15303,15326,15347,15382,15388,15423,15457,15465,15471,15482,15487,15492,15551,15570,15611,15617,15636,15637,15640,15738,15752,15757,15767,15783,15829,15866,15913,15935,16036,16039,16042,16043,16059,16082,16084,16097,16127,16129,16140,16153,16156,16161,16181,16206,16248,16256,16292,16303,16304,16314,16315,16373,16403,16458,16459,16552,16568,16577,16759,16775,16828,16889,16890,16929,16981,16991,17005,17048,17053,17074,17086,17102,17115,17145,17160,17216,17233,17273,17381,17468,17484,17526,17596,17633,17634,17650,17702,17757,17766,17840,17844,17855,17859,17864,17893,17895,17926,17961,17966,18054,18062,18122,18157,18180,18233,18255,18267,18274,18292,18314,18326,18344,18362,18384,18442,18460,18498,18539,18544,18561,18564,18577,18608,18709,18800,18846,18847,18862,18869,18878,18904,18916,18922,18931,18954,18975,18977,18980,18991,18995,19028,19034,19042,19091,19105,19112,19124,19128,19132,19135,19149,19155,19218,19240,19247,19294,19313,19329,19350,19366,19446,19453,19530,19550,19561,19581,19595,19604,19608,19609,19637,19652,19655,19661,19684,19700,19707,19713,19732,19852,19867,19872,19945,19964,19983,20018,20030,20034,20036,20127,20145,20199,20250,20260,20264,20289,20327,20346,20348,20354,20358,20374,20376,20393,20403,20429,20444,20461,20578,20602,20638,20649,20659,20678,20741,20755,20768,20779,20797,20813,20826,20828,20850,20856,20906,20912,20915,20950,20959,21000,21057,21062,21100,21107,21108,21118,21143,21161,21190,21249,21305,21325,21369,21381,21397,21433,21434,21435,21458,21464,21489,21490,21546,21552,21554,21578,21590,21593,21641,21710,21737,21740,21744,21764,21776,21777,21855,21858,21883,21894,21944,21947,21948,21952,21976,21982,22010,22040,22063,22141,22143,22160,22173,22175,22176,22214,22237,22244,22245,22246,22298,22313,22338,22345,22348,22407,22435,22455,22458,22459,22461,22517,22592,22617,22647,22667,22668,22715,22733,22739,22763,22803,22819,22837,22889,22890,22904,22957,22969,23000,23022,23034,23060,23065,23067,23081,23091,23131,23162,23185,23195,23196,23200,23201,23204,23234,23237,23241,23247,23250,23253,23260,23275,23280,23313,23320,23325,23326,23328,23335,23339,23348,23370,23392,23425,23467,23516,23538,23546,23559,23564,23582,23606,23658,23668,23678,23679,23691,23767,23785,23829,23857,23890,23911,23922,23930,23962,24009,24075,24076,24102,24104,24111,24141,24152,24156,24174,24191,24217,24230,24232,24273,24274,24287,24327,24366,24371,24392,24503,24523,24592,24616,24621,24644,24733,24788,24816,24823,24837,24844,24845,24899,24964,24968,25003,25037,25072,25098,25107,25125,25126,25133,25225,25253,25293,25325,25333,25369,25377,25380,25534,25538,25545,25624,25639,25644,25645,25652,25714,25730,25744,25764,25785,25798,25850,25993,26107,26122,26178,26183,26256,26257,26273,26361,26454,26493,26501,26504,26507,26521,26522,26563,26582,26648,26681,26767,26779,26800,26816,26901,26910,26926,26972,27002,27011,27026,27048,27088,27131,27150,27170,27186,27246,27273,27306,27321,27353,27363,27418,27431,27438,27452,27496,27521,27545,27593,27644,27686,27694,27704,27721,27842,27891,27917,27931,27936,27993,28005,28033,28045,28082,28225,28312,28411,28639,28653,28658,28780,28845,28989,29008,29009,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29745,29781,29833,29905,29922,29923,29935,32250,32302,32381,32507,32590,32768,32842,32843,32896,32943,33040,33129,33199,33649,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,35617,35689,35883,35885,37893,38807,38831,38854,38866,38948,38999,39010,39481,39603,39681,39857,40025,40038,40083,40097,40170,40200,40708,40759,40785,40809,40822,40850,40907,40937,40984,40990,41059,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 | 909 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.37 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 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 |