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

^ 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 => 4 ] ] 4 => array:3 [ 0 => "g.id" 1 => "in" 2 => array:66 [ 0 => "349296" 1 => "723798" 2 => "349298" 3 => "1755058" 4 => "349299" 5 => "349300" 6 => "723776" 7 => "606604" 8 => "1622763" 9 => "1755054" 10 => "1698231" 11 => "712179" 12 => "1624333" 13 => "618483" 14 => "343019" 15 => "1698229" 16 => "1698228" 17 => "343007" 18 => "718451" 19 => "343008" 20 => "552445" 21 => "1626496" 22 => "618485" 23 => "1656002" 24 => "693246" 25 => "1667955" 26 => "1621108" 27 => "343013" 28 => "1656001" 29 => "1624332" 30 => "748508" 31 => "343015" 32 => "1622066" 33 => "1115179" 34 => "723799" 35 => "349302" 36 => "345954" 37 => "1189032" 38 => "345955" 39 => "1698222" 40 => "345957" 41 => "1069929" 42 => "754876" 43 => "1721500" 44 => "345958" 45 => "345959" 46 => "630822" 47 => "1721499" 48 => "458744" 49 => "1721497" 50 => "1660957" 51 => "849271" 52 => "1721495" 53 => "345961" 54 => "1660956" 55 => "345962" 56 => "699516" 57 => "1781148" 58 => "1667951" 59 => "1721501" 60 => "345965" 61 => "1660955" 62 => "699517" 63 => "697330" 64 => "1659914" 65 => "723864" ] ] ] "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` = '4' AND `g`.`id` IN ('349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864') 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` = '4' AND `g`.`id` IN ('349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864') 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 ('343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','458744','552445','606604','618483','618485','630822','693246','697330','699516','699517','712179','718451','723776','723798','723799','748508','754876','849271','1069929','1115179','1189032','1621108','1622066','1622763','1624332','1624333','1626496','1656001','1656002','1660955','1660956','1660957','1667951','1667955','1698222','1698228','1698229','1698231','1721495','1721497','1721499','1721500','1721501','1755054','1755058','1781148','723864','1659914') 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='4') 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` = '4' AND `g`.`id` IN ('349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864') AND `g`.`id` IN ('343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','458744','552445','606604','618483','618485','630822','693246','697330','699516','699517','712179','718451','723776','723798','723799','748508','754876','849271','1069929','1115179','1189032','1621108','1622066','1622763','1624332','1624333','1626496','1656001','1656002','1660955','1660956','1660957','1667951','1667955','1698222','1698228','1698229','1698231','1721495','1721497','1721499','1721500','1721501','1755054','1755058','1781148','723864','1659914') 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` = '4' AND `g`.`id` IN ('349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864') AND `g`.`id` IN ('343007','343008','343013','343015','343019','345954','345955','345957','345958','345959','345961','345962','345965','349296','349298','349299','349300','349302','458744','552445','606604','618483','618485','630822','693246','697330','699516','699517','712179','718451','723776','723798','723799','748508','754876','849271','1069929','1115179','1189032','1621108','1622066','1622763','1624332','1624333','1626496','1656001','1656002','1660955','1660956','1660957','1667951','1667955','1698222','1698228','1698229','1698231','1721495','1721497','1721499','1721500','1721501','1755054','1755058','1781148','723864','1659914') 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` = '4' AND `g`.`id` IN ('349296','723798','349298','1755058','349299','349300','723776','606604','1622763','1755054','1698231','712179','1624333','618483','343019','1698229','1698228','343007','718451','343008','552445','1626496','618485','1656002','693246','1667955','1621108','343013','1656001','1624332','748508','343015','1622066','1115179','723799','349302','345954','1189032','345955','1698222','345957','1069929','754876','1721500','345958','345959','630822','1721499','458744','1721497','1660957','849271','1721495','345961','1660956','345962','699516','1781148','1667951','1721501','345965','1660955','699517','697330','1659914','723864') AND ( `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"