SELECT * FROM `cmf_nav` WHERE `controllername` = 'BrandRecom' LIMIT 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `cmf_declare` [ RunTime:0.0006s ]
SHOW COLUMNS FROM `cmf_brand` [ RunTime:0.0004s ]
SHOW COLUMNS FROM `cmf_declareshow` [ RunTime:0.0005s ]
SHOW COLUMNS FROM `cmf_declareshowf` [ RunTime:0.0011s ]
SHOW COLUMNS FROM `cmf_declareshowv` [ RunTime:0.0005s ]
SHOW COLUMNS FROM `cmf_declare_cat` [ RunTime:0.0004s ]
SELECT * FROM `cmf_declare` WHERE ( recommended=1 and status=1 and length(background_pic)>0 ) ORDER BY date desc LIMIT 5 [ RunTime:0.0012s ]
SHOW COLUMNS FROM `cmf_brand_act` [ RunTime:0.0004s ]
SELECT * FROM `cmf_brand_act` WHERE ( cateid=5 and status=1 and (isact=1 or isact=2) and create_date >= '2021-01-01' ) ORDER BY listorder desc,create_date desc LIMIT 7 [ RunTime:0.0001s ]
SELECT * FROM `cmf_brand_act` WHERE ( cateid=5 and status=1 and isact=2 ) ORDER BY listorder desc,create_date desc LIMIT 5 [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare_cat` ORDER BY date desc [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '11' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0009s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2020-01-01' AND '2020-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '10' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2019-01-01' AND '2019-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '9' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2018-01-01' AND '2018-12-31' [ RunTime:0.0002s ]
SELECT * FROM `cmf_declare` WHERE `category` = '8' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2017-01-01' AND '2017-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '7' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2016-01-01' AND '2016-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '3' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2015-01-01' AND '2015-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '2' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2014-01-01' AND '2014-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '1' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2013-01-01' AND '2013-12-31' [ RunTime:0.0001s ]
SELECT * FROM `cmf_declare` WHERE `category` = '4' AND `is_chinese` = 1 AND `status` = 1 AND `video_url` <> '' ORDER BY date desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `cmf_declareshowv` WHERE `status` = 1 AND `background_pic` <> '' AND `date` BETWEEN '2012-01-01' AND '2012-12-31' [ RunTime:0.0001s ]
SHOW COLUMNS FROM `cmf_declare` [ RunTime:0.0007s ]
SELECT * FROM `cmf_declare` WHERE `status` = 1 AND `recommended` = 1 AND ( date >= '2021-01-01' ) LIMIT 10 [ RunTime:0.0003s ]
SELECT * FROM `cmf_declare` WHERE `status` = 1 AND `recommended` = 0 AND ( date >= '2021-01-01' ) ORDER BY date desc LIMIT 10 [ RunTime:0.0004s ]
SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.0006s ]
SELECT * FROM `cmf_nav` LIMIT 1 [ RunTime:0.0001s ]
