Pid	Duration	State
3701729	00:02:43	idle in transaction
odoo `SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=17 FOR UPDATE NOWAIT`
3700778	00:01:47	active
odoo DELETE FROM mrp_product_produce WHERE id IN (9967781, 9967782, 9967783, 9967784, 9967785, 9967786, 9967787, 9967788, 9967789, 9967790, 9967791, 9967792, 9967793, 9967794, 9967795, 9967796, 9967797, 9967798, 9967799, 9967800, 9967801, 9967802, 9967803, 9967804, 9967805, 9967806, 9967807, 9967808, 9967809, 9967810, 9967811, 9967812, 9967813, 9967814, 9967815, 9967816, 9967817, 9967818, 9967819, 9967820, 9967821, 9967822, 9967823, 9967824, 9967825, 9967826, 9967827, 9967828, 9967829, 9967830, 9967831, 9967832, 9967833, 9967834, 9967835, 9967836, 9967837, 9967838, 9967839, 9967840, 9967841, 9967842, 9967843, 9967844, 9967845, 9967846, 9967847, 9967848, 9967849, 9967850, 9967851, 9967852, 9967853, 9967854, 9967855, 9967856, 9967857, 9967858, 9967859, 9967860, 9967861, 9967862, 9969517, 9969842, 9969843, 9969844, 9969845, 9969846, 9969847, 9969848, 9969849, 9969850, 9969851, 9969852, 9969853, 9969854, 9969855, 9969856, 9969857, 9969858, 9969859, 9969860, 9969861, 9969862, 9969863, 9969864, 9969865, 9969866, 996986

Total Time	Average Time	Calls
137 min < 0.1%	153 ms	53,706 odoo
`SELECT "mrp_product_produce_line".id FROM "mrp_product_produce_line" WHERE ("mrp_product_produce_line"."product_produce_id" in ($1)) ORDER BY "mrp_product_produce_line"."id"`

Total Time	Average Time	Calls
241 min 0.1%	167 ms	86,364 odoo
`SELECT "order_dispatch".id FROM "order_dispatch" WHERE ("order_dispatch"."state" = $1) ORDER BY "order_dispatch"."create_date" DESC limit $2`

Total Time	Average Time	Calls
720 min 0.4%	3,927 ms	10,995 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE ("queue_job"."date_done" <= $1) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC`

Total Time	Average Time	Calls
35 min < 0.1%	169 ms	12,536 odoo
`SELECT "stock_inventory_line".id FROM "stock_inventory_line" WHERE ("stock_inventory_line"."prod_lot_id" in ($1)) ORDER BY "stock_inventory_line"."id"`

Total Time	Average Time	Calls
3,356 min 2%	96 ms	2,096,434 odoo
SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_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)) ORDER BY "stock_scrap"."id" DESC
1,065 min 0.6%	103 ms	617,632 odoo
`SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_id" in ($1)) ORDER BY "stock_scrap"."id" DESC`

Total Time	Average Time	Calls
29 min < 0.1%	270 ms	6,505 odoo
`SELECT "swk_scrap_ticket".id FROM "swk_scrap_ticket" WHERE ("swk_scrap_ticket"."state" = $1) ORDER BY "swk_scrap_ticket"."id" DESC`

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time	Average Time	Calls
81,939 min 49%	5,659 ms	868,830 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = $1 ) AND ("stock_move"."raw_material_production_id" in ($2))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
19,457 min 12%	6,307 ms	185,097 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = $1 ) AND ("stock_move"."production_id" in ($2))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
11,866 min 7%	1,270 ms	560,700 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE ((("queue_job"."state" = $1) AND ("queue_job"."date_created" > $2)) AND ("queue_job"."name" in ($3,$4,$5,$6,$7))) ORDER BY "queue_job"."date_created"` `Covered by index on (name, date_created) Rows: 1715737 Row progression: 1715737, 95319, 9532 Row estimates - name (=): 95319 - date_created (>): 171574 - state (=): 428934 - date_created (sort): 3 Existing indexes - id PRIMARY - channel - company_id - identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL) - name, date_created - state - uuid`
11,358 min 7%	1,145 ms	595,054 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE ((("queue_job"."state" = $1) AND ("queue_job"."date_created" > $2)) AND (("queue_job"."name" not in ($3,$4,$5,$6,$7,$8,$9)) OR "queue_job"."name" IS NULL)) ORDER BY "queue_job"."date_created"`
4,418 min 3%	9,135 ms	29,018 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1,$2)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
4,336 min 3%	4,680 ms	55,589 odoo
SELECT "product_product".id FROM "product_template" as "product_product__product_tmpl_id","product_product" WHERE ("product_product"."product_tmpl_id"="product_product__product_tmpl_id"."id") AND ((("product_product"."active" = $1) AND ("product_product__product_tmpl_id"."id" in (WITH temp_irt_current (id, name) as ( SELECT ct.id, coalesce(it.value,ct."name") FROM product_template ct LEFT JOIN ir_translation it ON (it.name = $2 and it.lang = $3 and it.type = $4 and it.res_id = ct.id and it.value != $5) ) SELECT id FROM temp_irt_current WHERE name ilike $6 order by name ))) AND ($7 OR "product_product"."id" IS NULL)) ORDER BY "product_product"."default_code" ,"product_product"."id" limit $8
3,795 min 2%	12,960 ms	17,567 odoo
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id"),"stock_location" as "stock_move__location_dest_id" WHERE ("stock_move"."inventory_id" in ($1)) AND ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id") AND (("stock_move"."company_id" IS NULL OR ("stock_move"."company_id" in ($2))) OR "stock_move__location_dest_id"."company_id" IS NULL ) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"
3,525 min 2%	8,928 ms	23,690 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
3,356 min 2%	96 ms	2,096,434 odoo
SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_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)) ORDER BY "stock_scrap"."id" DESC Details `CREATE INDEX CONCURRENTLY ON stock_scrap (scrap_ticket_id)` `Rows: 122328 Row progression: 122328, 1 Row estimates - scrap_ticket_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - product_id`
2,398 min 1%	153,420 ms	938 odoo
DELETE FROM mrp_product_produce WHERE id IN (9964819, 9964820, 9964821, 9964822, 9964823, 9964824, 9964825, 9964826, 9964827, 9964828, 9964829, 9964830, 9964831, 9964832, 9964833, 9964834, 9964835, 9964836, 9964837, 9964838, 9964839, 9964840, 9964841, 9964842, 9964843, 9964844, 9964845, 9964846, 9964847, 9964848, 9964849, 9964850, 9964851, 9964852, 9964853, 9964854, 9964855, 9964856, 9964857, 9964858, 9964859, 9964860, 9964861, 9964862, 9964863, 9964864, 9964865, 9964866, 9964867, 9964868, 9964869, 9964870, 9964871, 9964872, 9964873, 9964874, 9964875, 9964876, 9964877, 9964878, 9964879, 9964880, 9964881, 9964882, 9964883, 9964884, 9964885, 9964886, 9964887, 9964888, 9964889, 9964890, 9964891, 9964892, 9964893, 9964894, 9964895, 9964896, 9964897, 9964898, 9964899, 9964900, 9964901, 9964902, 9964906, 9964907, 9964908, 9964903, 9964904, 9964905, 9964909, 9964910, 9964911, 9964912, 9964913, 9964914, 9964915, 9964916, 9964917, 9964918, 9964919, 9964920, 9964921, 9964922, 9964923, 9964924, 9964925, 9964926, 9964927, 9964928, 9964929, 9964930, 9964931, 9964932, 9964933, 9964934, 9964935, 9964936, 9964937, 9964938, 9964939, 9964940, 9964941, 9964942, 9964943, 9964944, 9964945, 9964946, 9964947, 9964948, 9964949, 9964950, 9964951, 9964952, 9964953, 9964954, 9964955, 9964956, 9964957, 9964958, 9964959, 9964960, 9964961, 9964962, 9964963, 9964964, 9964965, 9964966, 9964967, 9964968, 9964969, 9964970, 9964971, 9964972, 9964973, 9964974, 9964975, 9964976, 9964977, 9964978, 9964979, 9964980, 9964981, 9964982, 9964983, 9964984, 9964985, 9964986, 9964987, 9964988, 9964989, 9964990, 9964991, 9964992, 9964993, 9964994, 9964995, 9964996, 9964997, 9964998, 9964999, 9965000, 9965001, 9965002, 9965003, 9965004, 9965005, 9965006, 9965007, 9965008, 9965009, 9965010, 9965011, 9965012, 9965013, 9965014, 9965015, 9965016, 9965017, 9965018, 9965019, 9965020, 9965021, 9965022, 9965023, 9965024, 9965025, 9965026, 9965027, 9965028, 9965029, 9965030, 9965031, 9965032, 9965033, 9965034, 9965035, 9965036, 9965037, 9965038, 9965039, 9965040, 9965041, 9965042, 9965043, 9965044, 9965045, 9965046, 9965047, 9965048, 9965049, 9965050, 9965051, 9965052, 9965053, 9965054, 9965055, 9965056, 9965057, 9965058, 9965059, 9965060, 9965061, 9965062, 9965063, 9965064, 9965065, 9965066, 9965067, 9965068, 9965069, 9965070, 9965071, 9965072, 9965073, 9965074, 9965075, 9965076, 9965077, 9965078, 9965079, 9965080, 9965081, 9965082, 9965085, 9965086, 9966031, 9966032, 9966033, 9966034, 9966035, 9966036, 9966037, 9966038, 9966039, 9966040, 9966041, 9966042, 9966043, 9966044, 9966045, 9966046, 9966047, 9966048, 9966049, 9966050, 9966051, 9966052, 9966053, 9966054, 9966055, 9966056, 9966057, 9966058, 9966059, 9966060, 9966061, 9966062, 9966063, 9966064, 9966065, 9966066, 9966067, 9966068, 9966069, 9966070, 9966071, 9966072, 9966073, 9966074, 9966075, 9966076, 9966077, 9966078, 9966079, 9966080, 9966081, 9966082, 9966083, 9966084, 9966085, 9966086, 9966087, 9966088, 9966089, 9966090, 9966091, 9966092, 9966093, 9966094, 9966095, 9966096, 9966097, 9966098, 9966099, 9966100, 9966101, 9966102, 9966103, 9966104, 9967544, 9966106, 9966107, 9966108, 9966109, 9966110, 9966111, 9966112, 9966113, 9966114, 9966115, 9965083, 9965084, 9965087, 9965088, 9965089, 9965090, 9965091, 9966116, 9966117, 9966581, 9966582, 9966583, 9966584, 9966585, 9966586, 9966587, 9966588, 9966589, 9966590, 9966591, 9966592, 9966593, 9966594, 9966595, 9966596, 9966597, 9966598, 9966599, 9966600, 9966601, 9966602, 9967545, 9967558, 9966605, 9966606, 9966607, 9966608, 9966609, 9966610, 9966611, 9966612, 9966613, 9966614, 9966615, 9966616, 9966617, 9966618, 9966619, 9966620, 9966621, 9966622, 9966623, 9966624, 9966625, 9966626, 9966627, 9966628, 9966629, 9966630, 9966631, 9966632, 9966633, 9966634, 9966635, 9966636, 9966637, 9966638, 9966639, 9966640, 9966641, 9966642, 9967559, 9966644, 9966645, 9966646, 9966647, 9966648, 9966649, 9966650, 9966651, 9966652, 9966653, 9966654, 9966655, 9966656, 9966657, 9966658, 9966659, 9965092, 9965093, 9965094, 9965095, 9965096, 9965097, 9965098, 9965099, 9965100, 9965101, 9965102, 9965103, 9965104, 9965105, 9965106, 9965107, 9965108, 9965109, 9965110, 9965111, 9965112, 9965113, 9966118, 9965115, 9965116, 9965117, 9965118, 9965119, 9965120, 9965121, 9965122, 9965123, 9965124, 9965125, 9965126, 9965127, 9965128, 9965129, 9965130, 9965131, 9965132, 9965133, 9965134, 9965135, 9965136, 9965137, 9965138, 9966119, 9965140, 9965141, 9965142, 9965143, 9965144, 9965145, 9965146, 9965147, 9965148, 9965149, 9965150, 9965151, 9965152, 9965153, 9965154, 9965155, 9965156, 9965157, 9965158, 9965159, 9965160, 9965161, 9965162, 9965163, 9965164, 9965165, 9966120, 9965167, 9965168, 9965169, 9965170, 9965171, 9965172, 9965173, 9966121, 9965175, 9965176, 9965177, 9965178, 9965179, 9965180, 9965181, 9965182, 9966122, 9966660, 9966665, 9966666, 9967085, 9967086, 9967087, 9967088, 9967089, 9967091, 9967092, 9967093, 9967094, 9967095, 9967096, 9967097, 9967098, 9967099, 9967100, 9967101, 9967102, 9967103, 9967104, 9967105, 9967106, 9967107, 9967108, 9967109, 9967110, 9967111, 9967112, 9967113, 9967114, 9967115, 9967116, 9967117, 9967118, 9967119, 9967120, 9967121, 9967122, 9967123, 9967124, 9967125, 9967126, 9967127, 9967128, 9967129, 9967130, 9967131, 9967132, 9967133, 9967134, 9967135, 9967136, 9967137, 9967138, 9967139, 9967140, 9967141, 9967142, 9967143, 9967144, 9967145, 9967146, 9967147, 9967148, 9967149, 9967150, 9967151, 9967152, 9967153, 9967154, 9967155, 9967156, 9967157, 9967158, 9967159, 9967160, 9967161, 9967162, 9967163, 9967164, 9967165, 9967166, 9965184, 9965185, 9966123, 9966124, 9966125, 9966126, 9966127, 9966128, 9966129, 9966130, 9966131, 9966132, 9966133, 9966134, 9966135, 9966136, 9966137, 9966138, 9966139, 9966140, 9966141, 9966142, 9966143, 9966144, 9966145, 9966146, 9966147, 9966148, 9966149, 9966150, 9966151, 9966152, 9966153, 9966154, 9966155, 9966156, 9966157, 9967546, 9966159, 9966160, 9966161, 9966162, 9966163, 9966164, 9966165, 9966166, 9966167, 9966168, 9966169, 9966170, 9966171, 9966172, 9966173, 9966174, 9966175, 9966176, 9966177, 9966178, 9966179, 9966180, 9966181, 9966182, 9966183, 9966184, 9966185, 9966186, 9966187, 9966188, 9966189, 9966190, 9966191, 9966192, 9966193, 9966194, 9966195, 9966196, 9966197, 9966198, 9966199, 9966200, 9966201, 9966202, 9966203, 9966204, 9966205, 9966206, 9966207, 9966208, 9965186, 9965187, 9966209, 9966210, 9966215, 9966224, 9966661, 9966662, 9966663, 9966664, 9966667, 9966668, 9966669, 9966670, 9966671, 9966672, 9966673, 9966674, 9966675, 9966676, 9966677, 9966678, 9966679, 9966680, 9966681, 9966682, 9966683, 9966684, 9966685, 9966686, 9966687, 9966688, 9966689, 9966690, 9966691, 9966692, 9966693, 9966694, 9966695, 9966696, 9966697, 9966698, 9966699, 9966700, 9966701, 9966702, 9966703, 9966704, 9966705, 9966706, 9966707, 9966708, 9966709, 9966710, 9966711, 9966712, 9966713, 9966714, 9966715, 9966716, 9966717, 9966718, 9966719, 9966720, 9966721, 9966722, 9966723, 9966724, 9966725, 9966726, 9966727, 9966728, 9966729, 9967547, 9966731, 9966732, 9966733, 9966734, 9966735, 9966736, 9966737, 9966738, 9966739, 9966740, 9966741, 9966742, 9966743, 9966744, 9965188, 9965189, 9965190, 9965191, 9965192, 9965193, 9965194, 9965195, 9965196, 9965197, 9965198, 9965199, 9965200, 9965201, 9965202, 9965203, 9965204, 9965205, 9965206, 9965207, 9965208, 9965209, 9966211, 9965211, 9965212, 9965213, 9965214, 9965215, 9965216, 9965217, 9965218, 9965219, 9966212, 9965221, 9965222, 9965223, 9965224, 9965225, 9965226, 9965227, 9965228, 9965229, 9965230, 9965231, 9965232, 9965233, 9965234, 9965235, 9965236, 9965237, 9965238, 9965239, 9965240, 9965241, 9965242, 9965243, 9965244, 9965245, 9965246, 9965247, 9965248, 9965249, 9965250, 9965251, 9965252, 9965253, 9965254, 9965255, 9965256, 9965257, 9965258, 9965259, 9966213, 9965261, 9965262, 9965263, 9965264, 9965265, 9965266, 9965267, 9965268, 9965269, 9965270, 9965271, 9965272, 9965273, 9965274, 9965275, 9965276, 9965277, 9966214, 9966745, 9967167, 9967168, 9967320, 9967321, 9967322, 9967323, 9967324, 9967325, 9967326, 9967327, 9967328, 9967329, 9967330, 9967331, 9967332, 9967333, 9967334, 9967335, 9967336, 9967337, 9967338, 9967339, 9967340, 9967341, 9967342, 9967343, 9967344, 9967345, 9967346, 9967347, 9967348, 9967349, 9967350, 9967351, 9967352, 9967353, 9967354, 9967355, 9967356, 9967357, 9967358, 9967359, 9967360, 9967361, 9967362, 9967363, 9967364, 9967365, 9967366, 9967367, 9967368, 9967369, 9967370, 9967371, 9967372, 9967373, 9967374, 9967375, 9967376, 9967377, 9967378, 9967379, 9967380, 9967381, 9967382, 9967383, 9967384, 9967385, 9967386, 9967387, 9967388, 9967389, 9967390, 9967391, 9967392, 9967393, 9967394, 9967395, 9967396, 9967397, 9967398, 9967399, 9967400, 9967401, 9965278, 9966216, 9966217, 9966218, 9966219, 9966220, 9966221, 9966222, 9966223, 9966225, 9966226, 9966227, 9966228, 9966229, 9966230, 9966231, 9966232, 9966233, 9966234, 9966235, 9966236, 9966237, 9966238, 9966239, 9966240, 9966241, 9966242, 9966243, 9966244, 9966245, 9966246, 9966247, 9966248) `Covered by index on (id) Rows: 121332 Row progression: 121332, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
2,370 min 1%	8,758 ms	16,240 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1,$2,$3)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
1,896 min 1%	268 ms	425,162 odoo
`DELETE FROM stock_move WHERE id IN ($1)` `Covered by index on (id) Rows: 19496894 Row progression: 19496894, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - date - date_expected - location_id - name - origin_returned_move_id - picking_id, id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - purchase_line_id - scrapped - state`
1,856 min 1%	295 ms	376,965 odoo
`SELECT "account_invoice".id FROM "account_invoice" WHERE ((("account_invoice"."origin"::text like $1) AND ("account_invoice"."company_id" = $2)) AND ("account_invoice"."type" in ($3,$4))) ORDER BY "account_invoice"."date_invoice" DESC,"account_invoice"."number" DESC,"account_invoice"."id" DESC`
1,065 min 0.6%	103 ms	617,632 odoo
`SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_id" in ($1)) ORDER BY "stock_scrap"."id" DESC` Details `CREATE INDEX CONCURRENTLY ON stock_scrap (scrap_ticket_id)` `Rows: 122328 Row progression: 122328, 1 Row estimates - scrap_ticket_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - product_id`
1,033 min 0.6%	8,057 ms	7,696 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1,$2,$3,$4)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
840 min 0.5%	3,933 ms	12,821 odoo
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count" , sum("sale_report"."product_uom_qty") AS "product_uom_qty" ,"sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" as "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") WHERE (("sale_report"."state" in ($1,$2)) AND ("sale_report"."product_id" in ($3))) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in ($4))) GROUP BY "sale_report"."product_id","sale_report__product_id"."default_code","sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code" ,"sale_report__product_id"."id"
720 min 0.4%	3,927 ms	10,995 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE ("queue_job"."date_done" <= $1) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC` Details `CREATE INDEX CONCURRENTLY ON queue_job (date_done)` `Rows: 1715737 Row progression: 1715737, 129596 Row estimates - date_done (<=): 129596 - date_created (sort): 3 Existing indexes - id PRIMARY - channel - company_id - identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL) - name, date_created - state - uuid`
667 min 0.4%	5,782 ms	6,917 odoo
`SELECT distinct("order_id") FROM "sale_order_line" where "order_id" is not null`
464 min 0.3%	7,601 ms	3,660 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1,$2,$3,$4,$5)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
451 min 0.3%	3,818 ms	7,092 odoo
`SELECT "stock_production_lot".id FROM "stock_production_lot" WHERE ("stock_production_lot"."automatic_scrap" IS NULL or "stock_production_lot"."automatic_scrap" = $1 ) ORDER BY "stock_production_lot"."id"`
320 min 0.2%	24 ms	814,832 odoo
SELECT "stock_scrap"."id" as "id","stock_scrap"."production_id" as "production_id","stock_scrap"."date_expected" as "date_expected","stock_scrap"."value_food" as "value_food","stock_scrap"."write_date" as "write_date","stock_scrap"."scrap_qty" as "scrap_qty","stock_scrap"."move_id" as "move_id","stock_scrap"."warehouse_id" as "warehouse_id","stock_scrap"."value_nonfood" as "value_nonfood","stock_scrap"."is_swk_scrap" as "is_swk_scrap","stock_scrap"."workorder_id" as "workorder_id","stock_scrap"."product_id" as "product_id","stock_scrap"."state" as "state","stock_scrap"."picking_id" as "picking_id","stock_scrap"."create_uid" as "create_uid","stock_scrap"."date" as "date","stock_scrap"."name" as "name","stock_scrap"."product_uom_id" as "product_uom_id","stock_scrap"."kitchen_ticket" as "kitchen_ticket","stock_scrap"."initial_quantity" as "initial_quantity","stock_scrap"."location_id" as "location_id","stock_scrap"."write_uid" as "write_uid","stock_scrap"."origin" as "origin","stock_scrap"."variation" as "variation","stock_scrap"."lot_id" as "lot_id","stock_scrap"."scrap_ticket_id" as "scrap_ticket_id","stock_scrap"."create_date" as "create_date","stock_scrap"."scrap_location_id" as "scrap_location_id","stock_scrap"."value" as "value","stock_scrap"."package_id" as "package_id","stock_scrap"."company_id" as "company_id","stock_scrap"."currency_id" as "currency_id","stock_scrap"."owner_id" as "owner_id" FROM "stock_scrap" WHERE "stock_scrap".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) `Covered by index on (id) Rows: 122328 Row progression: 122328, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - product_id`
312 min 0.2%	24 ms	781,766 odoo
SELECT "stock_scrap"."id" as "id","stock_scrap"."location_id" as "location_id","stock_scrap"."is_swk_scrap" as "is_swk_scrap","stock_scrap"."initial_quantity" as "initial_quantity","stock_scrap"."write_uid" as "write_uid","stock_scrap"."lot_id" as "lot_id","stock_scrap"."package_id" as "package_id","stock_scrap"."company_id" as "company_id","stock_scrap"."variation" as "variation","stock_scrap"."date" as "date","stock_scrap"."scrap_location_id" as "scrap_location_id","stock_scrap"."name" as "name","stock_scrap"."owner_id" as "owner_id","stock_scrap"."currency_id" as "currency_id","stock_scrap"."value" as "value","stock_scrap"."production_id" as "production_id","stock_scrap"."origin" as "origin","stock_scrap"."move_id" as "move_id","stock_scrap"."warehouse_id" as "warehouse_id","stock_scrap"."value_food" as "value_food","stock_scrap"."create_date" as "create_date","stock_scrap"."scrap_qty" as "scrap_qty","stock_scrap"."product_id" as "product_id","stock_scrap"."workorder_id" as "workorder_id","stock_scrap"."write_date" as "write_date","stock_scrap"."date_expected" as "date_expected","stock_scrap"."picking_id" as "picking_id","stock_scrap"."value_nonfood" as "value_nonfood","stock_scrap"."create_uid" as "create_uid","stock_scrap"."state" as "state","stock_scrap"."product_uom_id" as "product_uom_id","stock_scrap"."kitchen_ticket" as "kitchen_ticket","stock_scrap"."scrap_ticket_id" as "scrap_ticket_id" FROM "stock_scrap" WHERE "stock_scrap".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) `Covered by index on (id) Rows: 122328 Row progression: 122328, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - product_id`
242 min 0.1%	5,397 ms	2,688 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = $1 ) AND ("stock_move"."raw_material_production_id" in ($2,$3))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
241 min 0.1%	167 ms	86,364 odoo
`SELECT "order_dispatch".id FROM "order_dispatch" WHERE ("order_dispatch"."state" = $1) ORDER BY "order_dispatch"."create_date" DESC limit $2` Details `CREATE INDEX CONCURRENTLY ON order_dispatch (state, create_date)` `Rows: 93702 Row progression: 93702, 46851, 1 Row estimates - state (=): 46851 - create_date (sort): 1 Existing indexes - id PRIMARY`
206 min 0.1%	7,244 ms	1,709 odoo
`SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE ("stock_move"."sale_line_id" in ($1,$2,$3,$4,$5,$6)) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"`
137 min < 0.1%	153 ms	53,706 odoo
`SELECT "mrp_product_produce_line".id FROM "mrp_product_produce_line" WHERE ("mrp_product_produce_line"."product_produce_id" in ($1)) ORDER BY "mrp_product_produce_line"."id"` Details `CREATE INDEX CONCURRENTLY ON mrp_product_produce_line (product_produce_id)` `Rows: 681078 Row progression: 681078, 9 Row estimates - product_produce_id (=): 9 - id (sort): 1 Existing indexes - id PRIMARY`
121 min < 0.1%	633 ms	11,421 odoo
`SELECT "sale_order".id FROM "sale_order" WHERE ((("sale_order"."partner_id" = $1) AND ("sale_order"."brand_id" = $2)) AND ("sale_order"."create_date" < $3)) ORDER BY "sale_order"."date_order" DESC,"sale_order"."id" DESC limit $4` `Covered by index on (partner_id) Rows: 865848 Row progression: 865848, 8 Row estimates - partner_id (=): 8 - brand_id (=): 12026 - create_date (<): 86585 - date_order (sort): 1 Existing indexes - id PRIMARY - brand_id - code - confirmation_date - create_date - date_order - deliverect_id UNIQUE - dh_token UNIQUE - fo_state - instashop_id UNIQUE - name - partner_id - platform_id - state - user_id - zomato_id UNIQUE`
109 min < 0.1%	10,857 ms	601 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $598) AND ("stock_move__location_id"."parent_left" < $599)) OR (("stock_move__location_id"."parent_left" >= $600) AND ("stock_move__location_id"."parent_left" < $601))) OR (("stock_move__location_id"."parent_left" >= $602) AND ("stock_move__location_id"."parent_left" < $603))) OR (("stock_move__location_id"."parent_left" >= $604) AND ("stock_move__location_id"."parent_left" < $605))) OR (("stock_move__location_id"."parent_left" >= $606) AND ("stock_move__location_id"."parent_left" < $607))) OR (("stock_move__location_id"."parent_left" >= $608) AND ("stock_move__location_id"."parent_left" < $609))) OR (("stock_move__location_id"."parent_left" >= $610) AND ("stock_move__location_id"."parent_left" < $611))) OR (("stock_move__location_id"."parent_left" >= $612) AND ("stock_move__location_id"."parent_left" < $613))) OR (("stock_move__location_id"."parent_left" >= $614) AND ("stock_move__location_id"."parent_left" < $615))) OR (("stock_move__location_id"."parent_left" >= $616) AND ("stock_move__location_id"."parent_left" < $617))) OR (("stock_move__location_id"."parent_left" >= $618) AND ("stock_move__location_id"."parent_left" < $619))) OR (("stock_move__location_id"."parent_left" >= $620) AND ("stock_move__location_id"."parent_left" < $621))) OR (("stock_move__location_id"."parent_left" >= $622) AND ("stock_move__location_id"."parent_left" < $623))) OR (("stock_move__location_id"."parent_left" >= $624) AND ("stock_move__location_id"."parent_left" < $625)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $626) OR ("stock_move__location_dest_id"."parent_left" >= $627)) AND (("stock_move__location_dest_id"."parent_left" < $628) OR ("stock_move__location_dest_id"."parent_left" >= $629))) AND (("stock_move__location_dest_id"."parent_left" < $630) OR ("stock_move__location_dest_id"."parent_left" >= $631))) AND (("stock_move__location_dest_id"."parent_left" < $632) OR ("stock_move__location_dest_id"."parent_left" >= $633))) AND (("stock_move__location_dest_id"."parent_left" < $634) OR ("stock_move__location_dest_id"."parent_left" >= $635))) AND (("stock_move__location_dest_id"."parent_left" < $636) OR ("stock_move__location_dest_id"."parent_left" >= $637))) AND (("stock_move__location_dest_id"."parent_left" < $638) OR ("stock_move__location_dest_id"."parent_left" >= $639))) AND (("stock_move__location_dest_id"."parent_left" < $640) OR ("stock_move__location_dest_id"."parent_left" >= $641))) AND (("stock_move__location_dest_id"."parent_left" < $642) OR ("stock_move__location_dest_id"."parent_left" >= $643))) AND (("stock_move__location_dest_id"."parent_left" < $644) OR ("stock_move__location_dest_id"."parent_left" >= $645))) AND (("stock_move__location_dest_id"."parent_left" < $646) OR ("stock_move__location_dest_id"."parent_left" >= $647))) AND (("stock_move__location_dest_id"."parent_left" < $648) OR ("stock_move__location_dest_id"."parent_left" >= $649))) AND (("stock_move__location_dest_id"."parent_left" < $650) OR ("stock_move__location_dest_id"."parent_left" >= $651))) AND (("stock_move__location_dest_id"."parent_left" < $652) OR ("stock_move__location_dest_id"."parent_left" >= $653)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
103 min < 0.1%	9,923 ms	624 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $605) AND ("stock_move__location_id"."parent_left" < $606)) OR (("stock_move__location_id"."parent_left" >= $607) AND ("stock_move__location_id"."parent_left" < $608))) OR (("stock_move__location_id"."parent_left" >= $609) AND ("stock_move__location_id"."parent_left" < $610))) OR (("stock_move__location_id"."parent_left" >= $611) AND ("stock_move__location_id"."parent_left" < $612))) OR (("stock_move__location_id"."parent_left" >= $613) AND ("stock_move__location_id"."parent_left" < $614))) OR (("stock_move__location_id"."parent_left" >= $615) AND ("stock_move__location_id"."parent_left" < $616))) OR (("stock_move__location_id"."parent_left" >= $617) AND ("stock_move__location_id"."parent_left" < $618))) OR (("stock_move__location_id"."parent_left" >= $619) AND ("stock_move__location_id"."parent_left" < $620))) OR (("stock_move__location_id"."parent_left" >= $621) AND ("stock_move__location_id"."parent_left" < $622))) OR (("stock_move__location_id"."parent_left" >= $623) AND ("stock_move__location_id"."parent_left" < $624))) OR (("stock_move__location_id"."parent_left" >= $625) AND ("stock_move__location_id"."parent_left" < $626))) OR (("stock_move__location_id"."parent_left" >= $627) AND ("stock_move__location_id"."parent_left" < $628))) OR (("stock_move__location_id"."parent_left" >= $629) AND ("stock_move__location_id"."parent_left" < $630))) OR (("stock_move__location_id"."parent_left" >= $631) AND ("stock_move__location_id"."parent_left" < $632)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $633) OR ("stock_move__location_dest_id"."parent_left" >= $634)) AND (("stock_move__location_dest_id"."parent_left" < $635) OR ("stock_move__location_dest_id"."parent_left" >= $636))) AND (("stock_move__location_dest_id"."parent_left" < $637) OR ("stock_move__location_dest_id"."parent_left" >= $638))) AND (("stock_move__location_dest_id"."parent_left" < $639) OR ("stock_move__location_dest_id"."parent_left" >= $640))) AND (("stock_move__location_dest_id"."parent_left" < $641) OR ("stock_move__location_dest_id"."parent_left" >= $642))) AND (("stock_move__location_dest_id"."parent_left" < $643) OR ("stock_move__location_dest_id"."parent_left" >= $644))) AND (("stock_move__location_dest_id"."parent_left" < $645) OR ("stock_move__location_dest_id"."parent_left" >= $646))) AND (("stock_move__location_dest_id"."parent_left" < $647) OR ("stock_move__location_dest_id"."parent_left" >= $648))) AND (("stock_move__location_dest_id"."parent_left" < $649) OR ("stock_move__location_dest_id"."parent_left" >= $650))) AND (("stock_move__location_dest_id"."parent_left" < $651) OR ("stock_move__location_dest_id"."parent_left" >= $652))) AND (("stock_move__location_dest_id"."parent_left" < $653) OR ("stock_move__location_dest_id"."parent_left" >= $654))) AND (("stock_move__location_dest_id"."parent_left" < $655) OR ("stock_move__location_dest_id"."parent_left" >= $656))) AND (("stock_move__location_dest_id"."parent_left" < $657) OR ("stock_move__location_dest_id"."parent_left" >= $658))) AND (("stock_move__location_dest_id"."parent_left" < $659) OR ("stock_move__location_dest_id"."parent_left" >= $660)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
95 min < 0.1%	6,725 ms	846 odoo
SELECT min("mrp_production".id) AS id, count("mrp_production".id) AS "picking_type_id_count" , "mrp_production"."picking_type_id" as "picking_type_id" FROM "mrp_production" LEFT JOIN "stock_picking_type" as "mrp_production__picking_type_id" ON ("mrp_production"."picking_type_id" = "mrp_production__picking_type_id"."id") WHERE (((("mrp_production"."date_planned_start" < $1) AND ("mrp_production"."state" = $2)) AND (("mrp_production"."state" not in ($3,$4)) OR "mrp_production"."state" IS NULL)) AND ("mrp_production"."picking_type_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))) AND (("mrp_production"."company_id" in ($44)) OR "mrp_production"."company_id" IS NULL ) GROUP BY "mrp_production"."picking_type_id","mrp_production__picking_type_id"."sequence","mrp_production__picking_type_id"."id" ORDER BY "mrp_production__picking_type_id"."sequence" ,"mrp_production__picking_type_id"."id"
93 min < 0.1%	9,305 ms	601 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $598) AND ("stock_move__location_dest_id"."parent_left" < $599)) OR (("stock_move__location_dest_id"."parent_left" >= $600) AND ("stock_move__location_dest_id"."parent_left" < $601))) OR (("stock_move__location_dest_id"."parent_left" >= $602) AND ("stock_move__location_dest_id"."parent_left" < $603))) OR (("stock_move__location_dest_id"."parent_left" >= $604) AND ("stock_move__location_dest_id"."parent_left" < $605))) OR (("stock_move__location_dest_id"."parent_left" >= $606) AND ("stock_move__location_dest_id"."parent_left" < $607))) OR (("stock_move__location_dest_id"."parent_left" >= $608) AND ("stock_move__location_dest_id"."parent_left" < $609))) OR (("stock_move__location_dest_id"."parent_left" >= $610) AND ("stock_move__location_dest_id"."parent_left" < $611))) OR (("stock_move__location_dest_id"."parent_left" >= $612) AND ("stock_move__location_dest_id"."parent_left" < $613))) OR (("stock_move__location_dest_id"."parent_left" >= $614) AND ("stock_move__location_dest_id"."parent_left" < $615))) OR (("stock_move__location_dest_id"."parent_left" >= $616) AND ("stock_move__location_dest_id"."parent_left" < $617))) OR (("stock_move__location_dest_id"."parent_left" >= $618) AND ("stock_move__location_dest_id"."parent_left" < $619))) OR (("stock_move__location_dest_id"."parent_left" >= $620) AND ("stock_move__location_dest_id"."parent_left" < $621))) OR (("stock_move__location_dest_id"."parent_left" >= $622) AND ("stock_move__location_dest_id"."parent_left" < $623))) OR (("stock_move__location_dest_id"."parent_left" >= $624) AND ("stock_move__location_dest_id"."parent_left" < $625)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $626) OR ("stock_move__location_id"."parent_left" >= $627)) AND (("stock_move__location_id"."parent_left" < $628) OR ("stock_move__location_id"."parent_left" >= $629))) AND (("stock_move__location_id"."parent_left" < $630) OR ("stock_move__location_id"."parent_left" >= $631))) AND (("stock_move__location_id"."parent_left" < $632) OR ("stock_move__location_id"."parent_left" >= $633))) AND (("stock_move__location_id"."parent_left" < $634) OR ("stock_move__location_id"."parent_left" >= $635))) AND (("stock_move__location_id"."parent_left" < $636) OR ("stock_move__location_id"."parent_left" >= $637))) AND (("stock_move__location_id"."parent_left" < $638) OR ("stock_move__location_id"."parent_left" >= $639))) AND (("stock_move__location_id"."parent_left" < $640) OR ("stock_move__location_id"."parent_left" >= $641))) AND (("stock_move__location_id"."parent_left" < $642) OR ("stock_move__location_id"."parent_left" >= $643))) AND (("stock_move__location_id"."parent_left" < $644) OR ("stock_move__location_id"."parent_left" >= $645))) AND (("stock_move__location_id"."parent_left" < $646) OR ("stock_move__location_id"."parent_left" >= $647))) AND (("stock_move__location_id"."parent_left" < $648) OR ("stock_move__location_id"."parent_left" >= $649))) AND (("stock_move__location_id"."parent_left" < $650) OR ("stock_move__location_id"."parent_left" >= $651))) AND (("stock_move__location_id"."parent_left" < $652) OR ("stock_move__location_id"."parent_left" >= $653)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
89 min < 0.1%	8,592 ms	625 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $605) AND ("stock_move__location_dest_id"."parent_left" < $606)) OR (("stock_move__location_dest_id"."parent_left" >= $607) AND ("stock_move__location_dest_id"."parent_left" < $608))) OR (("stock_move__location_dest_id"."parent_left" >= $609) AND ("stock_move__location_dest_id"."parent_left" < $610))) OR (("stock_move__location_dest_id"."parent_left" >= $611) AND ("stock_move__location_dest_id"."parent_left" < $612))) OR (("stock_move__location_dest_id"."parent_left" >= $613) AND ("stock_move__location_dest_id"."parent_left" < $614))) OR (("stock_move__location_dest_id"."parent_left" >= $615) AND ("stock_move__location_dest_id"."parent_left" < $616))) OR (("stock_move__location_dest_id"."parent_left" >= $617) AND ("stock_move__location_dest_id"."parent_left" < $618))) OR (("stock_move__location_dest_id"."parent_left" >= $619) AND ("stock_move__location_dest_id"."parent_left" < $620))) OR (("stock_move__location_dest_id"."parent_left" >= $621) AND ("stock_move__location_dest_id"."parent_left" < $622))) OR (("stock_move__location_dest_id"."parent_left" >= $623) AND ("stock_move__location_dest_id"."parent_left" < $624))) OR (("stock_move__location_dest_id"."parent_left" >= $625) AND ("stock_move__location_dest_id"."parent_left" < $626))) OR (("stock_move__location_dest_id"."parent_left" >= $627) AND ("stock_move__location_dest_id"."parent_left" < $628))) OR (("stock_move__location_dest_id"."parent_left" >= $629) AND ("stock_move__location_dest_id"."parent_left" < $630))) OR (("stock_move__location_dest_id"."parent_left" >= $631) AND ("stock_move__location_dest_id"."parent_left" < $632)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $633) OR ("stock_move__location_id"."parent_left" >= $634)) AND (("stock_move__location_id"."parent_left" < $635) OR ("stock_move__location_id"."parent_left" >= $636))) AND (("stock_move__location_id"."parent_left" < $637) OR ("stock_move__location_id"."parent_left" >= $638))) AND (("stock_move__location_id"."parent_left" < $639) OR ("stock_move__location_id"."parent_left" >= $640))) AND (("stock_move__location_id"."parent_left" < $641) OR ("stock_move__location_id"."parent_left" >= $642))) AND (("stock_move__location_id"."parent_left" < $643) OR ("stock_move__location_id"."parent_left" >= $644))) AND (("stock_move__location_id"."parent_left" < $645) OR ("stock_move__location_id"."parent_left" >= $646))) AND (("stock_move__location_id"."parent_left" < $647) OR ("stock_move__location_id"."parent_left" >= $648))) AND (("stock_move__location_id"."parent_left" < $649) OR ("stock_move__location_id"."parent_left" >= $650))) AND (("stock_move__location_id"."parent_left" < $651) OR ("stock_move__location_id"."parent_left" >= $652))) AND (("stock_move__location_id"."parent_left" < $653) OR ("stock_move__location_id"."parent_left" >= $654))) AND (("stock_move__location_id"."parent_left" < $655) OR ("stock_move__location_id"."parent_left" >= $656))) AND (("stock_move__location_id"."parent_left" < $657) OR ("stock_move__location_id"."parent_left" >= $658))) AND (("stock_move__location_id"."parent_left" < $659) OR ("stock_move__location_id"."parent_left" >= $660)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
85 min < 0.1%	8,642 ms	587 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $598) AND ("stock_move__location_dest_id"."parent_left" < $599)) OR (("stock_move__location_dest_id"."parent_left" >= $600) AND ("stock_move__location_dest_id"."parent_left" < $601))) OR ("stock_move"."location_dest_id" in ($602)))) AND (((("stock_move__location_id"."parent_left" < $603) OR ("stock_move__location_id"."parent_left" >= $604)) AND (("stock_move__location_id"."parent_left" < $605) OR ("stock_move__location_id"."parent_left" >= $606))) AND (NOT (("stock_move"."location_id" in ($607)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
83 min < 0.1%	8,097 ms	613 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $605) AND ("stock_move__location_dest_id"."parent_left" < $606)) OR (("stock_move__location_dest_id"."parent_left" >= $607) AND ("stock_move__location_dest_id"."parent_left" < $608))) OR ("stock_move"."location_dest_id" in ($609)))) AND (((("stock_move__location_id"."parent_left" < $610) OR ("stock_move__location_id"."parent_left" >= $611)) AND (("stock_move__location_id"."parent_left" < $612) OR ("stock_move__location_id"."parent_left" >= $613))) AND (NOT (("stock_move"."location_id" in ($614)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
80 min < 0.1%	7,970 ms	601 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $605) AND ("stock_move__location_id"."parent_left" < $606)) OR (("stock_move__location_id"."parent_left" >= $607) AND ("stock_move__location_id"."parent_left" < $608))) OR ("stock_move"."location_id" in ($609)))) AND (((("stock_move__location_dest_id"."parent_left" < $610) OR ("stock_move__location_dest_id"."parent_left" >= $611)) AND (("stock_move__location_dest_id"."parent_left" < $612) OR ("stock_move__location_dest_id"."parent_left" >= $613))) AND (NOT (("stock_move"."location_dest_id" in ($614)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
78 min < 0.1%	8,091 ms	576 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $598) AND ("stock_move__location_id"."parent_left" < $599)) OR (("stock_move__location_id"."parent_left" >= $600) AND ("stock_move__location_id"."parent_left" < $601))) OR ("stock_move"."location_id" in ($602)))) AND (((("stock_move__location_dest_id"."parent_left" < $603) OR ("stock_move__location_dest_id"."parent_left" >= $604)) AND (("stock_move__location_dest_id"."parent_left" < $605) OR ("stock_move__location_dest_id"."parent_left" >= $606))) AND (NOT (("stock_move"."location_dest_id" in ($607)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
77 min < 0.1%	9,511 ms	485 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $582) AND ("stock_move__location_id"."parent_left" < $583)) OR (("stock_move__location_id"."parent_left" >= $584) AND ("stock_move__location_id"."parent_left" < $585))) OR (("stock_move__location_id"."parent_left" >= $586) AND ("stock_move__location_id"."parent_left" < $587))) OR (("stock_move__location_id"."parent_left" >= $588) AND ("stock_move__location_id"."parent_left" < $589))) OR (("stock_move__location_id"."parent_left" >= $590) AND ("stock_move__location_id"."parent_left" < $591))) OR (("stock_move__location_id"."parent_left" >= $592) AND ("stock_move__location_id"."parent_left" < $593))) OR (("stock_move__location_id"."parent_left" >= $594) AND ("stock_move__location_id"."parent_left" < $595))) OR (("stock_move__location_id"."parent_left" >= $596) AND ("stock_move__location_id"."parent_left" < $597))) OR (("stock_move__location_id"."parent_left" >= $598) AND ("stock_move__location_id"."parent_left" < $599))) OR (("stock_move__location_id"."parent_left" >= $600) AND ("stock_move__location_id"."parent_left" < $601))) OR (("stock_move__location_id"."parent_left" >= $602) AND ("stock_move__location_id"."parent_left" < $603))) OR (("stock_move__location_id"."parent_left" >= $604) AND ("stock_move__location_id"."parent_left" < $605))) OR (("stock_move__location_id"."parent_left" >= $606) AND ("stock_move__location_id"."parent_left" < $607))) OR (("stock_move__location_id"."parent_left" >= $608) AND ("stock_move__location_id"."parent_left" < $609)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $610) OR ("stock_move__location_dest_id"."parent_left" >= $611)) AND (("stock_move__location_dest_id"."parent_left" < $612) OR ("stock_move__location_dest_id"."parent_left" >= $613))) AND (("stock_move__location_dest_id"."parent_left" < $614) OR ("stock_move__location_dest_id"."parent_left" >= $615))) AND (("stock_move__location_dest_id"."parent_left" < $616) OR ("stock_move__location_dest_id"."parent_left" >= $617))) AND (("stock_move__location_dest_id"."parent_left" < $618) OR ("stock_move__location_dest_id"."parent_left" >= $619))) AND (("stock_move__location_dest_id"."parent_left" < $620) OR ("stock_move__location_dest_id"."parent_left" >= $621))) AND (("stock_move__location_dest_id"."parent_left" < $622) OR ("stock_move__location_dest_id"."parent_left" >= $623))) AND (("stock_move__location_dest_id"."parent_left" < $624) OR ("stock_move__location_dest_id"."parent_left" >= $625))) AND (("stock_move__location_dest_id"."parent_left" < $626) OR ("stock_move__location_dest_id"."parent_left" >= $627))) AND (("stock_move__location_dest_id"."parent_left" < $628) OR ("stock_move__location_dest_id"."parent_left" >= $629))) AND (("stock_move__location_dest_id"."parent_left" < $630) OR ("stock_move__location_dest_id"."parent_left" >= $631))) AND (("stock_move__location_dest_id"."parent_left" < $632) OR ("stock_move__location_dest_id"."parent_left" >= $633))) AND (("stock_move__location_dest_id"."parent_left" < $634) OR ("stock_move__location_dest_id"."parent_left" >= $635))) AND (("stock_move__location_dest_id"."parent_left" < $636) OR ("stock_move__location_dest_id"."parent_left" >= $637)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
75 min < 0.1%	11,051 ms	407 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ('done','cancel','draft')) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_id" in (900718,1004893,1004894,1029147,1006438,889236,889239,889242,889278,889310,889350,889369,1006704,889555,889570,1007671,889638,1007673,1007674,1007776,981124,889650,1007785,981128,889675,889680,889687,889696,981201,981203,981205,981210,981220,890121,890123,890131,981230,890142,890149,890152,1029834,981255,890165,1029837,1029836,890419,890430,981271,890468,981281,890479,981284,981287,981299,981322,981324,981325,981327,981328,981463,981464,1010202,981488,890979,1030052,890987,981534,981563,981565,981569,981571,981573,981577,892007,981849,982059,982108,1030732,1030734,1030840,982211,1030846,982237,982243,1030851,982245,1030856,1030857,1030852,982343,1030933,901024,982445,982454,901418,982518,1017680,1017683,902460,982578,1018626,982582,982642,1018677,982656,982694,1029125,983195,983197,1018755,983247,983253,983258,983271,983288,1018788,1018794,983365,983372,983387,983388,983396,983404,1034514,983406,1034516,1034515,1034518,983416,1034519,1034517,983432,1018823,983486,1018844,983638,905268,1018847,1018848,1018849,983646,1018850,983647,983711,983778,983823,1018883,983841,1018922,1018929,1018930,1019052,1019097,1019110,1019128,1019133,1019135,1019136,1019137,1019138,1019145,1019146,767640,1019149,910992,1019159,1019166,1019170,1019177,1019178,1019181,1019183,1019184,1019185,1019186,1019213,1019214,1019329,1019340,1019352,1019367,1019376,1019381,1019446,1019447,1019450,1019493,1019510,1019520,1019524,1019531,1019534,1021881,1021882,1038841,984296,1039562,1021885,1039566,984309,1039565,1039569,984324,1039571,1039619,1039821,1039820,1039824,1040080,1040081,1040084,1040089,1040443,1040461,1040462,1040463,1021891,1040476,1040477,1043782,1021894,1045218,1045238,1045239,1045243,984620,1045824,984795,985158,985162,985169,985184,985385,985523,985534,985677,985696,985735,985749,985753,985756,985759,985763,985772,985877,985887,985907,986080,986120,986489,986699,986700,986701,986703,986704,979343,986705,986975,986981,987057,987058,987370,987372,987373,987637,987726,979383,988157,988263,979411,988880,989752,990840,991769,878758,878983,878990,979671,879786,879833,879841,926511,993599,993644,993995,879934,994060,880883,880888,881344,881345,979821,979825,979829,979836,979838,881420,881738,881751,881781,979885,994506,930548,881838,881844,994533,994547,882282,882287,994688,994693,994699,994704,994714,994715,882986,883022,995565,1020400,1021470,995892,1021475,1021481,996654,1021483,1021482,1021485,1021486,883071,996881,1021495,1021498,1021499,1021500,1021501,996892,1021508,996896,1021517,1021873,1021874,1021875,1021876,1021877,1021878,1021879,1021880,980438,980435,1021883,1021884,996925,1021886,1021887,1021888,980455,1021890,1021889,1021892,1021893,980457,1021895,980463,1021897,1021896,1021899,1021900,1021901,997835,1021902,1021904,1021905,1021903,980489,885705,1021906,1022151,1022518,1022519,1022520,1022522,1022523,886249,1022525,1022527,1022528,1022529,1022530,1022531,1022532,1022533,1022534,1022535,1022536,1022537,1022538,1022539,1022540,886272,1022542,1022547,1022548,1022551,1022552,886312,1022555,886303,1022541,1022559,1022560,1022561,1022558,1022557,1022695,980547,1022781,1022823,1022868,1022869,1022598,1022922,1022953,886461,1022965,886555,1022970,1022971,1022969,1022973,1022974,1022975,1022976,1023017,1023020,1023021,1023022,1022972,1023024,1023025,1023026,1023027,1023028,1023029,1023067,1023071,980602,1002146,1010150,1012972,1014065,1022060,1022924,1028981,1034228,1045336,1048007,1023195,1023205,1023207,1023208,1023261,1023262,1023263,1023265,1023425,1023583,1023587,1023590,887148,1023603,1023604,1023605,980656,1023607,1023609,1023608,1023612,1023616,1023618,1023619,1023620,1023621,980679,980660,980676,1023630,1023631,1023632,1023633,1023636,980694,1023639,1023640,1023644,1023645,887342,1023648,1023655,1023647,1023657,1023793,1023794,1023804,1023808,1023814,1023817,887389,1023825,1023849,1023850,1023852,1023920,1024016,999911,1024060,980760,1000097,1024106,1024110,1024111,1024112,1024109,999913,1024260,1024278,1000716,1024280,1024281,1024288,1024290,1024292,1024300,1024316,1024328,1024329,887456,1024331,1024340,1024339,980862,1001036,1024360,1024367,1024384,1024385,980866,1024369,980873,1025274,980881,1026913,1027084,1027103,1027270,1027362,1028061,980892,1028076,1028077,980896,980899,980902,888006,1028133,1028135,1028136,1028138,1028139,1028149,1028150,980924,980925,980928,980931,888068,1028573,1002460,980938,1002668,1028729,888180,888185,1004889,1004890,1004891,1004892))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= 192) AND ("stock_move__location_id"."parent_left" < 193)) OR (("stock_move__location_id"."parent_left" >= 196) AND ("stock_move__location_id"."parent_left" < 197))) OR (("stock_move__location_id"."parent_left" >= 208) AND ("stock_move__location_id"."parent_left" < 209))) OR (("stock_move__location_id"."parent_left" >= 220) AND ("stock_move__location_id"."parent_left" < 221))) OR (("stock_move__location_id"."parent_left" >= 232) AND ("stock_move__location_id"."parent_left" < 233))) OR (("stock_move__location_id"."parent_left" >= 244) AND ("stock_move__location_id"."parent_left" < 245))) OR (("stock_move__location_id"."parent_left" >= 412) AND ("stock_move__location_id"."parent_left" < 413))) OR (("stock_move__location_id"."parent_left" >= 522) AND ("stock_move__location_id"."parent_left" < 523))) OR (("stock_move__location_id"."parent_left" >= 534) AND ("stock_move__location_id"."parent_left" < 535))) OR (("stock_move__location_id"."parent_left" >= 546) AND ("stock_move__location_id"."parent_left" < 547))) OR (("stock_move__location_id"."parent_left" >= 558) AND ("stock_move__location_id"."parent_left" < 559))) OR (("stock_move__location_id"."parent_left" >= 570) AND ("stock_move__location_id"."parent_left" < 571))) OR (("stock_move__location_id"."parent_left" >= 594) AND ("stock_move__location_id"."parent_left" < 595))) OR (("stock_move__location_id"."parent_left" >= 664) AND ("stock_move__location_id"."parent_left" < 665)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < 192) OR ("stock_move__location_dest_id"."parent_left" >= 193)) AND (("stock_move__location_dest_id"."parent_left" < 196) OR ("stock_move__location_dest_id"."parent_left" >= 197))) AND (("stock_move__location_dest_id"."parent_left" < 208) OR ("stock_move__location_dest_id"."parent_left" >= 209))) AND (("stock_move__location_dest_id"."parent_left" < 220) OR ("stock_move__location_dest_id"."parent_left" >= 221))) AND (("stock_move__location_dest_id"."parent_left" < 232) OR ("stock_move__location_dest_id"."parent_left" >= 233))) AND (("stock_move__location_dest_id"."parent_left" < 244) OR ("stock_move__location_dest_id"."parent_left" >= 245))) AND (("stock_move__location_dest_id"."parent_left" < 412) OR ("stock_move__location_dest_id"."parent_left" >= 413))) AND (("stock_move__location_dest_id"."parent_left" < 522) OR ("stock_move__location_dest_id"."parent_left" >= 523))) AND (("stock_move__location_dest_id"."parent_left" < 534) OR ("stock_move__location_dest_id"."parent_left" >= 535))) AND (("stock_move__location_dest_id"."parent_left" < 546) OR ("stock_move__location_dest_id"."parent_left" >= 547))) AND (("stock_move__location_dest_id"."parent_left" < 558) OR ("stock_move__location_dest_id"."parent_left" >= 559))) AND (("stock_move__location_dest_id"."parent_left" < 570) OR ("stock_move__location_dest_id"."parent_left" >= 571))) AND (("stock_move__location_dest_id"."parent_left" < 594) OR ("stock_move__location_dest_id"."parent_left" >= 595))) AND (("stock_move__location_dest_id"."parent_left" < 664) OR ("stock_move__location_dest_id"."parent_left" >= 665)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
67 min < 0.1%	72 ms	55,589 odoo
`SELECT "product_product".id FROM "product_product" WHERE (("product_product"."active" = $1) AND ("product_product"."default_code"::text ilike $2)) ORDER BY "product_product"."default_code" ,"product_product"."id" limit $3`
66 min < 0.1%	8,133 ms	485 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $582) AND ("stock_move__location_dest_id"."parent_left" < $583)) OR (("stock_move__location_dest_id"."parent_left" >= $584) AND ("stock_move__location_dest_id"."parent_left" < $585))) OR (("stock_move__location_dest_id"."parent_left" >= $586) AND ("stock_move__location_dest_id"."parent_left" < $587))) OR (("stock_move__location_dest_id"."parent_left" >= $588) AND ("stock_move__location_dest_id"."parent_left" < $589))) OR (("stock_move__location_dest_id"."parent_left" >= $590) AND ("stock_move__location_dest_id"."parent_left" < $591))) OR (("stock_move__location_dest_id"."parent_left" >= $592) AND ("stock_move__location_dest_id"."parent_left" < $593))) OR (("stock_move__location_dest_id"."parent_left" >= $594) AND ("stock_move__location_dest_id"."parent_left" < $595))) OR (("stock_move__location_dest_id"."parent_left" >= $596) AND ("stock_move__location_dest_id"."parent_left" < $597))) OR (("stock_move__location_dest_id"."parent_left" >= $598) AND ("stock_move__location_dest_id"."parent_left" < $599))) OR (("stock_move__location_dest_id"."parent_left" >= $600) AND ("stock_move__location_dest_id"."parent_left" < $601))) OR (("stock_move__location_dest_id"."parent_left" >= $602) AND ("stock_move__location_dest_id"."parent_left" < $603))) OR (("stock_move__location_dest_id"."parent_left" >= $604) AND ("stock_move__location_dest_id"."parent_left" < $605))) OR (("stock_move__location_dest_id"."parent_left" >= $606) AND ("stock_move__location_dest_id"."parent_left" < $607))) OR (("stock_move__location_dest_id"."parent_left" >= $608) AND ("stock_move__location_dest_id"."parent_left" < $609)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $610) OR ("stock_move__location_id"."parent_left" >= $611)) AND (("stock_move__location_id"."parent_left" < $612) OR ("stock_move__location_id"."parent_left" >= $613))) AND (("stock_move__location_id"."parent_left" < $614) OR ("stock_move__location_id"."parent_left" >= $615))) AND (("stock_move__location_id"."parent_left" < $616) OR ("stock_move__location_id"."parent_left" >= $617))) AND (("stock_move__location_id"."parent_left" < $618) OR ("stock_move__location_id"."parent_left" >= $619))) AND (("stock_move__location_id"."parent_left" < $620) OR ("stock_move__location_id"."parent_left" >= $621))) AND (("stock_move__location_id"."parent_left" < $622) OR ("stock_move__location_id"."parent_left" >= $623))) AND (("stock_move__location_id"."parent_left" < $624) OR ("stock_move__location_id"."parent_left" >= $625))) AND (("stock_move__location_id"."parent_left" < $626) OR ("stock_move__location_id"."parent_left" >= $627))) AND (("stock_move__location_id"."parent_left" < $628) OR ("stock_move__location_id"."parent_left" >= $629))) AND (("stock_move__location_id"."parent_left" < $630) OR ("stock_move__location_id"."parent_left" >= $631))) AND (("stock_move__location_id"."parent_left" < $632) OR ("stock_move__location_id"."parent_left" >= $633))) AND (("stock_move__location_id"."parent_left" < $634) OR ("stock_move__location_id"."parent_left" >= $635))) AND (("stock_move__location_id"."parent_left" < $636) OR ("stock_move__location_id"."parent_left" >= $637)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
64 min < 0.1%	7,997 ms	479 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $582) AND ("stock_move__location_dest_id"."parent_left" < $583)) OR (("stock_move__location_dest_id"."parent_left" >= $584) AND ("stock_move__location_dest_id"."parent_left" < $585))) OR ("stock_move"."location_dest_id" in ($586)))) AND (((("stock_move__location_id"."parent_left" < $587) OR ("stock_move__location_id"."parent_left" >= $588)) AND (("stock_move__location_id"."parent_left" < $589) OR ("stock_move__location_id"."parent_left" >= $590))) AND (NOT (("stock_move"."location_id" in ($591)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
62 min < 0.1%	7,916 ms	468 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $582) AND ("stock_move__location_id"."parent_left" < $583)) OR (("stock_move__location_id"."parent_left" >= $584) AND ("stock_move__location_id"."parent_left" < $585))) OR ("stock_move"."location_id" in ($586)))) AND (((("stock_move__location_dest_id"."parent_left" < $587) OR ("stock_move__location_dest_id"."parent_left" >= $588)) AND (("stock_move__location_dest_id"."parent_left" < $589) OR ("stock_move__location_dest_id"."parent_left" >= $590))) AND (NOT (("stock_move"."location_dest_id" in ($591)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
61 min < 0.1%	8,980 ms	407 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $590) AND ("stock_move__location_dest_id"."parent_left" < $591)) OR (("stock_move__location_dest_id"."parent_left" >= $592) AND ("stock_move__location_dest_id"."parent_left" < $593))) OR (("stock_move__location_dest_id"."parent_left" >= $594) AND ("stock_move__location_dest_id"."parent_left" < $595))) OR (("stock_move__location_dest_id"."parent_left" >= $596) AND ("stock_move__location_dest_id"."parent_left" < $597))) OR (("stock_move__location_dest_id"."parent_left" >= $598) AND ("stock_move__location_dest_id"."parent_left" < $599))) OR (("stock_move__location_dest_id"."parent_left" >= $600) AND ("stock_move__location_dest_id"."parent_left" < $601))) OR (("stock_move__location_dest_id"."parent_left" >= $602) AND ("stock_move__location_dest_id"."parent_left" < $603))) OR (("stock_move__location_dest_id"."parent_left" >= $604) AND ("stock_move__location_dest_id"."parent_left" < $605))) OR (("stock_move__location_dest_id"."parent_left" >= $606) AND ("stock_move__location_dest_id"."parent_left" < $607))) OR (("stock_move__location_dest_id"."parent_left" >= $608) AND ("stock_move__location_dest_id"."parent_left" < $609))) OR (("stock_move__location_dest_id"."parent_left" >= $610) AND ("stock_move__location_dest_id"."parent_left" < $611))) OR (("stock_move__location_dest_id"."parent_left" >= $612) AND ("stock_move__location_dest_id"."parent_left" < $613))) OR (("stock_move__location_dest_id"."parent_left" >= $614) AND ("stock_move__location_dest_id"."parent_left" < $615))) OR (("stock_move__location_dest_id"."parent_left" >= $616) AND ("stock_move__location_dest_id"."parent_left" < $617)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $618) OR ("stock_move__location_id"."parent_left" >= $619)) AND (("stock_move__location_id"."parent_left" < $620) OR ("stock_move__location_id"."parent_left" >= $621))) AND (("stock_move__location_id"."parent_left" < $622) OR ("stock_move__location_id"."parent_left" >= $623))) AND (("stock_move__location_id"."parent_left" < $624) OR ("stock_move__location_id"."parent_left" >= $625))) AND (("stock_move__location_id"."parent_left" < $626) OR ("stock_move__location_id"."parent_left" >= $627))) AND (("stock_move__location_id"."parent_left" < $628) OR ("stock_move__location_id"."parent_left" >= $629))) AND (("stock_move__location_id"."parent_left" < $630) OR ("stock_move__location_id"."parent_left" >= $631))) AND (("stock_move__location_id"."parent_left" < $632) OR ("stock_move__location_id"."parent_left" >= $633))) AND (("stock_move__location_id"."parent_left" < $634) OR ("stock_move__location_id"."parent_left" >= $635))) AND (("stock_move__location_id"."parent_left" < $636) OR ("stock_move__location_id"."parent_left" >= $637))) AND (("stock_move__location_id"."parent_left" < $638) OR ("stock_move__location_id"."parent_left" >= $639))) AND (("stock_move__location_id"."parent_left" < $640) OR ("stock_move__location_id"."parent_left" >= $641))) AND (("stock_move__location_id"."parent_left" < $642) OR ("stock_move__location_id"."parent_left" >= $643))) AND (("stock_move__location_id"."parent_left" < $644) OR ("stock_move__location_id"."parent_left" >= $645)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
59 min < 0.1%	8,883 ms	396 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $590) AND ("stock_move__location_dest_id"."parent_left" < $591)) OR (("stock_move__location_dest_id"."parent_left" >= $592) AND ("stock_move__location_dest_id"."parent_left" < $593))) OR ("stock_move"."location_dest_id" in ($594)))) AND (((("stock_move__location_id"."parent_left" < $595) OR ("stock_move__location_id"."parent_left" >= $596)) AND (("stock_move__location_id"."parent_left" < $597) OR ("stock_move__location_id"."parent_left" >= $598))) AND (NOT (("stock_move"."location_id" in ($599)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
56 min < 0.1%	8,659 ms	389 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $590) AND ("stock_move__location_id"."parent_left" < $591)) OR (("stock_move__location_id"."parent_left" >= $592) AND ("stock_move__location_id"."parent_left" < $593))) OR ("stock_move"."location_id" in ($594)))) AND (((("stock_move__location_dest_id"."parent_left" < $595) OR ("stock_move__location_dest_id"."parent_left" >= $596)) AND (("stock_move__location_dest_id"."parent_left" < $597) OR ("stock_move__location_dest_id"."parent_left" >= $598))) AND (NOT (("stock_move"."location_dest_id" in ($599)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
50 min < 0.1%	45 ms	67,206 odoo
`UPDATE "stock_scrap" SET "scrap_qty"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 122328 Row progression: 122328, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - product_id`
48 min < 0.1%	77 ms	37,186 odoo
SELECT "material_requisition_line".id FROM "material_requisition_line" LEFT JOIN "res_partner" as "material_requisition_line__partner_id" ON ("material_requisition_line"."partner_id" = "material_requisition_line__partner_id"."id") LEFT JOIN "product_category" as "material_requisition_line__categ_id" ON ("material_requisition_line"."categ_id" = "material_requisition_line__categ_id"."id") LEFT JOIN "product_product" as "material_requisition_line__product_id" ON ("material_requisition_line"."product_id" = "material_requisition_line__product_id"."id") WHERE ("material_requisition_line"."requisition_id" in ($1)) ORDER BY "material_requisition_line__partner_id"."display_name" ,"material_requisition_line__categ_id"."parent_left" ,"material_requisition_line__product_id"."default_code" ,"material_requisition_line__product_id"."id"
44 min < 0.1%	12,964 ms	205 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $577) AND ("stock_move__location_id"."parent_left" < $578)) OR (("stock_move__location_id"."parent_left" >= $579) AND ("stock_move__location_id"."parent_left" < $580))) OR (("stock_move__location_id"."parent_left" >= $581) AND ("stock_move__location_id"."parent_left" < $582))) OR (("stock_move__location_id"."parent_left" >= $583) AND ("stock_move__location_id"."parent_left" < $584))) OR (("stock_move__location_id"."parent_left" >= $585) AND ("stock_move__location_id"."parent_left" < $586))) OR (("stock_move__location_id"."parent_left" >= $587) AND ("stock_move__location_id"."parent_left" < $588))) OR (("stock_move__location_id"."parent_left" >= $589) AND ("stock_move__location_id"."parent_left" < $590))) OR (("stock_move__location_id"."parent_left" >= $591) AND ("stock_move__location_id"."parent_left" < $592))) OR (("stock_move__location_id"."parent_left" >= $593) AND ("stock_move__location_id"."parent_left" < $594))) OR (("stock_move__location_id"."parent_left" >= $595) AND ("stock_move__location_id"."parent_left" < $596))) OR (("stock_move__location_id"."parent_left" >= $597) AND ("stock_move__location_id"."parent_left" < $598))) OR (("stock_move__location_id"."parent_left" >= $599) AND ("stock_move__location_id"."parent_left" < $600))) OR (("stock_move__location_id"."parent_left" >= $601) AND ("stock_move__location_id"."parent_left" < $602))) OR (("stock_move__location_id"."parent_left" >= $603) AND ("stock_move__location_id"."parent_left" < $604)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $605) OR ("stock_move__location_dest_id"."parent_left" >= $606)) AND (("stock_move__location_dest_id"."parent_left" < $607) OR ("stock_move__location_dest_id"."parent_left" >= $608))) AND (("stock_move__location_dest_id"."parent_left" < $609) OR ("stock_move__location_dest_id"."parent_left" >= $610))) AND (("stock_move__location_dest_id"."parent_left" < $611) OR ("stock_move__location_dest_id"."parent_left" >= $612))) AND (("stock_move__location_dest_id"."parent_left" < $613) OR ("stock_move__location_dest_id"."parent_left" >= $614))) AND (("stock_move__location_dest_id"."parent_left" < $615) OR ("stock_move__location_dest_id"."parent_left" >= $616))) AND (("stock_move__location_dest_id"."parent_left" < $617) OR ("stock_move__location_dest_id"."parent_left" >= $618))) AND (("stock_move__location_dest_id"."parent_left" < $619) OR ("stock_move__location_dest_id"."parent_left" >= $620))) AND (("stock_move__location_dest_id"."parent_left" < $621) OR ("stock_move__location_dest_id"."parent_left" >= $622))) AND (("stock_move__location_dest_id"."parent_left" < $623) OR ("stock_move__location_dest_id"."parent_left" >= $624))) AND (("stock_move__location_dest_id"."parent_left" < $625) OR ("stock_move__location_dest_id"."parent_left" >= $626))) AND (("stock_move__location_dest_id"."parent_left" < $627) OR ("stock_move__location_dest_id"."parent_left" >= $628))) AND (("stock_move__location_dest_id"."parent_left" < $629) OR ("stock_move__location_dest_id"."parent_left" >= $630))) AND (("stock_move__location_dest_id"."parent_left" < $631) OR ("stock_move__location_dest_id"."parent_left" >= $632)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
41 min < 0.1%	9,617 ms	257 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $585) AND ("stock_move__location_id"."parent_left" < $586)) OR (("stock_move__location_id"."parent_left" >= $587) AND ("stock_move__location_id"."parent_left" < $588))) OR (("stock_move__location_id"."parent_left" >= $589) AND ("stock_move__location_id"."parent_left" < $590))) OR (("stock_move__location_id"."parent_left" >= $591) AND ("stock_move__location_id"."parent_left" < $592))) OR (("stock_move__location_id"."parent_left" >= $593) AND ("stock_move__location_id"."parent_left" < $594))) OR (("stock_move__location_id"."parent_left" >= $595) AND ("stock_move__location_id"."parent_left" < $596))) OR (("stock_move__location_id"."parent_left" >= $597) AND ("stock_move__location_id"."parent_left" < $598))) OR (("stock_move__location_id"."parent_left" >= $599) AND ("stock_move__location_id"."parent_left" < $600))) OR (("stock_move__location_id"."parent_left" >= $601) AND ("stock_move__location_id"."parent_left" < $602))) OR (("stock_move__location_id"."parent_left" >= $603) AND ("stock_move__location_id"."parent_left" < $604))) OR (("stock_move__location_id"."parent_left" >= $605) AND ("stock_move__location_id"."parent_left" < $606))) OR (("stock_move__location_id"."parent_left" >= $607) AND ("stock_move__location_id"."parent_left" < $608))) OR (("stock_move__location_id"."parent_left" >= $609) AND ("stock_move__location_id"."parent_left" < $610))) OR (("stock_move__location_id"."parent_left" >= $611) AND ("stock_move__location_id"."parent_left" < $612)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $613) OR ("stock_move__location_dest_id"."parent_left" >= $614)) AND (("stock_move__location_dest_id"."parent_left" < $615) OR ("stock_move__location_dest_id"."parent_left" >= $616))) AND (("stock_move__location_dest_id"."parent_left" < $617) OR ("stock_move__location_dest_id"."parent_left" >= $618))) AND (("stock_move__location_dest_id"."parent_left" < $619) OR ("stock_move__location_dest_id"."parent_left" >= $620))) AND (("stock_move__location_dest_id"."parent_left" < $621) OR ("stock_move__location_dest_id"."parent_left" >= $622))) AND (("stock_move__location_dest_id"."parent_left" < $623) OR ("stock_move__location_dest_id"."parent_left" >= $624))) AND (("stock_move__location_dest_id"."parent_left" < $625) OR ("stock_move__location_dest_id"."parent_left" >= $626))) AND (("stock_move__location_dest_id"."parent_left" < $627) OR ("stock_move__location_dest_id"."parent_left" >= $628))) AND (("stock_move__location_dest_id"."parent_left" < $629) OR ("stock_move__location_dest_id"."parent_left" >= $630))) AND (("stock_move__location_dest_id"."parent_left" < $631) OR ("stock_move__location_dest_id"."parent_left" >= $632))) AND (("stock_move__location_dest_id"."parent_left" < $633) OR ("stock_move__location_dest_id"."parent_left" >= $634))) AND (("stock_move__location_dest_id"."parent_left" < $635) OR ("stock_move__location_dest_id"."parent_left" >= $636))) AND (("stock_move__location_dest_id"."parent_left" < $637) OR ("stock_move__location_dest_id"."parent_left" >= $638))) AND (("stock_move__location_dest_id"."parent_left" < $639) OR ("stock_move__location_dest_id"."parent_left" >= $640)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
40 min < 0.1%	9,734 ms	246 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $592) AND ("stock_move__location_id"."parent_left" < $593)) OR (("stock_move__location_id"."parent_left" >= $594) AND ("stock_move__location_id"."parent_left" < $595))) OR (("stock_move__location_id"."parent_left" >= $596) AND ("stock_move__location_id"."parent_left" < $597))) OR (("stock_move__location_id"."parent_left" >= $598) AND ("stock_move__location_id"."parent_left" < $599))) OR (("stock_move__location_id"."parent_left" >= $600) AND ("stock_move__location_id"."parent_left" < $601))) OR (("stock_move__location_id"."parent_left" >= $602) AND ("stock_move__location_id"."parent_left" < $603))) OR (("stock_move__location_id"."parent_left" >= $604) AND ("stock_move__location_id"."parent_left" < $605))) OR (("stock_move__location_id"."parent_left" >= $606) AND ("stock_move__location_id"."parent_left" < $607))) OR (("stock_move__location_id"."parent_left" >= $608) AND ("stock_move__location_id"."parent_left" < $609))) OR (("stock_move__location_id"."parent_left" >= $610) AND ("stock_move__location_id"."parent_left" < $611))) OR (("stock_move__location_id"."parent_left" >= $612) AND ("stock_move__location_id"."parent_left" < $613))) OR (("stock_move__location_id"."parent_left" >= $614) AND ("stock_move__location_id"."parent_left" < $615))) OR (("stock_move__location_id"."parent_left" >= $616) AND ("stock_move__location_id"."parent_left" < $617))) OR (("stock_move__location_id"."parent_left" >= $618) AND ("stock_move__location_id"."parent_left" < $619)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $620) OR ("stock_move__location_dest_id"."parent_left" >= $621)) AND (("stock_move__location_dest_id"."parent_left" < $622) OR ("stock_move__location_dest_id"."parent_left" >= $623))) AND (("stock_move__location_dest_id"."parent_left" < $624) OR ("stock_move__location_dest_id"."parent_left" >= $625))) AND (("stock_move__location_dest_id"."parent_left" < $626) OR ("stock_move__location_dest_id"."parent_left" >= $627))) AND (("stock_move__location_dest_id"."parent_left" < $628) OR ("stock_move__location_dest_id"."parent_left" >= $629))) AND (("stock_move__location_dest_id"."parent_left" < $630) OR ("stock_move__location_dest_id"."parent_left" >= $631))) AND (("stock_move__location_dest_id"."parent_left" < $632) OR ("stock_move__location_dest_id"."parent_left" >= $633))) AND (("stock_move__location_dest_id"."parent_left" < $634) OR ("stock_move__location_dest_id"."parent_left" >= $635))) AND (("stock_move__location_dest_id"."parent_left" < $636) OR ("stock_move__location_dest_id"."parent_left" >= $637))) AND (("stock_move__location_dest_id"."parent_left" < $638) OR ("stock_move__location_dest_id"."parent_left" >= $639))) AND (("stock_move__location_dest_id"."parent_left" < $640) OR ("stock_move__location_dest_id"."parent_left" >= $641))) AND (("stock_move__location_dest_id"."parent_left" < $642) OR ("stock_move__location_dest_id"."parent_left" >= $643))) AND (("stock_move__location_dest_id"."parent_left" < $644) OR ("stock_move__location_dest_id"."parent_left" >= $645))) AND (("stock_move__location_dest_id"."parent_left" < $646) OR ("stock_move__location_dest_id"."parent_left" >= $647)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
38 min < 0.1%	11,313 ms	201 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_id"."parent_left" >= $569) AND ("stock_move__location_id"."parent_left" < $570)) OR (("stock_move__location_id"."parent_left" >= $571) AND ("stock_move__location_id"."parent_left" < $572))) OR (("stock_move__location_id"."parent_left" >= $573) AND ("stock_move__location_id"."parent_left" < $574))) OR (("stock_move__location_id"."parent_left" >= $575) AND ("stock_move__location_id"."parent_left" < $576))) OR (("stock_move__location_id"."parent_left" >= $577) AND ("stock_move__location_id"."parent_left" < $578))) OR (("stock_move__location_id"."parent_left" >= $579) AND ("stock_move__location_id"."parent_left" < $580))) OR (("stock_move__location_id"."parent_left" >= $581) AND ("stock_move__location_id"."parent_left" < $582))) OR (("stock_move__location_id"."parent_left" >= $583) AND ("stock_move__location_id"."parent_left" < $584))) OR (("stock_move__location_id"."parent_left" >= $585) AND ("stock_move__location_id"."parent_left" < $586))) OR (("stock_move__location_id"."parent_left" >= $587) AND ("stock_move__location_id"."parent_left" < $588))) OR (("stock_move__location_id"."parent_left" >= $589) AND ("stock_move__location_id"."parent_left" < $590))) OR (("stock_move__location_id"."parent_left" >= $591) AND ("stock_move__location_id"."parent_left" < $592))) OR (("stock_move__location_id"."parent_left" >= $593) AND ("stock_move__location_id"."parent_left" < $594))) OR (("stock_move__location_id"."parent_left" >= $595) AND ("stock_move__location_id"."parent_left" < $596)))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" < $597) OR ("stock_move__location_dest_id"."parent_left" >= $598)) AND (("stock_move__location_dest_id"."parent_left" < $599) OR ("stock_move__location_dest_id"."parent_left" >= $600))) AND (("stock_move__location_dest_id"."parent_left" < $601) OR ("stock_move__location_dest_id"."parent_left" >= $602))) AND (("stock_move__location_dest_id"."parent_left" < $603) OR ("stock_move__location_dest_id"."parent_left" >= $604))) AND (("stock_move__location_dest_id"."parent_left" < $605) OR ("stock_move__location_dest_id"."parent_left" >= $606))) AND (("stock_move__location_dest_id"."parent_left" < $607) OR ("stock_move__location_dest_id"."parent_left" >= $608))) AND (("stock_move__location_dest_id"."parent_left" < $609) OR ("stock_move__location_dest_id"."parent_left" >= $610))) AND (("stock_move__location_dest_id"."parent_left" < $611) OR ("stock_move__location_dest_id"."parent_left" >= $612))) AND (("stock_move__location_dest_id"."parent_left" < $613) OR ("stock_move__location_dest_id"."parent_left" >= $614))) AND (("stock_move__location_dest_id"."parent_left" < $615) OR ("stock_move__location_dest_id"."parent_left" >= $616))) AND (("stock_move__location_dest_id"."parent_left" < $617) OR ("stock_move__location_dest_id"."parent_left" >= $618))) AND (("stock_move__location_dest_id"."parent_left" < $619) OR ("stock_move__location_dest_id"."parent_left" >= $620))) AND (("stock_move__location_dest_id"."parent_left" < $621) OR ("stock_move__location_dest_id"."parent_left" >= $622))) AND (("stock_move__location_dest_id"."parent_left" < $623) OR ("stock_move__location_dest_id"."parent_left" >= $624)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
37 min < 0.1%	9,020 ms	246 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $592) AND ("stock_move__location_id"."parent_left" < $593)) OR (("stock_move__location_id"."parent_left" >= $594) AND ("stock_move__location_id"."parent_left" < $595))) OR ("stock_move"."location_id" in ($596)))) AND (((("stock_move__location_dest_id"."parent_left" < $597) OR ("stock_move__location_dest_id"."parent_left" >= $598)) AND (("stock_move__location_dest_id"."parent_left" < $599) OR ("stock_move__location_dest_id"."parent_left" >= $600))) AND (NOT (("stock_move"."location_dest_id" in ($601)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
36 min < 0.1%	8,436 ms	257 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $585) AND ("stock_move__location_id"."parent_left" < $586)) OR (("stock_move__location_id"."parent_left" >= $587) AND ("stock_move__location_id"."parent_left" < $588))) OR ("stock_move"."location_id" in ($589)))) AND (((("stock_move__location_dest_id"."parent_left" < $590) OR ("stock_move__location_dest_id"."parent_left" >= $591)) AND (("stock_move__location_dest_id"."parent_left" < $592) OR ("stock_move__location_dest_id"."parent_left" >= $593))) AND (NOT (("stock_move"."location_dest_id" in ($594)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
36 min < 0.1%	8,412 ms	257 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $585) AND ("stock_move__location_dest_id"."parent_left" < $586)) OR (("stock_move__location_dest_id"."parent_left" >= $587) AND ("stock_move__location_dest_id"."parent_left" < $588))) OR (("stock_move__location_dest_id"."parent_left" >= $589) AND ("stock_move__location_dest_id"."parent_left" < $590))) OR (("stock_move__location_dest_id"."parent_left" >= $591) AND ("stock_move__location_dest_id"."parent_left" < $592))) OR (("stock_move__location_dest_id"."parent_left" >= $593) AND ("stock_move__location_dest_id"."parent_left" < $594))) OR (("stock_move__location_dest_id"."parent_left" >= $595) AND ("stock_move__location_dest_id"."parent_left" < $596))) OR (("stock_move__location_dest_id"."parent_left" >= $597) AND ("stock_move__location_dest_id"."parent_left" < $598))) OR (("stock_move__location_dest_id"."parent_left" >= $599) AND ("stock_move__location_dest_id"."parent_left" < $600))) OR (("stock_move__location_dest_id"."parent_left" >= $601) AND ("stock_move__location_dest_id"."parent_left" < $602))) OR (("stock_move__location_dest_id"."parent_left" >= $603) AND ("stock_move__location_dest_id"."parent_left" < $604))) OR (("stock_move__location_dest_id"."parent_left" >= $605) AND ("stock_move__location_dest_id"."parent_left" < $606))) OR (("stock_move__location_dest_id"."parent_left" >= $607) AND ("stock_move__location_dest_id"."parent_left" < $608))) OR (("stock_move__location_dest_id"."parent_left" >= $609) AND ("stock_move__location_dest_id"."parent_left" < $610))) OR (("stock_move__location_dest_id"."parent_left" >= $611) AND ("stock_move__location_dest_id"."parent_left" < $612)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $613) OR ("stock_move__location_id"."parent_left" >= $614)) AND (("stock_move__location_id"."parent_left" < $615) OR ("stock_move__location_id"."parent_left" >= $616))) AND (("stock_move__location_id"."parent_left" < $617) OR ("stock_move__location_id"."parent_left" >= $618))) AND (("stock_move__location_id"."parent_left" < $619) OR ("stock_move__location_id"."parent_left" >= $620))) AND (("stock_move__location_id"."parent_left" < $621) OR ("stock_move__location_id"."parent_left" >= $622))) AND (("stock_move__location_id"."parent_left" < $623) OR ("stock_move__location_id"."parent_left" >= $624))) AND (("stock_move__location_id"."parent_left" < $625) OR ("stock_move__location_id"."parent_left" >= $626))) AND (("stock_move__location_id"."parent_left" < $627) OR ("stock_move__location_id"."parent_left" >= $628))) AND (("stock_move__location_id"."parent_left" < $629) OR ("stock_move__location_id"."parent_left" >= $630))) AND (("stock_move__location_id"."parent_left" < $631) OR ("stock_move__location_id"."parent_left" >= $632))) AND (("stock_move__location_id"."parent_left" < $633) OR ("stock_move__location_id"."parent_left" >= $634))) AND (("stock_move__location_id"."parent_left" < $635) OR ("stock_move__location_id"."parent_left" >= $636))) AND (("stock_move__location_id"."parent_left" < $637) OR ("stock_move__location_id"."parent_left" >= $638))) AND (("stock_move__location_id"."parent_left" < $639) OR ("stock_move__location_id"."parent_left" >= $640)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
36 min < 0.1%	10,736 ms	200 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $577) AND ("stock_move__location_id"."parent_left" < $578)) OR (("stock_move__location_id"."parent_left" >= $579) AND ("stock_move__location_id"."parent_left" < $580))) OR ("stock_move"."location_id" in ($581)))) AND (((("stock_move__location_dest_id"."parent_left" < $582) OR ("stock_move__location_dest_id"."parent_left" >= $583)) AND (("stock_move__location_dest_id"."parent_left" < $584) OR ("stock_move__location_dest_id"."parent_left" >= $585))) AND (NOT (("stock_move"."location_dest_id" in ($586)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
36 min < 0.1%	10,407 ms	205 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $577) AND ("stock_move__location_dest_id"."parent_left" < $578)) OR (("stock_move__location_dest_id"."parent_left" >= $579) AND ("stock_move__location_dest_id"."parent_left" < $580))) OR (("stock_move__location_dest_id"."parent_left" >= $581) AND ("stock_move__location_dest_id"."parent_left" < $582))) OR (("stock_move__location_dest_id"."parent_left" >= $583) AND ("stock_move__location_dest_id"."parent_left" < $584))) OR (("stock_move__location_dest_id"."parent_left" >= $585) AND ("stock_move__location_dest_id"."parent_left" < $586))) OR (("stock_move__location_dest_id"."parent_left" >= $587) AND ("stock_move__location_dest_id"."parent_left" < $588))) OR (("stock_move__location_dest_id"."parent_left" >= $589) AND ("stock_move__location_dest_id"."parent_left" < $590))) OR (("stock_move__location_dest_id"."parent_left" >= $591) AND ("stock_move__location_dest_id"."parent_left" < $592))) OR (("stock_move__location_dest_id"."parent_left" >= $593) AND ("stock_move__location_dest_id"."parent_left" < $594))) OR (("stock_move__location_dest_id"."parent_left" >= $595) AND ("stock_move__location_dest_id"."parent_left" < $596))) OR (("stock_move__location_dest_id"."parent_left" >= $597) AND ("stock_move__location_dest_id"."parent_left" < $598))) OR (("stock_move__location_dest_id"."parent_left" >= $599) AND ("stock_move__location_dest_id"."parent_left" < $600))) OR (("stock_move__location_dest_id"."parent_left" >= $601) AND ("stock_move__location_dest_id"."parent_left" < $602))) OR (("stock_move__location_dest_id"."parent_left" >= $603) AND ("stock_move__location_dest_id"."parent_left" < $604)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $605) OR ("stock_move__location_id"."parent_left" >= $606)) AND (("stock_move__location_id"."parent_left" < $607) OR ("stock_move__location_id"."parent_left" >= $608))) AND (("stock_move__location_id"."parent_left" < $609) OR ("stock_move__location_id"."parent_left" >= $610))) AND (("stock_move__location_id"."parent_left" < $611) OR ("stock_move__location_id"."parent_left" >= $612))) AND (("stock_move__location_id"."parent_left" < $613) OR ("stock_move__location_id"."parent_left" >= $614))) AND (("stock_move__location_id"."parent_left" < $615) OR ("stock_move__location_id"."parent_left" >= $616))) AND (("stock_move__location_id"."parent_left" < $617) OR ("stock_move__location_id"."parent_left" >= $618))) AND (("stock_move__location_id"."parent_left" < $619) OR ("stock_move__location_id"."parent_left" >= $620))) AND (("stock_move__location_id"."parent_left" < $621) OR ("stock_move__location_id"."parent_left" >= $622))) AND (("stock_move__location_id"."parent_left" < $623) OR ("stock_move__location_id"."parent_left" >= $624))) AND (("stock_move__location_id"."parent_left" < $625) OR ("stock_move__location_id"."parent_left" >= $626))) AND (("stock_move__location_id"."parent_left" < $627) OR ("stock_move__location_id"."parent_left" >= $628))) AND (("stock_move__location_id"."parent_left" < $629) OR ("stock_move__location_id"."parent_left" >= $630))) AND (("stock_move__location_id"."parent_left" < $631) OR ("stock_move__location_id"."parent_left" >= $632)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
35 min < 0.1%	169 ms	12,536 odoo
`SELECT "stock_inventory_line".id FROM "stock_inventory_line" WHERE ("stock_inventory_line"."prod_lot_id" in ($1)) ORDER BY "stock_inventory_line"."id"` Details `CREATE INDEX CONCURRENTLY ON stock_inventory_line (prod_lot_id)` `Rows: 126832 Row progression: 126832, 2 Row estimates - prod_lot_id (=): 2 - id (sort): 1 Existing indexes - id PRIMARY - company_id - inventory_id - location_id - package_id - product_id`
35 min < 0.1%	10,577 ms	200 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $577) AND ("stock_move__location_dest_id"."parent_left" < $578)) OR (("stock_move__location_dest_id"."parent_left" >= $579) AND ("stock_move__location_dest_id"."parent_left" < $580))) OR ("stock_move"."location_dest_id" in ($581)))) AND (((("stock_move__location_id"."parent_left" < $582) OR ("stock_move__location_id"."parent_left" >= $583)) AND (("stock_move__location_id"."parent_left" < $584) OR ("stock_move__location_id"."parent_left" >= $585))) AND (NOT (("stock_move"."location_id" in ($586)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
35 min < 0.1%	8,152 ms	257 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $585) AND ("stock_move__location_dest_id"."parent_left" < $586)) OR (("stock_move__location_dest_id"."parent_left" >= $587) AND ("stock_move__location_dest_id"."parent_left" < $588))) OR ("stock_move"."location_dest_id" in ($589)))) AND (((("stock_move__location_id"."parent_left" < $590) OR ("stock_move__location_id"."parent_left" >= $591)) AND (("stock_move__location_id"."parent_left" < $592) OR ("stock_move__location_id"."parent_left" >= $593))) AND (NOT (("stock_move"."location_id" in ($594)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
35 min < 0.1%	8,506 ms	246 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $592) AND ("stock_move__location_dest_id"."parent_left" < $593)) OR (("stock_move__location_dest_id"."parent_left" >= $594) AND ("stock_move__location_dest_id"."parent_left" < $595))) OR ("stock_move"."location_dest_id" in ($596)))) AND (((("stock_move__location_id"."parent_left" < $597) OR ("stock_move__location_id"."parent_left" >= $598)) AND (("stock_move__location_id"."parent_left" < $599) OR ("stock_move__location_id"."parent_left" >= $600))) AND (NOT (("stock_move"."location_id" in ($601)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
34 min < 0.1%	8,240 ms	246 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $592) AND ("stock_move__location_dest_id"."parent_left" < $593)) OR (("stock_move__location_dest_id"."parent_left" >= $594) AND ("stock_move__location_dest_id"."parent_left" < $595))) OR (("stock_move__location_dest_id"."parent_left" >= $596) AND ("stock_move__location_dest_id"."parent_left" < $597))) OR (("stock_move__location_dest_id"."parent_left" >= $598) AND ("stock_move__location_dest_id"."parent_left" < $599))) OR (("stock_move__location_dest_id"."parent_left" >= $600) AND ("stock_move__location_dest_id"."parent_left" < $601))) OR (("stock_move__location_dest_id"."parent_left" >= $602) AND ("stock_move__location_dest_id"."parent_left" < $603))) OR (("stock_move__location_dest_id"."parent_left" >= $604) AND ("stock_move__location_dest_id"."parent_left" < $605))) OR (("stock_move__location_dest_id"."parent_left" >= $606) AND ("stock_move__location_dest_id"."parent_left" < $607))) OR (("stock_move__location_dest_id"."parent_left" >= $608) AND ("stock_move__location_dest_id"."parent_left" < $609))) OR (("stock_move__location_dest_id"."parent_left" >= $610) AND ("stock_move__location_dest_id"."parent_left" < $611))) OR (("stock_move__location_dest_id"."parent_left" >= $612) AND ("stock_move__location_dest_id"."parent_left" < $613))) OR (("stock_move__location_dest_id"."parent_left" >= $614) AND ("stock_move__location_dest_id"."parent_left" < $615))) OR (("stock_move__location_dest_id"."parent_left" >= $616) AND ("stock_move__location_dest_id"."parent_left" < $617))) OR (("stock_move__location_dest_id"."parent_left" >= $618) AND ("stock_move__location_dest_id"."parent_left" < $619)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $620) OR ("stock_move__location_id"."parent_left" >= $621)) AND (("stock_move__location_id"."parent_left" < $622) OR ("stock_move__location_id"."parent_left" >= $623))) AND (("stock_move__location_id"."parent_left" < $624) OR ("stock_move__location_id"."parent_left" >= $625))) AND (("stock_move__location_id"."parent_left" < $626) OR ("stock_move__location_id"."parent_left" >= $627))) AND (("stock_move__location_id"."parent_left" < $628) OR ("stock_move__location_id"."parent_left" >= $629))) AND (("stock_move__location_id"."parent_left" < $630) OR ("stock_move__location_id"."parent_left" >= $631))) AND (("stock_move__location_id"."parent_left" < $632) OR ("stock_move__location_id"."parent_left" >= $633))) AND (("stock_move__location_id"."parent_left" < $634) OR ("stock_move__location_id"."parent_left" >= $635))) AND (("stock_move__location_id"."parent_left" < $636) OR ("stock_move__location_id"."parent_left" >= $637))) AND (("stock_move__location_id"."parent_left" < $638) OR ("stock_move__location_id"."parent_left" >= $639))) AND (("stock_move__location_id"."parent_left" < $640) OR ("stock_move__location_id"."parent_left" >= $641))) AND (("stock_move__location_id"."parent_left" < $642) OR ("stock_move__location_id"."parent_left" >= $643))) AND (("stock_move__location_id"."parent_left" < $644) OR ("stock_move__location_id"."parent_left" >= $645))) AND (("stock_move__location_id"."parent_left" < $646) OR ("stock_move__location_id"."parent_left" >= $647)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
32 min < 0.1%	82 ms	23,131 odoo
`SELECT "product_product".id FROM "product_product" WHERE ("product_product"."active" = $1) ORDER BY "product_product"."default_code" ,"product_product"."id" limit $2` `Covered by index on (active, default_code) Rows: 1000206 Row progression: 1000206, 500103, 0 Row estimates - active (=): 500103 - default_code (sort): 0 - id (sort): 1 Existing indexes - id PRIMARY - active, default_code - barcode UNIQUE - default_code - product_tmpl_id`
31 min < 0.1%	2,188 ms	847 odoo
SELECT min("mrp_production".id) AS id, count("mrp_production".id) AS "picking_type_id_count" , "mrp_production"."picking_type_id" as "picking_type_id" FROM "mrp_production" LEFT JOIN "stock_picking_type" as "mrp_production__picking_type_id" ON ("mrp_production"."picking_type_id" = "mrp_production__picking_type_id"."id") WHERE ((("mrp_production"."state" in ('confirmed','planned','progress')) AND (("mrp_production"."state" not in ('done','cancel')) OR "mrp_production"."state" IS NULL)) AND ("mrp_production"."picking_type_id" in (1,2,5,6,389,390,7,8,135,396,397,294,295,300,302,307,309,313,314,318,320,322,327,329,334,340,341,347,348,353,355,360,362,367,369,374,376,381,383))) AND (("mrp_production"."company_id" in (1)) OR "mrp_production"."company_id" IS NULL ) GROUP BY "mrp_production"."picking_type_id","mrp_production__picking_type_id"."sequence","mrp_production__picking_type_id"."id" ORDER BY "mrp_production__picking_type_id"."sequence" ,"mrp_production__picking_type_id"."id"
31 min < 0.1%	9,151 ms	201 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_id"."parent_left" >= $569) AND ("stock_move__location_id"."parent_left" < $570)) OR (("stock_move__location_id"."parent_left" >= $571) AND ("stock_move__location_id"."parent_left" < $572))) OR ("stock_move"."location_id" in ($573)))) AND (((("stock_move__location_dest_id"."parent_left" < $574) OR ("stock_move__location_dest_id"."parent_left" >= $575)) AND (("stock_move__location_dest_id"."parent_left" < $576) OR ("stock_move__location_dest_id"."parent_left" >= $577))) AND (NOT (("stock_move"."location_dest_id" in ($578)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
31 min < 0.1%	2,165 ms	847 odoo
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "picking_type_id_count" , "stock_picking"."picking_type_id" as "picking_type_id" FROM "stock_picking" LEFT JOIN "stock_picking_type" as "stock_picking__picking_type_id" ON ("stock_picking"."picking_type_id" = "stock_picking__picking_type_id"."id") WHERE ((("stock_picking"."state" in ($1,$2,$3)) AND (("stock_picking"."state" not in ($4,$5)) OR "stock_picking"."state" IS NULL)) AND ("stock_picking"."picking_type_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))) AND ("stock_picking"."company_id" IS NULL OR ("stock_picking"."company_id" in ($45))) GROUP BY "stock_picking"."picking_type_id","stock_picking__picking_type_id"."sequence","stock_picking__picking_type_id"."id" ORDER BY "stock_picking__picking_type_id"."sequence" ,"stock_picking__picking_type_id"."id"
30 min < 0.1%	9,090 ms	201 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND (((("stock_move__location_dest_id"."parent_left" >= $569) AND ("stock_move__location_dest_id"."parent_left" < $570)) OR (("stock_move__location_dest_id"."parent_left" >= $571) AND ("stock_move__location_dest_id"."parent_left" < $572))) OR ("stock_move"."location_dest_id" in ($573)))) AND (((("stock_move__location_id"."parent_left" < $574) OR ("stock_move__location_id"."parent_left" >= $575)) AND (("stock_move__location_id"."parent_left" < $576) OR ("stock_move__location_id"."parent_left" >= $577))) AND (NOT (("stock_move"."location_id" in ($578)))))) GROUP BY "stock_move"."product_id" ORDER BY "id"
30 min < 0.1%	8,812 ms	201 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_dest_id","stock_location" as "stock_move__location_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_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,$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))) AND ((((((((((((((("stock_move__location_dest_id"."parent_left" >= $569) AND ("stock_move__location_dest_id"."parent_left" < $570)) OR (("stock_move__location_dest_id"."parent_left" >= $571) AND ("stock_move__location_dest_id"."parent_left" < $572))) OR (("stock_move__location_dest_id"."parent_left" >= $573) AND ("stock_move__location_dest_id"."parent_left" < $574))) OR (("stock_move__location_dest_id"."parent_left" >= $575) AND ("stock_move__location_dest_id"."parent_left" < $576))) OR (("stock_move__location_dest_id"."parent_left" >= $577) AND ("stock_move__location_dest_id"."parent_left" < $578))) OR (("stock_move__location_dest_id"."parent_left" >= $579) AND ("stock_move__location_dest_id"."parent_left" < $580))) OR (("stock_move__location_dest_id"."parent_left" >= $581) AND ("stock_move__location_dest_id"."parent_left" < $582))) OR (("stock_move__location_dest_id"."parent_left" >= $583) AND ("stock_move__location_dest_id"."parent_left" < $584))) OR (("stock_move__location_dest_id"."parent_left" >= $585) AND ("stock_move__location_dest_id"."parent_left" < $586))) OR (("stock_move__location_dest_id"."parent_left" >= $587) AND ("stock_move__location_dest_id"."parent_left" < $588))) OR (("stock_move__location_dest_id"."parent_left" >= $589) AND ("stock_move__location_dest_id"."parent_left" < $590))) OR (("stock_move__location_dest_id"."parent_left" >= $591) AND ("stock_move__location_dest_id"."parent_left" < $592))) OR (("stock_move__location_dest_id"."parent_left" >= $593) AND ("stock_move__location_dest_id"."parent_left" < $594))) OR (("stock_move__location_dest_id"."parent_left" >= $595) AND ("stock_move__location_dest_id"."parent_left" < $596)))) AND ((((((((((((((("stock_move__location_id"."parent_left" < $597) OR ("stock_move__location_id"."parent_left" >= $598)) AND (("stock_move__location_id"."parent_left" < $599) OR ("stock_move__location_id"."parent_left" >= $600))) AND (("stock_move__location_id"."parent_left" < $601) OR ("stock_move__location_id"."parent_left" >= $602))) AND (("stock_move__location_id"."parent_left" < $603) OR ("stock_move__location_id"."parent_left" >= $604))) AND (("stock_move__location_id"."parent_left" < $605) OR ("stock_move__location_id"."parent_left" >= $606))) AND (("stock_move__location_id"."parent_left" < $607) OR ("stock_move__location_id"."parent_left" >= $608))) AND (("stock_move__location_id"."parent_left" < $609) OR ("stock_move__location_id"."parent_left" >= $610))) AND (("stock_move__location_id"."parent_left" < $611) OR ("stock_move__location_id"."parent_left" >= $612))) AND (("stock_move__location_id"."parent_left" < $613) OR ("stock_move__location_id"."parent_left" >= $614))) AND (("stock_move__location_id"."parent_left" < $615) OR ("stock_move__location_id"."parent_left" >= $616))) AND (("stock_move__location_id"."parent_left" < $617) OR ("stock_move__location_id"."parent_left" >= $618))) AND (("stock_move__location_id"."parent_left" < $619) OR ("stock_move__location_id"."parent_left" >= $620))) AND (("stock_move__location_id"."parent_left" < $621) OR ("stock_move__location_id"."parent_left" >= $622))) AND (("stock_move__location_id"."parent_left" < $623) OR ("stock_move__location_id"."parent_left" >= $624)))) GROUP BY "stock_move"."product_id" ORDER BY "id"
29 min < 0.1%	270 ms	6,505 odoo
`SELECT "swk_scrap_ticket".id FROM "swk_scrap_ticket" WHERE ("swk_scrap_ticket"."state" = $1) ORDER BY "swk_scrap_ticket"."id" DESC` Details `CREATE INDEX CONCURRENTLY ON swk_scrap_ticket (state, id)` `Rows: 128097 Row progression: 128097, 42699, 0 Row estimates - state (=): 42699 - id (sort): 1 Existing indexes - id PRIMARY - name - state`
29 min < 0.1%	2,025 ms	847 odoo
SELECT min("mrp_production".id) AS id, count("mrp_production".id) AS "picking_type_id_count" , "mrp_production"."picking_type_id" as "picking_type_id" FROM "mrp_production" LEFT JOIN "stock_picking_type" as "mrp_production__picking_type_id" ON ("mrp_production"."picking_type_id" = "mrp_production__picking_type_id"."id") WHERE ((("mrp_production"."availability" = $1) AND (("mrp_production"."state" not in ($2,$3)) OR "mrp_production"."state" IS NULL)) AND ("mrp_production"."picking_type_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))) AND (("mrp_production"."company_id" in ($43)) OR "mrp_production"."company_id" IS NULL ) GROUP BY "mrp_production"."picking_type_id","mrp_production__picking_type_id"."sequence","mrp_production__picking_type_id"."id" ORDER BY "mrp_production__picking_type_id"."sequence" ,"mrp_production__picking_type_id"."id"
28 min < 0.1%	109 ms	15,246 odoo
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "product_id_count" , sum("stock_move"."product_qty") AS "product_qty" ,"stock_move"."product_id" as "product_id" FROM "stock_location" as "stock_move__location_id","stock_location" as "stock_move__location_dest_id","stock_move" WHERE ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id" AND "stock_move"."location_id"="stock_move__location_id"."id") AND ((((("stock_move"."state" not in ($1,$2,$3)) OR "stock_move"."state" IS NULL) AND ("stock_move"."product_id" in ($4))) AND (((((((((((((("stock_move__location_id"."parent_left" >= $5) AND ("stock_move__location_id"."parent_left" < $6)) OR (("stock_move__location_id"."parent_left" >= $7) AND ("stock_move__location_id"."parent_left" < $8))) OR (("stock_move__location_id"."parent_left" >= $9) AND ("stock_move__location_id"."parent_left" < $10))) OR (("stock_move__location_id"."parent_left" >= $11) AND ("stock_move__location_id"."parent_left" < $12))) OR (("stock_move__location_id"."parent_left" >= $13) AND ("stock_move__location_id"."parent_left" < $14))) OR (("stock_move__location_id"."parent_left" >= $15) AND ("stock_move__location_id"."parent_left" < $16))) OR (("stock_move__location_id"."parent_left" >= $17) AND ("stock_move__location_id"."parent_left" < $18))) OR (("stock_move__location_id"."parent_left" >= $19) AND ("stock_move__location_id"."parent_left" < $20))) OR (("stock_move__location_id"."parent_left" >= $21) AND ("stock_move__location_id"."parent_left" < $22))) OR (("stock_move__location_id"."parent_left" >= $23) AND ("stock_move__location_id"."parent_left" < $24))) OR (("stock_move__location_id"."parent_left" >= $25) AND ("stock_move__location_id"."parent_left" < $26))) OR (("stock_move__location_id"."parent_left" >= $27) AND ("stock_move__location_id"."parent_left" < $28))) OR (("stock_move__location_id"."parent_left" >= $29) AND ("stock_move__location_id"."parent_left" < $30)))) AND (((((((((((((("stock_move__location_dest_id"."parent_left" < $31) OR ("stock_move__location_dest_id"."parent_left" >= $32)) AND (("stock_move__location_dest_id"."parent_left" < $33) OR ("stock_move__location_dest_id"."parent_left" >= $34))) AND (("stock_move__location_dest_id"."parent_left" < $35) OR ("stock_move__location_dest_id"."parent_left" >= $36))) AND (("stock_move__location_dest_id"."parent_left" < $37) OR ("stock_move__location_dest_id"."parent_left" >= $38))) AND (("stock_move__location_dest_id"."parent_left" < $39) OR ("stock_move__location_dest_id"."parent_left" >= $40))) AND (("stock_move__location_dest_id"."parent_left" < $41) OR ("stock_move__location_dest_id"."parent_left" >= $42))) AND (("stock_move__location_dest_id"."parent_left" < $43) OR ("stock_move__location_dest_id"."parent_left" >= $44))) AND (("stock_move__location_dest_id"."parent_left" < $45) OR ("stock_move__location_dest_id"."parent_left" >= $46))) AND (("stock_move__location_dest_id"."parent_left" < $47) OR ("stock_move__location_dest_id"."parent_left" >= $48))) AND (("stock_move__location_dest_id"."parent_left" < $49) OR ("stock_move__location_dest_id"."parent_left" >= $50))) AND (("stock_move__location_dest_id"."parent_left" < $51) OR ("stock_move__location_dest_id"."parent_left" >= $52))) AND (("stock_move__location_dest_id"."parent_left" < $53) OR ("stock_move__location_dest_id"."parent_left" >= $54))) AND (("stock_move__location_dest_id"."parent_left" < $55) OR ("stock_move__location_dest_id"."parent_left" >= $56)))) AND ("stock_move"."location_dest_id"="stock_move__location_dest_id"."id") AND (("stock_move"."company_id" IS NULL OR ("stock_move"."company_id" in ($57))) OR "stock_move__location_dest_id"."company_id" IS NULL ) GROUP BY "stock_move"."product_id" ORDER BY "id"

Long Running Queries

Suggested Indexes

Slow Queries