Created
March 24, 2020 09:07
-
-
Save herawais/06cd4dfcca7592b0607ec62105e91ce9 to your computer and use it in GitHub Desktop.
not printing the invoice
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2020-03-24 09:07:11,227 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:11,228 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:11,230 20746 DEBUG ems_development odoo.sql_db: query: SELECT base_registry_signaling.last_value, | |
| base_cache_signaling.last_value | |
| FROM base_registry_signaling, base_cache_signaling | |
| 2020-03-24 09:07:11,231 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00/1 [2764] | |
| 2020-03-24 09:07:11,231 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/1 [2764] | |
| 2020-03-24 09:07:11,231 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:11,232 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:11,233 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:11,234 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:11,237 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.actions' 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) | |
| 2020-03-24 09:07:11,238 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_actions"."id" as "id","ir_actions"."type" as "type" FROM "ir_actions" WHERE "ir_actions".id IN (325) | |
| 2020-03-24 09:07:11,241 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.report' 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) | |
| 2020-03-24 09:07:11,243 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_act_report_xml"."id" as "id",COALESCE("ir_act_report_xml__name"."value", "ir_act_report_xml"."name") as "name","ir_act_report_xml"."type" as "type","ir_act_report_xml"."binding_type" as "binding_type","ir_act_report_xml"."model" as "model","ir_act_report_xml"."report_type" as "report_type","ir_act_report_xml"."report_name" as "report_name","ir_act_report_xml"."report_file" as "report_file","ir_act_report_xml"."multi" as "multi","ir_act_report_xml"."paperformat_id" as "paperformat_id","ir_act_report_xml"."print_report_name" as "print_report_name","ir_act_report_xml"."attachment_use" as "attachment_use","ir_act_report_xml"."attachment" as "attachment","ir_act_report_xml"."help" as "help","ir_act_report_xml"."binding_model_id" as "binding_model_id","ir_act_report_xml"."create_uid" as "create_uid","ir_act_report_xml"."create_date" as "create_date","ir_act_report_xml"."write_uid" as "write_uid","ir_act_report_xml"."write_date" as "write_date" FROM "ir_act_report_xml" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.actions.report,name' AND lang='en_US' AND value!='') | |
| as "ir_act_report_xml__name" ON ("ir_act_report_xml"."id" = "ir_act_report_xml__name"."res_id") WHERE "ir_act_report_xml".id IN (325) | |
| 2020-03-24 09:07:11,245 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.actions.report,help' AND res_id IN (325) | |
| 2020-03-24 09:07:11,248 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.groups' 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) | |
| 2020-03-24 09:07:11,250 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_groups_report_rel.uid, res_groups_report_rel.gid FROM res_groups_report_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_report_rel.uid IN (325) AND res_groups_report_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,254 20746 DEBUG ems_development odoo.sql_db: query: SELECT "report_paperformat"."id" as "id","report_paperformat"."margin_bottom" as "margin_bottom","report_paperformat"."create_date" as "create_date","report_paperformat"."dpi" as "dpi","report_paperformat"."page_height" as "page_height","report_paperformat"."write_uid" as "write_uid","report_paperformat"."margin_top" as "margin_top","report_paperformat"."header_spacing" as "header_spacing","report_paperformat"."orientation" as "orientation","report_paperformat"."create_uid" as "create_uid","report_paperformat"."margin_right" as "margin_right","report_paperformat"."default" as "default","report_paperformat"."header_line" as "header_line","report_paperformat"."format" as "format","report_paperformat"."margin_left" as "margin_left","report_paperformat"."write_date" as "write_date","report_paperformat"."name" as "name","report_paperformat"."page_width" as "page_width" FROM "report_paperformat" WHERE "report_paperformat".id IN (4) | |
| 2020-03-24 09:07:11,257 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model"."id" as "id","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."write_date" as "write_date","ir_model"."write_uid" as "write_uid","ir_model"."state" as "state","ir_model"."create_date" as "create_date","ir_model"."create_uid" as "create_uid","ir_model"."transient" as "transient","ir_model"."model" as "model","ir_model"."info" as "info",COALESCE("ir_model__name"."value", "ir_model"."name") as "name" FROM "ir_model" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.model,name' AND lang='en_US' AND value!='') | |
| as "ir_model__name" ON ("ir_model"."id" = "ir_model__name"."res_id") WHERE "ir_model".id IN (183) | |
| 2020-03-24 09:07:11,264 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."website_id" as "website_id","res_users"."login" as "login","res_users"."company_id" as "company_id","res_users"."odoobot_state" as "odoobot_state","res_users"."write_date" as "write_date","res_users"."create_date" as "create_date","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."share" as "share","res_users"."alias_id" as "alias_id","res_users"."active" as "active","res_users"."partner_id" as "partner_id","res_users"."notification_type" as "notification_type","res_users"."create_uid" as "create_uid" FROM "res_users" WHERE "res_users".id IN (1) | |
| 2020-03-24 09:07:11,270 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner"."id" as "id","res_partner"."industry_id" as "industry_id","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."vat" as "vat","res_partner"."customer" as "customer","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."additional_info" as "additional_info","res_partner"."write_uid" as "write_uid","res_partner"."ref" as "ref","res_partner"."street2" as "street2","res_partner"."company_name" as "company_name","res_partner"."company_id" as "company_id","res_partner"."supplier" as "supplier","res_partner"."website" as "website","res_partner"."user_id" as "user_id","res_partner"."phone" as "phone","res_partner"."partner_gid" as "partner_gid","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."debit_limit" as "debit_limit","res_partner"."date" as "date","res_partner"."lang" as "lang","res_partner"."zip" as "zip","res_partner"."user_defined_id" as "user_defined_id","res_partner"."invoice_warn" as "invoice_warn","res_partner"."employee" as "employee","res_partner"."barcode" as "barcode","res_partner"."mobile" as "mobile","res_partner"."signup_token" as "signup_token","res_partner"."comment" as "comment","res_partner"."message_bounce" as "message_bounce","res_partner"."tz" as "tz","res_partner"."city" as "city","res_partner"."legacy_user_id" as "legacy_user_id","res_partner"."is_company" as "is_company","res_partner"."create_date" as "create_date","res_partner"."title" as "title","res_partner"."name" as "name","res_partner"."function" as "function","res_partner"."state_id" as "state_id","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."signup_type" as "signup_type","res_partner"."website_id" as "website_id","res_partner"."credit_limit" as "credit_limit","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."signup_expiration" as "signup_expiration","res_partner"."email" as "email","res_partner"."color" as "color","res_partner"."write_date" as "write_date","res_partner"."display_name" as "display_name","res_partner"."parent_id" as "parent_id","res_partner"."type" as "type","res_partner"."create_uid" as "create_uid","res_partner"."country_id" as "country_id","res_partner"."active" as "active","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."partner_share" as "partner_share","res_partner"."street" as "street" FROM "res_partner" WHERE "res_partner".id IN (2) | |
| 2020-03-24 09:07:11,281 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.actions.report') AND ("ir_model_data"."res_id" in (325))) ORDER BY "ir_model_data"."id" | |
| 2020-03-24 09:07:11,281 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (70562) | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: SQL LOG from: | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: table: report_paperformat: 0:00:00.000398/1 | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: table: res_users: 0:00:00.000402/1 | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: table: res_partner: 0:00:00.000708/1 | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: table: ir_actions: 0:00:00.000950/1 | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: table: ir_model_data: 0:00:00.000555/2 | |
| 2020-03-24 09:07:11,284 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00.003013/13 [2777] | |
| 2020-03-24 09:07:11,285 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/13 [2777] | |
| 2020-03-24 09:07:11,285 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:11,285 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:11,285 20746 INFO ems_development werkzeug: 127.0.0.1 - - [24/Mar/2020 09:07:11] "POST /web/action/load HTTP/1.1" 200 - 14 0.012 0.047 | |
| 2020-03-24 09:07:11,324 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:11,325 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:11,325 20746 DEBUG ems_development odoo.sql_db: query: SELECT base_registry_signaling.last_value, | |
| base_cache_signaling.last_value | |
| FROM base_registry_signaling, base_cache_signaling | |
| 2020-03-24 09:07:11,326 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00/1 [2778] | |
| 2020-03-24 09:07:11,326 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/1 [2778] | |
| 2020-03-24 09:07:11,326 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:11,327 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:11,328 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:11,328 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:11,330 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.report' 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) | |
| 2020-03-24 09:07:11,332 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_act_report_xml".id FROM "ir_act_report_xml" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.actions.report,name' AND lang='en_US' AND value!='') | |
| as "ir_act_report_xml__name" ON ("ir_act_report_xml"."id" = "ir_act_report_xml__name"."res_id") WHERE ("ir_act_report_xml"."report_name" = 'openeducat_core.report_fee_voucher') ORDER BY COALESCE("ir_act_report_xml__name"."value", "ir_act_report_xml"."name") limit 1 | |
| 2020-03-24 09:07:11,335 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.report' 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) | |
| 2020-03-24 09:07:11,337 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_act_report_xml"."id" as "id","ir_act_report_xml"."write_uid" as "write_uid",COALESCE("ir_act_report_xml__name"."value", "ir_act_report_xml"."name") as "name","ir_act_report_xml"."binding_type" as "binding_type","ir_act_report_xml"."report_file" as "report_file","ir_act_report_xml"."create_uid" as "create_uid","ir_act_report_xml"."attachment_use" as "attachment_use","ir_act_report_xml"."report_name" as "report_name","ir_act_report_xml"."print_report_name" as "print_report_name","ir_act_report_xml"."binding_model_id" as "binding_model_id","ir_act_report_xml"."write_date" as "write_date","ir_act_report_xml"."multi" as "multi","ir_act_report_xml"."report_type" as "report_type","ir_act_report_xml"."attachment" as "attachment","ir_act_report_xml"."paperformat_id" as "paperformat_id","ir_act_report_xml"."model" as "model","ir_act_report_xml"."help" as "help","ir_act_report_xml"."create_date" as "create_date","ir_act_report_xml"."type" as "type" FROM "ir_act_report_xml" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.actions.report,name' AND lang='en_US' AND value!='') | |
| as "ir_act_report_xml__name" ON ("ir_act_report_xml"."id" = "ir_act_report_xml__name"."res_id") WHERE "ir_act_report_xml".id IN (325) | |
| 2020-03-24 09:07:11,339 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.actions.report,help' AND res_id IN (325) | |
| 2020-03-24 09:07:11,345 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.users' 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) | |
| 2020-03-24 09:07:11,349 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:11,351 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,355 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (19) | |
| 2020-03-24 09:07:11,360 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."website_id" as "website_id","res_users"."login" as "login","res_users"."company_id" as "company_id","res_users"."odoobot_state" as "odoobot_state","res_users"."write_date" as "write_date","res_users"."create_date" as "create_date","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."share" as "share","res_users"."alias_id" as "alias_id","res_users"."active" as "active","res_users"."partner_id" as "partner_id","res_users"."notification_type" as "notification_type","res_users"."create_uid" as "create_uid" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:11,363 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (19) | |
| 2020-03-24 09:07:11,366 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (19) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,371 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_company".id FROM "res_company" WHERE ("res_company"."parent_id" in (1)) ORDER BY "res_company"."sequence" ,"res_company"."name" | |
| 2020-03-24 09:07:11,372 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_company".id FROM "res_company" WHERE ("res_company"."id" in (1)) ORDER BY "res_company"."sequence" ,"res_company"."name" | |
| 2020-03-24 09:07:11,372 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:11,376 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (9, 10) | |
| 2020-03-24 09:07:11,380 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (9, 10) | |
| 2020-03-24 09:07:11,382 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (9, 10) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,387 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."website_id" as "website_id","res_users"."login" as "login","res_users"."company_id" as "company_id","res_users"."odoobot_state" as "odoobot_state","res_users"."write_date" as "write_date","res_users"."create_date" as "create_date","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."share" as "share","res_users"."alias_id" as "alias_id","res_users"."active" as "active","res_users"."partner_id" as "partner_id","res_users"."notification_type" as "notification_type","res_users"."create_uid" as "create_uid" FROM "res_users","res_partner" as "res_users__partner_id" WHERE "res_users".id IN (2) AND ("res_users"."id" in (SELECT "user_id" FROM "res_company_users_rel" WHERE "cid" IN (1))) AND ("res_users"."partner_id" = "res_users__partner_id"."id") AND ((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL ) OR ("res_users__partner_id"."type" = 'private')) | |
| 2020-03-24 09:07:11,393 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:11,397 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:11,399 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,403 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (35, 36, 37) | |
| 2020-03-24 09:07:11,405 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (35, 36, 37) | |
| 2020-03-24 09:07:11,406 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (35, 36, 37) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,412 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (923) AND TRUE | |
| 2020-03-24 09:07:11,415 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (923) | |
| 2020-03-24 09:07:11,590 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:11,594 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:11,596 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,601 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (35, 36, 37) | |
| 2020-03-24 09:07:11,602 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (35, 36, 37) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:11,605 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."model" as "model" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (923) AND TRUE | |
| 2020-03-24 09:07:11,607 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (923))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:11,610 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (71361) | |
| 2020-03-24 09:07:11,629 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:11,635 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 923) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:12,860 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student' 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) | |
| 2020-03-24 09:07:12,864 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (40, 109, 39) | |
| 2020-03-24 09:07:12,868 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (40, 109, 39) | |
| 2020-03-24 09:07:12,869 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (40, 39, 109) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:12,871 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:12,872 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_user_first_rel1.user_id, res_user_first_rel1.res_user_second_rel1 FROM res_user_first_rel1, "res_users" LEFT JOIN "res_partner" as "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") | |
| WHERE ("res_users"."active" = true) AND res_user_first_rel1.user_id IN (2) AND res_user_first_rel1.res_user_second_rel1 = res_users.id | |
| ORDER BY "res_users__partner_id"."name" ,"res_users"."login" OFFSET 0 | |
| 2020-03-24 09:07:12,874 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:12,878 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student"."id" as "id","op_student"."partner_id" as "partner_id","op_student"."last_name" as "last_name","op_student"."mobile_2" as "mobile_2","op_student"."is_active" as "is_active","op_student"."create_uid" as "create_uid","op_student"."father_name" as "father_name","op_student"."state" as "state","op_student"."category_id" as "category_id","op_student"."mother_email" as "mother_email","op_student"."blood_group" as "blood_group","op_student"."write_uid" as "write_uid","op_student"."father_edu" as "father_edu","op_student"."create_date" as "create_date","op_student"."gender" as "gender","op_student"."mother_edu" as "mother_edu","op_student"."father_occup" as "father_occup","op_student"."write_date" as "write_date","op_student"."visa_info" as "visa_info","op_student"."mother_occup" as "mother_occup","op_student"."nationality" as "nationality","op_student"."birth_date" as "birth_date","op_student"."mother_name" as "mother_name","op_student"."middle_name" as "middle_name","op_student"."id_number" as "id_number","op_student"."emergency_contact" as "emergency_contact","op_student"."already_partner" as "already_partner","op_student"."gr_no" as "gr_no" FROM "op_student","res_partner" as "op_student__partner_id" WHERE "op_student".id IN (968) AND TRUE AND ("op_student"."partner_id" = "op_student__partner_id"."id") AND ((("op_student__partner_id"."type" != 'private') OR "op_student__partner_id"."type" IS NULL ) OR ("op_student__partner_id"."type" = 'private')) | |
| 2020-03-24 09:07:12,882 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:12,886 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner"."id" as "id","res_partner"."industry_id" as "industry_id","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."vat" as "vat","res_partner"."customer" as "customer","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."additional_info" as "additional_info","res_partner"."write_uid" as "write_uid","res_partner"."ref" as "ref","res_partner"."street2" as "street2","res_partner"."company_name" as "company_name","res_partner"."company_id" as "company_id","res_partner"."supplier" as "supplier","res_partner"."website" as "website","res_partner"."user_id" as "user_id","res_partner"."phone" as "phone","res_partner"."partner_gid" as "partner_gid","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."debit_limit" as "debit_limit","res_partner"."date" as "date","res_partner"."lang" as "lang","res_partner"."zip" as "zip","res_partner"."user_defined_id" as "user_defined_id","res_partner"."invoice_warn" as "invoice_warn","res_partner"."employee" as "employee","res_partner"."barcode" as "barcode","res_partner"."mobile" as "mobile","res_partner"."signup_token" as "signup_token","res_partner"."comment" as "comment","res_partner"."message_bounce" as "message_bounce","res_partner"."tz" as "tz","res_partner"."city" as "city","res_partner"."legacy_user_id" as "legacy_user_id","res_partner"."is_company" as "is_company","res_partner"."create_date" as "create_date","res_partner"."title" as "title","res_partner"."name" as "name","res_partner"."function" as "function","res_partner"."state_id" as "state_id","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."signup_type" as "signup_type","res_partner"."website_id" as "website_id","res_partner"."credit_limit" as "credit_limit","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."signup_expiration" as "signup_expiration","res_partner"."email" as "email","res_partner"."color" as "color","res_partner"."write_date" as "write_date","res_partner"."display_name" as "display_name","res_partner"."parent_id" as "parent_id","res_partner"."type" as "type","res_partner"."create_uid" as "create_uid","res_partner"."country_id" as "country_id","res_partner"."active" as "active","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."partner_share" as "partner_share","res_partner"."street" as "street" FROM "res_partner" WHERE "res_partner".id IN (1946) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private')) | |
| 2020-03-24 09:07:12,891 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student' 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) | |
| 2020-03-24 09:07:12,894 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:12,899 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student"."id" as "id" FROM "op_student","res_partner" as "op_student__partner_id" WHERE "op_student".id IN (968) AND TRUE AND ("op_student"."partner_id" = "op_student__partner_id"."id") AND ((("op_student__partner_id"."type" != 'private') OR "op_student__partner_id"."type" IS NULL ) OR ("op_student__partner_id"."type" = 'private')) | |
| 2020-03-24 09:07:12,901 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:12,902 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course".id FROM "op_student_course" WHERE ("op_student_course"."student_id" in (968)) ORDER BY "op_student_course"."id" | |
| 2020-03-24 09:07:12,903 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:12,905 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course"."id" as "id","op_student_course"."student_id" as "student_id" FROM "op_student_course" WHERE "op_student_course".id IN (968) | |
| 2020-03-24 09:07:12,907 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:12,908 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course"."id" as "id","op_student_course"."write_date" as "write_date","op_student_course"."batch_id" as "batch_id","op_student_course"."roll_number" as "roll_number","op_student_course"."student_id" as "student_id","op_student_course"."is_current" as "is_current","op_student_course"."course_id" as "course_id","op_student_course"."write_uid" as "write_uid","op_student_course"."create_date" as "create_date","op_student_course"."create_uid" as "create_uid" FROM "op_student_course" WHERE "op_student_course".id IN (968) | |
| 2020-03-24 09:07:12,911 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.course' 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) | |
| 2020-03-24 09:07:12,912 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_course"."id" as "id","op_course"."name" as "name","op_course"."create_uid" as "create_uid","op_course"."create_date" as "create_date","op_course"."write_uid" as "write_uid","op_course"."evaluation_type" as "evaluation_type","op_course"."fees_term_id" as "fees_term_id","op_course"."parent_id" as "parent_id","op_course"."section" as "section","op_course"."min_unit_load" as "min_unit_load","op_course"."max_unit_load" as "max_unit_load","op_course"."write_date" as "write_date","op_course"."code" as "code" FROM "op_course" WHERE "op_course".id IN (764) | |
| 2020-03-24 09:07:12,919 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,924 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (184) AND TRUE | |
| 2020-03-24 09:07:12,926 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (184) | |
| 2020-03-24 09:07:12,929 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,931 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."model" as "model" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (184) AND TRUE | |
| 2020-03-24 09:07:12,933 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (184))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:12,934 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (3557) | |
| 2020-03-24 09:07:12,938 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,942 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 184) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:12,947 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,950 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (183) AND TRUE | |
| 2020-03-24 09:07:12,952 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (183) | |
| 2020-03-24 09:07:12,954 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,956 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."model" as "model" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (183) AND TRUE | |
| 2020-03-24 09:07:12,958 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (183))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:12,959 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (3556) | |
| 2020-03-24 09:07:12,963 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,966 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 183) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:12,967 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (398) | |
| 2020-03-24 09:07:12,968 20746 DEBUG ems_development odoo.sql_db: query: SELECT ir_ui_view_group_rel.view_id, ir_ui_view_group_rel.group_id FROM ir_ui_view_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND ir_ui_view_group_rel.view_id IN (398) AND ir_ui_view_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:12,970 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (398))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:12,971 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (5399) | |
| 2020-03-24 09:07:12,973 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (398) | |
| 2020-03-24 09:07:12,975 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (398) | |
| 2020-03-24 09:07:12,979 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:12,982 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 398) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:13,032 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,034 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,035 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,037 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang"."id" as "id","res_lang"."write_date" as "write_date","res_lang"."translatable" as "translatable","res_lang"."direction" as "direction","res_lang"."time_format" as "time_format","res_lang"."date_format" as "date_format","res_lang"."thousands_sep" as "thousands_sep","res_lang"."create_uid" as "create_uid","res_lang"."create_date" as "create_date","res_lang"."iso_code" as "iso_code","res_lang"."decimal_point" as "decimal_point","res_lang"."code" as "code","res_lang"."grouping" as "grouping","res_lang"."week_start" as "week_start","res_lang"."active" as "active","res_lang"."name" as "name","res_lang"."write_uid" as "write_uid" FROM "res_lang" WHERE "res_lang".id IN (1) | |
| 2020-03-24 09:07:13,043 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-e6d46de/web.assets_common.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,044 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (8441) | |
| 2020-03-24 09:07:13,045 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (8441) | |
| 2020-03-24 09:07:13,048 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,049 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,050 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-ea8d432/web.report_assets_common.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,052 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (8462, 8463) | |
| 2020-03-24 09:07:13,053 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (8462, 8463) | |
| 2020-03-24 09:07:13,056 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,057 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,061 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-e6d46de/web.assets_common.js' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,063 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (8446) | |
| 2020-03-24 09:07:13,065 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (8446) | |
| 2020-03-24 09:07:13,069 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,070 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,072 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-ea8d432/web.report_assets_common.js' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,074 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (8464) | |
| 2020-03-24 09:07:13,076 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (8464) | |
| 2020-03-24 09:07:13,079 20746 DEBUG ems_development odoo.sql_db: query: SELECT id FROM "ir_ui_view" WHERE id IN (185) | |
| 2020-03-24 09:07:13,082 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,086 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (35, 36, 37) | |
| 2020-03-24 09:07:13,088 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (35, 36, 37) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,093 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (185) AND TRUE | |
| 2020-03-24 09:07:13,096 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (185) | |
| 2020-03-24 09:07:13,101 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,104 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:13,105 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,110 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (35, 36, 37) | |
| 2020-03-24 09:07:13,111 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (35, 36, 37) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,116 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."model" as "model" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (185) AND TRUE | |
| 2020-03-24 09:07:13,118 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (185))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:13,120 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (3558) | |
| 2020-03-24 09:07:13,124 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,128 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 185) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:13,130 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (399) | |
| 2020-03-24 09:07:13,133 20746 DEBUG ems_development odoo.sql_db: query: SELECT ir_ui_view_group_rel.view_id, ir_ui_view_group_rel.group_id FROM ir_ui_view_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND ir_ui_view_group_rel.view_id IN (399) AND ir_ui_view_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,136 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (399))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2020-03-24 09:07:13,138 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN (5400) | |
| 2020-03-24 09:07:13,141 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."create_uid" as "create_uid","ir_ui_view"."model" as "model","ir_ui_view"."name" as "name","ir_ui_view"."website_id" as "website_id","ir_ui_view"."arch_db" as "arch_db","ir_ui_view"."mode" as "mode","ir_ui_view"."write_uid" as "write_uid","ir_ui_view"."create_date" as "create_date","ir_ui_view"."key" as "key","ir_ui_view"."active" as "active","ir_ui_view"."type" as "type","ir_ui_view"."inherit_id" as "inherit_id","ir_ui_view"."write_date" as "write_date","ir_ui_view"."arch_fs" as "arch_fs",COALESCE("ir_ui_view__website_meta_title"."value", "ir_ui_view"."website_meta_title") as "website_meta_title","ir_ui_view"."priority" as "priority","ir_ui_view"."field_parent" as "field_parent",COALESCE("ir_ui_view__website_meta_description"."value", "ir_ui_view"."website_meta_description") as "website_meta_description",COALESCE("ir_ui_view__website_meta_keywords"."value", "ir_ui_view"."website_meta_keywords") as "website_meta_keywords","ir_ui_view"."theme_template_id" as "theme_template_id","ir_ui_view"."customize_show" as "customize_show","ir_ui_view"."website_meta_og_img" as "website_meta_og_img" FROM "ir_ui_view" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_title' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_title" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_title"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_description' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_description" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_description"."res_id") LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.ui.view,website_meta_keywords' AND lang='en_US' AND value!='') | |
| as "ir_ui_view__website_meta_keywords" ON ("ir_ui_view"."id" = "ir_ui_view__website_meta_keywords"."res_id") WHERE "ir_ui_view".id IN (399) | |
| 2020-03-24 09:07:13,144 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.ui.view,arch_db' AND res_id IN (399) | |
| 2020-03-24 09:07:13,151 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,155 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 399) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:13,175 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,177 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,178 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-058c02c/web.report_assets_pdf.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,180 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (8465) | |
| 2020-03-24 09:07:13,182 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (8465) | |
| 2020-03-24 09:07:13,184 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,186 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,187 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-ea8d432/web.report_assets_common.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,189 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,191 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,194 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,197 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view"."id" as "id","ir_ui_view"."model" as "model" FROM "ir_ui_view" WHERE "ir_ui_view".id IN (185) AND TRUE | |
| 2020-03-24 09:07:13,201 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,205 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 185) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:13,208 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.ui.view' 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) | |
| 2020-03-24 09:07:13,212 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE ((FALSE OR "ir_ui_view"."website_id" IS NULL) AND (((("ir_ui_view"."inherit_id" = 399) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true))) AND TRUE ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id" | |
| 2020-03-24 09:07:13,241 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,243 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,244 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-058c02c/web.report_assets_pdf.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,246 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,248 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,250 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT max(id) | |
| FROM ir_attachment | |
| WHERE create_uid = 1 | |
| AND url like '/web/content/%-ea8d432/web.report_assets_common.%.css' | |
| GROUP BY datas_fname | |
| ORDER BY datas_fname | |
| 2020-03-24 09:07:13,253 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.lang' 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) | |
| 2020-03-24 09:07:13,254 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_lang".id FROM "res_lang" WHERE (("res_lang"."active" = true) AND ("res_lang"."code" = 'en_US')) ORDER BY COALESCE("res_lang"."active", false) DESC,"res_lang"."name" | |
| 2020-03-24 09:07:13,257 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='report.paperformat' 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) | |
| 2020-03-24 09:07:13,258 20746 DEBUG ems_development odoo.sql_db: query: SELECT "report_paperformat"."id" as "id","report_paperformat"."margin_bottom" as "margin_bottom","report_paperformat"."create_date" as "create_date","report_paperformat"."dpi" as "dpi","report_paperformat"."page_height" as "page_height","report_paperformat"."write_uid" as "write_uid","report_paperformat"."margin_top" as "margin_top","report_paperformat"."header_spacing" as "header_spacing","report_paperformat"."orientation" as "orientation","report_paperformat"."create_uid" as "create_uid","report_paperformat"."margin_right" as "margin_right","report_paperformat"."default" as "default","report_paperformat"."header_line" as "header_line","report_paperformat"."format" as "format","report_paperformat"."margin_left" as "margin_left","report_paperformat"."write_date" as "write_date","report_paperformat"."name" as "name","report_paperformat"."page_width" as "page_width" FROM "report_paperformat" WHERE "report_paperformat".id IN (4) | |
| 2020-03-24 09:07:13,788 20746 WARNING ems_development odoo.addons.base.models.ir_actions_report: wkhtmltopdf: b'The switch --header-html, is not support using unpatched qt, and will be ignored.The switch --footer-html, is not support using unpatched qt, and will be ignored.' | |
| 2020-03-24 09:07:13,789 20746 INFO ems_development odoo.addons.base.models.ir_actions_report: The PDF report has been generated for records [968]. | |
| 2020-03-24 09:07:13,791 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.report' 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) | |
| 2020-03-24 09:07:13,792 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_act_report_xml".id FROM "ir_act_report_xml" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.actions.report,name' AND lang='en_US' AND value!='') | |
| as "ir_act_report_xml__name" ON ("ir_act_report_xml"."id" = "ir_act_report_xml__name"."res_id") WHERE ("ir_act_report_xml"."report_name" = 'openeducat_core.report_fee_voucher') ORDER BY COALESCE("ir_act_report_xml__name"."value", "ir_act_report_xml"."name") limit 1 | |
| 2020-03-24 09:07:13,794 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='ir.actions.report' 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) | |
| 2020-03-24 09:07:13,796 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_act_report_xml"."id" as "id","ir_act_report_xml"."write_uid" as "write_uid","ir_act_report_xml"."binding_type" as "binding_type",COALESCE("ir_act_report_xml__name"."value", "ir_act_report_xml"."name") as "name","ir_act_report_xml"."report_file" as "report_file","ir_act_report_xml"."create_uid" as "create_uid","ir_act_report_xml"."attachment_use" as "attachment_use","ir_act_report_xml"."report_name" as "report_name","ir_act_report_xml"."print_report_name" as "print_report_name","ir_act_report_xml"."binding_model_id" as "binding_model_id","ir_act_report_xml"."write_date" as "write_date","ir_act_report_xml"."multi" as "multi","ir_act_report_xml"."report_type" as "report_type","ir_act_report_xml"."attachment" as "attachment","ir_act_report_xml"."paperformat_id" as "paperformat_id","ir_act_report_xml"."model" as "model","ir_act_report_xml"."help" as "help","ir_act_report_xml"."create_date" as "create_date","ir_act_report_xml"."type" as "type" FROM "ir_act_report_xml" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='ir.actions.report,name' AND lang='en_US' AND value!='') | |
| as "ir_act_report_xml__name" ON ("ir_act_report_xml"."id" = "ir_act_report_xml__name"."res_id") WHERE "ir_act_report_xml".id IN (325) | |
| 2020-03-24 09:07:13,797 20746 DEBUG ems_development odoo.sql_db: query: SELECT * FROM ir_translation | |
| WHERE lang='en_US' AND type='model_terms' AND name='ir.actions.report,help' AND res_id IN (325) | |
| 2020-03-24 09:07:13,800 20746 DEBUG ems_development odoo.sql_db: SQL LOG from: | |
| 2020-03-24 09:07:13,800 20746 DEBUG ems_development odoo.sql_db: table: op_course: 0:00:00.000352/1 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: res_company_users_rel: 0:00:00.000735/1 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: res_partner: 0:00:00.000803/1 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: report_paperformat: 0:00:00.000895/1 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: res_company: 0:00:00.000479/2 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: op_student_course: 0:00:00.000894/3 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: res_users: 0:00:00.002549/6 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: ir_attachment: 0:00:00.003835/10 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: res_lang: 0:00:00.003984/11 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: ir_rule: 0:00:00.004445/11 | |
| 2020-03-24 09:07:13,801 20746 DEBUG ems_development odoo.sql_db: table: ir_model_data: 0:00:00.007827/12 | |
| 2020-03-24 09:07:13,802 20746 DEBUG ems_development odoo.sql_db: table: ir_ui_view: 0:00:00.006507/16 | |
| 2020-03-24 09:07:13,802 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00.033305/161 [2939] | |
| 2020-03-24 09:07:13,802 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/161 [2939] | |
| 2020-03-24 09:07:13,802 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:13,802 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:13,803 20746 INFO ems_development werkzeug: 127.0.0.1 - - [24/Mar/2020 09:07:13] "POST /report/download HTTP/1.1" 200 - 162 0.121 2.359 | |
| 2020-03-24 09:07:13,821 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:13,821 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:13,822 20746 DEBUG ems_development odoo.sql_db: query: SELECT base_registry_signaling.last_value, | |
| base_cache_signaling.last_value | |
| FROM base_registry_signaling, base_cache_signaling | |
| 2020-03-24 09:07:13,823 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00/1 [2940] | |
| 2020-03-24 09:07:13,823 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/1 [2940] | |
| 2020-03-24 09:07:13,823 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:13,824 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:13,826 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:13,827 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:13,832 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student' 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) | |
| 2020-03-24 09:07:13,835 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:13,837 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,840 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (40, 109, 39) | |
| 2020-03-24 09:07:13,843 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (40, 109, 39) | |
| 2020-03-24 09:07:13,844 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (40, 39, 109) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,848 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:13,850 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_user_first_rel1.user_id, res_user_first_rel1.res_user_second_rel1 FROM res_user_first_rel1, "res_users" LEFT JOIN "res_partner" as "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") | |
| WHERE ("res_users"."active" = true) AND res_user_first_rel1.user_id IN (2) AND res_user_first_rel1.res_user_second_rel1 = res_users.id | |
| ORDER BY "res_users__partner_id"."name" ,"res_users"."login" OFFSET 0 | |
| 2020-03-24 09:07:13,853 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:13,855 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (9, 10) | |
| 2020-03-24 09:07:13,857 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (9, 10) | |
| 2020-03-24 09:07:13,859 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (9, 10) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,865 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student"."id" as "id","op_student"."already_partner" as "already_partner","op_student"."partner_id" as "partner_id","op_student"."is_active" as "is_active","op_student"."gender" as "gender","op_student"."birth_date" as "birth_date","op_student"."nationality" as "nationality","op_student"."father_name" as "father_name","op_student"."father_edu" as "father_edu","op_student"."father_occup" as "father_occup","op_student"."mother_name" as "mother_name","op_student"."mobile_2" as "mobile_2","op_student"."mother_email" as "mother_email","op_student"."mother_edu" as "mother_edu","op_student"."mother_occup" as "mother_occup","op_student"."blood_group" as "blood_group","op_student"."category_id" as "category_id","op_student"."state" as "state","op_student"."emergency_contact" as "emergency_contact","op_student"."gr_no" as "gr_no","op_student__partner_id"."title" as "title","op_student__partner_id"."name" as "name","op_student__partner_id"."type" as "type","op_student__partner_id"."street" as "street","op_student__partner_id"."street2" as "street2","op_student__partner_id"."city" as "city","op_student__partner_id"."state_id" as "state_id","op_student__partner_id"."zip" as "zip","op_student__partner_id"."country_id" as "country_id","op_student__partner_id"."user_id" as "user_id","op_student__partner_id"."email" as "email" FROM "op_student","res_partner" as "op_student__partner_id" WHERE "op_student".id IN (968) AND TRUE AND ("op_student"."partner_id" = "op_student__partner_id"."id") AND ((("op_student__partner_id"."type" != 'private') OR "op_student__partner_id"."type" IS NULL ) OR ("op_student__partner_id"."type" = 'private')) | |
| 2020-03-24 09:07:13,869 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:13,871 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course".id FROM "op_student_course" WHERE ("op_student_course"."student_id" in (968)) ORDER BY "op_student_course"."id" | |
| 2020-03-24 09:07:13,872 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:13,873 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course"."id" as "id","op_student_course"."student_id" as "student_id" FROM "op_student_course" WHERE "op_student_course".id IN (968) | |
| 2020-03-24 09:07:13,874 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.parent' 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) | |
| 2020-03-24 09:07:13,879 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (107, 108) | |
| 2020-03-24 09:07:13,884 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (107, 108) | |
| 2020-03-24 09:07:13,887 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (107, 108) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,895 20746 DEBUG ems_development odoo.sql_db: query: SELECT op_parent_op_student_rel.op_student_id, op_parent_op_student_rel.op_parent_id FROM op_parent_op_student_rel, "op_parent" | |
| WHERE TRUE AND op_parent_op_student_rel.op_student_id IN (968) AND op_parent_op_student_rel.op_parent_id = op_parent.id | |
| ORDER BY "op_parent"."id" OFFSET 0 | |
| 2020-03-24 09:07:13,901 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.fees.details' 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) | |
| 2020-03-24 09:07:13,904 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (111, 110) | |
| 2020-03-24 09:07:13,909 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (111, 110) | |
| 2020-03-24 09:07:13,911 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (111, 110) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,915 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_fees_details".id FROM "op_student_fees_details" WHERE ("op_student_fees_details"."student_id" in (968)) AND (("op_student_fees_details"."state" in ('invoice')) AND ("op_student_fees_details"."state" in ('invoice'))) ORDER BY "op_student_fees_details"."date" | |
| 2020-03-24 09:07:13,923 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.fees.details' 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) | |
| 2020-03-24 09:07:13,932 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:13,933 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,936 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (111, 110) | |
| 2020-03-24 09:07:13,937 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (111, 110) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,940 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_fees_details"."id" as "id","op_student_fees_details"."student_id" as "student_id" FROM "op_student_fees_details" WHERE "op_student_fees_details".id IN (13412, 13400, 13401, 13402, 13403, 13404, 13405, 13406) AND (("op_student_fees_details"."state" in ('invoice')) AND ("op_student_fees_details"."state" in ('invoice'))) | |
| 2020-03-24 09:07:13,942 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.assignment' 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) | |
| 2020-03-24 09:07:13,946 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (101, 105, 103) | |
| 2020-03-24 09:07:13,952 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (101, 105, 103) | |
| 2020-03-24 09:07:13,954 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (101, 103, 105) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:13,957 20746 DEBUG ems_development odoo.sql_db: query: SELECT op_assignment_op_student_rel.op_student_id, op_assignment_op_student_rel.op_assignment_id FROM op_assignment_op_student_rel, "op_assignment" | |
| WHERE TRUE AND op_assignment_op_student_rel.op_student_id IN (968) AND op_assignment_op_student_rel.op_assignment_id = op_assignment.id | |
| ORDER BY "op_assignment"."id" OFFSET 0 | |
| 2020-03-24 09:07:13,965 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner"."id" as "id","res_partner"."industry_id" as "industry_id","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."vat" as "vat","res_partner"."customer" as "customer","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."additional_info" as "additional_info","res_partner"."write_uid" as "write_uid","res_partner"."ref" as "ref","res_partner"."street2" as "street2","res_partner"."company_name" as "company_name","res_partner"."company_id" as "company_id","res_partner"."supplier" as "supplier","res_partner"."website" as "website","res_partner"."user_id" as "user_id","res_partner"."phone" as "phone","res_partner"."partner_gid" as "partner_gid","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."debit_limit" as "debit_limit","res_partner"."date" as "date","res_partner"."lang" as "lang","res_partner"."zip" as "zip","res_partner"."user_defined_id" as "user_defined_id","res_partner"."invoice_warn" as "invoice_warn","res_partner"."employee" as "employee","res_partner"."barcode" as "barcode","res_partner"."mobile" as "mobile","res_partner"."signup_token" as "signup_token","res_partner"."comment" as "comment","res_partner"."message_bounce" as "message_bounce","res_partner"."tz" as "tz","res_partner"."city" as "city","res_partner"."legacy_user_id" as "legacy_user_id","res_partner"."is_company" as "is_company","res_partner"."create_date" as "create_date","res_partner"."title" as "title","res_partner"."name" as "name","res_partner"."function" as "function","res_partner"."state_id" as "state_id","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."signup_type" as "signup_type","res_partner"."website_id" as "website_id","res_partner"."credit_limit" as "credit_limit","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."signup_expiration" as "signup_expiration","res_partner"."email" as "email","res_partner"."color" as "color","res_partner"."write_date" as "write_date","res_partner"."display_name" as "display_name","res_partner"."parent_id" as "parent_id","res_partner"."type" as "type","res_partner"."create_uid" as "create_uid","res_partner"."country_id" as "country_id","res_partner"."active" as "active","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."partner_share" as "partner_share","res_partner"."street" as "street" FROM "res_partner" WHERE "res_partner".id IN (1946) | |
| 2020-03-24 09:07:13,971 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:13,974 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner"."id" as "id" FROM "res_partner" WHERE "res_partner".id IN (1946) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private')) | |
| 2020-03-24 09:07:13,978 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (((("ir_attachment"."active" = true) AND ("ir_attachment"."res_model" = 'res.partner')) AND ("ir_attachment"."res_field" = 'image')) AND ("ir_attachment"."res_id" in (1946))) ORDER BY "ir_attachment"."id" DESC | |
| 2020-03-24 09:07:13,983 20746 DEBUG ems_development odoo.sql_db: query: SELECT res_model, res_id, create_uid, public FROM ir_attachment WHERE id IN (6298) | |
| 2020-03-24 09:07:13,984 20746 DEBUG ems_development odoo.sql_db: query: SELECT id FROM "res_partner" WHERE id IN (1946) | |
| 2020-03-24 09:07:13,986 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_attachment"."id" as "id","ir_attachment"."datas_fname" as "datas_fname","ir_attachment"."mimetype" as "mimetype","ir_attachment"."active" as "active","ir_attachment"."write_uid" as "write_uid","ir_attachment"."public" as "public","ir_attachment"."url" as "url","ir_attachment"."company_id" as "company_id","ir_attachment"."res_name" as "res_name","ir_attachment"."access_token" as "access_token","ir_attachment"."website_id" as "website_id","ir_attachment"."res_model" as "res_model","ir_attachment"."store_fname" as "store_fname","ir_attachment"."create_date" as "create_date","ir_attachment"."res_model_name" as "res_model_name","ir_attachment"."key" as "key","ir_attachment"."theme_template_id" as "theme_template_id","ir_attachment"."file_size" as "file_size","ir_attachment"."checksum" as "checksum","ir_attachment"."name" as "name","ir_attachment"."description" as "description","ir_attachment"."write_date" as "write_date","ir_attachment"."res_field" as "res_field","ir_attachment"."create_uid" as "create_uid","ir_attachment"."res_id" as "res_id","ir_attachment"."type" as "type" FROM "ir_attachment" WHERE "ir_attachment".id IN (6298) | |
| 2020-03-24 09:07:13,992 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."website_id" as "website_id","res_users"."login" as "login","res_users"."company_id" as "company_id","res_users"."odoobot_state" as "odoobot_state","res_users"."write_date" as "write_date","res_users"."create_date" as "create_date","res_users"."action_id" as "action_id","res_users"."write_uid" as "write_uid","res_users"."share" as "share","res_users"."alias_id" as "alias_id","res_users"."active" as "active","res_users"."partner_id" as "partner_id","res_users"."notification_type" as "notification_type","res_users"."create_uid" as "create_uid" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:13,998 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_company"."id" as "id","res_company"."currency_id" as "currency_id","res_company"."chart_template_id" as "chart_template_id","res_company"."accreditation" as "accreditation","res_company"."account_no" as "account_no","res_company"."external_report_layout_id" as "external_report_layout_id","res_company"."base_onboarding_company_state" as "base_onboarding_company_state","res_company"."partner_gid" as "partner_gid","res_company"."payment_onboarding_payment_method" as "payment_onboarding_payment_method","res_company"."qr_code" as "qr_code","res_company"."account_onboarding_invoice_layout_state" as "account_onboarding_invoice_layout_state","res_company"."write_uid" as "write_uid","res_company"."write_date" as "write_date","res_company"."sequence" as "sequence","res_company"."expects_chart_of_accounts" as "expects_chart_of_accounts","res_company"."approval_authority" as "approval_authority","res_company"."phone" as "phone","res_company"."social_googleplus" as "social_googleplus","res_company"."invoice_reference_type" as "invoice_reference_type","res_company"."account_sale_tax_id" as "account_sale_tax_id","res_company"."snailmail_color" as "snailmail_color","res_company"."social_twitter" as "social_twitter","res_company"."fiscalyear_last_month" as "fiscalyear_last_month","res_company"."incoterm_id" as "incoterm_id","res_company"."invoice_is_email" as "invoice_is_email","res_company"."account_onboarding_sample_invoice_state" as "account_onboarding_sample_invoice_state","res_company"."report_header" as "report_header","res_company"."anglo_saxon_accounting" as "anglo_saxon_accounting","res_company"."social_instagram" as "social_instagram","res_company"."account_setup_bank_data_state" as "account_setup_bank_data_state","res_company"."snailmail_duplex" as "snailmail_duplex","res_company"."account_purchase_tax_id" as "account_purchase_tax_id","res_company"."social_facebook" as "social_facebook","res_company"."bank_account_code_prefix" as "bank_account_code_prefix","res_company"."resource_calendar_id" as "resource_calendar_id","res_company"."parent_id" as "parent_id","res_company"."property_stock_account_input_categ_id" as "property_stock_account_input_categ_id","res_company"."invoice_is_print" as "invoice_is_print","res_company"."account_opening_move_id" as "account_opening_move_id","res_company"."account_onboarding_sale_tax_state" as "account_onboarding_sale_tax_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"."invoice_is_snailmail" as "invoice_is_snailmail","res_company"."social_youtube" as "social_youtube","res_company"."account_setup_fy_data_state" as "account_setup_fy_data_state","res_company"."fiscalyear_last_day" as "fiscalyear_last_day","res_company"."social_github" as "social_github","res_company"."cash_account_code_prefix" as "cash_account_code_prefix","res_company"."tax_cash_basis_journal_id" as "tax_cash_basis_journal_id","res_company"."nomenclature_id" as "nomenclature_id","res_company"."property_stock_account_output_categ_id" as "property_stock_account_output_categ_id","res_company"."account_invoice_onboarding_state" as "account_invoice_onboarding_state","res_company"."tax_exigibility" as "tax_exigibility","res_company"."company_registry" as "company_registry","res_company"."name" as "name","res_company"."payment_acquirer_onboarding_state" as "payment_acquirer_onboarding_state","res_company"."account_setup_coa_state" as "account_setup_coa_state","res_company"."period_lock_date" as "period_lock_date","res_company"."social_linkedin" as "social_linkedin","res_company"."paperformat_id" as "paperformat_id","res_company"."transfer_account_code_prefix" as "transfer_account_code_prefix","res_company"."tax_calculation_rounding_method" as "tax_calculation_rounding_method","res_company"."partner_id" as "partner_id","res_company"."transfer_account_id" as "transfer_account_id","res_company"."currency_exchange_journal_id" as "currency_exchange_journal_id","res_company"."property_stock_valuation_account_id" as "property_stock_valuation_account_id","res_company"."account_bank_reconciliation_start" as "account_bank_reconciliation_start","res_company"."account_dashboard_onboarding_state" as "account_dashboard_onboarding_state","res_company"."create_uid" as "create_uid","res_company"."create_date" as "create_date","res_company"."fiscalyear_lock_date" as "fiscalyear_lock_date","res_company"."email" as "email" FROM "res_company" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.company,report_footer' AND lang='en_US' AND value!='') | |
| 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='model' AND name='res.company,overdue_msg' AND lang='en_US' AND value!='') | |
| as "res_company__overdue_msg" ON ("res_company"."id" = "res_company__overdue_msg"."res_id") WHERE "res_company".id IN (1) | |
| 2020-03-24 09:07:14,008 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:14,014 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:14,017 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:14,023 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (9, 10) | |
| 2020-03-24 09:07:14,025 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (9, 10) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:14,036 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."parent_id" in (1946)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private')) ORDER BY "res_partner"."display_name" | |
| 2020-03-24 09:07:14,038 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:14,045 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (1946)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private')) ORDER BY "res_partner"."display_name" | |
| 2020-03-24 09:07:14,049 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='account.invoice.report' 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) | |
| 2020-03-24 09:07:14,056 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (61) | |
| 2020-03-24 09:07:14,063 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (61) | |
| 2020-03-24 09:07:14,068 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (61) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:14,074 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_company".id FROM "res_company" WHERE ("res_company"."parent_id" in (1)) ORDER BY "res_company"."sequence" ,"res_company"."name" | |
| 2020-03-24 09:07:14,079 20746 DEBUG ems_development odoo.sql_db: query: | |
| SELECT SUM(price_total) as total, partner_id | |
| FROM account_invoice_report account_invoice_report | |
| WHERE ((("account_invoice_report"."partner_id" in (1946)) AND (("account_invoice_report"."state" not in ('draft','cancel')) OR "account_invoice_report"."state" IS NULL)) AND ("account_invoice_report"."type" in ('out_invoice','out_refund'))) AND ("account_invoice_report"."company_id" IS NULL OR ("account_invoice_report"."company_id" in (1))) | |
| GROUP BY partner_id | |
| 2020-03-24 09:07:14,126 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:14,135 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_partner"."id" as "id","res_partner"."industry_id" as "industry_id","res_partner"."message_main_attachment_id" as "message_main_attachment_id","res_partner"."vat" as "vat","res_partner"."customer" as "customer","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."additional_info" as "additional_info","res_partner"."write_uid" as "write_uid","res_partner"."ref" as "ref","res_partner"."street2" as "street2","res_partner"."company_name" as "company_name","res_partner"."company_id" as "company_id","res_partner"."supplier" as "supplier","res_partner"."website" as "website","res_partner"."user_id" as "user_id","res_partner"."phone" as "phone","res_partner"."partner_gid" as "partner_gid","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."debit_limit" as "debit_limit","res_partner"."date" as "date","res_partner"."lang" as "lang","res_partner"."zip" as "zip","res_partner"."user_defined_id" as "user_defined_id","res_partner"."invoice_warn" as "invoice_warn","res_partner"."employee" as "employee","res_partner"."barcode" as "barcode","res_partner"."mobile" as "mobile","res_partner"."signup_token" as "signup_token","res_partner"."comment" as "comment","res_partner"."message_bounce" as "message_bounce","res_partner"."tz" as "tz","res_partner"."city" as "city","res_partner"."legacy_user_id" as "legacy_user_id","res_partner"."is_company" as "is_company","res_partner"."create_date" as "create_date","res_partner"."title" as "title","res_partner"."name" as "name","res_partner"."function" as "function","res_partner"."state_id" as "state_id","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."signup_type" as "signup_type","res_partner"."website_id" as "website_id","res_partner"."credit_limit" as "credit_limit","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."signup_expiration" as "signup_expiration","res_partner"."email" as "email","res_partner"."color" as "color","res_partner"."write_date" as "write_date","res_partner"."display_name" as "display_name","res_partner"."parent_id" as "parent_id","res_partner"."type" as "type","res_partner"."create_uid" as "create_uid","res_partner"."country_id" as "country_id","res_partner"."active" as "active","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."partner_share" as "partner_share","res_partner"."street" as "street" FROM "res_partner" WHERE "res_partner".id IN (1946) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private')) | |
| 2020-03-24 09:07:14,143 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.currency' 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) | |
| 2020-03-24 09:07:14,146 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_currency"."id" as "id","res_currency"."decimal_places" as "decimal_places","res_currency"."position" as "position","res_currency"."rounding" as "rounding","res_currency"."symbol" as "symbol","res_currency"."write_uid" as "write_uid","res_currency"."name" as "name","res_currency"."currency_subunit_label" as "currency_subunit_label","res_currency"."write_date" as "write_date","res_currency"."active" as "active","res_currency"."create_uid" as "create_uid","res_currency"."currency_unit_label" as "currency_unit_label","res_currency"."create_date" as "create_date" FROM "res_currency" WHERE "res_currency".id IN (165) | |
| 2020-03-24 09:07:14,168 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student' 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) | |
| 2020-03-24 09:07:14,173 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='res.partner' 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) | |
| 2020-03-24 09:07:14,189 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student"."id" as "id","op_student"."partner_id" as "partner_id","op_student"."last_name" as "last_name","op_student"."mobile_2" as "mobile_2","op_student"."is_active" as "is_active","op_student"."create_uid" as "create_uid","op_student"."father_name" as "father_name","op_student"."state" as "state","op_student"."category_id" as "category_id","op_student"."blood_group" as "blood_group","op_student"."mother_email" as "mother_email","op_student"."write_uid" as "write_uid","op_student"."father_edu" as "father_edu","op_student"."create_date" as "create_date","op_student"."gender" as "gender","op_student"."mother_edu" as "mother_edu","op_student"."father_occup" as "father_occup","op_student"."write_date" as "write_date","op_student"."visa_info" as "visa_info","op_student"."mother_occup" as "mother_occup","op_student"."nationality" as "nationality","op_student"."birth_date" as "birth_date","op_student"."mother_name" as "mother_name","op_student"."middle_name" as "middle_name","op_student"."id_number" as "id_number","op_student"."emergency_contact" as "emergency_contact","op_student"."already_partner" as "already_partner","op_student"."gr_no" as "gr_no" FROM "op_student","res_partner" as "op_student__partner_id" WHERE "op_student".id IN (968) AND TRUE AND ("op_student"."partner_id" = "op_student__partner_id"."id") AND ((("op_student__partner_id"."type" != 'private') OR "op_student__partner_id"."type" IS NULL ) OR ("op_student__partner_id"."type" = 'private')) | |
| 2020-03-24 09:07:14,208 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student"."id" as "id","op_student"."partner_id" as "partner_id","op_student"."last_name" as "last_name","op_student"."mobile_2" as "mobile_2","op_student"."is_active" as "is_active","op_student"."create_uid" as "create_uid","op_student"."father_name" as "father_name","op_student"."state" as "state","op_student"."category_id" as "category_id","op_student"."mother_email" as "mother_email","op_student"."blood_group" as "blood_group","op_student"."write_uid" as "write_uid","op_student"."father_edu" as "father_edu","op_student"."create_date" as "create_date","op_student"."gender" as "gender","op_student"."mother_edu" as "mother_edu","op_student"."father_occup" as "father_occup","op_student"."write_date" as "write_date","op_student"."visa_info" as "visa_info","op_student"."mother_occup" as "mother_occup","op_student"."nationality" as "nationality","op_student"."birth_date" as "birth_date","op_student"."mother_name" as "mother_name","op_student"."middle_name" as "middle_name","op_student"."id_number" as "id_number","op_student"."emergency_contact" as "emergency_contact","op_student"."already_partner" as "already_partner","op_student"."gr_no" as "gr_no" FROM "op_student" WHERE "op_student".id IN (968) | |
| 2020-03-24 09:07:14,215 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:14,217 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course"."id" as "id","op_student_course"."write_date" as "write_date","op_student_course"."batch_id" as "batch_id","op_student_course"."student_id" as "student_id","op_student_course"."roll_number" as "roll_number","op_student_course"."is_current" as "is_current","op_student_course"."course_id" as "course_id","op_student_course"."write_uid" as "write_uid","op_student_course"."create_date" as "create_date","op_student_course"."create_uid" as "create_uid" FROM "op_student_course" WHERE "op_student_course".id IN (968) | |
| 2020-03-24 09:07:14,222 20746 DEBUG ems_development odoo.sql_db: SQL LOG from: | |
| 2020-03-24 09:07:14,222 20746 DEBUG ems_development odoo.sql_db: table: res_company: 0:00:00.000624/1 | |
| 2020-03-24 09:07:14,223 20746 DEBUG ems_development odoo.sql_db: table: op_student: 0:00:00.000710/1 | |
| 2020-03-24 09:07:14,223 20746 DEBUG ems_development odoo.sql_db: table: res_currency: 0:00:00.003042/1 | |
| 2020-03-24 09:07:14,224 20746 DEBUG ems_development odoo.sql_db: table: op_student_fees_details: 0:00:00.004699/2 | |
| 2020-03-24 09:07:14,224 20746 DEBUG ems_development odoo.sql_db: table: op_student_course: 0:00:00.001085/3 | |
| 2020-03-24 09:07:14,224 20746 DEBUG ems_development odoo.sql_db: table: ir_attachment: 0:00:00.002081/3 | |
| 2020-03-24 09:07:14,224 20746 DEBUG ems_development odoo.sql_db: table: res_users: 0:00:00.003083/5 | |
| 2020-03-24 09:07:14,224 20746 DEBUG ems_development odoo.sql_db: table: res_partner: 0:00:00.004165/6 | |
| 2020-03-24 09:07:14,225 20746 DEBUG ems_development odoo.sql_db: table: ir_rule: 0:00:00.007281/14 | |
| 2020-03-24 09:07:14,225 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00.026770/71 [3011] | |
| 2020-03-24 09:07:14,225 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/71 [3011] | |
| 2020-03-24 09:07:14,225 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:14,225 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:14,227 20746 INFO ems_development werkzeug: 127.0.0.1 - - [24/Mar/2020 09:07:14] "POST /web/dataset/call_kw/op.student/read HTTP/1.1" 200 - 72 0.112 0.295 | |
| 2020-03-24 09:07:14,325 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:14,326 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:14,326 20746 DEBUG ems_development odoo.sql_db: query: SELECT base_registry_signaling.last_value, | |
| base_cache_signaling.last_value | |
| FROM base_registry_signaling, base_cache_signaling | |
| 2020-03-24 09:07:14,339 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:14,340 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00/1 [3012] | |
| 2020-03-24 09:07:14,340 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/1 [3012] | |
| 2020-03-24 09:07:14,342 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:14,343 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:14,343 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:14,345 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:14,346 20746 DEBUG ems_development odoo.sql_db: query: SELECT base_registry_signaling.last_value, | |
| base_cache_signaling.last_value | |
| FROM base_registry_signaling, base_cache_signaling | |
| 2020-03-24 09:07:14,346 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:14,360 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.course' 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) | |
| 2020-03-24 09:07:14,360 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00/1 [3013] | |
| 2020-03-24 09:07:14,361 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/1 [3013] | |
| 2020-03-24 09:07:14,361 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:14,362 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:14,365 20746 DEBUG ems_development odoo.sql_db: create serialized cursor to {'database': 'ems_development', 'sslmode': 'prefer'} | |
| 2020-03-24 09:07:14,367 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Borrow existing connection to 'sslmode=prefer dbname=ems_development' at index 1 | |
| 2020-03-24 09:07:14,372 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.student.fees.details' 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) | |
| 2020-03-24 09:07:14,373 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_course"."id" as "id","op_student_course"."course_id" as "course_id","op_student_course"."batch_id" as "batch_id","op_student_course"."roll_number" as "roll_number","op_student_course"."is_current" as "is_current" FROM "op_student_course" WHERE "op_student_course".id IN (968) | |
| 2020-03-24 09:07:14,374 20746 DEBUG ems_development odoo.sql_db: query: SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) | |
| WHERE m.model='op.subject' 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) | |
| 2020-03-24 09:07:14,377 20746 DEBUG ems_development odoo.sql_db: query: SELECT op_student_course_op_subject_rel.op_student_course_id, op_student_course_op_subject_rel.op_subject_id FROM op_student_course_op_subject_rel, "op_subject" | |
| WHERE 1=1 AND op_student_course_op_subject_rel.op_student_course_id IN (968) AND op_student_course_op_subject_rel.op_subject_id = op_subject.id | |
| ORDER BY "op_subject"."id" OFFSET 0 | |
| 2020-03-24 09:07:14,379 20746 DEBUG ems_development odoo.sql_db: query: SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN (2) | |
| 2020-03-24 09:07:14,382 20746 DEBUG ems_development odoo.sql_db: query: 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='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND res_groups_users_rel.uid IN (2) AND res_groups_users_rel.gid = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:14,387 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_course"."id" as "id","op_course"."name" as "name","op_course"."create_uid" as "create_uid","op_course"."create_date" as "create_date","op_course"."write_uid" as "write_uid","op_course"."evaluation_type" as "evaluation_type","op_course"."fees_term_id" as "fees_term_id","op_course"."parent_id" as "parent_id","op_course"."section" as "section","op_course"."min_unit_load" as "min_unit_load","op_course"."max_unit_load" as "max_unit_load","op_course"."write_date" as "write_date","op_course"."code" as "code" FROM "op_course" WHERE "op_course".id IN (764) | |
| 2020-03-24 09:07:14,389 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id","ir_rule"."active" as "active","ir_rule"."write_uid" as "write_uid","ir_rule"."perm_write" as "perm_write","ir_rule"."create_uid" as "create_uid","ir_rule"."global" as "global","ir_rule"."model_id" as "model_id","ir_rule"."perm_read" as "perm_read","ir_rule"."perm_create" as "perm_create","ir_rule"."write_date" as "write_date","ir_rule"."perm_unlink" as "perm_unlink","ir_rule"."domain_force" as "domain_force","ir_rule"."create_date" as "create_date","ir_rule"."name" as "name" FROM "ir_rule" WHERE "ir_rule".id IN (111, 110) | |
| 2020-03-24 09:07:14,392 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_batch"."id" as "id","op_batch"."code" as "code","op_batch"."write_uid" as "write_uid","op_batch"."end_date" as "end_date","op_batch"."create_uid" as "create_uid","op_batch"."write_date" as "write_date","op_batch"."start_date" as "start_date","op_batch"."course_id" as "course_id","op_batch"."create_date" as "create_date","op_batch"."name" as "name" FROM "op_batch" WHERE "op_batch".id IN (54) | |
| 2020-03-24 09:07:14,395 20746 DEBUG ems_development odoo.sql_db: SQL LOG from: | |
| 2020-03-24 09:07:14,395 20746 DEBUG ems_development odoo.sql_db: table: op_student_course: 0:00:00.000403/1 | |
| 2020-03-24 09:07:14,395 20746 DEBUG ems_development odoo.sql_db: table: op_batch: 0:00:00.000462/1 | |
| 2020-03-24 09:07:14,396 20746 DEBUG ems_development odoo.sql_db: table: op_course: 0:00:00.001996/1 | |
| 2020-03-24 09:07:14,396 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00.002861/6 [3019] | |
| 2020-03-24 09:07:14,396 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/6 [3019] | |
| 2020-03-24 09:07:14,396 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=3/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:14,396 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:14,397 20746 INFO ems_development werkzeug: 127.0.0.1 - - [24/Mar/2020 09:07:14] "POST /web/dataset/call_kw/op.student.course/read HTTP/1.1" 200 - 7 0.032 0.047 | |
| 2020-03-24 09:07:14,403 20746 DEBUG ems_development odoo.sql_db: query: SELECT "ir_rule"."id" as "id" FROM "ir_rule" WHERE "ir_rule".id IN (111, 110) | |
| 2020-03-24 09:07:14,405 20746 DEBUG ems_development odoo.sql_db: query: SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='res.groups,name' AND lang='en_US' AND value!='') | |
| as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id") | |
| WHERE 1=1 AND rule_group_rel.rule_group_id IN (111, 110) AND rule_group_rel.group_id = res_groups.id | |
| ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET 0 | |
| 2020-03-24 09:07:14,411 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_fees_details"."id" as "id","op_student_fees_details"."course_id" as "course_id","op_student_fees_details"."date" as "date","op_student_fees_details"."product_id" as "product_id","op_student_fees_details"."amount" as "amount","op_student_fees_details"."discount_amt" as "discount_amt","op_student_fees_details"."disc_prod_id" as "disc_prod_id","op_student_fees_details"."invoice_id" as "invoice_id","op_student_fees_details"."state" as "state" FROM "op_student_fees_details" WHERE "op_student_fees_details".id IN (13412, 13400, 13401, 13402, 13403, 13404, 13405, 13406) AND (("op_student_fees_details"."state" in ('invoice')) AND ("op_student_fees_details"."state" in ('invoice'))) | |
| 2020-03-24 09:07:14,417 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_course"."id" as "id","op_course"."name" as "name","op_course"."create_uid" as "create_uid","op_course"."create_date" as "create_date","op_course"."write_uid" as "write_uid","op_course"."evaluation_type" as "evaluation_type","op_course"."fees_term_id" as "fees_term_id","op_course"."parent_id" as "parent_id","op_course"."section" as "section","op_course"."min_unit_load" as "min_unit_load","op_course"."max_unit_load" as "max_unit_load","op_course"."write_date" as "write_date","op_course"."code" as "code" FROM "op_course" WHERE "op_course".id IN (764) | |
| 2020-03-24 09:07:14,426 20746 DEBUG ems_development odoo.sql_db: query: SELECT "product_product"."id" as "id","product_product"."default_code" as "default_code","product_product"."product_tmpl_id" as "product_tmpl_id",COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") as "name" FROM "product_product","product_template" as "product_product__product_tmpl_id" LEFT JOIN | |
| (SELECT res_id, value FROM "ir_translation" | |
| WHERE type='model' AND name='product.template,name' AND lang='en_US' AND value!='') | |
| as "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id") WHERE "product_product".id IN (40, 1) AND ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") | |
| 2020-03-24 09:07:14,429 20746 DEBUG ems_development odoo.sql_db: query: SELECT product_attribute_value_product_product_rel.product_product_id, product_attribute_value_product_product_rel.product_attribute_value_id FROM product_attribute_value_product_product_rel, "product_attribute_value" LEFT JOIN "product_attribute" as "product_attribute_value__attribute_id" ON ("product_attribute_value"."attribute_id" = "product_attribute_value__attribute_id"."id") | |
| WHERE 1=1 AND product_attribute_value_product_product_rel.product_product_id IN (1, 40) AND product_attribute_value_product_product_rel.product_attribute_value_id = product_attribute_value.id | |
| ORDER BY "product_attribute_value__attribute_id"."sequence" ,"product_attribute_value__attribute_id"."id" ,"product_attribute_value"."sequence" ,"product_attribute_value"."id" OFFSET 0 | |
| 2020-03-24 09:07:14,433 20746 DEBUG ems_development odoo.sql_db: query: SELECT "product_template"."id" as "id" FROM "product_template" WHERE "product_template".id IN (40, 1) | |
| 2020-03-24 09:07:14,436 20746 DEBUG ems_development odoo.sql_db: query: SELECT "product_template_attribute_line".id FROM "product_template_attribute_line" LEFT JOIN "product_attribute" as "product_template_attribute_line__attribute_id" ON ("product_template_attribute_line"."attribute_id" = "product_template_attribute_line__attribute_id"."id") WHERE ("product_template_attribute_line"."product_tmpl_id" in (1,40)) ORDER BY "product_template_attribute_line__attribute_id"."sequence" ,"product_template_attribute_line__attribute_id"."id" ,"product_template_attribute_line"."id" | |
| 2020-03-24 09:07:14,452 20746 DEBUG ems_development odoo.sql_db: query: SELECT "account_invoice"."id" as "id","account_invoice"."commercial_partner_id" as "commercial_partner_id","account_invoice"."comment" as "comment","account_invoice"."partner_id" as "partner_id","account_invoice"."amount_total" as "amount_total","account_invoice"."journal_id" as "journal_id","account_invoice"."access_token" as "access_token","account_invoice"."write_date" as "write_date","account_invoice"."amount_untaxed" as "amount_untaxed","account_invoice"."residual_company_signed" as "residual_company_signed","account_invoice"."move_name" as "move_name","account_invoice"."attn" as "attn","account_invoice"."signature" as "signature","account_invoice"."cash_rounding_id" as "cash_rounding_id","account_invoice"."sent" as "sent","account_invoice"."amount_total_signed" as "amount_total_signed","account_invoice"."vendor_bill_id" as "vendor_bill_id","account_invoice"."company_id" as "company_id","account_invoice"."create_uid" as "create_uid","account_invoice"."amount_untaxed_signed" as "amount_untaxed_signed","account_invoice"."reference" as "reference","account_invoice"."date_invoice" as "date_invoice","account_invoice"."move_id" as "move_id","account_invoice"."name" as "name","account_invoice"."amount_total_company_signed" as "amount_total_company_signed","account_invoice"."payment_term_id" as "payment_term_id","account_invoice"."partner_bank_id" as "partner_bank_id","account_invoice"."incoterm_id" as "incoterm_id","account_invoice"."source_email" as "source_email","account_invoice"."write_uid" as "write_uid","account_invoice"."state" as "state","account_invoice"."date_due" as "date_due","account_invoice"."reconciled" as "reconciled","account_invoice"."refund_invoice_id" as "refund_invoice_id","account_invoice"."origin" as "origin","account_invoice"."currency_id" as "currency_id","account_invoice"."account_id" as "account_id","account_invoice"."user_id" as "user_id","account_invoice"."vendor_display_name" as "vendor_display_name","account_invoice"."journal_bank_id" as "journal_bank_id","account_invoice"."amount_tax" as "amount_tax","account_invoice"."date" as "date","account_invoice"."residual" as "residual","account_invoice"."type" as "type","account_invoice"."course_id" as "course_id","account_invoice"."fiscal_position_id" as "fiscal_position_id","account_invoice"."message_main_attachment_id" as "message_main_attachment_id","account_invoice"."create_date" as "create_date","account_invoice"."residual_signed" as "residual_signed","account_invoice"."number" as "number" FROM "account_invoice" WHERE "account_invoice".id IN (887, 1988, 3831, 6446, 2927, 4727, 7673, 5595) | |
| 2020-03-24 09:07:14,480 20746 DEBUG ems_development odoo.sql_db: query: SELECT "op_student_fees_details"."id" as "id","op_student_fees_details"."student_id" as "student_id","op_student_fees_details"."create_date" as "create_date","op_student_fees_details"."amount" as "amount","op_student_fees_details"."write_uid" as "write_uid","op_student_fees_details"."product_id" as "product_id","op_student_fees_details"."create_uid" as "create_uid","op_student_fees_details"."invoice_id" as "invoice_id","op_student_fees_details"."discount_amt" as "discount_amt","op_student_fees_details"."state" as "state","op_student_fees_details"."course_id" as "course_id","op_student_fees_details"."disc_prod_id" as "disc_prod_id","op_student_fees_details"."write_date" as "write_date","op_student_fees_details"."date" as "date" FROM "op_student_fees_details" WHERE "op_student_fees_details".id IN (13412, 13400, 13401, 13402, 13403, 13404, 13405, 13406) | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: SQL LOG from: | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: table: res_users: 0:00:00.000450/1 | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: table: product_template: 0:00:00.000463/1 | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: table: product_template_attribute_line: 0:00:00.000923/1 | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: table: account_invoice: 0:00:00.000936/1 | |
| 2020-03-24 09:07:14,494 20746 DEBUG ems_development odoo.sql_db: table: op_course: 0:00:00.000950/1 | |
| 2020-03-24 09:07:14,495 20746 DEBUG ems_development odoo.sql_db: table: op_student_fees_details: 0:00:00.002482/2 | |
| 2020-03-24 09:07:14,495 20746 DEBUG ems_development odoo.sql_db: table: ir_rule: 0:00:00.010708/2 | |
| 2020-03-24 09:07:14,495 20746 DEBUG ems_development odoo.sql_db: SUM from:0:00:00.016912/14 [3033] | |
| 2020-03-24 09:07:14,495 20746 DEBUG ems_development odoo.sql_db: SUM into:0:00:00/14 [3033] | |
| 2020-03-24 09:07:14,495 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'sslmode=prefer dbname=ems_development' | |
| 2020-03-24 09:07:14,496 20746 DEBUG ems_development odoo.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'sslmode=prefer dbname=ems_development' in pool | |
| 2020-03-24 09:07:14,496 20746 INFO ems_development werkzeug: 127.0.0.1 - - [24/Mar/2020 09:07:14] "POST /web/dataset/call_kw/op.student.fees.details/read HTTP/1.1" 200 - 15 0.045 0.117 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment