SHOW FULL COLUMNS FROM `cmf_earnings` [ RunTime:0.028568s ]
SELECT `e`.`id`,`e`.`slug`,`e`.`fiscal_year`,`e`.`fiscal_quarter`,`e`.`period_code`,`e`.`period_type`,`e`.`filing_date`,`e`.`period_end_date`,`e`.`revenue`,`e`.`net_income`,`e`.`eps_diluted`,c.name as company_name,c.slug as company_slug,`c`.`symbol`,`c`.`logo`,`c`.`sector` FROM `cmf_earnings` `e` INNER JOIN `cmf_company` `c` ON `e`.`company_id`=`c`.`id` WHERE `c`.`delete_time` = '0' AND ( `c`.`name` LIKE '%JOBS%' OR `c`.`symbol` LIKE '%JOBS%' OR `c`.`slug` LIKE '%jobs%' ) ORDER BY `e`.`filing_date` DESC,`e`.`id` DESC LIMIT 100 [ RunTime:0.019972s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.016788s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.017214s ]
SELECT `more`,`file`,`id`,`is_public` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'matrix/list' ) ORDER BY `is_public` DESC [ RunTime:0.005481s ]