SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000636s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000528s ]
SELECT c.id,c.phone,c.email,c.customer_service_qr,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 = "zh-cn" 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.000488s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000492s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `sys_product_category` [ RunTime:0.000501s ]
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 = "zh-cn" 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.000475s ]
SHOW FULL COLUMNS FROM `sys_product` [ RunTime:0.000439s ]
SELECT p.id,p.category_id,p.intro_video,p.intro_images,p.color_images,p.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 = "zh-cn" 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 = "zh-cn" 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.000512s ]