Tiempo de la consulta: 3.46 ms Después de la última consulta: 0.61 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.308 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-09 03:33:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 03:33:10')
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(76,138,165,192,323,385,406,452,489,494,497,505,507,614,681,733,737,771,795,802,805,808,864,872,889,894,909,910,914,928,942,943,1062,1101,1125,1132,1167,1174,1190,1210,1216,1285,1297,1326,1355,1459,1465,1492,1521,1712,1771,1907,1971,1973,2013,2021,2089,2124,2331,2543,2569,2617,2706,2780,2790,2808,2958,2961,3002,3027,3060,3082,3114,3209,3224,3227,3240,3244,3249,3317,3330,3424,3573,3604,3651,3660,3749,3792,3832,3898,3905,3910,3943,3984,4008,4029,4035,4084,4224,4234,4235,4273,4313,4331,4332,4356,4361,4362,4364,4381,4391,4444,4560,4726,4732,4750,4752,4810,4835,4880,5000,5037,5048,5074,5076,5101,5195,5221,5263,5269,5348,5390,5418,5423,5434,5648,5803,5834,5859,6009,6038,6049,6160,6233,6266,6309,6335,6345,6353,6370,6429,6469,6492,6493,6539,6557,6611,6614,6664,6670,6671,6758,6848,6941,7037,7062,7072,7242,7278,7297,7338,7580,7581,7596,7837,7913,7914,7993,7998,8076,8077,8080,8089,8105,8290,8303,8373,8404,8417,8443,8512,8551,8577,8784,8859,8907,9004,9011,9028,9184,9516,9544,9849,9857,9899,9970,10090,10091,10101,10140,10467,10658,10677,10689,10890,10947,11040,11137,11138,11195,11240,11494,11531,11532,11534,11552,11618,11621,11669,11681,11693,11694,11727,11834,11853,11880,11926,11930,11947,12138,12141,12152,12205,12270,12333,12334,12439,12458,12462,12479,12531,12613,12628,12667,12668,12949,12954,12974,13025,13083,13088,13149,13220,13358,13363,13436,13477,13567,13579,13744,13811,13822,13850,13875,13974,13980,14016,14134,14159,14337,14338,14374,14400,14700,14705,14789,14795,14876,14927,14928,14941,14997,15091,15224,15261,15300,15323,15531,15537,15546,15589,15625,15762,15859,15896,15927,15943,15992,16045,16051,16142,16162,16216,16246,16260,16285,16318,16398,16529,16538,16557,16641,16719,16720,16829,16837,16916,16924,16940,16944,16947,16968,16969,16977,17043,17054,17132,17137,17203,17206,17268,17275,17349,17371,17416,17443,17470,17493,17535,17683,17695,17750,17753,17772,17799,17842,17883,18040,18076,18168,18235,18249,18312,18326,18422,18452,18456,18534,18535,18542,18588,18599,18747,18803,18833,18835,18851,18893,18921,18923,18931,18933,18934,18950,18954,18973,18980,19046,19098,19113,19156,19172,19197,19241,19365,19481,19493,19499,19551,19573,19582,19618,19641,19678,19742,19745,19778,19816,19835,19870,19900,19924,19943,19950,20026,20080,20129,20230,20233,20235,20267,20387,20452,20453,20503,20539,20570,20575,20601,20617,20650,20677,20689,20698,20733,20734,20740,20808,20830,20905,20913,21059,21070,21114,21204,21261,21284,21291,21311,21333,21342,21361,21383,21549,21559,21647,21691,21703,21761,21767,21794,21803,21810,21822,21844,21848,21889,21900,21929,21962,21985,21986,22131,22158,22161,22202,22339,22351,22354,22355,22408,22565,22591,22753,22758,22774,22816,22818,22860,22926,23040,23051,23084,23085,23164,23174,23196,23217,23250,23264,23379,23391,23434,23453,23454,23455,23460,23483,23561,23570,23574,23603,23645,23648,23803,23805,23807,23854,23894,23904,23979,24011,24087,24151,24155,24209,24216,24226,24228,24234,24387,24462,24502,24510,24529,24549,24575,24644,24685,24719,24763,24805,24861,25061,25110,25334,25398,25507,25626,25649,25670,25695,25712,25801,25845,25860,25865,25890,25906,25918,25983,26019,26056,26080,26087,26123,26195,26334,26373,26379,26473,26489,26534,26734,26758,27039,27189,27206,27312,27313,27337,27338,27362,27548,27549,27694,27800,28453,28625,28733,28886,28898,29164,29169,29366,29464,29589,30242,31447,31798,32056,32182,32514,32623,32827,33907,34197,34220,34701,34714,34733,34994,35114,35127,35192,35321,35379,35428,35464,35621,35653,35668,35776,35790,35823,35835,35836,35859,35862,35951,35958,36004,36014,36109,36427,37235,37623,37624,38218,38658,38659,38660,38763,38779,38788,38815,38957,39726,39820,39984,39997,40099,40113,40469,40521,40533,40831,40886,41194,42880,43501,44679,44830,44852,44853,44870,45032,45251)
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 | 668 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.26 ms |
preparing | 0.49 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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 |