{
"query_block": {
"select_id": 1,
"table": {
"table_name": "shared_option_variants",
"access_type": "system",
"possible_keys": ["PRIMARY", "company_id"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"read_sorted_file": {
"filesort": {
"sort_key": "a.position, a.variant_id",
"table": {
"table_name": "a",
"access_type": "range",
"possible_keys": ["option_id", "option_id_2", "status"],
"key": "option_id",
"key_length": "6",
"used_key_parts": ["option_id", "status"],
"rows": 68,
"filtered": 100,
"index_condition": "a.option_id in (22573,22574,22571,22572,22246) and a.`status` = 'A'"
}
}
},
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["variant_id", "lang_code"],
"ref": ["cscart_migrate.a.variant_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(b.lang_code = 'en')"
}
}
}| variant_id | option_id | position | modifier | modifier_type | weight_modifier | weight_modifier_type | nav_skus | commercial_modifier | commercial_dn | same_as_option | price_overrides | base_cost | variant_name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220319 | 22246 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222726 | 22571 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222727 | 22572 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222760 | 22573 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Select Option | |
| 222761 | 22574 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 219225 | 22246 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | None | ||
| 222712 | 22571 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard Black | |
| 222730 | 22573 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 222713 | 22571 | 5 | 5.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.00 | Standard White | |
| 222728 | 22572 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 222731 | 22573 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 222762 | 22574 | 5 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 219227 | 22246 | 10 | 13.000 | A | 0.000 | A | 13.00 | 0.00 | 0 | 0.00 | LED Clear ST19 - 31-4.5FSST19DIM/821 | ||
| 222714 | 22571 | 10 | 10.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 0.00 | Black Cloth | |
| 222729 | 22572 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 222732 | 22573 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 222763 | 22574 | 10 | 36.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 222715 | 22571 | 15 | 10.000 | A | 0.000 | A | SLVR | 0.00 | 0.00 | 0 | 0.00 | Silver Cloth | |
| 222733 | 22573 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 242997 | 22246 | 15 | 13.000 | A | 0.000 | A | 13.00 | 0.00 | 0 | 0.00 | LED Amber ST19 - 31-4.5FSST19DIM/820/A | ||
| 222755 | 22573 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 222748 | 22573 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 219229 | 22246 | 20 | 14.000 | A | 0.000 | A | 20.00 | 0.00 | 0 | 0.00 | LED Smoky ST19 - 31-4.5FSST19DIM/840/S | ||
| 222716 | 22571 | 20 | 10.000 | A | 0.000 | A | CRM | 0.00 | 0.00 | 0 | 0.00 | Creme Cloth | |
| 237240 | 22573 | 21 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237241 | 22573 | 22 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 222734 | 22573 | 24 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 222717 | 22571 | 25 | 10.000 | A | 0.000 | A | BPNK | 0.00 | 0.00 | 0 | 0.00 | Blush Pink Cloth | |
| 242916 | 22573 | 25 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241700 | 22573 | 26 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 222735 | 22573 | 28 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 222718 | 22571 | 30 | 20.000 | A | 0.000 | A | CNF | 0.00 | 0.00 | 0 | 0.00 | Confetti Cloth | |
| 222736 | 22573 | 30 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 222719 | 22571 | 35 | 10.000 | A | 0.000 | A | RST | 0.00 | 0.00 | 0 | 0.00 | Rust Cloth | |
| 222737 | 22573 | 35 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 222720 | 22571 | 40 | 15.000 | A | 0.000 | A | RBS | 0.00 | 0.00 | 0 | 0.00 | Barn Red & Black Swirl Cloth | |
| 222738 | 22573 | 40 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 222721 | 22571 | 45 | 10.000 | A | 0.000 | A | ORG | 0.00 | 0.00 | 0 | 0.00 | Orange Cloth | |
| 222739 | 22573 | 45 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241701 | 22573 | 48 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 222722 | 22571 | 50 | 10.000 | A | 0.000 | A | YLW | 0.00 | 0.00 | 0 | 0.00 | Buttery Yellow Cloth | |
| 222740 | 22573 | 50 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 222723 | 22571 | 55 | 10.000 | A | 0.000 | A | NGRN | 0.00 | 0.00 | 0 | 0.00 | Neon Green Cloth | |
| 222741 | 22573 | 55 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 222724 | 22571 | 60 | 10.000 | A | 0.000 | A | EGRN | 0.00 | 0.00 | 0 | 0.00 | Emerald Green Cloth | |
| 222742 | 22573 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 222725 | 22571 | 65 | 20.000 | A | 0.000 | A | FGRN | 0.00 | 0.00 | 0 | 0.00 | Fern Green Chevron Cloth | |
| 222743 | 22573 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 222744 | 22573 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 243091 | 22571 | 70 | 10.000 | A | 0.000 | A | SFM | 0.00 | 0.00 | 0 | 0.00 | Seafoam Cloth | |
| 222745 | 22573 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 243092 | 22571 | 75 | 10.000 | A | 0.000 | A | SBLU | 0.00 | 0.00 | 0 | 0.00 | Sky Blue Cloth | |
| 222746 | 22573 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 243093 | 22571 | 80 | 10.000 | A | 0.000 | A | RBLU | 0.00 | 0.00 | 0 | 0.00 | Royal Blue Cloth | |
| 222747 | 22573 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 243094 | 22571 | 85 | 10.000 | A | 0.000 | A | NVY | 0.00 | 0.00 | 0 | 0.00 | Navy Cloth | |
| 241702 | 22573 | 88 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 222749 | 22573 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241703 | 22573 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 222750 | 22573 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 222751 | 22573 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 242917 | 22573 | 107 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242918 | 22573 | 109 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 222752 | 22573 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 222753 | 22573 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 222754 | 22573 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242919 | 22573 | 122 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241704 | 22573 | 123 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey |