Tiempo de la consulta: 3.98 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.320 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 20:10:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 20:10:51')
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(96,227,454,535,570,740,743,801,887,918,971,979,991,1155,1158,1308,1413,1614,1747,1886,2061,2098,2223,2271,2282,2316,2419,2466,2471,2479,2488,2525,2631,2632,2641,2670,2688,2700,2720,2743,2799,2815,2834,2843,2847,2854,2902,2956,3025,3046,3067,3076,3087,3090,3128,3146,3161,3176,3396,3468,3579,3725,3780,3871,3925,3946,3948,3990,3994,4090,4095,4100,4131,4200,4227,4304,4337,4392,4580,4739,4930,4985,5432,5479,5484,5530,5537,5590,5616,5639,5694,5713,5719,5800,5819,5934,6043,6050,6055,6066,6081,6097,6127,6178,6236,6244,6264,6270,6272,6298,6300,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,6568,6601,6603,6608,6645,6654,6656,6658,6659,6684,6711,6718,6749,6762,6775,6776,6779,6788,6805,6806,6809,6827,6847,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6942,6945,6990,6995,7043,7045,7071,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7169,7170,7171,7173,7176,7178,7179,7181,7201,7212,7213,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7327,7328,7330,7333,7334,7342,7343,7344,7346,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7406,7407,7408,7410,7411,7413,7414,7415,7417,7418,7427,7428,7430,7431,7435,7436,7443,7447,7450,7457,7458,7459,7461,7462,7464,7465,7469,7488,7489,7494,7495,7513,7514,7521,7523,7545,7546,7552,7553,7555,7567,7570,7577,7578,7579,7583,7615,7636,7674,7677,7678,7679,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7720,7722,7743,7744,7746,7749,7753,7757,7758,7768,7780,7804,7806,7808,7810,7825,7831,7833,7834,7835,7836,7841,7855,7856,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7912,7915,7918,7919,7920,7923,7928,7930,7940,7953,7955,7957,7960,7961,7962,7963,7979,7982,7987,7994,8017,8020,8021,8022,8026,8028,8045,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8115,8134,8139,8140,8159,8311,8330,8441,8572,8660,8680,8687,8732,8808,8865,8903,9045,9303,9308,9478,9543,9566,9746,9759,9826,9834,9854,9975,9982,9999,10004,10033,10098,10144,10160,10161,10197,10199,10265,10349,10379,10399,10440,10504,10534,10553,10560,10600,10660,10811,10813,10835,11099,11126,11192,11207,11226,11229,11231,11429,11548,11581,11592,11703,11849,11859,11900,12013,12019,12024,12140,12171,12184,12317,12340,12358,12437,12474,12499,12520,12609,12650,12692,12708,13019,13042,13264,13334,13347,13359,13604,13636,13656,13685,13725,13936,14052,14084,14110,14206,14349,14357,14378,14536,14653,14682,14685,14744,14749,14751,14760,14818,14890,14898,14905,14940,14947,15015,15065,15074,15148,15180,15220,15244,15253,15298,15319,15351,15372,15456,15475,15494,15680,15726,15731,15750,15835,15925,15954,15973,16031,16055,16101,16156,16236,16257,16270,16477,16484,16652,16723,16742,16819,16823,16826,16854,16913,16964,16992,17062,17105,17158,17317,17425,17427,17605,17763,17846,17857,17937,17991,18183,18227,18305,18317,18401,18409,18474,18512,18659,18663,18695,18701,18744,18927,18982,18995,19010,19048,19049,19090,19118,19158,19170,19183,19213,19222,19281,19368,19426,19519,19571,19574,19690,19807,19851,19858,19918,19934,19947,19949,19951,19955,19980,20246,20294,20431,20486,20608,20632,20670,20672,20700,20711,20718,20720,20792,20819,20833,20841,20863,20923,21055,21069,21122,21180,21231,21259,21273,21279,21294,21327,21339,21351,21366,21413,21512,21520,21529,21548,21550,21566,21588,21614,21637,21696,21719,21733,21791,21884,21913,21914,21924,21954,21990,22009,22027,22037,22038,22133,22137,22152,22230,22254,22261,22362,22381,22440,22483,22486,22505,22550,22566,22605,22614,22625,22833,22959,22989,23023,23056,23062,23121,23192,23240,23288,23308,23371,23437,23505,23542,23631,23689,23795,23911,23913,23996,24015,24077,24082,24099,24140,24162,24187,24190,24201,24211,24237,24259,24279,24329,24349,24350,24357,24358,24362,24409,24538,24623,24650,24764,24774,24846,24862,24956,24958,24983,25076,25113,25137,25225,25255,25273,25331,25335,25369,25372,25443,25445,25459,25510,25512,25514,25621,25639,25668,25673,25717,25724,25746,25763,25764,25985,26031,26074,26097,26117,26134,26174,26191,26203,26221,26319,26385,26471,26480,26508,26513,26535,26582,26634,26671,26703,26710,26830,26840,26935,26991,27084,27085,27258,27396,27454,27510,27523,27541,27555,27559,27563,27570,27589,27613,27636,27655,27656,27671,27743,27930,27983,28006,28018,28045,28075,28115,28127,28129,28137,28158,28168,28387,28395,28491,28595,28673,28759,29129,29142,29345,29359,29382,29405,29444,29560,29602,29603,29655,29660,29671,29681,29759,29818,29909,29914,30325,31207,32469,32661,33041,33417,33500,34075,34089,34126,34163,34257,34321,34500,34559,34653,34748,34750,34781,34782,34793,34804,34838,34895,35055,35103,35176,35184,35359,35435,35452,35484,35492,35523,35545,35570,35623,35645,35653,35681,35741,35841,35869,35872,35967,35980,36232,36234,36281,36461,36476,36583,36615,36680,36803,36815,36889,36896,36945,37131,37147,37284,37353,37360,37371,37396,37397,37401,37402,37426,37538,37597,37602,37618,37642,37717,37880,37906,37907,37947,38079,38131,38393,38451,38549,38574,38601,38602,38666,38713,38755,38886,39060,39088,39135,39183,39286,39291,39370,39411,39507,39520,39580,39598,39634,39675,39677,39727,39816,39827,39981,40089,40311,40326,40332,40365,40486,40585,40594,40640,40720,40724,40727,40759,40761,40775,40785,40803,40860,40887,40937,40941,40973,41007,41048,41140,41153,41158,41163,41200,41295,41299,41377,41421,41455,41543,41566,41619,41622,41687,41695,41696,41747,41779,41816,41840,41853,41876,41911,41993,42021,42036,42080,42187,42259,42274,42277,42313,42331,42367,42368,42375,42395,42412,42469,42475,42531,42535,42651,42676,42694,42730,42758,42785,42789,42797,42891,42950,42959,43046,43068,43082,43488,43554,43653,43678,43809,43988,44142,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 | 1018 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.61 ms |
preparing | 0.79 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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 |