v4.0.51模型多对多关联超过一定数量报错

[skyselang]

会员表ya_member：member_id，nickname；
会员标签表ya_member_tag：tag_id，tag_name；
会员标签关联表ya_member_attributes：id，member_id，tag_id；

模型多对多关联查询

$list  = $model->with($with)->page($page)->limit($limit)->append($append)->hidden($hidden)->group($group)->order($order)->select()->toArray();

当limit等于300是正常的；超过300的时候会报错（具体数值未知，因为分页数量设置了只能选...300,500,800,1000）：

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'tag_id' in where clause is ambiguous；

[skyselang]

查看sql语句发现超过一定数量查询语句不一样：
limit300:

SELECT `ya_member_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`member_id` AS `pivot__member_id`,`pivot`.`group_id` AS `pivot__group_id`,`pivot`.`tag_id` AS `pivot__tag_id`
FROM `ya_member_tag`
INNER JOIN `ya_member_attributes` `pivot` ON `pivot`.`tag_id`=`ya_member_tag`.`tag_id`
WHERE  (
  `pivot`.`member_id` IN ('100001','100000','99999','99998','99997','99996','99995','99994','99993','99992','99991','99990','99989','99988','99987','99986','99985','99984','99983','99982','99981','99980','99979','99978','99977','99976','99975','99974','99973','99972','99971','99970','99969','99968','99967','99966','99965','99964','99963','99962','99961','99960','99959','99958','99957','99956','99955','99954','99953','99952','99951','99950','99949','99948','99947','99946','99945','99944','99943','99942','99941','99940','99939','99938','99937','99936','99935','99934','99933','99932','99931','99930','99929','99928','99927','99926','99925','99924','99923','99922','99921','99920','99919','99918','99917','99916','99915','99914','99913','99912','99911','99910','99909','99908','99907','99906','99905','99904','99903','99902','99901','99900','99899','99898','99897','99896','99895','99894','99893','99892','99891','99890','99889','99888','99887','99886','99885','99884','99883','99882','99881','99880','99879','99878','99877','99876','99875','99874','99873','99872','99871','99870','99869','99868','99867','99866','99865','99864','99863','99862','99861','99860','99859','99858','99857','99856','99855','99854','99853','99852','99851','99850','99849','99848','99847','99846','99845','99844','99843','99842','99841','99840','99839','99838','99837','99836','99835','99834','99833','99832','99831','99830','99829','99828','99827','99826','99825','99824','99823','99822','99821','99820','99819','99818','99817','99816','99815','99814','99813','99812','99811','99810','99809','99808','99807','99806','99805','99804','99803','99802','99801','99800','99799','99798','99797','99796','99795','99794','99793','99792','99791','99790','99789','99788','99787','99786','99785','99784','99783','99782','99781','99780','99779','99778','99777','99776','99775','99774','99773','99772','99771','99770','99769','99768','99767','99766','99765','99764','99763','99762','99761','99760','99759','99758','99757','99756','99755','99754','99753','99752','99751','99750','99749','99748','99747','99746','99745','99744','99743','99742','99741','99740','99739','99738','99737','99736','99735','99734','99733','99732','99731','99730','99729','99728','99727','99726','99725','99724','99723','99722','99721','99720','99719','99718','99717','99716','99715','99714','99713','99712','99711','99710','99709','99708','99707','99706','99705','99704','99703','99702')
 )
 ORDER BY `tag_id` DESC
 LIMIT 1000

limit500

SELECT `ya_member_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`member_id` AS `pivot__member_id`,`pivot`.`group_id` AS `pivot__group_id`,`pivot`.`tag_id` AS `pivot__tag_id`
 FROM `ya_member_tag`
 INNER JOIN `ya_member_attributes` `pivot` ON `pivot`.`tag_id`=`ya_member_tag`.`tag_id`
 WHERE  (
  `pivot`.`member_id` IN (:ThinkBind_1_637987322_,:ThinkBind_2_721438219_,:ThinkBind_3_1413211595_,:ThinkBind_4_445839638_,:ThinkBind_5_1493217608_,:ThinkBind_6_1972160969_,:ThinkBind_7_532032851_,:ThinkBind_8_993411534_,:ThinkBind_9_1979211848_,:ThinkBind_10_1080540716_,:ThinkBind_11_1054188877_,:ThinkBind_12_1966851107_,:ThinkBind_13_708554808_,:ThinkBind_14_1486329013_,:ThinkBind_15_1647913989_,:ThinkBind_16_1331388141_,:ThinkBind_17_939669388_,:ThinkBind_18_1802311163_,:ThinkBind_19_534981565_,:ThinkBind_20_1452767245_,:ThinkBind_21_476852798_,:ThinkBind_22_699841341_,:ThinkBind_23_1791501671_,:ThinkBind_24_148323533_,:ThinkBind_25_876555443_,:ThinkBind_26_1689145550_,:ThinkBind_27_127278194_,:ThinkBind_28_1333106441_,:ThinkBind_29_157873578_,:ThinkBind_30_428526039_,:ThinkBind_31_1215428217_,:ThinkBind_32_1907662883_,:ThinkBind_33_873342348_,:ThinkBind_34_76327268_,:ThinkBind_35_331040674_,:ThinkBind_36_1305623525_,:ThinkBind_37_810647784_,:ThinkBind_38_2018381747_,:ThinkBind_39_372744188_,:ThinkBind_40_1723855184_,:ThinkBind_41_860717312_,:ThinkBind_42_1435031245_,:ThinkBind_43_1598473654_,:ThinkBind_44_1342055243_,:ThinkBind_45_1089472697_,:ThinkBind_46_411589962_,:ThinkBind_47_304618627_,:ThinkBind_48_1625077245_,:ThinkBind_49_1318729676_,:ThinkBind_50_838048492_,:ThinkBind_51_1351252149_,:ThinkBind_52_1323515761_,:ThinkBind_53_2112493991_,:ThinkBind_54_1770231591_,:ThinkBind_55_390418244_,:ThinkBind_56_326052321_,:ThinkBind_57_2075352342_,:ThinkBind_58_198396026_,:ThinkBind_59_1645942430_,:ThinkBind_60_127829468_,:ThinkBind_61_298161352_,:ThinkBind_62_579228513_,:ThinkBind_63_580175285_,:ThinkBind_64_1652327928_,:ThinkBind_65_307836777_,:ThinkBind_66_521456837_,:ThinkBind_67_1607869182_,:ThinkBind_68_1600061629_,:ThinkBind_69_411499037_,:ThinkBind_70_1749286738_,:ThinkBind_71_1464693214_,:ThinkBind_72_431257087_,:ThinkBind_73_608636656_,:ThinkBind_74_1237297629_,:ThinkBind_75_1519626492_,:ThinkBind_76_705370936_,:ThinkBind_77_851285354_,:ThinkBind_78_1872092601_,:ThinkBind_79_386581980_,:ThinkBind_80_2049553984_,:ThinkBind_81_1174661959_,:ThinkBind_82_2049388122_,:ThinkBind_83_959094897_,:ThinkBind_84_2113851407_,:ThinkBind_85_609392828_,:ThinkBind_86_1690656768_,:ThinkBind_87_1330922928_,:ThinkBind_88_1402009625_,:ThinkBind_89_1177183243_,:ThinkBind_90_406176998_,:ThinkBind_91_1056202494_,:ThinkBind_92_392289300_,:ThinkBind_93_210926591_,:ThinkBind_94_366581500_,:ThinkBind_95_1561027988_,:ThinkBind_96_1422173792_,:ThinkBind_97_1250300716_,:ThinkBind_98_445038613_,:ThinkBind_99_1413594444_,:ThinkBind_100_45588035_,:ThinkBind_101_228118788_,:ThinkBind_102_569610548_,:ThinkBind_103_605496061_,:ThinkBind_104_564708475_,:ThinkBind_105_1026144753_,:ThinkBind_106_1261152489_,:ThinkBind_107_605901056_,:ThinkBind_108_1423391072_,:ThinkBind_109_1313000570_,:ThinkBind_110_2077399528_,:ThinkBind_111_1169235723_,:ThinkBind_112_1559058630_,:ThinkBind_113_1122916524_,:ThinkBind_114_586725113_,:ThinkBind_115_1487199586_,:ThinkBind_116_1103182147_,:ThinkBind_117_1720468914_,:ThinkBind_118_243137461_,:ThinkBind_119_605098008_,:ThinkBind_120_1109053629_,:ThinkBind_121_388036034_,:ThinkBind_122_1155930003_,:ThinkBind_123_2021468174_,:ThinkBind_124_1942567573_,:ThinkBind_125_550995203_,:ThinkBind_126_1136189651_,:ThinkBind_127_639590837_,:ThinkBind_128_833719615_,:ThinkBind_129_1142925483_,:ThinkBind_130_1055200808_,:ThinkBind_131_1376553290_,:ThinkBind_132_1087451100_,:ThinkBind_133_1118176830_,:ThinkBind_134_1772614454_,:ThinkBind_135_837508743_,:ThinkBind_136_2087137527_,:ThinkBind_137_1649996741_,:ThinkBind_138_370018504_,:ThinkBind_139_1372134019_,:ThinkBind_140_856369310_,:ThinkBind_141_631988015_,:ThinkBind_142_366555076_,:ThinkBind_143_1523457435_,:ThinkBind_144_1061952824_,:ThinkBind_145_1718234462_,:ThinkBind_146_987378498_,:ThinkBind_147_1200842760_,:ThinkBind_148_1274005968_,:ThinkBind_149_1380434361_,:ThinkBind_150_986165989_,:ThinkBind_151_1523065837_,:ThinkBind_152_1863191881_,:ThinkBind_153_1808187743_,:ThinkBind_154_2117613262_,:ThinkBind_155_7053679_,:ThinkBind_156_637128687_,:ThinkBind_157_354540769_,:ThinkBind_158_1504682131_,:ThinkBind_159_92895657_,:ThinkBind_160_670534052_,:ThinkBind_161_605573267_,:ThinkBind_162_204989092_,:ThinkBind_163_750940690_,:ThinkBind_164_487284724_,:ThinkBind_165_1303716519_,:ThinkBind_166_1861350269_,:ThinkBind_167_1362852678_,:ThinkBind_168_1454953780_,:ThinkBind_169_1366295093_,:ThinkBind_170_464228782_,:ThinkBind_171_1098367134_,:ThinkBind_172_1059162384_,:ThinkBind_173_1834138431_,:ThinkBind_174_1325392453_,:ThinkBind_175_1071695682_,:ThinkBind_176_1756100441_,:ThinkBind_177_1566808508_,:ThinkBind_178_1731543218_,:ThinkBind_179_2078746189_,:ThinkBind_180_340373326_,:ThinkBind_181_987769356_,:ThinkBind_182_1546577494_,:ThinkBind_183_943219199_,:ThinkBind_184_1977503350_,:ThinkBind_185_992546209_,:ThinkBind_186_1858465892_,:ThinkBind_187_484660453_,:ThinkBind_188_694204622_,:ThinkBind_189_124606861_,:ThinkBind_190_1053989436_,:ThinkBind_191_1103827962_,:ThinkBind_192_383646297_,:ThinkBind_193_656152253_,:ThinkBind_194_4130951_,:ThinkBind_195_678684696_,:ThinkBind_196_1477896752_,:ThinkBind_197_857709203_,:ThinkBind_198_1881555823_,:ThinkBind_199_128010988_,:ThinkBind_200_571684914_,:ThinkBind_201_1631892526_,:ThinkBind_202_1864404538_,:ThinkBind_203_537715055_,:ThinkBind_204_214805546_,:ThinkBind_205_289146873_,:ThinkBind_206_2011982511_,:ThinkBind_207_455269626_,:ThinkBind_208_529413695_,:ThinkBind_209_1760964362_,:ThinkBind_210_405658563_,:ThinkBind_211_2126154489_,:ThinkBind_212_2078039237_,:ThinkBind_213_1531502775_,:ThinkBind_214_110348844_,:ThinkBind_215_803077125_,:ThinkBind_216_1389659010_,:ThinkBind_217_1909973480_,:ThinkBind_218_502474516_,:ThinkBind_219_1405059153_,:ThinkBind_220_927647559_,:ThinkBind_221_1954493666_,:ThinkBind_222_64525413_,:ThinkBind_223_1293993475_,:ThinkBind_224_1678733525_,:ThinkBind_225_31856997_,:ThinkBind_226_1086906552_,:ThinkBind_227_1199945591_,:ThinkBind_228_501388519_,:ThinkBind_229_309008481_,:ThinkBind_230_1696951798_,:ThinkBind_231_170239956_,:ThinkBind_232_1584870701_,:ThinkBind_233_1120380866_,:ThinkBind_234_1950601493_,:ThinkBind_235_692641918_,:ThinkBind_236_2082625246_,:ThinkBind_237_1303760475_,:ThinkBind_238_1675968672_,:ThinkBind_239_1843902899_,:ThinkBind_240_1373049670_,:ThinkBind_241_157407633_,:ThinkBind_242_474498769_,:ThinkBind_243_842828509_,:ThinkBind_244_936257081_,:ThinkBind_245_2135547701_,:ThinkBind_246_802671487_,:ThinkBind_247_1189605317_,:ThinkBind_248_1607777257_,:ThinkBind_249_665207051_,:ThinkBind_250_916944428_,:ThinkBind_251_2029543102_,:ThinkBind_252_1143480246_,:ThinkBind_253_1672735674_,:ThinkBind_254_814410717_,:ThinkBind_255_1896200126_,:ThinkBind_256_1853193888_,:ThinkBind_257_1813455669_,:ThinkBind_258_1271998065_,:ThinkBind_259_1124014594_,:ThinkBind_260_820978527_,:ThinkBind_261_1306495109_,:ThinkBind_262_1850918719_,:ThinkBind_263_2053090965_,:ThinkBind_264_2061637081_,:ThinkBind_265_655403386_,:ThinkBind_266_1389774029_,:ThinkBind_267_435379698_,:ThinkBind_268_1812129540_,:ThinkBind_269_160895626_,:ThinkBind_270_1760569876_,:ThinkBind_271_42615306_,:ThinkBind_272_271494468_,:ThinkBind_273_1981726846_,:ThinkBind_274_388595429_,:ThinkBind_275_1607744571_,:ThinkBind_276_1072061906_,:ThinkBind_277_1631157473_,:ThinkBind_278_353164639_,:ThinkBind_279_783401890_,:ThinkBind_280_1143959809_,:ThinkBind_281_170472274_,:ThinkBind_282_86823635_,:ThinkBind_283_1198690434_,:ThinkBind_284_2032336849_,:ThinkBind_285_765232519_,:ThinkBind_286_698891948_,:ThinkBind_287_1838943816_,:ThinkBind_288_200488901_,:ThinkBind_289_1468151189_,:ThinkBind_290_1389329689_,:ThinkBind_291_288640977_,:ThinkBind_292_650828657_,:ThinkBind_293_1716576824_,:ThinkBind_294_193713021_,:ThinkBind_295_620749837_,:ThinkBind_296_1172444489_,:ThinkBind_297_92429371_,:ThinkBind_298_1443265512_,:ThinkBind_299_528424399_,:ThinkBind_300_734130824_,:ThinkBind_301_56254382_,:ThinkBind_302_1816672747_,:ThinkBind_303_1567067020_,:ThinkBind_304_1351926274_,:ThinkBind_305_1997028117_,:ThinkBind_306_1088158278_,:ThinkBind_307_353514344_,:ThinkBind_308_986125795_,:ThinkBind_309_1988868907_,:ThinkBind_310_356071269_,:ThinkBind_311_2123431536_,:ThinkBind_312_830775816_,:ThinkBind_313_924178067_,:ThinkBind_314_529419190_,:ThinkBind_315_547943060_,:ThinkBind_316_1068994765_,:ThinkBind_317_383691090_,:ThinkBind_318_1536270773_,:ThinkBind_319_1538799143_,:ThinkBind_320_329228728_,:ThinkBind_321_914380722_,:ThinkBind_322_1300666213_,:ThinkBind_323_1576900028_,:ThinkBind_324_2011828665_,:ThinkBind_325_1401305438_,:ThinkBind_326_1105200301_,:ThinkBind_327_882570752_,:ThinkBind_328_1928881382_,:ThinkBind_329_348626391_,:ThinkBind_330_1191750583_,:ThinkBind_331_1035360068_,:ThinkBind_332_15010762_,:ThinkBind_333_88288567_,:ThinkBind_334_1423641508_,:ThinkBind_335_693829911_,:ThinkBind_336_1214926177_,:ThinkBind_337_1535905112_,:ThinkBind_338_69976982_,:ThinkBind_339_2002702311_,:ThinkBind_340_1372455513_,:ThinkBind_341_403036512_,:ThinkBind_342_1669665670_,:ThinkBind_343_738019588_,:ThinkBind_344_565638070_,:ThinkBind_345_155040251_,:ThinkBind_346_1782834068_,:ThinkBind_347_1936540067_,:ThinkBind_348_132053757_,:ThinkBind_349_189466656_,:ThinkBind_350_1061879442_,:ThinkBind_351_1465893686_,:ThinkBind_352_358187741_,:ThinkBind_353_1882201828_,:ThinkBind_354_2082389703_,:ThinkBind_355_1856765093_,:ThinkBind_356_1887939013_,:ThinkBind_357_363407994_,:ThinkBind_358_1253733176_,:ThinkBind_359_1732067942_,:ThinkBind_360_682460788_,:ThinkBind_361_1855618291_,:ThinkBind_362_468222557_,:ThinkBind_363_767149319_,:ThinkBind_364_1743473481_,:ThinkBind_365_1829581032_,:ThinkBind_366_1141875343_,:ThinkBind_367_1998025198_,:ThinkBind_368_567507949_,:ThinkBind_369_1290576989_,:ThinkBind_370_1338327608_,:ThinkBind_371_1597450381_,:ThinkBind_372_140051268_,:ThinkBind_373_2082417826_,:ThinkBind_374_1383640012_,:ThinkBind_375_1203932824_,:ThinkBind_376_1867316783_,:ThinkBind_377_1600631267_,:ThinkBind_378_941532714_,:ThinkBind_379_1167647233_,:ThinkBind_380_1884315918_,:ThinkBind_381_715976286_,:ThinkBind_382_491709308_,:ThinkBind_383_333460917_,:ThinkBind_384_1792764803_,:ThinkBind_385_417131823_,:ThinkBind_386_1667909520_,:ThinkBind_387_1380844052_,:ThinkBind_388_287305953_,:ThinkBind_389_302026003_,:ThinkBind_390_1839725735_,:ThinkBind_391_1661892545_,:ThinkBind_392_2029056892_,:ThinkBind_393_954947626_,:ThinkBind_394_1390543569_,:ThinkBind_395_1277782773_,:ThinkBind_396_161032558_,:ThinkBind_397_898896674_,:ThinkBind_398_1265059839_,:ThinkBind_399_2004012404_,:ThinkBind_400_405172861_,:ThinkBind_401_308320909_,:ThinkBind_402_1658486947_,:ThinkBind_403_303646093_,:ThinkBind_404_114095407_,:ThinkBind_405_169654520_,:ThinkBind_406_202632550_,:ThinkBind_407_1325068390_,:ThinkBind_408_1242022366_,:ThinkBind_409_1779326475_,:ThinkBind_410_1748231492_,:ThinkBind_411_794869963_,:ThinkBind_412_863095868_,:ThinkBind_413_1426029151_,:ThinkBind_414_94135136_,:ThinkBind_415_1603532934_,:ThinkBind_416_1037389536_,:ThinkBind_417_1548449549_,:ThinkBind_418_1322072132_,:ThinkBind_419_1409212849_,:ThinkBind_420_2106267525_,:ThinkBind_421_1537378051_,:ThinkBind_422_1916016964_,:ThinkBind_423_1580710685_,:ThinkBind_424_110584846_,:ThinkBind_425_1332056953_,:ThinkBind_426_1851363762_,:ThinkBind_427_1956644901_,:ThinkBind_428_1983989083_,:ThinkBind_429_704471818_,:ThinkBind_430_210351664_,:ThinkBind_431_1397345772_,:ThinkBind_432_478772323_,:ThinkBind_433_32073073_,:ThinkBind_434_1531675681_,:ThinkBind_435_1211863318_,:ThinkBind_436_1617643646_,:ThinkBind_437_2140524917_,:ThinkBind_438_1296811912_,:ThinkBind_439_1520703578_,:ThinkBind_440_217127900_,:ThinkBind_441_636170532_,:ThinkBind_442_1740650952_,:ThinkBind_443_1417575618_,:ThinkBind_444_1136205982_,:ThinkBind_445_562416135_,:ThinkBind_446_136935152_,:ThinkBind_447_1891980066_,:ThinkBind_448_531848639_,:ThinkBind_449_652054528_,:ThinkBind_450_348428847_,:ThinkBind_451_1488314231_,:ThinkBind_452_11401368_,:ThinkBind_453_174282948_,:ThinkBind_454_752073112_,:ThinkBind_455_1538355911_,:ThinkBind_456_1766037824_,:ThinkBind_457_771317183_,:ThinkBind_458_2101663020_,:ThinkBind_459_327548307_,:ThinkBind_460_753981343_,:ThinkBind_461_736342677_,:ThinkBind_462_967830921_,:ThinkBind_463_1541616257_,:ThinkBind_464_374633091_,:ThinkBind_465_2023723104_,:ThinkBind_466_1564491590_,:ThinkBind_467_660722000_,:ThinkBind_468_1641537466_,:ThinkBind_469_2117379198_,:ThinkBind_470_1259258482_,:ThinkBind_471_2126032796_,:ThinkBind_472_1462064893_,:ThinkBind_473_326250065_,:ThinkBind_474_1631752447_,:ThinkBind_475_587267373_,:ThinkBind_476_1025975851_,:ThinkBind_477_1462823257_,:ThinkBind_478_1320854038_,:ThinkBind_479_1971699565_,:ThinkBind_480_1440991207_,:ThinkBind_481_280181854_,:ThinkBind_482_128197247_,:ThinkBind_483_2062269543_,:ThinkBind_484_1060017142_,:ThinkBind_485_2125121857_,:ThinkBind_486_819694984_,:ThinkBind_487_840130977_,:ThinkBind_488_1310560751_,:ThinkBind_489_1871600262_,:ThinkBind_490_370841189_,:ThinkBind_491_1406582289_,:ThinkBind_492_1732793259_,:ThinkBind_493_793573811_,:ThinkBind_494_1937460734_,:ThinkBind_495_1205089573_,:ThinkBind_496_339144285_,:ThinkBind_497_1322643180_,:ThinkBind_498_1609722596_,:ThinkBind_499_913840196_,:ThinkBind_500_33869258_)
 ) 
 AND `tag_id` < :ThinkBind_501_1455795124_
 ORDER BY `tag_id` DESC
 LIMIT 1000

好像是多了 AND tag_id < ，所以报错了。

[skyselang]

好像是和关联的数量有关，比如100个会员，每个会员关联一个标签，查询没问题；但是100个会员，每个会员关联11个标签，查询就会有问题。

[skyselang]

根因： lazy() 默认使用游标分页，在数据量超过 1000 条时（chunk size 默认值）生成第二批查询：
sql WHERE tag_id < {lastId}
而 belongsToManyQuery 已将主表（ya_member_tag）与中间表（ya_member_attributes）JOIN 在一起，两张表都有 tag_id 列，MySQL 报列歧义错误。