[ DB ] CONNECT:[ UseTime:0.006000s ] mysql:host=127.0.0.1;port=3312;dbname=tzwlpzw_data;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wl_line` [ RunTime:0.002000s ]
[ 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.039002s ]
[ 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.038002s ]
[ 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.001000s ]
[ 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.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.002000s ]
[ 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 ] 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.001000s ]
[ 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_transport_type` [ RunTime:0.002000s ]
[ SQL ] SELECT `transport_type_id`,`transport_type_name` FROM `wl_transport_type` ORDER BY `transport_type_id` ASC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_carbody_type` [ RunTime:0.002000s ]
[ SQL ] SELECT `carbody_type_id`,`carbody_type_name` FROM `wl_carbody_type` [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `wl_carlength_type` [ RunTime:0.002000s ]
[ SQL ] SELECT `carlength_type_id`,`carlength_type_name` FROM `wl_carlength_type` ORDER BY `carlength_type_name` [ RunTime:0.001000s ]
[ SQL ] SELECT `a`.`line_id` FROM `wl_line` `a` LEFT JOIN `wl_line_transport_relation` `b` ON `b`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carlength_relation` `c` ON `c`.`line_id`=`a`.`line_id` LEFT JOIN `wl_line_carbody_relation` `d` ON `d`.`line_id`=`a`.`line_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 AND `a`.`line_destination_city_id` = '430100' [ RunTime:0.003000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count 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_departure_district_id` LEFT JOIN `wl_region` `d` ON `d`.`region_id`=`a`.`line_destination_city_id` LEFT JOIN `wl_region` `e` ON `e`.`region_id`=`a`.`line_destination_district_id` LEFT JOIN `wl_carrier` `f` ON `f`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_personal_auth` `g` ON `g`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_company_auth` `h` ON `h`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_line_transport_relation` `i` ON `i`.`line_id`=`a`.`line_id` LEFT JOIN `wl_transport_type` `j` ON `j`.`transport_type_id`=`i`.`transport_type_id` LEFT JOIN `wl_line_carlength_relation` `k` ON `k`.`line_id`=`a`.`line_id` LEFT JOIN `wl_carlength_type` `l` ON `l`.`carlength_type_id`=`k`.`carlength_type_id` LEFT JOIN `wl_line_carbody_relation` `m` ON `m`.`line_id`=`a`.`line_id` LEFT JOIN `wl_carbody_type` `n` ON `n`.`carbody_type_id`=`m`.`carbody_type_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 AND `f`.`carrier_is_available` = 1 AND `a`.`line_id` IN (115,116,117,118,119,120,121,122,123,234,426,427,428,429,430,431,432,433) GROUP BY `a`.`line_id` ) `_group_count_` [ RunTime:0.003000s ]
[ SQL ] SELECT
a.line_id,
a.line_audit_time,
a.line_add_time,
b.region_name AS departure_city,
c.region_name AS departure_district,
d.region_name AS destination_city,
e.region_name AS destination_district,
f.carrier_applied_auth_type,
f.carrier_passed_auth_type,
f.carrier_is_official,
g.personal_auth_contact_name,
g.personal_auth_avatar,
h.company_auth_name,
h.company_auth_avatar,
group_concat(distinct j.transport_type_name separator "|") as transport_type_name,
group_concat(distinct l.carlength_type_name separator "|") as carlength_type_name,
group_concat(distinct n.carbody_type_name separator "|") as carbody_type_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_departure_district_id` LEFT JOIN `wl_region` `d` ON `d`.`region_id`=`a`.`line_destination_city_id` LEFT JOIN `wl_region` `e` ON `e`.`region_id`=`a`.`line_destination_district_id` LEFT JOIN `wl_carrier` `f` ON `f`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_personal_auth` `g` ON `g`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_carrier_company_auth` `h` ON `h`.`carrier_id`=`a`.`carrier_id` LEFT JOIN `wl_line_transport_relation` `i` ON `i`.`line_id`=`a`.`line_id` LEFT JOIN `wl_transport_type` `j` ON `j`.`transport_type_id`=`i`.`transport_type_id` LEFT JOIN `wl_line_carlength_relation` `k` ON `k`.`line_id`=`a`.`line_id` LEFT JOIN `wl_carlength_type` `l` ON `l`.`carlength_type_id`=`k`.`carlength_type_id` LEFT JOIN `wl_line_carbody_relation` `m` ON `m`.`line_id`=`a`.`line_id` LEFT JOIN `wl_carbody_type` `n` ON `n`.`carbody_type_id`=`m`.`carbody_type_id` WHERE `a`.`line_audit_status` = 1 AND `a`.`line_delete_status` = 0 AND `f`.`carrier_is_available` = 1 AND `a`.`line_id` IN (115,116,117,118,119,120,121,122,123,234,426,427,428,429,430,431,432,433) GROUP BY `a`.`line_id` ORDER BY `a`.`line_add_time` DESC LIMIT 14,7 [ RunTime:0.009001s ]
[ 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.096006s ]
