Tiempo de la consulta: 4.49 ms Después de la última consulta: 0.87 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.520 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 04:06:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 04:06:26')
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(79,80,81,82,83,85,86,149,177,188,192,341,434,579,599,677,690,701,841,908,911,931,940,969,971,974,981,986,1051,1052,1091,1162,1207,1277,1280,1326,1342,1343,1352,1408,1464,1467,1473,1488,1679,1694,1730,1731,1756,1769,1776,1829,1944,2046,2098,2150,2170,2235,2241,2250,2284,2285,2376,2427,2543,2607,2623,2650,2665,2695,2763,2801,2802,2941,2958,2967,3023,3025,3112,3114,3163,3186,3269,3270,3282,3297,3321,3341,3346,3373,3410,3415,3426,3439,3448,3454,3471,3475,3487,3510,3521,3582,3636,3637,3663,3707,3784,3831,3839,3903,3984,3986,3996,4001,4002,4066,4154,4173,4191,4203,4233,4257,4283,4386,4390,4406,4533,4605,4699,4912,4991,5076,5085,5140,5261,5262,5273,5300,5327,5332,5346,5353,5391,5393,5479,5480,5501,5565,5662,5676,5766,5783,5846,5894,5896,5921,5962,5992,6004,6158,6179,6275,6425,6448,6473,6496,6513,6539,6564,6568,6779,6823,6859,6878,6919,7078,7091,7092,7111,7167,7216,7245,7258,7287,7316,7354,7399,7491,7509,7568,7593,7600,7621,7699,7710,7731,7748,7906,7908,7930,7966,8010,8014,8020,8027,8035,8051,8131,8138,8149,8152,8167,8188,8214,8231,8282,8319,8444,8458,8483,8511,8546,8584,8621,8630,8659,8660,8663,8688,8732,8737,8744,8808,8871,8923,8939,8970,9144,9161,9165,9283,9313,9364,9378,9386,9409,9443,9518,9554,9568,9605,9606,9629,9756,9801,9846,9902,9995,10017,10039,10109,10124,10131,10142,10166,10275,10374,10391,10397,10610,10689,10780,10791,10816,10866,10892,10914,10961,11073,11120,11162,11180,11632,11677,11685,11696,11699,11806,11934,11940,11997,12187,12221,12331,12359,12391,12459,12494,12499,12515,12534,12596,12624,12628,12652,12696,12742,12790,12837,12933,12934,12945,12996,13021,13064,13093,13161,13169,13213,13232,13260,13290,13479,13535,13576,13622,13740,13747,13759,13781,13825,13898,13909,13910,13962,14135,14335,14350,14360,14372,14496,14531,14534,14570,14604,14607,14622,14644,14645,14691,14727,14777,14805,14833,14870,14886,14929,14950,14964,14991,15007,15070,15074,15089,15128,15131,15134,15158,15166,15189,15219,15220,15240,15268,15277,15306,15325,15340,15344,15401,15515,15519,15531,15533,15541,15590,15594,15610,15611,15626,15636,15713,15751,15771,15772,15821,15895,15904,15945,15959,15978,16025,16066,16105,16115,16136,16174,16217,16221,16229,16301,16314,16317,16325,16351,16516,16651,16652,16708,16713,16850,16872,16874,16908,16976,17224,17245,17253,17300,17340,17365,17378,17407,17453,17468,17510,17640,17668,17695,17714,17718,17803,17820,17843,17992,18071,18179,18246,18309,18330,18358,18399,18468,18477,18483,18556,18559,18601,18616,18643,18665,18675,18688,18744,18770,18787,18845,18878,19213,19288,19332,19333,19416,19437,19561,19594,19659,19674,19695,19733,19814,19893,19935,19997,20003,20031,20058,20060,20103,20157,20360,20500,20503,20531,20559,20576,20620,20664,20676,20680,20701,20732,20806,20812,20825,20833,20837,20883,20926,20975,21056,21094,21140,21285,21337,21349,21369,21386,21393,21441,21445,21530,21590,21627,21681,21704,21796,21809,21825,21834,21962,22006,22015,22038,22049,22055,22061,22069,22075,22097,22117,22122,22288,22373,22384,22387,22421,22482,22494,22749,22751,22827,22829,22871,22938,23107,23115,23155,23297,23335,23416,23453,23454,23506,23523,23573,23591,23727,23814,23940,23963,23978,24061,24283,24305,24343,24364,24413,24433,24514,24528,24633,24648,24763,24799,24803,24807,24846,25010,25073,25131,25226,25251,25310,25351,25379,25413,25446,25462,25463,25464,25465,25466,25467,25469,25470,25471,25472,25473,25474,25475,25476,25478,25479,25480,25481,25482,25483,25484,25486,25487,25489,25490,25491,25492,25493,25494,25495,25496,25497,25498,25499,25500,25502,25503,25506,25509,25512,25515,25518,25524,25528,25532,25540,25541,25545,25546,25551,25554,25555,25559,25565,25602,25675,25828,25865,25874,25894,25923,25937,25991,25995,26010,26147,26209,26232,26273,26360,26403,26471,26474,26526,26533,26573,26604,26687,26702,26832,26840,26947,26956,26985,26991,27024,27055,27058,27076,27137,27181,27190,27319,27332,27360,27408,27931,27981,28349,28423,28664,28741,28757,28809,28836,28902,28912,29038,29054,29105,29356,29365,29374,29391,29630,29724,30282,30864,31356,31896,32342,32642,32643,32644,32831,32914,33065,33215,33416,33417,33750,33954,33955,34016,34047,34146,34180,34189,34196,34251,34376,34377,34391,34483,34502,34683,34832,34935,34959,35010,35094,35175,35185,35205,35277,35310,35314,35392,35557,35581,35658,35773,35847,35876,35902,35910,35930,35982,36031,36066,36159,36227,36437,36531,36688,36714,36736,36828,36888,36957,37024,37137,37344,37357,37365,37479,37521,37543,37544,37553,37579,37642,37669,37693,37710,37731,37740,37767,37787,37802,37844,37852,37876,37932,37953,37999,38060,38185,38329,38346,38361,38370,38409,38430,38506,38512,38520,38567,38588,38594,38623,38734,38764,38781,38809,38836,38837,38851,38861,38888,38956,39019,39023,39070,39114,39160,39185,39212,39346,39415,39416,39439,39491,39544,39582,39615,39627,39631,39649,39670,39736,39757,39767,39838,39849,39858,39932,39934,39993,40003,40024,40072,40073,40094,40195,40302,40306,40345,40379,40431,40494,40505,40508,40605,40638,40665,40699,40714,40802,40897,40904,40917,40970,40996,41023,41046,41051,41075,41078,41096,41142,41181,41190,41227,41245,41251,41259,41273,41284,41297,41303,41313,41350,41370,41373,41391,41440,41468,41515,41517,41660,41722,41726,41738,41739,41768,41811,41822,41851,41875,41931,41959,41972,41973,41981,41983,41997,42002,42010,42029,42113,42124,42136,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,43058,43083,43116,43143,43181,43182,43199,43268,43312,43342,43347,43348,43364,43434,43443,43455,43468,43471,43507,43512,43527,43612,43617,43628,43629,43647,43684,43703,43704,43730,43742,43758,43800,43836,43877,43883,43927,43960,44003,44045,44049,44050,44070,44073,44098,44239,44259,44338,44353,44356,44379,44389,44392,44437,44455,44509,44521,44558,44570,44586,44603,44625,44626,44658,44683,44691,44708,44748,44825,44842,44874,44907,44964,44989,45008,45055,45060,45147,45195,45289,45301,45311)
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 | 1032 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.65 ms |
preparing | 0.76 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.01 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 |