PgHero

Queries

Total Time Average Time Calls
30 min 6% 942 ms 1,929 odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (("res_partner"."active" = $1) AND (("res_partner"."name"::text ilike $2) OR (("res_partner"."mobile"::text ilike $3) OR (("res_partner"."city"::text ilike $4) OR (("res_partner"."email"::text ilike $5) OR (("res_partner"."phone"::text ilike $6) OR (("res_partner"."mobile2"::text ilike $7) OR (("res_partner"."ref"::text ilike $8) OR ("res_partner"."function"::text ilike $9))))))))) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $10 ) OR ("res_partner"."company_id" in ($11))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $12) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $13))) AND  (res_partner.email ilike $14
                           OR res_partner.display_name ilike $15
                           OR res_partner.ref ilike $16
                           OR res_partner.vat ilike $17)
                           -- don't panic, trust postgres bitmap
                     ORDER BY COALESCE(res_partner.customer_rank, $18) DESC, res_partner.display_name ilike $19 desc,
                              res_partner.display_name
                     limit $20
23 min 5% 369 ms 3,660 odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $1 ) OR ("res_partner"."company_id" in ($2))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $3) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $4))) AND  (res_partner.email ilike $5
                           OR res_partner.display_name ilike $6
                           OR res_partner.ref ilike $7
                           OR res_partner.vat ilike $8)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike $9 desc,
                              res_partner.display_name
22 min 5% 156 ms 8,546 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."sr_id" in ($1))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (sr_id)
18 min 4% 134 ms 8,171 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2,$3)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($18))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
16 min 3% 281 ms 3,390 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $8
14 min 3% 640 ms 1,321 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ((($1 OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."phone"::text ilike $2) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $3 ) OR ("res_partner"."company_id" in ($4))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $5) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $6))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile"::text ilike $7) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $8 ) OR ("res_partner"."company_id" in ($9))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $10) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $11))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile2"::text ilike $12) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $13 ) OR ("res_partner"."company_id" in ($14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $16))) ORDER BY  "res_partner"."id"  ))) AND (((("asm_sr"."service_center_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($139,$140))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $141
12 min 2% 108 ms 6,668 odoo14 
SELECT count($1) FROM "asm_so" WHERE (((("asm_so"."client_id" = $2) AND ("asm_so"."product_id" = $3)) AND (("asm_so"."id" != $4) OR "asm_so"."id" IS NULL)) AND "asm_so"."product_serial_warranty_id" IS NOT NULL)
12 min 2% 430 ms 1,610 odoo14 
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in (SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ($1,$2)))) AND ("mail_message"."author_id" = $3)) AND ("mail_message"."res_id" != $4)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != $5) OR "mail_message"."message_type" IS NULL)) ORDER BY  "mail_message"."id" DESC
11 min 2% 516 ms 1,265 odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE ("res_partner"."active" = $1) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $5))) AND  (res_partner.email ilike $6
                           OR res_partner.display_name ilike $7
                           OR res_partner.ref ilike $8
                           OR res_partner.vat ilike $9)
                           -- don't panic, trust postgres bitmap
                     ORDER BY COALESCE(res_partner.customer_rank, $10) DESC, res_partner.display_name ilike $11 desc,
                              res_partner.display_name
                     limit $12
