Tiempo de la consulta: 5.92 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.308 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 16:54:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:54:35')
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(14,33,34,35,39,40,41,42,43,71,75,126,127,128,129,174,255,263,277,294,307,389,458,481,607,611,667,701,801,816,868,903,970,973,988,1078,1080,1183,1201,1207,1277,1329,1337,1340,1697,1883,1976,2150,2181,2195,2290,2371,2489,2732,2750,2797,2827,2857,2946,3059,3080,3111,3202,3208,3255,3302,3312,3329,3364,3442,3491,3517,3603,3620,3732,3782,3821,3849,3880,3980,3986,4157,4255,4315,4384,4531,4643,4765,4774,4791,4813,4852,4872,4917,4920,4931,5085,5154,5207,5208,5211,5218,5295,5315,5451,5456,5472,5491,5647,5658,5698,5767,5792,5827,5833,5854,5862,5877,5894,5896,5911,5912,5917,5932,5953,5961,6015,6050,6062,6080,6082,6116,6135,6141,6167,6186,6278,6279,6282,6306,6319,6339,6340,6412,6415,6463,6475,6476,6477,6479,6515,6517,6534,6548,6588,6594,6605,6616,6628,6632,6643,6658,6698,6751,6762,6791,6888,6889,6897,6927,6928,6933,6935,6969,7031,7045,7077,7105,7136,7148,7150,7185,7193,7201,7270,7321,7379,7429,7447,7463,7492,7545,7553,7561,7604,7669,7675,7691,7696,7718,7737,7741,7743,7777,7825,7829,7835,7837,7895,7950,7954,7955,7960,7965,7987,8015,8027,8052,8125,8259,8281,8298,8323,8565,8621,8638,8655,8660,8663,8687,8689,8711,8759,8909,9031,9073,9157,9351,9365,9412,9481,9646,9673,9820,9853,9863,9948,10120,10126,10180,10184,10192,10202,10222,10247,10278,10289,10297,10351,10414,10439,10452,10479,10485,10519,10810,10827,10926,10971,10987,11034,11038,11045,11080,11101,11150,11171,11189,11230,11235,11293,11328,11335,11399,11425,11438,11611,11675,11719,11764,11826,11836,11848,11912,11919,11945,11951,11960,11992,12076,12092,12108,12176,12248,12321,12340,12415,12516,12525,12557,12584,12627,12657,12665,12672,12697,12723,12750,12758,12794,12804,12808,12857,12868,12912,13043,13055,13082,13162,13175,13190,13218,13242,13243,13306,13329,13358,13371,13410,13421,13460,13495,13511,13529,13543,13593,13600,13603,13613,13646,13695,13707,13709,13713,13715,13733,13758,13772,13808,13826,13831,13838,13911,13920,13926,13933,14050,14053,14054,14076,14096,14115,14147,14148,14200,14202,14249,14270,14282,14291,14470,14471,14486,14489,14521,14523,14555,14556,14639,14657,14661,14684,14694,14785,14796,14820,14841,14851,14949,14959,14980,14981,15051,15058,15122,15154,15161,15213,15215,15243,15245,15249,15269,15301,15326,15330,15354,15373,15411,15418,15475,15497,15498,15499,15582,15588,15632,15633,15787,15789,15842,15864,15900,15913,15926,15964,15979,16023,16059,16060,16086,16128,16145,16164,16168,16194,16199,16208,16235,16264,16283,16320,16327,16341,16342,16366,16373,16394,16405,16451,16460,16468,16507,16560,16659,16663,16664,16686,16829,16844,16877,16922,16965,16993,16996,17004,17005,17042,17048,17115,17125,17132,17183,17229,17243,17276,17277,17318,17322,17374,17392,17407,17411,17434,17438,17457,17459,17464,17470,17494,17517,17519,17541,17554,17557,17568,17596,17601,17633,17707,17715,17723,17730,17753,17776,17781,17815,17843,17846,17890,17901,17908,17912,17935,17953,17972,17993,18007,18046,18047,18048,18056,18069,18100,18134,18239,18244,18260,18281,18296,18311,18316,18352,18355,18368,18395,18408,18434,18436,18449,18492,18518,18539,18562,18563,18569,18592,18617,18627,18640,18648,18674,18680,18697,18722,18746,18764,18765,18790,18812,18823,18825,18886,18889,18896,18938,18951,18960,19006,19011,19029,19065,19073,19092,19109,19139,19195,19201,19208,19266,19290,19292,19304,19306,19313,19329,19346,19370,19415,19428,19429,19469,19490,19497,19510,19537,19542,19578,19590,19596,19621,19623,19645,19646,19662,19682,19700,19720,19741,19775,19789,19810,19883,19930,19951,19970,19971,19995,20029,20070,20075,20076,20164,20172,20195,20247,20274,20313,20347,20365,20378,20398,20407,20462,20496,20512,20534,20543,20621,20662,20684,20685,20701,20745,20747,20748,20783,20795,20809,20818,20840,20870,20888,20914,20939,20958,21054,21073,21106,21120,21141,21164,21171,21179,21219,21238,21248,21274,21286,21307,21310,21348,21373,21388,21407,21446,21499,21548,21552,21563,21568,21612,21635,21638,21645,21669,21675,21737,21763,21774,21851,21871,21886,21922,21923,21931,21939,21948,22001,22025,22029,22043,22065,22073,22110,22128,22177,22211,22223,22286,22294,22307,22319,22325,22336,22338,22352,22360,22387,22422,22487,22504,22533,22558,22594,22607,22648,22675,22686,22700,22702,22723,22741,22755,22770,22778,22849,22853,22861,22956,22996,23019,23028,23030,23044,23045,23063,23067,23073,23077,23079,23090,23128,23153,23163,23165,23220,23244,23255,23284,23303,23323,23330,23341,23366,23375,23382,23386,23415,23418,23424,23436,23441,23443,23487,23518,23524,23534,23545,23575,23635,23660,23672,23673,23706,23708,23735,23737,23749,23764,23819,23822,23856,23913,23950,23960,23987,23994,24006,24063,24084,24142,24176,24184,24223,24273,24276,24289,24293,24325,24332,24347,24357,24419,24475,24495,24550,24612,24636,24638,24642,24646,24665,24675,24682,24687,24698,24702,24717,24733,24767,24769,24770,24812,24828,24858,24863,24877,24902,24947,24987,25011,25012,25039,25041,25048,25056,25125,25162,25208,25248,25250,25263,25279,25280,25301,25312,25313,25394,25397,25442,25528,25548,25567,25608,25696,25725,25763,25799,25882,25923,25932,25945,26031,26048,26078,26178,26255,26287,26317,26423,26543,26574,26765,26824,26861,26928,26938,27014,27024,27056,27130,27152,27283,27319,27362,27365,27394,27482,27517,27575,27833,27920,27938,28005,28020,28033,28192,28318,28436,28559,28561,28607,28608,28640,28646,28677,28692,28763,28765,28837,28961,28992,29012,29032,29066,29067,29180,29244,29329,29443,29461,29475,29486,29559,29832,30326,30481,31853,33270,34998,35594,35726,35884,36602,36798,36821,36834,37915,39283,39464,39650,39998,40110,40147,40490,40515,40545,41035,41058,41069,41082,41184,41292,41305)
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 | 975 | 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.80 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 2.36 ms |
preparing | 1.21 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.56 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.06 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 |