[ DB ] CONNECT:[ UseTime:0.004840s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.014971s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000465s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.002321s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000213s ]
[ DB ] CONNECT:[ UseTime:0.000066s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001745s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000192s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.003268s ]
[ DB ] CONNECT:[ UseTime:0.016644s ] 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.000439s ]
[ DB ] CONNECT:[ UseTime:0.000407s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001350s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000481s ]
[ DB ] CONNECT:[ UseTime:0.000137s ] 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.000378s ]
[ DB ] CONNECT:[ UseTime:0.000164s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000461s ]
[ DB ] CONNECT:[ UseTime:0.000171s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001945s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000734s ]
[ DB ] CONNECT:[ UseTime:0.000195s ] 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.000506s ]
[ DB ] CONNECT:[ UseTime:0.000138s ] 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.000412s ]
[ DB ] CONNECT:[ UseTime:0.000164s ] 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.000350s ]
[ DB ] CONNECT:[ UseTime:0.000133s ] 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.000422s ]
[ DB ] CONNECT:[ UseTime:0.000148s ] 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.000398s ]
[ DB ] CONNECT:[ UseTime:0.000184s ] 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.000440s ]
[ DB ] CONNECT:[ UseTime:0.000153s ] 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.000409s ]
[ DB ] CONNECT:[ UseTime:0.000152s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.000424s ]
[ DB ] CONNECT:[ UseTime:0.000140s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001767s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('37', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.041441s ]
[ DB ] CONNECT:[ UseTime:0.000089s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (4,75,1,2,69,1,2,2,1,2,5) [ RunTime:0.000188s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 6 ) LIMIT 1 [ RunTime:0.000148s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000191s ]
[ DB ] CONNECT:[ UseTime:0.000066s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1209 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000293s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 6 ) LIMIT 1 [ RunTime:0.000143s ]
[ DB ] CONNECT:[ UseTime:0.000044s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000164s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000197s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000155s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1209 ) LIMIT 1 [ RunTime:0.000164s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000194s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000168s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000162s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000191s ]
[ DB ] CONNECT:[ UseTime:0.000042s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1209 ) LIMIT 1 [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 6 ) LIMIT 1 [ RunTime:0.000303s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] 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(1412,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) AND ( FIND_IN_SET(6,jg_class) ) LIMIT 1 [ RunTime:0.003081s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(1412,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 3 AND jg_age_max >= 4 ) AND ( FIND_IN_SET(6,jg_class) ) GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.131592s ]
[ DB ] CONNECT:[ UseTime:0.000323s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000334s ]
[ DB ] CONNECT:[ UseTime:0.000717s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(37, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.066408s ]
[ DB ] CONNECT:[ UseTime:0.000222s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.002438s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 413 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000496s ]
[ DB ] CONNECT:[ UseTime:0.000327s ] 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` = 2298 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000457s ]
[ DB ] CONNECT:[ UseTime:0.000255s ] 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` = 1459 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000598s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1412 ) LIMIT 1 [ RunTime:0.000327s ]
[ DB ] CONNECT:[ UseTime:0.000209s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 6 ) LIMIT 1 [ RunTime:0.002146s ]