[ DB ] CONNECT:[ UseTime:0.000525s ] mysql:dbname=niushop_b2c;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sys_config` [ RunTime:0.000750s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'WAP_CUSTOM_TEMPLATE_IS_ENABLE' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000417s ]
[ SQL ] SHOW COLUMNS FROM `sys_wap_custom_template` [ RunTime:0.000672s ]
[ SQL ] SELECT * FROM `sys_wap_custom_template` WHERE `shop_id` = 0 AND `is_default` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'USE_WAP_TEMPLATE' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `sys_config` WHERE `instance_id` = 0 AND `key` = 'REGISTERANDVISIT' LIMIT 1 [ RunTime:0.000399s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'SHOPWCHAT' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_category_block` [ RunTime:0.000626s ]
[ SQL ] SELECT `color`,`category_alias`,`category_id`,`goods_sort_type` FROM `ns_goods_category_block` WHERE `shop_id` = 0 AND `is_show` = 1 ORDER BY sort asc [ RunTime:0.000409s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods` [ RunTime:0.000986s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng_sap`.`pic_cover_small`,`ng`.`goods_name`,`ng`.`promotion_price`,`ng`.`state`,`ng`.`shipping_fee`,`ng`.`group_id_array`,`ng`.`point_exchange_type`,`ng`.`point_exchange` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`category_id_1` = 5 AND `ng`.`state` = 1 ORDER BY ng.sort asc,ng.create_time desc LIMIT 0,4 [ RunTime:0.000763s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_discount_goods` [ RunTime:0.000680s ]
[ 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 `status` = 1 AND `ng`.`state` = 1 ORDER BY end_time LIMIT 0,2 [ RunTime:0.000399s ]
[ 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 `status` = 1 AND `ng`.`state` = 1 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'SHOPWCHAT' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000303s ]
[ SQL ] SHOW COLUMNS FROM `ns_coupon_type` [ RunTime:0.000770s ]
[ SQL ] SELECT * FROM `ns_coupon_type` WHERE `start_time` <= 1768076348 AND `end_time` >= 1768076348 AND `is_show` = 1 AND `shop_id` = 0 ORDER BY start_time desc [ RunTime:0.000357s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_games` [ RunTime:0.000825s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_promotion_games` WHERE `status` = 1 AND `activity_images` <> '' LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `ns_promotion_games` WHERE `status` = 1 AND `activity_images` <> '' ORDER BY game_id desc [ RunTime:0.000381s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_new` = 1 ORDER BY ng.sort asc LIMIT 0,4 [ RunTime:0.000355s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_recommend` = 1 ORDER BY ng.sort asc LIMIT 0,4 [ RunTime:0.000349s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_hot` = 1 ORDER BY ng.sort asc LIMIT 0,4 [ RunTime:0.000414s ]
