PgHero

Queries

Total Time Average Time Calls
8,593 min 39% 51,067 ms 10,096 odoo 
REFRESH MATERIALIZED VIEW mt5_orders_view
7,505 min 34% 44,601 ms 10,096 odoo 
REFRESH MATERIALIZED VIEW mt5_deals_view
3,072 min 14% 0 ms 418,169,954 mt5backup_main 
UPDATE "mt5_users" SET "Timestamp"=$1,"Group"=$2,"CertSerialNumber"=$3,"Rights"=$4,"Registration"=$5,"LastAccess"=$6,"LastPassChange"=$7,"FirstName"=$8,"LastName"=$9,"MiddleName"=$10,"Company"=$11,"Account"=$12,"Country"=$13,"Language"=$14,"ClientID"=$15,"City"=$16,"State"=$17,"ZipCode"=$18,"Address"=$19,"Phone"=$20,"Email"=$21,"ID"=$22,"Status"=$23,"Comment"=$24,"Color"=$25,"PhonePassword"=$26,"Leverage"=$27,"Agent"=$28,"TradeAccounts"=$29,"LimitPositions"=$30,"LimitOrders"=$31,"LeadCampaign"=$32,"LeadSource"=$33,"TimestampTrade"=$34,"Balance"=$35,"Credit"=$36,"InterestRate"=$37,"CommissionDaily"=$38,"CommissionMonthly"=$39,"BalancePrevDay"=$40,"BalancePrevMonth"=$41,"EquityPrevDay"=$42,"EquityPrevMonth"=$43,"Name"=$44,"MQID"=$45,"LastIP"=$46,"ApiData"=$47 WHERE ("Login"=$48)
503 min 2% 43 ms 695,639 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_trading_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id)
458 min 2% 42 ms 647,312 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_funding_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id)
313 min 1% 45 ms 421,786 afxprodapiusr 
select news_id, content_id, publish_date, category, subject, body, status 
            from fx_market_news where news_id > $1 and push_flg = $2 order by news_id desc
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
310 min 1% 20 ms 926,115 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_id" = $2)) ORDER BY "survey_user_input_line"."id"   limit $3
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
251 min 1% 21 ms 710,013 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
237 min 1% 34 ms 421,786 afxprodapiusr 
select MAX(news_id) from fx_market_news
107 min 0.5% 0 ms 421,923,298 mt5backup_main 
UPDATE "mt5_positions" SET "PriceCurrent"=$1,"Profit"=$2 WHERE ("Position_ID"=$3)
103 min 0.5% 41 ms 149,806 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_finish_doc_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id, remind_finish_doc_flg)
88 min 0.4% 78 ms 67,206 afxprodapiusr 
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
58 min 0.3% 0 ms 236,097,207 mt5backup_main 
UPDATE "mt5_prices" SET "Digits"=$1,"BidDir"=$2,"AskDir"=$3,"LastDir"=$4,"Time"=$5,"BidLast"=$6,"BidHigh"=$7,"BidLow"=$8,"AskLast"=$9,"AskHigh"=$10,"AskLow"=$11,"LastLast"=$12,"LastHigh"=$13,"LastLow"=$14 WHERE ("Price_ID"=$15)
56 min 0.3% 46 ms 73,118 afxprodapiusr 
select content_id, category, subject, body
                        from fx_market_news
                        where news_id < $1 and content_id = $2
                        and category = $3 and subject = $4
                        and body = $5 and push_flg = $6
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (content_id)
28 min 0.1% 0 ms 68,406,341 mt5backup_main 
UPDATE "mt5_accounts" SET "CurrencyDigits"=$1,"Balance"=$2,"Credit"=$3,"Margin"=$4,"MarginFree"=$5,"MarginLevel"=$6,"MarginLeverage"=$7,"MarginInitial"=$8,"MarginMaintenance"=$9,"Profit"=$10,"Storage"=$11,"Floating"=$12,"Equity"=$13,"Assets"=$14,"Liabilities"=$15,"BlockedCommission"=$16,"BlockedProfit"=$17 WHERE ("Login"=$18)
15 min < 0.1% 3 ms 262,689 pspprodbakusr 
select fxrespartn0_.id as id1_2_, fxrespartn0_.active as active2_2_, fxrespartn0_.buten_cd as buten_cd3_2_, fxrespartn0_.buten_id as buten_id4_2_, fxrespartn0_.device_id as device_i5_2_, fxrespartn0_.insider_ticker_code as insider_6_2_, fxrespartn0_.login_audit as login_au7_2_, fxrespartn0_.login_email as login_em8_2_, fxrespartn0_.login_id as login_id9_2_, fxrespartn0_.partner_id as partner10_2_, fxrespartn0_.passkey_required_at as passkey11_2_, fxrespartn0_.passkey_skip_at as passkey12_2_, fxrespartn0_.password as passwor13_2_, fxrespartn0_.pwd_change_flg as pwd_cha14_2_, fxrespartn0_.pwd_expired as pwd_exp15_2_, fxrespartn0_.skip_passkey_flg as skip_pa16_2_, fxrespartn0_.st_account_category as st_acco17_2_, fxrespartn0_.trading_pin as trading18_2_, fxrespartn0_.trading_pin_expired as trading19_2_, fxrespartn0_.user_passkey as user_pa20_2_, fxrespartn0_.withdraw_pin as withdra21_2_, fxrespartn0_.withdraw_pin_expired as withdra22_2_ from fx_res_partner fxrespartn0_ where fxrespartn0_.skip_passkey_flg=$1
14 min < 0.1% 21 ms 40,966 odoo 
SELECT "fx_swap_history".id FROM "fx_swap_history" WHERE ((("fx_swap_history"."symbol_id" = $1)  AND  ("fx_swap_history"."group_id" = $2))  AND  ("fx_swap_history"."effect_date" = $3)) AND ("fx_swap_history"."company_id" in ($4)) ORDER BY "fx_swap_history"."create_date" DESC  limit $5
Details
CREATE INDEX CONCURRENTLY ON fx_swap_history (effect_date, symbol_id)
12 min < 0.1% 0 ms 1,640,166 afxprodbakusr 
insert into fx_report_partner (account_type, create_date, file_name, file_path, file_type, partner_trading_id, read_flg, report_cd, report_date, report_title, report_type, company_id, partner_id, trading_account_id, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
RETURNING *
7 min < 0.1% 1 ms 420,493 mt5backup_main 
SELECT "column_name"::varchar,"data_type"::varchar,"numeric_precision"::int4,"datetime_precision"::int4,"character_maximum_length"::int4,"is_nullable"::bool FROM information_schema.columns WHERE table_schema=current_schema() and table_name=$1
7 min < 0.1% 0 ms 1,694,151 afxprodbakusr 
insert into fx_report_funding_summary (account_type, base_currency_cd, create_date, eod_balance, eod_equity, eod_real_balance, eod_real_equity, prev_balance, prev_real_balance, report_date, company_id, total_com, total_deposit, total_pending_withdraw, total_realized_profit, total_swap, total_unrealized_profit, total_used_margin, total_withdraw, trading_account_id, trading_account_name, type, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23)
RETURNING *
6 min < 0.1% 0 ms 294,990,849 mt5backup_main 
BEGIN
5 min < 0.1% 0 ms 16,455,289 odoo 
DISCARD ALL
4 min < 0.1% 0 ms 40,089,531 odoo 
insert into fx_mt5_auditlog_2026 (log_time, ip, log_level, log_type, log_category, message, create_uid, create_date, write_uid, write_date) values ($1, $2, $3, $4, $5, $6, $7, NOW(), $8, NOW())
4 min < 0.1% 0 ms 294,990,849 mt5backup_main 
COMMIT
4 min < 0.1% 1 ms 327,409 odoo 
SELECT CAST("Symbol_ID" AS INTEGER), "Symbol" 
                   FROM   mt5_symbols
                   WHERE "Path" SIMILAR TO $1
3 min < 0.1% 2 ms 104,960 odoo 
SELECT "st_exchange_calendar".id FROM "st_exchange_calendar" WHERE (("st_exchange_calendar"."national_holiday_flg" IS NULL or "st_exchange_calendar"."national_holiday_flg" = $1 )  AND  ("st_exchange_calendar"."holiday_flg" IS NULL or "st_exchange_calendar"."holiday_flg" = $2 )) ORDER BY "st_exchange_calendar"."id"
3 min < 0.1% 0 ms 4,186,663 odoo 
SELECT MAX(CASE WHEN perm_read THEN $1 ELSE $2 END)
		                              FROM ir_model_access a
		                              JOIN ir_model m ON (m.id = a.model_id)
		                              JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
		                             WHERE m.model = $3
		                               AND gu.uid = $4
		                               AND a.active IS TRUE
2 min < 0.1% 2 ms 76,640 odoo 
SELECT "fx_res_partner".id FROM "fx_res_partner" WHERE (("fx_res_partner"."active" = $1)  AND  ("fx_res_partner"."partner_id" in ($2))) ORDER BY "fx_res_partner"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner (partner_id)
2 min < 0.1% 0 ms 1,889,171 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)
2 min < 0.1% 0 ms 1,959,453 odoo 
INSERT INTO "auditlog_log_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "field_id", "log_id", "new_value", "new_value_text", "old_value", "old_value_text") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11) RETURNING id
2 min < 0.1% 0 ms 710,013 odoo 
SELECT "survey_question".id FROM "survey_question" WHERE ("survey_question"."question_cd" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)) ORDER BY "survey_question"."sequence" ,"survey_question"."id"
2 min < 0.1% 0 ms 905,508 odoo 
SELECT "survey_question".id FROM "survey_question" WHERE ("survey_question"."question_cd" = $1) ORDER BY "survey_question"."sequence" ,"survey_question"."id"   limit $2
2 min < 0.1% 0 ms 421,786 afxprodapiusr 
SELECT res_partner.type AS res_partner_type, res_partner.id AS res_partner_id, res_partner.create_uid AS res_partner_create_uid, res_partner.create_date AS res_partner_create_date, res_partner.write_uid AS res_partner_write_uid, res_partner.write_date AS res_partner_write_date, res_partner.name AS res_partner_name, res_partner.fx_name1 AS res_partner_fx_name1, res_partner.fx_dob AS res_partner_fx_dob, res_partner.zip AS res_partner_zip, res_partner.street AS res_partner_street, res_partner.street2 AS res_partner_street2, res_partner.fx_street3 AS res_partner_fx_street3, res_partner.city AS res_partner_city, res_partner.company_id AS res_partner_company_id, res_partner.parent_id AS res_partner_parent_id, res_partner.country_id AS res_partner_country_id, res_partner.active AS res_partner_active, res_partner.is_company AS res_partner_is_company, res_partner.ose_examination_state AS res_partner_ose_examination_state, res_partner.stage_id AS res_partner_stage_id 
FROM res_partner 
WHERE res_partner.ose_examination_state = $1 AND res_partner.active = $2 AND res_partner.stage_id = $3 AND res_partner.company_id = $4 AND res_partner.type = $5
Details
CREATE INDEX CONCURRENTLY ON res_partner (stage_id, ose_examination_state)
2 min < 0.1% 1 ms 73,130 afxprodapiusr 
insert into fx_market_news (
            news_id, content_id, publish_date, category, subject, body, status, write_date, create_date, push_flg
            )
            values ($1, $2, $3, $4, $5, $6, $7, now(), now(), $8)
