[ DB ] CONNECT:[ UseTime:0.009808s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.015876s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.022827s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.025015s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.040468s ]
[ DB ] CONNECT:[ UseTime:0.006765s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.026547s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sjz' ) LIMIT 1 [ RunTime:0.013461s ]
[ DB ] CONNECT:[ UseTime:0.010830s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sjz' LIMIT 1 [ RunTime:0.021866s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sjz' LIMIT 1 [ RunTime:0.013248s ]
[ DB ] CONNECT:[ UseTime:0.008112s ] 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.021393s ]
[ DB ] CONNECT:[ UseTime:0.008634s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.021680s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.014582s ]
[ DB ] CONNECT:[ UseTime:0.004962s ] 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.007638s ]
[ DB ] CONNECT:[ UseTime:0.004115s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sjz' ) LIMIT 1 [ RunTime:0.008410s ]
[ DB ] CONNECT:[ UseTime:0.001935s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.015976s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.004926s ]
[ DB ] CONNECT:[ UseTime:0.002826s ] 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.005707s ]
[ DB ] CONNECT:[ UseTime:0.002443s ] 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.002180s ]
[ DB ] CONNECT:[ UseTime:0.001658s ] 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.004016s ]
[ DB ] CONNECT:[ UseTime:0.001442s ] 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.002115s ]
[ DB ] CONNECT:[ UseTime:0.001325s ] 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.002326s ]
[ DB ] CONNECT:[ UseTime:0.002996s ] 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.002563s ]
[ DB ] CONNECT:[ UseTime:0.003151s ] 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.016811s ]
[ DB ] CONNECT:[ UseTime:0.009314s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'sjz' LIMIT 1 [ RunTime:0.013459s ]
[ DB ] CONNECT:[ UseTime:0.005766s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.007200s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('43', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.515540s ]
[ DB ] CONNECT:[ UseTime:0.009301s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (1,2,4,1,2,3) [ RunTime:0.019352s ]
[ DB ] CONNECT:[ UseTime:0.005190s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 1 ) LIMIT 1 [ RunTime:0.022085s ]
[ DB ] CONNECT:[ UseTime:0.007810s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.016232s ]
[ DB ] CONNECT:[ UseTime:0.011167s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1632 ) LIMIT 1 [ RunTime:0.013463s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.017159s ]
[ DB ] CONNECT:[ UseTime:0.004580s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 1 ) LIMIT 1 [ RunTime:0.014329s ]
[ DB ] CONNECT:[ UseTime:0.008540s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.019142s ]
[ DB ] CONNECT:[ UseTime:0.008624s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.017379s ]
[ DB ] CONNECT:[ UseTime:0.011499s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.028880s ]
[ DB ] CONNECT:[ UseTime:0.007750s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1632 ) LIMIT 1 [ RunTime:0.021109s ]
[ DB ] CONNECT:[ UseTime:0.010064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sjz' ) LIMIT 1 [ RunTime:0.022069s ]
[ DB ] CONNECT:[ UseTime:0.004027s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sjz' ) LIMIT 1 [ RunTime:0.005815s ]
[ DB ] CONNECT:[ UseTime:0.005226s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.013158s ]
[ DB ] CONNECT:[ UseTime:0.007756s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.015943s ]
[ DB ] CONNECT:[ UseTime:0.008293s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1632 ) LIMIT 1 [ RunTime:0.021569s ]
[ DB ] CONNECT:[ UseTime:0.005315s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.027001s ]
[ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 1 ) LIMIT 1 [ RunTime:0.027005s ]
[ DB ] CONNECT:[ UseTime:0.014602s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT COUNT(*) AS tp_count FROM clt_jigou as jg LEFT JOIN `clt_jg_renzheng` `renzheng` ON `jg`.`id`=`renzheng`.`jg_id` WHERE ( FIND_IN_SET(1688,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 9 AND jg_age_max >= 10 ) AND ( FIND_IN_SET(1,jg_class) ) LIMIT 1 [ RunTime:0.559998s ]
[ DB ] CONNECT:[ UseTime:0.052311s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(1688,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 9 AND jg_age_max >= 10 ) AND ( FIND_IN_SET(1,jg_class) ) GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:1.602308s ]
[ DB ] CONNECT:[ UseTime:0.008905s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE ( jx = 'sjz' ) LIMIT 1 [ RunTime:0.003694s ]
[ DB ] CONNECT:[ UseTime:0.004847s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(43, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.584132s ]
[ DB ] CONNECT:[ UseTime:0.016942s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.055325s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 17603 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.024016s ]
[ DB ] CONNECT:[ UseTime:0.026988s ] 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` = 17811 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.036684s ]
[ DB ] CONNECT:[ UseTime:0.013979s ] 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` = 17201 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.021242s ]
[ DB ] CONNECT:[ UseTime:0.005484s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1688 ) LIMIT 1 [ RunTime:0.020469s ]
[ DB ] CONNECT:[ UseTime:0.004310s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 1 ) LIMIT 1 [ RunTime:0.025802s ]