Query time 0.00138
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.34"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"units_in_product",
"show_price_per_x_units",
"is_mobilede",
"seller_id",
"mdc_product_id"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`danishecarter_25_march`.`cscart_product_prices`.`lower_limit` = 1) and (`danishecarter_25_march`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"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": "1.40",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"unit_name"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "1.60",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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": "1.80",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`danishecarter_25_march`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "3.00",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"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": [
"danishecarter_25_march.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.20",
"data_read_per_join": "172"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`danishecarter_25_march`.`cscart_categories`.`storefront_id` in (0,1)) and ((`danishecarter_25_march`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`danishecarter_25_march`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`danishecarter_25_march`.`cscart_categories`.`usergroup_ids`)) and (`danishecarter_25_march`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.26",
"data_read_per_join": "86"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": [
"unique_key",
"src_k"
],
"key": "unique_key",
"used_key_parts": [
"lower_limit",
"usergroup_id",
"product_id"
],
"key_length": "8",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.32",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(point_prices), 1, true) and <if>(is_not_null_compl(point_prices), ((`danishecarter_25_march`.`point_prices`.`lower_limit` = 1) and (`danishecarter_25_march`.`point_prices`.`product_id` = 127) and (`danishecarter_25_march`.`point_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.33",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.34",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
is_mobilede |
seller_id |
mdc_product_id |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
| 127 |
A0127P1V0T |
P |
A |
1 |
0.00 |
10 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328644800 |
1328690720 |
0 |
N |
N |
N |
|
N |
|
Y |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
6 |
N |
0 |
|
|
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
0.000 |
1.000 |
N |
0 |
0 |
en |
Fore CR5 SRAM Red |
|
|
<p>An all new frame and new graphics package make the Fore CR5 look as fast as it really is. Now available with SRAM Red componants.</p>
<p>What do you get when you interview hundreds of riders, questioning them about their desires for the ultimate road bike and then, spend thousands of hours translating those ideas into reality? A dream come true. We call it the Fezzari Foré CR5. It is the pinnacle of road bike performance. From its all new state of the art, proprietary Fezzari Racing Design Xr7 3K monocoque carbon frame to its best-of-market components, the Foré CR5 is THE ultimate road bike. Our designers and engineers didn't cut corners.<br /> <br /> Take, for instance, the state of the art proprietary Fezzari Racing Design Xr7 3K monocoque carbon fiber frame. We used the highest grade of carbon fiber available on the market. We made it even stiffer laterally by enlarging the bottom bracket shell and adding the BB30 bottom bracket/crank design, strengthening the headtube and making it more laterally stiff by enlarging the diameter to a 1.5" tapered design. We've also enlarged the seatstays near the rear axle for more lateral rigidity. We made the Xr7 frame even more vertically compliant for those rides on the cobblestones. We've done this by using an oval design in our top tube and down tube. The new Xr7 frame is even more aerodynamic than before with the new F4 ultralight bladed carbon fork and internal cable routing on the top tube. The Xr7 frame was recently tested to be one of the most durable frames on the market, and it weighs a mere 900 grams. Strength, lightweight, rigidity where you need it most, and flexible enough to take the edge off of rough roads -- it's the perfect frame for anyone who wants to get the most out of their riding experience.<br /> <br /> Next, take a look at the perfect blend of components. The Fore CR5 includes SRAM Red components shifters, brakes and derraileurs, FSA K-Force Light BB30 Carbon Crankset, Fezzari F4 XrT 3K carbon ultralite bladed carbon fork with carbon steerer tube, FSA K-Force compact carbon bars, FSA K- Force carbon seat post, and even carbon spacers on the headset.<br /> <br /> Finally, add the new sleek graphics and logos and you have--the ultimate road ride.<br /> <br /> You get the following upgrades over the CR3:</p>
<ol>
<li> <strong>Upgraded Frameset</strong> – from the Xr5 to the new Xr7 frame, more lateral stiffness with a BB30 crank system, enlarged headtube for better cornering, and sprinting, added rigidity in the rear triangle, increased aerodynamics with the new F4 bladed fork design and internal cable routing.</li>
<li> <strong>Upgraded Shifters</strong> – from Shimano Ultegra to the flagship SRAM Red, for smoother, more precise shifting</li>
<li> <strong>Upgraded Front Derailleur</strong> – from Shimano Ultegra to SRAM Red, which is lighter and smoother</li>
<li> <strong>Upgraded Cassette</strong> – from Shimano Ultegra to SRAM Red</li>
<li> <strong>Upgraded Crankset</strong> – from FSA SLK Light to FSA K-Force Light, which is lighter</li>
<li> <strong>Upgraded Chain</strong> – from Shimano Ultegra to SRAM Red</li>
<li> <strong>Upgraded Wheelset</strong> – Mavic Ksyrium SL, which are lighter,stiffer, faster, and perform better</li>
<li> <strong>Upgraded Brakes</strong> – from Shimano Ultegra to SRAM Red, which are lighter and smoother</li>
<li> <strong>Upgraded Seatpost- </strong>The FSA K-force light seatpost is one of the lightest on the market. It also completes the graphics package complimenting the crank and handle bar.</li>
</ol>
<p>When you get a Foré CR5, we custom fit it for you through our 23-Point Custom Setup program. We’ll get your specific body measurements so we can outfit your bike to fit you perfectly. You'll have the rest of the peloton envious of your ride.</p> |
|
|
|
|
|
<p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p> |
|
4779.00000000 |
209M |
18 |
CS-Cart |
|
fore-cr5-sram-red |
203/204/209 |
|
|
|
|