[ DB ] CONNECT:[ UseTime:0.010001s ] 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.045003s ]
[ 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.045002s ]
[ 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.003000s ]
[ 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.000000s ]
[ 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.002001s ]
[ SQL ] SHOW COLUMNS FROM `wl_friendly_link` [ RunTime:0.002000s ]
[ SQL ] SELECT `friendly_link_id`,`friendly_link_name`,`friendly_link_url` FROM `wl_friendly_link` [ RunTime:0.000000s ]
[ 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.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.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` = 1 ORDER BY `article_class_id` [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `wl_article` [ RunTime:0.002000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `wl_article` WHERE `article_delete_status` = 0 AND `article_class_id` = 6 [ RunTime:0.005000s ]
[ SQL ] SELECT `article_id`,`article_title`,`article_cover`,`article_content`,`article_browse_count`,`article_add_time` FROM `wl_article` WHERE `article_delete_status` = 0 AND `article_class_id` = 6 ORDER BY `article_show_order`,`article_id` DESC LIMIT 10,10 [ RunTime:0.005001s ]
[ SQL ] SELECT `article_class_id`,`article_class_name` FROM `wl_article_class` WHERE `article_class_id` = 6 LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SELECT
a.line_id,
a.line_add_time,
a.line_contact_name,
a.line_contact_phone,
b.line_transport_relation_id,
group_concat(distinct c.transport_type_name separator "|") as transport_type_name,
group_concat(distinct g.carbody_type_name separator "|") as carbody_type_name,
d.region_name AS departure_city,
e.region_name AS destination_city,
h.carrier_applied_auth_type,
h.carrier_passed_auth_type,
h.carrier_is_official,
i.personal_auth_contact_name,
i.personal_auth_audit_time,
j.company_auth_name,
j.company_auth_audit_time
FROM `wl_line` `a` LEFT JOIN `wl_line_transport_relation` `b` ON `b`.`line_id`=`a`.`line_id` LEFT JOIN `wl_transport_type` `c` ON `c`.`transport_type_id`=`b`.`transport_type_id` LEFT JOIN `wl_region` `d` ON `d`.`region_id`=`a`.`line_departure_city_id` LEFT JOIN `wl_region` `e` ON `e`.`region_id`=`a`.`line_destination_city_id` LEFT JOIN `wl_line_carbody_relation` `f` ON `f`.`line_id`=`a`.`line_id` LEFT JOIN `wl_carbody_type` `g` ON `g`.`carbody_type_id`=`f`.`carbody_type_id` LEFT JOIN `wl_carrier` `h` ON `h`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_personal_auth` `i` ON `i`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_company_auth` `j` ON `j`.`carrier_id`=`a`.`carrier_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 AND `h`.`carrier_is_available` = 1 GROUP BY `a`.`line_id` ORDER BY `a`.`line_add_time` DESC LIMIT 5 [ RunTime:0.107006s ]
[ SQL ] SELECT
a.cargo_id,
a.cargo_weight,
a.cargo_name,
b.region_name AS departure_city,
c.region_name AS destination_city,
d.shipper_applied_auth_type,
d.shipper_is_official,
d.shipper_passed_auth_type,
e.personal_auth_contact_name,
e.personal_auth_audit_time,
f.company_auth_name,
f.company_auth_audit_time,
group_concat(h.transport_type_name separator "|") AS transport_type_name
FROM `wl_cargo` `a` LEFT JOIN `wl_region` `b` ON `b`.`region_id`=`a`.`cargo_departure_city_id` LEFT JOIN `wl_region` `c` ON `c`.`region_id`=`a`.`cargo_destination_city_id` LEFT JOIN `wl_shipper` `d` ON `d`.`shipper_id`=`a`.`shipper_id` LEFT JOIN `wl_shipper_personal_auth` `e` ON `e`.`shipper_id`=`a`.`shipper_id` LEFT JOIN `wl_shipper_company_auth` `f` ON `f`.`shipper_id`=`a`.`shipper_id` LEFT JOIN `wl_cargo_transport_relation` `g` ON `g`.`cargo_id`=`a`.`cargo_id` LEFT JOIN `wl_transport_type` `h` ON `h`.`transport_type_id`=`g`.`transport_type_id` WHERE `a`.`cargo_audit_status` = 1 AND `a`.`cargo_order_cooperation_status` = 0 AND `a`.`cargo_delete_status` = 0 AND `d`.`shipper_is_available` = 1 GROUP BY `g`.`cargo_id` ORDER BY `a`.`cargo_add_time` DESC LIMIT 5 [ RunTime:0.001000s ]