زمان پرس و جو: 33.54 ms پس از آخرین پرس و جو: 1.83 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 15.029 MB سطرهای بازگشتی: 1
SELECT MAX(imgdate)
FROM r167e_joomgallery AS a
LEFT JOIN r167e_joomgallery_catg AS c
ON c.cid = a.catid
WHERE a.catid IN (2849,2811,2477,2267,2266,2130,1933,1783,1647,1250,958,957,956,955,954,953,952,951,950,940,938,937,936,935,933,932,931,930,537,512,445,281,280,279,278,277,276,275,274,273,2978,2940,2932,2931,2930,2929,2928,2927,2926,2885,2884,2865,2858,2857,2825,2824,2823,2822,2821,2724,2722,2721,2720,2719,2639,2638,2567,2558,2557,2511,2508,2507,2506,2465,2464,2462,2380,2356,2331,2328,2308,2306,2295,2281,2254,2253,2226,2143,2142,2099,2085,2059,2037,1973,1960,1952,1935,1902,1820,1815,1813,1812,1784,1757,1717,1678,1677,1662,1661,1627,1626,1505,1504,1503,1493,1456,1438,1432,1416,1396,1393,1392,1369,1198,1197,1196,1145,1122,1030,1019,1012,816,784,783,782,781,780,779,778,777,776,775,774,773,772,768,767,766,765,764,763,762,761,760,759,758,757,756,755,754,753,750,749,748,747,746,745,744,742,741,740,739,738,736,734,733,732,730,729,728,633,367,335,334,333,332,331,328,327,326,323,322,321,320,319,318,317,316,315,211,3054,3018,3014,3011,2946,2890,2889,2888,2862,2861,2832,2831,2830,2826,2784,2783,2782,2781,2780,2757,2730,2729,2655,2654,2653,2652,2651,2649,2600,2599,2598,2592,2591,2590,2589,2588,2587,2585,2584,2565,2562,2492,2491,2490,2489,2488,2485,2483,2471,2470,2469,2399,2398,2397,2396,2373,2371,2361,2360,2359,2358,2344,2333,2332,2285,2284,2269,2240,2228,2217,2216,2204,2194,2170,2133,2132,2126,2087,2086,2074,2073,2050,2049,2038,2031,2030,2025,2024,2023,2022,2021,2019,2018,2017,2016,2015,2014,2013,2012,2011,2010,2009,2008,2007,2006,2005,2004,2003,2002,2001,2000,1999,1998,1997,1996,1995,1994,1993,1992,1991,1990,1989,1988,1987,1977,1976,1975,1974,1964,1963,1954,1940,1927,1926,1925,1909,1894,1893,1892,1882,1870,1853,1852,1851,1791,1789,1775,1760,1759,1758,1743,1737,1721,1720,1703,1702,1664,1613,1612,1611,1610,1609,1539,1538,1537,1535,1534,1533,1532,1531,1519,1508,1497,1496,1495,1458,1422,1421,1420,1419,1404,1375,1374,1373,1372,1343,1341,1315,1314,1313,1312,1311,1310,1284,1200,1105,1104,1103,1102,1101,1045,1044,1043,1042,1041,986,964,963,962,961,960,679,666,630,612,611,596,590,589,588,572,567,566,560,513,509,500,444,443,439,435,400,399,373,372,370,369,368,364,363,353,305,66,65,64,63,62,61,60,58,57,56,55,54,53,52,51,50,49,46,44,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,3023,2981,2948,2947,2891,2869,2868,2834,2833,2789,2788,2787,2786,2785,2731,2660,2659,2658,2657,2656,2601,2560,2535,2534,2533,2515,2472,2405,2404,2403,2402,2401,2374,2346,2345,2334,2298,2297,2287,2286,2270,2243,2242,2221,2219,2218,2203,2172,2171,2145,2135,2134,2075,2052,2039,1979,1978,1965,1942,1941,1910,1896,1895,1885,1884,1883,1876,1862,1861,1854,1823,1822,1793,1761,1746,1745,1744,1739,1723,1722,1705,1704,1685,1684,1665,1554,1544,1543,1542,1541,1540,1530,1517,1509,1454,1444,1440,1424,1423,1394,1377,1376,1347,1346,1345,1344,1317,1316,1257,1256,1255,1254,1253,1201,1168,1167,1107,1106,1060,1047,1046,1021,985,984,983,969,968,967,966,965,713,712,597,577,541,540,501,448,391,390,389,388,386,385,381,380,379,378,377,376,375,348,347,179,121,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85,80,79,78,76,74,71,70,69,68,67,3056,3041,3022,2992,2950,2949,2937,2899,2898,2897,2896,2895,2894,2893,2892,2870,2839,2838,2837,2836,2835,2796,2795,2794,2793,2792,2791,2790,2737,2736,2735,2734,2733,2732,2728,2727,2665,2664,2663,2661,2607,2606,2605,2604,2603,2582,2581,2579,2571,2539,2538,2537,2536,2521,2520,2519,2518,2517,2516,2497,2494,2493,2473,2416,2415,2414,2412,2411,2410,2409,2408,2407,2406,2389,2388,2387,2386,2385,2384,2383,2381,2375,2363,2362,2347,2335,2323,2311,2310,2309,2289,2288,2257,2256,2255,2230,2229,2223,2222,2205,2195,2175,2174,2147,2146,2125,2124,2123,2105,2089,2088,2076,2062,2061,2055,2032,1966,1955,1945,1944,1943,1928,1903,1897,1886,1855,1828,1827,1826,1825,1803,1795,1794,1776,1774,1762,1749,1747,1740,1727,1726,1725,1724,1706,1692,1691,1690,1689,1688,1687,1686,1666,1655,1654,1614,1560,1556,1555,1552,1551,1550,1548,1547,1546,1545,1521,1520,1467,1466,1462,1453,1434,1425,1406,1403,1348,1339,1287,1286,1285,1258,1205,1204,1203,1202,1193,1176,1175,1123,1112,1111,1110,1109,1108,1049,1048,1013,974,973,972,971,970,959,934,914,913,909,865,697,696,690,682,681,680,670,647,616,615,614,613,578,568,561,544,543,542,534,525,524,521,520,511,494,421,397,396,395,394,393,374,361,307,137,136,135,134,133,132,131,130,129,127,126,125,124,123,122,120,119,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,81,2976,2953,2952,2951,2900,2872,2871,2797,2742,2741,2740,2739,2738,2666,2608,2498,2290,2271,2258,2196,2148,2137,2136,2093,2092,2091,2090,2077,1898,1887,1796,1536,1463,1426,1260,1259,1228,1206,1177,1113,1078,987,975,731,667,436,416,415,414,141,140,139,3029,3019,3004,2997,2987,2955,2954,2903,2902,2901,2840,2827,2779,2662,2745,2744,2743,2667,2648,2647,2615,2614,2613,2612,2611,2610,2609,2583,2570,2566,2512,2474,2423,2422,2421,2420,2419,2417,2348,2313,2312,2300,2299,2292,2291,2259,2244,2231,2224,2210,2209,2208,2207,2150,2149,2127,2106,2063,2040,2033,1980,1967,1912,1911,1856,1831,1830,1829,1764,1750,1693,1559,1525,1524,1523,1522,1510,1498,1483,1482,1457,1449,1435,1408,1407,1349,1318,1290,1289,1241,1230,1229,1220,1210,1209,1208,1207,1178,1147,1115,1050,988,980,979,978,977,976,885,863,803,795,635,634,618,591,579,573,569,535,434,433,432,430,429,362,162,161,160,159,158,157,156,155,154,153,152,151,150,149,148,147,146,145,143,142,3010,2983,2960,2959,2958,2957,2956,2908,2907,2906,2905,2904,2874,2873,2863,2843,2842,2841,2802,2801,2800,2799,2798,2748,2747,2746,2690,2675,2674,2673,2672,2671,2670,2669,2668,2641,2618,2616,2523,2522,2495,2475,2461,2437,2431,2430,2429,2428,2427,2426,2425,2424,2366,2365,2364,2350,2349,2338,2337,2336,2293,2274,2273,2260,2246,2245,2233,2232,2197,2176,2151,2139,2138,2121,2120,2119,2118,2117,2116,2107,2094,2078,2042,2041,2028,2027,1982,1981,1956,1929,1866,1857,1836,1835,1834,1833,1832,1817,1777,1770,1769,1768,1767,1766,1765,1751,1741,1728,1696,1695,1694,1652,1630,1629,1628,1616,1615,1563,1562,1561,1526,1485,1484,1473,1472,1442,1409,1402,1386,1292,1291,1263,1262,1261,1242,1211,1149,1148,1125,1100,1051,1022,1015,1014,991,990,989,944,304,881,866,715,673,672,653,652,651,650,636,621,620,619,598,592,580,562,546,502,496,495,420,419,418,401,387,383,349,330,324,198,197,196,195,194,193,192,191,190,189,188,187,186,185,184,183,182,181,180,178,177,176,175,174,173,172,171,170,169,168,167,166,165,164,77,73,48,3035,2909,2875,2828,2805,2804,2803,2751,2750,2749,2679,2678,2677,2676,2619,2577,2576,2542,2524,2436,2435,2434,2433,2432,2376,2367,2247,2212,2211,2108,2064,2034,1969,1968,1946,1913,1899,1863,1778,1752,1729,1669,1668,1667,1635,1634,1633,1631,1617,1459,1455,1445,1436,1410,1387,1381,1380,1379,1378,1319,1293,1266,1265,1264,1231,1116,1053,1052,995,994,993,992,911,883,882,668,552,551,550,545,350,213,212,210,209,208,207,206,205,204,202,201,200,43,3021,2986,2910,2876,2754,2753,2752,2681,2680,2620,2275,2198,1931,1914,1873,1872,1871,1771,1753,1637,1636,1486,1460,1450,1363,1362,1361,1360,1359,1358,1357,1356,1355,1354,1353,1328,1327,1326,1324,1323,1322,1321,1320,1179,1126,1054,996,623,593,505,504,503,221,220,219,218,217,216,215,214,100,3038,2994,2961,2912,2911,2864,2845,2844,2755,2685,2684,2683,2682,2622,2621,2543,2443,2442,2441,2440,2439,2438,2393,2392,2391,2339,2235,2234,2095,2079,2046,2045,2044,2043,1983,1962,1961,1947,1900,1865,1864,1838,1837,1799,1790,1781,1780,1779,1772,1730,1709,1708,1697,1638,1619,1618,1527,1518,1511,1441,1437,1398,1385,1338,1337,1334,1333,1332,1331,1330,1329,1305,1304,1303,1302,1301,1300,1297,1296,1295,1294,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1237,1236,1235,1234,1233,1232,1227,1180,1150,1127,1118,1086,1016,997,981,642,624,600,599,581,530,529,528,527,526,515,514,441,440,438,437,231,230,229,228,227,226,225,224,223,3027,2965,2964,2963,2962,2939,2938,2915,2914,2913,2848,2847,2846,2810,2809,2808,2807,2806,2765,2764,2763,2762,2761,2758,2756,2703,2702,2701,2698,2697,2696,2695,2694,2693,2692,2691,2689,2688,2686,2626,2625,2624,2623,2544,2547,2546,2545,2527,2526,2525,2499,2476,2451,2450,2449,2448,2447,2445,2444,2377,2354,2353,2352,2351,2340,2325,2324,2302,2301,2276,2265,2264,2263,2262,2241,2236,2214,2213,2200,2199,2191,2190,2189,2188,2187,2177,2166,2165,2164,2153,2152,2129,2128,2097,2082,2081,2080,2065,2056,2048,2047,2036,1984,1972,1971,1970,1957,1932,1919,1918,1917,1916,1907,1906,1905,1904,1901,1891,1888,1858,1841,1840,1824,1818,1805,1782,1756,1755,1754,1732,1731,1712,1711,1710,1670,1660,1659,1656,1653,1648,1646,1645,1644,1642,1641,1640,1639,1622,1621,1620,1553,1529,1528,1513,1512,1489,1488,1487,1479,1478,1477,1475,1464,1451,1448,1447,1428,1427,1411,1401,1400,1383,1382,1365,1364,1308,1307,1306,1249,1248,1247,1246,1245,1244,1243,1240,1239,1238,1226,1223,1222,1221,1219,1218,1217,1216,1215,1214,1213,1212,1192,1191,1189,1188,1187,1186,1185,1184,1183,1182,1181,1174,1173,1172,1171,1170,1169,1166,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1154,1153,1152,1151,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1129,1128,1088,1058,1056,1018,1017,1010,1009,1008,1007,1006,1005,1004,1003,1002,1001,999,998,948,947,946,945,659,644,627,626,601,582,575,574,556,555,554,536,497,447,427,426,425,424,423,422,411,409,408,407,406,404,403,382,371,360,358,352,272,271,270,269,268,267,266,265,264,262,261,260,259,258,257,256,255,254,253,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,235,234,233,232,3052,3049,3030,3025,2995,2977,2972,2971,2970,2969,2968,2967,2966,2925,2924,2922,2921,2920,2919,2918,2917,2916,2883,2882,2881,2880,2879,2878,2877,2856,2855,2854,2853,2852,2851,2850,2829,2820,2819,2818,2817,2815,2814,2813,2812,2775,2774,2773,2772,2771,2770,2769,2768,2767,2766,2726,2723,2718,2717,2716,2715,2714,2713,2712,2711,2710,2709,2708,2707,2705,2704,2637,2636,2635,2634,2633,2632,2631,2630,2629,2628,2568,2564,2563,2556,2555,2554,2553,2552,2551,2550,2548,2529,2528,2481,2480,2479,2478,2460,2459,2458,2457,2456,2455,2454,2453,2379,2378,2369,2355,2342,2341,2327,2326,2319,2318,2317,2316,2314,2305,2304,2303,2294,2280,2279,2278,2277,2252,2251,2238,2237,2225,2215,2201,2186,2185,2184,2179,2178,2141,2140,2112,2111,2110,2109,2104,2098,2084,2083,2068,2067,2066,2058,2057,2053,1986,1985,1959,1958,1951,1950,1949,1934,1930,1922,1921,1908,1890,1889,1860,1859,1846,1845,1844,1843,1842,1814,1811,1810,1809,1808,1806,1802,1801,1800,1786,1785,1773,1742,1736,1735,1734,1715,1714,1713,1701,1700,1699,1683,1676,1675,1674,1673,1672,1671,1650,1649,1624,1623,1516,1515,1514,1507,1502,1501,1500,1499,1492,1491,1481,1476,1468,1461,1446,1433,1431,1430,1415,1414,1412,1399,1395,1391,1390,1389,1388,1368,1367,1366,1335,1309,1299,1252,1251,1195,1194,1144,1121,1120,1064,1063,1062,1061,1059,1039,1029,1028,1027,1026,1025,1024,1023,1020,982,941,929,928,927,926,925,924,923,922,921,920,919,918,917,916,884,879,878,877,876,875,874,873,872,871,870,869,868,867,862,861,860,859,858,857,856,855,854,853,852,851,850,849,848,847,846,845,844,842,841,840,837,836,835,834,833,832,831,830,829,828,827,826,825,824,821,820,819,818,817,815,813,810,809,807,806,805,801,800,799,798,797,796,794,793,792,791,790,789,788,787,786,785,737,735,719,675,669,663,662,661,660,658,649,648,646,645,628,607,604,603,602,594,587,586,585,584,583,565,564,563,557,548,547,538,533,532,531,523,522,518,517,516,499,498,493,449,446,410,402,398,384,359,354,325,314,313,312,311,310,309,308,306,303,302,301,300,299,298,297,296,295,294,293,292,291,290,289,288,287,286,285,284,263,163,47,3024,2975,2974,2973,2936,2935,2934,2933,2887,2886,2860,2859,2778,2777,2776,2725,2650,2645,2644,2643,2642,1549,2513,2468,2467,2395,2357,2330,2329,2282,2239,2227,2154,2113,2101,2100,2035,1953,1850,1849,1848,1847,1821,1816,1719,1718,1682,1681,1680,1679,1506,1494,1418,1417,1370,1225,1224,1038,1037,1036,1035,1034,1033,1032,1031,942,724,723,722,721,720,718,717,716,711,693,692,691,689,687,686,685,678,677,676,605,595,576,559,558,539,346,345,344,342,341,340,339,338,337,336)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | ALL | idx_catid | کلید شاخصی برای استفاده نیست | NULL | NULL | 27522 | |
| 1 | PRIMARY | <subquery2> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
| 2 | MATERIALIZED | <derived3> | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 2523 | |
| 3 | DERIVED | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 1.41 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.77 ms |
| Optimizing | 0.56 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 1.39 ms |
| Removing tmp table | 0.02 ms |
| Sending data | 28.44 ms |
| End of update loop | 0.02 ms |
| Removing tmp table | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 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 |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.22 ms |
| Reset for next command | 0.02 ms |
| # | فراخوانده | فایل و شماره خط |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_joomgallery/helpers/helper.php:213 |
| 11 | JoomHelper::checkNewCatg() | JROOT/components/com_joomgallery/views/gallery/view.html.php:183 |
| 10 | JoomGalleryViewGallery->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_joomgallery/controller.php:100 |
| 8 | JoomGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_joomgallery/joomgallery.php:41 |
| 6 | require_once JROOT/components/com_joomgallery/joomgallery.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 |
مجموعه محدود شده 
