Tiempo de la consulta: 10.50 ms Después de la última consulta: 1.06 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.352 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-06 11:17:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 11:17:53')
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(13,21,30,51,75,82,174,183,184,197,257,275,280,328,350,385,393,407,693,902,935,976,1101,1216,1280,1295,1329,1352,1354,1357,1425,1455,1490,1535,1603,1634,1646,1713,1755,1781,1785,1800,1802,1810,1822,1900,1905,1913,1929,2022,2081,2210,2217,2305,2337,2378,2424,2428,2554,2598,2600,2601,2613,2632,2636,2668,2689,2805,2825,2902,3035,3067,3087,3177,3212,3216,3337,3373,3408,3499,3553,3594,3624,3702,3706,3718,3719,3725,3790,3871,3986,4033,4069,4084,4090,4131,4152,4166,4215,4227,4230,4282,4320,4473,4493,4612,4613,4614,4615,4617,4715,4748,4760,4770,4800,4832,4842,4891,4910,4947,4957,4990,5021,5033,5071,5083,5086,5092,5104,5150,5152,5170,5173,5215,5232,5237,5238,5268,5269,5295,5329,5350,5442,5491,5559,5686,5687,5691,5731,5751,5755,5798,5814,5819,5846,5878,5933,5943,5998,6004,6024,6028,6039,6069,6095,6185,6192,6264,6268,6270,6324,6409,6414,6433,6447,6453,6485,6571,6581,6586,6706,6715,6788,6797,6817,6830,6910,6917,6977,6982,6985,7079,7081,7088,7100,7102,7149,7205,7330,7353,7358,7395,7396,7397,7398,7416,7482,7526,7556,7565,7610,7624,7659,7690,7735,7737,7745,7787,7799,7813,7866,7971,8026,8039,8043,8057,8100,8247,8280,8285,8308,8311,8330,8335,8346,8354,8375,8392,8396,8408,8416,8429,8436,8437,8438,8452,8462,8492,8506,8546,8571,8632,8646,8653,8656,8685,8690,8706,8715,8740,8755,8761,8771,8785,8851,8854,8866,8923,8940,8972,8983,8987,9012,9018,9039,9042,9051,9064,9071,9091,9114,9127,9130,9142,9157,9166,9189,9196,9197,9297,9300,9308,9330,9334,9347,9370,9382,9407,9450,9481,9529,9585,9604,9639,9646,9675,9676,9690,9693,9694,9757,9840,9865,9869,9883,9922,9951,9964,9973,9990,10039,10087,10108,10135,10186,10260,10278,10342,10352,10359,10400,10422,10458,10510,10522,10570,10603,10604,10634,10636,10764,10789,10791,10793,10811,10963,11023,11031,11098,11106,11107,11115,11121,11193,11239,11253,11305,11323,11338,11356,11476,11510,11568,11581,11627,11673,11703,11721,11722,11742,11803,11820,11859,11864,11875,11994,12027,12060,12101,12104,12113,12144,12155,12184,12186,12216,12232,12254,12289,12434,12488,12507,12509,12541,12592,12594,12609,12650,12669,12686,12708,12844,12984,13077,13089,13154,13188,13209,13268,13276,13321,13328,13349,13356,13454,13458,13474,13485,13501,13535,13537,13575,13576,13685,13693,13727,13748,13750,13769,13782,13783,13830,13846,13853,13913,13924,13941,13947,13995,13996,14008,14038,14052,14079,14122,14157,14169,14263,14327,14345,14356,14357,14407,14430,14524,14569,14648,14663,14679,14713,14733,14737,14749,14754,14828,14832,14846,14860,14862,14863,14899,14905,14906,14911,14973,14996,15012,15020,15040,15045,15046,15071,15101,15152,15153,15160,15166,15179,15208,15209,15217,15234,15253,15262,15269,15293,15295,15298,15304,15310,15323,15326,15366,15517,15528,15539,15540,15563,15594,15628,15673,15689,15703,15721,15751,15753,15771,15772,15777,15796,15851,15862,15870,15917,15937,15938,15947,16057,16120,16122,16136,16258,16274,16314,16327,16346,16354,16378,16422,16440,16455,16465,16509,16526,16562,16578,16602,16653,16654,16678,16726,16728,16737,16747,16767,16798,16802,16823,16873,16894,16959,17014,17023,17024,17034,17121,17133,17136,17159,17167,17199,17213,17304,17329,17334,17335,17344,17353,17369,17385,17386,17409,17412,17475,17541,17554,17568,17584,17590,17597,17603,17609,17620,17630,17635,17662,17700,17731,17826,17857,17862,17877,17902,17910,17927,17956,17976,17977,18028,18029,18067,18150,18155,18165,18170,18190,18227,18334,18362,18473,18568,18590,18595,18631,18658,18702,18707,18739,18768,18782,18801,18825,18827,18841,18906,18907,18926,18958,18974,19024,19069,19123,19127,19153,19158,19204,19211,19225,19232,19235,19299,19353,19423,19426,19432,19478,19484,19487,19706,19750,19796,19858,19875,19876,19904,19916,19959,19967,19988,20066,20068,20083,20140,20180,20309,20338,20376,20396,20398,20399,20434,20437,20469,20521,20565,20574,20592,20611,20618,20642,20648,20671,20688,20690,20750,20751,20753,20792,20888,20902,20953,20990,21053,21087,21192,21198,21259,21329,21332,21361,21405,21407,21413,21455,21487,21520,21523,21524,21547,21566,21569,21598,21602,21612,21614,21696,21707,21719,21722,21726,21747,21769,21773,21787,21795,21811,21824,21891,21932,21944,21969,22009,22067,22073,22117,22129,22134,22137,22144,22173,22230,22233,22253,22262,22267,22286,22360,22393,22453,22454,22466,22481,22484,22494,22581,22620,22659,22684,22712,22739,22749,22781,22785,22805,22812,22851,22869,22871,22886,22892,22914,22925,22959,22964,23012,23036,23037,23083,23099,23104,23119,23123,23139,23184,23201,23213,23229,23273,23287,23309,23328,23364,23365,23381,23398,23523,23552,23704,23720,23770,23885,23888,23891,23897,23905,23907,23921,23964,24029,24067,24077,24145,24163,24229,24316,24337,24485,24524,24528,24538,24617,24766,24781,24785,24834,24871,24983,25032,25038,25062,25068,25201,25377,25450,25505,25518,25548,25554,25589,25592,25621,25622,25639,25646,25648,25671,25673,25717,25723,25727,25729,25747,25757,25758,25771,25817,25818,25830,25836,25916,25924,25927,25928,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26062,26066,26082,26087,26099,26103,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26234,26259,26296,26335,26337,26359,26372,26386,26388,26565,26575,26576,26590,26620,26630,26639,26646,26691,26699,26765,26780,26784,26820,26845,26873,26879,26927,26933,26935,26968,27065,27183,27211,27212,27216,27240,27270,27323,27327,27347,27367,27405,27408,27423,27487,27492,27526,27541,27568,27570,27578,27583,27592,27595,27601,27671,27688,27707,27717,27758,27786,27834,27922,27924,28019,28031,28059,28066,28073,28075,28094,28097,28104,28114,28120,28129,28162,28168,28192,28230,28243,28264,28329,28397,28420,28435,28454,28673,28846,28931,28943,29011,29045,29266,29505,29611,29616,29639,29724,29743,29769,29866,30111,31608,31735,31820,31837,31853,32084,32720,32767,32768,33874,33908,33925,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35688,35728,35805,35806,35808,35814,35835,35846,35882,35948,36000,36015,36141,36220,36237,36368,36369,36373,36385,36420,36441,36584,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37544,37626,37644,37677,37883,37902,38058,38092,38126,38133,38330,38433,38489,38546,38617,38723,38799,38821,38824,38829,38877,38904,38912,38922,38949,38965,38990,39155,39205,39290,39293,39296,39366,39442,39476,39497,39559,39587,39610,39686,39717,39724,40319,40509,40560,40624,40647,41062,41120,41171,41289,41332,41345,41516,41781,41969,42637,42987,43003,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 1166 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.82 ms |
preparing | 0.90 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.94 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |