^ array:9 [
  "base" => array:3 [
    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
    ]
  ]
  "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" => "LOCATE('2', g.model_base)>0"
  "screening_price" => []
  "order_by" => "goodslen asc,g.min_price asc,b.sort asc,g.access_count desc, g.sales_count desc, g.id 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`.`model_base` LIKE '6205%' )  AND ( LOCATE('2', g.model_base)>0 )  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`.`spec_desc` LIKE '5026|%' )  AND ( LOCATE('2', g.model_base)>0 )  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','107109','107112','107113','107114','224974','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227713','227840','227993','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343014','343015','343019','345953','345954','345955','345957','345958','345959','345961','345962','345965','345966','349296','349298','349299','349300','349302','351739','352124','352127','352128','352129','353085','384693','385905','387173','387174','388453','389475','389477','390716','390719','390720','417915','427089','427092','431398','458744','466348','468912','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','496872','498123','500183','516700','516701','519425','519573','519694','521680','521963','521999','522057','522085','522897','522898','523080','525664','525732','525733','526009','537812','539429','539454','539488','544609','551767','551822','551976','552032','552099','552445','552612','553157','558395','558627','560937','565216','565318','565378','583929','584564','601141','603469','604037','604219','605686','605732','606604','610199','615590','618483','618485','618706','618707','619574','619581','619593','625040','625282','625490','625491','625721','630370','630822','631473','632165','632940','633256','633270','633355','634463','634467','634469','634471','634689','634692','634762','634970','640072','641060','644250','647089','648517','648570','649314','652973','654144','688184','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','715886','716542','717996','718057','718451','719778','720073','720743','723535','723776','723798','723799','726667','736223','739927','740113','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','762109','765244','766410','768554','769971','776902','777787','780146','790209','790568','797113','798462','798480','798481','799553','801725','802606','803049','805236','805847','807552','807565','807623','812520','812521','812522','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1078785','1106735','1107769','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1135085','1175011','1189032','1189464','1287760','1303575','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625482','1625483','1625484','1625485','1625486','1626494','1626495','1626496','1626497','1626498','1627685','1627686','1627687','1627688','1630386','1630387','1634889','1634890','1634891','1634892','1634893','1634894','1634895','1646776','1646777','1646778','1646780','1652262','1652263','1652265','1652266','1652267','1652268','1652270','1652271','1652272','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1656006','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1660963','1667948','1667949','1667950','1667951','1667952','1667954','1667955','1667956','1667957','1667958','1667959','1667963','1677249','1677250','1677251','1677252','1677253','1677254','1677255','1677256','1677257','1698217','1698218','1698219','1698220','1698221','1698222','1698223','1698224','1698225','1698226','1698227','1698228','1698229','1698230','1698231','1698232','1698233','1698234','1698235','1698236','1698240','1698241','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721506','1721507','1721508','1721509','1721510','1721511','1755050','1755051','1755052','1755053','1755054','1755055','1755056','1755057','1755058','1755059','1755060','1755069','1781147','1781148','1781149','1781150','1781151','1781153','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1793233','1793234','1802248','1802249','1802250','1802251','1802252','1802253','1802254','1802255','1802256','1802257','1802258','1802259','1802265','1813657','1813658','1813659','1813660','1813661','1813663','1813664','1813667','1813674','1824109','1824110','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833335','1833336','1833337','1833338','1833339','1833340','1833341','1833342','1833343','1833344','1833345','1833346','1833347','1841509','1847210','1847211','1847212','107095','107108','107110','351951','352131','352381','353081','353082','353083','376558','377084','379317','379318','379319','381059','384949','385891','385892','385893','385894','385895','385897','385899','385900','385903','388440','388442','388444','388446','388449','389030','393104','415814','424300','470926','479416','480514','481829','512668','513618','520409','520485','521013','521091','521326','524504','524907','524940','527228','527554','527555','527612','532721','533720','536933','536944','541419','553041','555198','555324','555559','559889','560133','560134','572148','573129','578572','584532','588353','601629','609944','610069','610574','610575','610626','610627','610628','625436','625671','625691','626714','645170','646995','652610','652858','688202','694569','708750','710976','712180','722760','723864','749455','753992','770838','779757','783602','798885','804420','809437','848501','921094','981868','982942','996652','1106782','1112304','1189198','1189234','1189272','1189311','1189383','1190351','1298966','1338717','1626134','1630388','1630389','1641794','1646779','1646781','1652273','1652274','1654898','1659914','1660964','1660965','1660966','1667961','1667962','1674254','1674255','1677258','1696678','1698237','1698238','1698239','1699618','1707277','1721512','1721513','1721514','1721515','1721516','1721517','1721518','1728629','1735730','1735922','1736337','1755061','1755062','1755063','1755064','1755065','1755066','1755067','1755068','1756903','1768784','1781154','1781157','1781158','1781159','1781160','1781161','1781162','1781163','1781164','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793231','1793235','1793236','1793237','1793238','1793239','1793240','1793241','1793242','1793243','1797970','1800270','1802260','1802261','1802262','1802263','1802264','1802899','1813666','1813668','1813669','1813670','1813671','1813672','1815382','1815383','1815384','1820168','1822883','1824123','1824127','1824128','1844321') ORDER BY `goodslen` ASC,`g`.`min_price` ASC,`b`.`sort` ASC,`g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` 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 ( LOCATE('2', g.model_base)>0 )  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 ('107097','107098','107099','107109','107112','107113','107114','224974','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227713','227840','227993','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343014','343015','343019','345953','345954','345955','345957','345958','345959','345961','345962','345965','345966','349296','349298','349299','349300','349302','351739','352124','352127','352128','352129','353085','384693','385905','387173','387174','388453','389475','389477','390716','390719','390720','417915','427089','427092','431398','458744','466348','468912','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','496872','498123','500183','516700','516701','519425','519573','519694','521680','521963','521999','522057','522085','522897','522898','523080','525664','525732','525733','526009','537812','539429','539454','539488','544609','551767','551822','551976','552032','552099','552445','552612','553157','558395','558627','560937','565216','565318','565378','583929','584564','601141','603469','604037','604219','605686','605732','606604','610199','615590','618483','618485','618706','618707','619574','619581','619593','625040','625282','625490','625491','625721','630370','630822','631473','632165','632940','633256','633270','633355','634463','634467','634469','634471','634689','634692','634762','634970','640072','641060','644250','647089','648517','648570','649314','652973','654144','688184','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','715886','716542','717996','718057','718451','719778','720073','720743','723535','723776','723798','723799','726667','736223','739927','740113','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','762109','765244','766410','768554','769971','776902','777787','780146','790209','790568','797113','798462','798480','798481','799553','801725','802606','803049','805236','805847','807552','807565','807623','812520','812521','812522','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1078785','1106735','1107769','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1135085','1175011','1189032','1189464','1287760','1303575','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625482','1625483','1625484','1625485','1625486','1626494','1626495','1626496','1626497','1626498','1627685','1627686','1627687','1627688','1630386','1630387','1634889','1634890','1634891','1634892','1634893','1634894','1634895','1646776','1646777','1646778','1646780','1652262','1652263','1652265','1652266','1652267','1652268','1652270','1652271','1652272','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1656006','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1660963','1667948','1667949','1667950','1667951','1667952','1667954','1667955','1667956','1667957','1667958','1667959','1667963','1677249','1677250','1677251','1677252','1677253','1677254','1677255','1677256','1677257','1698217','1698218','1698219','1698220','1698221','1698222','1698223','1698224','1698225','1698226','1698227','1698228','1698229','1698230','1698231','1698232','1698233','1698234','1698235','1698236','1698240','1698241','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721506','1721507','1721508','1721509','1721510','1721511','1755050','1755051','1755052','1755053','1755054','1755055','1755056','1755057','1755058','1755059','1755060','1755069','1781147','1781148','1781149','1781150','1781151','1781153','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1793233','1793234','1802248','1802249','1802250','1802251','1802252','1802253','1802254','1802255','1802256','1802257','1802258','1802259','1802265','1813657','1813658','1813659','1813660','1813661','1813663','1813664','1813667','1813674','1824109','1824110','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833335','1833336','1833337','1833338','1833339','1833340','1833341','1833342','1833343','1833344','1833345','1833346','1833347','1841509','1847210','1847211','1847212','107095','107108','107110','351951','352131','352381','353081','353082','353083','376558','377084','379317','379318','379319','381059','384949','385891','385892','385893','385894','385895','385897','385899','385900','385903','388440','388442','388444','388446','388449','389030','393104','415814','424300','470926','479416','480514','481829','512668','513618','520409','520485','521013','521091','521326','524504','524907','524940','527228','527554','527555','527612','532721','533720','536933','536944','541419','553041','555198','555324','555559','559889','560133','560134','572148','573129','578572','584532','588353','601629','609944','610069','610574','610575','610626','610627','610628','625436','625671','625691','626714','645170','646995','652610','652858','688202','694569','708750','710976','712180','722760','723864','749455','753992','770838','779757','783602','798885','804420','809437','848501','921094','981868','982942','996652','1106782','1112304','1189198','1189234','1189272','1189311','1189383','1190351','1298966','1338717','1626134','1630388','1630389','1641794','1646779','1646781','1652273','1652274','1654898','1659914','1660964','1660965','1660966','1667961','1667962','1674254','1674255','1677258','1696678','1698237','1698238','1698239','1699618','1707277','1721512','1721513','1721514','1721515','1721516','1721517','1721518','1728629','1735730','1735922','1736337','1755061','1755062','1755063','1755064','1755065','1755066','1755067','1755068','1756903','1768784','1781154','1781157','1781158','1781159','1781160','1781161','1781162','1781163','1781164','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793231','1793235','1793236','1793237','1793238','1793239','1793240','1793241','1793242','1793243','1797970','1800270','1802260','1802261','1802262','1802263','1802264','1802899','1813666','1813668','1813669','1813670','1813671','1813672','1815382','1815383','1815384','1820168','1822883','1824123','1824127','1824128','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 ('107097','107098','107099','107109','107112','107113','107114','224974','226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227713','227840','227993','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','343007','343008','343013','343014','343015','343019','345953','345954','345955','345957','345958','345959','345961','345962','345965','345966','349296','349298','349299','349300','349302','351739','352124','352127','352128','352129','353085','384693','385905','387173','387174','388453','389475','389477','390716','390719','390720','417915','427089','427092','431398','458744','466348','468912','470928','470931','475645','475650','481828','483138','484673','494528','494529','495527','496872','498123','500183','516700','516701','519425','519573','519694','521680','521963','521999','522057','522085','522897','522898','523080','525664','525732','525733','526009','537812','539429','539454','539488','544609','551767','551822','551976','552032','552099','552445','552612','553157','558395','558627','560937','565216','565318','565378','583929','584564','601141','603469','604037','604219','605686','605732','606604','610199','615590','618483','618485','618706','618707','619574','619581','619593','625040','625282','625490','625491','625721','630370','630822','631473','632165','632940','633256','633270','633355','634463','634467','634469','634471','634689','634692','634762','634970','640072','641060','644250','647089','648517','648570','649314','652973','654144','688184','693166','693246','693377','693847','693947','695816','696826','697269','697330','698896','699516','699517','709740','710596','712179','715886','716542','717996','718057','718451','719778','720073','720743','723535','723776','723798','723799','726667','736223','739927','740113','744560','744574','748508','749313','749314','752847','754433','754876','756632','756712','756777','756808','756841','756856','757063','759739','762109','765244','766410','768554','769971','776902','777787','780146','790209','790568','797113','798462','798480','798481','799553','801725','802606','803049','805236','805847','807552','807565','807623','812520','812521','812522','815113','849271','902915','903886','946148','982382','996485','996552','996649','998551','1069929','1072368','1072794','1078785','1106735','1107769','1107936','1112465','1115179','1135048','1135065','1135072','1135073','1135085','1175011','1189032','1189464','1287760','1303575','1472937','1479348','1621068','1621108','1621109','1621744','1622066','1622763','1624332','1624333','1624739','1624740','1624741','1625482','1625483','1625484','1625485','1625486','1626494','1626495','1626496','1626497','1626498','1627685','1627686','1627687','1627688','1630386','1630387','1634889','1634890','1634891','1634892','1634893','1634894','1634895','1646776','1646777','1646778','1646780','1652262','1652263','1652265','1652266','1652267','1652268','1652270','1652271','1652272','1655999','1656000','1656001','1656002','1656003','1656004','1656005','1656006','1660954','1660955','1660956','1660957','1660958','1660959','1660961','1660962','1660963','1667948','1667949','1667950','1667951','1667952','1667954','1667955','1667956','1667957','1667958','1667959','1667963','1677249','1677250','1677251','1677252','1677253','1677254','1677255','1677256','1677257','1698217','1698218','1698219','1698220','1698221','1698222','1698223','1698224','1698225','1698226','1698227','1698228','1698229','1698230','1698231','1698232','1698233','1698234','1698235','1698236','1698240','1698241','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721506','1721507','1721508','1721509','1721510','1721511','1755050','1755051','1755052','1755053','1755054','1755055','1755056','1755057','1755058','1755059','1755060','1755069','1781147','1781148','1781149','1781150','1781151','1781153','1781155','1781156','1793223','1793224','1793226','1793227','1793228','1793230','1793232','1793233','1793234','1802248','1802249','1802250','1802251','1802252','1802253','1802254','1802255','1802256','1802257','1802258','1802259','1802265','1813657','1813658','1813659','1813660','1813661','1813663','1813664','1813667','1813674','1824109','1824110','1824111','1824112','1824116','1824117','1824118','1824119','1824120','1824121','1824122','1824124','1824125','1824126','1833335','1833336','1833337','1833338','1833339','1833340','1833341','1833342','1833343','1833344','1833345','1833346','1833347','1841509','1847210','1847211','1847212','107095','107108','107110','351951','352131','352381','353081','353082','353083','376558','377084','379317','379318','379319','381059','384949','385891','385892','385893','385894','385895','385897','385899','385900','385903','388440','388442','388444','388446','388449','389030','393104','415814','424300','470926','479416','480514','481829','512668','513618','520409','520485','521013','521091','521326','524504','524907','524940','527228','527554','527555','527612','532721','533720','536933','536944','541419','553041','555198','555324','555559','559889','560133','560134','572148','573129','578572','584532','588353','601629','609944','610069','610574','610575','610626','610627','610628','625436','625671','625691','626714','645170','646995','652610','652858','688202','694569','708750','710976','712180','722760','723864','749455','753992','770838','779757','783602','798885','804420','809437','848501','921094','981868','982942','996652','1106782','1112304','1189198','1189234','1189272','1189311','1189383','1190351','1298966','1338717','1626134','1630388','1630389','1641794','1646779','1646781','1652273','1652274','1654898','1659914','1660964','1660965','1660966','1667961','1667962','1674254','1674255','1677258','1696678','1698237','1698238','1698239','1699618','1707277','1721512','1721513','1721514','1721515','1721516','1721517','1721518','1728629','1735730','1735922','1736337','1755061','1755062','1755063','1755064','1755065','1755066','1755067','1755068','1756903','1768784','1781154','1781157','1781158','1781159','1781160','1781161','1781162','1781163','1781164','1781165','1781166','1781167','1781168','1781169','1781170','1781171','1792258','1793231','1793235','1793236','1793237','1793238','1793239','1793240','1793241','1793242','1793243','1797970','1800270','1802260','1802261','1802262','1802263','1802264','1802899','1813666','1813668','1813669','1813670','1813671','1813672','1815382','1815383','1815384','1820168','1822883','1824123','1824127','1824128','1844321')  AND ( g.suffix LIKE concat('%', gptc.NAME, '%') and Length(gptc.name)>1 ) ORDER BY (gptc.name='-2') desc,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`.`model_base` LIKE '6205%' )  AND ( LOCATE('2', g.model_base)>0 ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
6205 - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类

筛选出 721 条数据

  • 1
  • 2
  • 3
  • 4
  • 5
    • 每页条跳转到页
    共 721 条数据共 41 页

物流信息

×
...
在线咨询
温馨提示 ×
商品已成功加入购物车！
购物车共 0 件商品
去购物车结算