Tiempo de la consulta: 6.04 ms Después de la última consulta: 1.23 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.242 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 12:08:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 12:08:29')
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,23,45,46,54,62,65,71,129,415,466,643,659,675,764,844,879,900,1335,1337,1372,1497,1557,1563,1571,1720,1987,2026,2064,2084,2103,2109,2219,2224,2298,2304,2325,2404,2426,2439,2563,2573,2613,2767,2799,2827,2831,2857,2909,2914,2921,2924,2933,2934,2946,2953,3034,3037,3038,3196,3248,3266,3285,3462,3533,3570,3591,3617,3620,3682,3685,3715,3760,3767,3776,3833,3913,3960,3974,4030,4034,4078,4101,4110,4114,4129,4148,4150,4204,4209,4255,4284,4285,4306,4310,4323,4327,4387,4423,4456,4459,4548,4573,4575,4735,4767,4813,4859,4940,4944,5026,5219,5259,5387,5422,5458,5484,5530,5537,5849,5851,5874,5909,5932,5934,5971,5977,6015,6100,6105,6128,6340,6360,6362,6440,6561,6608,6629,6644,6649,6663,6685,6720,6736,6743,6791,6801,6815,6833,6842,6865,6881,6906,6925,6933,6995,7019,7029,7036,7042,7045,7077,7111,7162,7163,7164,7216,7250,7251,7258,7264,7282,7311,7331,7343,7359,7364,7412,7436,7439,7444,7447,7486,7490,7586,7605,7614,7618,7651,7679,7724,7752,7771,7784,7787,7816,7821,7840,7854,7903,7925,7935,7942,7987,8004,8045,8055,8096,8152,8160,8216,8227,8234,8265,8370,8378,8397,8408,8421,8430,8431,8441,8476,8497,8507,8550,8555,8567,8611,8614,8644,8660,8691,8700,8750,8753,8799,8813,8820,8826,8864,8903,8925,8945,8954,8956,9027,9036,9063,9069,9101,9120,9194,9304,9317,9326,9328,9346,9350,9354,9359,9390,9415,9477,9533,9578,9593,9600,9610,9657,9673,9738,9826,9829,9836,9838,9847,9878,9904,9908,9922,9956,10004,10033,10160,10163,10169,10190,10265,10269,10272,10286,10313,10379,10393,10414,10443,10448,10453,10484,10512,10513,10554,10607,10617,10642,10661,10666,10713,10754,10756,10760,10769,10771,10993,11023,11031,11034,11041,11073,11100,11121,11170,11250,11286,11320,11337,11338,11387,11417,11427,11438,11488,11545,11553,11687,11716,11796,11821,11828,11872,11916,11921,11949,12019,12076,12114,12117,12139,12249,12312,12410,12440,12553,12567,12632,12638,12689,12690,12692,12933,13019,13115,13146,13166,13188,13190,13209,13262,13276,13312,13323,13334,13351,13361,13376,13384,13385,13388,13456,13496,13551,13574,13604,13633,13659,13702,13731,13738,13760,13789,13828,13911,13926,13946,13961,13996,14057,14109,14141,14180,14246,14266,14341,14351,14375,14396,14408,14409,14413,14454,14491,14512,14513,14515,14532,14601,14613,14616,14624,14632,14662,14693,14695,14696,14701,14730,14739,14751,14760,14819,14820,14824,14825,14939,14966,14999,15004,15006,15034,15041,15048,15069,15074,15081,15088,15094,15148,15149,15155,15160,15164,15178,15193,15214,15232,15268,15273,15276,15281,15326,15330,15346,15347,15351,15388,15423,15426,15451,15457,15465,15474,15475,15482,15487,15497,15551,15570,15574,15582,15611,15617,15635,15636,15637,15640,15641,15668,15677,15726,15738,15750,15764,15767,15779,15783,15866,15913,15949,15953,16036,16038,16039,16042,16059,16062,16082,16084,16097,16111,16127,16128,16129,16156,16168,16170,16181,16236,16248,16256,16280,16292,16302,16305,16314,16315,16322,16366,16403,16430,16486,16495,16497,16507,16552,16564,16571,16577,16623,16673,16705,16742,16759,16827,16828,16890,16903,16963,16991,17053,17066,17074,17088,17102,17112,17115,17145,17153,17160,17184,17191,17216,17222,17231,17233,17266,17287,17389,17406,17411,17425,17431,17468,17495,17633,17650,17671,17704,17715,17752,17844,17846,17855,17859,17893,17901,17917,17926,17950,17966,17968,18008,18054,18062,18109,18122,18128,18150,18157,18161,18180,18233,18255,18274,18292,18294,18314,18344,18362,18453,18460,18539,18544,18564,18608,18610,18625,18655,18666,18667,18689,18698,18699,18709,18718,18768,18800,18846,18862,18864,18878,18888,18916,18922,18931,18954,18975,18980,18985,19000,19028,19034,19042,19051,19064,19105,19111,19124,19128,19135,19155,19191,19218,19233,19240,19247,19248,19310,19313,19366,19368,19403,19475,19504,19530,19550,19561,19571,19580,19604,19626,19637,19652,19705,19708,19711,19713,19732,19754,19807,19818,19846,19847,19852,19869,19872,19903,19918,19919,19945,19946,19948,19951,19973,19978,20020,20030,20049,20089,20091,20105,20120,20127,20168,20186,20226,20250,20260,20264,20294,20297,20312,20327,20336,20348,20359,20371,20376,20388,20393,20429,20431,20444,20458,20461,20498,20506,20513,20523,20556,20596,20602,20608,20649,20655,20672,20678,20685,20687,20721,20741,20777,20779,20784,20794,20797,20809,20813,20818,20828,20845,20850,20870,20906,20915,20959,20985,21000,21057,21062,21074,21107,21108,21110,21135,21143,21157,21160,21161,21183,21190,21231,21244,21249,21297,21325,21339,21369,21381,21397,21420,21434,21435,21458,21464,21489,21505,21510,21512,21537,21540,21552,21554,21578,21590,21641,21662,21710,21713,21733,21740,21744,21764,21765,21776,21777,21816,21831,21855,21856,21858,21861,21865,21878,21883,21894,21905,21931,21944,21947,21973,21976,21982,22010,22012,22027,22040,22051,22058,22063,22089,22114,22122,22144,22160,22176,22185,22205,22214,22216,22237,22238,22250,22254,22259,22273,22277,22298,22305,22312,22313,22317,22347,22348,22383,22407,22430,22457,22459,22460,22461,22479,22532,22553,22561,22571,22582,22605,22617,22640,22644,22645,22647,22656,22706,22708,22711,22717,22724,22733,22739,22745,22763,22775,22819,22837,22877,22883,22889,22890,22904,22910,22942,22957,22978,23045,23049,23060,23065,23067,23076,23112,23131,23185,23188,23189,23195,23201,23209,23237,23241,23260,23263,23280,23286,23306,23307,23313,23320,23325,23326,23328,23335,23339,23365,23367,23393,23436,23444,23458,23488,23503,23582,23612,23678,23679,23689,23698,23706,23709,23770,23783,23786,23830,23883,23890,23895,23917,23941,23957,23988,23994,24012,24020,24064,24075,24086,24102,24104,24114,24138,24152,24191,24219,24273,24274,24289,24295,24297,24327,24332,24348,24366,24371,24392,24423,24471,24503,24536,24550,24557,24559,24571,24574,24576,24592,24614,24635,24636,24641,24644,24658,24680,24684,24687,24689,24716,24727,24733,24735,24756,24760,24765,24807,24812,24816,24817,24822,24837,24844,24860,24899,24903,24930,24964,25022,25060,25072,25078,25098,25107,25111,25125,25133,25166,25174,25176,25206,25215,25225,25253,25261,25273,25274,25297,25308,25332,25348,25361,25377,25380,25394,25425,25452,25477,25560,25561,25567,25580,25603,25644,25645,25650,25657,25671,25672,25676,25677,25680,25681,25696,25697,25699,25711,25714,25717,25724,25730,25738,25755,25778,25785,25793,25795,25799,25807,25814,25820,25847,25850,25872,25884,25887,25907,25908,25935,25938,25945,25946,25947,25948,25958,25967,25971,25993,26030,26031,26041,26052,26064,26119,26133,26146,26173,26177,26178,26183,26193,26205,26225,26230,26239,26250,26256,26273,26292,26302,26409,26414,26431,26456,26493,26501,26504,26507,26508,26521,26529,26540,26541,26543,26559,26563,26571,26582,26596,26605,26648,26651,26664,26678,26685,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26859,26860,26896,26901,26926,26937,26961,26972,26976,26991,27002,27011,27022,27025,27028,27045,27056,27060,27082,27097,27147,27150,27155,27170,27246,27248,27261,27272,27273,27304,27318,27321,27373,27417,27418,27431,27478,27496,27512,27521,27544,27545,27565,27567,27575,27589,27591,27593,27634,27644,27686,27704,27721,27737,27738,27745,27748,27763,27789,27802,27811,27822,27842,27917,27930,27931,27936,27945,27948,27957,27998,28005,28006,28033,28036,28045,28047,28082,28135,28184,28225,28250,28309,28312,28320,28342,28360,28361,28398,28411,28431,28460,28472,28620,28639,28653,28658,28675,28690,28702,28748,28755,28785,28852,28916,28920,28949,28989,29008,29009,29023,29026,29099,29123,29129,29139,29152,29153,29157,29174,29197,29224,29241,29249,29250,29319,29356,29413,29417,29438,29443,29444,29476,29533,29536,29608,29618,29781,29790,29799,29868,29890,29904,29905,29911,29922,29923,29935,32374,32768,32842,33082,34007,34432,34451,34653,34750,35196,35617,35645,35689,35871,35883,35885,36367,37426,38666,38807,38831,38850,38854,38866,39286,39481,39558,39603,39681,39761,39766,39857,39892,39893,39979,40025,40038,40083,40097,40170,40200,40272,40661,40708,40727,40759,40785,40809,40860,40887,40907,40937,40984,41059,41122,41158,41200,41217,41255,41257,41301,41325,41375,41421,42486,42758)
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 | 1369 | 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.74 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.17 ms |
preparing | 1.30 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.86 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |