Tiempo de la consulta: 4.20 ms Después de la última consulta: 0.87 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.176 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-08 06:55:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 06:55:36')
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(78,85,120,121,122,123,124,155,214,279,282,285,303,349,437,446,450,495,531,572,660,666,667,669,670,671,746,774,800,808,863,869,885,954,986,1054,1101,1102,1123,1216,1278,1279,1304,1386,1458,1538,1601,1644,1648,1846,1867,2328,2372,2402,2591,2647,2713,2853,2954,3106,3107,3174,3219,3229,3252,3369,3402,3409,3412,3449,3454,3577,3633,3663,3698,3784,3971,3974,4503,4527,4589,4674,4676,4823,4952,5300,5396,5461,5478,5536,5725,5857,5913,6097,6120,6178,6288,6399,6514,6621,6639,6748,6826,6841,6876,6895,7009,7122,7149,7246,7314,7449,7478,7523,7534,7547,7548,7551,7581,7618,7682,7700,7711,7720,7736,7746,7779,7793,7797,7808,7818,7829,7841,7847,7897,7924,7984,8016,8046,8090,8113,8116,8118,8142,8209,8210,8264,8270,8280,8282,8312,8382,8387,8700,8851,8862,8864,8874,9001,9029,9087,9106,9124,9239,9265,9313,9364,9441,9548,9584,9589,9730,9836,9905,9949,10052,10061,10100,10122,10199,10332,10398,10475,10478,10498,10575,10611,10630,10656,10675,10771,10801,11059,11095,11164,11360,11379,11427,11431,11472,11474,11648,11658,11776,11796,11905,11911,11920,12051,12096,12121,12156,12299,12401,12410,12412,12460,12565,12620,12625,12637,12651,12708,12718,12743,12754,12865,12875,13017,13110,13294,13298,13412,13633,13644,13671,13687,13707,13842,13975,13998,14092,14105,14142,14163,14199,14242,14271,14273,14348,14359,14373,14378,14456,14469,14480,14482,14502,14508,14580,14608,14637,14646,14654,14673,14701,14722,14726,14747,14814,14896,14897,14964,14987,15004,15030,15032,15037,15084,15107,15154,15174,15181,15247,15283,15325,15358,15375,15382,15403,15410,15412,15417,15424,15439,15492,15542,15562,15575,15580,15693,15717,15728,15729,15762,15794,15840,15901,15954,15955,15977,16040,16056,16071,16079,16097,16126,16140,16161,16173,16203,16206,16257,16279,16337,16355,16370,16484,16497,16518,16534,16543,16556,16611,16621,16627,16652,16657,16660,16715,16822,16927,16929,16936,17000,17036,17145,17162,17193,17215,17269,17278,17347,17358,17408,17432,17433,17437,17449,17486,17500,17511,17596,17610,17659,17675,17702,17728,17753,17766,17818,17831,17918,17961,18001,18031,18057,18143,18215,18222,18248,18262,18263,18274,18275,18282,18309,18311,18315,18316,18326,18376,18384,18404,18406,18419,18435,18442,18498,18519,18543,18555,18573,18577,18612,18682,18689,18695,18724,18732,18739,18762,18786,18804,18821,18847,18848,18852,18901,18910,18933,18948,18952,18961,18966,18991,19007,19018,19022,19053,19061,19062,19083,19086,19104,19105,19106,19121,19152,19171,19185,19207,19247,19254,19260,19267,19274,19294,19304,19350,19366,19386,19396,19405,19416,19434,19437,19440,19442,19453,19462,19508,19509,19523,19524,19567,19592,19601,19604,19650,19654,19658,19661,19668,19700,19733,19761,19762,19774,19827,19856,19857,19867,19885,19932,19957,19982,19991,20035,20036,20053,20064,20099,20103,20117,20127,20162,20183,20213,20214,20216,20243,20263,20343,20352,20354,20374,20440,20459,20464,20489,20518,20543,20545,20578,20579,20630,20649,20659,20666,20681,20691,20716,20726,20768,20782,20810,20826,20837,20841,20862,20876,20906,20956,20982,20986,21002,21005,21010,21135,21142,21161,21167,21172,21178,21222,21252,21262,21269,21286,21312,21313,21324,21346,21366,21388,21436,21452,21466,21501,21516,21522,21536,21545,21585,21588,21591,21596,21647,21664,21709,21727,21783,21851,21860,21906,21912,21969,21988,22002,22013,22017,22059,22081,22087,22098,22115,22153,22156,22162,22170,22175,22210,22216,22222,22239,22244,22245,22246,22389,22411,22432,22500,22502,22511,22518,22523,22527,22534,22539,22647,22666,22671,22680,22742,22743,22744,22779,22804,22805,22829,22872,22874,22895,22923,22924,22949,22963,22985,23013,23034,23036,23064,23081,23093,23117,23124,23127,23157,23202,23203,23251,23256,23257,23264,23277,23300,23305,23315,23318,23358,23408,23440,23463,23465,23480,23524,23527,23544,23565,23574,23602,23730,23743,23746,23759,23763,23785,23839,23857,23876,23881,23893,23900,23902,23913,23922,23930,23955,23962,23967,24016,24072,24076,24082,24088,24101,24110,24141,24174,24188,24197,24210,24213,24264,24270,24282,24369,24390,24395,24412,24414,24422,24425,24456,24472,24486,24496,24503,24563,24577,24598,24618,24624,24663,24668,24679,24692,24764,24773,24852,24924,24943,24968,24979,24984,24989,25046,25048,25100,25126,25142,25157,25205,25233,25245,25320,25326,25348,25360,25374,25376,25405,25416,25418,25548,25624,25639,25673,25691,25785,25818,25904,25955,26042,26066,26120,26122,26131,26136,26146,26147,26161,26164,26168,26172,26344,26379,26415,26434,26452,26453,26454,26562,26651,26665,26671,26673,26677,26706,26710,26772,26779,26808,26810,26811,26827,26861,26898,26900,26910,26924,26925,26939,26940,26971,26996,27024,27026,27057,27085,27128,27131,27151,27153,27155,27171,27186,27213,27232,27247,27316,27356,27363,27393,27395,27438,27485,27490,27505,27520,27545,27738,27739,27743,27761,27777,27821,27922,27937,28163,28322,28336,28351,28425,28441,28452,28465,28606,28609,28739,28786,28789,28845,29004,29005,29017,29037,29053,29065,29105,29142,29155,29208,29460,29484,29502,29550,29563,29608,29635,29682,29742,29760,29801,29803,29895,29897,30723,31850,33969,34239,35144,35495,39269,40213,40772,43564)
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 | 878 | 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.04 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.44 ms |
preparing | 0.74 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |