{
"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": 75,
"filtered": 100,
"index_condition": "a.option_id in (22685,21954,22247) 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220173 | 21954 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220320 | 22247 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 224467 | 22685 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Select Option | |
| 215556 | 21954 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard Black | |
| 219237 | 22247 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | None | ||
| 224437 | 22685 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215557 | 21954 | 5 | 5.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.32 | Standard White | |
| 219238 | 22247 | 5 | 19.000 | A | 0.000 | A | 19.00 | 0.00 | 0 | 0.00 | LED Silver Bowl G25 - 31-4.5FG25DIM/827/SB/R | ||
| 224438 | 22685 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215558 | 21954 | 10 | 10.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 3.66 | Black Cloth | |
| 219239 | 22247 | 10 | 13.000 | A | 0.000 | A | 13.00 | 0.00 | 0 | 0.00 | LED Clear ST19 - 31-4.5FSST19DIM/821 | ||
| 224439 | 22685 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215559 | 21954 | 15 | 10.000 | A | 0.000 | A | SLVR | 0.00 | 0.00 | 0 | 3.66 | Silver Cloth | |
| 224440 | 22685 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 242973 | 22247 | 15 | 13.000 | A | 0.000 | A | 13.00 | 0.00 | 0 | 0.00 | LED Amber ST19 - 31-4.5FSST19DIM/820/A | ||
| 224462 | 22685 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 224455 | 22685 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215560 | 21954 | 20 | 10.000 | A | 0.000 | A | CRM | 0.00 | 0.00 | 0 | 3.66 | Creme Cloth | |
| 219241 | 22247 | 20 | 14.000 | A | 0.000 | A | 14.00 | 0.00 | 0 | 0.00 | LED Smoky ST19 - 31-4.5FSST19DIM/840/S | ||
| 237080 | 22685 | 21 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237081 | 22685 | 22 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 224441 | 22685 | 24 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 215561 | 21954 | 25 | 10.000 | A | 0.000 | A | BPNK | 0.00 | 0.00 | 0 | 3.66 | Blush Pink Cloth | |
| 242769 | 22685 | 26 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 224442 | 22685 | 28 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 215562 | 21954 | 30 | 30.000 | A | 0.000 | A | CNF | 0.00 | 0.00 | 0 | 10.66 | Confetti Cloth | |
| 224443 | 22685 | 30 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 215563 | 21954 | 35 | 10.000 | A | 0.000 | A | RST | 0.00 | 0.00 | 0 | 3.66 | Rust Cloth | |
| 224444 | 22685 | 35 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 215564 | 21954 | 40 | 15.000 | A | 0.000 | A | RBS | 0.00 | 0.00 | 0 | 6.81 | Barn Red & Black Swirl Cloth | |
| 224445 | 22685 | 40 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 215565 | 21954 | 45 | 10.000 | A | 0.000 | A | ORG | 0.00 | 0.00 | 0 | 3.66 | Orange Cloth | |
| 224446 | 22685 | 45 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 242770 | 22685 | 48 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 215566 | 21954 | 50 | 10.000 | A | 0.000 | A | YLW | 0.00 | 0.00 | 0 | 3.66 | Buttery Yellow Cloth | |
| 224447 | 22685 | 50 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 215567 | 21954 | 55 | 10.000 | A | 0.000 | A | NGRN | 0.00 | 0.00 | 0 | 3.66 | Neon Green Cloth | |
| 224448 | 22685 | 55 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 215568 | 21954 | 60 | 10.000 | A | 0.000 | A | EGRN | 0.00 | 0.00 | 0 | 3.66 | Emerald Green Cloth | |
| 219249 | 22247 | 60 | 13.000 | A | 0.000 | A | 13.00 | 0.00 | 0 | 0.00 | Lurra LED Tala Lamp - 28LURA | ||
| 224449 | 22685 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 215569 | 21954 | 65 | 30.000 | A | 0.000 | A | FGRN | 0.00 | 0.00 | 0 | 10.66 | Fern Green Chevron Cloth | |
| 219250 | 22247 | 65 | 15.000 | A | 0.000 | A | 15.00 | 0.00 | 0 | 0.00 | Globe LED Tala Lamp - 28GLOB | ||
| 224450 | 22685 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 224451 | 22685 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 243103 | 21954 | 70 | 10.000 | A | 0.000 | A | SFM | 0.00 | 0.00 | 0 | 3.66 | Seafoam Cloth | |
| 219252 | 22247 | 75 | 28.000 | A | 0.000 | A | 28.00 | 0.00 | 0 | 0.00 | Elva LED Tala Lamp - 28ELVA | ||
| 224452 | 22685 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 243104 | 21954 | 75 | 10.000 | A | 0.000 | A | SBLU | 0.00 | 0.00 | 0 | 3.66 | Sky Blue Cloth | |
| 219253 | 22247 | 80 | 90.000 | A | 0.000 | A | 90.00 | 0.00 | 0 | 0.00 | Oval LED Tala Lamp - 28OVAL | ||
| 224453 | 22685 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 243105 | 21954 | 80 | 10.000 | A | 0.000 | A | RBLU | 0.00 | 0.00 | 0 | 3.66 | Royal Blue Cloth | |
| 219254 | 22247 | 85 | 90.000 | A | 0.000 | A | 90.00 | 0.00 | 0 | 0.00 | Oblo LED Tala Lamp - 28OBLO | ||
| 224454 | 22685 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 243106 | 21954 | 85 | 10.000 | A | 0.000 | A | NVY | 0.00 | 0.00 | 0 | 3.66 | Navy Cloth | |
| 242771 | 22685 | 88 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 219255 | 22247 | 90 | 38.000 | A | 0.000 | A | 38.00 | 0.00 | 0 | 0.00 | Porcelain III LED Tala Lamp - 28PORC-III | ||
| 219256 | 22247 | 95 | 90.000 | A | 0.000 | A | 90.00 | 0.00 | 0 | 0.00 | Noma LED Tala Lamp - 28NOMA | ||
| 224456 | 22685 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 242772 | 22685 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 219257 | 22247 | 100 | 90.000 | A | 0.000 | A | 90.00 | 0.00 | 0 | 0.00 | Enno LED Tala Lamp - 28ENNO | ||
| 224457 | 22685 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 219258 | 22247 | 105 | 93.000 | A | 0.000 | A | 93.00 | 0.00 | 0 | 0.00 | Voronoi I LED Tala Lamp - 28VORN-I | ||
| 224458 | 22685 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 219259 | 22247 | 110 | 145.000 | A | 0.000 | A | 145.00 | 0.00 | 0 | 0.00 | Voronoi II LED Tala Lamp - 28VORN-II | ||
| 224459 | 22685 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 224460 | 22685 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 224461 | 22685 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242773 | 22685 | 123 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 224463 | 22685 | 130 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 224464 | 22685 | 135 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 224465 | 22685 | 140 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 224466 | 22685 | 145 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 224468 | 22685 | 165 | 87.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 224469 | 22685 | 170 | 99.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass |