Query time 0.00200
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.70"
},
"ordering_operation": {
"using_filesort": false,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "inventory",
"access_type": "system",
"possible_keys": [
"pc"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "976"
},
"used_columns": [
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "variation_group_products",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "4",
"rows_examined_per_scan": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"index_condition": "(`portal`.`variation_group_products`.`group_id` in (59,60,61,62,58,48,29,42,21,22))",
"cost_info": {
"read_cost": "53.21",
"eval_cost": "7.20",
"prefix_cost": "60.41",
"data_read_per_join": "576"
},
"used_columns": [
"product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"portal.variation_group_products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 33,
"filtered": "93.11",
"index_condition": "(`portal`.`variation_group_products`.`product_id` = `portal`.`products`.`product_id`)",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "6.70",
"prefix_cost": "67.61",
"data_read_per_join": "197K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((case `portal`.`products`.`tracking` when 'O' then <cache>((NULL > 0)) when 'B' then (`portal`.`products`.`amount` > 0) else 1 end) and ((`portal`.`products`.`usergroup_ids` = '') or find_in_set(0,`portal`.`products`.`usergroup_ids`) or find_in_set(1,`portal`.`products`.`usergroup_ids`)) and (`portal`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"portal.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "10.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.67",
"prefix_cost": "74.31",
"data_read_per_join": "18K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`portal`.`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": [
"portal.products.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.67",
"prefix_cost": "74.98",
"data_read_per_join": "12K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
},
{
"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": [
"portal.variation_group_products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "99.95",
"using_index": true,
"cost_info": {
"read_cost": "3.35",
"eval_cost": "0.67",
"prefix_cost": "79.01",
"data_read_per_join": "80"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`portal`.`prices`.`lower_limit` = 1) and (`portal`.`prices`.`product_id` = `portal`.`products`.`product_id`) and (`portal`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"portal.variation_group_products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "100.00",
"index_condition": "(`portal`.`products_categories`.`product_id` = `portal`.`products`.`product_id`)",
"cost_info": {
"read_cost": "3.35",
"eval_cost": "0.67",
"prefix_cost": "83.03",
"data_read_per_join": "53"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "q_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"portal.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "20.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.13",
"prefix_cost": "83.70",
"data_read_per_join": "1K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`portal`.`q_categories`.`usergroup_ids` = '') or find_in_set(0,`portal`.`q_categories`.`usergroup_ids`) or find_in_set(1,`portal`.`q_categories`.`usergroup_ids`)) and (`portal`.`q_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
variation_group_id |
product_type |
parent_product_id |
2388 |
Y&D Bodycon Workwear Deep V Neck Dress For Women |
J D F General Trading LLC |
21 |
P |
0 |
2505 |
Y&D Bodycon Workwear Deep V Neck Dress For Women |
J D F General Trading LLC |
21 |
V |
2388 |
2391 |
Y&D V Neck Long Sleeve Elegant Dress |
J D F General Trading LLC |
22 |
P |
0 |
2507 |
Y&D V Neck Long Sleeve Elegant Dress |
J D F General Trading LLC |
22 |
V |
2391 |
2802 |
Y&D Fashion Floral Pattern Maxi Long Dress For Women, Black |
J D F General Trading LLC |
29 |
P |
0 |
2894 |
Y&D Fashion Floral Pattern Maxi Long Dress For Women, Black |
J D F General Trading LLC |
29 |
V |
2802 |
2895 |
Y&D Fashion Floral Pattern Maxi Long Dress For Women, Black |
J D F General Trading LLC |
29 |
V |
2802 |
2896 |
Y&D Fashion Floral Pattern Maxi Long Dress For Women, Black |
J D F General Trading LLC |
29 |
V |
2802 |
2897 |
Y&D Fashion Floral Pattern Maxi Long Dress For Women, Black |
J D F General Trading LLC |
29 |
V |
2802 |
2808 |
Women's Aline Dress Round Neck Half Sleeve Hollow-Out Decor Floral Pattern Lace Mid Calf Dress |
J D F General Trading LLC |
42 |
P |
0 |
3372 |
Women's Aline Dress Round Neck Half Sleeve Hollow-Out Decor Floral Pattern Lace Mid Calf Dress |
J D F General Trading LLC |
42 |
V |
2808 |
3373 |
Women's Aline Dress Round Neck Half Sleeve Hollow-Out Decor Floral Pattern Lace Mid Calf Dress |
J D F General Trading LLC |
42 |
V |
2808 |
3374 |
Women's Aline Dress Round Neck Half Sleeve Hollow-Out Decor Floral Pattern Lace Mid Calf Dress |
J D F General Trading LLC |
42 |
V |
2808 |
3375 |
Women's Aline Dress Round Neck Half Sleeve Hollow-Out Decor Floral Pattern Lace Mid Calf Dress |
J D F General Trading LLC |
42 |
V |
2808 |
3012 |
Y&D Mid Calf Shirt Neck Solid Pattern Full Sleeve Dress For Women Gold Color |
J D F General Trading LLC |
48 |
P |
0 |
5926 |
Y&D Mid Calf Shirt Neck Solid Pattern Full Sleeve Dress For Women Gold Color |
J D F General Trading LLC |
48 |
V |
3012 |
5927 |
Y&D Mid Calf Shirt Neck Solid Pattern Full Sleeve Dress For Women Gold Color |
J D F General Trading LLC |
48 |
V |
3012 |
5928 |
Y&D Mid Calf Shirt Neck Solid Pattern Full Sleeve Dress For Women Gold Color |
J D F General Trading LLC |
48 |
V |
3012 |
5929 |
Y&D Mid Calf Shirt Neck Solid Pattern Full Sleeve Dress For Women Gold Color |
J D F General Trading LLC |
48 |
V |
3012 |
3007 |
Y&D Mid Calf Round Neck Solid Pattern Full Sleeve Dress For Women Black Color |
J D F General Trading LLC |
58 |
P |
0 |
6089 |
Y&D Mid Calf Round Neck Solid Pattern Full Sleeve Dress For Women Black Color |
J D F General Trading LLC |
58 |
V |
3007 |
6090 |
Y&D Mid Calf Round Neck Solid Pattern Full Sleeve Dress For Women Black Color |
J D F General Trading LLC |
58 |
V |
3007 |
6091 |
Y&D Mid Calf Round Neck Solid Pattern Full Sleeve Dress For Women Black Color |
J D F General Trading LLC |
58 |
V |
3007 |
6092 |
Y&D Mid Calf Round Neck Solid Pattern Full Sleeve Dress For Women Black Color |
J D F General Trading LLC |
58 |
V |
3007 |
2988 |
Y&D Maxi Round Neck Dress For Women White Color |
J D F General Trading LLC |
59 |
P |
0 |
6094 |
Y&D Maxi Round Neck Dress For Women White Color |
J D F General Trading LLC |
59 |
V |
2988 |
6095 |
Y&D Maxi Round Neck Dress For Women White Color |
J D F General Trading LLC |
59 |
V |
2988 |
6096 |
Y&D Maxi Round Neck Dress For Women White Color |
J D F General Trading LLC |
59 |
V |
2988 |
2992 |
Y&D Mid Calf Shirt Neck Floral Pattern Full Sleeve Dress For Women Multi Color |
J D F General Trading LLC |
60 |
P |
0 |
6098 |
Y&D Mid Calf Shirt Neck Floral Pattern Full Sleeve Dress For Women Multi Color |
J D F General Trading LLC |
60 |
V |
2992 |
6099 |
Y&D Mid Calf Shirt Neck Floral Pattern Full Sleeve Dress For Women Multi Color |
J D F General Trading LLC |
60 |
V |
2992 |
6100 |
Y&D Mid Calf Shirt Neck Floral Pattern Full Sleeve Dress For Women Multi Color |
J D F General Trading LLC |
60 |
V |
2992 |
6101 |
Y&D Mid Calf Shirt Neck Floral Pattern Full Sleeve Dress For Women Multi Color |
J D F General Trading LLC |
60 |
V |
2992 |
2997 |
Y&D Maxi Shirt Neck Animal Print Pattern Full Sleeve Straight Dress For Women Multi Color |
J D F General Trading LLC |
61 |
P |
0 |
6103 |
Y&D Maxi Shirt Neck Animal Print Pattern Full Sleeve Straight Dress For Women Multi Color |
J D F General Trading LLC |
61 |
V |
2997 |
6104 |
Y&D Maxi Shirt Neck Animal Print Pattern Full Sleeve Straight Dress For Women Multi Color |
J D F General Trading LLC |
61 |
V |
2997 |
6105 |
Y&D Maxi Shirt Neck Animal Print Pattern Full Sleeve Straight Dress For Women Multi Color |
J D F General Trading LLC |
61 |
V |
2997 |
6106 |
Y&D Maxi Shirt Neck Animal Print Pattern Full Sleeve Straight Dress For Women Multi Color |
J D F General Trading LLC |
61 |
V |
2997 |
3002 |
Y&D Maxi Length Shirt Neck Print Pattern Full Sleeve Casual Dress For Women Multi Color |
J D F General Trading LLC |
62 |
P |
0 |
6108 |
Y&D Maxi Length Shirt Neck Print Pattern Full Sleeve Casual Dress For Women Multi Color |
J D F General Trading LLC |
62 |
V |
3002 |
6109 |
Y&D Maxi Length Shirt Neck Print Pattern Full Sleeve Casual Dress For Women Multi Color |
J D F General Trading LLC |
62 |
V |
3002 |
6110 |
Y&D Maxi Length Shirt Neck Print Pattern Full Sleeve Casual Dress For Women Multi Color |
J D F General Trading LLC |
62 |
V |
3002 |
6111 |
Y&D Maxi Length Shirt Neck Print Pattern Full Sleeve Casual Dress For Women Multi Color |
J D F General Trading LLC |
62 |
V |
3002 |