Tiempo de la consulta: 5.55 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.227 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-09 13:29:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 13:29: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(3,8,11,33,34,35,39,40,41,42,43,46,57,62,64,73,75,93,124,128,130,149,155,177,180,186,188,189,198,202,212,214,215,220,221,244,246,248,250,253,260,263,277,330,337,394,417,418,419,423,427,433,439,452,458,459,481,521,524,550,551,567,583,587,595,596,597,603,604,612,613,628,641,647,659,662,678,686,699,779,788,845,852,868,902,903,927,938,954,988,1015,1066,1080,1099,1100,1114,1119,1201,1207,1218,1222,1227,1268,1269,1271,1272,1273,1274,1277,1284,1329,1332,1340,1357,1397,1432,1512,1519,1543,1627,1697,1734,1740,1800,1803,1853,1904,1960,1976,2012,2048,2053,2088,2092,2103,2122,2137,2142,2155,2189,2190,2241,2288,2325,2344,2349,2389,2426,2427,2431,2482,2532,2551,2563,2581,2598,2609,2625,2687,2710,2746,2750,2811,2827,2852,2857,2865,2906,2916,2924,2937,2968,3007,3027,3031,3038,3080,3120,3130,3156,3193,3217,3224,3232,3240,3248,3255,3258,3276,3285,3302,3305,3329,3345,3400,3415,3416,3417,3418,3442,3462,3473,3512,3554,3557,3565,3721,3732,3748,3782,3836,3880,3947,3980,3986,4034,4068,4209,4301,4315,4490,4573,4580,4611,4640,4765,4767,4815,4831,4844,4846,4872,4905,4912,4913,5018,5034,5045,5055,5085,5096,5164,5174,5207,5208,5370,5472,5544,5562,5581,5647,5658,5698,5708,5769,5827,5833,5877,5894,5899,5934,5944,5977,6003,6011,6067,6093,6112,6141,6166,6253,6264,6277,6278,6279,6319,6340,6405,6466,6481,6515,6517,6594,6616,6628,6629,6632,6658,6736,6791,6906,6935,6939,6969,7007,7045,7077,7105,7136,7150,7218,7270,7282,7290,7324,7429,7447,7458,7462,7490,7491,7658,7675,7716,7743,7758,7777,7795,7835,7895,7954,8052,8080,8084,8087,8135,8152,8255,8281,8291,8512,8517,8559,8681,8759,8803,8873,8909,9087,9219,9282,9343,9351,9360,9387,9435,9460,9515,9585,9679,9816,9853,9854,9908,9930,9941,9947,10038,10046,10185,10192,10222,10260,10286,10304,10436,10439,10440,10452,10483,10485,10532,10554,10661,10671,10708,10713,10720,10764,10810,10827,10832,10837,10926,10971,10987,11038,11045,11101,11171,11188,11189,11262,11293,11328,11399,11457,11510,11590,11675,11702,11748,11757,11764,11765,11798,11821,11846,11854,11872,11903,11912,11945,11946,11951,11960,11992,12019,12092,12172,12175,12176,12202,12216,12236,12256,12271,12292,12321,12340,12357,12364,12380,12427,12489,12510,12516,12657,12665,12718,12753,12794,12804,12806,12832,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,13027,13043,13055,13082,13142,13162,13186,13187,13218,13242,13243,13246,13262,13264,13306,13328,13329,13371,13384,13385,13391,13410,13460,13495,13529,13536,13603,13659,13702,13709,13733,13748,13758,13772,13826,13844,13873,13886,13911,13926,13946,13996,14060,14074,14076,14096,14114,14115,14147,14148,14200,14202,14209,14224,14242,14263,14270,14291,14375,14384,14470,14482,14489,14504,14521,14523,14525,14527,14555,14556,14565,14571,14599,14613,14639,14653,14685,14703,14713,14851,14869,14873,14959,14976,14977,15040,15045,15051,15113,15122,15128,15149,15154,15175,15180,15235,15269,15301,15324,15326,15330,15335,15354,15360,15373,15418,15470,15473,15498,15500,15533,15540,15542,15550,15562,15565,15580,15602,15604,15630,15632,15635,15707,15709,15748,15753,15781,15787,15832,15842,15864,15893,15900,15913,15926,15940,15945,15955,15979,15985,16017,16056,16060,16128,16134,16145,16168,16199,16208,16235,16245,16279,16283,16297,16327,16337,16341,16345,16354,16366,16373,16382,16405,16411,16412,16417,16422,16434,16435,16460,16468,16475,16479,16515,16545,16552,16556,16566,16612,16619,16643,16659,16661,16678,16686,16722,16771,16790,16791,16820,16827,16830,16838,16912,16922,16949,16965,16985,16996,17018,17028,17042,17052,17080,17115,17125,17160,17178,17183,17184,17222,17229,17236,17268,17276,17283,17293,17299,17318,17337,17360,17369,17411,17415,17422,17434,17439,17442,17457,17458,17465,17491,17494,17507,17519,17541,17554,17567,17568,17584,17596,17613,17704,17707,17806,17807,17815,17850,17856,17863,17902,17905,17906,17918,17935,17953,17972,17993,18005,18030,18045,18046,18047,18048,18050,18056,18069,18124,18140,18147,18179,18190,18194,18217,18225,18244,18281,18296,18313,18334,18352,18357,18395,18408,18435,18439,18449,18460,18470,18480,18496,18518,18519,18524,18537,18539,18544,18563,18588,18592,18598,18603,18609,18627,18629,18640,18646,18648,18649,18659,18665,18674,18680,18706,18718,18722,18746,18754,18768,18769,18790,18804,18812,18823,18825,18859,18861,18868,18885,18889,18894,18896,18908,18923,18930,18933,18938,18941,18949,18952,18953,18960,18989,19005,19013,19020,19029,19042,19061,19064,19073,19091,19109,19139,19148,19160,19195,19219,19237,19263,19266,19282,19293,19299,19320,19322,19342,19346,19358,19370,19427,19452,19469,19490,19503,19510,19516,19537,19542,19590,19593,19621,19641,19647,19662,19679,19695,19796,19810,19837,19883,19904,19918,19930,19951,19957,19971,19989,19995,20001,20008,20075,20147,20152,20164,20172,20191,20195,20215,20220,20262,20306,20313,20347,20365,20378,20391,20398,20407,20462,20496,20512,20530,20556,20567,20587,20621,20658,20661,20662,20685,20701,20748,20795,20840,20843,20846,20860,20870,20894,20910,20914,20920,20937,20939,20958,20963,21047,21049,21054,21080,21097,21103,21106,21120,21123,21141,21147,21164,21166,21172,21219,21238,21274,21294,21297,21313,21348,21373,21407,21420,21445,21446,21472,21508,21552,21563,21568,21612,21638,21675,21683,21695,21717,21737,21739,21741,21757,21778,21831,21878,21886,21923,21931,21948,21966,21982,22025,22049,22073,22128,22162,22167,22211,22232,22233,22238,22286,22287,22290,22294,22307,22319,22325,22338,22346,22347,22348,22352,22360,22362,22387,22394,22402,22424,22427,22487,22494,22504,22511,22514,22558,22563,22571,22594,22651,22675,22689,22700,22709,22711,22758,22770,22775,22778,22779,22814,22849,22861,22883,22941,22956,22958,22980,23023,23030,23035,23045,23067,23072,23079,23090,23128,23138,23163,23165,23188,23200,23230,23244,23254,23255,23261,23281,23284,23303,23305,23323,23330,23340,23341,23354,23364,23366,23375,23381,23386,23418,23443,23469,23485,23487,23523,23534,23542,23545,23612,23625,23635,23659,23660,23735,23783,23790,23804,23855,23856,23877,23898,23913,23950,23951,23966,23971,23994,24006,24084,24142,24153,24276,24281,24293,24325,24347,24390,24426,24475,24495,24496,24540,24585,24598,24629,24638,24679,24684,24698,24711,24717,24723,24760,24764,24767,24769,24770,24802,24812,24828,24858,24860,24862,24863,24877,24896,24902,24911,24947,24987,25001,25004,25011,25012,25056,25105,25125,25162,25174,25184,25208,25248,25257,25263,25267,25280,25301,25313,25401,25442,25465,25539,25567,25572,25600,25696,25721,25747,25763,25777,25781,25799,25882,25924,25932,25938,25947,25950,25956,25995,26010,26013,26033,26073,26074,26146,26172,26173,26194,26227,26245,26268,26295,26296,26337,26395,26423,26432,26455,26525,26586,26626,26710,26765,26818,26832,26861,26928,26968,26990,27005,27014,27042,27115,27152,27187,27198,27240,27273,27283,27291,27307,27319,27343,27362,27394,27478,27487,27496,27517,27625,27656,27695,27799,27956,28020,28153,28163,28184,28240,28248,28294,28402,28416,28436,28442,28458,28534,28547,28555,28575,28607,28623,28640,28677,28683,28692,28756,28765,28778,28817,28867,28918,29033,29201,29221,29312,29440,29537,29553,29572,29697,29757,29758,29805,29824,29857,29928,30596,31114,31663,31763,31885,31896,33073,33416,33649,35726,36834,37056,37210,37695,37696,37702,38261,38362,38475,39180,39186,39258,39267,39463,39469,39491,39495,39543,39650,39750,39819,39870,39884,39933,40207,40208,40355,40402,40572,40837,40852,41241,41444,41525,41526,41541,41606,41823,41946,41960,42024,42025,42067,42132,42251,42408,42421,42425,42426,42444,42748,42824,42839,43002,43052,43060,43069,43084,43087,43388,43717,44161,44509,44656,44749,44763)
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 | 1330 | 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.02 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.16 ms |
preparing | 1.20 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.48 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.10 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 |