Temps de requête : 113.83 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.343 MB mémoire avant requête : 4.558 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 13:40:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 13:40:39')
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,12,13,16,29,41,57,100,107,126,129,130,134,137,139,152,158,167,172,173,190,199,202,212,213,223,240,257,267,268,275,277,288,302,305,315,316,317,321,327,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,439,440,441,442,443,444,445,447,448,449,451,452,454,467,472,487,488,489,490,491,496,497,498,499,523,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,560,561,562,563,564,566,580,601,602,603,608,612,613,614,616,622,635,637,661,665,667,668,669,687,690,702,703,704,705,706,707,712,713,714,764,774,776,821,822,938,939,941,942,954,956,969,978,979,980,981,982,983,984,993,996,1005,1020,1036,1039,1040,1041,1042,1045,1072,1073,1074,1093,1095,1103,1104,1109,1110,1111,1129,1132,1158,1163,1167,1173,1175,1177,1178,1179,1180,1182,1185,1201,1207,1210,1211,1217,1223,1226,1247,1248,1251,1252,1253,1263,1264,1265,1270,1273,1276,1279,1280,1290,1296,1297,1304,1311,1312,1318,1322,1323,1324,1327,1329,1330,1335,1336,1337,1338,1342,1346,1350,1351,1354,1356,1358,1359,1360,1383,1389,1390,1391,1392,1394,1397,1401,1402,1405,1411,1412,1424,1430,1433,1435,1436,1437,1439,1440,1441,1442,1443,1444,1445,1446,1895,1898,1899,1901,1902,1929,2214,2215,2218,2222,2223,2225,2226,2227,2228,2229,2230,2231,2232,2233,2238,2244,2245,2253,2263,2264,2265,2266,2277,2278,2279,2280,2285,2286,2287,2291,2292,2293,2295,2297,2299,2300,2302,2303,2312,2316,2317,2318,2319,2321,2324,2326,2332,2334,2335,2340,2343,2344,2345,2348,2349,2353,2359,2361,2363,2365,2367,2371,2373,2375,2381,2390,2391,2393,2394,2395,2397,2400,2402,2403,2407,2412,2413,2414,2416,2427,2435,2440,2441,2442,2445,2446,2453,2454,2459,2464,2468,2475,2480,2505,2523,2557,2559,2561,2578,2602,2649,2653,2657,2660,2661,2662,2663,2664,2668,2669,2670,2677,2678,2681,2686,2687,2688,2694,2695,2697,2701,2702,2703,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2716,2722,2725,2729,2730,2736,2738,2739,2740,2744,2746,2747,2750,2751,2752,2755,2757,2758,2785,2786,2787,2789,2796,2800,2801,2802,2803,2804,2805,2810,2814,2815,2816,2818,2819,2826,2827,2828,2833,2837,2838,2844,2847,2848,2850,2863,2871,2872,2877,2884,2888,2895,2896,2899,2903,2904,2905,2906,2907,2908,2909,2910,2923,2925,2926,2927,2928,2932,2949,2952,2965,2966,2971,2976,2979,2981,2983,2985,2986,2987,2988,2989,2991,2996,2997,2999,3010,3013,3022,3023,3026,3030,3032,3034,3044,3067,3068,3080,3087,3088,3089,3095,3103,3104,3109,3110,3113,3114,3115,3116,3117,3118,3119,3121,3122,3123,3124,3125,3126,3127,3128,3131,3132,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3159,3160,3161,3162,3163,3164,3165,3166,3170,3171,3174,3192,3202,3212,3217,3223,3228,3230,3231,3232,3234,3236,3237,3241,3244,3249,3260,3285,3313,3314,3323,3324,3325,3326,3327,3328,3330,3331,3335,3337,3338,3341,3342,3343,3344,3345,3346,3354,3364,3365,3366,3368,3379,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3397,3401,3402,3405,3410,3425,3431,3456,3465,3467,3470,3474,3476,3477,3478,3479,3480,3481,3482,3483,3484,3485,3486,3490,3491,3492,3513,3514,3520,3521,3525,3526,3530,3531,3532,3533,3535,3536,3537,3538,3539,3551,3573,3575,3611,3612,3613,3614,3624,3626,3658,3659,3665,3670,3684,3688,3704,3707,3708,3709,3712,3713,3714,3715,3724,3726,3756,3767,3768,3772,3803,3808,3811,3821,3822,3823,3824,3825,3826,3839,3840,3844,3849,3850,3851,3860,3863,3865,3870,3873,3875,3876,3879,3880,3887,3889,3893,3895,3896,3897,3898,3899,3903,3905,3912,3916,3924,3931,3935,3936,3937,3950,3957,3964,3966,3971,3974,3975,3976,3979,3986,3989,3990,3991,3992,3994,3995,3996,3997,3998,4008,4030,4032,4039,4053,4056,4073,4107,4108,4109,4112,4113,4123,4134,4137,4153,4154,4184,4193,4199,4209,4212,4217,4218,4219,4236,4237,4246,4265,4296,4297,4300,4305,4313,4322,4330,4333,4337,4338,4341,4344,4352,4363,4364,4367,4385,4389,4390,4401,4407,4408,4414,4418,4420,4442,4451,4457,4458,4470,4472,4478,4483,4485,4505,4506,4509,4511,4512,4514,4515,4520,4522,4532,4533,4542,4547,4551,4556,4558,4581,4584,4585,4594,4626,4629,4633,4634,4637,4644,4657,4661,4672,4674,4680,4686,4687,4689,4693,4694,4704,4706,4707,4708,4709,4750,4767,4770,4771,4775,4778,4781,4787,4791,4793,4796,4797,4799,4805,4806,4807,4808,4817,4822,4823,4824,4828,4832,4833,4834,4838,4841,4843,4844,4845,4852,4854,4857,4858,4861,4862,4863,4865,4866,4867,4868,4869,4871,4872,4874,4881,4882,4883,4884,4885,4888,4889,4890,4896,4899,4901,4905,4925,4926,4929,4937,4938,4942,4944,4945,4952,4953,4955,4956,4957,4958,4959,4964,4967,4970,4971,4975,4977,4979,4985,4986,4987,4988,4989,4990,4995,4996,4997,5000,5001,5002,5003,5004,5006,5010,5011,5012,5014,5024,5029,5032,5034,5035,5036,5040,5042,5046,5047,5051,5052,5053,5055,5056,5057,5058,5064,5069,5070,5085,5086,5089,5094,5100,5101,5102,5103,5111,5112,5120,5149,5150,5152,5155,5156,5159,5164,5170,5172,5173,5174,5191,5192,5196,5200,5210,5211,5212,5215,5216,5218,5222,5224,5225,5227,5229,5237,5238,5240,5244,5266,5269,5281,5285,5293,5299,5301,5302,5303,5313,5315,5316,5317,5319,5327,5329,5330,5332,5333,5335,5337,5340,5341,5352,5353,5360,5367,5370,5375,5376,5387,5393,5394,5396,5401,5405,5411,5416,5425,5433,5446,5456,5458,5466,5467,5472,5474,5475,5480,5481,5483,5484,5489,5490,5491,5496,5498,5499,5500,5501,5502,5504,5506,5509,5511,5515,5517,5520,5555,5556,5557,5566,5572,5573,5577,5580,5581,5583,5585,5592,5594,5595,5601,5609,5611,5612,5613,5616,5618,5619,5624,5625,5630,5635,5647,5648,5653,5658,5659,5662,5664,5665,5669,5671,5673,5674,5675,5676,5677,5703,5705,5706,5707,5712,5715,5716,5718,5720,5721,5722,5727,5734,5735,5739,5740,5762,5766,5777,5779,5780,5781,5782,5796,5797,5799,5800,5801,5803,5804,5805,5808,5810,5851,5856,5860,5888,5892,5896,5913,5914,5955,5956,5965,5968,5977,5983,5992,5993,6010,6014,6019,6020,6024,6027,6032,6059,6060,6068,6069,6073,6076,6095,6098,6101,6102,6120,6121,6122,6123,6124,6126,6127,6129,6130,6132,6133,6135,6140,6147,6150,6154,6166,6167,6168,6176,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6209,6210,6211,6212,6216,6217,6224,6225,6226,6234,6272,6281,6303,6304,6306,6308,6309,6310,6315,6318,6319,6322,6323,6324,6325,6329,6330,6331,6332,6333,6334,6338,6347,6357,6359,6361,6365,6374,6375,6376,6397,6406,6412,6414,6419,6420,6422,6426,6432,6448,6449,6456,6466,6472,6473,6474,6475,6477,6478,6480,6481,6492,6520,6528,6548,6549,6550,6551,6553,6554,6555,6590,6591,6593,6608,6609,6610,6611,6613,6638,6641,6642,6643,6656,6657,6658,6663,6664,6665,6666,6668,6673,6676,6680,6681,6682,6683,6684,6685,6687,6690,6691,6693,6695,6699,6706,6707,6709,6715,6716,6720,6721,6722,6724,6726,6729,6731,6737,6747,6749,6761,6763,6764,6765,6777,6778,6780,6784,6785,6788,6789,6790,6791,6793,6794,6795,6799,6801,6802,6806,6808,6809,6810,6811,6815,6818,6824,6828,6830,6832,6835,6839,6840,6846,6850,6851,6852,6853,6854,6858,6868,6869,6870,6871,6872,6873,6874,6875,6876,6877,6883,6887,6895,6903,6907,6908,6909,6910,6917,6918,6920,6921,6922,6923,6926,6927,6929,6930,6931,6933,6937,6938,6942,6943,6945,6949,6950,6952,6954,6956,6961,6962,6965,6968,6987,6988,6989,6990,6991,6997,6998,7001,7002,7005,7007,7011,7013,7014,7015,7029,7033,7034,7035,7038,7042,7047,7048,7056,7057,7061,7073,7074,7081,7083,7084,7085,7087,7088,7089,7095,7097,7098,7100,7101,7102,7105,7111,7112,7113,7114,7115,7118,7119,7121,7122,7124,7125,7130,7132,7133,7139,7142,7143,7148,7149,7150,7152,7161,7166,7167,7182,7184,7185,7187,7189,7191,7194,7200,7201,7207,7208,7233,7234,7240,7247,7251,7253,7254,7255,7267,7269,7275,7277,7282,7289,7291,7294,7295,7296,7298,7308,7310,7314,7316,7317,7319,7320,7321,7322,7323,7324,7325,7326,7327,7328,7329,7335,7336,7342,7352,7353,7354,7355,7362,7365,7373,7374,7375,7376,7378,7379,7381,7382,7383,7387,7389,7390,7394,7395,7416,7419,7420,7423,7424,7428,7442,7445,7446,7447,7460,7461,7466,7468,7481,7498,7501,7503,7508,7509,7510,7513,7521,7525,7528,7534,7544,7551,7565,7566,7572,7575,7578,7581,7587,7588,7593,7595,7598,7607,7624,7625,7627,7634,7635,7643,7644,7646,7647,7660,7662,7664,7666,7667,7668,7672,7673,7678,7681,7682,7688,7692,7695,7698,7708,7709,7713,7714,7721,7722,7723,7724,7738,7739,7740,7744,7745,7748,7749,7754,7755,7766,7767,7768,7769,7772,7773,7775,7780,7781,7783,7785,7789,7790,7791,7795,7798,7800,7804,7805,7806,7807,7808,7817,7818,7819,7834,7840,7841,7842,7843,7845,7848,7849,7856,7872,7890,7892,7895,7899,7901,7910,7916,7918,7919,7922,7929,7931,7934,7936,7945,7951,7952,7961,7963,8010,8018,8026,8027,8035,8039,8044,8055,8057,8060,8070,8076,8079,8084,8086,8091,8095,8096,8098,8103,8104,8105,8106,8110,8111,8117,8118,8129,8145,8148,8149,8158,8177,8178,8184,8193,8194,8195,8212,8214,8219,8234,8245,8254,8263,8277,8280,8289,8292,8298,8300,8326,8336,8353,8354,8358,8360,8363,8367,8369,8373,8374,8375,8387,8389,8401,8404,8405,8406,8407,8415,8419,8426,8432,8436,8452,8460,8462,8468,8474,8483,8485,8500,8501,8511,8518,8525,8526,8528,8529,8539,8544,8561,8572,8573,8575,8577,8579,8580,8587,8591,8597,8609,8625,8626,8627,8628,8634,8639,8641,8644,8646,8653,8655,8660,8665,8666,8668,8671,8682,8685,8686,8689,8690,8692,8695,8696,8702,8704,8705,8710,8711,8715,8723,8727,8728,8730,8736,8737,8738,8742,8743,8744,8745,8753,8754,8755,8760,8761,8765,8771,8781,8785,8786,8789,8797,8798,8799,8802,8839,8840,8841,8842,8844,8845,8847,8853,8854,8855,8865,8866,8868,8879,8881,8883,8885,8886,8890,8893,8896,8903,8913,8914,8918,8919,8920,8921,8928,8930,8935,8936,8937,8939,8943,8944,8952,8967,8971,8974,8977,8988,8989,9006,9013,9014,9020,9023,9029,9046,9059,9061,9062,9067,9087,9090,9096,9097,9108,9130,9134,9138,9141,9173,9176,9181,9182,9183,9184,9187,9190,9191,9192,9203,9207,9213,9222,9233,9551,9553,9554,9555,9557,9562,9568,9583,9587,9593,9595,9600,9608,9613,9614,9623,9626,9635,9636,9639,9643,9644,9645,9646,9656,9657,9658,9659,9661,9662,9664,9665,9667,9668,9669,9671,9673,9680,9681,9682,9684,9685,9686,9687,9688,9689,9690,9694,9697,9701,9702,9703,9704,9705,9706,9710,9711,9712,9713,9714,9715,9716,9719,9720,9723,9724,9725,9726,9727,9731,9732,9736,9737,9740,9743,9745,9747,9748,9749,9757,9758,9759,9760,9762,9763,9764,9769,9771,9774,9778,9779,9780,9781,9783,9789,9792,9809,9810,9813,9814,9815,9838,9840,9848,9854,9857,9860,9862,9868,9869,9881,9882,9884,9891,9892,9893,9898,9910,9914,9915,9917,9923,9924,9927,9928,9935,9936,9940,9941,9947,9955,9958,9970,9987,9993,9997,10001,10002,10003,10005,10006,10007,10008,10013,10014,10015,10038,10048,10053,10069,10071,10072,10073,10083,10089,10092,10105,10107,10113,10123,10132,10133,10145,10146,10162,10167,10175,10182,10183,10187,10188,10190,10196,10198,10215,10233,10235,10250,10251,10256,10269,10272,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|filter | PRIMARY,item,catid | catid|item | 4|7 | j3.c.id | 7 (50%) | Using index condition; Using where; Using rowid filter |
| 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.58 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.68 ms |
| Optimizing | 0.74 ms |
| Statistics | 0.36 ms |
| Preparing | 0.09 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 18.46 ms |
| Removing tmp table | 0.02 ms |
| Sending data | 84.69 ms |
| Creating sort index | 2.17 ms |
| Removing tmp table | 4.21 ms |
| Creating sort index | 0.12 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.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 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 |
