Temps de requête : 78.40 ms Après la dernière requête : 1.44 ms Mémoire de requête : 0.222 MB mémoire avant requête : 4.494 MB Rangées retournées : 10
SELECT i.*, c.alias AS categoryalias
FROM p2tgq_k2_items AS i
LEFT JOIN p2tgq_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 <= '2025-12-10 11:39:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 11:39:19')
AND i.access IN(1,1,5,12,13,16)
AND c.access IN(1,1,5,12,13,16)
AND c.published = 1
AND c.trash = 0
AND i.id IN(14,28,142,143,181,192,193,228,231,242,243,276,299,306,309,315,424,425,426,427,428,430,431,437,444,461,462,463,465,466,478,479,480,493,494,500,501,502,516,519,567,626,642,657,658,660,662,663,668,683,702,749,765,766,854,929,935,972,1000,1009,1021,1051,1089,1130,1132,1133,1182,1200,1203,1210,1211,1218,1260,1261,1273,1276,1292,1293,1297,1318,1340,1400,1406,1407,1413,1414,1415,1416,1436,2214,2220,2221,2225,2245,2265,2269,2270,2275,2287,2304,2311,2321,2324,2326,2328,2329,2359,2370,2371,2373,2378,2395,2398,2400,2402,2447,2477,2480,2523,2536,2653,2712,2713,2724,2730,2750,2763,2787,2793,2795,2847,2848,2889,2925,2927,2967,2974,2985,2988,2992,3000,3001,3006,3035,3058,3078,3095,3168,3170,3171,3186,3193,3198,3214,3220,3222,3223,3238,3248,3251,3265,3266,3304,3306,3313,3334,3368,3396,3399,3401,3436,3472,3476,3500,3512,3519,3634,3652,3709,3718,3737,3775,3801,3806,3810,3811,3829,3833,3834,3837,3838,3840,3843,3844,3849,3850,3851,3855,3856,3874,3884,3887,3889,3907,3912,3917,3932,3944,3946,3965,3966,3967,3968,3976,3978,3985,3986,3988,3997,3998,4015,4025,4030,4039,4056,4057,4065,4070,4074,4092,4102,4103,4107,4119,4154,4159,4160,4161,4168,4169,4193,4200,4203,4205,4214,4215,4236,4241,4248,4266,4302,4306,4321,4342,4349,4392,4407,4408,4413,4414,4418,4434,4454,4456,4459,4468,4490,4506,4520,4538,4555,4558,4560,4561,4562,4564,4573,4583,4595,4596,4610,4624,4629,4631,4637,4643,4648,4649,4659,4661,4662,4663,4677,4684,4688,4694,4710,4711,4760,4772,4773,4780,4782,4793,4794,4796,4799,4800,4810,4820,4822,4832,4834,4855,4856,4873,4897,4943,4952,4971,4980,4985,4986,4992,4996,4997,5014,5033,5035,5040,5044,5054,5058,5076,5077,5078,5079,5080,5081,5082,5083,5084,5085,5095,5168,5169,5201,5202,5206,5209,5213,5232,5233,5234,5235,5236,5252,5270,5286,5287,5288,5300,5305,5313,5319,5330,5352,5360,5375,5377,5392,5396,5411,5412,5432,5456,5489,5491,5503,5504,5507,5509,5515,5522,5533,5553,5567,5573,5583,5594,5612,5635,5645,5663,5671,5673,5680,5681,5682,5691,5692,5717,5718,5723,5727,5739,5746,5751,5753,5762,5773,5786,5790,5791,5792,5793,5794,5795,5811,5849,5850,5852,5854,5858,5859,5863,5864,5866,5879,5884,5886,5892,5905,5910,5912,5932,5943,5960,5966,5967,5973,5977,5984,5987,5988,5989,5996,5997,6006,6012,6013,6021,6026,6028,6034,6040,6046,6052,6063,6070,6091,6092,6093,6094,6096,6100,6103,6106,6112,6128,6137,6139,6141,6142,6149,6155,6163,6171,6172,6173,6174,6175,6181,6185,6191,6193,6215,6218,6222,6225,6226,6227,6228,6229,6233,6268,6269,6270,6271,6272,6275,6276,6278,6279,6280,6281,6295,6296,6301,6305,6311,6316,6343,6363,6370,6371,6372,6374,6375,6387,6390,6413,6428,6435,6438,6439,6441,6460,6476,6480,6494,6497,6498,6499,6500,6501,6502,6503,6505,6506,6511,6513,6521,6522,6524,6529,6530,6531,6532,6535,6543,6563,6564,6565,6566,6568,6571,6573,6581,6583,6590,6592,6644,6647,6652,6701,6710,6712,6717,6731,6736,6738,6750,6753,6756,6761,6765,6775,6776,6781,6785,6786,6787,6792,6797,6800,6803,6805,6809,6812,6819,6821,6826,6836,6841,6846,6855,6860,6865,6866,6879,6884,6894,6899,6900,6901,6904,6906,6914,6925,6936,6939,6947,6954,6981,6997,7012,7018,7024,7028,7032,7040,7041,7046,7048,7064,7074,7079,7090,7095,7099,7107,7109,7115,7123,7125,7131,7138,7140,7152,7159,7184,7189,7193,7196,7198,7199,7202,7205,7246,7249,7264,7266,7279,7280,7293,7305,7306,7307,7312,7313,7330,7332,7347,7349,7350,7361,7364,7367,7368,7379,7384,7385,7392,7393,7396,7397,7398,7403,7405,7411,7412,7413,7415,7417,7419,7421,7425,7431,7433,7436,7441,7444,7454,7461,7463,7469,7470,7471,7472,7474,7484,7490,7491,7492,7493,7494,7495,7496,7497,7499,7500,7503,7507,7510,7511,7512,7513,7515,7516,7517,7519,7522,7523,7528,7536,7558,7576,7578,7585,7592,7593,7601,7603,7607,7608,7609,7610,7611,7613,7614,7615,7626,7630,7633,7637,7642,7649,7650,7651,7652,7653,7654,7655,7656,7657,7665,7669,7696,7698,7701,7706,7710,7713,7714,7723,7726,7732,7737,7749,7753,7754,7756,7758,7761,7763,7766,7767,7769,7770,7771,7772,7773,7776,7777,7780,7781,7782,7784,7787,7788,7789,7790,7806,7807,7808,7812,7813,7816,7820,7837,7842,7843,7851,7861,7862,7863,7866,7869,7870,7872,7882,7885,7899,7906,7908,7911,7913,7915,7917,7918,7926,7930,7936,7941,7942,7967,7969,7971,7974,7975,7976,8021,8022,8023,8031,8035,8037,8038,8043,8062,8066,8077,8079,8083,8084,8090,8091,8094,8097,8100,8103,8104,8128,8133,8146,8151,8155,8159,8160,8167,8172,8184,8187,8215,8218,8224,8228,8232,8256,8277,8287,8290,8300,8310,8314,8327,8328,8331,8332,8335,8339,8344,8353,8366,8367,8378,8382,8383,8384,8402,8422,8431,8457,8464,8469,8472,8473,8475,8481,8495,8507,8520,8536,8537,8538,8551,8554,8559,8577,8586,8602,8605,8616,8630,8636,8638,8645,8671,8674,8680,8692,8694,8709,8712,8740,8741,8745,8773,8780,8781,8784,8809,8846,8849,8855,8856,8862,8864,8872,8894,8904,8911,8917,8922,8925,8926,8930,8941,8942,8976,8981,9008,9011,9012,9018,9019,9031,9045,9048,9057,9066,9068,9070,9072,9079,9081,9082,9092,9093,9100,9111,9118,9121,9147,9150,9166,9211,9212,9221,9540,9541,9543,9565,9574,9576,9581,9596,9606,9610,9634,9660,9689,9691,9700,9709,9738,9746,9754,9766,9767,9775,9786,9792,9797,9798,9804,9805,9806,9807,9819,9821,9826,9842,9843,9844,9846,9849,9851,9859,9873,9880,9897,9901,9904,9911,9929,9932,9943,9959,9962,9968,9969,9970,9973,9977,9980,9987,9988,9989,9995,9998,9999,10041,10042,10043,10045,10046,10047,10054,10057,10058,10061,10066,10067,10068,10070,10085,10103,10153,10180,10222,10224,10232,10288,10291)
ORDER BY i.id DESC
LIMIT 0, 10| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | range | PRIMARY,category,published,access,trash | category | 8 | NULL | 202 | Using index condition; Using temporary; Utilisation du tri complet de type filesort |
| 1 | PRIMARY | i | ref | PRIMARY,item,catid | catid | 4 | j3.c.id | 6 | Using index condition; Using where |
| 1 | PRIMARY | <derived3> | ref | key0 | key0 | 4 | j3.i.id | 10 | FirstMatch(i) |
| 3 | DERIVED | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.58 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.23 ms |
| Optimizing | 0.27 ms |
| Statistics | 0.23 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.34 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 68.61 ms |
| Creating sort index | 2.10 ms |
| Removing tmp table | 5.21 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.13 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:654 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:292 |
| 11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:19 |
| 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:64 |
| 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 |