Tiempo de la consulta: 5.29 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.449 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 10:00:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 10:00:26')
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(9,11,49,58,80,101,112,147,148,149,150,151,152,153,154,155,156,170,172,185,210,267,287,290,291,293,344,353,361,365,385,389,391,403,428,437,458,493,501,516,523,607,633,672,686,693,701,710,756,797,799,811,813,843,844,868,870,887,936,950,953,956,965,970,986,997,1018,1053,1075,1077,1083,1091,1117,1129,1130,1139,1185,1186,1207,1212,1232,1233,1243,1247,1277,1291,1298,1321,1331,1339,1431,1455,1486,1503,1601,1785,1817,1821,1835,1931,1945,2013,2021,2045,2072,2089,2092,2101,2198,2314,2338,2376,2473,2477,2523,2543,2644,2713,2757,2827,2857,2881,2964,2997,3020,3028,3045,3124,3210,3212,3292,3322,3329,3346,3442,3444,3453,3509,3519,3671,3692,3738,3803,3842,3869,3887,3901,3961,3986,4006,4013,4076,4120,4128,4221,4268,4281,4356,4399,4405,4670,4722,4723,4750,4800,4837,5021,5048,5150,5157,5300,5348,5471,5488,5525,5537,5559,5565,5567,5597,5622,5628,5638,5647,5648,5685,5746,5871,5894,5970,6035,6039,6045,6131,6147,6188,6209,6234,6257,6260,6266,6274,6290,6307,6310,6362,6392,6466,6470,6473,6478,6484,6493,6550,6557,6574,6614,6616,6633,6654,6688,6694,6702,6725,6726,6744,6749,6785,6821,6854,6869,6883,6905,6911,6955,6971,6998,7101,7120,7133,7210,7266,7276,7281,7285,7287,7289,7296,7298,7315,7328,7334,7344,7361,7432,7435,7456,7465,7471,7483,7497,7519,7544,7596,7627,7647,7673,7677,7688,7710,7749,7797,7798,7806,7829,7837,7847,7848,7858,7863,7894,7913,7936,7938,7943,7965,7977,7993,7998,7999,8027,8032,8047,8076,8093,8190,8250,8290,8352,8354,8373,8404,8406,8411,8449,8502,8543,8551,8663,8666,8679,8736,8754,8932,8974,9029,9051,9075,9107,9150,9155,9195,9197,9200,9242,9282,9286,9305,9318,9344,9355,9392,9507,9562,9563,9616,9625,9626,9800,9825,9857,9864,9965,9970,10011,10025,10047,10066,10068,10090,10091,10099,10100,10115,10134,10138,10149,10157,10167,10206,10216,10239,10257,10264,10315,10344,10382,10413,10425,10480,10535,10559,10572,10611,10623,10644,10658,10705,10721,10741,10779,10782,10797,10802,10890,10907,10925,10952,10957,10964,11001,11006,11059,11091,11102,11207,11214,11231,11327,11352,11360,11371,11404,11456,11532,11554,11693,11694,11697,11730,11874,11884,11896,11924,11926,11947,12073,12134,12135,12152,12165,12188,12221,12222,12259,12270,12274,12282,12301,12341,12398,12435,12440,12459,12461,12482,12510,12532,12581,12582,12598,12613,12625,12714,12716,12758,12799,12835,12850,12851,12884,12890,12902,12978,13010,13061,13067,13078,13087,13088,13100,13145,13157,13159,13213,13220,13223,13241,13253,13298,13307,13332,13408,13413,13420,13465,13474,13481,13487,13515,13519,13530,13534,13544,13546,13557,13635,13662,13674,13691,13811,13846,13847,13850,13853,13863,13870,13894,13963,13972,13974,13980,13990,14076,14103,14106,14107,14122,14135,14140,14161,14176,14189,14194,14205,14206,14236,14240,14280,14285,14292,14293,14372,14386,14392,14401,14414,14419,14435,14448,14453,14457,14464,14473,14496,14512,14581,14586,14591,14595,14596,14598,14630,14631,14638,14665,14698,14706,14725,14769,14773,14789,14813,14829,14830,14845,14847,14852,14854,14856,14865,14882,14911,14920,14925,14935,14983,14999,15007,15038,15039,15063,15083,15094,15129,15156,15158,15171,15177,15187,15214,15224,15233,15246,15259,15262,15270,15272,15293,15323,15335,15346,15351,15361,15376,15406,15407,15412,15413,15418,15424,15425,15429,15469,15475,15487,15516,15520,15522,15538,15553,15581,15600,15631,15642,15689,15700,15705,15712,15742,15761,15781,15785,15790,15812,15816,15842,15850,15863,15875,15880,15937,15943,15981,15987,15997,16014,16024,16029,16043,16056,16090,16095,16098,16101,16127,16129,16155,16173,16182,16189,16211,16232,16237,16249,16281,16285,16301,16319,16323,16338,16357,16359,16360,16384,16410,16416,16427,16438,16503,16521,16524,16526,16539,16547,16551,16557,16561,16564,16567,16571,16585,16626,16668,16675,16682,16689,16717,16781,16808,16816,16822,16836,16840,16841,16851,16857,16859,16863,16876,16896,16905,16907,16950,16951,16977,17002,17014,17023,17049,17058,17065,17067,17086,17093,17116,17132,17148,17188,17193,17233,17240,17242,17246,17253,17273,17282,17287,17288,17331,17343,17344,17360,17367,17376,17381,17387,17390,17443,17444,17470,17490,17497,17509,17511,17522,17537,17539,17561,17572,17573,17592,17614,17618,17630,17631,17642,17659,17701,17705,17711,17727,17736,17738,17753,17759,17771,17772,17779,17782,17800,17809,17818,17822,17826,17834,17853,17862,17879,17893,17911,17919,17920,17930,17936,17950,17967,17983,17987,18022,18038,18041,18044,18049,18052,18061,18074,18083,18105,18142,18173,18219,18220,18222,18234,18260,18295,18299,18311,18326,18352,18371,18382,18406,18412,18450,18488,18505,18552,18554,18572,18602,18648,18664,18693,18696,18728,18822,18830,18833,18866,18877,18878,18880,18888,18893,18905,18911,18953,19004,19014,19015,19018,19024,19029,19040,19060,19063,19105,19124,19128,19140,19155,19173,19183,19217,19231,19246,19283,19287,19297,19308,19315,19323,19381,19384,19407,19430,19431,19433,19441,19457,19467,19482,19486,19583,19591,19607,19617,19624,19639,19648,19650,19677,19684,19710,19718,19725,19733,19747,19794,19807,19816,19833,19854,19921,19923,19929,20000,20015,20119,20127,20162,20175,20179,20233,20289,20295,20325,20333,20414,20423,20445,20452,20522,20542,20607,20615,20638,20641,20650,20659,20664,20710,20711,20717,20737,20772,20777,20801,20826,20877,20913,20915,20919,20940,20944,20947,20959,21079,21080,21117,21118,21126,21128,21135,21143,21158,21187,21192,21223,21270,21291,21297,21302,21323,21344,21367,21372,21398,21400,21421,21457,21460,21470,21496,21520,21522,21549,21555,21590,21599,21614,21663,21681,21684,21702,21741,21757,21764,21776,21778,21780,21803,21846,21879,21883,21906,21917,21968,21987,21997,22011,22018,22035,22038,22040,22058,22067,22089,22106,22119,22157,22178,22202,22278,22298,22306,22359,22408,22450,22460,22476,22484,22506,22523,22527,22555,22570,22606,22607,22632,22725,22753,22759,22820,22840,22909,22923,22934,22935,22944,22960,22972,22974,22976,23011,23019,23034,23040,23074,23093,23139,23160,23196,23215,23221,23242,23250,23279,23297,23357,23367,23368,23398,23405,23430,23438,23439,23454,23456,23491,23525,23538,23553,23555,23562,23574,23585,23602,23616,23708,23718,23759,23761,23826,23849,23853,23878,23882,23898,23910,23936,23955,23958,23968,24025,24034,24047,24076,24112,24162,24164,24186,24216,24220,24237,24307,24326,24329,24364,24424,24429,24462,24480,24526,24530,24577,24584,24668,24690,24721,24779,24790,24793,24805,24841,24849,24868,24883,24910,24941,24946,24963,24975,24996,25037,25070,25071,25080,25081,25117,25126,25153,25173,25211,25221,25280,25297,25310,25329,25332,25352,25403,25452,25523,25535,25548,25611,25653,25676,25737,25747,25779,25785,25807,25919,25921,25949,25971,26008,26013,26040,26050,26093,26117,26221,26229,26248,26261,26333,26358,26366,26367,26373,26390,26393,26404,26410,26429,26430,26444,26498,26530,26534,26583,26596,26606,26698,26742,26778,26854,26873,26910,26959,26992,27001,27002,27009,27024,27055,27061,27062,27082,27101,27143,27158,27184,27218,27274,27290,27293,27338,27382,27552,27578,27642,27646,27707,27745,27758,27851,27944,27950,28013,28066,28075,28082,28094,28203,28213,28256,28264,28283,28614,28616,28627,28681,28683,28739,28749,28785,28826,28851,29061,29073,29098,29105,29106,29331,29372,29378,29417,29426,29446,29539,29582,29617,29618,29714,29719,29760,29791,29853,29920,29937,30265,31115,31167,31763,31873,32069,32552,32676,32840,33042,33044,33317,33884,33885,33886,34111,34115,34284,34623,34667,34668,34669,34788,34892,34902,35126,35195,35235,35472,35511,35650,35701,35710,35744,35831,35833,35882,35943,35948,35990,36042,36047,36095,36136,36324,36343,36414,36614,36761,36880,37066,37088,37506,38293,38346,38411,38552,38651,39088,39142,39158,39269,39345,39370,39411,39513,39693,39780,39781,39857,39883,39959,39981,39998,40104,40168,40203,40238,40356,40401,40483,40583,40611,41236,41250,41253,41254,42232,42260,42951,43429,43602,43644,43652,44971,45064)
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 | 1362 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 1.98 ms |
preparing | 1.02 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.08 ms |
cleaning up | 0.08 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 |