Temps de requête : 87.62 ms Après la dernière requête : 2.35 ms Mémoire de requête : 0.140 MB mémoire avant requête : 4.521 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:34:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 13:34:08')
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(15,102,148,181,193,200,231,237,243,244,245,246,247,250,254,257,258,276,278,281,282,285,286,289,290,291,293,294,295,296,297,298,303,307,309,311,313,314,318,457,458,461,462,463,464,465,466,467,501,502,516,570,571,572,585,594,600,601,602,603,608,614,615,616,620,623,624,625,626,654,655,656,657,658,659,660,661,662,663,664,665,682,683,684,708,709,710,726,767,768,769,770,771,772,773,774,775,776,783,855,912,930,931,932,935,974,976,1007,1009,1014,1016,1019,1026,1037,1071,1093,1121,1142,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1215,1216,1217,1218,1220,1221,1222,1223,1227,1235,1241,1242,1243,1250,1255,1260,1268,1271,1274,1299,1300,1307,1308,1311,1313,1321,1322,1340,1344,1345,1394,1397,1398,1399,1400,1406,1407,1413,1414,1431,1432,1436,1438,2073,2152,2156,2205,2210,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2225,2234,2235,2254,2260,2262,2275,2282,2296,2309,2319,2320,2325,2330,2333,2335,2337,2347,2355,2356,2370,2374,2378,2386,2398,2400,2401,2402,2436,2451,2553,2572,2574,2582,2603,2644,2645,2663,2665,2679,2680,2702,2711,2713,2724,2737,2741,2742,2748,2756,2764,2793,2795,2810,2811,2814,2831,2841,2869,2870,2871,2878,2922,2925,2926,2927,2928,2934,2935,2936,2948,2964,2985,3000,3001,3003,3006,3009,3020,3024,3026,3031,3032,3036,3039,3043,3058,3063,3078,3086,3095,3097,3098,3099,3133,3159,3160,3161,3162,3163,3164,3165,3168,3175,3180,3181,3182,3189,3192,3218,3222,3229,3237,3238,3239,3244,3252,3254,3257,3263,3264,3267,3303,3308,3335,3338,3339,3353,3363,3369,3371,3392,3393,3397,3399,3401,3402,3428,3430,3439,3441,3443,3447,3452,3460,3461,3466,3474,3475,3489,3491,3492,3503,3512,3513,3514,3515,3518,3529,3537,3538,3539,3544,3557,3564,3573,3574,3575,3577,3579,3580,3600,3615,3616,3622,3623,3634,3638,3646,3656,3657,3672,3678,3680,3681,3682,3687,3693,3695,3696,3697,3710,3711,3716,3722,3735,3752,3754,3755,3759,3760,3765,3769,3773,3774,3779,3789,3793,3794,3806,3810,3813,3829,3832,3833,3834,3835,3845,3854,3861,3864,3871,3878,3895,3896,3922,3923,3933,3946,3980,3985,3987,4002,4005,4006,4008,4018,4019,4022,4033,4036,4044,4062,4063,4066,4074,4075,4076,4077,4094,4099,4122,4131,4135,4138,4150,4152,4176,4179,4186,4187,4188,4189,4192,4206,4210,4221,4224,4228,4234,4244,4245,4253,4258,4261,4274,4276,4282,4295,4298,4299,4314,4320,4329,4331,4332,4333,4334,4336,4339,4351,4353,4355,4358,4365,4380,4383,4385,4400,4405,4406,4410,4416,4418,4426,4429,4431,4467,4480,4481,4484,4492,4496,4499,4500,4513,4520,4521,4548,4555,4575,4576,4582,4586,4587,4588,4591,4592,4593,4594,4595,4596,4597,4598,4599,4600,4601,4610,4611,4617,4618,4620,4624,4628,4630,4632,4635,4636,4645,4654,4655,4658,4659,4660,4661,4662,4666,4667,4668,4669,4670,4673,4675,4676,4679,4681,4684,4685,4688,4689,4690,4695,4696,4697,4699,4700,4701,4704,4706,4709,4710,4711,4714,4715,4716,4724,4731,4734,4735,4740,4742,4744,4753,4754,4758,4768,4782,4794,4802,4806,4810,4823,4824,4837,4842,4843,4844,4850,4853,4868,4869,4870,4893,4896,4902,4904,4914,4915,4928,4936,4965,4968,4974,4980,4982,4986,5003,5004,5015,5019,5024,5028,5030,5031,5036,5037,5038,5039,5042,5044,5050,5054,5062,5065,5066,5067,5068,5071,5072,5073,5074,5086,5091,5092,5096,5106,5108,5110,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,5151,5153,5166,5167,5173,5181,5182,5197,5204,5207,5208,5214,5216,5220,5221,5222,5223,5230,5237,5240,5243,5248,5255,5256,5258,5260,5261,5263,5265,5267,5269,5270,5275,5278,5279,5280,5282,5283,5286,5287,5288,5289,5290,5294,5295,5297,5298,5307,5314,5315,5320,5321,5322,5324,5330,5338,5342,5348,5349,5350,5352,5357,5362,5364,5371,5375,5377,5390,5393,5396,5406,5413,5414,5421,5422,5427,5430,5434,5435,5447,5448,5456,5457,5458,5460,5463,5464,5465,5468,5471,5475,5479,5480,5481,5482,5485,5492,5493,5496,5497,5511,5518,5521,5522,5523,5525,5528,5529,5530,5531,5534,5536,5538,5544,5546,5548,5551,5552,5553,5554,5558,5568,5569,5573,5574,5575,5576,5577,5579,5580,5587,5588,5593,5597,5598,5599,5602,5603,5604,5605,5606,5607,5609,5614,5615,5617,5621,5622,5623,5626,5627,5631,5632,5633,5636,5637,5639,5640,5643,5644,5646,5650,5651,5652,5653,5654,5655,5656,5660,5664,5665,5678,5679,5680,5696,5698,5702,5704,5713,5714,5717,5720,5724,5725,5726,5728,5735,5736,5738,5741,5755,5757,5758,5759,5761,5764,5766,5773,5778,5783,5785,5787,5788,5789,5802,5807,5809,5818,5819,5825,5838,5847,5875,5876,5878,5890,5894,5898,5901,5903,5904,5905,5906,5907,5908,5911,5919,5920,5925,5926,5927,5934,5935,5936,5937,5938,5939,5940,5943,5954,5955,5959,5960,5962,5963,5964,5975,5978,5985,5986,5990,5998,5999,6005,6007,6010,6020,6023,6024,6034,6039,6041,6042,6043,6044,6045,6046,6047,6048,6049,6056,6071,6081,6088,6089,6090,6097,6102,6107,6111,6116,6158,6159,6160,6170,6177,6194,6195,6196,6197,6199,6200,6201,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,6262,6266,6268,6269,6272,6280,6283,6288,6300,6301,6302,6303,6309,6310,6314,6321,6336,6339,6345,6346,6361,6364,6395,6396,6399,6402,6422,6429,6440,6453,6469,6474,6475,6477,6478,6482,6495,6514,6523,6537,6558,6567,6580,6599,6676,6688,6689,6695,6709,6722,6739,6743,6748,6751,6762,6767,6771,6782,6800,6807,6809,6816,6821,6834,6838,6853,6876,6877,6888,6898,6904,6925,6933,6935,6936,6942,6944,6950,6951,6982,6983,6984,6985,6986,6994,7009,7010,7032,7039,7048,7053,7058,7063,7074,7134,7146,7162,7165,7175,7180,7190,7193,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,7243,7245,7248,7256,7264,7278,7279,7280,7287,7296,7297,7307,7312,7316,7321,7322,7323,7324,7325,7329,7343,7350,7351,7357,7360,7381,7382,7386,7388,7392,7396,7400,7401,7432,7435,7444,7452,7476,7482,7484,7504,7507,7513,7514,7519,7520,7522,7523,7526,7528,7529,7533,7537,7538,7539,7540,7541,7542,7543,7544,7545,7546,7547,7548,7549,7550,7563,7571,7576,7582,7596,7599,7600,7603,7606,7612,7616,7617,7619,7628,7631,7632,7633,7636,7644,7647,7657,7658,7665,7666,7667,7668,7671,7676,7677,7693,7696,7705,7718,7719,7729,7730,7731,7737,7746,7777,7778,7785,7787,7794,7796,7797,7809,7810,7825,7832,7833,7835,7838,7841,7844,7845,7847,7854,7857,7867,7871,7875,7877,7878,7880,7882,7895,7897,7901,7902,7908,7909,7913,7924,7932,7956,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,8011,8016,8017,8028,8034,8041,8045,8046,8047,8048,8053,8055,8056,8069,8070,8071,8076,8087,8091,8096,8099,8113,8116,8118,8119,8125,8126,8127,8132,8134,8137,8138,8140,8141,8142,8143,8147,8149,8150,8153,8156,8157,8164,8170,8176,8177,8178,8179,8186,8187,8189,8190,8191,8192,8196,8198,8199,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8216,8220,8225,8230,8231,8232,8233,8235,8242,8243,8244,8247,8252,8253,8256,8261,8264,8265,8267,8268,8270,8271,8273,8274,8275,8276,8277,8279,8282,8283,8285,8286,8287,8289,8293,8295,8296,8297,8299,8300,8302,8303,8304,8313,8321,8322,8328,8332,8334,8337,8338,8340,8341,8346,8347,8352,8353,8356,8357,8381,8386,8392,8393,8394,8395,8401,8404,8425,8426,8427,8429,8432,8435,8441,8443,8445,8446,8447,8449,8451,8454,8455,8456,8457,8458,8459,8465,8469,8478,8482,8484,8488,8489,8491,8493,8498,8503,8505,8508,8510,8514,8516,8519,8521,8527,8534,8535,8540,8543,8548,8550,8553,8555,8558,8559,8562,8563,8564,8568,8569,8570,8571,8574,8578,8583,8588,8589,8594,8598,8599,8600,8601,8602,8604,8605,8608,8614,8615,8617,8620,8621,8622,8624,8629,8631,8632,8633,8639,8640,8642,8647,8652,8661,8662,8664,8672,8673,8675,8683,8688,8697,8698,8700,8714,8717,8719,8722,8731,8733,8734,8751,8752,8759,8764,8769,8772,8777,8783,8786,8801,8806,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,8851,8857,8858,8862,8870,8873,8877,8882,8884,8895,8897,8908,8909,8931,8932,8937,8945,8950,8951,8953,8959,8960,8965,8966,8967,8970,8972,8973,8978,8979,8982,8985,8986,8987,9009,9011,9017,9057,9064,9083,9088,9093,9115,9129,9131,9133,9155,9159,9164,9173,9174,9177,9180,9202,9205,9206,9210,9217,9218,9219,9224,9225,9230,9231,9232,9547,9552,9555,9556,9557,9564,9569,9587,9626,9629,9647,9649,9655,9739,9744,9777,9784,9787,9816,9822,9834,9835,9847,9872,9895,9909,9920,9932,9940,9942,9943,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,10040,10053,10076,10089,10095,10100,10127,10164,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|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 | 0.62 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.31 ms |
| Statistics | 0.20 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 9.07 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 69.08 ms |
| Creating sort index | 1.72 ms |
| Removing tmp table | 5.68 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.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.13 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 |