Query time 0.00153
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "160.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "30.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": 30,
"rows_produced_per_join": 30,
"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')))",
"cost_info": {
"read_cost": "52.01",
"eval_cost": "6.00",
"prefix_cost": "58.01",
"data_read_per_join": "2K"
},
"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.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.00",
"eval_cost": "6.00",
"prefix_cost": "94.01",
"data_read_per_join": "22K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
],
"attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
}
},
{
"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": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.00",
"eval_cost": "6.00",
"prefix_cost": "130.01",
"data_read_per_join": "17K"
},
"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 |
51ABsUcLVIL._SL1500_.jpg |
1500 |
1500 |
N |
25930 |
9751 |
product |
27892 |
A |
1 |
|
27892 |
0 |
MSHI-L-023131_1_1024x.jpg |
1024 |
1024 |
N |
25933 |
9750 |
product |
27895 |
A |
1 |
|
27895 |
0 |
03_rn1t-yf.jpg |
1600 |
1600 |
N |
25936 |
9749 |
product |
27898 |
A |
1 |
|
27898 |
0 |
1369946765000_980445.jpg |
500 |
500 |
N |
25939 |
9748 |
product |
27901 |
A |
1 |
|
27901 |
0 |
04.jpg |
1600 |
1600 |
N |
25940 |
9747 |
product |
27902 |
A |
1 |
|
27902 |
0 |
04_dyjb-tx.jpg |
1600 |
1600 |
N |
25942 |
9746 |
product |
27904 |
A |
1 |
|
27904 |
0 |
04_3r7y-k6.jpg |
1600 |
1600 |
N |
25948 |
9744 |
product |
27910 |
A |
1 |
|
27910 |
0 |
41CURROMOgL.jpg |
500 |
500 |
N |
25951 |
9743 |
product |
27913 |
A |
1 |
|
27913 |
0 |
81YRQMntjhL._SL1500_.jpg |
1500 |
1500 |
N |
25955 |
9742 |
product |
27917 |
A |
1 |
|
27917 |
0 |
Moshi_Progeo_4-Port_Usb_Wall_Charger_35W_-_Eu_Version_2_1024x.jpg |
1024 |
1024 |
N |
25958 |
9741 |
product |
27920 |
A |
1 |
|
27920 |
0 |
01.jpg |
1600 |
1600 |
N |
26230 |
9754 |
product |
28192 |
A |
1 |
|
28192 |
0 |
01_prr8-58.jpg |
1600 |
1600 |
N |
26231 |
9753 |
product |
28193 |
A |
1 |
|
28193 |
0 |
htyrhyt11_1.jpg |
1080 |
590 |
N |
26235 |
9752 |
product |
28197 |
A |
1 |
|
28197 |
0 |
03.jpg |
1600 |
1600 |
N |
25931 |
9751 |
product |
27893 |
A |
2 |
|
27893 |
0 |
Integra_Headphone_Jack_Adapter_LS_3_1024x.jpg |
1024 |
683 |
N |
25934 |
9750 |
product |
27896 |
A |
2 |
|
27896 |
0 |
05.jpg |
1600 |
1600 |
N |
25937 |
9749 |
product |
27899 |
A |
2 |
|
27899 |
0 |
02_nau1-d4.jpg |
1600 |
1600 |
N |
25941 |
9747 |
product |
27903 |
A |
2 |
|
27903 |
0 |
03_m740-wp.jpg |
1600 |
1600 |
N |
25943 |
9746 |
product |
27905 |
A |
2 |
|
27905 |
0 |
999__1_.jpg |
500 |
500 |
N |
25946 |
9745 |
product |
27908 |
A |
2 |
|
27908 |
0 |
02_2z3s-y6.jpg |
1600 |
1600 |
N |
25949 |
9744 |
product |
27911 |
A |
2 |
|
27911 |
0 |
41qvj8XdAIL.jpg |
500 |
500 |
N |
25952 |
9743 |
product |
27914 |
A |
2 |
|
27914 |
0 |
61urPj1XOnL._SL1500_.jpg |
1500 |
1500 |
N |
25956 |
9742 |
product |
27918 |
A |
2 |
|
27918 |
0 |
03_9ihh-d3.jpg |
1600 |
1600 |
N |
25959 |
9741 |
product |
27921 |
A |
2 |
|
27921 |
0 |
71L6_abTk5L._SL1500_.jpg |
1500 |
1500 |
N |
25932 |
9751 |
product |
27894 |
A |
3 |
|
27894 |
0 |
71OOkZBOA2L._SL1500_.jpg |
1500 |
1500 |
N |
25935 |
9750 |
product |
27897 |
A |
3 |
|
27897 |
0 |
02.jpg |
1600 |
1600 |
N |
25938 |
9749 |
product |
27900 |
A |
3 |
|
27900 |
0 |
02_f6r0-jl.jpg |
1600 |
1600 |
N |
25944 |
9746 |
product |
27906 |
A |
3 |
|
27906 |
0 |
999__2_.jpg |
500 |
500 |
N |
25947 |
9745 |
product |
27909 |
A |
3 |
|
27909 |
0 |
01.jpg |
1600 |
1600 |
N |
25950 |
9744 |
product |
27912 |
A |
3 |
|
27912 |
0 |
51sSvg2U-ZL.jpg |
500 |
500 |
N |
25953 |
9743 |
product |
27915 |
A |
3 |
|
27915 |
0 |
01_o45h-0i.jpg |
1200 |
1200 |
N |
25957 |
9742 |
product |
27919 |
A |
3 |
|
27919 |
0 |
05_6qi8-yn.jpg |
1600 |
1600 |
N |
25960 |
9741 |
product |
27922 |
A |
3 |
|
27922 |
0 |
51gQ3UrzOOL.jpg |
500 |
500 |
N |
25954 |
9743 |
product |
27916 |
A |
4 |
|
27916 |