SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `sys_footer_nav` [ RunTime:0.000448s ]
SELECT f.id,f.pid,f.sort,f.status,COALESCE(NULLIF(ft.name, ""), NULLIF(fd.name, ""), "") as name,COALESCE(NULLIF(ft.url, ""), NULLIF(fd.url, ""), "") as url FROM `sys_footer_nav` `f` LEFT JOIN `sys_footer_nav_translate` `ft` ON `ft`.`footer_nav_id`=f.id AND ft.lang = "en-us" LEFT JOIN `sys_footer_nav_translate` `fd` ON `fd`.`footer_nav_id`=f.id AND fd.lang = "zh-cn" WHERE `f`.`status` = '1' ORDER BY `f`.`sort` ASC,`f`.`id` ASC [ RunTime:0.000546s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000477s ]
SELECT c.id,c.phone,c.email,c.customer_service_qr,ct.address as current_address,cd.address as default_address,ct.content as current_content,cd.content as default_content,COALESCE(NULLIF(ct.address, ""), NULLIF(cd.address, ""), "") as address,COALESCE(NULLIF(ct.content, ""), NULLIF(cd.content, ""), "") as content FROM `sys_contact` `c` LEFT JOIN `sys_contact_translate` `ct` ON `ct`.`contact_id`=c.id AND ct.lang = "en-us" LEFT JOIN `sys_contact_translate` `cd` ON `cd`.`contact_id`=c.id AND cd.lang = "zh-cn" WHERE `c`.`status` = '1' ORDER BY `c`.`id` ASC LIMIT 1 [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000433s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `sys_product_category` [ RunTime:0.000472s ]
SELECT pc.id,pc.parent_id,pc.level,pc.sort,pc.cover_image,COALESCE(NULLIF(pct.name, ""), NULLIF(pcd.name, ""), "") as name,COALESCE(NULLIF(pct.subtitle, ""), NULLIF(pcd.subtitle, ""), "") as subtitle FROM `sys_product_category` `pc` LEFT JOIN `sys_product_category_translate` `pct` ON `pct`.`category_id`=pc.id AND pct.lang = "en-us" LEFT JOIN `sys_product_category_translate` `pcd` ON `pcd`.`category_id`=pc.id AND pcd.lang = "zh-cn" WHERE `pc`.`status` = '1' ORDER BY `pc`.`level` ASC,`pc`.`sort` ASC,`pc`.`id` ASC [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `sys_product` [ RunTime:0.000463s ]
SELECT p.id,p.category_id,p.intro_video,p.intro_images,p.color_images,COALESCE(NULLIF(pt.parameters, ""), NULLIF(pd.parameters, ""), "") as parameters,p.help_docs,p.sort,p.create_time,p.update_time,COALESCE(NULLIF(pt.name, ""), NULLIF(pd.name, ""), "") as name,COALESCE(NULLIF(pt.description, ""), NULLIF(pd.description, ""), "") as description,COALESCE(NULLIF(pt.rights_schema, ""), NULLIF(pd.rights_schema, ""), "") as rights_schema,COALESCE(NULLIF(pct.name, ""), NULLIF(pcd.name, ""), "") as category_name,COALESCE(NULLIF(pct.subtitle, ""), NULLIF(pcd.subtitle, ""), "") as category_subtitle FROM `sys_product` `p` LEFT JOIN `sys_product_translate` `pt` ON `pt`.`product_id`=p.id AND pt.lang = "en-us" LEFT JOIN `sys_product_translate` `pd` ON `pd`.`product_id`=p.id AND pd.lang = "zh-cn" LEFT JOIN `sys_product_category_translate` `pct` ON `pct`.`category_id`=p.category_id AND pct.lang = "en-us" LEFT JOIN `sys_product_category_translate` `pcd` ON `pcd`.`category_id`=p.category_id AND pcd.lang = "zh-cn" WHERE `p`.`status` = '1' ORDER BY `p`.`sort` ASC,`p`.`id` DESC [ RunTime:0.001333s ]