SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `sys_footer_nav` [ RunTime:0.000458s ]
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 = "zh-cn" 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.000488s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000432s ]
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 = "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.000379s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000401s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000495s ]
SELECT c.id,c.category_id,c.product_id,c.cover_image,c.detail_image,c.province_code,c.city_code,c.district_code,c.location as default_location,c.sort,c.create_time,c.update_time,COALESCE(NULLIF(ct.title, ""), NULLIF(cd.title, ""), "") as title,COALESCE(NULLIF(ct.scene, ""), NULLIF(cd.scene, ""), "") as scene,COALESCE(NULLIF(ct.summary, ""), NULLIF(cd.summary, ""), "") as summary,COALESCE(NULLIF(ct.content, ""), NULLIF(cd.content, ""), "") as content,COALESCE(NULLIF(ct.location, ""), NULLIF(cd.location, ""), NULLIF(c.location, ""), "") as location,COALESCE(NULLIF(pt.name, ""), NULLIF(pd.name, ""), "") as product_name,COALESCE(NULLIF(cct.name, ""), NULLIF(ccd.name, ""), "") as category_name FROM `sys_case` `c` LEFT JOIN `sys_case_translate` `ct` ON `ct`.`case_id`=c.id AND ct.lang = "zh-cn" LEFT JOIN `sys_case_translate` `cd` ON `cd`.`case_id`=c.id AND cd.lang = "zh-cn" LEFT JOIN `sys_product_translate` `pt` ON `pt`.`product_id`=c.product_id AND pt.lang = "zh-cn" LEFT JOIN `sys_product_translate` `pd` ON `pd`.`product_id`=c.product_id AND pd.lang = "zh-cn" LEFT JOIN `sys_case_category_translate` `cct` ON `cct`.`category_id`=c.category_id AND cct.lang = "zh-cn" LEFT JOIN `sys_case_category_translate` `ccd` ON `ccd`.`category_id`=c.category_id AND ccd.lang = "zh-cn" WHERE `c`.`status` = '1' AND `c`.`id` = '7' LIMIT 1 [ RunTime:0.000635s ]
SELECT c.id,c.cover_image,c.sort,c.create_time,COALESCE(NULLIF(ct.title, ""), NULLIF(cd.title, ""), "") as title FROM `sys_case` `c` LEFT JOIN `sys_case_translate` `ct` ON `ct`.`case_id`=c.id AND ct.lang = "zh-cn" LEFT JOIN `sys_case_translate` `cd` ON `cd`.`case_id`=c.id AND cd.lang = "zh-cn" WHERE `c`.`status` = '1' AND `c`.`id` <> '7' AND ( `c`.`sort` > '50' OR ( `c`.`sort` = '50' AND `c`.`id` < '7' ) ) ORDER BY `c`.`sort` ASC,`c`.`id` DESC LIMIT 1 [ RunTime:0.000404s ]
广东省 / 广州市 / 增城区
