SHOW FULL COLUMNS FROM `cr_category` [ RunTime:0.001601s ]
SELECT * FROM `cr_category` WHERE ( `status` = 1 AND `parent_id` = 0 ) AND `cr_category`.`delete_time` = '0' ORDER BY `sort` ASC LIMIT 6 [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `cr_article` [ RunTime:0.001125s ]
SELECT * FROM `cr_article` WHERE `status` = 1 AND `type` IN ('help','page') ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000502s ]
SELECT `id` FROM `cr_category` WHERE ( `parent_id` = 2 AND `status` = 1 ) AND `cr_category`.`delete_time` = '0' [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `cr_product` [ RunTime:0.001240s ]
SELECT COUNT(*) AS think_count FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 2 ) AND `cr_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000461s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 2 ) AND `cr_product`.`delete_time` = '0' ORDER BY `sort` DESC,`id` DESC LIMIT 0,12 [ RunTime:0.000394s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `cr_product_attr` [ RunTime:0.000991s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` IN (12,6,5) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000448s ]
SELECT * FROM `cr_category` WHERE ( `status` = 1 ) AND `cr_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000292s ]