Tiempo de la consulta: 3.71 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.199 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-10 02:38:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-10 02:38:31')
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(9,45,46,54,62,65,71,233,306,330,415,463,583,643,659,764,965,1137,1326,1335,1384,1504,1563,1571,1747,2053,2084,2125,2311,2607,2611,2639,2687,2720,2817,2825,2909,3077,3129,3196,3266,3425,3443,3462,3468,3654,3657,3685,3721,3760,3767,3776,3833,3899,3913,3960,4034,4049,4101,4110,4129,4148,4150,4204,4283,4284,4323,4327,4423,4456,4548,4575,4620,4767,4859,4876,4940,5140,5162,5183,5259,5291,5355,5387,5390,5422,5623,5646,5797,5909,6019,6094,6100,6128,6142,6360,6362,6440,6458,6549,6567,6649,6720,6775,6782,6840,6865,6881,7077,7082,7111,7128,7216,7250,7258,7331,7364,7435,7444,7513,7586,7605,7614,7618,7621,7651,7724,7752,7766,7771,7784,7787,7903,7925,7935,7942,7975,8004,8055,8152,8160,8227,8234,8265,8273,8338,8370,8378,8421,8507,8509,8519,8550,8611,8644,8660,8700,8750,8753,8799,8813,8826,8864,8925,8926,8954,9005,9021,9051,9063,9120,9248,9256,9328,9350,9389,9390,9422,9475,9477,9525,9578,9600,9610,9636,9733,9738,9752,9773,9829,9838,9878,9904,9908,9922,9956,9999,10004,10101,10190,10265,10269,10288,10313,10414,10448,10471,10513,10617,10642,10754,10756,10981,10993,11023,11031,11041,11073,11120,11121,11250,11286,11338,11387,11425,11488,11545,11687,11693,11796,11921,12249,12315,12385,12553,12632,12638,12689,12690,12749,12901,12974,13000,13126,13146,13166,13209,13321,13376,13385,13702,13731,13738,13760,13789,13930,13946,13961,13996,14141,14169,14198,14310,14351,14396,14428,14512,14513,14515,14532,14601,14616,14631,14662,14730,14739,14760,14820,14824,14825,14847,14923,14939,14953,14984,14999,15006,15041,15069,15081,15118,15148,15160,15178,15193,15268,15306,15326,15347,15388,15411,15421,15423,15457,15465,15482,15487,15506,15516,15551,15570,15611,15613,15617,15636,15637,15640,15738,15767,15783,15866,15913,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16214,16248,16256,16292,16314,16315,16403,16413,16421,16446,16552,16577,16581,16719,16759,16828,16876,16890,16920,16991,16998,17053,17074,17102,17115,17145,17151,17160,17216,17233,17373,17408,17458,17468,17595,17633,17640,17650,17655,17721,17735,17746,17844,17855,17859,17893,17926,17966,17968,18054,18062,18088,18122,18151,18157,18180,18233,18241,18255,18274,18292,18314,18344,18348,18362,18374,18396,18446,18460,18539,18544,18551,18564,18601,18608,18609,18664,18709,18775,18800,18846,18862,18878,18908,18916,18922,18931,18933,18949,18954,18975,18980,18992,19019,19028,19034,19042,19104,19105,19124,19128,19135,19155,19218,19240,19247,19313,19315,19346,19366,19530,19550,19561,19604,19637,19652,19713,19732,19752,19816,19835,19852,19872,19922,19945,20018,20030,20052,20071,20127,20250,20260,20264,20327,20348,20376,20393,20429,20444,20448,20461,20602,20649,20678,20741,20779,20797,20813,20828,20850,20860,20869,20906,20915,20959,20967,21000,21057,21062,21103,21107,21108,21117,21132,21143,21161,21190,21249,21325,21342,21369,21381,21397,21434,21435,21439,21458,21464,21489,21508,21552,21554,21559,21578,21590,21591,21617,21641,21648,21700,21710,21740,21744,21761,21764,21767,21776,21777,21808,21855,21858,21883,21894,21907,21944,21971,21976,21982,22010,22040,22063,22160,22162,22164,22176,22214,22237,22249,22285,22298,22313,22348,22407,22459,22461,22515,22560,22568,22617,22647,22733,22739,22763,22819,22837,22889,22890,22904,22957,23017,23065,23067,23072,23131,23185,23190,23194,23195,23201,23237,23241,23260,23264,23265,23280,23302,23313,23320,23325,23326,23328,23335,23339,23351,23374,23452,23455,23476,23510,23517,23582,23675,23678,23679,23806,23882,23884,23890,24075,24102,24104,24148,24152,24191,24248,24273,24274,24327,24366,24371,24392,24407,24503,24592,24644,24727,24733,24816,24837,24844,24899,24913,24964,24975,25053,25072,25089,25098,25107,25122,25125,25133,25225,25253,25355,25377,25380,25439,25522,25535,25644,25645,25714,25730,25785,25850,25891,25993,26062,26082,26116,26178,26183,26256,26273,26334,26362,26493,26501,26504,26521,26563,26587,26615,26648,26652,26690,26694,26731,26758,26802,26806,26814,26901,26906,26926,26972,27002,27011,27141,27150,27170,27246,27273,27315,27321,27357,27397,27418,27431,27496,27521,27532,27545,27585,27592,27593,27616,27629,27635,27644,27686,27704,27721,27842,27873,27907,27917,27931,27936,27985,28005,28033,28045,28081,28082,28225,28312,28361,28411,28445,28636,28639,28652,28653,28658,28728,28963,28989,29008,29009,29152,29153,29174,29197,29289,29319,29356,29417,29418,29443,29444,29476,29781,29886,29905,29922,29923,29935,31239,32646,32768,32842,33628,33983,33993,34143,34149,34195,34198,34796,34808,34864,35062,35617,35674,35689,35792,35883,35885,36051,36300,37056,37408,37475,38807,38831,38854,38866,39225,39453,39481,39499,39590,39601,39681,39714,39857,39933,39953,40025,40038,40083,40097,40170,40200,40422,40708,40759,40785,40809,40837,40907,40914,40937,40984,41059,41255,41256,41301,41311,41325,41372,41374,41375,41378,41467,41823,41915,41958,41972,41988,42035,42053,42107,42110,42223,42251,42390,42444,42669,43055,43100,43101,43102,43253,43388,43750,43783,44070,44218,44219,44267,44743,45103,45272,45296)
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 | 860 | 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.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.47 ms |
preparing | 0.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |