SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000656s ]
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.000547s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000523s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000583s ]
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` = '27' AND `g`.`status` = '1' AND `g`.`starttime` <= '1768082732' AND `g`.`endtime` > '1768082732' ) LIMIT 1 [ RunTime:0.000792s ]
UPDATE `sys_goods` SET `views` = `views` + 1 WHERE ( `id` = 27 ) [ RunTime:0.007546s ]
JAN集团
分享
库存98件
收藏
