线路信息-泰州物流配载网

基本文件流程错误 SQL 调试

E:\wwwroot\www.tzwlpzw.com\index.php ( 0.81 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\base.php ( 1.71 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Loader.php ( 12.70 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Error.php ( 4.00 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Container.php ( 15.53 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\App.php ( 28.20 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Env.php ( 2.85 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Config.php ( 9.71 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\convention.php ( 12.23 KB )
E:\wwwroot\www.tzwlpzw.com\application\tags.php ( 0.96 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Hook.php ( 5.58 KB )
E:\wwwroot\www.tzwlpzw.com\application\common.php ( 13.70 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\helper.php ( 20.40 KB )
E:\wwwroot\www.tzwlpzw.com\application\provider.php ( 0.62 KB )
E:\wwwroot\www.tzwlpzw.com\config\app.php ( 6.70 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\facade\Env.php ( 1.17 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Facade.php ( 3.44 KB )
E:\wwwroot\www.tzwlpzw.com\config\cache.php ( 1.00 KB )
E:\wwwroot\www.tzwlpzw.com\config\console.php ( 0.91 KB )
E:\wwwroot\www.tzwlpzw.com\config\cookie.php ( 1.11 KB )
E:\wwwroot\www.tzwlpzw.com\config\database.php ( 2.24 KB )
E:\wwwroot\www.tzwlpzw.com\config\log.php ( 1.19 KB )
E:\wwwroot\www.tzwlpzw.com\config\middleware.php ( 0.85 KB )
E:\wwwroot\www.tzwlpzw.com\config\session.php ( 1.06 KB )
E:\wwwroot\www.tzwlpzw.com\config\template.php ( 1.39 KB )
E:\wwwroot\www.tzwlpzw.com\config\trace.php ( 0.84 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Db.php ( 7.67 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Lang.php ( 7.38 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Request.php ( 57.59 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Log.php ( 8.92 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\log\driver\File.php ( 9.40 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\lang\zh-cn.php ( 12.58 KB )
E:\wwwroot\www.tzwlpzw.com\route\route.php ( 1.30 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\facade\Route.php ( 3.83 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Route.php ( 25.79 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\Domain.php ( 7.07 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\RuleGroup.php ( 16.45 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\Rule.php ( 28.92 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\RuleItem.php ( 8.84 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\RuleName.php ( 3.92 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\dispatch\Url.php ( 5.23 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\Dispatch.php ( 9.26 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\route\dispatch\Module.php ( 5.42 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\middleware.php ( 0.07 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Middleware.php ( 5.34 KB )
E:\wwwroot\www.tzwlpzw.com\application\http\middleware\CORS.php ( 1.11 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Cookie.php ( 7.35 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\View.php ( 5.74 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\view\driver\Think.php ( 6.12 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Template.php ( 47.31 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\template\driver\File.php ( 2.29 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Session.php ( 14.13 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Debug.php ( 7.57 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Cache.php ( 3.27 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\cache\driver\File.php ( 7.91 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\cache\Driver.php ( 8.64 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\controller\Line.php ( 27.00 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\controller\Base.php ( 8.85 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Controller.php ( 7.53 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\traits\controller\Jump.php ( 4.76 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\LineModel.php ( 16.65 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Model.php ( 27.26 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\concern\Attribute.php ( 17.64 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\concern\RelationShip.php ( 19.85 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\concern\ModelEvent.php ( 6.04 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\concern\TimeStamp.php ( 2.58 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\concern\Conversion.php ( 7.83 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\Connection.php ( 58.93 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\connector\Mysql.php ( 6.24 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\builder\Mysql.php ( 5.55 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\Builder.php ( 36.72 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\Query.php ( 104.58 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\model\Collection.php ( 2.80 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Collection.php ( 13.59 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\CargoModel.php ( 14.79 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\FriendlyLinkModel.php ( 0.96 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\SiteConfigModel.php ( 0.88 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\ArticleClassModel.php ( 3.54 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\facade\Session.php ( 2.05 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\TransportTypeModel.php ( 0.75 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\CarbodyTypeModel.php ( 0.74 KB )
E:\wwwroot\www.tzwlpzw.com\application\reception\model\CarlengthTypeModel.php ( 0.79 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\db\Expression.php ( 1.11 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\paginator\driver\Bootstrap.php ( 5.25 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Paginator.php ( 9.83 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Response.php ( 9.68 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\response\View.php ( 2.77 KB )
E:\wwwroot\www.tzwlpzw.com\runtime\temp\b218f04cef5f9378b275656a3e08afe0.php ( 27.27 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\facade\Url.php ( 1.13 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\Url.php ( 13.06 KB )
E:\wwwroot\www.tzwlpzw.com\thinkphp\library\think\debug\Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.015600s ] mysql:host=127.0.0.1;port=3312;dbname=tzwlpzw_data;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wl_line` [ RunTime:0.000000s ]
[ 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.031200s ]
[ 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.046800s ]
[ 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.000000s ]
[ 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.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_cargo` [ RunTime:0.000000s ]
[ 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.000000s ]
[ 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.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_friendly_link` [ RunTime:0.015600s ]
[ 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.000000s ]
[ SQL ] SELECT * FROM `wl_site_config` WHERE `site_id` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_article_class` [ RunTime:0.000000s ]
[ 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.000000s ]
[ SQL ] SELECT `article_class_id` FROM `wl_article_class` WHERE `article_class_name` = '帮助中心' LIMIT 1 [ RunTime:0.000000s ]
[ 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.000000s ]
[ 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.000000s ]
[ 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.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_transport_type` [ RunTime:0.000000s ]
[ 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.000000s ]
[ SQL ] SELECT `carbody_type_id`,`carbody_type_name` FROM `wl_carbody_type` [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `wl_carlength_type` [ RunTime:0.015600s ]
[ SQL ] SELECT `carlength_type_id`,`carlength_type_name` FROM `wl_carlength_type` ORDER BY `carlength_type_name` [ RunTime:0.000000s ]
[ 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` = '650100' [ RunTime:0.000000s ]
[ 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` = 208 GROUP BY `a`.`line_id` ) `_group_count_` [ RunTime:0.015600s ]
[ 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` = 208 GROUP BY `a`.`line_id` ORDER BY `a`.`line_add_time` DESC LIMIT 0,7 [ RunTime:0.000000s ]
[ 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.093600s ]

新手入门

关于我们

常见问题

电信反诈