Tiempo de la consulta: 4.33 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.475 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-08 22:34:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 22:34:24')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,87,88,89,110,111,125,188,189,190,200,205,234,246,248,249,263,271,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,496,501,503,531,574,575,593,686,785,853,862,868,986,1026,1207,1223,1353,1357,1434,1713,1718,1878,1902,2046,2108,2208,2272,2631,2632,2641,2688,2825,2902,3020,3025,3051,3067,3087,3176,3212,3325,3426,3650,3682,3725,3871,3925,4090,4095,4100,4131,4227,4310,4337,4392,4674,4832,4902,4905,4930,5060,5150,5189,5324,5392,5476,5538,5639,5685,5694,5713,5719,5798,5800,5819,5895,5913,5934,6043,6050,6055,6066,6081,6097,6127,6178,6264,6270,6272,6298,6311,6329,6330,6332,6340,6347,6350,6376,6388,6392,6427,6442,6455,6456,6460,6462,6465,6468,6471,6473,6482,6492,6494,6497,6499,6500,6502,6515,6517,6520,6534,6545,6546,6568,6573,6601,6603,6608,6616,6645,6654,6656,6658,6659,6666,6671,6711,6718,6749,6762,6776,6779,6788,6805,6806,6809,6827,6836,6847,6869,6872,6879,6882,6889,6910,6914,6915,6916,6942,6945,6990,6995,7017,7043,7045,7050,7056,7081,7102,7109,7122,7124,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7201,7210,7212,7213,7214,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7287,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,7413,7414,7415,7417,7418,7427,7428,7430,7431,7435,7436,7447,7450,7457,7458,7459,7461,7462,7464,7465,7469,7488,7489,7494,7495,7513,7514,7523,7526,7545,7546,7552,7553,7555,7567,7570,7577,7578,7583,7615,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7692,7708,7713,7715,7716,7720,7722,7730,7743,7744,7745,7746,7749,7757,7758,7768,7780,7782,7804,7806,7808,7810,7811,7831,7833,7834,7835,7836,7841,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7933,7940,7955,7957,7960,7961,7962,7963,7970,7979,7982,7987,7993,7994,7997,8017,8020,8021,8022,8026,8027,8028,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8215,8222,8289,8311,8330,8416,8444,8532,8565,8589,8602,8603,8610,8638,8787,8808,8835,8856,8887,9206,9262,9282,9308,9411,9428,9472,9478,9650,9677,9678,9759,9826,9924,10004,10035,10197,10199,10265,10274,10349,10379,10399,10534,10553,10560,10600,10604,10811,10835,10968,11099,11126,11192,11226,11229,11231,11345,11548,11581,11592,11849,12013,12020,12024,12171,12184,12324,12340,12358,12437,12460,12474,12499,12520,12609,12620,12650,12670,12685,12686,12708,12913,12973,12996,13014,13016,13152,13294,13348,13474,13475,13656,13685,13782,13900,13971,13973,14052,14084,14110,14139,14229,14293,14349,14357,14362,14534,14536,14554,14601,14648,14653,14663,14682,14685,14749,14818,14860,14880,14905,14947,15038,15043,15059,15060,15065,15244,15245,15253,15261,15262,15293,15298,15382,15414,15467,15475,15476,15520,15533,15574,15796,15835,15861,15925,15945,15947,15954,15972,16031,16055,16062,16071,16101,16115,16156,16161,16176,16208,16257,16465,16497,16526,16543,16566,16751,16823,16826,16833,16854,16908,16950,16964,16976,17114,17133,17158,17309,17334,17335,17419,17496,17528,17531,17607,17629,17702,17721,17763,17857,17866,17927,17991,18071,18073,18220,18227,18260,18300,18309,18317,18360,18401,18409,18512,18558,18578,18663,18695,18701,18744,18757,18819,18929,19048,19049,19170,19183,19213,19222,19265,19282,19381,19426,19460,19551,19650,19661,19668,19695,19733,19772,19825,19851,19858,19886,19923,19931,19937,19947,19980,20060,20095,20192,20193,20213,20246,20308,20439,20459,20486,20567,20595,20616,20632,20648,20670,20699,20700,20727,20792,20833,20837,20847,20883,21016,21038,21159,21180,21256,21259,21273,21275,21279,21283,21285,21288,21294,21300,21327,21338,21366,21368,21413,21441,21464,21485,21486,21502,21523,21524,21526,21529,21566,21588,21614,21618,21623,21650,21661,21664,21690,21695,21696,21704,21719,21727,21800,21824,21843,21850,21875,21884,21910,21913,21924,21932,21954,21955,21990,22009,22015,22018,22038,22062,22077,22117,22137,22163,22164,22195,22230,22241,22302,22324,22357,22362,22384,22406,22421,22446,22453,22512,22550,22580,22603,22614,22620,22622,22626,22655,22658,22710,22727,22753,22765,22780,22787,22804,22829,22833,22897,22923,22947,22959,22972,22989,23007,23023,23024,23043,23062,23082,23089,23121,23124,23179,23214,23273,23308,23309,23365,23371,23437,23479,23480,23528,23542,23631,23665,23716,23927,24015,24016,24140,24162,24208,24211,24226,24237,24249,24279,24329,24337,24362,24381,24393,24408,24409,24475,24522,24538,24582,24617,24650,24696,24764,24774,24803,24846,24862,24937,24951,24956,24980,24983,24993,25030,25035,25062,25076,25131,25137,25138,25171,25225,25255,25318,25335,25351,25369,25372,25406,25436,25448,25510,25512,25542,25584,25646,25648,25660,25665,25904,26000,26033,26074,26113,26147,26175,26203,26221,26317,26343,26360,26415,26424,26454,26474,26626,26651,26677,26713,26742,26760,26801,26820,26845,26864,26881,26905,26907,26944,26973,27000,27036,27038,27196,27323,27366,27530,27563,27688,27722,27846,28016,28031,28059,28066,28072,28075,28080,28095,28097,28115,28120,28243,28339,28435,28440,28442,28614,28615,28616,28673,28712,28728,28765,28845,28858,28944,29054,29142,29359,29382,29405,29444,29460,29635,29655,29759,30325,30525,31706,31735,31794,32257,32468,32761,32768,32879,32977,32980,33026,33065,33157,33289,33338,33417,33545,35330,35653,35713,35741,35744,35955,39398,39530,40036,40492,40605,42010,42029,42036,42513,43612,43704,44070,44098,44379,44509,44553,45008)
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 | 990 | 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.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.63 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.04 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 |