^ 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 => 27
      ]
    ]
    4 => array:3 [
      0 => "g.id"
      1 => "in"
      2 => array:182 [
        0 => "744574"
        1 => "233510"
        2 => "233517"
        3 => "558627"
        4 => "1721509"
        5 => "233518"
        6 => "739927"
        7 => "769971"
        8 => "552099"
        9 => "1755057"
        10 => "1793228"
        11 => "1698235"
        12 => "1721508"
        13 => "233520"
        14 => "720743"
        15 => "233524"
        16 => "797113"
        17 => "603469"
        18 => "233529"
        19 => "565216"
        20 => "744560"
        21 => "807552"
        22 => "1112465"
        23 => "226591"
        24 => "226592"
        25 => "226594"
        26 => "630370"
        27 => "1656005"
        28 => "1656004"
        29 => "1634892"
        30 => "1652268"
        31 => "1627687"
        32 => "1072368"
        33 => "736223"
        34 => "226602"
        35 => "226595"
        36 => "226600"
        37 => "226596"
        38 => "756632"
        39 => "226597"
        40 => "565318"
        41 => "696826"
        42 => "226598"
        43 => "815113"
        44 => "996552"
        45 => "551976"
        46 => "1656003"
        47 => "1677256"
        48 => "1652267"
        49 => "1677255"
        50 => "1667959"
        51 => "1667958"
        52 => "1652266"
        53 => "1660962"
        54 => "1660961"
        55 => "1634891"
        56 => "1634890"
        57 => "1667957"
        58 => "1646778"
        59 => "807565"
        60 => "226606"
        61 => "226607"
        62 => "525733"
        63 => "766410"
        64 => "790568"
        65 => "226605"
        66 => "526009"
        67 => "1793227"
        68 => "1646777"
        69 => "226610"
        70 => "634463"
        71 => "634467"
        72 => "634469"
        73 => "634471"
        74 => "632940"
        75 => "1621744"
        76 => "710596"
        77 => "1624740"
        78 => "233512"
        79 => "644250"
        80 => "1755055"
        81 => "227993"
        82 => "230311"
        83 => "583929"
        84 => "697269"
        85 => "1627685"
        86 => "1626495"
        87 => "641060"
        88 => "1626494"
        89 => "227660"
        90 => "756712"
        91 => "1656000"
        92 => "1630386"
        93 => "1698225"
        94 => "996485"
        95 => "648517"
        96 => "648570"
        97 => "565378"
        98 => "765244"
        99 => "230034"
        100 => "230035"
        101 => "619593"
        102 => "230036"
        103 => "693947"
        104 => "805847"
        105 => "756808"
        106 => "716542"
        107 => "1698224"
        108 => "1655999"
        109 => "1667952"
        110 => "525664"
        111 => "230040"
        112 => "756856"
        113 => "230037"
        114 => "654144"
        115 => "230038"
        116 => "803049"
        117 => "757063"
        118 => "709740"
        119 => "693166"
        120 => "718057"
        121 => "1698220"
        122 => "1698221"
        123 => "229281"
        124 => "229282"
        125 => "537812"
        126 => "1677252"
        127 => "1660959"
        128 => "1660958"
        129 => "1698219"
        130 => "726667"
        131 => "996649"
        132 => "229289"
        133 => "1072794"
        134 => "539429"
        135 => "229290"
        136 => "229291"
        137 => "525732"
        138 => "229283"
        139 => "902915"
        140 => "756777"
        141 => "229284"
        142 => "551767"
        143 => "229287"
        144 => "698896"
        145 => "229292"
        146 => "1106735"
        147 => "768554"
        148 => "717996"
        149 => "1721496"
        150 => "1625484"
        151 => "1625483"
        152 => "552032"
        153 => "1677251"
        154 => "1677250"
        155 => "1667950"
        156 => "1652262"
        157 => "1677249"
        158 => "1698217"
        159 => "1479348"
        160 => "998551"
        161 => "807623"
        162 => "229301"
        163 => "229302"
        164 => "229304"
        165 => "229294"
        166 => "632165"
        167 => "903886"
        168 => "756841"
        169 => "759739"
        170 => "229296"
        171 => "229306"
        172 => "229305"
        173 => "619574"
        174 => "229309"
        175 => "229307"
        176 => "619581"
        177 => "1721494"
        178 => "1667948"
        179 => "229311"
        180 => "229312"
        181 => "1660954"
      ]
    ]
  ]
  "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.sales_count 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` = '27'  AND `g`.`id` IN ('744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954')  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` = '27'  AND `g`.`id` IN ('744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954')  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 ('226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','525664','525732','525733','526009','537812','539429','551767','551976','552032','552099','558627','565216','565318','565378','583929','603469','619574','619581','619593','630370','632165','632940','634463','634467','634469','634471','641060','644250','648517','648570','654144','693166','693947','696826','697269','698896','709740','710596','716542','717996','718057','720743','726667','736223','739927','744560','744574','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','790568','797113','803049','805847','807552','807565','807623','815113','902915','903886','996485','996552','996649','998551','1072368','1072794','1106735','1112465','1479348','1621744','1624740','1625483','1625484','1626494','1626495','1627685','1627687','1630386','1634890','1634891','1634892','1646777','1646778','1652262','1652266','1652267','1652268','1655999','1656000','1656003','1656004','1656005','1660954','1660958','1660959','1660961','1660962','1667948','1667950','1667952','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698224','1698225','1698235','1721494','1721496','1721508','1721509','1755055','1755057','1793227','1793228') ORDER BY `g`.`sales_count` 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='27') 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` = '27'  AND `g`.`id` IN ('744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954')  AND `g`.`id` IN ('226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','525664','525732','525733','526009','537812','539429','551767','551976','552032','552099','558627','565216','565318','565378','583929','603469','619574','619581','619593','630370','632165','632940','634463','634467','634469','634471','641060','644250','648517','648570','654144','693166','693947','696826','697269','698896','709740','710596','716542','717996','718057','720743','726667','736223','739927','744560','744574','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','790568','797113','803049','805847','807552','807565','807623','815113','902915','903886','996485','996552','996649','998551','1072368','1072794','1106735','1112465','1479348','1621744','1624740','1625483','1625484','1626494','1626495','1627685','1627687','1630386','1634890','1634891','1634892','1646777','1646778','1652262','1652266','1652267','1652268','1655999','1656000','1656003','1656004','1656005','1660954','1660958','1660959','1660961','1660962','1667948','1667950','1667952','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698224','1698225','1698235','1721494','1721496','1721508','1721509','1755055','1755057','1793227','1793228') 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` = '27'  AND `g`.`id` IN ('744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954')  AND `g`.`id` IN ('226591','226592','226594','226595','226596','226597','226598','226600','226602','226605','226606','226607','226610','227660','227993','229281','229282','229283','229284','229287','229289','229290','229291','229292','229294','229296','229301','229302','229304','229305','229306','229307','229309','229311','229312','230034','230035','230036','230037','230038','230040','230311','233510','233512','233517','233518','233520','233524','233529','525664','525732','525733','526009','537812','539429','551767','551976','552032','552099','558627','565216','565318','565378','583929','603469','619574','619581','619593','630370','632165','632940','634463','634467','634469','634471','641060','644250','648517','648570','654144','693166','693947','696826','697269','698896','709740','710596','716542','717996','718057','720743','726667','736223','739927','744560','744574','756632','756712','756777','756808','756841','756856','757063','759739','765244','766410','768554','769971','790568','797113','803049','805847','807552','807565','807623','815113','902915','903886','996485','996552','996649','998551','1072368','1072794','1106735','1112465','1479348','1621744','1624740','1625483','1625484','1626494','1626495','1627685','1627687','1630386','1634890','1634891','1634892','1646777','1646778','1652262','1652266','1652267','1652268','1655999','1656000','1656003','1656004','1656005','1660954','1660958','1660959','1660961','1660962','1667948','1667950','1667952','1667957','1667958','1667959','1677249','1677250','1677251','1677252','1677255','1677256','1698217','1698219','1698220','1698221','1698224','1698225','1698235','1721494','1721496','1721508','1721509','1755055','1755057','1793227','1793228')  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` = '27'  AND `g`.`id` IN ('744574','233510','233517','558627','1721509','233518','739927','769971','552099','1755057','1793228','1698235','1721508','233520','720743','233524','797113','603469','233529','565216','744560','807552','1112465','226591','226592','226594','630370','1656005','1656004','1634892','1652268','1627687','1072368','736223','226602','226595','226600','226596','756632','226597','565318','696826','226598','815113','996552','551976','1656003','1677256','1652267','1677255','1667959','1667958','1652266','1660962','1660961','1634891','1634890','1667957','1646778','807565','226606','226607','525733','766410','790568','226605','526009','1793227','1646777','226610','634463','634467','634469','634471','632940','1621744','710596','1624740','233512','644250','1755055','227993','230311','583929','697269','1627685','1626495','641060','1626494','227660','756712','1656000','1630386','1698225','996485','648517','648570','565378','765244','230034','230035','619593','230036','693947','805847','756808','716542','1698224','1655999','1667952','525664','230040','756856','230037','654144','230038','803049','757063','709740','693166','718057','1698220','1698221','229281','229282','537812','1677252','1660959','1660958','1698219','726667','996649','229289','1072794','539429','229290','229291','525732','229283','902915','756777','229284','551767','229287','698896','229292','1106735','768554','717996','1721496','1625484','1625483','552032','1677251','1677250','1667950','1652262','1677249','1698217','1479348','998551','807623','229301','229302','229304','229294','632165','903886','756841','759739','229296','229306','229305','619574','229309','229307','619581','1721494','1667948','229311','229312','1660954')  AND (  `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
NSK - 轴承行业的京东 - 贝果轴链 正品包邮
贝果轴链
d mm
D mm
B mm
我的购物车
全部分类
全部分类

筛选出 182 条数据

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

物流信息

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