SHOW FULL COLUMNS FROM `xgw_url_beautify` [ RunTime:0.000980s ]
SELECT * FROM `xgw_url_beautify` WHERE `app` = 'home' AND `status` = 1 AND `type` IN (2,3,4) [ RunTime:0.000865s ]
SHOW FULL COLUMNS FROM `xgw_coupon` [ RunTime:0.001696s ]
SELECT `id`,`full_deduction`,`nums`,`curact`,`type`,`use_conditions_type`,`use_full_deduction`,`use_endtime`,`use_starttime` FROM `xgw_coupon` WHERE `type` = 1 AND `is_home` = 1 AND `starttime` <= 1766236732 AND `endtime` >= 1766236732 AND `delete_time` IS NULL ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003517s ]
SHOW FULL COLUMNS FROM `xgw_hot_search` [ RunTime:0.000859s ]
SELECT `id`,`name`,`link`,`link_type`,`link_id` FROM `xgw_hot_search` WHERE ( `status` = 1 AND `delete_time` IS NULL ) AND `xgw_hot_search`.`delete_time` IS NULL ORDER BY `weigh` DESC,`id` DESC LIMIT 12 [ RunTime:0.000188s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.000191s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 13 LIMIT 1 [ RunTime:0.000175s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 108 LIMIT 1 [ RunTime:0.000154s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 107 LIMIT 1 [ RunTime:0.000146s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000139s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 267 LIMIT 1 [ RunTime:0.000150s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 229 LIMIT 1 [ RunTime:0.000140s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 73 LIMIT 1 [ RunTime:0.000135s ]
SHOW FULL COLUMNS FROM `xgw_links` [ RunTime:0.000802s ]
SELECT * FROM `xgw_links` WHERE `status` = '1' AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000204s ]
SHOW FULL COLUMNS FROM `xgw_invitation` [ RunTime:0.000921s ]
SELECT * FROM `xgw_invitation` WHERE `status` = 2 LIMIT 1 [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `xgw_vlog` [ RunTime:0.000872s ]
SHOW FULL COLUMNS FROM `xgw_vlog_classify` [ RunTime:0.000796s ]
SHOW FULL COLUMNS FROM `xgw_course_category` [ RunTime:0.000852s ]
SHOW FULL COLUMNS FROM `xgw_course` [ RunTime:0.000866s ]
SHOW FULL COLUMNS FROM `xgw_collection` [ RunTime:0.000815s ]
SHOW FULL COLUMNS FROM `xgw_user_buy_info` [ RunTime:0.000806s ]
SELECT `category_id`,`name` FROM `xgw_vlog_classify` WHERE `xgw_vlog_classify`.`delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000827s ]
SELECT * FROM `xgw_course_category` ORDER BY `weigh` DESC,`id` DESC LIMIT 3 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `xgw_course_category_join` [ RunTime:0.000777s ]
SHOW FULL COLUMNS FROM `xgw_course_video` [ RunTime:0.000812s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 103 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.001657s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000980s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000916s ]
SELECT SUM(`click_num`) AS think_sum FROM `xgw_course_video` WHERE ( `id` IN (1462,30,29,28,24,25,26,19,350,31,27,20,23,485,124,82,83,85,21,22,173,174,175,176,216,217,218,219,220,221,222,223,224,225,226,303,351,353,352,2066,2067,2068,2069,2070,2071,2072,2103,2107,2111,1986,1990,1994,1998,177,354,376,377,304,305,306,357,358,359,360,361,362,363,2002,1445,402,388,389,390,391,392,393,394,395,396,397,398,399,400,401,403,404,125,484,2006,2010,2014,2018,2022,2026,1596,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,405,178,1322,2209,2206,2207,2205,2208,1645,1646,1647,1666,1667,1668,1669,1670,1672,1675,1677,1679,1681,1683,1685,1687,1688,1690,1693,1695,1697,1699,1701,1703,1705,1707,1709,1713,1712,1715,2030,2034,2038,2094,2099,382,2039,344,345,346,347,1197,1198,1199,1200,1201,1203,1814,1818,1822,1917,1919,1921,1923,1925,1927,1929,1931,1933,1935,1937,1939,1941,1943,1945,1947,1826,1830,1834,1838,1850,1845,1849,1861,1862,1863,1864,1865,1866,1867,1868,2115,2119,2123,2128,2132,2136,2140,1869,1870,2144,2148,2152,2156,2161,2165,2169,2173,2177,2181,2185,2189,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,328,329,330,331,332,333,334,335,336,337,1648,1649,1650,1651,1652) ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002032s ]
SELECT `study_people` FROM `xgw_course_category` WHERE `id` = 103 LIMIT 1 [ RunTime:0.000557s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000179s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,302,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000993s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.001231s ]
SELECT SUM(`click_num`) AS think_sum FROM `xgw_course_video` WHERE ( `id` IN (1448,44,108,41,42,107,1579,192,193,1466,126,1460,134,136,179,180,1587,160,162,159,161,164,181,182,183,185,184,137,189,1452,135,138,194,190,191,115,116,127,195,196,197,198,199,200,215,227,228,229,243,244,245,186,246,247,248,40,250,251,256,253,1593,249,230,264,265,266,267,268,252,270,271,272,273,274,275,276,278,279,1590,280,281,284,285,286,277,257,282,289,290,1455,307,309,310,311,308,1457,478,479,480,481,1581,1323,1324,1325,1326,1327,1328,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,287,258,312,188,269,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,1569,1570,1571,1572,1573,1574,1575,117,1329,163,291,288,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1719,1722,1725,1728,1731,1734,1737,1740,1743,1746,1749,1752,1755,1758,1761,1764,1767,1770,1773,1776,1779,1782,1786,1790,1794,1798,1802,1806,1810,1893,1896,1899,1902,1905,1909,1912,1915,1951,1955,1960,1964,1968,1972,1976,1980) ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001769s ]
SELECT `study_people` FROM `xgw_course_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000190s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 8 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000177s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (302,249,97,96,46,36,95,23,94,38,37) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.001000s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (249,97,96,46,36,95,23,94,38,37) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000967s ]
SELECT SUM(`click_num`) AS think_sum FROM `xgw_course_video` WHERE ( `id` IN (49,114,52,53,54,55,56,57,58,59,62,69,66,165,110,113,111,112,51,64,119,122,120,128,129,130,131,132,148,121,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342) ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000844s ]
SELECT `study_people` FROM `xgw_course_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000163s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 103 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000178s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000218s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 103 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000187s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000255s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL [ RunTime:0.000797s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 103 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000178s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000227s ]
SELECT SUM(`video_time`) AS think_sum FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001162s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 103 LIMIT 1 [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `xgw_limit_discounts_product` [ RunTime:0.000909s ]
SELECT `p`.`l_id`,`p`.`price`,`p`.`number` FROM `xgw_limit_discounts_product` `p` INNER JOIN `xgw_limit_discounts` `l` ON `p`.`l_id`=`l`.`id` WHERE `p`.`v_id` = '103' AND `p`.`type` = '1' AND `l`.`starttime` <= '1766236732' AND `l`.`endtime` > '1766236732' AND ( p.delete_time is null ) AND ( l.delete_time is null ) ORDER BY `l`.`id` DESC LIMIT 1 [ RunTime:0.001098s ]
SELECT `price` FROM `xgw_course_category` WHERE `id` = 103 LIMIT 1 [ RunTime:0.000155s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 103 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000264s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (108,109,107,296,92,106,110,1,277,105,247) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000222s ]
SELECT SUM(`price`) AS think_sum FROM `xgw_course` WHERE `id` IN (108,109,107,296,92,106,110,1,277,105,247) LIMIT 1 [ RunTime:0.000274s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000184s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,302,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000246s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000183s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,302,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000318s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL [ RunTime:0.000964s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000180s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,302,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000249s ]
SELECT SUM(`video_time`) AS think_sum FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000913s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 2 LIMIT 1 [ RunTime:0.000171s ]
SELECT `p`.`l_id`,`p`.`price`,`p`.`number` FROM `xgw_limit_discounts_product` `p` INNER JOIN `xgw_limit_discounts` `l` ON `p`.`l_id`=`l`.`id` WHERE `p`.`v_id` = '2' AND `p`.`type` = '1' AND `l`.`starttime` <= '1766236732' AND `l`.`endtime` > '1766236732' AND ( p.delete_time is null ) AND ( l.delete_time is null ) ORDER BY `l`.`id` DESC LIMIT 1 [ RunTime:0.000203s ]
SELECT `price` FROM `xgw_course_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000511s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000167s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (73,100,229,302,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000232s ]
SELECT SUM(`price`) AS think_sum FROM `xgw_course` WHERE `id` IN (73,100,229,264,272,248,286,230,301,44,228,282,231,54,71,294,13,250,267) LIMIT 1 [ RunTime:0.000207s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 8 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000164s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (302,249,97,96,46,36,95,23,94,38,37) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000195s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 8 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000159s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (302,249,97,96,46,36,95,23,94,38,37) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000189s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` IN (249,97,96,46,36,95,23,94,38,37) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL [ RunTime:0.000926s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 8 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000304s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (302,249,97,96,46,36,95,23,94,38,37) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000203s ]
SELECT SUM(`video_time`) AS think_sum FROM `xgw_course_video` WHERE ( `course_id` IN (249,97,96,46,36,95,23,94,38,37) AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000941s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 8 LIMIT 1 [ RunTime:0.000281s ]
SELECT `p`.`l_id`,`p`.`price`,`p`.`number` FROM `xgw_limit_discounts_product` `p` INNER JOIN `xgw_limit_discounts` `l` ON `p`.`l_id`=`l`.`id` WHERE `p`.`v_id` = '8' AND `p`.`type` = '1' AND `l`.`starttime` <= '1766236732' AND `l`.`endtime` > '1766236732' AND ( p.delete_time is null ) AND ( l.delete_time is null ) ORDER BY `l`.`id` DESC LIMIT 1 [ RunTime:0.001033s ]
SELECT `price` FROM `xgw_course_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000156s ]
SELECT `course_id` FROM `xgw_course_category_join` `j` INNER JOIN `xgw_course` `c` ON `c`.`id`=`j`.`course_id` WHERE `category_id` = 8 AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.000161s ]
SELECT `course_id` FROM `xgw_course_video` WHERE ( `course_id` IN (302,249,97,96,46,36,95,23,94,38,37) AND `status` = 2 AND `delete_time` IS NULL ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000188s ]
SELECT SUM(`price`) AS think_sum FROM `xgw_course` WHERE `id` IN (249,97,96,46,36,95,23,94,38,37) LIMIT 1 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `xgw_vlog` WHERE `status` = 2 AND `tag` = 2 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000655s ]
SELECT * FROM `xgw_vlog` WHERE `status` = 2 AND `tag` = 2 AND `delete_time` IS NULL ORDER BY `weigh` DESC,`id` DESC LIMIT 0,8 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `xgw_lecturer` [ RunTime:0.000984s ]
SELECT `id`,`category_id`,`lecturer_id`,`vname`,`isfree`,`learning_num`,`hits`,`video_address`,`long_time` FROM `xgw_vlog` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000193s ]
SELECT `name` FROM `xgw_vlog_classify` WHERE ( `category_id` = 6 ) AND `xgw_vlog_classify`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000155s ]
SELECT `lname` FROM `xgw_lecturer` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000147s ]
SELECT `id` FROM `xgw_collection` WHERE `user_id` = 0 AND `data_id` = 58 AND `type` = 2 LIMIT 1 [ RunTime:0.000163s ]
SELECT `name` FROM `xgw_vlog_classify` WHERE ( `category_id` = 6 ) AND `xgw_vlog_classify`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000148s ]
SELECT `lname` FROM `xgw_lecturer` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000136s ]
SELECT `id` FROM `xgw_collection` WHERE `user_id` = 0 AND `data_id` = 58 AND `type` = 2 LIMIT 1 [ RunTime:0.000153s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000196s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.000160s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000160s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.000139s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000175s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000164s ]
SHOW FULL COLUMNS FROM `xgw_play_log_video` [ RunTime:0.000835s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1448,44,108,41,42,107,40,250,251,252,270,271,272,273,274,275,276,277,287) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000224s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000335s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1448 LIMIT 1 [ RunTime:0.000150s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000160s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000184s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1448,44,108,41,42,107,40,250,251,252,270,271,272,273,274,275,276,277,287) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000198s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000170s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1448 LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000171s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000174s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1986,1990,1994,1998,2002,2006,2010,2014,2018,2022,2026,2030,2034,2038,2094,2099,382,2039,344,345,346,347,1197,1198,1199,1200,1201,1203,1814,1818,1822,1826,1830,1834,1838,1850,1845,1849,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000283s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000163s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2014 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000161s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000178s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1986,1990,1994,1998,2002,2006,2010,2014,2018,2022,2026,2030,2034,2038,2094,2099,382,2039,344,345,346,347,1197,1198,1199,1200,1201,1203,1814,1818,1822,1826,1830,1834,1838,1850,1845,1849,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000262s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000179s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2014 LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000163s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000176s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (2209,2206,2207,2205,2208,1645,1646,1647,1648,1649,1650,1651,1652) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000187s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000161s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2209 LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000161s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000171s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (2209,2206,2207,2205,2208,1645,1646,1647,1648,1649,1650,1651,1652) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000185s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000158s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2209 LIMIT 1 [ RunTime:0.000152s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000161s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000138s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000187s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000148s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000174s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000165s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (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) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000223s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000161s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1495 LIMIT 1 [ RunTime:0.000146s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000160s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000162s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (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) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000220s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000159s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1495 LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000175s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000163s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1466,126,179,180,181,182,183,185,184,137,189,138,127,195,196,197,198,199,200,215,227,228,229,230,264,265,266,267,268,269) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000228s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000166s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1466 LIMIT 1 [ RunTime:0.000150s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000162s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000160s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1466,126,179,180,181,182,183,185,184,137,189,138,127,195,196,197,198,199,200,215,227,228,229,230,264,265,266,267,268,269) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000227s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000161s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1466 LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000654s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000163s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1455,307,309,310,311,308,312) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000184s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000157s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1455 LIMIT 1 [ RunTime:0.000139s ]
SELECT * FROM `xgw_hot_search` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000172s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000160s ]
SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1455,307,309,310,311,308,312) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000182s ]
SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000157s ]
SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1455 LIMIT 1 [ RunTime:0.000137s ]
冀公网安备13010502001619号