2 min < 0.1% 0 ms 7,042,597 mt5backup_main 
UPDATE "mt5_orders" SET "PriceCurrent"=$1 WHERE ("Order"=$2)
2 min < 0.1% 0 ms 226,377 odoo 
SELECT "st_ticker".id FROM "st_ticker" WHERE "st_ticker"."ticker_code" IS NULL  ORDER BY "st_ticker"."ticker_code" ASC  limit $1
2 min < 0.1% 1 ms 131,733 odoo 
INSERT INTO "mail_message" ("id", "create_uid", "create_date", "write_uid", "write_date", "add_sign", "author_id", "body", "date", "email_from", "message_id", "message_type", "model", "no_auto_thread", "record_name", "reply_to", "res_id", "subject", "subtype_id", "website_published") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) RETURNING id
2 min < 0.1% 0 ms 16,795,566 odoo 
BEGIN ISOLATION LEVEL REPEATABLE READ
1 min < 0.1% 0 ms 1,092,921 odoo 
INSERT INTO "fx_news_trace" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "agree_flg", "news_id", "partner_id", "read_flg") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10) RETURNING id
1 min < 0.1% 1 ms 85,280 pspprodbakusr 
select fxrespartn0_.id as id1_2_, fxrespartn0_.active as active2_2_, fxrespartn0_.buten_cd as buten_cd3_2_, fxrespartn0_.buten_id as buten_id4_2_, fxrespartn0_.device_id as device_i5_2_, fxrespartn0_.insider_ticker_code as insider_6_2_, fxrespartn0_.login_audit as login_au7_2_, fxrespartn0_.login_email as login_em8_2_, fxrespartn0_.login_id as login_id9_2_, fxrespartn0_.partner_id as partner10_2_, fxrespartn0_.passkey_required_at as passkey11_2_, fxrespartn0_.passkey_skip_at as passkey12_2_, fxrespartn0_.password as passwor13_2_, fxrespartn0_.pwd_change_flg as pwd_cha14_2_, fxrespartn0_.pwd_expired as pwd_exp15_2_, fxrespartn0_.skip_passkey_flg as skip_pa16_2_, fxrespartn0_.st_account_category as st_acco17_2_, fxrespartn0_.trading_pin as trading18_2_, fxrespartn0_.trading_pin_expired as trading19_2_, fxrespartn0_.user_passkey as user_pa20_2_, fxrespartn0_.withdraw_pin as withdra21_2_, fxrespartn0_.withdraw_pin_expired as withdra22_2_ from fx_res_partner fxrespartn0_ where fxrespartn0_.login_id=$1 limit $2
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner (login_id)
1 min < 0.1% 318 ms 267 afxprodapiusr 
UPDATE "fx_news_trace" SET "read_flg" = $1 WHERE ("fx_news_trace"."active" = $2 AND "fx_news_trace"."news_id" = $3 AND "fx_news_trace"."partner_id" = $4)
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
1 min < 0.1% 0 ms 5,521,384 odoo 
SELECT base_registry_signaling.last_value,
                                  base_cache_signaling.last_value
                           FROM base_registry_signaling, base_cache_signaling
1 min < 0.1% 11 ms 7,029 odoo 
SELECT "mail_mail".id FROM "mail_mail" WHERE (("mail_mail"."state" = $1)  AND  (("mail_mail"."scheduled_date" < $2)  OR  "mail_mail"."scheduled_date" IS NULL )) ORDER BY "mail_mail"."id" DESC  limit $3
1 min < 0.1% 0 ms 1,645,203 afxprodbakusr 
insert into fx_report_company (account_type, category, create_date, file_name, file_path, file_path_csv, file_type, report_cd, report_date, report_title, report_type, company_id, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
RETURNING *
1 min < 0.1% 0 ms 2,521,013 mt5backup_main 
INSERT INTO "mt5_deals" ("Deal","Timestamp","ExternalID","Login","Dealer","Order","Action","Entry","Reason","Digits","DigitsCurrency","ContractSize","Time","TimeMsc","Symbol","Price","VolumeExt","Profit","Storage","Commission","Fee","RateProfit","RateMargin","ExpertID","PositionID","PartyID","Comment","ProfitRaw","PricePosition","PriceSL","PriceTP","VolumeClosedExt","TickValue","TickSize","Flags","Value","Gateway","PriceGateway","VolumeGatewayExt","ActionGateway","ModifyFlags","MarketBid","MarketAsk","MarketLast","Volume","VolumeClosed","ApiData") VALUES ($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)
1 min < 0.1% 0 ms 3,722,988 mt5backup_main 
INSERT INTO "mt5_orders_history" ("Order","Timestamp","ExternalID","Login","Dealer","Symbol","Digits","DigitsCurrency","ContractSize","State","Reason","TimeSetup","TimeExpiration","TimeDone","TimeSetupMsc","TimeDoneMsc","ModifyFlags","Type","TypeFill","TypeTime","Flags","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","PartyID","RateMargin","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","VolumeInitial","VolumeCurrent","ApiData") VALUES ($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)
1 min < 0.1% 6 ms 10,327 odoo 
SELECT "fx_res_partner_trading".id FROM "fx_res_partner_trading" WHERE ("fx_res_partner_trading"."platform" = $1) ORDER BY "fx_res_partner_trading"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner_trading (platform, id)
1 min < 0.1% 0 ms 515,907 odoo 
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id")
                    WHERE $5=$6 AND res_groups_users_rel.uid IN ($7) AND res_groups_users_rel.gid = res_groups.id
                     ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name")    OFFSET $8
1 min < 0.1% 2 ms 32,718 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
1 min < 0.1% 0 ms 1,183,581 mt5backup_main 
UPDATE "mt5_positions" SET "ExternalID"=$1,"Login"=$2,"Dealer"=$3,"Timestamp"=$4,"Symbol"=$5,"Action"=$6,"Digits"=$7,"DigitsCurrency"=$8,"Reason"=$9,"ContractSize"=$10,"TimeCreate"=$11,"TimeUpdate"=$12,"TimeCreateMsc"=$13,"TimeUpdateMsc"=$14,"PriceOpen"=$15,"PriceCurrent"=$16,"PriceSL"=$17,"PriceTP"=$18,"VolumeExt"=$19,"Profit"=$20,"Storage"=$21,"RateProfit"=$22,"RateMargin"=$23,"ExpertID"=$24,"ExpertPositionID"=$25,"Comment"=$26,"ActivationMode"=$27,"ActivationTime"=$28,"ActivationPrice"=$29,"ActivationFlags"=$30,"ActionGateway"=$31,"PriceGateway"=$32,"VolumeGatewayExt"=$33,"Volume"=$34,"ApiData"=$35 WHERE ("Position_ID"=$36)
1 min < 0.1% 7 ms 7,035 afxprodapiusr 
SELECT id, news_title, news_content, news_scope, 
            trading_account_id, news_group, push_flg 
            FROM fx_news WHERE push_flg = $1 
            AND publish_date < now() 
            AND company_id = $2
            AND active = $3
Details
CREATE INDEX CONCURRENTLY ON fx_news (publish_date)
1 min < 0.1% 1 ms 33,089 odoo 
SELECT count($1) FROM "res_partner" WHERE (("res_partner"."active" = $2)  AND  (("res_partner"."stage_id" = $3)  AND  ("res_partner"."type" = $4))) AND (("res_partner"."company_id" in ($5))  AND  ((("res_partner"."type" != $6)  OR  "res_partner"."type" IS NULL )  OR  ("res_partner"."type" = $7)))
1 min < 0.1% 0 ms 765,052 mt5backup_main 
FETCH FORWARD 10000 FROM "mt5_batch_reader"
1 min < 0.1% 0 ms 567,945 odoo 
insert into fx_remind_mail ("create_date", email, partner_id, "remind_finish_doc_date", remind_finish_doc_flg, "remind_funding_date", remind_funding_flg, "remind_trading_date", remind_trading_flg, company_id, "write_date") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
RETURNING *
1 min < 0.1% 6 ms 7,030 odoo 
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $1)  AND  ("res_partner"."id" in (WITH temp_irt_current (id, name) as (
                            SELECT ct.id, coalesce(it.value,ct."stage_code")
                            FROM res_partner 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 = $6 order by name
                            ))) ORDER BY "res_partner"."write_date" DESC
