Tiempo de la consulta: 6.46 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.189 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 07:05:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 07:05:20')
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(51,133,138,197,204,260,263,328,393,431,460,523,529,583,892,907,927,1036,1112,1130,1133,1535,1587,1714,1808,2378,2485,2552,2671,2825,3126,3176,3279,3319,3320,3379,3825,3951,3984,4046,4263,4339,4515,4771,4794,4900,4992,5686,5708,5757,5814,6221,6396,6448,6465,6468,6497,6676,6686,6691,6820,6837,6939,6942,6960,6965,7018,7121,7266,7291,7292,7594,7652,7659,7712,7745,7804,7855,7940,7967,8187,8258,8658,8664,8720,8728,9018,9059,9078,9109,9218,9239,9303,9776,9823,9907,10011,10156,10348,10541,10603,10709,10869,10955,11113,11147,11207,11462,11560,11662,11693,11694,11722,11753,11788,11815,11854,11965,11978,12061,12113,12135,12213,12242,12278,12281,12430,12475,12500,12505,12550,12617,12752,12839,12935,12999,13044,13132,13202,13220,13227,13264,13269,13325,13358,13387,13452,13534,13575,13589,13616,13710,13729,13782,13896,13941,14264,14320,14356,14364,14425,14498,14663,14733,14759,14865,14873,14927,15018,15020,15027,15074,15282,15292,15312,15393,15539,15594,15689,15706,15753,15782,15804,15806,15848,15991,16014,16080,16122,16157,16176,16187,16195,16220,16224,16375,16465,16481,16545,16578,16630,16636,16652,16674,16693,16704,16740,16742,16772,16800,16862,16880,16894,16904,16913,16958,16969,17026,17055,17061,17062,17137,17138,17142,17199,17248,17301,17328,17331,17335,17336,17353,17372,17377,17409,17412,17427,17449,17527,17530,17531,17584,17590,17592,17609,17635,17658,17700,17712,17746,17767,17770,17798,17826,17862,17883,17924,17942,17954,17976,17977,18022,18027,18042,18068,18072,18078,18087,18212,18227,18265,18283,18290,18317,18320,18326,18327,18380,18384,18419,18430,18442,18473,18476,18485,18547,18548,18582,18638,18761,18892,18893,18912,18927,18929,18934,19145,19158,19235,19236,19249,19387,19435,19439,19547,19549,19565,19596,19639,19664,19694,19705,19720,19723,19740,19759,19779,19796,19800,19804,19820,19890,19916,19918,19919,19942,19973,20002,20042,20045,20066,20068,20076,20100,20191,20226,20246,20296,20315,20384,20385,20396,20577,20624,20677,20693,20694,20750,20767,20787,20836,20861,20883,20885,20969,20992,20997,21019,21027,21031,21033,21093,21154,21180,21188,21198,21203,21206,21233,21236,21251,21264,21268,21275,21279,21283,21326,21354,21356,21358,21362,21378,21398,21488,21502,21520,21536,21592,21593,21609,21644,21714,21719,21728,21769,21787,21791,21805,21813,21828,21830,21837,21875,21932,21940,21992,22037,22038,22048,22072,22131,22134,22166,22200,22244,22245,22246,22260,22271,22299,22330,22341,22377,22385,22401,22419,22421,22424,22426,22494,22507,22550,22556,22585,22615,22677,22693,22704,22736,22761,22850,22851,22854,22893,22934,22938,22939,22954,22968,22991,23083,23116,23119,23123,23134,23145,23173,23178,23213,23214,23229,23236,23272,23273,23287,23309,23334,23350,23364,23365,23409,23413,23426,23495,23668,23677,23711,23776,23851,23860,23869,23872,23906,23914,24043,24077,24108,24163,24185,24195,24233,24337,24368,24380,24391,24406,24407,24408,24442,24463,24502,24518,24527,24623,24628,24650,24774,24815,24915,24942,24974,25030,25032,25049,25116,25130,25148,25170,25195,25548,25622,25625,25673,25734,25740,25745,25750,25771,25772,25818,25864,25912,25944,25985,26003,26014,26028,26031,26056,26078,26082,26108,26117,26132,26136,26198,26221,26234,26281,26289,26362,26378,26381,26386,26387,26399,26403,26410,26412,26447,26454,26509,26544,26562,26591,26599,26616,26626,26627,26630,26671,26672,26678,26720,26744,26760,26785,26803,26804,26835,26839,26842,26843,26845,26864,26866,26916,26933,26944,26947,26948,26950,26955,27005,27055,27059,27076,27100,27102,27107,27108,27109,27118,27120,27124,27133,27137,27161,27192,27268,27269,27270,27275,27287,27302,27322,27327,27408,27445,27450,27454,27457,27465,27487,27491,27499,27526,27548,27550,27552,27604,27605,27614,27707,27717,27767,27786,27855,27856,27918,27923,27926,27950,27986,27999,28016,28017,28095,28109,28152,28208,28279,28349,28354,28356,28372,28419,28570,28670,28846,28857,28985,29223,29333,29345,29380,29483,29495,29590,29602,29611,29630,29641,29726,29977,30334,30529,30580,30621,30804,30810,30932,30977,31019,31679,31764,32304,32322,32649,32689,32796,32817,32865,32973,33090,33091,33099,33116,33259,33282,33440,33504,33505,33506,33507,33508,33509,33510,33511,33573,33596,33832,33871,33874,33902,33917,33924,33951,33952,33957,33981,33982,33993,33999,34014,34105,34122,34140,34171,34175,34185,34186,34251,34441,34501,34629,34714,34776,34784,34795,34876,34914,34923,35092,35195,35197,35282,35375,35554,35621,35637,35668,35683,35687,35783,35850,35910,35937,35956,36174,36181,36208,36222,36378,36439,36581,36584,36722,36797,36828,36934,36942,37155,37283,37370,37437,37520,37643,37644,37757,37820,37981,38058,38086,38157,38246,38257,38278,38288,38328,38330,38391,38402,38432,38453,38728,38836,38843,38885,38898,38912,38939,39062,39184,39242,39296,39345,39376,39448,39474,39600,39850,39886,40218,40263,40673,40786,40885,41009,41109,41121,41149,41155,41172,41363,41407,41483,41505,41506,41515,41516,41577,41586,41612,41668,41912,41968,42042,42181,42184,42479,42941,42992,43004,43350,43363,43369,43401,43688,44421,44848,44871,44936,45057)
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 | 854 | 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.84 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
init | 0.31 ms |
System lock | 0.03 ms |
optimizing | 0.12 ms |
statistics | 2.60 ms |
preparing | 1.19 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.61 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.08 ms |
freeing items | 0.11 ms |
cleaning up | 0.05 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 |