Temps de requête : 87.24 ms Après la dernière requête : 1.98 ms Mémoire de requête : 0.151 MB mémoire avant requête : 4.622 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 09:48:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 09:48:45')
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(10,13,15,26,28,32,33,34,41,57,93,100,102,129,130,134,137,139,142,152,158,172,192,199,223,225,227,228,231,232,233,234,240,247,250,260,261,265,267,268,276,278,288,298,299,302,305,306,309,312,323,324,325,326,327,330,345,347,348,349,350,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,404,405,406,407,408,414,416,417,418,419,420,423,424,425,426,427,429,430,431,433,437,440,441,442,443,444,445,446,447,448,449,450,451,452,458,459,460,461,462,463,464,465,466,471,472,477,478,479,480,483,484,485,486,487,488,489,490,491,492,493,496,497,498,499,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,556,557,558,560,561,562,565,567,568,574,575,576,577,578,579,580,581,582,583,584,587,590,591,592,593,604,605,606,610,615,618,619,623,624,626,627,628,629,630,631,632,633,634,635,642,647,648,654,655,657,658,659,669,683,684,691,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,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,774,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,913,914,915,918,919,920,921,922,923,924,925,926,927,929,930,931,932,935,938,939,942,950,954,956,962,965,966,969,970,972,978,979,980,981,982,983,984,986,988,993,996,999,1000,1002,1005,1008,1009,1020,1021,1024,1026,1029,1033,1036,1040,1041,1042,1052,1058,1066,1067,1068,1070,1072,1073,1074,1078,1079,1080,1084,1094,1102,1103,1104,1105,1106,1109,1110,1111,1112,1116,1118,1129,1130,1140,1141,1150,1151,1159,1160,1162,1163,1166,1172,1173,1177,1178,1179,1180,1182,1214,1217,1223,1226,1227,1228,1229,1232,1239,1246,1247,1248,1251,1252,1253,1254,1260,1261,1263,1264,1265,1266,1267,1270,1272,1273,1284,1290,1292,1293,1296,1303,1304,1309,1311,1312,1314,1315,1316,1321,1323,1326,1327,1329,1330,1333,1336,1338,1340,1342,1346,1348,1349,1350,1354,1356,1358,1359,1360,1363,1364,1365,1371,1372,1373,1382,1387,1389,1390,1391,1392,1407,1408,1409,1410,1411,1412,1437,2219,2220,2221,2228,2234,2238,2244,2245,2250,2252,2253,2254,2266,2267,2268,2269,2270,2271,2272,2274,2277,2278,2279,2280,2282,2283,2284,2286,2287,2288,2289,2292,2295,2297,2302,2303,2306,2307,2309,2311,2312,2316,2317,2318,2319,2320,2321,2326,2327,2334,2335,2339,2343,2344,2345,2348,2349,2353,2359,2370,2373,2375,2378,2393,2394,2401,2407,2408,2409,2411,2412,2413,2416,2418,2422,2423,2424,2426,2427,2429,2433,2434,2435,2437,2440,2441,2442,2445,2446,2447,2448,2453,2454,2455,2459,2464,2466,2468,2475,2480,2481,2505,2506,2507,2508,2554,2555,2556,2559,2560,2561,2564,2567,2578,2579,2602,2608,2649,2657,2661,2662,2663,2664,2667,2668,2669,2677,2678,2680,2682,2686,2687,2688,2690,2695,2697,2700,2701,2715,2716,2717,2718,2720,2721,2722,2725,2726,2730,2735,2736,2739,2744,2746,2751,2752,2755,2763,2786,2792,2793,2794,2795,2796,2801,2803,2804,2805,2809,2810,2814,2815,2816,2817,2826,2837,2838,2844,2850,2852,2853,2857,2858,2859,2863,2867,2869,2872,2877,2878,2884,2885,2888,2893,2895,2896,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2916,2923,2932,2947,2948,2949,2952,2964,2965,2966,2971,2972,2973,2974,2975,2977,2981,2982,2984,2986,2987,2989,2991,2996,2997,2999,3006,3010,3022,3026,3032,3037,3044,3049,3055,3056,3058,3060,3061,3063,3067,3068,3080,3087,3088,3089,3095,3103,3104,3107,3109,3110,3111,3113,3114,3115,3116,3117,3118,3119,3121,3122,3123,3124,3125,3126,3127,3128,3131,3132,3133,3136,3142,3143,3167,3174,3198,3199,3202,3205,3206,3208,3212,3214,3216,3220,3223,3225,3230,3231,3232,3234,3235,3241,3244,3249,3251,3258,3259,3260,3300,3311,3312,3314,3317,3320,3322,3324,3325,3326,3327,3332,3337,3354,3364,3379,3381,3382,3383,3384,3385,3386,3387,3389,3390,3391,3392,3396,3397,3399,3401,3405,3406,3410,3425,3427,3429,3430,3431,3445,3446,3451,3452,3456,3457,3467,3475,3476,3477,3478,3479,3480,3481,3482,3483,3484,3485,3486,3487,3488,3495,3513,3514,3515,3520,3521,3529,3530,3531,3533,3535,3536,3550,3551,3609,3610,3611,3612,3613,3614,3618,3619,3620,3621,3631,3638,3641,3646,3652,3659,3662,3663,3664,3665,3666,3676,3678,3684,3696,3704,3707,3708,3709,3710,3712,3714,3715,3717,3719,3720,3726,3754,3763,3764,3766,3767,3768,3772,3780,3781,3787,3788,3804,3806,3811,3820,3821,3822,3823,3824,3825,3826,3832,3839,3840,3849,3865,3869,3873,3894,3905,3917,3931,3936,3943,3945,3948,3950,3954,3955,3957,3964,3968,3970,3975,3985,3991,3995,3999,4024,4032,4038,4053,4065,4073,4104,4106,4109,4112,4113,4119,4123,4137,4138,4139,4151,4153,4154,4158,4180,4183,4184,4192,4193,4217,4218,4219,4222,4238,4242,4246,4265,4266,4277,4279,4292,4293,4296,4297,4298,4300,4302,4304,4305,4322,4330,4337,4341,4344,4352,4363,4383,4389,4390,4403,4407,4408,4417,4418,4419,4420,4429,4431,4432,4442,4451,4460,4462,4464,4465,4470,4471,4472,4473,4474,4475,4476,4478,4505,4506,4509,4511,4512,4517,4520,4522,4532,4533,4538,4542,4551,4553,4555,4558,4578,4581,4584,4585,4587,4594,4610,4619,4623,4624,4626,4627,4630,4633,4634,4637,4644,4649,4651,4654,4655,4657,4672,4674,4686,4688,4690,4693,4694,4710,4711,4733,4734,4750,4756,4761,4767,4771,4772,4778,4781,4782,4787,4788,4791,4793,4794,4805,4807,4808,4820,4827,4828,4845,4854,4858,4862,4864,4868,4869,4874,4880,4881,4882,4883,4885,4888,4889,4890,4896,4925,4926,4929,4937,4938,4942,4943,4944,4952,4955,4956,4957,4958,4959,4960,4970,4971,4973,4974,4975,4976,4977,4980,4985,4986,4987,4988,4989,4990,4995,4996,4997,5001,5002,5003,5006,5007,5010,5011,5012,5014,5026,5028,5029,5032,5034,5035,5040,5044,5046,5047,5051,5052,5053,5054,5055,5056,5057,5058,5060,5063,5064,5070,5089,5094,5100,5101,5102,5103,5111,5112,5114,5118,5120,5149,5150,5152,5155,5156,5160,5161,5164,5166,5170,5172,5173,5174,5191,5192,5195,5196,5200,5201,5202,5209,5212,5216,5218,5224,5225,5227,5229,5233,5234,5235,5236,5238,5240,5266,5267,5281,5285,5289,5292,5295,5299,5301,5302,5303,5310,5313,5315,5316,5317,5320,5321,5327,5328,5329,5333,5337,5338,5339,5340,5341,5344,5347,5353,5355,5367,5371,5376,5387,5388,5392,5393,5394,5403,5405,5412,5415,5416,5425,5433,5446,5449,5458,5464,5466,5467,5471,5472,5485,5492,5493,5494,5498,5499,5500,5501,5502,5504,5507,5508,5510,5520,5521,5522,5525,5533,5553,5556,5557,5558,5566,5573,5582,5583,5584,5592,5594,5601,5610,5616,5618,5619,5624,5625,5635,5638,5648,5653,5655,5658,5659,5663,5664,5669,5681,5707,5712,5716,5717,5722,5734,5735,5736,5739,5740,5743,5753,5756,5762,5765,5766,5777,5779,5780,5781,5782,5786,5790,5792,5793,5794,5795,5796,5797,5799,5800,5801,5803,5804,5808,5811,5833,5838,5847,5849,5850,5851,5852,5854,5856,5858,5859,5860,5863,5864,5866,5875,5879,5888,5890,5892,5896,5910,5912,5913,5914,5932,5935,5956,5959,5965,5966,5967,5971,5973,5977,5982,5983,5984,5988,5989,5992,5993,5996,5997,6001,6005,6010,6012,6013,6014,6019,6020,6021,6027,6028,6032,6034,6046,6052,6059,6063,6065,6068,6069,6070,6076,6084,6085,6091,6092,6093,6094,6095,6096,6098,6100,6101,6102,6103,6105,6106,6109,6116,6120,6121,6122,6123,6124,6126,6127,6128,6129,6130,6132,6133,6135,6140,6141,6142,6147,6149,6150,6154,6166,6167,6168,6172,6173,6174,6175,6176,6181,6183,6185,6191,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6209,6210,6211,6212,6215,6216,6217,6220,6224,6225,6227,6228,6234,6270,6275,6276,6278,6279,6281,6289,6290,6291,6292,6293,6294,6303,6304,6305,6315,6318,6319,6320,6321,6322,6323,6324,6325,6329,6330,6331,6332,6333,6334,6338,6339,6343,6345,6347,6348,6357,6359,6361,6363,6365,6370,6372,6376,6379,6406,6412,6413,6414,6422,6426,6432,6433,6439,6440,6448,6449,6452,6455,6456,6466,6468,6469,6476,6480,6481,6482,6492,6496,6497,6509,6512,6513,6514,6520,6521,6522,6523,6524,6528,6529,6535,6548,6549,6550,6551,6554,6555,6564,6570,6583,6584,6587,6591,6592,6593,6606,6608,6609,6610,6611,6613,6614,6615,6616,6617,6618,6619,6620,6621,6622,6623,6624,6625,6626,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6641,6642,6643,6649,6658,6662,6663,6664,6665,6666,6667,6673,6679,6680,6681,6683,6684,6685,6686,6687,6688,6690,6691,6692,6693,6695,6696,6699,6703,6704,6706,6707,6709,6710,6714,6715,6716,6720,6721,6722,6724,6729,6735,6736,6747,6752,6755,6756,6761,6763,6764,6765,6766,6769,6777,6778,6779,6780,6781,6784,6788,6789,6790,6791,6793,6794,6799,6800,6801,6802,6805,6808,6809,6811,6814,6815,6816,6817,6819,6820,6821,6826,6828,6832,6839,6840,6850,6851,6852,6855,6877,6883,6884,6894,6895,6896,6898,6903,6907,6909,6910,6914,6917,6918,6919,6920,6921,6923,6926,6928,6929,6931,6933,6935,6936,6938,6943,6944,6949,6950,6952,6956,6961,6965,6968,6981,6988,6989,6990,6991,6998,7001,7003,7007,7012,7013,7014,7015,7019,7032,7033,7034,7035,7038,7048,7053,7056,7057,7058,7061,7067,7073,7079,7081,7082,7083,7084,7085,7087,7088,7089,7090,7091,7092,7095,7097,7098,7100,7101,7104,7108,7109,7111,7112,7114,7118,7119,7121,7122,7125,7130,7131,7132,7133,7139,7141,7142,7143,7148,7149,7150,7152,7154,7161,7164,7166,7167,7168,7182,7184,7185,7186,7187,7188,7191,7194,7195,7196,7197,7198,7199,7200,7201,7207,7208,7233,7234,7236,7237,7238,7240,7242,7243,7246,7247,7251,7253,7254,7255,7258,7260,7261,7262,7275,7277,7282,7289,7290,7291,7295,7296,7298,7300,7303,7308,7309,7310,7313,7314,7316,7317,7318,7326,7330,7332,7335,7336,7342,7347,7352,7353,7354,7355,7362,7363,7364,7365,7367,7373,7374,7375,7376,7377,7378,7383,7384,7387,7388,7389,7390,7393,7394,7395,7414,7415,7416,7419,7420,7421,7423,7424,7428,7430,7432,7435,7436,7439,7442,7445,7446,7447,7451,7452,7457,7458,7460,7462,7466,7468,7469,7481,7482,7501,7508,7509,7510,7512,7513,7515,7517,7519,7521,7522,7525,7527,7528,7534,7535,7536,7544,7551,7552,7566,7571,7572,7575,7578,7581,7583,7584,7585,7587,7588,7591,7592,7595,7617,7619,7624,7625,7628,7630,7633,7634,7635,7642,7643,7644,7648,7657,7660,7663,7664,7665,7669,7672,7673,7678,7681,7682,7688,7692,7695,7701,7703,7707,7708,7709,7712,7713,7714,7717,7721,7722,7723,7724,7728,7732,7734,7735,7736,7737,7738,7739,7740,7741,7742,7744,7745,7748,7754,7755,7756,7757,7768,7774,7775,7783,7792,7795,7798,7799,7800,7804,7805,7817,7818,7819,7820,7830,7834,7835,7836,7837,7839,7840,7841,7842,7843,7845,7848,7849,7855,7856,7865,7869,7878,7885,7888,7890,7891,7894,7895,7896,7901,7905,7906,7908,7910,7916,7917,7918,7919,7921,7922,7923,7929,7931,7933,7934,7936,7941,7945,7951,7952,7961,7962,7963,7965,7967,7969,7976,8010,8018,8021,8022,8026,8027,8029,8035,8036,8038,8040,8055,8057,8060,8067,8076,8078,8079,8083,8084,8086,8090,8091,8095,8096,8098,8099,8100,8103,8104,8105,8106,8110,8111,8112,8117,8129,8145,8155,8158,8159,8164,8166,8187,8190,8192,8193,8194,8195,8212,8214,8215,8217,8218,8219,8222,8224,8226,8228,8229,8232,8240,8241,8243,8245,8246,8254,8263,8271,8274,8276,8277,8278,8280,8289,8292,8298,8300,8312,8323,8326,8332,8333,8335,8344,8345,8349,8351,8358,8359,8360,8363,8366,8367,8369,8373,8374,8375,8378,8379,8380,8382,8383,8384,8386,8387,8389,8393,8401,8402,8403,8404,8405,8410,8413,8415,8419,8436,8440,8452,8457,8464,8468,8472,8473,8474,8477,8483,8485,8487,8490,8492,8499,8500,8501,8509,8511,8513,8518,8525,8526,8528,8529,8533,8538,8539,8544,8554,8560,8561,8572,8573,8575,8577,8579,8580,8587,8591,8593,8597,8602,8609,8611,8612,8613,8616,8618,8625,8626,8628,8634,8636,8638,8641,8644,8645,8646,8653,8655,8660,8664,8665,8666,8668,8671,8682,8685,8686,8689,8690,8692,8694,8695,8696,8699,8701,8702,8703,8704,8705,8711,8715,8723,8727,8728,8730,8736,8737,8739,8741,8742,8743,8744,8753,8754,8755,8756,8757,8758,8760,8761,8765,8771,8773,8781,8784,8785,8798,8799,8802,8804,8839,8840,8841,8842,8844,8845,8846,8847,8853,8854,8855,8860,8863,8865,8866,8868,8872,8876,8879,8881,8883,8885,8886,8890,8893,8894,8897,8899,8903,8911,8914,8918,8919,8920,8921,8922,8925,8926,8928,8935,8937,8939,8940,8942,8944,8945,8966,8971,8974,8976,8977,8979,8981,9006,9018,9019,9020,9023,9029,9031,9045,9046,9048,9053,9054,9059,9061,9066,9068,9069,9070,9071,9072,9073,9074,9075,9076,9079,9084,9085,9087,9090,9092,9096,9097,9100,9108,9111,9112,9116,9118,9121,9130,9134,9138,9141,9142,9147,9161,9162,9173,9174,9176,9181,9183,9184,9187,9188,9190,9191,9192,9202,9203,9207,9210,9211,9212,9213,9217,9218,9222,9233,9540,9541,9543,9551,9553,9554,9555,9562,9563,9565,9568,9576,9581,9583,9588,9596,9600,9610,9612,9621,9626,9634,9635,9636,9639,9643,9644,9645,9646,9654,9656,9658,9660,9663,9682,9685,9690,9692,9700,9701,9709,9710,9711,9712,9713,9714,9715,9716,9719,9724,9725,9726,9729,9730,9736,9738,9746,9748,9754,9758,9762,9763,9766,9767,9772,9774,9775,9789,9798,9805,9806,9807,9809,9810,9819,9821,9826,9829,9838,9841,9842,9846,9849,9851,9859,9862,9867,9868,9870,9873,9880,9881,9882,9884,9890,9892,9893,9896,9897,9898,9900,9901,9902,9904,9910,9911,9914,9915,9917,9920,9923,9924,9927,9928,9929,9935,9936,9940,9947,9958,9959,9960,9963,9968,9969,9970,9977,9980,9988,9989,9993,9995,9997,9998,10012,10038,10041,10042,10043,10045,10046,10047,10048,10054,10055,10061,10064,10065,10066,10067,10068,10070,10071,10072,10073,10075,10076,10083,10105,10107,10110,10113,10116,10125,10132,10133,10134,10135,10138,10145,10146,10162,10163,10167,10173,10175,10180,10182,10187,10188,10190,10191,10196,10206,10219,10222,10225,10233,10242,10250,10251,10256,10269,10272,10274,10287)
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.33 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.77 ms |
| Optimizing | 0.68 ms |
| Statistics | 0.30 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 1.26 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 77.17 ms |
| Creating sort index | 1.53 ms |
| Removing tmp table | 3.54 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.02 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.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.14 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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 |
