Queries

Total Time	Average Time	Calls
636 min 42%	221 ms	172,310 odoo
`SELECT "production_schedule_line".id FROM "production_schedule_line" WHERE ("production_schedule_line"."production_ticket_id" IS NULL AND ("production_schedule_line"."to_skip" IS NULL or "production_schedule_line"."to_skip" = false )) ORDER BY "production_schedule_line"."id"`
520 min 34%	13 ms	2,320,227 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE (("queue_job"."name" = $1) AND ("queue_job"."state" = $2)) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC` Details `CREATE INDEX CONCURRENTLY ON queue_job (name)` `Rows: 6780031 Row progression: 6780031, 565003, 188334 Row estimates - name (=): 565003 - state (=): 2260010 - date_created (sort): 19 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) - state - uuid`
220 min 14%	11 ms	1,195,056 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE (("queue_job"."name" = $1) AND ("queue_job"."state" = $2)) ORDER BY "queue_job"."date_created" ASC limit $3` Details `CREATE INDEX CONCURRENTLY ON queue_job (name)` `Rows: 6780031 Row progression: 6780031, 565003, 188334 Row estimates - name (=): 565003 - state (=): 2260010 - date_created (sort): 19 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) - state - uuid`
36 min 2%	2 ms	1,159,628 odoo
`SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."move_id" in ($1)) ORDER BY "stock_scrap"."id"` Details `CREATE INDEX CONCURRENTLY ON stock_scrap (move_id)` `Rows: 8095 Row progression: 8095, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY`
12 min 0.8%	20 ms	35,742 odoo
`SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."state" = $1) ORDER BY "material_requisition"."create_date" DESC` Details `CREATE INDEX CONCURRENTLY ON material_requisition (state, create_date)` `Rows: 46131 Row progression: 46131, 11533, 0 Row estimates - state (=): 11533 - create_date (sort): 1 Existing indexes - id PRIMARY`
10 min 0.7%	0 ms	19,068,176 odoo
`DISCARD ALL`
9 min 0.6%	15 ms	35,545 odoo
`INSERT INTO "mail_message" ("id", "parent_id", "message_type", "message_id", "reply_to", "res_id", "author_id", "email_from", "model", "no_auto_thread", "body", "subject", "date", "subtype_id", "record_name", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, (now() at time zone $18), (now() at time zone $19)) RETURNING id`
7 min 0.5%	0 ms	924,651 odoo
`SELECT "stock_move_line".id FROM "stock_move_line" WHERE ("stock_move_line"."picking_id" in ($1))` `Covered by index on (picking_id) Rows: 5142585 Row progression: 5142585, 3 Row estimates - picking_id (=): 3 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
5 min 0.4%	103 ms	3,147 odoo
`SELECT "swk_production_receipt".id FROM "swk_production_receipt" WHERE ("swk_production_receipt"."production_ticket" in ($1)) ORDER BY "swk_production_receipt"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_production_receipt (production_ticket)` `Rows: 301172 Row progression: 301172, 1 Row estimates - production_ticket (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - name`
4 min 0.3%	0 ms	9,176,141 odoo
`SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling`
4 min 0.3%	0 ms	14,595,532 odoo
`SELECT id FROM "product_category" WHERE id IN ($1)`
4 min 0.2%	17 ms	12,532 odoo
`INSERT INTO "mail_message" ("id", "res_id", "reply_to", "date", "parent_id", "message_type", "email_from", "model", "body", "record_name", "subtype_id", "subject", "author_id", "message_id", "no_auto_thread", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, (now() at time zone $18), (now() at time zone $19)) RETURNING id`
3 min 0.2%	0 ms	978,096 odoo
`SELECT substr(p.res_id, $1)::integer, p.value_float FROM ir_property p WHERE p.fields_id=$2 AND (p.company_id=$3 OR p.company_id IS NULL) AND (p.res_id IN ($4) OR p.res_id IS NULL) ORDER BY p.company_id NULLS FIRST`
3 min 0.2%	4 ms	50,691 odoo
`SELECT "queue_job".id FROM "queue_job" WHERE ("queue_job"."uuid" = $1) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC limit $2` `Covered by index on (uuid) Rows: 6780031 Row progression: 6780031, 1 Row estimates - uuid (=): 1 - date_created (sort): 19 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) - state - uuid`
3 min 0.2%	605 ms	292 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"
3 min 0.2%	2 ms	70,620 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: 8095 Row progression: 8095, 1 Row estimates - scrap_ticket_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY`
2 min 0.1%	0 ms	19,884,228 odoo
`BEGIN ISOLATION LEVEL REPEATABLE READ`
2 min 0.1%	0 ms	3,461,550 odoo
`SELECT "stock_picking"."id" as "id" FROM "stock_picking" WHERE "stock_picking".id IN ($1)` `Covered by index on (id) Rows: 3024004 Row progression: 3024004, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - backorder_id - company_id - date - group_id, picking_type_id, location_dest_id - name, company_id UNIQUE - origin - priority - sale_id - scheduled_date - state, picking_type_id, scheduled_date`
2 min 0.1%	0 ms	541,644 odoo
`SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_right" >= $1) ORDER BY "stock_location"."parent_left"`
2 min 0.1%	0 ms	541,644 odoo
`SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_left" <= $1) ORDER BY "stock_location"."parent_left"`
1 min < 0.1%	0 ms	1,535,580 odoo
SELECT "product_product"."id" as "id","product_product"."message_last_post" as "message_last_post","product_product"."volume" as "volume","product_product"."production_cost_food" as "production_cost_food","product_product"."production_cost_nonfood" as "production_cost_nonfood","product_product"."create_date" as "create_date","product_product"."write_date" as "write_date","product_product"."write_uid" as "write_uid","product_product"."active" as "active","product_product"."default_code" as "default_code","product_product"."product_tmpl_id" as "product_tmpl_id","product_product"."product_id" as "product_id","product_product"."create_uid" as "create_uid","product_product"."activity_date_deadline" as "activity_date_deadline","product_product"."barcode" as "barcode","product_product"."weight" as "weight" FROM "product_product" WHERE "product_product".id IN ($1) `Covered by index on (id) Rows: 1540718 Row progression: 1540718, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id - product_tmpl_id, default_code`
1 min < 0.1%	0 ms	758,555 odoo
`SELECT "stock_move_line"."id" as "id","stock_move_line"."picking_id" as "picking_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1)` `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
1 min < 0.1%	0 ms	2,836,465 odoo
`SELECT "stock_move_line".id FROM "stock_move_line" WHERE ("stock_move_line"."move_id" in ($1)) ORDER BY "stock_move_line"."id"` `Covered by index on (move_id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
1 min < 0.1%	0 ms	3,506,108 odoo
`SELECT "swk_sub_purchase".id FROM "swk_sub_purchase" WHERE ("swk_sub_purchase"."move_id" in ($1)) ORDER BY "swk_sub_purchase"."id"` `Covered by index on (move_id) Rows: 155530 Row progression: 155530, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - name - state`
1 min < 0.1%	0 ms	1,507,467 odoo
SELECT "res_partner"."id" as "id","res_partner"."phone" as "phone","res_partner"."supplier" as "supplier","res_partner"."activity_date_deadline" as "activity_date_deadline","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."lang" as "lang","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."street2" as "street2","res_partner"."cancelled_order_count" as "cancelled_order_count","res_partner"."customer_platform" as "customer_platform","res_partner"."company_id" as "company_id","res_partner"."picking_warn" as "picking_warn","res_partner"."employee" as "employee","res_partner"."user_id" as "user_id","res_partner"."vat" as "vat","res_partner"."tz" as "tz","res_partner"."mobile" as "mobile","res_partner"."message_bounce" as "message_bounce","res_partner"."debit_limit" as "debit_limit","res_partner"."name" as "name","res_partner"."zip" as "zip","res_partner"."signup_token" as "signup_token","res_partner"."purchase_warn" as "purchase_warn","res_partner"."write_date" as "write_date","res_partner"."team_id" as "team_id","res_partner"."create_uid" as "create_uid","res_partner"."message_last_post" as "message_last_post","res_partner"."is_company" as "is_company","res_partner"."website" as "website","res_partner"."opt_out" as "opt_out","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."comment" as "comment","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."first_order_date" as "first_order_date","res_partner"."create_date" as "create_date","res_partner"."display_name" as "display_name","res_partner"."city" as "city","res_partner"."signup_type" as "signup_type","res_partner"."write_uid" as "write_uid","res_partner"."title" as "title","res_partner"."date" as "date","res_partner"."color" as "color","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."barcode" as "barcode","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."credit_limit" as "credit_limit","res_partner"."signup_expiration" as "signup_expiration","res_partner"."state_id" as "state_id","res_partner"."total_orders_group" as "total_orders_group","res_partner"."email" as "email","res_partner"."active" as "active","res_partner"."partner_share" as "partner_share","res_partner"."parent_id" as "parent_id","res_partner"."commercial_partner_country_id" as "commercial_partner_country_id","res_partner"."function" as "function","res_partner"."company_name" as "company_name","res_partner"."type" as "type","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."invoice_warn" as "invoice_warn","res_partner"."swk_order_count" as "swk_order_count","res_partner"."country_id" as "country_id","res_partner"."ref" as "ref","res_partner"."average_basket_size" as "average_basket_size","res_partner"."customer" as "customer","res_partner"."suborder_count" as "suborder_count","res_partner"."sale_warn" as "sale_warn","res_partner"."last_order_date" as "last_order_date","res_partner"."street" as "street","res_partner"."dh_id" as "dh_id","res_partner"."industry_id" as "industry_id" FROM "res_partner" WHERE "res_partner".id IN ($1) `Covered by index on (id) Rows: 724 Row progression: 724, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - commercial_partner_id - company_id - date - dh_id, active - display_name - name - parent_id - ref - total_orders_group`
1 min < 0.1%	128 ms	533 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)))) AND ((("stock_move__location_dest_id"."parent_left" < $9) OR ("stock_move__location_dest_id"."parent_left" >= $10)) AND (("stock_move__location_dest_id"."parent_left" < $11) OR ("stock_move__location_dest_id"."parent_left" >= $12)))) 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 ($13))) OR "stock_move__location_dest_id"."company_id" IS NULL ) GROUP BY "stock_move"."product_id" ORDER BY "id"
1 min < 0.1%	0 ms	480,921 odoo
`SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id=f.id JOIN res_users u ON u.id=$1 WHERE f.model=$2 AND (d.user_id IS NULL OR d.user_id=u.id) AND (d.company_id IS NULL OR d.company_id=u.company_id) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id`
1 min < 0.1%	0 ms	963,810 odoo
SELECT "product_template"."id" as "id","product_template"."name" as "name","product_template"."color" as "color","product_template"."purchase_method" as "purchase_method","product_template"."non_food" as "non_food","product_template"."description_pickingout" as "description_pickingout","product_template"."sale_line_warn_msg" as "sale_line_warn_msg","product_template"."priority" as "priority","product_template"."print_as" as "print_as","product_template"."station_id" as "station_id","product_template"."delivery_minimum_stock" as "delivery_minimum_stock","product_template"."delivery_frequency" as "delivery_frequency","product_template"."procurement_target_days" as "procurement_target_days","product_template"."swk_inventory_loss" as "swk_inventory_loss","product_template"."sequence" as "sequence","product_template"."allow_negative_stock" as "allow_negative_stock","product_template"."purchase_line_warn" as "purchase_line_warn","product_template"."delivery_quantity" as "delivery_quantity","product_template"."description_pickingin" as "description_pickingin","product_template"."list_price" as "list_price","product_template"."expense_policy" as "expense_policy","product_template"."production_time" as "production_time","product_template"."zomato_new" as "zomato_new","product_template"."looker_subcategory_id" as "looker_subcategory_id","product_template"."pr_printer_id" as "pr_printer_id","product_template"."looker_category_id" as "looker_category_id","product_template"."uom_id" as "uom_id","product_template"."delivery_day" as "delivery_day","product_template"."rental" as "rental","product_template"."type" as "type","product_template"."life_time" as "life_time","product_template"."purchase_line_warn_msg" as "purchase_line_warn_msg","product_template"."zomato_spicy" as "zomato_spicy","product_template"."invoice_policy" as "invoice_policy","product_template"."production_instructions" as "production_instructions","product_template"."arabic_description" as "arabic_description","product_template"."swk_accounting_tag" as "swk_accounting_tag","product_template"."bom_cost" as "bom_cost","product_template"."write_date" as "write_date","product_template"."write_uid" as "write_uid","product_template"."calculated_selling" as "calculated_selling","product_template"."create_uid" as "create_uid","product_template"."uom_po_id" as "uom_po_id","product_template"."sale_ok" as "sale_ok","product_template"."description" as "description","product_template"."sale_delay" as "sale_delay","product_template"."produce_delay" as "produce_delay","product_template"."use_time" as "use_time","product_template"."categ_id" as "categ_id","product_template"."is_printed" as "is_printed","product_template"."production_minimum_stock" as "production_minimum_stock","product_template"."production_weekday" as "production_weekday","product_template"."price_as_attribute" as "price_as_attribute","product_template"."zomato_vegan" as "zomato_vegan","product_template"."purchase_ok" as "purchase_ok","product_template"."removal_time" as "removal_time","product_template"."responsible_id" as "responsible_id","product_template"."tracking" as "tracking","product_template"."company_id" as "company_id","product_template"."description_purchase" as "description_purchase","product_template"."service_type" as "service_type","product_template"."print_bold" as "print_bold","product_template"."production_quantity" as "production_quantity","product_template"."automatic_variant_create" as "automatic_variant_create","product_template"."swk_scrap_account" as "swk_scrap_account","product_template"."transferable_storage_temperature" as "transferable_storage_temperature","product_template"."zomato_tag" as "zomato_tag","product_template"."target_stock_override" as "target_stock_override","product_template"."classification" as "classification","product_template"."create_date" as "create_date","product_template"."uom_id_temp" as "uom_id_temp","product_template"."active" as "active","product_template"."alert_time" as "alert_time","product_template"."description_sale" as "description_sale","product_template"."description_picking" as "description_picking","product_template"."sale_line_warn" as "sale_line_warn","product_template"."container_price" as "container_price","product_template"."image_url" as "image_url","product_template"."has_non_empty_bom" as "has_non_empty_bom","product_template"."daily_consumption_override" as "daily_consumption_override","product_template"."transferable_type" as "transferable_type","product_template"."activity_date_deadline" as "activity_date_deadline","product_template"."message_last_post" as "message_last_post","product_template"."swk_inventory_gain" as "swk_inventory_gain","product_template"."pt_printer_id" as "pt_printer_id" FROM "product_template" WHERE "product_template".id IN ($1) `Covered by index on (id) Rows: 30259 Row progression: 30259, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - name`
1 min < 0.1%	10 ms	5,265 odoo
`SELECT "production_dashboard_entry".id FROM "production_dashboard_entry" WHERE ("production_dashboard_entry"."pt_id" in ($1)) ORDER BY "production_dashboard_entry"."id"` Details `CREATE INDEX CONCURRENTLY ON production_dashboard_entry (pt_id)` `Rows: 45055 Row progression: 45055, 1 Row estimates - pt_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	2,193,550 odoo
`SELECT DISTINCT "purchase_line_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
1 min < 0.1%	0 ms	2,036,258 odoo
`SELECT DISTINCT "picking_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
1 min < 0.1%	0 ms	1,584,010 odoo
SELECT "stock_move_line"."id" as "id","stock_move_line"."product_id" as "product_id","stock_move_line"."product_uom_qty" as "product_uom_qty","stock_move_line"."lot_produced_id" as "lot_produced_id","stock_move_line"."location_id" as "location_id","stock_move_line"."ordered_qty" as "ordered_qty","stock_move_line"."lot_name" as "lot_name","stock_move_line"."product_uom_id" as "product_uom_id","stock_move_line"."create_date" as "create_date","stock_move_line"."location_dest_id" as "location_dest_id","stock_move_line"."done_wo" as "done_wo","stock_move_line"."qty_done" as "qty_done","stock_move_line"."date" as "date","stock_move_line"."write_date" as "write_date","stock_move_line"."package_id" as "package_id","stock_move_line"."create_uid" as "create_uid","stock_move_line"."picking_id" as "picking_id","stock_move_line"."workorder_id" as "workorder_id","stock_move_line"."state" as "state","stock_move_line"."done_move" as "done_move","stock_move_line"."lot_id" as "lot_id","stock_move_line"."write_uid" as "write_uid","stock_move_line"."location_processed" as "location_processed","stock_move_line"."production_id" as "production_id","stock_move_line"."move_id" as "move_id","stock_move_line"."reference" as "reference","stock_move_line"."lot_produced_qty" as "lot_produced_qty","stock_move_line"."product_qty" as "product_qty","stock_move_line"."result_package_id" as "result_package_id","stock_move_line"."move_line_processed" as "move_line_processed","stock_move_line"."owner_id" as "owner_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1) `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
1 min < 0.1%	0 ms	1,744,786 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"."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"`
1 min < 0.1%	0 ms	822,295 odoo
SELECT "stock_production_lot"."id" as "id","stock_production_lot"."write_uid" as "write_uid","stock_production_lot"."create_date" as "create_date","stock_production_lot"."removal_date" as "removal_date","stock_production_lot"."alert_date" as "alert_date","stock_production_lot"."automatic_scrap" as "automatic_scrap","stock_production_lot"."automatic_scrap_cancelled" as "automatic_scrap_cancelled","stock_production_lot"."message_last_post" as "message_last_post","stock_production_lot"."ref" as "ref","stock_production_lot"."product_uom_id" as "product_uom_id","stock_production_lot"."create_uid" as "create_uid","stock_production_lot"."expiration_alert" as "expiration_alert","stock_production_lot"."use_date" as "use_date","stock_production_lot"."write_date" as "write_date","stock_production_lot"."product_id" as "product_id","stock_production_lot"."name" as "name","stock_production_lot"."before_expiration_alert" as "before_expiration_alert","stock_production_lot"."life_date" as "life_date","stock_production_lot"."use_next_on_work_order_id" as "use_next_on_work_order_id" FROM "stock_production_lot" WHERE "stock_production_lot".id IN ($1) `Covered by index on (id) Rows: 497929 Row progression: 497929, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name, product_id UNIQUE`
1 min < 0.1%	0 ms	1,322,771 odoo
SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."login" as "login","res_users"."printing_action" as "printing_action","res_users"."printer_tray_id" as "printer_tray_id","res_users"."target_sales_won" as "target_sales_won","res_users"."write_date" as "write_date","res_users"."company_id" as "company_id","res_users"."target_sales_done" as "target_sales_done","res_users"."active" as "active","res_users"."alias_id" as "alias_id","res_users"."target_sales_invoiced" as "target_sales_invoiced","res_users"."notification_type" as "notification_type","res_users"."sale_team_id" as "sale_team_id","res_users"."share" as "share","res_users"."password" as "password","res_users"."partner_id" as "partner_id","res_users"."create_uid" as "create_uid","res_users"."printing_printer_id" as "printing_printer_id","res_users"."password_crypt" as "password_crypt","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."create_date" as "create_date" FROM "res_users" WHERE "res_users".id IN ($1)
1 min < 0.1%	70 ms	533 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))) AND ((("stock_move__location_dest_id"."parent_left" >= $5) AND ("stock_move__location_dest_id"."parent_left" < $6)) OR (("stock_move__location_dest_id"."parent_left" >= $7) AND ("stock_move__location_dest_id"."parent_left" < $8)))) AND ((("stock_move__location_id"."parent_left" < $9) OR ("stock_move__location_id"."parent_left" >= $10)) AND (("stock_move__location_id"."parent_left" < $11) OR ("stock_move__location_id"."parent_left" >= $12)))) 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 ($13))) OR "stock_move__location_dest_id"."company_id" IS NULL ) GROUP BY "stock_move"."product_id" ORDER BY "id"
1 min < 0.1%	0 ms	1,417,412 odoo
`SELECT DISTINCT "move_id" FROM "stock_move_line" WHERE "id" IN ($1)` `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
1 min < 0.1%	0 ms	473,319 odoo
`select nextval($1)`
0 min < 0.1%	0 ms	1,237,787 odoo
`SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."id" in ($1)) ORDER BY "stock_picking"."id"` `Covered by index on (id) Rows: 3024004 Row progression: 3024004, 1 Row estimates - id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - backorder_id - company_id - date - group_id, picking_type_id, location_dest_id - name, company_id UNIQUE - origin - priority - sale_id - scheduled_date - state, picking_type_id, scheduled_date`
0 min < 0.1%	0 ms	972,882 odoo
`SELECT DISTINCT "raw_material_production_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	2 ms	15,359 odoo
`UPDATE "stock_move_line" SET "state"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	0 ms	913,426 odoo
`SELECT DISTINCT "inventory_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	44,563 odoo
`INSERT INTO "res_users_log" ("id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, (now() at time zone $4), (now() at time zone $5)) RETURNING id`
0 min < 0.1%	4 ms	5,288 odoo
`SELECT "mrp_bom".id FROM "mrp_bom" LEFT JOIN "product_product" as "mrp_bom__product_id" ON ("mrp_bom"."product_id" = "mrp_bom__product_id"."id") WHERE ((("mrp_bom"."active" = $1) AND (("mrp_bom"."product_id" = $2) OR ("mrp_bom"."product_id" IS NULL AND ("mrp_bom"."product_tmpl_id" = $3)))) AND ("mrp_bom"."company_id" = $4)) ORDER BY "mrp_bom"."sequence" ,"mrp_bom__product_id"."default_code" ,"mrp_bom__product_id"."id" limit $5`
0 min < 0.1%	0 ms	41,096 odoo
`SELECT "stock_move_line".id FROM "stock_move_line" WHERE ("stock_move_line"."move_id" in ($1))` `Covered by index on (move_id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - move_id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	0 ms	879,138 odoo
`SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."id" in ($1)) ORDER BY "stock_picking"."priority" DESC,"stock_picking"."date" ASC,"stock_picking"."id" DESC` `Covered by index on (id) Rows: 3024004 Row progression: 3024004, 1 Row estimates - id (=): 1 - priority (sort): 3024004 Existing indexes - id PRIMARY - backorder_id - company_id - date - group_id, picking_type_id, location_dest_id - name, company_id UNIQUE - origin - priority - sale_id - scheduled_date - state, picking_type_id, scheduled_date`
0 min < 0.1%	1 ms	30,606 odoo
`SELECT COUNT(*) FROM ir_module_module WHERE state LIKE $1`
0 min < 0.1%	3 ms	6,437 odoo
`UPDATE "stock_move" SET "state"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	685,654 odoo
`SELECT DISTINCT "production_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	1 ms	11,990 odoo
`UPDATE "stock_move_line" SET "product_qty"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	1 ms	20,490 odoo
`UPDATE "queue_job" SET "identity_key"=$1,"date_enqueued"=$2,"date_started"=$3,"company_id"=$4,"exc_info"=$5,"eta"=$6,"max_retries"=$7,"state"=$8,"result"=$9,"priority"=$10,"user_id"=$11,"retry"=$12,"date_done"=$13 WHERE id IN ($14)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	117,097 odoo
`SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = $1) AND ("ir_model_data"."res_id" in ($2))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name"` Details `CREATE INDEX CONCURRENTLY ON ir_model_data (res_id)` `Rows: 5993507 Row progression: 5993507, 1 Row estimates - res_id (=): 1 - model (=): 107027 - module (sort): 54486 - model (sort): 107027 - name (sort): 7 Existing indexes - id PRIMARY - model, res_id - module, name UNIQUE`
0 min < 0.1%	0 ms	44,027 odoo
`SELECT "ir_model".id FROM "ir_model" WHERE ("ir_model"."model"::text like $1) ORDER BY COALESCE("ir_model"."is_mail_thread", $2) DESC,"ir_model"."name" ASC`
0 min < 0.1%	1 ms	22,806 odoo
`UPDATE "stock_move" SET "is_done"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	9,732,749 odoo
`COMMIT`
0 min < 0.1%	0 ms	35,310 odoo
`UPDATE "swk_scrap_ticket" SET "currency_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 18051 Row progression: 18051, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
0 min < 0.1%	1 ms	13,140 odoo
`INSERT INTO "mail_followers" ("id", "partner_id", "res_model", "res_id") VALUES(nextval($1), $2, $3, $4) RETURNING id`
0 min < 0.1%	0 ms	247,277 odoo
SELECT "res_partner"."id" as "id","res_partner"."barcode" as "barcode","res_partner"."customer" as "customer","res_partner"."partner_share" as "partner_share","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."credit_limit" as "credit_limit","res_partner"."total_orders_group" as "total_orders_group","res_partner"."cancelled_order_count" as "cancelled_order_count","res_partner"."email" as "email","res_partner"."create_date" as "create_date","res_partner"."write_uid" as "write_uid","res_partner"."company_id" as "company_id","res_partner"."activity_date_deadline" as "activity_date_deadline","res_partner"."message_bounce" as "message_bounce","res_partner"."function" as "function","res_partner"."supplier" as "supplier","res_partner"."user_id" as "user_id","res_partner"."company_name" as "company_name","res_partner"."team_id" as "team_id","res_partner"."picking_warn" as "picking_warn","res_partner"."average_basket_size" as "average_basket_size","res_partner"."ref" as "ref","res_partner"."last_order_date" as "last_order_date","res_partner"."create_uid" as "create_uid","res_partner"."opt_out" as "opt_out","res_partner"."tz" as "tz","res_partner"."employee" as "employee","res_partner"."street" as "street","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."lang" as "lang","res_partner"."sale_warn" as "sale_warn","res_partner"."customer_platform" as "customer_platform","res_partner"."first_order_date" as "first_order_date","res_partner"."phone" as "phone","res_partner"."dh_id" as "dh_id","res_partner"."write_date" as "write_date","res_partner"."title" as "title","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."is_company" as "is_company","res_partner"."signup_expiration" as "signup_expiration","res_partner"."street2" as "street2","res_partner"."signup_token" as "signup_token","res_partner"."debit_limit" as "debit_limit","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."state_id" as "state_id","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."vat" as "vat","res_partner"."mobile" as "mobile","res_partner"."date" as "date","res_partner"."color" as "color","res_partner"."type" as "type","res_partner"."parent_id" as "parent_id","res_partner"."name" as "name","res_partner"."zip" as "zip","res_partner"."commercial_partner_country_id" as "commercial_partner_country_id","res_partner"."signup_type" as "signup_type","res_partner"."invoice_warn" as "invoice_warn","res_partner"."purchase_warn" as "purchase_warn","res_partner"."country_id" as "country_id","res_partner"."website" as "website","res_partner"."suborder_count" as "suborder_count","res_partner"."active" as "active","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."comment" as "comment","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."display_name" as "display_name","res_partner"."city" as "city","res_partner"."message_last_post" as "message_last_post","res_partner"."industry_id" as "industry_id","res_partner"."swk_order_count" as "swk_order_count" FROM "res_partner" WHERE "res_partner".id IN ($1) `Covered by index on (id) Rows: 724 Row progression: 724, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - commercial_partner_id - company_id - date - dh_id, active - display_name - name - parent_id - ref - total_orders_group`
0 min < 0.1%	0 ms	35,310 odoo
`UPDATE "swk_scrap_ticket" SET "scrap_quantity"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 18051 Row progression: 18051, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
0 min < 0.1%	1 ms	9,661 odoo
`UPDATE "queue_job" SET "channel"=$1 WHERE id IN ($2)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	414,966 odoo
SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."active" as "active","res_users"."action_id" as "action_id","res_users"."notification_type" as "notification_type","res_users"."target_sales_invoiced" as "target_sales_invoiced","res_users"."write_uid" as "write_uid","res_users"."password" as "password","res_users"."printer_tray_id" as "printer_tray_id","res_users"."password_crypt" as "password_crypt","res_users"."alias_id" as "alias_id","res_users"."share" as "share","res_users"."company_id" as "company_id","res_users"."sale_team_id" as "sale_team_id","res_users"."create_date" as "create_date","res_users"."login" as "login","res_users"."printing_action" as "printing_action","res_users"."target_sales_won" as "target_sales_won","res_users"."write_date" as "write_date","res_users"."create_uid" as "create_uid","res_users"."partner_id" as "partner_id","res_users"."target_sales_done" as "target_sales_done","res_users"."printing_printer_id" as "printing_printer_id" FROM "res_users" WHERE "res_users".id IN ($1)
0 min < 0.1%	0 ms	236,194 odoo
SELECT "product_template"."id" as "id","product_template"."target_stock_override" as "target_stock_override","product_template"."uom_id" as "uom_id","product_template"."sale_ok" as "sale_ok","product_template"."use_time" as "use_time","product_template"."purchase_line_warn" as "purchase_line_warn","product_template"."list_price" as "list_price","product_template"."description_pickingin" as "description_pickingin","product_template"."expense_policy" as "expense_policy","product_template"."production_time" as "production_time","product_template"."delivery_quantity" as "delivery_quantity","product_template"."delivery_day" as "delivery_day","product_template"."write_uid" as "write_uid","product_template"."write_date" as "write_date","product_template"."create_uid" as "create_uid","product_template"."transferable_type" as "transferable_type","product_template"."type" as "type","product_template"."purchase_ok" as "purchase_ok","product_template"."uom_po_id" as "uom_po_id","product_template"."removal_time" as "removal_time","product_template"."invoice_policy" as "invoice_policy","product_template"."purchase_line_warn_msg" as "purchase_line_warn_msg","product_template"."categ_id" as "categ_id","product_template"."is_printed" as "is_printed","product_template"."production_instructions" as "production_instructions","product_template"."uom_id_temp" as "uom_id_temp","product_template"."arabic_description" as "arabic_description","product_template"."looker_category_id" as "looker_category_id","product_template"."create_date" as "create_date","product_template"."classification" as "classification","product_template"."swk_scrap_account" as "swk_scrap_account","product_template"."print_bold" as "print_bold","product_template"."description" as "description","product_template"."active" as "active","product_template"."sale_delay" as "sale_delay","product_template"."produce_delay" as "produce_delay","product_template"."company_id" as "company_id","product_template"."responsible_id" as "responsible_id","product_template"."alert_time" as "alert_time","product_template"."production_minimum_stock" as "production_minimum_stock","product_template"."production_weekday" as "production_weekday","product_template"."has_non_empty_bom" as "has_non_empty_bom","product_template"."price_as_attribute" as "price_as_attribute","product_template"."looker_subcategory_id" as "looker_subcategory_id","product_template"."calculated_selling" as "calculated_selling","product_template"."message_last_post" as "message_last_post","product_template"."procurement_target_days" as "procurement_target_days","product_template"."swk_inventory_gain" as "swk_inventory_gain","product_template"."activity_date_deadline" as "activity_date_deadline","product_template"."description_purchase" as "description_purchase","product_template"."color" as "color","product_template"."tracking" as "tracking","product_template"."service_type" as "service_type","product_template"."non_food" as "non_food","product_template"."production_quantity" as "production_quantity","product_template"."station_id" as "station_id","product_template"."automatic_variant_create" as "automatic_variant_create","product_template"."zomato_tag" as "zomato_tag","product_template"."transferable_storage_temperature" as "transferable_storage_temperature","product_template"."bom_cost" as "bom_cost","product_template"."pt_printer_id" as "pt_printer_id","product_template"."zomato_spicy" as "zomato_spicy","product_template"."sequence" as "sequence","product_template"."allow_negative_stock" as "allow_negative_stock","product_template"."description_picking" as "description_picking","product_template"."description_sale" as "description_sale","product_template"."sale_line_warn" as "sale_line_warn","product_template"."container_price" as "container_price","product_template"."purchase_method" as "purchase_method","product_template"."image_url" as "image_url","product_template"."delivery_minimum_stock" as "delivery_minimum_stock","product_template"."swk_inventory_loss" as "swk_inventory_loss","product_template"."zomato_new" as "zomato_new","product_template"."name" as "name","product_template"."daily_consumption_override" as "daily_consumption_override","product_template"."pr_printer_id" as "pr_printer_id","product_template"."zomato_vegan" as "zomato_vegan","product_template"."rental" as "rental","product_template"."life_time" as "life_time","product_template"."description_pickingout" as "description_pickingout","product_template"."sale_line_warn_msg" as "sale_line_warn_msg","product_template"."priority" as "priority","product_template"."print_as" as "print_as","product_template"."delivery_frequency" as "delivery_frequency","product_template"."swk_accounting_tag" as "swk_accounting_tag" FROM "product_template" WHERE "product_template".id IN ($1) `Covered by index on (id) Rows: 30259 Row progression: 30259, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - name`
0 min < 0.1%	0 ms	82,131 odoo
`SELECT "ir_sequence".id FROM "ir_sequence" LEFT JOIN "res_company" as "ir_sequence__company_id" ON ("ir_sequence"."company_id" = "ir_sequence__company_id"."id") WHERE ((("ir_sequence"."active" = $1) AND ("ir_sequence"."code" = $2)) AND (("ir_sequence"."company_id" in ($3)) OR "ir_sequence"."company_id" IS NULL)) ORDER BY "ir_sequence__company_id"."sequence" ,"ir_sequence__company_id"."name"`
0 min < 0.1%	0 ms	1,046,753 odoo
`SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."id" in ($1)) ORDER BY "mrp_production"."id"` `Covered by index on (id) Rows: 359903 Row progression: 359903, 1 Row estimates - id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - date_finished - date_planned_finished - date_planned_start - date_start - name, company_id UNIQUE`
0 min < 0.1%	0 ms	229,935 odoo
SELECT "stock_warehouse".id FROM "stock_warehouse" WHERE ((("stock_warehouse"."active" = $1) AND ("stock_warehouse"."view_location_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22))) AND ("stock_warehouse"."view_location_id" in ($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))) ORDER BY "stock_warehouse"."name" limit $363
0 min < 0.1%	1 ms	9,662 odoo
`UPDATE "queue_job" SET "job_function_id"=$1,"channel_method_name"=$2 WHERE id IN ($3)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	35,310 odoo
`UPDATE "swk_scrap_ticket" SET "value"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 18051 Row progression: 18051, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
0 min < 0.1%	0 ms	370,128 odoo
`SELECT "material_requisition"."id" as "id","material_requisition"."name" as "name" FROM "material_requisition" WHERE "material_requisition".id IN ($1)` `Covered by index on (id) Rows: 46131 Row progression: 46131, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	21,896 odoo
`UPDATE "stock_quant" SET "commissary_reserved"=$1,"commissary_quantity"= $2,"write_uid"=$3,"write_date"=(now() at time zone $4) WHERE id IN ($5)` `Covered by index on (id) Rows: 917150 Row progression: 917150, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - location_id, lot_id, quantity - lot_id - product_id, location_id, lot_id`
0 min < 0.1%	0 ms	167,824 odoo
SELECT "stock_warehouse".id FROM "stock_warehouse" WHERE ((("stock_warehouse"."active" = $1) AND ("stock_warehouse"."view_location_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$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))) AND ("stock_warehouse"."view_location_id" in ($353,$354,$355,$356,$357,$358,$359,$360,$361,$362))) ORDER BY "stock_warehouse"."name" limit $363
0 min < 0.1%	0 ms	23,261 odoo
`UPDATE "mail_message" SET "write_uid"=$1,"write_date"=(now() at time zone $2) WHERE id IN ($3)` `Covered by index on (id) Rows: 22124542 Row progression: 22124542, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - author_id - mail_activity_type_id - message_id - model, res_id - parent_id - res_id - subtype_id`
0 min < 0.1%	1 ms	12,215 odoo
`UPDATE "stock_move" SET "picking_currency_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	10,151,232 odoo
`ROLLBACK`
0 min < 0.1%	1 ms	12,749 odoo
`UPDATE "stock_move" SET "product_qty"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	324,386 odoo
`SELECT DISTINCT "origin_returned_move_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	1,739,354 odoo
`SELECT "purchase_order".id FROM "purchase_order" WHERE $1 ORDER BY "purchase_order"."id"`
0 min < 0.1%	1 ms	9,662 odoo
`UPDATE "queue_job" SET "activity_date_deadline"=$1 WHERE id IN ($2)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	1,234,713 odoo
`SELECT "purchase_order_line".id FROM "purchase_order_line" LEFT JOIN "purchase_order" as "purchase_order_line__order_id" ON ("purchase_order_line"."order_id" = "purchase_order_line__order_id"."id") WHERE ("purchase_order_line"."id" in ($1)) ORDER BY "purchase_order_line__order_id"."date_order" DESC,"purchase_order_line__order_id"."id" DESC,"purchase_order_line"."sequence" ,"purchase_order_line"."id"`
0 min < 0.1%	0 ms	324,386 odoo
`SELECT DISTINCT "workorder_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	1 ms	12,203 odoo
`UPDATE "stock_move" SET "scrapped"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	1 ms	12,215 odoo
`UPDATE "stock_move" SET "reference"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` Covered by index on (id) Rows: 5222519 Row progression: 5222519, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - created_purchase_line_id - date - date_expected - inventory_id, location_dest_id - location_dest_id, created_purchase_line_id - location_dest_id, state, product_id, date - location_id - name - origin_returned_move_id - picking_id, location_dest_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id, location_dest_id - purchase_line_id - raw_material_production_id, location_dest_id - sale_line_id, location_dest_id - scrapped - state
0 min < 0.1%	0 ms	15,359 odoo
`UPDATE "stock_move_line" SET "done_move"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	1 ms	5,347 odoo
`INSERT INTO "queue_job" ("id", "method_name", "uuid", "exc_info", "date_enqueued", "date_created", "date_started", "kwargs", "model_name", "state", "priority", "name", "record_ids", "date_done", "identity_key", "company_id", "args", "max_retries", "result", "eta", "user_id", "failed_once", "retry") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23) RETURNING id`
0 min < 0.1%	1 ms	5,097 odoo
`UPDATE "queue_job" SET "state"=$1 WHERE id IN ($2)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	31,428 odoo
`SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) WHERE m.model=$1 AND r.active AND r.perm_read AND (r.id IN (SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id=gu.gid) WHERE gu.uid=$2) OR r.global)`
0 min < 0.1%	0 ms	48,348 odoo
`SELECT "mail_message".id FROM "mail_message" WHERE ((("mail_message"."res_id" = $1) AND ("mail_message"."model" = $2)) AND ("mail_message"."message_type" = $3)) ORDER BY "mail_message"."id" ASC limit $4` `Covered by index on (res_id) Rows: 22124542 Row progression: 22124542, 45 Row estimates - res_id (=): 45 - model (=): 2212380 - message_type (=): 11062271 - id (sort): 1 Existing indexes - id PRIMARY - author_id - mail_activity_type_id - message_id - model, res_id - parent_id - res_id - subtype_id`
0 min < 0.1%	0 ms	80,090 odoo
`SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN ($1)` `Covered by index on (id) Rows: 5993507 Row progression: 5993507, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - model, res_id - module, name UNIQUE`
0 min < 0.1%	1 ms	9,662 odoo
`UPDATE "queue_job" SET "func_string"=$1 WHERE id IN ($2)` `Covered by index on (id) Rows: 6780031 Row progression: 6780031, 1 Row estimates - id (=): 1 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) - state - uuid`
0 min < 0.1%	0 ms	707,106 odoo
`SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."id" in ($1)) ORDER BY "mrp_production"."date_planned_start" ASC,"mrp_production"."id"` `Covered by index on (id) Rows: 359903 Row progression: 359903, 1 Row estimates - id (=): 1 - date_planned_start (sort): 1 - id (sort): 1 Existing indexes - id PRIMARY - date_finished - date_planned_finished - date_planned_start - date_start - name, company_id UNIQUE`
0 min < 0.1%	0 ms	59,703 odoo
SELECT "product_product"."id" as "id","product_product"."product_tmpl_id" as "product_tmpl_id","product_product"."barcode" as "barcode","product_product"."message_last_post" as "message_last_post","product_product"."create_uid" as "create_uid","product_product"."write_date" as "write_date","product_product"."production_cost_food" as "production_cost_food","product_product"."product_id" as "product_id","product_product"."activity_date_deadline" as "activity_date_deadline","product_product"."create_date" as "create_date","product_product"."weight" as "weight","product_product"."production_cost_nonfood" as "production_cost_nonfood","product_product"."default_code" as "default_code","product_product"."active" as "active","product_product"."write_uid" as "write_uid","product_product"."volume" as "volume" FROM "product_product" WHERE "product_product".id IN ($1, $2) `Covered by index on (id) Rows: 1540718 Row progression: 1540718, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id - product_tmpl_id, default_code`
0 min < 0.1%	1 ms	10,691 odoo
`INSERT INTO "mail_followers" ("id", "res_model", "res_id", "partner_id") VALUES(nextval($1), $2, $3, $4) RETURNING id`
0 min < 0.1%	0 ms	1,109,742 odoo
`SELECT "purchase_order_line".id FROM "purchase_order_line" WHERE ("purchase_order_line"."id" in ($1)) ORDER BY "purchase_order_line"."id"` `Covered by index on (id) Rows: 158131 Row progression: 158131, 1 Row estimates - id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - date_planned - order_id`
0 min < 0.1%	0 ms	97,146 odoo
SELECT "res_currency"."id" as "id","res_currency"."currency_subunit_label" as "currency_subunit_label","res_currency"."rounding" as "rounding","res_currency"."create_uid" as "create_uid","res_currency"."active" as "active","res_currency"."create_date" as "create_date","res_currency"."currency_unit_label" as "currency_unit_label","res_currency"."position" as "position","res_currency"."symbol" as "symbol","res_currency"."write_date" as "write_date","res_currency"."write_uid" as "write_uid","res_currency"."name" as "name" FROM "res_currency" WHERE "res_currency".id IN ($1)
0 min < 0.1%	8 ms	687 odoo
SELECT min("stock_quant".id) AS id, count("stock_quant".id) AS "product_id_count" , sum("stock_quant"."quantity") AS "quantity" ,"stock_quant"."product_id" as "product_id" FROM "stock_location" as "stock_quant__location_id","stock_quant" WHERE ("stock_quant"."location_id"="stock_quant__location_id"."id") AND (("stock_quant"."product_id" in ($1)) AND ((("stock_quant__location_id"."parent_left" >= $2) AND ("stock_quant__location_id"."parent_left" < $3)) OR (("stock_quant__location_id"."parent_left" >= $4) AND ("stock_quant__location_id"."parent_left" < $5)))) AND ("stock_quant"."company_id" IS NULL OR ("stock_quant"."company_id" in ($6))) GROUP BY "stock_quant"."product_id" ORDER BY "id"
0 min < 0.1%	0 ms	180,533 odoo
SELECT "stock_move_line"."id" as "id","stock_move_line"."package_id" as "package_id","stock_move_line"."create_uid" as "create_uid","stock_move_line"."picking_id" as "picking_id","stock_move_line"."workorder_id" as "workorder_id","stock_move_line"."create_date" as "create_date","stock_move_line"."lot_id" as "lot_id","stock_move_line"."write_uid" as "write_uid","stock_move_line"."lot_produced_qty" as "lot_produced_qty","stock_move_line"."move_id" as "move_id","stock_move_line"."production_id" as "production_id","stock_move_line"."done_wo" as "done_wo","stock_move_line"."date" as "date","stock_move_line"."write_date" as "write_date","stock_move_line"."result_package_id" as "result_package_id","stock_move_line"."product_id" as "product_id","stock_move_line"."lot_produced_id" as "lot_produced_id","stock_move_line"."product_uom_qty" as "product_uom_qty","stock_move_line"."owner_id" as "owner_id","stock_move_line"."location_processed" as "location_processed","stock_move_line"."ordered_qty" as "ordered_qty","stock_move_line"."product_uom_id" as "product_uom_id","stock_move_line"."lot_name" as "lot_name","stock_move_line"."location_id" as "location_id","stock_move_line"."move_line_processed" as "move_line_processed","stock_move_line"."qty_done" as "qty_done","stock_move_line"."location_dest_id" as "location_dest_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1) `Covered by index on (id) Rows: 5142585 Row progression: 5142585, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	0 ms	913,430 odoo
`SELECT "stock_inventory".id FROM "stock_inventory" WHERE ("stock_inventory"."id" in ($1)) ORDER BY "stock_inventory"."date" DESC,"stock_inventory"."id" DESC` `Covered by index on (id) Rows: 63248 Row progression: 63248, 1 Row estimates - id (=): 1 - date (sort): 1 Existing indexes - id PRIMARY - company_id - state`
0 min < 0.1%	0 ms	158,570 odoo
`SELECT "product_category".id FROM "product_category" WHERE ("product_category"."parent_id" in ($1)) ORDER BY "product_category"."parent_left"`
0 min < 0.1%	2 ms	2,279 odoo
INSERT INTO "stock_move_line" ("id", "product_id", "ordered_qty", "location_id", "done_wo", "package_id", "product_uom_qty", "qty_done", "done_move", "picking_id", "move_id", "date", "location_processed", "move_line_processed", "lot_id", "location_dest_id", "owner_id", "product_uom_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, (now() at time zone $21), (now() at time zone $22)) RETURNING id
0 min < 0.1%	0 ms	75,365 odoo
SELECT "ir_sequence"."id" as "id","ir_sequence"."number_next" as "number_next","ir_sequence"."padding" as "padding","ir_sequence"."active" as "active","ir_sequence"."create_uid" as "create_uid","ir_sequence"."prefix" as "prefix","ir_sequence"."number_increment" as "number_increment","ir_sequence"."auto_reset" as "auto_reset","ir_sequence"."code" as "code","ir_sequence"."implementation" as "implementation","ir_sequence"."write_date" as "write_date","ir_sequence"."company_id" as "company_id","ir_sequence"."last_prefix" as "last_prefix","ir_sequence"."write_uid" as "write_uid","ir_sequence"."use_date_range" as "use_date_range","ir_sequence"."name" as "name","ir_sequence"."create_date" as "create_date","ir_sequence"."suffix" as "suffix" FROM "ir_sequence" WHERE "ir_sequence".id IN ($1)
0 min < 0.1%	0 ms	906,412 odoo
`SELECT "stock_inventory_line".id FROM "stock_inventory_line" WHERE $1 ORDER BY "stock_inventory_line"."id"`