SELECT 
  q_images.*, 
  q_images_links.*, 
  q_common_descriptions.description AS alt, 
  q_images.image_id AS images_image_id 
FROM 
  q_images_links 
  LEFT JOIN q_images ON q_images_links.image_id = q_images.image_id 
  LEFT JOIN q_common_descriptions ON q_common_descriptions.object_id = q_images.image_id 
  AND q_common_descriptions.object_holder = 'images' 
  AND q_common_descriptions.lang_code = 'en' 
WHERE 
  q_images_links.object_type = 'product' 
  AND q_images_links.type = 'A' 
  AND q_images_links.object_id IN (
    '790', '789', '788', '787', '786', '785', 
    '784', '783', '782', '781', '780', 
    '779', '778', '777', '776', '775', 
    '774', '773', '772', '771', '770', 
    '769', '768', '767', '766', '765', 
    '764', '763', '762', '761'
  ) 
ORDER BY 
  q_images_links.position, 
  q_images_links.pair_id

Query time 0.00238

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "500.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "98.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": 98,
            "rows_produced_per_join": 98,
            "filtered": "100.00",
            "index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('790','789','788','787','786','785','784','783','782','781','780','779','778','777','776','775','774','773','772','771','770','769','768','767','766','765','764','763','762','761')))",
            "cost_info": {
              "read_cost": "147.61",
              "eval_cost": "19.60",
              "prefix_cost": "167.21",
              "data_read_per_join": "9K"
            },
            "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": 98,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "98.00",
              "eval_cost": "19.60",
              "prefix_cost": "284.81",
              "data_read_per_join": "75K"
            },
            "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": 98,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "98.00",
              "eval_cost": "19.60",
              "prefix_cost": "402.41",
              "data_read_per_join": "58K"
            },
            "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 1789 761 product 3765 A 1
0 1794 762 product 3770 A 1
0 1800 763 product 3776 A 1
0 1805 764 product 3781 A 1
0 1810 765 product 3786 A 1
0 1814 766 product 3790 A 1
0 1820 767 product 3796 A 1
0 1825 768 product 3801 A 1
0 1830 769 product 3806 A 1
0 1836 770 product 3812 A 1
0 1841 771 product 3817 A 1
0 1847 772 product 3823 A 1
0 1851 773 product 3827 A 1
0 1861 775 product 3837 A 1
0 1865 776 product 3841 A 1
0 1870 777 product 3846 A 1
0 1875 778 product 3851 A 1
0 1879 779 product 3855 A 1
0 1883 780 product 3859 A 1
0 1887 781 product 3863 A 1
0 1891 782 product 3867 A 1
0 1897 783 product 3873 A 1
0 1902 784 product 3878 A 1
0 1907 785 product 3883 A 1
0 1913 786 product 3889 A 1
0 1919 787 product 3895 A 1
0 1923 788 product 3899 A 1
0 1928 789 product 3904 A 1
0 1933 790 product 3909 A 1
0 1790 761 product 3766 A 2
0 1795 762 product 3771 A 2
0 1801 763 product 3777 A 2
0 1806 764 product 3782 A 2
0 1811 765 product 3787 A 2
0 1815 766 product 3791 A 2
0 1821 767 product 3797 A 2
0 1826 768 product 3802 A 2
0 1831 769 product 3807 A 2
0 1837 770 product 3813 A 2
0 1842 771 product 3818 A 2
0 1848 772 product 3824 A 2
0 1852 773 product 3828 A 2
0 1862 775 product 3838 A 2
0 1866 776 product 3842 A 2
0 1871 777 product 3847 A 2
0 1876 778 product 3852 A 2
0 1880 779 product 3856 A 2
0 1884 780 product 3860 A 2
0 1888 781 product 3864 A 2
0 1892 782 product 3868 A 2
0 1898 783 product 3874 A 2
0 1903 784 product 3879 A 2
0 1908 785 product 3884 A 2
0 1914 786 product 3890 A 2
0 1920 787 product 3896 A 2
0 1924 788 product 3900 A 2
0 1929 789 product 3905 A 2
0 1934 790 product 3910 A 2
0 1791 761 product 3767 A 3
0 1796 762 product 3772 A 3
0 1802 763 product 3778 A 3
0 1807 764 product 3783 A 3
0 1812 765 product 3788 A 3
0 1816 766 product 3792 A 3
0 1822 767 product 3798 A 3
0 1827 768 product 3803 A 3
0 1832 769 product 3808 A 3
0 1838 770 product 3814 A 3
0 1843 771 product 3819 A 3
0 1849 772 product 3825 A 3
0 1853 773 product 3829 A 3
0 1863 775 product 3839 A 3
0 1867 776 product 3843 A 3
0 1872 777 product 3848 A 3
0 1877 778 product 3853 A 3
0 1881 779 product 3857 A 3
0 1885 780 product 3861 A 3
0 1889 781 product 3865 A 3
0 1893 782 product 3869 A 3
0 1899 783 product 3875 A 3
0 1904 784 product 3880 A 3
0 1909 785 product 3885 A 3
0 1915 786 product 3891 A 3
0 1921 787 product 3897 A 3
0 1925 788 product 3901 A 3
0 1930 789 product 3906 A 3
0 1935 790 product 3911 A 3
0 1792 761 product 3768 A 4
0 1797 762 product 3773 A 4
0 1803 763 product 3779 A 4
0 1808 764 product 3784 A 4
0 1823 767 product 3799 A 4
0 1828 768 product 3804 A 4
0 1833 769 product 3809 A 4
0 1839 770 product 3815 A 4
0 1844 771 product 3820 A 4
0 1854 773 product 3830 A 4
0 1868 776 product 3844 A 4
0 1873 777 product 3849 A 4
0 1890 781 product 3866 A 4
0 1894 782 product 3870 A 4
0 1900 783 product 3876 A 4
0 1905 784 product 3881 A 4
0 1910 785 product 3886 A 4
0 1916 786 product 3892 A 4
0 1926 788 product 3902 A 4
0 1931 789 product 3907 A 4
0 1798 762 product 3774 A 5
0 1834 769 product 3810 A 5
0 1845 771 product 3821 A 5
0 1895 782 product 3871 A 5
0 1911 785 product 3887 A 5
0 1917 786 product 3893 A 5
0 1856 774 product 3832 A 6
0 1857 774 product 3833 A 7
0 1858 774 product 3834 A 8
0 1859 774 product 3835 A 9