Query time 0.00104
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "9.53"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"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": "2K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.07",
"eval_cost": "0.80",
"prefix_cost": "1.88",
"data_read_per_join": "64"
},
"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": 1,
"filtered": "42.58",
"cost_info": {
"read_cost": "4.00",
"eval_cost": "0.34",
"prefix_cost": "6.67",
"data_read_per_join": "8K"
},
"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`.`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`.`company_id` in ('1','2','3','4','5','6')) and (`atulecarter_atul_demo1`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"atulecarter_atul_demo1.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "16.67",
"cost_info": {
"read_cost": "1.70",
"eval_cost": "0.06",
"prefix_cost": "8.72",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
}
},
{
"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.28",
"eval_cost": "0.06",
"prefix_cost": "9.06",
"data_read_per_join": "1K"
},
"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.30",
"eval_cost": "0.17",
"prefix_cost": "9.53",
"data_read_per_join": "19"
},
"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 |
| 170 |
588 Chrome Wedge |
CS-Cart |
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> |
| 177 |
CG BLACK DRIVER |
CS-Cart |
P |
0 |
<p>With a sleek and striking look, the CG Black driver weighs only 265 grams, making it the lightest driver on the market to help players generate measurable increases in swing speed and distance with the same swing effort. The advanced aerodynamics found in the driver’s Speed Crown Design – an innovative, teardrop-inspired crown profile – maximize distance by reducing drag at all angles of airflow during the swing. MaxCOR2 Variable Face Thickness Technology reduces face weight and increases trampoline effect on off-center hits, meaning higher ball speed and more distance on off-center hits. Plus, a high-density weight screw at the rear of the sole plate positions the center of gravity lower and deeper to promote a high, draw-biased trajectory with optimal launch conditions for effortless distance. The CG Black driver features a Miyazaki C. Kua 39 Limited Edition graphite shaft and a Golf Pride Ultralite grip, a combination that decreases overall club weight for faster swing speed.</p> |
| 179 |
CG16 Black Pearl Wedge |
CS-Cart |
P |
0 |
<div class="overviewbody">
<p>Based on the shape of the tour proven CG14<span style="font-size: 8pt;">™</span> wedge, the CG16<span style="font-size: 8pt;">™</span> has a hint of offset and is slightly larger for added forgiveness. The face features the same spin maximizing technology featured on the CG15<span style="font-size: 8pt;">™</span> wedge – Tour Zip Grooves<span style="font-size: 8pt;">™</span> in combination with Cleveland<span style="font-size: 8pt;">®</span> Golf’s breakthrough Laser Milled<span style="font-size: 8pt;">™ </span>surface roughness technology. Using the precision accuracy of a laser, each face features four perfectly calibrated texture lines milled between each groove exactly to the conforming roughness limit. This surface roughness application optimizes ball-to-face friction and maximizes spin within the Rules of Golf.</p>
</div> |
| 181 |
Women's Bloom Complete Set |
CS-Cart |
P |
0 |
<p>Created for women golfers looking to improve their game, the Bloom 14 Piece set covers all of her equipment needs. Designed specifically for her swing, the 100% titanium Driver and Stainless Steel Fairway woods are designed with today’s modern lightweight and oversized technology to drastically increase distance and consistency-particularly on mishits. The hybrid long irons are hollow and extremely forgiving and are packaged together with the short game simplifying NIBLICK – to make the game even easier to learn. If that isn’t enough, the classically designed mini boot bag has retro details yet modern convenience with ample pocket space and detachable wristlet.</p> |