^ 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 => "608%"
    ]
  ]
  "keywords_substr" => "REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='608'"
  "fankeywords" => array:1 [
    0 => array:3 [
      0 => "g.spec_desc"
      1 => "like"
      2 => "806|%"
    ]
  ]
  "keywords_fansubstr" => "REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='806'"
  "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 '608%' )  AND ( LOCATE('2', g.model_base)>0 )  AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='608' ) 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 '806|%' )  AND ( LOCATE('2', g.model_base)>0 )  AND ( REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='806' ) 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 ('231962','234996','234998','235002','518690','518695','518696','518699','518701','518703','518706','518709','518710','518716','518717','518718','518772','518778','518780','518782','518784','518785','518786','518788','518790','518795','518800','551649','579230','641373','644325','644978','644997','645008','696840','698913','711211','718035','718039','718098','718104','719240','736307','740146','762310','762313','803053','805102','807788','867448','999013','1068565','1115221','1226461','1286286','1288021','1288340','1624157','1624325','1624891','1625164','1626508','1626512','1626513','1626514','1627697','1627698','1627700','1627701','1627702','1630323','1630325','1646807','1646808','1646809','1646810','1646811','1646812','1646813','1646814','1652297','1652302','1656096','1656097','1656100','1656101','1656103','1660988','1668001','1677136','1698020','1698021','1721565','1793278','1813339','1823658','1823660','111897','352601','352602','353355','355223','376491','377349','382580','386418','387237','387238','387239','389499','389501','389502','427122','480669','481974','483216','520365','520618','531273','532621','602373','620107','620243','715662','715664','727649','799579','799580','809426','921298','1112314','1137952','1182608','1189471','1266506','1296708','1624433','1625147','1626185','1641771','1649892','1653644','1660989','1665499','1665500','1668003','1668004','1677647','1698025','1698026','1698027','1755108','1755109','1755110','1769157','1769318','1781412','1781413','1781979','1786931','1793279','1793280','1793281','1802336','1802337','1802338','1802339','1802916','1806167','1806168','1809463','1810139','1813342','1817783','1820174','1822885','1823662','1823663','1823664','1823665','1823666','1823667','1823668','1829700','1833389','1833390') 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 '608%'  AND `b`.`is_enable` = '1' )  AND ( LOCATE('2', g.model_base)>0 )  AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='608' ) 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 ('231962','234996','234998','235002','518690','518695','518696','518699','518701','518703','518706','518709','518710','518716','518717','518718','518772','518778','518780','518782','518784','518785','518786','518788','518790','518795','518800','551649','579230','641373','644325','644978','644997','645008','696840','698913','711211','718035','718039','718098','718104','719240','736307','740146','762310','762313','803053','805102','807788','867448','999013','1068565','1115221','1226461','1286286','1288021','1288340','1624157','1624325','1624891','1625164','1626508','1626512','1626513','1626514','1627697','1627698','1627700','1627701','1627702','1630323','1630325','1646807','1646808','1646809','1646810','1646811','1646812','1646813','1646814','1652297','1652302','1656096','1656097','1656100','1656101','1656103','1660988','1668001','1677136','1698020','1698021','1721565','1793278','1813339','1823658','1823660','111897','352601','352602','353355','355223','376491','377349','382580','386418','387237','387238','387239','389499','389501','389502','427122','480669','481974','483216','520365','520618','531273','532621','602373','620107','620243','715662','715664','727649','799579','799580','809426','921298','1112314','1137952','1182608','1189471','1266506','1296708','1624433','1625147','1626185','1641771','1649892','1653644','1660989','1665499','1665500','1668003','1668004','1677647','1698025','1698026','1698027','1755108','1755109','1755110','1769157','1769318','1781412','1781413','1781979','1786931','1793279','1793280','1793281','1802336','1802337','1802338','1802339','1802916','1806167','1806168','1809463','1810139','1813342','1817783','1820174','1822885','1823662','1823663','1823664','1823665','1823666','1823667','1823668','1829700','1833389','1833390') 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 ('231962','234996','234998','235002','518690','518695','518696','518699','518701','518703','518706','518709','518710','518716','518717','518718','518772','518778','518780','518782','518784','518785','518786','518788','518790','518795','518800','551649','579230','641373','644325','644978','644997','645008','696840','698913','711211','718035','718039','718098','718104','719240','736307','740146','762310','762313','803053','805102','807788','867448','999013','1068565','1115221','1226461','1286286','1288021','1288340','1624157','1624325','1624891','1625164','1626508','1626512','1626513','1626514','1627697','1627698','1627700','1627701','1627702','1630323','1630325','1646807','1646808','1646809','1646810','1646811','1646812','1646813','1646814','1652297','1652302','1656096','1656097','1656100','1656101','1656103','1660988','1668001','1677136','1698020','1698021','1721565','1793278','1813339','1823658','1823660','111897','352601','352602','353355','355223','376491','377349','382580','386418','387237','387238','387239','389499','389501','389502','427122','480669','481974','483216','520365','520618','531273','532621','602373','620107','620243','715662','715664','727649','799579','799580','809426','921298','1112314','1137952','1182608','1189471','1266506','1296708','1624433','1625147','1626185','1641771','1649892','1653644','1660989','1665499','1665500','1668003','1668004','1677647','1698025','1698026','1698027','1755108','1755109','1755110','1769157','1769318','1781412','1781413','1781979','1786931','1793279','1793280','1793281','1802336','1802337','1802338','1802339','1802916','1806167','1806168','1809463','1810139','1813342','1817783','1820174','1822885','1823662','1823663','1823664','1823665','1823666','1823667','1823668','1829700','1833389','1833390')  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 '608%' )  AND ( LOCATE('2', g.model_base)>0 ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
608 - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类
  • 首页
  • 608 / -2 / 西北搜索结果

筛选出 186 条数据

  • 1
  • 2
  • 3
  • 4
  • 5
    • 每页条跳转到页
    共 186 条数据共 11 页

物流信息

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