SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000696s ]
SELECT `n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC LIMIT 4 [ RunTime:0.000550s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000528s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000498s ]
SELECT `g`.*,`gt`.`name`,`gt`.`basic_unit`,`gt`.`in_quantity`,`gt`.`content`,s.logo as supplier_logo,st.name as supplier_name,`s`.`mark_up_rate`,IF(s.mark_up_rate > 0, ROUND(g.price + (g.price * s.mark_up_rate / 100), 2), g.price) as price,IF(s.mark_up_rate > 0, ROUND(g.market_price + (g.market_price * s.mark_up_rate / 100), 2), g.market_price) as market_price FROM `sys_goods` `g` LEFT JOIN `sys_goods_translate` `gt` ON `g`.`id`=gt.goods_id AND gt.lang="zh-cn" LEFT JOIN `sys_supplier` `s` ON `g`.`supplier_id`=`s`.`id` LEFT JOIN `sys_supplier_translate` `st` ON `s`.`id`=st.supplier_id AND st.lang="zh-cn" WHERE ( `g`.`id` = '1' AND `g`.`status` = '1' AND `g`.`starttime` <= '1768084018' AND `g`.`endtime` > '1768084018' ) LIMIT 1 [ RunTime:0.000750s ]
UPDATE `sys_goods` SET `views` = `views` + 1 WHERE ( `id` = 1 ) [ RunTime:0.006642s ]
测试供应商
分享
库存192件
收藏
