Tiempo de la consulta: 10.40 ms Después de la última consulta: 1.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.516 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 21:12:57')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 21:12:57')
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(11,25,31,49,58,60,61,62,63,64,65,67,68,80,82,85,138,147,148,149,150,151,152,153,154,155,161,162,163,164,165,166,167,175,180,197,205,206,222,225,250,263,271,272,278,281,307,308,327,328,329,331,344,350,370,380,387,388,389,390,392,393,395,397,398,400,402,403,404,405,406,408,410,411,417,433,435,436,437,438,442,443,445,448,451,452,454,455,456,458,459,474,489,494,497,502,570,583,586,589,614,622,633,672,681,686,697,701,717,733,737,760,771,776,796,797,799,802,805,806,813,844,856,857,858,861,864,867,868,872,881,889,894,905,909,910,924,928,935,943,955,956,958,963,970,978,983,986,1017,1018,1021,1024,1033,1040,1053,1062,1087,1091,1132,1137,1139,1168,1174,1185,1186,1187,1188,1190,1205,1207,1208,1210,1224,1226,1233,1248,1252,1253,1277,1280,1290,1297,1298,1305,1319,1344,1354,1355,1402,1455,1465,1491,1503,1506,1535,1563,1594,1603,1612,1614,1634,1646,1656,1683,1698,1712,1713,1714,1716,1717,1739,1744,1770,1784,1788,1800,1802,1817,1822,1835,1849,1851,1860,1900,1907,1913,1917,1949,1953,1964,1968,1971,1973,1999,2005,2102,2112,2124,2162,2188,2305,2331,2337,2353,2378,2394,2408,2424,2433,2468,2569,2598,2601,2613,2617,2632,2633,2637,2648,2668,2689,2706,2713,2732,2739,2788,2790,2805,2827,2857,2875,2948,2962,2964,3020,3027,3060,3067,3082,3085,3087,3209,3210,3212,3216,3224,3240,3244,3251,3259,3271,3299,3317,3322,3330,3337,3340,3373,3424,3425,3439,3444,3519,3573,3592,3684,3692,3696,3706,3718,3719,3725,3792,3794,3832,3869,3871,3873,3905,3932,3943,3963,3982,3986,3988,4008,4013,4029,4033,4035,4063,4076,4082,4084,4105,4131,4191,4224,4234,4235,4249,4273,4281,4313,4320,4331,4332,4348,4355,4361,4362,4364,4391,4405,4434,4444,4502,4506,4560,4563,4587,4641,4670,4688,4732,4752,4765,4770,4780,4801,4808,4832,4835,4854,4880,4901,4947,4957,4990,5000,5037,5063,5074,5086,5101,5104,5136,5150,5168,5170,5173,5183,5190,5195,5227,5237,5263,5268,5269,5300,5328,5363,5390,5413,5423,5525,5529,5559,5575,5632,5646,5648,5694,5730,5769,5798,5803,5811,5814,5833,5834,5859,5894,5895,5904,5922,5994,6009,6021,6039,6066,6068,6160,6166,6233,6264,6268,6270,6301,6315,6349,6362,6381,6393,6429,6442,6470,6475,6484,6498,6501,6570,6633,6654,6659,6688,6725,6726,6744,6748,6749,6758,6783,6785,6830,6834,6848,6857,6878,6884,6889,6905,6908,6910,6911,6917,6941,6955,6960,6971,6985,7012,7026,7037,7053,7054,7101,7124,7125,7172,7175,7194,7205,7242,7273,7278,7285,7296,7297,7328,7330,7342,7348,7358,7374,7396,7405,7416,7421,7432,7435,7443,7456,7482,7514,7526,7544,7552,7567,7580,7581,7591,7595,7596,7597,7624,7644,7659,7688,7710,7722,7745,7751,7797,7801,7806,7813,7830,7838,7839,7858,7860,7863,7866,7931,7946,7965,7966,7980,7981,7985,7996,8018,8020,8026,8027,8077,8105,8148,8161,8188,8250,8296,8303,8325,8387,8390,8406,8417,8438,8443,8462,8492,8505,8506,8512,8531,8551,8554,8555,8613,8663,8679,8716,8760,8852,8864,8910,8972,9004,9011,9012,9018,9155,9184,9193,9196,9197,9242,9252,9282,9305,9330,9370,9416,9472,9481,9501,9507,9516,9525,9529,9532,9556,9573,9626,9648,9708,9757,9766,9831,9840,9864,9865,9869,9889,9895,9899,9934,9944,9945,9970,10048,10129,10140,10144,10206,10239,10243,10246,10264,10278,10280,10298,10315,10352,10364,10383,10400,10425,10449,10467,10494,10535,10561,10603,10604,10611,10644,10677,10741,10764,10779,10800,10811,10818,10834,10850,10900,10907,10915,10942,10952,10967,11040,11059,11091,11098,11106,11107,11129,11137,11158,11198,11207,11240,11259,11299,11305,11350,11356,11377,11452,11482,11542,11552,11565,11627,11651,11669,11672,11681,11685,11688,11709,11711,11722,11743,11822,11853,11859,11880,11896,11914,11917,11924,12042,12150,12165,12168,12216,12238,12254,12301,12337,12370,12379,12387,12398,12410,12424,12439,12458,12473,12482,12509,12541,12567,12592,12609,12612,12624,12625,12650,12663,12668,12669,12675,12708,12713,12714,12750,12758,12780,12850,12892,12913,12917,12925,12926,12944,12949,12952,12969,12973,12974,13004,13014,13061,13079,13083,13100,13152,13153,13209,13219,13251,13268,13269,13297,13317,13323,13328,13348,13352,13358,13436,13442,13481,13501,13510,13519,13535,13553,13560,13575,13576,13579,13635,13657,13685,13694,13722,13725,13727,13729,13748,13750,13773,13782,13783,13816,13822,13846,13875,13894,13900,13924,13934,13941,13959,13966,14014,14052,14082,14103,14107,14122,14134,14140,14149,14153,14159,14164,14168,14178,14183,14189,14194,14197,14205,14226,14232,14237,14287,14290,14302,14327,14337,14356,14368,14369,14382,14401,14417,14424,14430,14451,14457,14487,14504,14508,14524,14527,14529,14548,14570,14591,14596,14601,14620,14631,14648,14655,14663,14671,14679,14684,14687,14688,14698,14700,14725,14733,14769,14812,14829,14846,14847,14860,14862,14865,14884,14890,14892,14895,14905,14906,14911,14927,14928,14930,14941,14958,14973,14997,14999,15005,15020,15030,15038,15046,15061,15063,15091,15094,15114,15125,15145,15158,15171,15177,15179,15183,15187,15202,15208,15209,15223,15233,15234,15244,15250,15259,15261,15262,15270,15293,15298,15304,15308,15310,15346,15359,15360,15361,15368,15375,15392,15407,15418,15429,15430,15450,15469,15476,15484,15487,15493,15500,15516,15517,15522,15537,15540,15542,15547,15563,15566,15577,15583,15594,15596,15601,15632,15645,15669,15670,15674,15706,15726,15751,15753,15762,15832,15836,15843,15844,15850,15851,15858,15859,15863,15870,15875,15881,15901,15906,15909,15913,15916,15917,15927,15930,15937,15957,15975,15981,15987,15999,16024,16042,16043,16056,16083,16090,16122,16129,16142,16155,16162,16176,16201,16211,16260,16281,16303,16311,16313,16318,16322,16323,16334,16338,16344,16359,16422,16437,16438,16440,16446,16455,16464,16465,16467,16520,16522,16524,16526,16547,16550,16555,16556,16561,16564,16571,16589,16620,16626,16629,16641,16642,16654,16661,16668,16683,16684,16689,16698,16706,16712,16717,16728,16754,16782,16791,16802,16816,16830,16840,16861,16863,16876,16891,16894,16909,16916,16924,16936,16940,16944,16947,16951,16966,16968,16969,17002,17014,17054,17064,17067,17086,17123,17131,17133,17136,17137,17142,17148,17169,17199,17203,17206,17209,17210,17220,17232,17242,17248,17251,17253,17268,17273,17282,17286,17287,17334,17335,17344,17360,17362,17369,17371,17402,17409,17412,17416,17424,17427,17443,17450,17471,17490,17500,17509,17513,17515,17521,17535,17539,17543,17572,17584,17597,17608,17609,17618,17622,17630,17635,17655,17659,17683,17690,17700,17701,17713,17727,17746,17750,17752,17759,17761,17782,17788,17799,17808,17818,17826,17853,17857,17858,17862,17879,17885,17893,17902,17907,17910,17918,17920,17921,17927,17933,17956,17976,17977,17978,17981,17994,18001,18004,18019,18022,18027,18028,18029,18033,18040,18067,18068,18074,18076,18083,18141,18159,18160,18162,18165,18168,18170,18173,18203,18214,18219,18220,18227,18229,18235,18260,18285,18292,18300,18302,18311,18312,18352,18362,18364,18398,18409,18415,18422,18447,18450,18467,18473,18501,18506,18507,18517,18520,18534,18535,18542,18564,18567,18572,18587,18599,18647,18648,18668,18671,18672,18676,18696,18707,18720,18721,18747,18762,18778,18800,18801,18803,18825,18828,18835,18851,18866,18879,18880,18906,18907,18911,18923,18926,18927,18931,18934,18939,18946,18950,18953,18954,18973,18974,18980,19002,19004,19014,19018,19024,19047,19060,19063,19067,19093,19102,19113,19123,19127,19145,19148,19153,19155,19156,19170,19172,19180,19184,19185,19196,19197,19200,19204,19216,19217,19218,19231,19235,19253,19264,19276,19283,19297,19299,19302,19308,19313,19316,19327,19340,19352,19353,19365,19376,19383,19402,19407,19426,19432,19457,19460,19473,19481,19482,19484,19487,19493,19495,19514,19532,19545,19562,19565,19573,19577,19580,19583,19586,19587,19591,19606,19617,19618,19620,19633,19641,19648,19665,19668,19678,19687,19703,19706,19718,19720,19732,19733,19741,19742,19745,19746,19747,19750,19751,19755,19776,19778,19779,19796,19805,19806,19811,19813,19826,19835,19854,19864,19870,19876,19900,19908,19909,19924,19942,19950,19956,19973,19988,19998,20002,20010,20015,20028,20032,20056,20062,20066,20068,20076,20080,20086,20094,20117,20126,20127,20129,20141,20142,20154,20155,20156,20170,20179,20187,20204,20208,20209,20221,20234,20235,20256,20263,20267,20271,20278,20289,20303,20309,20333,20336,20338,20352,20353,20366,20384,20387,20393,20396,20434,20437,20449,20450,20469,20516,20521,20522,20535,20541,20558,20564,20565,20570,20574,20575,20585,20592,20601,20607,20615,20630,20642,20648,20650,20664,20688,20689,20710,20714,20729,20733,20737,20740,20750,20751,20765,20773,20792,20795,20808,20830,20866,20876,20935,20947,20948,20953,20982,20990,20991,21035,21040,21042,21050,21059,21070,21079,21087,21100,21114,21126,21128,21149,21156,21173,21187,21189,21198,21199,21200,21204,21223,21225,21259,21261,21270,21274,21291,21297,21302,21311,21314,21323,21329,21332,21335,21341,21342,21361,21372,21383,21405,21412,21415,21422,21432,21465,21487,21496,21513,21519,21528,21545,21547,21555,21559,21565,21583,21598,21602,21603,21604,21611,21614,21620,21632,21636,21640,21647,21652,21678,21691,21694,21703,21705,21722,21726,21729,21738,21752,21757,21764,21768,21769,21770,21773,21775,21810,21811,21819,21824,21844,21848,21854,21879,21891,21908,21929,21930,21932,21950,21972,21980,21985,21986,21987,21992,21995,22011,22036,22040,22055,22058,22074,22089,22100,22127,22131,22137,22146,22158,22161,22169,22177,22196,22229,22253,22260,22262,22267,22270,22286,22294,22297,22306,22321,22327,22333,22337,22359,22361,22386,22408,22411,22428,22453,22468,22476,22481,22484,22508,22520,22534,22548,22559,22581,22589,22591,22592,22594,22621,22623,22647,22673,22707,22712,22739,22753,22758,22774,22781,22788,22804,22816,22836,22851,22854,22860,22869,22871,22886,22899,22903,22908,22909,22914,22922,22925,22927,22932,22935,22949,22959,22964,22967,22974,22976,22980,22988,23004,23011,23019,23027,23031,23032,23036,23037,23051,23083,23084,23085,23090,23091,23099,23102,23104,23110,23119,23123,23136,23139,23164,23166,23174,23184,23186,23204,23213,23215,23217,23221,23229,23242,23260,23269,23275,23281,23287,23295,23296,23309,23319,23328,23332,23374,23379,23398,23402,23411,23412,23430,23434,23439,23456,23459,23460,23481,23495,23503,23525,23531,23536,23548,23555,23561,23562,23579,23585,23602,23610,23624,23633,23634,23636,23645,23652,23678,23685,23704,23707,23732,23761,23764,23783,23803,23826,23840,23843,23845,23850,23853,23858,23866,23885,23891,23894,23897,23905,23907,23910,23936,23958,23964,23979,24002,24011,24018,24023,24028,24029,24034,24059,24067,24077,24083,24087,24119,24134,24137,24151,24154,24155,24194,24220,24228,24234,24316,24326,24342,24364,24366,24387,24391,24413,24429,24442,24451,24485,24489,24502,24526,24540,24549,24568,24575,24577,24586,24617,24621,24639,24644,24653,24668,24707,24719,24735,24747,24781,24785,24791,24804,24817,24834,24841,24849,24855,24868,24882,24884,24897,24922,24941,24975,24976,24986,25032,25033,25038,25045,25061,25068,25070,25071,25081,25099,25153,25184,25201,25264,25271,25280,25310,25315,25325,25332,25352,25377,25379,25382,25450,25512,25535,25545,25548,25621,25622,25626,25640,25648,25653,25670,25673,25676,25684,25695,25702,25717,25723,25735,25742,25747,25749,25768,25775,25782,25785,25789,25845,25865,25872,25906,25921,25927,25947,25983,26000,26008,26019,26043,26050,26056,26080,26113,26140,26153,26154,26197,26215,26315,26317,26323,26324,26334,26335,26358,26367,26379,26388,26398,26405,26444,26464,26473,26489,26491,26535,26548,26565,26576,26577,26583,26612,26620,26630,26637,26639,26640,26646,26691,26698,26699,26708,26734,26743,26784,26807,26820,26845,26879,26885,26897,26909,26919,26935,26941,26954,27002,27009,27024,27030,27055,27065,27082,27086,27087,27101,27104,27141,27143,27145,27184,27206,27216,27218,27312,27313,27323,27362,27408,27423,27444,27488,27492,27518,27541,27552,27559,27560,27568,27570,27582,27595,27694,27724,27786,27892,28019,28075,28157,28162,28169,28243,28329,28336,28453,28454,28495,28714,28733,28805,28882,28886,28889,28898,28925,29164,29372,29378,29412,29454,29589,29617,29618,29802,30740,31115,31129,31560,31604,31663,31937,32676,32905,34220,34428,34754,35127,35428,35570,35603,35744,35776,35806,35808,35862,35882,35893,35926,36004,36109,36124,36160,36178,36179,36286,36368,36369,36633,36802,36891,36987,37142,37399,37538,37604,37692,37833,37942,38133,38273,38300,38443,38601,38763,38816,38817,38824,38833,38845,38877,38887,38897,38949,38967,38987,39205,39271,39342,39587,39614,39645,39716,39726,39820,39857,39972,39984,39997,40015,40116,40203,40319,40356,40483,40509,40533,40588,40672,40691,41295,41363,41392,41532,41794,42038,43432,44062,44249,44250,44277,44292,45063,45282)
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 | 2186 | 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 | 1.28 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.50 ms |
System lock | 0.04 ms |
optimizing | 0.16 ms |
statistics | 4.68 ms |
preparing | 2.57 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.11 ms |
cleaning up | 0.04 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 |