[ DB ] CONNECT:[ UseTime:0.012656s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.020003s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.005944s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.009861s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.005850s ]
[ DB ] CONNECT:[ UseTime:0.004001s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.013186s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'szs' ) LIMIT 1 [ RunTime:0.000617s ]
[ DB ] CONNECT:[ UseTime:0.000123s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'szs' LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'szs' LIMIT 1 [ RunTime:0.000557s ]
[ DB ] CONNECT:[ UseTime:0.000056s ] 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.000207s ]
[ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.002367s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000899s ]
[ DB ] CONNECT:[ UseTime:0.001424s ] 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.006339s ]
[ DB ] CONNECT:[ UseTime:0.001509s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'szs' ) LIMIT 1 [ RunTime:0.028027s ]
[ DB ] CONNECT:[ UseTime:0.015347s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.026011s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.014850s ]
[ DB ] CONNECT:[ UseTime:0.008796s ] 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.012894s ]
[ DB ] CONNECT:[ UseTime:0.007806s ] 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.024443s ]
[ DB ] CONNECT:[ UseTime:0.006900s ] 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.002206s ]
[ DB ] CONNECT:[ UseTime:0.001629s ] 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.002277s ]
[ DB ] CONNECT:[ UseTime:0.005849s ] 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.029007s ]
[ DB ] CONNECT:[ UseTime:0.030781s ] 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.022037s ]
[ DB ] CONNECT:[ UseTime:0.010698s ] 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.017670s ]
[ DB ] CONNECT:[ UseTime:0.000634s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'szs' LIMIT 1 [ RunTime:0.000183s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.020114s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('49', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.083301s ]
[ DB ] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (2,5,4,4,69,1,2) [ RunTime:0.000192s ]
[ DB ] CONNECT:[ UseTime:0.000086s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000171s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000178s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] 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.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000257s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000144s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000139s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000139s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.000164s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.000158s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'szs' ) LIMIT 1 [ RunTime:0.000189s ]
[ DB ] CONNECT:[ UseTime:0.000083s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'szs' ) LIMIT 1 [ RunTime:0.000225s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.000161s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.000187s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000141s ]
[ DB ] CONNECT:[ UseTime:0.000042s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000134s ]
[ DB ] CONNECT:[ UseTime:0.000044s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000141s ]
[ DB ] CONNECT:[ UseTime:0.000058s ] 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(1697,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND `jg_class_tag` LIKE '%钢琴%' LIMIT 1 [ RunTime:0.003597s ]
[ DB ] CONNECT:[ UseTime:0.000087s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(1697,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 0,10 [ RunTime:0.080914s ]
[ DB ] CONNECT:[ UseTime:0.010727s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.022723s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 18227 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.017208s ]
[ DB ] CONNECT:[ UseTime:0.001537s ] 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` = 18233 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.010844s ]
[ DB ] CONNECT:[ UseTime:0.003966s ] 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` = 18239 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.005096s ]
[ DB ] CONNECT:[ UseTime:0.002517s ] 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` = 18243 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.008144s ]
[ DB ] CONNECT:[ UseTime:0.006594s ] 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` = 18259 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.013512s ]
[ DB ] CONNECT:[ UseTime:0.013161s ] 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` = 18316 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.021236s ]
[ DB ] CONNECT:[ UseTime:0.007482s ] 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` = 18459 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.009350s ]
[ DB ] CONNECT:[ UseTime:0.002358s ] 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` = 18461 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.007080s ]
[ DB ] CONNECT:[ UseTime:0.004609s ] 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` = 18961 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.011312s ]
[ DB ] CONNECT:[ UseTime:0.002398s ] 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` = 18967 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.013416s ]
[ DB ] CONNECT:[ UseTime:0.003476s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 1697 ) LIMIT 1 [ RunTime:0.005417s ]
[ DB ] CONNECT:[ UseTime:0.001253s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.007419s ]
[ DB ] CONNECT:[ UseTime:0.000051s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 14 ) LIMIT 1 [ RunTime:0.000146s ]
