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

^ 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 => 343 ] ] ] "keywords" => [] "keywords_substr" => [] "fankeywords" => [] "keywords_fansubstr" => [] "goods_params" => [] "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 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 ('1298966','1299020','1800083','1800084','1800085','1800086','1800087','1800088','1800089','1800090','1800091','1800092','1806051','1806052','1806053','1806054','1806055','1806056','1806057','1806058','1806059','1806061','1806063','1806064','1806065','1806066','1806067','1806068','1806069','1806070','1806071','1806072','1806073','1806074','1806075','1806090','1806091','1806092','1806093','1806094','1806095','1806096','1806098','1806099','1806100','1806102','1806112','1806113','1806114','1806115','1806116','1806117','1806118','1806119','1806120','1806121','1806122','1806124','1806125','1806126','1806127','1806128','1806130','1806131','1806134','1806135','1806136','1806137','1806138','1806140','1806152','1806153','1806154','1806155','1806157','1806158','1806159','1806160','1806161','1806162','1806163','1806165','1806173','1806174','1806175','1806176','1806178','1806179','1806180','1806181','1806182','1806183','1806185','1806186','1806189','1815263','1815264','1815267','1815268','1815270','1815272','1815274','1815276','1815278','1815280','1815282','1815284','1815286','1815291','1815292','1815295','1815296','1815299','1815300','1815303','1815304','1815307','1815308','1815311','1815312','1815314','1815321','1815322','1815325','1815327','1815328','1815330','1815332','1815335','1815338','1815341','1815344','1815347','1815350','1815358','1815360','1815362','1815364','1815366','1815369','1815371','1815373','1815376','1815381','1815382','1815385','1815388','1815393','1815394','1815398','1815405','1815407','1815409','1815411','1815413','1815415','1815418','1815419','1815422','1815425','1815428','1815431','1815435','1815437','1815440','1815446','1815450','1820141','1820142','1820143','1820144','1820145','1820172','1820174','1820175','1820176','1820177','1820178','1820761','1820762','1820763','1820766','1820767','1820770','1820771','1820773','1820774','1820775','1820776','1820777','1820778','1820779','1820780','1820781','1820782','1820783','1820803','1820804','1820805','1820806','1820807','1820808','1820809','1820810','1820811','1820812','1820813','1820814','1820817','1820818','1820819','1820820','1820821','1820822','1820824','1820825','1820847','1831375','1831376','1831377','1831378','1831379','1831382','1831383','1831386','1831387','1831390','1831391','1831394','1831395','1831398','1831399','1831402','1831403','1831407','1831408','1831411','1831412','1836416','1836417','1836418','1836419','1836420','1836421','1836422','1836425','1836426','1836429','1836430','1836433','1836434','1836437','1836438','1836440') ORDER BY `goodslen` ASC,`g`.`min_price` ASC,`b`.`sort` ASC,`g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` DESC LIMIT 0,18"

^ "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` = '343' AND `g`.`id` IN ('1298966','1299020','1800083','1800084','1800085','1800086','1800087','1800088','1800089','1800090','1800091','1800092','1806051','1806052','1806053','1806054','1806055','1806056','1806057','1806058','1806059','1806061','1806063','1806064','1806065','1806066','1806067','1806068','1806069','1806070','1806071','1806072','1806073','1806074','1806075','1806090','1806091','1806092','1806093','1806094','1806095','1806096','1806098','1806099','1806100','1806102','1806112','1806113','1806114','1806115','1806116','1806117','1806118','1806119','1806120','1806121','1806122','1806124','1806125','1806126','1806127','1806128','1806130','1806131','1806134','1806135','1806136','1806137','1806138','1806140','1806152','1806153','1806154','1806155','1806157','1806158','1806159','1806160','1806161','1806162','1806163','1806165','1806173','1806174','1806175','1806176','1806178','1806179','1806180','1806181','1806182','1806183','1806185','1806186','1806189','1815263','1815264','1815267','1815268','1815270','1815272','1815274','1815276','1815278','1815280','1815282','1815284','1815286','1815291','1815292','1815295','1815296','1815299','1815300','1815303','1815304','1815307','1815308','1815311','1815312','1815314','1815321','1815322','1815325','1815327','1815328','1815330','1815332','1815335','1815338','1815341','1815344','1815347','1815350','1815358','1815360','1815362','1815364','1815366','1815369','1815371','1815373','1815376','1815381','1815382','1815385','1815388','1815393','1815394','1815398','1815405','1815407','1815409','1815411','1815413','1815415','1815418','1815419','1815422','1815425','1815428','1815431','1815435','1815437','1815440','1815446','1815450','1820141','1820142','1820143','1820144','1820145','1820172','1820174','1820175','1820176','1820177','1820178','1820761','1820762','1820763','1820766','1820767','1820770','1820771','1820773','1820774','1820775','1820776','1820777','1820778','1820779','1820780','1820781','1820782','1820783','1820803','1820804','1820805','1820806','1820807','1820808','1820809','1820810','1820811','1820812','1820813','1820814','1820817','1820818','1820819','1820820','1820821','1820822','1820824','1820825','1820847','1831375','1831376','1831377','1831378','1831379','1831382','1831383','1831386','1831387','1831390','1831391','1831394','1831395','1831398','1831399','1831402','1831403','1831407','1831408','1831411','1831412','1836416','1836417','1836418','1836419','1836420','1836421','1836422','1836425','1836426','1836429','1836430','1836433','1836434','1836437','1836438','1836440') 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` = '343' AND `g`.`id` IN ('1298966','1299020','1800083','1800084','1800085','1800086','1800087','1800088','1800089','1800090','1800091','1800092','1806051','1806052','1806053','1806054','1806055','1806056','1806057','1806058','1806059','1806061','1806063','1806064','1806065','1806066','1806067','1806068','1806069','1806070','1806071','1806072','1806073','1806074','1806075','1806090','1806091','1806092','1806093','1806094','1806095','1806096','1806098','1806099','1806100','1806102','1806112','1806113','1806114','1806115','1806116','1806117','1806118','1806119','1806120','1806121','1806122','1806124','1806125','1806126','1806127','1806128','1806130','1806131','1806134','1806135','1806136','1806137','1806138','1806140','1806152','1806153','1806154','1806155','1806157','1806158','1806159','1806160','1806161','1806162','1806163','1806165','1806173','1806174','1806175','1806176','1806178','1806179','1806180','1806181','1806182','1806183','1806185','1806186','1806189','1815263','1815264','1815267','1815268','1815270','1815272','1815274','1815276','1815278','1815280','1815282','1815284','1815286','1815291','1815292','1815295','1815296','1815299','1815300','1815303','1815304','1815307','1815308','1815311','1815312','1815314','1815321','1815322','1815325','1815327','1815328','1815330','1815332','1815335','1815338','1815341','1815344','1815347','1815350','1815358','1815360','1815362','1815364','1815366','1815369','1815371','1815373','1815376','1815381','1815382','1815385','1815388','1815393','1815394','1815398','1815405','1815407','1815409','1815411','1815413','1815415','1815418','1815419','1815422','1815425','1815428','1815431','1815435','1815437','1815440','1815446','1815450','1820141','1820142','1820143','1820144','1820145','1820172','1820174','1820175','1820176','1820177','1820178','1820761','1820762','1820763','1820766','1820767','1820770','1820771','1820773','1820774','1820775','1820776','1820777','1820778','1820779','1820780','1820781','1820782','1820783','1820803','1820804','1820805','1820806','1820807','1820808','1820809','1820810','1820811','1820812','1820813','1820814','1820817','1820818','1820819','1820820','1820821','1820822','1820824','1820825','1820847','1831375','1831376','1831377','1831378','1831379','1831382','1831383','1831386','1831387','1831390','1831391','1831394','1831395','1831398','1831399','1831402','1831403','1831407','1831408','1831411','1831412','1836416','1836417','1836418','1836419','1836420','1836421','1836422','1836425','1836426','1836429','1836430','1836433','1836434','1836437','1836438','1836440') 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` = '343' GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"