Temps de requête : 74.24 ms Après la dernière requête : 2.61 ms Mémoire de requête : 0.140 MB mémoire avant requête : 4.501 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:31:57')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 12:31:57')
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(42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,102,109,110,111,112,113,114,115,116,117,118,119,120,136,145,146,147,181,193,196,200,225,226,231,237,243,244,245,246,247,250,251,254,257,258,276,278,281,282,285,286,289,290,291,293,294,295,296,297,298,303,304,307,308,309,313,314,318,328,329,330,407,458,461,462,463,464,465,466,467,501,502,516,561,570,571,572,594,600,601,602,603,607,608,644,656,657,658,660,661,662,663,664,710,772,773,774,775,776,821,912,935,937,945,951,955,956,959,973,974,975,994,997,1001,1006,1009,1013,1014,1016,1019,1023,1025,1026,1030,1031,1035,1037,1043,1046,1047,1049,1050,1071,1075,1093,1119,1121,1125,1142,1148,1149,1156,1171,1176,1215,1216,1217,1218,1222,1223,1227,1235,1238,1242,1243,1255,1257,1260,1262,1268,1271,1291,1299,1307,1308,1311,1313,1321,1322,1325,1335,1339,1340,1343,1344,1345,1347,1353,1355,1400,1406,1407,1412,1413,1414,1431,1432,1434,1436,1446,2073,2152,2156,2205,2210,2225,2236,2238,2242,2243,2255,2259,2298,2299,2300,2309,2319,2320,2335,2337,2341,2342,2347,2357,2369,2370,2374,2378,2379,2400,2401,2402,2415,2436,2438,2439,2451,2452,2465,2469,2470,2478,2479,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,2524,2525,2526,2527,2528,2529,2531,2532,2533,2534,2535,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2563,2564,2568,2569,2571,2572,2573,2574,2577,2581,2582,2584,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2600,2601,2603,2613,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2644,2645,2651,2662,2663,2665,2692,2702,2711,2728,2732,2733,2737,2738,2742,2743,2748,2756,2764,2784,2789,2794,2797,2807,2810,2811,2814,2824,2825,2831,2840,2841,2846,2862,2869,2870,2871,2878,2890,2891,2892,2898,2911,2915,2916,2917,2920,2921,2922,2933,2934,2935,2936,2939,2940,2943,2945,2946,2954,2969,2970,2985,2990,2995,2998,3000,3001,3003,3004,3006,3007,3008,3009,3011,3012,3019,3020,3021,3024,3025,3031,3033,3036,3038,3041,3042,3043,3045,3050,3051,3057,3058,3059,3063,3066,3077,3078,3085,3094,3095,3097,3105,3130,3133,3144,3145,3157,3158,3159,3160,3161,3162,3163,3164,3165,3167,3168,3172,3174,3175,3180,3181,3182,3189,3192,3197,3209,3210,3211,3213,3218,3219,3220,3221,3222,3223,3226,3229,3237,3238,3239,3242,3243,3244,3246,3252,3254,3257,3263,3264,3267,3296,3297,3298,3303,3308,3333,3339,3352,3359,3361,3363,3371,3372,3375,3376,3377,3378,3392,3393,3394,3395,3397,3399,3400,3401,3402,3409,3418,3419,3420,3426,3428,3429,3441,3444,3452,3453,3458,3460,3461,3466,3474,3475,3489,3491,3492,3494,3495,3496,3499,3503,3507,3512,3513,3514,3515,3516,3522,3529,3537,3538,3539,3544,3549,3550,3554,3556,3557,3560,3561,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3577,3581,3582,3583,3584,3585,3586,3587,3590,3591,3592,3594,3595,3596,3597,3605,3607,3609,3610,3615,3616,3617,3618,3623,3627,3631,3634,3635,3637,3639,3640,3642,3643,3647,3648,3649,3654,3655,3656,3660,3671,3679,3685,3687,3690,3694,3695,3697,3701,3710,3716,3721,3724,3727,3735,3752,3754,3755,3759,3760,3765,3769,3770,3771,3773,3774,3782,3793,3806,3810,3827,3829,3833,3834,3835,3864,3871,3872,3878,3882,3883,3895,3896,3900,3904,3922,3923,3926,3927,3928,3929,3930,3940,3941,3946,3951,3973,3977,3985,4012,4014,4021,4027,4029,4033,4034,4035,4040,4041,4042,4043,4044,4062,4063,4066,4067,4074,4076,4077,4085,4093,4098,4102,4105,4124,4125,4127,4128,4148,4150,4173,4176,4186,4187,4188,4189,4194,4196,4197,4207,4208,4224,4228,4231,4234,4239,4243,4244,4245,4250,4251,4255,4261,4269,4270,4276,4279,4282,4291,4292,4293,4294,4298,4299,4302,4303,4308,4312,4313,4314,4315,4318,4319,4320,4323,4324,4325,4331,4332,4336,4338,4339,4345,4350,4351,4355,4358,4380,4402,4405,4418,4426,4441,4443,4444,4445,4446,4447,4448,4449,4450,4453,4463,4467,4471,4473,4474,4475,4480,4483,4484,4485,4492,4513,4520,4523,4524,4525,4526,4527,4528,4529,4530,4531,4540,4544,4545,4548,4551,4552,4554,4555,4575,4576,4586,4587,4591,4592,4593,4594,4595,4596,4597,4598,4599,4600,4601,4609,4610,4611,4617,4618,4620,4625,4628,4630,4632,4635,4636,4639,4640,4641,4642,4645,4654,4655,4658,4659,4660,4661,4662,4668,4669,4673,4675,4676,4679,4681,4682,4684,4685,4688,4690,4695,4696,4697,4699,4700,4701,4704,4706,4709,4710,4711,4714,4715,4716,4724,4728,4730,4731,4735,4739,4741,4744,4745,4746,4751,4754,4762,4782,4794,4806,4809,4823,4824,4842,4843,4844,4851,4868,4869,4870,4876,4886,4887,4893,4899,4900,4901,4902,4903,4904,4915,4928,4936,4961,4965,4974,4980,4986,4991,4992,4993,4994,4998,5000,5003,5004,5015,5018,5019,5027,5028,5030,5034,5036,5037,5038,5039,5042,5062,5066,5067,5071,5072,5074,5086,5091,5092,5096,5098,5099,5106,5108,5110,5117,5118,5119,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,5167,5173,5181,5182,5193,5197,5198,5204,5205,5207,5213,5214,5216,5219,5220,5222,5228,5230,5237,5240,5247,5248,5251,5255,5256,5261,5267,5270,5275,5278,5286,5287,5288,5290,5320,5321,5322,5324,5354,5377,5393,5396,5413,5414,5421,5422,5427,5430,5435,5447,5448,5460,5463,5471,5480,5481,5492,5493,5496,5497,5511,5521,5523,5525,5535,5538,5539,5540,5541,5544,5545,5546,5548,5549,5551,5553,5554,5558,5569,5575,5577,5580,5599,5622,5636,5637,5686,5712,5717,5724,5725,5732,5734,5736,5741,5755,5764,5766,5767,5773,5785,5809,5818,5821,5822,5823,5824,5825,5898,5901,5906,5907,5908,5926,5938,5943,5955,5959,5962,5975,5978,5986,5990,5998,5999,6005,6010,6020,6024,6031,6034,6041,6042,6043,6044,6045,6046,6047,6048,6049,6067,6111,6158,6159,6160,6170,6177,6194,6218,6223,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,6280,6283,6288,6299,6300,6301,6302,6303,6309,6310,6311,6325,6339,6345,6361,6364,6394,6395,6426,6474,6475,6523,6673,6748,6767,6771,6782,6800,6821,6834,6853,6876,6877,6925,6935,6936,6982,6983,6984,6985,6986,7032,7039,7048,7053,7058,7063,7074,7134,7160,7162,7175,7190,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,7241,7245,7256,7264,7278,7279,7280,7297,7305,7307,7312,7321,7322,7323,7329,7334,7338,7339,7350,7371,7372,7381,7382,7392,7396,7401,7435,7444,7482,7484,7504,7507,7514,7520,7523,7526,7527,7533,7537,7538,7539,7540,7541,7542,7543,7544,7545,7546,7547,7548,7549,7550,7571,7576,7599,7600,7603,7606,7616,7617,7628,7631,7632,7633,7636,7643,7657,7658,7665,7666,7667,7693,7696,7705,7729,7730,7737,7746,7759,7777,7778,7785,7787,7809,7810,7825,7835,7838,7841,7844,7854,7871,7877,7878,7880,7882,7897,7902,7904,7908,7913,7924,7950,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,8041,8045,8046,8047,8051,8052,8053,8054,8056,8059,8064,8116,8118,8119,8127,8132,8134,8137,8138,8140,8141,8142,8143,8147,8149,8150,8153,8154,8156,8170,8176,8179,8181,8185,8189,8198,8199,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8216,8220,8225,8230,8233,8237,8238,8243,8244,8247,8252,8253,8261,8264,8265,8270,8271,8273,8274,8275,8276,8279,8282,8283,8285,8286,8287,8289,8293,8295,8296,8297,8302,8303,8304,8313,8321,8322,8328,8332,8334,8346,8347,8352,8353,8357,8386,8394,8426,8432,8445,8448,8451,8503,8505,8550,8555,8559,8562,8564,8568,8583,8584,8594,8602,8605,8633,8639,8664,8672,8732,8764,8776,8801,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,8862,8873,8884,8895,8897,8908,8945,8959,8967,8970,8973,9064,9083,9088,9129,9131,9155,9159,9164,9168,9174,9177,9202,9206,9210,9217,9218,9219,9224,9225,9230,9231,9232,9547,9552,9556,9557,9564,9587,9647,9649,9655,9698,9739,9777,9784,9787,9822,9834,9835,9847,9895,9909,9920,9932,9942,9943,9951,9961,9962,9963,9987,9999,10008,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10085,10086,10129,10140,10169,10217,10224)
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 | 0.66 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.32 ms |
| Optimizing | 0.39 ms |
| Statistics | 0.21 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.47 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 65.38 ms |
| Creating sort index | 1.44 ms |
| Removing tmp table | 4.71 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.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.13 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 |
