Symfony Profiler

SELECT
  COALESCE(
    q0_.delivered_at, q0_.created_at
  ) AS sclr_0,
  q0_.number AS number_1,
  q0_.subject AS subject_2,
  q0_.conversion_rate AS conversion_rate_3,
  q0_.total_price AS total_price_4,
  q0_.total_vat AS total_vat_5,
  q0_.total_discounts AS total_discounts_6,
  q0_.billed_gross_without_tax AS billed_gross_without_tax_7,
  q0_.delivered_at AS delivered_at_8,
  q0_.delivered_method AS delivered_method_9,
  q0_.accepted_at AS accepted_at_10,
  q0_.lost_at AS lost_at_11,
  q0_.groups_as_alternatives AS groups_as_alternatives_12,
  q0_.id AS id_13,
  q0_.created_at AS created_at_14,
  q0_.updated_at AS updated_at_15,
  q0_.deleted_at AS deleted_at_16,
  q0_.creator_id AS creator_id_17,
  q0_.modifier_id AS modifier_id_18,
  q0_.related_to AS related_to_19,
  a1_.id AS id_20,
  a1_.name AS name_21,
  a1_.type AS type_22,
  a1_.email AS email_23,
  a1_.phone AS phone_24,
  a1_.phone_alternate AS phone_alternate_25,
  a1_.url AS url_26,
  a1_.image AS image_27,
  a1_.locale AS locale_28,
  a1_.timezone AS timezone_29,
  a1_.observation AS observation_30,
  a1_.bad_customer AS bad_customer_31,
  a1_.disabled AS disabled_32,
  a1_.created_at AS created_at_33,
  a1_.updated_at AS updated_at_34,
  a1_.deleted_at AS deleted_at_35,
  a1_.creator_id AS creator_id_36,
  a1_.modifier_id AS modifier_id_37,
  u2_.username AS username_38,
  u2_.email AS email_39,
  u2_.password AS password_40,
  u2_.firstname AS firstname_41,
  u2_.lastname AS lastname_42,
  u2_.gender AS gender_43,
  u2_.birthdate AS birthdate_44,
  u2_.origin_place AS origin_place_45,
  u2_.phone AS phone_46,
  u2_.phone_alternate AS phone_alternate_47,
  u2_.telegram_chat_id AS telegram_chat_id_48,
  u2_.avatar_name AS avatar_name_49,
  u2_.fonction AS fonction_50,
  u2_.roles AS roles_51,
  u2_.privileges AS privileges_52,
  u2_.locale AS locale_53,
  u2_.timezone AS timezone_54,
  u2_.authenticator_name AS authenticator_name_55,
  u2_.authenticator_user_id AS authenticator_user_id_56,
  u2_.confirmation_token AS confirmation_token_57,
  u2_.newsletter_subscribed AS newsletter_subscribed_58,
  u2_.observation AS observation_59,
  u2_.motorcycles AS motorcycles_60,
  u2_.password_updated_at AS password_updated_at_61,
  u2_.must_change_password AS must_change_password_62,
  u2_.logged_in_at AS logged_in_at_63,
  u2_.bad_customer AS bad_customer_64,
  u2_.disabled AS disabled_65,
  u2_.id AS id_66,
  u2_.created_at AS created_at_67,
  u2_.updated_at AS updated_at_68,
  u2_.deleted_at AS deleted_at_69,
  u2_.creator_id AS creator_id_70,
  u2_.modifier_id AS modifier_id_71,
  u2_.e_shop_id AS e_shop_id_72,
  a3_.id AS id_73,
  a3_.name AS name_74,
  a3_.type AS type_75,
  a3_.email AS email_76,
  a3_.phone AS phone_77,
  a3_.phone_alternate AS phone_alternate_78,
  a3_.url AS url_79,
  a3_.image AS image_80,
  a3_.locale AS locale_81,
  a3_.timezone AS timezone_82,
  a3_.observation AS observation_83,
  a3_.bad_customer AS bad_customer_84,
  a3_.disabled AS disabled_85,
  a3_.created_at AS created_at_86,
  a3_.updated_at AS updated_at_87,
  a3_.deleted_at AS deleted_at_88,
  a3_.creator_id AS creator_id_89,
  a3_.modifier_id AS modifier_id_90,
  a4_.id AS id_91,
  a4_.alias AS alias_92,
  a4_.company AS company_93,
  a4_.firstname AS firstname_94,
  a4_.lastname AS lastname_95,
  a4_.address1 AS address1_96,
  a4_.address2 AS address2_97,
  a4_.postal_code AS postal_code_98,
  a4_.city AS city_99,
  a4_.created_at AS created_at_100,
  a4_.updated_at AS updated_at_101,
  a4_.deleted_at AS deleted_at_102,
  a4_.e_shop_id AS e_shop_id_103,
  s5_.id AS id_104,
  s5_.iso_code AS iso_code_105,
  s5_.name AS name_106,
  s5_.e_shop_id AS e_shop_id_107,
  c6_.id AS id_108,
  c6_.iso_code AS iso_code_109,
  c6_.name AS name_110,
  c6_.e_shop_id AS e_shop_id_111,
  a7_.id AS id_112,
  a7_.alias AS alias_113,
  a7_.company AS company_114,
  a7_.firstname AS firstname_115,
  a7_.lastname AS lastname_116,
  a7_.address1 AS address1_117,
  a7_.address2 AS address2_118,
  a7_.postal_code AS postal_code_119,
  a7_.city AS city_120,
  a7_.created_at AS created_at_121,
  a7_.updated_at AS updated_at_122,
  a7_.deleted_at AS deleted_at_123,
  a7_.e_shop_id AS e_shop_id_124,
  s8_.id AS id_125,
  s8_.iso_code AS iso_code_126,
  s8_.name AS name_127,
  s8_.e_shop_id AS e_shop_id_128,
  c9_.id AS id_129,
  c9_.iso_code AS iso_code_130,
  c9_.name AS name_131,
  c9_.e_shop_id AS e_shop_id_132,
  c10_.id AS id_133,
  c10_.name AS name_134,
  c10_.iso_code AS iso_code_135,
  c10_.sign AS sign_136,
  c10_.format AS format_137,
  c10_.decimals AS decimals_138,
  c10_.conversion_rate AS conversion_rate_139,
  c10_.disabled AS disabled_140,
  c10_.created_at AS created_at_141,
  c10_.updated_at AS updated_at_142,
  c10_.deleted_at AS deleted_at_143,
  c10_.e_shop_id AS e_shop_id_144,
  s11_.id AS id_145,
  s11_.unique_token AS unique_token_146,
  s11_.data AS data_147,
  s11_.created_at AS created_at_148,
  s11_.updated_at AS updated_at_149,
  s11_.deleted_at AS deleted_at_150,
  s11_.creator_id AS creator_id_151,
  s11_.modifier_id AS modifier_id_152,
  q12_.id AS id_153,
  q12_.name AS name_154,
  q12_.position AS position_155,
  q12_.removed AS removed_156,
  q12_.created_at AS created_at_157,
  q12_.updated_at AS updated_at_158,
  q12_.deleted_at AS deleted_at_159,
  q12_.creator_id AS creator_id_160,
  q12_.modifier_id AS modifier_id_161,
  q13_.reference AS reference_162,
  q13_.name AS name_163,
  q13_.description AS description_164,
  q13_.position AS position_165,
  q13_.quantity AS quantity_166,
  q13_.quantity_unit AS quantity_unit_167,
  q13_.unit_price AS unit_price_168,
  q13_.vat_included AS vat_included_169,
  q13_.discount AS discount_170,
  q13_.total_price AS total_price_171,
  q13_.total_vat AS total_vat_172,
  q13_.related_to AS related_to_173,
  q13_.id AS id_174,
  q13_.removed AS removed_175,
  q13_.created_at AS created_at_176,
  q13_.updated_at AS updated_at_177,
  q13_.deleted_at AS deleted_at_178,
  q13_.creator_id AS creator_id_179,
  q13_.modifier_id AS modifier_id_180,
  q0_.account_id AS account_id_181,
  q0_.user_id AS user_id_182,
  q0_.address_invoice_id AS address_invoice_id_183,
  q0_.address_delivery_id AS address_delivery_id_184,
  q0_.currency_id AS currency_id_185,
  q0_.invoice_layout_id AS invoice_layout_id_186,
  q0_.signature_id AS signature_id_187,
  q0_.replaced_by_quote_id AS replaced_by_quote_id_188,
  q0_.replace_quote_id AS replace_quote_id_189,
  a1_.address_invoice_id AS address_invoice_id_190,
  a1_.address_delivery_id AS address_delivery_id_191,
  u2_.account_id AS account_id_192,
  a3_.address_invoice_id AS address_invoice_id_193,
  a3_.address_delivery_id AS address_delivery_id_194,
  a4_.user_id AS user_id_195,
  a4_.state_id AS state_id_196,
  a4_.country_id AS country_id_197,
  s5_.country_id AS country_id_198,
  a7_.user_id AS user_id_199,
  a7_.state_id AS state_id_200,
  a7_.country_id AS country_id_201,
  s8_.country_id AS country_id_202,
  s11_.account_id AS account_id_203,
  s11_.user_id AS user_id_204,
  q12_.quote_id AS quote_id_205,
  q13_.accounting_account_id AS accounting_account_id_206,
  q13_.accounting_vat_type_id AS accounting_vat_type_id_207,
  q13_.quote_item_group_id AS quote_item_group_id_208
