Query time 0.00177
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.10"
},
"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": "range",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 3,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.05",
"eval_cost": "0.60",
"prefix_cost": "1.65",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products_categories`.`category_id` = 209) and (`atulecarter_atul_demo1`.`products_categories`.`product_id` <> 127))"
}
},
{
"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": "17.03",
"cost_info": {
"read_cost": "3.00",
"eval_cost": "0.10",
"prefix_cost": "5.25",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products`.`parent_product_id` = 0) and ((`atulecarter_atul_demo1`.`products`.`amount` > 0) or (`atulecarter_atul_demo1`.`products`.`tracking` = 'D')) 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": "0.51",
"eval_cost": "0.02",
"prefix_cost": "5.87",
"data_read_per_join": "613"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
}
},
{
"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": "29.30",
"using_index": true,
"cost_info": {
"read_cost": "0.09",
"eval_cost": "0.01",
"prefix_cost": "6.01",
"data_read_per_join": "1"
},
"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)))"
}
},
{
"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.07",
"eval_cost": "0.01",
"prefix_cost": "6.10",
"data_read_per_join": "349"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 131 |
Catania |
CS-Cart |
P |
0 |
<p class="MsoPlainText">The new Catania features carbon fork, carbon seatpost, Ultegra derailleur, and the new Fezzari Racing Design R3A frame with increased aerodynamic properties and a sleeker look.</p>
<p class="MsoPlainText">The Catania road bike is a great all-around bike. If you want to get into road biking or want a bike that is durable, high-performing, and as comfortable as a road bike can get, the Catania is for you.</p>
<p class="MsoPlainText">The Catania features the R3A frame with compact geometry. Compact geometry means that we shorten the seat tube slightly, which makes the bike a little lighter and reduces lateral flex (you don’t want your bike flexing side to side when you’re pedaling). It also allows your riding position to be a little more upright.</p>
<p class="MsoPlainText">Add to that a great set of components, including: Shimano Ultegra derailleur and Shimano 105 shifters for smooth shifting Fezzari Carbon II fork to minimize the road chatter; FSA Gossamer crank with external oversized bearings that make it pedal smoother and more efficiently; Alex double-wall rims that are extremely durable; Maxxis performance tires; and a Fezzari Racing Design Ultra XR saddle that is one of the most comfortable road saddles you’ll ride.</p> |
| 129 |
Fore CR1 |
CS-Cart |
P |
0 |
<p>Take your riding to the next level with the Foré CR1 full carbon road bike, built to be extremely durable and responsive. Feel the adrenalin rush as it accelerates smoothly and corners aggressively. Great for cross-country riding, a triathlon, and even a race. The new Fezzari Fore CR1 is the newest bike to the Fezzari carbon road bike family. It has the same tried and true monocoque carbon frame as the Fore CR2, but is built with a Shimano 105/Ultegra groupo to help save a little on the price.</p>
<p>Start with a proprietary Fezzari Racing Design Xr4 monocoque carbon frame that was recently tested as one of the most durable frames on the market.</p>
<p>All this translates into exhilaration when you’re climbing – knowing that you’re ascending more efficiently – and confidence on the downhill when you take that corner at high speeds. Our proprietrary frame painting process give one of the best looking finishes available.</p>
<p>You get e upgrades over the Catania:</p>
<ol>
<li> <strong>Upgraded Frame</strong> – the CR1 has a full monocoque carbon frame vs the Catania’s aluminum alloy frame. The carbon frame is lighter and will absorb more of the road chatter when riding.</li>
<li> <strong>Upgraded Seatpost</strong> – the larger diameter 31.6mm seatpost is stiffer and lighter.</li>
<li> <strong>Upgraded Wheels</strong> – The CR1 gets a lighter and more aero dynamic wheel whith looks to go with it.</li>
</ol>
<p>Who will want this bike? If you’ve been biking and plan to get into it more, and you want to get something that will grow with you as you grow in the sport (but you’re not willing to pay the price of a CR3 or CR5), then this is the bike for you. It gets you on a full monocoque carbon fiber frame and still gives you the confidence you won't miss a shift with the Shimano 105/Ultegra drivetrain. You’ll have the confidence that you can ride with anyone, anytime.</p> |