SHOW FULL COLUMNS FROM `sc_category` [ RunTime:0.001495s ]
SELECT * FROM `sc_category` WHERE ( `state` = 1 AND `id` = 138 ) AND `sc_category`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `sc_files` [ RunTime:0.001164s ]
SELECT * FROM `sc_files` WHERE ( `id` = 7 ) AND `sc_files`.`delete_time` IS NULL [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `sc_periodical` [ RunTime:0.001079s ]
SELECT * FROM `sc_periodical` WHERE ( `state` = 1 AND `category_id` = '138' ) AND `sc_periodical`.`delete_time` IS NULL ORDER BY `year` DESC,`cycle` DESC [ RunTime:0.000959s ]
SELECT * FROM `sc_periodical` WHERE ( `state` = 1 AND `category_id` = '138' AND `year` = '2019' AND `cycle` = '06' ) AND `sc_periodical`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `sc_periodical` WHERE ( `id` = 259 ) AND `sc_periodical`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `sc_document` [ RunTime:0.001153s ]
SELECT * FROM `sc_document` WHERE ( `periodical_id` = 259 AND `title` IS NOT NULL AND `author` IS NOT NULL ) AND `sc_document`.`delete_time` IS NULL ORDER BY `ordernum` ASC,`origin_ordernum` ASC,`id` ASC LIMIT 0,20 [ RunTime:0.042152s ]