FROM
  quote q0_
  LEFT JOIN account a1_ ON q0_.account_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN `user` u2_ ON q0_.user_id = u2_.id
  AND (u2_.deleted_at IS NULL)
  LEFT JOIN account a3_ ON u2_.account_id = a3_.id
  AND (a3_.deleted_at IS NULL)
  LEFT JOIN address a4_ ON q0_.address_invoice_id = a4_.id
  AND (a4_.deleted_at IS NULL)
  LEFT JOIN state s5_ ON a4_.state_id = s5_.id
  LEFT JOIN country c6_ ON a4_.country_id = c6_.id
  LEFT JOIN address a7_ ON q0_.address_delivery_id = a7_.id
  AND (a7_.deleted_at IS NULL)
  LEFT JOIN state s8_ ON a4_.state_id = s8_.id
  LEFT JOIN country c9_ ON a4_.country_id = c9_.id
  LEFT JOIN currency c10_ ON q0_.currency_id = c10_.id
  AND (c10_.deleted_at IS NULL)
  LEFT JOIN signature s11_ ON q0_.signature_id = s11_.id
  AND (s11_.deleted_at IS NULL)
  LEFT JOIN quote_item_group q12_ ON q0_.id = q12_.quote_id
  AND (q12_.deleted_at IS NULL)
  LEFT JOIN quote_item q13_ ON q12_.id = q13_.quote_item_group_id
  AND (q13_.deleted_at IS NULL)
WHERE
  (q0_.id = ?)
  AND (q0_.deleted_at IS NULL)
ORDER BY
  sclr_0 ASC,
  q12_.position ASC,
  q13_.position ASC

SELECT COALESCE(q0_.delivered_at, q0_.created_at) AS sclr_0, q0_.number AS number_1, q0_.subject AS subject_2, q0_.conversion_rate AS conversion_rate_3, q0_.total_price AS total_price_4, q0_.total_vat AS total_vat_5, q0_.total_discounts AS total_discounts_6, q0_.billed_gross_without_tax AS billed_gross_without_tax_7, q0_.delivered_at AS delivered_at_8, q0_.delivered_method AS delivered_method_9, q0_.accepted_at AS accepted_at_10, q0_.lost_at AS lost_at_11, q0_.groups_as_alternatives AS groups_as_alternatives_12, q0_.id AS id_13, q0_.created_at AS created_at_14, q0_.updated_at AS updated_at_15, q0_.deleted_at AS deleted_at_16, q0_.creator_id AS creator_id_17, q0_.modifier_id AS modifier_id_18, q0_.related_to AS related_to_19, a1_.id AS id_20, a1_.name AS name_21, a1_.type AS type_22, a1_.email AS email_23, a1_.phone AS phone_24, a1_.phone_alternate AS phone_alternate_25, a1_.url AS url_26, a1_.image AS image_27, a1_.locale AS locale_28, a1_.timezone AS timezone_29, a1_.observation AS observation_30, a1_.bad_customer AS bad_customer_31, a1_.disabled AS disabled_32, a1_.created_at AS created_at_33, a1_.updated_at AS updated_at_34, a1_.deleted_at AS deleted_at_35, a1_.creator_id AS creator_id_36, a1_.modifier_id AS modifier_id_37, u2_.username AS username_38, u2_.email AS email_39, u2_.password AS password_40, u2_.firstname AS firstname_41, u2_.lastname AS lastname_42, u2_.gender AS gender_43, u2_.birthdate AS birthdate_44, u2_.origin_place AS origin_place_45, u2_.phone AS phone_46, u2_.phone_alternate AS phone_alternate_47, u2_.telegram_chat_id AS telegram_chat_id_48, u2_.avatar_name AS avatar_name_49, u2_.fonction AS fonction_50, u2_.roles AS roles_51, u2_.privileges AS privileges_52, u2_.locale AS locale_53, u2_.timezone AS timezone_54, u2_.authenticator_name AS authenticator_name_55, u2_.authenticator_user_id AS authenticator_user_id_56, u2_.confirmation_token AS confirmation_token_57, u2_.newsletter_subscribed AS newsletter_subscribed_58, u2_.observation AS observation_59, u2_.motorcycles AS motorcycles_60, u2_.password_updated_at AS password_updated_at_61, u2_.must_change_password AS must_change_password_62, u2_.logged_in_at AS logged_in_at_63, u2_.bad_customer AS bad_customer_64, u2_.disabled AS disabled_65, u2_.id AS id_66, u2_.created_at AS created_at_67, u2_.updated_at AS updated_at_68, u2_.deleted_at AS deleted_at_69, u2_.creator_id AS creator_id_70, u2_.modifier_id AS modifier_id_71, u2_.e_shop_id AS e_shop_id_72, a3_.id AS id_73, a3_.name AS name_74, a3_.type AS type_75, a3_.email AS email_76, a3_.phone AS phone_77, a3_.phone_alternate AS phone_alternate_78, a3_.url AS url_79, a3_.image AS image_80, a3_.locale AS locale_81, a3_.timezone AS timezone_82, a3_.observation AS observation_83, a3_.bad_customer AS bad_customer_84, a3_.disabled AS disabled_85, a3_.created_at AS created_at_86, a3_.updated_at AS updated_at_87, a3_.deleted_at AS deleted_at_88, a3_.creator_id AS creator_id_89, a3_.modifier_id AS modifier_id_90, a4_.id AS id_91, a4_.alias AS alias_92, a4_.company AS company_93, a4_.firstname AS firstname_94, a4_.lastname AS lastname_95, a4_.address1 AS address1_96, a4_.address2 AS address2_97, a4_.postal_code AS postal_code_98, a4_.city AS city_99, a4_.created_at AS created_at_100, a4_.updated_at AS updated_at_101, a4_.deleted_at AS deleted_at_102, a4_.e_shop_id AS e_shop_id_103, s5_.id AS id_104, s5_.iso_code AS iso_code_105, s5_.name AS name_106, s5_.e_shop_id AS e_shop_id_107, c6_.id AS id_108, c6_.iso_code AS iso_code_109, c6_.name AS name_110, c6_.e_shop_id AS e_shop_id_111, a7_.id AS id_112, a7_.alias AS alias_113, a7_.company AS company_114, a7_.firstname AS firstname_115, a7_.lastname AS lastname_116, a7_.address1 AS address1_117, a7_.address2 AS address2_118, a7_.postal_code AS postal_code_119, a7_.city AS city_120, a7_.created_at AS created_at_121, a7_.updated_at AS updated_at_122, a7_.deleted_at AS deleted_at_123, a7_.e_shop_id AS e_shop_id_124, s8_.id AS id_125, s8_.iso_code AS iso_code_126, s8_.name AS name_127, s8_.e_shop_id AS e_shop_id_128, c9_.id AS id_129, c9_.iso_code AS iso_code_130, c9_.name AS name_131, c9_.e_shop_id AS e_shop_id_132, c10_.id AS id_133, c10_.name AS name_134, c10_.iso_code AS iso_code_135, c10_.sign AS sign_136, c10_.format AS format_137, c10_.decimals AS decimals_138, c10_.conversion_rate AS conversion_rate_139, c10_.disabled AS disabled_140, c10_.created_at AS created_at_141, c10_.updated_at AS updated_at_142, c10_.deleted_at AS deleted_at_143, c10_.e_shop_id AS e_shop_id_144, s11_.id AS id_145, s11_.unique_token AS unique_token_146, s11_.data AS data_147, s11_.created_at AS created_at_148, s11_.updated_at AS updated_at_149, s11_.deleted_at AS deleted_at_150, s11_.creator_id AS creator_id_151, s11_.modifier_id AS modifier_id_152, q12_.id AS id_153, q12_.name AS name_154, q12_.position AS position_155, q12_.removed AS removed_156, q12_.created_at AS created_at_157, q12_.updated_at AS updated_at_158, q12_.deleted_at AS deleted_at_159, q12_.creator_id AS creator_id_160, q12_.modifier_id AS modifier_id_161, q13_.reference AS reference_162, q13_.name AS name_163, q13_.description AS description_164, q13_.position AS position_165, q13_.quantity AS quantity_166, q13_.quantity_unit AS quantity_unit_167, q13_.unit_price AS unit_price_168, q13_.vat_included AS vat_included_169, q13_.discount AS discount_170, q13_.total_price AS total_price_171, q13_.total_vat AS total_vat_172, q13_.related_to AS related_to_173, q13_.id AS id_174, q13_.removed AS removed_175, q13_.created_at AS created_at_176, q13_.updated_at AS updated_at_177, q13_.deleted_at AS deleted_at_178, q13_.creator_id AS creator_id_179, q13_.modifier_id AS modifier_id_180, q0_.account_id AS account_id_181, q0_.user_id AS user_id_182, q0_.address_invoice_id AS address_invoice_id_183, q0_.address_delivery_id AS address_delivery_id_184, q0_.currency_id AS currency_id_185, q0_.invoice_layout_id AS invoice_layout_id_186, q0_.signature_id AS signature_id_187, q0_.replaced_by_quote_id AS replaced_by_quote_id_188, q0_.replace_quote_id AS replace_quote_id_189, a1_.address_invoice_id AS address_invoice_id_190, a1_.address_delivery_id AS address_delivery_id_191, u2_.account_id AS account_id_192, a3_.address_invoice_id AS address_invoice_id_193, a3_.address_delivery_id AS address_delivery_id_194, a4_.user_id AS user_id_195, a4_.state_id AS state_id_196, a4_.country_id AS country_id_197, s5_.country_id AS country_id_198, a7_.user_id AS user_id_199, a7_.state_id AS state_id_200, a7_.country_id AS country_id_201, s8_.country_id AS country_id_202, s11_.account_id AS account_id_203, s11_.user_id AS user_id_204, q12_.quote_id AS quote_id_205, q13_.accounting_account_id AS accounting_account_id_206, q13_.accounting_vat_type_id AS accounting_vat_type_id_207, q13_.quote_item_group_id AS quote_item_group_id_208 FROM quote q0_ LEFT JOIN account a1_ ON q0_.account_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN `user` u2_ ON q0_.user_id = u2_.id AND (u2_.deleted_at IS NULL) LEFT JOIN account a3_ ON u2_.account_id = a3_.id AND (a3_.deleted_at IS NULL) LEFT JOIN address a4_ ON q0_.address_invoice_id = a4_.id AND (a4_.deleted_at IS NULL) LEFT JOIN state s5_ ON a4_.state_id = s5_.id LEFT JOIN country c6_ ON a4_.country_id = c6_.id LEFT JOIN address a7_ ON q0_.address_delivery_id = a7_.id AND (a7_.deleted_at IS NULL) LEFT JOIN state s8_ ON a4_.state_id = s8_.id LEFT JOIN country c9_ ON a4_.country_id = c9_.id LEFT JOIN currency c10_ ON q0_.currency_id = c10_.id AND (c10_.deleted_at IS NULL) LEFT JOIN signature s11_ ON q0_.signature_id = s11_.id AND (s11_.deleted_at IS NULL) LEFT JOIN quote_item_group q12_ ON q0_.id = q12_.quote_id AND (q12_.deleted_at IS NULL) LEFT JOIN quote_item q13_ ON q12_.id = q13_.quote_item_group_id AND (q13_.deleted_at IS NULL) WHERE (q0_.id = 392) AND (q0_.deleted_at IS NULL) ORDER BY sclr_0 ASC, q12_.position ASC, q13_.position ASC;

UPDATE
  user
SET
  logged_in_at = UTC_TIMESTAMP()
WHERE
  id = 4348

UPDATE user SET logged_in_at=UTC_TIMESTAMP() WHERE id=4348;

SELECT
  t0.id AS id_1,
  t0.financial_year AS financial_year_2,
  t0.figure AS figure_3,
  t0.name AS name_4,
  t0.rate AS rate_5,
  t0.accounting AS accounting_6,
  t0.rounding AS rounding_7,
  t0.calculation_method AS calculation_method_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.creator_id AS creator_id_12,
  t0.modifier_id AS modifier_id_13,
  t0.accouting_account_id AS accouting_account_id_14,
  t15.id AS id_16,
  t15.financial_year AS financial_year_17,
  t15.number AS number_18,
  t15.name AS name_19,
  t15.class AS class_20,
  t15.type AS type_21,
  t15.old_vat_type_until AS old_vat_type_until_22,
  t15.starred AS starred_23,
  t15.balance AS balance_24,
  t15.foreign_balance AS foreign_balance_25,
  t15.created_at AS created_at_26,
  t15.updated_at AS updated_at_27,
  t15.deleted_at AS deleted_at_28,
  t15.creator_id AS creator_id_29,
  t15.modifier_id AS modifier_id_30,
  t15.currency_id AS currency_id_31,
  t15.accounting_vat_type_id AS accounting_vat_type_id_32,
  t15.old_accounting_vat_type_id AS old_accounting_vat_type_id_33
