[ DB ] CONNECT:[ UseTime:0.012979s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_wx_config` [ RunTime:0.006480s ]
[ SQL ] SELECT * FROM `clt_wx_config` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.005331s ]
[ SQL ] SHOW COLUMNS FROM `clt_category` [ RunTime:0.007553s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.005808s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_region` [ RunTime:0.004988s ]
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'yc' ) LIMIT 1 [ RunTime:0.001465s ]
[ DB ] CONNECT:[ UseTime:0.000169s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'yc' LIMIT 1 [ RunTime:0.001139s ]
[ SQL ] SELECT * FROM `clt_region` WHERE `jx` = 'yc' LIMIT 1 [ RunTime:0.000309s ]
[ 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.000265s ]
[ DB ] CONNECT:[ UseTime:0.000095s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_ad` [ RunTime:0.001233s ]
[ SQL ] SELECT * FROM `clt_ad` WHERE ( type_id = 12 ) AND ( open = 1 ) LIMIT 1 [ RunTime:0.000255s ]
[ 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.000190s ]
[ DB ] CONNECT:[ UseTime:0.000056s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'yc' ) LIMIT 1 [ RunTime:0.000249s ]
[ DB ] CONNECT:[ UseTime:0.000074s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jgclass` [ RunTime:0.001269s ]
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( type = 0 ) AND `id` IN (1,2,3,4,5,6,69) ORDER BY `sort` [ RunTime:0.000300s ]
[ DB ] CONNECT:[ UseTime:0.000068s ] 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.000228s ]
[ DB ] CONNECT:[ UseTime:0.000069s ] 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.000233s ]
[ DB ] CONNECT:[ UseTime:0.000073s ] 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.000191s ]
[ DB ] CONNECT:[ UseTime:0.000104s ] 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.000226s ]
[ DB ] CONNECT:[ UseTime:0.000086s ] 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.000260s ]
[ DB ] CONNECT:[ UseTime:0.000081s ] 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.000257s ]
[ DB ] CONNECT:[ UseTime:0.000076s ] 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.000194s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE `jx` = 'yc' LIMIT 1 [ RunTime:0.000172s ]
[ DB ] CONNECT:[ UseTime:0.000070s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_jigou` [ RunTime:0.002168s ]
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET('70', jg_pcd) ) AND `status` = '1' ORDER BY `jg_yuyue_num` DESC LIMIT 10 [ RunTime:0.065674s ]
[ DB ] CONNECT:[ UseTime:0.000757s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE `id` IN (4,69,2) [ RunTime:0.000488s ]
[ DB ] CONNECT:[ UseTime:0.000607s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000180s ]
[ DB ] CONNECT:[ UseTime:0.000071s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000197s ]
[ DB ] CONNECT:[ UseTime:0.000060s ] 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.000049s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000155s ]
[ DB ] CONNECT:[ UseTime:0.000043s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2285 ) LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `clt_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000250s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000135s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000137s ]
[ DB ] CONNECT:[ UseTime:0.000040s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000135s ]
[ DB ] CONNECT:[ UseTime:0.000046s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000162s ]
[ DB ] CONNECT:[ UseTime:0.000042s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) 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_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000363s ]
[ DB ] CONNECT:[ UseTime:0.000096s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2285 ) LIMIT 1 [ RunTime:0.002715s ]
[ DB ] CONNECT:[ UseTime:0.000229s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'yc' ) LIMIT 1 [ RunTime:0.000701s ]
[ DB ] CONNECT:[ UseTime:0.000141s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( jx = 'yc' ) LIMIT 1 [ RunTime:0.000495s ]
[ DB ] CONNECT:[ UseTime:0.000150s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000454s ]
[ DB ] CONNECT:[ UseTime:0.000192s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000597s ]
[ DB ] CONNECT:[ UseTime:0.000118s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2285 ) LIMIT 1 [ RunTime:0.000438s ]
[ DB ] CONNECT:[ UseTime:0.000124s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000444s ]
[ DB ] CONNECT:[ UseTime:0.000203s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000626s ]
[ DB ] CONNECT:[ UseTime:0.000158s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000403s ]
[ DB ] CONNECT:[ UseTime:0.000157s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.001488s ]
[ DB ] CONNECT:[ UseTime:0.000168s ] 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(2292,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND `jg_class_tag` LIKE '%电子琴%' LIMIT 1 [ RunTime:0.013384s ]
[ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM clt_jigou as jg WHERE ( FIND_IN_SET(2292,jg_pcd) ) AND `status` = '1' AND ( jg_age_min <= 13 AND jg_age_max >= 14 ) AND `jg_class_tag` LIKE '%电子琴%' GROUP BY `jg`.`id` LIMIT 0,10 [ RunTime:0.192505s ]
[ DB ] CONNECT:[ UseTime:0.008178s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT `id` FROM `clt_region` WHERE ( jx = 'yc' ) LIMIT 1 [ RunTime:0.000993s ]
[ DB ] CONNECT:[ UseTime:0.000061s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jigou` WHERE ( FIND_IN_SET(70, jg_pcd) ) AND `status` = '1' ORDER BY rand() LIMIT 3 [ RunTime:0.048728s ]
[ DB ] CONNECT:[ UseTime:0.000681s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_kecheng` [ RunTime:0.013005s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_kecheng` WHERE `kc_jg_id` = 21601 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.006116s ]
[ DB ] CONNECT:[ UseTime:0.000066s ] 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` = 21528 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000260s ]
[ 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_kecheng` WHERE `kc_jg_id` = 21514 AND `kc_shitingke` = '1' LIMIT 1 [ RunTime:0.000299s ]
[ DB ] CONNECT:[ UseTime:0.000059s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_region` WHERE ( id = 2292 ) LIMIT 1 [ RunTime:0.000205s ]
[ DB ] CONNECT:[ UseTime:0.000050s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 2 ) LIMIT 1 [ RunTime:0.000153s ]
[ DB ] CONNECT:[ UseTime:0.000083s ] mysql:host=127.0.0.1;port=3306;dbname=zaoyiwang;charset=utf8
[ SQL ] SELECT * FROM `clt_jgclass` WHERE ( id = 33 ) LIMIT 1 [ RunTime:0.000145s ]
