SELECT COUNT(*) AS think_count FROM `cm_product` WHERE `status` = 1 AND `category_id` = 1 AND ( `title` LIKE '%MES%' OR `summary` LIKE '%MES%' OR `tags` LIKE '%MES%' OR `tech_stack` LIKE '%MES%' ) [ RunTime:0.000166s ]
SELECT * FROM `cm_product` WHERE `status` = 1 AND `category_id` = 1 AND ( `title` LIKE '%MES%' OR `summary` LIKE '%MES%' OR `tags` LIKE '%MES%' OR `tech_stack` LIKE '%MES%' ) ORDER BY `is_top` DESC,`sort` ASC,`hot` DESC,`id` ASC LIMIT 12 OFFSET 0 [ RunTime:0.000235s ]
SELECT `industries`,`tech_stack` FROM `cm_product` WHERE `status` = 1 [ RunTime:0.000067s ]
SELECT `name`,`id` FROM `cm_category` [ RunTime:0.000042s ]
SELECT `slug`,`id` FROM `cm_category` [ RunTime:0.000023s ]
SELECT category_id, COUNT(*) AS n FROM `cm_product` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.000078s ]
SELECT * FROM `cm_category` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000055s ]
SELECT COUNT(*) AS think_count FROM `cm_product` WHERE `status` = 1 [ RunTime:0.000051s ]