SHOW FULL COLUMNS FROM `jd_config` [ RunTime:0.001397s ]
SELECT `val`,`tag` FROM `jd_config` WHERE `cate` = '1' [ RunTime:0.000912s ]
SHOW FULL COLUMNS FROM `jd_link` [ RunTime:0.001615s ]
SELECT `name`,`url` FROM `jd_link` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `jd_province_set` [ RunTime:0.001716s ]
SELECT `name` FROM `jd_province_set` [ RunTime:0.000872s ]
SHOW FULL COLUMNS FROM `jd_major_cate` [ RunTime:0.001141s ]
SELECT `id`,`name` FROM `jd_major_cate` WHERE `pid` = 0 AND `level` = '本科' [ RunTime:0.000881s ]
SELECT `id`,`pid`,`name` FROM `jd_major_cate` [ RunTime:0.000917s ]
SELECT `id`,`pid`,`name` FROM `jd_major_cate` WHERE `pid` IN (1,3,8,15,19,23,25,39,71,79,91,101) [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `jd_major_cate` WHERE `pid` = 0 AND `level` = '专科' [ RunTime:0.000838s ]
SELECT `id`,`pid`,`name` FROM `jd_major_cate` [ RunTime:0.000926s ]
SELECT `id`,`pid`,`name` FROM `jd_major_cate` WHERE `pid` IN (107,112,122,130,138,143,151,154,159,164,173,178,189,199,203,208,211,215,224) [ RunTime:0.001154s ]
SHOW FULL COLUMNS FROM `jd_cp` [ RunTime:0.002473s ]
SELECT `id`,`cate`,`title`,`detail` FROM `jd_cp` WHERE `id` = 1 AND `is_show` = 1 LIMIT 1 [ RunTime:0.000786s ]
SHOW FULL COLUMNS FROM `jd_cp_relation` [ RunTime:0.001608s ]
SHOW FULL COLUMNS FROM `jd_cp_subject` [ RunTime:0.001461s ]
SELECT `cp_relation_model`.`id`,`cp_relation_model`.`tm_id`,`cp_relation_model`.`sort`,`subject`.`id` AS `subject__id`,`subject`.`cate` AS `subject__cate`,`subject`.`title` AS `subject__title`,`subject`.`options` AS `subject__options` FROM `jd_cp_relation` `cp_relation_model` RIGHT JOIN `jd_cp_subject` `subject` ON `cp_relation_model`.`tm_id`=`subject`.`id` WHERE `cp_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000862s ]