FIFO-容量约束下公交乘客搭载的动态分配问题建模与优化

FIFO-容量约束下公交乘客搭载的动态分配问题建模与优化

：OracleSQL实现与验证
Original 江月明203 会飞的一十六
2025年01月25日 23:00
1问题引入“公交乘客搭载的 FIFO - 容量约束匹配模型” 是一种基于先进先出（FIFO）原则，以乘客到达时间和公交车到达时间为匹配依据，在公交车容量约束条件下，计算每辆公交车搭载乘客数量，实现乘客与公交车合理分配的统计模型 。1.1 关键要素

乘客集合：所有等待乘车的乘客构成集合，每个乘客具有**标识（如乘客 ID）以及到达公交站点的时间属性。
公交车集合：运营中的公交车构成集合，每辆公交车有**编号（公交 ID），同时具备到达站点的时间和最大载客容量两个关键属性。
先进先出原则：按照乘客到达公交站点的时间先后顺序安排上车，先到达的乘客优先上车。
容量约束：每辆公交车的实际载客量不能超过其最大载客容量。
1.2 模型构建
1.2.1数据结构抽象
· 输入集合
·
以公交车搭载乘客问题为例，存在两个输入集合。集合

表示乘客集合，其中
，标识乘客，表示乘客的到达时间。集合表示公交车集合，其中标识公交车，表示公交车 的到达时间，表示公交车的容量。
· 输出集合
，其中
，
与公交车集合
中的
对应，
表示公交车
搭载的乘客数量。
1.2.2 规则抽象
· 匹配规则

·
对于每个乘客
，要找到满足
的公交车
。这类似于在两个有序序列（按到达时间排序）中进行匹配，优先选择最早到达且能搭载该乘客的公交车。
· 计数规则
当找到满足条件的公交车后，要按照先进先出原则计数。在公交车
的容量
限制下，统计能搭载的乘客数量。可以将其看作是一个容量有限的容器，按照元素进入的顺序（乘客到达时间顺序）填充元素（乘客），并统计填充的元素数量。
1.3.3 数学运算抽象
· 排序运算
·
对集合
按进
行升序排序，对集合
也按
进行升序排序。这是为了后续匹配和计数的有序性，类似在数学中对数列进行排序以便后续操作。

条件判断与累加运算：
·
对于每辆公交车
，从排序后的乘客集合
中，依次检查乘客
，当

 且搭载的乘客数量未超过

时，将搭载的乘客数量加1。这可以用数学中的循环和条件判断来描述，假设用表示当前已搭载的乘客数量，初始k=0，对于
，如果
且
，则k =k+1。最终k的值就是
。2 基础问题-基于时间匹配的公交车乘客搭载问题
2.1 问题描述

[backcolor=rgba(0, 0, 0, 0.03)]
表: Buses+--------------+------+| Column Name | Type |+--------------+------+| bus_id | int || arrival_time | int |+--------------+------+bus_id 是该表的主键。该表的每一行都包含关于 LeetCode 站点的公交车到达时间的信息。不会出现两辆公交车会同时到达。表: Passengers+--------------+------+| Column Name | Type |+--------------+------+| passenger_id | int || arrival_time | int |+--------------+------+passenger_id 是该表的主键。该表的每一行都包含乘客到达 LeetCode 站的时间信息。公交车和乘客到达 LeetCode 站。如果一辆公交车在时间 tbus 到站，乘客在时间 tpassenger 到站，其中 tpassenger <= tbus，该乘客之前没有赶上任何公交车，则该乘客将搭乘该公交车。编写一个 SQL 来查询使用每条总线的用户数量。返回按 bus_id 升序排序的结果表。查询结果格式如下所示。示例 1:输入: Buses 表:+--------+--------------+| bus_id | arrival_time |+--------+--------------+| 1 | 2 || 2 | 4 || 3 | 7 |+--------+--------------+Passengers 表:+--------------+--------------+| passenger_id | arrival_time |+--------------+--------------+| 11 | 1 || 12 | 5 || 13 | 6 || 14 | 7 |+--------------+--------------+输出: +--------+----------------+| bus_id | passengers_cnt |+--------+----------------+| 1 | 1 || 2 | 0 || 3 | 3 |+--------+----------------+解释: - 11 号乘客在时间 1 到达。- 1 号公交车到达时间为 2，搭载 11 号乘客。- 2 号公交车车在时间 4 到达，没有乘客。- 12 号乘客在时间 5 到达。- 13 号乘客在时间 6 到达。- 14 号乘客在时间 7 到达。- 3 号车在时间 7 到达，搭载 12、13、14 号乘客。来源：力扣（LeetCode）链接：https://leetcode.cn/problems/the-number-of-passengers-in-each...数据准备

//测试数据Create table If Not Exists Buses (bus_id int, arrival_time int);Create table If Not Exists Passengers (passenger_id int, arrival_time int);
insert into Buses (bus_id, arrival_time) values ('1', '2');insert into Buses (bus_id, arrival_time) values ('2', '4');insert into Buses (bus_id, arrival_time) values ('3', '7');
insert into Passengers (passenger_id, arrival_time) values ('11', '1');insert into Passengers (passenger_id, arrival_time) values ('12', '5');insert into Passengers (passenger_id, arrival_time) values ('13', '6');insert into Passengers (passenger_id, arrival_time) values ('14', '7');2.3问题分析
步骤1：计算每个乘客最早能赶上的公交车的到达时间

