Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save lukebranch/bc7b0ac6aa3c4f95a422 to your computer and use it in GitHub Desktop.
Save lukebranch/bc7b0ac6aa3c4f95a422 to your computer and use it in GitHub Desktop.
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