Tiempo de la consulta: 7.36 ms Después de la última consulta: 1.22 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.396 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-09 05:15:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 05:15:33')
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(66,72,127,166,185,188,214,259,328,367,374,405,441,450,461,495,556,608,647,708,709,710,712,713,741,744,752,754,763,783,843,854,975,977,1006,1190,1280,1286,1351,1363,1371,1432,1468,1503,1540,1565,1693,1740,1776,1897,1916,1994,2004,2013,2042,2089,2109,2233,2285,2337,2354,2384,2396,2467,2478,2533,2608,2628,2643,2695,2781,2807,2870,2894,2898,2939,2967,3033,3074,3251,3283,3296,3346,3377,3472,3478,3512,3554,3564,3567,3590,3641,3779,3796,3856,3934,3962,3986,4025,4172,4192,4214,4257,4266,4341,4451,4468,4520,4529,4622,4674,4690,4718,4741,4751,4834,4876,4953,4979,5054,5072,5076,5103,5149,5180,5209,5233,5247,5286,5298,5299,5303,5389,5452,5454,5470,5484,5495,5530,5578,5581,5586,5587,5606,5644,5669,5684,5720,5729,5748,5799,5827,5837,5880,5888,5940,5951,5972,6012,6067,6176,6217,6336,6343,6381,6432,6484,6501,6504,6597,6599,6673,6675,6681,6684,6690,6706,6729,6816,6918,6945,6950,7002,7022,7048,7086,7104,7105,7156,7168,7183,7299,7374,7411,7428,7461,7500,7512,7531,7555,7581,7582,7592,7594,7619,7624,7630,7676,7681,7688,7754,7799,7837,7856,7860,7866,7869,7871,7920,7932,7935,7936,7981,7984,7991,7993,7995,7998,8020,8027,8087,8095,8185,8194,8295,8355,8391,8416,8481,8613,8634,8773,8776,8813,8942,8989,9010,9029,9087,9109,9114,9115,9148,9149,9199,9200,9201,9219,9223,9242,9253,9276,9280,9282,9285,9387,9425,9442,9619,9653,9702,9728,9757,9767,9833,9851,9852,9878,9880,10001,10156,10172,10298,10299,10340,10364,10387,10468,10562,10673,10689,10721,10764,10932,10991,11001,11016,11124,11144,11211,11320,11556,11626,11665,11694,11773,11814,11909,11936,12218,12334,12406,12410,12500,12567,12589,12622,12656,12682,12705,12760,12790,12839,12878,12888,12895,12897,13002,13129,13142,13153,13297,13357,13387,13436,13452,13475,13476,13501,13514,13585,13608,13629,13707,13728,13730,13748,13750,13811,13851,13858,13859,13922,13971,14047,14048,14052,14099,14126,14181,14328,14393,14398,14432,14505,14600,14718,14729,14735,14754,14758,14762,14782,14790,14834,14866,14879,14956,14980,15063,15144,15162,15198,15208,15238,15259,15269,15282,15306,15325,15336,15339,15378,15380,15383,15488,15508,15533,15570,15594,15608,15613,15709,15755,15776,15903,15917,16002,16046,16088,16126,16340,16358,16365,16393,16409,16423,16425,16426,16439,16466,16494,16503,16507,16536,16571,16588,16646,16647,16724,16831,16840,16887,16905,16907,16994,16995,17028,17090,17127,17233,17299,17333,17377,17419,17435,17440,17446,17458,17487,17543,17597,17635,17643,17645,17662,17680,17737,17738,17767,17823,17839,17863,17877,17881,17947,18001,18032,18066,18088,18096,18126,18135,18142,18189,18203,18217,18219,18257,18311,18447,18466,18490,18548,18587,18629,18661,18723,18737,18739,18754,18770,18779,18807,18816,18817,18820,18836,18855,18862,18892,18904,18966,18970,18997,19006,19012,19014,19015,19040,19062,19096,19120,19274,19306,19359,19367,19390,19400,19463,19477,19529,19533,19569,19575,19587,19630,19638,19647,19680,19776,19853,19895,19931,19944,19987,20057,20058,20059,20095,20103,20134,20135,20152,20167,20177,20188,20250,20256,20321,20424,20437,20439,20448,20483,20508,20600,20624,20704,20787,20818,20850,20873,20879,20886,20949,20968,21027,21036,21049,21062,21130,21132,21174,21195,21201,21219,21247,21256,21261,21268,21279,21295,21402,21423,21459,21464,21474,21483,21487,21489,21610,21614,21630,21791,21803,21809,21820,21836,21886,21909,21912,21960,21962,22045,22132,22171,22176,22187,22196,22199,22214,22247,22314,22358,22471,22477,22499,22525,22530,22531,22540,22550,22569,22631,22633,22651,22655,22749,22758,22850,22851,22868,22921,22927,22982,23007,23024,23072,23116,23127,23142,23171,23196,23225,23238,23250,23254,23278,23379,23391,23397,23401,23455,23457,23471,23521,23556,23569,23619,23651,23666,23673,23684,23686,23687,23690,23705,23722,23785,23817,23878,23888,23930,23935,23973,23995,24014,24015,24050,24078,24100,24121,24164,24180,24181,24192,24202,24203,24206,24255,24335,24379,24382,24450,24479,24480,24499,24526,24556,24591,24594,24618,24662,24670,24734,24808,24910,24912,24957,24998,25083,25146,25280,25304,25335,25357,25366,25407,25473,25554,25582,25641,25644,25730,25741,25750,25769,25835,25846,25862,25872,25909,25995,26011,26125,26374,26516,26521,26531,26579,26601,26629,26630,26635,26638,26663,26760,26772,26796,26935,26936,26999,27003,27009,27100,27101,27184,27259,27326,27384,27424,27432,27463,27479,27491,27524,27526,27559,27571,27673,27688,27805,27860,27898,27997,28007,28037,28049,28129,28198,28225,28248,28280,28379,28384,28587,28636,28671,28971,29145,29757,29950,33736,34245,35027,35495,35501,35602,35801,36021,36161,36308,36315,36338,37083,37828,37949,37950,37952,37965,37992,38138,38147,38213,38232,38595,38866,38962,39222,39321,39375,39446,39544,39571,40034,40093,40096,40320,40388,40781,40835,41685,41718,41734,41902,42914,43591,43833,44851,44906,44914,44915,45164)
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 | 844 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.40 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |