Tiempo de la consulta: 12.75 ms Después de la última consulta: 1.73 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.597 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-03 22:22:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 22:22:11')
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,11,64,157,192,193,218,230,257,263,275,311,353,354,356,357,358,359,360,361,363,364,401,460,466,471,477,482,499,500,543,560,579,599,610,635,643,655,661,680,685,686,691,692,694,700,703,709,713,723,729,736,756,757,761,772,783,786,803,841,859,868,960,965,968,971,981,984,998,1020,1024,1029,1032,1034,1039,1042,1045,1048,1051,1067,1079,1080,1090,1098,1104,1106,1120,1127,1136,1138,1142,1143,1150,1151,1172,1192,1194,1198,1207,1214,1217,1226,1255,1269,1271,1279,1280,1295,1305,1308,1322,1324,1336,1342,1343,1349,1352,1375,1386,1401,1408,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1460,1464,1466,1472,1473,1476,1481,1484,1530,1534,1553,1586,1595,1624,1639,1661,1664,1666,1718,1745,1751,1785,1811,1812,1815,1841,1852,1855,1870,1903,1906,1944,1984,2001,2046,2077,2098,2105,2136,2148,2177,2193,2199,2252,2284,2285,2301,2322,2359,2408,2427,2432,2465,2469,2480,2623,2629,2630,2631,2665,2691,2695,2724,2773,2858,2939,2941,2958,2964,2967,2983,2989,3025,3039,3056,3119,3169,3202,3219,3242,3278,3294,3321,3355,3364,3373,3410,3426,3442,3454,3463,3475,3487,3510,3513,3521,3590,3594,3663,3673,3761,3778,3811,3831,3836,3872,3906,3938,3984,3992,4066,4075,4132,4168,4176,4197,4252,4271,4378,4422,4477,4483,4523,4524,4525,4539,4558,4580,4585,4586,4587,4592,4605,4665,4699,4758,4795,4822,4874,4892,4919,4960,5014,5035,5076,5079,5136,5143,5157,5166,5182,5226,5250,5302,5373,5391,5393,5435,5451,5480,5496,5507,5508,5534,5560,5579,5586,5597,5627,5642,5647,5659,5694,5700,5729,5731,5798,5846,5876,5894,5936,5966,5990,6007,6013,6064,6068,6133,6200,6202,6217,6234,6308,6323,6328,6350,6356,6396,6421,6461,6502,6512,6516,6520,6533,6539,6541,6553,6573,6596,6601,6645,6648,6663,6665,6667,6690,6707,6727,6756,6778,6840,6842,6854,6870,6932,6939,6997,7026,7135,7138,7139,7167,7182,7191,7200,7237,7241,7277,7284,7287,7320,7358,7360,7365,7380,7387,7399,7401,7402,7419,7421,7435,7453,7531,7611,7626,7627,7629,7688,7709,7718,7730,7741,7748,7753,7765,7769,7778,7802,7824,7830,7834,7839,7845,7860,7868,7870,7878,7931,7944,7946,7950,7951,7965,7986,8027,8067,8069,8090,8091,8093,8099,8108,8149,8206,8220,8230,8283,8319,8338,8341,8361,8377,8400,8444,8458,8483,8502,8518,8627,8638,8659,8666,8695,8729,8744,8778,8808,8907,8938,8939,8944,8974,9029,9075,9108,9122,9132,9313,9318,9364,9449,9462,9548,9562,9605,9616,9629,9675,9690,9717,9756,9846,9849,9879,9886,9924,10013,10023,10039,10078,10226,10239,10263,10314,10316,10345,10371,10373,10380,10416,10501,10503,10572,10576,10601,10616,10665,10686,10689,10725,10736,10738,10739,10768,10775,10834,10851,10964,10980,10989,11001,11029,11064,11152,11191,11195,11204,11219,11223,11265,11314,11320,11428,11446,11461,11523,11542,11632,11677,11678,11705,11754,11795,11806,11835,11842,11859,11885,11948,11954,12031,12078,12089,12116,12125,12170,12171,12224,12238,12259,12309,12334,12367,12412,12434,12439,12440,12479,12494,12499,12524,12534,12535,12540,12546,12563,12571,12605,12625,12670,12708,12737,12756,12790,12791,12816,12822,12856,12872,12902,12946,12994,13064,13078,13140,13160,13258,13266,13272,13297,13316,13344,13350,13428,13436,13437,13438,13444,13458,13467,13478,13479,13480,13481,13482,13488,13502,13503,13516,13525,13530,13535,13542,13571,13576,13589,13597,13602,13615,13618,13645,13653,13660,13698,13777,13784,13794,13797,13806,13824,13861,13874,13898,13916,13962,13968,13990,14000,14007,14047,14074,14140,14152,14153,14177,14205,14219,14227,14243,14249,14269,14280,14292,14309,14360,14371,14401,14429,14432,14493,14496,14506,14508,14513,14534,14546,14552,14591,14604,14638,14641,14646,14665,14693,14710,14754,14830,14837,14846,14849,14864,14874,14958,15063,15079,15128,15138,15147,15174,15216,15220,15222,15229,15230,15268,15278,15353,15359,15372,15390,15420,15464,15494,15520,15533,15543,15551,15568,15577,15579,15598,15606,15632,15644,15645,15681,15717,15722,15739,15751,15759,15835,15885,15896,15899,15904,15935,15939,15945,15953,15982,16016,16022,16052,16062,16091,16156,16161,16216,16258,16286,16337,16348,16361,16386,16390,16398,16414,16466,16472,16529,16541,16569,16586,16607,16621,16629,16634,16646,16652,16658,16723,16774,16780,16790,16791,16808,16809,16816,16818,16851,16908,16943,16987,16998,17069,17090,17092,17121,17126,17131,17132,17177,17230,17282,17290,17307,17312,17321,17355,17361,17383,17384,17391,17426,17442,17478,17500,17545,17555,17571,17611,17630,17645,17658,17660,17667,17679,17695,17699,17708,17735,17768,17777,17780,17783,17799,17817,17839,17869,17882,17892,17921,17927,17939,17947,18006,18009,18013,18037,18039,18055,18071,18073,18079,18122,18142,18145,18160,18174,18176,18181,18202,18216,18220,18222,18226,18253,18260,18264,18279,18284,18290,18295,18308,18309,18332,18360,18363,18382,18388,18406,18424,18466,18494,18520,18522,18540,18550,18554,18598,18653,18700,18703,18718,18739,18775,18778,18789,18791,18813,18822,18861,18901,18908,18912,18916,18945,18982,18995,19010,19018,19022,19043,19086,19110,19135,19181,19196,19304,19307,19335,19343,19367,19383,19388,19404,19407,19412,19449,19462,19496,19505,19507,19581,19596,19612,19624,19640,19652,19657,19677,19695,19704,19773,19774,19797,19816,19826,19832,19853,19856,19913,19921,19933,19935,19973,19979,20001,20004,20043,20051,20056,20142,20157,20180,20181,20184,20194,20202,20208,20217,20232,20242,20265,20277,20304,20354,20370,20404,20440,20452,20467,20488,20503,20525,20529,20546,20564,20568,20569,20576,20579,20602,20626,20643,20647,20677,20736,20739,20749,20768,20771,20773,20803,20825,20833,20837,20865,20871,20883,20919,20933,20986,20988,21004,21011,21094,21116,21123,21151,21158,21167,21183,21189,21197,21205,21252,21263,21272,21280,21284,21285,21301,21328,21333,21376,21394,21408,21411,21413,21416,21419,21427,21437,21438,21441,21491,21493,21510,21527,21534,21556,21575,21589,21601,21611,21619,21620,21622,21633,21659,21691,21699,21721,21735,21779,21796,21809,21821,21825,21834,21888,21938,21944,21957,21962,21999,22011,22071,22100,22117,22173,22174,22178,22206,22251,22263,22283,22288,22298,22332,22343,22384,22400,22412,22415,22416,22421,22464,22476,22483,22494,22496,22528,22555,22600,22653,22669,22682,22696,22710,22713,22722,22726,22747,22756,22784,22820,22829,22831,22835,22848,22864,22872,22883,22900,22938,22974,22979,23022,23031,23032,23039,23040,23101,23114,23118,23172,23221,23240,23249,23277,23284,23296,23313,23344,23355,23378,23394,23406,23428,23430,23446,23453,23454,23476,23530,23546,23547,23586,23592,23593,23616,23634,23638,23648,23665,23676,23691,23693,23695,23701,23715,23719,23722,23747,23769,23806,23825,23860,23863,23868,23898,23951,23954,23996,24017,24021,24033,24047,24052,24054,24099,24135,24146,24170,24198,24441,24447,24455,24477,24484,24505,24524,24535,24548,24563,24599,24706,24709,24721,24726,24754,24756,24763,24784,24790,24819,24832,24838,24875,24883,24884,24919,24953,24963,24965,24966,24977,24996,25010,25039,25048,25096,25105,25120,25131,25141,25172,25175,25188,25197,25278,25284,25288,25292,25297,25317,25322,25326,25330,25351,25383,25405,25406,25428,25447,25471,25486,25497,25506,25514,25518,25539,25542,25609,25612,25621,25648,25655,25658,25693,25705,25717,25736,25748,25764,25790,25792,25813,25821,25842,25859,25860,25864,25874,25881,25943,25955,25964,25995,26010,26043,26109,26117,26134,26154,26155,26166,26167,26171,26184,26204,26221,26240,26310,26348,26353,26366,26403,26431,26468,26469,26480,26530,26541,26603,26634,26639,26659,26709,26722,26753,26769,26797,26807,26852,26909,26923,26944,26945,26947,26950,26951,26956,27035,27046,27052,27054,27057,27137,27143,27170,27207,27237,27262,27274,27280,27311,27360,27372,27383,27406,27408,27414,27415,27491,27552,27571,27610,27644,27663,27677,27738,27742,27779,27859,27985,28120,28163,28189,28233,28256,28306,28334,28465,28598,28627,28628,28662,28680,28681,28682,28683,28702,28710,28716,28746,28781,28844,28847,29064,29133,29373,29379,29417,29548,29571,29630,29646,29727,29864,29865,30050,30318,30562,30790,31384,32530,32642,32643,32644,32919,33065,33345,33750,33954,33955,34016,34047,34174,34180,34181,34189,34251,34377,34391,34483,34502,34676,34759,34832,34935,34959,35010,35094,35102,35175,35185,35205,35226,35299,35310,35314,35337,35360,35379,35392,35434,35557,35581,35596,35658,35773,35780,35800,35836,35845,35847,35876,35902,35925,35930,35982,36031,36066,36085,36200,36204,36227,36297,36323,36437,36531,36688,36714,36736,36751,36817,36828,36888,36957,36961,37024,37026,37034,37107,37116,37137,37170,37316,37344,37357,37365,37397,37403,37439,37454,37521,37543,37544,37553,37579,37581,37642,37661,37669,37693,37710,37731,37740,37767,37787,37802,37844,37852,37876,37932,37953,37999,38006,38060,38103,38114,38122,38128,38185,38315,38329,38343,38346,38361,38370,38398,38409,38430,38440,38446,38452,38506,38512,38520,38530,38549,38567,38588,38623,38674,38734,38764,38781,38809,38837,38842,38851,38861,38888,38956,39005,39019,39023,39027,39052,39070,39114,39150,39160,39163,39185,39193,39212,39225,39245,39276,39315,39319,39346,39347,39375,39389,39415,39416,39439,39475,39491,39492,39537,39575,39582,39609,39649,39670,39706,39722,39736,39739,39747,39757,39767,39768,39802,39838,39849,39932,39934,39993,40003,40018,40072,40073,40089,40092,40094,40111,40116,40195,40231,40276,40302,40306,40345,40379,40398,40431,40436,40438,40460,40465,40494,40505,40508,40535,40554,40555,40562,40583,40614,40638,40665,40667,40688,40699,40714,40774,40811,40817,40897,40904,40959,40970,40996,41023,41040,41046,41051,41068,41075,41078,41096,41142,41146,41150,41159,41181,41190,41220,41227,41245,41246,41248,41251,41259,41273,41284,41297,41303,41313,41322,41370,41371,41373,41391,41401,41418,41436,41440,41499,41508,41517,41570,41576,41649,41660,41722,41724,41726,41738,41739,41768,41797,41800,41811,41822,41839,41851,41865,41871,41875,41879,41896,41927,41956,41957,41959,41963,41972,41973,41981,41983,41997,42002,42009,42010,42029,42040,42054,42057,42065,42091,42113,42124,42134,42136,42154,42163,42174,42188,42199,42212,42232,42251,42275,42282,42303,42304,42353,42380,42405,42427,42430,42446,42448,42462,42478,42484,42490,42538,42572,42574,42604,42625,42703,42729,42765,42768,42788,42800,42806,42863,43009,43058,43083,43115,43116,43136,43143,43181,43182,43199,43216,43217,43222,43234,43236,43244,43268,43294,43312,43342,43345,43347,43348,43434,43443,43455,43459,43468,43471,43507,43508,43509,43512,43527,43539,43550,43565,43596,43601,43605,43612,43615,43617,43628,43629,43647,43682,43684,43703,43704,43730,43742,43758,43800,43836,43846,43875,43876,43877,43883,43927,43979,44003,44026,44045,44049,44050,44070,44073,44098,44177,44184,44239,44259,44338,44351,44353,44356,44379,44389,44392,44400,44413,44431,44437,44455,44491,44521,44544,44558,44570,44586,44588,44603,44611,44613,44625,44658,44683,44691,44701,44708,44748,44842,44874,44894,44907,44908,44941,44964,44989,45008,45051,45055,45060,45136,45147,45157,45195,45289,45301,45302,45303,45311)
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 | 1878 | 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.81 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.35 ms |
| System lock | 0.02 ms |
| optimizing | 0.12 ms |
| statistics | 2.85 ms |
| preparing | 1.43 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 6.30 ms |
| end | 0.03 ms |
| query end | 0.04 ms |
| closing tables | 0.03 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.05 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 |
Juan Sebastián Lemba, negro cimarrón.
Foto de archivo
