[ DB ] CONNECT:[ UseTime:0.000235s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.001624s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000697s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.001502s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000199s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.001073s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'zz' ) LIMIT 1 [ RunTime:0.000178s ]
[ DB ] CONNECT:[ UseTime:0.000040s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'zz' LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'zz' LIMIT 1 [ RunTime:0.000194s ]
[ DB ] CONNECT:[ UseTime:0.000033s ] 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.000122s ]
[ DB ] CONNECT:[ UseTime:0.000039s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.000994s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000143s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] 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.000086s ]
[ DB ] CONNECT:[ UseTime:0.000029s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'zz' ) LIMIT 1 [ RunTime:0.000094s ]
[ DB ] CONNECT:[ UseTime:0.000042s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.000918s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000148s ]
[ 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.000094s ]
[ DB ] CONNECT:[ UseTime:0.000029s ] 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.000103s ]
[ DB ] CONNECT:[ UseTime:0.000031s ] 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.000108s ]
[ DB ] CONNECT:[ UseTime:0.000067s ] 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.000153s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] 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.000128s ]
[ DB ] CONNECT:[ UseTime:0.000039s ] 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.000121s ]
[ DB ] CONNECT:[ UseTime:0.000039s ] 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.000142s ]
[ DB ] CONNECT:[ UseTime:0.000040s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'zz' LIMIT 1 [ RunTime:0.000112s ]
[ DB ] CONNECT:[ UseTime:0.000038s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.001117s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('55', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.036262s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (5,4,2,1,2) [ RunTime:0.000203s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 3 ) LIMIT 1 [ RunTime:0.000158s ]
[ DB ] CONNECT:[ UseTime:0.000056s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000174s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2525 ) LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000296s ]
[ DB ] CONNECT:[ UseTime:0.000057s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 3 ) LIMIT 1 [ RunTime:0.000151s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000196s ]
[ DB ] CONNECT:[ UseTime:0.000055s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000162s ]
[ DB ] CONNECT:[ UseTime:0.000040s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000130s ]
[ DB ] CONNECT:[ UseTime:0.000035s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2525 ) LIMIT 1 [ RunTime:0.000113s ]
[ DB ] CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'zz' ) LIMIT 1 [ RunTime:0.000133s ]
[ DB ] CONNECT:[ UseTime:0.000037s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'zz' ) LIMIT 1 [ RunTime:0.000112s ]
[ DB ] CONNECT:[ UseTime:0.000033s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000112s ]
[ DB ] CONNECT:[ UseTime:0.000034s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000109s ]
[ DB ] CONNECT:[ UseTime:0.000032s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2525 ) LIMIT 1 [ RunTime:0.000136s ]
[ DB ] CONNECT:[ UseTime:0.000038s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000113s ]
[ DB ] CONNECT:[ UseTime:0.000033s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 3 ) LIMIT 1 [ RunTime:0.000139s ]
[ DB ] CONNECT:[ UseTime:0.000056s ] 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(2537,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND ( FIND_IN_SET(3,jg_class) ) LIMIT 1 [ RunTime:0.002360s ]
[ DB ] CONNECT:[ UseTime:0.000120s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(2537,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND ( FIND_IN_SET(3,jg_class) ) GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.101174s ]
[ DB ] CONNECT:[ UseTime:0.000081s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE ( jx = 'zz' ) LIMIT 1 [ RunTime:0.000132s ]
[ DB ] CONNECT:[ UseTime:0.000052s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(55, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.031787s ]
[ DB ] CONNECT:[ UseTime:0.000080s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.001437s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 20406 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000367s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] 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` = 20396 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000380s ]
[ DB ] CONNECT:[ UseTime:0.000063s ] 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` = 20267 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000298s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2537 ) LIMIT 1 [ RunTime:0.000207s ]
[ DB ] CONNECT:[ UseTime:0.000053s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 3 ) LIMIT 1 [ RunTime:0.000155s ]