Query time 0.00174
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "185.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "32.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": 32,
"rows_produced_per_join": 32,
"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 ('8982','8983','8986','8987','8991','8992','8993','8994','8995','8996','8997','8998','8999','9000','9001','9002','9003','9004','9005','9006','9007','9008','9009','9010','9011','9012','9013','9014','9015','9016','9017','9018')))",
"cost_info": {
"read_cost": "70.41",
"eval_cost": "6.40",
"prefix_cost": "76.81",
"data_read_per_join": "3K"
},
"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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "115.21",
"data_read_per_join": "24K"
},
"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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "153.61",
"data_read_per_join": "19K"
},
"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 |
KSIPH-083-SBLK_LS.jpg |
800 |
800 |
N |
19805 |
8982 |
product |
21767 |
M |
0 |
|
21767 |
0 |
KSIPH-090-GOLG_LS.jpg |
800 |
800 |
N |
19806 |
8983 |
product |
21768 |
M |
0 |
|
21768 |
0 |
KSSA-045-SBLK_4_e2e7ad67-c119-44eb-a501-fde3a526a459.jpg |
800 |
800 |
N |
19809 |
8986 |
product |
21771 |
M |
0 |
|
21771 |
0 |
Moshi_Versa_Cover_For_iPad_2017_-_Sakura_Pink_1.jpg |
1177 |
1500 |
N |
19810 |
8987 |
product |
21772 |
M |
0 |
|
21772 |
0 |
MSHI-H-088061_LS.jpg |
800 |
800 |
N |
19814 |
8991 |
product |
21776 |
M |
0 |
|
21776 |
0 |
MSHI-H-090061_LS.jpg |
800 |
800 |
N |
19815 |
8992 |
product |
21777 |
M |
0 |
|
21777 |
0 |
MSHI-H-090901_LS.jpg |
800 |
800 |
N |
19816 |
8993 |
product |
21778 |
M |
0 |
|
21778 |
0 |
Sahara_White_3.jpg |
225 |
225 |
N |
19817 |
8994 |
product |
21779 |
M |
0 |
|
21779 |
0 |
Overture_iPhone_L_Black_01_Front.jpg |
4000 |
4000 |
N |
19818 |
8995 |
product |
21780 |
M |
0 |
|
21780 |
0 |
Overture_-_Daisy_Pink_2.jpg |
679 |
679 |
N |
19819 |
8996 |
product |
21781 |
M |
0 |
|
21781 |
0 |
MOSHI_Overture_for_iPhone_8_Plus_Daisy_Pink_2.jpg |
750 |
750 |
N |
19820 |
8997 |
product |
21782 |
M |
0 |
|
21782 |
0 |
MSHI-H-102302.jpg |
1600 |
1600 |
N |
19822 |
8999 |
product |
21784 |
M |
0 |
|
21784 |
0 |
StealthCover_iPhone_L_Pink_01_Front.jpg |
4000 |
4000 |
N |
19823 |
9000 |
product |
21785 |
M |
0 |
|
21785 |
0 |
Moshi_iPhone_X_Vitros_-_Clear.jpg |
450 |
450 |
N |
19824 |
9001 |
product |
21786 |
M |
0 |
|
21786 |
0 |
Moshi-Vitros-gunmetal_gray_2.jpg |
700 |
700 |
N |
19825 |
9002 |
product |
21787 |
M |
0 |
|
21787 |
0 |
Vitros_iPhone_M__Black_01_Front.jpg |
4000 |
4000 |
N |
19826 |
9003 |
product |
21788 |
M |
0 |
|
21788 |
0 |
Vitros_iPhone_L__Clear_01_Front.jpg |
4000 |
4000 |
N |
19827 |
9004 |
product |
21789 |
M |
0 |
|
21789 |
0 |
Vitros_iPhone_M__Silver_01_Front.jpg |
4000 |
4000 |
N |
19828 |
9005 |
product |
21790 |
M |
0 |
|
21790 |
0 |
Vitros_iPhone_L__Clear_05_Discrete.jpg |
4000 |
4000 |
N |
19829 |
9006 |
product |
21791 |
M |
0 |
|
21791 |
0 |
Vitros_-_Golden_Rose_1.jpg |
450 |
450 |
N |
19830 |
9007 |
product |
21792 |
M |
0 |
|
21792 |
0 |
Vitros_iPhone_M__Gold_01_Front.jpg |
4000 |
4000 |
N |
19831 |
9008 |
product |
21793 |
M |
0 |
|
21793 |
0 |
Vitros_iPhone_M__Clear_05_Discrete.jpg |
4000 |
4000 |
N |
19833 |
9010 |
product |
21795 |
M |
0 |
|
21795 |
0 |
MSHI-H-113101.jpg |
480 |
480 |
N |
19834 |
9011 |
product |
21796 |
M |
0 |
|
21796 |
0 |
iGlaze_iPhone_L_White_01_Front.jpg |
4000 |
4000 |
N |
19835 |
9012 |
product |
21797 |
M |
0 |
|
21797 |
0 |
iGlaze_iPhone_L_White_01_Front_6cb8d627-15c4-4b8d-b307-e47c767c981d.jpg |
4000 |
4000 |
N |
19837 |
9014 |
product |
21799 |
M |
0 |
|
21799 |
0 |
iGlaze_iPhone_L_White_01_Front_d9d23320-b092-4941-a3f4-9ec499aef424.jpg |
4000 |
4000 |
N |
19838 |
9015 |
product |
21800 |
M |
0 |
|
21800 |
0 |
MSHI-H-114001.jpg |
1600 |
1600 |
N |
19839 |
9016 |
product |
21801 |
M |
0 |
|
21801 |
0 |
Capto_L_LS_05.jpg |
4480 |
3881 |
N |
19840 |
9017 |
product |
21802 |
M |
0 |
|
21802 |
0 |
MSHI-H-114003.jpg |
1600 |
1600 |
N |
19841 |
9018 |
product |
21803 |
M |
0 |
|
21803 |
0 |
2_8g3o-hr.jpg |
640 |
626 |
N |
81495 |
8998 |
product |
83438 |
M |
0 |
|
83438 |
0 |
02.jpg |
1600 |
1600 |
N |
80727 |
9009 |
product |
82670 |
M |
1 |
|
82670 |
0 |
01_4tey-iy.jpg |
1600 |
1600 |
N |
80731 |
9013 |
product |
82674 |
M |
1 |
|
82674 |