SHOW FULL COLUMNS FROM `cr_category` [ RunTime:0.001492s ]
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.000598s ]
SHOW FULL COLUMNS FROM `cr_article` [ RunTime:0.001151s ]
SELECT * FROM `cr_article` WHERE `status` = 1 AND `type` IN ('help','page') ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `cr_product` [ RunTime:0.001243s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `slug` = 'flushable-wipes-mini' ) AND `cr_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `cr_sku` [ RunTime:0.001130s ]
SELECT * FROM `cr_sku` WHERE ( `product_id` = 9 AND `status` = 1 ) AND `cr_sku`.`delete_time` = '0' ORDER BY `price` ASC [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `cr_product_image` [ RunTime:0.000912s ]
SELECT * FROM `cr_product_image` WHERE `product_id` = 9 AND `product_id` = 9 ORDER BY `sort` ASC [ RunTime:0.000357s ]
SELECT * FROM `cr_category` WHERE ( `id` = 5 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `cr_product_attr` [ RunTime:0.000967s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 9 AND `product_id` = 9 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `cr_product_spec` [ RunTime:0.000914s ]
SELECT `spec_id` FROM `cr_product_spec` WHERE `product_id` = 9 ORDER BY `sort` ASC [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `cr_review` [ RunTime:0.001006s ]
SELECT rating, COUNT(*) AS n FROM `cr_review` WHERE `product_id` = 9 AND `status` = 1 GROUP BY `rating` [ RunTime:0.000413s ]
UPDATE `cr_product` SET `views` = `views` + 1 WHERE `id` = 9 [ RunTime:0.004049s ]
SELECT COUNT(*) AS think_count FROM `cr_review` WHERE `product_id` = 9 AND `status` = 1 LIMIT 1 [ RunTime:0.000312s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 5 AND `id` <> 9 ) AND `cr_product`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 4 [ RunTime:0.000414s ]