热门赛事
-
2015-09-25131832关注
-
2016年中国体育彩票江西省乒协会员直通南昌积分大赛-赣州分站赛
2016-09-1666621关注
-
2015-10-2462830关注
-
2016中国体育彩票江西省乒协会员直通南昌积分大赛-景德镇分站赛
2016-10-1548183关注
-
2015-08-299448关注
-
2017-08-188279关注
2015-09-25131832关注
2016年中国体育彩票江西省乒协会员直通南昌积分大赛-赣州分站赛
2016-09-1666621关注
2015-10-2462830关注
2016中国体育彩票江西省乒协会员直通南昌积分大赛-景德镇分站赛
2016-10-1548183关注
2015-08-299448关注
2017-08-188279关注
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | select game_id from contests Contest where status != 'draft' and status != 'cancel' | 15046 | 15046 | 20 | |
| 2 | SELECT `Game`.`id`, `Game`.`number`, `Game`.`name`, `Game`.`placard`, `Game`.`stage`, `Game`.`status`, `Game`.`scale`, `Game`.`type`, `Game`.`user_id`, `Game`.`sponsor`, `Game`.`organizer`, `Game`.`cosponsor`, `Game`.`contact`, `Game`.`phone`, `Game`.`scheduled_start_date`, `Game`.`scheduled_end_date`, `Game`.`enroll_start_date`, `Game`.`enroll_end_date`, `Game`.`created`, `Game`.`region`, `Game`.`description`, `Game`.`state`, `Game`.`publish_date`, `Game`.`crowd_id`, `Game`.`club_id`, `Game`.`support`, `Game`.`private`, `Game`.`prefix`, `Game`.`category`, `Game`.`focus`, `Game`.`zone`, `Game`.`sport_id`, `Game`.`related`, `Game`.`px_type`, `Game`.`game_score`, `Game`.`manage_group_id` FROM `hpp_game`.`games` AS `Game` WHERE `Game`.`status` <> 'draft' AND `Game`.`category` = 'gaoxiao' AND `Game`.`sport_id` = 1 AND `Game`.`px_type` IS NULL AND `Game`.`id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 22, 25, 27, 29, 30, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 45, 46, 47, 50, 52, 58, 59, 62, 63, 64, 67, 69, 70, 71, 72, 74, 75, 76, 77, 78, 80, 81, 83, 84, 85, 86, 87, 88, 90, 91, 94, 95, 97, 98, 99, 100, 101, 102, 104, 105, 107, 110, 111, 112, 114, 117, 118, 120, 123, 124, 125, 126, 127, 128, 130, 131, 132, 134, 135, 136, 138, 139, 141, 142, 143, 144, 145, 146, 147, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 177, 178, 180, 181, 183, 184, 185, 186, 187, 188, 189, 190, 191, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 294, 295, 296, 297, 298, 299, 300, 301, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 319, 320, 322, 323, 324, 325, 326, 327, 328, 330, 332, 333, 338, 339, 348, 351, 352, 354, 355, 357, 359, 361, 363, 364, 365, 367, 368, 369, 370, 371, 372, 373, 375, 377, 378, 380, 381, 382, 385, 386, 387, 388, 389, 390, 391, 393, 395, 397, 400, 401, 402, 403, 406, 408, 409, 411, 412, 413, 415, 416, 419, 420, 421, 423, 424, 426, 427, 428, 429, 430, 432, 437, 438, 439, 440, 441, 443, 444, 445, 448, 449, 450, 452, 453, 456, 457, 459, 462, 463, 464, 465, 466, 467, 468, 470, 472, 473, 477, 478, 479, 480, 482, 486, 487, 488, 490, 491, 492, 495, 496, 497, 498, 500, 505, 506, 507, 509, 510, 511, 515, 516, 517, 518, 519, 520, 521, 524, 525, 526, 527, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 543, 544, 545, 546, 547, 548, 550, 551, 553, 554, 556, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 573, 575, 576, 577, 579, 580, 581, 585, 586, 587, 589, 590, 591, 592, 593, 595, 596, 597, 598, 599, 604, 607, 610, 614, 616, 617, 618, 622, 625, 626, 628, 629, 630, 631, 632, 635, 641, 644, 646, 647, 648, 649, 650, 652, 655, 656, 657, 659, 660, 661, 663, 664, 666, 667, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 682, 683, 685, 686, 687, 690, 691, 692, 693, 694, 696, 697, 699, 700, 702, 703, 704, 705, 706, 709, 712, 713, 714, 715, 716, 717, 719, 724, 726, 727, 729, 730, 732, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 747, 748, 749, 750, 751, 752, 753, 754, 756, 757, 758, 759, 762, 766, 768, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 785, 788, 790, 791, 792, 793, 794, 797, 798, 799, 800, 802, 803, 804, 805, 808, 810, 811, 813, 815, 816, 817, 818, 819, 820, 822, 823, 825, 826, 827, 829, 832, 834, 836, 837, 838, 839, 843, 844, 845, 846, 848, 849, 850, 851, 852, 855, 856, 858, 859, 861, 862, 863, 866, 867, 868, 869, 870, 871, 872, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 886, 888, 889, 891, 892, 893, 894, 895, 897, 900, 901, 905, 906, 907, 908, 910, 911, 912, 913, 915, 917, 918, 919, 920, 921, 923, 925, 926, 927, 928, 929, 930, 932, 933, 934, 941, 942, 943, 944, 945, 948, 950, 951, 952, 953, 954, 955, 956, 958, 959, 960, 961, 962, 964, 965, 966, 968, 972, 973, 974, 975, 976, 977, 978, 979, 980, 982, 984, 985, 986, 989, 990, 991, 992, 993, 994, 995, 997, 999, 1000, 1001, 1002, 1004, 1005, 1007, 1008, 1009, 1011, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1022, 1023, 1024, 1025, 1028, 1031, 1032, 1033, 1036, 1037, 1041, 1042, 1043, 1045, 1046, 1047, 1048, 1050, 1051, 1053, 1054, 1055, 1056, 1057, 1058, 1060, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1096, 1097, 1098, 1100, 1101, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1119, 1122, 1123, 1125, 1126, 1127, 1128, 1129, 1132, 1134, 1140, 1144, 1146, 1147, 1148, 1149, 1150, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1173, 1176, 1179, 1180, 1181, 1182, 1184, 1185, 1186, 1187, 1188, 1189, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1223, 1225, 1226, 1227, 1228, 1229, 1230, 1235, 1236, 1238, 1239, 1240, 1243, 1244, 1245, 1246, 1249, 1251, 1252, 1253, 1255, 1257, 1258, 1259, 1261, 1262, 1263, 1265, 1266, 1267, 1269, 1270, 1271, 1272, 1273, 1274, 1276, 1277, 1279, 1282, 1283, 1285, 1287, 1288, 1289, 1290, 1291, 1292, 1293, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1302, 1303, 1305, 1306, 1307, 1308, 1315, 1316, 1318, 1319, 1320, 1322, 1324, 1325, 1326, 1327, 1329, 1330, 1331, 1333, 1334, 1335, 1338, 1341, 1343, 1344, 1345, 1346, 1347, 1348, 1350, 1351, 1352, 1353, 1354, 1357, 1358, 1359, 1360, 1362, 1364, 1365, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1392, 1393, 1394, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1404, 1405, 1406, 1409, 1411, 1412, 1414, 1418, 1419, 1420, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429, 1430, 1431, 1432, 1434, 1435, 1436, 1438, 1440, 1441, 1442, 1443, 1444, 1445, 1446, 1448, 1449, 1450, 1452, 1457, 1459, 1461, 1463, 1464, 1468, 1469, 1470, 1471, 1473, 1474, 1475, 1477, 1478, 1479, 1481, 1482, 1483, 1485, 1486, 1487, 1490, 1492, 1494, 1495, 1496, 1497, 1500, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1523, 1524, 1525, 1529, 1531, 1534, 1539, 1540, 1542, 1544, 1545, 1546, 1548, 1549, 1550, 1551, 1552, 1554, 1555, 1556, 1557, 1558, 1559, 1562, 1563, 1564, 1565, 1569, 1570, 1572, 1573, 1574, 1575, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1586, 1587, 1588, 1589, 1590, 1591, 1592, 1595, 1596, 1597, 1598, 1599, 1600, 1601, 1602, 1603, 1604, 1605, 1607, 1608, 1609, 1610, 1611, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1622, 1624, 1625, 1627, 1629, 1630, 1633, 1634, 1636, 1637, 1638, 1640, 1641, 1642, 1643, 1646, 1649, 1650, 1651, 1652, 1655, 1656, 1657, 1658, 1661, 1663, 1664, 1665, 1669, 1671, 1674, 1676, 1677, 1679, 1680, 1681, 1682, 1683, 1684, 1690, 1691, 1693, 1694, 1695, 1696, 1700, 1701, 1704, 1705, 1706, 1709, 1710, 1712, 1713, 1716, 1717, 1722, 1723, 1726, 1728, 1729, 1732, 1734, 1735, 1736, 1737, 1738, 1740, 1742, 1744, 1746, 1747, 1748, 1749, 1750, 1752, 1754, 1757, 1760, 1761, 1763, 1764, 1765, 1766, 1767, 1768, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1778, 1779, 1780, 1781, 1782, 1784, 1786, 1789, 1790, 1791, 1793, 1794, 1795, 1796, 1797, 1798, 1799, 1800, 1803, 1804, 1805, 1807, 1809, 1811, 1812, 1813, 1814, 1815, 1817, 1818, 1819, 1820, 1821, 1825, 1826, 1828, 1830, 1831, 1832, 1834, 1835, 1836, 1837, 1838, 1839, 1841, 1842, 1846, 1847, 1850, 1851, 1852, 1854, 1855, 1856, 1857, 1858, 1859, 1861, 1865, 1866, 1867, 1868, 1870, 1871, 1872, 1873, 1874, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1891, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1909, 1910, 1911, 1912, 1913, 1914, 1915, 1918, 1920, 1921, 1923, 1924, 1927, 1929, 1930, 1931, 1932, 1935, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1947, 1948, 1952, 1953, 1954, 1956, 1958, 1959, 1960, 1961, 1962, 1963, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1974, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1988, 1989, 1990, 1991, 1994, 1996, 2000, 2002, 2003, 2004, 2006, 2007, 2008, 2010, 2012, 2013, 2015, 2016, 2017, 2021, 2022, 2023, 2025, 2026, 2027, 2031, 2032, 2033, 2034, 2036, 2037, 2038, 2040, 2041, 2043, 2044, 2046, 2047, 2048, 2049, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2074, 2075, 2076, 2077, 2078, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2096, 2097, 2098, 2099, 2100, 2101, 2104, 2105, 2108, 2109, 2110, 2111, 2112, 2113, 2115, 2118, 2119, 2122, 2123, 2124, 2125, 2128, 2130, 2133, 2134, 2135, 2137, 2138, 2139, 2140, 2141, 2145, 2146, 2147, 2148, 2149, 2150, 2153, 2155, 2156, 2157, 2159, 2160, 2161, 2163, 2167, 2168, 2169, 2170, 2171, 2174, 2177, 2178, 2179, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2196, 2199, 2200, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2214, 2216, 2220, 2221, 2224, 2225, 2226, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2241, 2243, 2245, 2246, 2248, 2249, 2251, 2252, 2253, 2254, 2258, 2259, 2261, 2263, 2265, 2266, 2267, 2268, 2271, 2273, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2285, 2287, 2288, 2290, 2291, 2293, 2294, 2297, 2298, 2299, 2300, 2301, 2303, 2305, 2327, 2328, 2331, 2332, 2333, 2335, 2336, 2337, 2338, 2339, 2340, 2341, 2342, 2343, 2344, 2345, 2346, 2347, 2349, 2350, 2351, 2352, 2353, 2355, 2356, 2357, 2358, 2360, 2361, 2363, 2364, 2365, 2366, 2367, 2368, 2369, 2370, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2380, 2381, 2383, 2384, 2385, 2387, 2388, 2389, 2390, 2391, 2393, 2394, 2395, 2396, 2397, 2399, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, |