Tiempo de la consulta: 10.84 ms Después de la última consulta: 0.88 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.329 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 09:52:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 09:52:18')
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,30,51,82,98,150,176,178,179,183,184,197,211,214,328,350,385,393,396,405,407,432,435,441,466,693,760,902,935,1280,1287,1322,1331,1348,1354,1455,1535,1555,1603,1634,1646,1687,1713,1785,1800,1802,1814,1822,1878,1900,1910,1913,1928,2090,2092,2217,2305,2337,2378,2424,2583,2592,2598,2600,2601,2610,2613,2632,2636,2668,2689,2740,2805,2844,3067,3085,3087,3137,3212,3216,3314,3337,3346,3373,3408,3572,3592,3698,3718,3719,3725,3870,3871,3969,4015,4033,4065,4131,4163,4203,4320,4343,4369,4371,4378,4388,4458,4461,4469,4473,4478,4489,4511,4524,4534,4572,4658,4668,4758,4770,4832,4910,4947,4957,4990,5086,5104,5150,5170,5173,5237,5268,5288,5559,5648,5682,5686,5798,5810,5814,5820,5976,6012,6039,6078,6112,6190,6199,6264,6268,6270,6276,6307,6429,6473,6571,6626,6741,6830,6910,6917,6985,7205,7227,7317,7330,7358,7396,7416,7433,7477,7482,7495,7526,7623,7624,7659,7745,7782,7813,7829,7866,7875,7908,7936,8017,8026,8034,8039,8049,8057,8146,8167,8233,8311,8325,8330,8354,8362,8384,8410,8416,8438,8462,8680,8681,8689,8742,8769,8899,8952,8972,9012,9018,9023,9046,9051,9085,9107,9196,9197,9211,9224,9270,9300,9330,9370,9481,9483,9500,9518,9524,9529,9564,9595,9624,9734,9740,9775,9851,9858,9865,9869,9892,9896,9965,9975,9982,10026,10186,10205,10352,10400,10420,10603,10604,10660,10715,10745,10764,10811,10877,10878,10900,11094,11098,11106,11107,11121,11182,11305,11356,11374,11424,11627,11722,11775,11820,11859,11864,11994,12053,12054,12113,12144,12203,12216,12254,12318,12351,12482,12541,12592,12609,12669,12708,12714,12727,12895,12936,12997,13039,13060,13092,13268,13290,13321,13328,13352,13399,13402,13501,13535,13560,13575,13576,13604,13685,13693,13727,13748,13750,13782,13783,13846,13924,13941,14052,14122,14327,14356,14366,14421,14430,14435,14504,14524,14581,14586,14598,14648,14663,14679,14684,14699,14733,14846,14860,14862,14904,14905,14906,14953,14961,14973,14974,15001,15020,15045,15046,15139,15166,15179,15208,15209,15234,15250,15262,15273,15287,15293,15298,15304,15310,15311,15517,15528,15540,15561,15594,15615,15705,15714,15720,15741,15751,15753,15781,15851,15937,15947,15965,15985,16012,16057,16106,16122,16142,16198,16237,16243,16246,16392,16422,16430,16440,16455,16465,16477,16526,16654,16667,16720,16728,16737,16792,16802,16894,16944,16950,17065,17127,17133,17136,17199,17334,17335,17344,17346,17369,17409,17412,17419,17442,17463,17471,17584,17590,17597,17603,17609,17635,17654,17698,17700,17719,17750,17824,17826,17846,17857,17862,17900,17902,17910,17927,17948,17956,17976,17977,18028,18029,18051,18067,18135,18136,18165,18170,18227,18247,18271,18275,18277,18292,18313,18362,18410,18473,18509,18573,18595,18606,18624,18650,18670,18707,18719,18756,18778,18784,18825,18906,18907,18926,18958,18972,18974,18986,19010,19024,19029,19076,19106,19123,19127,19153,19204,19211,19215,19232,19235,19242,19247,19281,19285,19288,19299,19335,19353,19423,19426,19430,19432,19484,19487,19590,19666,19706,19715,19750,19777,19796,19807,19858,19876,19920,19967,19988,20040,20066,20068,20074,20140,20142,20179,20185,20187,20193,20198,20256,20295,20309,20325,20334,20338,20371,20396,20434,20437,20457,20469,20516,20521,20565,20574,20592,20598,20618,20641,20642,20648,20688,20715,20750,20751,20792,20807,20877,20882,20887,20897,20923,20953,20990,20991,21017,21053,21066,21087,21110,21160,21163,21173,21191,21198,21247,21259,21310,21329,21332,21344,21356,21405,21487,21502,21530,21547,21560,21598,21602,21614,21722,21726,21747,21750,21759,21769,21773,21811,21818,21824,21842,21891,21908,21932,22027,22037,22118,22128,22129,22134,22137,22156,22185,22229,22243,22253,22262,22265,22267,22273,22453,22466,22468,22481,22484,22494,22508,22581,22606,22609,22634,22674,22739,22741,22746,22764,22781,22851,22869,22871,22886,22914,22925,22959,22964,23036,23037,23042,23083,23099,23104,23119,23123,23184,23213,23225,23229,23257,23277,23287,23309,23328,23364,23381,23398,23404,23486,23576,23695,23704,23731,23764,23832,23866,23885,23888,23891,23897,23901,23905,23906,23907,23921,23964,24005,24029,24067,24069,24077,24163,24283,24316,24337,24474,24485,24592,24617,24721,24738,24781,24784,24785,24834,24871,24947,24983,25011,25032,25038,25068,25118,25121,25201,25260,25269,25281,25290,25312,25348,25377,25447,25450,25512,25525,25547,25548,25611,25621,25622,25644,25673,25717,25723,25757,25818,25927,25928,25929,25964,25979,26000,26001,26013,26038,26066,26093,26113,26128,26135,26153,26254,26296,26335,26372,26386,26388,26393,26448,26530,26565,26576,26603,26620,26630,26639,26646,26691,26699,26725,26734,26769,26784,26807,26820,26841,26845,26868,26879,26935,26990,27065,27097,27160,27212,27216,27235,27250,27251,27271,27314,27323,27347,27367,27399,27408,27423,27440,27445,27492,27541,27568,27570,27577,27583,27592,27595,27601,27611,27671,27717,27757,27758,27786,27920,27944,27957,27971,28031,28059,28066,28075,28094,28097,28114,28120,28129,28139,28162,28168,28192,28230,28243,28323,28329,28435,28441,28533,28624,28632,28673,28757,28839,28916,28933,28952,28972,29011,29023,29045,29057,29187,29234,29266,29331,29341,29343,29639,29720,29769,29812,29835,29865,29866,29896,30222,31608,31975,32084,32629,33925,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35468,35490,35554,35556,35621,35688,35770,35805,35806,35808,35831,35882,35948,35965,36000,36015,36220,36237,36368,36369,36373,36385,36420,36441,36584,36733,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37626,37644,38058,38126,38133,38330,38433,38489,38546,38740,38824,38877,38904,38922,38949,39205,39290,39296,39476,39497,39570,39587,39610,39666,39717,39940,40319,40343,40356,40367,40509,40560,40647,41062,41332,41345,41516,41781,41969,42637,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44267,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 | 1017 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.60 ms |
preparing | 0.81 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.63 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.07 ms |
freeing items | 0.14 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 |