SHOW FULL COLUMNS FROM `system_config` [ RunTime:0.002850s ]
SHOW TABLES LIKE 'article' [ RunTime:0.001047s ]
SHOW TABLES LIKE 'article_category' [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `article` [ RunTime:0.001289s ]
SELECT `a`.`id`,`a`.`title`,`a`.`content`,`a`.`jump_link`,`a`.`article_type`,`a`.`product_type`,`a`.`create_time`,`c`.`identifier` FROM `article` `a` LEFT JOIN `article_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `c`.`identifier` = 'products' AND `a`.`delete_time` IS NULL AND `c`.`delete_time` IS NULL AND `a`.`product_type` = 'coating' ORDER BY `a`.`id` DESC LIMIT 12 [ RunTime:0.002547s ]