Tiempo de la consulta: 4.24 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.319 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 01:58:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 01:58:56')
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,260,263,415,643,659,764,1335,1563,1571,2035,2084,2321,2909,2976,3150,3160,3196,3266,3430,3452,3604,3685,3700,3732,3760,3767,3772,3776,3833,3913,3960,4031,4034,4100,4101,4110,4129,4148,4150,4169,4188,4204,4236,4284,4305,4323,4327,4387,4396,4423,4425,4456,4548,4575,4677,4859,4920,4933,4940,4965,4980,5026,5138,5189,5259,5387,5422,5435,5461,5474,5503,5825,5909,6100,6128,6360,6362,6407,6440,6492,6493,6530,6532,6556,6575,6596,6616,6638,6649,6660,6663,6667,6671,6716,6720,6722,6865,6881,6921,7010,7047,7077,7111,7128,7172,7185,7190,7216,7237,7238,7250,7258,7331,7335,7336,7364,7396,7420,7425,7444,7455,7507,7565,7572,7586,7605,7614,7618,7651,7684,7724,7725,7735,7741,7752,7771,7784,7785,7787,7903,7925,7935,7937,7942,8004,8010,8055,8064,8125,8152,8155,8160,8223,8227,8229,8232,8234,8265,8285,8370,8378,8383,8420,8421,8507,8510,8549,8550,8555,8578,8589,8596,8611,8621,8627,8644,8650,8660,8668,8689,8700,8713,8750,8753,8799,8813,8826,8851,8856,8864,8897,8925,8954,8978,9063,9079,9112,9113,9120,9130,9142,9172,9181,9225,9233,9274,9328,9350,9390,9399,9420,9432,9438,9439,9453,9477,9578,9599,9600,9610,9704,9738,9805,9828,9829,9838,9871,9873,9878,9904,9908,9922,9945,9956,10004,10054,10085,10110,10120,10127,10154,10156,10180,10190,10265,10269,10295,10304,10313,10369,10414,10448,10513,10564,10583,10611,10617,10642,10754,10756,10775,10823,10855,10920,10947,10991,10993,11023,11026,11031,11041,11066,11073,11121,11150,11250,11286,11328,11338,11345,11386,11387,11488,11512,11545,11592,11642,11687,11768,11769,11772,11796,11921,12248,12249,12272,12302,12405,12436,12542,12553,12632,12638,12689,12690,12736,12812,12935,13146,13166,13209,13348,13376,13385,13414,13656,13670,13689,13702,13731,13738,13760,13769,13789,13794,13809,13946,13961,13996,14141,14276,14345,14351,14396,14420,14511,14512,14513,14515,14532,14601,14616,14662,14663,14686,14730,14739,14820,14824,14825,14835,14939,14999,15006,15041,15069,15076,15081,15148,15160,15178,15193,15209,15268,15326,15347,15388,15423,15457,15465,15482,15487,15551,15570,15611,15617,15636,15637,15640,15661,15696,15738,15759,15766,15767,15783,15866,15872,15894,15913,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16207,16225,16248,16256,16292,16314,16315,16400,16403,16484,16490,16523,16552,16563,16577,16675,16726,16739,16759,16791,16828,16890,16991,17053,17074,17102,17115,17145,17160,17216,17233,17288,17394,17468,17556,17633,17650,17657,17700,17844,17850,17855,17859,17893,17926,17966,18054,18062,18083,18122,18157,18180,18216,18233,18243,18255,18274,18292,18314,18344,18362,18453,18460,18539,18544,18564,18576,18608,18709,18748,18793,18800,18846,18862,18870,18878,18916,18931,18954,18975,18980,18997,19028,19034,19042,19105,19124,19128,19135,19155,19218,19240,19247,19313,19366,19437,19530,19550,19561,19591,19604,19637,19652,19713,19732,19852,19872,19891,19945,20018,20030,20127,20189,20250,20260,20264,20327,20348,20376,20383,20393,20429,20444,20461,20602,20649,20660,20678,20692,20741,20779,20797,20813,20828,20850,20906,20915,20947,20959,21000,21049,21057,21062,21107,21108,21143,21161,21190,21249,21305,21325,21350,21369,21381,21397,21434,21435,21458,21464,21478,21489,21552,21554,21578,21590,21640,21641,21665,21710,21740,21744,21764,21776,21777,21788,21792,21855,21858,21883,21894,21944,21976,21982,22010,22040,22062,22063,22137,22160,22176,22210,22214,22237,22243,22281,22298,22313,22348,22359,22395,22407,22454,22459,22461,22617,22647,22649,22733,22739,22751,22763,22819,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,23665,23678,23679,23680,23693,23716,23849,23869,23890,23942,23955,24075,24100,24102,24104,24152,24170,24191,24273,24274,24327,24366,24371,24392,24397,24475,24503,24592,24644,24668,24716,24727,24733,24767,24780,24816,24837,24839,24844,24872,24899,24964,25072,25098,25107,25125,25133,25225,25253,25310,25343,25377,25380,25442,25529,25560,25644,25645,25664,25714,25730,25785,25807,25813,25850,25993,26025,26178,26183,26230,26250,26256,26273,26356,26367,26493,26501,26504,26521,26563,26648,26901,26926,26972,27002,27011,27150,27170,27210,27245,27246,27273,27321,27418,27431,27438,27441,27496,27521,27545,27557,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28411,28639,28653,28658,28979,28989,29008,29009,29019,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29781,29905,29922,29923,29935,29936,30285,30288,30306,30307,30325,30345,30372,30375,30395,30396,30412,30432,30447,30450,30451,30465,30466,30468,30469,30474,30481,30497,30549,30602,30605,30606,30622,30624,30625,30631,30647,30654,30710,30724,30734,30774,30775,30786,30787,30800,30801,30818,30819,30830,30831,30837,30849,30852,30853,30856,30865,30930,30939,30949,30956,30957,30963,30981,31024,31107,31109,31167,31517,31561,31640,31684,31773,31798,31866,32182,32374,32768,32842,33416,33437,34932,35574,35617,35632,35689,35691,35741,35760,35768,35780,35791,35792,35846,35883,35885,36093,36106,36139,36143,36146,36159,36265,37577,38807,38831,38854,38866,39273,39275,39481,39597,39603,39642,39681,39857,40025,40027,40038,40083,40097,40170,40200,40708,40759,40785,40809,40907,40937,40984,41059,41255,41301,41325,41375)
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 | 924 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.34 ms |
preparing | 0.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 ms |
end | 0.01 ms |
query end | 0.01 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 |