^"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`.`shop_category_id` = '3110' 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 ('224265','224266','225134','226957','226958','226959','226960','226962','226964','226965','228136','228140','228144','230376','230377','230378','230379','230380','230382','230383','230384','230386','231993','231994','234213','234214','234215','234216','525465','525475','525535','525536','525537','525564','525565','525580','525935','525936','525994','525995','526067','526112','537573','539381','539393','539440','539562','539591','539598','539599','565300','565301','565338','565341','565342','583878','584315','584316','584335','584336','603462','606349','606363','615708','619872','625251','625252','625253','625298','625299','625300','625325','630402','630419','641365','641366','645693','646393','646429','648410','654145','695853','698882','710359','710455','710456','710473','710474','710475','710476','710477','710478','710479','710480','710481','710508','710509','710510','710602','710603','710604','712483','712794','712796','712797','717975','726471','730983','740049','740050','750695','757614','759450','768595','790569','790573','792317','792361','793047','805182','807572','807642','807650','813795','1069694','1106200','1290791','1624597','1629351','1647443','1654230','1659909','1662965','1673134','1673402','1694191','1696532','1706708','1706709','1706710','1765217','1786932','1799789','1809773','1817780','1817781','1817782','1817788','1817789','1818314','1839160') 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`.`shop_category_id` = '3110' AND `g`.`id` IN ('224265','224266','225134','226957','226958','226959','226960','226962','226964','226965','228136','228140','228144','230376','230377','230378','230379','230380','230382','230383','230384','230386','231993','231994','234213','234214','234215','234216','525465','525475','525535','525536','525537','525564','525565','525580','525935','525936','525994','525995','526067','526112','537573','539381','539393','539440','539562','539591','539598','539599','565300','565301','565338','565341','565342','583878','584315','584316','584335','584336','603462','606349','606363','615708','619872','625251','625252','625253','625298','625299','625300','625325','630402','630419','641365','641366','645693','646393','646429','648410','654145','695853','698882','710359','710455','710456','710473','710474','710475','710476','710477','710478','710479','710480','710481','710508','710509','710510','710602','710603','710604','712483','712794','712796','712797','717975','726471','730983','740049','740050','750695','757614','759450','768595','790569','790573','792317','792361','793047','805182','807572','807642','807650','813795','1069694','1106200','1290791','1624597','1629351','1647443','1654230','1659909','1662965','1673134','1673402','1694191','1696532','1706708','1706709','1706710','1765217','1786932','1799789','1809773','1817780','1817781','1817782','1817788','1817789','1818314','1839160') 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`.`shop_category_id` = '3110' AND `g`.`id` IN ('224265','224266','225134','226957','226958','226959','226960','226962','226964','226965','228136','228140','228144','230376','230377','230378','230379','230380','230382','230383','230384','230386','231993','231994','234213','234214','234215','234216','525465','525475','525535','525536','525537','525564','525565','525580','525935','525936','525994','525995','526067','526112','537573','539381','539393','539440','539562','539591','539598','539599','565300','565301','565338','565341','565342','583878','584315','584316','584335','584336','603462','606349','606363','615708','619872','625251','625252','625253','625298','625299','625300','625325','630402','630419','641365','641366','645693','646393','646429','648410','654145','695853','698882','710359','710455','710456','710473','710474','710475','710476','710477','710478','710479','710480','710481','710508','710509','710510','710602','710603','710604','712483','712794','712796','712797','717975','726471','730983','740049','740050','750695','757614','759450','768595','790569','790573','792317','792361','793047','805182','807572','807642','807650','813795','1069694','1106200','1290791','1624597','1629351','1647443','1654230','1659909','1662965','1673134','1673402','1694191','1696532','1706708','1706709','1706710','1765217','1786932','1799789','1809773','1817780','1817781','1817782','1817788','1817789','1818314','1839160') 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`.`shop_category_id` = '3110' GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
