[ DB ] CONNECT:[ UseTime:0.010000s ] mysql:host=127.0.0.1;port=3312;dbname=tzwlpzw_data;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wl_line` [ RunTime:0.003000s ]
[ SQL ] SELECT a.line_departure_city_id AS departure_id,b.region_name AS departure_name,`f`.`transport_type_id` FROM `wl_line` `a` LEFT JOIN `wl_region` `b` ON `a`.`line_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`line_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_line_carbody_relation` `d` ON `d`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carlength_relation` `e` ON `e`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_transport_relation` `f` ON `f`.`line_id`=`a`.`line_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 GROUP BY `f`.`transport_type_id`,`a`.`line_departure_city_id` [ RunTime:0.042002s ]
[ SQL ] SELECT a.line_destination_city_id AS destination_id,c.region_name AS destination_name,`f`.`transport_type_id` FROM `wl_line` `a` LEFT JOIN `wl_region` `b` ON `a`.`line_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`line_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_line_carbody_relation` `d` ON `d`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carlength_relation` `e` ON `e`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_transport_relation` `f` ON `f`.`line_id`=`a`.`line_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 GROUP BY `f`.`transport_type_id`,`a`.`line_destination_city_id` [ RunTime:0.043002s ]
[ SQL ] SELECT a.line_departure_city_id AS departure_id,b.region_name AS departure_name,`f`.`transport_type_id` FROM `wl_line` `a` LEFT JOIN `wl_region` `b` ON `a`.`line_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`line_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_line_carbody_relation` `d` ON `d`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carlength_relation` `e` ON `e`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_transport_relation` `f` ON `f`.`line_id`=`a`.`line_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 GROUP BY `f`.`transport_type_id`,`a`.`line_departure_city_id` [ RunTime:0.002000s ]
[ SQL ] SELECT a.line_destination_city_id AS destination_id,c.region_name AS destination_name,`f`.`transport_type_id` FROM `wl_line` `a` LEFT JOIN `wl_region` `b` ON `a`.`line_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`line_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_line_carbody_relation` `d` ON `d`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carlength_relation` `e` ON `e`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_transport_relation` `f` ON `f`.`line_id`=`a`.`line_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 GROUP BY `f`.`transport_type_id`,`a`.`line_destination_city_id` [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `wl_cargo` [ RunTime:0.002000s ]
[ SQL ] SELECT `a`.`cargo_departure_city_id`,b.region_name AS departure_city FROM `wl_cargo` `a` LEFT JOIN `wl_region` `b` ON `a`.`cargo_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`cargo_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_cargo_carbody_relation` `d` ON `d`.`cargo_id`=`a`.`cargo_id` LEFT JOIN `wl_cargo_carlength_relation` `e` ON `e`.`cargo_id`=`a`.`cargo_id` LEFT JOIN `wl_cargo_transport_relation` `f` ON `f`.`cargo_id`=`a`.`cargo_id` GROUP BY `a`.`cargo_departure_city_id` [ RunTime:0.001000s ]
[ SQL ] SELECT `a`.`cargo_destination_city_id`,c.region_name AS destination_city FROM `wl_cargo` `a` LEFT JOIN `wl_region` `b` ON `a`.`cargo_departure_city_id`=`b`.`region_id` LEFT JOIN `wl_region` `c` ON `a`.`cargo_destination_city_id`=`c`.`region_id` LEFT JOIN `wl_cargo_carbody_relation` `d` ON `d`.`cargo_id`=`a`.`cargo_id` LEFT JOIN `wl_cargo_carlength_relation` `e` ON `e`.`cargo_id`=`a`.`cargo_id` LEFT JOIN `wl_cargo_transport_relation` `f` ON `f`.`cargo_id`=`a`.`cargo_id` GROUP BY `a`.`cargo_destination_city_id` [ RunTime:0.001000s ]
[ SQL ] SELECT `a`.`line_id`,b.region_name as b_region_name,c.region_name as c_region_name FROM `wl_line` `a` LEFT JOIN `wl_region` `b` ON `b`.`region_id`=`a`.`line_departure_city_id` LEFT JOIN `wl_region` `c` ON `c`.`region_id`=`a`.`line_destination_city_id` WHERE `a`.`is_navigation_recommend` = 1 AND `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 ORDER BY `line_browse_count` DESC [ RunTime:0.002000s ]
[ SQL ] SHOW COLUMNS FROM `wl_friendly_link` [ RunTime:0.001000s ]
[ SQL ] SELECT `friendly_link_id`,`friendly_link_name`,`friendly_link_url` FROM `wl_friendly_link` [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `wl_site_config` [ RunTime:0.002000s ]
[ SQL ] SELECT * FROM `wl_site_config` WHERE `site_id` = 1 LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `wl_article_class` [ RunTime:0.001000s ]
[ SQL ] SELECT `a`.`article_class_id`,`a`.`article_class_name`,`b`.`article_id`,`b`.`article_title` FROM `wl_article_class` `a` LEFT JOIN `wl_article` `b` ON `b`.`article_class_id`=a.article_class_id and b.article_delete_time is null WHERE `a`.`article_parent_class_id` = 2 ORDER BY `article_id` ASC [ RunTime:0.001001s ]
[ SQL ] SELECT `article_class_id` FROM `wl_article_class` WHERE `article_class_name` = '帮助中心' LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SELECT `article_class_id`,`article_parent_class_id`,`article_class_name` FROM `wl_article_class` WHERE `article_parent_class_id` = 2 ORDER BY `article_class_id` [ RunTime:0.001000s ]
[ SQL ] SELECT `a`.`article_class_id`,`a`.`article_class_name`,`b`.`article_id`,`b`.`article_title` FROM `wl_article_class` `a` LEFT JOIN `wl_article` `b` ON `b`.`article_class_id`=a.article_class_id and b.article_delete_time is null WHERE `a`.`article_parent_class_id` = 2 ORDER BY `article_id` ASC [ RunTime:0.001000s ]
[ SQL ] SELECT `article_class_id` FROM `wl_article_class` WHERE `article_class_name` = '帮助中心' LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SELECT `article_class_id`,`article_parent_class_id`,`article_class_name` FROM `wl_article_class` WHERE `article_parent_class_id` = 2 ORDER BY `article_class_id` [ RunTime:0.001001s ]
[ SQL ] SHOW COLUMNS FROM `wl_article` [ RunTime:0.002000s ]
[ SQL ] SELECT `a`.*,`b`.`article_class_name` FROM `wl_article` `a` LEFT JOIN `wl_article_class` `b` ON `b`.`article_class_id`=`a`.`article_class_id` WHERE `a`.`article_id` = '303' AND `a`.`article_delete_status` = 0 LIMIT 1 [ RunTime:0.001000s ]
