Tiempo de la consulta: 3.91 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.321 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 23:50:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 23:50:38')
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,11,14,35,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,87,88,89,95,110,111,125,188,189,190,200,205,234,246,248,249,263,271,291,325,331,344,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,495,496,501,503,509,523,531,574,575,593,672,681,686,785,799,805,808,853,862,868,986,1175,1207,1223,1324,1326,1350,1353,1357,1361,1364,1434,1436,1456,1486,1501,1537,1544,1593,1607,1718,1756,1757,1825,1878,1922,1931,2041,2042,2108,2208,2241,2265,2272,2285,2294,2353,2463,2601,2604,2608,2611,2695,2797,2825,2884,2893,3005,3020,3051,3070,3114,3123,3212,3242,3325,3393,3531,3650,3682,3737,3829,3831,3931,3932,4310,4488,4653,4674,4870,4902,4905,5060,5189,5279,5324,5348,5362,5392,5439,5476,5538,5610,5617,5685,5749,5792,5796,5798,5825,5895,5968,6076,6221,6256,6292,6311,6392,6454,6482,6558,6568,6616,6666,6671,6776,6836,6868,7017,7050,7056,7109,7124,7138,7139,7204,7210,7287,7292,7325,7380,7387,7401,7404,7431,7450,7453,7455,7488,7565,7594,7692,7716,7730,7782,7811,7847,7860,7933,7934,7970,7992,7993,8015,8027,8061,8147,8173,8190,8215,8366,8444,8480,8527,8532,8565,8587,8589,8602,8610,8638,8776,8835,8856,8887,8892,8894,8983,9055,9079,9206,9233,9262,9282,9411,9422,9428,9472,9488,9650,9670,9677,9678,9727,9820,9858,9909,9924,9942,9963,10019,10034,10035,10071,10078,10274,10305,10340,10416,10418,10434,10471,10620,10629,10673,10946,11247,11345,11477,11486,11612,11626,11706,11720,11809,11854,11928,12010,12020,12324,12415,12460,12525,12532,12592,12620,12650,12670,12677,12685,12686,12708,12718,12752,12783,12809,12851,12895,12903,12913,12915,12939,12942,12945,12973,12996,13014,13016,13152,13269,13273,13294,13309,13348,13373,13474,13475,13672,13759,13770,13819,13834,13891,13900,13901,13902,13915,13935,13971,13973,14048,14084,14101,14103,14152,14172,14229,14243,14293,14334,14336,14354,14362,14363,14401,14437,14478,14534,14536,14554,14630,14846,14860,14990,15038,15043,15065,15115,15213,15245,15261,15293,15346,15382,15414,15475,15476,15520,15533,15574,15605,15796,15861,15899,15945,15972,16014,16050,16055,16062,16071,16087,16089,16115,16161,16176,16208,16474,16497,16526,16543,16566,16579,16652,16715,16751,16794,16833,16863,16891,16908,16921,16950,16964,17043,17059,17114,17115,17156,17169,17205,17263,17270,17309,17334,17335,17374,17375,17419,17496,17528,17541,17607,17629,17702,17721,17824,17857,17960,18071,18073,18079,18220,18227,18260,18300,18309,18333,18360,18379,18427,18447,18455,18494,18558,18563,18578,18593,18594,18619,18653,18668,18691,18749,18756,18757,18789,18819,18876,18877,18891,18903,18905,18951,18985,19000,19027,19078,19220,19260,19282,19381,19411,19428,19447,19460,19545,19551,19645,19646,19650,19661,19668,19695,19702,19718,19733,19772,19825,19886,19923,19929,19931,19937,19944,19980,20060,20095,20192,20193,20207,20213,20218,20291,20308,20426,20439,20459,20567,20595,20616,20648,20656,20660,20699,20700,20704,20727,20820,20847,20948,21005,21016,21020,21038,21065,21101,21159,21256,21279,21283,21285,21288,21297,21300,21319,21338,21368,21464,21485,21486,21524,21526,21529,21592,21618,21623,21650,21661,21664,21690,21695,21698,21704,21719,21727,21800,21824,21843,21850,21910,21954,21955,22015,22018,22062,22077,22117,22157,22163,22164,22195,22241,22302,22324,22374,22406,22421,22446,22453,22512,22580,22603,22620,22622,22626,22655,22658,22705,22710,22727,22765,22780,22787,22804,22829,22833,22897,22923,22947,22965,22972,22985,23007,23024,23043,23062,23082,23089,23124,23179,23214,23423,23429,23470,23480,23528,23665,23716,23927,23930,23936,24016,24032,24226,24236,24249,24279,24393,24408,24418,24443,24475,24497,24522,24557,24582,24586,24617,24752,24803,24937,24956,24993,25030,25035,25062,25131,25138,25171,25318,25351,25406,25436,25448,25542,25584,25646,25660,25888,25904,26000,26033,26078,26147,26221,26317,26343,26360,26415,26424,26454,26474,26530,26628,26651,26677,26713,26742,26801,26820,26845,26881,26905,26907,26944,26973,27000,27038,27301,27366,27447,27530,27688,27722,27846,28072,28080,28339,28440,28442,28614,28615,28616,28712,28728,28845,28944,29054,29460,29635,33417,35330,35713,35731,35744,35955,36147,36208,36223,38593,39398,39505,39530,40036,40492,40558,40605,44136,44167,45008)
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 | 749 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.19 ms |
preparing | 0.57 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 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 |