[ DB ] CONNECT:[ UseTime:0.007109s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.003413s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.003636s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.002172s ]
[ DB ] CONNECT:[ UseTime:0.003695s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.003384s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000296s ]
[ DB ] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'ty' LIMIT 1 [ RunTime:0.003035s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'ty' LIMIT 1 [ RunTime:0.000388s ]
[ DB ] CONNECT:[ UseTime:0.000641s ] 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.000361s ]
[ DB ] CONNECT:[ UseTime:0.000877s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001467s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000897s ]
[ DB ] CONNECT:[ UseTime:0.000881s ] 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.000285s ]
[ DB ] CONNECT:[ UseTime:0.001206s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000352s ]
[ DB ] CONNECT:[ UseTime:0.005478s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.008641s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000717s ]
[ DB ] CONNECT:[ UseTime:0.010432s ] 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.000238s ]
[ DB ] CONNECT:[ UseTime:0.002485s ] 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.001727s ]
[ DB ] CONNECT:[ UseTime:0.000929s ] 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.000312s ]
[ DB ] CONNECT:[ UseTime:0.000963s ] 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.000356s ]
[ DB ] CONNECT:[ UseTime:0.000959s ] 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.000231s ]
[ DB ] CONNECT:[ UseTime:0.000301s ] 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.000251s ]
[ DB ] CONNECT:[ UseTime:0.000720s ] 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.000276s ]
[ DB ] CONNECT:[ UseTime:0.000771s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000263s ]
[ DB ] CONNECT:[ UseTime:0.000875s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001361s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(42,jg_pcd) ) AND ( status = 1 ) ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.051595s ]
[ DB ] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000335s ]
[ DB ] CONNECT:[ UseTime:0.000283s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000218s ]
[ DB ] CONNECT:[ UseTime:0.000310s ] 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.000665s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000299s ]
[ DB ] CONNECT:[ UseTime:0.000400s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000210s ]
[ DB ] CONNECT:[ UseTime:0.000349s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000357s ]
[ DB ] CONNECT:[ UseTime:0.000594s ] 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.000316s ]
[ DB ] CONNECT:[ UseTime:0.000544s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000240s ]
[ DB ] CONNECT:[ UseTime:0.020778s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000376s ]
[ DB ] CONNECT:[ UseTime:0.002212s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000338s ]
[ DB ] CONNECT:[ UseTime:0.000322s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000805s ]
[ DB ] CONNECT:[ UseTime:0.000568s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.000629s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.002298s ]
[ DB ] CONNECT:[ UseTime:0.000264s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000198s ]
[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.001676s ]
[ DB ] CONNECT:[ UseTime:0.000319s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.000246s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000275s ]
[ DB ] CONNECT:[ UseTime:0.000495s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000262s ]
[ DB ] CONNECT:[ UseTime:0.000288s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.000277s ]
[ DB ] CONNECT:[ UseTime:0.000949s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.000273s ]
[ DB ] CONNECT:[ UseTime:0.005138s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000196s ]
[ DB ] CONNECT:[ UseTime:0.001371s ] 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(1808,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) AND ( FIND_IN_SET(5,jg_class) ) [ RunTime:0.070363s ]
[ DB ] CONNECT:[ UseTime:0.001114s ] 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(1808,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) 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.057786s ]
[ DB ] CONNECT:[ UseTime:0.000345s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001282s ]
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 9896 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.025355s ]
[ DB ] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 9939 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.025835s ]
[ DB ] CONNECT:[ UseTime:0.000430s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 9877 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.016484s ]
[ DB ] CONNECT:[ UseTime:0.000335s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 9922 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.019464s ]
[ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1808 ) LIMIT 1 [ RunTime:0.000330s ]
[ DB ] CONNECT:[ UseTime:0.000347s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 5 ) LIMIT 1 [ RunTime:0.000235s ]