Query time 0.00107
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "92.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "16.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": 16,
"rows_produced_per_join": 16,
"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 ('2899','2900','2901','2902','2903','2904','2905','2906','2907','2908','2909','2910','2911','2912','2913','2914')))",
"cost_info": {
"read_cost": "35.21",
"eval_cost": "3.20",
"prefix_cost": "38.41",
"data_read_per_join": "1K"
},
"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": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.00",
"eval_cost": "3.20",
"prefix_cost": "57.61",
"data_read_per_join": "12K"
},
"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": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.00",
"eval_cost": "3.20",
"prefix_cost": "76.81",
"data_read_per_join": "9K"
},
"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 |
ba795224815488f9b2b545cfd686ee51e795f0be_234cea4545ae74f5b8064790aeb9e1ad8564398c_Amouage_Beloved_Perfume_For_Women_EDP_100ml_7016663600-600x600.jpg |
600 |
600 |
N |
6327 |
2899 |
product |
8295 |
M |
0 |
|
8295 |
0 |
536931_fragrancex_EBAY_US.jpg |
500 |
500 |
N |
6328 |
2900 |
product |
8296 |
M |
0 |
|
8296 |
0 |
s-l1000_o8zj-zj.jpg |
800 |
800 |
N |
6329 |
2901 |
product |
8297 |
M |
0 |
|
8297 |
0 |
14777122206-7-700.jpg |
700 |
700 |
N |
6330 |
2902 |
product |
8298 |
M |
0 |
|
8298 |
0 |
701666316923_1.jpg |
530 |
663 |
N |
6331 |
2903 |
product |
8299 |
M |
0 |
|
8299 |
0 |
amouage-figment-eau-de-parfum-for-men-100-ml___7_1_.jpg |
657 |
777 |
N |
6332 |
2904 |
product |
8300 |
M |
0 |
|
8300 |
0 |
item_XL_39879868_157809679.jpg |
600 |
556 |
N |
6333 |
2905 |
product |
8301 |
M |
0 |
|
8301 |
0 |
701666340966.jpg |
500 |
500 |
N |
6334 |
2906 |
product |
8302 |
M |
0 |
|
8302 |
0 |
s-l1000_sy5y-di.jpg |
605 |
463 |
N |
6335 |
2907 |
product |
8303 |
M |
0 |
|
8303 |
0 |
701666129097-amouage-gold-women-set-edp-body-lotion-100-ml-300-ml-lana-parfumerija-niche-zagreb.jpg |
600 |
600 |
N |
6336 |
2908 |
product |
8304 |
M |
0 |
|
8304 |
0 |
0e237a8c7b205f9eb10be0994bb9020abadd6b48_8239df5cd32c250cecede31d75da207f7b21e782_Amouage_Honour_Perfume_For_Men_EDP_100ml_701666314929_-600x600.jpg |
600 |
600 |
N |
6337 |
2909 |
product |
8305 |
M |
0 |
|
8305 |
0 |
s-l1000_aqvg-uw.jpg |
940 |
750 |
N |
6338 |
2910 |
product |
8306 |
M |
0 |
|
8306 |
0 |
542f360e99064fb11b00013f.jpg |
412 |
477 |
N |
6339 |
2911 |
product |
8307 |
M |
0 |
|
8307 |
0 |
Amouage-Journey-Woman-Eau-De-Parfum-100ml-701666317128-30.jpg |
500 |
489 |
N |
6340 |
2912 |
product |
8308 |
M |
0 |
|
8308 |
0 |
9d755210f79fb2fe2ec2ff89d966a00929e26f67_f8cea365416c775a44c1ae508bbece4f1f9fb6cf_Amouage_Jubilation_XXV_Perfume_For_Men_EDP_100ml_70166-600x600.jpg |
600 |
600 |
N |
6341 |
2913 |
product |
8309 |
M |
0 |
|
8309 |
0 |
the_library_collection_opus_v_by_amouage_for_unisex_1.jpg |
560 |
389 |
N |
6342 |
2914 |
product |
8310 |
M |
0 |
|
8310 |