Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "174.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` = 'M') and (`portal`.`q_images_links`.`object_id` in ('8764','8765','8766','8767','8768','8769','8770','8771','8772','8773','8774','8776','8788','8825','8826','8827','8828','8829','8830','8831','8832','8833','8834','8835','8841','8843','8844','8845','8846','8847')))",
"cost_info": {
"read_cost": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.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": "108.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": "144.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 |
CAT-DRPHX-BLKM_2.jpg |
1500 |
1500 |
N |
18920 |
8764 |
product |
20882 |
M |
0 |
|
20882 |
0 |
CAT-IPHOX-TEAL.jpg |
1024 |
1024 |
N |
18931 |
8765 |
product |
20893 |
M |
0 |
|
20893 |
0 |
2913728_iphone-xr__color_white_7011903.png.560x560.m80.jpg |
560 |
560 |
N |
18939 |
8767 |
product |
20901 |
M |
0 |
|
20901 |
0 |
120-1040-Casetify-CTF40876006511801-1_95661a9f-90d2-4823-ae1d-f580e28241da.jpg |
2624 |
2624 |
N |
18963 |
8771 |
product |
20925 |
M |
0 |
|
20925 |
0 |
120-1040-Casetify-CTF40876006511801-1_e10ca151-c212-4de7-bc76-409ba58e65ff.jpg |
2624 |
2624 |
N |
18967 |
8772 |
product |
20929 |
M |
0 |
|
20929 |
0 |
61dp58SpMuL._SX425.jpg |
425 |
425 |
N |
18971 |
8773 |
product |
20933 |
M |
0 |
|
20933 |
0 |
1aee5601befb94f52ae78634a9fc719b.jpg |
1564 |
2400 |
N |
18975 |
8774 |
product |
20937 |
M |
0 |
|
20937 |
0 |
EMT-333-200E-01.jpg |
1500 |
1174 |
N |
19025 |
8776 |
product |
20987 |
M |
0 |
|
20987 |
0 |
NU-CLIC-BLK-WD-NP17_LS.jpg |
800 |
800 |
N |
19065 |
8788 |
product |
21027 |
M |
0 |
|
21027 |
0 |
CAT-DRPHX-BLKL.jpg |
1500 |
1500 |
N |
19332 |
8825 |
product |
21294 |
M |
0 |
|
21294 |
0 |
CAT-DRPHX-BLKL_976f76e6-ea51-4255-9ab0-4a212bf91f10.jpg |
1500 |
1500 |
N |
19349 |
8828 |
product |
21311 |
M |
0 |
|
21311 |
0 |
CAT-DRPHX-BLKL_3_1d508ce8-34e3-4046-b99c-8d2d3c02486e.jpg |
1500 |
1500 |
N |
19358 |
8827 |
product |
21320 |
M |
0 |
|
21320 |
0 |
XR_Assembly_Black_1500x1500_8c4dd609-c151-4ede-95cf-a5c7b3215498_1024x1024_hplh-j2.jpg |
1024 |
1024 |
N |
19367 |
8828 |
product |
21329 |
M |
0 |
|
21329 |
0 |
CAT-DRPHX-BLKM.jpg |
1500 |
1500 |
N |
19376 |
8826 |
product |
21338 |
M |
0 |
|
21338 |
0 |
CAT-DRPHX-BLKL_3.jpg |
1500 |
1500 |
N |
19479 |
8829 |
product |
21441 |
M |
0 |
|
21441 |
0 |
CAT-DRPHX-BLKM_3.jpg |
1500 |
1500 |
N |
19488 |
8830 |
product |
21450 |
M |
0 |
|
21450 |
0 |
CAT-IPHO7P-BLK_LS.jpg |
800 |
800 |
N |
19497 |
8831 |
product |
21459 |
M |
0 |
|
21459 |
0 |
CAT-IPHO7P-BLK_LS2.jpg |
800 |
800 |
N |
19504 |
8832 |
product |
21466 |
M |
0 |
|
21466 |
0 |
CAT-IPHO7P-WHT_LS_3cb9a834-d597-40ac-ae36-0d2e5c011892.jpg |
800 |
800 |
N |
19511 |
8833 |
product |
21473 |
M |
0 |
|
21473 |
0 |
712TSVUL2nL._SL1500__z79a-pa.jpg |
1500 |
1500 |
N |
19520 |
8834 |
product |
21482 |
M |
0 |
|
21482 |
0 |
iPhoneX_WaterProof_Black__Website_Scaled_EP_1024x1024_b0c42967-0307-4564-b1ff-2f74083f632e_1024x1024.jpg |
1024 |
1024 |
N |
19534 |
8835 |
product |
21496 |
M |
0 |
|
21496 |
0 |
CLIC-SMO-AIR-7_LS.jpg |
800 |
800 |
N |
19573 |
8841 |
product |
21535 |
M |
0 |
|
21535 |
0 |
CM034690_LS.jpg |
800 |
800 |
N |
19594 |
8843 |
product |
21556 |
M |
0 |
|
21556 |
0 |
CM034760.jpg |
800 |
800 |
N |
19597 |
8844 |
product |
21559 |
M |
0 |
|
21559 |
0 |
cmi_VECTRA_KaratPetal_Purple_CM036174_1.png |
1000 |
1000 |
N |
19600 |
8845 |
product |
21562 |
M |
0 |
|
21562 |
0 |
CM036252_2.jpg |
560 |
560 |
N |
19602 |
8846 |
product |
21564 |
M |
0 |
|
21564 |
0 |
Case-Mate_iPhone_X_Squish_-_Iridescent_2.png |
700 |
700 |
N |
19605 |
8847 |
product |
21567 |
M |
0 |
|
21567 |
0 |
2_jkut-z6.jpg |
640 |
626 |
N |
77935 |
8766 |
product |
79878 |
M |
0 |
|
79878 |
0 |
2_jf00-at.jpg |
640 |
626 |
N |
82096 |
8768 |
product |
84039 |
M |
0 |
|
84039 |
0 |
2_ki2u-8i.jpg |
640 |
626 |
N |
82814 |
8770 |
product |
84757 |
M |
0 |
|
84757 |
0 |
2_z9ds-26.jpg |
640 |
626 |
N |
83053 |
8769 |
product |
84996 |
M |
0 |
|
84996 |