10 min 2% 82 ms 7,398 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON asm_so (sr_id)
10 min 2% 230 ms 2,515 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80)) AND (((("asm_so"."service_center_id" in ($81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($203,$204))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
8 min 2% 124 ms 4,067 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
8 min 2% 138 ms 3,551 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($124,$125))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
8 min 2% 597 ms 809 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ((($1 OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."phone"::text ilike $2) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $3 ) OR ("res_partner"."company_id" in ($4))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $5) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $6))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile"::text ilike $7) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $8 ) OR ("res_partner"."company_id" in ($9))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $10) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $11))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile2"::text ilike $12) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $13 ) OR ("res_partner"."company_id" in ($14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $16))) ORDER BY  "res_partner"."id"  ))) AND (((("asm_sr"."service_center_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($137,$138))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $139
7 min 1% 169 ms 2,382 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($123,$124))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $125
7 min 1% 217 ms 1,825 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80)) AND (((("asm_so"."service_center_id" in ($81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($201,$202))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
7 min 1% 132 ms 2,986 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($122,$123))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
6 min 1% 144 ms 2,386 odoo14 
SELECT count($1) FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($124,$125)))
5 min 1% 159 ms 2,008 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
5 min 1.0% 161 ms 1,799 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($121,$122))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $123
5 min 1.0% 33 ms 8,476 odoo14 
SELECT "asm_signature".id FROM "asm_signature" WHERE ("asm_signature"."sr_id" in ($1)) ORDER BY  "asm_signature"."id"
Details
CREATE INDEX CONCURRENTLY ON asm_signature (sr_id)
4 min 0.9% 161 ms 1,650 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
4 min 0.9% 245 ms 1,064 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ("asm_sr"."sr_state_id" = $1) AND (((("asm_sr"."service_center_id" in ($2)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($3,$4,$5,$6)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($7,$8))) ORDER BY  "asm_sr"."name" DESC,"asm_sr"."id" DESC  LIMIT $9
4 min 0.9% 229 ms 1,119 odoo14 
UPDATE account_move SET write_date = write_date WHERE id = (
                SELECT id FROM account_move
                WHERE journal_id = $1 AND name != $2 AND date_trunc($3, date::timestamp without time zone) = date_trunc($4, $5::date)  AND sequence_prefix !~ $6  AND move_type NOT IN ($7, $8)  AND id != $9 
                AND sequence_prefix = (SELECT sequence_prefix FROM account_move WHERE journal_id = $10 AND name != $11 AND date_trunc($12, date::timestamp without time zone) = date_trunc($13, $14::date)  AND sequence_prefix !~ $15  AND move_type NOT IN ($16, $17)  AND id != $18  ORDER BY id DESC LIMIT $19)
                ORDER BY sequence_number DESC
                LIMIT $20
            )
            RETURNING name
4 min 0.8% 131 ms 1,800 odoo14 
SELECT count($1) FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($122,$123)))
4 min 0.8% 158 ms 1,468 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."url"::text like $1)) ORDER BY  "ir_attachment"."id" DESC
4 min 0.7% 15 ms 14,245 odoo14 
SELECT "asm_so"."id" as "id", "asm_so"."sr_id" as "sr_id", "asm_so"."sr_state_id" as "sr_state_id", "asm_so"."sr_state_type" as "sr_state_type", "asm_so"."so_type" as "so_type", "asm_so"."so_state_id" as "so_state_id", "asm_so"."is_closed" as "is_closed", "asm_so"."is_locked" as "is_locked", "asm_so"."name" as "name", "asm_so"."person_id" as "person_id", "asm_so"."car_id" as "car_id", "asm_so"."client_id" as "client_id", "asm_so"."client_type" as "client_type", "asm_so"."contract_id" as "contract_id", "asm_so"."service_center_id" as "service_center_id", "asm_so"."sr_type" as "sr_type", "asm_so"."pref_date_start" as "pref_date_start", "asm_so"."pref_date_end" as "pref_date_end", "asm_so"."diagnose_id" as "diagnose_id", "asm_so"."diagnose_description" as "diagnose_description", "asm_so"."diagnose_warranty" as "diagnose_warranty", "asm_so"."final_diagnose_id" as "final_diagnose_id", "asm_so"."final_diagnose_description" as "final_diagnose_description", "asm_so"."final_diagnose_warranty" as "final_diagnose_warranty", "asm_so"."scheduled_date" as "scheduled_date", "asm_so"."product_type" as "product_type", "asm_so"."service_to_charge" as "service_to_charge", "asm_so"."product_id" as "product_id", "asm_so"."product_brand" as "product_brand", "asm_so"."product_serial_id" as "product_serial_id", "asm_so"."product_serial_warranty_id" as "product_serial_warranty_id", "asm_so"."product_serial_warranty" as "product_serial_warranty", "asm_so"."current_product_serial_warranty" as "current_product_serial_warranty", "asm_so"."pricelist_id" as "pricelist_id", "asm_so"."invoice_count" as "invoice_count", "asm_so"."delivery_picking_id" as "delivery_picking_id", "asm_so"."pull_type" as "pull_type", "asm_so"."reg_warranty_id" as "reg_warranty_id", "asm_so"."reg_serial" as "reg_serial", "asm_so"."error_return" as "error_return", "asm_so"."error_warranty" as "error_warranty", "asm_so"."last_activity_time" as "last_activity_time", "asm_so"."diff_last_activity_create" as "diff_last_activity_create", "asm_so"."work_description" as "work_description", "asm_so"."related_soo_service_center_id" as "related_soo_service_center_id", "asm_so"."amount_paid" as "amount_paid", "asm_so"."invoice_amounts" as "invoice_amounts", "asm_so"."req_qty" as "req_qty", "asm_so"."waiting_qty" as "waiting_qty", "asm_so"."cancelled_qty" as "cancelled_qty", "asm_so"."rec_qty" as "rec_qty", "asm_so"."diff_qty" as "diff_qty", "asm_so"."installed_qty" as "installed_qty", "asm_so"."to_return_qty" as "to_return_qty", "asm_so"."returned_qty" as "returned_qty", "asm_so"."damaged_qty" as "damaged_qty", "asm_so"."rec_damaged_qty" as "rec_damaged_qty", "asm_so"."not_rec_damaged_qty" as "not_rec_damaged_qty", "asm_so"."req_cost" as "req_cost", "asm_so"."waiting_cost" as "waiting_cost", "asm_so"."cancelled_cost" as "cancelled_cost", "asm_so"."rec_cost" as "rec_cost", "asm_so"."diff_cost" as "diff_cost", "asm_so"."to_return_cost" as "to_return_cost", "asm_so"."returned_cost" as "returned_cost", "asm_so"."damaged_cost" as "damaged_cost", "asm_so"."rec_damaged_cost" as "rec_damaged_cost", "asm_so"."not_rec_damaged_cost" as "not_rec_damaged_cost", "asm_so"."installed_cost" as "installed_cost", "asm_so"."installed_price" as "installed_price", "asm_so"."installed_price_tax_exl" as "installed_price_tax_exl", "asm_so"."service_qty" as "service_qty", "asm_so"."service_price" as "service_price", "asm_so"."order_total_price" as "order_total_price", "asm_so"."message_main_attachment_id" as "message_main_attachment_id", "asm_so"."create_uid" as "create_uid", "asm_so"."create_date" as "create_date", "asm_so"."write_uid" as "write_uid", "asm_so"."write_date" as "write_date" FROM "asm_so" WHERE (((("asm_so"."service_center_id" in ($1,$2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($17))) AND "asm_so".id IN ($18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000, $1001, $1002, $1003, $1004, $1005, $1006, $1007, $1008, $1009, $1010, $1011, $1012, $1013, $1014, $1015, $1016, $1017)
4 min 0.7% 137 ms 1,569 odoo14 
SELECT "asm_products_used".id FROM "asm_products_used" WHERE ((("asm_products_used"."product_id" = $1) AND ("asm_products_used"."location_id" = $2)) AND ("asm_products_used"."is_moved" IS NULL or "asm_products_used"."is_moved" = $3 )) ORDER BY  "asm_products_used"."id"
3 min 0.7% 103 ms 2,034 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($16,$17,$18,$19,$20)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($21))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
3 min 0.7% 2,151 ms 97 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND (((((("asm_so"."create_date" >= $2) AND (("asm_so"."so_state_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($374)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $375 ) OR ("res_partner"."company_id" in ($376))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $377) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $378))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($379)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $380 ) OR ("res_partner"."company_id" in ($381))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $382) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $383))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($384)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $385 ) OR ("res_partner"."company_id" in ($386))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $387) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $388))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($389)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $390 ) OR ("res_partner"."company_id" in ($391))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $392) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $393))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($394)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $395 ) OR ("res_partner"."company_id" in ($396))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $397) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $398))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($399)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $400 ) OR ("res_partner"."company_id" in ($401))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $402) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $403))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($404)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $405 ) OR ("res_partner"."company_id" in ($406))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $407) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $408))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($409)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $410 ) OR ("res_partner"."company_id" in ($411))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $412) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $413))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($414)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $415 ) OR ("res_partner"."company_id" in ($416))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $417) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $418))) ORDER BY  "res_partner"."id"  ))))) AND (((("asm_so"."service_center_id" in ($419,$420,$421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($522,$523,$524,$525)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($526,$527))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
3 min 0.7% 800 ms 248 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ((($1 OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."phone"::text ilike $2) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $3 ) OR ("res_partner"."company_id" in ($4))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $5) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $6))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile"::text ilike $7) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $8 ) OR ("res_partner"."company_id" in ($9))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $10) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $11))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile2"::text ilike $12) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $13 ) OR ("res_partner"."company_id" in ($14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $16))) ORDER BY  "res_partner"."id"  ))) AND (((("asm_sr"."service_center_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($138,$139))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $140
3 min 0.6% 281 ms 681 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80)) AND (((("asm_so"."service_center_id" in ($81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($202,$203))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
3 min 0.6% 1,717 ms 109 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND (((((((("asm_so"."create_date" >= $2) AND (("asm_so"."so_state_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($374)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $375 ) OR ("res_partner"."company_id" in ($376))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $377) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $378))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($379)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $380 ) OR ("res_partner"."company_id" in ($381))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $382) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $383))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($384)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $385 ) OR ("res_partner"."company_id" in ($386))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $387) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $388))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($389)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $390 ) OR ("res_partner"."company_id" in ($391))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $392) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $393))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($394)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $395 ) OR ("res_partner"."company_id" in ($396))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $397) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $398))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($399)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $400 ) OR ("res_partner"."company_id" in ($401))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $402) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $403))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($404)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $405 ) OR ("res_partner"."company_id" in ($406))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $407) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $408))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($409)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $410 ) OR ("res_partner"."company_id" in ($411))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $412) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $413))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($414)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $415 ) OR ("res_partner"."company_id" in ($416))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $417) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $418))) ORDER BY  "res_partner"."id"  )))) AND ("asm_so"."so_type" = $419)) AND ("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $420) ORDER BY  "asm_service_center"."id"  )))) AND (((("asm_so"."service_center_id" in ($421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($524,$525,$526,$527)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($528,$529))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
3 min 0.6% 1,719 ms 107 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND ((((((("asm_so"."create_date" >= $2) AND (("asm_so"."so_state_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($374)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $375 ) OR ("res_partner"."company_id" in ($376))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $377) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $378))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($379)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $380 ) OR ("res_partner"."company_id" in ($381))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $382) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $383))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($384)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $385 ) OR ("res_partner"."company_id" in ($386))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $387) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $388))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($389)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $390 ) OR ("res_partner"."company_id" in ($391))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $392) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $393))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($394)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $395 ) OR ("res_partner"."company_id" in ($396))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $397) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $398))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($399)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $400 ) OR ("res_partner"."company_id" in ($401))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $402) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $403))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($404)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $405 ) OR ("res_partner"."company_id" in ($406))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $407) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $408))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($409)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $410 ) OR ("res_partner"."company_id" in ($411))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $412) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $413))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($414)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $415 ) OR ("res_partner"."company_id" in ($416))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $417) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $418))) ORDER BY  "res_partner"."id"  )))) AND ("asm_so"."so_type" = $419))) AND (((("asm_so"."service_center_id" in ($420,$421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($523,$524,$525,$526)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($527,$528))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
3 min 0.6% 186 ms 926 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
3 min 0.6% 194 ms 848 odoo14 
SELECT count($1) FROM "asm_sr" WHERE ("asm_sr"."sr_state_id" = $2) AND (((("asm_sr"."service_center_id" in ($3)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($4,$5,$6,$7)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($8,$9)))
3 min 0.6% 165 ms 1,000 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ("asm_sr"."product_type" in ($1)) ORDER BY  "asm_sr"."name" DESC,"asm_sr"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON asm_sr (product_type, name)
3 min 0.5% 132 ms 1,161 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."client_id" = $1) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($124,$125))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $126
2 min 0.5% 182 ms 820 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 145 ms 988 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND ("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $2) ORDER BY  "asm_service_center"."id"  ))) AND (((("asm_so"."service_center_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($37,$38))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
2 min 0.5% 186 ms 771 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 0 ms 1,727,662 odoo14 
DISCARD ALL
2 min 0.5% 4 ms 38,437 odoo14 
SELECT "asm_sr"."id" as "id", "asm_sr"."product_type" as "product_type" FROM "asm_sr" WHERE "asm_sr".id IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000)
2 min 0.5% 186 ms 736 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 1,103 ms 124 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "sr_state_id_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."sr_state_id" as "sr_state_id" 
            FROM "asm_sr" LEFT JOIN "asm_state" AS "asm_sr__sr_state_id" ON ("asm_sr"."sr_state_id" = "asm_sr__sr_state_id"."id") LEFT JOIN "ir_translation" AS "asm_sr__sr_state_id__name" ON ("asm_sr__sr_state_id"."id" = "asm_sr__sr_state_id__name"."res_id" AND "asm_sr__sr_state_id__name"."type" = $1 AND "asm_sr__sr_state_id__name"."name" = $2 AND "asm_sr__sr_state_id__name"."lang" = $3 AND "asm_sr__sr_state_id__name"."value" != $4)
            WHERE ((((((("asm_sr"."create_date" >= $5) AND ((((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($6)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $7 ) OR ("res_partner"."company_id" in ($8))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $9) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $10))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($11)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $12 ) OR ("res_partner"."company_id" in ($13))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $14) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $15))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($16)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $17 ) OR ("res_partner"."company_id" in ($18))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $19) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $20))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($21,$22)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $23 ) OR ("res_partner"."company_id" in ($24))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $25) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $26))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($27)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $28 ) OR ("res_partner"."company_id" in ($29))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $30) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $31))) ORDER BY  "res_partner"."id"  )))) AND (("asm_sr"."sr_type" != $32) OR "asm_sr"."sr_type" IS NULL)) AND (("asm_sr"."sr_state_id" in ($33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,$399,$400,$401,$402,$403,$404,$405,$406,$407,$408,$409,$410,$411,$412,$413,$414)) OR "asm_sr"."sr_state_id" IS NULL)) AND (((("asm_sr"."service_center_id" in ($415,$416,$417,$418,$419,$420,$421,$422,$423)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($436,$437)))
            GROUP BY "asm_sr"."sr_state_id","asm_sr__sr_state_id"."sequence",COALESCE("asm_sr__sr_state_id__name"."value","asm_sr__sr_state_id"."name"),"asm_sr__sr_state_id"."id"
            ORDER BY  "asm_sr__sr_state_id"."sequence" ,COALESCE("asm_sr__sr_state_id__name"."value", "asm_sr__sr_state_id"."name") ,"asm_sr__sr_state_id"."id"  
            LIMIT $438
2 min 0.5% 0 ms 790,374 odoo14 
INSERT INTO "asm_products" ("id", "create_uid", "create_date", "write_uid", "write_date", "location_id", "product_id", "product_uom_id", "product_uom_qty", "so_id", "sr_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11) RETURNING id
2 min 0.5% 186 ms 728 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 178 ms 759 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 126 ms 1,068 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($23,$24))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
2 min 0.5% 187 ms 716 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.5% 2 ms 60,259 odoo14 
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."credit_limit" as "credit_limit", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."city" as "city", "res_partner"."state_id" as "state_id", "res_partner"."country_id" as "country_id", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."city_id" as "city_id", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", "res_partner"."partner_type" as "partner_type", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."warning_stage" as "warning_stage", "res_partner"."blocking_stage" as "blocking_stage", "res_partner"."active_limit" as "active_limit", "res_partner"."followup_status" as "followup_status", "res_partner"."mobile2" as "mobile2", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" WHERE "res_partner".id IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212)
2 min 0.4% 119 ms 1,111 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."client_id" = $1) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($122,$123))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $124
2 min 0.4% 206 ms 630 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($122,$123))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $124
2 min 0.4% 234 ms 550 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ("asm_sr"."name"::text ilike $1) AND (((("asm_sr"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($124,$125))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $126
2 min 0.4% 2,290 ms 55 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (("asm_sr"."client_type" = $1) AND (("asm_sr"."sr_state_id" = $2) AND (((((((("asm_sr"."sr_state_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96)) OR "asm_sr"."sr_state_id" IS NULL) AND (("asm_sr"."sr_state_id" in ($97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386)) OR "asm_sr"."sr_state_id" IS NULL)) AND ("asm_sr"."create_date" > $387)) AND ((((((((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($388)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $389 ) OR ("res_partner"."company_id" in ($390))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $391) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $392))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($393)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $394 ) OR ("res_partner"."company_id" in ($395))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $396) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $397))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($398)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $399 ) OR ("res_partner"."company_id" in ($400))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $401) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $402))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($403)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $404 ) OR ("res_partner"."company_id" in ($405))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $406) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $407))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($408)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $409 ) OR ("res_partner"."company_id" in ($410))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $411) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $412))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($413)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $414 ) OR ("res_partner"."company_id" in ($415))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $416) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $417))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($418)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $419 ) OR ("res_partner"."company_id" in ($420))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $421) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $422))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($423)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $424 ) OR ("res_partner"."company_id" in ($425))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $426) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $427))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($428)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $429 ) OR ("res_partner"."company_id" in ($430))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $431) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $432))) ORDER BY  "res_partner"."id"  )))) AND (("asm_sr"."sr_type" != $433) OR "asm_sr"."sr_type" IS NULL)))) AND (((("asm_sr"."service_center_id" in ($434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535,$536)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($537,$538,$539,$540)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($541,$542))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $543
2 min 0.4% 184 ms 636 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.4% 164 ms 701 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($123,$124))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
2 min 0.4% 188 ms 605 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.4% 186 ms 598 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.4% 337 ms 316 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND ((((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7))) AND (("asm_so"."person_id" = $8) AND ((("asm_so"."so_state_id" in ($9)) OR ("asm_so"."so_state_id" in ($10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23))) OR $24))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $25
2 min 0.4% 120 ms 875 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (((("asm_so"."service_center_id" in ($1)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($2,$3,$4,$5)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($6))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $7
2 min 0.3% 164 ms 630 odoo14 
SELECT count($1) FROM "asm_sr" WHERE (((("asm_sr"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($123,$124)))
2 min 0.3% 113 ms 900 odoo14 
SELECT count($1) FROM "asm_so" WHERE (((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7)))
2 min 0.3% 115 ms 867 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($18))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
2 min 0.3% 615 ms 161 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "client_type_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."client_type" as "client_type" 
            FROM "asm_sr"
            WHERE ((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($1)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $5))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($6)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $7 ) OR ("res_partner"."company_id" in ($8))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $9) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $10))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($11)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $12 ) OR ("res_partner"."company_id" in ($13))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $14) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $15))) ORDER BY  "res_partner"."id"  ))) AND (((("asm_sr"."service_center_id" in ($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($34,$35,$36,$37,$38)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($39,$40)))
            GROUP BY "asm_sr"."client_type"
            ORDER BY "client_type"
            LIMIT $41
2 min 0.3% 574 ms 166 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "sr_type_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."sr_type" as "sr_type" 
            FROM "asm_sr"
            WHERE (("asm_sr"."client_type" = $1) AND ((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($2)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $3 ) OR ("res_partner"."company_id" in ($4))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $5) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $6))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($7)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $8 ) OR ("res_partner"."company_id" in ($9))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $10) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $11))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($12)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $13 ) OR ("res_partner"."company_id" in ($14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $16))) ORDER BY  "res_partner"."id"  )))) AND (((("asm_sr"."service_center_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($35,$36,$37,$38,$39)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($40,$41)))
            GROUP BY "asm_sr"."sr_type"
            ORDER BY "sr_type"
2 min 0.3% 170 ms 546 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.3% 182 ms 510 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
2 min 0.3% 2 ms 59,497 odoo14 
SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $213 ) OR ("res_partner"."company_id" in ($214))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $215) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $216))) ORDER BY  "res_partner"."display_name"
2 min 0.3% 648 ms 139 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "sr_state_id_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."sr_state_id" as "sr_state_id" 
            FROM "asm_sr" LEFT JOIN "asm_state" AS "asm_sr__sr_state_id" ON ("asm_sr"."sr_state_id" = "asm_sr__sr_state_id"."id") LEFT JOIN "ir_translation" AS "asm_sr__sr_state_id__name" ON ("asm_sr__sr_state_id"."id" = "asm_sr__sr_state_id__name"."res_id" AND "asm_sr__sr_state_id__name"."type" = $1 AND "asm_sr__sr_state_id__name"."name" = $2 AND "asm_sr__sr_state_id__name"."lang" = $3 AND "asm_sr__sr_state_id__name"."value" != $4)
            WHERE ((($5 OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."phone"::text ilike $6) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $7 ) OR ("res_partner"."company_id" in ($8))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $9) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $10))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile"::text ilike $11) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $12 ) OR ("res_partner"."company_id" in ($13))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $14) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $15))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile2"::text ilike $16) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $17 ) OR ("res_partner"."company_id" in ($18))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $19) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $20))) ORDER BY  "res_partner"."id"  ))) AND (((("asm_sr"."service_center_id" in ($21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($143,$144)))
            GROUP BY "asm_sr"."sr_state_id","asm_sr__sr_state_id"."sequence",COALESCE("asm_sr__sr_state_id__name"."value","asm_sr__sr_state_id"."name"),"asm_sr__sr_state_id"."id"
            ORDER BY  "asm_sr__sr_state_id"."sequence" ,COALESCE("asm_sr__sr_state_id__name"."value", "asm_sr__sr_state_id"."name") ,"asm_sr__sr_state_id"."id"  
            LIMIT $145
1 min 0.3% 189 ms 465 odoo14 
SELECT "ir_attachment".id FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IS NULL  AND ("ir_attachment"."activity_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12))) ORDER BY  "ir_attachment"."id" DESC
Details
CREATE INDEX CONCURRENTLY ON ir_attachment (activity_line_id)
1 min 0.3% 611 ms 142 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (("asm_sr"."sr_state_id" = $1) AND ((($2 OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."phone"::text ilike $3) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $4 ) OR ("res_partner"."company_id" in ($5))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $6) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $7))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile"::text ilike $8) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $9 ) OR ("res_partner"."company_id" in ($10))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $11) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $12))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."mobile2"::text ilike $13) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $14 ) OR ("res_partner"."company_id" in ($15))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $16) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $17))) ORDER BY  "res_partner"."id"  )))) AND (((("asm_sr"."service_center_id" in ($18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($140,$141))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $142
1 min 0.3% 482 ms 180 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "sr_state_id_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."sr_state_id" as "sr_state_id" 
            FROM "asm_sr" LEFT JOIN "asm_state" AS "asm_sr__sr_state_id" ON ("asm_sr"."sr_state_id" = "asm_sr__sr_state_id"."id") LEFT JOIN "ir_translation" AS "asm_sr__sr_state_id__name" ON ("asm_sr__sr_state_id"."id" = "asm_sr__sr_state_id__name"."res_id" AND "asm_sr__sr_state_id__name"."type" = $1 AND "asm_sr__sr_state_id__name"."name" = $2 AND "asm_sr__sr_state_id__name"."lang" = $3 AND "asm_sr__sr_state_id__name"."value" != $4)
            WHERE (("asm_sr"."sr_type" = $5) AND (("asm_sr"."client_type" = $6) AND ((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($7)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $8 ) OR ("res_partner"."company_id" in ($9))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $10) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $11))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($12)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $13 ) OR ("res_partner"."company_id" in ($14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $16))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($17)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $18 ) OR ("res_partner"."company_id" in ($19))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $20) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $21))) ORDER BY  "res_partner"."id"  ))))) AND (((("asm_sr"."service_center_id" in ($22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($40,$41,$42,$43,$44)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($45,$46)))
            GROUP BY "asm_sr"."sr_state_id","asm_sr__sr_state_id"."sequence",COALESCE("asm_sr__sr_state_id__name"."value","asm_sr__sr_state_id"."name"),"asm_sr__sr_state_id"."id"
            ORDER BY  "asm_sr__sr_state_id"."sequence" ,COALESCE("asm_sr__sr_state_id__name"."value", "asm_sr__sr_state_id"."name") ,"asm_sr__sr_state_id"."id"
1 min 0.3% 172 ms 492 odoo14 
UPDATE "asm_products" SET "contract_id"=$1,"product_qty"=$2,"service_center_id"=$3,"write_uid"=$4,"write_date"=(now() at time zone $5) WHERE id IN ($6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000, $1001, $1002, $1003, $1004, $1005)
1 min 0.3% 862 ms 95 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (("asm_sr"."sr_state_id" = $1) AND ((((((("asm_sr"."create_date" >= $2) AND ((((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($3)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $4 ) OR ("res_partner"."company_id" in ($5))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $6) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $7))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($8)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $9 ) OR ("res_partner"."company_id" in ($10))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $11) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $12))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($13)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $14 ) OR ("res_partner"."company_id" in ($15))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $16) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $17))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($18,$19)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $20 ) OR ("res_partner"."company_id" in ($21))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $22) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $23))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($24)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $25 ) OR ("res_partner"."company_id" in ($26))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $27) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $28))) ORDER BY  "res_partner"."id"  )))) AND (("asm_sr"."sr_type" != $29) OR "asm_sr"."sr_type" IS NULL)) AND (("asm_sr"."sr_state_id" in ($30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,$399,$400,$401,$402,$403,$404,$405,$406,$407,$408,$409,$410,$411)) OR "asm_sr"."sr_state_id" IS NULL))) AND (((("asm_sr"."service_center_id" in ($412,$413,$414,$415,$416,$417,$418,$419,$420)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($433,$434))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $435
1 min 0.3% 132 ms 618 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($105,$106,$107,$108)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($109,$110))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.3% 134 ms 602 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE "asm_so"."client_id" IS NULL  AND (((("asm_so"."service_center_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($121,$122))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $123
1 min 0.3% 2,356 ms 34 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."client_type" = $1) AND (("asm_so"."so_state_id" = $2) AND (((((((("asm_so"."create_date" >= $3) AND (("asm_so"."so_state_id" in ($4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($375)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $376 ) OR ("res_partner"."company_id" in ($377))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $378) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $379))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($380)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $381 ) OR ("res_partner"."company_id" in ($382))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $383) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $384))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($385)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $386 ) OR ("res_partner"."company_id" in ($387))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $388) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $389))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($390)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $391 ) OR ("res_partner"."company_id" in ($392))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $393) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $394))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($395)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $396 ) OR ("res_partner"."company_id" in ($397))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $398) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $399))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($400)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $401 ) OR ("res_partner"."company_id" in ($402))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $403) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $404))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($405)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $406 ) OR ("res_partner"."company_id" in ($407))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $408) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $409))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($410)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $411 ) OR ("res_partner"."company_id" in ($412))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $413) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $414))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($415)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $416 ) OR ("res_partner"."company_id" in ($417))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $418) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $419))) ORDER BY  "res_partner"."id"  )))) AND ("asm_so"."so_type" = $420)) AND ("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $421) ORDER BY  "asm_service_center"."id"  ))))) AND (((("asm_so"."service_center_id" in ($422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($525,$526,$527,$528)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($529,$530))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.3% 305 ms 257 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND ((((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6,$7)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($8,$9))) AND (("asm_so"."person_id" = $10) AND ((("asm_so"."so_state_id" in ($11)) OR ("asm_so"."so_state_id" in ($12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25))) OR $26))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $27
1 min 0.3% 119 ms 660 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ((((("asm_so"."service_center_id" in ($1)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($2,$3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7))) AND (("asm_so"."person_id" = $8) AND ((("asm_so"."so_state_id" in ($9)) OR ("asm_so"."so_state_id" in ($10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23))) OR $24))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $25
1 min 0.3% 122 ms 629 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($20,$21,$22,$23,$24)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($25))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.3% 222 ms 339 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE ("asm_sr"."name"::text ilike $1) AND (((("asm_sr"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($122,$123))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $124
1 min 0.3% 122 ms 613 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE "asm_so"."client_id" IS NULL  AND (((("asm_so"."service_center_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($123,$124))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $125
1 min 0.2% 20 ms 3,567 odoo14 
SELECT "product_warranty".id FROM "product_warranty" WHERE ("product_warranty"."lot_id" in ($1)) ORDER BY  "product_warranty"."id"
Details
CREATE INDEX CONCURRENTLY ON product_warranty (lot_id)
1 min 0.2% 121 ms 583 odoo14 
SELECT min("asm_so".id) AS id, count("asm_so".id) AS "so_state_id_count" , sum("asm_so"."diff_last_activity_create") AS "diff_last_activity_create","asm_so"."so_state_id" as "so_state_id" 
            FROM "asm_so" LEFT JOIN "asm_state" AS "asm_so__so_state_id" ON ("asm_so"."so_state_id" = "asm_so__so_state_id"."id") LEFT JOIN "ir_translation" AS "asm_so__so_state_id__name" ON ("asm_so__so_state_id"."id" = "asm_so__so_state_id__name"."res_id" AND "asm_so__so_state_id__name"."type" = $1 AND "asm_so__so_state_id__name"."name" = $2 AND "asm_so__so_state_id__name"."lang" = $3 AND "asm_so__so_state_id__name"."value" != $4)
            WHERE (((("asm_so"."service_center_id" in ($5)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($6,$7,$8,$9)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($10)))
            GROUP BY "asm_so"."so_state_id","asm_so__so_state_id"."sequence",COALESCE("asm_so__so_state_id__name"."value","asm_so__so_state_id"."name"),"asm_so__so_state_id"."id"
            ORDER BY  "asm_so__so_state_id"."sequence" ,COALESCE("asm_so__so_state_id__name"."value", "asm_so__so_state_id"."name") ,"asm_so__so_state_id"."id"  
            LIMIT $11
1 min 0.2% 1,104 ms 63 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND (((((((("asm_so"."create_date" >= $2) AND (("asm_so"."so_state_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($374)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $375 ) OR ("res_partner"."company_id" in ($376))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $377) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $378))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($379)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $380 ) OR ("res_partner"."company_id" in ($381))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $382) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $383))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($384)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $385 ) OR ("res_partner"."company_id" in ($386))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $387) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $388))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($389)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $390 ) OR ("res_partner"."company_id" in ($391))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $392) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $393))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($394)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $395 ) OR ("res_partner"."company_id" in ($396))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $397) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $398))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($399)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $400 ) OR ("res_partner"."company_id" in ($401))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $402) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $403))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($404)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $405 ) OR ("res_partner"."company_id" in ($406))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $407) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $408))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($409)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $410 ) OR ("res_partner"."company_id" in ($411))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $412) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $413))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($414)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $415 ) OR ("res_partner"."company_id" in ($416))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $417) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $418))) ORDER BY  "res_partner"."id"  )))) AND ("asm_so"."so_type" = $419)) AND (("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $420) ORDER BY  "asm_service_center"."id"  )) OR ("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $421) ORDER BY  "asm_service_center"."id"  ))))) AND (((("asm_so"."service_center_id" in ($422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($525,$526,$527,$528)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($529,$530))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.2% 1,959 ms 35 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "client_type_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."client_type" as "client_type" 
            FROM "asm_sr"
            WHERE (("asm_sr"."sr_state_id" = $1) AND (((((((("asm_sr"."sr_state_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95)) OR "asm_sr"."sr_state_id" IS NULL) AND (("asm_sr"."sr_state_id" in ($96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385)) OR "asm_sr"."sr_state_id" IS NULL)) AND ("asm_sr"."create_date" > $386)) AND ((((((((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($387)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $388 ) OR ("res_partner"."company_id" in ($389))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $390) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $391))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($392)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $393 ) OR ("res_partner"."company_id" in ($394))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $395) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $396))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($397)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $398 ) OR ("res_partner"."company_id" in ($399))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $400) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $401))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($402)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $403 ) OR ("res_partner"."company_id" in ($404))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $405) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $406))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($407)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $408 ) OR ("res_partner"."company_id" in ($409))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $410) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $411))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($412)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $413 ) OR ("res_partner"."company_id" in ($414))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $415) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $416))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($417)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $418 ) OR ("res_partner"."company_id" in ($419))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $420) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $421))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($422)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $423 ) OR ("res_partner"."company_id" in ($424))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $425) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $426))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($427)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $428 ) OR ("res_partner"."company_id" in ($429))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $430) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $431))) ORDER BY  "res_partner"."id"  )))) AND (("asm_sr"."sr_type" != $432) OR "asm_sr"."sr_type" IS NULL))) AND (((("asm_sr"."service_center_id" in ($433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($536,$537,$538,$539)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($540,$541)))
            GROUP BY "asm_sr"."client_type"
            ORDER BY "client_type"
1 min 0.2% 117 ms 576 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."so_state_id" = $1) AND (((("asm_so"."service_center_id" in ($2)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($3,$4,$5,$6)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($7,$8))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.2% 392 ms 172 odoo14 
SELECT "asm_sr".id FROM "asm_sr" WHERE (("asm_sr"."sr_state_id" = $1) AND (("asm_sr"."sr_type" = $2) AND (("asm_sr"."client_type" = $3) AND ((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($4)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $5 ) OR ("res_partner"."company_id" in ($6))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $7) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $8))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($9)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $10 ) OR ("res_partner"."company_id" in ($11))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $12) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $13))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($14)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $15 ) OR ("res_partner"."company_id" in ($16))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $17) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $18))) ORDER BY  "res_partner"."id"  )))))) AND (((("asm_sr"."service_center_id" in ($19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($37,$38,$39,$40,$41)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($42,$43))) ORDER BY  "asm_sr"."call_date" DESC  LIMIT $44
1 min 0.2% 2,093 ms 32 odoo14 
SELECT min("asm_sr".id) AS id, count("asm_sr".id) AS "sr_state_id_count" , sum("asm_sr"."diff_last_activity_create") AS "diff_last_activity_create",sum("asm_sr"."so_count") AS "so_count","asm_sr"."sr_state_id" as "sr_state_id" 
            FROM "asm_sr" LEFT JOIN "asm_state" AS "asm_sr__sr_state_id" ON ("asm_sr"."sr_state_id" = "asm_sr__sr_state_id"."id") LEFT JOIN "ir_translation" AS "asm_sr__sr_state_id__name" ON ("asm_sr__sr_state_id"."id" = "asm_sr__sr_state_id__name"."res_id" AND "asm_sr__sr_state_id__name"."type" = $1 AND "asm_sr__sr_state_id__name"."name" = $2 AND "asm_sr__sr_state_id__name"."lang" = $3 AND "asm_sr__sr_state_id__name"."value" != $4)
            WHERE (((((((("asm_sr"."sr_state_id" in ($5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98)) OR "asm_sr"."sr_state_id" IS NULL) AND (("asm_sr"."sr_state_id" in ($99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287,$288,$289)) OR "asm_sr"."sr_state_id" IS NULL)) AND (("asm_sr"."sr_state_id" in ($290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388)) OR "asm_sr"."sr_state_id" IS NULL)) AND ("asm_sr"."create_date" > $389)) AND ((((((((("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($390)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $391 ) OR ("res_partner"."company_id" in ($392))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $393) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $394))) ORDER BY  "res_partner"."id"  )) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($395)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $396 ) OR ("res_partner"."company_id" in ($397))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $398) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $399))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($400)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $401 ) OR ("res_partner"."company_id" in ($402))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $403) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $404))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($405)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $406 ) OR ("res_partner"."company_id" in ($407))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $408) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $409))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($410)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $411 ) OR ("res_partner"."company_id" in ($412))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $413) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $414))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($415)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $416 ) OR ("res_partner"."company_id" in ($417))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $418) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $419))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($420)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $421 ) OR ("res_partner"."company_id" in ($422))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $423) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $424))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($425)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $426 ) OR ("res_partner"."company_id" in ($427))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $428) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $429))) ORDER BY  "res_partner"."id"  ))) OR ("asm_sr"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($430)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $431 ) OR ("res_partner"."company_id" in ($432))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $433) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $434))) ORDER BY  "res_partner"."id"  )))) AND (("asm_sr"."sr_type" != $435) OR "asm_sr"."sr_type" IS NULL)) AND (((("asm_sr"."service_center_id" in ($436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535,$536,$537,$538)) OR "asm_sr"."service_center_id" IS NULL ) AND (("asm_sr"."contract_id" in ($539,$540,$541,$542)) OR "asm_sr"."contract_id" IS NULL )) AND ("asm_sr"."client_type" in ($543,$544)))
            GROUP BY "asm_sr"."sr_state_id","asm_sr__sr_state_id"."sequence",COALESCE("asm_sr__sr_state_id__name"."value","asm_sr__sr_state_id"."name"),"asm_sr__sr_state_id"."id"
            ORDER BY  "asm_sr__sr_state_id"."sequence" ,COALESCE("asm_sr__sr_state_id__name"."value", "asm_sr__sr_state_id"."name") ,"asm_sr__sr_state_id"."id"  
            LIMIT $545
1 min 0.2% 168 ms 391 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."so_state_id" = $1) AND (("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $2) ORDER BY  "asm_service_center"."id"  )) AND (("asm_so"."create_date" >= $3) AND ("asm_so"."create_date" <= $4)))) AND (((("asm_so"."service_center_id" in ($5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($39,$40))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.2% 94 ms 699 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE ("asm_so"."sr_id" in ($1)) AND (((("asm_so"."service_center_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($16,$17,$18,$19,$20)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($21))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC
1 min 0.2% 18 ms 3,501 odoo14 
SELECT "product_product".id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = $1 AND "product_product__product_tmpl_id__name"."name" = $2 AND "product_product__product_tmpl_id__name"."lang" = $3 AND "product_product__product_tmpl_id__name"."value" != $4) WHERE ((((("product_product"."active" = $5) AND "product_product__product_tmpl_id"."scrap_for_template" IS NULL ) AND ("product_product__product_tmpl_id"."is_product" = $6)) AND COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") ilike $7) AND ($8 OR "product_product"."id" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in ($9)) OR "product_product__product_tmpl_id"."company_id" IS NULL ) ORDER BY  "product_product"."default_code" ,COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") ,"product_product"."id"   LIMIT $10
1 min 0.2% 2,444 ms 26 odoo14 
SELECT "asm_so".id FROM "asm_so" WHERE (("asm_so"."client_type" = $1) AND (("asm_so"."so_state_id" = $2) AND (((((((("asm_so"."create_date" >= $3) AND (("asm_so"."so_state_id" in ($4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280)) OR "asm_so"."so_state_id" IS NULL)) AND (("asm_so"."so_state_id" in ($281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374)) OR "asm_so"."so_state_id" IS NULL)) AND ((((((((("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($375)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $376 ) OR ("res_partner"."company_id" in ($377))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $378) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $379))) ORDER BY  "res_partner"."id"  )) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($380)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $381 ) OR ("res_partner"."company_id" in ($382))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $383) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $384))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($385)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $386 ) OR ("res_partner"."company_id" in ($387))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $388) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $389))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($390)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $391 ) OR ("res_partner"."company_id" in ($392))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $393) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $394))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($395)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $396 ) OR ("res_partner"."company_id" in ($397))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $398) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $399))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($400)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $401 ) OR ("res_partner"."company_id" in ($402))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $403) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $404))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($405)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $406 ) OR ("res_partner"."company_id" in ($407))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $408) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $409))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($410)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $411 ) OR ("res_partner"."company_id" in ($412))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $413) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $414))) ORDER BY  "res_partner"."id"  ))) OR ("asm_so"."client_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."state_id" in ($415)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $416 ) OR ("res_partner"."company_id" in ($417))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $418) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $419))) ORDER BY  "res_partner"."id"  )))) AND ("asm_so"."so_type" = $420)) AND ("asm_so"."service_center_id" in (SELECT "asm_service_center".id FROM "asm_service_center" WHERE ("asm_service_center"."name"::text ilike $421) ORDER BY  "asm_service_center"."id"  ))))) AND (((("asm_so"."service_center_id" in ($422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($525,$526,$527,$528)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($529,$530))) ORDER BY  "asm_so"."name" DESC,"asm_so"."id" DESC  LIMIT $531
1 min 0.2% 1 ms 59,497 odoo14 
SELECT
                U.partner_id as id,
                CASE WHEN max(B.last_poll) IS NULL THEN $1
                    WHEN age(now() AT TIME ZONE $2, max(B.last_poll)) > interval $3 THEN $4
                    WHEN age(now() AT TIME ZONE $5, max(B.last_presence)) > interval $6 THEN $7
                    ELSE $8
                END as status
            FROM bus_presence B
            RIGHT JOIN res_users U ON B.user_id = U.id
            WHERE U.partner_id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220) AND U.active = $221
         GROUP BY U.partner_id
1 min 0.2% 0 ms 148,956 odoo14 
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" LEFT JOIN "ir_translation" AS "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id" AND "res_groups__name"."type" = $1 AND "res_groups__name"."name" = $2 AND "res_groups__name"."lang" = $3 AND "res_groups__name"."value" != $4)
                    WHERE $5=$6 AND res_groups_users_rel.uid IN ($7) AND res_groups_users_rel.gid = res_groups.id
                     ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name")    OFFSET $8
1 min 0.2% 156 ms 385 odoo14 
SELECT min("asm_so".id) AS id, count("asm_so".id) AS "so_state_id_count" , sum("asm_so"."diff_last_activity_create") AS "diff_last_activity_create","asm_so"."so_state_id" as "so_state_id" 
            FROM "asm_so" LEFT JOIN "asm_state" AS "asm_so__so_state_id" ON ("asm_so"."so_state_id" = "asm_so__so_state_id"."id") LEFT JOIN "ir_translation" AS "asm_so__so_state_id__name" ON ("asm_so__so_state_id"."id" = "asm_so__so_state_id__name"."res_id" AND "asm_so__so_state_id__name"."type" = $1 AND "asm_so__so_state_id__name"."name" = $2 AND "asm_so__so_state_id__name"."lang" = $3 AND "asm_so__so_state_id__name"."value" != $4)
            WHERE (((("asm_so"."service_center_id" in ($5,$6)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($21)))
            GROUP BY "asm_so"."so_state_id","asm_so__so_state_id"."sequence",COALESCE("asm_so__so_state_id__name"."value","asm_so__so_state_id"."name"),"asm_so__so_state_id"."id"
            ORDER BY  "asm_so__so_state_id"."sequence" ,COALESCE("asm_so__so_state_id__name"."value", "asm_so__so_state_id"."name") ,"asm_so__so_state_id"."id"  
            LIMIT $22
1 min 0.2% 344 ms 172 odoo14 
SELECT DISTINCT ON(pid, cid) * FROM (
    WITH sub_followers AS (
        SELECT fol.id, fol.partner_id, fol.channel_id, subtype.internal
        FROM mail_followers fol
            RIGHT JOIN mail_followers_mail_message_subtype_rel subrel
            ON subrel.mail_followers_id = fol.id
            RIGHT JOIN mail_message_subtype subtype
            ON subtype.id = subrel.mail_message_subtype_id
        WHERE subrel.mail_message_subtype_id = $1 AND fol.res_model = $2 AND fol.res_id IN ($3)
    )
    SELECT partner.id as pid, $4::int AS cid,
            partner.active as active, partner.partner_share as pshare, $5 as ctype,
            users.notification_type AS notif, array_agg(groups.id) AS groups
        FROM res_partner partner
        LEFT JOIN res_users users ON users.partner_id = partner.id AND users.active
        LEFT JOIN res_groups_users_rel groups_rel ON groups_rel.uid = users.id
        LEFT JOIN res_groups groups ON groups.id = groups_rel.gid
        WHERE EXISTS (
            SELECT partner_id FROM sub_followers
            WHERE sub_followers.channel_id IS NULL
                AND sub_followers.partner_id = partner.id
                AND (coalesce(sub_followers.internal, $6) <> $7 OR coalesce(partner.partner_share, $8) <> $9)
        ) OR partner.id IN ($10)
        GROUP BY partner.id, users.notification_type
    UNION
    SELECT $11::int AS pid, channel.id AS cid,
            $12 as active, $13 AS pshare, channel.channel_type AS ctype,
            CASE WHEN channel.email_send = $14 THEN $15 ELSE $16 END AS notif, $17 AS groups
        FROM mail_channel channel
        WHERE EXISTS (
            SELECT channel_id FROM sub_followers WHERE partner_id IS NULL AND sub_followers.channel_id = channel.id
        ) 
) AS x
ORDER BY pid, cid, notif
1 min 0.2% 158 ms 375 odoo14 
SELECT count($1) FROM "asm_so" WHERE ("asm_so"."so_state_id" = $2) AND (((("asm_so"."service_center_id" in ($3)) OR "asm_so"."service_center_id" IS NULL ) AND (("asm_so"."contract_id" in ($4,$5,$6,$7)) OR "asm_so"."contract_id" IS NULL )) AND ("asm_so"."so_type" in ($8)))
1 min 0.2% 168 ms 348 odoo14 
SELECT "stock_production_lot".id FROM "stock_production_lot" WHERE (("stock_production_lot"."product_id" = $1) AND ("stock_production_lot"."name"::text ilike $2)) AND ("stock_production_lot"."company_id" in ($3)) ORDER BY  "stock_production_lot"."id"   LIMIT $4