Temps de requête : 97.49 ms Après la dernière requête : 1.20 ms Mémoire de requête : 0.550 MB mémoire avant requête : 4.549 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 10:55:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 10:55:23')
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(11,18,19,20,32,33,34,141,232,233,234,235,236,261,262,263,265,279,280,292,316,321,322,323,324,325,326,327,503,504,505,506,507,508,509,510,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,574,575,576,577,578,579,580,581,582,583,584,604,605,606,610,617,618,619,627,628,629,630,631,632,633,634,647,648,674,693,694,695,696,697,698,699,700,701,717,718,719,720,721,722,723,724,725,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,750,751,752,753,754,755,756,757,758,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,856,857,858,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,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,913,914,915,916,918,919,920,921,922,923,924,925,926,927,949,950,963,964,965,966,967,985,986,987,988,989,990,991,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1102,1105,1106,1136,1137,1138,1139,1140,1141,1159,1160,1166,1215,1266,1267,1278,1282,1285,1286,1287,1288,1289,1298,1307,1308,1309,1314,1315,1316,1348,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1384,1385,1386,1387,1388,1408,1409,1410,2247,2248,2249,2251,2273,2274,2281,2282,2283,2284,2288,2291,2305,2306,2322,2339,2363,2364,2408,2409,2410,2411,2417,2418,2429,2430,2431,2432,2437,2506,2507,2508,2567,2671,2672,2673,2674,2675,2696,2717,2718,2720,2721,2726,2727,2735,2792,2827,2829,2830,2831,2832,2833,2847,2848,2852,2853,2857,2858,2859,2867,2877,2884,2893,2918,2937,2938,2941,2942,2944,2964,2972,2973,2974,2975,2981,2982,2987,2989,3027,3028,3032,3043,3047,3048,3049,3055,3056,3060,3061,3062,3069,3070,3071,3072,3073,3074,3075,3107,3111,3156,3176,3177,3186,3188,3190,3191,3194,3195,3196,3203,3205,3206,3208,3216,3235,3255,3258,3274,3275,3276,3277,3278,3279,3282,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3295,3299,3300,3301,3305,3309,3310,3311,3312,3320,3322,3331,3332,3360,3388,3392,3406,3408,3415,3416,3417,3421,3424,3432,3433,3434,3435,3436,3437,3438,3440,3445,3446,3451,3452,3457,3464,3472,3475,3501,3502,3503,3504,3505,3506,3515,3564,3624,3625,3626,3628,3629,3630,3632,3633,3641,3657,3662,3663,3664,3666,3676,3678,3687,3688,3717,3718,3734,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3753,3757,3758,3763,3764,3766,3772,3780,3781,3788,3804,3832,3888,3894,3897,3898,3906,3907,3908,3909,3910,3911,3913,3925,3942,3943,3945,3947,3948,3954,3958,3980,3985,3987,4002,4038,4045,4046,4047,4048,4049,4050,4052,4054,4055,4056,4057,4058,4059,4060,4061,4062,4063,4071,4072,4077,4078,4079,4080,4081,4086,4087,4088,4091,4097,4101,4104,4114,4140,4141,4142,4145,4146,4147,4155,4158,4159,4160,4161,4162,4163,4164,4166,4167,4168,4171,4180,4185,4186,4187,4200,4201,4202,4203,4204,4210,4211,4220,4222,4236,4245,4264,4272,4277,4304,4336,4364,4369,4370,4371,4372,4373,4374,4375,4376,4377,4378,4379,4391,4392,4393,4394,4395,4396,4397,4398,4399,4412,4417,4435,4436,4437,4438,4439,4454,4455,4456,4460,4462,4464,4477,4487,4488,4489,4492,4498,4502,4503,4504,4516,4517,4518,4538,4559,4560,4561,4562,4563,4567,4568,4569,4570,4571,4572,4573,4574,4577,4579,4582,4583,4586,4589,4590,4592,4600,4603,4606,4619,4624,4627,4650,4651,4656,4664,4665,4666,4667,4677,4680,4705,4711,4712,4713,4734,4747,4748,4752,4753,4756,4758,4759,4760,4764,4765,4766,4772,4773,4774,4779,4784,4785,4788,4794,4795,4803,4804,4810,4811,4812,4813,4819,4825,4826,4827,4831,4846,4847,4848,4849,4878,4879,4897,4898,4907,4908,4909,4910,4911,4912,4913,4921,4922,4923,4924,4935,4946,4947,4948,4949,4950,4951,4960,4965,4973,4974,4976,4983,5008,5009,5013,5017,5020,5021,5022,5025,5044,5059,5060,5075,5076,5077,5078,5079,5080,5081,5082,5083,5084,5088,5090,5091,5104,5114,5115,5118,5148,5170,5175,5176,5177,5178,5179,5180,5181,5182,5183,5184,5185,5186,5187,5188,5189,5190,5202,5264,5292,5294,5305,5308,5323,5325,5326,5328,5338,5339,5356,5360,5390,5391,5409,5415,5434,5435,5436,5437,5438,5439,5440,5441,5442,5443,5444,5445,5450,5451,5452,5453,5454,5455,5476,5483,5484,5485,5494,5505,5509,5513,5514,5527,5533,5575,5581,5582,5611,5661,5667,5668,5678,5679,5680,5681,5682,5683,5684,5685,5687,5688,5689,5690,5691,5692,5693,5694,5695,5697,5699,5700,5701,5708,5709,5736,5737,5743,5744,5745,5746,5747,5748,5749,5750,5751,5754,5756,5762,5765,5768,5769,5770,5771,5773,5775,5776,5786,5898,5899,5900,5901,5906,5907,5908,5909,5928,5929,5930,5945,5946,5947,5948,5949,5950,5951,5952,5957,5958,6001,6003,6004,6005,6064,6065,6072,6084,6085,6087,6099,6108,6109,6110,6113,6114,6136,6143,6144,6145,6146,6157,6158,6159,6160,6161,6162,6163,6164,6165,6170,6178,6179,6186,6187,6188,6189,6190,6192,6225,6226,6227,6228,6282,6297,6298,6348,6379,6403,6420,6442,6443,6444,6445,6446,6447,6448,6453,6457,6458,6459,6460,6461,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6491,6509,6512,6513,6514,6534,6536,6538,6539,6540,6541,6543,6544,6545,6546,6547,6571,6572,6573,6574,6575,6576,6577,6578,6579,6580,6584,6586,6594,6595,6596,6597,6598,6599,6600,6601,6602,6603,6604,6605,6612,6648,6652,6671,6672,6688,6689,6692,6713,6741,6742,6743,6744,6745,6746,6773,6774,6803,6804,6809,6826,6856,6864,6865,6866,6867,6878,6879,6880,6881,6882,6899,6900,6901,6911,6912,6913,6916,6932,6934,6935,6936,6940,6941,6957,6958,6959,6969,6970,6971,6972,6973,6974,6975,6976,6977,6979,6993,6994,6995,6996,6997,7000,7012,7045,7046,7047,7049,7050,7051,7059,7060,7062,7063,7077,7078,7084,7085,7092,7097,7098,7102,7104,7109,7116,7120,7135,7136,7139,7155,7156,7157,7164,7169,7170,7171,7172,7173,7174,7175,7176,7177,7178,7179,7180,7181,7204,7236,7238,7252,7257,7263,7271,7272,7273,7274,7292,7377,7396,7397,7398,7399,7400,7401,7402,7403,7404,7405,7406,7407,7408,7409,7410,7425,7426,7427,7429,7430,7431,7439,7449,7451,7452,7453,7457,7458,7469,7475,7476,7477,7478,7479,7480,7487,7488,7489,7502,7519,7553,7554,7555,7556,7557,7559,7560,7567,7568,7569,7574,7579,7580,7584,7585,7586,7589,7590,7594,7597,7604,7620,7637,7638,7639,7641,7665,7691,7694,7703,7704,7705,7706,7707,7712,7719,7720,7734,7735,7736,7737,7740,7747,7750,7751,7752,7760,7762,7764,7777,7782,7791,7801,7802,7803,7811,7835,7846,7850,7858,7859,7860,7861,7862,7866,7873,7874,7875,7876,7877,7884,7889,7894,7897,7905,7906,7908,7910,7933,7938,7939,7943,7957,7958,7962,7964,7968,7969,7970,7973,7977,8012,8013,8014,8015,8016,8033,8034,8036,8038,8040,8044,8078,8080,8081,8082,8101,8130,8160,8165,8167,8168,8169,8171,8172,8173,8182,8183,8188,8196,8197,8213,8222,8224,8226,8228,8232,8240,8241,8249,8255,8256,8257,8258,8259,8260,8266,8269,8278,8301,8305,8309,8313,8314,8315,8316,8317,8318,8319,8330,8333,8344,8345,8349,8351,8361,8362,8364,8365,8371,8372,8379,8396,8397,8398,8399,8410,8417,8442,8450,8453,8461,8462,8463,8466,8471,8475,8481,8486,8490,8492,8496,8497,8499,8500,8502,8504,8506,8509,8523,8524,8530,8531,8532,8565,8566,8567,8576,8592,8610,8618,8633,8648,8649,8650,8651,8657,8658,8659,8663,8670,8680,8681,8684,8691,8693,8699,8701,8702,8706,8710,8718,8746,8747,8748,8749,8750,8762,8763,8764,8768,8788,8790,8791,8792,8793,8794,8795,8800,8803,8806,8852,8860,8863,8872,8874,8875,8876,8889,8891,8892,8895,8915,8916,8927,8933,8934,8950,8954,8955,8956,8969,8975,8978,8980,8983,8989,8990,8991,9007,9008,9009,9013,9014,9015,9024,9026,9030,9032,9047,9052,9053,9054,9060,9110,9114,9115,9117,9143,9145,9146,9149,9150,9151,9152,9154,9156,9157,9158,9160,9161,9162,9166,9170,9171,9172,9178,9183,9188,9189,9194,9195,9209,9214,9215,9216,9220,9223,9227,9228,9229,9563,9570,9571,9585,9586,9594,9595,9601,9602,9603,9604,9605,9609,9618,9622,9624,9633,9641,9650,9653,9655,9663,9666,9674,9675,9676,9677,9678,9679,9683,9695,9699,9717,9718,9721,9722,9724,9741,9748,9753,9785,9786,9787,9793,9794,9797,9800,9801,9802,9803,9804,9811,9812,9817,9818,9822,9823,9824,9825,9828,9830,9836,9837,9841,9845,9847,9852,9853,9855,9861,9867,9876,9877,9878,9879,9883,9885,9886,9888,9899,9918,9919,9921,9926,9930,9931,9933,9934,9937,9939,9949,9950,9954,9970,9971,9972,9975,9976,9990,9991,10000,10001,10002,10004,10006,10011,10013,10014,10015,10016,10049,10052,10062,10063,10113,10125,10126,10146,10151,10162,10200,10273)
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 | 0.64 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.31 ms |
| Optimizing | 0.32 ms |
| Statistics | 0.19 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.46 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 90.60 ms |
| Creating sort index | 3.48 ms |
| Removing tmp table | 0.95 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.12 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 |