Tiempo de la consulta: 7.77 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.379 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 14:31:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 14:31:37')
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,11,23,72,138,141,255,263,295,296,301,302,307,332,353,354,356,357,358,359,360,361,363,364,373,460,466,477,500,522,583,655,686,723,756,757,826,828,841,965,986,996,1020,1045,1051,1067,1080,1090,1120,1133,1143,1198,1207,1214,1237,1264,1308,1323,1324,1335,1336,1363,1386,1533,1556,1557,1587,1718,1720,1745,2105,2107,2108,2109,2156,2272,2282,2304,2322,2342,2571,2573,2610,2630,2721,2767,2799,2858,2907,2925,2939,2964,2983,3039,3103,3132,3145,3169,3294,3353,3354,3396,3442,3463,3476,3570,3617,3673,3682,3715,3761,3834,3974,3984,4030,4114,4200,4221,4285,4306,4310,4326,4370,4378,4422,4680,4698,4874,5026,5091,5136,5160,5182,5192,5203,5278,5302,5313,5365,5373,5386,5451,5484,5530,5537,5579,5597,5616,5647,5659,5666,5729,5730,5731,5784,5798,5846,5849,5874,5894,5896,5934,6350,6389,6470,6498,6514,6516,6531,6539,6541,6542,6543,6573,6575,6601,6608,6645,6665,6688,6690,6727,6730,6799,6802,6833,6854,6925,6933,6939,6942,6965,7014,7026,7027,7029,7052,7069,7105,7124,7135,7138,7139,7156,7162,7163,7164,7191,7192,7200,7244,7251,7264,7284,7336,7339,7340,7343,7365,7380,7384,7387,7401,7402,7411,7419,7420,7421,7436,7437,7447,7450,7453,7556,7588,7616,7621,7624,7627,7629,7679,7718,7719,7725,7730,7741,7751,7753,7758,7776,7799,7831,7837,7840,7850,7852,7854,7866,7889,7950,7965,7986,8027,8038,8045,8058,8067,8089,8090,8093,8096,8258,8259,8271,8338,8354,8377,8386,8397,8417,8430,8441,8497,8525,8528,8555,8566,8567,8580,8617,8638,8666,8759,8823,8860,8903,8909,8974,9029,9304,9318,9326,9552,9616,9673,9750,9801,9854,9886,9918,9924,9956,10023,10030,10033,10078,10114,10160,10162,10163,10169,10226,10239,10263,10272,10274,10298,10314,10316,10345,10379,10380,10416,10443,10453,10484,10503,10512,10554,10572,10601,10607,10661,10665,10686,10738,10768,10771,10868,10964,10980,10989,11001,11029,11030,11057,11152,11191,11194,11204,11219,11250,11253,11265,11299,11320,11408,11417,11427,11440,11441,11446,11523,11542,11553,11678,11714,11716,11730,11754,11806,11828,11835,11857,11948,11954,12011,12019,12031,12078,12116,12117,12125,12171,12193,12224,12259,12309,12318,12367,12546,12563,12571,12605,12620,12624,12625,12628,12670,12678,12685,12686,12692,12708,12737,12791,12811,12856,12871,12872,12902,12933,12973,12989,13016,13017,13019,13140,13224,13239,13246,13312,13323,13334,13344,13349,13350,13444,13452,13456,13463,13488,13516,13542,13551,13571,13602,13604,13615,13618,13645,13653,13806,13851,13861,13874,13900,13916,13990,14000,14074,14141,14152,14153,14180,14192,14205,14219,14224,14227,14243,14246,14249,14263,14266,14267,14269,14280,14292,14371,14375,14382,14385,14401,14460,14491,14508,14516,14591,14601,14613,14624,14632,14638,14665,14693,14701,14708,14751,14754,14760,14795,14819,14830,14837,14846,14849,14850,14945,14992,15048,15055,15074,15079,15080,15094,15108,15147,15174,15214,15217,15232,15268,15273,15278,15281,15347,15351,15353,15372,15378,15426,15440,15475,15486,15493,15494,15520,15561,15579,15582,15606,15632,15639,15667,15677,15712,15714,15717,15726,15739,15750,15835,15885,15896,15899,15904,15939,15949,15952,16022,16038,16062,16087,16089,16091,16156,16200,16216,16236,16258,16267,16286,16297,16303,16305,16313,16322,16337,16366,16386,16390,16414,16430,16472,16486,16497,16541,16564,16571,16609,16621,16623,16646,16671,16673,16714,16723,16742,16780,16790,16808,16809,16813,16816,16818,16863,16866,16903,16928,16943,16963,16998,17000,17038,17039,17066,17069,17088,17090,17092,17116,17126,17132,17142,17148,17191,17209,17222,17224,17230,17234,17266,17275,17282,17290,17307,17321,17344,17361,17363,17381,17391,17405,17406,17411,17422,17426,17431,17442,17496,17500,17571,17573,17611,17627,17630,17661,17679,17699,17708,17710,17715,17734,17735,17777,17783,17812,17817,17839,17846,17869,17882,17889,17947,18008,18009,18079,18097,18109,18122,18128,18142,18176,18181,18187,18216,18220,18226,18229,18249,18253,18260,18264,18279,18295,18308,18316,18318,18332,18360,18362,18388,18406,18419,18421,18424,18429,18452,18453,18494,18498,18509,18520,18522,18552,18554,18556,18588,18598,18605,18625,18652,18653,18666,18668,18675,18689,18698,18699,18700,18718,18750,18775,18801,18807,18816,18822,18826,18845,18856,18861,18864,18904,18908,18912,18945,18953,18982,18985,18988,18989,18995,19000,19007,19010,19018,19022,19024,19027,19040,19056,19059,19086,19110,19135,19145,19181,19189,19191,19217,19226,19260,19261,19272,19282,19291,19292,19303,19304,19364,19367,19368,19370,19388,19404,19427,19437,19449,19462,19496,19504,19507,19527,19571,19580,19581,19604,19624,19626,19652,19655,19657,19659,19677,19705,19774,19807,19818,19826,19856,19857,19873,19883,19903,19913,19918,19919,19921,19940,19946,19948,19950,19951,19972,19973,19978,19980,20001,20006,20010,20018,20020,20024,20033,20039,20043,20056,20089,20105,20115,20180,20184,20186,20194,20217,20226,20232,20234,20237,20254,20277,20294,20304,20312,20327,20354,20356,20359,20370,20371,20388,20394,20402,20426,20431,20440,20458,20467,20488,20498,20513,20523,20525,20529,20539,20546,20551,20559,20564,20579,20596,20608,20626,20647,20672,20677,20681,20721,20736,20744,20749,20757,20777,20784,20803,20823,20837,20865,20866,20870,20906,20919,20946,20947,20986,20988,21004,21007,21011,21049,21074,21087,21094,21095,21110,21116,21118,21123,21135,21151,21158,21160,21167,21183,21194,21202,21231,21252,21255,21263,21272,21283,21294,21301,21339,21368,21376,21380,21384,21390,21394,21401,21416,21419,21422,21427,21491,21493,21505,21510,21512,21520,21529,21534,21556,21575,21583,21589,21633,21659,21664,21692,21701,21711,21721,21727,21732,21733,21735,21740,21765,21816,21836,21851,21878,21888,21907,21912,21947,21998,21999,22012,22015,22020,22026,22027,22030,22035,22062,22071,22081,22100,22103,22114,22117,22122,22140,22144,22149,22164,22174,22177,22178,22185,22205,22206,22216,22222,22225,22228,22251,22254,22263,22273,22277,22283,22298,22305,22312,22317,22323,22324,22343,22351,22359,22382,22383,22404,22412,22415,22416,22421,22430,22452,22476,22496,22502,22528,22543,22555,22605,22651,22669,22682,22696,22698,22706,22713,22724,22726,22747,22750,22804,22820,22835,22841,22877,22883,22890,22898,22900,22917,22919,22974,22979,22985,23000,23002,23014,23028,23053,23072,23076,23089,23112,23118,23181,23189,23201,23209,23240,23249,23263,23294,23299,23304,23306,23307,23328,23355,23365,23367,23369,23378,23393,23401,23428,23430,23444,23446,23458,23476,23546,23586,23615,23616,23633,23648,23665,23668,23676,23689,23693,23698,23709,23719,23732,23757,23770,23786,23806,23825,23863,23883,23895,23898,23917,23941,23951,23957,23965,23994,23996,24020,24021,24025,24033,24060,24064,24086,24099,24114,24127,24135,24155,24164,24248,24297,24305,24332,24346,24356,24388,24423,24471,24484,24505,24523,24536,24547,24559,24563,24571,24573,24574,24576,24580,24615,24635,24641,24667,24680,24684,24689,24706,24709,24710,24721,24754,24756,24785,24790,24807,24812,24822,24832,24883,24889,24953,24996,25007,25022,25048,25062,25079,25099,25100,25105,25111,25120,25147,25170,25175,25176,25184,25188,25215,25273,25274,25278,25288,25297,25315,25322,25330,25332,25348,25361,25383,25394,25411,25420,25428,25452,25463,25471,25477,25486,25497,25498,25500,25514,25524,25539,25560,25580,25584,25603,25640,25648,25650,25657,25671,25672,25676,25680,25681,25694,25696,25697,25699,25711,25724,25755,25764,25790,25799,25807,25813,25820,25821,25847,25859,25864,25884,25907,25908,25935,25947,25948,25954,25955,25958,25967,25971,26030,26043,26064,26117,26119,26133,26134,26177,26193,26204,26205,26221,26225,26230,26239,26240,26250,26292,26360,26366,26409,26431,26456,26469,26480,26507,26508,26529,26535,26541,26543,26559,26571,26582,26595,26596,26603,26605,26634,26639,26651,26664,26678,26685,26709,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26769,26801,26809,26810,26818,26859,26860,26896,26923,26937,26947,26976,26991,27025,27028,27045,27056,27057,27060,27082,27097,27143,27155,27170,27189,27248,27260,27261,27262,27318,27364,27372,27406,27417,27454,27478,27512,27518,27541,27544,27567,27571,27589,27591,27624,27628,27634,27644,27677,27737,27738,27743,27763,27789,27811,27822,27846,27930,27948,27957,27985,27998,28006,28036,28046,28049,28120,28135,28163,28184,28240,28256,28309,28320,28328,28342,28360,28361,28460,28465,28472,28616,28620,28627,28662,28675,28680,28681,28682,28683,28690,28702,28710,28755,28781,28844,28847,28852,28916,28944,29023,29064,29123,29129,29133,29241,29249,29250,29379,29389,29413,29417,29438,29533,29571,29590,29608,29618,29646,29727,29799,29890,29904,30050,30318,30482,30656,30790,31623,31624,32374,34290,34316,34384,34385,34432,34451,34470,34531,34645,34653,34750,34804,34813,35196,35571,35590,35645,35869,35871,36232,36234,36302,36323,36476,36477,36543,37426,37602,38079,38131,38206,38602,38666,38713,38910,39088,39128,39183,39204,39286,39370,39411,39433,39507,39625,39761,39926,40116,40238,40311,40352,40404,40540,40583,40661,40720,40727,40860,40865,40887,41013,41140,41158,41200,41217,41298,41354,41363,41421,41456,41486,41543,41662,41695,41696,41779,41853,41911,41993,42009,42044,42080,42094,42187,42274,42395,42412,42486,42531,42651,42676,42730,42745,42758,42797,42932,42950,43068,43152,43153,43213,43214,43215,43488,43576,43595,43685,43765,43988,44142,44916,45001,45069)
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 | 1575 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 3.26 ms |
preparing | 2.05 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.57 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.09 ms |
cleaning up | 0.04 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 |