SELECT * FROM `cmf_nav` WHERE `controllername` = 'BrandRecom' LIMIT 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `cmf_declare` [ RunTime:0.0005s ]
SHOW COLUMNS FROM `cmf_brand` [ RunTime:0.0004s ]
SHOW COLUMNS FROM `cmf_declareshow` [ RunTime:0.0004s ]
SHOW COLUMNS FROM `cmf_declareshowf` [ RunTime:0.0009s ]
SHOW COLUMNS FROM `cmf_declareshowv` [ RunTime:0.0004s ]
SELECT `year` FROM `cmf_brand` WHERE ( cateid=4 ) [ RunTime:0.0004s ]
SELECT * FROM `cmf_brand` WHERE ( cateid=4 and status=1 and year=2020 and create_date>='2021-1-1' ) ORDER BY istop asc,create_date desc LIMIT 10 [ RunTime:0.0005s ]
SHOW COLUMNS FROM `cmf_brand_act` [ RunTime:0.0004s ]
SELECT * FROM `cmf_brand_act` WHERE ( cateid=4 and status=1 and (isact=1 or isact=2) and create_date>='2021-1-1' ) ORDER BY istop asc,listorder desc,create_date desc LIMIT 8 [ RunTime:0.0001s ]
SELECT * FROM `cmf_brand_act` WHERE ( cateid=4 and status=1 and isact=2 ) ORDER BY istop asc,listorder desc,create_date desc LIMIT 5 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.0005s ]
SELECT * FROM `cmf_nav` LIMIT 1 [ RunTime:0.0001s ]
