SHOW FULL COLUMNS FROM `cr_category` [ RunTime:0.001606s ]
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.001172s ]
SELECT * FROM `cr_article` WHERE `status` = 1 AND `type` IN ('help','page') ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `cr_product` [ RunTime:0.001259s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `slug` = 'kids-sanitary-wipes' ) AND `cr_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `cr_sku` [ RunTime:0.001109s ]
SELECT * FROM `cr_sku` WHERE ( `product_id` = 6 AND `status` = 1 ) AND `cr_sku`.`delete_time` = '0' ORDER BY `price` ASC [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `cr_product_image` [ RunTime:0.000936s ]
SELECT * FROM `cr_product_image` WHERE `product_id` = 6 AND `product_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000387s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `cr_product_attr` [ RunTime:0.000980s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 6 AND `product_id` = 6 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `cr_product_spec` [ RunTime:0.000906s ]
SELECT `spec_id` FROM `cr_product_spec` WHERE `product_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `cr_review` [ RunTime:0.001004s ]
SELECT rating, COUNT(*) AS n FROM `cr_review` WHERE `product_id` = 6 AND `status` = 1 GROUP BY `rating` [ RunTime:0.000449s ]
UPDATE `cr_product` SET `views` = `views` + 1 WHERE `id` = 6 [ RunTime:0.004115s ]
SELECT COUNT(*) AS think_count FROM `cr_review` WHERE `product_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.000283s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 2 AND `id` <> 6 ) AND `cr_product`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 4 [ RunTime:0.000444s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 5 AND `product_id` = 5 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000274s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000258s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 12 AND `product_id` = 12 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000256s ]