Tiempo de la consulta: 4.43 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.321 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 04:14:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 04:14:24')
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(3,8,57,97,99,112,124,138,155,180,198,210,215,219,221,224,232,238,243,244,245,249,276,289,309,318,325,328,330,337,357,385,394,395,406,414,417,418,423,424,426,427,433,451,452,459,468,481,489,494,497,521,524,525,527,528,529,532,548,553,555,557,565,567,587,595,596,597,603,604,614,620,628,632,641,646,647,659,662,681,686,730,733,737,740,746,771,781,788,792,800,802,805,818,833,840,842,852,864,872,889,894,901,902,909,910,925,928,943,962,994,1007,1008,1015,1058,1062,1066,1072,1100,1114,1119,1132,1145,1146,1165,1174,1182,1190,1200,1210,1227,1256,1264,1268,1272,1274,1276,1278,1282,1285,1297,1325,1328,1355,1388,1389,1390,1394,1412,1465,1504,1526,1712,1754,1776,1797,1800,1803,1839,1853,1907,1960,1971,1973,2007,2012,2048,2053,2086,2124,2185,2331,2355,2429,2463,2520,2532,2559,2580,2589,2617,2687,2706,2790,2811,2852,3017,3026,3027,3060,3082,3128,3156,3167,3181,3182,3193,3224,3240,3244,3269,3317,3318,3330,3337,3344,3363,3364,3387,3415,3416,3417,3423,3444,3473,3512,3517,3520,3573,3704,3709,3776,3792,3832,3836,3853,3905,3943,4000,4008,4029,4035,4084,4224,4234,4235,4273,4301,4313,4331,4332,4361,4362,4364,4391,4444,4491,4538,4560,4561,4580,4619,4620,4675,4732,4752,4822,4832,4835,4848,4880,4955,5000,5028,5037,5043,5045,5074,5096,5101,5195,5220,5243,5263,5269,5285,5301,5357,5390,5417,5423,5577,5582,5583,5636,5637,5644,5646,5648,5678,5702,5732,5759,5777,5779,5780,5794,5795,5803,5804,5831,5834,5859,5899,5910,5919,5923,5942,5978,5997,6000,6009,6011,6022,6087,6112,6160,6220,6233,6258,6266,6312,6343,6390,6429,6615,6758,6802,6848,6855,6885,6941,7037,7048,7242,7278,7297,7432,7473,7549,7580,7581,7622,7716,7771,7811,7958,7969,8009,8050,8062,8070,8077,8078,8081,8084,8087,8105,8178,8218,8229,8303,8314,8374,8398,8417,8443,8512,8617,8763,8815,9004,9011,9093,9121,9139,9163,9174,9175,9182,9184,9186,9237,9251,9277,9307,9362,9430,9431,9516,9572,9655,9660,9697,9700,9709,9814,9850,9899,9934,9970,10046,10140,10213,10361,10405,10467,10481,10603,10677,10708,10720,10734,10753,10875,10893,10917,11040,11081,11131,11137,11240,11302,11482,11552,11559,11669,11681,11792,11822,11853,11880,12040,12137,12217,12242,12255,12426,12439,12458,12550,12568,12590,12668,12788,12806,12949,12974,12982,13013,13083,13152,13186,13215,13238,13263,13285,13325,13358,13365,13383,13415,13432,13436,13459,13556,13558,13566,13579,13590,13609,13617,13625,13626,13729,13753,13822,13833,13875,13881,13903,13986,13987,14015,14029,14134,14159,14177,14193,14218,14238,14337,14571,14577,14616,14631,14651,14680,14688,14700,14725,14810,14885,14904,14914,14927,14928,14940,14941,14957,14997,15006,15054,15091,15096,15138,15175,15235,15244,15261,15292,15303,15314,15405,15469,15490,15518,15537,15540,15547,15550,15579,15602,15612,15623,15627,15630,15654,15666,15667,15707,15752,15762,15835,15859,15902,15925,15927,15937,15942,15973,16005,16013,16015,16021,16023,16024,16117,16122,16142,16162,16165,16213,16219,16260,16265,16304,16316,16318,16336,16382,16402,16417,16443,16479,16588,16641,16775,16833,16905,16916,16924,16940,16944,16947,16968,16969,17045,17054,17137,17160,17203,17206,17238,17268,17371,17416,17535,17584,17683,17721,17750,17799,17863,17976,17977,18006,18035,18036,18040,18067,18068,18076,18151,18168,18235,18253,18297,18312,18313,18378,18421,18422,18437,18534,18535,18542,18547,18599,18655,18747,18752,18766,18792,18803,18804,18835,18851,18853,18857,18868,18874,18923,18931,18934,18950,18954,18956,18973,18977,18980,18996,19038,19053,19062,19066,19082,19113,19156,19164,19172,19197,19267,19275,19293,19365,19426,19481,19493,19573,19592,19618,19641,19678,19742,19745,19778,19796,19835,19876,19900,19924,19950,19964,19976,20038,20080,20129,20145,20184,20235,20267,20289,20310,20337,20387,20502,20570,20572,20575,20601,20650,20689,20697,20733,20740,20750,20808,20821,20828,20858,20879,20917,20963,20966,20997,20999,21040,21041,21047,21050,21059,21069,21070,21100,21102,21114,21159,21185,21195,21204,21230,21261,21279,21291,21311,21313,21342,21361,21383,21490,21559,21647,21648,21691,21703,21705,21737,21760,21810,21815,21820,21844,21848,21929,21948,21955,21985,21986,22036,22131,22158,22161,22173,22201,22338,22345,22353,22376,22408,22540,22541,22550,22569,22591,22592,22615,22738,22743,22758,22816,22860,22955,23011,23051,23082,23084,23085,23164,23173,23181,23217,23253,23258,23268,23275,23302,23336,23354,23358,23379,23392,23398,23424,23425,23434,23435,23449,23460,23514,23561,23573,23606,23645,23713,23785,23803,23826,23871,23894,23911,23945,23979,24011,24085,24087,24144,24151,24155,24199,24234,24247,24289,24300,24303,24309,24386,24387,24500,24502,24545,24549,24572,24575,24606,24644,24662,24719,24727,24731,24876,24962,25061,25083,25214,25256,25325,25456,25465,25538,25545,25610,25626,25628,25652,25670,25695,25819,25845,25865,25906,25983,26014,26019,26049,26056,26080,26334,26379,26447,26473,26489,26507,26582,26681,26700,26728,26734,26838,26890,27048,27088,27142,27144,27146,27164,27179,27206,27307,27312,27313,27362,27470,27694,28072,28325,28416,28423,28453,28547,28733,28886,28898,29164,29221,29417,29589,29621,29640,29696,30111,30478,31533,31899,33874,34220,35127,35333,35428,35776,35862,36004,36109,36564,37289,37656,37865,38000,38691,38763,39036,39616,39726,39984,39997,40053,40533,40913,41074,41460,42330,42444,43388,43436,44866)
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 | 955 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.57 ms |
preparing | 1.02 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.51 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 |