Tiempo de la consulta: 3.47 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.303 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 13:20:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:20:26')
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(178,179,281,294,316,329,855,1295,1322,1490,1673,1755,1823,1905,1929,1943,2015,2022,2381,2481,2594,2607,2740,2787,2838,2902,2922,2945,2960,2970,2972,2975,3035,3116,3177,3199,3247,3328,3427,3514,3567,3781,3790,3979,3991,3995,3997,4001,4013,4084,4090,4152,4170,4217,4230,4282,4454,4494,4547,4627,4715,4733,4748,4776,4842,4857,4859,4891,4893,4933,5033,5061,5071,5083,5129,5152,5175,5178,5237,5238,5269,5329,5350,5383,5438,5631,5657,5665,5684,5690,5691,5774,5800,5819,5909,5920,5933,5972,5998,6004,6024,6028,6048,6054,6069,6078,6094,6095,6185,6383,6414,6418,6454,6496,6550,6559,6581,6714,6797,6817,6866,6896,6899,6930,6982,7071,7076,7079,7088,7115,7145,7174,7205,7224,7320,7341,7353,7354,7395,7397,7398,7451,7546,7608,7610,7656,7657,7687,7737,7765,7766,7769,7770,7787,7814,7971,8014,8068,8131,8142,8202,8210,8212,8235,8246,8247,8248,8280,8284,8308,8311,8320,8330,8332,8335,8346,8375,8388,8396,8408,8426,8429,8452,8471,8492,8506,8510,8531,8546,8571,8632,8653,8656,8690,8691,8717,8722,8740,8755,8761,8771,8785,8790,8812,8816,8840,8845,8866,8888,8921,8923,8952,8971,8976,8983,8986,8987,8995,9039,9042,9127,9130,9151,9157,9180,9187,9297,9330,9334,9342,9347,9365,9382,9403,9407,9450,9480,9505,9585,9604,9636,9639,9683,9688,9693,9694,9712,9773,9799,9815,9840,9842,9883,9913,9943,9972,9973,9988,9990,9994,9995,10021,10074,10084,10087,10108,10135,10152,10224,10253,10269,10278,10335,10342,10359,10392,10394,10395,10411,10491,10522,10564,10573,10636,10640,10695,10841,10867,10939,10953,10963,10983,11023,11031,11074,11075,11115,11149,11154,11193,11239,11253,11255,11284,11581,11608,11629,11632,11641,11673,11698,11737,11738,11750,11800,11875,11889,11938,11998,12027,12060,12082,12100,12101,12104,12118,12154,12155,12181,12184,12186,12197,12215,12232,12289,12314,12326,12384,12434,12441,12487,12507,12509,12513,12602,12688,12690,12845,12922,12951,13066,13077,13089,13217,13352,13356,13412,13458,13485,13537,13585,13685,13705,13706,13769,13830,13832,13913,13996,14012,14038,14157,14181,14247,14299,14436,14484,14517,14533,14569,14607,14649,14714,14779,14857,14863,14873,14881,14899,15040,15056,15071,15152,15153,15160,15166,15209,15211,15216,15252,15253,15269,15314,15323,15326,15430,15527,15628,15632,15636,15721,15756,15771,15772,15777,15783,15801,15862,15938,15974,16078,16107,16130,16138,16139,16258,16324,16353,16371,16378,16421,16501,16523,16628,16747,16823,16844,16873,17022,17024,17055,17070,17213,17275,17340,17362,17386,17541,17547,17568,17662,17687,17729,17751,17769,17783,17830,17877,18088,18155,18190,18192,18269,18386,18396,18467,18483,18531,18568,18634,18664,18671,18702,18708,18768,18775,18801,18816,18841,18876,18942,18972,19006,19017,19096,19225,19478,19521,19597,19641,19790,19858,19959,19979,20028,20083,20140,20141,20184,20399,20611,20631,20654,20671,20888,20900,20901,21112,21129,21176,21191,21192,21218,21259,21307,21407,21443,21455,21459,21598,21696,21707,21787,21788,21859,21910,21969,21987,22009,22073,22117,22127,22144,22152,22173,22230,22233,22261,22286,22360,22393,22454,22580,22659,22684,22694,22695,22712,22749,22785,22805,22812,22871,22892,22936,23012,23139,23310,23359,23381,23741,23770,24097,24100,24118,24229,24241,24285,24524,24528,24538,24556,24597,25036,25428,25570,25729,25771,25835,25891,25995,26038,26048,26053,26062,26078,26099,26103,26114,26145,26148,26153,26298,26308,26309,26339,26394,26427,26461,26476,26485,26520,26539,26554,26561,26567,26575,26578,26590,26595,26627,26642,26643,26647,26769,26791,26828,26847,26893,26906,26938,26991,27113,27121,27134,27141,27162,27175,27233,27250,27342,27354,27381,27442,27455,27463,27521,27626,27650,27672,27864,27884,27887,27900,28073,28088,28104,28118,28252,28259,28263,28335,28420,28422,28487,28554,28560,28579,28637,28673,28849,28882,28902,28941,29010,29028,29073,29077,29104,29106,29126,29141,29172,29265,29426,29437,29505,29575,29622,29650,29783,29933,30381,30475,30499,30547,31173,31733,31742,31762,34066,34841,35675,35751,35798,35843,35941,36046,37218,39115,39466,39527,41007,41120)
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 | 704 | 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.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.11 ms |
preparing | 0.53 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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 |