id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | range | status,option_id,option_id_2 | option_id | 6 | 40 | Using index condition; Using filesort | |
1 | SIMPLE | b | eq_ref | PRIMARY | PRIMARY | 9 | toolboxdigitalshop_dev.a.variant_id,const | 1 | Using where |
1 | SIMPLE | shared_option_variants | eq_ref | PRIMARY,company_id | PRIMARY | 7 | toolboxdigitalshop_dev.a.variant_id,const | 1 |
variant_name | variant_id | option_id | position | modifier | modifier_type | weight_modifier | weight_modifier_type | point_modifier | point_modifier_type | status |
---|---|---|---|---|---|---|---|---|---|---|
MP3 | 168258 | 83861 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 175412 | 87438 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177546 | 88505 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177548 | 88506 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177550 | 88507 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177552 | 88508 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177554 | 88509 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177556 | 88510 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 177792 | 88628 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178642 | 89053 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178644 | 89054 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178872 | 89168 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178906 | 89185 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178908 | 89186 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178910 | 89187 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 178944 | 89204 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 179010 | 89237 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 179034 | 89249 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 179044 | 89254 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
MP3 | 179186 | 89325 | 1 | 0.000 | A | 0.000 | A | 0.000 | A | A |
WAV | 168259 | 83861 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 175413 | 87438 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177547 | 88505 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177549 | 88506 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177551 | 88507 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177553 | 88508 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177555 | 88509 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177557 | 88510 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 177793 | 88628 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178643 | 89053 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178645 | 89054 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178873 | 89168 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178907 | 89185 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178909 | 89186 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178911 | 89187 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 178945 | 89204 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 179011 | 89237 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 179035 | 89249 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 179045 | 89254 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |
WAV | 179187 | 89325 | 2 | 0.300 | A | 0.000 | A | 0.000 | A | A |