Tiempo de la consulta: 5.49 ms Después de la última consulta: 1.30 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.501 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 11:54:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 11:54:49')
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,94,109,110,111,125,185,188,189,190,192,194,195,200,205,233,234,239,241,246,248,249,263,267,271,302,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,496,501,503,519,520,531,574,575,579,593,599,686,772,774,782,785,841,853,862,868,891,931,951,960,971,972,979,981,986,1001,1013,1043,1051,1054,1067,1069,1111,1121,1129,1198,1207,1223,1242,1254,1257,1280,1284,1321,1326,1331,1335,1342,1343,1347,1352,1353,1357,1373,1408,1431,1434,1473,1551,1649,1718,1785,1806,1878,1908,1924,1944,1945,2046,2072,2090,2098,2108,2136,2155,2198,2208,2250,2272,2284,2285,2314,2338,2352,2376,2424,2427,2473,2530,2543,2568,2607,2623,2665,2695,2825,2847,2894,2941,2952,2958,2963,2967,2978,2987,3000,3020,3025,3051,3114,3209,3212,3292,3321,3325,3329,3346,3368,3373,3410,3426,3442,3453,3454,3461,3475,3481,3487,3510,3521,3537,3637,3650,3663,3682,3787,3831,3961,3984,4002,4066,4081,4117,4132,4133,4310,4378,4390,4570,4587,4674,4699,4902,4905,4952,5021,5060,5091,5189,5322,5324,5391,5392,5456,5476,5479,5480,5488,5530,5538,5565,5622,5628,5638,5648,5649,5676,5685,5714,5723,5783,5798,5846,5847,5894,5895,5962,5996,6057,6158,6209,6260,6275,6290,6307,6310,6311,6386,6392,6482,6484,6496,6539,6550,6614,6616,6666,6671,6776,6788,6836,6868,6878,7017,7050,7056,7061,7107,7109,7111,7124,7138,7142,7157,7162,7163,7164,7167,7169,7181,7192,7210,7266,7271,7275,7289,7294,7332,7335,7356,7374,7399,7442,7450,7469,7471,7509,7553,7567,7572,7647,7680,7692,7716,7726,7730,7731,7759,7782,7811,7906,7933,7936,7938,7970,7993,8027,8047,8131,8149,8167,8191,8214,8215,8272,8319,8352,8395,8397,8406,8444,8449,8458,8464,8480,8483,8502,8543,8565,8589,8602,8610,8621,8638,8659,8660,8688,8732,8737,8754,8806,8808,8818,8835,8856,8871,8887,8919,8970,9029,9051,9062,9075,9107,9155,9165,9195,9197,9198,9206,9262,9282,9286,9303,9313,9364,9392,9411,9428,9472,9568,9605,9629,9650,9677,9678,9756,9767,9787,9800,9806,9825,9861,9902,9924,9928,9965,10011,10035,10037,10039,10068,10078,10100,10124,10131,10134,10138,10166,10167,10274,10323,10389,10413,10610,10613,10689,10765,10791,11073,11162,11231,11235,11345,11371,11374,11494,11620,11625,11632,11677,11697,11784,11934,11969,12020,12221,12324,12327,12341,12440,12459,12460,12494,12499,12534,12620,12650,12669,12670,12685,12686,12708,12789,12790,12800,12835,12902,12913,12973,12996,13010,13014,13016,13040,13062,13064,13145,13152,13294,13298,13348,13413,13427,13450,13474,13475,13506,13530,13534,13535,13544,13546,13557,13576,13645,13691,13740,13747,13759,13825,13846,13853,13871,13889,13898,13900,13927,13969,13971,13973,13985,14009,14122,14135,14151,14156,14206,14229,14246,14293,14360,14361,14362,14369,14419,14435,14464,14496,14514,14534,14536,14554,14581,14595,14602,14603,14604,14607,14608,14645,14651,14691,14706,14727,14766,14773,14860,14870,14896,14897,14925,14950,14977,14991,15038,15043,15074,15120,15128,15158,15166,15181,15188,15198,15219,15220,15240,15245,15251,15261,15293,15304,15311,15312,15315,15325,15333,15344,15382,15414,15475,15476,15515,15520,15533,15541,15574,15611,15667,15751,15796,15861,15874,15904,15945,15972,16014,16025,16029,16055,16062,16071,16105,16115,16161,16176,16221,16365,16416,16439,16488,16497,16500,16503,16526,16542,16543,16566,16573,16651,16652,16660,16751,16760,16833,16836,16859,16869,16874,16905,16908,16927,16929,16950,16976,16983,16984,17039,17057,17058,17091,17114,17126,17142,17151,17224,17303,17309,17334,17335,17337,17344,17367,17376,17405,17407,17419,17447,17453,17496,17510,17528,17607,17629,17668,17695,17702,17710,17721,17773,17820,17857,17961,18071,18073,18097,18163,18179,18220,18260,18300,18309,18320,18360,18371,18399,18412,18465,18468,18480,18483,18488,18509,18558,18573,18578,18602,18643,18659,18757,18770,18789,18804,18819,18825,18856,18878,18949,19003,19007,19026,19056,19077,19109,19154,19182,19191,19282,19287,19288,19332,19333,19381,19390,19460,19551,19650,19658,19661,19668,19674,19690,19695,19733,19772,19825,19849,19886,19887,19903,19919,19923,19931,19932,19935,19937,19966,19980,20003,20055,20060,20071,20084,20095,20106,20157,20192,20193,20213,20308,20360,20368,20391,20400,20408,20439,20459,20503,20525,20567,20577,20595,20616,20620,20639,20645,20648,20676,20699,20700,20727,20762,20786,20825,20833,20837,20847,20883,21016,21038,21092,21094,21159,21199,21216,21230,21256,21279,21283,21285,21288,21300,21338,21368,21441,21460,21464,21469,21485,21486,21509,21524,21526,21529,21530,21614,21618,21623,21627,21650,21661,21664,21690,21695,21704,21719,21727,21773,21780,21782,21796,21800,21824,21825,21834,21843,21846,21850,21862,21868,21875,21902,21910,21919,21954,21955,21962,22013,22015,22018,22062,22069,22077,22097,22117,22163,22164,22175,22195,22241,22254,22302,22324,22332,22344,22357,22384,22406,22421,22430,22446,22453,22472,22494,22510,22512,22556,22574,22580,22603,22620,22622,22626,22627,22632,22655,22658,22694,22695,22696,22710,22727,22765,22780,22787,22804,22827,22829,22833,22879,22897,22923,22938,22947,22972,23007,23024,23035,23043,23062,23073,23077,23082,23089,23117,23123,23124,23179,23185,23214,23243,23254,23286,23304,23335,23336,23345,23358,23371,23409,23451,23453,23454,23475,23480,23528,23644,23665,23703,23716,23721,23751,23833,23834,23881,23921,23927,23962,24016,24019,24047,24064,24226,24249,24255,24264,24343,24393,24408,24433,24475,24514,24522,24525,24538,24570,24579,24582,24602,24617,24633,24692,24793,24803,24822,24824,24937,24956,24985,24993,25030,25035,25062,25081,25090,25131,25138,25156,25171,25182,25214,25217,25303,25318,25348,25351,25406,25409,25410,25436,25448,25493,25506,25518,25542,25584,25606,25646,25660,25665,25671,25721,25731,25874,25885,25898,25904,25922,25987,25995,26000,26010,26033,26040,26093,26106,26117,26147,26221,26248,26273,26284,26294,26317,26326,26343,26360,26409,26410,26415,26424,26429,26435,26454,26474,26505,26533,26565,26651,26671,26677,26713,26742,26771,26775,26801,26820,26832,26840,26842,26845,26881,26905,26907,26937,26944,26947,26956,26973,26988,26992,27000,27037,27038,27053,27091,27137,27188,27293,27360,27366,27401,27408,27460,27529,27530,27688,27722,27775,27834,27846,27916,27956,27969,27992,28007,28013,28030,28072,28080,28339,28440,28442,28447,28614,28615,28616,28712,28728,28845,28912,28944,29054,29121,29174,29446,29460,29630,29635,29683,29888,30282,30293,30496,30916,31026,31425,31873,32484,32552,32642,32643,32644,33042,33044,33065,33417,33750,33884,33885,33886,33954,33955,34016,34047,34111,34180,34189,34251,34284,34377,34391,34483,34502,34667,34668,34669,34788,34832,34892,34902,34935,34959,35010,35094,35126,35175,35185,35195,35205,35235,35310,35314,35330,35392,35472,35557,35581,35650,35658,35713,35744,35773,35847,35876,35902,35930,35943,35955,35982,36031,36042,36047,36066,36095,36227,36330,36437,36462,36531,36688,36714,36828,36829,36880,36888,36945,36957,37024,37088,37137,37284,37344,37357,37365,37521,37543,37544,37557,37579,37642,37669,37693,37710,37731,37740,37767,37787,37802,37844,37852,37876,37932,37953,37999,38060,38185,38293,38329,38346,38361,38370,38372,38409,38411,38430,38506,38512,38520,38567,38581,38588,38623,38651,38734,38764,38781,38809,38837,38851,38861,38888,38956,39019,39023,39070,39079,39142,39160,39185,39212,39241,39285,39346,39398,39415,39416,39439,39491,39511,39530,39582,39615,39627,39631,39649,39670,39736,39757,39767,39838,39849,39932,39934,39993,40003,40023,40036,40054,40072,40073,40094,40126,40195,40251,40302,40306,40345,40379,40431,40492,40494,40505,40508,40605,40638,40659,40699,40714,40765,40897,40904,40970,40996,41023,41046,41051,41075,41078,41096,41142,41181,41190,41227,41245,41251,41259,41273,41284,41297,41303,41313,41350,41370,41373,41391,41431,41440,41517,41660,41722,41726,41738,41739,41768,41811,41822,41837,41851,41875,41959,41972,41973,41981,41983,41997,42002,42010,42029,42113,42124,42136,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,43056,43058,43083,43116,43143,43181,43199,43268,43312,43342,43347,43348,43434,43443,43455,43468,43471,43507,43512,43527,43612,43617,43628,43629,43644,43647,43652,43684,43703,43704,43730,43742,43758,43800,43836,43877,43883,43927,44003,44045,44049,44050,44070,44073,44098,44239,44259,44338,44353,44356,44379,44389,44392,44437,44455,44521,44558,44570,44586,44603,44625,44658,44683,44691,44708,44748,44842,44874,44907,44964,44971,44989,45008,45055,45060,45147,45195,45289,45301,45311)
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 | 1478 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.15 ms |
preparing | 1.12 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.02 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 |