Query time 0.00236
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "207.23"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "90.65"
},
"nested_loop": [
{
"table": {
"table_name": "c",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 92,
"rows_produced_per_join": 92,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`c`.`product_id` in (8576,8634,7876,8711,8712,7877,26583,26603,26602,26588,26579,26586,26585,26597,26599,14148,17561,14165,26595,39228,33829,54854,36613,33830,36615,36614,64584,67747,68322,39258,70308,71429,70773,71047,71389,71388,71413,71418,71428,71453,71458,71479,71490,71491,71518))",
"cost_info": {
"read_cost": "43.46",
"eval_cost": "9.20",
"prefix_cost": "52.66",
"data_read_per_join": "736"
},
"used_columns": [
"option_id",
"product_id"
],
"attached_condition": "(`cscartdb`.`c`.`option_id` is not null)"
}
},
{
"table": {
"table_name": "a",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status"
],
"key": "PRIMARY",
"used_key_parts": [
"option_id"
],
"key_length": "3",
"ref": [
"cscartdb.c.option_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 90,
"filtered": "98.53",
"cost_info": {
"read_cost": "23.00",
"eval_cost": "9.06",
"prefix_cost": "84.86",
"data_read_per_join": "207K"
},
"used_columns": [
"option_id",
"product_id",
"company_id",
"option_type",
"regexp",
"required",
"multiupload",
"allowed_extensions",
"max_file_size",
"missing_variants_handling",
"status",
"position",
"value"
],
"attached_condition": "((`cscartdb`.`a`.`product_id` = 0) and (`cscartdb`.`a`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"option_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.c.option_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 90,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.66",
"eval_cost": "9.06",
"prefix_cost": "116.59",
"data_read_per_join": "308K"
},
"used_columns": [
"option_id",
"lang_code",
"option_name",
"internal_option_name",
"option_text",
"description",
"comment",
"inner_hint",
"incorrect_message"
]
}
}
]
}
}
}
Result
cur_product_id |
option_id |
product_id |
company_id |
option_type |
regexp |
required |
multiupload |
allowed_extensions |
max_file_size |
missing_variants_handling |
status |
position |
value |
option_name |
internal_option_name |
option_text |
description |
inner_hint |
incorrect_message |
comment |
54854 |
758 |
0 |
331 |
S |
|
N |
N |
|
0 |
M |
A |
0 |
|
COLOR |
COLOR |
|
|
|
|
|
54854 |
759 |
0 |
331 |
S |
|
N |
N |
|
0 |
M |
A |
0 |
|
With Add-On Leash |
With Add-On Leash |
|
|
|
|
|
71518 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
39228 |
736 |
0 |
284 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
WAIST SIZE |
WAIST SIZE |
|
|
|
|
|
39258 |
736 |
0 |
284 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
WAIST SIZE |
WAIST SIZE |
|
|
|
|
|
67747 |
1127 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Inner Diameter |
Glansring Inner Diameter |
|
|
|
|
|
68322 |
1127 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Inner Diameter |
Glansring Inner Diameter |
|
|
|
|
|
70308 |
1146 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring Inner Diameter |
Carboner Inner Diameter |
|
|
|
|
|
70773 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71047 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71388 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71389 |
1155 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring Size |
Cockring Size |
|
|
|
|
|
71413 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71491 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71490 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71479 |
1127 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Inner Diameter |
Glansring Inner Diameter |
|
|
|
|
|
71458 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71453 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71429 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71428 |
1147 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Cockring inner diameter |
Cockring inner diameter |
|
|
|
|
|
71418 |
1127 |
0 |
417 |
S |
|
N |
N |
|
0 |
M |
A |
1 |
|
Inner Diameter |
Glansring Inner Diameter |
|
|
|
|
|
26583 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26585 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26579 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26603 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26586 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26602 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26599 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26597 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26588 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26595 |
270 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
2 |
|
Firmness |
Firmness |
|
|
|
|
|
26595 |
524 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
4 |
|
Design Style |
Pour Style - C Rings |
|
|
|
|
|
26588 |
524 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
4 |
|
Design Style |
Pour Style - C Rings |
|
|
|
|
|
7876 |
187 |
0 |
37 |
S |
|
N |
N |
|
0 |
M |
A |
7 |
|
Size |
Size (Dragon skin) |
|
|
|
|
Select your size |
7877 |
187 |
0 |
37 |
S |
|
N |
N |
|
0 |
M |
A |
7 |
|
Size |
Size (Dragon skin) |
|
|
|
|
Select your size |
26583 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26602 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26588 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26599 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26603 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26595 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26597 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26579 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26586 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26585 |
260 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
9 |
|
Color one |
Color One |
|
|
|
|
|
26603 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26583 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26602 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26586 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26585 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26579 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26599 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26597 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26595 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26588 |
271 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
10 |
|
Color Two |
Color Two |
|
|
|
|
|
26602 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26599 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26603 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26588 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26579 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26597 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26586 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26583 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26585 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26595 |
265 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
12 |
|
Add-On Color Three |
Add-On Color Three |
|
|
|
|
|
26579 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26603 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26583 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26585 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26586 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26602 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26599 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26597 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26588 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
26595 |
266 |
0 |
6 |
S |
|
N |
N |
|
0 |
M |
A |
13 |
|
Add-On Color Four |
Add-On Color Four |
|
|
|
|
|
7877 |
188 |
0 |
37 |
S |
|
N |
N |
|
0 |
M |
A |
16 |
|
Firmness |
Firmness (cock rings) |
|
|
|
|
Select your firmness |
7876 |
188 |
0 |
37 |
S |
|
N |
N |
|
0 |
M |
A |
16 |
|
Firmness |
Firmness (cock rings) |
|
|
|
|
Select your firmness |
7877 |
95 |
0 |
37 |
S |
|
Y |
N |
|
0 |
M |
A |
18 |
|
Color 1 |
Color 1 |
|
|
|
|
Select your first color |
7876 |
87 |
0 |
37 |
S |
|
Y |
N |
|
0 |
M |
A |
20 |
|
Color |
Color (for solid color toys) |
|
|
|
|
Select your color |
7877 |
96 |
0 |
37 |
S |
|
Y |
N |
|
0 |
M |
A |
21 |
|
Color 2 |
Color 2 |
|
|
|
|
Select your second color |
7877 |
97 |
0 |
37 |
S |
|
N |
N |
|
0 |
M |
A |
23 |
|
Color 3 (Optional) |
Color 3 |
|
|
|
|
Select your third color (Optional) |