[ DB ] CONNECT:[ UseTime:0.003049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.006595s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.005469s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.001389s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000194s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.002251s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000241s ]
[ DB ] CONNECT:[ UseTime:0.000134s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'ty' LIMIT 1 [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'ty' LIMIT 1 [ RunTime:0.000536s ]
[ DB ] CONNECT:[ UseTime:0.000268s ] 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.000368s ]
[ DB ] CONNECT:[ UseTime:0.000247s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001325s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.005708s ]
[ DB ] CONNECT:[ UseTime:0.000871s ] 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.000590s ]
[ DB ] CONNECT:[ UseTime:0.002577s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.025452s ]
[ DB ] CONNECT:[ UseTime:0.009358s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.005118s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000431s ]
[ DB ] CONNECT:[ UseTime:0.000266s ] 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.000296s ]
[ DB ] CONNECT:[ UseTime:0.000289s ] 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.005018s ]
[ DB ] CONNECT:[ UseTime:0.002768s ] 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.001130s ]
[ DB ] CONNECT:[ UseTime:0.000277s ] 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.000368s ]
[ DB ] CONNECT:[ UseTime:0.000207s ] 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.000303s ]
[ DB ] CONNECT:[ UseTime:0.000286s ] 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.000312s ]
[ DB ] CONNECT:[ UseTime:0.000235s ] 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.001256s ]
[ DB ] CONNECT:[ UseTime:0.000619s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'ty' LIMIT 1 [ RunTime:0.000200s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001614s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('42', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.042784s ]
[ DB ] CONNECT:[ UseTime:0.000067s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (4,1,2,1,2) [ RunTime:0.000178s ]
[ DB ] CONNECT:[ UseTime:0.000077s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000186s ]
[ DB ] CONNECT:[ UseTime:0.005018s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000610s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000181s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000295s ]
[ DB ] CONNECT:[ UseTime:0.000737s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.001101s ]
[ DB ] CONNECT:[ UseTime:0.000141s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000607s ]
[ DB ] CONNECT:[ UseTime:0.000144s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000340s ]
[ DB ] CONNECT:[ UseTime:0.000096s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000315s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'ty' ) LIMIT 1 [ RunTime:0.000163s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000185s ]
[ DB ] CONNECT:[ UseTime:0.000058s ] 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.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000138s ]
[ DB ] CONNECT:[ UseTime:0.000054s ] 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(42,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND `jg_class_tag` LIKE '%吉他%' LIMIT 1 [ RunTime:0.057797s ]
[ DB ] CONNECT:[ UseTime:0.005044s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(42,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND `jg_class_tag` LIKE '%吉他%' GROUP BY `jg`.`id` LIMIT 20,10 [ RunTime:0.084088s ]
[ DB ] CONNECT:[ UseTime:0.008676s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.002249s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 9869 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.006618s ]
[ DB ] CONNECT:[ UseTime:0.003309s ] 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` = 10087 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.010853s ]
[ DB ] CONNECT:[ UseTime:0.000197s ] 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` = 10094 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.001116s ]
[ DB ] CONNECT:[ UseTime:0.000143s ] 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` = 10096 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000724s ]
[ DB ] CONNECT:[ UseTime:0.000251s ] 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` = 10103 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.022493s ]
[ DB ] CONNECT:[ UseTime:0.000070s ] 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` = 10106 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000319s ]
[ DB ] CONNECT:[ UseTime:0.000605s ] 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` = 10114 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.002427s ]
[ DB ] CONNECT:[ UseTime:0.003636s ] 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` = 10116 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.003698s ]
[ DB ] CONNECT:[ UseTime:0.000074s ] 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` = 10125 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000400s ]
[ 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_kecheng` WHERE `kc_jg_id` = 10130 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000246s ]
[ 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.000152s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 18 ) LIMIT 1 [ RunTime:0.000140s ]