SELECT p.passenger_id, MIN(b.arrival_time) earliest_bus_arrivalFROM Passengers p JOIN Buses b ON p.arrival_time <= b.arrival_timegroup by p.passenger_id

会飞的一十六
一个专注大于大数据、数据库、数据分析、相关领域的公众号，分享技术干货、学习资料、面试、职场经验和个人思考感悟，更重要的是让SQLBOY的SQL有质的飞越。
195篇原创内容
公众号
步骤2：计算每辆车乘客数

WITH PassengerEarliestBus AS ( SELECT p.passenger_id, MIN(b.arrival_time) earliest_bus_arrival FROM Passengers p JOIN Buses b ON p.arrival_time <= b.arrival_time group by p.passenger_id )-- 主查询SELECT b.bus_id, COUNT(peb.passenger_id) AS passengers_cntFROM Buses bLEFT JOIN PassengerEarliestBus peb ON b.arrival_time = peb.earliest_bus_arrivalGROUP BY b.bus_idORDER BY b.bus_id;

3 公交乘客搭载的 FIFO - 容量约束匹配问题3.1 问题描述

表: Buses+--------------+------+| Column Name | Type |+--------------+------+| bus_id | int || arrival_time | int || capacity | int |+--------------+------+bus_id 包含的值。该表的每一行都包含关于公交车到达 LeetCode 站点的时间和它的容量 (空座位的数量) 的信息。不会出现两辆公交车同时到达，所有公交车的容量都是正整数。表: Passengers+--------------+------+| Column Name | Type |+--------------+------+| passenger_id | int || arrival_time | int |+--------------+------+passenger_id 包含的值。该表的每一行都包含乘客到达 LeetCode 站的时间信息。公交车和乘客到达 LeetCode 站。如果一辆公交车在 tbus 时间点到达车站，乘客在 tpassenger 到达车站，其中 tpassenger <= tbus，而该乘客没有赶上任何公交车，则该乘客将搭乘该公交车。此外，每辆公交车都有一个容量。如果在公交车到站的那一刻，等待的乘客超过了它的载客量 capacity，只有 capacity 个乘客才会搭乘该公交车。编写解决方案，报告使用每条总线的用户数量。返回按 bus_id 升序排序 的结果表。结果格式如下所示。示例 1:输入: Buses 表:+--------+--------------+----------+| bus_id | arrival_time | capacity |+--------+--------------+----------+| 1 | 2 | 1 || 2 | 4 | 10 || 3 | 7 | 2 |+--------+--------------+----------+Passengers 表:+--------------+--------------+| passenger_id | arrival_time |+--------------+--------------+| 11 | 1 || 12 | 1 || 13 | 5 || 14 | 6 || 15 | 7 |+--------------+--------------+输出: +--------+----------------+| bus_id | passengers_cnt |+--------+----------------+| 1 | 1 || 2 | 1 || 3 | 2 |+--------+----------------+解释: - 11 号乘客在时间 1 到达。- 12 号乘客在时间 1 到达。- 1 号公交车到达时间为 2，因为有一个空座位，所以搭载了 11 号乘客。

• 2 号公交车在时间 4 到达，搭载了12 号乘客，因为它有 10 个空座位。
• 13 号乘客在时间 5 到达。- 14 号乘客在时间 6 到达。- 15 号乘客在时间 7 到达。- 3 号公交车在时间 7 到达，车上有两个空座位，搭载了 12 号和 13 号乘客。3.2数据准备

[backcolor=rgba(0, 0, 0, 0.03)]

