Tiempo de la consulta: 4.36 ms Después de la última consulta: 0.88 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.512 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 23:57:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:57:32')
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(82,93,192,407,454,495,579,595,599,600,634,743,801,821,834,841,931,979,981,1001,1051,1111,1122,1198,1280,1342,1343,1352,1408,1473,1551,1614,1649,1713,1747,1800,1804,1806,1944,2046,2098,2123,2155,2210,2228,2260,2284,2285,2316,2337,2378,2419,2424,2427,2466,2468,2509,2543,2623,2665,2688,2695,2828,2847,2941,2952,2958,2963,2967,3025,3067,3076,3114,3211,3258,3319,3321,3373,3408,3410,3426,3454,3475,3481,3487,3510,3521,3663,3757,3831,3871,3984,4066,4131,4132,4304,4383,4657,4699,4832,4836,4910,5092,5224,5298,5391,5432,5480,5714,5798,5846,5943,5944,5973,6039,6055,6131,6350,6539,6571,6609,6645,6665,6711,6770,6775,6809,6919,6945,6977,7001,7162,7163,7164,7167,7169,7192,7271,7287,7294,7330,7342,7377,7399,7482,7523,7585,7624,7716,7810,7837,7855,7866,7913,7933,7991,7993,7999,8000,8085,8088,8149,8222,8250,8289,8319,8354,8416,8444,8458,8483,8532,8603,8659,8706,8732,8764,8808,8818,8865,8903,8964,9012,9018,9045,9051,9195,9239,9308,9313,9364,9481,9552,9566,9605,9629,9756,9806,9823,9920,9975,10039,10100,10160,10260,10301,10440,10504,10598,10604,10660,10689,10764,10813,11632,11677,12035,12113,12140,12216,12224,12317,12437,12494,12499,12534,12650,12669,12708,12790,13064,13188,13359,13474,13535,13576,13671,13685,13693,13725,13727,13748,13750,13782,13858,13898,13924,13941,13947,14206,14360,14378,14496,14534,14536,14604,14648,14663,14669,14688,14703,14709,14726,14744,14762,14790,14849,14890,14905,14911,14940,14949,14970,14992,15020,15038,15128,15148,15180,15220,15262,15293,15298,15304,15319,15365,15366,15372,15456,15494,15533,15594,15751,15753,15785,15904,15931,15945,16115,16122,16157,16422,16439,16652,16723,16787,16862,16894,16908,17101,17105,17166,17224,17296,17317,17496,17530,17531,17635,17695,17857,17862,18022,18071,18227,18309,18377,18595,18659,18789,18912,18927,18929,18982,18995,19010,19056,19118,19182,19211,19235,19236,19245,19268,19281,19472,19507,19519,19661,19695,19706,19723,19935,19980,19988,20066,20157,20246,20376,20396,20488,20503,20567,20656,20700,20711,20720,20825,20833,20837,20841,20863,20883,21016,21055,21094,21122,21180,21198,21279,21285,21368,21441,21509,21520,21550,21566,21598,21650,21718,21719,21727,21796,21825,21834,21850,21875,21914,21932,21954,21962,22062,22117,22241,22357,22384,22406,22419,22421,22446,22486,22494,22510,22761,22780,22829,22833,22850,22851,22897,22938,23035,23043,23062,23117,23179,23184,23192,23213,23254,23273,23287,23288,23304,23345,23453,23454,23479,23493,23720,23751,23795,23831,23887,23913,23996,24027,24043,24062,24077,24082,24099,24153,24185,24187,24190,24199,24201,24208,24247,24259,24281,24286,24316,24334,24337,24357,24393,24399,24406,24463,24485,24497,24539,24570,24582,24624,24743,24788,24803,24824,24906,24951,24952,24956,25035,25131,25171,25214,25318,25351,25410,25436,25493,25506,25514,25518,25639,25648,25665,25668,25673,25721,25734,25746,25747,25763,25764,25771,25800,25817,25874,25995,26010,26113,26117,26134,26153,26174,26187,26191,26221,26296,26360,26386,26388,26424,26480,26630,26634,26671,26710,26815,26820,26830,26916,26933,26935,26944,26947,26956,26964,27085,27091,27103,27108,27109,27137,27192,27196,27209,27212,27216,27242,27252,27258,27268,27269,27270,27298,27307,27323,27360,27367,27396,27408,27454,27487,27510,27523,27541,27555,27559,27570,27595,27636,27655,27656,27671,27717,27743,27786,27923,28031,28045,28059,28066,28075,28094,28097,28120,28127,28129,28137,28158,28168,28237,28243,28435,28759,28995,29045,29152,29166,29226,29229,29272,29602,29630,29660,29671,29681,29716,29909,30525,30692,31735,32642,32643,32644,32767,32768,33065,33750,33954,33955,34016,34047,34180,34189,34251,34377,34391,34483,34502,34646,34811,34832,34935,34959,35010,35094,35100,35175,35185,35191,35205,35232,35238,35239,35250,35289,35295,35310,35314,35345,35365,35376,35392,35397,35540,35554,35557,35581,35621,35641,35658,35744,35773,35808,35847,35876,35902,35930,35948,35982,36015,36031,36066,36220,36227,36368,36373,36380,36385,36386,36437,36441,36531,36688,36714,36790,36791,36792,36793,36828,36849,36888,36941,36957,36984,37015,37024,37104,37137,37245,37344,37357,37365,37370,37473,37508,37521,37543,37544,37579,37642,37643,37644,37669,37693,37710,37731,37740,37757,37767,37787,37802,37834,37844,37852,37876,37902,37932,37953,37979,37999,38058,38060,38185,38329,38330,38346,38361,38370,38402,38409,38418,38430,38506,38512,38520,38567,38588,38617,38623,38673,38681,38723,38734,38764,38781,38809,38821,38829,38837,38851,38861,38888,38956,38965,39019,39023,39039,39070,39110,39133,39160,39185,39199,39212,39244,39290,39293,39297,39346,39398,39415,39416,39439,39460,39470,39491,39519,39582,39649,39670,39718,39736,39757,39767,39837,39838,39849,39856,39932,39934,39993,40003,40059,40072,40073,40094,40195,40275,40302,40306,40319,40345,40379,40431,40494,40505,40508,40560,40576,40638,40699,40714,40762,40855,40896,40897,40904,40970,40996,41004,41009,41023,41033,41046,41051,41075,41078,41096,41123,41142,41152,41172,41176,41181,41189,41190,41201,41212,41225,41227,41245,41251,41259,41272,41273,41284,41289,41297,41303,41308,41310,41313,41328,41339,41343,41370,41373,41391,41415,41434,41440,41479,41504,41517,41519,41550,41571,41591,41625,41637,41660,41722,41726,41737,41738,41739,41745,41757,41768,41783,41811,41822,41851,41862,41875,41948,41959,41964,41972,41973,41980,41981,41983,41997,42002,42010,42029,42113,42124,42136,42199,42232,42251,42275,42282,42303,42329,42353,42380,42427,42430,42446,42462,42478,42482,42484,42574,42604,42625,42682,42736,42768,42788,42811,42941,43043,43058,43083,43093,43104,43116,43117,43143,43167,43181,43199,43221,43240,43241,43268,43312,43326,43342,43347,43348,43375,43434,43443,43446,43455,43461,43468,43471,43475,43477,43507,43512,43517,43518,43527,43612,43617,43628,43629,43647,43684,43703,43704,43730,43739,43742,43749,43758,43792,43800,43836,43877,43883,43927,44003,44045,44049,44050,44070,44073,44098,44122,44186,44187,44239,44259,44338,44353,44356,44378,44379,44389,44392,44437,44455,44521,44558,44570,44581,44586,44603,44625,44632,44640,44656,44658,44683,44691,44708,44718,44735,44748,44788,44807,44829,44842,44873,44874,44881,44907,44912,44935,44936,44964,44989,45008,45055,45060,45147,45174,45175,45195,45223,45249,45274,45289,45300,45301,45311,45313)
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 | 1062 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.74 ms |
preparing | 0.87 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 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 |