1 min < 0.1% 0 ms 83,301 odoo 
SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" as "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = $1)  AND  (("ir_ui_view"."key" = $2)  AND  (("ir_ui_view"."website_id" in ($3)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id"   limit $4
1 min < 0.1% 22 ms 1,749 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_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))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
1 min < 0.1% 0 ms 663,101 odoo 
SELECT MAX(CASE WHEN perm_write THEN $1 ELSE $2 END)
		                              FROM ir_model_access a
		                              JOIN ir_model m ON (m.id = a.model_id)
		                              JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
		                             WHERE m.model = $3
		                               AND gu.uid = $4
		                               AND a.active IS TRUE
1 min < 0.1% 0 ms 71,150 odoo 
SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" as "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = $1)  AND  (("ir_ui_view"."key" = $2)  AND  ($3 OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id"   limit $4
0 min < 0.1% 112 ms 260 afxprodapiusr 
SELECT "fx_news_trace"."id", "fx_news_trace"."news_id", "fx_news_trace"."partner_id", "fx_news_trace"."active", "fx_news_trace"."read_flg", "fx_news_trace"."agree_flg", "fx_news_trace"."create_date", "fx_news_trace"."write_date", "fx_news_trace"."create_uid", "fx_news_trace"."write_uid", "fx_news_trace"."agree_date" FROM "fx_news_trace" WHERE ("fx_news_trace"."active" = $1 AND "fx_news_trace"."news_id" = $2 AND "fx_news_trace"."partner_id" = $3) ORDER BY "fx_news_trace"."id" ASC LIMIT $4
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
0 min < 0.1% 0 ms 739,406 mt5backup_main 
UPDATE "mt5_orders" SET "Timestamp"=$1,"ExternalID"=$2,"Login"=$3,"Dealer"=$4,"Symbol"=$5,"Digits"=$6,"DigitsCurrency"=$7,"ContractSize"=$8,"State"=$9,"Reason"=$10,"TimeSetup"=$11,"TimeExpiration"=$12,"TimeDone"=$13,"TimeSetupMsc"=$14,"TimeDoneMsc"=$15,"ModifyFlags"=$16,"Type"=$17,"TypeFill"=$18,"TypeTime"=$19,"Flags"=$20,"PriceOrder"=$21,"PriceTrigger"=$22,"PriceCurrent"=$23,"PriceSL"=$24,"PriceTP"=$25,"VolumeInitialExt"=$26,"VolumeCurrentExt"=$27,"ExpertID"=$28,"PositionID"=$29,"PositionByID"=$30,"PartyID"=$31,"RateMargin"=$32,"Comment"=$33,"ActivationMode"=$34,"ActivationTime"=$35,"ActivationPrice"=$36,"ActivationFlags"=$37,"VolumeInitial"=$38,"VolumeCurrent"=$39,"ApiData"=$40 WHERE ("Order"=$41)
0 min < 0.1% 0 ms 222,657 mt5backup_main 
INSERT INTO "mt5_positions" ("Position_ID","Position","Timestamp","ExternalID","Login","Dealer","Symbol","Action","Digits","DigitsCurrency","Reason","ContractSize","TimeCreate","TimeUpdate","TimeCreateMsc","TimeUpdateMsc","PriceOpen","PriceCurrent","PriceSL","PriceTP","VolumeExt","Profit","Storage","RateProfit","RateMargin","ExpertID","ExpertPositionID","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","ActionGateway","PriceGateway","VolumeGatewayExt","Volume","ApiData") VALUES ($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)
0 min < 0.1% 0 ms 611,876 odoo 
SELECT website_lang_rel.website_id, website_lang_rel.lang_id FROM website_lang_rel, "res_lang"
                    WHERE ("res_lang"."active" = $1) AND website_lang_rel.website_id IN ($2) AND website_lang_rel.lang_id = res_lang.id
                     ORDER BY COALESCE("res_lang"."active", $3) DESC,"res_lang"."name"    OFFSET $4
0 min < 0.1% 0 ms 1,856,640 afxprodbakusr 
select fxreportac0_."id" as id1_15_0_, fxreportac0_."Assets" as assets2_15_0_, fxreportac0_."Balance" as balance3_15_0_, fxreportac0_."BlockedCommission" as blockedc4_15_0_, fxreportac0_."BlockedProfit" as blockedp5_15_0_, fxreportac0_."Commission" as commissi6_15_0_, fxreportac0_."create_date" as create_d7_15_0_, fxreportac0_."Credit" as credit8_15_0_, fxreportac0_."CurrencyDigits" as currency9_15_0_, fxreportac0_."Equity" as equity10_15_0_, fxreportac0_."Floating" as floatin11_15_0_, fxreportac0_."Liabilities" as liabili12_15_0_, fxreportac0_."Login" as login13_15_0_, fxreportac0_."Margin" as margin14_15_0_, fxreportac0_."MarginFree" as marginf15_15_0_, fxreportac0_."MarginInitial" as margini16_15_0_, fxreportac0_."MarginLevel" as marginl17_15_0_, fxreportac0_."MarginLeverage" as marginl18_15_0_, fxreportac0_."MarginMaintenance" as marginm19_15_0_, fxreportac0_."Profit" as profit20_15_0_, fxreportac0_."report_date" as report_21_15_0_, fxreportac0_."Storage" as storage22_15_0_, fxreportac0_."write_date" as write_d23_15_0_ from fx_report_accounts_daily fxreportac0_ where fxreportac0_."id"=$1
0 min < 0.1% 0 ms 1,877,313 mt5backup_main 
INSERT INTO "mt5_daily" ("Datetime","Login","Timestamp","DatetimePrev","Name","Group","Currency","Company","EMail","Balance","Credit","InterestRate","CommissionDaily","CommissionMonthly","AgentDaily","AgentMonthly","BalancePrevDay","BalancePrevMonth","EquityPrevDay","EquityPrevMonth","Margin","MarginFree","MarginLevel","MarginLeverage","Profit","ProfitStorage","ProfitEquity","ProfitAssets","ProfitLiabilities","DailyProfit","DailyBalance","DailyCredit","DailyCharge","DailyCorrection","DailyBonus","DailyStorage","DailyCommInstant","DailyCommFee","DailyCommRound","DailyAgent","DailyInterest","DailyDividend","DailyTaxes","DailySOCompensation","DailySOCompensationCredit") VALUES ($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)
0 min < 0.1% 0 ms 1,099,048 odoo 
SELECT MAX(CASE WHEN perm_read THEN $1 ELSE $2 END)
		                                  FROM ir_model_access a
		                                  JOIN ir_model m ON (m.id = a.model_id)
		                                 WHERE a.group_id IS NULL
		                                   AND m.model = $3
		                                   AND a.active IS TRUE
0 min < 0.1% 0 ms 1,640,166 afxprodbakusr 
select respartner_.id, respartner_.active as active2_42_, respartner_.additional_info as addition3_42_, respartner_.barcode as barcode4_42_, respartner_.calendar_last_notif_ack as calendar5_42_, respartner_.city as city6_42_, respartner_.color as color7_42_, respartner_.comment as comment8_42_, respartner_.commercial_company_name as commerci9_42_, respartner_.is_company as is_comp10_42_, respartner_.company_name as company11_42_, respartner_.create_date as create_12_42_, respartner_.credit_limit as credit_13_42_, respartner_.customer as custome14_42_, respartner_.date as date15_42_, respartner_.display_name as display16_42_, respartner_.email as email17_42_, respartner_.employee as employe18_42_, respartner_.first_deposit_date as first_d19_42_, respartner_.function as functio20_42_, respartner_.fx_dept as fx_dept21_42_, respartner_.fx_dob as fx_dob22_42_, respartner_.fx_fax as fx_fax23_42_, respartner_.fx_gender as fx_gend24_42_, respartner_.fx_industry_content as fx_indu25_42_, respartner_.fx_name1 as fx_name26_42_, respartner_.fx_occ_company_name as fx_occ_27_42_, respartner_.fx_occ_other as fx_occ_28_42_, respartner_.fx_occ_phone as fx_occ_29_42_, respartner_.fx_street3 as fx_stre30_42_, respartner_.fx_subruler_liveinjp_flg as fx_subr31_42_, respartner_.lang as lang32_42_, respartner_.message_bounce as message33_42_, respartner_.mobile as mobile34_42_, respartner_.name as name35_42_, respartner_.partner_gid as partner36_42_, respartner_.partner_share as partner37_42_, respartner_.password as passwor38_42_, respartner_.phone as phone39_42_, respartner_.ref as ref40_42_, respartner_.commercial_partner_id as commerc58_42_, respartner_.parent_id as parent_59_42_, respartner_.signup_expiration as signup_41_42_, respartner_.signup_token as signup_42_42_, respartner_.signup_type as signup_43_42_, respartner_.stage_code as stage_c44_42_, respartner_.status_applied_date as status_45_42_, respartner_.status_audit_date as status_46_42_, respartner_.status_completed_date as status_47_42_, respartner_.status_docwait_date as status_48_42_, respartner_.street as street49_42_, respartner_.street2 as street50_42_, respartner_.supplier as supplie51_42_, respartner_.type as type52_42_, respartner_.tz as tz53_42_, respartner_.vat as vat54_42_, respartner_.website as website55_42_, respartner_.write_date as write_d56_42_, respartner_.zip as zip57_42_ from res_partner respartner_ where respartner_.id=$1
0 min < 0.1% 0 ms 1,842,010 odoo 
SELECT value FROM ir_translation
                       WHERE lang=$1 AND type in ($2, $3) AND src=$4 AND md5(src)=md5($5)
0 min < 0.1% 0 ms 245,417 odoo 
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = $1) ORDER BY "ir_model_fields"."name"
0 min < 0.1% 0 ms 327,284 odoo 
SELECT MAX(CASE WHEN perm_create THEN $1 ELSE $2 END)
		                              FROM ir_model_access a
		                              JOIN ir_model m ON (m.id = a.model_id)
		                              JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
		                             WHERE m.model = $3
		                               AND gu.uid = $4
		                               AND a.active IS TRUE
0 min < 0.1% 0 ms 1,734,563 odoo 
SELECT count($1) FROM "fx_res_partner_trading" WHERE (("fx_res_partner_trading"."active" = $2)  AND  ("fx_res_partner_trading"."partner_id" = $3))
0 min < 0.1% 0 ms 2,163,419 odoo 
SELECT value FROM ir_translation
                       WHERE lang=$1 AND type in ($2) AND src=$3 AND md5(src)=md5($4) AND name=$5
0 min < 0.1% 0 ms 765,295 odoo 
SELECT * FROM ir_cron
                              WHERE numbercall != $1
                                  AND active AND nextcall <= (now() at time zone $2)
                              ORDER BY priority
0 min < 0.1% 2 ms 10,902 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
0 min < 0.1% 2 ms 9,816 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
0 min < 0.1% 0 ms 292,715 mt5backup_main 
UPDATE "mt5_users" SET "TimestampTrade"=$1,"Balance"=$2,"Credit"=$3,"InterestRate"=$4,"CommissionDaily"=$5,"CommissionMonthly"=$6,"BalancePrevDay"=$7,"BalancePrevMonth"=$8,"EquityPrevDay"=$9,"EquityPrevMonth"=$10 WHERE ("Login"=$11)
0 min < 0.1% 2 ms 6,228 pspprodbakusr 
insert into auditlog_http_session (create_date, create_uid, write_date, write_uid, device_id, display_name, hostname_address, ip_address, module_type, name, partner_id, trading_account_id, user_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
RETURNING *
0 min < 0.1% 0 ms 751,184 odoo 
SELECT "res_users"."id" as "id","res_users"."create_date" as "create_date","res_users"."notification_type" as "notification_type","res_users"."company_id" as "company_id","res_users"."write_date" as "write_date","res_users"."active" as "active","res_users"."sale_team_id" as "sale_team_id","res_users"."signature" as "signature","res_users"."website_id" as "website_id","res_users"."target_sales_won" as "target_sales_won","res_users"."odoobot_state" as "odoobot_state","res_users"."target_sales_done" as "target_sales_done","res_users"."partner_id" as "partner_id","res_users"."create_uid" as "create_uid","res_users"."chatter_position" as "chatter_position","res_users"."alias_id" as "alias_id","res_users"."share" as "share","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."login" as "login" FROM "res_users" WHERE "res_users".id IN ($1)
0 min < 0.1% 0 ms 59,993 odoo 
INSERT INTO "auditlog_log" ("id", "create_uid", "create_date", "write_uid", "write_date", "http_request_id", "http_session_id", "log_type", "method", "model_id", "name", "res_id", "user_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13) RETURNING id
0 min < 0.1% 0 ms 80,485 odoo 
SELECT "res_company"."id" as "id","res_company"."currency_id" as "currency_id","res_company"."social_twitter" as "social_twitter","res_company"."ttl_passkey" as "ttl_passkey","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."partner_gid" as "partner_gid","res_company"."social_facebook" as "social_facebook","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."qr_code" as "qr_code","res_company"."snailmail_color" as "snailmail_color","res_company"."invoice_is_email" as "invoice_is_email","res_company"."social_github" as "social_github","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."invoice_is_print" as "invoice_is_print","res_company"."social_linkedin" as "social_linkedin","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."social_youtube" as "social_youtube","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."paperformat_id" as "paperformat_id","res_company"."period_lock_date" as "period_lock_date","res_company"."social_googleplus" as "social_googleplus","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."currency_next_execution_date" as "currency_next_execution_date","res_company"."social_instagram" as "social_instagram","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."sequence" as "sequence","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."last_currency_sync_date" as "last_currency_sync_date","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."report_header" as "report_header","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."fx_bjp_secret_key" as "fx_bjp_secret_key","res_company"."account_setup_coa_state" as "account_setup_coa_state",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."create_date" as "create_date","res_company"."name" as "name","res_company"."fx_open_time" as "fx_open_time","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."write_date" as "write_date","res_company"."account_no" as "account_no","res_company"."fx_close_time" as "fx_close_time","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."fx_corp_group" as "fx_corp_group","res_company"."fx_margin_call_mode" as "fx_margin_call_mode","res_company"."fx_login_checknum" as "fx_login_checknum","res_company"."fx_pwd_allow" as "fx_pwd_allow","res_company"."chart_template_id" as "chart_template_id","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."fx_funding_min_deposit" as "fx_funding_min_deposit","res_company"."fx_indv_group" as "fx_indv_group","res_company"."fx_association_code" as "fx_association_code","res_company"."fx_login_reset_time" as "fx_login_reset_time","res_company"."fx_mt5_version" as "fx_mt5_version","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."incoterm_id" as "incoterm_id","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."fx_funding_min_withdraw" as "fx_funding_min_withdraw","res_company"."fx_login_check_flg" as "fx_login_check_flg","res_company"."fx_demo_group" as "fx_demo_group","res_company"."fx_business_name" as "fx_business_name","res_company"."fx_trading_email_mode" as "fx_trading_email_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."fx_funding_max_deposit" as "fx_funding_max_deposit","res_company"."fx_min_length_pwd" as "fx_min_length_pwd","res_company"."trade_pin_check_num" as "trade_pin_check_num","res_company"."fx_mail_om" as "fx_mail_om","res_company"."fx_front_url" as "fx_front_url","res_company"."currency_interval_unit" as "currency_interval_unit","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."withdraw_pin_check_num" as "withdraw_pin_check_num","res_company"."fx_funding_max_withdraw" as "fx_funding_max_withdraw","res_company"."fx_max_length_pwd" as "fx_max_length_pwd","res_company"."email" as "email","res_company"."fx_mail_back" as "fx_mail_back","res_company"."fx_regist_quick_url" as "fx_regist_quick_url","res_company"."currency_provider" as "currency_provider","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."create_uid" as "create_uid","res_company"."fx_internal_transfer_flg" as "fx_internal_transfer_flg","res_company"."fx_pwd_policy" as "fx_pwd_policy","res_company"."st_withdraw_otp_mode" as "st_withdraw_otp_mode","res_company"."fx_webapi_url" as "fx_webapi_url","res_company"."fx_symbol_suffix" as "fx_symbol_suffix","res_company"."phone" as "phone","res_company"."write_uid" as "write_uid","res_company"."fx_forex_seqnum" as "fx_forex_seqnum","res_company"."fx_passwd_policy_flg" as "fx_passwd_policy_flg","res_company"."st_otp_check_num" as "st_otp_check_num","res_company"."fx_webapi_account" as "fx_webapi_account","res_company"."fx_mt5_agent" as "fx_mt5_agent","res_company"."fx_corp_max_leverage" as "fx_corp_max_leverage","res_company"."fx_pwd_uppercase" as "fx_pwd_uppercase","res_company"."sto_funding_max_deposit" as "sto_funding_max_deposit","res_company"."fx_webapi_pwd" as "fx_webapi_pwd","res_company"."fx_mt5_acc_type" as "fx_mt5_acc_type","res_company"."parent_id" as "parent_id","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."fx_indv_max_leverage" as "fx_indv_max_leverage","res_company"."fx_pwd_lowercase" as "fx_pwd_lowercase","res_company"."passkey_enabled" as "passkey_enabled","res_company"."company_registry" as "company_registry","res_company"."fx_whitelabel_code" as "fx_whitelabel_code","res_company"."gfo_web_url" as "gfo_web_url","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."fx_allow_change_pass" as "fx_allow_change_pass","res_company"."fx_pwd_digits" as "fx_pwd_digits","res_company"."ttl_passkey_skip" as "ttl_passkey_skip","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."demo_seq_number" as "demo_seq_number","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."partner_id" as "partner_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."fx_schedule_date" as "fx_schedule_date","res_company"."fx_pwd_symbols" as "fx_pwd_symbols","res_company"."ttl_otp" as "ttl_otp","res_company"."phone_international_format" as "phone_international_format","res_company"."fx_demo_max_leverage" as "fx_demo_max_leverage","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method" FROM "res_company" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") WHERE "res_company".id IN ($9)
0 min < 0.1% 0 ms 2,001,733 odoo 
SELECT "res_company".id FROM "res_company" WHERE ("res_company"."parent_id" in ($1)) ORDER BY "res_company"."sequence" ,"res_company"."name"
0 min < 0.1% 0 ms 253,948 mt5backup_main 
INSERT INTO "mt5_orders" ("Order","Timestamp","ExternalID","Login","Dealer","Symbol","Digits","DigitsCurrency","ContractSize","State","Reason","TimeSetup","TimeExpiration","TimeDone","TimeSetupMsc","TimeDoneMsc","ModifyFlags","Type","TypeFill","TypeTime","Flags","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","PartyID","RateMargin","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","VolumeInitial","VolumeCurrent","ApiData") VALUES ($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)
0 min < 0.1% 1 ms 15,911 pspprodbakusr 
update res_partner set lang=$1, write_date=$2 where id=$3
0 min < 0.1% 0 ms 65,596 odoo 
SELECT "res_company"."id" as "id","res_company"."currency_id" as "currency_id","res_company"."social_twitter" as "social_twitter","res_company"."ttl_passkey" as "ttl_passkey","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."partner_gid" as "partner_gid","res_company"."social_facebook" as "social_facebook","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."qr_code" as "qr_code","res_company"."snailmail_color" as "snailmail_color","res_company"."invoice_is_email" as "invoice_is_email","res_company"."social_github" as "social_github","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."invoice_is_print" as "invoice_is_print","res_company"."social_linkedin" as "social_linkedin","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."email" as "email","res_company"."social_youtube" as "social_youtube","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."paperformat_id" as "paperformat_id","res_company"."period_lock_date" as "period_lock_date","res_company"."social_googleplus" as "social_googleplus","res_company"."phone" as "phone","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."currency_next_execution_date" as "currency_next_execution_date","res_company"."social_instagram" as "social_instagram","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."sequence" as "sequence","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."last_currency_sync_date" as "last_currency_sync_date","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."report_header" as "report_header","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."company_registry" as "company_registry","res_company"."fx_bjp_secret_key" as "fx_bjp_secret_key","res_company"."account_setup_coa_state" as "account_setup_coa_state",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."create_date" as "create_date","res_company"."name" as "name","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."fx_open_time" as "fx_open_time","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."write_date" as "write_date","res_company"."account_no" as "account_no","res_company"."phone_international_format" as "phone_international_format","res_company"."fx_close_time" as "fx_close_time","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."fx_corp_group" as "fx_corp_group","res_company"."fx_margin_call_mode" as "fx_margin_call_mode","res_company"."fx_login_checknum" as "fx_login_checknum","res_company"."fx_pwd_allow" as "fx_pwd_allow","res_company"."chart_template_id" as "chart_template_id","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."fx_funding_min_deposit" as "fx_funding_min_deposit","res_company"."fx_indv_group" as "fx_indv_group","res_company"."fx_association_code" as "fx_association_code","res_company"."fx_login_reset_time" as "fx_login_reset_time","res_company"."fx_mt5_version" as "fx_mt5_version","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."incoterm_id" as "incoterm_id","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."fx_funding_min_withdraw" as "fx_funding_min_withdraw","res_company"."fx_login_check_flg" as "fx_login_check_flg","res_company"."fx_demo_group" as "fx_demo_group","res_company"."fx_business_name" as "fx_business_name","res_company"."fx_trading_email_mode" as "fx_trading_email_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."fx_funding_max_deposit" as "fx_funding_max_deposit","res_company"."fx_min_length_pwd" as "fx_min_length_pwd","res_company"."trade_pin_check_num" as "trade_pin_check_num","res_company"."fx_mail_om" as "fx_mail_om","res_company"."fx_front_url" as "fx_front_url","res_company"."currency_interval_unit" as "currency_interval_unit","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."withdraw_pin_check_num" as "withdraw_pin_check_num","res_company"."fx_funding_max_withdraw" as "fx_funding_max_withdraw","res_company"."fx_max_length_pwd" as "fx_max_length_pwd","res_company"."fx_mail_back" as "fx_mail_back","res_company"."fx_regist_quick_url" as "fx_regist_quick_url","res_company"."currency_provider" as "currency_provider","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."create_uid" as "create_uid","res_company"."fx_internal_transfer_flg" as "fx_internal_transfer_flg","res_company"."fx_pwd_policy" as "fx_pwd_policy","res_company"."st_withdraw_otp_mode" as "st_withdraw_otp_mode","res_company"."fx_webapi_url" as "fx_webapi_url","res_company"."fx_symbol_suffix" as "fx_symbol_suffix","res_company"."write_uid" as "write_uid","res_company"."fx_forex_seqnum" as "fx_forex_seqnum","res_company"."fx_passwd_policy_flg" as "fx_passwd_policy_flg","res_company"."st_otp_check_num" as "st_otp_check_num","res_company"."fx_webapi_account" as "fx_webapi_account","res_company"."fx_mt5_agent" as "fx_mt5_agent","res_company"."fx_corp_max_leverage" as "fx_corp_max_leverage","res_company"."fx_pwd_uppercase" as "fx_pwd_uppercase","res_company"."sto_funding_max_deposit" as "sto_funding_max_deposit","res_company"."fx_webapi_pwd" as "fx_webapi_pwd","res_company"."fx_mt5_acc_type" as "fx_mt5_acc_type","res_company"."parent_id" as "parent_id","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."fx_indv_max_leverage" as "fx_indv_max_leverage","res_company"."fx_pwd_lowercase" as "fx_pwd_lowercase","res_company"."passkey_enabled" as "passkey_enabled","res_company"."fx_whitelabel_code" as "fx_whitelabel_code","res_company"."gfo_web_url" as "gfo_web_url","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."fx_allow_change_pass" as "fx_allow_change_pass","res_company"."fx_pwd_digits" as "fx_pwd_digits","res_company"."ttl_passkey_skip" as "ttl_passkey_skip","res_company"."demo_seq_number" as "demo_seq_number","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."partner_id" as "partner_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."fx_schedule_date" as "fx_schedule_date","res_company"."fx_pwd_symbols" as "fx_pwd_symbols","res_company"."ttl_otp" as "ttl_otp","res_company"."fx_demo_max_leverage" as "fx_demo_max_leverage","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method" FROM "res_company" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") WHERE "res_company".id IN ($9)
0 min < 0.1% 23 ms 488 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."question_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))  AND  ("survey_user_input_line"."partner_id" in ($33))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
0 min < 0.1% 22 ms 488 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."question_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))  AND  ("survey_user_input_line"."partner_id" in ($41))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
0 min < 0.1% 0 ms 129,420 odoo 
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != $1
                                          AND active
                                          AND nextcall <= (now() at time zone $2)
                                          AND id=$3
                                       FOR UPDATE NOWAIT
0 min < 0.1% 0 ms 765,296 odoo 
SELECT latest_version FROM ir_module_module WHERE name=$1
0 min < 0.1% 0 ms 357,970 odoo 
SELECT active, id, login, password, (SELECT value FROM ir_config_parameter WHERE key=$1)
                                FROM res_users
                                WHERE id=$2
0 min < 0.1% 490 ms 20 odoo 
SELECT count($1) FROM "fx_report_partner" WHERE ("fx_report_partner"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_partner"."company_id" in ($6))
Details
CREATE INDEX CONCURRENTLY ON fx_report_partner (account_type)
0 min < 0.1% 0 ms 52,472 afxprodbakusr 
select rescompany0_.id as id1_12_0_, rescompany0_.account_no as account_2_12_0_, rescompany0_.base_onboarding_company_state as base_onb3_12_0_, rescompany0_.company_registry as company_4_12_0_, rescompany0_.create_date as create_d5_12_0_, rescompany0_.demo_seq_number as demo_seq6_12_0_, rescompany0_.email as email7_12_0_, rescompany0_.fx_allow_change_pass as fx_allow8_12_0_, rescompany0_.fx_bjp_secret_key as fx_bjp_s9_12_0_, rescompany0_.fx_close_time as fx_clos10_12_0_, rescompany0_.fx_corp_group as fx_corp11_12_0_, rescompany0_.fx_corp_max_leverage as fx_corp12_12_0_, rescompany0_.fx_demo_group as fx_demo13_12_0_, rescompany0_.fx_demo_max_leverage as fx_demo14_12_0_, rescompany0_.fx_forex_seqnum as fx_fore15_12_0_, rescompany0_.fx_front_url as fx_fron16_12_0_, rescompany0_.fx_funding_max_deposit as fx_fund17_12_0_, rescompany0_.fx_funding_max_withdraw as fx_fund18_12_0_, rescompany0_.fx_funding_min_deposit as fx_fund19_12_0_, rescompany0_.fx_funding_min_withdraw as fx_fund20_12_0_, rescompany0_.fx_indv_group as fx_indv21_12_0_, rescompany0_.fx_indv_max_leverage as fx_indv22_12_0_, rescompany0_.fx_login_check_flg as fx_logi23_12_0_, rescompany0_.fx_mail_back as fx_mail24_12_0_, rescompany0_.fx_mail_om as fx_mail25_12_0_, rescompany0_.fx_margin_call_mode as fx_marg26_12_0_, rescompany0_.fx_open_time as fx_open27_12_0_, rescompany0_.fx_schedule_date as fx_sche28_12_0_, rescompany0_.fx_webapi_account as fx_weba29_12_0_, rescompany0_.fx_webapi_pwd as fx_weba30_12_0_, rescompany0_.fx_webapi_url as fx_weba31_12_0_, rescompany0_.fx_whitelabel_code as fx_whit32_12_0_, rescompany0_.logo_web as logo_we33_12_0_, rescompany0_.name as name34_12_0_, rescompany0_.partner_gid as partner35_12_0_, rescompany0_.passkey_enabled as passkey36_12_0_, rescompany0_.phone as phone37_12_0_, rescompany0_.phone_international_format as phone_i38_12_0_, rescompany0_.report_footer as report_39_12_0_, rescompany0_.report_header as report_40_12_0_, rescompany0_.sequence as sequenc41_12_0_, rescompany0_.snailmail_color as snailma42_12_0_, rescompany0_.snailmail_duplex as snailma43_12_0_, rescompany0_.social_facebook as social_44_12_0_, rescompany0_.social_github as social_45_12_0_, rescompany0_.social_googleplus as social_46_12_0_, rescompany0_.social_instagram as social_47_12_0_, rescompany0_.social_linkedin as social_48_12_0_, rescompany0_.social_twitter as social_49_12_0_, rescompany0_.social_youtube as social_50_12_0_, rescompany0_.write_date as write_d51_12_0_ from res_company rescompany0_ where rescompany0_.id=$1
0 min < 0.1% 0 ms 59,629 odoo 
SELECT "ir_module_module".id FROM "ir_module_module" WHERE ("ir_module_module"."state" = $1) ORDER BY "ir_module_module"."sequence" ,"ir_module_module"."name"
Details
CREATE INDEX CONCURRENTLY ON ir_module_module (state, sequence)
0 min < 0.1% 2 ms 5,430 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
0 min < 0.1% 0 ms 53,900 afxprodbakusr 
update fx_report_accounts_daily set "Assets"=$1, "Balance"=$2, "BlockedCommission"=$3, "BlockedProfit"=$4, "Commission"=$5, "create_date"=$6, "Credit"=$7, "CurrencyDigits"=$8, "Equity"=$9, "Floating"=$10, "Liabilities"=$11, "Login"=$12, "Margin"=$13, "MarginFree"=$14, "MarginInitial"=$15, "MarginLevel"=$16, "MarginLeverage"=$17, "MarginMaintenance"=$18, "Profit"=$19, "report_date"=$20, "Storage"=$21, "write_date"=$22 where "id"=$23
0 min < 0.1% 0 ms 49,474 odoo 
SELECT "res_company"."id" as "id","res_company"."fx_corp_group" as "fx_corp_group","res_company"."fx_margin_call_mode" as "fx_margin_call_mode","res_company"."fx_login_checknum" as "fx_login_checknum","res_company"."fx_pwd_allow" as "fx_pwd_allow","res_company"."chart_template_id" as "chart_template_id","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."fx_funding_min_deposit" as "fx_funding_min_deposit","res_company"."fx_indv_group" as "fx_indv_group","res_company"."fx_association_code" as "fx_association_code","res_company"."fx_login_reset_time" as "fx_login_reset_time","res_company"."fx_mt5_version" as "fx_mt5_version","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."incoterm_id" as "incoterm_id","res_company"."qr_code" as "qr_code","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."fx_funding_min_withdraw" as "fx_funding_min_withdraw","res_company"."fx_login_check_flg" as "fx_login_check_flg","res_company"."fx_demo_group" as "fx_demo_group","res_company"."fx_business_name" as "fx_business_name","res_company"."fx_trading_email_mode" as "fx_trading_email_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."invoice_is_email" as "invoice_is_email","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."fx_funding_max_deposit" as "fx_funding_max_deposit","res_company"."fx_min_length_pwd" as "fx_min_length_pwd","res_company"."trade_pin_check_num" as "trade_pin_check_num","res_company"."fx_mail_om" as "fx_mail_om","res_company"."fx_front_url" as "fx_front_url","res_company"."invoice_is_print" as "invoice_is_print","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."currency_interval_unit" as "currency_interval_unit","res_company"."fx_funding_max_withdraw" as "fx_funding_max_withdraw","res_company"."fx_max_length_pwd" as "fx_max_length_pwd","res_company"."withdraw_pin_check_num" as "withdraw_pin_check_num","res_company"."email" as "email","res_company"."fx_mail_back" as "fx_mail_back","res_company"."fx_regist_quick_url" as "fx_regist_quick_url","res_company"."currency_provider" as "currency_provider","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."create_uid" as "create_uid","res_company"."fx_internal_transfer_flg" as "fx_internal_transfer_flg","res_company"."fx_pwd_policy" as "fx_pwd_policy","res_company"."st_withdraw_otp_mode" as "st_withdraw_otp_mode","res_company"."fx_webapi_url" as "fx_webapi_url","res_company"."fx_symbol_suffix" as "fx_symbol_suffix","res_company"."phone" as "phone","res_company"."write_uid" as "write_uid","res_company"."fx_forex_seqnum" as "fx_forex_seqnum","res_company"."fx_passwd_policy_flg" as "fx_passwd_policy_flg","res_company"."st_otp_check_num" as "st_otp_check_num","res_company"."currency_next_execution_date" as "currency_next_execution_date","res_company"."fx_webapi_account" as "fx_webapi_account","res_company"."fx_mt5_agent" as "fx_mt5_agent","res_company"."fx_corp_max_leverage" as "fx_corp_max_leverage","res_company"."fx_pwd_uppercase" as "fx_pwd_uppercase","res_company"."sto_funding_max_deposit" as "sto_funding_max_deposit","res_company"."last_currency_sync_date" as "last_currency_sync_date","res_company"."fx_webapi_pwd" as "fx_webapi_pwd","res_company"."fx_mt5_acc_type" as "fx_mt5_acc_type","res_company"."parent_id" as "parent_id","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."fx_indv_max_leverage" as "fx_indv_max_leverage","res_company"."fx_pwd_lowercase" as "fx_pwd_lowercase","res_company"."passkey_enabled" as "passkey_enabled","res_company"."company_registry" as "company_registry","res_company"."fx_whitelabel_code" as "fx_whitelabel_code","res_company"."gfo_web_url" as "gfo_web_url","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."fx_allow_change_pass" as "fx_allow_change_pass","res_company"."fx_pwd_digits" as "fx_pwd_digits","res_company"."ttl_passkey_skip" as "ttl_passkey_skip","res_company"."create_date" as "create_date","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."demo_seq_number" as "demo_seq_number","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."partner_id" as "partner_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."fx_schedule_date" as "fx_schedule_date","res_company"."fx_pwd_symbols" as "fx_pwd_symbols","res_company"."ttl_otp" as "ttl_otp","res_company"."write_date" as "write_date","res_company"."phone_international_format" as "phone_international_format","res_company"."fx_demo_max_leverage" as "fx_demo_max_leverage","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."currency_id" as "currency_id","res_company"."social_twitter" as "social_twitter","res_company"."ttl_passkey" as "ttl_passkey","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."partner_gid" as "partner_gid","res_company"."social_facebook" as "social_facebook","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."snailmail_color" as "snailmail_color","res_company"."social_github" as "social_github","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."social_linkedin" as "social_linkedin","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."social_youtube" as "social_youtube","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."paperformat_id" as "paperformat_id","res_company"."period_lock_date" as "period_lock_date","res_company"."social_googleplus" as "social_googleplus","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."social_instagram" as "social_instagram","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."sequence" as "sequence","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."report_header" as "report_header","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."fx_bjp_secret_key" as "fx_bjp_secret_key","res_company"."account_setup_coa_state" as "account_setup_coa_state",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."name" as "name","res_company"."fx_open_time" as "fx_open_time","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."account_no" as "account_no","res_company"."fx_close_time" as "fx_close_time","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state" FROM "res_company" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") WHERE "res_company".id IN ($9)
0 min < 0.1% 0 ms 11,172,011 odoo 
COMMIT
0 min < 0.1% 0 ms 546,609 odoo 
SELECT $1 FROM res_groups_users_rel WHERE uid=$2 AND gid IN
                            (SELECT res_id FROM ir_model_data WHERE module=$3 AND name=$4)
0 min < 0.1% 0 ms 47,817 odoo 
SELECT "res_company"."id" as "id","res_company"."currency_id" as "currency_id","res_company"."social_twitter" as "social_twitter","res_company"."ttl_passkey" as "ttl_passkey","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."partner_gid" as "partner_gid","res_company"."social_facebook" as "social_facebook","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."incoterm_id" as "incoterm_id","res_company"."qr_code" as "qr_code","res_company"."snailmail_color" as "snailmail_color","res_company"."invoice_is_email" as "invoice_is_email","res_company"."social_github" as "social_github","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."invoice_is_print" as "invoice_is_print","res_company"."social_linkedin" as "social_linkedin","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."social_youtube" as "social_youtube","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."paperformat_id" as "paperformat_id","res_company"."create_uid" as "create_uid","res_company"."period_lock_date" as "period_lock_date","res_company"."social_googleplus" as "social_googleplus","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."write_uid" as "write_uid","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."currency_next_execution_date" as "currency_next_execution_date","res_company"."social_instagram" as "social_instagram","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."sequence" as "sequence","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."last_currency_sync_date" as "last_currency_sync_date","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."report_header" as "report_header","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."fx_bjp_secret_key" as "fx_bjp_secret_key","res_company"."account_setup_coa_state" as "account_setup_coa_state",COALESCE("res_company__report_footer"."value", "res_company"."report_footer") as "report_footer",COALESCE("res_company__overdue_msg"."value", "res_company"."overdue_msg") as "overdue_msg","res_company"."create_date" as "create_date","res_company"."name" as "name","res_company"."fx_open_time" as "fx_open_time","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."transfer_account_id" as "transfer_account_id","res_company"."tax_exigibility" as "tax_exigibility","res_company"."write_date" as "write_date","res_company"."account_no" as "account_no","res_company"."fx_close_time" as "fx_close_time","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."fx_corp_group" as "fx_corp_group","res_company"."fx_margin_call_mode" as "fx_margin_call_mode","res_company"."fx_login_checknum" as "fx_login_checknum","res_company"."fx_pwd_allow" as "fx_pwd_allow","res_company"."chart_template_id" as "chart_template_id","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_state","res_company"."fx_funding_min_deposit" as "fx_funding_min_deposit","res_company"."fx_indv_group" as "fx_indv_group","res_company"."fx_association_code" as "fx_association_code","res_company"."fx_login_reset_time" as "fx_login_reset_time","res_company"."fx_mt5_version" as "fx_mt5_version","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."fx_funding_min_withdraw" as "fx_funding_min_withdraw","res_company"."fx_login_check_flg" as "fx_login_check_flg","res_company"."fx_demo_group" as "fx_demo_group","res_company"."fx_business_name" as "fx_business_name","res_company"."fx_trading_email_mode" as "fx_trading_email_mode","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."fx_funding_max_deposit" as "fx_funding_max_deposit","res_company"."fx_min_length_pwd" as "fx_min_length_pwd","res_company"."trade_pin_check_num" as "trade_pin_check_num","res_company"."fx_mail_om" as "fx_mail_om","res_company"."fx_front_url" as "fx_front_url","res_company"."currency_interval_unit" as "currency_interval_unit","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."withdraw_pin_check_num" as "withdraw_pin_check_num","res_company"."fx_funding_max_withdraw" as "fx_funding_max_withdraw","res_company"."fx_max_length_pwd" as "fx_max_length_pwd","res_company"."email" as "email","res_company"."fx_mail_back" as "fx_mail_back","res_company"."fx_regist_quick_url" as "fx_regist_quick_url","res_company"."currency_provider" as "currency_provider","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."fx_internal_transfer_flg" as "fx_internal_transfer_flg","res_company"."fx_pwd_policy" as "fx_pwd_policy","res_company"."st_withdraw_otp_mode" as "st_withdraw_otp_mode","res_company"."fx_webapi_url" as "fx_webapi_url","res_company"."fx_symbol_suffix" as "fx_symbol_suffix","res_company"."phone" as "phone","res_company"."fx_forex_seqnum" as "fx_forex_seqnum","res_company"."fx_passwd_policy_flg" as "fx_passwd_policy_flg","res_company"."st_otp_check_num" as "st_otp_check_num","res_company"."fx_webapi_account" as "fx_webapi_account","res_company"."fx_mt5_agent" as "fx_mt5_agent","res_company"."fx_corp_max_leverage" as "fx_corp_max_leverage","res_company"."fx_pwd_uppercase" as "fx_pwd_uppercase","res_company"."sto_funding_max_deposit" as "sto_funding_max_deposit","res_company"."fx_webapi_pwd" as "fx_webapi_pwd","res_company"."fx_mt5_acc_type" as "fx_mt5_acc_type","res_company"."parent_id" as "parent_id","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."fx_indv_max_leverage" as "fx_indv_max_leverage","res_company"."fx_pwd_lowercase" as "fx_pwd_lowercase","res_company"."passkey_enabled" as "passkey_enabled","res_company"."company_registry" as "company_registry","res_company"."fx_whitelabel_code" as "fx_whitelabel_code","res_company"."gfo_web_url" as "gfo_web_url","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."fx_allow_change_pass" as "fx_allow_change_pass","res_company"."fx_pwd_digits" as "fx_pwd_digits","res_company"."ttl_passkey_skip" as "ttl_passkey_skip","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."demo_seq_number" as "demo_seq_number","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."partner_id" as "partner_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."fx_schedule_date" as "fx_schedule_date","res_company"."fx_pwd_symbols" as "fx_pwd_symbols","res_company"."ttl_otp" as "ttl_otp","res_company"."phone_international_format" as "phone_international_format","res_company"."fx_demo_max_leverage" as "fx_demo_max_leverage","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method" FROM "res_company" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_company__report_footer" ON ("res_company"."id" = "res_company__report_footer"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") WHERE "res_company".id IN ($9)
0 min < 0.1% 0 ms 222,665 mt5backup_main 
DELETE FROM "mt5_positions" WHERE ("Position_ID"=$1)
0 min < 0.1% 0 ms 123,899 odoo 
INSERT INTO "mail_tracking_value" ("id", "create_uid", "create_date", "write_uid", "write_date", "field", "field_desc", "field_type", "mail_message_id", "new_value_float", "old_value_float", "track_sequence") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12) RETURNING id