[ DB ] CONNECT:[ UseTime:0.000100s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.001268s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.001120s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.018726s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.017829s ]
[ DB ] CONNECT:[ UseTime:0.011434s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.026946s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.004589s ]
[ DB ] CONNECT:[ UseTime:0.008862s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.007304s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.000235s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] 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.000231s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001622s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000888s ]
[ DB ] CONNECT:[ UseTime:0.000333s ] 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.000370s ]
[ DB ] CONNECT:[ UseTime:0.000408s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.001463s ]
[ DB ] CONNECT:[ UseTime:0.000304s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001504s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69,75,76) ORDER BY `sort` [ RunTime:0.000424s ]
[ DB ] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 1 ) [ RunTime:0.001349s ]
[ DB ] CONNECT:[ UseTime:0.000276s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 2 ) [ RunTime:0.000484s ]
[ DB ] CONNECT:[ UseTime:0.000162s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 3 ) [ RunTime:0.000405s ]
[ DB ] CONNECT:[ UseTime:0.000228s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 4 ) [ RunTime:0.000432s ]
[ DB ] CONNECT:[ UseTime:0.000152s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 5 ) [ RunTime:0.000462s ]
[ DB ] CONNECT:[ UseTime:0.000159s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 6 ) [ RunTime:0.000399s ]
[ DB ] CONNECT:[ UseTime:0.000162s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 75 ) [ RunTime:0.000422s ]
[ DB ] CONNECT:[ UseTime:0.000162s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 76 ) [ RunTime:0.000474s ]
[ DB ] CONNECT:[ UseTime:0.000142s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 69 ) [ RunTime:0.000393s ]
[ DB ] CONNECT:[ UseTime:0.000147s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.000347s ]
[ DB ] CONNECT:[ UseTime:0.000597s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.002550s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('36', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.000873s ]
[ DB ] CONNECT:[ UseTime:0.000169s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (4,75,6,76,5) [ RunTime:0.000415s ]
[ DB ] CONNECT:[ UseTime:0.000157s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000367s ]
[ DB ] CONNECT:[ UseTime:0.000145s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000390s ]
[ DB ] CONNECT:[ UseTime:0.000152s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 75 ) LIMIT 1 [ RunTime:0.000388s ]
[ DB ] CONNECT:[ UseTime:0.000165s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000769s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000602s ]
[ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000627s ]
[ DB ] CONNECT:[ UseTime:0.000164s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000284s ]
[ DB ] CONNECT:[ UseTime:0.000072s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 75 ) LIMIT 1 [ RunTime:0.000117s ]
[ DB ] CONNECT:[ UseTime:0.000036s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000165s ]
[ DB ] CONNECT:[ UseTime:0.000076s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000153s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000120s ]
[ DB ] CONNECT:[ UseTime:0.000034s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000143s ]
[ DB ] CONNECT:[ UseTime:0.000041s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000114s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000108s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000104s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 75 ) LIMIT 1 [ RunTime:0.000093s ]
[ DB ] CONNECT:[ UseTime:0.000038s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 82 ) LIMIT 1 [ RunTime:0.000099s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] 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(801,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 11 AND jg_age_max >= 12 ) AND `jg_class_tag` LIKE '%滑雪%' LIMIT 1 [ RunTime:0.030795s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(801,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.089606s ]
[ DB ] CONNECT:[ UseTime:0.000213s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000184s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(36, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.062805s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jg_renzheng` [ RunTime:0.001066s ]
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE `jg_id` = 238809 LIMIT 1 [ RunTime:0.000204s ]
[ DB ] CONNECT:[ UseTime:0.000040s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001109s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 238809 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000331s ]
[ 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` = 31335 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000264s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] 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` = 4391 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000244s ]
[ DB ] CONNECT:[ UseTime:0.000044s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 801 ) LIMIT 1 [ RunTime:0.000126s ]
[ DB ] CONNECT:[ UseTime:0.000037s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 75 ) LIMIT 1 [ 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 ( id = 82 ) LIMIT 1 [ RunTime:0.000120s ]
