Created
October 4, 2014 04:57
-
-
Save lukebranch/bc7b0ac6aa3c4f95a422 to your computer and use it in GitHub Desktop.
debug_sql for https://github.com/odoo/odoo/issues/2887
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
| 2014-10-04 04:43:35,131 13002 INFO ? openerp: OpenERP version 8.0 | |
| 2014-10-04 04:43:35,131 13002 INFO ? openerp: addons paths: ['/opt/odoo/.local/share/Odoo/addons/8.0', u'/opt/odoo/odoo-server/addons', u'/opt/odoo/custom/addons', u'/opt/odoo/custom/aeroo_reports/report_aeroo', u'/opt/odoo/custom/aeroo_reports/report_aeroo_ooo', u'/opt/odoo/custom/aeroo_reports/report_aeroo_sample', u'/opt/odoo/custom/server-tools', u'/opt/odoo/custom/community-management', '/opt/odoo/odoo-server/openerp/addons'] | |
| 2014-10-04 04:43:35,131 13002 INFO ? openerp: database hostname: localhost | |
| 2014-10-04 04:43:35,131 13002 INFO ? openerp: database port: 5432 | |
| 2014-10-04 04:43:35,131 13002 INFO ? openerp: database user: odoo | |
| 2014-10-04 04:43:35,226 13002 INFO ? openerp.service.server: Evented Service (longpolling) running on 0.0.0.0:8072 | |
| 2014-10-04 04:43:35,735 13002 INFO ? openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf | |
| 2014-10-04 04:43:35,736 13002 INFO ? openerp.addons.bus.bus: Bus.loop listen imbus on db postgres | |
| 2014-10-04 04:43:35,736 13002 DEBUG ? openerp.sql_db: create serialized cursor to 'user=odoo dbname=postgres' | |
| 2014-10-04 04:43:35,736 13002 DEBUG ? openerp.sql_db: ConnectionPool(used=0/count=0/max=64) Borrow connection to 'user=odoo dbname=postgres' | |
| 2014-10-04 04:43:35,740 13002 DEBUG ? openerp.sql_db: ConnectionPool(used=1/count=1/max=64) Create new connection | |
| 2014-10-04 04:43:35,741 13002 DEBUG ? openerp.sql_db: query: listen imbus | |
| 2014-10-04 04:43:35,745 13002 INFO ? openerp.addons.report.models.report: Upgrade Wkhtmltopdf to (at least) 0.12.0 | |
| 2014-10-04 04:43:35,860 13002 INFO ? openerp.http: HTTP Configuring static files | |
| 2014-10-04 04:43:35,877 13002 INFO test openerp.modules.loading: loading 1 modules... | |
| 2014-10-04 04:43:36,881 13002 INFO test openerp.modules.loading: 1 modules loaded in 0.26s, 0 queries | |
| 2014-10-04 04:43:37,003 13002 INFO test openerp.modules.loading: loading 192 modules... | |
| 2014-10-04 04:43:37,050 13002 ERROR test openerp.addons.hw_scale.controllers.main: Odoo module hw_scale depends on the pyserial python module | |
| 2014-10-04 04:43:37,052 13002 ERROR test openerp.addons.hw_scanner.controllers.main: Odoo module hw_scanner depends on the evdev python module | |
| 2014-10-04 04:43:41,247 13002 INFO test openerp.modules.loading: 192 modules loaded in 4.24s, 0 queries | |
| 2014-10-04 04:43:41,460 13002 INFO test openerp.modules.loading: Modules loaded. | |
| 2014-10-04 04:43:41,466 13002 INFO test openerp.addons.base.ir.ir_http: Generating routing map | |
| 2014-10-04 04:43:41,478 13002 INFO testingpricelist openerp.modules.loading: loading 1 modules... | |
| 2014-10-04 04:43:41,637 13002 INFO testingpricelist openerp.modules.loading: 1 modules loaded in 0.16s, 0 queries | |
| 2014-10-04 04:43:41,662 13002 INFO testingpricelist openerp.modules.loading: loading 41 modules... | |
| 2014-10-04 04:43:42,626 13002 INFO testingpricelist openerp.modules.loading: 41 modules loaded in 0.96s, 0 queries | |
| 2014-10-04 04:43:42,710 13002 INFO testingpricelist openerp.modules.loading: Modules loaded. | |
| 2014-10-04 04:43:42,712 13002 INFO testingpricelist openerp.addons.base.ir.ir_http: Generating routing map | |
| 2014-10-04 04:43:42,712 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,712 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=3/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,714 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=3/count=3/max=64) Existing connection found at index 2 | |
| 2014-10-04 04:43:42,715 13002 DEBUG test openerp.sql_db: query: SELECT "ir_module_module".id FROM "ir_module_module" WHERE (("ir_module_module"."state" = 'installed') AND ("ir_module_module"."name" != 'web')) ORDER BY "ir_module_module"."sequence" ,"ir_module_module"."name" | |
| 2014-10-04 04:43:42,720 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_module_module".id FROM "ir_module_module" WHERE (("ir_module_module"."state" = 'installed') AND ("ir_module_module"."name" != 'web')) ORDER BY "ir_module_module"."sequence" ,"ir_module_module"."name" | |
| 2014-10-04 04:43:42,721 13002 DEBUG test openerp.sql_db: query: SELECT ir_module_module."name",ir_module_module."id" FROM "ir_module_module" | |
| WHERE ir_module_module.id IN (2, 3, 4, 5, 6, 7, 8, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 28, 29, 30, 31, 32, 33, 34, 35, 38, 39, 41, 42, 43, 44, 45, 46, 47, 48, 50, 51, 52, 53, 55, 56, 57, 58, 59, 60, 62, 64, 65, 66, 67, 68, 69, 70, 71, 72, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 87, 92, 93, 94, 95, 96, 97, 100, 101, 103, 104, 106, 107, 108, 110, 111, 112, 114, 115, 116, 118, 120, 122, 125, 128, 129, 134, 135, 136, 137, 139, 140, 141, 143, 144, 147, 150, 152, 153, 159, 160, 161, 163, 164, 165, 166, 167, 169, 171, 172, 174, 175, 178, 179, 181, 183, 184, 186, 189, 190, 191, 192, 195, 196, 198, 199, 200, 201, 202, 204, 206, 208, 209, 210, 211, 213, 215, 217, 218, 219, 221, 223, 224, 225, 226, 227, 229, 230, 231, 232, 234, 235, 236, 237, 239, 241, 242, 243, 244, 245, 249, 250, 251, 252, 254, 256, 257, 258, 259, 260, 261, 262, 263, 266, 268, 269, 270, 271, 273, 274, 275, 276) AND (TRUE) | |
| ORDER BY sequence,name | |
| 2014-10-04 04:43:42,880 13002 DEBUG test openerp.sql_db: create serialized cursor to u'user=odoo dbname=test' | |
| 2014-10-04 04:43:42,880 13002 DEBUG test openerp.sql_db: ConnectionPool(used=3/count=3/max=64) Borrow connection to u'user=odoo dbname=test' | |
| 2014-10-04 04:43:42,881 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_module_module."name",ir_module_module."id" FROM "ir_module_module" | |
| WHERE ir_module_module.id IN (260, 5, 262, 9, 275, 276, 21, 22, 279, 24, 288, 34, 38, 296, 41, 173, 48, 177, 115, 55, 184, 185, 191, 192, 160, 194, 32, 202, 78, 209, 212, 225, 102, 242, 243, 116, 121, 122, 125, 254) AND (TRUE) | |
| ORDER BY sequence,name | |
| 2014-10-04 04:43:42,919 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'base') AND ("ir_model_data"."name" = 'public_user')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:42,920 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (1466) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:42,920 13002 DEBUG test openerp.sql_db: ConnectionPool(used=4/count=4/max=64) Create new connection | |
| 2014-10-04 04:43:42,921 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:42,921 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_data: 0:00:00.001112/1 | |
| 2014-10-04 04:43:42,921 13002 DEBUG testingpricelist openerp.sql_db: table: ir_module_module: 0:00:00.005059/1 | |
| 2014-10-04 04:43:42,921 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.006171/4 [47] | |
| 2014-10-04 04:43:42,921 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/4 [47] | |
| 2014-10-04 04:43:42,922 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=4/count=4/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,922 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=3/count=4/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:43:42,922 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,922 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=3/count=4/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,922 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=4/count=4/max=64) Existing connection found at index 3 | |
| 2014-10-04 04:43:42,924 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:42:52') AND FALSE) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: table: bus_bus: 0:00:00.000879/1 | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.000879/1 [48] | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/1 [48] | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=4/count=4/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:42,925 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=3/count=4/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:43:42,947 13002 DEBUG test openerp.sql_db: query: SELECT password, password_crypt FROM res_users WHERE id=1 AND active | |
| 2014-10-04 04:43:42,949 13002 DEBUG test openerp.sql_db: query: SELECT "res_users".id FROM "res_users" WHERE ((("res_users"."active" = true) AND "res_users".id = 1) AND ("res_users"."password" = 'P5413536')) ORDER BY "res_users"."id" | |
| 2014-10-04 04:43:43,083 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:43,083 13002 DEBUG test openerp.sql_db: table: res_users: 0:00:00.025985/2 | |
| 2014-10-04 04:43:43,083 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.025985/2 [50] | |
| 2014-10-04 04:43:43,083 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/2 [50] | |
| 2014-10-04 04:43:43,084 13002 DEBUG test openerp.sql_db: ConnectionPool(used=3/count=4/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:43:43,084 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:43:43,087 13002 DEBUG test openerp.sql_db: query: SELECT "im_chat_presence".id FROM "im_chat_presence" WHERE ("im_chat_presence"."user_id" = 1) ORDER BY "im_chat_presence"."id" | |
| 2014-10-04 04:43:43,088 13002 DEBUG test openerp.sql_db: query: SELECT im_chat_presence."status",im_chat_presence."create_uid",im_chat_presence."create_date",im_chat_presence."user_id",im_chat_presence."last_presence",im_chat_presence."write_uid",im_chat_presence."write_date",im_chat_presence."last_poll",im_chat_presence."id" FROM "im_chat_presence" | |
| WHERE im_chat_presence.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:43,094 13002 DEBUG test openerp.sql_db: query: update im_chat_presence set "status"='online',"last_poll"='2014-10-04 04:43:43',"last_presence"='2014-10-04 04:43:43',write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1) | |
| 2014-10-04 04:43:43,096 13002 DEBUG test openerp.sql_db: query: select id from wkf_instance where res_id=1 and res_type='im_chat.presence' and state='active' | |
| 2014-10-04 04:43:43,097 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: table: wkf_instance: 0:00:00.000745/1 | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: table: im_chat_presence: 0:00:00.001322/1 | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: table: ir_module_module: 0:00:00.002324/1 | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.004391/6 [56] | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/6 [56] | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: create serialized cursor to u'user=odoo dbname=test' | |
| 2014-10-04 04:43:43,098 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=4/max=64) Borrow connection to u'user=odoo dbname=test' | |
| 2014-10-04 04:43:43,099 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Existing connection found at index 2 | |
| 2014-10-04 04:43:43,102 13002 DEBUG test openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:42:53') AND ("bus_bus"."channel" in ('["test","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:43:43,102 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:43,102 13002 DEBUG test openerp.sql_db: table: bus_bus: 0:00:00.001138/1 | |
| 2014-10-04 04:43:43,102 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.001138/1 [57] | |
| 2014-10-04 04:43:43,102 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/1 [57] | |
| 2014-10-04 04:43:43,103 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:43:43,103 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:43:57,275 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:57,275 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=4/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:57,279 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Existing connection found at index 1 | |
| 2014-10-04 04:43:57,283 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'website' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,284 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'website' AND a.active IS True | |
| 2014-10-04 04:43:57,286 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'website' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:43:57,286 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."id" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,288 13002 DEBUG testingpricelist openerp.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 is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:43:57,289 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_lang_rel.lang_id, website_lang_rel.website_id FROM website_lang_rel, "res_lang" WHERE website_lang_rel.website_id IN (1) AND website_lang_rel.lang_id = res_lang.id AND ("res_lang"."active" = true) ORDER BY "res_lang".id OFFSET 0 | |
| 2014-10-04 04:43:57,291 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'res.lang' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,291 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'res.lang' AND a.active IS True | |
| 2014-10-04 04:43:57,292 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_lang."date_format",res_lang."direction",res_lang."code",res_lang."create_date",res_lang."name",res_lang."create_uid",res_lang."thousands_sep",res_lang."translatable",res_lang."write_uid",res_lang."time_format",res_lang."write_date",res_lang."decimal_point",res_lang."active",res_lang."iso_code",res_lang."id",res_lang."grouping" FROM "res_lang" | |
| WHERE res_lang.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,294 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."menu_id",website."create_uid",website."create_date",website."social_linkedin",website."name",website."default_lang_id",website."default_lang_code",website."social_googleplus",website."company_id",website."write_uid",website."google_analytics_key",website."social_github",website."write_date",website."social_facebook",website."user_id",website."id",website."social_youtube",website."social_twitter" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,298 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.model.data' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,299 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.model.data' AND a.active IS True | |
| 2014-10-04 04:43:57,301 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'ir.model.data' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:43:57,302 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'main_menu')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,303 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4225) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,304 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT id FROM "website_menu" WHERE id IN (1) | |
| 2014-10-04 04:43:57,305 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'website.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,305 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'website.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,306 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'website.menu' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:43:57,307 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,308 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "website_menu".id FROM "website_menu" WHERE ("website_menu"."parent_id" in (1)) ORDER BY "website_menu"."sequence" | |
| 2014-10-04 04:43:57,308 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."parent_id",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,310 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."create_uid",website_menu."parent_right",website_menu."create_date",website_menu."name",website_menu."sequence",website_menu."url",website_menu."parent_left",website_menu."website_id",website_menu."write_uid",website_menu."parent_id",website_menu."new_window",website_menu."write_date",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1, 2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,312 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."id" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,313 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_lang_rel.lang_id, website_lang_rel.website_id FROM website_lang_rel, "res_lang" WHERE website_lang_rel.website_id IN (1) AND website_lang_rel.lang_id = res_lang.id AND ("res_lang"."active" = true) ORDER BY "res_lang".id OFFSET 0 | |
| 2014-10-04 04:43:57,314 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_lang."date_format",res_lang."direction",res_lang."code",res_lang."create_date",res_lang."name",res_lang."create_uid",res_lang."thousands_sep",res_lang."translatable",res_lang."write_uid",res_lang."time_format",res_lang."write_date",res_lang."decimal_point",res_lang."active",res_lang."iso_code",res_lang."id",res_lang."grouping" FROM "res_lang" | |
| WHERE res_lang.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,317 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'homepage')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,317 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4276) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,319 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,320 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,321 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,322 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,323 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT 1 FROM res_groups_users_rel WHERE uid=3 AND gid IN | |
| (SELECT res_id FROM ir_model_data WHERE module='base' AND name='group_website_publisher') | |
| 2014-10-04 04:43:57,324 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,325 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,326 13002 DEBUG testingpricelist openerp.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 is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:43:57,327 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (350) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,328 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (350) | |
| 2014-10-04 04:43:57,329 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (350) | |
| 2014-10-04 04:43:57,329 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (350) | |
| 2014-10-04 04:43:57,331 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (350) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,333 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,334 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_groups" WHERE res_groups_users_rel.uid IN (3) AND res_groups_users_rel.gid = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:43:57,336 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 350) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,338 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'layout')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,338 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4250) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,339 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (324) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,340 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (324) | |
| 2014-10-04 04:43:57,341 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (324) | |
| 2014-10-04 04:43:57,341 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (324) | |
| 2014-10-04 04:43:57,342 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (324) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,344 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 324) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,345 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (675, 325, 326, 327, 330, 331, 377) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,346 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view_group_rel.group_id, ir_ui_view_group_rel.view_id FROM ir_ui_view_group_rel, "res_groups" WHERE ir_ui_view_group_rel.view_id IN (327, 331, 325, 675, 326, 330, 377) AND ir_ui_view_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:43:57,347 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (675, 325, 326, 327, 330, 331, 377) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,348 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (327, 331, 325, 675, 326, 330, 377) | |
| 2014-10-04 04:43:57,349 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (327, 331, 325, 675, 326, 330, 377) | |
| 2014-10-04 04:43:57,350 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (327, 331, 325, 675, 326, 330, 377) | |
| 2014-10-04 04:43:57,353 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 331) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,354 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (324, 332) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,355 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view_group_rel.group_id, ir_ui_view_group_rel.view_id FROM ir_ui_view_group_rel, "res_groups" WHERE ir_ui_view_group_rel.view_id IN (332, 324) AND ir_ui_view_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:43:57,356 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (324, 332) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,357 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (332) | |
| 2014-10-04 04:43:57,358 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (332) | |
| 2014-10-04 04:43:57,359 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (332) | |
| 2014-10-04 04:43:57,361 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 332) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,362 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 325) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,363 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 675) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,364 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 326) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,366 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 330) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,368 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Toggle navigation' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,369 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='My cart' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,369 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='My Account' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,370 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Logout' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,371 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Sign in' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,372 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Our products & Services' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,372 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Home' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,373 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Connect with us' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,374 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Contact us' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,375 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='About us' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,375 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='We are a team of passionate people whose goal is to improve everyone''s | |
| life through disruptive products. We build great products to solve your | |
| business problems.' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,376 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Our products are designed for small to medium size companies willing to optimize | |
| their performance.' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,377 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Add a language...' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,378 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Powered by' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,378 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Odoo' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,379 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src=', | |
| the #1' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,379 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Open Source eCommerce' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,452 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Company name' AND res_id=324 AND name='website' | |
| 2014-10-04 04:43:57,457 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_company."sale_note",res_company."rml_footer",res_company."create_date",res_company."rml_header",res_company."rml_paper_format",res_company."write_uid",res_company."currency_id",res_company."font",res_company."partner_id",res_company."expects_chart_of_accounts",res_company."account_no",res_company."create_uid",res_company."expense_currency_exchange_account_id",res_company."id",res_company."parent_id",res_company."paperformat_id",res_company."email",res_company."custom_footer",res_company."phone",res_company."rml_header2",res_company."rml_header3",res_company."write_date",res_company."rml_header1",res_company."company_registry",res_company."paypal_account",res_company."name",res_company."overdue_msg",res_company."tax_calculation_rounding_method",res_company."income_currency_exchange_account_id" FROM "res_company" | |
| WHERE res_company.id IN (1) AND (TRUE) | |
| ORDER BY name | |
| 2014-10-04 04:43:57,458 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='res.company,sale_note' and res_id IN (1) | |
| 2014-10-04 04:43:57,459 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='res.company,overdue_msg' and res_id IN (1) | |
| 2014-10-04 04:43:57,463 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,464 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,465 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,466 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,467 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'web') AND ("ir_model_data"."name" = 'assets_common')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,468 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (2614) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,470 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (161) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,471 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (161) | |
| 2014-10-04 04:43:57,472 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (161) | |
| 2014-10-04 04:43:57,474 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (161) | |
| 2014-10-04 04:43:57,475 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (161) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,477 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:43:57,477 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_groups" WHERE res_groups_users_rel.uid IN (3) AND res_groups_users_rel.gid = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:43:57,479 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 161) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,483 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,484 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,486 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,489 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,490 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'assets_frontend')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,491 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4247) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,492 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (321) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,493 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (321) | |
| 2014-10-04 04:43:57,494 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (321) | |
| 2014-10-04 04:43:57,495 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (321) | |
| 2014-10-04 04:43:57,497 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (321) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,499 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 321) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,501 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (673, 598) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,502 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view_group_rel.group_id, ir_ui_view_group_rel.view_id FROM ir_ui_view_group_rel, "res_groups" WHERE ir_ui_view_group_rel.view_id IN (598, 673) AND ir_ui_view_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:43:57,504 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (673, 598) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,504 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (598, 673) | |
| 2014-10-04 04:43:57,505 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (598, 673) | |
| 2014-10-04 04:43:57,506 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (598, 673) | |
| 2014-10-04 04:43:57,508 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 598) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,510 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 673) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,512 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'theme')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,513 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4246) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,514 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (320) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,515 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (320) | |
| 2014-10-04 04:43:57,516 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (320) | |
| 2014-10-04 04:43:57,517 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (320) | |
| 2014-10-04 04:43:57,518 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (320) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,520 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 320) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,526 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,527 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "website_menu".id FROM "website_menu" WHERE ("website_menu"."parent_id" in (1)) ORDER BY "website_menu"."sequence" | |
| 2014-10-04 04:43:57,529 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."parent_id",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,531 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'submenu')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:43:57,532 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4249) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:43:57,533 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (161, 323, 321) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,534 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (323) | |
| 2014-10-04 04:43:57,536 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (323) | |
| 2014-10-04 04:43:57,536 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (323) | |
| 2014-10-04 04:43:57,538 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (323) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:43:57,540 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 323) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:43:57,542 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."create_uid",website_menu."parent_right",website_menu."create_date",website_menu."name",website_menu."sequence",website_menu."url",website_menu."parent_left",website_menu."website_id",website_menu."write_uid",website_menu."parent_id",website_menu."new_window",website_menu."write_date",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1, 2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,542 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='website.menu,name' and res_id IN (1, 2, 4, 3) | |
| 2014-10-04 04:43:57,544 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:43:57,545 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "website_menu".id FROM "website_menu" WHERE ("website_menu"."parent_id" in (2,4,3)) ORDER BY "website_menu"."sequence" | |
| 2014-10-04 04:43:57,551 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,552 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,553 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,554 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,558 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,559 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:43:57,560 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:43:57,561 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:43:57,564 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:43:57,564 13002 DEBUG testingpricelist openerp.sql_db: table: website_menu: 0:00:00.002022/4 | |
| 2014-10-04 04:43:57,565 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_data: 0:00:00.005053/7 | |
| 2014-10-04 04:43:57,565 13002 DEBUG testingpricelist openerp.sql_db: table: ir_ui_view: 0:00:00.008520/14 | |
| 2014-10-04 04:43:57,565 13002 DEBUG testingpricelist openerp.sql_db: table: ir_translation: 0:00:00.018678/30 | |
| 2014-10-04 04:43:57,565 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_access: 0:00:00.027959/30 | |
| 2014-10-04 04:43:57,565 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.062232/157 [214] | |
| 2014-10-04 04:43:57,566 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/157 [214] | |
| 2014-10-04 04:43:57,566 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=4/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:43:57,566 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=4/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:43:58,674 13002 INFO AsiaElectricTest openerp.modules.loading: loading 1 modules... | |
| 2014-10-04 04:43:58,886 13002 INFO AsiaElectricTest openerp.modules.loading: 1 modules loaded in 0.21s, 0 queries | |
| 2014-10-04 04:43:58,889 13002 WARNING AsiaElectricTest openerp.modules.module: module website_issue: module not found | |
| 2014-10-04 04:43:58,890 13002 WARNING AsiaElectricTest openerp.modules.graph: module website_issue: not installable, skipped | |
| 2014-10-04 04:43:58,891 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_mail: module not found | |
| 2014-10-04 04:43:58,892 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_mail: not installable, skipped | |
| 2014-10-04 04:43:58,892 13002 WARNING AsiaElectricTest openerp.modules.module: module server_environment_files: module not found | |
| 2014-10-04 04:43:58,893 13002 WARNING AsiaElectricTest openerp.modules.graph: module server_environment_files: not installable, skipped | |
| 2014-10-04 04:43:58,896 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_base: module not found | |
| 2014-10-04 04:43:58,896 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_base: not installable, skipped | |
| 2014-10-04 04:43:58,900 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_document: module not found | |
| 2014-10-04 04:43:58,900 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_document: not installable, skipped | |
| 2014-10-04 04:43:58,904 13002 WARNING AsiaElectricTest openerp.modules.module: module login_serial: module not found | |
| 2014-10-04 04:43:58,905 13002 WARNING AsiaElectricTest openerp.modules.graph: module login_serial: not installable, skipped | |
| 2014-10-04 04:43:58,921 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_address: module not found | |
| 2014-10-04 04:43:58,921 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_address: not installable, skipped | |
| 2014-10-04 04:43:58,927 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_project_issue: module not found | |
| 2014-10-04 04:43:58,927 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_project_issue: not installable, skipped | |
| 2014-10-04 04:43:58,931 13002 WARNING AsiaElectricTest openerp.modules.module: module fts_project: module not found | |
| 2014-10-04 04:43:58,932 13002 WARNING AsiaElectricTest openerp.modules.graph: module fts_project: not installable, skipped | |
| 2014-10-04 04:43:59,028 13002 WARNING AsiaElectricTest openerp.modules.graph: Some modules were not loaded. | |
| 2014-10-04 04:43:59,029 13002 INFO AsiaElectricTest openerp.modules.loading: loading 182 modules... | |
| 2014-10-04 04:44:03,180 13002 INFO AsiaElectricTest openerp.modules.loading: 182 modules loaded in 4.15s, 0 queries | |
| 2014-10-04 04:44:03,388 13002 INFO AsiaElectricTest openerp.modules.loading: Modules loaded. | |
| 2014-10-04 04:44:03,394 13002 INFO AsiaElectricTest openerp.addons.base.ir.ir_http: Generating routing map | |
| 2014-10-04 04:44:03,395 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:03,395 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=5/max=64) Existing connection found at index 4 | |
| 2014-10-04 04:44:03,395 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=5/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:03,397 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=3/count=5/max=64) Existing connection found at index 3 | |
| 2014-10-04 04:44:03,399 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."id" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,400 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_lang_rel.lang_id, website_lang_rel.website_id FROM website_lang_rel, "res_lang" WHERE website_lang_rel.website_id IN (1) AND website_lang_rel.lang_id = res_lang.id AND ("res_lang"."active" = true) ORDER BY "res_lang".id OFFSET 0 | |
| 2014-10-04 04:44:03,401 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_lang."date_format",res_lang."direction",res_lang."code",res_lang."create_date",res_lang."name",res_lang."create_uid",res_lang."thousands_sep",res_lang."translatable",res_lang."write_uid",res_lang."time_format",res_lang."write_date",res_lang."decimal_point",res_lang."active",res_lang."iso_code",res_lang."id",res_lang."grouping" FROM "res_lang" | |
| WHERE res_lang.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,403 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."menu_id",website."create_uid",website."create_date",website."social_linkedin",website."name",website."default_lang_id",website."default_lang_code",website."social_googleplus",website."company_id",website."write_uid",website."google_analytics_key",website."social_github",website."write_date",website."social_facebook",website."user_id",website."id",website."social_youtube",website."social_twitter" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,406 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."password_crypt",res_users."create_uid",res_users."create_date",res_users."alias_id",res_users."default_section_id",res_users."share",res_users."company_id",res_users."write_uid",res_users."display_groups_suggestions",res_users."write_date",res_users."signature",res_users."active",res_users."login_date",res_users."login",res_users."password",res_users."partner_id",res_users."id",res_users."action_id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,407 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_partner."id" FROM "res_partner" | |
| WHERE res_partner.id IN (4) AND (TRUE) | |
| ORDER BY display_name | |
| 2014-10-04 04:44:03,408 13002 DEBUG testingpricelist openerp.sql_db: query: select id from ir_model_fields where name='property_product_pricelist' and model='res.partner' | |
| 2014-10-04 04:44:03,410 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model".id FROM "ir_model" WHERE ("ir_model"."model" = 'res.partner') ORDER BY "ir_model"."model" | |
| 2014-10-04 04:44:03,411 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "ir_module_module".id FROM "ir_module_module" WHERE (("ir_module_module"."state" = 'installed') AND ("ir_module_module"."name" != 'web')) ORDER BY "ir_module_module"."sequence" ,"ir_module_module"."name" | |
| 2014-10-04 04:44:03,412 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "multi_company_default".id FROM "multi_company_default" LEFT JOIN "res_company" as "multi_company_default__company_id" ON ("multi_company_default"."company_id" = "multi_company_default__company_id"."id") WHERE (("multi_company_default"."object_id" in (78)) AND ("multi_company_default"."field_id" = 1807)) ORDER BY "multi_company_default__company_id"."name" ,"multi_company_default"."sequence" ,"multi_company_default"."id" | |
| 2014-10-04 04:44:03,413 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."password_crypt",res_users."create_uid",res_users."create_date",res_users."alias_id",res_users."default_section_id",res_users."share",res_users."company_id",res_users."write_uid",res_users."display_groups_suggestions",res_users."write_date",res_users."signature",res_users."active",res_users."login_date",res_users."login",res_users."password",res_users."partner_id",res_users."id",res_users."action_id" FROM "res_users" | |
| WHERE res_users.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,414 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT ir_module_module."name",ir_module_module."id" FROM "ir_module_module" | |
| WHERE ir_module_module.id IN (2, 3, 4, 5, 7, 8, 9, 10, 13, 15, 18, 19, 20, 21, 25, 26, 28, 31, 32, 33, 34, 35, 36, 37, 39, 40, 41, 43, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 59, 60, 61, 62, 63, 64, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 88, 90, 92, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 108, 109, 110, 112, 113, 114, 118, 119, 121, 127, 128, 133, 134, 135, 136, 138, 139, 142, 145, 148, 149, 151, 156, 157, 159, 160, 161, 162, 163, 164, 167, 169, 170, 171, 175, 176, 177, 178, 179, 181, 182, 187, 188, 190, 191, 193, 194, 195, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 213, 215, 216, 217, 219, 220, 221, 222, 225, 226, 227, 228, 229, 230, 231, 232, 233, 236, 238, 239, 240, 241, 242, 246, 248, 250, 252, 253, 254, 255, 256, 259, 260, 261, 266, 267, 268, 269, 270, 271, 272, 273, 274, 393, 394, 395, 396, 397, 398, 399, 400, 409) AND (TRUE) | |
| ORDER BY sequence,name | |
| 2014-10-04 04:44:03,877 13002 DEBUG AsiaElectricTest openerp.sql_db: create serialized cursor to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:03,877 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=3/count=5/max=64) Borrow connection to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:03,877 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_property".id FROM "ir_property" LEFT JOIN "res_company" as "ir_property__company_id" ON ("ir_property"."company_id" = "ir_property__company_id"."id") WHERE ((("ir_property"."fields_id" = 1807) AND (("ir_property"."company_id" in (1)) OR "ir_property"."company_id" IS NULL)) AND (("ir_property"."res_id" in ('res.partner,4')) OR "ir_property"."res_id" IS NULL)) ORDER BY "ir_property__company_id"."name" asc | |
| 2014-10-04 04:44:03,879 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_property."value_text",ir_property."value_float",ir_property."create_date",ir_property."name",ir_property."create_uid",ir_property."type",ir_property."company_id",ir_property."write_uid",ir_property."fields_id",ir_property."value_datetime",ir_property."write_date",ir_property."value_reference",ir_property."value_integer",ir_property."res_id",ir_property."id" FROM "ir_property" | |
| WHERE ir_property.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:03,880 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT id FROM "product_pricelist" WHERE id IN (1) | |
| 2014-10-04 04:44:03,881 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=4/count=6/max=64) Create new connection | |
| 2014-10-04 04:44:03,881 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist."create_uid",product_pricelist."code",product_pricelist."create_date",product_pricelist."name",product_pricelist."company_id",product_pricelist."write_uid",product_pricelist."currency_id",product_pricelist."write_date",product_pricelist."active",product_pricelist."type",product_pricelist."id" FROM "product_pricelist" | |
| WHERE product_pricelist.id IN (1) AND (TRUE) | |
| ORDER BY name | |
| 2014-10-04 04:44:03,882 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.pricelist,name' and res_id IN (1) | |
| 2014-10-04 04:44:03,884 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_currency."create_uid",res_currency."create_date",res_currency."name",res_currency."rounding",res_currency."symbol",res_currency."company_id",res_currency."write_uid",res_currency."base",res_currency."write_date",res_currency."active",res_currency."position",res_currency."id",res_currency."accuracy" FROM "res_currency" | |
| WHERE res_currency.id IN (3) AND (TRUE) | |
| ORDER BY name | |
| 2014-10-04 04:44:03,886 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.template' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:03,887 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.template' AND a.active IS True | |
| 2014-10-04 04:44:03,887 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT password, password_crypt FROM res_users WHERE id=1 AND active | |
| 2014-10-04 04:44:03,888 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.template' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:03,889 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "res_users".id FROM "res_users" WHERE ((("res_users"."active" = true) AND "res_users".id = 1) AND ("res_users"."password" = 'P5413536')) ORDER BY "res_users"."id" | |
| 2014-10-04 04:44:04,030 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:04,031 13002 DEBUG AsiaElectricTest openerp.sql_db: table: res_users: 0:00:00.005261/2 | |
| 2014-10-04 04:44:04,031 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.005261/2 [239] | |
| 2014-10-04 04:44:04,031 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/2 [239] | |
| 2014-10-04 04:44:04,032 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.rule' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,032 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=4/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:04,032 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=3/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool | |
| 2014-10-04 04:44:04,032 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.rule' AND a.active IS True | |
| 2014-10-04 04:44:04,033 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'ir.rule' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,034 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (22) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,035 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "im_chat_presence".id FROM "im_chat_presence" WHERE ("im_chat_presence"."user_id" = 1) ORDER BY "im_chat_presence"."id" | |
| 2014-10-04 04:44:04,036 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."model_id",ir_rule."domain_force",ir_rule."name",ir_rule."create_uid",ir_rule."global",ir_rule."write_uid",ir_rule."active",ir_rule."create_date",ir_rule."write_date",ir_rule."perm_unlink",ir_rule."perm_write",ir_rule."perm_read",ir_rule."perm_create",ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (22) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,037 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT im_chat_presence."status",im_chat_presence."create_uid",im_chat_presence."create_date",im_chat_presence."user_id",im_chat_presence."last_presence",im_chat_presence."write_uid",im_chat_presence."write_date",im_chat_presence."last_poll",im_chat_presence."id" FROM "im_chat_presence" | |
| WHERE im_chat_presence.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,039 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."password_crypt",res_users."create_uid",res_users."create_date",res_users."alias_id",res_users."default_section_id",res_users."share",res_users."company_id",res_users."write_uid",res_users."display_groups_suggestions",res_users."write_date",res_users."signature",res_users."active",res_users."login_date",res_users."login",res_users."password",res_users."partner_id",res_users."id",res_users."action_id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,040 13002 DEBUG AsiaElectricTest openerp.sql_db: query: update im_chat_presence set "status"='away',"last_poll"='2014-10-04 04:44:04',write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1) | |
| 2014-10-04 04:44:04,041 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (68, 22) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,042 13002 DEBUG AsiaElectricTest openerp.sql_db: query: select id from wkf_instance where res_id=1 and res_type='im_chat.presence' and state='active' | |
| 2014-10-04 04:44:04,042 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT rule_group_rel.group_id, rule_group_rel.rule_group_id FROM rule_group_rel, "res_groups" WHERE rule_group_rel.rule_group_id IN (22, 68) AND rule_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,043 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: table: wkf_instance: 0:00:00.001208/1 | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: table: im_chat_presence: 0:00:00.001969/1 | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: table: ir_module_module: 0:00:00.014380/1 | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.017557/6 [245] | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/6 [245] | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=3/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: create serialized cursor to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:04,044 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Borrow connection to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:04,045 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (68) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,046 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=3/count=6/max=64) Existing connection found at index 4 | |
| 2014-10-04 04:44:04,046 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."model_id",ir_rule."domain_force",ir_rule."name",ir_rule."create_uid",ir_rule."global",ir_rule."write_uid",ir_rule."active",ir_rule."create_date",ir_rule."write_date",ir_rule."perm_unlink",ir_rule."perm_write",ir_rule."perm_read",ir_rule."perm_create",ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (68) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,048 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."id" FROM "res_users" | |
| WHERE res_users.id IN (1, 3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,049 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_groups" WHERE res_groups_users_rel.uid IN (1, 3) AND res_groups_users_rel.gid = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,051 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:43:14') AND ("bus_bus"."channel" in ('["AsiaElectricTest","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:04,051 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:04,051 13002 DEBUG AsiaElectricTest openerp.sql_db: table: bus_bus: 0:00:00.002479/1 | |
| 2014-10-04 04:44:04,051 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.002479/1 [246] | |
| 2014-10-04 04:44:04,052 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/1 [246] | |
| 2014-10-04 04:44:04,052 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=3/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:04,052 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool | |
| 2014-10-04 04:44:04,052 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT count(1) FROM "product_template" WHERE (("product_template"."active" = true) AND ("product_template"."sale_ok" = true)) AND ((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true))) | |
| 2014-10-04 04:44:04,053 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND ("product_template"."sale_ok" = true)) AND ((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template"."website_published", false) desc,"product_template"."website_sequence" desc limit 30 | |
| 2014-10-04 04:44:04,055 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.style' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,056 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.style' AND a.active IS True | |
| 2014-10-04 04:44:04,057 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.style' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,058 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_style".id FROM "product_style" ORDER BY "product_style"."id" | |
| 2014-10-04 04:44:04,059 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.public.category' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,060 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.public.category' AND a.active IS True | |
| 2014-10-04 04:44:04,061 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.public.category' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,062 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_public_category".id FROM "product_public_category" ORDER BY "product_public_category"."sequence" ,"product_public_category"."name" | |
| 2014-10-04 04:44:04,063 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_public_category."create_uid",product_public_category."create_date",product_public_category."name",product_public_category."sequence",product_public_category."write_uid",product_public_category."parent_id",product_public_category."write_date",product_public_category."id" FROM "product_public_category" | |
| WHERE product_public_category.id IN (1) AND (TRUE) | |
| ORDER BY sequence, name | |
| 2014-10-04 04:44:04,064 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.public.category,name' and res_id IN (1) | |
| 2014-10-04 04:44:04,066 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.attribute' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,068 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.attribute' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,069 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_attribute".id FROM "product_attribute" ORDER BY "product_attribute"."id" | |
| 2014-10-04 04:44:04,070 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.price.type' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,071 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.price.type' AND a.active IS True | |
| 2014-10-04 04:44:04,072 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.price.type' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,073 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_price_type".id FROM "product_price_type" WHERE (("product_price_type"."active" = true) AND ("product_price_type"."field" = 'list_price')) ORDER BY "product_price_type"."id" | |
| 2014-10-04 04:44:04,074 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_price_type."create_uid",product_price_type."create_date",product_price_type."name",product_price_type."write_uid",product_price_type."currency_id",product_price_type."field",product_price_type."write_date",product_price_type."active",product_price_type."id" FROM "product_price_type" | |
| WHERE product_price_type.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,075 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.price.type,name' and res_id IN (1) | |
| 2014-10-04 04:44:04,079 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."warranty",product_template."uos_id",product_template."list_price",product_template."weight",product_template."color",product_template."write_uid",product_template."mes_type",product_template."uom_id",product_template."description_purchase",product_template."create_date",product_template."id",product_template."uos_coeff",product_template."create_uid",product_template."sale_ok",product_template."rental",product_template."product_manager",product_template."message_last_post",product_template."company_id",product_template."state",product_template."website_meta_title",product_template."uom_po_id",product_template."description_sale",product_template."website_published",product_template."description",product_template."weight_net",product_template."volume",product_template."website_meta_description",product_template."website_description",product_template."write_date",product_template."active",product_template."categ_id",product_template."name",product_template."website_sequence",product_template."type",product_template."website_size_x",product_template."website_size_y",product_template."website_meta_keywords" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true)))) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,080 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,description_purchase' and res_id IN (2) | |
| 2014-10-04 04:44:04,081 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,website_meta_title' and res_id IN (2) | |
| 2014-10-04 04:44:04,082 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,description_sale' and res_id IN (2) | |
| 2014-10-04 04:44:04,083 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,description' and res_id IN (2) | |
| 2014-10-04 04:44:04,083 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,website_meta_description' and res_id IN (2) | |
| 2014-10-04 04:44:04,084 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,name' and res_id IN (2) | |
| 2014-10-04 04:44:04,085 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.template,website_meta_keywords' and res_id IN (2) | |
| 2014-10-04 04:44:04,087 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."id" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true)))) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,088 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_style_product_template_rel.product_style_id, product_style_product_template_rel.product_template_id FROM product_style_product_template_rel, "product_style" WHERE product_style_product_template_rel.product_template_id IN (2) AND product_style_product_template_rel.product_style_id = product_style.id ORDER BY "product_style".id OFFSET 0 | |
| 2014-10-04 04:44:04,090 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,091 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,092 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,093 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,095 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website_sale') AND ("ir_model_data"."name" = 'products')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:44:04,096 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (7385) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:44:04,097 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (681) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,098 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (681) | |
| 2014-10-04 04:44:04,098 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (681) | |
| 2014-10-04 04:44:04,099 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (681) | |
| 2014-10-04 04:44:04,100 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (681) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,103 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,104 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_groups" WHERE res_groups_users_rel.uid IN (3) AND res_groups_users_rel.gid = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,105 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 681) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:44:04,106 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Shop' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,107 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='pagination form-inline col-md-3' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,108 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Options' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,109 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Size' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,110 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Styles' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,111 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Promote' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,111 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Push to top' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,112 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Push up' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,113 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Push down' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,114 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Push to bottom' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,115 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='No product defined.' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,115 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Use the' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,116 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='''Content''' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,117 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='top menu to create a new product.' AND res_id=681 AND name='website' | |
| 2014-10-04 04:44:04,120 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website_sale') AND ("ir_model_data"."name" = 'search')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:44:04,121 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (7380) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:44:04,122 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (676) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,123 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (676) | |
| 2014-10-04 04:44:04,124 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (676) | |
| 2014-10-04 04:44:04,124 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (676) | |
| 2014-10-04 04:44:04,126 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (676) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,127 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 676) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:44:04,129 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Search...' AND res_id=676 AND name='website' | |
| 2014-10-04 04:44:04,130 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."id" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,131 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_lang_rel.lang_id, website_lang_rel.website_id FROM website_lang_rel, "res_lang" WHERE website_lang_rel.website_id IN (1) AND website_lang_rel.lang_id = res_lang.id AND ("res_lang"."active" = true) ORDER BY "res_lang".id OFFSET 0 | |
| 2014-10-04 04:44:04,133 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_lang."date_format",res_lang."direction",res_lang."code",res_lang."create_date",res_lang."name",res_lang."create_uid",res_lang."thousands_sep",res_lang."translatable",res_lang."write_uid",res_lang."time_format",res_lang."write_date",res_lang."decimal_point",res_lang."active",res_lang."iso_code",res_lang."id",res_lang."grouping" FROM "res_lang" | |
| WHERE res_lang.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,135 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = 'pager')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:44:04,136 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4261) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:44:04,137 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (335) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,137 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (335) | |
| 2014-10-04 04:44:04,138 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (335) | |
| 2014-10-04 04:44:04,139 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (335) | |
| 2014-10-04 04:44:04,140 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (335) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,141 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 335) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:44:04,142 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Prev' AND res_id=335 AND name='website' | |
| 2014-10-04 04:44:04,143 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Next' AND res_id=335 AND name='website' | |
| 2014-10-04 04:44:04,146 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website_sale') AND ("ir_model_data"."name" = 'products_item')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:44:04,147 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (7382) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:44:04,149 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (678) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,150 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (678) | |
| 2014-10-04 04:44:04,151 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (678) | |
| 2014-10-04 04:44:04,152 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (678) | |
| 2014-10-04 04:44:04,153 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (678) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,154 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 678) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:44:04,155 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Sale' AND res_id=678 AND name='website' | |
| 2014-10-04 04:44:04,159 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."warranty",product_template."uos_id",product_template."list_price",product_template."weight",product_template."color",product_template."write_uid",product_template."mes_type",product_template."uom_id",product_template."description_purchase",product_template."create_date",product_template."id",product_template."uos_coeff",product_template."create_uid",product_template."sale_ok",product_template."rental",product_template."product_manager",product_template."message_last_post",product_template."company_id",product_template."state",product_template."website_meta_title",product_template."uom_po_id",product_template."description_sale",product_template."website_published",product_template."description",product_template."weight_net",product_template."volume",product_template."website_meta_description",product_template."website_description",product_template."write_date",product_template."active",product_template."categ_id",product_template."name",product_template."website_sequence",product_template."type",product_template."website_size_x",product_template."website_size_y",product_template."website_meta_keywords" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (TRUE) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,162 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."id" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true)))) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,163 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.product' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,164 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.product' AND a.active IS True | |
| 2014-10-04 04:44:04,166 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.product' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,167 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_product".id FROM "product_product","product_template" as "product_product__product_tmpl_id" WHERE (("product_product"."active" = true) AND ("product_product"."product_tmpl_id" in (2))) AND ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") AND ((("product_product__product_tmpl_id"."company_id" = 1) OR "product_product__product_tmpl_id"."company_id" IS NULL ) AND (("product_product__product_tmpl_id"."website_published" = true) AND ("product_product__product_tmpl_id"."sale_ok" = true))) ORDER BY "product_product"."default_code" ,"product_product"."name_template" | |
| 2014-10-04 04:44:04,169 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_product."product_tmpl_id",product_product."id" FROM "product_product" | |
| WHERE product_product.id IN (2) AND (TRUE) | |
| ORDER BY default_code,name_template | |
| 2014-10-04 04:44:04,170 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."id" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true)))) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,172 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_template."id" FROM "product_template" | |
| WHERE product_template.id IN (2) AND (((("product_template"."company_id" = 1) OR "product_template"."company_id" IS NULL ) AND (("product_template"."website_published" = true) AND ("product_template"."sale_ok" = true)))) | |
| ORDER BY website_published desc, website_sequence desc, name | |
| 2014-10-04 04:44:04,173 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.pricelist' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,175 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.pricelist' AND a.active IS True | |
| 2014-10-04 04:44:04,176 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.pricelist' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,177 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (23) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,177 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."model_id",ir_rule."domain_force",ir_rule."name",ir_rule."create_uid",ir_rule."global",ir_rule."write_uid",ir_rule."active",ir_rule."create_date",ir_rule."write_date",ir_rule."perm_unlink",ir_rule."perm_write",ir_rule."perm_read",ir_rule."perm_create",ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (23) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,179 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."password_crypt",res_users."create_uid",res_users."create_date",res_users."alias_id",res_users."default_section_id",res_users."share",res_users."company_id",res_users."write_uid",res_users."display_groups_suggestions",res_users."write_date",res_users."signature",res_users."active",res_users."login_date",res_users."login",res_users."password",res_users."partner_id",res_users."id",res_users."action_id" FROM "res_users" | |
| WHERE res_users.id IN (3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,180 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (23) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,182 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT rule_group_rel.group_id, rule_group_rel.rule_group_id FROM rule_group_rel, "res_groups" WHERE rule_group_rel.rule_group_id IN (23) AND rule_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,183 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist."id" FROM "product_pricelist" | |
| WHERE product_pricelist.id IN (1) AND ((("product_pricelist"."company_id" = 1) OR "product_pricelist"."company_id" IS NULL )) | |
| ORDER BY name | |
| 2014-10-04 04:44:04,184 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.pricelist.version' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,185 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.pricelist.version' AND a.active IS True | |
| 2014-10-04 04:44:04,186 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.pricelist.version' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,187 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (25) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,188 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."model_id",ir_rule."domain_force",ir_rule."name",ir_rule."create_uid",ir_rule."global",ir_rule."write_uid",ir_rule."active",ir_rule."create_date",ir_rule."write_date",ir_rule."perm_unlink",ir_rule."perm_write",ir_rule."perm_read",ir_rule."perm_create",ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (25) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,189 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (25) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,190 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT rule_group_rel.group_id, rule_group_rel.rule_group_id FROM rule_group_rel, "res_groups" WHERE rule_group_rel.rule_group_id IN (25) AND rule_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,192 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "product_pricelist_version".id FROM "product_pricelist_version" WHERE (("product_pricelist_version"."active" = true) AND ("product_pricelist_version"."pricelist_id" in (1))) AND (("product_pricelist_version"."company_id" = 1) OR "product_pricelist_version"."company_id" IS NULL ) ORDER BY "product_pricelist_version"."id" | |
| 2014-10-04 04:44:04,193 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist_version."pricelist_id",product_pricelist_version."id" FROM "product_pricelist_version" | |
| WHERE product_pricelist_version.id IN (1) AND ((("product_pricelist_version"."company_id" = 1) OR "product_pricelist_version"."company_id" IS NULL )) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,194 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist_version."create_uid",product_pricelist_version."create_date",product_pricelist_version."name",product_pricelist_version."date_end",product_pricelist_version."date_start",product_pricelist_version."company_id",product_pricelist_version."write_uid",product_pricelist_version."write_date",product_pricelist_version."active",product_pricelist_version."pricelist_id",product_pricelist_version."id" FROM "product_pricelist_version" | |
| WHERE product_pricelist_version.id IN (1) AND ((("product_pricelist_version"."company_id" = 1) OR "product_pricelist_version"."company_id" IS NULL )) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,195 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.pricelist.version,name' and res_id IN (1) | |
| 2014-10-04 04:44:04,196 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.category' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,197 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.category' AND a.active IS True | |
| 2014-10-04 04:44:04,199 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.category' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,200 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_category."create_uid",product_category."parent_right",product_category."create_date",product_category."name",product_category."sequence",product_category."write_uid",product_category."parent_id",product_category."parent_left",product_category."write_date",product_category."type",product_category."id" FROM "product_category" | |
| WHERE product_category.id IN (1) AND (TRUE) | |
| ORDER BY sequence, name | |
| 2014-10-04 04:44:04,201 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='product.category,name' and res_id IN (1) | |
| 2014-10-04 04:44:04,202 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT i.id FROM product_pricelist_item AS i WHERE (product_tmpl_id IS NULL OR product_tmpl_id = any(ARRAY[2])) AND (product_id IS NULL OR (product_id = any(ARRAY[2]))) AND ((categ_id IS NULL) OR (categ_id = any(ARRAY[1]))) AND (price_version_id = 1) ORDER BY sequence, min_quantity desc | |
| 2014-10-04 04:44:04,203 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'product.pricelist.item' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,204 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'product.pricelist.item' AND a.active IS True | |
| 2014-10-04 04:44:04,206 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT r.id | |
| FROM ir_rule r | |
| JOIN ir_model m ON (r.model_id = m.id) | |
| WHERE m.model = 'product.pricelist.item' | |
| AND r.active is True | |
| AND r.perm_read | |
| AND (r.id IN (SELECT rule_group_id FROM rule_group_rel g_rel | |
| JOIN res_groups_users_rel u_rel ON (g_rel.group_id = u_rel.gid) | |
| WHERE u_rel.uid = 3) OR r.global) | |
| 2014-10-04 04:44:04,207 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (24) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,208 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."model_id",ir_rule."domain_force",ir_rule."name",ir_rule."create_uid",ir_rule."global",ir_rule."write_uid",ir_rule."active",ir_rule."create_date",ir_rule."write_date",ir_rule."perm_unlink",ir_rule."perm_write",ir_rule."perm_read",ir_rule."perm_create",ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (24) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,209 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_rule."id" FROM "ir_rule" | |
| WHERE ir_rule.id IN (24) AND (TRUE) | |
| ORDER BY model_id DESC | |
| 2014-10-04 04:44:04,210 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT rule_group_rel.group_id, rule_group_rel.rule_group_id FROM rule_group_rel, "res_groups" WHERE rule_group_rel.rule_group_id IN (24) AND rule_group_rel.group_id = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,212 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist_item."create_uid",product_pricelist_item."create_date",product_pricelist_item."price_discount",product_pricelist_item."base_pricelist_id",product_pricelist_item."sequence",product_pricelist_item."name",product_pricelist_item."price_max_margin",product_pricelist_item."categ_id",product_pricelist_item."company_id",product_pricelist_item."write_uid",product_pricelist_item."price_round",product_pricelist_item."min_quantity",product_pricelist_item."base",product_pricelist_item."price_version_id",product_pricelist_item."write_date",product_pricelist_item."price_surcharge",product_pricelist_item."price_min_margin",product_pricelist_item."product_tmpl_id",product_pricelist_item."id",product_pricelist_item."product_id" FROM "product_pricelist_item" | |
| WHERE product_pricelist_item.id IN (1) AND ((("product_pricelist_item"."company_id" = 1) OR "product_pricelist_item"."company_id" IS NULL )) | |
| ORDER BY sequence, min_quantity desc | |
| 2014-10-04 04:44:04,214 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_price_type."create_uid",product_price_type."create_date",product_price_type."name",product_price_type."write_uid",product_price_type."currency_id",product_price_type."field",product_price_type."write_date",product_price_type."active",product_price_type."id" FROM "product_price_type" | |
| WHERE product_price_type.id IN (2) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,215 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT product_pricelist."create_uid",product_pricelist."code",product_pricelist."create_date",product_pricelist."name",product_pricelist."company_id",product_pricelist."write_uid",product_pricelist."currency_id",product_pricelist."write_date",product_pricelist."active",product_pricelist."type",product_pricelist."id" FROM "product_pricelist" | |
| WHERE product_pricelist.id IN (1) AND ((("product_pricelist"."company_id" = 1) OR "product_pricelist"."company_id" IS NULL )) | |
| ORDER BY name | |
| 2014-10-04 04:44:04,216 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT 1 FROM res_groups_users_rel WHERE uid=3 AND gid IN | |
| (SELECT res_id FROM ir_model_data WHERE module='base' AND name='group_user') | |
| 2014-10-04 04:44:04,217 13002 WARNING testingpricelist openerp.models: Access Denied by ACLs for operation: read, uid: 3, model: product.template, fields: standard_price | |
| 2014-10-04 04:44:04,217 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('code', 'sql_constraint') | |
| AND src='The requested operation cannot be completed due to security restrictions. Please contact your system administrator. | |
| (Document type: %s, Operation: %s)' | |
| 2014-10-04 04:44:04,219 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."type" = 'binary') AND ("ir_attachment"."url" = '/shop')) ORDER BY "ir_attachment"."id" desc | |
| 2014-10-04 04:44:04,220 13002 WARNING testingpricelist openerp.addons.website.models.ir_http: 403 Forbidden: | |
| Traceback (most recent call last): | |
| File "/opt/odoo/odoo-server/addons/website/models/ir_http.py", line 204, in _handle_exception | |
| response = super(ir_http, self)._handle_exception(exception) | |
| File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_http.py", line 100, in _handle_exception | |
| return request._handle_exception(exception) | |
| File "/opt/odoo/odoo-server/openerp/http.py", line 596, in _handle_exception | |
| return super(HttpRequest, self)._handle_exception(exception) | |
| File "/opt/odoo/odoo-server/openerp/http.py", line 259, in _handle_exception | |
| raise | |
| QWebException: ('AccessError', 'No value found for product.template(2,).price') | |
| 2014-10-04 04:44:04,221 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,222 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,224 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,225 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,226 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = 'website') AND ("ir_model_data"."name" = '403')) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name" | |
| 2014-10-04 04:44:04,227 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_model_data."model",ir_model_data."res_id",ir_model_data."id" FROM "ir_model_data" | |
| WHERE ir_model_data.id IN (4269) AND (TRUE) | |
| ORDER BY module,model,name | |
| 2014-10-04 04:44:04,230 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (681, 343) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,232 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_description' and res_id IN (343) | |
| 2014-10-04 04:44:04,232 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_title' and res_id IN (343) | |
| 2014-10-04 04:44:04,233 13002 DEBUG testingpricelist openerp.sql_db: query: select res_id,value from ir_translation where lang='en_US' and type='model' and name='ir.ui.view,website_meta_keywords' and res_id IN (343) | |
| 2014-10-04 04:44:04,235 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT ir_ui_view."model",ir_ui_view."arch",ir_ui_view."id" FROM "ir_ui_view" | |
| WHERE ir_ui_view.id IN (343) AND (TRUE) | |
| ORDER BY priority,name | |
| 2014-10-04 04:44:04,236 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_users."id" FROM "res_users" | |
| WHERE res_users.id IN (1, 3) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:04,237 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_groups" WHERE res_groups_users_rel.uid IN (1, 3) AND res_groups_users_rel.gid = res_groups.id ORDER BY "res_groups".name OFFSET 0 | |
| 2014-10-04 04:44:04,239 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 343) AND "ir_ui_view"."model" IS NULL ) AND ("ir_ui_view"."mode" = 'extension')) AND ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."name" | |
| 2014-10-04 04:44:04,240 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='403: Forbidden' AND res_id=343 AND name='website' | |
| 2014-10-04 04:44:04,241 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='The page you were looking for could not be authorized.' AND res_id=343 AND name='website' | |
| 2014-10-04 04:44:04,241 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Maybe you were looking for one of these popular pages ?' AND res_id=343 AND name='website' | |
| 2014-10-04 04:44:04,242 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Homepage' AND res_id=343 AND name='website' | |
| 2014-10-04 04:44:04,243 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT value | |
| FROM ir_translation | |
| WHERE lang='en_US' | |
| AND type in ('view') | |
| AND src='Contact Us' AND res_id=343 AND name='website' | |
| 2014-10-04 04:44:04,247 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_company."sale_note",res_company."rml_footer",res_company."create_date",res_company."rml_header",res_company."rml_paper_format",res_company."write_uid",res_company."currency_id",res_company."font",res_company."partner_id",res_company."expects_chart_of_accounts",res_company."account_no",res_company."create_uid",res_company."expense_currency_exchange_account_id",res_company."id",res_company."parent_id",res_company."paperformat_id",res_company."email",res_company."custom_footer",res_company."phone",res_company."rml_header2",res_company."rml_header3",res_company."write_date",res_company."rml_header1",res_company."company_registry",res_company."paypal_account",res_company."name",res_company."overdue_msg",res_company."tax_calculation_rounding_method",res_company."income_currency_exchange_account_id" FROM "res_company" | |
| WHERE res_company.id IN (1) AND (TRUE) | |
| ORDER BY name | |
| 2014-10-04 04:44:04,251 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,252 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,253 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,254 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,257 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,258 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,259 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,260 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,264 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:44:04,266 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "website_menu".id FROM "website_menu" WHERE ("website_menu"."parent_id" in (1)) ORDER BY "website_menu"."sequence" | |
| 2014-10-04 04:44:04,267 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."parent_id",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:44:04,269 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."create_uid",website_menu."parent_right",website_menu."create_date",website_menu."name",website_menu."sequence",website_menu."url",website_menu."parent_left",website_menu."website_id",website_menu."write_uid",website_menu."parent_id",website_menu."new_window",website_menu."write_date",website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (1, 2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:44:04,271 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_menu."id" FROM "website_menu" | |
| WHERE website_menu.id IN (2, 3, 4) AND (TRUE) | |
| ORDER BY sequence | |
| 2014-10-04 04:44:04,272 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "website_menu".id FROM "website_menu" WHERE ("website_menu"."parent_id" in (2,4,3)) ORDER BY "website_menu"."sequence" | |
| 2014-10-04 04:44:04,279 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,280 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,281 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,282 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,285 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.view' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,286 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.view' AND a.active IS True | |
| 2014-10-04 04:44:04,287 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = 'ir.ui.menu' AND gu.uid = 3 AND a.active IS True | |
| 2014-10-04 04:44:04,288 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) WHERE a.group_id IS NULL AND m.model = 'ir.ui.menu' AND a.active IS True | |
| 2014-10-04 04:44:04,290 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_fields: 0:00:00.000550/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_public_category: 0:00:00.000686/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_style: 0:00:00.000689/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_attribute: 0:00:00.000694/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_price_type: 0:00:00.000710/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_pricelist: 0:00:00.000790/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: ir_attachment: 0:00:00.000818/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: product_pricelist_item: 0:00:00.000840/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model: 0:00:00.000853/1 | |
| 2014-10-04 04:44:04,291 13002 DEBUG testingpricelist openerp.sql_db: table: multi_company_default: 0:00:00.001441/1 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: product_pricelist_version: 0:00:00.001499/1 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: ir_property: 0:00:00.463737/1 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: website_menu: 0:00:00.001052/2 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: product_template: 0:00:00.002382/2 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: ir_ui_view: 0:00:00.002865/5 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_data: 0:00:00.003521/5 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: ir_translation: 0:00:00.015686/27 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: table: ir_model_access: 0:00:00.179785/45 | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.678598/211 [457] | |
| 2014-10-04 04:44:04,292 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/211 [457] | |
| 2014-10-04 04:44:04,293 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:04,293 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:44:25,107 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:25,107 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:25,108 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 5 | |
| 2014-10-04 04:44:25,110 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website."id" FROM "website" | |
| WHERE website.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:25,111 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT website_lang_rel.lang_id, website_lang_rel.website_id FROM website_lang_rel, "res_lang" WHERE website_lang_rel.website_id IN (1) AND website_lang_rel.lang_id = res_lang.id AND ("res_lang"."active" = true) ORDER BY "res_lang".id OFFSET 0 | |
| 2014-10-04 04:44:25,112 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT res_lang."date_format",res_lang."direction",res_lang."code",res_lang."create_date",res_lang."name",res_lang."create_uid",res_lang."thousands_sep",res_lang."translatable",res_lang."write_uid",res_lang."time_format",res_lang."write_date",res_lang."decimal_point",res_lang."active",res_lang."iso_code",res_lang."id",res_lang."grouping" FROM "res_lang" | |
| WHERE res_lang.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:25,113 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."type" = 'binary') AND ("ir_attachment"."url" = '/calendar/notify')) ORDER BY "ir_attachment"."id" desc | |
| 2014-10-04 04:44:25,113 13002 ERROR testingpricelist openerp.http: Exception during JSON request handling. | |
| Traceback (most recent call last): | |
| File "/opt/odoo/odoo-server/openerp/http.py", line 500, in _handle_exception | |
| return super(JsonRequest, self)._handle_exception(exception) | |
| File "/opt/odoo/odoo-server/openerp/http.py", line 259, in _handle_exception | |
| raise | |
| NotFound: 404: Not Found | |
| 2014-10-04 04:44:25,114 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:25,114 13002 DEBUG testingpricelist openerp.sql_db: table: ir_attachment: 0:00:00.000634/1 | |
| 2014-10-04 04:44:25,114 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.000634/4 [461] | |
| 2014-10-04 04:44:25,114 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/4 [461] | |
| 2014-10-04 04:44:25,115 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:25,115 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:44:32,928 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,928 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,929 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 5 | |
| 2014-10-04 04:44:32,931 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:43:42') AND FALSE) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:32,931 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:32,931 13002 DEBUG testingpricelist openerp.sql_db: table: bus_bus: 0:00:00.000594/1 | |
| 2014-10-04 04:44:32,932 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.000594/1 [462] | |
| 2014-10-04 04:44:32,932 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/1 [462] | |
| 2014-10-04 04:44:32,932 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,932 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:44:32,939 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,939 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,940 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 5 | |
| 2014-10-04 04:44:32,941 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00/0 [462] | |
| 2014-10-04 04:44:32,941 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/0 [462] | |
| 2014-10-04 04:44:32,942 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,942 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:44:32,942 13002 DEBUG testingpricelist openerp.sql_db: create serialized cursor to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,942 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,943 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 5 | |
| 2014-10-04 04:44:32,945 13002 DEBUG testingpricelist openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:43:42') AND FALSE) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: table: bus_bus: 0:00:00.000779/1 | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: SUM from:0:00:00.000779/1 [463] | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: SUM into:0:00:00/1 [463] | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=testingpricelist' | |
| 2014-10-04 04:44:32,946 13002 DEBUG testingpricelist openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=testingpricelist' in pool | |
| 2014-10-04 04:44:33,104 13002 DEBUG test openerp.sql_db: create serialized cursor to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,104 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,105 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 1 | |
| 2014-10-04 04:44:33,107 13002 DEBUG test openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:43:43') AND ("bus_bus"."channel" in ('["test","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:33,108 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:33,108 13002 DEBUG test openerp.sql_db: table: bus_bus: 0:00:00.001095/1 | |
| 2014-10-04 04:44:33,109 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.001095/1 [464] | |
| 2014-10-04 04:44:33,109 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/1 [464] | |
| 2014-10-04 04:44:33,109 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,109 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:44:33,122 13002 DEBUG test openerp.sql_db: create serialized cursor to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,122 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,123 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 1 | |
| 2014-10-04 04:44:33,125 13002 DEBUG test openerp.sql_db: query: SELECT "im_chat_presence".id FROM "im_chat_presence" WHERE ("im_chat_presence"."user_id" = 1) ORDER BY "im_chat_presence"."id" | |
| 2014-10-04 04:44:33,127 13002 DEBUG test openerp.sql_db: query: SELECT im_chat_presence."status",im_chat_presence."create_uid",im_chat_presence."create_date",im_chat_presence."user_id",im_chat_presence."last_presence",im_chat_presence."write_uid",im_chat_presence."write_date",im_chat_presence."last_poll",im_chat_presence."id" FROM "im_chat_presence" | |
| WHERE im_chat_presence.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:33,129 13002 DEBUG test openerp.sql_db: query: update im_chat_presence set "status"='online',"last_poll"='2014-10-04 04:44:33',"last_presence"='2014-10-04 04:44:33',write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1) | |
| 2014-10-04 04:44:33,129 13002 DEBUG test openerp.sql_db: query: select id from wkf_instance where res_id=1 and res_type='im_chat.presence' and state='active' | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: table: wkf_instance: 0:00:00.000475/1 | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: table: im_chat_presence: 0:00:00.001058/1 | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.001533/4 [468] | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/4 [468] | |
| 2014-10-04 04:44:33,150 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,151 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:44:33,151 13002 DEBUG test openerp.sql_db: create serialized cursor to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,151 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,152 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 4 | |
| 2014-10-04 04:44:33,155 13002 DEBUG test openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:43:43') AND ("bus_bus"."channel" in ('["test","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:33,155 13002 DEBUG test openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:33,155 13002 DEBUG test openerp.sql_db: table: bus_bus: 0:00:00.000943/1 | |
| 2014-10-04 04:44:33,156 13002 DEBUG test openerp.sql_db: SUM from:0:00:00.000943/1 [469] | |
| 2014-10-04 04:44:33,156 13002 DEBUG test openerp.sql_db: SUM into:0:00:00/1 [469] | |
| 2014-10-04 04:44:33,156 13002 DEBUG test openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=test' | |
| 2014-10-04 04:44:33,156 13002 DEBUG test openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=test' in pool | |
| 2014-10-04 04:44:54,057 13002 DEBUG AsiaElectricTest openerp.sql_db: create serialized cursor to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,058 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,059 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 1 | |
| 2014-10-04 04:44:54,061 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:44:04') AND ("bus_bus"."channel" in ('["AsiaElectricTest","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:54,061 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:54,062 13002 DEBUG AsiaElectricTest openerp.sql_db: table: bus_bus: 0:00:00.000981/1 | |
| 2014-10-04 04:44:54,062 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.000981/1 [470] | |
| 2014-10-04 04:44:54,062 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/1 [470] | |
| 2014-10-04 04:44:54,062 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,062 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool | |
| 2014-10-04 04:44:54,069 13002 DEBUG AsiaElectricTest openerp.sql_db: create serialized cursor to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,069 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,070 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 1 | |
| 2014-10-04 04:44:54,072 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "im_chat_presence".id FROM "im_chat_presence" WHERE ("im_chat_presence"."user_id" = 1) ORDER BY "im_chat_presence"."id" | |
| 2014-10-04 04:44:54,073 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT im_chat_presence."status",im_chat_presence."create_uid",im_chat_presence."create_date",im_chat_presence."user_id",im_chat_presence."last_presence",im_chat_presence."write_uid",im_chat_presence."write_date",im_chat_presence."last_poll",im_chat_presence."id" FROM "im_chat_presence" | |
| WHERE im_chat_presence.id IN (1) AND (TRUE) | |
| ORDER BY id | |
| 2014-10-04 04:44:54,074 13002 DEBUG AsiaElectricTest openerp.sql_db: query: update im_chat_presence set "status"='away',"last_poll"='2014-10-04 04:44:54',write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1) | |
| 2014-10-04 04:44:54,075 13002 DEBUG AsiaElectricTest openerp.sql_db: query: select id from wkf_instance where res_id=1 and res_type='im_chat.presence' and state='active' | |
| 2014-10-04 04:44:54,077 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: table: wkf_instance: 0:00:00.000733/1 | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: table: im_chat_presence: 0:00:00.000954/1 | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.001687/4 [474] | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/4 [474] | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: create serialized cursor to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,078 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Borrow connection to u'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,079 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Existing connection found at index 4 | |
| 2014-10-04 04:44:54,081 13002 DEBUG AsiaElectricTest openerp.sql_db: query: SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2014-10-04 04:44:04') AND ("bus_bus"."channel" in ('["AsiaElectricTest","im_chat.session",1]'))) ORDER BY "bus_bus"."id" | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: SQL LOG from: | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: table: bus_bus: 0:00:00.000750/1 | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM from:0:00:00.000750/1 [475] | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: SUM into:0:00:00/1 [475] | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=2/count=6/max=64) Give back connection to 'user=odoo dbname=AsiaElectricTest' | |
| 2014-10-04 04:44:54,082 13002 DEBUG AsiaElectricTest openerp.sql_db: ConnectionPool(used=1/count=6/max=64) Put connection to 'user=odoo dbname=AsiaElectricTest' in pool |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment