Tiempo de la consulta: 10.51 ms Después de la última consulta: 1.46 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.369 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 06:30:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 06:30:35')
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(8,14,44,45,46,47,48,49,50,51,52,53,56,57,58,59,67,71,75,90,92,96,97,98,99,102,104,107,109,127,136,137,141,190,195,198,199,200,205,209,210,217,226,228,232,234,238,239,240,241,242,243,265,276,278,325,358,368,374,411,419,428,445,446,466,479,487,489,520,523,593,605,607,621,637,672,681,692,697,709,710,723,737,752,771,804,812,826,853,871,874,878,904,928,948,955,966,1018,1031,1067,1092,1112,1188,1200,1209,1210,1223,1235,1256,1264,1285,1287,1329,1353,1361,1381,1383,1395,1434,1461,1478,1489,1495,1506,1531,1559,1579,1596,1601,1621,1690,1691,1698,1738,1756,1760,1782,1825,1845,1873,1883,1938,1954,1957,1999,2082,2147,2156,2376,2401,2425,2433,2447,2530,2565,2566,2569,2579,2584,2595,2610,2660,2667,2729,2740,2791,2822,2823,2870,2875,2894,2899,2922,2940,2970,2974,2975,2997,3020,3022,3024,3058,3065,3097,3129,3215,3273,3290,3332,3350,3397,3476,3506,3524,3550,3556,3589,3602,3634,3666,3671,3707,3720,3736,3785,3915,3930,3951,3977,4008,4045,4092,4111,4167,4208,4305,4357,4471,4516,4522,4560,4627,4697,4710,4784,4792,4808,4853,4857,4896,4902,4929,4968,4992,5061,5063,5066,5125,5175,5176,5186,5212,5256,5265,5278,5281,5285,5305,5323,5371,5427,5472,5515,5537,5541,5555,5560,5561,5573,5622,5647,5649,5685,5707,5726,5727,5821,5841,5847,5850,5969,6071,6121,6144,6145,6176,6195,6207,6211,6212,6215,6216,6254,6264,6283,6333,6384,6386,6393,6402,6403,6445,6459,6470,6473,6482,6498,6501,6518,6666,6690,6740,6741,6742,6757,6760,6761,6769,6794,6795,6802,6829,6839,6847,6853,6856,6862,6865,6881,6894,6915,6944,6976,6984,7017,7056,7084,7121,7129,7130,7172,7209,7253,7273,7374,7394,7560,7584,7591,7593,7594,7621,7624,7652,7670,7726,7762,7772,7774,7775,7928,7958,7967,7988,7991,7993,7998,8027,8037,8056,8062,8070,8138,8220,8238,8244,8249,8312,8320,8321,8352,8354,8394,8427,8487,8494,8521,8558,8563,8569,8593,8718,8819,8834,8838,8840,8844,8939,8983,9003,9017,9047,9083,9103,9104,9183,9201,9203,9206,9256,9391,9395,9539,9574,9643,9650,9685,9724,9749,9818,9924,9942,9953,9993,10031,10099,10100,10103,10130,10141,10149,10165,10179,10254,10262,10268,10278,10315,10323,10436,10471,10483,10612,10645,10695,10856,10860,10889,10956,10970,11112,11138,11152,11163,11241,11253,11285,11292,11374,11461,11661,11857,11911,11946,11989,11996,12048,12095,12177,12183,12223,12283,12326,12332,12382,12412,12523,12628,12630,12668,12679,12703,12811,12818,12913,12962,12973,12990,13002,13004,13010,13062,13079,13152,13188,13231,13276,13277,13314,13321,13336,13398,13405,13471,13473,13646,13681,13718,13725,13750,13775,13800,13868,13900,13969,14029,14034,14156,14203,14218,14224,14263,14293,14313,14356,14386,14400,14427,14537,14581,14602,14608,14675,14772,14871,14970,14987,15021,15039,15110,15162,15179,15188,15198,15200,15223,15245,15262,15298,15347,15366,15418,15421,15470,15473,15482,15495,15511,15517,15550,15566,15573,15630,15667,15759,15784,15835,15890,15919,15941,15945,15972,16014,16029,16149,16150,16165,16197,16202,16213,16263,16313,16352,16362,16365,16370,16457,16481,16488,16532,16589,16720,16812,16816,16818,16826,16865,16894,16983,17045,17063,17104,17114,17139,17142,17143,17154,17169,17177,17194,17234,17236,17275,17307,17317,17334,17409,17417,17453,17506,17513,17520,17521,17608,17611,17619,17629,17662,17687,17695,17710,17728,17785,17862,17949,17965,18052,18072,18074,18084,18106,18121,18124,18133,18150,18181,18213,18245,18264,18300,18322,18336,18362,18426,18441,18447,18458,18465,18490,18509,18538,18571,18588,18596,18626,18675,18707,18726,18739,18753,18767,18780,18791,18801,18817,18845,18846,18852,18956,18958,18992,18999,19019,19024,19031,19040,19041,19057,19094,19098,19099,19134,19150,19186,19192,19216,19224,19245,19252,19260,19263,19303,19312,19353,19358,19369,19402,19429,19454,19483,19484,19527,19545,19551,19582,19586,19637,19659,19676,19720,19722,19741,19772,19791,19798,19816,19834,19837,19844,19939,19943,19963,20004,20026,20039,20042,20043,20045,20076,20092,20122,20183,20208,20216,20239,20269,20296,20301,20343,20386,20408,20434,20492,20497,20526,20528,20539,20570,20573,20592,20595,20617,20627,20643,20670,20677,20681,20688,20728,20742,20792,20804,20881,20894,20907,20944,20964,20984,21002,21061,21080,21182,21188,21198,21259,21280,21300,21390,21404,21421,21454,21528,21538,21622,21631,21653,21679,21756,21767,21826,21891,21899,21958,21960,22032,22085,22156,22162,22172,22181,22189,22237,22239,22253,22267,22304,22309,22339,22344,22361,22363,22409,22413,22466,22481,22499,22544,22547,22564,22611,22623,22694,22695,22726,22753,22781,22814,22827,22865,22871,22896,22958,22973,23003,23010,23036,23074,23082,23096,23099,23104,23119,23176,23184,23203,23218,23228,23230,23235,23254,23264,23268,23292,23304,23351,23364,23371,23381,23391,23455,23460,23475,23481,23483,23523,23554,23555,23563,23585,23604,23619,23632,23719,23805,23813,23815,23854,23893,23897,23901,23905,23906,23909,23947,23964,23986,23995,24000,24007,24032,24092,24095,24160,24197,24209,24226,24238,24294,24303,24339,24352,24361,24368,24376,24429,24496,24503,24526,24527,24585,24598,24615,24655,24663,24678,24679,24711,24741,24764,24772,24782,24861,24918,24922,24934,24954,24982,24984,24992,25005,25036,25062,25079,25089,25109,25131,25151,25232,25244,25287,25303,25368,25375,25401,25432,25441,25480,25506,25507,25598,25613,25637,25649,25707,25716,25776,25863,25918,25949,25956,25959,26028,26040,26047,26069,26118,26131,26184,26221,26283,26317,26328,26340,26345,26360,26443,26485,26625,26673,26699,26732,26742,26874,26884,26900,26905,26916,26925,26940,26944,26947,26959,26971,26978,26990,27000,27091,27109,27118,27126,27143,27171,27232,27405,27430,27526,27550,27707,27717,27726,27786,27805,27809,27846,27878,27949,27978,28030,28078,28121,28198,28438,28531,28545,28614,28615,28643,28718,28825,28845,29054,29063,29155,29218,29297,29459,29540,29926,29943,30083,30273,30472,30477,30483,30484,30700,30808,30940,31136,31447,32107,32352,33168,35000,35585,35744,35832,35846,35861,35891,35909,36479,36836,37368,38120,38542,38563,38628,38631,38901,39320,39381,39887,40086,40113,40270,40451,40492,40548,40578,40810,41049,41213,41264,41268,41477,44204)
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 | 1087 | 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.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.91 ms |
preparing | 1.25 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.66 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.17 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 |