[ DB ] CONNECT:[ UseTime:0.000319s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.005298s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.001643s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000407s ]
[ DB ] CONNECT:[ UseTime:0.000477s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001170s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000313s ]
[ DB ] CONNECT:[ UseTime:0.005731s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.000449s ]
[ DB ] CONNECT:[ UseTime:0.000875s ] 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.000411s ]
[ DB ] CONNECT:[ UseTime:0.012481s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.012360s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000354s ]
[ DB ] CONNECT:[ UseTime:0.000317s ] 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.000241s ]
[ DB ] CONNECT:[ UseTime:0.000299s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000283s ]
[ DB ] CONNECT:[ UseTime:0.000307s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001320s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69,75,76) ORDER BY `sort` [ RunTime:0.000346s ]
[ DB ] CONNECT:[ UseTime:0.000333s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 1 ) [ RunTime:0.000196s ]
[ DB ] CONNECT:[ UseTime:0.000280s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 2 ) [ RunTime:0.000222s ]
[ DB ] CONNECT:[ UseTime:0.000278s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 3 ) [ RunTime:0.000216s ]
[ DB ] CONNECT:[ UseTime:0.000281s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 4 ) [ RunTime:0.000207s ]
[ DB ] CONNECT:[ UseTime:0.000323s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 5 ) [ RunTime:0.000237s ]
[ DB ] CONNECT:[ UseTime:0.000284s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 6 ) [ RunTime:0.000248s ]
[ DB ] CONNECT:[ UseTime:0.000332s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 75 ) [ RunTime:0.000210s ]
[ DB ] CONNECT:[ UseTime:0.000360s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 76 ) [ RunTime:0.000217s ]
[ DB ] CONNECT:[ UseTime:0.000890s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 69 ) [ RunTime:0.000455s ]
[ DB ] CONNECT:[ UseTime:0.009800s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.011079s ]
[ DB ] CONNECT:[ UseTime:0.003896s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001363s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(36,jg_pcd) ) AND ( status = 1 ) ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.000584s ]
[ DB ] CONNECT:[ UseTime:0.007404s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000263s ]
[ DB ] CONNECT:[ UseTime:0.000363s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000223s ]
[ DB ] CONNECT:[ UseTime:0.000287s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000246s ]
[ DB ] CONNECT:[ UseTime:0.000290s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000227s ]
[ DB ] CONNECT:[ UseTime:0.000314s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000223s ]
[ DB ] CONNECT:[ UseTime:0.000364s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000231s ]
[ DB ] CONNECT:[ UseTime:0.000268s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000227s ]
[ DB ] CONNECT:[ UseTime:0.000306s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 76 LIMIT 1 [ RunTime:0.000224s ]
[ DB ] CONNECT:[ UseTime:0.000299s ] 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.000797s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000248s ]
[ DB ] CONNECT:[ UseTime:0.002520s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000297s ]
[ DB ] CONNECT:[ UseTime:0.000414s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 807 ) LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000496s ]
[ DB ] CONNECT:[ UseTime:0.000280s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000270s ]
[ DB ] CONNECT:[ UseTime:0.002876s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000335s ]
[ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000260s ]
[ DB ] CONNECT:[ UseTime:0.000296s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 807 ) LIMIT 1 [ RunTime:0.000262s ]
[ DB ] CONNECT:[ UseTime:0.002194s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000285s ]
[ DB ] CONNECT:[ UseTime:0.006446s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000297s ]
[ DB ] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000279s ]
[ DB ] CONNECT:[ UseTime:0.000332s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000297s ]
[ DB ] CONNECT:[ UseTime:0.000816s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 807 ) LIMIT 1 [ RunTime:0.000348s ]
[ DB ] CONNECT:[ UseTime:0.000406s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000269s ]
[ DB ] CONNECT:[ UseTime:0.002560s ] 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(979,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) [ RunTime:0.064975s ]
[ DB ] CONNECT:[ UseTime:0.000446s ] 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(979,jg_pcd) ) AND ( status = 1 ) AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) GROUP BY `jg`.`id` ORDER BY `jg`.`jg_shoucang_num` DESC,`renzheng`.`rezhengtime` DESC LIMIT 0,10 [ RunTime:0.049310s ]
[ DB ] CONNECT:[ UseTime:0.000320s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jg_renzheng` [ RunTime:0.001469s ]
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 31068 ) LIMIT 1 [ RunTime:0.000317s ]
[ DB ] CONNECT:[ UseTime:0.000240s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001577s ]
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 31068 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.017644s ]
[ DB ] CONNECT:[ UseTime:0.004800s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 30980 ) LIMIT 1 [ RunTime:0.000863s ]
[ DB ] CONNECT:[ UseTime:0.001199s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 30980 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.025861s ]
[ DB ] CONNECT:[ UseTime:0.000770s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 33900 ) LIMIT 1 [ RunTime:0.000332s ]
[ DB ] CONNECT:[ UseTime:0.000344s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 33900 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.024961s ]
[ DB ] CONNECT:[ UseTime:0.000487s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE ( jg_id = 29116 ) LIMIT 1 [ RunTime:0.000457s ]
[ DB ] CONNECT:[ UseTime:0.000349s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 29116 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.017521s ]
[ DB ] CONNECT:[ UseTime:0.000354s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 31044 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.024959s ]
[ DB ] CONNECT:[ UseTime:0.017609s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 31039 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.028689s ]
[ DB ] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 31393 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.026107s ]
[ DB ] CONNECT:[ UseTime:0.000558s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 27096 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.024609s ]
[ DB ] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 28406 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.029397s ]
[ DB ] CONNECT:[ UseTime:0.000718s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_kecheng` WHERE ( kc_jg_id = 28713 ) AND ( kc_shitingke = '1' ) LIMIT 1 [ RunTime:0.025907s ]
[ DB ] CONNECT:[ UseTime:0.000798s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 979 ) LIMIT 1 [ RunTime:0.000258s ]