Tiempo de la consulta: 3.70 ms Después de la última consulta: 0.72 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.313 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-07 19:30:25')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 19:30:25')
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(33,34,35,39,40,41,42,43,70,72,75,126,127,128,263,277,280,458,473,615,676,689,722,832,868,903,941,945,946,988,1073,1080,1201,1207,1220,1257,1277,1324,1329,1340,1697,1753,1805,1976,2112,2263,2279,2428,2535,2705,2750,2773,2794,2827,2843,2857,2872,2893,2980,3080,3125,3234,3255,3302,3329,3442,3716,3732,3733,3782,3880,3883,3980,3986,4028,4063,4093,4182,4217,4260,4268,4302,4405,4722,4765,4868,4872,5085,5182,5207,5208,5302,5406,5472,5576,5647,5658,5698,5718,5827,5833,5877,5879,5889,5967,6084,6141,6278,6279,6319,6487,6515,6517,6594,6616,6628,6632,6658,6780,6791,6935,6969,7045,7077,7105,7136,7150,7270,7329,7365,7429,7447,7536,7554,7627,7675,7743,7777,7835,7858,7895,7919,7954,8015,8052,8083,8231,8306,8394,8406,8414,8759,8765,8909,9111,9114,9207,9351,9398,9444,9454,9480,9584,9604,9741,9853,9928,9981,10068,10075,10086,10138,10192,10217,10222,10402,10439,10452,10479,10485,10519,10696,10758,10810,10827,10842,10863,10924,10926,10971,10982,10987,11032,11038,11045,11100,11101,11140,11171,11179,11189,11261,11268,11293,11328,11398,11399,11421,11542,11675,11717,11723,11764,11794,11838,11859,11912,11945,11951,11990,11992,12004,12034,12092,12176,12186,12206,12321,12340,12516,12554,12657,12665,12773,12794,12804,12852,12902,12912,12964,13043,13055,13082,13162,13218,13242,13243,13306,13329,13371,13410,13460,13495,13529,13603,13698,13709,13710,13733,13758,13765,13772,13826,13838,13911,13925,13926,13970,13982,14037,14076,14083,14096,14115,14147,14148,14154,14200,14202,14255,14270,14291,14385,14470,14489,14521,14523,14555,14556,14609,14639,14766,14811,14839,14851,14855,14959,14975,15002,15009,15051,15115,15122,15154,15257,15269,15272,15286,15301,15326,15354,15373,15418,15479,15488,15495,15498,15499,15632,15633,15643,15732,15787,15842,15864,15893,15900,15913,15926,15979,15980,16060,16128,16145,16168,16199,16208,16235,16267,16283,16327,16341,16356,16359,16366,16373,16394,16405,16460,16468,16533,16535,16565,16624,16659,16686,16714,16749,16784,16831,16887,16922,16925,16955,16965,16996,17042,17115,17125,17183,17229,17271,17276,17318,17327,17359,17411,17423,17434,17438,17457,17459,17494,17519,17532,17541,17554,17568,17570,17596,17614,17707,17730,17781,17815,17832,17865,17873,17897,17935,17953,17960,17972,17993,18048,18056,18069,18073,18145,18153,18221,18244,18281,18296,18352,18395,18408,18449,18492,18518,18527,18539,18563,18570,18576,18581,18592,18594,18607,18617,18627,18640,18648,18674,18680,18690,18697,18722,18737,18746,18765,18790,18812,18823,18825,18889,18896,18900,18915,18921,18938,18952,18960,18971,18998,19011,19026,19029,19050,19057,19089,19109,19139,19195,19202,19256,19292,19346,19370,19374,19401,19411,19469,19490,19510,19537,19542,19560,19586,19590,19605,19610,19621,19623,19648,19662,19682,19713,19770,19810,19883,19917,19930,19944,19951,19971,19995,20009,20075,20164,20172,20179,20195,20313,20347,20365,20378,20398,20407,20462,20496,20510,20512,20536,20589,20662,20685,20701,20795,20816,20818,20840,20870,20876,20914,20919,20939,20951,20958,20962,21019,21054,21067,21072,21101,21106,21120,21141,21146,21163,21164,21171,21179,21219,21238,21239,21274,21277,21311,21348,21373,21379,21407,21411,21446,21450,21455,21467,21490,21552,21562,21563,21568,21583,21592,21612,21638,21651,21654,21675,21697,21713,21737,21775,21789,21886,21923,21931,21948,21981,22001,22025,22029,22073,22113,22128,22147,22181,22211,22272,22286,22294,22307,22319,22325,22338,22352,22360,22387,22487,22504,22558,22594,22664,22675,22687,22700,22733,22770,22778,22783,22849,22861,22863,22905,22956,23028,23030,23042,23044,23045,23066,23067,23075,23079,23090,23109,23128,23152,23163,23165,23244,23255,23278,23284,23303,23323,23330,23341,23362,23366,23375,23386,23418,23443,23487,23534,23545,23635,23660,23696,23735,23819,23822,23856,23913,23950,23987,23994,24006,24059,24084,24142,24235,24266,24276,24293,24325,24347,24353,24381,24452,24475,24495,24498,24638,24674,24698,24717,24760,24767,24769,24770,24812,24828,24858,24877,24902,24947,24987,24999,25011,25012,25024,25041,25056,25162,25208,25248,25263,25280,25301,25313,25347,25442,25696,25725,25732,25763,25799,25882,25932,26078,26336,26423,26765,26861,26928,27014,27152,27236,27264,27279,27283,27289,27319,27362,27394,27517,27694,27954,28020,28104,28607,28640,28677,28692,28765,28922,29289,29387,29486,29647,29719,29832,31377,35059,35726,36189,36446,36549,36834,36919,37987,38036,38182,38866,38903,38927,38953,38992,39035,39048,39111,39195,39335,39410,39480,39505,39537,39572,39608,39645,39650,39666,39891,39907,40304,40441,40511,40558,40942,41092,41219,41856,42073,42961,43656)
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 | 788 | 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.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.31 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.02 ms |
query end | 0.02 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 |