{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "129.61"
},
"table": {
"table_name": "jmj_product_feature_variants",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"rows_examined_per_scan": 54,
"rows_produced_per_join": 54,
"filtered": "100.00",
"index_condition": "(`jmj_test`.`jmj_product_feature_variants`.`variant_id` in (3233,2831,2835,2837,2838,2839,2841,2845,2850,2851,2852,2854,2853,2848,2849,2855,2856,2857,2859,2860,2862,2864,2865,2876,2878,2881,2882,2883,2885,2886,2867,2871,2873,1688,1689,1690,1691,2103,2105,2106,2107,2112,2126,2127,2143,2145,2148,2153,2154,2185,2195,2207,2208,766))",
"cost_info": {
"read_cost": "118.81",
"eval_cost": "10.80",
"prefix_cost": "129.61",
"data_read_per_join": "83K"
},
"used_columns": [
"variant_id",
"feature_id",
"url",
"color",
"position",
"abt__ut2_color_style",
"abt__ut2_multicolor"
]
}
}
}
| variant_id | feature_id | url | color | position | abt__ut2_color_style | abt__ut2_multicolor |
|---|---|---|---|---|---|---|
| 766 | 132 | #ffffff | 1 | default | ||
| 1688 | 255 | #ffffff | 0 | default | ||
| 1689 | 255 | #ffffff | 0 | default | ||
| 1690 | 255 | #ffffff | 0 | default | ||
| 1691 | 255 | #ffffff | 0 | default | ||
| 2103 | 280 | #000000 | 0 | default | ||
| 2105 | 280 | #808080 | 23 | default | ||
| 2106 | 280 | #a9a9a9 | 25 | default | ||
| 2107 | 280 | #c0c0c0 | 27 | default | ||
| 2112 | 280 | #191970 | 52 | default | ||
| 2126 | 280 | #b0c4de | 105 | default | ||
| 2127 | 280 | #e6e6fa | 109 | default | ||
| 2143 | 280 | #2f4f4f | 151 | default | ||
| 2145 | 280 | #3cb371 | 166 | default | ||
| 2148 | 280 | #556b2f | 173 | default | ||
| 2153 | 280 | #8fbc8f | 201 | default | ||
| 2154 | 280 | #9acd32 | 209 | default | ||
| 2185 | 280 | #bdb76b | 301 | default | ||
| 2195 | 280 | #e9967a | 368 | default | ||
| 2207 | 280 | #ffe4e1 | 428 | default | ||
| 2208 | 280 | #ffc0cb | 432 | default | ||
| 2831 | 370 | #ffffff | 0 | default | ||
| 2835 | 370 | #ffffff | 0 | default | ||
| 2837 | 370 | #ffffff | 0 | default | ||
| 2838 | 371 | #ffffff | 0 | default | ||
| 2839 | 371 | #ffffff | 0 | default | ||
| 2841 | 371 | #ffffff | 0 | default | ||
| 2845 | 372 | #ffffff | 2 | default | ||
| 2848 | 373 | #ffffff | 2 | default | ||
| 2849 | 373 | #ffffff | 3 | default | ||
| 2850 | 372 | #ffffff | 4 | default | ||
| 2851 | 374 | #ffffff | 1 | default | ||
| 2852 | 374 | #ffffff | 2 | default | ||
| 2853 | 374 | #ffffff | 4 | default | ||
| 2854 | 374 | #ffffff | 3 | default | ||
| 2855 | 375 | #ffffff | 1 | default | ||
| 2856 | 375 | #ffffff | 2 | default | ||
| 2857 | 375 | #ffffff | 3 | default | ||
| 2859 | 375 | #ffffff | 5 | default | ||
| 2860 | 375 | #ffffff | 6 | default | ||
| 2862 | 375 | #ffffff | 8 | default | ||
| 2864 | 376 | #ffffff | 1 | default | ||
| 2865 | 376 | #ffffff | 2 | default | ||
| 2867 | 377 | #ffffff | 0 | default | ||
| 2871 | 377 | #ffffff | 0 | default | ||
| 2873 | 377 | #ffffff | 0 | default | ||
| 2876 | 378 | #ffffff | 0 | default | ||
| 2878 | 378 | #ffffff | 0 | default | ||
| 2881 | 378 | #ffffff | 0 | default | ||
| 2882 | 379 | #ffffff | 1 | default | ||
| 2883 | 379 | #ffffff | 2 | default | ||
| 2885 | 380 | #ffffff | 1 | default | ||
| 2886 | 380 | #ffffff | 2 | default | ||
| 3233 | 31 | #ffffff | 121 | default |