NAK - 轴承行业的京东 - 贝果轴链正品包邮

^ 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.brand_id"
      1 => "in"
      2 => array:1 [
        0 => 40
      ]
    ]
  ]
  "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('LM', 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`.`brand_id` = '40'  AND (  `g`.`model_base` LIKE '608%' )  AND ( LOCATE('LM', 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`.`brand_id` = '40'  AND (  `g`.`spec_desc` LIKE '806|%' )  AND ( LOCATE('LM', g.model_base)>0 )  AND ( REGEXP_SUBSTR(g.spec_desc, '[0-9]{3,}')='806' ) ORDER BY `g`.`id` ASC"

^ "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('LM', g.model_base)>0 )  AND ( REGEXP_SUBSTR(g.model_base, '[0-9]{3,}')='608' ) GROUP BY `g`.`brand_id` ORDER BY (b.id='40') desc,b.sort asc"