Tiempo de la consulta: 4.09 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.183 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 00:14:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 00:14:19')
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,12,13,14,15,16,17,18,495,583,613,675,706,723,724,844,879,900,1029,1039,1089,1095,1158,1195,1249,1337,1372,1497,1557,1935,1987,2026,2064,2103,2106,2219,2224,2325,2379,2404,2426,2439,2563,2573,2613,2625,2631,2632,2641,2647,2688,2724,2827,2831,2842,2857,2888,2902,2914,2916,2924,2934,2946,3025,3037,3038,3067,3087,3111,3176,3207,3248,3276,3285,3462,3491,3533,3591,3620,3725,3812,3925,4078,4090,4095,4100,4114,4131,4204,4209,4227,4255,4315,4337,4392,4446,4459,4573,4712,4735,4767,4813,4930,4944,5219,5458,5639,5694,5713,5719,5800,5819,5851,5854,5932,5934,5971,5977,6043,6050,6055,6066,6081,6097,6105,6127,6178,6264,6270,6272,6298,6329,6330,6332,6340,6347,6350,6376,6388,6427,6442,6455,6456,6460,6462,6465,6468,6471,6473,6492,6494,6497,6499,6500,6502,6515,6517,6520,6534,6545,6546,6561,6568,6601,6603,6608,6629,6644,6645,6654,6656,6658,6659,6663,6685,6711,6718,6736,6743,6749,6762,6776,6779,6788,6791,6801,6804,6805,6806,6809,6815,6827,6833,6842,6847,6868,6869,6872,6879,6882,6889,6906,6910,6914,6915,6916,6942,6945,6969,6986,6990,7019,7042,7043,7045,7057,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7201,7212,7213,7241,7243,7246,7248,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7327,7328,7330,7333,7334,7344,7346,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7406,7407,7408,7410,7411,7412,7413,7414,7415,7417,7418,7427,7428,7430,7431,7435,7436,7439,7447,7450,7457,7458,7459,7461,7462,7464,7465,7469,7486,7488,7489,7490,7494,7495,7513,7514,7523,7545,7546,7552,7553,7555,7567,7570,7577,7578,7583,7615,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7720,7722,7743,7744,7746,7749,7752,7757,7758,7768,7780,7804,7806,7808,7810,7831,7833,7834,7835,7836,7841,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7940,7955,7957,7960,7961,7962,7963,7979,7982,7987,7994,8017,8020,8021,8022,8026,8028,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8216,8289,8311,8330,8431,8808,8820,8945,9027,9036,9069,9101,9308,9346,9359,9415,9478,9533,9610,9745,9759,9826,9834,9836,9847,9854,10004,10197,10199,10265,10286,10304,10349,10379,10386,10399,10484,10532,10534,10553,10554,10560,10600,10661,10666,10713,10760,10769,10811,10835,11099,11126,11170,11192,11226,11229,11231,11262,11271,11277,11320,11416,11438,11456,11548,11581,11592,11631,11645,11682,11821,11849,11872,12013,12019,12024,12055,12076,12114,12139,12171,12184,12206,12296,12340,12358,12369,12410,12440,12474,12499,12520,12567,12609,12708,13030,13115,13188,13190,13262,13276,13361,13384,13456,13496,13498,13574,13601,13656,13659,13685,13733,13828,13842,13911,13926,14052,14057,14084,14110,14141,14341,14349,14357,14408,14413,14454,14525,14613,14616,14630,14653,14682,14685,14692,14696,14749,14818,14947,15004,15065,15111,15149,15155,15236,15244,15253,15298,15330,15346,15474,15497,15565,15576,15635,15641,15668,15835,15925,15954,16031,16055,16060,16062,16101,16128,16156,16168,16257,16280,16343,16434,16507,16522,16571,16671,16823,16826,16827,16854,16964,17042,17138,17153,17158,17184,17222,17294,17389,17425,17444,17484,17704,17715,17752,17763,17857,17901,17991,18183,18227,18294,18311,18317,18401,18409,18512,18518,18610,18663,18695,18701,18718,18744,18756,18768,19020,19048,19049,19064,19100,19111,19170,19183,19193,19213,19222,19233,19267,19314,19355,19426,19475,19711,19851,19858,19918,19920,19930,19945,19947,19995,20018,20049,20091,20120,20168,20297,20361,20486,20556,20632,20655,20670,20671,20779,20784,20792,20794,20809,20845,21157,21244,21259,21273,21294,21297,21327,21366,21413,21420,21510,21517,21536,21537,21540,21566,21588,21614,21662,21696,21739,21831,21861,21865,21884,21903,21913,21917,21924,21973,21990,22009,22038,22051,22063,22137,22230,22238,22250,22317,22347,22348,22362,22457,22479,22550,22553,22561,22571,22582,22614,22640,22645,22656,22705,22708,22711,22714,22717,22770,22775,22883,22910,22942,22959,22978,22989,23023,23049,23076,23121,23148,23188,23195,23220,23286,23308,23371,23437,23488,23542,23612,23631,23706,23783,23830,23988,24015,24140,24162,24211,24219,24237,24273,24279,24282,24289,24329,24348,24362,24409,24476,24538,24550,24557,24559,24576,24614,24636,24650,24687,24735,24760,24764,24765,24774,24817,24846,24860,24862,24863,24886,24899,24903,24956,24983,24994,25060,25076,25125,25137,25174,25225,25255,25261,25335,25369,25372,25374,25425,25510,25512,25561,25567,25621,25677,25696,25703,25717,25738,25799,25872,25938,25946,25947,26030,26031,26041,26052,26062,26074,26146,26166,26173,26203,26273,26302,26457,26582,26818,26961,27170,27248,27283,27318,27478,27556,27563,27776,28115,28184,28536,28639,28673,28720,28965,29020,29099,29142,29153,29216,29359,29382,29405,29438,29444,29536,29655,29759,29871,29907,29935,30325,33417,34007,35653,35741,35769,35871,35899,35975,36092,36154,36367,36402,36490,36583,36897,37345,38226,38237,38352,38850,38899,38991,39214,39286,39558,39580,39677,39737,39761,39782,39801,39892,40120,40272,40375,40594,40739,40773,40887,40973,41122,41217,41475,41636,41761,41826,42036,42272,42486,42563,42591,42680,42766,42944,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44469,44509,44843,44933,44998)
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 | 936 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.47 ms |
preparing | 0.73 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.06 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 |