Tiempo de la consulta: 8.52 ms Después de la última consulta: 1.31 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.535 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-04 11:14:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 11:14:56')
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,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,81,84,87,88,89,90,91,92,93,95,96,97,98,99,100,102,103,104,105,106,107,108,110,111,112,125,188,189,190,198,199,200,204,205,209,210,211,217,226,227,228,229,230,231,232,236,237,238,240,242,243,246,248,249,263,265,271,276,293,325,353,362,412,415,416,419,420,421,422,423,424,426,427,428,429,431,437,447,466,484,487,495,496,501,503,523,531,574,575,593,605,607,637,639,644,645,653,686,691,694,701,714,719,721,723,725,757,777,785,803,836,853,862,868,904,912,944,948,965,966,986,1002,1031,1045,1067,1075,1104,1110,1147,1164,1168,1173,1207,1209,1217,1223,1236,1296,1313,1353,1357,1367,1434,1463,1643,1698,1718,1725,1825,1830,1845,1862,1878,1893,1957,2108,2144,2156,2163,2164,2169,2195,2199,2202,2204,2208,2210,2213,2217,2227,2234,2237,2242,2245,2252,2256,2272,2273,2286,2299,2346,2348,2353,2386,2398,2419,2590,2729,2822,2825,2858,2964,3020,3049,3051,3054,3058,3113,3212,3286,3320,3325,3442,3650,3682,3852,3886,3902,3986,4188,4310,4476,4674,4765,4784,4808,4902,4905,4910,4982,5060,5125,5189,5323,5324,5371,5392,5476,5516,5538,5567,5594,5622,5647,5649,5685,5726,5727,5798,5847,5894,5895,6264,6311,6318,6341,6363,6386,6392,6420,6482,6502,6518,6572,6586,6616,6666,6671,6690,6756,6760,6776,6836,6839,6840,6847,6868,6870,6881,6915,6948,6984,7017,7050,7056,7109,7110,7124,7138,7210,7241,7287,7450,7587,7591,7624,7654,7689,7692,7716,7730,7772,7776,7782,7811,7928,7933,7958,7967,7970,7993,8027,8038,8056,8062,8070,8139,8215,8220,8320,8354,8391,8444,8533,8565,8589,8602,8610,8638,8823,8835,8844,8856,8887,9003,9102,9206,9249,9262,9282,9318,9364,9411,9414,9428,9438,9451,9472,9650,9677,9678,9724,9851,9858,9924,10031,10035,10100,10274,10323,10366,10436,10451,10484,10722,10739,10889,10956,10964,11163,11242,11345,11746,11911,11946,12020,12095,12177,12324,12385,12412,12423,12460,12620,12650,12670,12679,12685,12686,12708,12756,12808,12887,12913,12973,12996,13010,13014,13016,13062,13067,13128,13152,13194,13224,13231,13276,13294,13321,13348,13349,13365,13398,13405,13471,13473,13474,13475,13530,13566,13645,13681,13725,13750,13800,13866,13868,13900,13902,13917,13969,13971,13973,14029,14034,14047,14156,14203,14213,14218,14224,14229,14263,14293,14356,14362,14386,14500,14534,14536,14537,14554,14581,14844,14860,14935,14987,15021,15038,15039,15043,15079,15110,15128,15179,15188,15198,15224,15230,15245,15261,15262,15293,15298,15347,15366,15382,15390,15414,15418,15421,15470,15473,15475,15476,15482,15490,15495,15496,15511,15517,15520,15533,15550,15573,15574,15630,15667,15759,15784,15796,15835,15861,15945,15972,16016,16036,16040,16048,16055,16062,16071,16115,16141,16161,16163,16165,16176,16213,16230,16263,16339,16352,16365,16366,16367,16476,16488,16497,16526,16532,16543,16566,16675,16692,16720,16728,16751,16812,16826,16833,16894,16908,16950,16976,16983,17036,17045,17063,17114,17142,17154,17222,17234,17236,17275,17307,17309,17317,17334,17335,17343,17409,17419,17447,17453,17496,17501,17506,17511,17520,17521,17528,17607,17611,17619,17629,17688,17702,17710,17712,17721,17771,17857,17862,17939,17948,17949,17965,17966,18052,18053,18071,18073,18106,18124,18133,18161,18174,18181,18213,18220,18249,18260,18297,18300,18309,18336,18360,18362,18426,18458,18465,18509,18538,18556,18558,18578,18588,18675,18707,18726,18753,18757,18801,18816,18819,18845,18846,18852,18864,18904,18956,18958,18997,18999,19024,19040,19056,19057,19062,19088,19098,19150,19174,19190,19245,19250,19252,19263,19282,19312,19353,19358,19369,19381,19402,19419,19437,19438,19454,19460,19483,19484,19524,19527,19551,19582,19592,19604,19650,19661,19668,19676,19693,19695,19702,19715,19722,19733,19772,19791,19795,19816,19825,19835,19837,19886,19923,19931,19937,19939,19943,19963,19980,20004,20026,20039,20053,20060,20083,20092,20095,20122,20183,20192,20193,20213,20216,20269,20287,20296,20301,20308,20325,20333,20343,20360,20386,20408,20434,20439,20459,20492,20497,20526,20528,20539,20542,20563,20567,20568,20573,20592,20595,20616,20617,20633,20648,20658,20665,20670,20688,20699,20700,20716,20727,20730,20771,20792,20804,20847,20881,20894,20907,20944,20947,20964,20984,21002,21016,21038,21049,21080,21118,21128,21159,21172,21182,21254,21256,21259,21279,21283,21285,21288,21300,21313,21338,21350,21368,21398,21404,21436,21454,21464,21472,21485,21486,21524,21526,21529,21543,21598,21618,21623,21631,21648,21650,21661,21664,21679,21690,21695,21700,21704,21718,21719,21727,21732,21753,21767,21768,21800,21824,21843,21850,21878,21891,21904,21910,21944,21954,21955,21958,21960,21965,21969,22015,22018,22030,22032,22049,22062,22077,22085,22101,22117,22126,22156,22162,22163,22164,22172,22189,22195,22208,22234,22239,22241,22253,22266,22267,22288,22302,22324,22332,22336,22339,22344,22361,22363,22395,22406,22409,22421,22446,22453,22466,22476,22481,22499,22512,22531,22544,22547,22564,22580,22603,22611,22620,22622,22626,22655,22658,22694,22695,22710,22726,22727,22735,22743,22752,22753,22765,22780,22781,22784,22787,22804,22814,22829,22833,22865,22871,22897,22913,22923,22935,22947,22958,22972,22973,22989,23003,23007,23010,23024,23034,23036,23043,23062,23063,23072,23074,23082,23089,23096,23099,23104,23119,23124,23150,23179,23184,23203,23214,23218,23230,23235,23242,23254,23264,23268,23279,23292,23300,23304,23335,23367,23371,23381,23391,23408,23438,23455,23460,23475,23480,23483,23517,23523,23527,23528,23554,23555,23585,23604,23619,23632,23665,23709,23716,23719,23805,23813,23854,23868,23882,23893,23897,23901,23905,23909,23927,23942,23947,23964,23986,24000,24007,24016,24092,24124,24146,24160,24178,24197,24209,24226,24238,24249,24259,24294,24303,24339,24352,24357,24361,24376,24390,24393,24408,24429,24475,24496,24503,24505,24522,24526,24548,24573,24582,24585,24598,24615,24617,24618,24624,24663,24672,24678,24679,24711,24741,24742,24756,24764,24772,24782,24803,24842,24861,24874,24879,24918,24926,24934,24937,24956,24984,24986,24992,24993,25005,25030,25035,25062,25079,25087,25089,25100,25115,25131,25138,25142,25151,25171,25232,25244,25255,25276,25287,25303,25310,25318,25332,25343,25351,25368,25375,25384,25389,25401,25405,25406,25420,25429,25432,25434,25436,25447,25448,25452,25477,25480,25487,25501,25507,25537,25542,25558,25560,25573,25584,25596,25613,25614,25637,25646,25649,25660,25664,25675,25676,25684,25688,25697,25711,25716,25718,25748,25780,25792,25809,25815,25820,25863,25884,25904,25908,25918,25948,25949,25956,25961,25971,25994,26000,26033,26047,26056,26118,26120,26131,26133,26147,26156,26184,26219,26221,26250,26260,26275,26283,26292,26303,26317,26321,26343,26346,26360,26410,26415,26424,26431,26443,26453,26454,26456,26474,26499,26541,26559,26569,26571,26596,26618,26623,26625,26651,26658,26673,26677,26697,26699,26710,26713,26732,26737,26742,26753,26801,26809,26811,26820,26845,26859,26881,26884,26892,26900,26905,26907,26925,26940,26944,26960,26971,26973,26978,26990,27000,27024,27025,27038,27056,27058,27102,27109,27118,27126,27143,27151,27171,27232,27258,27307,27366,27396,27405,27408,27417,27430,27466,27510,27520,27530,27544,27550,27688,27722,27763,27846,27998,28030,28036,28072,28080,28121,28280,28309,28334,28339,28342,28440,28442,28484,28499,28529,28533,28611,28614,28615,28616,28690,28712,28718,28728,28738,28759,28774,28787,28825,28845,28887,28939,28944,29054,29063,29155,29297,29328,29406,29460,29635,29710,29722,29926,29943,30083,30273,30388,30483,30484,30808,31136,31447,31532,32107,32392,32502,33165,33349,33417,33953,34316,35000,35330,35465,35566,35585,35643,35691,35713,35722,35744,35832,35846,35858,35942,35955,36052,36055,36153,38380,38495,38597,38612,38712,38736,38793,38846,38847,38857,38868,38902,39025,39049,39088,39144,39225,39263,39320,39381,39385,39398,39530,39601,39615,39657,39887,40036,40086,40113,40168,40342,40451,40492,40578,40605,40681,41005,41049,41213,41477,42210,42458,42532,42562,42948,43842,44303,45008,45180)
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 | 1383 | 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 | 1.21 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.44 ms |
System lock | 0.03 ms |
optimizing | 0.15 ms |
statistics | 3.61 ms |
preparing | 1.75 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.61 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.10 ms |
cleaning up | 0.08 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 |