| 4084429 |
00:09:15
|
active
|
|
odoo
SELECT "sale_order".id FROM "sale_order" WHERE (("sale_order"."warehouse_id" = 59) AND ("sale_order"."fo_state" = 'packed')) ORDER BY "sale_order"."date_order" ASC limit 1
|
| 4084553 |
00:04:20
|
idle in transaction
|
|
odoo
SELECT *
FROM ir_cron
WHERE numbercall != 0
AND active
AND nextcall <= (now() at time zone 'UTC')
AND id=8
FOR UPDATE NOWAIT
|
| 4084424 |
00:04:19
|
idle in transaction
|
|
odoo
SELECT "ir_model"."id" as "id","ir_model"."info" as "info","ir_model"."create_uid" as "create_uid","ir_model"."create_date" as "create_date","ir_model"."write_date" as "write_date","ir_model"."transient" as "transient","ir_model"."model" as "model","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."state" as "state","ir_model"."name" as "name","ir_model"."write_uid" as "write_uid" FROM "ir_model" WHERE "ir_model".id IN (286)
|
| 4084674 |
00:03:18
|
idle in transaction
|
|
odoo
SELECT *
FROM ir_cron
WHERE numbercall != 0
AND active
AND nextcall <= (now() at time zone 'UTC')
AND id=15
FOR UPDATE NOWAIT
|
| 4084552 |
00:03:18
|
idle in transaction
|
|
odoo
SELECT "ir_model"."id" as "id","ir_model"."info" as "info","ir_model"."state" as "state","ir_model"."create_uid" as "create_uid","ir_model"."create_date" as "create_date","ir_model"."transient" as "transient","ir_model"."model" as "model","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."write_date" as "write_date","ir_model"."write_uid" as "write_uid","ir_model"."name" as "name" FROM "ir_model" WHERE "ir_model".id IN (286)
|
| 4084496 |
00:03:10
|
active
|
|
odoo
SELECT "sale_order".id FROM "sale_order" WHERE (("sale_order"."warehouse_id" = 59) AND ("sale_order"."fo_state" = 'packed')) ORDER BY "sale_order"."date_order" ASC limit 1
|
| 4084731 |
00:01:16
|
idle in transaction
|
|
odoo
SELECT *
FROM ir_cron
WHERE numbercall != 0
AND active
AND nextcall <= (now() at time zone 'UTC')
AND id=7
FOR UPDATE NOWAIT
|
| 4084673 |
00:01:08
|
active
|
|
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 (1040084,1004893,1004894,1029147,1006438,889236,889239,889242,889278,889310,889350,889369,1006704,889555,889570,1007671,889638,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,98146
|
| 4084710 |
00:01:03
|
active
|
|
odoo
SELECT "mail_message".id FROM "mail_message" WHERE (("mail_message"."model" = 'queue.job') AND ("mail_message"."res_id" in (138083973,138083969,138083905,138083870,138083868,138083869,138083866,138083867,138083865,138083864,138083863,138083859,138083858,138083857,138083856,138083854,138083855,138083850,138083849,138083842,138083841,138083773,138083771,138083772,138083770,138083769,138083765,138083764,138083212,138083104,138083101,138083103,138083102,138083096,138083095,138083051,138082943,138082944,138082941,138082942,138082939,138082940,138082932,138082933,138082908,138082846,138082842,138082819,138082822,138082820,138082821,138082818,138082812,138082813,138082746,138082743,138082740,138082720,138082722,138082721,138082719,138082718,138082717,138082716,138082715,138082707,138082706,138082705,138082704,138082702,138082703,138082697,138082696,138082695,138082694,138082646,138082641,138082638,138082637,138082636,138082635,138082634,138082633,138082632,138082631,138082630,138082629,138082628,138082627,1380826
|
| 4084809 |
00:01:03
|
active
|
|
odoo
SELECT "mail_message".id FROM "mail_message" WHERE (("mail_message"."model" = 'queue.job') AND ("mail_message"."res_id" in (138083973,138083969,138083905,138083870,138083868,138083869,138083866,138083867,138083865,138083864,138083863,138083859,138083858,138083857,138083856,138083854,138083855,138083850,138083849,138083842,138083841,138083773,138083771,138083772,138083770,138083769,138083765,138083764,138083212,138083104,138083101,138083103,138083102,138083096,138083095,138083051,138082943,138082944,138082941,138082942,138082939,138082940,138082932,138082933,138082908,138082846,138082842,138082819,138082822,138082820,138082821,138082818,138082812,138082813,138082746,138082743,138082740,138082720,138082722,138082721,138082719,138082718,138082717,138082716,138082715,138082707,138082706,138082705,138082704,138082702,138082703,138082697,138082696,138082695,138082694,138082646,138082641,138082638,138082637,138082636,138082635,138082634,138082633,138082632,138082631,138082630,138082629,138082628,138082627,1380826
|
| 4084813 |
53.9 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079828))) 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"
|
| 4084422 |
53.9 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079828))) 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"
|
| 4084814 |
53.9 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079828))) 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"
|
| 4084493 |
3.7 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079827))) 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"
|
| 4084844 |
3.7 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079827))) 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"
|
| 4084845 |
3.7 s
|
active
|
|
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" = false ) AND ("stock_move"."raw_material_production_id" in (11079827))) 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"
|
| 4084791 |
-0.0 s
|
idle in transaction
|
|
odoo
SELECT "res_partner"."id" as "id","res_partner"."display_name" as "display_name","res_partner"."user_id" as "user_id","res_partner"."active" as "active","res_partner"."city" as "city","res_partner"."partner_share" as "partner_share","res_partner"."signup_type" as "signup_type","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."barcode" as "barcode","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."customer_platform" as "customer_platform","res_partner"."team_id" as "team_id","res_partner"."create_uid" as "create_uid","res_partner"."customer" as "customer","res_partner"."lang" as "lang","res_partner"."email" as "email","res_partner"."activity_date_deadline" as "activity_date_deadline","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."picking_warn" as "picking_warn","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."suborder_count" as "subo
|
| 4084712 |
-0.1 s
|
active
|
|
odoo
UPDATE "sale_order" SET "fiscal_position_id"=NULL,"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (4076550)
|