Query time 0.00129
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "12.20"
},
"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": "companies",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 5,
"rows_produced_per_join": 1,
"filtered": "20.00",
"cost_info": {
"read_cost": "3.05",
"eval_cost": "0.20",
"prefix_cost": "3.25",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo2`.`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": 5,
"rows_produced_per_join": 5,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.10",
"eval_cost": "1.00",
"prefix_cost": "5.35",
"data_read_per_join": "80"
},
"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_demo2.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.47",
"cost_info": {
"read_cost": "5.00",
"eval_cost": "0.05",
"prefix_cost": "11.35",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo2`.`products`.`company_id` = `atulecarter_atul_demo2`.`companies`.`company_id`) and (`atulecarter_atul_demo2`.`products`.`parent_product_id` = 0) and ((`atulecarter_atul_demo2`.`products`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo2`.`products`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo2`.`products`.`usergroup_ids`)) and (`atulecarter_atul_demo2`.`products`.`status` = 'A') and (`atulecarter_atul_demo2`.`products`.`product_type` <> 'D'))"
}
},
{
"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_demo2.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.27",
"eval_cost": "0.05",
"prefix_cost": "11.68",
"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_demo2.products_categories.product_id"
],
"rows_examined_per_scan": 4,
"rows_produced_per_join": 1,
"filtered": "98.35",
"using_index": true,
"cost_info": {
"read_cost": "0.30",
"eval_cost": "0.22",
"prefix_cost": "12.20",
"data_read_per_join": "25"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo2`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo2`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 107 |
Montblanc Classic Collection Money Clip |
CS-Cart test |
P |
0 |
<p>Platinum-plated money clip with black onyx inlay</p> |
| 109 |
Montblanc Contemporary Collection Key Ring with Montblanc emblem |
CS-Cart test |
P |
0 |
<p>Stainless steel key ring with brown calf leather</p> |
| 91 |
Montblanc Nicolas Rieussec Chronograph Automatic |
CS-Cart test |
P |
0 |
<p>43 mm watch with stainless steel case, Montblanc Calibre MB R200, monopusher chronograph with automatic winding, anthracite-coloured dial with applique hour circle, date display, second time zone with day/night display, chronograph counters with rotating discs.</p> |
| 92 |
Montblanc TimeWalker Automatic |
CS-Cart test |
P |
0 |
<p>42 mm stainless steel watch with black dial, red-gold plated hands and numerals, automatic movement, date display, black alligator-skin strap</p> |
| 102 |
PR 100 Women's White Quartz Watch |
CS-Cart test |
P |
0 |
<p>Unrivaled best seller that is true to its name, the PR 100 is certainly precise and hugely popular.<br /> <br /> A combination of tradition with up-to-the-minute looks using quality materials on the outside and Swiss reliability on the inside. This ironic watch family offers lady and gent sizes to prevent any rivalry, although as far as style is concerned, the race is on! The Swiss made quartz ETA movement has battery end-of-life indicator, a scratch resistant sapphire crystal and date indicator. Features include a stainless steel bracelet, a magnificent white dial, and water resistance up to 100 meters.</p> |