Tiempo de la consulta: 4.43 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.348 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-07 18:14:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 18:14:38')
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(25,155,165,175,180,205,206,222,225,250,263,271,272,308,327,329,370,385,387,388,390,392,393,395,397,398,400,402,403,404,405,408,410,411,433,435,436,437,438,442,443,445,451,454,455,589,686,701,743,749,760,793,805,831,856,1026,1027,1066,1088,1134,1183,1193,1198,1239,1261,1290,1312,1398,1491,1492,1618,1667,1788,1882,2038,2162,2243,2353,2372,2391,2477,2555,2568,2569,2620,2631,2637,2732,2818,2859,2934,2984,3018,3139,3141,3361,3373,3592,3636,3684,3696,3761,3828,3856,3876,3982,4006,4063,4249,4339,4358,4409,4641,4688,4765,4808,5059,5332,5543,5638,5662,5730,5833,5940,6294,6315,6327,6393,6424,6475,6516,6551,6562,6571,6681,6728,6780,6783,6889,6925,7057,7094,7194,7241,7294,7325,7342,7346,7371,7405,7421,7429,7449,7513,7537,7553,7591,7596,7597,7744,7801,7821,7965,7966,8016,8042,8201,8257,8406,8485,8551,8588,8613,8760,8777,8826,8864,8910,9020,9188,9191,9336,9367,9416,9432,9472,9702,9757,9789,9926,9934,10018,10049,10199,10263,10318,10344,10381,10464,10477,10479,10515,10544,10609,10681,10710,10808,10986,11009,11052,11091,11132,11139,11155,11161,11263,11308,11354,11480,11508,11633,11651,11713,11715,11763,11877,11950,12069,12136,12157,12317,12370,12470,12482,12491,12514,12524,12580,12624,12625,12691,12750,12803,12816,12842,12877,12913,12973,12980,13004,13086,13118,13161,13219,13222,13250,13348,13349,13379,13409,13428,13440,13501,13560,13594,13612,13689,13704,13708,13725,13761,13779,13786,13882,13890,13892,13900,13928,13932,14040,14052,14078,14112,14142,14149,14183,14199,14226,14234,14268,14383,14451,14480,14487,14529,14538,14599,14654,14657,14687,14721,14769,14814,14816,14837,14838,14860,14862,14887,14892,14895,14906,14981,14982,14983,15002,15013,15015,15060,15092,15111,15112,15123,15148,15180,15226,15325,15358,15371,15372,15417,15443,15470,15476,15500,15561,15568,15596,15642,15669,15672,15674,15733,15742,15745,15760,15762,15788,15824,15825,15832,15840,15868,15885,15895,15901,15954,16167,16176,16208,16261,16279,16282,16328,16353,16404,16463,16524,16550,16613,16627,16682,16706,16747,16778,16820,16821,16823,16843,16866,16876,16909,16921,16936,16942,17014,17072,17098,17131,17142,17158,17188,17214,17251,17269,17272,17288,17343,17346,17366,17424,17427,17441,17500,17517,17543,17608,17632,17690,17705,17733,17746,17762,17774,17816,17831,17877,17885,17907,17918,17951,17973,18007,18085,18102,18160,18179,18180,18231,18302,18309,18315,18345,18355,18366,18395,18401,18450,18454,18463,18499,18516,18643,18652,18666,18681,18701,18712,18726,18732,18754,18758,18770,18792,18817,18821,18828,18918,18929,18935,18936,18944,18982,18993,19003,19010,19027,19078,19106,19110,19136,19145,19172,19179,19231,19264,19265,19313,19331,19334,19348,19375,19405,19415,19445,19488,19506,19507,19562,19623,19667,19703,19712,19720,19748,19771,19778,19786,19790,19796,19806,19917,19957,19966,19987,19994,20008,20035,20065,20073,20076,20088,20094,20098,20117,20131,20143,20166,20205,20211,20258,20271,20312,20313,20314,20399,20515,20594,20673,20692,20780,20795,20829,20834,20835,20874,20914,20976,21008,21013,21015,21040,21057,21059,21065,21073,21078,21087,21092,21099,21149,21156,21198,21258,21266,21274,21321,21365,21388,21418,21440,21469,21471,21501,21520,21565,21573,21613,21629,21633,21683,21693,21775,21819,21879,21914,21967,21995,22031,22050,22159,22207,22223,22268,22282,22286,22292,22293,22294,22365,22411,22431,22442,22462,22476,22491,22498,22532,22534,22542,22606,22616,22645,22685,22700,22706,22732,22747,22748,22754,22785,22788,22854,22857,22863,22879,22890,22899,22977,23019,23029,23064,23082,23100,23110,23170,23210,23229,23260,23269,23307,23310,23318,23319,23332,23356,23358,23404,23409,23417,23430,23490,23495,23539,23622,23639,23685,23692,23695,23704,23739,23757,23772,23823,23832,23850,23880,23939,23970,24082,24109,24115,24167,24180,24187,24190,24202,24210,24215,24224,24236,24290,24333,24361,24465,24485,24617,24654,24659,24674,24688,24780,24787,24815,24829,24843,24862,24868,24889,24922,24971,24979,24980,25022,25029,25062,25097,25116,25137,25157,25181,25199,25217,25230,25280,25323,25529,25530,25600,25604,25606,25648,25683,25700,25718,25732,25746,25755,25801,25813,25822,25853,25911,25933,26039,26043,26050,26053,26054,26060,26063,26117,26154,26215,26227,26317,26395,26405,26464,26467,26601,26665,26715,26830,26885,26897,26935,26977,26980,27003,27009,27030,27074,27127,27129,27143,27230,27259,27272,27283,27303,27315,27350,27392,27516,27518,27541,27552,27558,27559,27571,27577,27582,27634,27638,27647,27655,27671,27724,27772,27870,27932,27955,28073,28127,28226,28280,28324,28407,28532,28542,28546,28551,28569,28571,28618,28654,28714,28889,29130,29154,29326,29551,29610,29787,29918,30133,30356,30529,31560,31937,32061,32583,32719,32964,33080,33854,33997,34428,34502,34511,34629,34647,35103,35684,35732,35926,35971,36003,36018,36060,36092,36160,36333,36416,36420,36424,36427,36428,36441,36452,36469,36490,36551,36565,36616,36625,36629,36638,36654,36656,36695,36761,36772,36802,36853,36855,36859,36891,36894,36900,36934,37005,37086,37155,37192,37232,37283,37286,37308,37331,37346,37347,37348,37349,37350,37351,37359,37361,37371,37383,37391,37397,37399,37443,37470,37495,37501,37505,37507,37520,37557,37558,37560,37573,37578,37618,37635,37645,37652,37692,37755,37780,37799,37820,37831,37833,37858,37890,37894,37916,37942,37959,38007,38011,38015,38016,38023,38031,38058,38083,38107,38113,38157,38160,38177,38185,38192,38222,38226,38236,38274,38288,38311,38350,38356,38366,38382,38401,38403,38432,38443,38456,38568,38622,38634,38671,38689,38718,38765,38786,38814,38843,38887,38969,38978,38989,38995,39155,39191,39194,39214,39217,39264,39271,39295,39296,39330,39332,39334,39338,39339,39342,39379,39424,39429,39442,39474,39490,39522,39550,39569,39596,39624,39649,39676,39725,39758,39761,39803,39855,39871,39873,39892,40004,40015,40054,40073,40095,40116,40166,40226,40271,40301,40333,40379,40445,40446,40461,40495,40496,40515,40534,40554,40588,40593,40629,40656,40672,40674,40742,40746,40854,40936,41007,41339,41532,41564,41645,41794,42148,42486,44277,45181)
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 | 1034 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.58 ms |
preparing | 0.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 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 |