[ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.001005s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.003622s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000395s ]
[ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001381s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000464s ]
[ DB ] CONNECT:[ UseTime:0.008138s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.003786s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.007527s ]
[ DB ] CONNECT:[ UseTime:0.009698s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `status` = '1' AND `type` = 2 ORDER BY `status` [ RunTime:0.004023s ]
[ DB ] CONNECT:[ UseTime:0.021399s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.007989s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.008089s ]
[ DB ] CONNECT:[ UseTime:0.000989s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 13 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000229s ]
[ DB ] CONNECT:[ UseTime:0.008989s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.007028s ]
[ DB ] CONNECT:[ UseTime:0.007179s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.006028s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.006825s ]
[ DB ] CONNECT:[ UseTime:0.007601s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 1 ) AND `id` NOT IN (91,92) [ RunTime:0.005989s ]
[ DB ] CONNECT:[ UseTime:0.008706s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 2 ) AND `id` NOT IN (91,92) [ RunTime:0.002430s ]
[ DB ] CONNECT:[ UseTime:0.004443s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 3 ) AND `id` NOT IN (91,92) [ RunTime:0.000245s ]
[ DB ] CONNECT:[ UseTime:0.001290s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 4 ) AND `id` NOT IN (91,92) [ RunTime:0.003118s ]
[ DB ] CONNECT:[ UseTime:0.011672s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 5 ) AND `id` NOT IN (91,92) [ RunTime:0.015974s ]
[ DB ] CONNECT:[ UseTime:0.005646s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 6 ) AND `id` NOT IN (91,92) [ RunTime:0.011994s ]
[ DB ] CONNECT:[ UseTime:0.011780s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 69 ) AND `id` NOT IN (91,92) [ RunTime:0.003557s ]
[ DB ] CONNECT:[ UseTime:0.001373s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000988s ]
[ DB ] CONNECT:[ UseTime:0.000944s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001410s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(44,jg_pcd) ) AND ( status = 1 ) ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.002109s ]
[ DB ] CONNECT:[ UseTime:0.006736s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 5 LIMIT 1 [ RunTime:0.004841s ]
[ DB ] CONNECT:[ UseTime:0.009662s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.003898s ]
[ DB ] CONNECT:[ UseTime:0.012812s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 5 LIMIT 1 [ RunTime:0.006994s ]
[ DB ] CONNECT:[ UseTime:0.006710s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4,5 LIMIT 1 [ RunTime:0.003472s ]
[ DB ] CONNECT:[ UseTime:0.007701s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.001038s ]
[ DB ] CONNECT:[ UseTime:0.001964s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2 LIMIT 1 [ RunTime:0.007490s ]
[ DB ] CONNECT:[ UseTime:0.003644s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2,4,5 LIMIT 1 [ RunTime:0.006266s ]
[ DB ] CONNECT:[ UseTime:0.003069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2 LIMIT 1 [ RunTime:0.001508s ]
[ DB ] CONNECT:[ UseTime:0.003212s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2 LIMIT 1 [ RunTime:0.000338s ]
[ DB ] CONNECT:[ UseTime:0.005724s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2 LIMIT 1 [ RunTime:0.006953s ]
[ DB ] CONNECT:[ UseTime:0.000998s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000704s ]
[ DB ] CONNECT:[ UseTime:0.004088s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000934s ]
[ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000224s ]
[ DB ] CONNECT:[ UseTime:0.011462s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.003717s ]
[ DB ] CONNECT:[ UseTime:0.010011s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.017684s ]
[ DB ] CONNECT:[ UseTime:0.013123s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.001028s ]
[ DB ] CONNECT:[ UseTime:0.002900s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(44,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND ( FIND_IN_SET(5,jg_class) ) [ RunTime:0.006600s ]
[ DB ] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `jg`.*,`renzheng`.`rezhengtime` FROM clt_jigou as jg JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(44,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND ( FIND_IN_SET(5,jg_class) ) GROUP BY `jg`.`id` ORDER BY `jg`.`jg_shoucang_num` DESC,`renzheng`.`rezhengtime` DESC LIMIT 0,10 [ RunTime:0.005166s ]
[ DB ] CONNECT:[ UseTime:0.000680s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jg_renzheng` [ RunTime:0.006273s ]
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 34572 ) LIMIT 1 [ RunTime:0.000929s ]
[ DB ] CONNECT:[ UseTime:0.001281s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.002018s ]
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 34572 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.051222s ]
[ DB ] CONNECT:[ UseTime:0.010988s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.006995s ]