Query time 0.00194
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "305.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "57.00"
},
"nested_loop": [
{
"table": {
"table_name": "q_images_links",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"type"
],
"key_length": "81",
"rows_examined_per_scan": 57,
"rows_produced_per_join": 57,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('9741','9742','9743','9744','9745','9746','9747','9748','9749','9750','9751','9752','9753','9754','9755','9756','9757','9758','9759','9760','9761','9762','9763','9764','9765','9766','9767','9768','9769','9770','9771','9772')))",
"cost_info": {
"read_cost": "100.41",
"eval_cost": "11.40",
"prefix_cost": "111.81",
"data_read_per_join": "5K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "q_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"portal.q_images_links.image_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 57,
"filtered": "100.00",
"cost_info": {
"read_cost": "57.00",
"eval_cost": "11.40",
"prefix_cost": "180.21",
"data_read_per_join": "43K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"table": {
"table_name": "q_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "107",
"ref": [
"portal.q_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 57,
"filtered": "100.00",
"cost_info": {
"read_cost": "57.00",
"eval_cost": "11.40",
"prefix_cost": "248.61",
"data_read_per_join": "33K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
}
}
]
}
}
}
Result
image_id |
image_path |
image_x |
image_y |
is_high_res |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
alt |
images_image_id |
0 |
|
|
|
|
25027 |
9761 |
product |
26989 |
A |
1 |
|
|
0 |
|
|
|
|
25033 |
9763 |
product |
26995 |
A |
1 |
|
|
0 |
|
|
|
|
25037 |
9764 |
product |
26999 |
A |
1 |
|
|
0 |
|
|
|
|
25039 |
9765 |
product |
27001 |
A |
1 |
|
|
0 |
|
|
|
|
25042 |
9766 |
product |
27004 |
A |
1 |
|
|
0 |
|
|
|
|
25045 |
9767 |
product |
27007 |
A |
1 |
|
|
0 |
|
|
|
|
25049 |
9768 |
product |
27011 |
A |
1 |
|
|
0 |
|
|
|
|
25051 |
9769 |
product |
27013 |
A |
1 |
|
|
0 |
|
|
|
|
25057 |
9770 |
product |
27019 |
A |
1 |
|
|
0 |
|
|
|
|
25058 |
9771 |
product |
27020 |
A |
1 |
|
|
0 |
|
|
|
|
25063 |
9772 |
product |
27025 |
A |
1 |
|
|
0 |
|
|
|
|
25930 |
9751 |
product |
27892 |
A |
1 |
|
|
0 |
|
|
|
|
25933 |
9750 |
product |
27895 |
A |
1 |
|
|
0 |
|
|
|
|
25936 |
9749 |
product |
27898 |
A |
1 |
|
|
0 |
|
|
|
|
25939 |
9748 |
product |
27901 |
A |
1 |
|
|
0 |
|
|
|
|
25940 |
9747 |
product |
27902 |
A |
1 |
|
|
0 |
|
|
|
|
25942 |
9746 |
product |
27904 |
A |
1 |
|
|
0 |
|
|
|
|
25948 |
9744 |
product |
27910 |
A |
1 |
|
|
0 |
|
|
|
|
25951 |
9743 |
product |
27913 |
A |
1 |
|
|
0 |
|
|
|
|
25955 |
9742 |
product |
27917 |
A |
1 |
|
|
0 |
|
|
|
|
25958 |
9741 |
product |
27920 |
A |
1 |
|
|
0 |
|
|
|
|
26230 |
9754 |
product |
28192 |
A |
1 |
|
|
0 |
|
|
|
|
26231 |
9753 |
product |
28193 |
A |
1 |
|
|
0 |
|
|
|
|
26235 |
9752 |
product |
28197 |
A |
1 |
|
|
0 |
|
|
|
|
25028 |
9761 |
product |
26990 |
A |
2 |
|
|
0 |
|
|
|
|
25030 |
9762 |
product |
26992 |
A |
2 |
|
|
0 |
|
|
|
|
25034 |
9763 |
product |
26996 |
A |
2 |
|
|
0 |
|
|
|
|
25038 |
9764 |
product |
27000 |
A |
2 |
|
|
0 |
|
|
|
|
25040 |
9765 |
product |
27002 |
A |
2 |
|
|
0 |
|
|
|
|
25043 |
9766 |
product |
27005 |
A |
2 |
|
|
0 |
|
|
|
|
25046 |
9767 |
product |
27008 |
A |
2 |
|
|
0 |
|
|
|
|
25050 |
9768 |
product |
27012 |
A |
2 |
|
|
0 |
|
|
|
|
25052 |
9769 |
product |
27014 |
A |
2 |
|
|
0 |
|
|
|
|
25059 |
9771 |
product |
27021 |
A |
2 |
|
|
0 |
|
|
|
|
25064 |
9772 |
product |
27026 |
A |
2 |
|
|
0 |
|
|
|
|
25931 |
9751 |
product |
27893 |
A |
2 |
|
|
0 |
|
|
|
|
25934 |
9750 |
product |
27896 |
A |
2 |
|
|
0 |
|
|
|
|
25937 |
9749 |
product |
27899 |
A |
2 |
|
|
0 |
|
|
|
|
25941 |
9747 |
product |
27903 |
A |
2 |
|
|
0 |
|
|
|
|
25943 |
9746 |
product |
27905 |
A |
2 |
|
|
0 |
|
|
|
|
25946 |
9745 |
product |
27908 |
A |
2 |
|
|
0 |
|
|
|
|
25949 |
9744 |
product |
27911 |
A |
2 |
|
|
0 |
|
|
|
|
25952 |
9743 |
product |
27914 |
A |
2 |
|
|
0 |
|
|
|
|
25956 |
9742 |
product |
27918 |
A |
2 |
|
|
0 |
|
|
|
|
25959 |
9741 |
product |
27921 |
A |
2 |
|
|
0 |
|
|
|
|
25031 |
9762 |
product |
26993 |
A |
3 |
|
|
0 |
|
|
|
|
25035 |
9763 |
product |
26997 |
A |
3 |
|
|
0 |
|
|
|
|
25041 |
9765 |
product |
27003 |
A |
3 |
|
|
0 |
|
|
|
|
25044 |
9766 |
product |
27006 |
A |
3 |
|
|
0 |
|
|
|
|
25047 |
9767 |
product |
27009 |
A |
3 |
|
|
0 |
|
|
|
|
25053 |
9769 |
product |
27015 |
A |
3 |
|
|
0 |
|
|
|
|
25932 |
9751 |
product |
27894 |
A |
3 |
|
|
0 |
|
|
|
|
25935 |
9750 |
product |
27897 |
A |
3 |
|
|
0 |
|
|
|
|
25938 |
9749 |
product |
27900 |
A |
3 |
|
|
0 |
|
|
|
|
25944 |
9746 |
product |
27906 |
A |
3 |
|
|
0 |
|
|
|
|
25947 |
9745 |
product |
27909 |
A |
3 |
|
|
0 |
|
|
|
|
25950 |
9744 |
product |
27912 |
A |
3 |
|
|
0 |
|
|
|
|
25953 |
9743 |
product |
27915 |
A |
3 |
|
|
0 |
|
|
|
|
25957 |
9742 |
product |
27919 |
A |
3 |
|
|
0 |
|
|
|
|
25960 |
9741 |
product |
27922 |
A |
3 |
|
|
0 |
|
|
|
|
25032 |
9762 |
product |
26994 |
A |
4 |
|
|
0 |
|
|
|
|
25048 |
9767 |
product |
27010 |
A |
4 |
|
|
0 |
|
|
|
|
25954 |
9743 |
product |
27916 |
A |
4 |
|
|