[ DB ] CONNECT:[ UseTime:0.000284s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.001730s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.004046s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000334s ]
[ DB ] CONNECT:[ UseTime:0.008284s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001308s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000309s ]
[ DB ] CONNECT:[ UseTime:0.012773s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.000960s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.010596s ]
[ DB ] CONNECT:[ UseTime:0.002870s ] 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.000687s ]
[ DB ] CONNECT:[ UseTime:0.012870s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000268s ]
[ DB ] CONNECT:[ UseTime:0.000558s ] 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.000801s ]
[ DB ] CONNECT:[ UseTime:0.013408s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000300s ]
[ DB ] CONNECT:[ UseTime:0.007839s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001275s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000317s ]
[ DB ] CONNECT:[ UseTime:0.001944s ] 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.000264s ]
[ DB ] CONNECT:[ UseTime:0.007309s ] 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.000296s ]
[ DB ] CONNECT:[ UseTime:0.000980s ] 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.000234s ]
[ DB ] CONNECT:[ UseTime:0.001059s ] 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.000366s ]
[ DB ] CONNECT:[ UseTime:0.001145s ] 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.000253s ]
[ DB ] CONNECT:[ UseTime:0.000915s ] 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.000319s ]
[ DB ] CONNECT:[ UseTime:0.001573s ] 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.000878s ]
[ DB ] CONNECT:[ UseTime:0.000275s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000552s ]
[ DB ] CONNECT:[ UseTime:0.005099s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.003042s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(37,jg_pcd) ) AND ( status = 1 ) ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.073621s ]
[ DB ] CONNECT:[ UseTime:0.002829s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000251s ]
[ DB ] CONNECT:[ UseTime:0.005197s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000239s ]
[ DB ] CONNECT:[ UseTime:0.003780s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000796s ]
[ DB ] CONNECT:[ UseTime:0.000810s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2,69 LIMIT 1 [ RunTime:0.000222s ]
[ DB ] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000213s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] 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.000230s ]
[ DB ] CONNECT:[ UseTime:0.000627s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000593s ]
[ DB ] CONNECT:[ UseTime:0.000827s ] 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.000289s ]
[ DB ] CONNECT:[ UseTime:0.003155s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1,2,5 LIMIT 1 [ RunTime:0.000228s ]
[ DB ] CONNECT:[ UseTime:0.012273s ] 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.000242s ]
[ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000377s ]
[ DB ] CONNECT:[ UseTime:0.005406s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1197 ) LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.015042s ]
[ DB ] CONNECT:[ UseTime:0.000566s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000305s ]
[ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000258s ]
[ DB ] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.010748s ]
[ DB ] CONNECT:[ UseTime:0.011836s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1197 ) LIMIT 1 [ RunTime:0.029605s ]
[ DB ] CONNECT:[ UseTime:0.002368s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.002018s ]
[ DB ] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000286s ]
[ DB ] CONNECT:[ UseTime:0.002897s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000317s ]
[ DB ] CONNECT:[ UseTime:0.001394s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000281s ]
[ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1197 ) LIMIT 1 [ RunTime:0.000814s ]
[ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000268s ]
[ DB ] CONNECT:[ UseTime:0.001051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg LEFT JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(1234,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 15 AND jg_age_max >= 16 ) [ RunTime:0.061988s ]
[ DB ] CONNECT:[ UseTime:0.000418s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `jg`.*,`renzheng`.`rezhengtime` FROM clt_jigou as jg LEFT JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(1234,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 15 AND jg_age_max >= 16 ) GROUP BY `jg`.`id` ORDER BY `jg`.`jg_shoucang_num` DESC,`renzheng`.`rezhengtime` DESC LIMIT 0,10 [ RunTime:0.064241s ]
[ DB ] CONNECT:[ UseTime:0.010624s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jg_renzheng` [ RunTime:0.002689s ]
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 35178 ) LIMIT 1 [ RunTime:0.000429s ]
[ DB ] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001589s ]
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 35178 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.026918s ]
[ DB ] CONNECT:[ UseTime:0.013770s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 2832 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.025533s ]
[ DB ] CONNECT:[ UseTime:0.000992s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 2896 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.060539s ]
[ DB ] CONNECT:[ UseTime:0.020609s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 2544 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.026928s ]
[ DB ] CONNECT:[ UseTime:0.000885s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 24630 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.059238s ]
[ DB ] CONNECT:[ UseTime:0.003272s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 3221 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.110839s ]
[ DB ] CONNECT:[ UseTime:0.001149s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 24798 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.044468s ]
[ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 25846 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.053403s ]
[ DB ] CONNECT:[ UseTime:0.012841s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 3303 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.069113s ]
[ DB ] CONNECT:[ UseTime:0.005998s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 1796 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.030519s ]
[ DB ] CONNECT:[ UseTime:0.000314s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1234 ) LIMIT 1 [ RunTime:0.000292s ]