Query time 0.00431
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "170.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "71.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": 71,
"rows_produced_per_join": 71,
"filtered": "100.00",
"index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_type` = 'product') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`type` = 'M') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_id` in (3112,3113,3664,3665,2655,5683,6152,6153,6154,6155,2227,2226,4110,4111,3811,6054,6055,6056,6057,6058,6059,3042,3153,3377,3378,2522,2719,2728,6041,6042,6043,6044,6045,6046,6047,3385,3386,5948,6128,6127,6126,6129,6130,6131,6132,6133,6134,6135,3832,3831,3290,3289,3382,3383,5956,6087,6088,6089,6090,6091,6092,6093,6196,6195,6194,6197,6198,6199,6200,6201,6202)))",
"cost_info": {
"read_cost": "42.61",
"eval_cost": "7.10",
"prefix_cost": "49.71",
"data_read_per_join": "6K"
},
"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": [
"softwarepirmam_hewadelivard_cscart_4.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 71,
"filtered": "100.00",
"cost_info": {
"read_cost": "17.75",
"eval_cost": "7.10",
"prefix_cost": "74.56",
"data_read_per_join": "54K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res",
"transparent",
"cp_in_opt_list"
]
}
},
{
"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": [
"softwarepirmam_hewadelivard_cscart_4.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 71,
"filtered": "100.00",
"cost_info": {
"read_cost": "17.75",
"eval_cost": "7.10",
"prefix_cost": "99.41",
"data_read_per_join": "42K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
]
}
}
]
}
}
}
Result
| image_id |
image_path |
image_x |
image_y |
is_high_res |
transparent |
cp_in_opt_list |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
alt |
images_image_id |
| 0 |
5_1__2avq-a7.jpg |
600 |
600 |
N |
N |
Y |
14550 |
2226 |
product |
11113 |
M |
0 |
|
11113 |
| 0 |
6_2_.jpg |
600 |
600 |
N |
N |
Y |
14552 |
2227 |
product |
11114 |
M |
0 |
|
11114 |
| 0 |
Untitled_design_-_2025-07-20T101457.347.jpg |
600 |
600 |
N |
N |
Y |
17520 |
3112 |
product |
13125 |
M |
0 |
|
13125 |
| 0 |
Untitled_design_-_2025-07-20T101519.126_3pfl-75.jpg |
600 |
600 |
N |
N |
Y |
17523 |
3113 |
product |
13128 |
M |
0 |
|
13128 |
| 0 |
Untitled_design_-_2025-07-20T144309.388_df29-q1.jpg |
600 |
600 |
N |
N |
Y |
17804 |
2728 |
product |
13379 |
M |
0 |
|
13379 |
| 0 |
Untitled_design__4__awfk-fa.jpg |
600 |
600 |
N |
N |
Y |
18063 |
3289 |
product |
13626 |
M |
0 |
|
13626 |
| 0 |
5d061a43fc8608f2_CAB009-BLK_BoostChargePro_SilaCoreEntry_USB-CtoUSB-C_Front_WEB.jpg |
700 |
700 |
N |
N |
Y |
18065 |
3290 |
product |
13627 |
M |
0 |
|
13627 |
| 0 |
Untitled_design__32__2bit-vh.jpg |
600 |
600 |
N |
N |
Y |
18235 |
3377 |
product |
13777 |
M |
0 |
|
13777 |
| 0 |
G0hnbur9IS6B1zWykq8HHF5yGd6mSHBqz1zIGGcy.jpg |
800 |
800 |
N |
N |
Y |
18237 |
3378 |
product |
13778 |
M |
0 |
|
13778 |
| 0 |
Untitled_design_-_2025-07-26T233638.595.jpg |
600 |
600 |
N |
N |
Y |
18256 |
3382 |
product |
13796 |
M |
0 |
|
13796 |
| 0 |
Untitled_design_-_2025-07-26T233846.888.jpg |
600 |
600 |
N |
N |
Y |
18264 |
3383 |
product |
13800 |
M |
0 |
|
13800 |
| 0 |
Untitled_design_-_2025-07-27T001807.555.jpg |
600 |
600 |
N |
N |
Y |
18272 |
3385 |
product |
13808 |
M |
0 |
|
13808 |
| 0 |
Untitled_design_-_2025-07-27T002116.649.jpg |
600 |
600 |
N |
N |
Y |
18280 |
3386 |
product |
13812 |
M |
0 |
|
13812 |
| 0 |
Delivard_Product_Images_-_2025-07-27T212330.138.jpg |
600 |
600 |
N |
N |
Y |
18387 |
2655 |
product |
13913 |
M |
0 |
|
13913 |
| 0 |
Untitled_design_-_2025-08-04T170555.097.jpg |
600 |
600 |
N |
N |
Y |
19388 |
2522 |
product |
14793 |
M |
0 |
|
14793 |
| 0 |
Untitled_design_-_2025-08-04T180534.842.jpg |
600 |
600 |
N |
N |
Y |
19417 |
3664 |
product |
14819 |
M |
0 |
|
14819 |
| 0 |
Untitled_design_-_2025-08-04T180555.422.jpg |
600 |
600 |
N |
N |
Y |
19419 |
3665 |
product |
14820 |
M |
0 |
|
14820 |
| 0 |
Untitled_design_-_2025-08-06T153512.255.jpg |
600 |
600 |
N |
N |
Y |
19903 |
3831 |
product |
15146 |
M |
0 |
|
15146 |
| 0 |
Untitled_design_-_2025-08-06T165902.839.jpg |
600 |
600 |
N |
N |
Y |
19905 |
3832 |
product |
15147 |
M |
0 |
|
15147 |
| 0 |
Untitled_design_-_2025-08-06T205908.842.jpg |
600 |
600 |
N |
N |
Y |
19952 |
3042 |
product |
15173 |
M |
0 |
|
15173 |
| 0 |
Untitled_design_-_2025-08-06T205942.131_qvpj-0c.jpg |
600 |
600 |
N |
N |
Y |
19955 |
3153 |
product |
15176 |
M |
0 |
|
15176 |
| 0 |
Delivard_rwvy-vb.jpg |
900 |
900 |
N |
N |
Y |
20934 |
3811 |
product |
15940 |
M |
0 |
|
15940 |
| 0 |
Xbox_uyp9-wq_jmlv-li.jpg |
900 |
900 |
N |
N |
Y |
20946 |
4110 |
product |
15952 |
M |
0 |
|
15952 |
| 0 |
Xbox_templete_z7oa-bg.jpg |
900 |
900 |
N |
N |
Y |
20958 |
4111 |
product |
15964 |
M |
0 |
|
15964 |
| 0 |
30_-_2025-09-23T200441.007.jpg |
600 |
600 |
N |
N |
Y |
26244 |
5683 |
product |
19982 |
M |
0 |
|
19982 |
| 0 |
30_-_2025-09-27T230645.057.jpg |
600 |
600 |
N |
N |
Y |
27475 |
5948 |
product |
20846 |
M |
0 |
|
20846 |
| 0 |
30_-_2025-09-27T235510.415.jpg |
600 |
600 |
N |
N |
Y |
27507 |
5956 |
product |
20854 |
M |
0 |
|
20854 |
| 0 |
30_-_2025-10-01T205249.977.jpg |
600 |
600 |
N |
N |
Y |
28260 |
6041 |
product |
21256 |
M |
0 |
|
21256 |
| 0 |
30_-_2025-10-01T205713.375.jpg |
600 |
600 |
N |
N |
Y |
28270 |
6045 |
product |
21261 |
M |
0 |
|
21261 |
| 0 |
30_-_2025-10-01T205815.416.jpg |
600 |
600 |
N |
N |
Y |
28274 |
6043 |
product |
21262 |
M |
0 |
|
21262 |
| 0 |
0195950310085_z312ntfQ5UMBjk7A3NFOwSyjRhXyTBORjU9lMStw.webp |
800 |
800 |
N |
N |
Y |
28284 |
6047 |
product |
21257 |
M |
0 |
|
21257 |
| 0 |
0195950310122_uwn2hGnjyQK0FPd2hpP4CRBuS7Sdlbbjxr6OSOpK.webp |
800 |
800 |
N |
N |
Y |
28289 |
6046 |
product |
21258 |
M |
0 |
|
21258 |
| 0 |
apple_watch_series_10_ultramarine_sport_loop.jpg |
700 |
700 |
N |
N |
Y |
28291 |
6042 |
product |
21260 |
M |
0 |
|
21260 |
| 0 |
apple_watch_series_10_lake_green_sport_loop.jpg |
700 |
700 |
N |
N |
Y |
28299 |
6044 |
product |
21259 |
M |
0 |
|
21259 |
| 0 |
30_-_2025-10-01T205249.977_obrs-x5.jpg |
600 |
600 |
N |
N |
Y |
28347 |
6054 |
product |
21271 |
M |
0 |
|
21271 |
| 0 |
30_-_2025-10-01T205713.375_k6xn-64.jpg |
600 |
600 |
N |
N |
Y |
28356 |
6058 |
product |
21272 |
M |
0 |
|
21272 |
| 0 |
30_-_2025-10-01T205815.416_fcui-ai.jpg |
600 |
600 |
N |
N |
Y |
28359 |
6056 |
product |
21273 |
M |
0 |
|
21273 |
| 0 |
0195950310122_uwn2hGnjyQK0FPd2hpP4CRBuS7Sdlbbjxr6OSOpK_mxft-6i.webp |
800 |
800 |
N |
N |
Y |
28367 |
6059 |
product |
21274 |
M |
0 |
|
21274 |
| 0 |
apple_watch_series_10_lake_green_sport_loop_h0y2-a4.jpg |
700 |
700 |
N |
N |
Y |
28370 |
6057 |
product |
21275 |
M |
0 |
|
21275 |
| 0 |
apple_watch_series_10_ultramarine_sport_loop_rad3-zo.jpg |
700 |
700 |
N |
N |
Y |
28373 |
6055 |
product |
21276 |
M |
0 |
|
21276 |
| 0 |
30_-_2025-10-02T130314.078.jpg |
600 |
600 |
N |
N |
Y |
28458 |
6088 |
product |
21313 |
M |
0 |
|
21313 |
| 0 |
30_-_2025-10-02T130354.455.jpg |
600 |
600 |
N |
N |
Y |
28469 |
6092 |
product |
21314 |
M |
0 |
|
21314 |
| 0 |
30_-_2025-10-02T130414.418.jpg |
600 |
600 |
N |
N |
Y |
28477 |
6093 |
product |
21315 |
M |
0 |
|
21315 |
| 0 |
30_-_2025-10-02T130547.807.jpg |
600 |
600 |
N |
N |
Y |
28481 |
6090 |
product |
21316 |
M |
0 |
|
21316 |
| 0 |
30_-_2025-10-02T130859.871.jpg |
600 |
600 |
N |
N |
Y |
28487 |
6089 |
product |
21317 |
M |
0 |
|
21317 |
| 0 |
30_-_2025-10-02T131003.818.jpg |
600 |
600 |
N |
N |
Y |
28492 |
6087 |
product |
21318 |
M |
0 |
|
21318 |
| 0 |
30_-_2025-10-02T130709.940.jpg |
600 |
600 |
N |
N |
Y |
28503 |
6091 |
product |
21319 |
M |
0 |
|
21319 |
| 0 |
30_-_2025-10-02T234924.968_fvjx-ov.jpg |
600 |
600 |
N |
N |
Y |
28760 |
6133 |
product |
21398 |
M |
0 |
|
21398 |
| 0 |
stonge_grey_5x53-ch.jpeg |
4000 |
4000 |
N |
N |
Y |
28764 |
6127 |
product |
21397 |
M |
0 |
|
21397 |
| 0 |
MDRU4ref__1__bkk7-ws.jpeg |
1144 |
1144 |
N |
N |
Y |
28779 |
6132 |
product |
21393 |
M |
0 |
|
21393 |
| 0 |
refurb-40-se-nc-alum-silver-sport-band-denim_AV2_awii-4a.jpeg |
1144 |
1144 |
N |
N |
Y |
28785 |
6128 |
product |
21396 |
M |
0 |
|
21396 |
| 0 |
IMG-16719765_m_jpg_1__1__45ma-kj.webp |
4000 |
4000 |
N |
N |
Y |
28798 |
6131 |
product |
21390 |
M |
0 |
|
21390 |
| 0 |
midnight_j4p0-pn.jpg |
600 |
600 |
N |
N |
Y |
28803 |
6126 |
product |
21394 |
M |
0 |
|
21394 |
| 0 |
MYJ33ref_fce7-k3.jpeg |
1144 |
1144 |
N |
N |
Y |
28822 |
6135 |
product |
21395 |
M |
0 |
|
21395 |
| 0 |
MAXC4ref_tz6n-fa.jpeg |
1144 |
1144 |
N |
N |
Y |
28831 |
6134 |
product |
21391 |
M |
0 |
|
21391 |
| 0 |
MDRR4ref__1__2ode-3u.jpeg |
1144 |
1144 |
N |
N |
Y |
28837 |
6130 |
product |
21392 |
M |
0 |
|
21392 |
| 0 |
51nIkdI69XL._UF894,1000_QL80__tpi4-gj.jpg |
894 |
894 |
N |
N |
Y |
28846 |
6129 |
product |
21399 |
M |
0 |
|
21399 |
| 0 |
navy_black_finish.jpg |
600 |
600 |
N |
N |
Y |
28978 |
6154 |
product |
21419 |
M |
0 |
|
21419 |
| 0 |
ice_blue_black_finish.jpg |
600 |
600 |
N |
N |
Y |
28980 |
6152 |
product |
21417 |
M |
0 |
|
21417 |
| 0 |
ice_blue_natural_finish.jpg |
600 |
600 |
N |
N |
Y |
28987 |
6155 |
product |
21418 |
M |
0 |
|
21418 |
| 0 |
navy_natural_finish__2_.jpg |
600 |
600 |
N |
N |
Y |
28989 |
6153 |
product |
21420 |
M |
0 |
|
21420 |
| 0 |
30_-_2025-10-05T193829.620.jpg |
600 |
600 |
N |
N |
Y |
29226 |
6194 |
product |
21505 |
M |
0 |
|
21505 |
| 0 |
MDGN4.jpeg |
1144 |
1144 |
N |
N |
Y |
29240 |
6200 |
product |
21506 |
M |
0 |
|
21506 |
| 0 |
MYY13.jpeg |
1144 |
1144 |
N |
N |
Y |
29243 |
6195 |
product |
21507 |
M |
0 |
|
21507 |
| 0 |
MYY23.jpeg |
1144 |
1144 |
N |
N |
Y |
29254 |
6198 |
product |
21508 |
M |
0 |
|
21508 |
| 0 |
MYY43.jpeg |
1144 |
1144 |
N |
N |
Y |
29263 |
6199 |
product |
21509 |
M |
0 |
|
21509 |
| 0 |
MYY53.jpeg |
1144 |
1144 |
N |
N |
Y |
29273 |
6201 |
product |
21510 |
M |
0 |
|
21510 |
| 0 |
MYY73__1_.jpeg |
1144 |
1144 |
N |
N |
Y |
29282 |
6202 |
product |
21511 |
M |
0 |
|
21511 |
| 0 |
MYY83__1_.jpeg |
1144 |
1144 |
N |
N |
Y |
29284 |
6196 |
product |
21512 |
M |
0 |
|
21512 |
| 0 |
30_-_2025-10-05T193926.202.jpg |
600 |
600 |
N |
N |
Y |
29293 |
6197 |
product |
21513 |
M |
0 |
|
21513 |
| 0 |
Untitled_design_-_2025-07-20T144006.058.jpg |
600 |
600 |
N |
N |
Y |
17794 |
2719 |
product |
13369 |
M |
2 |
|
13369 |