^ array:9 [ "base" => array:4 [ 0 => array:3 [ 0 => "g.is_delete_time" 1 => "=" 2 => 0 ] 1 => array:3 [ 0 => "g.is_shelves" 1 => "=" 2 => 1 ] 2 => array:3 [ 0 => "g.inventory" 1 => ">" 2 => 0 ] 3 => array:3 [ 0 => "g.id" 1 => "in" 2 => array:400 [ 0 => "390716" 1 => "720073" 2 => "1781151" 3 => "1781150" 4 => "1802250" 5 => "1793226" 6 => "776902" 7 => "633355" 8 => "390719" 9 => "801725" 10 => "390720" 11 => "1824119" 12 => "385905" 13 => "388453" 14 => "387174" 15 => "389475" 16 => "387173" 17 => "584564" 18 => "389030" 19 => "798480" 20 => "107112" 21 => "790209" 22 => "516700" 23 => "1135065" 24 => "1287760" 25 => "1135048" 26 => "799553" 27 => "1624741" 28 => "1625486" 29 => "107113" 30 => "798462" 31 => "1472937" 32 => "352128" 33 => "1135073" 34 => "1107936" 35 => "946148" 36 => "982382" 37 => "1627688" 38 => "1652271" 39 => "805236" 40 => "352129" 41 => "1652270" 42 => "1634894" 43 => "352127" 44 => "1135072" 45 => "107098" 46 => "107099" 47 => "604219" 48 => "475645" 49 => "752847" 50 => "107097" 51 => "749314" 52 => "475650" 53 => "749313" 54 => "522898" 55 => "693377" 56 => "1755059" 57 => "352124" 58 => "695816" 59 => "798481" 60 => "523080" 61 => "1781156" 62 => "1781155" 63 => "625491" 64 => "1626134" 65 => "349296" 66 => "723798" 67 => "349298" 68 => "1755058" 69 => "349299" 70 => "349300" 71 => "723776" 72 => "606604" 73 => "1622763" 74 => "1755054" 75 => "1698231" 76 => "712179" 77 => "1624333" 78 => "618483" 79 => "343019" 80 => "1698229" 81 => "1698228" 82 => "343007" 83 => "718451" 84 => "343008" 85 => "552445" 86 => "1626496" 87 => "618485" 88 => "1656002" 89 => "693246" 90 => "1667955" 91 => "1621108" 92 => "343013" 93 => "1656001" 94 => "1624332" 95 => "748508" 96 => "343015" 97 => "1622066" 98 => "1115179" 99 => "723799" 100 => "349302" 101 => "345954" 102 => "1189032" 103 => "345955" 104 => "1698222" 105 => "345957" 106 => "1069929" 107 => "754876" 108 => "1721500" 109 => "345958" 110 => "345959" 111 => "630822" 112 => "1721499" 113 => "458744" 114 => "1721497" 115 => "1660957" 116 => "849271" 117 => "1721495" 118 => "345961" 119 => "1660956" 120 => "345962" 121 => "699516" 122 => "1781148" 123 => "1667951" 124 => "1721501" 125 => "345965" 126 => "1660955" 127 => "699517" 128 => "697330" 129 => "1659914" 130 => "723864" 131 => "470928" 132 => "470931" 133 => "1833338" 134 => "1793224" 135 => "1793223" 136 => "744574" 137 => "233510" 138 => "233517" 139 => "558627" 140 => "1721509" 141 => "233518" 142 => "739927" 143 => "769971" 144 => "552099" 145 => "1755057" 146 => "1793228" 147 => "1698235" 148 => "1721508" 149 => "233520" 150 => "720743" 151 => "233524" 152 => "797113" 153 => "603469" 154 => "233529" 155 => "565216" 156 => "744560" 157 => "807552" 158 => "1112465" 159 => "226591" 160 => "226592" 161 => "226594" 162 => "630370" 163 => "1656005" 164 => "1656004" 165 => "1634892" 166 => "1652268" 167 => "1627687" 168 => "1072368" 169 => "736223" 170 => "226602" 171 => "226595" 172 => "226600" 173 => "226596" 174 => "756632" 175 => "226597" 176 => "565318" 177 => "696826" 178 => "226598" 179 => "815113" 180 => "996552" 181 => "551976" 182 => "1656003" 183 => "1677256" 184 => "1652267" 185 => "1677255" 186 => "1667959" 187 => "1667958" 188 => "1652266" 189 => "1660962" 190 => "1660961" 191 => "1634891" 192 => "1634890" 193 => "1667957" 194 => "1646778" 195 => "807565" 196 => "226606" 197 => "226607" 198 => "525733" 199 => "766410" 200 => "790568" 201 => "226605" 202 => "526009" 203 => "1793227" 204 => "1646777" 205 => "226610" 206 => "634463" 207 => "634467" 208 => "634469" 209 => "634471" 210 => "632940" 211 => "1621744" 212 => "710596" 213 => "1624740" 214 => "233512" 215 => "644250" 216 => "1755055" 217 => "227993" 218 => "230311" 219 => "583929" 220 => "697269" 221 => "1627685" 222 => "1626495" 223 => "641060" 224 => "1626494" 225 => "227660" 226 => "756712" 227 => "1656000" 228 => "1630386" 229 => "1698225" 230 => "996485" 231 => "648517" 232 => "648570" 233 => "565378" 234 => "765244" 235 => "230034" 236 => "230035" 237 => "619593" 238 => "230036" 239 => "693947" 240 => "805847" 241 => "756808" 242 => "716542" 243 => "1698224" 244 => "1655999" 245 => "1667952" 246 => "525664" 247 => "230040" 248 => "756856" 249 => "230037" 250 => "654144" 251 => "230038" 252 => "803049" 253 => "757063" 254 => "709740" 255 => "693166" 256 => "718057" 257 => "1698220" 258 => "1698221" 259 => "229281" 260 => "229282" 261 => "537812" 262 => "1677252" 263 => "1660959" 264 => "1660958" 265 => "1698219" 266 => "726667" 267 => "996649" 268 => "229289" 269 => "1072794" 270 => "539429" 271 => "229290" 272 => "229291" 273 => "525732" 274 => "229283" 275 => "902915" 276 => "756777" 277 => "229284" 278 => "551767" 279 => "229287" 280 => "698896" 281 => "229292" 282 => "1106735" 283 => "768554" 284 => "717996" 285 => "1721496" 286 => "1625484" 287 => "1625483" 288 => "552032" 289 => "1677251" 290 => "1677250" 291 => "1667950" 292 => "1652262" 293 => "1677249" 294 => "1698217" 295 => "1479348" 296 => "998551" 297 => "807623" 298 => "229301" 299 => "229302" 300 => "229304" 301 => "229294" 302 => "632165" 303 => "903886" 304 => "756841" 305 => "759739" 306 => "229296" 307 => "229306" 308 => "229305" 309 => "619574" 310 => "229309" 311 => "229307" 312 => "619581" 313 => "1721494" 314 => "1667948" 315 => "229311" 316 => "229312" 317 => "1660954" 318 => "431398" 319 => "427092" 320 => "427089" 321 => "417915" 322 => "634762" 323 => "1802252" 324 => "521963" 325 => "1802251" 326 => "1755053" 327 => "1755052" 328 => "631473" 329 => "652973" 330 => "1813658" 331 => "522057" 332 => "634689" 333 => "521999" 334 => "1847210" 335 => "1813674" 336 => "1833345" 337 => "1824118" 338 => "640072" 339 => "1813660" 340 => "693847" 341 => "544609" 342 => "1824122" 343 => "500183" 344 => "494529" 345 => "494528" 346 => "1721506" 347 => "1698233" 348 => "495527" 349 => "498123" 350 => "484673" 351 => "1824121" 352 => "1824120" 353 => "1841509" 354 => "560937" 355 => "481828" 356 => "483138" 357 => "610199" 358 => "1824125" 359 => "521680" 360 => "1847211" 361 => "1833343" 362 => "1824126" 363 => "1833342" 364 => "1833341" 365 => "1824117" 366 => "1824116" 367 => "1833347" 368 => "1824112" 369 => "520485" 370 => "1698232" 371 => "1824111" 372 => "1813661" 373 => "519694" 374 => "1813659" 375 => "1813657" 376 => "519573" 377 => "519425" 378 => "754433" 379 => "1699618" 380 => "1674254" 381 => "1820168" 382 => "1189464" 383 => "1189311" 384 => "1189234" 385 => "1621068" 386 => "1621109" 387 => "1624739" 388 => "1824109" 389 => "1634893" 390 => "1626497" 391 => "1793230" 392 => "1833336" 393 => "1755051" 394 => "1667954" 395 => "1802248" 396 => "1824124" 397 => "1793232" 398 => "1844321" 399 => "1698236" ] ] ] "keywords" => array:1 [ 0 => array:3 [ 0 => "g.model_base" 1 => "like" 2 => "6205%" ] ] "keywords_substr" => "REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='6205'" "fankeywords" => array:1 [ 0 => array:3 [ 0 => "g.spec_desc" 1 => "like" 2 => "5026|%" ] ] "keywords_fansubstr" => "REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='5026'" "goods_params" => [] "screening_price" => [] "order_by" => "g.sales_count desc" "is_map" => 1 ]
^ "SELECT DISTINCT `g`.`id` FROM `brg_goods` `g` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('390716','720073','1781151','1781150','1802250','1793226','776902','633355','390719','801725','390720','1824119','385905','388453','387174','389475','387173','584564','389030','798480','107112','790209','516700','1135065','1287760','1135048','799553','1624741','1625486','107113','798462','1472937','352128','1135073','1107936','946148','982382','1627688','1652271','805236','352129','1652270','1634894','352127','1135072','107098','107099','604219','475645','752847','107097','749314','475650','749313','522898','693377','1755059','352124','695816','798481','523080','1781156','1781155','625491','1626134','349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864','470928','470931','1833338','1793224','1793223','744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954','431398','427092','427089','417915','634762','1802252','521963','1802251','1755053','1755052','631473','652973','1813658','522057','634689','521999','1847210','1813674','1833345','1824118','640072','1813660','693847','544609','1824122','500183','494529','494528','1721506','1698233','495527','498123','484673','1824121','1824120','1841509','560937','481828','483138','610199','1824125','521680','1847211','1833343','1824126','1833342','1833341','1824117','1824116','1833347','1824112','520485','1698232','1824111','1813661','519694','1813659','1813657','519573','519425','754433','1699618','1674254','1820168','1189464','1189311','1189234','1621068','1621109','1624739','1824109','1634893','1626497','1793230','1833336','1755051','1667954','1802248','1824124','1793232','1844321','1698236') AND ( `g`.`model_base` LIKE '6205%' ) AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='6205' ) ORDER BY `g`.`id` ASC"
^ "SELECT DISTINCT `g`.`id` FROM `brg_goods` `g` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('390716','720073','1781151','1781150','1802250','1793226','776902','633355','390719','801725','390720','1824119','385905','388453','387174','389475','387173','584564','389030','798480','107112','790209','516700','1135065','1287760','1135048','799553','1624741','1625486','107113','798462','1472937','352128','1135073','1107936','946148','982382','1627688','1652271','805236','352129','1652270','1634894','352127','1135072','107098','107099','604219','475645','752847','107097','749314','475650','749313','522898','693377','1755059','352124','695816','798481','523080','1781156','1781155','625491','1626134','349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864','470928','470931','1833338','1793224','1793223','744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954','431398','427092','427089','417915','634762','1802252','521963','1802251','1755053','1755052','631473','652973','1813658','522057','634689','521999','1847210','1813674','1833345','1824118','640072','1813660','693847','544609','1824122','500183','494529','494528','1721506','1698233','495527','498123','484673','1824121','1824120','1841509','560937','481828','483138','610199','1824125','521680','1847211','1833343','1824126','1833342','1833341','1824117','1824116','1833347','1824112','520485','1698232','1824111','1813661','519694','1813659','1813657','519573','519425','754433','1699618','1674254','1820168','1189464','1189311','1189234','1621068','1621109','1624739','1824109','1634893','1626497','1793230','1833336','1755051','1667954','1802248','1824124','1793232','1844321','1698236') AND ( `g`.`spec_desc` LIKE '5026|%' ) AND ( REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='5026' ) ORDER BY `g`.`id` ASC"
^ "SELECT g.id,g.shop_category_id,g.brand_id,g.title,g.simple_desc,g.model_base,g.inventory,g.images,g.original_price,g.max_original_price,g.min_original_price,g.price,g.min_price,g.max_price,g.buy_max_number,g.buy_min_number,g.photo_count,g.sales_count,g.access_count,g.is_exist_many_spec,g.model,g.model_base,length(g.model) as goodslen FROM `brg_brand` `b` INNER JOIN `brg_goods` `g` ON `g`.`brand_id`=`b`.`id` WHERE `g`.`id` IN ('107097','107098','107099','107112','107113','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','352124','352127','352128','352129','385905','387173','387174','388453','389475','390716','390719','390720','417915','427089','427092','431398','458744','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','498123','500183','516700','519425','519573','519694','521680','521963','521999','522057','522898','523080','525664','525732','525733','526009','537812','539429','544609','551767','551976','552032','552099','552445','558627','560937','565216','565318','565378','583929','584564','603469','604219','606604','610199','618483','618485','619574','619581','619593','625491','630370','630822','631473','632165','632940','633355','634463','634467','634469','634471','634689','634762','640072','641060','644250','648517','648570','652973','654144','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','716542','717996','718057','718451','720073','720743','723776','723798','723799','726667','736223','739927','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','776902','790209','790568','797113','798462','798480','798481','799553','801725','803049','805236','805847','807552','807565','807623','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1106735','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1189032','1189464','1287760','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625483','1625484','1625486','1626494','1626495','1626496','1626497','1627685','1627687','1627688','1630386','1634890','1634891','1634892','1634893','1634894','1646777','1646778','1652262','1652266','1652267','1652268','1652270','1652271','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1667948','1667950','1667951','1667952','1667954','1667955','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698222','1698224','1698225','1698228','1698229','1698231','1698232','1698233','1698235','1698236','1721494','1721495','1721496','1721497','1721499','1721500','1721501','1721506','1721508','1721509','1755051','1755052','1755053','1755054','1755055','1755057','1755058','1755059','1781148','1781150','1781151','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1802248','1802250','1802251','1802252','1813657','1813658','1813659','1813660','1813661','1813674','1824109','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833336','1833338','1833341','1833342','1833343','1833345','1833347','1841509','1847210','1847211','389030','520485','723864','1189234','1189311','1626134','1659914','1674254','1699618','1820168','1844321') ORDER BY `g`.`sales_count` DESC LIMIT 0,18"
^ "SELECT `b`.`id`,`b`.`name`,`b`.`logo` FROM `brg_brand` `b` INNER JOIN `brg_goods` `g` ON `g`.`brand_id`=`b`.`id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND ( `g`.`model_base` LIKE '6205%' AND `b`.`is_enable` = '1' ) AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='6205' ) GROUP BY `g`.`brand_id` ORDER BY b.sort asc"
^ "SELECT DISTINCT(gct.name),gct.id FROM `brg_goods` `g` INNER JOIN `brg_goods_category` `gct` ON `g`.`shop_category_id`=`gct`.`id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('390716','720073','1781151','1781150','1802250','1793226','776902','633355','390719','801725','390720','1824119','385905','388453','387174','389475','387173','584564','389030','798480','107112','790209','516700','1135065','1287760','1135048','799553','1624741','1625486','107113','798462','1472937','352128','1135073','1107936','946148','982382','1627688','1652271','805236','352129','1652270','1634894','352127','1135072','107098','107099','604219','475645','752847','107097','749314','475650','749313','522898','693377','1755059','352124','695816','798481','523080','1781156','1781155','625491','1626134','349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864','470928','470931','1833338','1793224','1793223','744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954','431398','427092','427089','417915','634762','1802252','521963','1802251','1755053','1755052','631473','652973','1813658','522057','634689','521999','1847210','1813674','1833345','1824118','640072','1813660','693847','544609','1824122','500183','494529','494528','1721506','1698233','495527','498123','484673','1824121','1824120','1841509','560937','481828','483138','610199','1824125','521680','1847211','1833343','1824126','1833342','1833341','1824117','1824116','1833347','1824112','520485','1698232','1824111','1813661','519694','1813659','1813657','519573','519425','754433','1699618','1674254','1820168','1189464','1189311','1189234','1621068','1621109','1624739','1824109','1634893','1626497','1793230','1833336','1755051','1667954','1802248','1824124','1793232','1844321','1698236') AND `g`.`id` IN ('107097','107098','107099','107112','107113','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','352124','352127','352128','352129','385905','387173','387174','388453','389475','390716','390719','390720','417915','427089','427092','431398','458744','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','498123','500183','516700','519425','519573','519694','521680','521963','521999','522057','522898','523080','525664','525732','525733','526009','537812','539429','544609','551767','551976','552032','552099','552445','558627','560937','565216','565318','565378','583929','584564','603469','604219','606604','610199','618483','618485','619574','619581','619593','625491','630370','630822','631473','632165','632940','633355','634463','634467','634469','634471','634689','634762','640072','641060','644250','648517','648570','652973','654144','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','716542','717996','718057','718451','720073','720743','723776','723798','723799','726667','736223','739927','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','776902','790209','790568','797113','798462','798480','798481','799553','801725','803049','805236','805847','807552','807565','807623','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1106735','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1189032','1189464','1287760','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625483','1625484','1625486','1626494','1626495','1626496','1626497','1627685','1627687','1627688','1630386','1634890','1634891','1634892','1634893','1634894','1646777','1646778','1652262','1652266','1652267','1652268','1652270','1652271','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1667948','1667950','1667951','1667952','1667954','1667955','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698222','1698224','1698225','1698228','1698229','1698231','1698232','1698233','1698235','1698236','1721494','1721495','1721496','1721497','1721499','1721500','1721501','1721506','1721508','1721509','1755051','1755052','1755053','1755054','1755055','1755057','1755058','1755059','1781148','1781150','1781151','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1802248','1802250','1802251','1802252','1813657','1813658','1813659','1813660','1813661','1813674','1824109','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833336','1833338','1833341','1833342','1833343','1833345','1833347','1841509','1847210','1847211','389030','520485','723864','1189234','1189311','1626134','1659914','1674254','1699618','1820168','1844321') ORDER BY gct.id asc"
^ "SELECT DISTINCT(gptc.name),gptc.value,Length(gptc.name) as namelen FROM `brg_goods` `g` INNER JOIN `brg_goods_params_template_config` `gptc` ON `g`.`brand_id`=`gptc`.`brand_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('390716','720073','1781151','1781150','1802250','1793226','776902','633355','390719','801725','390720','1824119','385905','388453','387174','389475','387173','584564','389030','798480','107112','790209','516700','1135065','1287760','1135048','799553','1624741','1625486','107113','798462','1472937','352128','1135073','1107936','946148','982382','1627688','1652271','805236','352129','1652270','1634894','352127','1135072','107098','107099','604219','475645','752847','107097','749314','475650','749313','522898','693377','1755059','352124','695816','798481','523080','1781156','1781155','625491','1626134','349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864','470928','470931','1833338','1793224','1793223','744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954','431398','427092','427089','417915','634762','1802252','521963','1802251','1755053','1755052','631473','652973','1813658','522057','634689','521999','1847210','1813674','1833345','1824118','640072','1813660','693847','544609','1824122','500183','494529','494528','1721506','1698233','495527','498123','484673','1824121','1824120','1841509','560937','481828','483138','610199','1824125','521680','1847211','1833343','1824126','1833342','1833341','1824117','1824116','1833347','1824112','520485','1698232','1824111','1813661','519694','1813659','1813657','519573','519425','754433','1699618','1674254','1820168','1189464','1189311','1189234','1621068','1621109','1624739','1824109','1634893','1626497','1793230','1833336','1755051','1667954','1802248','1824124','1793232','1844321','1698236') AND `g`.`id` IN ('107097','107098','107099','107112','107113','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','352124','352127','352128','352129','385905','387173','387174','388453','389475','390716','390719','390720','417915','427089','427092','431398','458744','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','498123','500183','516700','519425','519573','519694','521680','521963','521999','522057','522898','523080','525664','525732','525733','526009','537812','539429','544609','551767','551976','552032','552099','552445','558627','560937','565216','565318','565378','583929','584564','603469','604219','606604','610199','618483','618485','619574','619581','619593','625491','630370','630822','631473','632165','632940','633355','634463','634467','634469','634471','634689','634762','640072','641060','644250','648517','648570','652973','654144','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','716542','717996','718057','718451','720073','720743','723776','723798','723799','726667','736223','739927','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','776902','790209','790568','797113','798462','798480','798481','799553','801725','803049','805236','805847','807552','807565','807623','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1106735','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1189032','1189464','1287760','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625483','1625484','1625486','1626494','1626495','1626496','1626497','1627685','1627687','1627688','1630386','1634890','1634891','1634892','1634893','1634894','1646777','1646778','1652262','1652266','1652267','1652268','1652270','1652271','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1667948','1667950','1667951','1667952','1667954','1667955','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698222','1698224','1698225','1698228','1698229','1698231','1698232','1698233','1698235','1698236','1721494','1721495','1721496','1721497','1721499','1721500','1721501','1721506','1721508','1721509','1755051','1755052','1755053','1755054','1755055','1755057','1755058','1755059','1781148','1781150','1781151','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1802248','1802250','1802251','1802252','1813657','1813658','1813659','1813660','1813661','1813674','1824109','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833336','1833338','1833341','1833342','1833343','1833345','1833347','1841509','1847210','1847211','389030','520485','723864','1189234','1189311','1626134','1659914','1674254','1699618','1820168','1844321') AND ( g.suffix LIKE concat('%', gptc.NAME, '%') and Length(gptc.name)>1 ) ORDER BY namelen asc"
^ "SELECT gsb.region as value,count(gsb.region) as count FROM `brg_goods_region` `gr` INNER JOIN `brg_goods_spec_base` `gsb` ON `gr`.`name`=`gsb`.`region` INNER JOIN `brg_goods` `g` ON `g`.`id`=`gsb`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`id` IN ('390716','720073','1781151','1781150','1802250','1793226','776902','633355','390719','801725','390720','1824119','385905','388453','387174','389475','387173','584564','389030','798480','107112','790209','516700','1135065','1287760','1135048','799553','1624741','1625486','107113','798462','1472937','352128','1135073','1107936','946148','982382','1627688','1652271','805236','352129','1652270','1634894','352127','1135072','107098','107099','604219','475645','752847','107097','749314','475650','749313','522898','693377','1755059','352124','695816','798481','523080','1781156','1781155','625491','1626134','349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864','470928','470931','1833338','1793224','1793223','744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954','431398','427092','427089','417915','634762','1802252','521963','1802251','1755053','1755052','631473','652973','1813658','522057','634689','521999','1847210','1813674','1833345','1824118','640072','1813660','693847','544609','1824122','500183','494529','494528','1721506','1698233','495527','498123','484673','1824121','1824120','1841509','560937','481828','483138','610199','1824125','521680','1847211','1833343','1824126','1833342','1833341','1824117','1824116','1833347','1824112','520485','1698232','1824111','1813661','519694','1813659','1813657','519573','519425','754433','1699618','1674254','1820168','1189464','1189311','1189234','1621068','1621109','1624739','1824109','1634893','1626497','1793230','1833336','1755051','1667954','1802248','1824124','1793232','1844321','1698236') AND ( `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
筛选出 400 条数据