Temps de requête : 103.25 ms Après la dernière requête : 2.06 ms Mémoire de requête : 0.072 MB mémoire avant requête : 4.554 MB Rangées retournées : 5
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 11:36:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-10 11:36:49')
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(13,14,17,23,24,37,101,128,131,135,144,149,150,191,198,212,213,239,242,249,254,259,267,268,287,301,315,319,345,447,448,449,483,484,487,488,489,490,491,492,493,557,558,591,592,659,663,668,669,692,702,706,707,708,712,765,909,917,940,961,971,979,980,981,983,998,1022,1048,1074,1096,1100,1117,1128,1132,1161,1175,1181,1200,1203,1210,1211,1226,1234,1236,1240,1258,1269,1277,1295,1297,1306,1307,1308,1317,1318,1327,1328,1341,1352,1356,1358,1359,1360,1389,1390,1391,1392,1400,1415,1416,1424,1433,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2237,2241,2246,2253,2255,2263,2294,2303,2310,2313,2314,2315,2324,2337,2347,2354,2362,2371,2376,2388,2389,2393,2395,2396,2398,2400,2402,2404,2407,2412,2419,2420,2425,2436,2445,2447,2449,2450,2456,2462,2471,2477,2480,2481,2505,2523,2530,2536,2553,2557,2558,2562,2575,2578,2581,2583,2584,2598,2599,2602,2611,2650,2652,2666,2670,2678,2686,2689,2691,2703,2712,2713,2716,2719,2738,2745,2747,2755,2760,2787,2789,2791,2793,2796,2802,2812,2816,2821,2838,2839,2849,2850,2865,2881,2886,2889,2900,2913,2919,2925,2927,2929,2951,2952,2953,2967,2968,2978,2981,2985,2988,2989,2992,3000,3010,3018,3020,3031,3035,3040,3044,3053,3078,3079,3081,3082,3083,3085,3089,3095,3096,3112,3115,3131,3132,3168,3169,3178,3179,3191,3193,3201,3207,3208,3217,3218,3229,3236,3247,3248,3252,3257,3261,3265,3266,3283,3284,3285,3286,3288,3289,3290,3291,3292,3293,3302,3306,3326,3334,3335,3338,3353,3354,3368,3381,3383,3384,3385,3388,3390,3393,3404,3414,3447,3450,3466,3489,3516,3540,3554,3586,3598,3617,3637,3648,3671,3678,3683,3695,3706,3708,3752,3759,3769,3792,3810,3829,3834,3850,3853,3875,3876,3879,3880,3886,3887,3893,3899,3901,3902,3903,3912,3915,3924,3931,3932,3935,3937,3946,3959,3965,3966,3967,3974,3976,3979,3986,3988,3989,3990,3992,3994,3995,3996,3997,3998,4008,4010,4011,4022,4025,4030,4032,4037,4039,4074,4081,4092,4096,4112,4113,4143,4150,4157,4170,4205,4233,4234,4241,4256,4262,4275,4280,4299,4306,4313,4321,4338,4347,4366,4368,4404,4430,4457,4459,4468,4483,4485,4486,4497,4513,4541,4547,4552,4555,4556,4558,4583,4601,4602,4610,4617,4620,4632,4637,4643,4645,4649,4652,4654,4655,4659,4661,4662,4663,4671,4675,4683,4684,4688,4689,4707,4715,4732,4742,4755,4757,4759,4766,4770,4775,4776,4777,4786,4793,4796,4797,4798,4799,4815,4816,4817,4822,4823,4824,4833,4834,4841,4843,4844,4860,4863,4865,4866,4867,4868,4869,4871,4873,4883,4884,4885,4894,4895,4896,4899,4901,4917,4927,4929,4931,4932,4933,4937,4938,4941,4944,4945,4953,4956,4957,4963,4964,4971,4978,4979,4985,4990,4992,4996,4997,4999,5004,5005,5010,5014,5023,5024,5026,5042,5043,5044,5046,5047,5053,5061,5062,5072,5086,5087,5096,5105,5106,5107,5116,5117,5153,5154,5155,5157,5163,5171,5172,5183,5185,5188,5194,5199,5203,5204,5222,5229,5237,5238,5240,5244,5245,5246,5259,5263,5266,5268,5269,5271,5272,5290,5291,5296,5299,5302,5318,5319,5330,5331,5337,5351,5352,5360,5373,5374,5375,5380,5381,5384,5385,5386,5396,5397,5412,5413,5414,5416,5417,5418,5419,5420,5423,5426,5432,5447,5448,5456,5466,5467,5469,5470,5474,5480,5481,5491,5495,5496,5509,5511,5512,5531,5550,5551,5553,5566,5577,5578,5606,5608,5609,5633,5634,5645,5649,5650,5665,5666,5671,5703,5711,5716,5717,5719,5720,5727,5740,5741,5742,5754,5757,5763,5764,5765,5783,5784,5786,5806,5807,5834,5835,5867,5899,5921,5943,5983,5992,5994,5995,6061,6062,6075,6115,6131,6170,6194,6213,6214,6229,6262,6268,6269,6271,6272,6273,6280,6296,6327,6328,6388,6389,6403,6404,6405,6410,6411,6424,6428,6430,6431,6449,6450,6451,6456,6474,6475,6510,6511,6555,6568,6581,6582,6590,6675,6676,6707,6726,6730,6731,6737,6747,6750,6775,6782,6783,6795,6797,6799,6805,6809,6812,6815,6830,6836,6841,6846,6848,6853,6858,6859,6869,6885,6886,6890,6898,6904,6905,6924,6925,6927,6939,6943,6945,6947,6948,6953,6954,6958,6959,6988,7051,7059,7064,7073,7074,7075,7094,7095,7104,7108,7125,7126,7151,7152,7184,7205,7236,7247,7264,7265,7280,7311,7312,7316,7349,7368,7369,7385,7391,7392,7393,7413,7417,7418,7433,7441,7443,7444,7454,7468,7484,7485,7506,7507,7510,7523,7524,7532,7533,7576,7577,7593,7602,7603,7607,7633,7657,7696,7697,7698,7723,7749,7752,7758,7764,7768,7769,7771,7772,7773,7780,7781,7786,7787,7806,7807,7808,7825,7826,7828,7838,7845,7848,7852,7853,7854,7858,7860,7862,7872,7873,7876,7882,7883,7895,7899,7910,7912,7913,7923,7927,7928,7933,7941,7979,8009,8019,8020,8089,8091,8128,8133,8134,8135,8160,8172,8175,8176,8181,8220,8221,8232,8251,8252,8256,8261,8262,8272,8273,8281,8290,8297,8303,8317,8340,8347,8348,8391,8392,8408,8409,8426,8434,8435,8469,8470,8512,8515,8516,8531,8540,8541,8557,8558,8559,8594,8595,8605,8620,8621,8623,8624,8642,8643,8716,8717,8732,8734,8735,8773,8782,8783,8807,8808,8810,8843,8861,8862,8870,8895,8904,8905,8910,8922,8923,8924,8931,8952,8967,8988,9002,9003,9021,9022,9032,9059,9083,9088,9089,9128,9129,9164,9165,9196,9546,9547,9548,9553,9560,9561,9567,9573,9574,9606,9607,9608,9613,9614,9616,9623,9638,9648,9652,9656,9657,9658,9659,9661,9662,9664,9665,9667,9668,9669,9670,9671,9673,9680,9681,9684,9686,9687,9688,9689,9694,9697,9701,9702,9703,9704,9705,9706,9707,9710,9711,9712,9713,9714,9715,9716,9719,9720,9723,9725,9726,9727,9731,9732,9736,9737,9740,9743,9745,9747,9749,9755,9757,9758,9759,9760,9764,9769,9771,9778,9779,9780,9781,9783,9792,9802,9813,9814,9815,9829,9834,9840,9847,9848,9854,9857,9860,9862,9869,9881,9888,9891,9909,9915,9932,9941,9943,9962,9974,9987,9999,10007,10069,10071,10078,10083,10088,10102,10112,10133,10168,10188,10223,10229,10243,10257,10261,10272,10273,10278,10283,10288)
ORDER BY i.id DESC
LIMIT 0, 5| 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 | 1.80 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.58 ms |
| Optimizing | 0.68 ms |
| Statistics | 0.31 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.93 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 79.31 ms |
| Creating sort index | 3.90 ms |
| Removing tmp table | 14.90 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.02 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.09 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 |
