Slow query SQL Server – Database Administrators Stack Exchange

I have a query that is taking too long to run.

i executed set statistics io on and set statistics time on , and I noticed that Scan count and logical reads are very high

Table ‘TABLE_01’. Scan count 6497248, logical reads 26065220, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server parse and compile time:
CPU time = 20 ms, elapsed time = 20 ms.

(138 row(s) affected)

SQL Server Execution Times:
CPU time = 28969 ms, elapsed time = 30559 ms.

here’s the query

SELECT Object1.Column1 AS Column2,
Object1.Column3 AS Column4,
Object1.Column5,
Object1.Column6,
Object1.Column7 AS Column8,
Object2.Column9 AS Column10,
Cast(Object2.Column11 AS VARCHAR) AS Column12,
Object2.Column13 AS Column14,
Object2.Column15 AS Column16,
Object2.Column17 AS Column18,
Object2.Column19 AS Column20,
Object3.Column21 AS Column22,
Object3.Column5 AS Column23,
Object2.Column24 AS Column25,
Object4.Column21 AS Column26,
Object4.Column5 AS Column27,
Object5.Column21 AS Column28,
Object5.Column29 AS
Column30,
Object6.Column31 AS Column32
FROM Object1
INNER JOIN (Object2
LEFT JOIN Object7 Object3
ON Object2.Column19 = Object3.Column19
INNER JOIN Object7 Object4
ON Object2.Column24 = Object4.Column19
INNER JOIN Object5
ON Object2.Column13 = Object5.Column15
INNER JOIN Object6
ON Object2.Column9 = Object6.Column9)
ON Object1.Column3 = Object2.Column3
WHERE Object1.Column3 IN (
43796020, 43795933, 43795931, 43795681,
43795672, 43793093, 43793090, 43793085,
43790358, 43790342, 43789167, 43789155,
43789154, 43788970, 43788928, 43788924,
43788776, 43788774, 43788712, 43788699,
43788674, 43788673, 43788626, 43788625,
43788227, 43788219, 43787557, 43787530,
43787088, 43787075, 43787063, 43787041,
43787002, 43786368, 43786351, 43786244,
43786243, 43786223, 43786222, 43786151,
43417954, 43417953, 43417929, 43417294,
43417293, 43417286, 43416500, 43416334,
43416304, 43416288, 43416089, 43416034,
43416016, 43416015, 43416014, 43416013,
43416012, 43416011, 43416010, 43416009,
43416008, 43416007, 43415753, 43401569,
43400701, 41524028, 41316604, 41311555,
41309174, 41308146, 41308136, 41286794,
41281375, 41281374, 41281294, 41263751,
41263749, 40960597, 38574969, 38133930,
38133868, 38133516, 38132482, 37630401,
37630400, 37630399, 37630398, 37630397,
37630396, 37630395, 37629851, 37629846,
37301414, 37298436, 37298433, 37298431,
37298429, 37298427, 37298424, 37298398
)
ORDER BY Object1.Column1 ASC

enter image description here

I would like to know how I can improve this query

Thanks.