SHOW FULL COLUMNS FROM `cr_category` [ RunTime:0.001516s ]
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.000609s ]
SHOW FULL COLUMNS FROM `cr_article` [ RunTime:0.001170s ]
SELECT * FROM `cr_article` WHERE `status` = 1 AND `type` IN ('help','page') ORDER BY `sort` ASC LIMIT 4 [ RunTime:0.000546s ]
SHOW FULL COLUMNS FROM `cr_product` [ RunTime:0.001266s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `slug` = 'asdasd' ) AND `cr_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `cr_sku` [ RunTime:0.001126s ]
SELECT * FROM `cr_sku` WHERE ( `product_id` = 12 AND `status` = 1 ) AND `cr_sku`.`delete_time` = '0' ORDER BY `price` ASC [ RunTime:0.000769s ]
SHOW FULL COLUMNS FROM `cr_product_image` [ RunTime:0.001488s ]
SELECT * FROM `cr_product_image` WHERE `product_id` = 12 AND `product_id` = 12 ORDER BY `sort` ASC [ RunTime:0.000750s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `cr_product_attr` [ RunTime:0.001067s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 12 AND `product_id` = 12 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `cr_product_spec` [ RunTime:0.001448s ]
SELECT `spec_id` FROM `cr_product_spec` WHERE `product_id` = 12 ORDER BY `sort` ASC [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `cr_sku_spec_value` [ RunTime:0.001307s ]
SELECT `ssv`.`spec_value_id` FROM `cr_sku_spec_value` `ssv` INNER JOIN `cr_sku` `s` ON `ssv`.`sku_id`=`s`.`id` WHERE `s`.`product_id` = '12' AND `s`.`status` = '1' AND `s`.`delete_time` = '0' [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `cr_spec` [ RunTime:0.001379s ]
SELECT * FROM `cr_spec` WHERE `id` IN (1,2,3,6) ORDER BY `sort` ASC [ RunTime:0.000631s ]
SHOW FULL COLUMNS FROM `cr_spec_value` [ RunTime:0.001418s ]
SELECT * FROM `cr_spec_value` WHERE `spec_id` IN (1,2,3,6) AND `id` IN (1,4,7,15,5,2,14) ORDER BY `sort` ASC [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `cr_review` [ RunTime:0.001521s ]
SELECT rating, COUNT(*) AS n FROM `cr_review` WHERE `product_id` = 12 AND `status` = 1 GROUP BY `rating` [ RunTime:0.000947s ]
UPDATE `cr_product` SET `views` = `views` + 1 WHERE `id` = 12 [ RunTime:0.005666s ]
SELECT COUNT(*) AS think_count FROM `cr_review` WHERE `product_id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.000346s ]
SELECT * FROM `cr_product` WHERE ( `status` = 1 AND `category_id` = 2 AND `id` <> 12 ) AND `cr_product`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 4 [ RunTime:0.000500s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000293s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 5 AND `product_id` = 5 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000285s ]
SELECT * FROM `cr_category` WHERE ( `id` = 2 ) AND `cr_category`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000265s ]
SELECT * FROM `cr_product_attr` WHERE `product_id` = 6 AND `product_id` = 6 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000267s ]