[ DB ] CONNECT:[ UseTime:0.004662s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.014998s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.008885s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.005305s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.008576s ]
[ DB ] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.002157s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000557s ]
[ DB ] CONNECT:[ UseTime:0.000336s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'bj' LIMIT 1 [ RunTime:0.035591s ]
[ DB ] CONNECT:[ UseTime:0.010219s ] 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.021392s ]
[ DB ] CONNECT:[ UseTime:0.000555s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.002847s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000202s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] 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.000157s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000197s ]
[ DB ] CONNECT:[ UseTime:0.000122s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.002668s ]
[ 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.000445s ]
[ DB ] CONNECT:[ UseTime:0.000217s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 1 ) [ RunTime:0.000159s ]
[ DB ] CONNECT:[ UseTime:0.000110s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 2 ) [ RunTime:0.000216s ]
[ DB ] CONNECT:[ UseTime:0.000045s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 3 ) [ RunTime:0.000139s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 4 ) [ RunTime:0.000151s ]
[ DB ] CONNECT:[ UseTime:0.000074s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 5 ) [ RunTime:0.000186s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 6 ) [ 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 ( pid = 75 ) [ RunTime:0.000153s ]
[ DB ] CONNECT:[ UseTime:0.000067s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 76 ) [ RunTime:0.000146s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( pid = 69 ) [ RunTime:0.000137s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] 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.000151s ]
[ DB ] CONNECT:[ UseTime:0.000150s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.002091s ]
[ 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.053317s ]
[ DB ] CONNECT:[ UseTime:0.001542s ] 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.002374s ]
[ DB ] CONNECT:[ UseTime:0.000286s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000538s ]
[ DB ] CONNECT:[ UseTime:0.000161s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000440s ]
[ DB ] CONNECT:[ UseTime:0.000178s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.000873s ]
[ DB ] CONNECT:[ UseTime:0.001152s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.001094s ]
[ DB ] CONNECT:[ UseTime:0.000145s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 800 ) LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000567s ]
[ DB ] CONNECT:[ UseTime:0.000238s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000443s ]
[ DB ] CONNECT:[ UseTime:0.000155s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000444s ]
[ DB ] CONNECT:[ UseTime:0.000161s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.000425s ]
[ DB ] CONNECT:[ UseTime:0.000149s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000445s ]
[ DB ] CONNECT:[ UseTime:0.000180s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000449s ]
[ DB ] CONNECT:[ UseTime:0.000168s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000449s ]
[ DB ] CONNECT:[ UseTime:0.000132s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 800 ) LIMIT 1 [ RunTime:0.000402s ]
[ DB ] CONNECT:[ UseTime:0.000454s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000243s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'bj' ) LIMIT 1 [ RunTime:0.000167s ]
[ DB ] CONNECT:[ UseTime:0.001087s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000483s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000167s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 800 ) LIMIT 1 [ RunTime:0.000155s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000201s ]
[ DB ] CONNECT:[ UseTime:0.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000142s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.000205s ]
[ DB ] CONNECT:[ UseTime:0.000072s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000166s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] 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(822,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 15 AND jg_age_max >= 16 ) AND `jg_class_tag` LIKE '%水粉%' LIMIT 1 [ RunTime:0.003141s ]
[ DB ] CONNECT:[ UseTime:0.000079s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(822,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 15 AND jg_age_max >= 16 ) AND `jg_class_tag` LIKE '%水粉%' GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.118270s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.002161s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 952 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000335s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] 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` = 994 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000299s ]
[ DB ] CONNECT:[ UseTime:0.000048s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jg_renzheng` [ RunTime:0.001700s ]
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE `jg_id` = 1046 LIMIT 1 [ RunTime:0.000240s ]
[ DB ] CONNECT:[ UseTime:0.000047s ] 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` = 1046 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000280s ]
[ DB ] CONNECT:[ UseTime:0.000063s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jg_renzheng` WHERE `jg_id` = 4584 LIMIT 1 [ RunTime:0.000206s ]
[ 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` = 4584 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000238s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] 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` = 4720 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000454s ]
[ 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_kecheng` WHERE `kc_jg_id` = 24751 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.001459s ]
[ DB ] CONNECT:[ UseTime:0.000062s ] 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` = 25401 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000259s ]
[ DB ] CONNECT:[ UseTime:0.005355s ] 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` = 25442 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.002709s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] 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` = 29438 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000351s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] 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` = 29963 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000306s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 822 ) LIMIT 1 [ RunTime:0.000183s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 4 ) LIMIT 1 [ RunTime:0.000189s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 45 ) LIMIT 1 [ RunTime:0.000174s ]