Create table If Not Exists Buses( bus_id int, arrival_time int, capacity int);Create table If Not Exists Passengers( passenger_id int, arrival_time int);---测试data1Truncate table Busesinsert into Buses (bus_id, arrival_time, capacity)values ('1', '2', '1');insert into Buses (bus_id, arrival_time, capacity)values ('2', '4', '10');insert into Buses (bus_id, arrival_time, capacity)values ('3', '7', '2');Truncate table Passengersinsert into Passengers (passenger_id, arrival_time)values ('11', '1');insert into Passengers (passenger_id, arrival_time)values ('12', '1');insert into Passengers (passenger_id, arrival_time)values ('13', '5');insert into Passengers (passenger_id, arrival_time)values ('14', '6');insert into Passengers (passenger_id, arrival_time)values ('15', '7');------------------------------测试data2-- 清空并插入Buses表数据TRUNCATE TABLE Buses;INSERT ALL INTO Buses (bus_id, arrival_time, capacity) VALUES (326, 412, 3) INTO Buses (bus_id, arrival_time, capacity) VALUES (394, 656, 3) INTO Buses (bus_id, arrival_time, capacity) VALUES (430, 701, 1) INTO Buses (bus_id, arrival_time, capacity) VALUES (514, 742, 4) INTO Buses (bus_id, arrival_time, capacity) VALUES (765, 867, 9) INTO Buses (bus_id, arrival_time, capacity) VALUES (259, 968, 3)SELECT 1 FROM DUAL;
-- 清空并插入Passengers表数据TRUNCATE TABLE Passengers;INSERT ALL INTO Passengers (passenger_id, arrival_time) VALUES (1145, 84) INTO Passengers (passenger_id, arrival_time) VALUES (1466, 146) INTO Passengers (passenger_id, arrival_time) VALUES (1446, 317) INTO Passengers (passenger_id, arrival_time) VALUES (1092, 420) INTO Passengers (passenger_id, arrival_time) VALUES (678, 486) INTO Passengers (passenger_id, arrival_time) VALUES (1643, 520) INTO Passengers (passenger_id, arrival_time) VALUES (253, 615) INTO Passengers (passenger_id, arrival_time) VALUES (1106, 656) INTO Passengers (passenger_id, arrival_time) VALUES (1309, 699) INTO Passengers (passenger_id, arrival_time) VALUES (142, 832) INTO Passengers (passenger_id, arrival_time) VALUES (431, 880) INTO Passengers (passenger_id, arrival_time) VALUES (1405, 963)SELECT 1 FROM DUAL;
语法解释：
INSERT ALL
·
Oracle特有语法，支持一次性插入多行数据。
·
每条 INTO 子句定义一行数据。
·
结尾的 SELECT 1 FROM DUAL 是必需的语法占位符。
DUAL 表
·
Oracle的虚拟表，用于无实际表时的占位查询
3.3 问题分析 3.3.1 问题分析
某平台需按公交车到达顺序分配乘客，规则如下：
· 乘客分配条件：乘客到达时间 ≤ 公交车到达时间。
· 容量限制：公交车最多搭载 capacity 人，超出的乘客需等待后续车辆。
· 先到先得：乘客按到达时间排序，早到的优先分配。
核心挑战
· 动态跟踪已分配乘客：避免重复分配或遗漏。
· 容量限制处理：每辆公交车搭载人数不超过容量。
· 递归终止条件：确保所有公交车处理完毕，且乘客分配完整。
3.3.2 关键步骤拆解
步骤1：排序公交车和乘客

-- 公交车按到达时间排序（相同时间按bus_id排序）ordered_buses AS ( SELECT bus_id, arrival_time, capacity, ROW_NUMBER() OVER (ORDER BY arrival_time, bus_id) AS rn FROM Buses)
-- 乘客按到达时间排序（相同时间按passenger_id排序）ordered_passengers AS ( SELECT passenger_id, arrival_time, ROW_NUMBER() OVER (ORDER BY arrival_time, passenger_id) AS prn FROM Passengers)

ordered_buses:+--------+--------------+----------+----+| bus_id | arrival_time | capacity | rn |+--------+--------------+----------+----+| 326 | 412 | 3 | 1 || 394 | 656 | 3 | 2 || 430 | 701 | 1 | 3 || 514 | 742 | 4 | 4 || 765 | 867 | 9 | 5 || 259 | 968 | 3 | 6 |+--------+--------------+----------+----+
ordered_passengers:+--------------+--------------+-----+| passenger_id | arrival_time | prn |+--------------+--------------+-----+| 1145 | 84 | 1 || 1466 | 146 | 2 || 1446 | 317 | 3 || 1092 | 420 | 4 || 678 | 486 | 5 || 1643 | 520 | 6 || 253 | 615 | 7 || 1106 | 656 | 8 || 1309 | 699 | 9 || 142 | 832 | 10 || 431 | 880 | 11 || 1405 | 963 | 12 |+--------------+--------------+-----+
步骤2：递归分配乘客

recursive_assign (bus_id, passengers_taken, next_prn) AS ( -- 初始状态：处理第一辆公交车 SELECT bus_id, 0 AS passengers_taken, 1 AS next_prn FROM ordered_buses WHERE rn = 1 UNION ALL -- 递归处理后续公交车 SELECT ob.bus_id, LEAST(ob.capacity, op_end.max_prn - ra.next_prn + 1), ra.next_prn + LEAST(ob.capacity, op_end.max_prn - ra.next_prn + 1) FROM recursive_assign ra JOIN ordered_buses ob ON ob.rn = (SELECT rn FROM ordered_buses WHERE bus_id = ra.bus_id) + 1 CROSS JOIN ( SELECT COALESCE(MAX(prn), 0) AS max_prn FROM ordered_passengers WHERE arrival_time <= ob.arrival_time ) op_end WHERE op_end.max_prn >= ra.next_prn)
递归过程关键中间状态：

递归步骤 | bus_id | passengers_taken | next_prn | 解释-------|--------|-------------------|----------|-----------------------------------------初始 | 326 | 0 | 1 | 开始处理第一辆公交车1 | 394 | 3 | 4 | 搭载prn=1-3的乘客（容量3）2 | 430 | 3 | 7 | 搭载prn=4-6的乘客（容量3）3 | 514 | 1 | 8 | 搭载prn=7的乘客（容量1）4 | 765 | 2 | 10 | 搭载prn=8-9的乘客（容量4 → 实际2人）5 | 259 | 1 | 11 | 搭载prn=10的乘客（容量9 → 实际1人） 步骤3：合并最终结果

