Tiempo de la consulta: 5.51 ms Después de la última consulta: 1.26 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.374 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 05:39:54')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 05:39:54')
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,45,46,49,54,62,65,71,90,92,96,97,98,99,102,104,107,198,199,209,210,217,226,228,232,234,238,240,242,243,265,276,338,340,350,415,419,428,466,482,487,523,605,607,637,643,659,764,823,851,870,904,948,966,1022,1031,1067,1209,1223,1335,1563,1571,1687,1698,1812,1825,1845,1957,2084,2135,2156,2392,2486,2729,2747,2822,2886,2887,2909,3020,3058,3083,3191,3196,3266,3499,3680,3685,3739,3760,3767,3776,3802,3806,3833,3851,3913,3960,3985,4033,4034,4101,4110,4129,4148,4150,4180,4204,4205,4237,4245,4280,4284,4311,4323,4327,4334,4337,4341,4419,4423,4456,4486,4533,4548,4568,4575,4594,4650,4784,4808,4820,4840,4859,4902,4936,4940,4980,5005,5086,5115,5125,5131,5210,5258,5259,5274,5323,5329,5337,5371,5387,5422,5455,5502,5504,5536,5598,5622,5647,5649,5685,5704,5726,5727,5783,5825,5835,5847,5855,5908,5909,5913,5940,5941,5959,5979,6009,6020,6051,6063,6064,6070,6100,6128,6135,6167,6189,6264,6274,6291,6294,6327,6356,6360,6361,6362,6386,6440,6442,6479,6505,6518,6610,6649,6720,6729,6760,6826,6839,6847,6865,6873,6915,6927,6980,6984,7017,7077,7085,7111,7148,7216,7250,7258,7331,7357,7364,7394,7444,7466,7500,7505,7569,7586,7605,7614,7617,7618,7624,7651,7711,7724,7752,7771,7772,7784,7787,7793,7813,7819,7854,7865,7903,7925,7928,7935,7942,7958,7967,8004,8055,8056,8060,8062,8070,8092,8104,8116,8133,8151,8152,8160,8170,8187,8225,8227,8234,8242,8265,8320,8331,8341,8354,8370,8378,8388,8421,8470,8507,8517,8535,8539,8550,8552,8595,8611,8644,8649,8652,8660,8687,8700,8750,8751,8753,8755,8765,8799,8813,8826,8844,8861,8864,8875,8913,8922,8925,8953,8954,9003,9009,9024,9063,9096,9120,9140,9253,9328,9350,9365,9390,9399,9477,9578,9600,9610,9650,9651,9724,9734,9738,9784,9829,9838,9877,9878,9904,9908,9922,9924,9956,10004,10031,10040,10100,10133,10176,10190,10265,10269,10313,10323,10377,10414,10436,10448,10513,10617,10642,10754,10756,10889,10956,10993,11023,11031,11041,11073,11077,11119,11121,11163,11250,11286,11338,11387,11488,11545,11687,11796,11911,11921,11946,11972,12095,12177,12249,12412,12481,12517,12553,12632,12638,12679,12689,12690,12884,12887,12913,12973,13010,13062,13146,13166,13209,13231,13276,13321,13376,13385,13398,13405,13471,13473,13671,13681,13702,13731,13738,13750,13760,13789,13800,13868,13946,13961,13969,13996,14029,14034,14123,14141,14156,14203,14218,14224,14263,14277,14293,14351,14356,14396,14512,14513,14515,14532,14581,14601,14616,14662,14730,14739,14796,14807,14820,14824,14825,14939,14987,14999,15006,15021,15039,15041,15069,15074,15081,15110,15132,15148,15160,15178,15179,15188,15193,15195,15198,15262,15268,15298,15326,15347,15366,15388,15418,15421,15423,15450,15457,15465,15470,15473,15482,15487,15495,15511,15517,15541,15550,15551,15570,15573,15611,15617,15630,15636,15637,15640,15667,15685,15704,15724,15736,15738,15759,15767,15783,15784,15835,15866,15913,15933,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16165,16181,16213,16227,16248,16256,16263,16292,16314,16315,16352,16365,16403,16488,16532,16552,16577,16720,16759,16812,16826,16828,16890,16894,16915,16942,16983,16984,16991,17045,17053,17063,17074,17075,17102,17115,17142,17145,17154,17160,17216,17227,17228,17233,17236,17245,17275,17314,17317,17334,17405,17409,17453,17468,17506,17520,17521,17611,17619,17633,17650,17672,17710,17739,17844,17855,17859,17862,17884,17893,17926,17949,17965,17966,18052,18054,18062,18106,18122,18124,18133,18157,18180,18181,18213,18233,18242,18255,18274,18292,18314,18336,18344,18362,18426,18458,18460,18465,18509,18538,18539,18544,18564,18588,18608,18675,18707,18709,18726,18742,18753,18800,18801,18845,18846,18852,18862,18878,18916,18922,18931,18954,18956,18958,18975,18980,18999,19024,19028,19034,19040,19042,19057,19098,19105,19115,19124,19128,19135,19150,19155,19218,19240,19245,19247,19252,19263,19271,19312,19313,19353,19358,19366,19369,19402,19454,19483,19484,19527,19530,19550,19551,19561,19582,19604,19637,19652,19676,19713,19722,19732,19772,19791,19816,19837,19852,19872,19898,19908,19939,19943,19945,19963,20004,20018,20030,20039,20092,20122,20127,20183,20216,20250,20260,20264,20269,20296,20301,20318,20327,20343,20348,20376,20386,20393,20408,20413,20429,20434,20444,20461,20492,20497,20526,20528,20539,20573,20592,20602,20617,20649,20670,20678,20688,20741,20779,20792,20797,20804,20813,20828,20850,20881,20894,20906,20907,20915,20944,20959,20964,20984,21000,21002,21057,21062,21080,21107,21108,21143,21161,21182,21190,21249,21259,21300,21325,21369,21381,21397,21404,21434,21435,21447,21454,21458,21464,21489,21552,21554,21578,21590,21605,21631,21641,21679,21710,21740,21744,21764,21767,21776,21777,21855,21858,21883,21891,21894,21944,21958,21960,21976,21982,22010,22032,22040,22063,22085,22123,22156,22160,22162,22172,22176,22189,22214,22237,22239,22253,22256,22267,22298,22313,22339,22344,22348,22361,22363,22407,22409,22459,22461,22466,22481,22499,22544,22547,22564,22611,22617,22647,22694,22695,22726,22733,22739,22753,22763,22781,22814,22819,22837,22865,22871,22889,22890,22904,22957,22958,22973,23003,23010,23036,23065,23067,23074,23096,23099,23104,23119,23131,23184,23185,23195,23201,23203,23218,23230,23235,23237,23241,23254,23260,23264,23268,23280,23292,23304,23313,23320,23325,23326,23328,23335,23339,23371,23381,23391,23452,23455,23460,23475,23483,23523,23554,23555,23582,23585,23604,23619,23632,23678,23679,23719,23805,23813,23854,23890,23893,23897,23901,23905,23909,23947,23964,23986,24000,24007,24075,24092,24102,24104,24152,24160,24191,24197,24209,24226,24238,24273,24274,24294,24303,24327,24339,24352,24361,24366,24371,24376,24392,24429,24496,24503,24526,24585,24592,24598,24615,24644,24663,24678,24679,24711,24727,24733,24737,24741,24764,24772,24782,24816,24837,24844,24861,24899,24918,24934,24964,24984,24992,25005,25062,25072,25079,25089,25098,25107,25125,25133,25151,25178,25212,25225,25232,25244,25253,25287,25303,25368,25375,25377,25380,25401,25432,25480,25507,25613,25637,25644,25645,25649,25714,25716,25728,25730,25785,25850,25863,25877,25918,25949,25956,25993,26047,26118,26131,26178,26183,26184,26221,26256,26273,26283,26304,26443,26493,26501,26504,26521,26563,26625,26648,26673,26684,26699,26732,26884,26900,26901,26925,26926,26940,26971,26972,26978,26990,27002,27011,27109,27118,27126,27143,27150,27170,27171,27232,27246,27273,27321,27405,27418,27430,27431,27434,27496,27521,27545,27550,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28030,28033,28045,28082,28121,28225,28312,28411,28639,28653,28658,28718,28825,28989,29008,29009,29063,29152,29153,29155,29174,29197,29213,29250,29297,29319,29332,29355,29356,29367,29417,29443,29444,29476,29781,29800,29905,29922,29923,29926,29935,29943,30083,30273,30483,30484,30808,31136,31447,32107,32768,32842,35000,35585,35617,35689,35744,35832,35846,35883,35885,38807,38831,38854,38866,39320,39381,39481,39603,39681,39857,39887,39943,40025,40038,40083,40086,40097,40113,40170,40200,40271,40451,40492,40578,40708,40759,40785,40809,40907,40937,40984,41049,41059,41213,41255,41301,41325,41375,41477)
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 | 1221 | 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.86 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.09 ms |
statistics | 2.16 ms |
preparing | 1.05 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.43 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.10 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 |