Query time 0.00145
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "15.85"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status",
"company"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 6,
"rows_produced_per_join": 0,
"filtered": "4.00",
"index_condition": "(`atulecarter_atul_demo1`.`cscart_categories`.`category_id` in (177,178,179,180,181,182))",
"cost_info": {
"read_cost": "14.36",
"eval_cost": "0.05",
"prefix_cost": "14.41",
"data_read_per_join": "641"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids`)) and (`atulecarter_atul_demo1`.`cscart_categories`.`status` in ('A','H')) and (`atulecarter_atul_demo1`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.cscart_categories.category_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.14",
"prefix_cost": "14.81",
"data_read_per_join": "11"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.52",
"cost_info": {
"read_cost": "0.72",
"eval_cost": "0.01",
"prefix_cost": "15.67",
"data_read_per_join": "300"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products`.`parent_product_id` = 0) and (`atulecarter_atul_demo1`.`products`.`company_id` = 1) and ((`atulecarter_atul_demo1`.`products`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo1`.`products`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo1`.`products`.`usergroup_ids`)) and (`atulecarter_atul_demo1`.`products`.`status` = 'A') and (`atulecarter_atul_demo1`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"atulecarter_atul_demo1.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.06",
"eval_cost": "0.01",
"prefix_cost": "15.74",
"data_read_per_join": "286"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "97.36",
"using_index": true,
"cost_info": {
"read_cost": "0.07",
"eval_cost": "0.04",
"prefix_cost": "15.85",
"data_read_per_join": "4"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 147 |
Sansa Clip+ MP3 Player (Red) - 4GB |
CS-Cart |
P |
0 |
<p>Small but powerful, the Sansa Clip+ is a tiny MP3 player that boasts an array of cool features, as well as distinctively big sound for its small size. Rock out with up to 1,000 songs on this red player. Enjoy even more play when you use the expandable memory slot to play preloaded microSDHC cards. slotRadio and slotMusic cards are preloaded with tunes ready to pop into the player’s memory card slot. Rock on with a 15-hour battery life.</p> |
| 157 |
Studio Monitor Headphones |
CS-Cart |
P |
0 |
<p>Love at first listen. Striking yet comfortable studio monitor headphones with neodymium magnets deliver sounds even the most discerning of audiophiles will flip for.</p> |
| 153 |
UR55 Full Size Headphones |
CS-Cart |
P |
0 |
<p>Slipping into a set of lightweight, professional headphones like the Koss UR55 studio headphones is like listening to a live musical performance at a spacious outdoor venue. These high velocity headphones feature open-screen ear cups that deliver great sound, lasting comfort, and impressive air circulation. <br /><br />Designed to deliver equal parts sound quality and comfort, Koss UR55s bump with massive bass while their lightweight foam ear cushions are enough to convince you it’s just you and the music. A padded sling with a sturdy metal headband reinforcement provides extreme durability, while the swivel ear cups encourage maximum flexibility, single-ear listening and convenient storage.</p> |
| 140 |
Yamaha PDX-11 DB |
CS-Cart |
P |
0 |
<p>This easy-to-carry, powerful speaker system frees your iPod/iPhone music for your active lifestyle. Enjoy your entire content library whenever you want, wherever you go.</p> |
| 141 |
Yamaha PDX-11 GR |
CS-Cart |
P |
0 |
<p>This easy-to-carry, powerful speaker system frees your iPod/iPhone music for your active lifestyle. Enjoy your entire content library whenever you want, wherever you go.</p> |
| 144 |
Yamaha PDX-30BU |
CS-Cart |
P |
0 |
<p>A certified "works with iPhone" Desktop Audio product that every iPhone or iPod fan who wants to enjoy a higher sound quality with a powerful output needs to have! The PDX-30 includes a card-type remote control for additional convenience.</p> |
| 143 |
Yamaha PDX-30PI |
CS-Cart |
P |
0 |
<p>A certified "works with iPhone" Desktop Audio product that every iPhone or iPod fan who wants to enjoy a higher sound quality with a powerful output needs to have! The PDX-30 includes a card-type remote control for additional convenience.</p> |
| 142 |
Yamaha TSX-130WH |
CS-Cart |
P |
0 |
<p>Enjoy music from all your favorite sources with this attractive all-in-one audio system.</p> |