Query time 0.00187
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 ('32785','32786','32787','32788','32789','32790','32791','32792','32793','32794','32795','32796','32797','32798','32799','32800','32801','32802','32803','32804','32805','32806','32807','32808','32809','32810','32811','32812','32813','32814','32815','32816')))",
"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.image_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"
]
}
},
{
"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 |
|
|
|
|
43629 |
32785 |
product |
45591 |
M |
0 |
|
|
0 |
|
|
|
|
43633 |
32786 |
product |
45595 |
M |
0 |
|
|
0 |
|
|
|
|
43637 |
32787 |
product |
45599 |
M |
0 |
|
|
0 |
|
|
|
|
43641 |
32788 |
product |
45603 |
M |
0 |
|
|
0 |
|
|
|
|
43645 |
32789 |
product |
45607 |
M |
0 |
|
|
0 |
|
|
|
|
43649 |
32790 |
product |
45611 |
M |
0 |
|
|
0 |
|
|
|
|
43653 |
32791 |
product |
45615 |
M |
0 |
|
|
0 |
|
|
|
|
43657 |
32792 |
product |
45619 |
M |
0 |
|
|
0 |
|
|
|
|
43661 |
32793 |
product |
45623 |
M |
0 |
|
|
0 |
|
|
|
|
43665 |
32794 |
product |
45627 |
M |
0 |
|
|
0 |
|
|
|
|
43669 |
32795 |
product |
45631 |
M |
0 |
|
|
0 |
|
|
|
|
43673 |
32796 |
product |
45635 |
M |
0 |
|
|
0 |
|
|
|
|
43677 |
32797 |
product |
45639 |
M |
0 |
|
|
0 |
|
|
|
|
43681 |
32798 |
product |
45643 |
M |
0 |
|
|
0 |
|
|
|
|
43685 |
32799 |
product |
45647 |
M |
0 |
|
|
0 |
|
|
|
|
43689 |
32800 |
product |
45651 |
M |
0 |
|
|
0 |
|
|
|
|
43693 |
32801 |
product |
45655 |
M |
0 |
|
|
0 |
|
|
|
|
43697 |
32802 |
product |
45659 |
M |
0 |
|
|
0 |
|
|
|
|
43701 |
32803 |
product |
45663 |
M |
0 |
|
|
0 |
|
|
|
|
43705 |
32804 |
product |
45667 |
M |
0 |
|
|
0 |
|
|
|
|
43709 |
32805 |
product |
45671 |
M |
0 |
|
|
0 |
|
|
|
|
43713 |
32806 |
product |
45675 |
M |
0 |
|
|
0 |
|
|
|
|
43717 |
32807 |
product |
45679 |
M |
0 |
|
|
0 |
|
|
|
|
43721 |
32808 |
product |
45683 |
M |
0 |
|
|
0 |
|
|
|
|
43725 |
32809 |
product |
45687 |
M |
0 |
|
|
0 |
|
|
|
|
43729 |
32810 |
product |
45691 |
M |
0 |
|
|
0 |
|
|
|
|
43733 |
32811 |
product |
45695 |
M |
0 |
|
|
0 |
|
|
|
|
43737 |
32812 |
product |
45699 |
M |
0 |
|
|
0 |
|
|
|
|
43741 |
32813 |
product |
45703 |
M |
0 |
|
|
0 |
|
|
|
|
43745 |
32814 |
product |
45707 |
M |
0 |
|
|
0 |
|
|
|
|
43749 |
32815 |
product |
45711 |
M |
0 |
|
|
0 |
|
|
|
|
43753 |
32816 |
product |
45715 |
M |
0 |
|
|