SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000646s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000500s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000468s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000488s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000402s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000427s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000592s ]
SELECT `id`,`title`,`content`,`description`,`is_erp`,`slideshow`,`origin`,`publish_time`,`class_id`,`attr_id`,`brand_id`,`unit`,`unit_count`,`seller_id`,`goods_sn`,`shipping_id`,`category_id`,`min_price` FROM `sys_goods` WHERE `id` = 1697 AND `status` = 1 LIMIT 1 [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000425s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` = 0 ) LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000625s ]
SELECT `name` FROM `sys_category` WHERE ( `id` = 7 ) LIMIT 1 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000612s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000650s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,local_stock as stock,`specs_ids`,`attr_id`,`erp_procode`,`erp_stock`,`barcode`,`thumb`,`weight_n`,`weight_g`,`unit_count` FROM `sys_goods_item` WHERE ( `goods_id` = 1697 ) ORDER BY `price` ASC [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `sys_goods_specs` [ RunTime:0.000636s ]
SELECT `child`.`name`,`child`.`id` FROM `sys_goods_specs` `child` INNER JOIN `sys_goods_specs` `parent` ON `child`.`pid`=`parent`.`id` WHERE `child`.`id` IN ('2626','2629','2630') AND `parent`.`code` = 'size' [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `sys_stockroom_cate` [ RunTime:0.000642s ]
SELECT `name`,`stock_code` FROM `sys_stockroom_cate` WHERE `stock_code` <> '' AND `status` = 1 [ RunTime:0.000453s ]
SELECT `pid`,`id` FROM `sys_goods_specs` WHERE `id` IN (2626,2629,2630) AND `status` = 1 [ RunTime:0.000465s ]
SELECT `pid`,`id` FROM `sys_goods_specs` WHERE `id` IN (2622,2623,2624) AND `status` = 1 [ RunTime:0.000471s ]
SELECT `id`,`pid`,`name`,`code`,`color`,`color_group`,`desc` FROM `sys_goods_specs` WHERE `status` = 1 AND `seller_id` = 4 AND ( `id` IN (2626,2629,2630,2622,2623,2624) OR `pid` = 0 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `sys_brand` [ RunTime:0.000630s ]
SELECT `name` FROM `sys_brand` WHERE ( `id` = 31 ) LIMIT 1 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000703s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '4' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794306314 AND `endtime` >= 1794306314 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000566s ]
SHOW FULL COLUMNS FROM `sys_seller` [ RunTime:0.000723s ]
SELECT `seller_id`,`seller_name`,`seller_logo`,`is_self`,`service_phone` FROM `sys_seller` WHERE ( `seller_id` = '4' ) LIMIT 1 [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `sys_seller_comment` [ RunTime:0.000600s ]
SELECT ROUND(AVG(service_score), 1) AS `service_score`,ROUND(AVG(logistics_score), 1) AS `logistics_score`,COUNT(*) AS `total` FROM `sys_seller_comment` WHERE `seller_id` = 4 LIMIT 1 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `sys_user_collect` [ RunTime:0.000510s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 4 ) [ RunTime:0.000418s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 4 AND `uid` = 0 ) [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `sys_goods_comment` [ RunTime:0.000677s ]
SELECT * FROM `sys_goods_comment` WHERE ( `goods_id` = 1697 AND `is_show` = 1 ) ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000474s ]
SELECT COUNT(*) AS think_count FROM `sys_goods_comment` WHERE ( `goods_id` = 1697 AND `is_show` = 1 ) [ RunTime:0.000415s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `uid` = 0 AND `type` = '2' AND `point_id` = 1697 ) [ RunTime:0.000462s ]
SHOW FULL COLUMNS FROM `sys_user_view_history` [ RunTime:0.000619s ]
SELECT * FROM `sys_user_view_history` WHERE `uid` = 0 AND `goods_id` = 1697 LIMIT 1 [ RunTime:0.000457s ]