Tiempo de la consulta: 31.35 ms Después de la última consulta: 1.34 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.399 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-04 21:24:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 21:24:43')
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(8,9,28,45,46,54,62,64,65,71,157,165,190,193,198,215,218,221,253,254,257,275,276,296,297,300,301,303,304,305,307,311,363,371,372,373,401,415,452,466,471,482,499,543,549,560,591,592,610,635,643,659,661,680,685,692,700,703,709,712,713,723,736,761,764,772,782,783,786,794,847,848,859,868,878,923,960,968,984,998,1024,1032,1034,1042,1048,1079,1080,1098,1106,1127,1138,1142,1150,1151,1172,1192,1194,1212,1226,1255,1269,1271,1277,1279,1280,1295,1305,1322,1335,1349,1375,1420,1421,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1553,1563,1571,1586,1595,1624,1664,1804,1811,1812,1841,1852,1855,1870,1903,1906,1940,1984,2001,2077,2084,2148,2177,2193,2199,2293,2301,2303,2322,2359,2408,2432,2469,2480,2629,2631,2639,2691,2773,2909,2989,3056,3108,3119,3125,3161,3196,3202,3266,3278,3355,3364,3513,3590,3594,3663,3666,3685,3715,3760,3767,3776,3786,3833,3836,3872,3913,3960,3992,4034,4075,4101,4110,4129,4132,4148,4150,4168,4176,4197,4204,4252,4271,4284,4323,4327,4378,4423,4430,4456,4477,4523,4548,4558,4575,4580,4585,4586,4587,4605,4691,4859,4868,4874,4907,4908,4940,5014,5079,5226,5259,5318,5387,5422,5484,5496,5507,5508,5534,5567,5730,5756,5876,5908,5909,5954,5990,6068,6100,6128,6133,6147,6308,6323,6360,6362,6440,6461,6470,6473,6533,6542,6543,6596,6649,6662,6663,6667,6707,6720,6842,6865,6881,6905,6911,7077,7111,7182,7200,7216,7237,7250,7258,7277,7329,7331,7364,7421,7435,7444,7586,7605,7614,7616,7618,7622,7626,7651,7688,7709,7724,7748,7752,7758,7771,7784,7787,7802,7811,7830,7839,7860,7868,7870,7897,7903,7925,7935,7942,7946,7950,7951,7969,8004,8021,8055,8069,8091,8108,8152,8160,8206,8227,8234,8265,8322,8370,8378,8400,8421,8499,8507,8518,8550,8611,8644,8660,8700,8750,8753,8799,8803,8813,8826,8864,8907,8925,8932,8938,8944,8954,9063,9084,9108,9120,9139,9153,9328,9345,9350,9369,9390,9398,9453,9462,9477,9578,9600,9608,9610,9664,9738,9768,9829,9838,9870,9878,9879,9904,9908,9922,9956,10004,10073,10098,10100,10183,10190,10265,10269,10272,10298,10313,10316,10368,10373,10414,10447,10448,10501,10513,10545,10617,10642,10725,10736,10754,10756,10775,10829,10834,10851,10899,10958,10993,11023,11031,11041,11054,11067,11073,11121,11133,11156,11195,11223,11250,11286,11292,11314,11338,11387,11461,11488,11545,11561,11600,11687,11705,11796,11827,11859,11894,11921,12089,12145,12170,12225,12238,12249,12280,12334,12394,12399,12440,12553,12585,12625,12632,12638,12689,12690,12816,12883,12902,12946,12966,12978,12994,13078,13146,13155,13160,13166,13209,13258,13272,13297,13300,13316,13344,13376,13385,13437,13438,13462,13467,13480,13481,13482,13503,13518,13525,13592,13660,13665,13702,13731,13738,13749,13760,13789,13797,13824,13843,13946,13961,13968,13996,14138,14141,14153,14177,14204,14205,14229,14309,14351,14370,14382,14396,14432,14440,14493,14506,14512,14513,14515,14524,14532,14546,14548,14598,14601,14616,14641,14662,14665,14710,14730,14739,14776,14820,14824,14825,14845,14850,14874,14909,14911,14912,14939,14945,14958,14966,14999,15006,15029,15041,15058,15063,15069,15081,15082,15094,15134,15138,15147,15148,15160,15178,15193,15216,15229,15258,15268,15304,15326,15328,15329,15343,15347,15359,15388,15389,15420,15423,15442,15457,15464,15465,15468,15482,15487,15543,15551,15561,15570,15577,15594,15611,15617,15632,15636,15637,15640,15644,15713,15722,15738,15767,15783,15815,15841,15866,15913,15946,15982,16004,16036,16039,16042,16052,16059,16063,16077,16082,16084,16097,16121,16127,16129,16154,16156,16180,16181,16216,16248,16256,16258,16292,16314,16315,16374,16386,16403,16466,16473,16517,16552,16569,16577,16607,16629,16634,16645,16731,16749,16759,16774,16780,16791,16828,16890,16963,16991,17053,17069,17074,17102,17115,17126,17131,17132,17145,17160,17177,17195,17200,17216,17217,17224,17233,17307,17431,17468,17470,17502,17555,17602,17633,17643,17645,17650,17658,17660,17714,17764,17766,17780,17799,17844,17855,17859,17892,17893,17921,17926,17966,18013,18037,18039,18054,18055,18062,18122,18157,18160,18174,18180,18181,18202,18233,18255,18274,18284,18292,18311,18314,18344,18355,18362,18375,18382,18390,18395,18460,18466,18525,18539,18544,18550,18553,18557,18564,18608,18616,18623,18689,18709,18714,18718,18755,18800,18813,18846,18862,18878,18901,18916,18922,18931,18934,18954,18955,18958,18975,18980,19028,19034,19042,19043,19070,19078,19080,19089,19092,19105,19115,19124,19128,19133,19135,19155,19218,19227,19235,19240,19247,19304,19313,19335,19343,19352,19366,19375,19393,19407,19439,19445,19471,19505,19530,19550,19561,19563,19596,19604,19612,19637,19652,19704,19713,19732,19749,19753,19773,19797,19852,19853,19868,19872,19913,19945,19979,19994,20004,20018,20030,20043,20051,20124,20127,20142,20144,20202,20224,20242,20250,20260,20264,20265,20312,20327,20346,20348,20366,20376,20393,20404,20406,20429,20444,20461,20510,20511,20568,20569,20649,20678,20698,20739,20741,20773,20779,20797,20813,20828,20845,20850,20871,20906,20915,20933,20949,20959,21000,21057,21062,21083,21107,21108,21143,21161,21189,21190,21195,21205,21215,21249,21284,21325,21342,21369,21381,21392,21397,21401,21434,21435,21438,21458,21464,21478,21488,21489,21552,21554,21578,21590,21601,21620,21639,21641,21691,21710,21740,21744,21764,21765,21776,21777,21783,21786,21821,21855,21858,21883,21894,21933,21944,21976,21982,22010,22040,22056,22063,22160,22173,22176,22179,22196,22198,22214,22237,22269,22298,22300,22313,22348,22407,22415,22416,22426,22453,22459,22461,22486,22550,22617,22647,22650,22653,22733,22734,22739,22756,22763,22808,22819,22837,22848,22864,22872,22889,22890,22904,22925,22957,22974,23031,23039,23065,23067,23076,23101,23113,23114,23131,23142,23185,23195,23201,23203,23221,23237,23241,23260,23280,23286,23296,23300,23313,23320,23325,23326,23328,23335,23339,23344,23394,23399,23406,23423,23521,23547,23555,23582,23592,23593,23622,23638,23678,23679,23691,23715,23722,23747,23757,23769,23822,23860,23890,23954,24015,24017,24043,24052,24062,24075,24102,24104,24122,24152,24170,24191,24198,24255,24273,24274,24289,24327,24335,24366,24367,24371,24392,24420,24455,24503,24524,24576,24592,24599,24644,24654,24655,24727,24733,24808,24816,24819,24826,24837,24838,24844,24860,24894,24899,24964,25010,25017,25039,25048,25066,25072,25088,25098,25107,25125,25128,25133,25141,25146,25157,25172,25197,25225,25253,25278,25284,25292,25317,25326,25335,25346,25356,25377,25380,25407,25440,25445,25510,25548,25565,25582,25621,25644,25645,25679,25693,25698,25705,25714,25717,25727,25730,25745,25785,25795,25834,25850,25864,25881,25935,25943,25964,25993,26065,26109,26154,26167,26178,26183,26235,26256,26273,26319,26348,26353,26362,26408,26409,26468,26469,26493,26501,26504,26521,26530,26563,26617,26638,26648,26717,26722,26753,26797,26807,26816,26848,26852,26901,26909,26926,26937,26944,26945,26955,26972,27002,27011,27035,27046,27122,27148,27150,27154,27170,27204,27237,27246,27250,27273,27280,27283,27311,27321,27376,27383,27418,27431,27448,27491,27496,27521,27545,27593,27610,27644,27686,27704,27721,27742,27779,27842,27859,27909,27917,27931,27936,27949,28005,28033,28045,28049,28082,28189,28225,28233,28306,28312,28344,28411,28432,28598,28628,28639,28653,28658,28695,28698,28746,28920,28989,28991,29008,29009,29028,29152,29153,29174,29197,29319,29356,29373,29417,29443,29444,29476,29548,29616,29781,29803,29864,29882,29905,29922,29923,29924,29935,30562,31216,31384,31820,32530,32768,32842,32919,33345,34174,34488,34676,35084,35115,35226,35299,35337,35360,35379,35434,35596,35617,35689,35746,35780,35883,35885,36085,36191,36297,36751,36817,36961,37034,37107,37116,37170,37360,37397,37403,37439,37454,38006,38103,38114,38122,38128,38315,38343,38395,38398,38440,38446,38452,38530,38549,38674,38807,38814,38831,38854,38866,38901,39013,39027,39052,39150,39163,39193,39245,39276,39315,39319,39347,39375,39389,39475,39481,39492,39603,39609,39681,39706,39722,39747,39768,39802,39857,40018,40025,40038,40083,40089,40097,40170,40200,40231,40276,40398,40436,40438,40460,40465,40535,40554,40555,40562,40614,40667,40688,40708,40752,40759,40774,40785,40809,40811,40817,40907,40937,40959,40984,41040,41059,41068,41150,41220,41246,41255,41301,41322,41325,41375,41418,41436,41499,41570,41576,41649,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42079,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44351,44400,44431,44491,44544,44588,44611,44613,44701,44814,44894,44908,44941,45051,45136,45157,45247,45302,45303)
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 | 1505 | 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.03 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.42 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 3.82 ms |
preparing | 1.71 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 22.42 ms |
end | 0.04 ms |
query end | 0.09 ms |
closing tables | 0.08 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 |