Tiempo de la consulta: 4.73 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.360 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-08 14:47:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 14:47: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(11,25,49,58,72,75,138,141,147,148,149,150,151,152,153,154,155,234,260,263,332,373,385,389,437,458,495,522,583,663,686,723,757,799,813,826,828,836,841,844,868,956,970,986,996,1018,1053,1091,1133,1139,1185,1186,1207,1233,1277,1298,1323,1463,1503,1587,1725,1817,1835,1893,1898,2107,2150,2178,2192,2194,2201,2202,2204,2222,2232,2246,2249,2272,2285,2299,2319,2409,2419,2610,2713,2827,2857,2858,2925,2964,3020,3054,3209,3210,3322,3353,3354,3452,3476,3519,3604,3692,3700,3732,3931,3932,3986,4013,4076,4169,4188,4204,4229,4254,4281,4405,4670,4677,4680,4698,4910,4920,4980,4982,5060,5085,5138,5160,5189,5192,5300,5313,5435,5461,5516,5525,5666,5730,5825,5846,5894,5896,6362,6389,6407,6470,6484,6492,6493,6498,6531,6539,6575,6586,6616,6633,6654,6688,6716,6725,6726,6730,6744,6749,6785,6799,6802,6905,6911,6915,6942,6955,6965,6971,6989,7014,7050,7052,7069,7101,7124,7128,7156,7200,7244,7275,7285,7288,7296,7312,7326,7328,7335,7336,7339,7340,7396,7411,7420,7421,7425,7435,7450,7455,7456,7544,7556,7565,7572,7588,7621,7624,7688,7710,7719,7725,7735,7741,7751,7776,7797,7799,7806,7831,7837,7850,7858,7863,7866,7889,8027,8038,8064,8089,8125,8223,8229,8250,8258,8259,8285,8354,8377,8383,8386,8417,8549,8555,8566,8580,8589,8617,8660,8663,8679,8689,8713,8759,8851,8856,8860,8909,9181,9233,9242,9282,9305,9364,9399,9428,9432,9438,9439,9507,9552,9626,9677,9678,9704,9750,9801,9805,9828,9851,9858,9864,9924,9956,10030,10054,10110,10114,10120,10154,10162,10180,10206,10239,10264,10274,10295,10304,10315,10316,10317,10369,10425,10535,10564,10611,10644,10741,10779,10868,10907,10912,10952,10964,11026,11030,11057,11059,11091,11150,11194,11207,11250,11253,11299,11316,11328,11345,11386,11408,11440,11441,11592,11640,11642,11714,11857,11896,11924,12011,12165,12248,12301,12318,12398,12482,12620,12624,12625,12628,12670,12677,12685,12686,12708,12736,12758,12769,12811,12850,12935,12973,12996,13061,13100,13128,13224,13239,13246,13348,13349,13452,13481,13519,13635,13645,13670,13725,13851,13894,13900,14107,14140,14153,14189,14192,14194,14205,14224,14263,14267,14276,14307,14385,14391,14401,14420,14447,14450,14457,14481,14500,14507,14516,14517,14523,14560,14570,14573,14591,14601,14631,14698,14708,14725,14754,14795,14829,14847,14865,14911,14992,14999,15038,15055,15063,15076,15080,15094,15108,15128,15147,15158,15171,15177,15187,15217,15233,15259,15270,15346,15347,15361,15378,15407,15418,15429,15440,15469,15486,15487,15493,15516,15632,15639,15712,15714,15766,15850,15863,15875,15894,15899,15904,15937,15952,15953,15981,15987,16005,16024,16038,16043,16056,16089,16090,16129,16155,16156,16161,16200,16211,16216,16267,16281,16297,16303,16313,16323,16338,16359,16364,16390,16430,16438,16476,16486,16490,16497,16501,16523,16524,16543,16547,16561,16564,16571,16609,16626,16668,16675,16689,16714,16717,16739,16780,16791,16813,16816,16840,16863,16866,16876,16928,16951,17002,17038,17039,17053,17067,17086,17116,17126,17142,17148,17209,17234,17242,17253,17273,17275,17282,17287,17288,17344,17360,17363,17381,17394,17405,17422,17490,17496,17509,17539,17572,17573,17615,17618,17627,17659,17661,17688,17699,17701,17710,17712,17727,17734,17759,17782,17812,17818,17826,17853,17859,17879,17889,17893,17920,17935,17943,18022,18074,18083,18173,18181,18187,18216,18219,18220,18229,18249,18260,18311,18316,18318,18352,18362,18380,18386,18419,18421,18429,18450,18452,18479,18486,18494,18498,18509,18520,18552,18556,18572,18588,18605,18648,18652,18675,18696,18711,18748,18750,18793,18801,18807,18816,18826,18839,18845,18847,18856,18864,18866,18880,18904,18911,18922,18945,18953,18988,18989,18997,19004,19007,19014,19024,19027,19040,19056,19059,19060,19063,19088,19135,19145,19155,19189,19217,19226,19231,19260,19261,19282,19283,19292,19297,19303,19308,19360,19364,19370,19407,19416,19427,19435,19437,19445,19457,19482,19524,19527,19583,19591,19604,19617,19648,19650,19655,19659,19693,19702,19718,19733,19747,19854,19857,19873,19883,19940,19950,19972,19980,19993,20006,20010,20015,20020,20024,20033,20039,20043,20056,20083,20103,20115,20116,20127,20179,20189,20234,20237,20254,20289,20333,20356,20394,20402,20426,20522,20539,20559,20607,20615,20660,20664,20665,20677,20681,20699,20710,20737,20785,20823,20837,20866,20946,21007,21049,21079,21087,21094,21095,21106,21118,21126,21128,21135,21187,21194,21223,21270,21294,21297,21305,21323,21350,21368,21372,21380,21384,21390,21398,21422,21464,21491,21496,21520,21554,21555,21583,21598,21640,21664,21692,21701,21711,21718,21727,21732,21757,21836,21879,21907,21987,21998,22011,22015,22020,22030,22035,22040,22062,22081,22089,22117,22140,22149,22164,22177,22222,22225,22228,22306,22324,22348,22351,22359,22382,22395,22404,22414,22415,22416,22417,22419,22454,22476,22484,22502,22543,22622,22649,22651,22698,22751,22753,22804,22820,22841,22877,22898,22909,22913,22919,22935,22974,22976,22985,22986,23011,23014,23028,23053,23072,23089,23139,23181,23214,23221,23242,23279,23294,23299,23304,23328,23340,23367,23369,23381,23398,23401,23430,23438,23439,23444,23456,23525,23527,23555,23562,23575,23585,23602,23615,23633,23634,23665,23666,23668,23680,23693,23716,23719,23732,23761,23826,23849,23853,23869,23910,23936,23955,23958,23965,23991,24024,24025,24034,24060,24100,24126,24127,24155,24164,24176,24178,24220,24248,24272,24302,24326,24356,24364,24397,24429,24475,24523,24526,24573,24577,24580,24615,24624,24668,24672,24710,24716,24756,24767,24780,24785,24841,24849,24868,24872,24941,24975,25007,25062,25070,25071,25079,25081,25099,25100,25102,25121,25153,25170,25184,25278,25280,25310,25315,25332,25343,25352,25386,25402,25411,25420,25428,25463,25478,25498,25535,25560,25584,25636,25640,25653,25657,25664,25676,25694,25747,25785,25807,25921,25954,26008,26030,26050,26056,26120,26193,26219,26221,26230,26239,26250,26358,26360,26367,26410,26431,26444,26451,26456,26499,26583,26651,26697,26698,26709,26723,26737,26741,26753,26801,26859,26892,26947,26960,26969,27002,27009,27024,27025,27028,27044,27055,27058,27070,27079,27082,27101,27189,27218,27245,27364,27408,27438,27454,27518,27520,27541,27557,27624,27628,27688,27738,27743,27763,27846,28046,28075,28240,28280,28328,28457,28461,28472,28496,28499,28616,28620,28747,28755,28944,29241,29372,29378,29389,29443,29534,29588,29590,29591,29617,29618,29936,30482,30656,30939,31115,31430,31623,31624,31684,32676,33165,33953,34039,34316,35465,35632,35741,35744,35760,35846,35858,35882,36153,36866,37577,37587,38867,38878,39387,39530,39601,39625,39642,39857,39902,39931,40014,40036,40203,40223,40342,40356,40404,40483,40797,41002,41026,41034,41047,41363,41399,41507,42434,42455,42532,43466,43842,43912,43981,43996,44289,45004,45005,45009,45023)
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 | 1152 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.78 ms |
preparing | 0.89 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |