[ DB ] CONNECT:[ UseTime:0.015312s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.020022s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.040474s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.029030s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.017630s ]
[ DB ] CONNECT:[ UseTime:0.014816s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.021231s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.016068s ]
[ DB ] CONNECT:[ UseTime:0.003992s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.009442s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.007714s ]
[ DB ] CONNECT:[ UseTime:0.007020s ] 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.015838s ]
[ DB ] CONNECT:[ UseTime:0.005286s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.007318s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.006795s ]
[ DB ] CONNECT:[ UseTime:0.006083s ] 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.007245s ]
[ DB ] CONNECT:[ UseTime:0.017556s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.005648s ]
[ DB ] CONNECT:[ UseTime:0.003490s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.004221s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.007372s ]
[ DB ] CONNECT:[ UseTime:0.008243s ] 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.000614s ]
[ DB ] CONNECT:[ UseTime:0.000171s ] 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.000492s ]
[ DB ] CONNECT:[ UseTime:0.000162s ] 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.000489s ]
[ DB ] CONNECT:[ UseTime:0.000159s ] 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.001882s ]
[ DB ] CONNECT:[ UseTime:0.002238s ] 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.004591s ]
[ DB ] CONNECT:[ UseTime:0.003473s ] 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.005392s ]
[ DB ] CONNECT:[ UseTime:0.001274s ] 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.000541s ]
[ DB ] CONNECT:[ UseTime:0.000833s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.002789s ]
[ DB ] CONNECT:[ UseTime:0.000273s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.003759s ]
[ 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.672909s ]
[ DB ] CONNECT:[ UseTime:0.030633s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (5,2,4,5,4,1,2,1,2,4,5) [ RunTime:0.014245s ]
[ DB ] CONNECT:[ UseTime:0.012414s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.022172s ]
[ DB ] CONNECT:[ UseTime:0.018662s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.022007s ]
[ DB ] CONNECT:[ UseTime:0.010699s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2833 ) LIMIT 1 [ RunTime:0.005643s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.010309s ]
[ DB ] CONNECT:[ UseTime:0.006017s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.004827s ]
[ DB ] CONNECT:[ UseTime:0.005523s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.004149s ]
[ DB ] CONNECT:[ UseTime:0.005642s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.004161s ]
[ DB ] CONNECT:[ UseTime:0.005638s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.010196s ]
[ DB ] CONNECT:[ UseTime:0.004633s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2833 ) LIMIT 1 [ RunTime:0.007265s ]
[ DB ] CONNECT:[ UseTime:0.004848s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.008919s ]
[ DB ] CONNECT:[ UseTime:0.004694s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.007193s ]
[ DB ] CONNECT:[ UseTime:0.003986s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.009666s ]
[ DB ] CONNECT:[ UseTime:0.001809s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.010985s ]
[ DB ] CONNECT:[ UseTime:0.004920s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2833 ) LIMIT 1 [ RunTime:0.006872s ]
[ DB ] CONNECT:[ UseTime:0.005807s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.004984s ]
[ DB ] CONNECT:[ UseTime:0.007794s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.009069s ]
[ DB ] CONNECT:[ UseTime:0.004891s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM clt_jigou as jg JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(2945,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) AND ( FIND_IN_SET(4,jg_class) ) LIMIT 1 [ RunTime:0.070245s ]
[ DB ] CONNECT:[ UseTime:0.003489s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(2945,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) AND ( FIND_IN_SET(4,jg_class) ) GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.419373s ]
[ DB ] CONNECT:[ UseTime:0.001760s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.004704s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 12127 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000396s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 12141 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000343s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2945 ) LIMIT 1 [ RunTime:0.000226s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.000243s ]
