SHOW FULL COLUMNS FROM `cr_category` [ RunTime:0.001522s ]
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.000553s ]
SHOW FULL COLUMNS FROM `cr_article` [ RunTime:0.001156s ]
SELECT * FROM `cr_article` WHERE `status` = 1 AND `type` IN ('help','page') ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `cr_product` [ RunTime:0.001236s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `slug` = 'kitchen-cleaning-wipes' ) AND `cr_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `cr_sku` [ RunTime:0.001101s ]
SELECT * FROM `cr_sku` WHERE ( `product_id` = 7 AND `status` = 1 ) AND `cr_sku`.`delete_time` = '0' ORDER BY `price` ASC [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `cr_product_image` [ RunTime:0.000943s ]
SELECT * FROM `cr_product_image` WHERE `product_id` = 7 AND `product_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000364s ]
SELECT * FROM `cr_category` WHERE ( `id` = 4 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `cr_product_attr` [ RunTime:0.000972s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 7 AND `product_id` = 7 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `cr_product_spec` [ RunTime:0.000898s ]
SELECT `spec_id` FROM `cr_product_spec` WHERE `product_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `cr_review` [ RunTime:0.001002s ]
SELECT rating, COUNT(*) AS n FROM `cr_review` WHERE `product_id` = 7 AND `status` = 1 GROUP BY `rating` [ RunTime:0.000409s ]
UPDATE `cr_product` SET `views` = `views` + 1 WHERE `id` = 7 [ RunTime:0.004138s ]
SELECT COUNT(*) AS think_count FROM `cr_review` WHERE `product_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.000286s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 4 AND `id` <> 7 ) AND `cr_product`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 4 [ RunTime:0.000419s ]
