^ 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('ZZ', 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('ZZ', 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('ZZ', 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 ('227713','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','233512','345953','345954','345955','345957','345958','345959','345961','345962','345965','417915','427089','458744','466348','519425','519573','519694','521999','522057','525732','537812','539429','539488','551767','551822','552032','565216','584564','604037','605732','615590','618706','618707','619574','619581','625282','625721','630822','631473','632165','634689','634692','640072','641060','644250','652973','693847','697269','697330','698896','699516','699517','715886','717996','726667','744574','749313','749314','754433','754876','756777','756841','759739','768554','802606','807623','849271','902915','903886','996649','998551','1069929','1072794','1078785','1106735','1189032','1189464','1479348','1624740','1625482','1625483','1625484','1625485','1626494','1627685','1646776','1652262','1652263','1660954','1660955','1660956','1660957','1660958','1660959','1667948','1667949','1667950','1667951','1677249','1677250','1677251','1677252','1677253','1698217','1698218','1698219','1698220','1698221','1698222','1698227','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721511','1755050','1781147','1781148','1781149','1793223','1793224','1793230','1793232','1793233','1802248','1802249','1813657','1813658','1813659','1813660','1824112','1824124','1833335','1833336','1833337','520485','560133','723864','749455','1189234','1189311','1659914','1674254','1674255','1735730','1768784','1781159','1781160','1781161','1781162','1820168') 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('ZZ', 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 ('227713','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','233512','345953','345954','345955','345957','345958','345959','345961','345962','345965','417915','427089','458744','466348','519425','519573','519694','521999','522057','525732','537812','539429','539488','551767','551822','552032','565216','584564','604037','605732','615590','618706','618707','619574','619581','625282','625721','630822','631473','632165','634689','634692','640072','641060','644250','652973','693847','697269','697330','698896','699516','699517','715886','717996','726667','744574','749313','749314','754433','754876','756777','756841','759739','768554','802606','807623','849271','902915','903886','996649','998551','1069929','1072794','1078785','1106735','1189032','1189464','1479348','1624740','1625482','1625483','1625484','1625485','1626494','1627685','1646776','1652262','1652263','1660954','1660955','1660956','1660957','1660958','1660959','1667948','1667949','1667950','1667951','1677249','1677250','1677251','1677252','1677253','1698217','1698218','1698219','1698220','1698221','1698222','1698227','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721511','1755050','1781147','1781148','1781149','1793223','1793224','1793230','1793232','1793233','1802248','1802249','1813657','1813658','1813659','1813660','1824112','1824124','1833335','1833336','1833337','520485','560133','723864','749455','1189234','1189311','1659914','1674254','1674255','1735730','1768784','1781159','1781160','1781161','1781162','1820168') 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 ('227713','229281','229282','229283','229284','229285','229287','229289','229290','229291','229292','229294','229296','229301','229302','229303','229304','229305','229306','229307','229309','229311','229312','233512','345953','345954','345955','345957','345958','345959','345961','345962','345965','417915','427089','458744','466348','519425','519573','519694','521999','522057','525732','537812','539429','539488','551767','551822','552032','565216','584564','604037','605732','615590','618706','618707','619574','619581','625282','625721','630822','631473','632165','634689','634692','640072','641060','644250','652973','693847','697269','697330','698896','699516','699517','715886','717996','726667','744574','749313','749314','754433','754876','756777','756841','759739','768554','802606','807623','849271','902915','903886','996649','998551','1069929','1072794','1078785','1106735','1189032','1189464','1479348','1624740','1625482','1625483','1625484','1625485','1626494','1627685','1646776','1652262','1652263','1660954','1660955','1660956','1660957','1660958','1660959','1667948','1667949','1667950','1667951','1677249','1677250','1677251','1677252','1677253','1698217','1698218','1698219','1698220','1698221','1698222','1698227','1721494','1721495','1721496','1721497','1721498','1721499','1721500','1721501','1721502','1721511','1755050','1781147','1781148','1781149','1793223','1793224','1793230','1793232','1793233','1802248','1802249','1813657','1813658','1813659','1813660','1824112','1824124','1833335','1833336','1833337','520485','560133','723864','749455','1189234','1189311','1659914','1674254','1674255','1735730','1768784','1781159','1781160','1781161','1781162','1820168')  AND ( g.suffix LIKE concat('%', gptc.NAME, '%') and Length(gptc.name)>1 ) ORDER BY (gptc.name='ZZ') 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('ZZ', g.model_base)>0 ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
6205 - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类
  • 首页
  • 6205 / ZZ / 华中搜索结果

筛选出 179 条数据

  • 1
  • 2
  • 3
  • 4
  • 5
    • 每页条跳转到页
    共 179 条数据共 10 页

物流信息

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