Tiempo de la consulta: 4.03 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.326 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-05 05:16:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 05:16:46')
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,14,34,35,70,72,95,126,127,280,344,615,799,808,832,886,941,945,946,969,1034,1073,1102,1220,1230,1257,1313,1324,1361,1364,1456,1501,1607,1753,1756,1757,1805,1825,1829,1922,2018,2041,2042,2285,2289,2353,2428,2604,2608,2611,2671,2695,2705,2762,2773,2794,2797,2872,2893,2980,3123,3125,3234,3393,3716,3733,3737,3829,3883,3931,3932,3961,4028,4063,4093,4118,4182,4217,4260,4268,4302,4405,4488,4722,4771,4794,4868,4876,5138,5182,5207,5302,5348,5439,5576,5617,5658,5698,5708,5718,5749,5879,5889,5967,5968,6076,6084,6141,6278,6279,6396,6454,6468,6497,6568,6614,6658,6665,6751,6780,6820,6837,6939,6960,7018,7139,7266,7329,7358,7365,7536,7554,7594,7627,7648,7743,7858,7860,7919,7934,7964,7992,8015,8061,8083,8147,8173,8187,8190,8306,8406,8587,8765,8776,8849,8858,8894,8901,8983,9015,9016,9073,9077,9079,9086,9111,9114,9207,9223,9398,9422,9444,9454,9480,9653,9654,9662,9727,9741,9752,9776,9820,9853,9928,9942,9963,9969,9981,10011,10019,10068,10071,10075,10078,10138,10156,10217,10222,10340,10402,10416,10471,10479,10519,10541,10673,10696,10709,10758,10796,10827,10842,10863,10924,10982,11032,11140,11147,11179,11207,11247,11261,11268,11398,11421,11462,11542,11549,11626,11693,11694,11717,11723,11788,11794,11815,11838,11854,11859,11990,12004,12034,12135,12206,12242,12341,12500,12505,12550,12554,12672,12677,12718,12750,12752,12773,12818,12839,12852,12895,12902,12945,12964,13202,13218,13220,13247,13264,13269,13358,13616,13698,13710,13759,13765,13838,13896,13925,13926,13970,14037,14048,14083,14101,14115,14125,14154,14202,14255,14320,14364,14385,14425,14609,14733,14759,14766,14811,14839,14851,14873,14927,14959,15002,15051,15074,15115,15122,15257,15272,15282,15286,15312,15346,15354,15488,15499,15613,15633,15643,15732,15804,15806,15848,15864,15980,16120,16220,16224,16235,16356,16359,16394,16455,16481,16533,16535,16545,16565,16578,16630,16636,16674,16686,16693,16704,16714,16742,16772,16784,16800,16880,16887,16904,16913,16925,16955,16969,16976,17026,17055,17092,17115,17117,17137,17167,17169,17198,17199,17250,17271,17301,17327,17353,17359,17372,17374,17377,17411,17423,17427,17434,17438,17459,17519,17527,17614,17730,17746,17767,17770,17781,17798,17832,17873,17897,17942,17953,17978,18068,18073,18145,18153,18221,18265,18283,18326,18327,18379,18384,18395,18427,18442,18447,18476,18492,18527,18547,18548,18563,18570,18576,18581,18593,18594,18607,18617,18627,18638,18648,18690,18691,18697,18737,18765,18790,18812,18889,18893,18900,18915,18921,18927,18934,18952,18960,18998,19011,19026,19050,19057,19078,19089,19158,19202,19256,19260,19266,19292,19374,19401,19411,19447,19469,19545,19547,19549,19590,19596,19605,19610,19623,19648,19682,19694,19713,19718,19770,19800,19804,19810,19918,19931,19944,20009,20164,20179,20207,20396,20426,20510,20589,20624,20693,20694,20701,20704,20816,20818,20836,20861,20883,20919,20951,20962,20997,21019,21020,21027,21031,21033,21067,21072,21101,21106,21146,21154,21163,21164,21171,21175,21179,21203,21206,21219,21233,21236,21238,21239,21268,21274,21283,21311,21319,21354,21356,21358,21361,21362,21379,21411,21413,21446,21450,21455,21467,21488,21490,21536,21553,21562,21564,21583,21593,21647,21651,21654,21675,21697,21713,21769,21775,21787,21789,21805,21820,21821,21828,21832,21837,21875,21886,21940,21942,21981,22001,22029,22037,22131,22147,22181,22200,22211,22244,22245,22246,22260,22272,22286,22294,22338,22377,22401,22426,22550,22585,22664,22677,22687,22733,22783,22854,22863,22905,22912,22938,22939,22954,22968,22991,23028,23042,23044,23066,23067,23075,23109,23128,23152,23163,23173,23278,23334,23350,23362,23696,23735,23822,23860,23906,23930,23987,24043,24059,24163,24185,24235,24236,24266,24353,24381,24406,24407,24408,24452,24497,24502,24623,24628,24674,24999,25024,25030,25041,25130,25347,25535,25622,25625,25725,25732,25750,25772,25818,25912,25932,26003,26014,26031,26078,26108,26136,26167,26198,26281,26362,26378,26399,26403,26408,26410,26447,26454,26530,26616,26626,26630,26741,26785,26803,26804,26839,26866,26948,26950,26955,27055,27107,27109,27118,27120,27124,27133,27152,27161,27236,27264,27275,27279,27287,27302,27319,27322,27445,27450,27457,27465,27491,27548,27550,27954,28104,28899,28922,29117,29118,29289,29387,29478,29485,29486,29488,29491,29647,29686,29719,29823,29832,30255,30285,30810,31019,32322,33018,33039,33300,33440,33504,33505,33506,33507,33508,33509,33510,33511,34093,34185,34186,34884,35059,35087,35165,35175,35176,35178,35217,35394,35457,35595,35600,35731,36057,36058,36059,36150,36185,36193,36195,36196,36283,36299,36322,36472,36549,36834,37029,37035,37036,37744,37824,38312,38397,38518,38550,38551,38607,38811,38866,38873,38903,38927,38934,38946,38953,38992,38999,39033,39035,39048,39102,39111,39195,39302,39335,39410,39413,39431,39445,39460,39480,39493,39494,39505,39572,39645,39650,39666,39891,39907,39979,40162,40304,40441,40545,40558,40580,40847,40942,41041,41092,41199,41219,41298,42073,42125,42264,42322,42468,42629,42643,42665,42673,42692,42719,42723,42724,42835,42850,42870,42891,42898,42910,42961,42967,42968,42969,42970,42986,42989,43010,43047,43048,43049,43067,43074,43110,43308,43645,43656,43761,44136,44641,44722,44852)
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 | 884 | 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.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.37 ms |
preparing | 0.72 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |