Temps de requête : 83.60 ms Après la dernière requête : 3.58 ms Mémoire de requête : 0.194 MB mémoire avant requête : 4.619 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 12:35:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 12:35:16')
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(13,15,26,28,32,33,34,41,93,102,129,134,137,139,142,181,192,193,200,225,227,228,231,232,233,234,237,240,243,244,245,246,247,250,254,257,258,260,261,265,267,268,276,278,281,282,285,286,289,290,291,293,294,295,296,297,298,299,305,306,307,309,312,313,314,318,323,324,325,326,327,330,349,350,351,352,353,354,357,358,359,360,361,363,366,368,370,371,374,375,376,377,378,379,380,382,383,384,385,386,387,388,390,391,392,393,394,395,396,397,398,400,404,408,414,416,417,418,419,420,423,424,425,426,427,429,430,431,433,437,441,442,443,444,445,446,447,448,449,450,451,452,458,459,460,461,462,463,464,465,466,467,471,477,478,479,480,483,484,485,486,487,488,489,490,491,492,493,497,498,500,501,502,503,504,505,506,507,508,509,510,511,512,513,516,517,518,519,522,527,541,543,544,545,546,547,548,549,550,551,552,553,554,555,557,558,560,562,565,567,568,574,575,576,577,578,579,580,581,582,583,584,587,590,591,592,593,594,600,601,602,603,604,605,606,608,610,615,618,619,623,624,626,627,628,629,630,631,632,633,634,642,647,648,654,655,656,657,658,659,660,661,662,663,664,669,683,684,691,693,694,695,696,697,698,699,700,701,703,710,711,717,718,719,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,750,751,754,755,756,757,758,765,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,808,809,810,811,812,813,814,816,817,818,819,821,822,824,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,849,850,854,855,856,857,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,903,905,912,913,914,915,918,919,920,921,922,923,924,925,926,927,929,930,931,932,935,942,950,962,965,966,970,972,974,979,986,988,996,999,1000,1002,1008,1009,1016,1019,1021,1024,1026,1029,1033,1037,1041,1052,1058,1066,1067,1068,1070,1071,1072,1074,1078,1079,1080,1084,1093,1094,1102,1103,1105,1106,1112,1116,1118,1121,1130,1140,1141,1142,1150,1151,1159,1160,1162,1166,1172,1177,1182,1214,1215,1216,1217,1218,1222,1223,1227,1228,1229,1232,1235,1239,1242,1243,1246,1247,1248,1251,1252,1253,1254,1260,1261,1266,1267,1268,1270,1271,1272,1273,1284,1290,1292,1293,1299,1303,1307,1308,1309,1311,1312,1313,1314,1315,1316,1321,1322,1326,1333,1338,1340,1344,1345,1348,1349,1354,1358,1363,1364,1365,1371,1372,1373,1382,1387,1389,1400,1406,1407,1408,1409,1410,1411,1413,1414,1431,1432,1436,1437,2073,2152,2156,2205,2210,2219,2220,2221,2225,2234,2245,2250,2252,2254,2267,2268,2269,2270,2271,2272,2274,2282,2283,2284,2286,2288,2289,2297,2306,2307,2309,2311,2319,2320,2321,2326,2327,2335,2337,2339,2347,2359,2370,2373,2374,2375,2378,2393,2400,2401,2402,2408,2409,2411,2412,2416,2418,2422,2423,2424,2426,2429,2433,2434,2436,2437,2445,2447,2448,2451,2455,2466,2475,2480,2481,2505,2506,2507,2508,2553,2554,2555,2556,2559,2560,2564,2567,2572,2574,2578,2579,2602,2603,2608,2644,2649,2663,2665,2667,2680,2682,2686,2690,2695,2700,2701,2702,2711,2715,2717,2718,2720,2721,2726,2730,2735,2737,2739,2742,2744,2746,2748,2755,2756,2763,2764,2792,2793,2794,2795,2801,2803,2805,2809,2810,2811,2814,2816,2817,2831,2837,2852,2853,2857,2858,2859,2867,2869,2870,2871,2877,2878,2884,2885,2893,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2916,2932,2934,2935,2936,2947,2948,2949,2952,2964,2966,2971,2972,2973,2974,2975,2977,2981,2982,2984,2985,2986,2987,2989,2996,3000,3001,3003,3006,3010,3020,3024,3026,3031,3032,3036,3037,3043,3049,3055,3056,3058,3060,3061,3063,3067,3068,3078,3080,3089,3095,3103,3104,3107,3109,3111,3115,3133,3136,3159,3160,3161,3162,3163,3164,3165,3167,3168,3175,3180,3181,3182,3189,3192,3198,3199,3205,3206,3208,3212,3214,3216,3218,3220,3222,3223,3225,3229,3232,3235,3237,3239,3244,3251,3252,3254,3257,3258,3259,3263,3264,3267,3300,3303,3308,3311,3312,3317,3320,3322,3332,3339,3354,3363,3385,3390,3392,3393,3396,3397,3399,3401,3402,3406,3427,3428,3429,3430,3431,3441,3445,3446,3451,3452,3457,3460,3461,3466,3467,3474,3475,3477,3478,3479,3486,3487,3488,3489,3491,3492,3495,3503,3512,3513,3514,3515,3520,3529,3530,3531,3535,3536,3537,3538,3539,3550,3551,3557,3564,3573,3574,3575,3577,3609,3610,3615,3616,3618,3619,3620,3621,3631,3634,3638,3641,3646,3652,3659,3662,3663,3664,3666,3676,3678,3684,3687,3695,3696,3708,3710,3712,3714,3715,3716,3717,3719,3720,3726,3735,3752,3754,3755,3759,3760,3763,3764,3766,3768,3769,3772,3773,3774,3780,3781,3787,3788,3804,3806,3810,3811,3820,3829,3832,3833,3834,3835,3849,3864,3865,3869,3871,3873,3878,3894,3895,3896,3917,3922,3923,3936,3943,3945,3946,3948,3954,3955,3968,3970,3985,3991,3995,3999,4024,4033,4038,4044,4053,4062,4063,4065,4066,4074,4076,4077,4104,4106,4112,4113,4119,4137,4138,4139,4150,4151,4158,4176,4180,4183,4186,4187,4188,4189,4192,4193,4217,4222,4224,4228,4234,4238,4242,4244,4245,4261,4265,4266,4276,4277,4279,4292,4293,4298,4299,4300,4302,4304,4314,4320,4322,4329,4331,4336,4339,4344,4355,4358,4380,4383,4403,4405,4408,4417,4418,4419,4420,4426,4429,4431,4432,4460,4462,4464,4465,4470,4471,4472,4473,4474,4475,4476,4480,4484,4492,4506,4513,4517,4520,4533,4538,4548,4551,4553,4555,4558,4576,4578,4581,4586,4587,4591,4592,4593,4594,4595,4596,4597,4598,4599,4600,4601,4610,4617,4618,4619,4620,4623,4624,4626,4627,4628,4630,4632,4635,4636,4644,4645,4649,4651,4654,4655,4657,4658,4659,4660,4661,4662,4668,4669,4672,4673,4675,4676,4679,4681,4684,4685,4688,4690,4693,4694,4695,4696,4697,4699,4700,4701,4704,4706,4709,4710,4711,4714,4715,4724,4731,4733,4734,4735,4744,4750,4756,4761,4771,4772,4778,4782,4788,4791,4793,4794,4806,4820,4823,4824,4827,4842,4843,4844,4845,4864,4868,4869,4880,4893,4896,4915,4928,4936,4943,4944,4960,4965,4973,4974,4976,4980,4985,4986,4987,4988,4989,4996,5003,5004,5007,5015,5028,5036,5037,5038,5039,5040,5042,5044,5054,5055,5058,5060,5062,5063,5066,5067,5070,5071,5072,5086,5089,5091,5092,5096,5106,5108,5110,5114,5117,5118,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5153,5160,5161,5166,5167,5170,5173,5174,5181,5182,5195,5196,5200,5201,5202,5204,5209,5212,5218,5220,5222,5230,5233,5237,5248,5255,5256,5261,5266,5267,5270,5275,5278,5286,5287,5288,5289,5290,5292,5295,5299,5310,5317,5320,5321,5322,5324,5328,5329,5337,5338,5339,5340,5341,5344,5347,5355,5371,5377,5388,5392,5396,5403,5405,5412,5413,5414,5415,5416,5421,5422,5425,5427,5430,5433,5435,5446,5447,5448,5449,5460,5463,5464,5466,5467,5471,5480,5481,5485,5492,5493,5494,5496,5497,5504,5507,5508,5510,5511,5521,5522,5523,5525,5533,5538,5544,5548,5551,5553,5554,5556,5557,5558,5566,5569,5573,5575,5577,5580,5582,5583,5584,5594,5599,5601,5610,5616,5622,5624,5625,5635,5636,5637,5648,5655,5663,5681,5716,5717,5722,5724,5725,5736,5739,5740,5741,5743,5753,5755,5756,5762,5764,5765,5773,5785,5786,5790,5792,5793,5794,5795,5796,5797,5799,5803,5804,5808,5809,5811,5818,5825,5833,5838,5847,5849,5850,5852,5854,5858,5859,5863,5864,5866,5875,5879,5888,5890,5896,5898,5901,5906,5907,5908,5910,5912,5914,5926,5932,5935,5938,5943,5955,5956,5959,5962,5965,5966,5967,5971,5973,5975,5977,5978,5982,5983,5984,5988,5989,5990,5993,5996,5997,5998,5999,6001,6005,6010,6012,6013,6020,6021,6024,6028,6034,6041,6042,6043,6044,6045,6046,6047,6048,6049,6052,6063,6065,6069,6070,6084,6085,6091,6092,6093,6094,6095,6096,6098,6100,6103,6105,6109,6111,6116,6128,6132,6140,6141,6142,6147,6149,6154,6158,6159,6160,6168,6170,6172,6173,6174,6175,6176,6177,6181,6183,6185,6191,6194,6198,6215,6218,6220,6223,6224,6225,6227,6228,6229,6233,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6268,6269,6270,6275,6280,6281,6283,6288,6289,6290,6291,6292,6293,6294,6300,6301,6302,6303,6304,6305,6309,6310,6318,6319,6320,6321,6339,6343,6345,6347,6348,6361,6363,6364,6365,6370,6372,6395,6412,6413,6432,6433,6439,6440,6452,6455,6456,6468,6469,6474,6475,6476,6480,6482,6496,6497,6509,6512,6513,6514,6520,6521,6522,6523,6524,6529,6535,6551,6554,6555,6564,6570,6583,6584,6587,6591,6592,6593,6606,6611,6614,6615,6616,6617,6618,6619,6620,6621,6622,6623,6624,6625,6626,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6649,6662,6663,6667,6679,6686,6688,6691,6692,6696,6703,6704,6707,6714,6722,6729,6735,6736,6747,6748,6752,6755,6756,6766,6767,6769,6771,6777,6779,6781,6782,6791,6799,6800,6801,6802,6805,6809,6814,6815,6816,6817,6819,6820,6821,6826,6828,6834,6853,6876,6877,6883,6884,6894,6896,6898,6914,6919,6921,6925,6928,6931,6935,6936,6944,6956,6981,6982,6983,6984,6985,6986,6988,6998,7003,7012,7013,7019,7032,7038,7039,7048,7053,7058,7063,7067,7073,7074,7079,7082,7090,7091,7092,7098,7104,7108,7109,7121,7122,7131,7134,7141,7142,7143,7154,7162,7164,7168,7175,7185,7186,7188,7190,7194,7195,7196,7197,7198,7199,7201,7209,7210,7211,7212,7213,7214,7215,7216,7217,7218,7219,7220,7221,7222,7223,7224,7225,7226,7227,7228,7229,7230,7231,7232,7235,7236,7237,7238,7240,7241,7242,7243,7245,7246,7247,7255,7256,7258,7260,7261,7262,7264,7277,7278,7279,7280,7282,7289,7290,7295,7297,7298,7300,7303,7307,7309,7312,7313,7316,7317,7318,7321,7322,7323,7329,7330,7332,7342,7347,7350,7363,7364,7367,7377,7378,7381,7382,7384,7388,7389,7392,7393,7396,7401,7414,7415,7419,7420,7421,7428,7430,7432,7435,7436,7439,7444,7451,7452,7457,7458,7460,7462,7468,7469,7482,7484,7501,7504,7507,7508,7512,7514,7515,7517,7519,7520,7522,7523,7526,7528,7533,7534,7535,7536,7537,7538,7539,7540,7541,7542,7543,7544,7545,7546,7547,7548,7549,7550,7552,7571,7575,7576,7578,7581,7583,7584,7585,7591,7592,7599,7600,7603,7606,7616,7617,7619,7624,7625,7628,7631,7632,7633,7636,7642,7648,7657,7658,7663,7665,7666,7667,7669,7678,7696,7701,7703,7705,7707,7712,7713,7714,7717,7723,7728,7729,7730,7732,7734,7735,7736,7737,7741,7742,7746,7756,7757,7774,7777,7778,7785,7787,7792,7799,7804,7810,7820,7825,7830,7835,7836,7837,7838,7839,7841,7842,7844,7845,7848,7854,7855,7865,7869,7871,7877,7878,7880,7882,7885,7888,7891,7894,7895,7896,7897,7902,7905,7906,7908,7910,7913,7917,7921,7923,7924,7931,7933,7936,7941,7962,7965,7967,7969,7976,7978,7979,7980,7981,7982,7983,7984,7985,7986,7987,7988,7989,7990,7991,7992,7993,7994,7995,7996,7997,7998,7999,8000,8001,8002,8003,8004,8005,8006,8007,8008,8009,8010,8017,8021,8022,8027,8029,8036,8038,8040,8041,8045,8046,8047,8056,8060,8067,8078,8083,8084,8090,8091,8095,8096,8099,8100,8110,8112,8118,8119,8127,8132,8134,8137,8138,8140,8141,8142,8143,8147,8149,8150,8153,8156,8159,8164,8166,8170,8176,8179,8187,8189,8190,8192,8194,8195,8198,8199,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8212,8214,8215,8216,8217,8218,8220,8222,8224,8225,8226,8228,8229,8230,8232,8233,8240,8241,8244,8245,8246,8247,8252,8253,8261,8264,8265,8270,8271,8273,8274,8275,8276,8278,8279,8282,8283,8285,8286,8287,8289,8292,8293,8295,8296,8297,8300,8302,8303,8304,8312,8313,8321,8322,8323,8326,8328,8332,8333,8334,8335,8344,8345,8346,8347,8349,8351,8352,8353,8357,8359,8363,8366,8374,8378,8379,8380,8382,8383,8384,8386,8389,8393,8394,8402,8403,8410,8413,8415,8426,8432,8440,8445,8451,8457,8464,8472,8473,8477,8487,8490,8492,8499,8500,8501,8503,8505,8509,8511,8513,8533,8538,8550,8554,8555,8559,8560,8562,8564,8568,8572,8583,8591,8593,8594,8602,8605,8611,8612,8613,8618,8633,8636,8638,8639,8653,8664,8672,8695,8699,8701,8702,8703,8739,8741,8756,8757,8758,8764,8773,8776,8781,8784,8799,8801,8802,8804,8807,8810,8811,8812,8813,8814,8815,8816,8817,8818,8819,8820,8821,8822,8823,8824,8825,8826,8827,8828,8829,8830,8831,8832,8833,8834,8835,8836,8837,8838,8843,8854,8855,8860,8862,8863,8872,8873,8876,8879,8884,8893,8895,8897,8899,8908,8920,8922,8937,8939,8940,8942,8945,8959,8966,8967,8970,8973,8977,8979,8981,9006,9053,9054,9059,9064,9083,9084,9087,9088,9090,9111,9112,9116,9129,9130,9131,9142,9147,9155,9159,9161,9162,9164,9174,9177,9183,9188,9192,9202,9203,9206,9210,9213,9217,9218,9219,9224,9225,9230,9231,9232,9233,9540,9541,9547,9552,9554,9556,9557,9563,9564,9587,9588,9612,9621,9626,9647,9649,9654,9655,9663,9682,9690,9692,9700,9710,9711,9712,9713,9714,9715,9716,9719,9725,9726,9729,9730,9739,9748,9758,9772,9777,9784,9787,9809,9822,9829,9834,9835,9841,9847,9867,9870,9881,9884,9890,9895,9896,9900,9902,9909,9915,9917,9920,9923,9932,9940,9942,9943,9947,9960,9961,9962,9963,9970,9987,9993,9999,10008,10012,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10065,10075,10076,10110,10116,10125,10134,10135,10146,10167,10169,10173,10182,10183,10191,10206,10217,10222,10224,10230,10242,10256,10261,10269,10274,10278,10283,10284,10285,10287,10288)
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 | 7 | 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.18 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.49 ms |
| Optimizing | 0.54 ms |
| Statistics | 0.23 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.77 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 72.22 ms |
| Creating sort index | 1.88 ms |
| Removing tmp table | 5.55 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.01 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.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 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 |