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

基本文件流程错误 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.001000s ] mysql:host=127.0.0.1;port=3312;dbname=tzwlpzw_data;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wl_line` [ RunTime:0.003001s ]
[ 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 ] 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.001001s ]
[ 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.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.001000s ]
[ 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.001001s ]
[ 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.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.001000s ]
[ 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.001000s ]
[ 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_departure_city_id` = '321200' [ RunTime:0.004001s ]
[ 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 (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,201,202,203,204,205,206,207,208,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590) GROUP BY `a`.`line_id` ) `_group_count_` [ RunTime:0.002000s ]
[ 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 (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,201,202,203,204,205,206,207,208,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590) GROUP BY `a`.`line_id` ORDER BY `a`.`line_add_time` DESC LIMIT 392,7 [ RunTime:0.200012s ]
[ 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.001000s ]

泰州市姜堰区 → 长沙市开福区运输类型：专线车型：高栏车长：11.7\|12.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 长沙市雨花区运输类型：专线车型：高栏车长：11.7\|12.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 长沙市长沙县运输类型：配载车型：平板\|高栏车长：12.5\|13.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 长沙市望城县运输类型：配载\|零担车型：平板\|高栏车长：12.5\|13.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 长沙市宁乡县运输类型：配载\|零担车型：平板车长：12.5\|13.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 长沙市浏阳市运输类型：配载\|零担车型：厢式\|平板\|高栏车长：11.7\|12.5\|13.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情
泰州市姜堰区 → 武汉市江岸区运输类型：专线\|配载车型：平板\|高栏车长：11.7\|12.5\|13.5	姜堰区航燕货物配载服务部企业认证发布时间：2025-03-05	详情

新手入门

关于我们

常见问题

电信反诈