[ DB ] CONNECT:[ UseTime:0.000148s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.002053s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.012702s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.011046s ]
[ DB ] CONNECT:[ UseTime:0.007762s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001902s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000258s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.002232s ]
[ DB ] CONNECT:[ UseTime:0.000086s ] 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.000218s ]
[ DB ] CONNECT:[ UseTime:0.000078s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001871s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000212s ]
[ DB ] CONNECT:[ UseTime:0.000084s ] 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.000171s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000168s ]
[ DB ] CONNECT:[ UseTime:0.000062s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001156s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000217s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] 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.000192s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] 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.000176s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] 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.000165s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] 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.000212s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] 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.000170s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] 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.000162s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] 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.000159s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] 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.000128s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001480s ]
[ 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.033738s ]
[ DB ] CONNECT:[ UseTime:0.000070s ] 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.000205s ]
[ DB ] CONNECT:[ UseTime:0.000084s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000165s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000147s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000143s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000173s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2829 ) LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000317s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000146s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000142s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000147s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000179s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000077s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000165s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2829 ) LIMIT 1 [ RunTime:0.000162s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000164s ]
[ DB ] CONNECT:[ UseTime:0.000074s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000168s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000163s ]
[ DB ] CONNECT:[ UseTime:0.000070s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2829 ) LIMIT 1 [ RunTime:0.000163s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000142s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.001002s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000128s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] 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(2852,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 9 AND jg_age_max >= 10 ) AND `jg_class_tag` LIKE '%萧%' LIMIT 1 [ RunTime:0.031063s ]
[ DB ] CONNECT:[ UseTime:0.000231s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(2852,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 9 AND jg_age_max >= 10 ) AND `jg_class_tag` LIKE '%萧%' GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.088479s ]
[ DB ] CONNECT:[ UseTime:0.000081s ] 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.000188s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(44, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.052648s ]
[ DB ] CONNECT:[ UseTime:0.000071s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.018864s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 11862 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000952s ]
[ DB ] CONNECT:[ UseTime:0.001179s ] 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` = 12678 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000658s ]
[ DB ] CONNECT:[ UseTime:0.000066s ] 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` = 12381 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000489s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2852 ) LIMIT 1 [ RunTime:0.000172s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000144s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 27 ) LIMIT 1 [ RunTime:0.000144s ]