[ DB ] CONNECT:[ UseTime:0.006885s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.003766s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.001234s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.011012s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000291s ]
[ DB ] CONNECT:[ UseTime:0.000191s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000263s ]
[ DB ] CONNECT:[ UseTime:0.000065s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'sh' LIMIT 1 [ RunTime:0.014979s ]
[ DB ] CONNECT:[ UseTime:0.002507s ] 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.000420s ]
[ DB ] CONNECT:[ UseTime:0.000287s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001355s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000458s ]
[ DB ] CONNECT:[ UseTime:0.002190s ] 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.004011s ]
[ DB ] CONNECT:[ UseTime:0.000572s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.007313s ]
[ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.009006s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.005861s ]
[ DB ] CONNECT:[ UseTime:0.002787s ] 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.010038s ]
[ DB ] CONNECT:[ UseTime:0.007756s ] 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.012165s ]
[ DB ] CONNECT:[ UseTime:0.003310s ] 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.000445s ]
[ DB ] CONNECT:[ UseTime:0.000287s ] 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.000956s ]
[ DB ] CONNECT:[ UseTime:0.001266s ] 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.000846s ]
[ DB ] CONNECT:[ UseTime:0.000107s ] 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.000458s ]
[ DB ] CONNECT:[ UseTime:0.000098s ] 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.000456s ]
[ DB ] CONNECT:[ UseTime:0.000096s ] 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.000681s ]
[ DB ] CONNECT:[ UseTime:0.000101s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.003221s ]
[ 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.049299s ]
[ DB ] CONNECT:[ UseTime:0.000350s ] 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.000244s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000170s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000259s ]
[ DB ] CONNECT:[ UseTime:0.000056s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000166s ]
[ DB ] CONNECT:[ UseTime:0.000074s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000206s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1208 ) LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000354s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000182s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000178s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000162s ]
[ DB ] CONNECT:[ UseTime:0.000054s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000199s ]
[ DB ] CONNECT:[ UseTime:0.000063s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000249s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000219s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1208 ) LIMIT 1 [ RunTime:0.000192s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.000202s ]
[ DB ] CONNECT:[ UseTime:0.000080s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'sh' ) LIMIT 1 [ RunTime:0.002212s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000212s ]
[ DB ] CONNECT:[ UseTime:0.000075s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000225s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1208 ) LIMIT 1 [ RunTime:0.000187s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000233s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000297s ]
[ 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.000169s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000179s ]
[ DB ] CONNECT:[ UseTime:0.000087s ] 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(1405,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND `jg_class_tag` LIKE '%古琴%' LIMIT 1 [ RunTime:0.003043s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(1405,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND `jg_class_tag` LIKE '%古琴%' GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.101621s ]
[ DB ] CONNECT:[ UseTime:0.000079s ] 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.000148s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] 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.057740s ]
[ DB ] CONNECT:[ UseTime:0.000080s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001367s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 24514 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000560s ]
[ DB ] CONNECT:[ UseTime:0.000063s ] 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` = 24497 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000917s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] 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` = 3262 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000397s ]
[ DB ] CONNECT:[ UseTime:0.000058s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1405 ) LIMIT 1 [ RunTime:0.000180s ]
[ 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.000147s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 25 ) LIMIT 1 [ RunTime:0.000167s ]