Tiempo de la consulta: 10.19 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.416 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-06 09:07:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 09:07:45')
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(13,21,30,51,60,82,183,184,197,274,328,350,385,393,407,693,902,935,998,1280,1304,1352,1354,1357,1455,1535,1603,1634,1646,1713,1781,1785,1800,1802,1822,1900,1913,1984,2027,2210,2217,2305,2337,2378,2424,2598,2600,2601,2613,2632,2636,2668,2689,2805,2825,2971,3067,3087,3161,3202,3212,3216,3337,3373,3408,3484,3594,3718,3719,3725,3795,3833,3871,4033,4131,4166,4215,4227,4320,4473,4493,4612,4613,4614,4615,4617,4770,4832,4910,4930,4947,4957,4990,5000,5086,5092,5104,5150,5170,5173,5237,5268,5525,5559,5625,5686,5700,5758,5798,5809,5814,5908,5924,5943,5947,5950,5986,5987,5989,5990,5991,5995,6012,6020,6022,6039,6073,6079,6083,6097,6108,6110,6112,6132,6138,6192,6222,6264,6268,6270,6319,6324,6432,6464,6504,6571,6586,6610,6611,6659,6788,6830,6886,6887,6910,6917,6945,6977,6985,7081,7146,7200,7205,7330,7358,7396,7416,7482,7526,7550,7565,7621,7624,7659,7690,7735,7745,7792,7799,7810,7813,7866,8026,8039,8057,8083,8088,8089,8261,8263,8330,8354,8416,8436,8437,8438,8462,8647,8696,8706,8723,8756,8841,8879,8962,8972,9012,9018,9023,9040,9051,9091,9126,9142,9196,9197,9300,9308,9330,9370,9387,9481,9515,9529,9665,9738,9757,9833,9865,9869,10039,10186,10228,10260,10352,10400,10422,10458,10510,10603,10604,10634,10764,10811,11006,11098,11106,11107,11121,11137,11178,11305,11323,11356,11476,11627,11703,11721,11722,11781,11803,11820,11859,11864,11868,11925,11994,12077,12113,12144,12216,12254,12265,12488,12541,12592,12609,12650,12669,12675,12686,12708,12922,12939,13015,13129,13145,13154,13188,13231,13248,13268,13276,13321,13328,13349,13352,13360,13474,13501,13535,13575,13576,13617,13685,13693,13701,13727,13748,13750,13782,13783,13846,13851,13855,13861,13924,13941,13947,14008,14052,14079,14122,14169,14263,14327,14356,14357,14398,14430,14478,14524,14531,14648,14655,14663,14679,14713,14733,14749,14754,14832,14846,14860,14862,14905,14906,14911,14973,14996,15002,15020,15045,15046,15101,15166,15179,15208,15209,15217,15234,15262,15287,15293,15298,15304,15310,15314,15324,15366,15517,15528,15539,15540,15594,15606,15642,15689,15749,15751,15753,15796,15851,15862,15870,15876,15899,15917,15937,15947,16057,16103,16120,16122,16346,16354,16422,16440,16455,16464,16465,16526,16562,16578,16648,16654,16678,16728,16737,16793,16795,16802,16884,16894,16895,16924,16995,17014,17034,17121,17133,17136,17156,17167,17199,17270,17293,17304,17334,17335,17344,17346,17353,17369,17385,17409,17412,17420,17584,17590,17597,17603,17609,17618,17620,17630,17635,17698,17700,17826,17842,17857,17862,17902,17910,17927,17956,17976,17977,18028,18029,18038,18067,18102,18165,18170,18184,18227,18234,18334,18347,18362,18473,18494,18517,18590,18595,18658,18678,18707,18739,18755,18778,18782,18825,18826,18851,18876,18891,18892,18905,18907,18917,18926,18929,18931,18934,18938,18940,18945,18956,18958,18974,19024,19046,19123,19127,19153,19163,19197,19204,19211,19232,19235,19299,19353,19422,19423,19426,19432,19483,19484,19487,19548,19553,19558,19589,19693,19706,19750,19796,19808,19809,19845,19857,19858,19865,19875,19876,19879,19904,19916,19967,19988,20066,20068,20081,20139,20180,20215,20309,20338,20353,20376,20396,20398,20434,20436,20437,20469,20521,20535,20565,20574,20592,20618,20642,20648,20688,20690,20750,20751,20792,20953,20990,21053,21087,21198,21259,21329,21332,21405,21413,21487,21520,21523,21524,21547,21566,21598,21602,21612,21614,21671,21719,21722,21726,21747,21769,21773,21787,21811,21824,21833,21891,21932,22067,22129,22134,22137,22209,22215,22253,22262,22267,22311,22362,22365,22453,22466,22481,22484,22494,22581,22591,22620,22651,22659,22739,22781,22850,22851,22869,22871,22886,22914,22925,22926,22959,22964,22998,23036,23037,23083,23099,23104,23112,23119,23123,23139,23184,23201,23213,23229,23273,23287,23309,23328,23364,23365,23381,23398,23402,23428,23494,23511,23523,23584,23589,23611,23704,23709,23720,23732,23885,23888,23891,23892,23897,23905,23907,23912,23921,23964,24014,24029,24067,24077,24145,24163,24190,24270,24280,24298,24316,24317,24337,24339,24342,24382,24387,24396,24415,24424,24431,24451,24485,24486,24553,24554,24617,24650,24766,24774,24777,24781,24783,24785,24831,24834,24856,24871,24983,25032,25038,25049,25062,25068,25201,25281,25377,25450,25505,25518,25526,25548,25554,25589,25592,25621,25622,25639,25646,25648,25671,25673,25717,25723,25727,25747,25752,25757,25758,25771,25817,25818,25830,25836,25909,25916,25924,25927,25928,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26066,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26190,26191,26194,26215,26221,26227,26234,26259,26296,26335,26337,26359,26372,26386,26388,26530,26531,26558,26565,26576,26579,26620,26630,26639,26646,26691,26699,26780,26784,26820,26845,26873,26875,26879,26927,26933,26935,26968,27065,27096,27208,27211,27212,27216,27217,27223,27240,27249,27270,27323,27327,27347,27367,27405,27408,27422,27423,27487,27492,27499,27526,27541,27568,27570,27578,27583,27592,27595,27601,27671,27688,27707,27717,27758,27786,27922,27924,28019,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28230,28243,28264,28329,28435,28596,28673,28674,28846,28931,28943,29011,29045,29231,29232,29266,29611,29616,29639,29724,29769,29866,30111,30385,31060,31608,31735,31820,31837,31853,32084,32720,32767,32768,33303,33476,33874,33908,33925,33946,33957,34025,34249,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35574,35621,35637,35688,35728,35805,35806,35808,35814,35835,35846,35882,35948,36000,36015,36027,36141,36220,36237,36368,36369,36373,36385,36420,36441,36584,36631,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37544,37626,37644,37677,37902,38058,38092,38126,38133,38330,38433,38489,38546,38617,38723,38799,38821,38824,38829,38877,38904,38912,38922,38949,38965,38990,39155,39205,39290,39293,39296,39366,39442,39476,39497,39508,39559,39587,39610,39686,39717,39724,40319,40328,40509,40560,40624,40647,41062,41171,41289,41332,41345,41516,41781,41969,42637,42987,43003,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44318,44366,44427,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 1069 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.64 ms |
preparing | 0.82 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.12 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.12 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 |