Tiempo de la consulta: 6.32 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.222 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-05 07:24:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 07:24:59')
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(49,58,71,75,174,279,281,293,294,324,437,481,500,611,801,816,879,973,1078,1183,1207,1697,1935,1987,2051,2061,2106,2150,2180,2181,2195,2225,2290,2343,2344,2360,2371,2442,2443,2444,2501,2520,2573,2586,2587,2588,2613,2631,2632,2641,2682,2688,2760,2776,2788,2797,2802,2810,2816,2831,2860,2861,2902,2914,2968,3008,3025,3036,3037,3052,3067,3075,3087,3111,3150,3176,3208,3250,3330,3462,3491,3515,3591,3620,3623,3637,3725,3925,4033,4034,4053,4078,4087,4090,4095,4100,4131,4144,4205,4207,4227,4262,4337,4392,4712,4767,4889,4899,4930,4958,5154,5404,5451,5458,5536,5639,5647,5694,5713,5719,5800,5819,5894,5934,6018,6043,6050,6055,6066,6070,6081,6097,6105,6127,6141,6178,6264,6270,6272,6278,6279,6298,6329,6330,6332,6339,6340,6347,6350,6376,6388,6415,6427,6442,6455,6456,6460,6462,6463,6465,6468,6471,6473,6475,6476,6477,6492,6494,6497,6499,6500,6502,6515,6516,6517,6520,6534,6545,6546,6548,6568,6601,6603,6605,6608,6616,6643,6645,6654,6656,6658,6659,6663,6688,6711,6718,6736,6749,6750,6762,6776,6779,6788,6805,6806,6809,6815,6827,6847,6868,6869,6872,6879,6882,6884,6886,6887,6888,6889,6910,6914,6915,6916,6942,6945,6959,6990,6995,7019,7042,7043,7045,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7185,7201,7212,7213,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7327,7328,7330,7333,7334,7344,7346,7361,7367,7368,7369,7370,7371,7372,7374,7376,7377,7378,7379,7380,7388,7389,7406,7407,7408,7410,7411,7413,7414,7415,7417,7418,7427,7428,7430,7431,7432,7435,7436,7447,7450,7457,7458,7459,7461,7462,7463,7464,7465,7469,7483,7486,7488,7489,7492,7494,7495,7513,7514,7523,7545,7546,7552,7553,7555,7567,7570,7571,7577,7578,7583,7615,7674,7677,7678,7680,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7718,7720,7722,7741,7743,7744,7746,7749,7757,7758,7768,7780,7804,7806,7808,7810,7831,7833,7834,7835,7836,7837,7841,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7940,7950,7955,7957,7960,7961,7962,7963,7965,7979,7981,7982,7984,7994,8017,8020,8021,8022,8026,8027,8028,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8289,8311,8330,8565,8671,8689,8808,8930,8998,9069,9070,9073,9308,9351,9412,9478,9533,9610,9744,9759,9820,9826,9836,9847,10004,10120,10180,10197,10199,10265,10278,10349,10379,10399,10414,10421,10534,10553,10560,10600,10666,10811,10835,10971,11080,11099,11124,11126,11170,11192,11207,11226,11229,11231,11328,11411,11416,11438,11456,11548,11581,11592,11631,11848,11849,12013,12024,12076,12108,12114,12171,12184,12248,12268,12340,12358,12410,12415,12440,12474,12499,12520,12557,12609,12672,12708,12723,12808,12868,12878,13038,13115,13188,13220,13276,13361,13488,13496,13516,13543,13574,13600,13646,13656,13685,13695,13699,13707,13713,13715,13773,13783,13828,13838,13839,13896,13920,13926,13933,14052,14084,14110,14144,14282,14333,14341,14349,14357,14408,14413,14454,14455,14471,14486,14509,14630,14653,14657,14682,14684,14685,14693,14694,14697,14719,14749,14796,14818,14830,14848,14862,14947,14980,15004,15065,15074,15076,15155,15158,15178,15215,15236,15243,15244,15245,15253,15298,15353,15406,15411,15475,15497,15588,15633,15641,15645,15719,15740,15789,15835,15893,15925,15954,15964,15991,16000,16031,16055,16059,16101,16156,16257,16320,16342,16451,16507,16520,16543,16579,16663,16747,16823,16826,16829,16848,16854,16907,16928,16964,16967,16996,17005,17048,17115,17132,17153,17158,17173,17210,17242,17243,17277,17322,17388,17392,17438,17444,17453,17464,17517,17557,17650,17730,17752,17753,17763,17777,17781,17857,17864,17890,17908,17912,17991,18007,18100,18134,18227,18239,18281,18294,18311,18316,18317,18355,18368,18401,18409,18436,18492,18512,18518,18562,18569,18663,18695,18701,18730,18744,18764,18765,18794,18839,18951,19012,19048,19049,19065,19073,19128,19170,19183,19208,19213,19222,19280,19290,19292,19304,19314,19329,19415,19426,19429,19497,19578,19596,19623,19656,19679,19682,19700,19711,19720,19741,19754,19825,19851,19858,19945,19947,19959,19970,19995,20018,20029,20049,20076,20091,20168,20297,20451,20486,20543,20614,20621,20631,20632,20670,20680,20684,20748,20792,20794,20809,20843,20845,21073,21157,21171,21217,21229,21244,21248,21259,21273,21294,21310,21313,21327,21366,21388,21413,21451,21540,21552,21554,21566,21588,21610,21614,21635,21645,21662,21669,21696,21763,21851,21861,21871,21884,21888,21913,21917,21922,21924,21952,21973,21990,22009,22029,22038,22051,22063,22065,22110,22137,22177,22223,22230,22336,22348,22362,22422,22457,22461,22527,22529,22533,22550,22561,22614,22640,22699,22702,22708,22717,22723,22741,22749,22750,22910,22942,22959,22978,22989,23023,23049,23063,23073,23077,23121,23153,23190,23195,23220,23224,23245,23308,23347,23352,23361,23371,23382,23424,23437,23441,23446,23464,23518,23524,23525,23542,23575,23631,23672,23706,23708,23749,23830,23925,23983,23987,23988,24015,24104,24118,24126,24140,24162,24211,24219,24237,24273,24279,24289,24329,24332,24348,24362,24370,24407,24409,24424,24475,24534,24538,24557,24612,24636,24642,24650,24665,24735,24764,24765,24771,24774,24817,24846,24862,24874,24903,24956,24980,24983,25039,25048,25076,25137,25225,25255,25261,25312,25335,25369,25372,25394,25397,25425,25510,25512,25528,25548,25561,25677,25725,25872,25946,26048,26052,26074,26162,26178,26203,26224,26255,26273,26317,26320,26325,26514,26574,26597,26814,26824,26913,26961,27079,27130,27170,27362,27372,27482,27563,27703,27746,27833,27938,28005,28033,28115,28318,28436,28559,28639,28673,28763,28992,29012,29099,29142,29154,29216,29244,29359,29382,29405,29444,29454,29486,29655,29759,29832,30325,33270,33417,33702,33908,34007,35335,35653,35741,36092,36798,36821,37657,38383,39283,39464,39790,40110,40351,40490,40515,40771,40864,41058,41069,41100,41122,41292,41761,42036,42272,44362,44509)
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 | 1038 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 2.42 ms |
preparing | 1.32 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.88 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.18 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 |