Tiempo de la consulta: 8.63 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.475 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 22:08:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 22:08:07')
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,183,184,197,269,275,311,328,350,393,407,693,715,764,902,935,988,1167,1280,1354,1358,1455,1535,1603,1634,1646,1800,1802,1822,1900,1913,2217,2228,2239,2305,2337,2378,2424,2598,2600,2601,2632,2636,2668,2689,3067,3075,3079,3087,3212,3216,3337,3373,3381,3408,3563,3718,3719,3725,3868,3871,4061,4131,4320,4339,4473,4493,4775,4799,4832,4910,4947,4957,4990,5104,5150,5170,5173,5224,5559,5679,5686,6039,6264,6270,6277,6427,6571,6775,6830,6910,6917,6985,7290,7330,7358,7416,7446,7526,7569,7624,7659,7712,7739,7745,7746,7855,8026,8039,8057,8330,8333,8354,8416,8462,8550,8685,8714,9012,9018,9052,9098,9111,9196,9197,9199,9300,9370,9865,9869,9958,10186,10213,10258,10352,10400,10522,10603,10604,10727,10764,10811,10840,11098,11107,11121,11208,11305,11356,11612,11742,11820,11859,11864,11994,12113,12144,12216,12254,12330,12541,12575,12609,12669,12843,12978,13132,13268,13321,13325,13352,13534,13535,13575,13576,13589,13693,13727,13782,13818,13819,13846,13941,13971,14052,14079,14122,14128,14327,14356,14389,14430,14524,14648,14660,14663,14679,14713,14733,14769,14838,14849,14860,14862,14869,14878,14905,14973,15020,15038,15045,15046,15054,15166,15179,15208,15209,15234,15262,15289,15298,15517,15528,15594,15650,15681,15751,15833,15849,15870,15917,15937,15947,16011,16057,16242,16422,16440,16455,16465,16548,16652,16654,16737,16740,16802,16862,16894,16899,17027,17035,17052,17080,17117,17121,17141,17199,17217,17334,17335,17344,17369,17409,17412,17590,17603,17609,17700,17826,17857,17871,17902,17927,17956,18022,18028,18029,18067,18165,18170,18227,18362,18473,18548,18595,18628,18707,18825,18906,18907,18912,18926,18927,18929,18958,19024,19032,19123,19127,19153,19204,19211,19232,19299,19353,19423,19426,19432,19484,19487,19750,19858,19876,19890,19967,19988,20026,20066,20086,20246,20309,20384,20437,20455,20469,20521,20565,20574,20592,20599,20604,20618,20638,20642,20648,20750,20787,20792,20806,21021,21040,21053,21180,21198,21256,21259,21275,21279,21329,21405,21520,21523,21547,21598,21602,21614,21718,21719,21722,21726,21747,21769,21773,21791,21811,21824,21891,21932,22129,22196,22253,22262,22267,22329,22332,22424,22453,22466,22476,22481,22484,22494,22581,22612,22659,22674,22689,22739,22753,22781,22869,22886,22914,22925,22959,22964,22966,23036,23037,23099,23104,23119,23123,23184,23200,23229,23261,23287,23304,23326,23328,23332,23340,23364,23365,23381,23495,23547,23555,23585,23625,23708,23718,23860,23871,23885,23888,23891,23897,23905,23921,23964,24051,24077,24163,24208,24269,24281,24286,24316,24337,24357,24463,24617,24650,24781,24785,24793,24800,24802,24815,24854,24871,24915,24951,24983,25032,25038,25068,25148,25200,25201,25377,25450,25548,25621,25622,25639,25673,25723,25740,25757,25758,25790,25818,25836,25864,25916,25927,25928,25949,26000,26013,26056,26066,26113,26117,26124,26153,26188,26211,26221,26262,26288,26296,26335,26359,26372,26376,26381,26386,26387,26544,26562,26565,26576,26587,26620,26639,26646,26658,26664,26671,26678,26691,26744,26755,26760,26820,26845,26915,26968,27005,27065,27102,27122,27212,27216,27323,27343,27347,27367,27408,27423,27448,27454,27541,27581,27583,27592,27595,27601,27614,27671,27717,27758,27766,27986,28016,28017,28031,28059,28066,28075,28094,28097,28109,28114,28120,28129,28152,28162,28168,28192,28230,28243,28354,28356,28435,28570,28582,28670,28673,28846,28857,28985,29011,29045,29266,29333,29483,29590,29602,29630,29639,29726,29769,29866,29977,30334,30529,30580,31608,31679,31764,32084,32649,32689,32817,32865,32973,33090,33091,33099,33116,33259,33573,33596,33832,33874,33902,33917,33924,33925,33946,33951,33952,33957,33981,33982,33993,33999,34014,34025,34105,34122,34140,34171,34175,34251,34275,34331,34501,34616,34629,34646,34677,34693,34714,34776,34811,34815,34914,35092,35197,35220,35227,35238,35239,35282,35288,35289,35339,35376,35385,35397,35426,35444,35490,35554,35556,35621,35668,35683,35684,35687,35688,35805,35882,35910,35921,35937,35948,36000,36015,36186,36210,36220,36237,36331,36368,36369,36373,36385,36420,36441,36584,36828,36851,36930,36934,36989,36998,37010,37011,37136,37147,37155,37177,37245,37250,37283,37307,37308,37370,37378,37520,37534,37626,37643,37644,37757,37798,37820,37902,38046,38058,38126,38133,38157,38277,38288,38301,38330,38402,38432,38433,38489,38546,38681,38723,38824,38843,38877,38904,38922,38939,38949,39058,39205,39290,39296,39392,39474,39476,39497,39587,39600,39610,39635,39686,39717,39850,39891,39963,40030,40118,40263,40319,40334,40405,40509,40560,40647,40702,40748,40857,41009,41062,41105,41172,41212,41225,41332,41345,41407,41415,41504,41505,41506,41516,41668,41781,41791,41912,41968,41969,42033,42131,42145,42198,42386,42564,42637,42683,42987,42992,43012,43016,43109,43113,43165,43237,43257,43271,43350,43405,43446,43461,43483,43517,43518,43535,43712,44009,44062,44366,44573,44718,44721,44788,44807,44829,44873,44912,44935,44936,44988,45101,45132,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 | 838 | 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.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.29 ms |
preparing | 0.66 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.97 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 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 |