Temps de requête : 98.57 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.315 MB mémoire avant requête : 4.491 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:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 13:34:46')
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,41,57,100,105,106,129,130,137,152,158,172,199,223,240,268,275,288,302,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,440,448,451,472,487,488,489,490,491,496,497,498,499,514,515,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,560,561,562,595,611,635,653,669,702,703,704,705,706,707,774,776,821,822,823,852,928,936,938,939,942,947,954,956,957,969,978,979,980,981,982,983,984,993,996,1005,1020,1036,1040,1041,1042,1072,1073,1091,1092,1097,1099,1101,1103,1104,1109,1110,1111,1115,1120,1129,1163,1173,1178,1179,1180,1182,1217,1219,1223,1226,1247,1248,1251,1252,1253,1263,1264,1265,1290,1296,1304,1311,1312,1323,1327,1329,1330,1336,1338,1342,1346,1350,1354,1356,1358,1359,1360,1389,1390,1391,1392,1411,1412,1437,2228,2238,2244,2245,2253,2266,2277,2278,2279,2280,2287,2292,2295,2297,2302,2303,2312,2316,2317,2318,2319,2334,2335,2343,2344,2345,2348,2349,2353,2375,2393,2394,2407,2413,2427,2435,2440,2441,2442,2445,2446,2453,2454,2459,2464,2468,2475,2505,2559,2561,2578,2602,2649,2657,2661,2662,2663,2664,2667,2668,2669,2677,2678,2684,2686,2687,2688,2695,2697,2716,2722,2725,2736,2739,2746,2751,2752,2755,2786,2789,2796,2803,2804,2808,2810,2812,2814,2815,2816,2826,2838,2844,2850,2863,2872,2888,2895,2896,2903,2904,2905,2906,2907,2908,2909,2910,2923,2932,2949,2952,2965,2986,2991,2996,2997,2999,3010,3022,3026,3036,3044,3064,3067,3068,3080,3087,3088,3089,3103,3104,3109,3110,3112,3113,3114,3115,3116,3117,3118,3119,3121,3122,3123,3124,3125,3126,3127,3128,3131,3132,3136,3142,3143,3174,3202,3212,3230,3231,3234,3241,3244,3249,3250,3260,3307,3314,3318,3319,3321,3324,3325,3326,3327,3336,3337,3348,3353,3354,3355,3356,3357,3358,3364,3379,3381,3382,3383,3384,3385,3386,3387,3389,3390,3391,3397,3401,3405,3410,3422,3425,3427,3431,3456,3459,3467,3476,3477,3478,3479,3480,3481,3482,3483,3484,3485,3520,3521,3523,3524,3526,3527,3528,3533,3551,3611,3612,3613,3614,3659,3665,3675,3684,3685,3700,3704,3707,3709,3726,3756,3759,3767,3768,3811,3821,3822,3823,3824,3825,3826,3830,3839,3840,3846,3865,3885,3889,3890,3891,3899,3905,3914,3915,3918,3919,3920,3921,3931,3932,3936,3938,3939,3950,3953,3957,3964,3975,3987,3991,4005,4006,4024,4026,4031,4032,4053,4068,4073,4095,4109,4120,4123,4137,4153,4154,4169,4177,4178,4181,4183,4184,4194,4195,4214,4215,4217,4218,4219,4229,4230,4246,4247,4252,4266,4268,4281,4296,4297,4300,4302,4305,4306,4307,4309,4310,4311,4312,4315,4316,4318,4321,4322,4330,4337,4341,4344,4352,4363,4389,4390,4407,4408,4420,4442,4451,4470,4472,4476,4478,4505,4509,4511,4512,4515,4522,4532,4533,4539,4542,4564,4565,4566,4581,4584,4585,4594,4602,4626,4633,4634,4637,4646,4647,4657,4674,4686,4693,4730,4750,4767,4778,4781,4783,4787,4805,4807,4808,4828,4830,4842,4845,4854,4858,4862,4868,4869,4874,4881,4882,4883,4885,4888,4890,4896,4920,4925,4926,4929,4937,4938,4942,4944,4952,4955,4956,4957,4958,4959,4962,4964,4966,4970,4971,4972,4975,4977,4979,4980,4981,4985,4986,4987,4988,4989,4990,4995,4996,4997,5001,5002,5003,5004,5006,5010,5011,5012,5014,5026,5029,5032,5034,5035,5045,5046,5047,5048,5049,5051,5052,5053,5056,5057,5063,5064,5089,5094,5100,5101,5102,5103,5111,5112,5117,5120,5149,5150,5152,5153,5155,5156,5157,5163,5164,5172,5173,5174,5191,5192,5194,5196,5200,5204,5212,5216,5218,5224,5225,5227,5229,5233,5234,5235,5236,5238,5240,5244,5247,5266,5281,5285,5293,5299,5301,5302,5303,5313,5315,5316,5317,5327,5333,5337,5353,5358,5367,5376,5387,5393,5394,5405,5416,5446,5458,5459,5466,5467,5472,5498,5499,5500,5501,5502,5520,5532,5541,5552,5557,5566,5570,5571,5574,5586,5592,5596,5597,5599,5601,5618,5619,5625,5638,5653,5658,5659,5664,5669,5707,5712,5716,5732,5733,5734,5735,5739,5740,5752,5753,5766,5777,5779,5780,5781,5782,5790,5792,5793,5794,5795,5796,5797,5799,5800,5801,5803,5804,5808,5811,5824,5850,5851,5856,5860,5863,5879,5888,5892,5896,5897,5913,5914,5924,5956,5960,5965,5983,5984,5992,5993,6000,6010,6014,6019,6020,6021,6027,6032,6059,6068,6069,6076,6094,6095,6098,6101,6102,6106,6120,6121,6122,6123,6124,6126,6127,6129,6130,6132,6133,6135,6140,6142,6147,6150,6154,6166,6167,6168,6172,6173,6176,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6209,6210,6211,6212,6216,6217,6224,6234,6275,6276,6278,6279,6303,6304,6305,6312,6313,6315,6317,6318,6319,6322,6323,6324,6325,6326,6328,6329,6330,6331,6332,6333,6334,6335,6338,6343,6344,6347,6357,6359,6361,6363,6365,6376,6379,6381,6388,6390,6391,6392,6393,6405,6406,6408,6411,6412,6414,6422,6426,6430,6432,6448,6449,6450,6462,6463,6466,6467,6471,6476,6479,6481,6492,6504,6505,6508,6511,6520,6522,6523,6528,6548,6549,6550,6552,6554,6556,6557,6562,6565,6566,6581,6588,6589,6591,6606,6608,6609,6610,6611,6613,6638,6641,6642,6643,6650,6657,6658,6659,6660,6663,6664,6665,6666,6673,6680,6681,6683,6684,6685,6687,6690,6693,6695,6699,6706,6709,6710,6715,6716,6720,6721,6722,6724,6731,6754,6756,6761,6763,6764,6765,6767,6770,6772,6777,6778,6780,6781,6782,6784,6788,6789,6790,6791,6793,6794,6801,6802,6808,6811,6813,6819,6822,6827,6829,6832,6839,6840,6847,6850,6851,6852,6855,6861,6862,6883,6884,6886,6889,6892,6893,6895,6897,6903,6904,6907,6909,6910,6914,6917,6918,6920,6921,6923,6925,6926,6929,6931,6933,6938,6943,6949,6950,6952,6960,6961,6965,6968,6981,6989,6990,6991,6999,7001,7007,7008,7013,7014,7015,7020,7021,7027,7032,7033,7034,7035,7038,7039,7048,7052,7054,7055,7056,7057,7061,7073,7079,7081,7083,7084,7085,7087,7088,7089,7095,7097,7100,7101,7106,7110,7111,7112,7114,7118,7119,7121,7122,7125,7130,7132,7133,7139,7142,7143,7148,7149,7150,7152,7161,7166,7167,7182,7184,7187,7191,7194,7196,7200,7201,7207,7208,7233,7234,7240,7251,7253,7254,7255,7275,7277,7282,7289,7291,7295,7296,7298,7308,7310,7313,7314,7317,7326,7335,7336,7337,7342,7352,7353,7354,7355,7362,7365,7373,7374,7375,7376,7378,7383,7384,7387,7389,7390,7394,7395,7416,7419,7420,7421,7423,7424,7428,7436,7442,7445,7446,7447,7456,7459,7460,7464,7466,7481,7501,7508,7509,7510,7513,7515,7521,7525,7527,7528,7530,7534,7544,7551,7566,7572,7575,7581,7587,7588,7592,7595,7624,7625,7630,7634,7635,7642,7643,7644,7660,7664,7672,7673,7678,7681,7682,7688,7692,7695,7708,7709,7713,7716,7721,7722,7724,7732,7738,7739,7740,7744,7745,7746,7748,7754,7755,7756,7768,7775,7783,7788,7794,7795,7798,7800,7804,7805,7817,7818,7819,7820,7834,7837,7840,7841,7842,7843,7848,7849,7856,7869,7881,7886,7890,7893,7895,7901,7909,7914,7916,7918,7919,7922,7925,7927,7929,7931,7934,7936,7941,7945,7951,7952,7961,7963,7967,8010,8018,8021,8026,8027,8035,8050,8051,8052,8055,8057,8060,8076,8079,8083,8084,8085,8086,8088,8095,8096,8098,8103,8104,8105,8106,8110,8111,8117,8129,8145,8151,8154,8155,8158,8159,8193,8212,8214,8218,8219,8245,8254,8263,8277,8280,8287,8292,8294,8298,8300,8326,8335,8358,8360,8363,8366,8367,8369,8373,8374,8375,8382,8387,8389,8401,8402,8404,8405,8413,8415,8418,8419,8421,8422,8423,8424,8430,8436,8437,8438,8444,8448,8452,8457,8464,8468,8474,8483,8485,8501,8511,8518,8525,8526,8528,8529,8538,8539,8544,8561,8572,8573,8575,8577,8579,8580,8587,8591,8596,8597,8602,8609,8616,8625,8626,8628,8634,8641,8644,8645,8646,8653,8655,8660,8665,8666,8668,8671,8677,8678,8682,8685,8686,8689,8690,8692,8694,8695,8696,8704,8705,8708,8711,8715,8717,8723,8727,8728,8729,8730,8734,8736,8737,8742,8743,8744,8753,8754,8755,8756,8760,8761,8765,8771,8773,8785,8798,8799,8802,8839,8840,8841,8842,8844,8845,8846,8847,8853,8854,8865,8866,8868,8879,8881,8883,8885,8886,8890,8893,8894,8899,8903,8904,8911,8914,8918,8919,8920,8921,8924,8925,8926,8928,8935,8937,8938,8939,8944,8946,8971,8974,8976,8977,8993,9006,9018,9019,9020,9023,9025,9027,9028,9029,9031,9044,9045,9046,9048,9055,9056,9059,9061,9062,9065,9066,9067,9068,9069,9070,9071,9072,9073,9074,9075,9076,9079,9085,9086,9087,9090,9092,9095,9096,9097,9098,9099,9100,9101,9102,9103,9104,9105,9106,9107,9108,9109,9118,9119,9120,9121,9122,9123,9124,9125,9126,9127,9129,9130,9134,9136,9137,9138,9139,9140,9141,9164,9173,9176,9181,9184,9185,9186,9187,9190,9191,9192,9201,9203,9207,9211,9212,9213,9222,9233,9542,9543,9544,9545,9547,9551,9553,9554,9555,9558,9559,9560,9562,9565,9568,9574,9575,9576,9577,9578,9579,9580,9581,9582,9583,9584,9591,9592,9596,9597,9598,9599,9600,9606,9610,9612,9617,9626,9634,9635,9636,9638,9639,9642,9643,9644,9645,9646,9656,9658,9660,9682,9685,9690,9700,9701,9709,9719,9724,9728,9736,9738,9742,9746,9748,9754,9758,9761,9762,9763,9766,9767,9768,9773,9774,9775,9782,9789,9798,9805,9806,9807,9809,9810,9819,9820,9821,9826,9838,9842,9846,9849,9851,9859,9862,9868,9873,9874,9880,9881,9882,9884,9892,9893,9897,9898,9901,9904,9910,9911,9914,9917,9923,9924,9927,9928,9929,9935,9936,9940,9947,9958,9959,9960,9968,9969,9970,9977,9980,9988,9989,9993,9995,9997,9998,10038,10041,10042,10043,10045,10046,10047,10048,10054,10055,10061,10064,10066,10067,10068,10070,10071,10072,10073,10075,10083,10104,10105,10107,10113,10129,10132,10133,10138,10145,10146,10162,10163,10173,10175,10180,10182,10183,10187,10188,10190,10196,10219,10225,10228,10233,10250,10251,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.32 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.59 ms |
| Optimizing | 0.63 ms |
| Statistics | 0.37 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 14.49 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 74.90 ms |
| Creating sort index | 2.16 ms |
| Removing tmp table | 3.28 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.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.13 ms |
| Updating status | 0.04 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 |
