[ DB ] CONNECT:[ UseTime:0.000615s ] mysql:dbname=niushop_b2c;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sys_config` [ RunTime:0.000839s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `instance_id` = 0 AND `key` = 'MERCHANT_SERVICE' LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'HOTKEY' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'DEFAULTKEY' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_discount_goods` [ RunTime:0.000684s ]
[ SQL ] SELECT `npdg`.`discount_goods_id`,`npdg`.`discount_id`,`npdg`.`start_time`,`npdg`.`end_time`,`npdg`.`goods_id`,`npdg`.`status`,`npdg`.`discount`,`npdg`.`goods_name`,`ng`.`picture`,`ng`.`category_id_1`,`ng`.`price`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`point_exchange_type`,`ng`.`point_exchange` FROM `ns_promotion_discount_goods` `npdg` INNER JOIN `ns_goods` `ng` ON `ng`.`goods_id`=`npdg`.`goods_id` WHERE `ng`.`state` = 1 AND `status` = 1 ORDER BY end_time LIMIT 0,5 [ RunTime:0.000552s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_promotion_discount_goods` `npdg` INNER JOIN `ns_goods` `ng` ON `ng`.`goods_id`=`npdg`.`goods_id` WHERE `ng`.`state` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000322s ]
咨询客服
