Tiempo de la consulta: 4.51 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.183 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 10:12:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 10:12:36')
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(12,29,39,355,495,535,546,675,740,844,900,918,959,977,991,1011,1029,1039,1089,1095,1123,1158,1195,1249,1308,1337,1363,1372,1456,1497,1557,1748,1794,1935,2026,2064,2071,2103,2223,2224,2242,2282,2288,2308,2325,2379,2404,2426,2445,2456,2479,2525,2563,2625,2647,2762,2815,2842,2843,2856,2857,2888,2895,2916,2924,2934,2946,3038,3084,3152,3159,3161,3207,3248,3276,3285,3291,3361,3396,3462,3498,3533,3591,3620,3700,3780,3812,3814,3980,4038,4114,4200,4233,4255,4284,4315,4333,4446,4459,4531,4580,4735,4767,4813,5187,5211,5219,5373,5458,5479,5484,5530,5537,5616,5851,5854,5896,5932,5934,5971,5977,6003,6106,6119,6232,6340,6351,6480,6534,6561,6629,6684,6685,6736,6743,6791,6801,6804,6833,6842,6906,6969,6995,7045,7071,7169,7181,7282,7343,7412,7436,7439,7443,7447,7457,7466,7490,7510,7516,7544,7676,7679,7688,7700,7728,7733,7752,7805,7825,7930,7954,7960,8005,8045,8159,8216,8289,8311,8370,8385,8399,8431,8441,8559,8615,8660,8680,8820,8915,8945,9036,9101,9143,9162,9191,9217,9303,9359,9415,9435,9525,9584,9649,9652,9745,9746,9802,9826,9834,9836,9854,9861,10033,10124,10184,10258,10265,10297,10304,10320,10435,10452,10453,10484,10508,10522,10532,10554,10661,10668,10713,10760,10769,10819,11004,11035,11076,11142,11149,11170,11256,11262,11277,11304,11416,11417,11429,11821,11859,11872,11891,12019,12114,12139,12218,12527,12549,12642,12655,12692,12763,12950,13019,13039,13190,13262,13276,13311,13334,13404,13574,13604,13659,13733,13921,14057,14077,14079,14105,14141,14180,14266,14282,14454,14525,14613,14616,14624,14632,14692,14696,14701,14751,14760,14767,14816,14898,14919,15015,15074,15111,15137,15149,15214,15243,15273,15314,15330,15334,15340,15346,15351,15425,15426,15430,15475,15497,15565,15574,15582,15626,15635,15668,15680,15725,15726,15750,15862,15875,15900,15949,15964,15973,16038,16060,16062,16128,16168,16174,16236,16270,16280,16301,16305,16324,16337,16343,16495,16498,16522,16571,16632,16651,16671,16742,16811,16824,16827,16841,16913,16963,16988,17042,17062,17092,17130,17138,17184,17218,17222,17277,17280,17364,17389,17398,17401,17427,17444,17486,17533,17578,17605,17625,17671,17704,17706,17715,17732,17747,17793,17813,17837,17846,17901,17920,17937,17998,18008,18009,18099,18109,18128,18150,18155,18183,18228,18247,18274,18328,18347,18350,18495,18528,18554,18570,18584,18610,18614,18625,18678,18692,18699,18718,18768,18771,18826,18914,18951,18961,19000,19001,19020,19051,19061,19064,19077,19193,19194,19223,19233,19270,19323,19351,19355,19368,19404,19475,19486,19493,19571,19613,19624,19690,19764,19807,19818,19911,19918,19920,19930,19934,19945,19946,19949,19951,19956,19995,20000,20018,20120,20174,20304,20326,20327,20361,20431,20441,20476,20498,20524,20556,20608,20632,20635,20655,20671,20672,20718,20777,20784,20809,20849,20870,20878,20893,20945,21074,21160,21170,21231,21253,21294,21297,21420,21468,21505,21510,21512,21529,21536,21537,21555,21637,21672,21733,21739,21865,21878,21906,22027,22051,22066,22082,22127,22141,22171,22193,22216,22238,22250,22254,22273,22274,22277,22283,22317,22320,22328,22347,22383,22468,22508,22553,22563,22566,22571,22605,22656,22688,22706,22711,22770,22775,22877,22883,23012,23076,23130,23141,23144,23148,23188,23189,23202,23209,23286,23307,23314,23441,23494,23568,23575,23606,23611,23612,23689,23698,23724,23769,23770,23778,23786,23837,23883,23895,23899,23911,23994,24064,24113,24116,24219,24274,24282,24289,24328,24559,24574,24576,24614,24623,24641,24667,24683,24687,24746,24760,24860,24863,24932,24958,25060,25069,25174,25273,25274,25285,25374,25443,25567,25608,25621,25671,25696,25703,25717,25724,25799,25847,25947,26030,26031,26041,26064,26146,26177,26319,26435,26471,26507,26508,26535,26563,26582,26818,26829,26840,26860,26937,27011,27022,27060,27125,27156,27161,27174,27190,27214,27248,27272,27283,27295,27304,27318,27478,27497,27512,27577,27589,27613,27745,27836,27930,27945,27983,28006,28018,28140,28167,28184,28250,28344,28398,28431,28702,28780,29129,29224,29345,29438,29533,29560,29603,29620,29671,29715,29790,29818,29914,31207,32374,34089,34126,34163,34257,34321,34500,34559,34653,34750,34781,34782,34793,34804,34838,34895,35055,35103,35176,35184,35359,35435,35452,35484,35492,35523,35545,35623,35841,35869,35872,35899,35962,35967,35975,35980,36033,36135,36154,36232,36234,36281,36367,36398,36402,36461,36476,36490,36583,36615,36680,36803,36815,36831,36896,36897,36945,37284,37290,37345,37353,37371,37397,37401,37426,37602,37618,37642,37717,37837,37880,37906,37907,38023,38079,38131,38226,38237,38323,38352,38393,38448,38451,38549,38574,38602,38624,38666,38713,38850,38899,38920,38984,38991,39008,39088,39135,39183,39214,39277,39286,39308,39370,39411,39507,39511,39520,39558,39580,39598,39634,39677,39737,39761,39801,39816,39879,39892,40007,40120,40194,40211,40251,40272,40279,40311,40326,40365,40375,40436,40531,40585,40594,40603,40640,40720,40727,40739,40761,40773,40775,40778,40785,40803,40808,40829,40860,40887,40937,40941,40973,41007,41048,41122,41140,41153,41158,41163,41200,41217,41299,41380,41381,41421,41475,41522,41543,41566,41619,41622,41636,41687,41695,41696,41747,41761,41779,41816,41826,41840,41853,41876,41911,41993,42021,42080,42159,42187,42259,42274,42331,42367,42368,42412,42486,42500,42531,42563,42571,42591,42651,42676,42680,42701,42730,42758,42766,42789,42797,42852,42891,42944,43068,43330,43488,43529,43554,43569,43570,43571,43592,43609,43653,43678,43755,43815,43816,43856,43972,43973,43988,44142,44143,44160,44185,44224,44270,44469,44618,44809,44843,44868,44933,44998,45276)
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 | 945 | 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.46 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.45 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.01 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 |