SHOW FULL COLUMNS FROM `xr_scene` [ RunTime:0.010914s ]
SELECT COUNT(*) AS think_count FROM `xr_scene` `s` LEFT JOIN `xr_oss_file` `f` ON `f`.`id`=`s`.`xsc_image` WHERE ( s.xsc_public=1 and sys_stt=0 ) LIMIT 1 [ RunTime:0.011742s ]
SELECT `s`.`id`,`xsc_name`,`file_path`,`storage_type` FROM `xr_scene` `s` LEFT JOIN `xr_oss_file` `f` ON `f`.`id`=`s`.`xsc_image` WHERE ( s.xsc_public=1 and sys_stt=0 ) ORDER BY `s`.`create_date` DESC LIMIT 100,20 [ RunTime:0.010909s ]
