SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000717s ]
SHOW FULL COLUMNS FROM `sys_footer_nav` [ RunTime:0.000512s ]
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.000559s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000526s ]
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.000497s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000477s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `sys_product_category` [ RunTime:0.000560s ]
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.000605s ]
SHOW FULL COLUMNS FROM `sys_support_material` [ RunTime:0.000609s ]
SELECT COUNT(*) AS think_count FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' [ RunTime:0.000471s ]
SELECT sm.id,sm.file_url,sm.file_size,sm.update_date,sm.doc_type,sm.version,sm.page_count,sm.sort,sm.addtime,sm.updatetime,COALESCE(NULLIF(smt.title, ""), NULLIF(smd.title, ""), "") as title,COALESCE(NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), NULLIF(sm.doc_type, ""), "") as doc_type_label,COALESCE(NULLIF(sm.doc_type, ""), NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), "") as effective_doc_type FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' ORDER BY `sm`.`sort` ASC,`sm`.`id` DESC LIMIT 0,8 [ RunTime:0.000394s ]
SELECT sm.doc_type,COALESCE(NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), NULLIF(sm.doc_type, ""), "") as doc_type_label,COALESCE(NULLIF(sm.doc_type, ""), NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), "") as effective_doc_type,sm.sort,sm.id FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' ORDER BY `sm`.`sort` ASC,`sm`.`id` DESC [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `sys_support_video` [ RunTime:0.000490s ]
SELECT COUNT(*) AS think_count FROM `sys_support_video` `sv` LEFT JOIN `sys_support_video_translate` `svt` ON `svt`.`support_video_id`=sv.id AND svt.lang = "zh-cn" LEFT JOIN `sys_support_video_translate` `svd` ON `svd`.`support_video_id`=sv.id AND svd.lang = "zh-cn" WHERE `sv`.`status` = '1' [ RunTime:0.000431s ]
SELECT sv.id,sv.cover_image,sv.video_url,sv.duration,sv.play_count,sv.update_date,sv.sort,sv.addtime,sv.updatetime,COALESCE(NULLIF(svt.title, ""), NULLIF(svd.title, ""), "") as title,COALESCE(NULLIF(svt.category_label, ""), NULLIF(svd.category_label, ""), "") as category_label FROM `sys_support_video` `sv` LEFT JOIN `sys_support_video_translate` `svt` ON `svt`.`support_video_id`=sv.id AND svt.lang = "zh-cn" LEFT JOIN `sys_support_video_translate` `svd` ON `svd`.`support_video_id`=sv.id AND svd.lang = "zh-cn" WHERE `sv`.`status` = '1' ORDER BY `sv`.`sort` ASC,`sv`.`id` DESC LIMIT 0,6 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000535s ]
SELECT `a`.`id`,`a`.`pos_id`,`a`.`name`,`a`.`description`,`a`.`pic`,`a`.`video`,`a`.`url`,`a`.`sort`,`a`.`starttime`,`a`.`endtime`,ap.size as pos_size FROM `sys_ad` `a` LEFT JOIN `sys_ad_pos` `ap` ON `ap`.`id`=`a`.`pos_id` WHERE `a`.`status` = '1' AND `a`.`module` = 'home' AND `a`.`pos_id` = '8' AND ( ( (a.starttime = 0 OR a.starttime IS NULL OR a.starttime <= 1777199716) ) ) AND ( ( (a.endtime = 0 OR a.endtime IS NULL OR a.endtime >= 1777199716) ) ) ORDER BY `a`.`sort` ASC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000486s ]
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.000337s ]