[ BEHAVIOR ] Run \addons\shop\Shop @view_filter [ RunTime:0.000365s ]
[ DB ] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fa_shop_goods` [ RunTime:0.000695s ]
[ SQL ] SELECT * FROM `fa_shop_goods` WHERE ( `status` <> 'hidden' AND `id` = 23 ) AND `fa_shop_goods`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000556s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_goods_sku` [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `fa_shop_goods_sku` WHERE `goods_id` = 23 [ RunTime:0.000510s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_comment` [ RunTime:0.000477s ]
[ SQL ] SELECT `id`,`goods_id`,`content`,`star`,`user_id`,`images`,`createtime` FROM `fa_shop_comment` WHERE `status` = 'normal' AND `goods_id` = 23 [ RunTime:0.000349s ]
[ SQL ] UPDATE `fa_shop_goods` SET `views`=`views`+1 WHERE `id` = 23 [ RunTime:0.005226s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_category` [ RunTime:0.000600s ]
[ SQL ] SELECT * FROM `fa_shop_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_goods_sku_spec` [ RunTime:0.000537s ]
[ SQL ] SELECT MIN(`id`) AS `id`, MIN(`goods_id`) AS `goods_id`, `spec_id` FROM `fa_shop_goods_sku_spec` WHERE `goods_id` = 23 GROUP BY `spec_id` [ RunTime:0.000357s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_spec` [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `fa_shop_spec` WHERE `id` IN (4,5,6) [ RunTime:0.000275s ]
[ SQL ] SELECT `id`,`goods_id`,`spec_id`,`spec_value_id` FROM `fa_shop_goods_sku_spec` WHERE `goods_id` = 23 AND `spec_id` IN (4,5,6) [ RunTime:0.000293s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_spec_value` [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `fa_shop_spec_value` WHERE `id` IN (11,12,16,13,14,15,18) [ RunTime:0.000253s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_shop_comment` WHERE `goods_id` = 23 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SELECT * FROM `fa_shop_comment` WHERE `goods_id` = 23 AND `status` = 'normal' LIMIT 0,15 [ RunTime:0.000258s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_guarantee` [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `fa_shop_guarantee` WHERE `id` IN (2,1) AND `status` = 'normal' [ RunTime:0.000246s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_coupon_condition` [ RunTime:0.000444s ]
[ SQL ] SELECT * FROM `fa_shop_coupon_condition` WHERE `type` = 2 OR ( `type` = 1 AND ( 1=2 OR FIND_IN_SET('23',content) ) ) OR ( `type` = 4 AND ( 1=2 OR FIND_IN_SET('9',content) ) ) OR ( `type` = 5 AND ( 1=2 OR FIND_IN_SET('1',content) ) ) [ RunTime:0.000294s ]
[ SQL ] SHOW COLUMNS FROM `fa_shop_coupon` [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `fa_shop_coupon` WHERE ( condition_ids IS NULL OR condition_ids='' ) AND `is_open` = 1 AND `is_private` = 'no' AND `endtime` > 1737565745 LIMIT 3 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `fa_shop_category` WHERE `id` IN (9) [ RunTime:0.000398s ]
[ SQL ] SELECT * FROM `fa_shop_category` WHERE `id` IN (9,10) [ RunTime:0.000364s ]
