^ array:9 [
  "base" => array:5 [
    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.brand_id"
      1 => "in"
      2 => array:1 [
        0 => 3
      ]
    ]
    4 => array:3 [
      0 => "g.id"
      1 => "in"
      2 => array:20 [
        0 => "107114"
        1 => "1135048"
        2 => "107113"
        3 => "1135073"
        4 => "1107936"
        5 => "1626498"
        6 => "1634895"
        7 => "805236"
        8 => "1793234"
        9 => "1135085"
        10 => "1135072"
        11 => "604219"
        12 => "475645"
        13 => "107097"
        14 => "475650"
        15 => "1175011"
        16 => "522897"
        17 => "780146"
        18 => "625491"
        19 => "777787"
      ]
    ]
  ]
  "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.min_price asc"
  "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`.`brand_id` = '3'  AND `g`.`id` IN ('107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787')  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`.`brand_id` = '3'  AND `g`.`id` IN ('107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787')  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','107113','107114','475645','475650','522897','604219','625491','777787','780146','805236','1107936','1135048','1135072','1135073','1135085','1175011','1626498','1634895','1793234') ORDER BY `g`.`min_price` ASC 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.id='3') desc,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`.`brand_id` = '3'  AND `g`.`id` IN ('107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787')  AND `g`.`id` IN ('107097','107113','107114','475645','475650','522897','604219','625491','777787','780146','805236','1107936','1135048','1135072','1135073','1135085','1175011','1626498','1634895','1793234') 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`.`brand_id` = '3'  AND `g`.`id` IN ('107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787')  AND `g`.`id` IN ('107097','107113','107114','475645','475650','522897','604219','625491','777787','780146','805236','1107936','1135048','1135072','1135073','1135085','1175011','1626498','1634895','1793234')  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`.`brand_id` = '3'  AND `g`.`id` IN ('107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787')  AND (  `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
FAG - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类

筛选出 20 条数据

  • 1
  • 2
    • 每页条跳转到页
    共 20 条数据共 2 页

物流信息

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