SELECT ob.bus_id, COALESCE(ra.passengers_taken, 0) AS passengers_cntFROM ordered_buses obLEFT JOIN recursive_assign ra ON ob.bus_id = ra.bus_idORDER BY ob.bus_id;
最终结果：

+--------+----------------+| bus_id | passengers_cnt |+--------+----------------+| 259 | 2 | -- 处理prn=11-12（实际搭载2人）| 326 | 3 | -- 处理prn=1-3（满载）| 394 | 3 | -- 处理prn=4-6（满载）| 430 | 1 | -- 处理prn=7（容量1）| 514 | 2 | -- 处理prn=8-9（实际搭载2人）| 765 | 1 | -- 处理prn=10（容量9 → 实际1人）+--------+----------------+

www.51sole.com/xinxi/458617317.htm
www.51sole.com/xinxi/458617538.htm
www.51sole.com/xinxi/458617597.htm
www.51sole.com/xinxi/458617654.htm
www.51sole.com/xinxi/458617916.htm
www.51sole.com/xinxi/458618204.htm
www.51sole.com/xinxi/458618410.htm
www.51sole.com/xinxi/458618506.htm
www.51sole.com/xinxi/458618705.htm
www.51sole.com/xinxi/458619026.htm
www.51sole.com/xinxi/458619118.htm
www.51sole.com/xinxi/458619224.htm
www.51sole.com/xinxi/458619341.htm
www.51sole.com/xinxi/458619464.htm
www.51sole.com/xinxi/458619586.htm
www.51sole.com/xinxi/458619704.htm
www.51sole.com/xinxi/458619828.htm
www.51sole.com/xinxi/458620056.htm
www.51sole.com/xinxi/458620296.htm
www.51sole.com/xinxi/458620416.htm
www.51sole.com/xinxi/458620539.htm
www.51sole.com/xinxi/458620786.htm
www.51sole.com/xinxi/458621031.htm
www.51sole.com/xinxi/458621152.htm
www.51sole.com/xinxi/458621286.htm
www.51sole.com/xinxi/458621413.htm
www.51sole.com/xinxi/458623773.htm
www.51sole.com/xinxi/458623907.htm
www.51sole.com/xinxi/458624046.htm
www.51sole.com/xinxi/458624327.htm
www.51sole.com/xinxi/458624626.htm
www.51sole.com/xinxi/458624905.htm
www.51sole.com/xinxi/458625032.htm
www.51sole.com/xinxi/458625165.htm
www.51sole.com/xinxi/458625308.htm
www.51sole.com/xinxi/458625701.htm
www.51sole.com/xinxi/458625843.htm
www.51sole.com/xinxi/458626267.htm
www.51sole.com/xinxi/458626405.htm
www.51sole.com/xinxi/458626677.htm
www.51sole.com/xinxi/458626805.htm
www.51sole.com/xinxi/458627621.htm
www.51sole.com/xinxi/458627777.htm
www.51sole.com/xinxi/458627931.htm
www.51sole.com/xinxi/458628215.htm
www.51sole.com/xinxi/458628506.htm
www.51sole.com/xinxi/458628783.htm
www.51sole.com/xinxi/458629333.htm
www.51sole.com/xinxi/458629615.htm
www.51sole.com/xinxi/458629757.htm
www.51sole.com/xinxi/458629905.htm
www.51sole.com/xinxi/458630043.htm
www.51sole.com/xinxi/458630179.htm
www.51sole.com/xinxi/458630759.htm
www.51sole.com/xinxi/458631062.htm
www.51sole.com/xinxi/458631228.htm
www.51sole.com/xinxi/458631362.htm
www.51sole.com/xinxi/458631676.htm
www.51sole.com/xinxi/458631818.htm
www.51sole.com/xinxi/458631975.htm
www.51sole.com/xinxi/458632268.htm
www.51sole.com/xinxi/458632439.htm
www.51sole.com/xinxi/458633183.htm
www.51sole.com/xinxi/458633376.htm
www.51sole.com/xinxi/458633693.htm
www.51sole.com/xinxi/458633857.htm
www.51sole.com/xinxi/458635738.htm
www.51sole.com/xinxi/458636204.htm
www.51sole.com/xinxi/458636368.htm
www.51sole.com/xinxi/458636522.htm
www.51sole.com/xinxi/458636663.htm
www.51sole.com/xinxi/458636818.htm
www.51sole.com/xinxi/458636972.htm
www.51sole.com/xinxi/458637238.htm
www.51sole.com/xinxi/458637383.htm
www.51sole.com/xinxi/458637670.htm
www.51sole.com/xinxi/458637823.htm
www.51sole.com/xinxi/458637961.htm
www.51sole.com/xinxi/458638100.htm
www.51sole.com/xinxi/458638403.htm
www.51sole.com/xinxi/458638547.htm
www.51sole.com/xinxi/458639374.htm
www.51sole.com/xinxi/458639530.htm
www.51sole.com/xinxi/458639672.htm
www.51sole.com/xinxi/458640125.htm
www.51sole.com/xinxi/458640430.htm
www.51sole.com/xinxi/458641074.htm
www.51sole.com/xinxi/458641548.htm
www.51sole.com/xinxi/458642183.htm
www.51sole.com/xinxi/458642350.htm
www.51sole.com/xinxi/458642492.htm
www.51sole.com/xinxi/458642961.htm
www.51sole.com/xinxi/458643125.htm
www.51sole.com/xinxi/458643293.htm
www.51sole.com/xinxi/458643611.htm
www.51sole.com/xinxi/458643951.htm
www.51sole.com/xinxi/458644284.htm
www.51sole.com/xinxi/458644438.htm
www.51sole.com/xinxi/458644890.htm
www.51sole.com/xinxi/458645485.htm
www.51sole.com/xinxi/458646061.htm
www.51sole.com/xinxi/458646211.htm
www.51sole.com/xinxi/458646360.htm
www.51sole.com/xinxi/458646982.htm
www.51sole.com/xinxi/458647118.htm
www.51sole.com/xinxi/458647642.htm
www.51sole.com/xinxi/458616504.htm
www.51sole.com/xinxi/458616544.htm
www.51sole.com/xinxi/458616621.htm
www.51sole.com/xinxi/458616845.htm
www.51sole.com/xinxi/458616899.htm
www.51sole.com/xinxi/458616937.htm
www.51sole.com/xinxi/458616983.htm
www.51sole.com/xinxi/458617035.htm
www.51sole.com/xinxi/458617078.htm
www.51sole.com/xinxi/458617113.htm
www.51sole.com/xinxi/458617194.htm
www.51sole.com/xinxi/458617243.htm
www.51sole.com/xinxi/458617354.htm
www.51sole.com/xinxi/458617407.htm
www.51sole.com/xinxi/458617461.htm
www.51sole.com/xinxi/458617508.htm
www.51sole.com/xinxi/458617624.htm
www.51sole.com/xinxi/458617923.htm
www.51sole.com/xinxi/458618123.htm
www.51sole.com/xinxi/458618362.htm
www.51sole.com/xinxi/458618693.htm
www.51sole.com/xinxi/458618806.htm
www.51sole.com/xinxi/458619256.htm
www.51sole.com/xinxi/458619386.htm
www.51sole.com/xinxi/458619631.htm
www.51sole.com/xinxi/458619752.htm
www.51sole.com/xinxi/458620280.htm
www.51sole.com/xinxi/458620674.htm
www.51sole.com/xinxi/458620808.htm
www.51sole.com/xinxi/458621486.htm
www.51sole.com/xinxi/458621633.htm
www.51sole.com/xinxi/458621751.htm
www.51sole.com/xinxi/458621908.htm
www.51sole.com/xinxi/458622050.htm
www.51sole.com/xinxi/458622216.htm
www.51sole.com/xinxi/458622356.htm
www.51sole.com/xinxi/458622530.htm
www.51sole.com/xinxi/458622713.htm
www.51sole.com/xinxi/458622854.htm
www.51sole.com/xinxi/458623334.htm
www.51sole.com/xinxi/458624111.htm
www.51sole.com/xinxi/458624253.htm
www.51sole.com/xinxi/458624574.htm
www.51sole.com/xinxi/458625176.htm
www.51sole.com/xinxi/458625464.htm
www.51sole.com/xinxi/458625603.htm
www.51sole.com/xinxi/458625768.htm
www.51sole.com/xinxi/458626340.htm
www.51sole.com/xinxi/458626500.htm
www.51sole.com/xinxi/458626656.htm
www.51sole.com/xinxi/458627123.htm
www.51sole.com/xinxi/458627278.htm
www.51sole.com/xinxi/458627431.htm
www.51sole.com/xinxi/458627749.htm
www.51sole.com/xinxi/458628090.htm
www.51sole.com/xinxi/458628280.htm
www.51sole.com/xinxi/458628473.htm
www.51sole.com/xinxi/458628633.htm
www.51sole.com/xinxi/458629100.htm
www.51sole.com/xinxi/458629377.htm
www.51sole.com/xinxi/458629847.htm
www.51sole.com/xinxi/458629994.htm
www.51sole.com/xinxi/458630302.htm
www.51sole.com/xinxi/458630624.htm
www.51sole.com/xinxi/458630771.htm
www.51sole.com/xinxi/458631151.htm
www.51sole.com/xinxi/458631315.htm
www.51sole.com/xinxi/458631841.htm
www.51sole.com/xinxi/458632154.htm
www.51sole.com/xinxi/458632654.htm
www.51sole.com/xinxi/458632832.htm
www.51sole.com/xinxi/458632993.htm
www.51sole.com/xinxi/458633170.htm
www.51sole.com/xinxi/458633725.htm
www.51sole.com/xinxi/458633924.htm
www.51sole.com/xinxi/458634497.htm
www.51sole.com/xinxi/458634684.htm
www.51sole.com/xinxi/458634889.htm
www.51sole.com/xinxi/458635065.htm
www.51sole.com/xinxi/458635276.htm
www.51sole.com/xinxi/458635659.htm
www.51sole.com/xinxi/458635831.htm
www.51sole.com/xinxi/458636194.htm
www.51sole.com/xinxi/458637014.htm
www.51sole.com/xinxi/458637169.htm
www.51sole.com/xinxi/458637317.htm
www.51sole.com/xinxi/458637469.htm
www.51sole.com/xinxi/458638255.htm
www.51sole.com/xinxi/458638424.htm
www.51sole.com/xinxi/458638588.htm
www.51sole.com/xinxi/458638907.htm
www.51sole.com/xinxi/458639040.htm
www.51sole.com/xinxi/458639202.htm
www.51sole.com/xinxi/458639510.htm
www.51sole.com/xinxi/458640012.htm
www.51sole.com/xinxi/458640330.htm
www.51sole.com/xinxi/458640510.htm
www.51sole.com/xinxi/458641040.htm
www.51sole.com/xinxi/458641368.htm
www.51sole.com/xinxi/458641566.htm
www.51sole.com/xinxi/458642452.htm
www.51sole.com/xinxi/458642622.htm
www.51sole.com/xinxi/458642781.htm
www.51sole.com/xinxi/458643496.htm
www.51sole.com/xinxi/458644056.htm
www.51sole.com/xinxi/458644237.htm
www.51sole.com/xinxi/458644410.htm
www.51sole.com/xinxi/458644573.htm
www.51sole.com/xinxi/458644740.htm
www.51sole.com/xinxi/458645098.htm
www.51sole.com/xinxi/458645256.htm
www.51sole.com/xinxi/458645409.htm
www.51sole.com/xinxi/458645576.htm
www.51sole.com/xinxi/458646206.htm
www.51sole.com/xinxi/458646392.htm
www.51sole.com/xinxi/458646928.htm
www.51sole.com/xinxi/458647432.htm
www.51sole.com/xinxi/458647767.htm
www.51sole.com/xinxi/458647944.htm
www.51sole.com/xinxi/458648114.htm
www.51sole.com/xinxi/458648260.htm
www.51sole.com/xinxi/458648592.htm
www.51sole.com/xinxi/458648743.htm
www.51sole.com/xinxi/458648901.htm
www.51sole.com/xinxi/458649201.htm
www.51sole.com/xinxi/458649371.htm
www.51sole.com/xinxi/458649524.htm
www.51sole.com/xinxi/458650294.htm
www.51sole.com/xinxi/458650443.htm
www.51sole.com/xinxi/458650735.htm
www.51sole.com/xinxi/458650884.htm
www.51sole.com/xinxi/458651017.htm
www.51sole.com/xinxi/458651178.htm
www.51sole.com/xinxi/458651331.htm
www.51sole.com/xinxi/458651728.htm
www.51sole.com/xinxi/458652021.htm
www.51sole.com/xinxi/458652160.htm
www.51sole.com/xinxi/458652598.htm
www.51sole.com/xinxi/458653041.htm
www.51sole.com/xinxi/458653324.htm
www.51sole.com/xinxi/458654046.htm
www.51sole.com/xinxi/458654487.htm
www.51sole.com/xinxi/458654746.htm
www.51sole.com/xinxi/458655039.htm
www.51sole.com/xinxi/458655184.htm
www.51sole.com/xinxi/458655450.htm
www.51sole.com/xinxi/458655560.htm
www.51sole.com/xinxi/458655838.htm
www.51sole.com/xinxi/458656203.htm
www.51sole.com/xinxi/458656329.htm
www.51sole.com/xinxi/458656442.htm
www.51sole.com/xinxi/458656568.htm
www.51sole.com/xinxi/458656692.htm
www.51sole.com/xinxi/458656954.htm
www.51sole.com/xinxi/458657176.htm
www.51sole.com/xinxi/458657417.htm
www.51sole.com/xinxi/458657636.htm
www.51sole.com/xinxi/458657893.htm
www.51sole.com/xinxi/458658011.htm
www.51sole.com/xinxi/458658140.htm
www.51sole.com/xinxi/458658251.htm
www.51sole.com/xinxi/458658604.htm
www.51sole.com/xinxi/458658712.htm
www.51sole.com/xinxi/458658940.htm
www.51sole.com/xinxi/458659044.htm
www.51sole.com/xinxi/458659154.htm
www.51sole.com/xinxi/458659482.htm
www.51sole.com/xinxi/458659815.htm
www.51sole.com/xinxi/458659930.htm
www.51sole.com/xinxi/458660136.htm
www.51sole.com/xinxi/458660234.htm
www.51sole.com/xinxi/458660432.htm
www.51sole.com/xinxi/458660543.htm
www.51sole.com/xinxi/458660857.htm
www.51sole.com/xinxi/458661072.htm
www.51sole.com/xinxi/458661165.htm
www.51sole.com/xinxi/458661483.htm
www.51sole.com/xinxi/458661860.htm
www.51sole.com/xinxi/458661966.htm
www.51sole.com/xinxi/458662070.htm
www.51sole.com/xinxi/458662418.htm
www.51sole.com/xinxi/458662777.htm
www.51sole.com/xinxi/458662866.htm
www.51sole.com/xinxi/458663166.htm
www.51sole.com/xinxi/458663447.htm
www.51sole.com/xinxi/458663795.htm
www.51sole.com/xinxi/458663989.htm
www.51sole.com/xinxi/458664165.htm
www.51sole.com/xinxi/458664337.htm
www.51sole.com/xinxi/458664435.htm
www.51sole.com/xinxi/458664598.htm
www.51sole.com/xinxi/458664680.htm
www.51sole.com/xinxi/458664833.htm
www.51sole.com/xinxi/458664993.htm
www.51sole.com/xinxi/458665072.htm
www.51sole.com/xinxi/458665158.htm
www.51sole.com/xinxi/458665329.htm
www.51sole.com/xinxi/458665390.htm
www.51sole.com/xinxi/458665752.htm
www.51sole.com/xinxi/458665909.htm
www.51sole.com/xinxi/458665992.htm
www.51sole.com/xinxi/458666056.htm
www.51sole.com/xinxi/458666132.htm
www.51sole.com/xinxi/458666388.htm
www.51sole.com/xinxi/458666627.htm
www.51sole.com/xinxi/458666712.htm
www.51sole.com/xinxi/458666789.htm
www.51sole.com/xinxi/458666872.htm
www.51sole.com/xinxi/458666951.htm
www.51sole.com/xinxi/458667111.htm
www.51sole.com/xinxi/458667187.htm
www.51sole.com/xinxi/458667268.htm
www.51sole.com/xinxi/458667441.htm
www.51sole.com/xinxi/458667524.htm
www.51sole.com/xinxi/458667620.htm
www.51sole.com/xinxi/458667940.htm
www.51sole.com/xinxi/458668113.htm
www.51sole.com/xinxi/458668197.htm
www.51sole.com/xinxi/458668287.htm
www.51sole.com/xinxi/458668361.htm
www.51sole.com/xinxi/458668536.htm
www.51sole.com/xinxi/458668818.htm
www.51sole.com/xinxi/458668907.htm
www.51sole.com/xinxi/458669171.htm
www.51sole.com/xinxi/458669503.htm
www.51sole.com/xinxi/458669795.htm
www.51sole.com/xinxi/458670025.htm
www.51sole.com/xinxi/458670109.htm
www.51sole.com/xinxi/458670337.htm
www.51sole.com/xinxi/458670409.htm
www.51sole.com/xinxi/458670569.htm
www.51sole.com/xinxi/458670658.htm
www.51sole.com/xinxi/458670734.htm
www.51sole.com/xinxi/458670889.htm
www.51sole.com/xinxi/458670981.htm
www.51sole.com/xinxi/458671135.htm
www.51sole.com/xinxi/458671290.htm
www.51sole.com/xinxi/458671703.htm
www.51sole.com/xinxi/458671984.htm
www.51sole.com/xinxi/458672055.htm
www.51sole.com/xinxi/458672133.htm
www.51sole.com/xinxi/458672261.htm
www.51sole.com/xinxi/458672412.htm
www.51sole.com/xinxi/458672656.htm
www.51sole.com/xinxi/458672762.htm
www.51sole.com/xinxi/458672937.htm
www.51sole.com/xinxi/458673032.htm
www.51sole.com/xinxi/458673111.htm
www.51sole.com/xinxi/458673277.htm
www.51sole.com/xinxi/458673357.htm
www.51sole.com/xinxi/458673526.htm
www.51sole.com/xinxi/458673594.htm
www.51sole.com/xinxi/458673679.htm
www.51sole.com/xinxi/458673839.htm
www.51sole.com/xinxi/458674010.htm
www.51sole.com/xinxi/458674091.htm
www.51sole.com/xinxi/458674271.htm
www.51sole.com/xinxi/458674440.htm
www.51sole.com/xinxi/458674521.htm
www.51sole.com/xinxi/458674599.htm
www.51sole.com/xinxi/458674679.htm
www.51sole.com/xinxi/458674854.htm
www.51sole.com/xinxi/458674952.htm
www.51sole.com/xinxi/458675099.htm
www.51sole.com/xinxi/458675259.htm
www.51sole.com/xinxi/458675537.htm
www.51sole.com/xinxi/458675878.htm
www.51sole.com/xinxi/458675969.htm
www.51sole.com/xinxi/458676149.htm
www.51sole.com/xinxi/458676412.htm
www.51sole.com/xinxi/458676495.htm
www.51sole.com/xinxi/458676595.htm
www.51sole.com/xinxi/458676687.htm
www.51sole.com/xinxi/458676786.htm
www.51sole.com/xinxi/458677340.htm
www.51sole.com/xinxi/458677422.htm
www.51sole.com/xinxi/458677602.htm
www.51sole.com/xinxi/458677778.htm
www.51sole.com/xinxi/458678275.htm
www.51sole.com/xinxi/458678346.htm
www.51sole.com/xinxi/458678487.htm
www.51sole.com/xinxi/458678572.htm
www.51sole.com/xinxi/458678659.htm
www.51sole.com/xinxi/458678728.htm
www.51sole.com/xinxi/458678808.htm
www.51sole.com/xinxi/458678948.htm
www.51sole.com/xinxi/458679120.htm
www.51sole.com/xinxi/458679410.htm
www.51sole.com/xinxi/458679487.htm
www.51sole.com/xinxi/458679573.htm
www.51sole.com/xinxi/458679659.htm
www.51sole.com/xinxi/458679736.htm
www.51sole.com/xinxi/458679813.htm
www.51sole.com/xinxi/458679902.htm
www.51sole.com/xinxi/458680124.htm
www.51sole.com/xinxi/458680279.htm
www.51sole.com/xinxi/458680366.htm
www.51sole.com/xinxi/458680444.htm
www.51sole.com/xinxi/458680596.htm
www.51sole.com/xinxi/458680675.htm
www.51sole.com/xinxi/458680755.htm
www.51sole.com/xinxi/458680827.htm
www.51sole.com/xinxi/458680982.htm
www.51sole.com/xinxi/458681123.htm
www.51sole.com/xinxi/458681193.htm
www.51sole.com/xinxi/458681479.htm
www.51sole.com/xinxi/458681684.htm
www.51sole.com/xinxi/458681897.htm
www.51sole.com/xinxi/458682165.htm
www.51sole.com/xinxi/458682342.htm
www.51sole.com/xinxi/458682398.htm
www.51sole.com/xinxi/458682459.htm
www.51sole.com/xinxi/458682507.htm
www.51sole.com/xinxi/458682799.htm
www.51sole.com/xinxi/458682865.htm
www.51sole.com/xinxi/458682922.htm
www.51sole.com/xinxi/458683224.htm
www.51sole.com/xinxi/458683285.htm
www.51sole.com/xinxi/458683349.htm
www.51sole.com/xinxi/458683584.htm
www.51sole.com/xinxi/458683642.htm
www.51sole.com/xinxi/458683723.htm
www.51sole.com/xinxi/458684003.htm
www.51sole.com/xinxi/458684177.htm
www.51sole.com/xinxi/458684242.htm
www.51sole.com/xinxi/458684354.htm
www.51sole.com/xinxi/458684474.htm
www.51sole.com/xinxi/458684646.htm
www.51sole.com/xinxi/458684713.htm
www.51sole.com/xinxi/458684770.htm
www.51sole.com/xinxi/458684827.htm
www.51sole.com/xinxi/458684940.htm
www.51sole.com/xinxi/458685161.htm
www.51sole.com/xinxi/458685216.htm
www.51sole.com/xinxi/458685283.htm
www.51sole.com/xinxi/458685391.htm
www.51sole.com/xinxi/458685445.htm
www.51sole.com/xinxi/458685508.htm
www.51sole.com/xinxi/458685637.htm
www.51sole.com/xinxi/458685699.htm
www.51sole.com/xinxi/458685883.htm
www.51sole.com/xinxi/458686080.htm
www.51sole.com/xinxi/458686327.htm
www.51sole.com/xinxi/458686526.htm
www.51sole.com/xinxi/458686590.htm
www.51sole.com/xinxi/458686721.htm
www.51sole.com/xinxi/458686787.htm
www.51sole.com/xinxi/458686854.htm
www.51sole.com/xinxi/458686982.htm
www.51sole.com/xinxi/458687107.htm
www.51sole.com/xinxi/458687289.htm
www.51sole.com/xinxi/458687354.htm
www.51sole.com/xinxi/458687619.htm
www.51sole.com/xinxi/458687700.htm
www.51sole.com/xinxi/458688024.htm
www.51sole.com/xinxi/458688276.htm
www.51sole.com/xinxi/458688335.htm
www.51sole.com/xinxi/458688450.htm
www.51sole.com/xinxi/458688643.htm
www.51sole.com/xinxi/458688791.htm
www.51sole.com/xinxi/458688863.htm
www.51sole.com/xinxi/458689017.htm
www.51sole.com/xinxi/458689169.htm
www.51sole.com/xinxi/458689502.htm
www.51sole.com/xinxi/458689567.htm
www.51sole.com/xinxi/458689630.htm
www.51sole.com/xinxi/458689770.htm
www.51sole.com/xinxi/458689837.htm
www.51sole.com/xinxi/458689903.htm
www.51sole.com/xinxi/458689961.htm
www.51sole.com/xinxi/458690090.htm
www.51sole.com/xinxi/458690222.htm
www.51sole.com/xinxi/458690296.htm
www.51sole.com/xinxi/458690477.htm
www.51sole.com/xinxi/458690538.htm
www.51sole.com/xinxi/458690599.htm
www.51sole.com/xinxi/458690661.htm
www.51sole.com/xinxi/458690724.htm
www.51sole.com/xinxi/458690794.htm
www.51sole.com/xinxi/458690866.htm
www.51sole.com/xinxi/458690930.htm
www.51sole.com/xinxi/458691005.htm
www.51sole.com/xinxi/458691128.htm
www.51sole.com/xinxi/458691265.htm
www.51sole.com/xinxi/458691334.htm
www.51sole.com/xinxi/458691454.htm
www.51sole.com/xinxi/458691512.htm
www.51sole.com/xinxi/458691570.htm
www.51sole.com/xinxi/458691679.htm
www.51sole.com/xinxi/458691800.htm
www.51sole.com/xinxi/458691964.htm
www.51sole.com/xinxi/458692019.htm
www.51sole.com/xinxi/458692248.htm
www.51sole.com/xinxi/458692301.htm