Tiempo de la consulta: 5.80 ms Después de la última consulta: 1.44 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.380 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-05 03:50:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:50: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(14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,72,78,113,114,124,127,136,198,204,207,208,215,219,221,253,254,263,272,276,309,325,328,330,349,353,377,393,394,417,418,431,452,484,505,507,548,550,551,555,583,587,608,667,686,693,705,709,801,816,882,895,917,961,968,986,994,1059,1124,1134,1198,1204,1207,1226,1238,1273,1287,1325,1328,1347,1352,1388,1389,1390,1394,1412,1464,1475,1587,1594,1611,1712,1747,1754,1787,1797,1800,1839,1952,2012,2024,2048,2053,2085,2086,2150,2151,2185,2290,2293,2355,2429,2482,2520,2532,2580,2687,2689,2719,2726,2758,2797,2825,2900,2901,2991,3017,3026,3067,3117,3144,3188,3193,3269,3306,3318,3323,3337,3353,3442,3495,3512,3517,3626,3668,3674,3696,3709,3769,3776,3837,3991,4000,4004,4092,4109,4127,4301,4378,4410,4538,4580,4611,4620,4631,4640,4835,4955,5043,5045,5051,5096,5154,5190,5220,5243,5263,5301,5357,5365,5417,5451,5544,5582,5583,5634,5637,5644,5646,5660,5666,5678,5702,5726,5727,5730,5732,5768,5777,5779,5794,5795,5798,5804,5831,5910,5919,5923,5992,5997,6000,6003,6007,6011,6016,6022,6087,6112,6135,6183,6186,6220,6237,6245,6258,6261,6266,6312,6355,6367,6390,6420,6457,6476,6477,6503,6521,6564,6596,6604,6605,6616,6708,6716,6733,6749,6764,6766,6793,6848,6855,6939,6989,7032,7048,7067,7245,7254,7280,7282,7311,7368,7387,7402,7403,7410,7413,7473,7484,7492,7527,7549,7576,7595,7606,7614,7618,7626,7711,7716,7720,7745,7760,7802,7811,7836,7853,7890,7902,7950,7958,7965,7969,7980,7994,8009,8027,8062,8064,8073,8078,8081,8084,8095,8107,8108,8164,8177,8178,8215,8218,8240,8351,8356,8374,8398,8420,8461,8546,8566,8568,8573,8587,8610,8637,8826,8861,8875,9057,9068,9093,9139,9175,9182,9184,9186,9237,9251,9254,9257,9277,9307,9351,9357,9362,9394,9408,9430,9431,9440,9509,9521,9540,9572,9576,9589,9629,9644,9660,9697,9711,9729,9734,9745,9792,9820,9823,9850,9864,9899,9932,9934,9945,9992,10051,10092,10110,10113,10120,10181,10213,10216,10237,10248,10260,10277,10282,10318,10361,10369,10370,10385,10399,10415,10444,10477,10478,10554,10603,10666,10686,10708,10720,10798,10857,10888,10912,10971,11006,11091,11116,11123,11131,11140,11149,11188,11235,11290,11302,11320,11388,11487,11559,11706,11726,11762,11779,11900,11922,11925,12032,12081,12126,12186,12217,12237,12242,12243,12250,12251,12258,12334,12369,12426,12463,12465,12474,12493,12520,12539,12568,12590,12608,12739,12746,12788,12799,12806,12873,12907,13006,13010,13013,13020,13035,13036,13037,13041,13058,13062,13126,13130,13137,13143,13169,13176,13186,13190,13191,13215,13238,13246,13249,13259,13263,13285,13309,13325,13365,13383,13387,13390,13415,13426,13432,13434,13452,13453,13456,13459,13466,13481,13497,13558,13566,13573,13590,13609,13621,13625,13631,13634,13662,13673,13674,13702,13782,13805,13817,13833,13835,13860,13867,13881,13906,13953,13986,13994,14005,14024,14062,14113,14143,14177,14184,14193,14205,14223,14227,14261,14273,14283,14339,14348,14368,14388,14408,14456,14461,14498,14530,14558,14571,14600,14624,14651,14652,14680,14684,14692,14695,14712,14725,14754,14775,14794,14805,14810,14815,14818,14869,14885,14888,14904,14914,14941,14953,14978,14984,15010,15028,15054,15096,15108,15120,15138,15147,15196,15215,15231,15235,15243,15244,15263,15266,15292,15304,15340,15356,15370,15402,15439,15464,15469,15477,15485,15490,15521,15522,15540,15547,15548,15550,15551,15552,15562,15581,15602,15604,15612,15623,15630,15655,15662,15664,15666,15703,15704,15707,15709,15725,15728,15730,15742,15753,15763,15778,15785,15797,15799,15806,15835,15837,15840,15841,15866,15873,15897,15902,15922,15925,15937,15955,15965,15993,16005,16008,16013,16015,16020,16026,16035,16037,16050,16058,16074,16093,16102,16117,16122,16143,16153,16157,16166,16185,16213,16219,16228,16242,16250,16254,16257,16262,16265,16279,16316,16324,16330,16346,16369,16370,16386,16402,16417,16422,16451,16479,16513,16539,16547,16588,16605,16619,16644,16657,16675,16695,16722,16724,16735,16783,16825,16833,16834,16839,16845,16867,16917,16930,16942,16947,17045,17059,17084,17115,17117,17128,17132,17160,17172,17194,17201,17240,17244,17257,17288,17291,17300,17331,17337,17353,17365,17371,17373,17386,17407,17409,17420,17432,17465,17493,17530,17531,17533,17552,17553,17569,17575,17584,17590,17623,17626,17635,17680,17688,17700,17712,17721,17747,17753,17766,17772,17775,17783,17826,17850,17852,17862,17875,17887,17889,17895,17922,17950,17952,17955,17976,17977,17980,17987,17996,18006,18022,18031,18036,18038,18057,18060,18068,18072,18087,18106,18116,18121,18140,18151,18169,18200,18216,18227,18253,18260,18278,18297,18311,18314,18316,18317,18320,18331,18342,18378,18391,18397,18402,18425,18428,18431,18440,18444,18473,18481,18493,18512,18514,18524,18541,18542,18543,18547,18552,18566,18571,18572,18582,18626,18638,18642,18646,18649,18655,18659,18663,18668,18679,18687,18693,18706,18738,18766,18781,18792,18793,18811,18830,18837,18849,18853,18868,18874,18891,18892,18914,18929,18930,18943,18951,18956,18977,18978,18991,19013,19033,19038,19053,19059,19062,19078,19082,19083,19130,19145,19160,19164,19168,19219,19220,19235,19236,19237,19267,19271,19275,19293,19318,19379,19387,19411,19427,19432,19435,19448,19457,19484,19505,19517,19519,19526,19531,19535,19553,19556,19592,19595,19596,19612,19639,19645,19646,19659,19699,19700,19706,19720,19728,19740,19754,19766,19796,19841,19894,19916,19927,19929,19953,19976,19984,19989,19996,20012,20016,20038,20052,20062,20068,20076,20097,20100,20120,20133,20137,20150,20153,20154,20181,20186,20191,20212,20295,20296,20297,20333,20337,20349,20366,20385,20403,20405,20411,20432,20502,20524,20572,20601,20616,20632,20649,20697,20713,20714,20721,20726,20733,20738,20744,20750,20754,20792,20805,20807,20821,20830,20858,20880,20885,20896,20906,20917,20932,20949,20960,20963,20966,20980,20997,20999,21002,21006,21009,21027,21040,21041,21047,21050,21055,21069,21102,21104,21115,21116,21128,21159,21166,21171,21172,21185,21195,21198,21213,21228,21233,21241,21250,21251,21258,21262,21305,21313,21316,21331,21368,21390,21398,21418,21425,21430,21445,21463,21472,21481,21495,21520,21539,21540,21543,21576,21586,21611,21632,21640,21648,21668,21682,21703,21705,21709,21734,21748,21781,21813,21853,21887,21907,21916,21924,21947,21952,21977,21992,22003,22021,22038,22045,22066,22087,22103,22112,22153,22154,22192,22216,22235,22236,22238,22249,22271,22289,22295,22334,22341,22349,22353,22371,22388,22395,22402,22411,22419,22458,22476,22484,22494,22498,22500,22503,22509,22512,22514,22530,22531,22540,22543,22550,22564,22587,22590,22595,22596,22602,22615,22616,22653,22661,22665,22708,22709,22718,22738,22746,22759,22761,22765,22768,22772,22799,22804,22850,22876,22888,22889,22891,22909,22924,22931,22943,22989,23023,23028,23035,23064,23071,23082,23083,23087,23094,23107,23112,23122,23123,23131,23140,23181,23194,23210,23213,23219,23242,23252,23256,23258,23272,23279,23299,23302,23309,23312,23336,23339,23354,23358,23359,23398,23418,23424,23428,23429,23435,23440,23449,23465,23469,23476,23489,23516,23527,23532,23541,23550,23555,23556,23567,23571,23577,23592,23613,23627,23649,23657,23682,23693,23698,23708,23722,23727,23729,23743,23765,23784,23793,23800,23809,23811,23816,23826,23849,23855,23861,23898,23899,23945,23967,23973,23984,24027,24065,24088,24101,24102,24105,24111,24125,24135,24158,24159,24166,24168,24177,24198,24199,24229,24270,24282,24283,24286,24289,24303,24333,24337,24372,24375,24386,24402,24406,24426,24457,24473,24475,24498,24536,24540,24545,24572,24577,24607,24656,24658,24662,24713,24722,24751,24765,24783,24784,24796,24800,24809,24814,24819,24823,24835,24838,24853,24859,24881,24924,24930,24941,24944,24958,24962,24975,24981,24984,25035,25042,25048,25049,25063,25083,25093,25096,25097,25112,25118,25129,25142,25151,25155,25157,25165,25169,25180,25183,25205,25214,25257,25268,25287,25312,25342,25349,25352,25355,25358,25365,25397,25416,25417,25418,25421,25449,25456,25462,25474,25477,25488,25537,25541,25548,25553,25557,25558,25564,25589,25595,25610,25628,25635,25668,25734,25771,25797,25809,25819,25847,25870,25887,25926,25958,25969,26010,26014,26020,26028,26043,26044,26048,26049,26063,26082,26159,26166,26179,26234,26249,26258,26282,26305,26363,26367,26369,26466,26508,26540,26541,26564,26570,26590,26597,26636,26711,26720,26726,26744,26779,26807,26835,26842,26845,26860,26916,26933,26944,26947,26999,27001,27039,27076,27084,27094,27108,27109,27126,27131,27137,27192,27209,27221,27252,27268,27269,27270,27307,27327,27363,27466,27470,27487,27499,27506,27552,27574,27717,27786,27856,27871,27926,27949,27968,27975,28005,28033,28107,28114,28128,28279,28303,28318,28325,28464,28621,28764,28771,28872,28892,28907,28908,28911,28943,28950,28951,28972,28973,29049,29140,29171,29172,29194,29208,29210,29349,29358,29438,29495,29509,29510,29512,29535,29576,29625,29642,29653,29673,29846,29863,29912,29939,30111,30433,30434,30449,30478,31623,31624,31697,31890,33282,33871,33874,33998,34258,35000,35333,35375,35637,35660,35661,35727,35777,35814,35956,36079,36889,38000,38691,38728,38900,38986,39131,39172,39184,39333,39465,39483,39698,39710,39866,40072,40224,40259,40351,40355,40651,40673,40875,40993,41074,41121,41211,41239,41483,42479,43401,44848)
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 | 1579 | 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.84 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.34 ms |
preparing | 1.24 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.01 ms |
freeing items | 0.07 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 |