Tiempo de la consulta: 3.81 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.485 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-06 01:31:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 01:31:50')
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(113,138,141,267,280,318,364,385,406,452,489,494,497,614,661,663,679,681,691,708,737,771,775,802,812,858,864,872,889,892,894,909,910,922,928,943,966,1018,1040,1047,1062,1084,1105,1132,1174,1185,1190,1210,1297,1302,1355,1369,1465,1554,1563,1573,1612,1665,1712,1743,1750,1753,1873,1907,1932,1949,1964,1971,1973,1999,2020,2043,2124,2128,2331,2422,2579,2617,2633,2706,2735,2790,2830,2875,2927,2997,3005,3027,3060,3082,3085,3112,3151,3155,3224,3240,3244,3265,3271,3289,3317,3330,3393,3424,3430,3444,3573,3576,3589,3711,3781,3792,3832,3855,3905,3943,3969,4008,4029,4035,4076,4082,4084,4165,4173,4182,4212,4224,4234,4235,4273,4305,4313,4331,4332,4361,4362,4364,4391,4405,4433,4434,4444,4560,4582,4644,4732,4752,4835,4854,4855,4880,4911,4933,5000,5037,5065,5074,5101,5195,5230,5263,5269,5328,5363,5367,5390,5423,5439,5593,5648,5803,5834,5859,5872,5924,5946,5949,6009,6094,6160,6233,6269,6343,6429,6451,6496,6635,6742,6758,6780,6848,6923,6941,6960,7037,7092,7095,7242,7260,7278,7297,7325,7419,7423,7424,7435,7520,7556,7580,7581,7644,7751,7771,7797,7978,7988,7994,8077,8101,8105,8148,8220,8224,8261,8303,8306,8352,8417,8425,8443,8512,8569,8573,8611,8661,8766,8779,8930,8963,8999,9004,9011,9030,9038,9104,9111,9184,9199,9238,9262,9263,9398,9426,9443,9444,9516,9537,9689,9699,9715,9755,9899,9970,10068,10140,10279,10315,10364,10402,10467,10481,10495,10564,10677,10701,10751,10886,10999,11038,11040,11041,11137,11151,11159,11179,11240,11279,11281,11294,11398,11432,11552,11669,11681,11701,11736,11782,11853,11859,11880,11914,11961,12158,12221,12267,12348,12357,12439,12458,12574,12615,12640,12668,12747,12918,12949,12967,12974,13079,13083,13086,13164,13265,13335,13358,13366,13436,13449,13454,13579,13670,13822,13823,13875,13907,13926,13970,14117,14134,14159,14190,14192,14232,14277,14278,14337,14338,14411,14417,14484,14544,14682,14688,14700,14723,14747,14852,14927,14928,14941,14997,15005,15047,15091,15112,15126,15195,15218,15261,15465,15475,15537,15566,15706,15732,15762,15859,15909,15927,16142,16162,16260,16311,16313,16318,16341,16365,16401,16492,16502,16535,16545,16565,16614,16641,16644,16671,16697,16712,16740,16760,16815,16828,16879,16910,16916,16924,16940,16944,16947,16968,16969,16979,16996,17040,17054,17085,17137,17189,17203,17206,17248,17268,17371,17388,17393,17404,17416,17429,17457,17462,17510,17535,17661,17667,17683,17692,17750,17781,17782,17799,17820,17833,17838,17959,17962,17990,17997,18019,18028,18040,18053,18073,18076,18145,18168,18186,18211,18235,18306,18312,18357,18383,18420,18422,18490,18534,18535,18542,18564,18578,18579,18591,18599,18686,18734,18747,18767,18771,18780,18801,18802,18803,18829,18835,18851,18853,18897,18923,18931,18934,18943,18950,18954,18973,18980,19113,19134,19156,19172,19197,19216,19260,19365,19389,19413,19476,19481,19493,19562,19573,19587,19591,19618,19641,19659,19678,19741,19742,19745,19778,19829,19835,19900,19924,19942,19950,19973,20076,20080,20129,20230,20235,20239,20267,20278,20307,20341,20387,20401,20409,20570,20575,20601,20627,20650,20681,20689,20733,20740,20808,20876,21031,21035,21042,21054,21059,21070,21102,21114,21115,21146,21175,21204,21260,21261,21291,21298,21308,21311,21342,21361,21383,21450,21528,21559,21583,21603,21604,21643,21647,21691,21703,21729,21810,21844,21848,21929,21964,21975,21979,21985,21986,22046,22120,22131,22158,22161,22201,22213,22242,22299,22408,22444,22551,22578,22591,22635,22758,22816,22835,22838,22846,22860,22916,23004,23051,23067,23084,23085,23164,23168,23174,23215,23217,23379,23434,23460,23561,23645,23687,23803,23842,23885,23894,23979,24011,24087,24134,24151,24154,24155,24234,24387,24431,24493,24502,24510,24549,24564,24575,24644,24699,24719,24940,24982,25061,25101,25109,25179,25347,25482,25626,25633,25670,25695,25845,25865,25906,25983,26012,26019,26056,26078,26080,26139,26140,26333,26334,26379,26449,26450,26473,26489,26497,26548,26637,26734,27049,27206,27312,27313,27362,27365,27562,27694,27761,28198,28453,28733,28886,28898,28955,28999,29164,29218,29589,30253,30254,31975,34220,35127,35428,35776,35862,36004,36109,36151,36480,38763,38833,38845,38901,38952,38987,39614,39644,39645,39726,39820,39918,39968,39972,39984,39997,40112,40133,40215,40502,40533,40548,40682,40719,40733,40963,41072,41118,41120,41210,41221,41363,42070,42263,42769,44309,44363)
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 | 757 | 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.36 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.18 ms |
preparing | 0.59 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |