odoo.addons.website.tests.test_configurator.TestConfiguratorTranslation.test_01_configurator_translation.browser: FAILED: [12/18] Tour configurator_translation → Step Wait for the editor to load after redirect (trigger: :iframe [data-view-xmlid='website.homepage']). Element (:iframe [data-view-xmlid='website.homepage']) has not been found. TIMEOUT step failed to complete within 10000 ms.

odoo.addons.website.tests.test_configurator: FAIL: TestConfiguratorTranslation.test_01_configurator_translation Traceback (most recent call last): File "/data/build/rb-aa5c29f-225760/addons/website/tests/test_configurator.py", line 174, in test_01_configurator_translation self.start_tour( ~~~~~~~~~~~~~~~^ '/website/force/%s?path=%%2Fwebsite%%2Fconfigurator' % website_fr.id, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ...<2 lines>... timeout=120, ^^^^^^^^^^^^ ) ^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 3004, in start_tour self.browser_js(url_path=url_path, code=code, ready=ready, timeout=timeout, success_signal="tour succeeded", **kwargs) ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 2979, in browser_js self.fail(str(error)) ~~~~~~~~~^^^^^^^^^^^^ AssertionError: FAILED: [12/18] Tour configurator_translation → Step Wait for the editor to load after redirect (trigger: :iframe [data-view-xmlid='website.homepage']). Element (:iframe [data-view-xmlid='website.homepage']) has not been found. TIMEOUT step failed to complete within 10000 ms.

odoo.addons.website.tests.test_ui.TestUi.test_snippet_carousel_clickable_slides.browser: TypeError: Cannot read properties of undefined (reading 'getAction') at getActionsSpecs (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1269:206) at callOperation (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1277:93) at BuilderUrlPicker.commit (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1253:317) at BuilderUrlPicker.onSelect (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:2473:421) at Proxy.onSelect (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:27634:141) at AutoCompleteBuilderUrlPicker.selectOption (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:1644:62) at AutoCompleteBuilderUrlPicker.onInputKeydown (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:1667:6)

odoo.addons.website.tests.test_ui: FAIL: TestUi.test_snippet_carousel_clickable_slides Traceback (most recent call last): File "/data/build/rb-aa5c29f-225760/addons/website/tests/test_ui.py", line 774, in test_snippet_carousel_clickable_slides self.start_tour(self.env['website'].get_client_action_url('/', True), "snippet_carousel_clickable_slides", login="admin") ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 3004, in start_tour self.browser_js(url_path=url_path, code=code, ready=ready, timeout=timeout, success_signal="tour succeeded", **kwargs) ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 2979, in browser_js self.fail(str(error)) ~~~~~~~~~^^^^^^^^^^^^ AssertionError: TypeError: Cannot read properties of undefined (reading 'getAction') at getActionsSpecs (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1269:206) at callOperation (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1277:93) at BuilderUrlPicker.commit (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:1253:317) at BuilderUrlPicker.onSelect (http://127.0.0.1:8069/web/assets/1/1bb702c/website.website_builder_assets.min.js:2473:421) at Proxy.onSelect (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:27634:141) at AutoCompleteBuilderUrlPicker.selectOption (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:1644:62) at AutoCompleteBuilderUrlPicker.onInputKeydown (http://127.0.0.1:8069/web/assets/1/8495a6c/web.assets_web.min.js:1667:6)

odoo.addons.website_links.tests.test_ui.TestUi.test_01_test_ui.browser: FAILED: [11/34] Tour website_links_tour → Step Check that selectMenu is properly filled (trigger: .o_website_links_utm_forms div#campaign-select-wrapper .o_select_menu_toggler:value(Super Specific Campaign)). Element (.o_website_links_utm_forms div#campaign-select-wrapper .o_select_menu_toggler:value(Super Specific Campaign)) has not been found. TIMEOUT step failed to complete within 10000 ms.

odoo.addons.website_links.tests.test_ui: FAIL: TestUi.test_01_test_ui Traceback (most recent call last): File "/data/build/rb-aa5c29f-225760/addons/website_links/tests/test_ui.py", line 27, in test_01_test_ui self.start_tour("/r", 'website_links_tour', login="admin") ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 3004, in start_tour self.browser_js(url_path=url_path, code=code, ready=ready, timeout=timeout, success_signal="tour succeeded", **kwargs) ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/build/rb-aa5c29f-225760/odoo/tests/common.py", line 2979, in browser_js self.fail(str(error)) ~~~~~~~~~^^^^^^^^^^^^ AssertionError: FAILED: [11/34] Tour website_links_tour → Step Check that selectMenu is properly filled (trigger: .o_website_links_utm_forms div#campaign-select-wrapper .o_select_menu_toggler:value(Super Specific Campaign)). Element (.o_website_links_utm_forms div#campaign-select-wrapper .o_select_menu_toggler:value(Super Specific Campaign)) has not been found. TIMEOUT step failed to complete within 10000 ms.

odoo.addons.website_sale.tests.test_performance: FAIL: TestWebsiteSalePerformanceWithPricelist.test_product_page_generation Traceback (most recent call last): File "/data/build/rb-aa5c29f-225760/addons/website_sale/tests/test_performance.py", line 271, in test_product_page_generation self._check_url_hot_query( ~~~~~~~~~~~~~~~~~~~~~~~~~^ self.heavy_product.website_url, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sum(select_queries.values()), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ select_tables_perf=select_queries, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/data/build/rb-aa5c29f-225760/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) ~~~~~~~~~^^^^^ AssertionError: Expected 48 queries but 49 where ran: Diff of select queries: {'res_company': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."can_be_expensed", "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."email_template_id", "product_template"."use_expiration_date", "product_template"."expiration_time", "product_template"."use_time", "product_template"."removal_time", "product_template"."alert_time", "product_template"."purchase_method", "product_template"."purchase_line_warn_msg", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."grade_id", "product_template"."self_order_available", "product_template"."product_add_mode", "product_template"."landed_cost_ok", "product_template"."split_method_landed_cost", "product_template"."gelato_template_ref", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."service_upsell_threshold" FROM "product_template" WHERE "product_template"."id" IN (201) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."lunch_minimum_threshold", "res_company"."lunch_notify_message"->>'en_US', "res_company"."iap_enrich_auto_done", "res_company"."snailmail_color", "res_company"."snailmail_cover", "res_company"."snailmail_duplex", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."sms_provider", "res_company"."sms_twilio_account_sid", "res_company"."sms_twilio_auth_token", "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."hr_presence_control_email_amount", "res_company"."hr_presence_control_ip_list", "res_company"."employee_properties_definition", "res_company"."hr_presence_control_login", "res_company"."hr_presence_control_email", "res_company"."hr_presence_control_ip", "res_company"."hr_presence_control_attendance", "res_company"."contract_expiration_notice_period", "res_company"."work_permit_expiration_notice_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."account_check_printing_layout", "res_company"."account_check_printing_date_label", "res_company"."account_check_printing_multi_stub", "res_company"."account_check_printing_margin_top", "res_company"."account_check_printing_margin_left", "res_company"."account_check_printing_margin_right", "res_company"."expense_journal_id", "res_company"."job_properties_definition", "res_company"."applicant_properties_definition", "res_company"."project_time_mode_id", "res_company"."timesheet_encode_uom_id", "res_company"."internal_project_id", "res_company"."external_code", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."po_lock", "res_company"."po_double_validation", "res_company"."po_double_validation_amount", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."account_interco_clearing_journal_id", "res_company"."account_interco_payable_id", "res_company"."account_interco_receivable_id", "res_company"."account_peppol_contact_email", "res_company"."account_peppol_migration_key", "res_company"."account_peppol_phone_number", "res_company"."account_peppol_proxy_state", "res_company"."peppol_purchase_journal_id", "res_company"."peppol_external_provider", "res_company"."peppol_metadata", "res_company"."peppol_metadata_updated_at", "res_company"."attendance_kiosk_mode", "res_company"."attendance_barcode_source", "res_company"."attendance_kiosk_delay", "res_company"."attendance_kiosk_key", "res_company"."attendance_kiosk_use_pin", "res_company"."attendance_from_systray", "res_company"."auto_check_out", "res_company"."single_check_in", "res_company"."auto_check_out_mode", "res_company"."auto_check_out_tolerance", "res_company"."auto_check_out_specific_time", "res_company"."absence_management", "res_company"."attendance_validation", "res_company"."attendance_validation_tolerance", "res_company"."attendance_work_entry_type_id", "res_company"."attendance_device_tracking", "res_company"."attendance_capture_check_in", "res_company"."attendance_break_management", "res_company"."attendance_based", "res_company"."subcontracting_location_id", "res_company"."point_of_sale_update_stock_quantities", "res_company"."days_to_purchase", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."hr_presence_last_compute_date", "res_company"."l10n_vn_edi_username", "res_company"."l10n_vn_edi_password", "res_company"."l10n_vn_edi_token", "res_company"."l10n_vn_edi_token_expiry", "res_company"."l10n_vn_edi_symbol_id", "res_company"."partnership_label"->>'en_US', "res_company"."leave_timesheet_task_id", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."lc_journal_id", "res_company"."l10n_vn_pos_default_symbol", "res_company"."l10n_vn_edi_send_transfer_note", "res_company"."l10n_vn_edi_stock_default_sinvoice_symbol_id", "res_company"."gelato_api_key", "res_company"."gelato_webhook_secret", "res_company"."free_order_label"->>'en_US', "res_company"."dropship_subcontractor_pick_type_id" FROM "res_company" WHERE "res_company"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "product_public_category_product_template_rel"."product_template_id", "product_public_category_product_template_rel"."product_public_category_id" FROM "product_public_category" JOIN "product_public_category_product_template_rel" ON ("product_public_category_product_template_rel"."product_public_category_id" = "product_public_category"."id") WHERE "product_public_category_product_template_rel"."product_template_id" IN (201) ORDER BY "product_public_category"."sequence" , "product_public_category"."name"->>'en_US' , "product_public_category"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_product"."id", "product_product"."product_tmpl_id", "product_product"."active" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE "product_product"."product_tmpl_id" IN (201) ORDER BY "product_product"."default_code" , "product_product__product_tmpl_id"."name"->>'en_US' , "product_product"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (111) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (111) ---------------------------------------------------------------------------------------------------- SELECT "product_category"."id", "product_category"."name"->>'en_US', "product_category"."parent_id", "product_category"."parent_path", "product_category"."product_properties_definition", "product_category"."company_id", "product_category"."create_uid", "product_category"."create_date", "product_category"."write_uid", "product_category"."write_date", "product_category"."removal_strategy_id", "product_category"."packaging_reserve_method" FROM "product_category" WHERE "product_category"."id" IN (35) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (35) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (111) AND ("product_pricelist_item"."product_id" IN (250, 251, 252, 253, 254, 255, 256, 257, 258) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (201) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:07'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:06'::timestamp) AND (("product_pricelist_item"."min_quantity" IN ('0.00') OR "product_pricelist_item"."min_quantity" IS NULL) OR ("product_pricelist_item"."min_quantity" <= '1.00' OR "product_pricelist_item"."min_quantity" IS NULL))) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id", "product_pricelist_item"."pricelist_id", "product_pricelist_item"."company_id", "product_pricelist_item"."currency_id", "product_pricelist_item"."date_start", "product_pricelist_item"."date_end", "product_pricelist_item"."min_quantity", "product_pricelist_item"."applied_on", "product_pricelist_item"."categ_id", "product_pricelist_item"."product_tmpl_id", "product_pricelist_item"."product_id", "product_pricelist_item"."uom_id", "product_pricelist_item"."base", "product_pricelist_item"."base_pricelist_id", "product_pricelist_item"."compute_price", "product_pricelist_item"."fixed_price", "product_pricelist_item"."price_discount", "product_pricelist_item"."price_round", "product_pricelist_item"."price_surcharge", "product_pricelist_item"."price_min_margin", "product_pricelist_item"."price_max_margin", "product_pricelist_item"."create_uid", "product_pricelist_item"."create_date", "product_pricelist_item"."write_uid", "product_pricelist_item"."write_date" FROM "product_pricelist_item" WHERE "product_pricelist_item"."id" IN (38, 37, 36, 35, 34, 33, 32, 31, 30) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id" FROM "res_company" WHERE "res_company"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "product_taxes_rel"."prod_id", "product_taxes_rel"."tax_id" FROM "account_tax" JOIN "product_taxes_rel" ON ("product_taxes_rel"."tax_id" = "account_tax"."id") WHERE "account_tax"."type_tax_use" IN ('sale') AND "product_taxes_rel"."prod_id" IN (201) ORDER BY "account_tax"."sequence" , "account_tax"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_tax"."id", "account_tax"."name"->>'en_US', "account_tax"."type_tax_use", "account_tax"."tax_scope", "account_tax"."amount_type", "account_tax"."is_domestic", "account_tax"."active", "account_tax"."company_id", "account_tax"."sequence", "account_tax"."amount", "account_tax"."description"->>'en_US', "account_tax"."invoice_label"->>'en_US', "account_tax"."price_include_override", "account_tax"."include_base_amount", "account_tax"."is_base_affected", "account_tax"."analytic", "account_tax"."tax_group_id", "account_tax"."tax_exigibility", "account_tax"."cash_basis_transition_account_id", "account_tax"."country_id", "account_tax"."invoice_legal_notes"->>'en_US', "account_tax"."create_uid", "account_tax"."create_date", "account_tax"."write_uid", "account_tax"."write_date", "account_tax"."ubl_cii_tax_category_code", "account_tax"."ubl_cii_tax_exemption_reason", "account_tax"."ubl_cii_tax_exemption_reason_code", "account_tax"."formula" FROM "account_tax" WHERE "account_tax"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "res_users"."id", "res_users"."partner_id", "res_users"."login", "res_users"."signature", "res_users"."active", "res_users"."action_id", "res_users"."share", "res_users"."company_id", "res_users"."create_uid", "res_users"."create_date", "res_users"."write_uid", "res_users"."write_date", "res_users"."totp_last_counter", "res_users"."tour_enabled", "res_users"."microsoft_calendar_rtoken", "res_users"."microsoft_calendar_token", "res_users"."microsoft_calendar_token_validity", "res_users"."notification_type", "res_users"."out_of_office_from", "res_users"."out_of_office_to", "res_users"."out_of_office_message", "res_users"."manual_im_status", "res_users"."primary_calendar_id", "res_users"."karma", "res_users"."rank_id", "res_users"."next_rank_id", "res_users"."last_lunch_location_id", "res_users"."odoobot_state", "res_users"."odoobot_failed", "res_users"."sale_team_id", "res_users"."oauth_provider_id", "res_users"."oauth_uid", "res_users"."website_id" FROM "res_users" WHERE "res_users"."id" IN (3) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", "res_partner"."is_seo_optimized", "res_partner"."website_meta_og_img", "res_partner"."seo_name"->>'en_US', "res_partner"."website_id", "res_partner"."is_published", "res_partner"."publish_on", "res_partner"."published_date", "res_partner"."name", "res_partner"."complete_name", "res_partner"."parent_id", "res_partner"."ref", "res_partner"."lang", "res_partner"."tz", "res_partner"."user_id", "res_partner"."vat", "res_partner"."additional_identifiers", "res_partner"."website", "res_partner"."comment", "res_partner"."active", "res_partner"."employee", "res_partner"."function", "res_partner"."type", "res_partner"."street", "res_partner"."street2", "res_partner"."zip", "res_partner"."city", "res_partner"."state_id", "res_partner"."country_id", "res_partner"."partner_latitude", "res_partner"."partner_longitude", "res_partner"."email", "res_partner"."phone", "res_partner"."is_company", "res_partner"."industry_id", "res_partner"."company_id", "res_partner"."color", "res_partner"."partner_share", "res_partner"."commercial_partner_id", "res_partner"."commercial_company_name", "res_partner"."create_uid", "res_partner"."create_date", "res_partner"."write_uid", "res_partner"."write_date", "res_partner"."monetary", "res_partner"."street_name", "res_partner"."street_number", "res_partner"."street_number2", "res_partner"."city_id", "res_partner"."date_localization", "res_partner"."should_be_geolocalized", "res_partner"."email_normalized", "res_partner"."message_bounce", "res_partner"."signup_type", "res_partner"."calendar_last_notif_ack", "res_partner"."phone_sanitized", "res_partner"."invoice_template_pdf_report_id", "res_partner"."supplier_rank", "res_partner"."customer_rank", "res_partner"."autopost_bills", "res_partner"."picking_warn_msg", "res_partner"."routing_scheme", "res_partner"."routing_endpoint", "res_partner"."purchase_warn_msg", "res_partner"."buyer_id", "res_partner"."purchase_incoterm_location", "res_partner"."purchase_incoterm_id", "res_partner"."website_short_description"->>'en_US', "res_partner"."peppol_supported_documents", "res_partner"."suggest_based_on", "res_partner"."suggest_days", "res_partner"."suggest_percent", "res_partner"."group_rfq", "res_partner"."group_on", "res_partner"."sale_warn_msg", "res_partner"."incoterm_id", "res_partner"."incoterm_location", "res_partner"."grade_id", "res_partner"."pickup_location_data", "res_partner"."partner_weight", "res_partner"."grade_sequence", "res_partner"."activation", "res_partner"."date_partnership", "res_partner"."date_review", "res_partner"."date_review_next", "res_partner"."assigned_partner_id", "res_partner"."implemented_partner_count", "res_partner"."pickup_delivery_method_id" FROM "res_partner" WHERE "res_partner"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", (COALESCE("res_partner"."barcode"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (SELECT "product_pricelist__exists".id FROM "product_pricelist" AS "product_pricelist__exists" WHERE "product_pricelist__exists".id = (COALESCE("res_partner"."specific_property_product_pricelist"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."qr_code_method"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."credit_limit"->('1'::"varchar"),to_jsonb(0.0::"float8")))::"float8", (SELECT "account_account__exists".id FROM "account_account" AS "account_account__exists" WHERE "account_account__exists".id = (COALESCE("res_partner"."property_account_payable_id"->('1'::"varchar"),to_jsonb(14::"int4"))->>0)::"int4"), (SELECT "account_account__exists".id FROM "account_account" AS "account_account__exists" WHERE "account_account__exists".id = (COALESCE("res_partner"."property_account_receivable_id"->('1'::"varchar"),to_jsonb(5::"int4"))->>0)::"int4"), (SELECT "account_fiscal_position__exists".id FROM "account_fiscal_position" AS "account_fiscal_position__exists" WHERE "account_fiscal_position__exists".id = (COALESCE("res_partner"."property_account_position_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_term__exists".id FROM "account_payment_term" AS "account_payment_term__exists" WHERE "account_payment_term__exists".id = (COALESCE("res_partner"."property_payment_term_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_term__exists".id FROM "account_payment_term" AS "account_payment_term__exists" WHERE "account_payment_term__exists".id = (COALESCE("res_partner"."property_supplier_payment_term_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."trust"->('1'::"varchar"),to_jsonb('normal'::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."ignore_abnormal_invoice_date"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."ignore_abnormal_invoice_amount"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."invoice_sending_method"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."invoice_edi_format_store"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (SELECT "account_payment_method_line__exists".id FROM "account_payment_method_line" AS "account_payment_method_line__exists" WHERE "account_payment_method_line__exists".id = (COALESCE("res_partner"."property_outbound_payment_method_line_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_method_line__exists".id FROM "account_payment_method_line" AS "account_payment_method_line__exists" WHERE "account_payment_method_line__exists".id = (COALESCE("res_partner"."property_inbound_payment_method_line_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_customer"->('1'::"varchar"),to_jsonb(2::"int4"))->>0)::"int4"), (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_supplier"->('1'::"varchar"),to_jsonb(1::"int4"))->>0)::"int4"), (SELECT "res_currency__exists".id FROM "res_currency" AS "res_currency__exists" WHERE "res_currency__exists".id = (COALESCE("res_partner"."property_purchase_currency_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."receipt_reminder_email"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."reminder_date_before_receipt"->('1'::"varchar"),to_jsonb(1::"int4")))::"int4", (COALESCE("res_partner"."peppol_verification_state"->('1'::"varchar"),to_jsonb('not_verified'::"varchar"))->>0)::"varchar", (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_subcontractor"->('1'::"varchar"),to_jsonb(15::"int4"))->>0)::"int4"), (SELECT "delivery_carrier__exists".id FROM "delivery_carrier" AS "delivery_carrier__exists" WHERE "delivery_carrier__exists".id = (COALESCE("res_partner"."property_delivery_carrier_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4") FROM "res_partner" WHERE "res_partner"."id" IN (4) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", "res_partner"."is_seo_optimized", "res_partner"."website_meta_og_img", "res_partner"."seo_name"->>'en_US', "res_partner"."website_id", "res_partner"."is_published", "res_partner"."publish_on", "res_partner"."published_date", "res_partner"."name", "res_partner"."complete_name", "res_partner"."parent_id", "res_partner"."ref", "res_partner"."lang", "res_partner"."tz", "res_partner"."user_id", "res_partner"."vat", "res_partner"."additional_identifiers", "res_partner"."website", "res_partner"."comment", "res_partner"."active", "res_partner"."employee", "res_partner"."function", "res_partner"."type", "res_partner"."street", "res_partner"."street2", "res_partner"."zip", "res_partner"."city", "res_partner"."state_id", "res_partner"."country_id", "res_partner"."partner_latitude", "res_partner"."partner_longitude", "res_partner"."email", "res_partner"."phone", "res_partner"."is_company", "res_partner"."industry_id", "res_partner"."company_id", "res_partner"."color", "res_partner"."partner_share", "res_partner"."commercial_partner_id", "res_partner"."commercial_company_name", "res_partner"."create_uid", "res_partner"."create_date", "res_partner"."write_uid", "res_partner"."write_date", "res_partner"."monetary", "res_partner"."street_name", "res_partner"."street_number", "res_partner"."street_number2", "res_partner"."city_id", "res_partner"."date_localization", "res_partner"."should_be_geolocalized", "res_partner"."email_normalized", "res_partner"."message_bounce", "res_partner"."signup_type", "res_partner"."calendar_last_notif_ack", "res_partner"."phone_sanitized", "res_partner"."invoice_template_pdf_report_id", "res_partner"."supplier_rank", "res_partner"."customer_rank", "res_partner"."autopost_bills", "res_partner"."picking_warn_msg", "res_partner"."routing_scheme", "res_partner"."routing_endpoint", "res_partner"."purchase_warn_msg", "res_partner"."buyer_id", "res_partner"."purchase_incoterm_location", "res_partner"."purchase_incoterm_id", "res_partner"."website_short_description"->>'en_US', "res_partner"."peppol_supported_documents", "res_partner"."suggest_based_on", "res_partner"."suggest_days", "res_partner"."suggest_percent", "res_partner"."group_rfq", "res_partner"."group_on", "res_partner"."sale_warn_msg", "res_partner"."incoterm_id", "res_partner"."incoterm_location", "res_partner"."grade_id", "res_partner"."pickup_location_data", "res_partner"."partner_weight", "res_partner"."grade_sequence", "res_partner"."activation", "res_partner"."date_partnership", "res_partner"."date_review", "res_partner"."date_review_next", "res_partner"."assigned_partner_id", "res_partner"."implemented_partner_count", "res_partner"."pickup_delivery_method_id" FROM "res_partner" WHERE "res_partner"."id" IN (4) ---------------------------------------------------------------------------------------------------- SELECT "res_currency"."id", "res_currency"."name", "res_currency"."iso_numeric", "res_currency"."full_name", "res_currency"."symbol", "res_currency"."rounding", "res_currency"."decimal_places", "res_currency"."active", "res_currency"."position", "res_currency"."currency_unit_label"->>'en_US', "res_currency"."currency_subunit_label"->>'en_US', "res_currency"."create_uid", "res_currency"."create_date", "res_currency"."write_uid", "res_currency"."write_date" FROM "res_currency" WHERE "res_currency"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "account_tax_repartition_line"."id", "account_tax_repartition_line"."tax_id" FROM "account_tax_repartition_line" WHERE ("account_tax_repartition_line"."document_type" IN ('invoice') AND "account_tax_repartition_line"."tax_id" IN (1)) ORDER BY array_position(ARRAY['invoice','refund']::text[], "account_tax_repartition_line"."document_type"::text) , array_position(ARRAY['base','tax']::text[], "account_tax_repartition_line"."repartition_type"::text) , "account_tax_repartition_line"."sequence" , "account_tax_repartition_line"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_tax_repartition_line"."id", "account_tax_repartition_line"."factor_percent", "account_tax_repartition_line"."repartition_type", "account_tax_repartition_line"."document_type", "account_tax_repartition_line"."account_id", "account_tax_repartition_line"."company_id", "account_tax_repartition_line"."sequence", "account_tax_repartition_line"."use_in_tax_closing", "account_tax_repartition_line"."create_uid", "account_tax_repartition_line"."create_date", "account_tax_repartition_line"."write_uid", "account_tax_repartition_line"."write_date" FROM "account_tax_repartition_line" WHERE "account_tax_repartition_line"."id" IN (1, 2) ---------------------------------------------------------------------------------------------------- SELECT "account_account_tag_product_template_rel"."product_template_id", "account_account_tag_product_template_rel"."account_account_tag_id" FROM "account_account_tag" JOIN "account_account_tag_product_template_rel" ON ("account_account_tag_product_template_rel"."account_account_tag_id" = "account_account_tag"."id") WHERE "account_account_tag_product_template_rel"."product_template_id" IN (201) ORDER BY "account_account_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_account_tag_account_tax_repartition_line_rel"."account_tax_repartition_line_id", "account_account_tag_account_tax_repartition_line_rel"."account_account_tag_id" FROM "account_account_tag" JOIN "account_account_tag_account_tax_repartition_line_rel" ON ("account_account_tag_account_tax_repartition_line_rel"."account_account_tag_id" = "account_account_tag"."id") WHERE "account_account_tag"."applicability" IN ('taxes') AND "account_account_tag_account_tax_repartition_line_rel"."account_tax_repartition_line_id" IN (1, 2) ORDER BY "account_account_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_variant_combination"."product_product_id", "product_variant_combination"."product_template_attribute_value_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") JOIN "product_variant_combination" ON ("product_variant_combination"."product_template_attribute_value_id" = "product_template_attribute_value"."id") WHERE "product_variant_combination"."product_product_id" IN (250, 251, 252, 253, 254, 255, 256, 257, 258) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_value"."id", "product_template_attribute_value"."ptav_active", "product_template_attribute_value"."sequence", "product_template_attribute_value"."product_attribute_value_id", "product_template_attribute_value"."attribute_line_id", "product_template_attribute_value"."price_extra", "product_template_attribute_value"."show_price_extra", "product_template_attribute_value"."product_tmpl_id", "product_template_attribute_value"."attribute_id", "product_template_attribute_value"."color", "product_template_attribute_value"."create_uid", "product_template_attribute_value"."create_date", "product_template_attribute_value"."write_uid", "product_template_attribute_value"."write_date" FROM "product_template_attribute_value" WHERE "product_template_attribute_value"."id" IN (78, 81, 82, 83, 79, 80) ---------------------------------------------------------------------------------------------------- SELECT "product_attribute_value"."id", "product_attribute_value"."name"->>'en_US', "product_attribute_value"."sequence", "product_attribute_value"."attribute_id", "product_attribute_value"."default_extra_price", "product_attribute_value"."is_custom", "product_attribute_value"."html_color", "product_attribute_value"."color", "product_attribute_value"."active", "product_attribute_value"."create_uid", "product_attribute_value"."create_date", "product_attribute_value"."write_uid", "product_attribute_value"."write_date" FROM "product_attribute_value" WHERE "product_attribute_value"."id" IN (100, 103, 104, 105, 101, 102) ---------------------------------------------------------------------------------------------------- SELECT "product_attribute"."id", "product_attribute"."name"->>'en_US', "product_attribute"."active", "product_attribute"."create_variant", "product_attribute"."display_type", "product_attribute"."sequence", "product_attribute"."create_uid", "product_attribute"."create_date", "product_attribute"."write_uid", "product_attribute"."write_date", "product_attribute"."category_id", "product_attribute"."visibility", "product_attribute"."preview_variants", "product_attribute"."is_thumbnail_visible", "product_attribute"."external_identifier" FROM "product_attribute" WHERE "product_attribute"."id" IN (53, 54) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_value"."id", "product_template_attribute_value"."attribute_line_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") WHERE "product_template_attribute_value"."attribute_line_id" IN (35, 36) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_product"."id", "product_product"."lst_price", "product_product"."default_code", "product_product"."barcode", "product_product"."combination_indices", "product_product"."volume", "product_product"."weight", "product_product"."can_image_variant_1024_be_zoomed", "product_product"."write_date", "product_product"."is_favorite", "product_product"."base_unit_count", "product_product"."base_unit_id", "product_product"."create_uid", "product_product"."create_date", "product_product"."write_uid", "product_product"."lot_properties_definition", "product_product"."gelato_product_uid", "product_product"."hs_code", "product_product"."country_of_origin", "product_product"."variant_ribbon_id" FROM "product_product" WHERE "product_product"."id" IN (250, 251, 252, 253, 254, 255, 256, 257, 258) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_meta_title"->>'en_US', "product_template"."website_meta_description"->>'en_US', "product_template"."website_meta_keywords"->>'en_US' FROM "product_template" WHERE "product_template"."id" IN (201) AND (("product_template"."company_id" IN (1) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (1) OR "product_template"."website_id" IS NULL)) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_line"."id", "product_template_attribute_line"."product_tmpl_id", "product_template_attribute_line"."active" FROM "product_template_attribute_line" JOIN "product_attribute" AS "product_template_attribute_line__attribute_id" ON ("product_template_attribute_line"."attribute_id" = "product_template_attribute_line__attribute_id"."id") WHERE "product_template_attribute_line"."product_tmpl_id" IN (201) ORDER BY "product_template_attribute_line"."sequence" , "product_template_attribute_line__attribute_id"."sequence" , "product_template_attribute_line__attribute_id"."id" , "product_template_attribute_line"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_attribute_value_product_template_attribute_line_rel"."product_template_attribute_line_id", "product_attribute_value_product_template_attribute_line_rel"."product_attribute_value_id" FROM "product_attribute_value" JOIN "product_attribute" AS "product_attribute_value__attribute_id" ON ("product_attribute_value"."attribute_id" = "product_attribute_value__attribute_id"."id") JOIN "product_attribute_value_product_template_attribute_line_rel" ON ("product_attribute_value_product_template_attribute_line_rel"."product_attribute_value_id" = "product_attribute_value"."id") WHERE "product_attribute_value_product_template_attribute_line_rel"."product_template_attribute_line_id" IN (35, 36) ORDER BY "product_attribute_value__attribute_id"."sequence" , "product_attribute_value__attribute_id"."id" , "product_attribute_value"."sequence" , "product_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_line"."id", "product_template_attribute_line"."sequence", "product_template_attribute_line"."attribute_id", "product_template_attribute_line"."value_count", "product_template_attribute_line"."create_uid", "product_template_attribute_line"."create_date", "product_template_attribute_line"."write_uid", "product_template_attribute_line"."write_date" FROM "product_template_attribute_line" WHERE "product_template_attribute_line"."id" IN (35, 36) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_excluded_value_ids_rel"."product_template_attribute_value_id", "product_template_attribute_excluded_value_ids_rel"."excluded_product_template_attribute_value_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") JOIN "product_template_attribute_excluded_value_ids_rel" ON ("product_template_attribute_excluded_value_ids_rel"."excluded_product_template_attribute_value_id" = "product_template_attribute_value"."id") WHERE "product_template_attribute_excluded_value_ids_rel"."product_template_attribute_value_id" IN (78, 79, 80, 81, 82, 83) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (35) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (111) AND ("product_pricelist_item"."product_id" IN (250) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (201) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."uom_id" IN (1) OR "product_pricelist_item"."uom_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:07'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:06'::timestamp)) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "delivery_carrier"."id" FROM "delivery_carrier" WHERE ("delivery_carrier"."active" IS TRUE AND "delivery_carrier"."delivery_type" IN ('in_store') AND "delivery_carrier"."is_published" IS TRUE) ORDER BY "delivery_carrier"."sequence" , "delivery_carrier"."id" ---------------------------------------------------------------------------------------------------- SELECT "ir_ui_view"."id", "ir_ui_view"."is_seo_optimized", "ir_ui_view"."website_meta_og_img", "ir_ui_view"."seo_name"->>'en_US', "ir_ui_view"."name", "ir_ui_view"."model", "ir_ui_view"."key", "ir_ui_view"."priority", "ir_ui_view"."type", "ir_ui_view"."arch_db"->>'en_US', "ir_ui_view"."arch_fs", "ir_ui_view"."arch_updated", "ir_ui_view"."arch_prev", "ir_ui_view"."inherit_id", "ir_ui_view"."mode", "ir_ui_view"."notes", "ir_ui_view"."active", "ir_ui_view"."technical_usage", "ir_ui_view"."create_uid", "ir_ui_view"."create_date", "ir_ui_view"."write_uid", "ir_ui_view"."write_date", "ir_ui_view"."customize_show", "ir_ui_view"."website_id", "ir_ui_view"."track", "ir_ui_view"."visibility", "ir_ui_view"."visibility_password", "ir_ui_view"."theme_template_id" FROM "ir_ui_view" WHERE "ir_ui_view"."id" IN (5041) ---------------------------------------------------------------------------------------------------- SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."parent_id" IS NULL AND "product_public_category"."id" IN (SELECT unnest(string_to_array(left(c.parent_path, -1), '/'))::integer FROM (SELECT "product_public_category"."parent_path" FROM "product_public_category" WHERE EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_public_category__product_tmpl_ids" WHERE "product_public_category__product_tmpl_ids"."product_public_category_id" = "product_public_category"."id" AND "product_public_category__product_tmpl_ids"."product_template_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (1) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no', 'partnership', 'subcontract', 'repair', 'task_global_project', 'task_in_project', 'project_only') AND ("product_template"."website_id" IN (1) OR "product_template"."website_id" IS NULL))))) c) ORDER BY "product_public_category"."sequence" , "product_public_category"."name"->>'en_US' , "product_public_category"."id" ---------------------------------------------------------------------------------------------------- SELECT "website_menu"."id", "website_menu"."name"->>'en_US', "website_menu"."manual_url", "website_menu"."page_id", "website_menu"."controller_page_id", "website_menu"."new_window", "website_menu"."sequence", "website_menu"."website_id", "website_menu"."parent_id", "website_menu"."parent_path", "website_menu"."mega_menu_content"->>'en_US', "website_menu"."mega_menu_classes", "website_menu"."create_uid", "website_menu"."create_date", "website_menu"."write_uid", "website_menu"."write_date", "website_menu"."theme_template_id" FROM "website_menu" WHERE ("website_menu"."website_id" IN (1) OR "website_menu"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "res_groups_website_menu_rel" AS "website_menu__group_ids" WHERE "website_menu__group_ids"."website_menu_id" = "website_menu"."id" AND "website_menu__group_ids"."res_groups_id" IN (12, 2, 13, 81)) OR NOT EXISTS (SELECT 1 FROM "res_groups_website_menu_rel" AS "website_menu__group_ids" WHERE "website_menu__group_ids"."website_menu_id" = "website_menu"."id")) ORDER BY "website_menu"."sequence" , "website_menu"."id" ---------------------------------------------------------------------------------------------------- SELECT "website_page"."id", "website_page"."header_visible", "website_page"."footer_visible", "website_page"."breadcrumb_visible", "website_page"."header_overlay", "website_page"."header_color", "website_page"."header_text_color", "website_page"."breadcrumb_overlay", "website_page"."breadcrumb_color", "website_page"."breadcrumb_text_color", "website_page"."website_id", "website_page"."is_published", "website_page"."publish_on", "website_page"."published_date", "website_page"."name"->>'en_US', "website_page"."url"->>'en_US', "website_page"."view_id", "website_page"."website_indexed", "website_page"."is_new_page_template", "website_page"."parent_id", "website_page"."create_uid", "website_page"."create_date", "website_page"."write_uid", "website_page"."write_date", "website_page"."theme_template_id" FROM "website_page" WHERE "website_page"."id" IN (2, 5) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE ("product_pricelist"."active" IS TRUE AND ("product_pricelist"."company_id" IN (1) OR "product_pricelist"."company_id" IS NULL) AND ("product_pricelist"."website_id" IN (1) OR ("product_pricelist"."website_id" IS NULL AND ("product_pricelist"."code" NOT IN ('') OR "product_pricelist"."selectable" IS TRUE)))) ORDER BY "product_pricelist"."sequence" , "product_pricelist"."id" , "product_pricelist"."name"->>'en_US' ---------------------------------------------------------------------------------------------------- SELECT "product_product_image_rel"."product_product_id", "product_product_image_rel"."product_image_id" FROM "product_image" JOIN "product_product_image_rel" ON ("product_product_image_rel"."product_image_id" = "product_image"."id") WHERE "product_product_image_rel"."product_product_id" IN (250) ORDER BY "product_image"."sequence" , "product_image"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_image"."id", "product_image"."product_tmpl_id" FROM "product_image" WHERE "product_image"."product_tmpl_id" IN (201) ORDER BY "product_image"."sequence" , "product_image"."id" ---------------------------------------------------------------------------------------------------- SELECT "ir_attachment"."id", "ir_attachment"."name", "ir_attachment"."description", "ir_attachment"."res_model", "ir_attachment"."res_field", "ir_attachment"."res_id", "ir_attachment"."company_id", "ir_attachment"."type", "ir_attachment"."url", "ir_attachment"."public", "ir_attachment"."access_token", "ir_attachment"."store_fname", "ir_attachment"."file_size", "ir_attachment"."checksum", "ir_attachment"."mimetype", "ir_attachment"."create_uid", "ir_attachment"."create_date", "ir_attachment"."write_uid", "ir_attachment"."write_date", "ir_attachment"."original_id", "ir_attachment"."key", "ir_attachment"."website_id", "ir_attachment"."theme_template_id" FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IN ('image_variant_1920') AND "ir_attachment"."res_id" IN (250) AND "ir_attachment"."res_model" IN ('product.product')) ORDER BY "ir_attachment"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id", "product_ribbon"."name"->>'en_US', "product_ribbon"."sequence", "product_ribbon"."bg_color", "product_ribbon"."text_color", "product_ribbon"."position", "product_ribbon"."style", "product_ribbon"."assign", "product_ribbon"."new_period", "product_ribbon"."create_uid", "product_ribbon"."create_date", "product_ribbon"."write_uid", "product_ribbon"."write_date" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag_product_template_rel"."product_template_id", "product_tag_product_template_rel"."product_tag_id" FROM "product_tag" JOIN "product_tag_product_template_rel" ON ("product_tag_product_template_rel"."product_tag_id" = "product_tag"."id") WHERE "product_tag_product_template_rel"."product_template_id" IN (201) ORDER BY "product_tag"."sequence" , "product_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag_product_product_rel"."product_product_id", "product_tag_product_product_rel"."product_tag_id" FROM "product_tag" JOIN "product_tag_product_product_rel" ON ("product_tag_product_product_rel"."product_tag_id" = "product_tag"."id") WHERE "product_tag_product_product_rel"."product_product_id" IN (250) ORDER BY "product_tag"."sequence" , "product_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_document"."id", "product_document"."active", "product_document"."ir_attachment_id" FROM "product_document" JOIN "ir_attachment" AS "product_document__ir_attachment_id" ON ("product_document"."ir_attachment_id" = "product_document__ir_attachment_id"."id") WHERE ("product_document__ir_attachment_id"."res_id" IN (201) AND "product_document__ir_attachment_id"."res_model" IN ('product.template')) ORDER BY "product_document"."sequence" , "product_document__ir_attachment_id"."name" ---------------------------------------------------------------------------------------------------- SELECT "product_document"."id", "product_document"."active", "product_document"."ir_attachment_id" FROM "product_document" JOIN "ir_attachment" AS "product_document__ir_attachment_id" ON ("product_document"."ir_attachment_id" = "product_document__ir_attachment_id"."id") WHERE ("product_document__ir_attachment_id"."res_id" IN (250) AND "product_document__ir_attachment_id"."res_model" IN ('product.product')) ORDER BY "product_document"."sequence" , "product_document__ir_attachment_id"."name" ---------------------------------------------------------------------------------------------------- SELECT "website_sale_extra_field"."id", "website_sale_extra_field"."website_id" FROM "website_sale_extra_field" WHERE "website_sale_extra_field"."website_id" IN (1) ORDER BY "website_sale_extra_field"."sequence" ---------------------------------------------------------------------------------------------------- SELECT "product_alternative_rel"."src_id", "product_alternative_rel"."dest_id" FROM "product_template" JOIN "product_alternative_rel" ON ("product_alternative_rel"."dest_id" = "product_template"."id") WHERE "product_alternative_rel"."src_id" IN (201) ORDER BY COALESCE("product_template"."is_favorite", FALSE) DESC , "product_template"."name"->>'en_US' ----------------------------------------------------------------------------------------------------

odoo.addons.website_sale.tests.test_performance: FAIL: TestWebsiteSalePerformanceWithPricelistDepth.test_product_page_generation Traceback (most recent call last): File "/data/build/rb-aa5c29f-225760/addons/website_sale/tests/test_performance.py", line 319, in test_product_page_generation self._check_url_hot_query( ~~~~~~~~~~~~~~~~~~~~~~~~~^ self.heavy_product.website_url, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sum(select_queries.values()), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ select_tables_perf=select_queries, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/data/build/rb-aa5c29f-225760/addons/website/tests/test_performance.py", line 113, in _check_url_hot_query self.fail(msq) ~~~~~~~~~^^^^^ AssertionError: Expected 54 queries but 55 where ran: Diff of select queries: {'res_company': 1} Diff of insert queries: {} ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_id", "product_template"."is_published", "product_template"."publish_on", "product_template"."published_date", "product_template"."is_seo_optimized", "product_template"."website_meta_og_img", "product_template"."seo_name"->>'en_US', "product_template"."name"->>'en_US', "product_template"."sequence", "product_template"."description"->>'en_US', "product_template"."description_purchase"->>'en_US', "product_template"."description_sale"->>'en_US', "product_template"."type", "product_template"."service_tracking", "product_template"."categ_id", "product_template"."list_price", "product_template"."is_storable", "product_template"."volume", "product_template"."weight", "product_template"."sale_ok", "product_template"."purchase_ok", "product_template"."uom_id", "product_template"."company_id", "product_template"."active", "product_template"."color", "product_template"."barcode", "product_template"."default_code", "product_template"."can_image_1024_be_zoomed", "product_template"."has_configurable_attributes", "product_template"."is_favorite", "product_template"."base_unit_count", "product_template"."base_unit_id", "product_template"."create_uid", "product_template"."create_date", "product_template"."write_uid", "product_template"."write_date", "product_template"."tracking", "product_template"."lot_sequence_id", "product_template"."description_picking"->>'en_US', "product_template"."description_pickingout"->>'en_US', "product_template"."description_pickingin"->>'en_US', "product_template"."can_be_expensed", "product_template"."available_in_pos", "product_template"."to_weight", "product_template"."public_description"->>'en_US', "product_template"."pos_sequence", "product_template"."email_template_id", "product_template"."use_expiration_date", "product_template"."expiration_time", "product_template"."use_time", "product_template"."removal_time", "product_template"."alert_time", "product_template"."purchase_method", "product_template"."purchase_line_warn_msg", "product_template"."lot_valuated", "product_template"."service_type", "product_template"."sale_line_warn_msg", "product_template"."reinvoice_policy", "product_template"."invoice_policy", "product_template"."grade_id", "product_template"."self_order_available", "product_template"."product_add_mode", "product_template"."landed_cost_ok", "product_template"."split_method_landed_cost", "product_template"."gelato_template_ref", "product_template"."rating_last_value", "product_template"."website_description"->>'en_US', "product_template"."description_ecommerce"->>'en_US', "product_template"."dropzone_above_price"->>'en_US', "product_template"."dropzone_above_specification"->>'en_US', "product_template"."suggest_optional_products", "product_template"."suggest_accessory_products", "product_template"."suggest_alternative_products", "product_template"."suggested_products_last_update", "product_template"."website_size_x", "product_template"."website_size_y", "product_template"."website_ribbon_id", "product_template"."minimum_quantity", "product_template"."website_sequence", "product_template"."publish_date", "product_template"."compare_list_price", "product_template"."variants_default_code", "product_template"."allow_out_of_stock_order", "product_template"."available_threshold", "product_template"."show_availability", "product_template"."out_of_stock_message"->>'en_US', "product_template"."service_upsell_threshold" FROM "product_template" WHERE "product_template"."id" IN (206) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id", "res_company"."name", "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>'en_US', "res_company"."report_footer"->>'en_US', "res_company"."company_details"->>'en_US', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."report_tables_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."social_discord", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."tz", "res_company"."alias_domain_id", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."lunch_minimum_threshold", "res_company"."lunch_notify_message"->>'en_US', "res_company"."iap_enrich_auto_done", "res_company"."snailmail_color", "res_company"."snailmail_cover", "res_company"."snailmail_duplex", "res_company"."pay_now_label"->>'en_US', "res_company"."pay_later_label"->>'en_US', "res_company"."sms_provider", "res_company"."sms_twilio_account_sid", "res_company"."sms_twilio_auth_token", "res_company"."fiscalyear_last_day", "res_company"."fiscalyear_last_month", "res_company"."fiscalyear_lock_date", "res_company"."tax_lock_date", "res_company"."sale_lock_date", "res_company"."purchase_lock_date", "res_company"."hard_lock_date", "res_company"."transfer_account_id", "res_company"."expects_chart_of_accounts", "res_company"."chart_template", "res_company"."bank_account_code_prefix", "res_company"."cash_account_code_prefix", "res_company"."default_cash_difference_income_account_id", "res_company"."default_cash_difference_expense_account_id", "res_company"."account_journal_suspense_account_id", "res_company"."account_journal_early_pay_discount_gain_account_id", "res_company"."account_journal_early_pay_discount_loss_account_id", "res_company"."transfer_account_code_prefix", "res_company"."account_sale_tax_id", "res_company"."account_purchase_tax_id", "res_company"."account_purchase_receipt_fiscal_position_id", "res_company"."tax_calculation_rounding_method", "res_company"."currency_exchange_journal_id", "res_company"."income_currency_exchange_account_id", "res_company"."expense_currency_exchange_account_id", "res_company"."anglo_saxon_accounting", "res_company"."incoterm_id", "res_company"."qr_code", "res_company"."link_qr_code", "res_company"."display_invoice_amount_total_words", "res_company"."display_invoice_tax_company_currency", "res_company"."account_use_credit_limit", "res_company"."batch_payment_sequence_id", "res_company"."vat_check_vies", "res_company"."account_opening_move_id", "res_company"."account_opening_date", "res_company"."invoice_terms"->>'en_US', "res_company"."terms_type", "res_company"."invoice_terms_html"->>'en_US', "res_company"."account_default_pos_receivable_account_id", "res_company"."expense_accrual_account_id", "res_company"."revenue_accrual_account_id", "res_company"."automatic_entry_default_journal_id", "res_company"."domestic_fiscal_position_id", "res_company"."account_fiscal_country_id", "res_company"."vat_disabled", "res_company"."tax_exigibility", "res_company"."tax_cash_basis_journal_id", "res_company"."account_cash_basis_base_account_id", "res_company"."account_storno", "res_company"."quick_edit_mode_enabled", "res_company"."quick_edit_mode", "res_company"."document_sequence_editable", "res_company"."set_to_review_documents", "res_company"."account_discount_income_allocation_id", "res_company"."account_discount_expense_allocation_id", "res_company"."restrictive_audit_trail", "res_company"."autopost_bills", "res_company"."account_price_include", "res_company"."price_difference_account_id", "res_company"."inventory_period", "res_company"."hr_presence_control_email_amount", "res_company"."hr_presence_control_ip_list", "res_company"."employee_properties_definition", "res_company"."hr_presence_control_login", "res_company"."hr_presence_control_email", "res_company"."hr_presence_control_ip", "res_company"."hr_presence_control_attendance", "res_company"."contract_expiration_notice_period", "res_company"."work_permit_expiration_notice_period", "res_company"."internal_transit_location_id", "res_company"."stock_move_email_validation", "res_company"."stock_mail_confirmation_template_id", "res_company"."annual_inventory_month", "res_company"."annual_inventory_day", "res_company"."horizon_days", "res_company"."stock_text_confirmation", "res_company"."stock_confirmation_type", "res_company"."picking_policy", "res_company"."website_id", "res_company"."account_check_printing_layout", "res_company"."account_check_printing_date_label", "res_company"."account_check_printing_multi_stub", "res_company"."account_check_printing_margin_top", "res_company"."account_check_printing_margin_left", "res_company"."account_check_printing_margin_right", "res_company"."expense_journal_id", "res_company"."job_properties_definition", "res_company"."applicant_properties_definition", "res_company"."project_time_mode_id", "res_company"."timesheet_encode_uom_id", "res_company"."internal_project_id", "res_company"."external_code", "res_company"."point_of_sale_use_ticket_qr_code", "res_company"."point_of_sale_ticket_unique_code", "res_company"."point_of_sale_ticket_portal_url_display_mode", "res_company"."po_lock", "res_company"."po_double_validation", "res_company"."po_double_validation_amount", "res_company"."account_production_wip_account_id", "res_company"."account_production_wip_overhead_account_id", "res_company"."stock_sms_confirmation_template_id", "res_company"."has_received_warning_stock_sms", "res_company"."account_interco_clearing_journal_id", "res_company"."account_interco_payable_id", "res_company"."account_interco_receivable_id", "res_company"."account_peppol_contact_email", "res_company"."account_peppol_migration_key", "res_company"."account_peppol_phone_number", "res_company"."account_peppol_proxy_state", "res_company"."peppol_purchase_journal_id", "res_company"."peppol_external_provider", "res_company"."peppol_metadata", "res_company"."peppol_metadata_updated_at", "res_company"."attendance_kiosk_mode", "res_company"."attendance_barcode_source", "res_company"."attendance_kiosk_delay", "res_company"."attendance_kiosk_key", "res_company"."attendance_kiosk_use_pin", "res_company"."attendance_from_systray", "res_company"."auto_check_out", "res_company"."single_check_in", "res_company"."auto_check_out_mode", "res_company"."auto_check_out_tolerance", "res_company"."auto_check_out_specific_time", "res_company"."absence_management", "res_company"."attendance_validation", "res_company"."attendance_validation_tolerance", "res_company"."attendance_work_entry_type_id", "res_company"."attendance_device_tracking", "res_company"."attendance_capture_check_in", "res_company"."attendance_break_management", "res_company"."attendance_based", "res_company"."subcontracting_location_id", "res_company"."point_of_sale_update_stock_quantities", "res_company"."days_to_purchase", "res_company"."portal_confirmation_sign", "res_company"."portal_confirmation_pay", "res_company"."prepayment_percent", "res_company"."display_product_images_on_so", "res_company"."quotation_validity_days", "res_company"."sale_discount_product_id", "res_company"."sale_onboarding_payment_method", "res_company"."downpayment_account_id", "res_company"."show_sol_numbers", "res_company"."sale_invoice_policy", "res_company"."sale_automatic_invoice", "res_company"."hr_presence_last_compute_date", "res_company"."l10n_vn_edi_username", "res_company"."l10n_vn_edi_password", "res_company"."l10n_vn_edi_token", "res_company"."l10n_vn_edi_token_expiry", "res_company"."l10n_vn_edi_symbol_id", "res_company"."partnership_label"->>'en_US', "res_company"."leave_timesheet_task_id", "res_company"."allow_spontaneous_returns", "res_company"."return_validity_days", "res_company"."security_lead", "res_company"."lc_journal_id", "res_company"."l10n_vn_pos_default_symbol", "res_company"."l10n_vn_edi_send_transfer_note", "res_company"."l10n_vn_edi_stock_default_sinvoice_symbol_id", "res_company"."gelato_api_key", "res_company"."gelato_webhook_secret", "res_company"."free_order_label"->>'en_US', "res_company"."dropship_subcontractor_pick_type_id" FROM "res_company" WHERE "res_company"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "product_public_category_product_template_rel"."product_template_id", "product_public_category_product_template_rel"."product_public_category_id" FROM "product_public_category" JOIN "product_public_category_product_template_rel" ON ("product_public_category_product_template_rel"."product_public_category_id" = "product_public_category"."id") WHERE "product_public_category_product_template_rel"."product_template_id" IN (206) ORDER BY "product_public_category"."sequence" , "product_public_category"."name"->>'en_US' , "product_public_category"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_product"."id", "product_product"."product_tmpl_id", "product_product"."active" FROM "product_product" JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE "product_product"."product_tmpl_id" IN (206) ORDER BY "product_product"."default_code" , "product_product__product_tmpl_id"."name"->>'en_US' , "product_product"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (113) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (113) ---------------------------------------------------------------------------------------------------- SELECT "product_category"."id", "product_category"."name"->>'en_US', "product_category"."parent_id", "product_category"."parent_path", "product_category"."product_properties_definition", "product_category"."company_id", "product_category"."create_uid", "product_category"."create_date", "product_category"."write_uid", "product_category"."write_date", "product_category"."removal_strategy_id", "product_category"."packaging_reserve_method" FROM "product_category" WHERE "product_category"."id" IN (36) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (113) AND ("product_pricelist_item"."product_id" IN (265, 266, 267, 268, 269, 270, 271, 272, 273) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:17'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:16'::timestamp) AND (("product_pricelist_item"."min_quantity" IN ('0.00') OR "product_pricelist_item"."min_quantity" IS NULL) OR ("product_pricelist_item"."min_quantity" <= '1.00' OR "product_pricelist_item"."min_quantity" IS NULL))) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id", "product_pricelist_item"."pricelist_id", "product_pricelist_item"."company_id", "product_pricelist_item"."currency_id", "product_pricelist_item"."date_start", "product_pricelist_item"."date_end", "product_pricelist_item"."min_quantity", "product_pricelist_item"."applied_on", "product_pricelist_item"."categ_id", "product_pricelist_item"."product_tmpl_id", "product_pricelist_item"."product_id", "product_pricelist_item"."uom_id", "product_pricelist_item"."base", "product_pricelist_item"."base_pricelist_id", "product_pricelist_item"."compute_price", "product_pricelist_item"."fixed_price", "product_pricelist_item"."price_discount", "product_pricelist_item"."price_round", "product_pricelist_item"."price_surcharge", "product_pricelist_item"."price_min_margin", "product_pricelist_item"."price_max_margin", "product_pricelist_item"."create_uid", "product_pricelist_item"."create_date", "product_pricelist_item"."write_uid", "product_pricelist_item"."write_date" FROM "product_pricelist_item" WHERE "product_pricelist_item"."id" IN (50) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE "product_pricelist"."id" IN (112) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (112) AND ("product_pricelist_item"."product_id" IN (265, 266, 267, 268, 269, 270, 271, 272, 273) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:17'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:16'::timestamp) AND (("product_pricelist_item"."min_quantity" IN ('0.00') OR "product_pricelist_item"."min_quantity" IS NULL) OR ("product_pricelist_item"."min_quantity" <= '1.00' OR "product_pricelist_item"."min_quantity" IS NULL))) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id", "product_pricelist_item"."pricelist_id", "product_pricelist_item"."company_id", "product_pricelist_item"."currency_id", "product_pricelist_item"."date_start", "product_pricelist_item"."date_end", "product_pricelist_item"."min_quantity", "product_pricelist_item"."applied_on", "product_pricelist_item"."categ_id", "product_pricelist_item"."product_tmpl_id", "product_pricelist_item"."product_id", "product_pricelist_item"."uom_id", "product_pricelist_item"."base", "product_pricelist_item"."base_pricelist_id", "product_pricelist_item"."compute_price", "product_pricelist_item"."fixed_price", "product_pricelist_item"."price_discount", "product_pricelist_item"."price_round", "product_pricelist_item"."price_surcharge", "product_pricelist_item"."price_min_margin", "product_pricelist_item"."price_max_margin", "product_pricelist_item"."create_uid", "product_pricelist_item"."create_date", "product_pricelist_item"."write_uid", "product_pricelist_item"."write_date" FROM "product_pricelist_item" WHERE "product_pricelist_item"."id" IN (49, 48, 47, 46, 45, 44, 43, 42, 41) ---------------------------------------------------------------------------------------------------- SELECT "res_company"."id" FROM "res_company" WHERE "res_company"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "product_taxes_rel"."prod_id", "product_taxes_rel"."tax_id" FROM "account_tax" JOIN "product_taxes_rel" ON ("product_taxes_rel"."tax_id" = "account_tax"."id") WHERE "account_tax"."type_tax_use" IN ('sale') AND "product_taxes_rel"."prod_id" IN (206) ORDER BY "account_tax"."sequence" , "account_tax"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_tax"."id", "account_tax"."name"->>'en_US', "account_tax"."type_tax_use", "account_tax"."tax_scope", "account_tax"."amount_type", "account_tax"."is_domestic", "account_tax"."active", "account_tax"."company_id", "account_tax"."sequence", "account_tax"."amount", "account_tax"."description"->>'en_US', "account_tax"."invoice_label"->>'en_US', "account_tax"."price_include_override", "account_tax"."include_base_amount", "account_tax"."is_base_affected", "account_tax"."analytic", "account_tax"."tax_group_id", "account_tax"."tax_exigibility", "account_tax"."cash_basis_transition_account_id", "account_tax"."country_id", "account_tax"."invoice_legal_notes"->>'en_US', "account_tax"."create_uid", "account_tax"."create_date", "account_tax"."write_uid", "account_tax"."write_date", "account_tax"."ubl_cii_tax_category_code", "account_tax"."ubl_cii_tax_exemption_reason", "account_tax"."ubl_cii_tax_exemption_reason_code", "account_tax"."formula" FROM "account_tax" WHERE "account_tax"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "res_users"."id", "res_users"."partner_id", "res_users"."login", "res_users"."signature", "res_users"."active", "res_users"."action_id", "res_users"."share", "res_users"."company_id", "res_users"."create_uid", "res_users"."create_date", "res_users"."write_uid", "res_users"."write_date", "res_users"."totp_last_counter", "res_users"."tour_enabled", "res_users"."microsoft_calendar_rtoken", "res_users"."microsoft_calendar_token", "res_users"."microsoft_calendar_token_validity", "res_users"."notification_type", "res_users"."out_of_office_from", "res_users"."out_of_office_to", "res_users"."out_of_office_message", "res_users"."manual_im_status", "res_users"."primary_calendar_id", "res_users"."karma", "res_users"."rank_id", "res_users"."next_rank_id", "res_users"."last_lunch_location_id", "res_users"."odoobot_state", "res_users"."odoobot_failed", "res_users"."sale_team_id", "res_users"."oauth_provider_id", "res_users"."oauth_uid", "res_users"."website_id" FROM "res_users" WHERE "res_users"."id" IN (3) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", "res_partner"."is_seo_optimized", "res_partner"."website_meta_og_img", "res_partner"."seo_name"->>'en_US', "res_partner"."website_id", "res_partner"."is_published", "res_partner"."publish_on", "res_partner"."published_date", "res_partner"."name", "res_partner"."complete_name", "res_partner"."parent_id", "res_partner"."ref", "res_partner"."lang", "res_partner"."tz", "res_partner"."user_id", "res_partner"."vat", "res_partner"."additional_identifiers", "res_partner"."website", "res_partner"."comment", "res_partner"."active", "res_partner"."employee", "res_partner"."function", "res_partner"."type", "res_partner"."street", "res_partner"."street2", "res_partner"."zip", "res_partner"."city", "res_partner"."state_id", "res_partner"."country_id", "res_partner"."partner_latitude", "res_partner"."partner_longitude", "res_partner"."email", "res_partner"."phone", "res_partner"."is_company", "res_partner"."industry_id", "res_partner"."company_id", "res_partner"."color", "res_partner"."partner_share", "res_partner"."commercial_partner_id", "res_partner"."commercial_company_name", "res_partner"."create_uid", "res_partner"."create_date", "res_partner"."write_uid", "res_partner"."write_date", "res_partner"."monetary", "res_partner"."street_name", "res_partner"."street_number", "res_partner"."street_number2", "res_partner"."city_id", "res_partner"."date_localization", "res_partner"."should_be_geolocalized", "res_partner"."email_normalized", "res_partner"."message_bounce", "res_partner"."signup_type", "res_partner"."calendar_last_notif_ack", "res_partner"."phone_sanitized", "res_partner"."invoice_template_pdf_report_id", "res_partner"."supplier_rank", "res_partner"."customer_rank", "res_partner"."autopost_bills", "res_partner"."picking_warn_msg", "res_partner"."routing_scheme", "res_partner"."routing_endpoint", "res_partner"."purchase_warn_msg", "res_partner"."buyer_id", "res_partner"."purchase_incoterm_location", "res_partner"."purchase_incoterm_id", "res_partner"."website_short_description"->>'en_US', "res_partner"."peppol_supported_documents", "res_partner"."suggest_based_on", "res_partner"."suggest_days", "res_partner"."suggest_percent", "res_partner"."group_rfq", "res_partner"."group_on", "res_partner"."sale_warn_msg", "res_partner"."incoterm_id", "res_partner"."incoterm_location", "res_partner"."grade_id", "res_partner"."pickup_location_data", "res_partner"."partner_weight", "res_partner"."grade_sequence", "res_partner"."activation", "res_partner"."date_partnership", "res_partner"."date_review", "res_partner"."date_review_next", "res_partner"."assigned_partner_id", "res_partner"."implemented_partner_count", "res_partner"."pickup_delivery_method_id" FROM "res_partner" WHERE "res_partner"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", (COALESCE("res_partner"."barcode"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (SELECT "product_pricelist__exists".id FROM "product_pricelist" AS "product_pricelist__exists" WHERE "product_pricelist__exists".id = (COALESCE("res_partner"."specific_property_product_pricelist"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."qr_code_method"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."credit_limit"->('1'::"varchar"),to_jsonb(0.0::"float8")))::"float8", (SELECT "account_account__exists".id FROM "account_account" AS "account_account__exists" WHERE "account_account__exists".id = (COALESCE("res_partner"."property_account_payable_id"->('1'::"varchar"),to_jsonb(14::"int4"))->>0)::"int4"), (SELECT "account_account__exists".id FROM "account_account" AS "account_account__exists" WHERE "account_account__exists".id = (COALESCE("res_partner"."property_account_receivable_id"->('1'::"varchar"),to_jsonb(5::"int4"))->>0)::"int4"), (SELECT "account_fiscal_position__exists".id FROM "account_fiscal_position" AS "account_fiscal_position__exists" WHERE "account_fiscal_position__exists".id = (COALESCE("res_partner"."property_account_position_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_term__exists".id FROM "account_payment_term" AS "account_payment_term__exists" WHERE "account_payment_term__exists".id = (COALESCE("res_partner"."property_payment_term_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_term__exists".id FROM "account_payment_term" AS "account_payment_term__exists" WHERE "account_payment_term__exists".id = (COALESCE("res_partner"."property_supplier_payment_term_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."trust"->('1'::"varchar"),to_jsonb('normal'::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."ignore_abnormal_invoice_date"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."ignore_abnormal_invoice_amount"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."invoice_sending_method"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (COALESCE("res_partner"."invoice_edi_format_store"->('1'::"varchar"),to_jsonb(NULL::"varchar"))->>0)::"varchar", (SELECT "account_payment_method_line__exists".id FROM "account_payment_method_line" AS "account_payment_method_line__exists" WHERE "account_payment_method_line__exists".id = (COALESCE("res_partner"."property_outbound_payment_method_line_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "account_payment_method_line__exists".id FROM "account_payment_method_line" AS "account_payment_method_line__exists" WHERE "account_payment_method_line__exists".id = (COALESCE("res_partner"."property_inbound_payment_method_line_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_customer"->('1'::"varchar"),to_jsonb(2::"int4"))->>0)::"int4"), (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_supplier"->('1'::"varchar"),to_jsonb(1::"int4"))->>0)::"int4"), (SELECT "res_currency__exists".id FROM "res_currency" AS "res_currency__exists" WHERE "res_currency__exists".id = (COALESCE("res_partner"."property_purchase_currency_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4"), (COALESCE("res_partner"."receipt_reminder_email"->('1'::"varchar"),to_jsonb(false::"bool")))::"bool", (COALESCE("res_partner"."reminder_date_before_receipt"->('1'::"varchar"),to_jsonb(1::"int4")))::"int4", (COALESCE("res_partner"."peppol_verification_state"->('1'::"varchar"),to_jsonb('not_verified'::"varchar"))->>0)::"varchar", (SELECT "stock_location__exists".id FROM "stock_location" AS "stock_location__exists" WHERE "stock_location__exists".id = (COALESCE("res_partner"."property_stock_subcontractor"->('1'::"varchar"),to_jsonb(15::"int4"))->>0)::"int4"), (SELECT "delivery_carrier__exists".id FROM "delivery_carrier" AS "delivery_carrier__exists" WHERE "delivery_carrier__exists".id = (COALESCE("res_partner"."property_delivery_carrier_id"->('1'::"varchar"),to_jsonb(NULL::"int4"))->>0)::"int4") FROM "res_partner" WHERE "res_partner"."id" IN (4) ---------------------------------------------------------------------------------------------------- SELECT "res_partner"."id", "res_partner"."is_seo_optimized", "res_partner"."website_meta_og_img", "res_partner"."seo_name"->>'en_US', "res_partner"."website_id", "res_partner"."is_published", "res_partner"."publish_on", "res_partner"."published_date", "res_partner"."name", "res_partner"."complete_name", "res_partner"."parent_id", "res_partner"."ref", "res_partner"."lang", "res_partner"."tz", "res_partner"."user_id", "res_partner"."vat", "res_partner"."additional_identifiers", "res_partner"."website", "res_partner"."comment", "res_partner"."active", "res_partner"."employee", "res_partner"."function", "res_partner"."type", "res_partner"."street", "res_partner"."street2", "res_partner"."zip", "res_partner"."city", "res_partner"."state_id", "res_partner"."country_id", "res_partner"."partner_latitude", "res_partner"."partner_longitude", "res_partner"."email", "res_partner"."phone", "res_partner"."is_company", "res_partner"."industry_id", "res_partner"."company_id", "res_partner"."color", "res_partner"."partner_share", "res_partner"."commercial_partner_id", "res_partner"."commercial_company_name", "res_partner"."create_uid", "res_partner"."create_date", "res_partner"."write_uid", "res_partner"."write_date", "res_partner"."monetary", "res_partner"."street_name", "res_partner"."street_number", "res_partner"."street_number2", "res_partner"."city_id", "res_partner"."date_localization", "res_partner"."should_be_geolocalized", "res_partner"."email_normalized", "res_partner"."message_bounce", "res_partner"."signup_type", "res_partner"."calendar_last_notif_ack", "res_partner"."phone_sanitized", "res_partner"."invoice_template_pdf_report_id", "res_partner"."supplier_rank", "res_partner"."customer_rank", "res_partner"."autopost_bills", "res_partner"."picking_warn_msg", "res_partner"."routing_scheme", "res_partner"."routing_endpoint", "res_partner"."purchase_warn_msg", "res_partner"."buyer_id", "res_partner"."purchase_incoterm_location", "res_partner"."purchase_incoterm_id", "res_partner"."website_short_description"->>'en_US', "res_partner"."peppol_supported_documents", "res_partner"."suggest_based_on", "res_partner"."suggest_days", "res_partner"."suggest_percent", "res_partner"."group_rfq", "res_partner"."group_on", "res_partner"."sale_warn_msg", "res_partner"."incoterm_id", "res_partner"."incoterm_location", "res_partner"."grade_id", "res_partner"."pickup_location_data", "res_partner"."partner_weight", "res_partner"."grade_sequence", "res_partner"."activation", "res_partner"."date_partnership", "res_partner"."date_review", "res_partner"."date_review_next", "res_partner"."assigned_partner_id", "res_partner"."implemented_partner_count", "res_partner"."pickup_delivery_method_id" FROM "res_partner" WHERE "res_partner"."id" IN (4) ---------------------------------------------------------------------------------------------------- SELECT "res_currency"."id", "res_currency"."name", "res_currency"."iso_numeric", "res_currency"."full_name", "res_currency"."symbol", "res_currency"."rounding", "res_currency"."decimal_places", "res_currency"."active", "res_currency"."position", "res_currency"."currency_unit_label"->>'en_US', "res_currency"."currency_subunit_label"->>'en_US', "res_currency"."create_uid", "res_currency"."create_date", "res_currency"."write_uid", "res_currency"."write_date" FROM "res_currency" WHERE "res_currency"."id" IN (1) ---------------------------------------------------------------------------------------------------- SELECT "account_tax_repartition_line"."id", "account_tax_repartition_line"."tax_id" FROM "account_tax_repartition_line" WHERE ("account_tax_repartition_line"."document_type" IN ('invoice') AND "account_tax_repartition_line"."tax_id" IN (1)) ORDER BY array_position(ARRAY['invoice','refund']::text[], "account_tax_repartition_line"."document_type"::text) , array_position(ARRAY['base','tax']::text[], "account_tax_repartition_line"."repartition_type"::text) , "account_tax_repartition_line"."sequence" , "account_tax_repartition_line"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_tax_repartition_line"."id", "account_tax_repartition_line"."factor_percent", "account_tax_repartition_line"."repartition_type", "account_tax_repartition_line"."document_type", "account_tax_repartition_line"."account_id", "account_tax_repartition_line"."company_id", "account_tax_repartition_line"."sequence", "account_tax_repartition_line"."use_in_tax_closing", "account_tax_repartition_line"."create_uid", "account_tax_repartition_line"."create_date", "account_tax_repartition_line"."write_uid", "account_tax_repartition_line"."write_date" FROM "account_tax_repartition_line" WHERE "account_tax_repartition_line"."id" IN (1, 2) ---------------------------------------------------------------------------------------------------- SELECT "account_account_tag_product_template_rel"."product_template_id", "account_account_tag_product_template_rel"."account_account_tag_id" FROM "account_account_tag" JOIN "account_account_tag_product_template_rel" ON ("account_account_tag_product_template_rel"."account_account_tag_id" = "account_account_tag"."id") WHERE "account_account_tag_product_template_rel"."product_template_id" IN (206) ORDER BY "account_account_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "account_account_tag_account_tax_repartition_line_rel"."account_tax_repartition_line_id", "account_account_tag_account_tax_repartition_line_rel"."account_account_tag_id" FROM "account_account_tag" JOIN "account_account_tag_account_tax_repartition_line_rel" ON ("account_account_tag_account_tax_repartition_line_rel"."account_account_tag_id" = "account_account_tag"."id") WHERE "account_account_tag"."applicability" IN ('taxes') AND "account_account_tag_account_tax_repartition_line_rel"."account_tax_repartition_line_id" IN (1, 2) ORDER BY "account_account_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_variant_combination"."product_product_id", "product_variant_combination"."product_template_attribute_value_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") JOIN "product_variant_combination" ON ("product_variant_combination"."product_template_attribute_value_id" = "product_template_attribute_value"."id") WHERE "product_variant_combination"."product_product_id" IN (265, 266, 267, 268, 269, 270, 271, 272, 273) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_value"."id", "product_template_attribute_value"."ptav_active", "product_template_attribute_value"."sequence", "product_template_attribute_value"."product_attribute_value_id", "product_template_attribute_value"."attribute_line_id", "product_template_attribute_value"."price_extra", "product_template_attribute_value"."show_price_extra", "product_template_attribute_value"."product_tmpl_id", "product_template_attribute_value"."attribute_id", "product_template_attribute_value"."color", "product_template_attribute_value"."create_uid", "product_template_attribute_value"."create_date", "product_template_attribute_value"."write_uid", "product_template_attribute_value"."write_date" FROM "product_template_attribute_value" WHERE "product_template_attribute_value"."id" IN (87, 90, 91, 92, 88, 89) ---------------------------------------------------------------------------------------------------- SELECT "product_attribute_value"."id", "product_attribute_value"."name"->>'en_US', "product_attribute_value"."sequence", "product_attribute_value"."attribute_id", "product_attribute_value"."default_extra_price", "product_attribute_value"."is_custom", "product_attribute_value"."html_color", "product_attribute_value"."color", "product_attribute_value"."active", "product_attribute_value"."create_uid", "product_attribute_value"."create_date", "product_attribute_value"."write_uid", "product_attribute_value"."write_date" FROM "product_attribute_value" WHERE "product_attribute_value"."id" IN (111, 114, 115, 116, 112, 113) ---------------------------------------------------------------------------------------------------- SELECT "product_attribute"."id", "product_attribute"."name"->>'en_US', "product_attribute"."active", "product_attribute"."create_variant", "product_attribute"."display_type", "product_attribute"."sequence", "product_attribute"."create_uid", "product_attribute"."create_date", "product_attribute"."write_uid", "product_attribute"."write_date", "product_attribute"."category_id", "product_attribute"."visibility", "product_attribute"."preview_variants", "product_attribute"."is_thumbnail_visible", "product_attribute"."external_identifier" FROM "product_attribute" WHERE "product_attribute"."id" IN (58, 59) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_value"."id", "product_template_attribute_value"."attribute_line_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") WHERE "product_template_attribute_value"."attribute_line_id" IN (38, 39) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_product"."id", "product_product"."lst_price", "product_product"."default_code", "product_product"."barcode", "product_product"."combination_indices", "product_product"."volume", "product_product"."weight", "product_product"."can_image_variant_1024_be_zoomed", "product_product"."write_date", "product_product"."is_favorite", "product_product"."base_unit_count", "product_product"."base_unit_id", "product_product"."create_uid", "product_product"."create_date", "product_product"."write_uid", "product_product"."lot_properties_definition", "product_product"."gelato_product_uid", "product_product"."hs_code", "product_product"."country_of_origin", "product_product"."variant_ribbon_id" FROM "product_product" WHERE "product_product"."id" IN (265, 266, 267, 268, 269, 270, 271, 272, 273) ---------------------------------------------------------------------------------------------------- SELECT "product_template"."id", "product_template"."website_meta_title"->>'en_US', "product_template"."website_meta_description"->>'en_US', "product_template"."website_meta_keywords"->>'en_US' FROM "product_template" WHERE "product_template"."id" IN (206) AND (("product_template"."company_id" IN (1) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND ("product_template"."website_id" IN (1) OR "product_template"."website_id" IS NULL)) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_line"."id", "product_template_attribute_line"."product_tmpl_id", "product_template_attribute_line"."active" FROM "product_template_attribute_line" JOIN "product_attribute" AS "product_template_attribute_line__attribute_id" ON ("product_template_attribute_line"."attribute_id" = "product_template_attribute_line__attribute_id"."id") WHERE "product_template_attribute_line"."product_tmpl_id" IN (206) ORDER BY "product_template_attribute_line"."sequence" , "product_template_attribute_line__attribute_id"."sequence" , "product_template_attribute_line__attribute_id"."id" , "product_template_attribute_line"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_attribute_value_product_template_attribute_line_rel"."product_template_attribute_line_id", "product_attribute_value_product_template_attribute_line_rel"."product_attribute_value_id" FROM "product_attribute_value" JOIN "product_attribute" AS "product_attribute_value__attribute_id" ON ("product_attribute_value"."attribute_id" = "product_attribute_value__attribute_id"."id") JOIN "product_attribute_value_product_template_attribute_line_rel" ON ("product_attribute_value_product_template_attribute_line_rel"."product_attribute_value_id" = "product_attribute_value"."id") WHERE "product_attribute_value_product_template_attribute_line_rel"."product_template_attribute_line_id" IN (38, 39) ORDER BY "product_attribute_value__attribute_id"."sequence" , "product_attribute_value__attribute_id"."id" , "product_attribute_value"."sequence" , "product_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_line"."id", "product_template_attribute_line"."sequence", "product_template_attribute_line"."attribute_id", "product_template_attribute_line"."value_count", "product_template_attribute_line"."create_uid", "product_template_attribute_line"."create_date", "product_template_attribute_line"."write_uid", "product_template_attribute_line"."write_date" FROM "product_template_attribute_line" WHERE "product_template_attribute_line"."id" IN (38, 39) ---------------------------------------------------------------------------------------------------- SELECT "product_template_attribute_excluded_value_ids_rel"."product_template_attribute_value_id", "product_template_attribute_excluded_value_ids_rel"."excluded_product_template_attribute_value_id" FROM "product_template_attribute_value" JOIN "product_template_attribute_line" AS "product_template_attribute_value__attribute_line_id" ON ("product_template_attribute_value"."attribute_line_id" = "product_template_attribute_value__attribute_line_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__attribute_line_id__a_fcdd6886" ON ("product_template_attribute_value__attribute_line_id"."attribute_id" = "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id") JOIN "product_attribute_value" AS "product_template_attribute_value__product_attribute_value_id" ON ("product_template_attribute_value"."product_attribute_value_id" = "product_template_attribute_value__product_attribute_value_id"."id") JOIN "product_attribute" AS "product_template_attribute_value__product_attribute_va_2b56e51d" ON ("product_template_attribute_value__product_attribute_value_id"."attribute_id" = "product_template_attribute_value__product_attribute_va_2b56e51d"."id") JOIN "product_template_attribute_excluded_value_ids_rel" ON ("product_template_attribute_excluded_value_ids_rel"."excluded_product_template_attribute_value_id" = "product_template_attribute_value"."id") WHERE "product_template_attribute_excluded_value_ids_rel"."product_template_attribute_value_id" IN (87, 88, 89, 90, 91, 92) ORDER BY "product_template_attribute_value"."sequence" , "product_template_attribute_value__attribute_line_id"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."sequence" , "product_template_attribute_value__attribute_line_id__a_fcdd6886"."id" , "product_template_attribute_value__attribute_line_id"."id" , "product_template_attribute_value__product_attribute_va_2b56e51d"."sequence" , "product_template_attribute_value__product_attribute_va_2b56e51d"."id" , "product_template_attribute_value__product_attribute_value_id"."sequence" , "product_template_attribute_value__product_attribute_value_id"."id" , "product_template_attribute_value"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (113) AND ("product_pricelist_item"."product_id" IN (265) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."uom_id" IN (1) OR "product_pricelist_item"."uom_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:18'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:17'::timestamp)) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (112) AND ("product_pricelist_item"."product_id" IN (265) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."uom_id" IN (1) OR "product_pricelist_item"."uom_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:18'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:17'::timestamp)) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (112) AND ("product_pricelist_item"."product_id" IN (265) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."uom_id" IN (1) OR "product_pricelist_item"."uom_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:18'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:17'::timestamp)) AND ("product_pricelist_item"."company_id" IN (1) OR "product_pricelist_item"."company_id" IS NULL) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist_item"."id" FROM "product_pricelist_item" LEFT JOIN "product_category" AS "product_pricelist_item__categ_id" ON ("product_pricelist_item"."categ_id" = "product_pricelist_item__categ_id"."id") LEFT JOIN "product_category" AS "product_pricelist_item__categ_id__parent_id" ON ("product_pricelist_item__categ_id"."parent_id" = "product_pricelist_item__categ_id__parent_id"."id") WHERE (("product_pricelist_item"."categ_id" IN (36) OR "product_pricelist_item"."categ_id" IS NULL) AND "product_pricelist_item"."pricelist_id" IN (112) AND ("product_pricelist_item"."product_id" IN (265) OR "product_pricelist_item"."product_id" IS NULL) AND ("product_pricelist_item"."product_tmpl_id" IN (206) OR "product_pricelist_item"."product_tmpl_id" IS NULL) AND ("product_pricelist_item"."uom_id" IN (1) OR "product_pricelist_item"."uom_id" IS NULL) AND ("product_pricelist_item"."date_start" IS NULL OR "product_pricelist_item"."date_start" < '2026-10-20T09:51:18'::timestamp) AND ("product_pricelist_item"."date_end" IS NULL OR "product_pricelist_item"."date_end" >= '2026-10-20T09:51:17'::timestamp)) AND ("product_pricelist_item"."company_id" IN (1) OR "product_pricelist_item"."company_id" IS NULL) ORDER BY array_position(ARRAY['0_product_variant','1_product','2_product_category','3_global']::text[], "product_pricelist_item"."applied_on"::text) , "product_pricelist_item"."min_quantity" DESC , "product_pricelist_item__categ_id__parent_id"."name"->>'en_US' ASC , "product_pricelist_item__categ_id"."name"->>'en_US' DESC , "product_pricelist_item"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "delivery_carrier"."id" FROM "delivery_carrier" WHERE ("delivery_carrier"."active" IS TRUE AND "delivery_carrier"."delivery_type" IN ('in_store') AND "delivery_carrier"."is_published" IS TRUE) ORDER BY "delivery_carrier"."sequence" , "delivery_carrier"."id" ---------------------------------------------------------------------------------------------------- SELECT "ir_ui_view"."id", "ir_ui_view"."is_seo_optimized", "ir_ui_view"."website_meta_og_img", "ir_ui_view"."seo_name"->>'en_US', "ir_ui_view"."name", "ir_ui_view"."model", "ir_ui_view"."key", "ir_ui_view"."priority", "ir_ui_view"."type", "ir_ui_view"."arch_db"->>'en_US', "ir_ui_view"."arch_fs", "ir_ui_view"."arch_updated", "ir_ui_view"."arch_prev", "ir_ui_view"."inherit_id", "ir_ui_view"."mode", "ir_ui_view"."notes", "ir_ui_view"."active", "ir_ui_view"."technical_usage", "ir_ui_view"."create_uid", "ir_ui_view"."create_date", "ir_ui_view"."write_uid", "ir_ui_view"."write_date", "ir_ui_view"."customize_show", "ir_ui_view"."website_id", "ir_ui_view"."track", "ir_ui_view"."visibility", "ir_ui_view"."visibility_password", "ir_ui_view"."theme_template_id" FROM "ir_ui_view" WHERE "ir_ui_view"."id" IN (5041) ---------------------------------------------------------------------------------------------------- SELECT "product_public_category"."id" FROM "product_public_category" WHERE "product_public_category"."parent_id" IS NULL AND "product_public_category"."id" IN (SELECT unnest(string_to_array(left(c.parent_path, -1), '/'))::integer FROM (SELECT "product_public_category"."parent_path" FROM "product_public_category" WHERE EXISTS (SELECT 1 FROM "product_public_category_product_template_rel" AS "product_public_category__product_tmpl_ids" WHERE "product_public_category__product_tmpl_ids"."product_public_category_id" = "product_public_category"."id" AND "product_public_category__product_tmpl_ids"."product_template_id" IN (SELECT "product_template"."id" FROM "product_template" WHERE ("product_template"."active" IS TRUE AND ("product_template"."company_id" IN (1) OR "product_template"."company_id" IS NULL) AND "product_template"."is_published" IS TRUE AND "product_template"."sale_ok" IS TRUE AND "product_template"."service_tracking" IN ('no', 'partnership', 'subcontract', 'repair', 'task_global_project', 'task_in_project', 'project_only') AND ("product_template"."website_id" IN (1) OR "product_template"."website_id" IS NULL))))) c) ORDER BY "product_public_category"."sequence" , "product_public_category"."name"->>'en_US' , "product_public_category"."id" ---------------------------------------------------------------------------------------------------- SELECT "website_menu"."id", "website_menu"."name"->>'en_US', "website_menu"."manual_url", "website_menu"."page_id", "website_menu"."controller_page_id", "website_menu"."new_window", "website_menu"."sequence", "website_menu"."website_id", "website_menu"."parent_id", "website_menu"."parent_path", "website_menu"."mega_menu_content"->>'en_US', "website_menu"."mega_menu_classes", "website_menu"."create_uid", "website_menu"."create_date", "website_menu"."write_uid", "website_menu"."write_date", "website_menu"."theme_template_id" FROM "website_menu" WHERE ("website_menu"."website_id" IN (1) OR "website_menu"."website_id" IS NULL) AND (EXISTS (SELECT 1 FROM "res_groups_website_menu_rel" AS "website_menu__group_ids" WHERE "website_menu__group_ids"."website_menu_id" = "website_menu"."id" AND "website_menu__group_ids"."res_groups_id" IN (12, 2, 13, 81)) OR NOT EXISTS (SELECT 1 FROM "res_groups_website_menu_rel" AS "website_menu__group_ids" WHERE "website_menu__group_ids"."website_menu_id" = "website_menu"."id")) ORDER BY "website_menu"."sequence" , "website_menu"."id" ---------------------------------------------------------------------------------------------------- SELECT "website_page"."id", "website_page"."header_visible", "website_page"."footer_visible", "website_page"."breadcrumb_visible", "website_page"."header_overlay", "website_page"."header_color", "website_page"."header_text_color", "website_page"."breadcrumb_overlay", "website_page"."breadcrumb_color", "website_page"."breadcrumb_text_color", "website_page"."website_id", "website_page"."is_published", "website_page"."publish_on", "website_page"."published_date", "website_page"."name"->>'en_US', "website_page"."url"->>'en_US', "website_page"."view_id", "website_page"."website_indexed", "website_page"."is_new_page_template", "website_page"."parent_id", "website_page"."create_uid", "website_page"."create_date", "website_page"."write_uid", "website_page"."write_date", "website_page"."theme_template_id" FROM "website_page" WHERE "website_page"."id" IN (2, 5) ---------------------------------------------------------------------------------------------------- SELECT "product_pricelist"."id", "product_pricelist"."name"->>'en_US', "product_pricelist"."active", "product_pricelist"."sequence", "product_pricelist"."currency_id", "product_pricelist"."company_id", "product_pricelist"."create_uid", "product_pricelist"."create_date", "product_pricelist"."write_uid", "product_pricelist"."write_date", "product_pricelist"."website_id", "product_pricelist"."code", "product_pricelist"."selectable", "product_pricelist"."tax_display" FROM "product_pricelist" WHERE ("product_pricelist"."active" IS TRUE AND ("product_pricelist"."company_id" IN (1) OR "product_pricelist"."company_id" IS NULL) AND ("product_pricelist"."website_id" IN (1) OR ("product_pricelist"."website_id" IS NULL AND ("product_pricelist"."code" NOT IN ('') OR "product_pricelist"."selectable" IS TRUE)))) ORDER BY "product_pricelist"."sequence" , "product_pricelist"."id" , "product_pricelist"."name"->>'en_US' ---------------------------------------------------------------------------------------------------- SELECT "product_product_image_rel"."product_product_id", "product_product_image_rel"."product_image_id" FROM "product_image" JOIN "product_product_image_rel" ON ("product_product_image_rel"."product_image_id" = "product_image"."id") WHERE "product_product_image_rel"."product_product_id" IN (265) ORDER BY "product_image"."sequence" , "product_image"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_image"."id", "product_image"."product_tmpl_id" FROM "product_image" WHERE "product_image"."product_tmpl_id" IN (206) ORDER BY "product_image"."sequence" , "product_image"."id" ---------------------------------------------------------------------------------------------------- SELECT "ir_attachment"."id", "ir_attachment"."name", "ir_attachment"."description", "ir_attachment"."res_model", "ir_attachment"."res_field", "ir_attachment"."res_id", "ir_attachment"."company_id", "ir_attachment"."type", "ir_attachment"."url", "ir_attachment"."public", "ir_attachment"."access_token", "ir_attachment"."store_fname", "ir_attachment"."file_size", "ir_attachment"."checksum", "ir_attachment"."mimetype", "ir_attachment"."create_uid", "ir_attachment"."create_date", "ir_attachment"."write_uid", "ir_attachment"."write_date", "ir_attachment"."original_id", "ir_attachment"."key", "ir_attachment"."website_id", "ir_attachment"."theme_template_id" FROM "ir_attachment" WHERE ("ir_attachment"."res_field" IN ('image_variant_1920') AND "ir_attachment"."res_id" IN (265) AND "ir_attachment"."res_model" IN ('product.product')) ORDER BY "ir_attachment"."id" DESC ---------------------------------------------------------------------------------------------------- SELECT "product_ribbon"."id", "product_ribbon"."name"->>'en_US', "product_ribbon"."sequence", "product_ribbon"."bg_color", "product_ribbon"."text_color", "product_ribbon"."position", "product_ribbon"."style", "product_ribbon"."assign", "product_ribbon"."new_period", "product_ribbon"."create_uid", "product_ribbon"."create_date", "product_ribbon"."write_uid", "product_ribbon"."write_date" FROM "product_ribbon" WHERE "product_ribbon"."assign" IN ('sale', 'new', 'out_of_stock') ORDER BY "product_ribbon"."sequence" ASC , "product_ribbon"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag_product_template_rel"."product_template_id", "product_tag_product_template_rel"."product_tag_id" FROM "product_tag" JOIN "product_tag_product_template_rel" ON ("product_tag_product_template_rel"."product_tag_id" = "product_tag"."id") WHERE "product_tag_product_template_rel"."product_template_id" IN (206) ORDER BY "product_tag"."sequence" , "product_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_tag_product_product_rel"."product_product_id", "product_tag_product_product_rel"."product_tag_id" FROM "product_tag" JOIN "product_tag_product_product_rel" ON ("product_tag_product_product_rel"."product_tag_id" = "product_tag"."id") WHERE "product_tag_product_product_rel"."product_product_id" IN (265) ORDER BY "product_tag"."sequence" , "product_tag"."id" ---------------------------------------------------------------------------------------------------- SELECT "product_document"."id", "product_document"."active", "product_document"."ir_attachment_id" FROM "product_document" JOIN "ir_attachment" AS "product_document__ir_attachment_id" ON ("product_document"."ir_attachment_id" = "product_document__ir_attachment_id"."id") WHERE ("product_document__ir_attachment_id"."res_id" IN (206) AND "product_document__ir_attachment_id"."res_model" IN ('product.template')) ORDER BY "product_document"."sequence" , "product_document__ir_attachment_id"."name" ---------------------------------------------------------------------------------------------------- SELECT "product_document"."id", "product_document"."active", "product_document"."ir_attachment_id" FROM "product_document" JOIN "ir_attachment" AS "product_document__ir_attachment_id" ON ("product_document"."ir_attachment_id" = "product_document__ir_attachment_id"."id") WHERE ("product_document__ir_attachment_id"."res_id" IN (265) AND "product_document__ir_attachment_id"."res_model" IN ('product.product')) ORDER BY "product_document"."sequence" , "product_document__ir_attachment_id"."name" ---------------------------------------------------------------------------------------------------- SELECT "website_sale_extra_field"."id", "website_sale_extra_field"."website_id" FROM "website_sale_extra_field" WHERE "website_sale_extra_field"."website_id" IN (1) ORDER BY "website_sale_extra_field"."sequence" ---------------------------------------------------------------------------------------------------- SELECT "product_alternative_rel"."src_id", "product_alternative_rel"."dest_id" FROM "product_template" JOIN "product_alternative_rel" ON ("product_alternative_rel"."dest_id" = "product_template"."id") WHERE "product_alternative_rel"."src_id" IN (206) ORDER BY COALESCE("product_template"."is_favorite", FALSE) DESC , "product_template"."name"->>'en_US' ----------------------------------------------------------------------------------------------------

odoo.tests.result: 5 failed, 0 error(s) of 1263 tests when loading database 'rb-aa5c29f-225760-426745'