Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.handle AS handle_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.model AS model_5,
  t0.status AS status_6,
  t0.image AS image_7,
  t0.add_date AS add_date_8,
  t0.description AS description_9,
  t0.uuid AS uuid_10,
  t0.component_price AS component_price_11,
  t0.container AS container_12,
  t0.container_size AS container_size_13,
  t0.storage_unit_length AS storage_unit_length_14,
  t0.storage_unit_width AS storage_unit_width_15,
  t0.storage_unit_height AS storage_unit_height_16,
  t0.storage_unit_volume AS storage_unit_volume_17,
  t0.storage_unit_container_size AS storage_unit_container_size_18,
  t0.storage_unit_pallet_size AS storage_unit_pallet_size_19,
  t0.storage_unit_total_liters AS storage_unit_total_liters_20,
  t0.storage_unit_weight AS storage_unit_weight_21,
  t0.sales_unit_factor AS sales_unit_factor_22,
  t0.deposit AS deposit_23,
  t0.purchasing_price AS purchasing_price_24,
  t0.is_follow_up AS is_follow_up_25,
  t0.has_follow_up AS has_follow_up_26,
  t0.receipt_tax_id AS receipt_tax_id_27,
  t0.receipt_unit_id AS receipt_unit_id_28,
  t0.product_id AS product_id_29,
  t0.receipt_id AS receipt_id_30,
  t0.receipt_contra_account_id AS receipt_contra_account_id_31
FROM
  receipt_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.handle AS handle_2, t0.name AS name_3, t0.price AS price_4, t0.model AS model_5, t0.status AS status_6, t0.image AS image_7, t0.add_date AS add_date_8, t0.description AS description_9, t0.uuid AS uuid_10, t0.component_price AS component_price_11, t0.container AS container_12, t0.container_size AS container_size_13, t0.storage_unit_length AS storage_unit_length_14, t0.storage_unit_width AS storage_unit_width_15, t0.storage_unit_height AS storage_unit_height_16, t0.storage_unit_volume AS storage_unit_volume_17, t0.storage_unit_container_size AS storage_unit_container_size_18, t0.storage_unit_pallet_size AS storage_unit_pallet_size_19, t0.storage_unit_total_liters AS storage_unit_total_liters_20, t0.storage_unit_weight AS storage_unit_weight_21, t0.sales_unit_factor AS sales_unit_factor_22, t0.deposit AS deposit_23, t0.purchasing_price AS purchasing_price_24, t0.is_follow_up AS is_follow_up_25, t0.has_follow_up AS has_follow_up_26, t0.receipt_tax_id AS receipt_tax_id_27, t0.receipt_unit_id AS receipt_unit_id_28, t0.product_id AS product_id_29, t0.receipt_id AS receipt_id_30, t0.receipt_contra_account_id AS receipt_contra_account_id_31 FROM receipt_product t0 WHERE t0.id = 25696;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.price AS price_3,
  t0.price_fixed AS price_fixed_4,
  t0.base_price AS base_price_5,
  t0.base_price_fixed AS base_price_fixed_6,
  t0.price_otax AS price_otax_7,
  t0.price_otax_fixed AS price_otax_fixed_8,
  t0.base_price_otax AS base_price_otax_9,
  t0.base_price_otax_fixed AS base_price_otax_fixed_10,
  t0.total AS total_11,
  t0.base_total AS base_total_12,
  t0.total_fixed AS total_fixed_13,
  t0.base_total_fixed AS base_total_fixed_14,
  t0.total_otax AS total_otax_15,
  t0.base_total_otax AS base_total_otax_16,
  t0.total_otax_fixed AS total_otax_fixed_17,
  t0.base_total_otax_fixed AS base_total_otax_fixed_18,
  t0.has_discount AS has_discount_19,
  t0.cart_price AS cart_price_20,
  t0.cart_price_fixed AS cart_price_fixed_21,
  t0.cart_base_price AS cart_base_price_22,
  t0.cart_base_price_fixed AS cart_base_price_fixed_23,
  t0.cart_price_otax AS cart_price_otax_24,
  t0.cart_price_otax_fixed AS cart_price_otax_fixed_25,
  t0.cart_base_price_otax AS cart_base_price_otax_26,
  t0.cart_base_price_otax_fixed AS cart_base_price_otax_fixed_27,
  t0.cart_total AS cart_total_28,
  t0.cart_base_total AS cart_base_total_29,
  t0.cart_total_fixed AS cart_total_fixed_30,
  t0.cart_base_total_fixed AS cart_base_total_fixed_31,
  t0.cart_total_otax AS cart_total_otax_32,
  t0.cart_base_total_otax AS cart_base_total_otax_33,
  t0.cart_total_otax_fixed AS cart_total_otax_fixed_34,
  t0.cart_base_total_otax_fixed AS cart_base_total_otax_fixed_35,
  t0.cart_has_discount AS cart_has_discount_36,
  t0.discount_value AS discount_value_37,
  t0.discount_type AS discount_type_38,
  t0.receipt_product_handle AS receipt_product_handle_39,
  t0.use_component AS use_component_40,
  t0.deposit_refund AS deposit_refund_41,
  t0.price_override AS price_override_42,
  t0.is_follow_up AS is_follow_up_43,
  t0.has_follow_up AS has_follow_up_44,
  t0.amount_locked AS amount_locked_45,
  t0.receipt_id AS receipt_id_46,
  t0.receipt_product_id AS receipt_product_id_47
FROM
  receipt_cart_product t0
WHERE
  t0.receipt_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.price AS price_3, t0.price_fixed AS price_fixed_4, t0.base_price AS base_price_5, t0.base_price_fixed AS base_price_fixed_6, t0.price_otax AS price_otax_7, t0.price_otax_fixed AS price_otax_fixed_8, t0.base_price_otax AS base_price_otax_9, t0.base_price_otax_fixed AS base_price_otax_fixed_10, t0.total AS total_11, t0.base_total AS base_total_12, t0.total_fixed AS total_fixed_13, t0.base_total_fixed AS base_total_fixed_14, t0.total_otax AS total_otax_15, t0.base_total_otax AS base_total_otax_16, t0.total_otax_fixed AS total_otax_fixed_17, t0.base_total_otax_fixed AS base_total_otax_fixed_18, t0.has_discount AS has_discount_19, t0.cart_price AS cart_price_20, t0.cart_price_fixed AS cart_price_fixed_21, t0.cart_base_price AS cart_base_price_22, t0.cart_base_price_fixed AS cart_base_price_fixed_23, t0.cart_price_otax AS cart_price_otax_24, t0.cart_price_otax_fixed AS cart_price_otax_fixed_25, t0.cart_base_price_otax AS cart_base_price_otax_26, t0.cart_base_price_otax_fixed AS cart_base_price_otax_fixed_27, t0.cart_total AS cart_total_28, t0.cart_base_total AS cart_base_total_29, t0.cart_total_fixed AS cart_total_fixed_30, t0.cart_base_total_fixed AS cart_base_total_fixed_31, t0.cart_total_otax AS cart_total_otax_32, t0.cart_base_total_otax AS cart_base_total_otax_33, t0.cart_total_otax_fixed AS cart_total_otax_fixed_34, t0.cart_base_total_otax_fixed AS cart_base_total_otax_fixed_35, t0.cart_has_discount AS cart_has_discount_36, t0.discount_value AS discount_value_37, t0.discount_type AS discount_type_38, t0.receipt_product_handle AS receipt_product_handle_39, t0.use_component AS use_component_40, t0.deposit_refund AS deposit_refund_41, t0.price_override AS price_override_42, t0.is_follow_up AS is_follow_up_43, t0.has_follow_up AS has_follow_up_44, t0.amount_locked AS amount_locked_45, t0.receipt_id AS receipt_id_46, t0.receipt_product_id AS receipt_product_id_47 FROM receipt_cart_product t0 WHERE t0.receipt_id = 11318;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.receipt_tax AS receipt_tax_3,
  t0.tax_id AS tax_id_4,
  t0.receipt_id AS receipt_id_5,
  t0.receipt_contra_account_id AS receipt_contra_account_id_6
FROM
  receipt_tax t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.receipt_tax AS receipt_tax_3, t0.tax_id AS tax_id_4, t0.receipt_id AS receipt_id_5, t0.receipt_contra_account_id AS receipt_contra_account_id_6 FROM receipt_tax t0 WHERE t0.id = 13192;

SELECT
  t0.id AS id_1,
  t0.transaction_date AS transaction_date_2,
  t0.to_pay AS to_pay_3,
  t0.given_cash AS given_cash_4,
  t0.change_cash AS change_cash_5,
  t0.transaction_id AS transaction_id_6,
  t0.receipt_payment_method_id AS receipt_payment_method_id_7,
  t0.receipt_id AS receipt_id_8
FROM
  receipt_transaction t0
WHERE
  t0.receipt_id = ?

SELECT t0.id AS id_1, t0.transaction_date AS transaction_date_2, t0.to_pay AS to_pay_3, t0.given_cash AS given_cash_4, t0.change_cash AS change_cash_5, t0.transaction_id AS transaction_id_6, t0.receipt_payment_method_id AS receipt_payment_method_id_7, t0.receipt_id AS receipt_id_8 FROM receipt_transaction t0 WHERE t0.receipt_id = 11318;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cash AS cash_3,
  t0.uuid AS uuid_4,
  t0.payment_method_id AS payment_method_id_5
FROM
  receipt_payment_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.cash AS cash_3, t0.uuid AS uuid_4, t0.payment_method_id AS payment_method_id_5 FROM receipt_payment_method t0 WHERE t0.id = 11286;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4
FROM
  configuration t0
WHERE
  t0.config_key = ?
  AND t0.config_group = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4 FROM configuration t0 WHERE t0.config_key = 'USE_TIMEZONE_DETECTION_BACKUP' AND t0.config_group = 'POS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.add_date AS add_date_3,
  t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_4,
  t0.cashbox_deposit_id AS cashbox_deposit_id_5
FROM
  daily_financial_statement_cashbox_deposit t0
WHERE
  t0.daily_financial_statement_cashbox_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.add_date AS add_date_3, t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_4, t0.cashbox_deposit_id AS cashbox_deposit_id_5 FROM daily_financial_statement_cashbox_deposit t0 WHERE t0.daily_financial_statement_cashbox_id = 908;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.status AS status_3,
  t0.discount AS discount_4,
  t0.discount_type AS discount_type_5,
  t0.comment AS comment_6,
  t0.total AS total_7,
  t0.total_otax AS total_otax_8,
  t0.total_fixed AS total_fixed_9,
  t0.total_otax_fixed AS total_otax_fixed_10,
  t0.total_tax AS total_tax_11,
  t0.total_tax_fixed AS total_tax_fixed_12,
  t0.cart_total AS cart_total_13,
  t0.cart_total_otax AS cart_total_otax_14,
  t0.cart_total_fixed AS cart_total_fixed_15,
  t0.cart_total_otax_fixed AS cart_total_otax_fixed_16,
  t0.cart_total_tax AS cart_total_tax_17,
  t0.cart_total_tax_fixed AS cart_total_tax_fixed_18,
  t0.number AS number_19,
  t0.uuid AS uuid_20,
  t0.canceled AS canceled_21,
  t0.reversal_receipt AS reversal_receipt_22,
  t0.receipt_cashbox_id AS receipt_cashbox_id_23,
  t0.receipt_location_id AS receipt_location_id_24,
  t0.receipt_employee_id AS receipt_employee_id_25,
  t0.customer_id AS customer_id_26,
  t0.customer_address_id AS customer_address_id_27,
  t0.daily_financial_statement_id AS daily_financial_statement_id_28
FROM
  receipt t0
WHERE
  t0.daily_financial_statement_id = ?

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.status AS status_3, t0.discount AS discount_4, t0.discount_type AS discount_type_5, t0.comment AS comment_6, t0.total AS total_7, t0.total_otax AS total_otax_8, t0.total_fixed AS total_fixed_9, t0.total_otax_fixed AS total_otax_fixed_10, t0.total_tax AS total_tax_11, t0.total_tax_fixed AS total_tax_fixed_12, t0.cart_total AS cart_total_13, t0.cart_total_otax AS cart_total_otax_14, t0.cart_total_fixed AS cart_total_fixed_15, t0.cart_total_otax_fixed AS cart_total_otax_fixed_16, t0.cart_total_tax AS cart_total_tax_17, t0.cart_total_tax_fixed AS cart_total_tax_fixed_18, t0.number AS number_19, t0.uuid AS uuid_20, t0.canceled AS canceled_21, t0.reversal_receipt AS reversal_receipt_22, t0.receipt_cashbox_id AS receipt_cashbox_id_23, t0.receipt_location_id AS receipt_location_id_24, t0.receipt_employee_id AS receipt_employee_id_25, t0.customer_id AS customer_id_26, t0.customer_address_id AS customer_address_id_27, t0.daily_financial_statement_id AS daily_financial_statement_id_28 FROM receipt t0 WHERE t0.daily_financial_statement_id = 908;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.add_date AS add_date_3,
  t0.supplier AS supplier_4,
  t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_5,
  t0.cashbox_payment_to_supplier_id AS cashbox_payment_to_supplier_id_6
FROM
  daily_financial_statement_cashbox_payment_to_supplier t0
WHERE
  t0.daily_financial_statement_cashbox_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.add_date AS add_date_3, t0.supplier AS supplier_4, t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_5, t0.cashbox_payment_to_supplier_id AS cashbox_payment_to_supplier_id_6 FROM daily_financial_statement_cashbox_payment_to_supplier t0 WHERE t0.daily_financial_statement_cashbox_id = 908;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.account_id AS account_id_5,
  t6.id AS id_7,
  t6.given_name AS given_name_8,
  t6.family_name AS family_name_9,
  t6.external_identifier AS external_identifier_10,
  t6.telephone AS telephone_11,
  t6.status AS status_12,
  t6.lock_pin AS lock_pin_13,
  t6.from_api AS from_api_14,
  t6.user_id AS user_id_15,
  t6.employee_group_id AS employee_group_id_16,
  t6.language_id AS language_id_17
FROM
  user t0
  LEFT JOIN employee t6 ON t6.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.account_id AS account_id_5, t6.id AS id_7, t6.given_name AS given_name_8, t6.family_name AS family_name_9, t6.external_identifier AS external_identifier_10, t6.telephone AS telephone_11, t6.status AS status_12, t6.lock_pin AS lock_pin_13, t6.from_api AS from_api_14, t6.user_id AS user_id_15, t6.employee_group_id AS employee_group_id_16, t6.language_id AS language_id_17 FROM user t0 LEFT JOIN employee t6 ON t6.user_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.cashbox_start_value AS cashbox_start_value_2,
  t0.cashbox_end_value AS cashbox_end_value_3,
  t0.receipt_value AS receipt_value_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.deposits AS deposits_7,
  t0.withdrawals AS withdrawals_8,
  t0.payments_to_suppliers AS payments_to_suppliers_9,
  t0.card_payment AS card_payment_10,
  t0.manually AS manually_11,
  t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_12
FROM
  daily_financial_statement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cashbox_start_value AS cashbox_start_value_2, t0.cashbox_end_value AS cashbox_end_value_3, t0.receipt_value AS receipt_value_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.deposits AS deposits_7, t0.withdrawals AS withdrawals_8, t0.payments_to_suppliers AS payments_to_suppliers_9, t0.card_payment AS card_payment_10, t0.manually AS manually_11, t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_12 FROM daily_financial_statement t0 WHERE t0.id = '908';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.comment AS comment_3,
  t0.locked AS locked_4,
  t0.serial_number AS serial_number_5,
  t0.daily_financial_statement_location_id AS daily_financial_statement_location_id_6,
  t0.cashbox_id AS cashbox_id_7
FROM
  daily_financial_statement_cashbox t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.locked AS locked_4, t0.serial_number AS serial_number_5, t0.daily_financial_statement_location_id AS daily_financial_statement_location_id_6, t0.cashbox_id AS cashbox_id_7 FROM daily_financial_statement_cashbox t0 WHERE t0.id = 908;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.add_date AS add_date_3,
  t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_4,
  t0.cashbox_withdrawal_id AS cashbox_withdrawal_id_5
FROM
  daily_financial_statement_cashbox_withdrawal t0
WHERE
  t0.daily_financial_statement_cashbox_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.add_date AS add_date_3, t0.daily_financial_statement_cashbox_id AS daily_financial_statement_cashbox_id_4, t0.cashbox_withdrawal_id AS cashbox_withdrawal_id_5 FROM daily_financial_statement_cashbox_withdrawal t0 WHERE t0.daily_financial_statement_cashbox_id = 908;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.street_address AS street_address_4,
  t0.postal_code AS postal_code_5,
  t0.address_locality AS address_locality_6,
  t0.address_addition AS address_addition_7,
  t0.address_country AS address_country_8,
  t0.telephone AS telephone_9,
  t0.website AS website_10,
  t0.email AS email_11,
  t0.fax_number AS fax_number_12,
  t0.show_address_on_receipt AS show_address_on_receipt_13,
  t0.show_contact_on_receipt AS show_contact_on_receipt_14,
  t0.location_id AS location_id_15
FROM
  daily_financial_statement_location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.street_address AS street_address_4, t0.postal_code AS postal_code_5, t0.address_locality AS address_locality_6, t0.address_addition AS address_addition_7, t0.address_country AS address_country_8, t0.telephone AS telephone_9, t0.website AS website_10, t0.email AS email_11, t0.fax_number AS fax_number_12, t0.show_address_on_receipt AS show_address_on_receipt_13, t0.show_contact_on_receipt AS show_contact_on_receipt_14, t0.location_id AS location_id_15 FROM daily_financial_statement_location t0 WHERE t0.id = 908;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.line1 AS line1_4,
  t0.line2 AS line2_5,
  t0.vat_id AS vat_id_6,
  t0.tax_number AS tax_number_7,
  t0.street_address AS street_address_8,
  t0.postal_code AS postal_code_9,
  t0.address_locality AS address_locality_10,
  t0.address_addition AS address_addition_11,
  t0.address_country AS address_country_12,
  t0.telephone AS telephone_13,
  t0.website AS website_14,
  t0.email AS email_15,
  t0.fax_number AS fax_number_16
FROM
  company t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.line1 AS line1_4, t0.line2 AS line2_5, t0.vat_id AS vat_id_6, t0.tax_number AS tax_number_7, t0.street_address AS street_address_8, t0.postal_code AS postal_code_9, t0.address_locality AS address_locality_10, t0.address_addition AS address_addition_11, t0.address_country AS address_country_12, t0.telephone AS telephone_13, t0.website AS website_14, t0.email AS email_15, t0.fax_number AS fax_number_16 FROM company t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.config_group AS config_group_4
FROM
  configuration t0

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.config_group AS config_group_4 FROM configuration t0;

SELECT
  t0.id AS id_1,
  t0.factor AS factor_2,
  t0.amount AS amount_3,
  t0.add_date AS add_date_4,
  t0.daily_financial_statement_id AS daily_financial_statement_id_5
FROM
  daily_financial_statement_counting t0
WHERE
  t0.daily_financial_statement_id = ?

SELECT t0.id AS id_1, t0.factor AS factor_2, t0.amount AS amount_3, t0.add_date AS add_date_4, t0.daily_financial_statement_id AS daily_financial_statement_id_5 FROM daily_financial_statement_counting t0 WHERE t0.daily_financial_statement_id = 908;