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 |
|
|