Tiempo de la consulta: 5.47 ms Después de la última consulta: 1.22 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.376 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 12:38:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:38:24')
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(9,25,45,46,54,58,62,65,71,174,260,263,415,535,643,659,740,764,918,991,1158,1308,1326,1335,1337,1439,1503,1563,1571,1752,1810,2084,2091,2223,2261,2282,2395,2479,2525,2537,2815,2843,2909,2953,3059,3111,3161,3196,3202,3266,3312,3342,3346,3368,3396,3452,3461,3504,3517,3553,3604,3614,3633,3637,3685,3700,3732,3760,3767,3769,3776,3777,3780,3821,3833,3849,3862,3913,3926,3960,4002,4034,4081,4101,4110,4129,4132,4148,4150,4157,4169,4177,4188,4200,4204,4231,4241,4284,4315,4323,4327,4384,4390,4423,4456,4494,4499,4513,4531,4548,4575,4580,4643,4677,4774,4791,4803,4852,4859,4917,4920,4927,4931,4935,4940,4980,5091,5138,5189,5211,5218,5259,5295,5315,5387,5422,5426,5435,5456,5459,5461,5479,5484,5530,5537,5565,5616,5641,5676,5751,5767,5783,5792,5825,5851,5854,5862,5909,5911,5912,5917,5932,5934,5953,5961,5962,6030,6050,6062,6080,6082,6100,6116,6128,6135,6158,6167,6186,6204,6268,6275,6282,6306,6340,6360,6362,6407,6412,6440,6456,6479,6492,6493,6496,6588,6616,6649,6684,6698,6716,6720,6722,6744,6812,6865,6878,6881,6897,6927,6928,6933,6953,7031,7061,7071,7077,7111,7120,7128,7148,7169,7181,7185,7216,7222,7250,7258,7287,7321,7331,7343,7364,7396,7425,7436,7443,7444,7446,7455,7509,7526,7553,7561,7565,7572,7586,7604,7605,7614,7618,7651,7669,7679,7696,7724,7725,7731,7732,7735,7737,7741,7752,7771,7784,7787,7825,7903,7906,7925,7935,7942,8004,8045,8055,8064,8125,8131,8142,8152,8160,8167,8181,8214,8223,8227,8229,8232,8234,8241,8259,8265,8279,8281,8285,8289,8298,8307,8311,8323,8334,8345,8370,8378,8381,8383,8397,8421,8441,8453,8507,8522,8523,8547,8549,8550,8555,8589,8611,8621,8644,8649,8655,8664,8680,8687,8688,8689,8700,8711,8713,8724,8732,8737,8750,8753,8799,8813,8826,8851,8856,8864,8871,8883,8897,8925,8935,8954,8970,9031,9059,9063,9120,9157,9165,9176,9181,9232,9233,9303,9328,9343,9350,9365,9390,9399,9432,9438,9439,9452,9458,9463,9467,9477,9481,9504,9568,9578,9593,9600,9610,9633,9645,9646,9673,9704,9738,9746,9769,9805,9828,9829,9838,9854,9861,9863,9878,9902,9904,9908,9922,9948,9956,9976,10004,10014,10033,10038,10042,10054,10110,10120,10124,10126,10131,10132,10154,10156,10166,10180,10184,10187,10190,10236,10240,10245,10265,10269,10295,10297,10304,10313,10369,10377,10414,10448,10513,10542,10564,10577,10610,10611,10614,10617,10642,10729,10754,10756,10787,10791,10846,10921,10993,11023,11026,11031,11041,11073,11121,11150,11162,11250,11286,11323,11328,11335,11338,11345,11386,11387,11414,11425,11428,11429,11442,11488,11545,11571,11592,11642,11687,11784,11796,11803,11859,11919,11921,11934,11960,12019,12221,12248,12249,12286,12328,12459,12525,12553,12627,12632,12638,12683,12689,12690,12692,12736,12857,12935,12978,12997,13019,13058,13059,13146,13166,13170,13173,13175,13209,13268,13334,13348,13376,13385,13450,13604,13670,13702,13731,13738,13740,13747,13760,13789,13825,13883,13889,13927,13946,13961,13985,13996,14050,14134,14141,14158,14276,14303,14327,14351,14381,14396,14420,14438,14439,14512,14513,14515,14532,14595,14598,14601,14607,14616,14645,14661,14662,14691,14730,14739,14751,14760,14785,14806,14820,14824,14825,14870,14889,14898,14939,14950,14991,14999,15006,15015,15041,15058,15069,15074,15076,15081,15120,15148,15158,15160,15161,15178,15192,15193,15219,15240,15268,15325,15326,15344,15347,15351,15388,15393,15423,15449,15453,15457,15465,15475,15482,15487,15515,15527,15537,15539,15541,15551,15570,15611,15617,15618,15636,15637,15640,15680,15726,15738,15750,15766,15767,15783,15866,15893,15894,15913,15973,16025,16036,16039,16042,16059,16082,16084,16097,16105,16107,16127,16129,16156,16181,16186,16221,16236,16248,16256,16257,16270,16292,16299,16314,16315,16389,16392,16403,16468,16490,16512,16523,16552,16562,16577,16625,16651,16675,16710,16739,16742,16759,16765,16791,16828,16874,16877,16886,16890,16913,16930,16991,16993,17006,17007,17053,17062,17074,17102,17115,17145,17160,17216,17233,17288,17394,17407,17425,17427,17435,17447,17453,17468,17491,17510,17605,17633,17650,17668,17672,17773,17820,17844,17846,17855,17859,17893,17899,17926,17937,17966,18054,18062,18122,18157,18163,18179,18180,18183,18216,18233,18255,18274,18292,18314,18344,18362,18367,18399,18460,18468,18483,18536,18539,18544,18564,18589,18608,18643,18709,18748,18789,18793,18800,18805,18846,18862,18878,18916,18922,18925,18931,18954,18975,18980,18997,19028,19034,19042,19068,19077,19105,19124,19128,19135,19142,19155,19171,19218,19240,19247,19288,19313,19332,19333,19366,19368,19437,19530,19550,19561,19571,19604,19637,19652,19674,19690,19713,19732,19742,19807,19851,19852,19872,19887,19918,19919,19934,19945,19949,19951,20003,20018,20030,20127,20189,20250,20260,20264,20284,20327,20348,20360,20376,20393,20429,20431,20444,20460,20461,20602,20608,20610,20620,20649,20660,20672,20676,20678,20718,20741,20779,20790,20797,20813,20828,20833,20850,20906,20915,20947,20959,21000,21017,21049,21057,21062,21107,21108,21143,21161,21183,21190,21231,21249,21305,21325,21350,21369,21381,21397,21434,21435,21458,21464,21489,21512,21529,21530,21552,21554,21578,21590,21609,21627,21637,21640,21641,21666,21710,21733,21740,21744,21764,21776,21777,21855,21858,21883,21894,21902,21919,21944,21976,21982,22010,22027,22040,22063,22069,22097,22141,22160,22176,22214,22237,22254,22258,22298,22313,22348,22359,22389,22395,22407,22454,22459,22461,22566,22605,22617,22647,22649,22659,22675,22696,22733,22739,22751,22763,22819,22827,22837,22877,22889,22890,22904,22957,22986,23065,23067,23131,23185,23195,23201,23214,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23340,23367,23438,23444,23527,23575,23582,23644,23665,23678,23679,23680,23689,23693,23716,23778,23849,23869,23890,23911,23949,23955,24075,24100,24102,24104,24152,24191,24273,24274,24327,24366,24371,24392,24397,24433,24475,24503,24514,24592,24602,24623,24633,24644,24668,24716,24727,24733,24767,24779,24780,24816,24837,24844,24872,24885,24899,24958,24964,25072,25098,25107,25125,25133,25225,25253,25273,25310,25341,25343,25377,25380,25443,25560,25621,25644,25645,25664,25714,25717,25724,25730,25785,25807,25850,25993,26031,26173,26178,26183,26208,26230,26250,26256,26273,26319,26471,26474,26493,26501,26504,26508,26521,26533,26535,26543,26563,26594,26648,26832,26840,26901,26926,26937,26939,26972,27002,27011,27150,27170,27245,27246,27273,27321,27418,27431,27438,27496,27521,27545,27557,27589,27593,27613,27644,27686,27687,27704,27721,27842,27917,27930,27931,27936,27983,28005,28006,28018,28033,28045,28082,28225,28312,28411,28639,28653,28658,28912,28989,29008,29009,29067,29129,29152,29153,29174,29197,29319,29345,29356,29417,29443,29444,29476,29560,29603,29781,29799,29818,29905,29914,29922,29923,29935,29936,30282,31207,31684,32768,32842,34089,34126,34163,34257,34273,34321,34500,34559,34653,34750,34781,34782,34793,34804,34838,34895,35055,35103,35176,35184,35359,35435,35452,35484,35492,35523,35545,35617,35623,35632,35689,35741,35760,35841,35846,35869,35872,35883,35885,35967,35980,36232,36234,36281,36461,36476,36583,36615,36680,36803,36815,36829,36896,36945,37284,37353,37371,37397,37401,37426,37557,37577,37602,37618,37642,37717,37880,37906,37907,38079,38131,38372,38393,38451,38549,38574,38602,38656,38666,38713,38807,38831,38854,38866,39088,39135,39183,39286,39370,39411,39481,39507,39511,39520,39580,39598,39603,39615,39627,39631,39634,39642,39677,39681,39816,39857,40025,40038,40054,40083,40097,40170,40200,40251,40311,40326,40365,40585,40594,40640,40659,40708,40720,40727,40759,40761,40775,40785,40803,40809,40860,40887,40907,40937,40941,40973,40984,41007,41048,41059,41140,41153,41158,41163,41200,41255,41299,41301,41325,41350,41375,41421,41543,41566,41619,41622,41687,41695,41696,41747,41779,41816,41840,41853,41876,41911,41993,42021,42080,42187,42259,42274,42367,42368,42412,42531,42651,42676,42730,42758,42789,42797,42891,43056,43068,43488,43554,43653,43678,43988,44142)
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 | 1360 | 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.67 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.01 ms |
preparing | 1.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |