Tiempo de la consulta: 4.16 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.343 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 19:03:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 19:03:40')
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(2,3,4,5,6,7,8,16,25,28,29,49,70,71,72,73,75,113,154,165,255,263,267,275,276,280,296,297,300,301,303,304,305,307,318,344,372,373,549,581,583,592,607,615,723,733,757,794,802,816,832,847,848,868,878,895,900,916,917,941,989,1015,1046,1053,1056,1073,1080,1105,1140,1161,1186,1207,1212,1220,1235,1238,1257,1304,1308,1504,1519,1563,1573,1600,1743,1753,1804,1805,1823,1920,1932,2020,2053,2076,2290,2293,2305,2322,2428,2547,2566,2773,2794,2801,2886,2887,2893,2927,2938,2980,2991,3005,3085,3093,3208,3226,3234,3245,3265,3306,3353,3393,3447,3452,3458,3579,3604,3634,3700,3716,3733,3786,3835,3855,3880,3883,3928,3969,3976,3986,4028,4063,4093,4114,4165,4173,4182,4209,4249,4250,4260,4268,4302,4344,4364,4378,4405,4433,4434,4515,4582,4644,4691,4739,4855,4907,4908,4911,4933,4973,5018,5065,5150,5182,5207,5247,5302,5363,5367,5439,5451,5559,5567,5576,5593,5640,5658,5665,5698,5730,5808,5824,5872,5879,5889,5894,5924,5967,5998,6062,6084,6141,6147,6311,6330,6451,6470,6473,6542,6543,6545,6616,6658,6662,6742,6780,6804,6945,7095,7249,7260,7325,7329,7365,7417,7423,7424,7458,7489,7520,7536,7554,7556,7584,7616,7622,7627,7718,7741,7743,7751,7758,7771,7797,7806,7934,7939,7950,7965,8021,8026,8027,8074,8083,8101,8114,8224,8261,8306,8318,8381,8406,8499,8569,8616,8661,8759,8765,8779,8860,8932,8963,8999,9010,9030,9038,9111,9114,9199,9262,9263,9291,9426,9443,9444,9454,9480,9483,9689,9704,9715,9741,9745,9755,9853,9864,9928,9981,9995,10010,10068,10098,10100,10110,10120,10138,10217,10267,10268,10298,10304,10368,10384,10402,10479,10481,10628,10686,10696,10713,10751,10758,10769,10827,10842,10863,10886,10912,10971,10982,11032,11038,11041,11076,11108,11140,11146,11150,11156,11159,11179,11224,11279,11292,11328,11383,11398,11421,11424,11438,11473,11534,11542,11561,11701,11717,11723,11730,11794,11838,11859,11894,11944,11990,12034,12115,12145,12158,12206,12212,12218,12225,12307,12357,12393,12399,12548,12554,12576,12625,12640,12684,12747,12758,12761,12815,12834,12852,12902,12959,12966,13115,13155,13172,13188,13218,13265,13425,13433,13454,13462,13518,13665,13670,13671,13675,13698,13710,13731,13734,13741,13765,13869,13907,13925,13926,13970,13972,13994,14005,14037,14070,14083,14101,14115,14141,14154,14159,14190,14204,14205,14227,14229,14249,14255,14270,14278,14281,14305,14331,14341,14382,14385,14482,14484,14495,14522,14524,14557,14560,14572,14573,14609,14665,14723,14746,14747,14766,14776,14807,14811,14846,14850,14909,14911,14931,14945,14981,14993,15002,15029,15047,15051,15055,15069,15091,15100,15115,15122,15126,15218,15257,15258,15272,15277,15286,15293,15304,15328,15411,15442,15468,15475,15488,15499,15518,15522,15524,15543,15561,15633,15643,15689,15728,15732,15750,15758,15864,15927,15952,15957,15980,16142,16154,16163,16209,16258,16311,16313,16356,16358,16359,16365,16394,16401,16451,16502,16515,16517,16535,16545,16604,16609,16645,16685,16686,16712,16784,16828,16879,16887,16910,16916,16955,16963,16996,17069,17085,17090,17115,17132,17146,17177,17187,17195,17205,17234,17307,17327,17359,17407,17423,17431,17434,17438,17470,17477,17518,17537,17546,17551,17602,17656,17666,17667,17692,17730,17750,17753,17764,17766,17781,17813,17820,17822,17839,17852,17873,17880,17925,17935,17953,17956,17993,18000,18018,18032,18040,18073,18145,18153,18200,18260,18278,18282,18304,18306,18311,18357,18364,18375,18390,18391,18395,18420,18524,18527,18562,18564,18570,18576,18578,18579,18581,18583,18591,18593,18594,18607,18617,18627,18651,18686,18689,18697,18718,18733,18734,18747,18765,18771,18773,18793,18812,18829,18853,18882,18889,18900,18915,18934,18949,18952,18955,18960,19011,19018,19026,19043,19047,19050,19057,19073,19089,19117,19119,19133,19134,19147,19202,19216,19227,19247,19256,19266,19304,19374,19381,19401,19411,19429,19469,19471,19476,19508,19545,19562,19563,19576,19591,19596,19604,19606,19610,19648,19663,19667,19700,19713,19744,19749,19758,19764,19770,19825,19829,19853,19868,19880,19882,19900,19913,19944,19994,20009,20016,20029,20050,20080,20116,20124,20144,20164,20179,20223,20224,20230,20291,20307,20341,20346,20355,20366,20398,20402,20406,20409,20455,20510,20511,20522,20542,20558,20586,20589,20602,20614,20651,20665,20705,20707,20714,20740,20742,20764,20807,20820,20845,20878,20919,20924,20941,20945,20951,20962,20967,20977,21019,21031,21042,21046,21054,21067,21072,21101,21136,21146,21163,21171,21179,21215,21226,21238,21239,21240,21255,21260,21274,21292,21308,21311,21322,21372,21379,21411,21450,21455,21467,21490,21562,21583,21584,21586,21592,21643,21675,21713,21729,21739,21765,21775,21789,21866,21886,21921,21964,21975,21979,21981,22001,22010,22029,22046,22056,22120,22181,22198,22201,22211,22213,22220,22223,22269,22272,22286,22294,22307,22318,22338,22455,22478,22486,22500,22509,22551,22578,22635,22664,22687,22688,22732,22733,22741,22750,22783,22786,22803,22808,22820,22831,22846,22852,22856,22863,22901,22916,22925,22935,22974,23028,23041,23042,23066,23067,23070,23075,23076,23078,23100,23109,23113,23128,23130,23163,23164,23201,23243,23259,23278,23286,23300,23362,23399,23423,23426,23433,23448,23449,23484,23555,23617,23622,23635,23649,23696,23767,23842,23859,23885,23926,23964,23987,23992,24059,24077,24122,24134,24200,24235,24260,24302,24322,24337,24367,24420,24433,24452,24475,24510,24513,24576,24611,24655,24674,24695,24699,24737,24826,24844,24860,24876,24999,25004,25024,25048,25088,25104,25123,25135,25178,25179,25212,25277,25346,25347,25397,25415,25445,25460,25482,25548,25565,25657,25679,25698,25709,25727,25795,25864,25932,25935,25946,25991,26065,26228,26235,26288,26317,26469,26548,26620,26760,26818,26892,26937,27049,27125,27138,27148,27236,27250,27279,27321,27362,27427,27495,27514,27592,27761,27790,27909,27949,27954,27968,28005,28049,28313,28327,28344,28476,28548,28557,28563,28575,28581,28630,28695,28698,28803,28920,28922,28999,29022,29028,29190,29319,29341,29382,29387,29486,29694,29695,29711,29719,29832,29882,30285,31975,33877,35746,36151,36191,38353,38465,38763,38866,38903,39035,39048,39071,39111,39195,39335,39384,39480,39542,39558,39572,39645,39646,39666,39819,39891,39907,40112,40441,40502,40558,40752,40813,40922,41092,41219,41350)
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 | 1074 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.66 ms |
preparing | 0.80 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |