Query time 0.00143
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "22.96"
},
"ordering_operation": {
"using_filesort": false,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 1,
"filtered": "50.00",
"cost_info": {
"read_cost": "2.29",
"eval_cost": "0.20",
"prefix_cost": "2.49",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemfive`.`companies`.`status` = 'A')"
}
},
{
"table": {
"table_name": "variation_group_products",
"access_type": "index",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"group_id"
],
"key_length": "6",
"rows_examined_per_scan": 14,
"rows_produced_per_join": 5,
"filtered": "35.71",
"using_index": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "3.85",
"eval_cost": "1.00",
"prefix_cost": "7.34",
"data_read_per_join": "80"
},
"used_columns": [
"product_id",
"group_id"
],
"attached_condition": "(`pankajecarter_systemfive`.`variation_group_products`.`group_id` in (20,21))"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemfive.variation_group_products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.93",
"cost_info": {
"read_cost": "5.00",
"eval_cost": "0.09",
"prefix_cost": "13.34",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemfive`.`products`.`company_id` = `pankajecarter_systemfive`.`companies`.`company_id`) and ((`pankajecarter_systemfive`.`products`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemfive`.`products`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemfive`.`products`.`usergroup_ids`)) and (`pankajecarter_systemfive`.`products`.`status` = 'A') and (`pankajecarter_systemfive`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemfive.variation_group_products.product_id"
],
"rows_examined_per_scan": 11,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.68",
"eval_cost": "0.98",
"prefix_cost": "17.00",
"data_read_per_join": "78"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemfive.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "4.91",
"eval_cost": "0.05",
"prefix_cost": "22.89",
"data_read_per_join": "655"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`pankajecarter_systemfive`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemfive`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemfive`.`cscart_categories`.`usergroup_ids`)) and (`pankajecarter_systemfive`.`cscart_categories`.`status` in ('A','H')) and (`pankajecarter_systemfive`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"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": [
"pankajecarter_systemfive.variation_group_products.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.02",
"eval_cost": "0.05",
"prefix_cost": "22.96",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
}
]
}
}
}
}
Result
| product_id |
amount |
product |
company_name |
variation_group_id |
product_type |
parent_product_id |
full_description |
| 18 |
1 |
3D Blu-ray Disc™ Player (BD-D7000) |
CS-Cart |
20 |
V |
315 |
<p>Whether you are viewing a premium-quality 2D picture or seeing incredible 3D depth, images are breathtakingly real in Samsung Full HD. Combine with a 3D TV and 3D active shutter glasses to view the latest Hollywood 3D titles or amplify your viewing experience by upconverting 2D content to immersive 3D.</p> |
| 170 |
1 |
588 Chrome Wedge |
CS-Cart |
21 |
P |
0 |
<p>The 588 Forged wedge maintains the popular, tour-proven shape of its predecessor with a series of technological breakthroughs to provide even more performance. Every wedge is Precision Forged from 1025 carbon steel for incredibly soft, solid feel and the highest level of manufacturing consistency for supreme confidence and trust over every shot. Tour Zip Grooves™ and Laser Milled™ technology maximize spin in accordance with USGA regulations. Exclusive to the 588 Forged wedge is the Tour Concept Wedge steel shaft, co-developed and engineered by Cleveland Golf and industry leader True Temper. With a unique stiffness profile that features a less active tip, this shaft promotes a more penetrating ball flight, increased spin and optimal distance control along with superior feel. Choose from two different finishes – Satin and Chrome – as well as low, standard and high bounce options.</p> |
| 314 |
1 |
3D Blu-ray Disc™ Player (BD-D7000) |
CS-Cart |
20 |
V |
315 |
<p>Whether you are viewing a premium-quality 2D picture or seeing incredible 3D depth, images are breathtakingly real in Samsung Full HD. Combine with a 3D TV and 3D active shutter glasses to view the latest Hollywood 3D titles or amplify your viewing experience by upconverting 2D content to immersive 3D.</p> |
| 315 |
1 |
3D Blu-ray Disc™ Player (BD-D7000) |
CS-Cart |
20 |
P |
0 |
<p>Whether you are viewing a premium-quality 2D picture or seeing incredible 3D depth, images are breathtakingly real in Samsung Full HD. Combine with a 3D TV and 3D active shutter glasses to view the latest Hollywood 3D titles or amplify your viewing experience by upconverting 2D content to immersive 3D.</p> |
| 316 |
1 |
588 Chrome Wedge |
CS-Cart |
21 |
P |
0 |
<p>The 588 Forged wedge maintains the popular, tour-proven shape of its predecessor with a series of technological breakthroughs to provide even more performance. Every wedge is Precision Forged from 1025 carbon steel for incredibly soft, solid feel and the highest level of manufacturing consistency for supreme confidence and trust over every shot. Tour Zip Grooves™ and Laser Milled™ technology maximize spin in accordance with USGA regulations. Exclusive to the 588 Forged wedge is the Tour Concept Wedge steel shaft, co-developed and engineered by Cleveland Golf and industry leader True Temper. With a unique stiffness profile that features a less active tip, this shaft promotes a more penetrating ball flight, increased spin and optimal distance control along with superior feel. Choose from two different finishes – Satin and Chrome – as well as low, standard and high bounce options.</p> |