[ BEHAVIOR ] Run app\common\behavior\SkyWalking @app_end [ RunTime:0.000047s ]
[ DB ] CONNECT:[ UseTime:0.000468s ] mysql:host=192.168.2.210;port=3306;dbname=zwdc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zwdc_banner` [ slave|RunTime:0.001681s ]
[ DB ] CONNECT:[ UseTime:0.000362s ] mysql:host=192.168.2.210;port=3306;dbname=zwdc;charset=utf8
[ SQL ] SELECT * FROM `zwdc_banner` WHERE `type` = 4 AND `status` = 1 AND `show_type` = 1 AND `start_time` <= '2025-06-13 22:57:03' AND `end_time` > '2025-06-13 22:57:03' ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000575s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_ad_set` [ slave|RunTime:0.001255s ]
[ SQL ] SELECT `adSetImages`.`id`,`adSetImages`.`fastdfs_id`,`adSetImages`.`title`,`adSetImages`.`url`,`adSetImages`.`position`,adSet.type type1,adSet.title title1,`adSet`.`status` FROM `zwdc_ad_set` `adSet` LEFT JOIN `zwdc_ad_set_images` `adSetImages` ON `adSet`.`id`=`adSetImages`.`ad_set_id` ORDER BY `adSetImages`.`position` DESC,`id` DESC [ slave|RunTime:0.000379s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_source_material_category` [ slave|RunTime:0.001186s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_source_material_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `position` ASC,`id` DESC LIMIT 0,21 [ slave|RunTime:0.000299s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_hot_search_words` [ slave|RunTime:0.001407s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_product_type` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000552s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_source` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000521s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_temp` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000515s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_product_type_bw_list` [ slave|RunTime:0.001540s ]
[ SQL ] SELECT `product_type_id`,`is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` IN (12496,12495,12493,12492,12488,12487,12481,12480) AND `group_id` = 0 AND `bw_type` = 1 [ slave|RunTime:0.000538s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12496 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('32','33','34','35','36') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000449s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12495 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('32','33','34','35','36') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.007987s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12493 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000619s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12492 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000608s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12488 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000611s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12487 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('29','30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000646s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12481 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('248') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000533s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12480 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('248') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000435s ]
[ SQL ] SELECT `product_type_id`,`is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` IN (12004,11979,12002,11909,11188,11488,11493,11481) AND `group_id` = 0 AND `bw_type` = 1 [ slave|RunTime:0.000534s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12004 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000607s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11979 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000601s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12002 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000574s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11909 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','33','34') AND `stockSkuItems`.`color_id` IN ('29','37','30','103','31') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000933s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11188 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000519s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11488 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000541s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11493 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('45','43','46','47','40') AND `stockSkuItems`.`color_id` IN ('29','30','31','32') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000717s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 11481 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','33','34') AND `stockSkuItems`.`color_id` IN ('29','37','30','33','34','31') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000629s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_batch_issue_coupon_rule` [ slave|RunTime:0.001146s ]
[ SQL ] SELECT `t1`.* FROM `zwdc_batch_issue_coupon_rule` `t1` LEFT JOIN `zwdc_batch_issue_coupon_issue_method` `t2` ON `t1`.`id`=`t2`.`batch_issue_coupon_rule_id` WHERE `t1`.`group_level_id` = 1 AND `t1`.`status` = 1 AND `t1`.`auto_issue_start_time` <= '2025-06-13' AND `t1`.`auto_issue_end_time` >= '2025-06-13' AND `t2`.`issue_method` = 1 AND `t2`.`issue_condition` = 1 ORDER BY `t1`.`id` DESC LIMIT 1 [ slave|RunTime:0.000325s ]
[ SQL ] SELECT `t1`.* FROM `zwdc_batch_issue_coupon_rule` `t1` LEFT JOIN `zwdc_batch_issue_coupon_issue_method` `t2` ON `t1`.`id`=`t2`.`batch_issue_coupon_rule_id` WHERE `t1`.`group_level_id` = 2 AND `t1`.`status` = 1 AND `t1`.`auto_issue_start_time` <= '2025-06-13' AND `t1`.`auto_issue_end_time` >= '2025-06-13' AND `t2`.`issue_method` = 1 AND `t2`.`issue_condition` = 1 ORDER BY `t1`.`id` DESC LIMIT 1 [ slave|RunTime:0.000318s ]
[ SQL ] SELECT `t1`.* FROM `zwdc_batch_issue_coupon_rule` `t1` LEFT JOIN `zwdc_batch_issue_coupon_issue_method` `t2` ON `t1`.`id`=`t2`.`batch_issue_coupon_rule_id` WHERE `t1`.`group_level_id` = 3 AND `t1`.`status` = 1 AND `t1`.`auto_issue_start_time` <= '2025-06-13' AND `t1`.`auto_issue_end_time` >= '2025-06-13' AND `t2`.`issue_method` = 1 AND `t2`.`issue_condition` = 1 ORDER BY `t1`.`id` DESC LIMIT 1 [ slave|RunTime:0.000330s ]
[ SQL ] SELECT `t1`.* FROM `zwdc_batch_issue_coupon_rule` `t1` LEFT JOIN `zwdc_batch_issue_coupon_issue_method` `t2` ON `t1`.`id`=`t2`.`batch_issue_coupon_rule_id` WHERE `t1`.`group_level_id` = 4 AND `t1`.`status` = 1 AND `t1`.`auto_issue_start_time` <= '2025-06-13' AND `t1`.`auto_issue_end_time` >= '2025-06-13' AND `t2`.`issue_method` = 1 AND `t2`.`issue_condition` = 1 ORDER BY `t1`.`id` DESC LIMIT 1 [ slave|RunTime:0.000368s ]
[ SQL ] SELECT `t1`.* FROM `zwdc_batch_issue_coupon_rule` `t1` LEFT JOIN `zwdc_batch_issue_coupon_issue_method` `t2` ON `t1`.`id`=`t2`.`batch_issue_coupon_rule_id` WHERE `t1`.`group_level_id` = 7 AND `t1`.`status` = 1 AND `t1`.`auto_issue_start_time` <= '2025-06-13' AND `t1`.`auto_issue_end_time` >= '2025-06-13' AND `t2`.`issue_method` = 1 AND `t2`.`issue_condition` = 1 ORDER BY `t1`.`id` DESC LIMIT 1 [ slave|RunTime:0.000319s ]
[ SQL ] SELECT `id` FROM `zwdc_group_level` WHERE `quarterly_cumulative_discount` = 1 AND `id` <= 4 ORDER BY `id` ASC LIMIT 2 [ master|RunTime:0.000312s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_frontend_service` [ slave|RunTime:0.001140s ]
[ SQL ] SELECT * FROM `zwdc_frontend_service` WHERE `module` = 3 AND `status` = 1 AND `is_del` = -1 AND `is_pc` = 1 ORDER BY `is_default` ASC,`position` DESC,`created` DESC [ slave|RunTime:0.000446s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_qrcode` [ slave|RunTime:0.001274s ]
[ SQL ] SELECT * FROM `zwdc_qrcode` WHERE `type` = 1 AND `status` = 1 AND `position` IN (3,1,2) GROUP BY `position` ORDER BY `position` ASC [ slave|RunTime:0.000330s ]