Query time 0.00121
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "37.45"
},
"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": "3K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
]
}
},
{
"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": "8K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemsix`.`companies`.`status` = 'A')"
}
},
{
"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": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.25",
"eval_cost": "2.20",
"prefix_cost": "5.94",
"data_read_per_join": "176"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "var_val_18",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
],
"key_length": "15",
"ref": [
"const",
"pankajecarter_systemsix.products_categories.product_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 11,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "11.00",
"eval_cost": "2.20",
"prefix_cost": "19.14",
"data_read_per_join": "8K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"lang_code"
]
}
},
{
"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": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.53",
"cost_info": {
"read_cost": "11.00",
"eval_cost": "0.19",
"prefix_cost": "32.34",
"data_read_per_join": "5K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`products`.`company_id` = `pankajecarter_systemsix`.`companies`.`company_id`) and (`pankajecarter_systemsix`.`products`.`parent_product_id` = 0) and ((`pankajecarter_systemsix`.`products`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemsix`.`products`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemsix`.`products`.`usergroup_ids`)) and (`pankajecarter_systemsix`.`products`.`status` = 'A') and (`pankajecarter_systemsix`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "epd",
"access_type": "ALL",
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "33.33",
"not_exists": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "2.44",
"eval_cost": "0.19",
"prefix_cost": "34.97",
"data_read_per_join": "37"
},
"used_columns": [
"product_id"
],
"attached_condition": "(<if>(found_match(epd), isnull(`pankajecarter_systemsix`.`epd`.`product_id`), true) and <if>(is_not_null_compl(epd), (`pankajecarter_systemsix`.`epd`.`product_id` = `pankajecarter_systemsix`.`products_categories`.`product_id`), true))"
}
},
{
"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_systemsix.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.94",
"eval_cost": "0.19",
"prefix_cost": "36.09",
"data_read_per_join": "4K"
},
"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": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 1,
"filtered": "92.52",
"using_index": true,
"cost_info": {
"read_cost": "0.98",
"eval_cost": "0.35",
"prefix_cost": "37.45",
"data_read_per_join": "41"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`prices`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 172 |
Compact Full HD Camcorder |
CS-Cart |
P |
0 |
<p>
The T10 camcorder was designed to capture memories in comfort and in style. It boasts an ultra compact size, alightweight body and a brushed metal finish creating a subtle but sophisticated look and feel. In fact, its smooth curves fit so comfortably in your hand, it makes shooting video for longer periods of time more enjoyable
</p> |
| 175 |
F50 Flash Memory 52x Zoom Camcorder (Silver) |
CS-Cart |
P |
0 |
<p>2.7” LCD Touch Panel display gives you a clearer picture of what you are shooting. By leveraging the latest in LCD display technology, the Touch Panel delivers clean, crisp images that are saturated with natural color and deep, dynamic detail, enabling you to shoot with enhanced comfort and confidence in any external light condition.</p> |
| 173 |
H300 Long Zoom Compact Full HD Camcorder (Black) |
CS-Cart |
P |
0 |
<p>3.0" LCD Touch Panel display gives you a clearer picture of what you are shooting. By leveraging the latest in LCD display technology, the Touch Panel delivers clean, crisp images that are saturated with natural color and deep, dynamic detail, enabling you to shoot with enhanced comfort and confidence in any external light condition. With the large 3.0" display, it’s much easier to browse through content and find the exact features you’re looking for. Most useful, the extra large LCD screen makes it easier to select the features you need.</p> |
| 161 |
MV800 16.1 Megapixel MultiView Compact Digital Camera |
CS-Cart |
P |
0 |
<p>The 3.0" Flip-Out Display lets you take and view great pictures from multiple angles. Easily adjust the LCD from 0 to 180 degrees and make any shot possible. Snap a picture over a crowd or get waist-level candids of kids and pets, or spin the display for perfectly framed self-portraits. Choose from 3 shutter options to comfortably snap pics from any position.</p> |
| 163 |
NX200 20.3 Megapixel Compact System Camera |
CS-Cart |
P |
0 |
<p>Capture every moment in true-to-life quality. With the best-in-class resolution of the extra large 20.3 MP APS-C CMOS sensor, shots are rich, deep and exquisitely detailed. For active subjects, stills can be captured beautifully with 7fps Continuous Shot/100ms AF Speed. Then review your shot on the large 3.0” AMOLED display—made for sharper images and glare reduction.</p> |
| 164 |
WB210 10MB 14 Megapixel Slim Digital Camera (Red) |
CS-Cart |
P |
0 |
<p>When shooting in low light, zooming in on a shot, or when your camera is unsteady, Optical Image Stabilization helps eliminate blurry results. This feature stabilizes your photos by changing their path to the image sensor before they are recorded digitally. Your photos come out sharp and ideally focused.</p> |