[ DB ] CONNECT:[ UseTime:0.000080s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.001759s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.002381s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000427s ]
[ DB ] CONNECT:[ UseTime:0.000080s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000264s ]
[ DB ] CONNECT:[ UseTime:0.000058s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'cd' LIMIT 1 [ RunTime:0.000277s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] 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.000274s ]
[ DB ] CONNECT:[ UseTime:0.000067s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.002778s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ DB ] CONNECT:[ UseTime:0.000038s ] 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.000116s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000132s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.000894s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000150s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] 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.000167s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] 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.000113s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] 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.000104s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] 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.000109s ]
[ DB ] CONNECT:[ UseTime:0.000041s ] 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.000110s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] 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.000107s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] 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.000107s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] 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.000193s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001435s ]
[ 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.030405s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] 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.000173s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000120s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000107s ]
[ DB ] CONNECT:[ UseTime:0.000038s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000093s ]
[ DB ] CONNECT:[ UseTime:0.000034s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000104s ]
[ DB ] CONNECT:[ UseTime:0.000039s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2832 ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000160s ]
[ DB ] CONNECT:[ UseTime:0.000033s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000082s ]
[ DB ] CONNECT:[ UseTime:0.000032s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000107s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000086s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000098s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000092s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000094s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2832 ) LIMIT 1 [ RunTime:0.000093s ]
[ DB ] CONNECT:[ UseTime:0.000042s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000126s ]
[ DB ] CONNECT:[ UseTime:0.000033s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'cd' ) LIMIT 1 [ RunTime:0.000097s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000094s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000093s ]
[ DB ] CONNECT:[ UseTime:0.000030s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2832 ) LIMIT 1 [ RunTime:0.000093s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000097s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000083s ]
[ DB ] CONNECT:[ UseTime:0.000030s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000084s ]
[ DB ] CONNECT:[ UseTime:0.000030s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000081s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] 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(2927,jg_pcd) ) AND `status` = '1' AND ( jg_age_max >= 16 ) AND `jg_class_tag` LIKE '%扬琴%' LIMIT 1 [ RunTime:0.002455s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(2927,jg_pcd) ) AND `status` = '1' AND ( jg_age_max >= 16 ) AND `jg_class_tag` LIKE '%扬琴%' GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.102158s ]
[ DB ] CONNECT:[ UseTime:0.000107s ] 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.000173s ]
[ DB ] CONNECT:[ UseTime:0.000065s ] 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.036135s ]
[ DB ] CONNECT:[ UseTime:0.000044s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001198s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 11963 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000261s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] 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` = 12289 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000187s ]
[ DB ] CONNECT:[ UseTime:0.000041s ] 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` = 12171 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000242s ]
[ DB ] CONNECT:[ UseTime:0.000433s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2927 ) LIMIT 1 [ RunTime:0.000139s ]
[ 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.000102s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 13 ) LIMIT 1 [ RunTime:0.000098s ]