Query time 0.00339
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "295.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "51.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_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": 51,
"rows_produced_per_join": 51,
"filtered": "100.00",
"index_condition": "((`webmarco`.`cscart_images_links`.`object_type` = 'product') and (`webmarco`.`cscart_images_links`.`type` = 'M') and (`webmarco`.`cscart_images_links`.`object_id` in (82038,148884,148887,148890,148893,148896,148899,148902,148905,148908,148911,148914,148917,148920,148923,148926,148929,148882,148883,148885,148888,148891,148894,148897,148900,148903,148906,148909,148912,148915,148918,148921,148924,148927,148930,148886,148889,148892,148895,148898,148901,148904,148907,148910,148913,148916,148919,148922,148925,148928,148931)))",
"cost_info": {
"read_cost": "112.21",
"eval_cost": "10.20",
"prefix_cost": "122.41",
"data_read_per_join": "4K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"webmarco.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "51.00",
"eval_cost": "10.20",
"prefix_cost": "183.61",
"data_read_per_join": "39K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"table": {
"table_name": "cscart_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "108",
"ref": [
"webmarco.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "51.00",
"eval_cost": "10.20",
"prefix_cost": "244.81",
"data_read_per_join": "30K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
]
}
}
]
}
}
}
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 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
97407 |
82038 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182853 |
148882 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182854 |
148883 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182855 |
148884 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182856 |
148885 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182857 |
148886 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182858 |
148887 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182859 |
148888 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182860 |
148889 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182861 |
148890 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182862 |
148891 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182863 |
148892 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182864 |
148893 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182865 |
148894 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182866 |
148895 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182867 |
148896 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182868 |
148897 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182869 |
148898 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182870 |
148899 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182871 |
148900 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182872 |
148901 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182873 |
148902 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182874 |
148903 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182875 |
148904 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182876 |
148905 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182877 |
148906 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182878 |
148907 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182879 |
148908 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182880 |
148909 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182881 |
148910 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182882 |
148911 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182883 |
148912 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182884 |
148913 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182885 |
148914 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182886 |
148915 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182887 |
148916 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182888 |
148917 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182889 |
148918 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182890 |
148919 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182891 |
148920 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182892 |
148921 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182893 |
148922 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182894 |
148923 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182895 |
148924 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182896 |
148925 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182897 |
148926 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182898 |
148927 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182899 |
148928 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182900 |
148929 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182901 |
148930 |
product |
89407 |
M |
0 |
|
89407 |
0 |
Abito-Corto-da-Donna-Webmarco.png |
800 |
800 |
N |
182902 |
148931 |
product |
89407 |
M |
0 |
|
89407 |