Tiempo de la consulta: 3.20 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.490 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-06 21:03:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 21:03:52')
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(76,133,165,188,192,323,334,341,390,505,507,593,690,729,795,805,808,841,908,914,931,942,969,1036,1051,1052,1069,1101,1125,1162,1193,1194,1216,1231,1285,1401,1414,1447,1459,1464,1473,1492,1521,1591,1645,1694,1769,1771,1978,2013,2089,2250,2543,2569,2802,2958,2961,2967,3099,3114,3227,3249,3409,3444,3604,3651,3749,3832,3898,3910,3984,3986,4301,4353,4381,4383,4410,4726,4732,4750,4810,5076,5078,5221,5273,5332,5348,5353,5393,5424,5560,5584,5680,5700,6038,6049,6058,6309,6331,6345,6353,6356,6370,6395,6469,6492,6539,6548,6557,6577,6614,6664,6670,6671,6883,6919,7062,7338,7596,7621,7699,7710,7748,7913,7914,8032,8076,8080,8089,8290,8327,8373,8377,8404,8530,8551,8577,8655,8744,8784,8819,8859,8907,8939,8943,9028,9051,9115,9283,9313,9364,9544,9554,9756,9849,9857,10006,10090,10091,10155,10198,10355,10576,10622,10652,10658,10689,10890,10947,11064,11138,11195,11207,11330,11494,11531,11532,11533,11534,11557,11618,11621,11693,11696,11699,11727,11834,11841,11927,11930,11937,11965,12023,12138,12141,12152,12189,12193,12205,12207,12244,12270,12331,12333,12430,12477,12479,12494,12531,12535,12628,12704,12726,12802,12933,12942,12954,12983,13023,13025,13050,13086,13107,13112,13188,13220,13230,13232,13269,13363,13477,13567,13637,13672,13678,13704,13707,13744,13781,13798,13937,13962,13974,13980,14016,14105,14135,14224,14338,14348,14374,14480,14602,14705,14789,14795,14876,14890,15074,15218,15300,15323,15327,15456,15531,15546,15568,15572,15589,15625,15760,15821,15827,15834,15896,15904,15915,15943,15973,15992,16014,16017,16051,16066,16108,16115,16209,16216,16230,16246,16269,16361,16387,16390,16398,16444,16454,16529,16538,16546,16596,16604,16642,16698,16700,16706,16829,16850,16851,16892,16912,16977,17001,17040,17043,17087,17135,17148,17166,17173,17177,17178,17189,17202,17224,17239,17301,17338,17349,17356,17377,17378,17460,17462,17474,17493,17526,17545,17617,17678,17695,17753,17806,17807,17811,17842,17870,17883,18042,18050,18078,18089,18140,18166,18249,18292,18363,18407,18452,18456,18457,18476,18485,18487,18525,18534,18535,18622,18623,18669,18688,18702,18703,18781,18789,18817,18832,18833,18835,18838,18879,18893,18945,18979,18996,19046,19162,19203,19241,19283,19300,19308,19356,19364,19439,19482,19514,19518,19541,19554,19649,19664,19673,19720,19729,19776,19779,19800,19823,19870,19893,19938,20002,20040,20046,20055,20082,20159,20167,20189,20199,20230,20236,20311,20323,20394,20402,20408,20422,20438,20452,20453,20456,20500,20503,20531,20533,20576,20643,20652,20677,20698,20774,20825,20905,20911,20915,20921,20981,20992,21044,21060,21094,21162,21215,21227,21284,21291,21293,21304,21309,21328,21333,21335,21337,21341,21364,21415,21441,21465,21480,21482,21567,21619,21622,21699,21704,21794,21801,21803,21809,21815,21822,21830,21834,21840,21848,21862,21900,21922,21941,21962,22015,22057,22104,22131,22154,22200,22202,22351,22373,22422,22565,22607,22740,22766,22774,22793,22802,22818,22827,22829,22882,22889,22926,22934,22992,23014,23019,23035,23040,23104,23106,23126,23145,23151,23178,23196,23250,23290,23332,23343,23376,23453,23454,23474,23481,23513,23530,23570,23574,23648,23652,23676,23677,23738,23749,23798,23807,23828,23833,23935,23948,23965,23998,24068,24158,24172,24216,24224,24228,24229,24271,24289,24300,24309,24427,24443,24462,24477,24510,24529,24535,24625,24630,24636,24685,24851,24919,24995,25018,25090,25110,25286,25334,25398,25400,25511,25550,25594,25612,25658,25707,25717,25736,25740,25745,25794,25801,25842,25860,25885,25892,25906,26002,26021,26091,26123,26130,26155,26195,26264,26360,26373,26396,26403,26458,26534,26550,26599,26602,26637,26702,26753,26758,26792,26838,26902,26907,26917,27039,27052,27105,27106,27142,27144,27164,27166,27178,27179,27189,27201,27203,27265,27337,27343,27409,27457,27548,27549,27800,29054,29366,29464,29511,29626,30242,30393,30394,30511,30932,31525,32056,32831,32914,33544,34052,34146,34415,34449,34525,34560,34683,34701,34723,34733,34978,35192,35321,35324,35436,35503,35609,35626,35790,35836,35852,35859,35925,35953,35958,36014,36192,36204,36238,36515,36736,36850,37479,37553,37581,38263,38658,38659,38660,38779,38788,38815,38842,39114,39381,39438,39729,39740,39820,39846,40024,40111,40187,40212,40225,40239,40392,40521,40622,40665,40831,40886,40917,40983,41059,41146,41159,41248,41508,41525,41526,41931,41963,42880,43182,43216,43217,43236,43501,43875,43876,43905,44255,44433,44853,44924,44925,45251)
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 | 754 | 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.36 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.19 ms |
preparing | 0.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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 |