Query time 0.00140
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "310.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "58.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": 58,
"rows_produced_per_join": 58,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'M') and (`portal`.`q_images_links`.`object_id` in ('41238','41239','41240','41241','41242','41243','41244','41245','41246','41247','41248','41249','41250','41251','41252','41253','41254','41255','41256','41257','41258','41259','41260','41261','41262','41263','41264','41265','41266','41267','41268','41269')))",
"cost_info": {
"read_cost": "101.61",
"eval_cost": "11.60",
"prefix_cost": "113.21",
"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": 58,
"filtered": "100.00",
"cost_info": {
"read_cost": "58.00",
"eval_cost": "11.60",
"prefix_cost": "182.81",
"data_read_per_join": "44K"
},
"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": 58,
"filtered": "100.00",
"cost_info": {
"read_cost": "58.00",
"eval_cost": "11.60",
"prefix_cost": "252.41",
"data_read_per_join": "34K"
},
"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 |
|
|
|
|
66788 |
41257 |
product |
68739 |
M |
0 |
|
|
0 |
|
|
|
|
66790 |
41258 |
product |
68741 |
M |
0 |
|
|
0 |
|
|
|
|
66791 |
41259 |
product |
68742 |
M |
0 |
|
|
0 |
|
|
|
|
66792 |
41260 |
product |
68743 |
M |
0 |
|
|
0 |
|
|
|
|
66793 |
41261 |
product |
68744 |
M |
0 |
|
|
0 |
|
|
|
|
66794 |
41262 |
product |
68745 |
M |
0 |
|
|
0 |
|
|
|
|
66795 |
41263 |
product |
68746 |
M |
0 |
|
|
0 |
|
|
|
|
66796 |
41264 |
product |
68747 |
M |
0 |
|
|
0 |
|
|
|
|
66797 |
41265 |
product |
68748 |
M |
0 |
|
|
0 |
|
|
|
|
66798 |
41266 |
product |
68749 |
M |
0 |
|
|
0 |
|
|
|
|
66799 |
41267 |
product |
68750 |
M |
0 |
|
|
0 |
|
|
|
|
66800 |
41259 |
product |
68751 |
M |
0 |
|
|
0 |
|
|
|
|
66801 |
41260 |
product |
68752 |
M |
0 |
|
|
0 |
|
|
|
|
66802 |
41263 |
product |
68753 |
M |
0 |
|
|
0 |
|
|
|
|
66803 |
41264 |
product |
68754 |
M |
0 |
|
|
0 |
|
|
|
|
66804 |
41266 |
product |
68755 |
M |
0 |
|
|
0 |
|
|
|
|
66805 |
41265 |
product |
68756 |
M |
0 |
|
|
0 |
|
|
|
|
66806 |
41269 |
product |
68757 |
M |
0 |
|
|
0 |
|
|
|
|
66962 |
41245 |
product |
68913 |
M |
0 |
|
|
0 |
|
|
|
|
66963 |
41244 |
product |
68914 |
M |
0 |
|
|
0 |
|
|
|
|
66964 |
41243 |
product |
68915 |
M |
0 |
|
|
0 |
|
|
|
|
66966 |
41242 |
product |
68917 |
M |
0 |
|
|
0 |
|
|
|
|
66967 |
41242 |
product |
68918 |
M |
0 |
|
|
0 |
|
|
|
|
66970 |
41241 |
product |
68921 |
M |
0 |
|
|
0 |
|
|
|
|
66971 |
41240 |
product |
68922 |
M |
0 |
|
|
0 |
|
|
|
|
66972 |
41239 |
product |
68923 |
M |
0 |
|
|
0 |
|
|
|
|
66973 |
41239 |
product |
68924 |
M |
0 |
|
|
0 |
|
|
|
|
66974 |
41238 |
product |
68925 |
M |
0 |
|
|
0 |
|
|
|
|
67168 |
41256 |
product |
69119 |
M |
0 |
|
|
0 |
|
|
|
|
67169 |
41256 |
product |
69120 |
M |
0 |
|
|
0 |
|
|
|
|
67170 |
41246 |
product |
69121 |
M |
0 |
|
|
0 |
|
|
|
|
67171 |
41247 |
product |
69122 |
M |
0 |
|
|
0 |
|
|
|
|
67172 |
41248 |
product |
69123 |
M |
0 |
|
|
0 |
|
|
|
|
67173 |
41249 |
product |
69124 |
M |
0 |
|
|
0 |
|
|
|
|
67174 |
41250 |
product |
69125 |
M |
0 |
|
|
0 |
|
|
|
|
67175 |
41251 |
product |
69126 |
M |
0 |
|
|
0 |
|
|
|
|
67176 |
41252 |
product |
69127 |
M |
0 |
|
|
0 |
|
|
|
|
67177 |
41253 |
product |
69128 |
M |
0 |
|
|
0 |
|
|
|
|
67178 |
41254 |
product |
69129 |
M |
0 |
|
|
0 |
|
|
|
|
67179 |
41254 |
product |
69130 |
M |
0 |
|
|
0 |
|
|
|
|
67180 |
41255 |
product |
69131 |
M |
0 |
|
|
0 |
|
|
|
|
67416 |
41268 |
product |
69367 |
M |
0 |
|
|