^ 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 => 3 ] ] 4 => array:3 [ 0 => "g.id" 1 => "in" 2 => array:26 [ 0 => "107109" 1 => "107114" 2 => "351739" 3 => "1135065" 4 => "516701" 5 => "107113" 6 => "352128" 7 => "1135073" 8 => "1107936" 9 => "352129" 10 => "1646780" 11 => "1660963" 12 => "812521" 13 => "625490" 14 => "1135085" 15 => "649314" 16 => "812522" 17 => "107098" 18 => "604219" 19 => "752847" 20 => "107097" 21 => "475650" 22 => "522897" 23 => "812520" 24 => "625491" 25 => "688184" ] ] ] "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` = '3' AND `g`.`id` IN ('107109','107114','351739','1135065','516701','107113','352128','1135073','1107936','352129','1646780','1660963','812521','625490','1135085','649314','812522','107098','604219','752847','107097','475650','522897','812520','625491','688184') 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` = '3' AND `g`.`id` IN ('107109','107114','351739','1135065','516701','107113','352128','1135073','1107936','352129','1646780','1660963','812521','625490','1135085','649314','812522','107098','604219','752847','107097','475650','522897','812520','625491','688184') 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 ('107097','107098','107109','107113','107114','351739','352128','352129','475650','516701','522897','604219','625490','625491','649314','688184','752847','812520','812521','812522','1107936','1135065','1135073','1135085','1646780','1660963') 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='3') 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` = '3' AND `g`.`id` IN ('107109','107114','351739','1135065','516701','107113','352128','1135073','1107936','352129','1646780','1660963','812521','625490','1135085','649314','812522','107098','604219','752847','107097','475650','522897','812520','625491','688184') AND `g`.`id` IN ('107097','107098','107109','107113','107114','351739','352128','352129','475650','516701','522897','604219','625490','625491','649314','688184','752847','812520','812521','812522','1107936','1135065','1135073','1135085','1646780','1660963') 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` = '3' AND `g`.`id` IN ('107109','107114','351739','1135065','516701','107113','352128','1135073','1107936','352129','1646780','1660963','812521','625490','1135085','649314','812522','107098','604219','752847','107097','475650','522897','812520','625491','688184') AND `g`.`id` IN ('107097','107098','107109','107113','107114','351739','352128','352129','475650','516701','522897','604219','625490','625491','649314','688184','752847','812520','812521','812522','1107936','1135065','1135073','1135085','1646780','1660963') 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` = '3' AND `g`.`id` IN ('107109','107114','351739','1135065','516701','107113','352128','1135073','1107936','352129','1646780','1660963','812521','625490','1135085','649314','812522','107098','604219','752847','107097','475650','522897','812520','625491','688184') AND ( `g`.`model_base` LIKE '6205%' ) GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"
筛选出 26 条数据
筛选出 26 条数据
清除
