Temps de requête : 116.19 ms Après la dernière requête : 2.37 ms Mémoire de requête : 0.288 MB mémoire avant requête : 4.692 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 10:32:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 10:32:05')
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(28,41,57,100,129,130,137,143,152,158,199,223,228,240,242,302,345,347,348,349,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,405,406,407,494,497,498,499,543,544,545,546,547,548,549,550,551,552,553,554,555,556,567,635,821,822,942,956,969,972,984,993,996,1000,1005,1020,1021,1036,1040,1041,1042,1051,1073,1089,1103,1104,1109,1110,1111,1129,1130,1133,1163,1178,1180,1182,1218,1226,1247,1248,1251,1252,1253,1263,1264,1265,1273,1276,1290,1292,1293,1296,1304,1311,1312,1327,1329,1330,1336,1338,1340,1346,1350,1354,1411,1412,1436,1437,2228,2244,2245,2265,2269,2270,2287,2304,2311,2316,2317,2319,2321,2324,2326,2334,2343,2344,2348,2353,2359,2373,2375,2393,2407,2413,2427,2440,2441,2442,2445,2446,2453,2464,2468,2475,2477,2559,2561,2649,2653,2657,2661,2662,2663,2664,2677,2678,2688,2695,2697,2716,2722,2725,2730,2736,2739,2746,2751,2752,2763,2786,2803,2804,2810,2814,2815,2826,2838,2844,2847,2848,2850,2863,2872,2895,2896,2903,2904,2905,2906,2907,2908,2909,2910,2923,2932,2949,2965,2974,2985,2986,2996,2999,3010,3022,3026,3044,3067,3068,3080,3103,3104,3109,3113,3114,3115,3116,3117,3118,3119,3121,3122,3123,3124,3125,3126,3127,3128,3131,3132,3136,3142,3143,3170,3174,3186,3198,3202,3212,3214,3222,3230,3231,3234,3238,3241,3251,3260,3313,3314,3324,3325,3326,3327,3334,3337,3354,3379,3396,3397,3401,3425,3431,3436,3467,3472,3476,3512,3520,3521,3551,3611,3612,3613,3614,3634,3652,3659,3665,3684,3709,3726,3737,3767,3768,3801,3811,3837,3838,3839,3840,3843,3844,3849,3850,3851,3865,3874,3887,3889,3905,3907,3912,3917,3931,3932,3936,3944,3946,3950,3957,3965,3966,3967,3975,3976,3978,3985,3986,3988,3991,3997,3998,4030,4032,4039,4053,4056,4057,4065,4070,4073,4074,4102,4103,4107,4109,4119,4137,4153,4154,4159,4160,4161,4168,4184,4193,4200,4203,4205,4214,4217,4218,4219,4246,4248,4266,4297,4300,4305,4322,4330,4337,4342,4344,4352,4363,4389,4390,4392,4442,4454,4456,4459,4470,4472,4478,4505,4506,4532,4560,4561,4562,4564,4573,4581,4583,4584,4585,4595,4596,4624,4626,4631,4637,4648,4657,4674,4677,4686,4693,4694,4710,4711,4750,4760,4767,4772,4773,4778,4780,4781,4782,4787,4794,4800,4807,4808,4810,4820,4828,4845,4854,4858,4874,4881,4882,4888,4889,4896,4897,4925,4926,4942,4943,4944,4952,4955,4958,4959,4970,4977,4980,4986,4987,4988,4989,5002,5003,5006,5011,5012,5029,5032,5034,5035,5040,5044,5046,5051,5052,5054,5056,5057,5058,5076,5077,5078,5079,5080,5081,5082,5083,5084,5085,5089,5094,5095,5100,5102,5103,5111,5112,5120,5149,5150,5152,5156,5164,5172,5173,5174,5191,5192,5196,5200,5201,5202,5209,5216,5218,5224,5225,5227,5232,5233,5234,5235,5236,5270,5281,5286,5287,5288,5300,5301,5302,5305,5313,5315,5316,5317,5319,5327,5330,5352,5353,5375,5376,5387,5392,5393,5394,5396,5411,5432,5446,5458,5472,5498,5499,5503,5504,5507,5515,5522,5533,5557,5567,5573,5583,5592,5601,5612,5618,5619,5625,5635,5638,5653,5658,5659,5663,5664,5669,5671,5673,5680,5681,5682,5691,5692,5707,5712,5716,5717,5718,5734,5735,5739,5746,5751,5753,5762,5766,5773,5777,5779,5780,5781,5782,5786,5790,5792,5793,5794,5795,5796,5799,5803,5804,5808,5811,5849,5850,5851,5852,5854,5856,5858,5859,5860,5863,5864,5866,5879,5884,5886,5888,5892,5896,5905,5910,5912,5913,5914,5932,5956,5965,5966,5967,5973,5977,5984,5987,5988,5989,5993,5996,5997,6006,6010,6012,6013,6019,6020,6021,6026,6027,6028,6032,6034,6040,6046,6052,6059,6063,6068,6069,6070,6076,6091,6092,6093,6094,6095,6096,6098,6100,6101,6102,6103,6106,6112,6120,6123,6124,6126,6127,6128,6129,6130,6132,6133,6135,6137,6139,6140,6141,6142,6147,6149,6150,6154,6155,6163,6166,6167,6168,6171,6172,6173,6174,6175,6176,6185,6191,6207,6209,6210,6211,6212,6215,6216,6217,6224,6225,6226,6227,6228,6234,6270,6275,6276,6278,6279,6281,6295,6301,6304,6305,6316,6319,6325,6334,6338,6343,6347,6357,6359,6361,6363,6365,6370,6371,6372,6374,6375,6376,6379,6390,6406,6412,6413,6414,6422,6426,6435,6438,6439,6441,6449,6460,6466,6476,6480,6492,6494,6497,6498,6499,6500,6501,6502,6503,6505,6506,6511,6513,6520,6522,6524,6528,6530,6531,6532,6535,6543,6549,6550,6554,6564,6566,6571,6573,6581,6590,6591,6592,6606,6608,6609,6610,6611,6613,6638,6641,6642,6643,6644,6647,6652,6658,6673,6681,6687,6690,6693,6695,6699,6701,6709,6710,6715,6717,6731,6753,6756,6761,6763,6764,6765,6776,6777,6778,6780,6781,6784,6786,6787,6792,6793,6794,6801,6802,6803,6808,6809,6811,6819,6832,6839,6840,6850,6851,6852,6855,6860,6865,6866,6879,6883,6884,6895,6899,6900,6901,6903,6904,6906,6907,6909,6910,6914,6917,6918,6920,6921,6923,6925,6929,6931,6936,6938,6943,6947,6949,6950,6952,6954,6961,6965,6981,6989,6990,6991,6997,7001,7007,7012,7013,7014,7015,7018,7024,7028,7032,7033,7034,7035,7040,7041,7046,7048,7056,7061,7064,7073,7074,7079,7081,7090,7095,7099,7100,7101,7107,7109,7111,7112,7114,7115,7118,7119,7121,7123,7125,7130,7131,7132,7138,7140,7142,7148,7149,7150,7152,7159,7161,7166,7167,7182,7187,7189,7194,7196,7198,7199,7200,7201,7202,7205,7207,7208,7233,7234,7240,7246,7249,7251,7253,7254,7264,7275,7277,7279,7282,7289,7291,7293,7296,7298,7305,7306,7307,7308,7310,7312,7313,7314,7326,7330,7332,7335,7336,7342,7347,7349,7350,7352,7353,7355,7361,7362,7364,7365,7367,7368,7373,7374,7375,7376,7379,7384,7385,7392,7393,7394,7395,7396,7397,7398,7403,7405,7411,7412,7413,7415,7416,7417,7419,7421,7423,7424,7425,7428,7431,7433,7436,7441,7442,7444,7445,7446,7447,7454,7460,7461,7463,7469,7470,7471,7472,7474,7481,7484,7490,7491,7492,7493,7494,7495,7496,7497,7499,7500,7501,7507,7508,7509,7510,7511,7512,7513,7515,7516,7517,7519,7521,7522,7523,7525,7527,7528,7534,7536,7551,7558,7566,7572,7576,7578,7581,7585,7587,7588,7592,7593,7595,7601,7603,7607,7608,7609,7610,7611,7613,7614,7615,7624,7625,7626,7630,7634,7635,7637,7642,7643,7644,7649,7650,7651,7652,7653,7654,7655,7656,7660,7664,7665,7669,7672,7678,7681,7682,7688,7692,7695,7696,7698,7701,7706,7708,7709,7710,7713,7714,7721,7722,7723,7724,7726,7732,7737,7738,7739,7744,7745,7749,7753,7754,7755,7756,7758,7761,7763,7766,7767,7768,7769,7770,7771,7772,7773,7775,7776,7777,7780,7781,7782,7783,7784,7787,7788,7789,7790,7798,7800,7804,7805,7806,7807,7808,7812,7813,7816,7817,7818,7819,7820,7834,7837,7840,7841,7842,7843,7848,7849,7851,7856,7861,7862,7863,7866,7869,7870,7872,7885,7890,7895,7899,7901,7906,7908,7911,7915,7916,7917,7918,7919,7922,7929,7930,7931,7934,7936,7941,7942,7951,7961,7963,7967,7969,7971,7974,7975,8010,8018,8021,8022,8026,8027,8031,8038,8043,8055,8057,8060,8066,8076,8077,8079,8083,8086,8089,8091,8094,8095,8096,8097,8098,8100,8103,8104,8105,8106,8110,8111,8117,8129,8146,8151,8155,8158,8159,8160,8167,8172,8193,8212,8215,8218,8219,8232,8245,8254,8256,8263,8277,8280,8287,8292,8298,8300,8310,8314,8327,8328,8331,8332,8335,8339,8344,8353,8358,8360,8363,8366,8367,8369,8373,8378,8382,8384,8387,8389,8401,8402,8404,8405,8413,8415,8419,8422,8431,8436,8452,8457,8464,8468,8472,8473,8474,8475,8481,8483,8485,8495,8501,8511,8518,8525,8526,8529,8536,8537,8538,8539,8544,8551,8554,8561,8572,8573,8575,8577,8579,8580,8586,8587,8591,8597,8602,8609,8616,8625,8626,8628,8630,8634,8636,8638,8641,8644,8645,8646,8655,8660,8665,8666,8668,8671,8674,8680,8682,8685,8686,8689,8690,8692,8694,8695,8696,8704,8705,8709,8711,8712,8715,8723,8727,8728,8730,8736,8737,8740,8741,8742,8743,8744,8753,8754,8755,8756,8760,8761,8765,8771,8773,8780,8784,8785,8798,8799,8802,8809,8839,8840,8841,8842,8844,8845,8846,8847,8849,8853,8854,8856,8864,8865,8866,8868,8872,8879,8881,8883,8886,8890,8893,8894,8899,8903,8904,8911,8914,8917,8918,8919,8920,8921,8925,8926,8928,8935,8937,8939,8941,8942,8971,8974,8976,8977,8981,9006,9008,9018,9019,9020,9023,9029,9031,9045,9046,9048,9059,9061,9066,9068,9069,9070,9071,9072,9073,9074,9075,9076,9079,9081,9082,9085,9087,9090,9092,9096,9097,9100,9108,9111,9118,9121,9130,9134,9138,9141,9147,9150,9166,9173,9176,9181,9184,9187,9190,9191,9192,9203,9207,9211,9212,9213,9221,9222,9540,9541,9543,9551,9554,9562,9565,9568,9581,9583,9596,9600,9610,9612,9626,9634,9635,9636,9639,9643,9644,9645,9646,9656,9658,9660,9682,9685,9690,9691,9700,9701,9709,9719,9724,9736,9738,9746,9748,9754,9758,9762,9763,9766,9767,9774,9775,9786,9789,9797,9798,9804,9805,9806,9807,9809,9810,9819,9821,9826,9838,9842,9843,9844,9846,9849,9851,9859,9862,9868,9873,9880,9881,9882,9884,9892,9893,9897,9898,9901,9904,9911,9914,9917,9924,9927,9928,9929,9935,9936,9940,9947,9958,9959,9960,9968,9969,9973,9977,9980,9988,9989,9993,9995,9997,9998,10038,10041,10042,10043,10045,10046,10047,10048,10054,10055,10057,10058,10061,10064,10066,10067,10068,10070,10072,10073,10075,10103,10105,10107,10113,10132,10138,10145,10146,10153,10162,10163,10173,10175,10180,10182,10183,10187,10190,10196,10219,10225,10233,10250,10251,10269,10274)
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 | 1.32 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.60 ms |
| Optimizing | 0.68 ms |
| Statistics | 0.30 ms |
| Preparing | 0.09 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.90 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 103.33 ms |
| Creating sort index | 3.13 ms |
| Removing tmp table | 5.11 ms |
| Creating sort index | 0.03 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.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.17 ms |
| Updating status | 0.03 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 |