FROM
  accounting_vat_type t0
  LEFT JOIN accounting_account t15 ON t0.accouting_account_id = t15.id
  AND (
    (t15.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.financial_year AS financial_year_2, t0.figure AS figure_3, t0.name AS name_4, t0.rate AS rate_5, t0.accounting AS accounting_6, t0.rounding AS rounding_7, t0.calculation_method AS calculation_method_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.creator_id AS creator_id_12, t0.modifier_id AS modifier_id_13, t0.accouting_account_id AS accouting_account_id_14, t15.id AS id_16, t15.financial_year AS financial_year_17, t15.number AS number_18, t15.name AS name_19, t15.class AS class_20, t15.type AS type_21, t15.old_vat_type_until AS old_vat_type_until_22, t15.starred AS starred_23, t15.balance AS balance_24, t15.foreign_balance AS foreign_balance_25, t15.created_at AS created_at_26, t15.updated_at AS updated_at_27, t15.deleted_at AS deleted_at_28, t15.creator_id AS creator_id_29, t15.modifier_id AS modifier_id_30, t15.currency_id AS currency_id_31, t15.accounting_vat_type_id AS accounting_vat_type_id_32, t15.old_accounting_vat_type_id AS old_accounting_vat_type_id_33 FROM accounting_vat_type t0 LEFT JOIN accounting_account t15 ON t0.accouting_account_id = t15.id AND ((t15.deleted_at IS NULL)) WHERE t0.id = 91 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.amount AS amount_3,
  t0.percentage AS percentage_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.creator_id AS creator_id_8,
  t0.modifier_id AS modifier_id_9,
  t0.quote_id AS quote_id_10,
  t11.number AS number_12,
  t11.subject AS subject_13,
  t11.conversion_rate AS conversion_rate_14,
  t11.total_price AS total_price_15,
  t11.total_vat AS total_vat_16,
  t11.total_discounts AS total_discounts_17,
  t11.billed_gross_without_tax AS billed_gross_without_tax_18,
  t11.delivered_at AS delivered_at_19,
  t11.delivered_method AS delivered_method_20,
  t11.accepted_at AS accepted_at_21,
  t11.lost_at AS lost_at_22,
  t11.groups_as_alternatives AS groups_as_alternatives_23,
  t11.id AS id_24,
  t11.created_at AS created_at_25,
  t11.updated_at AS updated_at_26,
  t11.deleted_at AS deleted_at_27,
  t11.creator_id AS creator_id_28,
  t11.modifier_id AS modifier_id_29,
  t11.related_to AS related_to_30,
  t11.account_id AS account_id_31,
  t11.user_id AS user_id_32,
  t11.address_invoice_id AS address_invoice_id_33,
  t11.address_delivery_id AS address_delivery_id_34,
  t11.currency_id AS currency_id_35,
  t11.invoice_layout_id AS invoice_layout_id_36,
  t11.signature_id AS signature_id_37,
  t11.replaced_by_quote_id AS replaced_by_quote_id_38,
  t11.replace_quote_id AS replace_quote_id_39,
  t0.accounting_account_id AS accounting_account_id_40,
  t0.accounting_vat_type_id AS accounting_vat_type_id_41
FROM
  quote_discount t0
  INNER JOIN quote t11 ON t0.quote_id = t11.id
  AND (
    (t11.deleted_at IS NULL)
  )
WHERE
  t0.quote_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.amount AS amount_3, t0.percentage AS percentage_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.creator_id AS creator_id_8, t0.modifier_id AS modifier_id_9, t0.quote_id AS quote_id_10, t11.number AS number_12, t11.subject AS subject_13, t11.conversion_rate AS conversion_rate_14, t11.total_price AS total_price_15, t11.total_vat AS total_vat_16, t11.total_discounts AS total_discounts_17, t11.billed_gross_without_tax AS billed_gross_without_tax_18, t11.delivered_at AS delivered_at_19, t11.delivered_method AS delivered_method_20, t11.accepted_at AS accepted_at_21, t11.lost_at AS lost_at_22, t11.groups_as_alternatives AS groups_as_alternatives_23, t11.id AS id_24, t11.created_at AS created_at_25, t11.updated_at AS updated_at_26, t11.deleted_at AS deleted_at_27, t11.creator_id AS creator_id_28, t11.modifier_id AS modifier_id_29, t11.related_to AS related_to_30, t11.account_id AS account_id_31, t11.user_id AS user_id_32, t11.address_invoice_id AS address_invoice_id_33, t11.address_delivery_id AS address_delivery_id_34, t11.currency_id AS currency_id_35, t11.invoice_layout_id AS invoice_layout_id_36, t11.signature_id AS signature_id_37, t11.replaced_by_quote_id AS replaced_by_quote_id_38, t11.replace_quote_id AS replace_quote_id_39, t0.accounting_account_id AS accounting_account_id_40, t0.accounting_vat_type_id AS accounting_vat_type_id_41 FROM quote_discount t0 INNER JOIN quote t11 ON t0.quote_id = t11.id AND ((t11.deleted_at IS NULL)) WHERE t0.quote_id = 392 AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.description AS description_2,
  i0_.table_definition AS table_definition_3,
  i0_.created_at AS created_at_4,
  i0_.updated_at AS updated_at_5,
  i0_.deleted_at AS deleted_at_6,
  i0_.creator_id AS creator_id_7,
  i0_.modifier_id AS modifier_id_8
FROM
  invoice_layout i0_
WHERE
  (i0_.id = ?)
  AND (i0_.deleted_at IS NULL)
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.table_definition AS table_definition_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.deleted_at AS deleted_at_6, i0_.creator_id AS creator_id_7, i0_.modifier_id AS modifier_id_8 FROM invoice_layout i0_ WHERE (i0_.id = 1) AND (i0_.deleted_at IS NULL) ORDER BY i0_.name ASC;

SELECT
  u0_.username AS username_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.firstname AS firstname_3,
  u0_.lastname AS lastname_4,
  u0_.gender AS gender_5,
  u0_.birthdate AS birthdate_6,
  u0_.origin_place AS origin_place_7,
  u0_.phone AS phone_8,
  u0_.phone_alternate AS phone_alternate_9,
  u0_.telegram_chat_id AS telegram_chat_id_10,
  u0_.avatar_name AS avatar_name_11,
  u0_.fonction AS fonction_12,
  u0_.roles AS roles_13,
  u0_.privileges AS privileges_14,
  u0_.locale AS locale_15,
  u0_.timezone AS timezone_16,
  u0_.authenticator_name AS authenticator_name_17,
  u0_.authenticator_user_id AS authenticator_user_id_18,
  u0_.confirmation_token AS confirmation_token_19,
  u0_.newsletter_subscribed AS newsletter_subscribed_20,
  u0_.observation AS observation_21,
  u0_.motorcycles AS motorcycles_22,
  u0_.password_updated_at AS password_updated_at_23,
  u0_.must_change_password AS must_change_password_24,
  u0_.logged_in_at AS logged_in_at_25,
  u0_.bad_customer AS bad_customer_26,
  u0_.disabled AS disabled_27,
  u0_.id AS id_28,
  u0_.created_at AS created_at_29,
  u0_.updated_at AS updated_at_30,
  u0_.deleted_at AS deleted_at_31,
  u0_.creator_id AS creator_id_32,
  u0_.modifier_id AS modifier_id_33,
  u0_.e_shop_id AS e_shop_id_34,
  a1_.id AS id_35,
  a1_.name AS name_36,
  a1_.type AS type_37,
  a1_.email AS email_38,
  a1_.phone AS phone_39,
  a1_.phone_alternate AS phone_alternate_40,
  a1_.url AS url_41,
  a1_.image AS image_42,
  a1_.locale AS locale_43,
  a1_.timezone AS timezone_44,
  a1_.observation AS observation_45,
  a1_.bad_customer AS bad_customer_46,
  a1_.disabled AS disabled_47,
  a1_.created_at AS created_at_48,
  a1_.updated_at AS updated_at_49,
  a1_.deleted_at AS deleted_at_50,
  a1_.creator_id AS creator_id_51,
  a1_.modifier_id AS modifier_id_52,
  u2_.id AS id_53,
  u2_.name AS name_54,
  u2_.description AS description_55,
  u2_.disabled AS disabled_56,
  u2_.created_at AS created_at_57,
  u2_.updated_at AS updated_at_58,
  u2_.deleted_at AS deleted_at_59,
  u2_.creator_id AS creator_id_60,
  u2_.modifier_id AS modifier_id_61,
  u2_.e_shop_id AS e_shop_id_62,
  t3_.name AS name_63,
  t3_.text_color AS text_color_64,
  t3_.background_color AS background_color_65,
  t3_.icon AS icon_66,
  t3_.id AS id_67,
  t3_.created_at AS created_at_68,
  t3_.updated_at AS updated_at_69,
  t3_.deleted_at AS deleted_at_70,
  t3_.creator_id AS creator_id_71,
  t3_.modifier_id AS modifier_id_72,
  u0_.account_id AS account_id_73,
  a1_.address_invoice_id AS address_invoice_id_74,
  a1_.address_delivery_id AS address_delivery_id_75
FROM
  `user` u0_
  LEFT JOIN account a1_ ON u0_.account_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id
  LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id
  AND (u2_.deleted_at IS NULL)
  LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id
  LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id
  AND (t3_.deleted_at IS NULL)
WHERE
  (
    (
      u0_.username LIKE ?
      OR u0_.email LIKE ?
    )
    AND u0_.disabled = 0
  )
  AND (u0_.deleted_at IS NULL)
ORDER BY
  u0_.lastname ASC,
  u0_.firstname ASC,
  u2_.name ASC

SELECT u0_.username AS username_0, u0_.email AS email_1, u0_.password AS password_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.gender AS gender_5, u0_.birthdate AS birthdate_6, u0_.origin_place AS origin_place_7, u0_.phone AS phone_8, u0_.phone_alternate AS phone_alternate_9, u0_.telegram_chat_id AS telegram_chat_id_10, u0_.avatar_name AS avatar_name_11, u0_.fonction AS fonction_12, u0_.roles AS roles_13, u0_.privileges AS privileges_14, u0_.locale AS locale_15, u0_.timezone AS timezone_16, u0_.authenticator_name AS authenticator_name_17, u0_.authenticator_user_id AS authenticator_user_id_18, u0_.confirmation_token AS confirmation_token_19, u0_.newsletter_subscribed AS newsletter_subscribed_20, u0_.observation AS observation_21, u0_.motorcycles AS motorcycles_22, u0_.password_updated_at AS password_updated_at_23, u0_.must_change_password AS must_change_password_24, u0_.logged_in_at AS logged_in_at_25, u0_.bad_customer AS bad_customer_26, u0_.disabled AS disabled_27, u0_.id AS id_28, u0_.created_at AS created_at_29, u0_.updated_at AS updated_at_30, u0_.deleted_at AS deleted_at_31, u0_.creator_id AS creator_id_32, u0_.modifier_id AS modifier_id_33, u0_.e_shop_id AS e_shop_id_34, a1_.id AS id_35, a1_.name AS name_36, a1_.type AS type_37, a1_.email AS email_38, a1_.phone AS phone_39, a1_.phone_alternate AS phone_alternate_40, a1_.url AS url_41, a1_.image AS image_42, a1_.locale AS locale_43, a1_.timezone AS timezone_44, a1_.observation AS observation_45, a1_.bad_customer AS bad_customer_46, a1_.disabled AS disabled_47, a1_.created_at AS created_at_48, a1_.updated_at AS updated_at_49, a1_.deleted_at AS deleted_at_50, a1_.creator_id AS creator_id_51, a1_.modifier_id AS modifier_id_52, u2_.id AS id_53, u2_.name AS name_54, u2_.description AS description_55, u2_.disabled AS disabled_56, u2_.created_at AS created_at_57, u2_.updated_at AS updated_at_58, u2_.deleted_at AS deleted_at_59, u2_.creator_id AS creator_id_60, u2_.modifier_id AS modifier_id_61, u2_.e_shop_id AS e_shop_id_62, t3_.name AS name_63, t3_.text_color AS text_color_64, t3_.background_color AS background_color_65, t3_.icon AS icon_66, t3_.id AS id_67, t3_.created_at AS created_at_68, t3_.updated_at AS updated_at_69, t3_.deleted_at AS deleted_at_70, t3_.creator_id AS creator_id_71, t3_.modifier_id AS modifier_id_72, u0_.account_id AS account_id_73, a1_.address_invoice_id AS address_invoice_id_74, a1_.address_delivery_id AS address_delivery_id_75 FROM `user` u0_ LEFT JOIN account a1_ ON u0_.account_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id AND (u2_.deleted_at IS NULL) LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id AND (t3_.deleted_at IS NULL) WHERE ((u0_.username LIKE 'p.germanier' OR u0_.email LIKE 'p.germanier') AND u0_.disabled = 0) AND (u0_.deleted_at IS NULL) ORDER BY u0_.lastname ASC, u0_.firstname ASC, u2_.name ASC;