Tiempo de la consulta: 3.88 ms Después de la última consulta: 0.82 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 07:38:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 07:38:32')
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(57,113,114,119,283,377,771,831,863,871,878,928,1169,1170,1178,1273,1322,1381,1383,1478,1559,1579,1596,1621,1690,1691,1718,1738,1756,1760,1782,1954,2082,2125,2425,2433,2530,2595,2667,2720,2740,2764,2765,2870,2894,2898,2922,2974,2975,3024,3097,3129,3258,3273,3290,3305,3332,3350,3446,3468,3473,3523,3589,3609,3613,3618,3634,3657,3774,3785,3930,3948,3951,3952,4008,4068,4069,4088,4305,4357,4451,4468,4560,4577,4627,4745,4784,4792,4853,4857,4896,4929,4988,4992,5063,5113,5162,5175,5186,5191,5214,5281,5285,5469,5515,5561,5578,5581,5969,5972,6039,6121,6176,6211,6215,6216,6298,6403,6445,6459,6482,6554,6709,6733,6766,6802,6856,7001,7121,7209,7253,7374,7378,7456,7488,7491,7584,7670,7774,7953,7967,8037,8040,8087,8238,8249,8312,8427,8487,8538,8569,8626,8838,8886,8895,8983,9017,9201,9203,9256,9262,9369,9574,9749,9818,9942,9993,10092,10099,10100,10141,10149,10165,10168,10181,10262,10370,10468,10471,10483,10489,10856,10860,10970,11082,11094,11112,11147,11241,11285,11292,11788,11805,11996,12019,12153,12223,12257,12630,12715,12887,12948,12962,13002,13006,13079,13152,13188,13211,13489,13493,13557,13685,13705,13706,13900,14024,14250,14261,14310,14320,14386,14401,14426,14435,14537,14759,15038,15287,15324,15368,15484,15744,15782,15794,15973,16155,16262,16394,16410,16594,16624,16695,16717,16748,16814,16846,16862,16908,16917,17014,17055,17063,17136,17140,17169,17172,17176,17194,17234,17242,17361,17363,17368,17381,17386,17400,17437,17539,17575,17584,17586,17598,17629,17630,17643,17644,17645,17663,17680,17691,17699,17700,17737,17748,17749,17785,17798,17823,17862,17876,17886,17905,17946,17965,17976,17977,18006,18021,18034,18035,18036,18084,18151,18168,18171,18184,18191,18192,18241,18253,18259,18308,18327,18347,18354,18376,18383,18413,18426,18427,18446,18447,18473,18490,18491,18497,18500,18540,18575,18596,18601,18626,18635,18638,18697,18746,18751,18780,18790,18795,18801,18828,18868,18917,18918,18999,19005,19018,19031,19079,19082,19134,19168,19192,19260,19267,19288,19301,19306,19310,19320,19327,19345,19364,19390,19397,19429,19432,19445,19454,19465,19484,19495,19531,19561,19594,19659,19684,19696,19710,19723,19729,19741,19751,19815,19824,19832,19834,19845,19862,19876,19939,19982,19988,19989,20017,20033,20042,20045,20086,20097,20128,20150,20151,20176,20177,20187,20188,20190,20193,20211,20213,20239,20264,20277,20298,20307,20310,20340,20343,20391,20392,20401,20410,20411,20421,20442,20481,20484,20550,20567,20570,20572,20601,20627,20630,20656,20681,20705,20709,20713,20714,20727,20735,20752,20760,20778,20805,20808,20813,20830,20865,20871,20881,20898,20907,20910,20920,20925,20954,20973,20990,21002,21009,21012,21021,21029,21033,21042,21047,21050,21059,21069,21080,21086,21090,21096,21107,21132,21134,21159,21168,21169,21204,21262,21273,21288,21305,21390,21397,21410,21466,21474,21485,21486,21491,21497,21502,21504,21543,21547,21560,21563,21574,21581,21593,21618,21640,21641,21650,21653,21660,21670,21683,21688,21690,21698,21699,21738,21764,21787,21800,21810,21823,21837,21853,21899,21902,21926,21947,21960,21976,21977,22015,22017,22028,22033,22034,22037,22050,22073,22081,22085,22100,22112,22162,22164,22180,22204,22219,22242,22278,22281,22290,22292,22305,22321,22353,22394,22405,22436,22502,22514,22522,22544,22545,22590,22606,22623,22646,22658,22689,22707,22716,22737,22745,22757,22759,22813,22816,22838,22881,22894,22968,22970,22971,22991,22997,23003,23017,23035,23051,23063,23070,23076,23085,23095,23097,23117,23132,23135,23136,23168,23176,23201,23208,23216,23217,23228,23238,23239,23257,23280,23282,23295,23302,23317,23320,23323,23345,23348,23349,23351,23352,23383,23396,23402,23420,23467,23486,23512,23528,23555,23556,23560,23567,23571,23582,23605,23609,23631,23649,23662,23672,23680,23681,23682,23685,23712,23727,23772,23797,23799,23800,23806,23811,23813,23814,23815,23826,23847,23851,23854,23945,23951,23953,23961,23963,23975,23999,24032,24045,24055,24095,24112,24120,24127,24139,24165,24169,24189,24203,24204,24206,24213,24223,24244,24245,24246,24307,24328,24333,24368,24385,24401,24410,24414,24425,24426,24481,24483,24502,24513,24539,24549,24560,24566,24583,24628,24644,24651,24681,24694,24730,24750,24796,24800,24809,24824,24848,24859,24861,24865,24877,24878,24896,24925,24941,24966,24967,24969,24973,24977,24982,25003,25021,25025,25031,25053,25057,25061,25089,25109,25118,25127,25129,25155,25171,25210,25243,25287,25296,25351,25369,25372,25378,25396,25399,25407,25424,25436,25440,25445,25458,25460,25517,25520,25523,25524,25525,25528,25535,25536,25541,25551,25552,25568,25582,25591,25596,25649,25678,25702,25775,25779,25781,25813,25844,25874,25925,25941,25962,25983,26033,26044,26082,26135,26147,26164,26172,26187,26201,26232,26241,26242,26271,26283,26296,26318,26320,26351,26354,26362,26366,26447,26478,26588,26613,26694,26734,26769,26796,26814,26871,26902,26999,27048,27119,27124,27139,27156,27162,27175,27180,27184,27188,27197,27200,27215,27221,27242,27252,27302,27330,27342,27351,27412,27425,27445,27455,27463,27479,27529,27551,27581,27619,27622,27685,27765,27803,27806,27818,27854,27860,27875,27886,27913,27929,27958,27965,28002,28030,28117,28281,28305,28328,28383,28409,28429,28458,28504,28545,28555,28625,28683,28691,28703,28919,29013,29108,29159,29242,29298,29320,29619,31623,31624,31651,31876,32679,34177,34205,34417,34489,34639,34690,34717,34888,35000,35300,35657,35676,35715,35782,35798,35834,35861,35886,35891,35922,35936,35941,35959,36140,36267,36298,36499,36611,36737,36813,36990,37158,38213,38961,39321,39752,40072,40189,40362,40370,40584,40902,41089,41185,41868,42344,42899,42900,42908,43581,43906,43921,44143,44478,44682,44830,45178)
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 | 958 | 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.47 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.49 ms |
preparing | 0.74 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.01 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 |