Tiempo de la consulta: 5.60 ms Después de la última consulta: 2.15 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.241 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 09:44:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 09:44:53')
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,14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,45,46,49,54,62,65,71,72,127,132,204,253,263,272,290,353,415,484,505,507,550,551,583,608,622,643,659,667,686,705,709,764,777,801,805,816,882,895,917,949,961,968,1035,1059,1124,1134,1198,1204,1207,1226,1232,1234,1238,1329,1335,1347,1563,1571,1587,1591,1594,1611,1619,1668,1694,1781,1787,1795,1951,1979,2001,2024,2025,2084,2150,2290,2293,2482,2681,2685,2707,2726,2758,2761,2793,2797,2800,2909,3193,3196,3231,3266,3303,3306,3324,3353,3442,3443,3453,3469,3495,3626,3685,3696,3760,3767,3769,3776,3833,3837,3838,3913,3960,4004,4018,4034,4092,4101,4110,4129,4148,4150,4174,4204,4263,4284,4307,4323,4327,4378,4410,4423,4456,4548,4575,4580,4631,4640,4859,4940,4943,5023,5051,5201,5259,5365,5387,5422,5451,5537,5634,5660,5686,5726,5727,5730,5798,5827,5837,5909,5916,5968,6100,6128,6157,6184,6186,6245,6360,6362,6367,6440,6503,6604,6605,6616,6649,6708,6720,6764,6793,6820,6865,6881,6882,6939,6971,7077,7089,7111,7180,7210,7216,7245,7250,7258,7331,7364,7368,7413,7444,7484,7492,7586,7605,7614,7618,7651,7711,7720,7724,7752,7771,7784,7787,7802,7862,7903,7925,7935,7942,7950,7965,7980,7994,8004,8027,8055,8073,8152,8160,8227,8234,8258,8265,8351,8357,8370,8378,8421,8435,8507,8550,8566,8568,8587,8610,8611,8621,8644,8660,8700,8741,8750,8753,8799,8813,8826,8864,8898,8908,8913,8925,8954,8981,9063,9120,9246,9257,9266,9314,9328,9350,9351,9390,9427,9477,9578,9600,9610,9630,9734,9738,9745,9792,9820,9829,9838,9878,9904,9906,9908,9922,9945,9956,10004,10051,10190,10216,10237,10248,10260,10265,10269,10282,10313,10369,10385,10414,10448,10463,10478,10513,10529,10554,10617,10642,10666,10686,10754,10756,10857,10888,10912,10971,10993,11006,11023,11031,11041,11073,11091,11104,11121,11123,11195,11250,11286,11290,11320,11338,11387,11388,11403,11487,11488,11545,11687,11694,11762,11796,11839,11900,11921,11925,11970,12032,12126,12186,12237,12249,12251,12297,12338,12369,12463,12474,12490,12493,12495,12553,12608,12632,12638,12666,12680,12689,12690,12725,13020,13143,13146,13166,13176,13190,13191,13209,13246,13259,13309,13376,13385,13434,13456,13535,13573,13609,13621,13631,13662,13673,13674,13702,13731,13738,13760,13789,13860,13867,13946,13961,13986,13994,13996,14005,14062,14106,14141,14151,14184,14205,14213,14227,14273,14339,14348,14351,14357,14368,14396,14401,14408,14455,14456,14512,14513,14515,14532,14600,14601,14616,14624,14652,14662,14684,14692,14730,14739,14746,14794,14815,14820,14824,14825,14926,14939,14941,14986,14999,15006,15007,15028,15041,15049,15069,15079,15081,15108,15110,15120,15134,15147,15148,15160,15173,15178,15193,15196,15215,15226,15243,15256,15263,15266,15268,15304,15326,15347,15355,15356,15370,15388,15402,15408,15423,15439,15457,15464,15465,15475,15477,15482,15483,15485,15487,15521,15548,15551,15562,15570,15604,15611,15617,15636,15637,15640,15648,15664,15692,15696,15703,15709,15718,15725,15728,15730,15738,15739,15763,15767,15783,15809,15837,15840,15841,15866,15873,15907,15913,15955,15973,16020,16036,16037,16039,16042,16050,16059,16082,16084,16086,16093,16097,16127,16129,16153,16156,16164,16166,16181,16248,16256,16257,16261,16292,16314,16315,16358,16369,16370,16373,16403,16451,16463,16513,16539,16549,16552,16577,16586,16599,16605,16619,16644,16667,16678,16722,16759,16788,16789,16822,16825,16828,16845,16846,16867,16890,16991,17053,17059,17067,17074,17102,17115,17128,17132,17145,17160,17194,17216,17233,17244,17257,17288,17291,17331,17337,17373,17407,17420,17432,17465,17468,17482,17493,17516,17533,17552,17569,17623,17626,17633,17650,17665,17688,17747,17766,17772,17775,17844,17852,17855,17859,17875,17885,17889,17893,17895,17896,17915,17926,17951,17952,17966,17980,17987,18031,18038,18054,18057,18058,18062,18072,18116,18122,18140,18150,18152,18157,18169,18180,18200,18216,18233,18242,18255,18260,18274,18292,18311,18314,18316,18331,18344,18345,18351,18362,18402,18425,18431,18440,18449,18457,18460,18481,18493,18514,18524,18539,18543,18544,18564,18566,18579,18608,18622,18646,18649,18659,18668,18679,18680,18681,18687,18709,18738,18758,18781,18793,18800,18837,18846,18862,18878,18891,18914,18916,18922,18930,18931,18935,18951,18954,18975,18978,18980,18991,19013,19028,19034,19042,19053,19059,19078,19083,19105,19124,19128,19135,19155,19168,19218,19219,19230,19237,19240,19247,19271,19293,19313,19318,19366,19411,19427,19448,19457,19463,19464,19505,19519,19526,19530,19535,19550,19553,19556,19561,19595,19596,19604,19612,19637,19645,19646,19652,19699,19700,19713,19720,19732,19818,19841,19852,19872,19894,19945,19953,20012,20016,20018,20030,20076,20077,20101,20119,20127,20133,20137,20153,20154,20181,20204,20222,20250,20260,20264,20295,20327,20348,20349,20376,20393,20403,20423,20429,20432,20444,20445,20461,20466,20470,20474,20524,20602,20613,20649,20678,20688,20714,20721,20726,20738,20741,20744,20757,20771,20779,20797,20803,20807,20813,20828,20846,20850,20880,20889,20896,20906,20915,20937,20959,20974,20980,20993,20996,21000,21010,21015,21057,21058,21062,21081,21107,21108,21115,21143,21149,21161,21171,21190,21198,21213,21243,21249,21251,21300,21325,21331,21347,21369,21381,21394,21397,21430,21434,21435,21458,21464,21472,21481,21489,21498,21506,21539,21552,21554,21576,21578,21586,21590,21606,21611,21614,21641,21652,21668,21709,21710,21716,21734,21740,21744,21748,21750,21764,21776,21777,21781,21842,21855,21858,21883,21894,21898,21910,21916,21944,21951,21952,21976,21982,21996,22010,22014,22021,22026,22038,22040,22045,22063,22066,22087,22151,22153,22160,22176,22192,22214,22216,22237,22238,22279,22289,22295,22298,22313,22334,22335,22348,22349,22371,22388,22402,22407,22455,22458,22459,22461,22476,22477,22500,22503,22509,22535,22540,22543,22576,22587,22602,22614,22617,22647,22679,22708,22733,22738,22739,22763,22771,22773,22819,22837,22848,22876,22888,22889,22890,22891,22900,22904,22924,22931,22943,22957,22971,23023,23028,23047,23064,23065,23067,23107,23122,23156,23185,23195,23201,23210,23213,23219,23222,23236,23237,23241,23247,23258,23260,23280,23299,23312,23313,23320,23325,23326,23328,23335,23339,23376,23394,23428,23469,23489,23525,23541,23567,23582,23592,23607,23613,23649,23657,23672,23678,23679,23722,23729,23748,23776,23792,23793,23811,23831,23832,23855,23861,23872,23890,23899,23967,23973,23984,24023,24075,24084,24088,24102,24104,24105,24111,24135,24152,24158,24166,24186,24191,24198,24229,24273,24274,24282,24288,24289,24327,24342,24366,24371,24375,24384,24392,24403,24449,24495,24498,24503,24516,24536,24561,24592,24607,24623,24637,24644,24658,24712,24713,24722,24727,24731,24733,24737,24748,24765,24784,24814,24816,24819,24823,24837,24838,24844,24853,24856,24881,24899,24924,24944,24958,24964,24973,25023,25034,25048,25072,25093,25098,25107,25125,25133,25155,25182,25183,25205,25225,25241,25253,25260,25268,25312,25342,25349,25365,25377,25380,25397,25417,25421,25449,25474,25488,25541,25553,25557,25595,25622,25635,25644,25645,25668,25714,25730,25748,25771,25785,25797,25847,25850,25870,25881,25920,25958,25969,25993,26020,26048,26159,26166,26178,26179,26183,26249,26256,26263,26273,26282,26305,26328,26342,26363,26369,26493,26501,26504,26508,26521,26524,26563,26564,26570,26590,26636,26648,26726,26779,26860,26901,26926,26954,26972,27002,27011,27080,27084,27131,27150,27170,27185,27246,27273,27277,27321,27363,27416,27418,27431,27496,27521,27543,27545,27574,27593,27644,27686,27704,27721,27757,27842,27917,27931,27936,28005,28033,28045,28082,28107,28114,28128,28225,28277,28303,28312,28318,28411,28621,28639,28643,28653,28658,28659,28764,28771,28872,28943,28950,28989,29008,29009,29018,29097,29152,29153,29167,29172,29174,29197,29210,29319,29356,29358,29417,29438,29443,29444,29476,29509,29510,29512,29625,29653,29781,29783,29846,29863,29905,29922,29923,29926,29935,30433,30434,31697,31890,32386,32577,32768,32842,33256,33709,34410,34430,34613,34617,35000,35204,35617,35660,35661,35686,35689,35727,35777,35814,35883,35885,35952,36096,36131,36186,36237,36241,36257,36307,36404,36487,36494,36559,36889,36949,37893,38088,38092,38111,38189,38190,38191,38219,38268,38269,38270,38271,38272,38310,38313,38340,38414,38447,38548,38584,38591,38600,38692,38697,38711,38763,38807,38831,38843,38851,38854,38866,38915,38942,39029,39125,39180,39197,39279,39280,39323,39333,39352,39391,39465,39467,39481,39483,39510,39596,39603,39681,39693,39698,39710,39738,39857,39866,39952,40005,40025,40038,40050,40068,40083,40097,40108,40170,40200,40224,40252,40259,40340,40355,40407,40473,40520,40534,40586,40651,40689,40692,40708,40759,40785,40809,40825,40875,40907,40929,40930,40937,40938,40984,41059,41076,41141,41166,41239,41252,41253,41255,41301,41325,41344,41375,41405,41419,41484,41635,41790,41992,42038,42060,42117,42144,42262,42292,42328,42511,42570,42645,42670,42822,42942,43020,43073,43229,43283,43534,43587,43691,43802,43803,43804,43894,44155,44262,44308,44606,44607,44608,44615,44672,44684,44728,44801,44869,44923,45184,45234)
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 | 1534 | 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.72 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.31 ms |
preparing | 1.16 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 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 |