Tiempo de la consulta: 4.12 ms Después de la última consulta: 0.72 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.338 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 03:08:34')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 03:08:34')
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(20,78,79,80,81,82,83,86,120,121,122,123,124,155,165,175,180,185,212,214,271,279,284,285,303,325,349,368,385,417,434,450,451,458,495,520,531,572,664,666,667,670,677,701,728,741,744,808,840,856,863,869,870,885,933,940,951,954,974,986,987,1010,1081,1091,1101,1102,1123,1207,1216,1277,1278,1279,1304,1327,1344,1357,1365,1519,1538,1614,1648,1656,1691,1716,1735,1739,1846,1860,1867,1879,1899,1953,2023,2188,2328,2345,2402,2468,2610,2647,2648,2799,2948,2954,3024,3034,3106,3107,3174,3305,3369,3402,3409,3412,3415,3439,3454,3577,3594,3648,3651,3663,3911,3963,3982,4155,4191,4249,4257,4323,4333,4381,4503,4533,4587,4589,4704,4710,4823,4990,5085,5086,5151,5157,5168,5300,5396,5413,5461,5478,5536,5662,5857,5894,5896,5913,5973,6120,6173,6178,6389,6470,6472,6473,6600,6639,6654,6681,6790,6876,6955,6971,6994,7022,7025,7109,7122,7168,7191,7246,7449,7459,7478,7547,7568,7720,7728,7736,7744,7747,7755,7764,7818,7830,7841,7851,7860,7897,7924,7930,7965,7966,8020,8027,8046,8090,8116,8118,8462,8502,8525,8555,8663,8809,8864,8952,9018,9029,9082,9087,9272,9364,9491,9836,9924,9960,10048,10280,10299,10302,10395,10412,10443,10475,10478,10540,10560,10630,10780,10801,10856,10887,10915,11022,11059,11060,11098,11146,11229,11278,11367,11415,11447,11472,11555,11747,12030,12133,12190,12293,12379,12401,12410,12416,12444,12472,12515,12559,12563,12567,12572,12620,12624,12625,12637,12708,12716,12837,12875,12913,12917,13017,13029,13062,13084,13147,13161,13177,13178,13213,13278,13294,13298,13387,13388,13456,13550,13588,13589,13596,13635,13658,13671,13687,13707,13730,13763,13836,13841,13842,13925,13972,13975,14092,14105,14108,14142,14264,14271,14273,14350,14453,14456,14477,14600,14634,14635,14646,14648,14729,14786,14833,14891,14895,14961,14987,15004,15030,15032,15037,15089,15151,15152,15153,15170,15209,15242,15247,15262,15304,15382,15403,15424,15439,15492,15542,15560,15562,15575,15590,15594,15626,15717,15728,15741,15752,15766,15774,15818,15937,15978,15991,16001,16024,16085,16103,16123,16129,16140,16161,16190,16206,16217,16257,16281,16301,16325,16392,16436,16497,16534,16543,16558,16561,16606,16623,16652,16657,16695,16713,16717,16750,16850,16909,16929,16936,16966,17000,17085,17088,17105,17116,17136,17157,17192,17215,17253,17327,17336,17347,17358,17432,17464,17468,17486,17538,17567,17585,17596,17635,17657,17659,17669,17702,17721,17759,17761,17766,17818,17831,17961,17968,17992,18005,18036,18042,18049,18143,18214,18246,18260,18261,18274,18309,18316,18326,18358,18384,18419,18438,18442,18455,18459,18464,18469,18498,18520,18543,18555,18565,18577,18612,18647,18648,18665,18682,18689,18695,18739,18744,18789,18792,18847,18848,18901,18905,18910,18961,18972,18973,18991,19006,19018,19022,19025,19060,19061,19074,19083,19086,19105,19123,19152,19171,19185,19207,19210,19226,19247,19249,19252,19274,19275,19292,19294,19304,19310,19321,19366,19383,19386,19396,19416,19419,19435,19442,19453,19484,19495,19524,19551,19567,19601,19604,19648,19650,19659,19661,19663,19700,19733,19751,19814,19867,19876,19932,19986,19988,19991,20015,20031,20036,20056,20083,20086,20087,20099,20103,20162,20163,20179,20183,20214,20216,20225,20243,20256,20335,20354,20374,20389,20440,20460,20464,20496,20513,20562,20578,20579,20649,20659,20664,20680,20689,20704,20710,20732,20737,20758,20768,20798,20804,20812,20874,20892,20898,20928,20975,20981,20991,20996,21047,21140,21161,21178,21194,21252,21259,21328,21349,21369,21386,21388,21452,21516,21522,21536,21555,21590,21618,21640,21681,21689,21704,21709,21719,21891,21906,21912,21962,21988,22038,22052,22059,22061,22122,22222,22228,22244,22245,22246,22296,22311,22393,22401,22446,22481,22495,22500,22502,22527,22709,22742,22744,22751,22752,22804,22805,22822,22829,22874,22895,22899,22924,22961,22963,22976,23034,23081,23109,23124,23251,23256,23297,23300,23408,23453,23471,23559,23565,23573,23591,23609,23614,23759,23763,23779,23814,23839,23857,23889,23900,23921,23922,23929,23930,23955,23962,23967,23988,23995,24061,24072,24076,24131,24141,24144,24174,24200,24225,24253,24264,24274,24282,24292,24364,24422,24455,24472,24513,24528,24570,24618,24624,24651,24668,24781,24807,24888,24924,24928,24942,24943,24968,24979,24989,25035,25048,25100,25126,25141,25154,25222,25226,25242,25245,25360,25525,25543,25548,25556,25624,25673,25680,25818,25955,26122,26124,26237,26405,26454,26499,26591,26592,26604,26665,26689,26698,26760,26772,26779,26808,26820,26867,26898,26910,26939,26958,26985,26996,27012,27024,27026,27055,27058,27065,27076,27131,27151,27153,27186,27213,27247,27269,27323,27356,27367,27444,27460,27490,27502,27518,27520,27545,27552,27635,27738,27757,27778,27827,27894,27939,28022,28030,28169,28248,28255,28336,28437,28452,28511,28521,28528,28561,28664,28678,28681,28734,28845,28877,29108,29143,29237,29356,29365,29374,29391,29511,29805,29833,29908,30404,30674,30696,30864,30947,31850,31907,35144,35762,35856,35926,35962,35988,36053,36184,36398,37373,38302,38886,39269,39464,39615,39681,39877,40072,40181,40213,40267,40503,40685,40771,40882,40955,41183,41337,41548,41613,42019,43130,43482,43911)
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 | 882 | 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.50 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.18 ms |
| System lock | 0.02 ms |
| optimizing | 0.07 ms |
| statistics | 1.37 ms |
| preparing | 0.69 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.31 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 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 |
Consejo del Plan Estratégico de la Provincia Espaillat (PEDEPE).
