SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000394s ]
SELECT `n`.`id`,`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.000345s ]
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 `n`.`pid` = '1' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000269s ]
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 `n`.`pid` = '2' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000189s ]
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 `n`.`pid` = '3' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000165s ]
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 `n`.`pid` = '4' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000286s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000172s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000327s ]
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,IF(s.mark_up_rate > 0, ROUND(gt.basic_price + (gt.basic_price * s.mark_up_rate / 100), 2), gt.basic_price) as basic_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` = '344' AND `g`.`status` = '1' AND `g`.`starttime` <= '1772195552' AND `g`.`endtime` > '1772195552' ) LIMIT 1 [ RunTime:0.000398s ]
UPDATE `sys_goods` SET `views` = `views` + 1 WHERE ( `id` = 344 ) [ RunTime:0.003440s ]
GYQYGLFW(DG)YXGS
分享
库存3200柜
收藏
