^ 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:161 [
        0 => "720073"
        1 => "390719"
        2 => "387174"
        3 => "625721"
        4 => "1793233"
        5 => "1721511"
        6 => "107114"
        7 => "1135048"
        8 => "107113"
        9 => "1135073"
        10 => "1107936"
        11 => "1626498"
        12 => "1634895"
        13 => "805236"
        14 => "1793234"
        15 => "1135085"
        16 => "1135072"
        17 => "604219"
        18 => "475645"
        19 => "107097"
        20 => "475650"
        21 => "1175011"
        22 => "522897"
        23 => "780146"
        24 => "625491"
        25 => "777787"
        26 => "349296"
        27 => "349300"
        28 => "606604"
        29 => "712179"
        30 => "343019"
        31 => "343007"
        32 => "343008"
        33 => "605686"
        34 => "618485"
        35 => "693246"
        36 => "343013"
        37 => "601141"
        38 => "343014"
        39 => "345966"
        40 => "349302"
        41 => "552612"
        42 => "345953"
        43 => "615590"
        44 => "345957"
        45 => "345958"
        46 => "630822"
        47 => "715886"
        48 => "849271"
        49 => "345961"
        50 => "1667949"
        51 => "618706"
        52 => "345965"
        53 => "1768784"
        54 => "468912"
        55 => "466348"
        56 => "802606"
        57 => "1735922"
        58 => "555324"
        59 => "233510"
        60 => "625040"
        61 => "233517"
        62 => "552099"
        63 => "1793228"
        64 => "233524"
        65 => "797113"
        66 => "1625485"
        67 => "224974"
        68 => "744560"
        69 => "553157"
        70 => "1112465"
        71 => "226592"
        72 => "1656005"
        73 => "1656004"
        74 => "723535"
        75 => "1072368"
        76 => "226602"
        77 => "226596"
        78 => "696826"
        79 => "558395"
        80 => "551976"
        81 => "1677256"
        82 => "1660961"
        83 => "1721507"
        84 => "226606"
        85 => "226607"
        86 => "539454"
        87 => "226610"
        88 => "740113"
        89 => "1652265"
        90 => "634463"
        91 => "719778"
        92 => "1667956"
        93 => "632940"
        94 => "233512"
        95 => "230311"
        96 => "1626494"
        97 => "227660"
        98 => "1107769"
        99 => "230034"
        100 => "230035"
        101 => "230036"
        102 => "1698224"
        103 => "1667952"
        104 => "230040"
        105 => "230038"
        106 => "1833340"
        107 => "227713"
        108 => "625282"
        109 => "537812"
        110 => "1677252"
        111 => "1660959"
        112 => "1660958"
        113 => "1677253"
        114 => "1072794"
        115 => "539429"
        116 => "229290"
        117 => "229291"
        118 => "229283"
        119 => "902915"
        120 => "229285"
        121 => "539488"
        122 => "552032"
        123 => "1667950"
        124 => "1698218"
        125 => "1479348"
        126 => "1755050"
        127 => "998551"
        128 => "229302"
        129 => "229304"
        130 => "632165"
        131 => "903886"
        132 => "759739"
        133 => "229296"
        134 => "229306"
        135 => "229305"
        136 => "229307"
        137 => "1667948"
        138 => "229311"
        139 => "229312"
        140 => "1625482"
        141 => "431398"
        142 => "1833337"
        143 => "1802249"
        144 => "417915"
        145 => "1755053"
        146 => "631473"
        147 => "521999"
        148 => "1847210"
        149 => "1833335"
        150 => "1813663"
        151 => "1802253"
        152 => "1755056"
        153 => "1781149"
        154 => "1824112"
        155 => "520485"
        156 => "1674255"
        157 => "1833339"
        158 => "519694"
        159 => "519425"
        160 => "754433"
      ]
    ]
  ]
  "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`.`id` IN ('720073','390719','387174','625721','1793233','1721511','107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787','349296','349300','606604','712179','343019','343007','343008','605686','618485','693246','343013','601141','343014','345966','349302','552612','345953','615590','345957','345958','630822','715886','849271','345961','1667949','618706','345965','1768784','468912','466348','802606','1735922','555324','233510','625040','233517','552099','1793228','233524','797113','1625485','224974','744560','553157','1112465','226592','1656005','1656004','723535','1072368','226602','226596','696826','558395','551976','1677256','1660961','1721507','226606','226607','539454','226610','740113','1652265','634463','719778','1667956','632940','233512','230311','1626494','227660','1107769','230034','230035','230036','1698224','1667952','230040','230038','1833340','227713','625282','537812','1677252','1660959','1660958','1677253','1072794','539429','229290','229291','229283','902915','229285','539488','552032','1667950','1698218','1479348','1755050','998551','229302','229304','632165','903886','759739','229296','229306','229305','229307','1667948','229311','229312','1625482','431398','1833337','1802249','417915','1755053','631473','521999','1847210','1833335','1813663','1802253','1755056','1781149','1824112','520485','1674255','1833339','519694','519425','754433')  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 ('720073','390719','387174','625721','1793233','1721511','107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787','349296','349300','606604','712179','343019','343007','343008','605686','618485','693246','343013','601141','343014','345966','349302','552612','345953','615590','345957','345958','630822','715886','849271','345961','1667949','618706','345965','1768784','468912','466348','802606','1735922','555324','233510','625040','233517','552099','1793228','233524','797113','1625485','224974','744560','553157','1112465','226592','1656005','1656004','723535','1072368','226602','226596','696826','558395','551976','1677256','1660961','1721507','226606','226607','539454','226610','740113','1652265','634463','719778','1667956','632940','233512','230311','1626494','227660','1107769','230034','230035','230036','1698224','1667952','230040','230038','1833340','227713','625282','537812','1677252','1660959','1660958','1677253','1072794','539429','229290','229291','229283','902915','229285','539488','552032','1667950','1698218','1479348','1755050','998551','229302','229304','632165','903886','759739','229296','229306','229305','229307','1667948','229311','229312','1625482','431398','1833337','1802249','417915','1755053','631473','521999','1847210','1833335','1813663','1802253','1755056','1781149','1824112','520485','1674255','1833339','519694','519425','754433')  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','224974','226592','226596','226602','226606','226607','226610','227660','227713','229283','229285','229290','229291','229296','229302','229304','229305','229306','229307','229311','229312','230034','230035','230036','230038','230040','230311','233510','233512','233517','233524','343007','343008','343013','343014','343019','345953','345957','345958','345961','345965','345966','349296','349300','349302','387174','390719','417915','431398','466348','468912','475645','475650','519425','519694','521999','522897','537812','539429','539454','539488','551976','552032','552099','552612','553157','558395','601141','604219','605686','606604','615590','618485','618706','625040','625282','625491','625721','630822','631473','632165','632940','634463','693246','696826','712179','715886','719778','720073','723535','740113','744560','754433','759739','777787','780146','797113','802606','805236','849271','902915','903886','998551','1072368','1072794','1107769','1107936','1112465','1135048','1135072','1135073','1135085','1175011','1479348','1625482','1625485','1626494','1626498','1634895','1652265','1656004','1656005','1660958','1660959','1660961','1667948','1667949','1667950','1667952','1667956','1677252','1677253','1677256','1698218','1698224','1721507','1721511','1755050','1755053','1755056','1781149','1793228','1793233','1793234','1802249','1802253','1813663','1824112','1833335','1833337','1833339','1833340','1847210','520485','555324','1674255','1735922','1768784') 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.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 ('720073','390719','387174','625721','1793233','1721511','107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787','349296','349300','606604','712179','343019','343007','343008','605686','618485','693246','343013','601141','343014','345966','349302','552612','345953','615590','345957','345958','630822','715886','849271','345961','1667949','618706','345965','1768784','468912','466348','802606','1735922','555324','233510','625040','233517','552099','1793228','233524','797113','1625485','224974','744560','553157','1112465','226592','1656005','1656004','723535','1072368','226602','226596','696826','558395','551976','1677256','1660961','1721507','226606','226607','539454','226610','740113','1652265','634463','719778','1667956','632940','233512','230311','1626494','227660','1107769','230034','230035','230036','1698224','1667952','230040','230038','1833340','227713','625282','537812','1677252','1660959','1660958','1677253','1072794','539429','229290','229291','229283','902915','229285','539488','552032','1667950','1698218','1479348','1755050','998551','229302','229304','632165','903886','759739','229296','229306','229305','229307','1667948','229311','229312','1625482','431398','1833337','1802249','417915','1755053','631473','521999','1847210','1833335','1813663','1802253','1755056','1781149','1824112','520485','1674255','1833339','519694','519425','754433')  AND `g`.`id` IN ('107097','107113','107114','224974','226592','226596','226602','226606','226607','226610','227660','227713','229283','229285','229290','229291','229296','229302','229304','229305','229306','229307','229311','229312','230034','230035','230036','230038','230040','230311','233510','233512','233517','233524','343007','343008','343013','343014','343019','345953','345957','345958','345961','345965','345966','349296','349300','349302','387174','390719','417915','431398','466348','468912','475645','475650','519425','519694','521999','522897','537812','539429','539454','539488','551976','552032','552099','552612','553157','558395','601141','604219','605686','606604','615590','618485','618706','625040','625282','625491','625721','630822','631473','632165','632940','634463','693246','696826','712179','715886','719778','720073','723535','740113','744560','754433','759739','777787','780146','797113','802606','805236','849271','902915','903886','998551','1072368','1072794','1107769','1107936','1112465','1135048','1135072','1135073','1135085','1175011','1479348','1625482','1625485','1626494','1626498','1634895','1652265','1656004','1656005','1660958','1660959','1660961','1667948','1667949','1667950','1667952','1667956','1677252','1677253','1677256','1698218','1698224','1721507','1721511','1755050','1755053','1755056','1781149','1793228','1793233','1793234','1802249','1802253','1813663','1824112','1833335','1833337','1833339','1833340','1847210','520485','555324','1674255','1735922','1768784') 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 ('720073','390719','387174','625721','1793233','1721511','107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787','349296','349300','606604','712179','343019','343007','343008','605686','618485','693246','343013','601141','343014','345966','349302','552612','345953','615590','345957','345958','630822','715886','849271','345961','1667949','618706','345965','1768784','468912','466348','802606','1735922','555324','233510','625040','233517','552099','1793228','233524','797113','1625485','224974','744560','553157','1112465','226592','1656005','1656004','723535','1072368','226602','226596','696826','558395','551976','1677256','1660961','1721507','226606','226607','539454','226610','740113','1652265','634463','719778','1667956','632940','233512','230311','1626494','227660','1107769','230034','230035','230036','1698224','1667952','230040','230038','1833340','227713','625282','537812','1677252','1660959','1660958','1677253','1072794','539429','229290','229291','229283','902915','229285','539488','552032','1667950','1698218','1479348','1755050','998551','229302','229304','632165','903886','759739','229296','229306','229305','229307','1667948','229311','229312','1625482','431398','1833337','1802249','417915','1755053','631473','521999','1847210','1833335','1813663','1802253','1755056','1781149','1824112','520485','1674255','1833339','519694','519425','754433')  AND `g`.`id` IN ('107097','107113','107114','224974','226592','226596','226602','226606','226607','226610','227660','227713','229283','229285','229290','229291','229296','229302','229304','229305','229306','229307','229311','229312','230034','230035','230036','230038','230040','230311','233510','233512','233517','233524','343007','343008','343013','343014','343019','345953','345957','345958','345961','345965','345966','349296','349300','349302','387174','390719','417915','431398','466348','468912','475645','475650','519425','519694','521999','522897','537812','539429','539454','539488','551976','552032','552099','552612','553157','558395','601141','604219','605686','606604','615590','618485','618706','625040','625282','625491','625721','630822','631473','632165','632940','634463','693246','696826','712179','715886','719778','720073','723535','740113','744560','754433','759739','777787','780146','797113','802606','805236','849271','902915','903886','998551','1072368','1072794','1107769','1107936','1112465','1135048','1135072','1135073','1135085','1175011','1479348','1625482','1625485','1626494','1626498','1634895','1652265','1656004','1656005','1660958','1660959','1660961','1667948','1667949','1667950','1667952','1667956','1677252','1677253','1677256','1698218','1698224','1721507','1721511','1755050','1755053','1755056','1781149','1793228','1793233','1793234','1802249','1802253','1813663','1824112','1833335','1833337','1833339','1833340','1847210','520485','555324','1674255','1735922','1768784')  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 ('720073','390719','387174','625721','1793233','1721511','107114','1135048','107113','1135073','1107936','1626498','1634895','805236','1793234','1135085','1135072','604219','475645','107097','475650','1175011','522897','780146','625491','777787','349296','349300','606604','712179','343019','343007','343008','605686','618485','693246','343013','601141','343014','345966','349302','552612','345953','615590','345957','345958','630822','715886','849271','345961','1667949','618706','345965','1768784','468912','466348','802606','1735922','555324','233510','625040','233517','552099','1793228','233524','797113','1625485','224974','744560','553157','1112465','226592','1656005','1656004','723535','1072368','226602','226596','696826','558395','551976','1677256','1660961','1721507','226606','226607','539454','226610','740113','1652265','634463','719778','1667956','632940','233512','230311','1626494','227660','1107769','230034','230035','230036','1698224','1667952','230040','230038','1833340','227713','625282','537812','1677252','1660959','1660958','1677253','1072794','539429','229290','229291','229283','902915','229285','539488','552032','1667950','1698218','1479348','1755050','998551','229302','229304','632165','903886','759739','229296','229306','229305','229307','1667948','229311','229312','1625482','431398','1833337','1802249','417915','1755053','631473','521999','1847210','1833335','1813663','1802253','1755056','1781149','1824112','520485','1674255','1833339','519694','519425','754433')  AND (  `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
6205 - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类

筛选出 161 条数据

  • 1
  • 2
  • 3
  • 4
  • 5
    • 每页条跳转到页
    共 161 条数据共 9 页

物流信息

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