mysql优化级别range和ref_mysql优化利器之explain使用介绍

一、语法

{EXPLAIN | DESCRIBE | DESC}

tbl_name [col_name | wild]

{EXPLAIN | DESCRIBE | DESC}

[explain_type] SELECT select_options

explain_type: {EXTENDED | PARTITIONS}

二、数据库准备

表一：

DROP TABLE IF EXISTS `products`;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `products` (

`products_id` int(11) unsigned NOT NULL auto_increment,

`products_type` int(11) unsigned NOT NULL default '1',

`products_quantity` float NOT NULL default '0',

`products_model` varchar(32) default NULL,

`products_upc` varchar(32) default NULL,

`products_isbn` varchar(32) default NULL,

`products_image` varchar(128) default NULL,

`products_image_thumbnail` varchar(200) NOT NULL，

`products_price` decimal(15,4) NOT NULL default '0.0000',

`products_virtual` tinyint(1) NOT NULL default '0',

`products_date_added` datetime NOT NULL default '0001-01-01 00:00:00',

`products_last_modified` datetime default NULL,

`products_date_available` datetime default NULL,

`products_weight` float NOT NULL default '0',

`products_status` tinyint(1) NOT NULL default '0',

`products_tax_class_id` int(11) NOT NULL default '0',

`manufacturers_id` int(11) default NULL,

`products_web_id` int(11) default NULL,

`products_ordered` float NOT NULL default '0',

`products_quantity_order_min` float NOT NULL default '1',

`products_quantity_order_units` float NOT NULL default '1',

`products_priced_by_attribute` tinyint(1) NOT NULL default '0',

`product_is_free` tinyint(1) NOT NULL default '0',

`product_is_call` tinyint(1) NOT NULL default '0',

`products_quantity_mixed` tinyint(1) NOT NULL default '0',

`product_is_always_free_shipping` tinyint(1) NOT NULL default '0',

`products_qty_box_status` tinyint(1) NOT NULL default '1',

`products_quantity_order_max` float NOT NULL default '