Tiempo de la consulta: 6.40 ms Después de la última consulta: 2.36 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.417 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 00:16:01')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 00:16:01')
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,14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,60,61,62,63,64,65,67,68,71,72,75,119,127,165,175,180,185,203,204,205,206,222,225,250,253,255,256,263,271,278,281,283,308,323,327,329,331,344,350,353,370,371,380,385,387,388,390,392,393,395,397,398,400,402,403,404,405,408,410,411,417,429,433,435,436,437,438,442,443,445,448,451,454,455,484,495,505,507,550,551,583,586,589,608,657,667,686,689,697,701,705,709,717,722,760,801,808,816,832,844,856,857,863,868,882,883,895,906,917,937,940,961,968,978,1024,1033,1059,1080,1101,1102,1121,1124,1134,1168,1187,1198,1204,1207,1208,1216,1226,1233,1238,1250,1290,1305,1319,1347,1436,1458,1459,1469,1491,1506,1562,1587,1594,1636,1658,1684,1698,1735,1745,1787,1788,1849,1851,1887,1917,1946,1975,2005,2016,2024,2069,2101,2112,2150,2162,2254,2266,2290,2293,2322,2353,2394,2482,2517,2569,2596,2605,2637,2674,2693,2713,2726,2732,2758,2797,2804,2962,2967,3001,3065,3106,3107,3154,3183,3193,3208,3303,3306,3312,3329,3340,3343,3346,3353,3442,3463,3493,3495,3569,3592,3597,3626,3684,3696,3732,3750,3754,3769,3786,3837,3880,3982,3983,4004,4063,4092,4249,4410,4492,4563,4580,4587,4631,4640,4641,4688,4765,4808,4848,5051,5079,5093,5095,5123,5199,5279,5365,5451,5513,5634,5660,5726,5727,5730,5798,5814,5833,5894,6062,6102,6186,6245,6301,6315,6354,6363,6367,6372,6381,6393,6400,6470,6475,6503,6542,6543,6570,6593,6604,6605,6616,6650,6708,6748,6764,6783,6793,6807,6808,6840,6889,6939,6964,6997,7018,7026,7091,7105,7125,7194,7220,7245,7248,7296,7368,7405,7413,7421,7432,7484,7488,7492,7569,7583,7588,7591,7596,7597,7618,7630,7711,7720,7749,7801,7802,7838,7839,7860,7917,7931,7946,7950,7965,7966,7980,7981,7985,7994,7998,8027,8073,8088,8115,8130,8206,8351,8406,8531,8551,8555,8566,8568,8587,8610,8613,8740,8760,8864,8907,8910,8937,9048,9056,9057,9082,9152,9200,9257,9314,9316,9351,9416,9472,9532,9556,9574,9658,9734,9745,9757,9764,9792,9820,9825,9860,9895,9934,9944,9945,10051,10059,10120,10164,10188,10195,10216,10237,10243,10248,10260,10273,10280,10282,10369,10383,10385,10462,10478,10554,10561,10666,10686,10757,10834,10857,10888,10912,10925,10971,10973,11006,11008,11022,11035,11091,11123,11129,11150,11195,11269,11290,11299,11318,11320,11366,11377,11388,11391,11410,11482,11487,11565,11651,11688,11711,11762,11822,11854,11900,11925,12032,12042,12126,12150,12186,12237,12238,12251,12337,12369,12388,12424,12445,12463,12474,12482,12493,12519,12567,12608,12624,12625,12668,12670,12750,12780,12902,12913,12940,12944,12973,12978,13004,13020,13029,13036,13038,13129,13143,13152,13153,13166,13176,13190,13191,13246,13259,13309,13348,13434,13456,13524,13530,13548,13550,13560,13573,13609,13621,13631,13641,13657,13662,13673,13674,13702,13712,13725,13748,13750,13763,13770,13783,13792,13816,13821,13855,13860,13867,13900,13924,13934,13950,13986,13994,14005,14052,14062,14081,14103,14148,14149,14153,14159,14183,14184,14188,14197,14205,14226,14227,14229,14249,14273,14336,14339,14348,14354,14368,14408,14424,14428,14451,14456,14570,14596,14600,14624,14652,14675,14684,14687,14692,14711,14769,14794,14815,14850,14856,14860,14862,14892,14895,14906,14911,14941,14958,15003,15018,15028,15038,15049,15058,15108,15114,15120,15145,15147,15183,15196,15212,15215,15243,15244,15248,15263,15266,15304,15356,15359,15368,15370,15402,15439,15464,15475,15476,15477,15485,15493,15496,15500,15521,15522,15548,15551,15562,15577,15596,15604,15606,15632,15645,15664,15669,15674,15703,15709,15719,15725,15728,15763,15832,15837,15841,15843,15866,15873,15897,15901,15955,15957,15975,16020,16037,16050,16083,16091,16093,16153,16166,16176,16178,16201,16218,16255,16257,16264,16321,16322,16325,16334,16369,16370,16432,16446,16450,16451,16464,16513,16520,16521,16539,16550,16556,16603,16605,16619,16629,16644,16684,16706,16713,16722,16733,16734,16748,16791,16808,16825,16830,16845,16861,16867,16876,16909,16936,17014,17050,17059,17060,17086,17100,17115,17128,17131,17132,17134,17138,17142,17157,17194,17197,17210,17244,17251,17253,17257,17291,17309,17337,17339,17362,17373,17407,17420,17424,17427,17432,17443,17456,17465,17470,17471,17493,17500,17521,17533,17543,17552,17559,17569,17608,17623,17626,17630,17655,17688,17690,17713,17746,17747,17753,17761,17766,17772,17775,17810,17826,17835,17852,17870,17875,17883,17889,17895,17918,17931,17933,17938,17952,17980,17987,17988,17994,18031,18032,18038,18043,18057,18072,18112,18113,18116,18129,18140,18142,18160,18162,18169,18200,18216,18229,18260,18285,18295,18300,18311,18314,18316,18326,18331,18358,18364,18402,18409,18425,18431,18440,18467,18481,18493,18494,18514,18520,18521,18524,18543,18566,18567,18612,18629,18646,18649,18659,18668,18671,18679,18687,18717,18720,18738,18751,18762,18763,18772,18781,18793,18826,18828,18837,18867,18891,18901,18914,18916,18930,18951,18978,18991,19002,19013,19047,19053,19059,19060,19067,19078,19083,19086,19126,19133,19134,19145,19148,19168,19170,19180,19185,19217,19219,19223,19237,19253,19260,19271,19276,19293,19313,19318,19327,19352,19376,19411,19420,19427,19448,19457,19460,19505,19519,19526,19532,19535,19553,19556,19562,19577,19595,19596,19612,19620,19633,19645,19646,19652,19653,19668,19687,19693,19699,19700,19703,19720,19732,19733,19806,19811,19828,19841,19855,19870,19871,19873,19875,19894,19908,19909,19953,19998,20010,20012,20016,20023,20028,20032,20056,20076,20086,20094,20117,20133,20137,20141,20153,20154,20156,20161,20163,20170,20181,20187,20198,20234,20256,20263,20271,20289,20295,20303,20349,20353,20403,20432,20449,20450,20471,20472,20516,20524,20535,20564,20579,20630,20649,20698,20714,20721,20726,20729,20738,20744,20757,20795,20807,20840,20866,20880,20896,20906,20980,20982,20993,21040,21050,21115,21149,21156,21165,21171,21173,21189,21198,21213,21225,21251,21255,21274,21314,21331,21347,21369,21397,21405,21422,21430,21432,21433,21472,21481,21491,21498,21513,21517,21539,21545,21565,21576,21586,21606,21611,21620,21636,21640,21668,21678,21694,21709,21732,21734,21738,21740,21746,21748,21750,21751,21764,21768,21775,21781,21819,21846,21854,21870,21916,21926,21950,21952,21980,21995,22021,22026,22038,22040,22045,22066,22087,22097,22099,22100,22113,22137,22146,22153,22180,22192,22194,22216,22229,22234,22238,22270,22276,22286,22289,22294,22295,22296,22297,22315,22334,22337,22361,22371,22385,22388,22402,22411,22414,22458,22476,22489,22500,22503,22509,22534,22543,22554,22559,22572,22587,22596,22602,22611,22647,22673,22692,22708,22712,22720,22738,22774,22784,22848,22854,22876,22888,22891,22899,22903,22908,22924,22931,22943,22960,22980,22988,22999,23016,23019,23022,23023,23028,23040,23064,23078,23107,23110,23122,23131,23147,23156,23186,23198,23210,23219,23229,23236,23245,23247,23258,23260,23269,23275,23281,23295,23299,23312,23319,23325,23332,23374,23388,23399,23402,23424,23428,23430,23469,23485,23489,23492,23495,23541,23555,23566,23567,23585,23592,23610,23613,23618,23636,23647,23649,23654,23657,23685,23722,23729,23732,23764,23793,23811,23840,23845,23850,23855,23858,23861,23899,23921,23967,23973,23984,24012,24028,24059,24088,24105,24111,24119,24135,24152,24158,24166,24168,24192,24194,24198,24229,24242,24277,24282,24284,24288,24289,24312,24340,24342,24375,24383,24398,24440,24450,24451,24479,24489,24498,24499,24536,24540,24586,24601,24605,24607,24617,24639,24643,24653,24658,24705,24707,24713,24722,24747,24765,24784,24791,24804,24814,24819,24823,24826,24838,24841,24853,24881,24884,24891,24897,24909,24922,24924,24941,24944,24958,25043,25045,25048,25091,25093,25133,25147,25155,25183,25184,25205,25222,25230,25242,25264,25268,25293,25312,25315,25333,25342,25349,25365,25397,25413,25417,25421,25449,25474,25488,25541,25553,25557,25560,25595,25631,25635,25640,25648,25668,25702,25711,25775,25787,25797,25798,25816,25847,25870,25872,25906,25940,25958,25968,25969,26017,26020,26034,26043,26048,26053,26061,26154,26159,26166,26179,26188,26202,26215,26249,26261,26282,26305,26315,26317,26363,26369,26378,26405,26410,26439,26464,26471,26508,26564,26570,26590,26630,26636,26640,26679,26708,26726,26763,26766,26770,26779,26807,26860,26866,26885,26897,26992,27030,27071,27084,27086,27131,27138,27141,27143,27161,27178,27208,27317,27321,27322,27363,27475,27513,27518,27552,27560,27574,27582,27724,27949,27968,27974,28005,28033,28107,28114,28128,28303,28318,28336,28454,28495,28548,28552,28621,28714,28764,28771,28779,28872,28882,28889,28927,28943,28950,29107,29143,29172,29187,29200,29210,29358,29412,29438,29454,29509,29510,29512,29625,29653,29743,29802,29846,29863,30000,30433,30434,30609,30740,30854,31129,31560,31604,31697,31773,31890,31937,32241,32905,33621,33950,34428,34524,34584,34758,34927,35000,35259,35305,35505,35603,35660,35661,35718,35727,35777,35814,35926,36160,36197,36423,36671,36889,37025,37942,38662,38784,38818,38865,38887,38905,38962,39078,39226,39271,39296,39333,39342,39465,39483,39629,39673,39698,39710,39808,39823,39866,40015,40116,40224,40259,40355,40588,40651,40672,40812,40875,40954,41239,41254,41532,41594,41794,42074,42262,43499,43538,44277,45191,45262,45277,45278)
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 | 1577 | 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 | 1.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.69 ms |
preparing | 1.18 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 ms |
cleaning up | 0.04 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 |