Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.phone_number AS phone_number_2,
  a0_.password AS password_3,
  a0_.roles AS roles_4,
  a0_.lastname AS lastname_5,
  a0_.firstname AS firstname_6,
  a0_.created_at AS created_at_7,
  a0_.registration_source AS registration_source_8,
  a0_.honorific_prefix AS honorific_prefix_9,
  a0_.reset_token AS reset_token_10,
  a0_.reset_token_expiration_date AS reset_token_expiration_date_11,
  a0_.uniq_id AS uniq_id_12,
  a0_.code_confirmation AS code_confirmation_13,
  a0_.updated_at AS updated_at_14,
  a0_.is_active AS is_active_15
FROM
  app_users a0_
WHERE
  a0_.email = ?
  OR a0_.phone_number = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'alain@hairun-technology.com' OR a0_.phone_number = 'alain@hairun-technology.com';

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.updated_at AS updated_at_2,
  i0_.confirmation_number AS confirmation_number_3,
  i0_.status AS status_4,
  i0_.vatrate AS vatrate_5,
  i0_.price_without_tax AS price_without_tax_6,
  i0_.object AS object_7,
  i0_.path AS path_8,
  i0_.price AS price_9,
  i0_.payment_recurrence AS payment_recurrence_10,
  i0_.new_organization_legal_name AS new_organization_legal_name_11,
  i0_.new_organization_vatid AS new_organization_vatid_12,
  i0_.is_new_organization AS is_new_organization_13,
  i0_.is_prescriber AS is_prescriber_14,
  i0_.total_paid AS total_paid_15,
  i0_.new_organization_user_email AS new_organization_user_email_16,
  i0_.is_sent AS is_sent_17,
  i0_.sent_date AS sent_date_18,
  i0_.sent_to AS sent_to_19,
  i0_.number AS number_20,
  i0_.total_refund AS total_refund_21,
  i0_.is_canceled AS is_canceled_22,
  i0_.discount_without_tax AS discount_without_tax_23,
  i0_.discount_without_tax_percent AS discount_without_tax_percent_24,
  i0_.is_imported AS is_imported_25,
  i0_.is_domiciliation AS is_domiciliation_26,
  i0_.payment_url AS payment_url_27,
  i0_.reference AS reference_28,
  i0_.remaining_to_pay AS remaining_to_pay_29,
  i0_.total_refunded_payment AS total_refunded_payment_30,
  i0_.marge AS marge_31,
  i0_.is_new_organization_prescribed AS is_new_organization_prescribed_32,
  i0_.is_not_in_prescriber AS is_not_in_prescriber_33,
  i0_.new_prescriber_legal_name AS new_prescriber_legal_name_34,
  i0_.new_prescriber_vatid AS new_prescriber_vatid_35,
  i0_.new_prescriber_user_email AS new_prescriber_user_email_36,
  i0_.is_attached_to_prescriber AS is_attached_to_prescriber_37,
  i0_.invoice_type AS invoice_type_38,
  i0_.reference_stripe AS reference_stripe_39,
  i0_.new_organization_phone_number AS new_organization_phone_number_40,
  i0_.payment_deadline AS payment_deadline_41,
  i0_.is_template AS is_template_42,
  i0_.unique_key AS unique_key_43,
  i0_.is_paid_by_stripe AS is_paid_by_stripe_44,
  i0_.is_pack_invoice AS is_pack_invoice_45,
  i0_.sync_billing_report AS sync_billing_report_46,
  i0_.external_id AS external_id_47,
  i0_.organization_id AS organization_id_48,
  i0_.user_id AS user_id_49,
  i0_.new_organization_address_id AS new_organization_address_id_50,
  i0_.prescriber_id AS prescriber_id_51,
  i0_.new_prescriber_address_id AS new_prescriber_address_id_52,
  i0_.invoice_parent_id AS invoice_parent_id_53,
  i0_.discount_code_id AS discount_code_id_54
FROM
  invoice i0_
WHERE
  i0_.status = ?
ORDER BY
  i0_.object ASC
LIMIT
  8

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.confirmation_number AS confirmation_number_3, i0_.status AS status_4, i0_.vatrate AS vatrate_5, i0_.price_without_tax AS price_without_tax_6, i0_.object AS object_7, i0_.path AS path_8, i0_.price AS price_9, i0_.payment_recurrence AS payment_recurrence_10, i0_.new_organization_legal_name AS new_organization_legal_name_11, i0_.new_organization_vatid AS new_organization_vatid_12, i0_.is_new_organization AS is_new_organization_13, i0_.is_prescriber AS is_prescriber_14, i0_.total_paid AS total_paid_15, i0_.new_organization_user_email AS new_organization_user_email_16, i0_.is_sent AS is_sent_17, i0_.sent_date AS sent_date_18, i0_.sent_to AS sent_to_19, i0_.number AS number_20, i0_.total_refund AS total_refund_21, i0_.is_canceled AS is_canceled_22, i0_.discount_without_tax AS discount_without_tax_23, i0_.discount_without_tax_percent AS discount_without_tax_percent_24, i0_.is_imported AS is_imported_25, i0_.is_domiciliation AS is_domiciliation_26, i0_.payment_url AS payment_url_27, i0_.reference AS reference_28, i0_.remaining_to_pay AS remaining_to_pay_29, i0_.total_refunded_payment AS total_refunded_payment_30, i0_.marge AS marge_31, i0_.is_new_organization_prescribed AS is_new_organization_prescribed_32, i0_.is_not_in_prescriber AS is_not_in_prescriber_33, i0_.new_prescriber_legal_name AS new_prescriber_legal_name_34, i0_.new_prescriber_vatid AS new_prescriber_vatid_35, i0_.new_prescriber_user_email AS new_prescriber_user_email_36, i0_.is_attached_to_prescriber AS is_attached_to_prescriber_37, i0_.invoice_type AS invoice_type_38, i0_.reference_stripe AS reference_stripe_39, i0_.new_organization_phone_number AS new_organization_phone_number_40, i0_.payment_deadline AS payment_deadline_41, i0_.is_template AS is_template_42, i0_.unique_key AS unique_key_43, i0_.is_paid_by_stripe AS is_paid_by_stripe_44, i0_.is_pack_invoice AS is_pack_invoice_45, i0_.sync_billing_report AS sync_billing_report_46, i0_.external_id AS external_id_47, i0_.organization_id AS organization_id_48, i0_.user_id AS user_id_49, i0_.new_organization_address_id AS new_organization_address_id_50, i0_.prescriber_id AS prescriber_id_51, i0_.new_prescriber_address_id AS new_prescriber_address_id_52, i0_.invoice_parent_id AS invoice_parent_id_53, i0_.discount_code_id AS discount_code_id_54 FROM invoice i0_ WHERE i0_.status = 'MODEL' ORDER BY i0_.object ASC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.status AS status_4,
  t0.vatrate AS vatrate_5,
  t0.price_without_tax AS price_without_tax_6,
  t0.object AS object_7,
  t0.path AS path_8,
  t0.price AS price_9,
  t0.new_organization_legal_name AS new_organization_legal_name_10,
  t0.new_organization_vatid AS new_organization_vatid_11,
  t0.is_new_organization AS is_new_organization_12,
  t0.is_prescriber AS is_prescriber_13,
  t0.new_organization_user_email AS new_organization_user_email_14,
  t0.is_sent AS is_sent_15,
  t0.sent_date AS sent_date_16,
  t0.sent_to AS sent_to_17,
  t0.number AS number_18,
  t0.is_canceled AS is_canceled_19,
  t0.discount_without_tax AS discount_without_tax_20,
  t0.discount_without_tax_percent AS discount_without_tax_percent_21,
  t0.invoice_is_generated AS invoice_is_generated_22,
  t0.payment_url AS payment_url_23,
  t0.is_generate AS is_generate_24,
  t0.marge AS marge_25,
  t0.new_organization_phone_number AS new_organization_phone_number_26,
  t0.is_new_organization_prescribed AS is_new_organization_prescribed_27,
  t0.is_not_in_prescriber AS is_not_in_prescriber_28,
  t0.new_prescriber_legal_name AS new_prescriber_legal_name_29,
  t0.new_prescriber_vatid AS new_prescriber_vatid_30,
  t0.new_prescriber_user_email AS new_prescriber_user_email_31,
  t0.is_attached_to_prescriber AS is_attached_to_prescriber_32,
  t0.is_paid_by_stripe AS is_paid_by_stripe_33,
  t0.organization_id AS organization_id_34,
  t0.new_organization_address_id AS new_organization_address_id_35,
  t0.invoice_id AS invoice_id_36,
  t0.prescriber_id AS prescriber_id_37,
  t0.new_prescriber_address_id AS new_prescriber_address_id_38,
  t0.discount_code_id AS discount_code_id_39
FROM
  quote t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.status AS status_4, t0.vatrate AS vatrate_5, t0.price_without_tax AS price_without_tax_6, t0.object AS object_7, t0.path AS path_8, t0.price AS price_9, t0.new_organization_legal_name AS new_organization_legal_name_10, t0.new_organization_vatid AS new_organization_vatid_11, t0.is_new_organization AS is_new_organization_12, t0.is_prescriber AS is_prescriber_13, t0.new_organization_user_email AS new_organization_user_email_14, t0.is_sent AS is_sent_15, t0.sent_date AS sent_date_16, t0.sent_to AS sent_to_17, t0.number AS number_18, t0.is_canceled AS is_canceled_19, t0.discount_without_tax AS discount_without_tax_20, t0.discount_without_tax_percent AS discount_without_tax_percent_21, t0.invoice_is_generated AS invoice_is_generated_22, t0.payment_url AS payment_url_23, t0.is_generate AS is_generate_24, t0.marge AS marge_25, t0.new_organization_phone_number AS new_organization_phone_number_26, t0.is_new_organization_prescribed AS is_new_organization_prescribed_27, t0.is_not_in_prescriber AS is_not_in_prescriber_28, t0.new_prescriber_legal_name AS new_prescriber_legal_name_29, t0.new_prescriber_vatid AS new_prescriber_vatid_30, t0.new_prescriber_user_email AS new_prescriber_user_email_31, t0.is_attached_to_prescriber AS is_attached_to_prescriber_32, t0.is_paid_by_stripe AS is_paid_by_stripe_33, t0.organization_id AS organization_id_34, t0.new_organization_address_id AS new_organization_address_id_35, t0.invoice_id AS invoice_id_36, t0.prescriber_id AS prescriber_id_37, t0.new_prescriber_address_id AS new_prescriber_address_id_38, t0.discount_code_id AS discount_code_id_39 FROM quote t0 WHERE t0.invoice_id = 222373;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.is_done AS is_done_4,
  t0.comment AS comment_5,
  t0.npai AS npai_6,
  t0.price_without_tax AS price_without_tax_7,
  t0.tracking_number AS tracking_number_8,
  t0.price AS price_9,
  t0.days_keep AS days_keep_10,
  t0.organization_id AS organization_id_11,
  t0.invoice_id AS invoice_id_12
FROM
  letter_forward t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.is_done AS is_done_4, t0.comment AS comment_5, t0.npai AS npai_6, t0.price_without_tax AS price_without_tax_7, t0.tracking_number AS tracking_number_8, t0.price AS price_9, t0.days_keep AS days_keep_10, t0.organization_id AS organization_id_11, t0.invoice_id AS invoice_id_12 FROM letter_forward t0 WHERE t0.invoice_id = 222373;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.confirmation_number AS confirmation_number_4,
  t0.status AS status_5,
  t0.vatrate AS vatrate_6,
  t0.price_without_tax AS price_without_tax_7,
  t0.object AS object_8,
  t0.path AS path_9,
  t0.price AS price_10,
  t0.payment_recurrence AS payment_recurrence_11,
  t0.new_organization_legal_name AS new_organization_legal_name_12,
  t0.new_organization_vatid AS new_organization_vatid_13,
  t0.is_new_organization AS is_new_organization_14,
  t0.is_prescriber AS is_prescriber_15,
  t0.total_paid AS total_paid_16,
  t0.new_organization_user_email AS new_organization_user_email_17,
  t0.is_sent AS is_sent_18,
  t0.sent_date AS sent_date_19,
  t0.sent_to AS sent_to_20,
  t0.number AS number_21,
  t0.total_refund AS total_refund_22,
  t0.is_canceled AS is_canceled_23,
  t0.discount_without_tax AS discount_without_tax_24,
  t0.discount_without_tax_percent AS discount_without_tax_percent_25,
  t0.is_imported AS is_imported_26,
  t0.is_domiciliation AS is_domiciliation_27,
  t0.payment_url AS payment_url_28,
  t0.reference AS reference_29,
  t0.remaining_to_pay AS remaining_to_pay_30,
  t0.total_refunded_payment AS total_refunded_payment_31,
  t0.marge AS marge_32,
  t0.is_new_organization_prescribed AS is_new_organization_prescribed_33,
  t0.is_not_in_prescriber AS is_not_in_prescriber_34,
  t0.new_prescriber_legal_name AS new_prescriber_legal_name_35,
  t0.new_prescriber_vatid AS new_prescriber_vatid_36,
  t0.new_prescriber_user_email AS new_prescriber_user_email_37,
  t0.is_attached_to_prescriber AS is_attached_to_prescriber_38,
  t0.invoice_type AS invoice_type_39,
  t0.reference_stripe AS reference_stripe_40,
  t0.new_organization_phone_number AS new_organization_phone_number_41,
  t0.payment_deadline AS payment_deadline_42,
  t0.is_template AS is_template_43,
  t0.unique_key AS unique_key_44,
  t0.is_paid_by_stripe AS is_paid_by_stripe_45,
  t0.is_pack_invoice AS is_pack_invoice_46,
  t0.sync_billing_report AS sync_billing_report_47,
  t0.external_id AS external_id_48,
  t0.organization_id AS organization_id_49,
  t0.user_id AS user_id_50,
  t0.new_organization_address_id AS new_organization_address_id_51,
  t52.id AS id_53,
  t52.created_at AS created_at_54,
  t52.updated_at AS updated_at_55,
  t52.status AS status_56,
  t52.vatrate AS vatrate_57,
  t52.price_without_tax AS price_without_tax_58,
  t52.object AS object_59,
  t52.path AS path_60,
  t52.price AS price_61,
  t52.new_organization_legal_name AS new_organization_legal_name_62,
  t52.new_organization_vatid AS new_organization_vatid_63,
  t52.is_new_organization AS is_new_organization_64,
  t52.is_prescriber AS is_prescriber_65,
  t52.new_organization_user_email AS new_organization_user_email_66,
  t52.is_sent AS is_sent_67,
  t52.sent_date AS sent_date_68,
  t52.sent_to AS sent_to_69,
  t52.number AS number_70,
  t52.is_canceled AS is_canceled_71,
  t52.discount_without_tax AS discount_without_tax_72,
  t52.discount_without_tax_percent AS discount_without_tax_percent_73,
  t52.invoice_is_generated AS invoice_is_generated_74,
  t52.payment_url AS payment_url_75,
  t52.is_generate AS is_generate_76,
  t52.marge AS marge_77,
  t52.new_organization_phone_number AS new_organization_phone_number_78,
  t52.is_new_organization_prescribed AS is_new_organization_prescribed_79,
  t52.is_not_in_prescriber AS is_not_in_prescriber_80,
  t52.new_prescriber_legal_name AS new_prescriber_legal_name_81,
  t52.new_prescriber_vatid AS new_prescriber_vatid_82,
  t52.new_prescriber_user_email AS new_prescriber_user_email_83,
  t52.is_attached_to_prescriber AS is_attached_to_prescriber_84,
  t52.is_paid_by_stripe AS is_paid_by_stripe_85,
  t52.organization_id AS organization_id_86,
  t52.new_organization_address_id AS new_organization_address_id_87,
  t52.invoice_id AS invoice_id_88,
  t52.prescriber_id AS prescriber_id_89,
  t52.new_prescriber_address_id AS new_prescriber_address_id_90,
  t52.discount_code_id AS discount_code_id_91,
  t0.prescriber_id AS prescriber_id_92,
  t0.new_prescriber_address_id AS new_prescriber_address_id_93,
  t94.id AS id_95,
  t94.created_at AS created_at_96,
  t94.updated_at AS updated_at_97,
  t94.is_done AS is_done_98,
  t94.comment AS comment_99,
  t94.npai AS npai_100,
  t94.price_without_tax AS price_without_tax_101,
  t94.tracking_number AS tracking_number_102,
  t94.price AS price_103,
  t94.days_keep AS days_keep_104,
  t94.organization_id AS organization_id_105,
  t94.invoice_id AS invoice_id_106,
  t0.invoice_parent_id AS invoice_parent_id_107,
  t108.id AS id_109,
  t108.created_at AS created_at_110,
  t108.updated_at AS updated_at_111,
  t108.confirmation_number AS confirmation_number_112,
  t108.status AS status_113,
  t108.vatrate AS vatrate_114,
  t108.price_without_tax AS price_without_tax_115,
  t108.object AS object_116,
  t108.path AS path_117,
  t108.price AS price_118,
  t108.payment_recurrence AS payment_recurrence_119,
  t108.new_organization_legal_name AS new_organization_legal_name_120,
  t108.new_organization_vatid AS new_organization_vatid_121,
  t108.is_new_organization AS is_new_organization_122,
  t108.is_prescriber AS is_prescriber_123,
  t108.total_paid AS total_paid_124,
  t108.new_organization_user_email AS new_organization_user_email_125,
  t108.is_sent AS is_sent_126,
  t108.sent_date AS sent_date_127,
  t108.sent_to AS sent_to_128,
  t108.number AS number_129,
  t108.total_refund AS total_refund_130,
  t108.is_canceled AS is_canceled_131,
  t108.discount_without_tax AS discount_without_tax_132,
  t108.discount_without_tax_percent AS discount_without_tax_percent_133,
  t108.is_imported AS is_imported_134,
  t108.is_domiciliation AS is_domiciliation_135,
  t108.payment_url AS payment_url_136,
  t108.reference AS reference_137,
  t108.remaining_to_pay AS remaining_to_pay_138,
  t108.total_refunded_payment AS total_refunded_payment_139,
  t108.marge AS marge_140,
  t108.is_new_organization_prescribed AS is_new_organization_prescribed_141,
  t108.is_not_in_prescriber AS is_not_in_prescriber_142,
  t108.new_prescriber_legal_name AS new_prescriber_legal_name_143,
  t108.new_prescriber_vatid AS new_prescriber_vatid_144,
  t108.new_prescriber_user_email AS new_prescriber_user_email_145,
  t108.is_attached_to_prescriber AS is_attached_to_prescriber_146,
  t108.invoice_type AS invoice_type_147,
  t108.reference_stripe AS reference_stripe_148,
  t108.new_organization_phone_number AS new_organization_phone_number_149,
  t108.payment_deadline AS payment_deadline_150,
  t108.is_template AS is_template_151,
  t108.unique_key AS unique_key_152,
  t108.is_paid_by_stripe AS is_paid_by_stripe_153,
  t108.is_pack_invoice AS is_pack_invoice_154,
  t108.sync_billing_report AS sync_billing_report_155,
  t108.external_id AS external_id_156,
  t108.organization_id AS organization_id_157,
  t108.user_id AS user_id_158,
  t108.new_organization_address_id AS new_organization_address_id_159,
  t108.prescriber_id AS prescriber_id_160,
  t108.new_prescriber_address_id AS new_prescriber_address_id_161,
  t108.invoice_parent_id AS invoice_parent_id_162,
  t108.discount_code_id AS discount_code_id_163,
  t0.discount_code_id AS discount_code_id_164
FROM
  invoice t0
  LEFT JOIN quote t52 ON t52.invoice_id = t0.id
  LEFT JOIN letter_forward t94 ON t94.invoice_id = t0.id
  LEFT JOIN invoice t108 ON t108.invoice_parent_id = t0.id
WHERE
  t0.invoice_parent_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.confirmation_number AS confirmation_number_4, t0.status AS status_5, t0.vatrate AS vatrate_6, t0.price_without_tax AS price_without_tax_7, t0.object AS object_8, t0.path AS path_9, t0.price AS price_10, t0.payment_recurrence AS payment_recurrence_11, t0.new_organization_legal_name AS new_organization_legal_name_12, t0.new_organization_vatid AS new_organization_vatid_13, t0.is_new_organization AS is_new_organization_14, t0.is_prescriber AS is_prescriber_15, t0.total_paid AS total_paid_16, t0.new_organization_user_email AS new_organization_user_email_17, t0.is_sent AS is_sent_18, t0.sent_date AS sent_date_19, t0.sent_to AS sent_to_20, t0.number AS number_21, t0.total_refund AS total_refund_22, t0.is_canceled AS is_canceled_23, t0.discount_without_tax AS discount_without_tax_24, t0.discount_without_tax_percent AS discount_without_tax_percent_25, t0.is_imported AS is_imported_26, t0.is_domiciliation AS is_domiciliation_27, t0.payment_url AS payment_url_28, t0.reference AS reference_29, t0.remaining_to_pay AS remaining_to_pay_30, t0.total_refunded_payment AS total_refunded_payment_31, t0.marge AS marge_32, t0.is_new_organization_prescribed AS is_new_organization_prescribed_33, t0.is_not_in_prescriber AS is_not_in_prescriber_34, t0.new_prescriber_legal_name AS new_prescriber_legal_name_35, t0.new_prescriber_vatid AS new_prescriber_vatid_36, t0.new_prescriber_user_email AS new_prescriber_user_email_37, t0.is_attached_to_prescriber AS is_attached_to_prescriber_38, t0.invoice_type AS invoice_type_39, t0.reference_stripe AS reference_stripe_40, t0.new_organization_phone_number AS new_organization_phone_number_41, t0.payment_deadline AS payment_deadline_42, t0.is_template AS is_template_43, t0.unique_key AS unique_key_44, t0.is_paid_by_stripe AS is_paid_by_stripe_45, t0.is_pack_invoice AS is_pack_invoice_46, t0.sync_billing_report AS sync_billing_report_47, t0.external_id AS external_id_48, t0.organization_id AS organization_id_49, t0.user_id AS user_id_50, t0.new_organization_address_id AS new_organization_address_id_51, t52.id AS id_53, t52.created_at AS created_at_54, t52.updated_at AS updated_at_55, t52.status AS status_56, t52.vatrate AS vatrate_57, t52.price_without_tax AS price_without_tax_58, t52.object AS object_59, t52.path AS path_60, t52.price AS price_61, t52.new_organization_legal_name AS new_organization_legal_name_62, t52.new_organization_vatid AS new_organization_vatid_63, t52.is_new_organization AS is_new_organization_64, t52.is_prescriber AS is_prescriber_65, t52.new_organization_user_email AS new_organization_user_email_66, t52.is_sent AS is_sent_67, t52.sent_date AS sent_date_68, t52.sent_to AS sent_to_69, t52.number AS number_70, t52.is_canceled AS is_canceled_71, t52.discount_without_tax AS discount_without_tax_72, t52.discount_without_tax_percent AS discount_without_tax_percent_73, t52.invoice_is_generated AS invoice_is_generated_74, t52.payment_url AS payment_url_75, t52.is_generate AS is_generate_76, t52.marge AS marge_77, t52.new_organization_phone_number AS new_organization_phone_number_78, t52.is_new_organization_prescribed AS is_new_organization_prescribed_79, t52.is_not_in_prescriber AS is_not_in_prescriber_80, t52.new_prescriber_legal_name AS new_prescriber_legal_name_81, t52.new_prescriber_vatid AS new_prescriber_vatid_82, t52.new_prescriber_user_email AS new_prescriber_user_email_83, t52.is_attached_to_prescriber AS is_attached_to_prescriber_84, t52.is_paid_by_stripe AS is_paid_by_stripe_85, t52.organization_id AS organization_id_86, t52.new_organization_address_id AS new_organization_address_id_87, t52.invoice_id AS invoice_id_88, t52.prescriber_id AS prescriber_id_89, t52.new_prescriber_address_id AS new_prescriber_address_id_90, t52.discount_code_id AS discount_code_id_91, t0.prescriber_id AS prescriber_id_92, t0.new_prescriber_address_id AS new_prescriber_address_id_93, t94.id AS id_95, t94.created_at AS created_at_96, t94.updated_at AS updated_at_97, t94.is_done AS is_done_98, t94.comment AS comment_99, t94.npai AS npai_100, t94.price_without_tax AS price_without_tax_101, t94.tracking_number AS tracking_number_102, t94.price AS price_103, t94.days_keep AS days_keep_104, t94.organization_id AS organization_id_105, t94.invoice_id AS invoice_id_106, t0.invoice_parent_id AS invoice_parent_id_107, t108.id AS id_109, t108.created_at AS created_at_110, t108.updated_at AS updated_at_111, t108.confirmation_number AS confirmation_number_112, t108.status AS status_113, t108.vatrate AS vatrate_114, t108.price_without_tax AS price_without_tax_115, t108.object AS object_116, t108.path AS path_117, t108.price AS price_118, t108.payment_recurrence AS payment_recurrence_119, t108.new_organization_legal_name AS new_organization_legal_name_120, t108.new_organization_vatid AS new_organization_vatid_121, t108.is_new_organization AS is_new_organization_122, t108.is_prescriber AS is_prescriber_123, t108.total_paid AS total_paid_124, t108.new_organization_user_email AS new_organization_user_email_125, t108.is_sent AS is_sent_126, t108.sent_date AS sent_date_127, t108.sent_to AS sent_to_128, t108.number AS number_129, t108.total_refund AS total_refund_130, t108.is_canceled AS is_canceled_131, t108.discount_without_tax AS discount_without_tax_132, t108.discount_without_tax_percent AS discount_without_tax_percent_133, t108.is_imported AS is_imported_134, t108.is_domiciliation AS is_domiciliation_135, t108.payment_url AS payment_url_136, t108.reference AS reference_137, t108.remaining_to_pay AS remaining_to_pay_138, t108.total_refunded_payment AS total_refunded_payment_139, t108.marge AS marge_140, t108.is_new_organization_prescribed AS is_new_organization_prescribed_141, t108.is_not_in_prescriber AS is_not_in_prescriber_142, t108.new_prescriber_legal_name AS new_prescriber_legal_name_143, t108.new_prescriber_vatid AS new_prescriber_vatid_144, t108.new_prescriber_user_email AS new_prescriber_user_email_145, t108.is_attached_to_prescriber AS is_attached_to_prescriber_146, t108.invoice_type AS invoice_type_147, t108.reference_stripe AS reference_stripe_148, t108.new_organization_phone_number AS new_organization_phone_number_149, t108.payment_deadline AS payment_deadline_150, t108.is_template AS is_template_151, t108.unique_key AS unique_key_152, t108.is_paid_by_stripe AS is_paid_by_stripe_153, t108.is_pack_invoice AS is_pack_invoice_154, t108.sync_billing_report AS sync_billing_report_155, t108.external_id AS external_id_156, t108.organization_id AS organization_id_157, t108.user_id AS user_id_158, t108.new_organization_address_id AS new_organization_address_id_159, t108.prescriber_id AS prescriber_id_160, t108.new_prescriber_address_id AS new_prescriber_address_id_161, t108.invoice_parent_id AS invoice_parent_id_162, t108.discount_code_id AS discount_code_id_163, t0.discount_code_id AS discount_code_id_164 FROM invoice t0 LEFT JOIN quote t52 ON t52.invoice_id = t0.id LEFT JOIN letter_forward t94 ON t94.invoice_id = t0.id LEFT JOIN invoice t108 ON t108.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = 222373;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.status AS status_4,
  t0.vatrate AS vatrate_5,
  t0.price_without_tax AS price_without_tax_6,
  t0.object AS object_7,
  t0.path AS path_8,
  t0.price AS price_9,
  t0.new_organization_legal_name AS new_organization_legal_name_10,
  t0.new_organization_vatid AS new_organization_vatid_11,
  t0.is_new_organization AS is_new_organization_12,
  t0.is_prescriber AS is_prescriber_13,
  t0.new_organization_user_email AS new_organization_user_email_14,
  t0.is_sent AS is_sent_15,
  t0.sent_date AS sent_date_16,
  t0.sent_to AS sent_to_17,
  t0.number AS number_18,
  t0.is_canceled AS is_canceled_19,
  t0.discount_without_tax AS discount_without_tax_20,
  t0.discount_without_tax_percent AS discount_without_tax_percent_21,
  t0.invoice_is_generated AS invoice_is_generated_22,
  t0.payment_url AS payment_url_23,
  t0.is_generate AS is_generate_24,
  t0.marge AS marge_25,
  t0.new_organization_phone_number AS new_organization_phone_number_26,
  t0.is_new_organization_prescribed AS is_new_organization_prescribed_27,
  t0.is_not_in_prescriber AS is_not_in_prescriber_28,
  t0.new_prescriber_legal_name AS new_prescriber_legal_name_29,
  t0.new_prescriber_vatid AS new_prescriber_vatid_30,
  t0.new_prescriber_user_email AS new_prescriber_user_email_31,
  t0.is_attached_to_prescriber AS is_attached_to_prescriber_32,
  t0.is_paid_by_stripe AS is_paid_by_stripe_33,
  t0.organization_id AS organization_id_34,
  t0.new_organization_address_id AS new_organization_address_id_35,
  t0.invoice_id AS invoice_id_36,
  t0.prescriber_id AS prescriber_id_37,
  t0.new_prescriber_address_id AS new_prescriber_address_id_38,
  t0.discount_code_id AS discount_code_id_39
FROM
  quote t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.status AS status_4, t0.vatrate AS vatrate_5, t0.price_without_tax AS price_without_tax_6, t0.object AS object_7, t0.path AS path_8, t0.price AS price_9, t0.new_organization_legal_name AS new_organization_legal_name_10, t0.new_organization_vatid AS new_organization_vatid_11, t0.is_new_organization AS is_new_organization_12, t0.is_prescriber AS is_prescriber_13, t0.new_organization_user_email AS new_organization_user_email_14, t0.is_sent AS is_sent_15, t0.sent_date AS sent_date_16, t0.sent_to AS sent_to_17, t0.number AS number_18, t0.is_canceled AS is_canceled_19, t0.discount_without_tax AS discount_without_tax_20, t0.discount_without_tax_percent AS discount_without_tax_percent_21, t0.invoice_is_generated AS invoice_is_generated_22, t0.payment_url AS payment_url_23, t0.is_generate AS is_generate_24, t0.marge AS marge_25, t0.new_organization_phone_number AS new_organization_phone_number_26, t0.is_new_organization_prescribed AS is_new_organization_prescribed_27, t0.is_not_in_prescriber AS is_not_in_prescriber_28, t0.new_prescriber_legal_name AS new_prescriber_legal_name_29, t0.new_prescriber_vatid AS new_prescriber_vatid_30, t0.new_prescriber_user_email AS new_prescriber_user_email_31, t0.is_attached_to_prescriber AS is_attached_to_prescriber_32, t0.is_paid_by_stripe AS is_paid_by_stripe_33, t0.organization_id AS organization_id_34, t0.new_organization_address_id AS new_organization_address_id_35, t0.invoice_id AS invoice_id_36, t0.prescriber_id AS prescriber_id_37, t0.new_prescriber_address_id AS new_prescriber_address_id_38, t0.discount_code_id AS discount_code_id_39 FROM quote t0 WHERE t0.invoice_id = 222471;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.is_done AS is_done_4,
  t0.comment AS comment_5,
  t0.npai AS npai_6,
  t0.price_without_tax AS price_without_tax_7,
  t0.tracking_number AS tracking_number_8,
  t0.price AS price_9,
  t0.days_keep AS days_keep_10,
  t0.organization_id AS organization_id_11,
  t0.invoice_id AS invoice_id_12
FROM
  letter_forward t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.is_done AS is_done_4, t0.comment AS comment_5, t0.npai AS npai_6, t0.price_without_tax AS price_without_tax_7, t0.tracking_number AS tracking_number_8, t0.price AS price_9, t0.days_keep AS days_keep_10, t0.organization_id AS organization_id_11, t0.invoice_id AS invoice_id_12 FROM letter_forward t0 WHERE t0.invoice_id = 222471;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.confirmation_number AS confirmation_number_4,
  t0.status AS status_5,
  t0.vatrate AS vatrate_6,
  t0.price_without_tax AS price_without_tax_7,
  t0.object AS object_8,
  t0.path AS path_9,
  t0.price AS price_10,
  t0.payment_recurrence AS payment_recurrence_11,
  t0.new_organization_legal_name AS new_organization_legal_name_12,
  t0.new_organization_vatid AS new_organization_vatid_13,
  t0.is_new_organization AS is_new_organization_14,
  t0.is_prescriber AS is_prescriber_15,
  t0.total_paid AS total_paid_16,
  t0.new_organization_user_email AS new_organization_user_email_17,
  t0.is_sent AS is_sent_18,
  t0.sent_date AS sent_date_19,
  t0.sent_to AS sent_to_20,
  t0.number AS number_21,
  t0.total_refund AS total_refund_22,
  t0.is_canceled AS is_canceled_23,
  t0.discount_without_tax AS discount_without_tax_24,
  t0.discount_without_tax_percent AS discount_without_tax_percent_25,
  t0.is_imported AS is_imported_26,
  t0.is_domiciliation AS is_domiciliation_27,
  t0.payment_url AS payment_url_28,
  t0.reference AS reference_29,
  t0.remaining_to_pay AS remaining_to_pay_30,
  t0.total_refunded_payment AS total_refunded_payment_31,
  t0.marge AS marge_32,
  t0.is_new_organization_prescribed AS is_new_organization_prescribed_33,
  t0.is_not_in_prescriber AS is_not_in_prescriber_34,
  t0.new_prescriber_legal_name AS new_prescriber_legal_name_35,
  t0.new_prescriber_vatid AS new_prescriber_vatid_36,
  t0.new_prescriber_user_email AS new_prescriber_user_email_37,
  t0.is_attached_to_prescriber AS is_attached_to_prescriber_38,
  t0.invoice_type AS invoice_type_39,
  t0.reference_stripe AS reference_stripe_40,
  t0.new_organization_phone_number AS new_organization_phone_number_41,
  t0.payment_deadline AS payment_deadline_42,
  t0.is_template AS is_template_43,
  t0.unique_key AS unique_key_44,
  t0.is_paid_by_stripe AS is_paid_by_stripe_45,
  t0.is_pack_invoice AS is_pack_invoice_46,
  t0.sync_billing_report AS sync_billing_report_47,
  t0.external_id AS external_id_48,
  t0.organization_id AS organization_id_49,
  t0.user_id AS user_id_50,
  t0.new_organization_address_id AS new_organization_address_id_51,
  t52.id AS id_53,
  t52.created_at AS created_at_54,
  t52.updated_at AS updated_at_55,
  t52.status AS status_56,
  t52.vatrate AS vatrate_57,
  t52.price_without_tax AS price_without_tax_58,
  t52.object AS object_59,
  t52.path AS path_60,
  t52.price AS price_61,
  t52.new_organization_legal_name AS new_organization_legal_name_62,
  t52.new_organization_vatid AS new_organization_vatid_63,
  t52.is_new_organization AS is_new_organization_64,
  t52.is_prescriber AS is_prescriber_65,
  t52.new_organization_user_email AS new_organization_user_email_66,
  t52.is_sent AS is_sent_67,
  t52.sent_date AS sent_date_68,
  t52.sent_to AS sent_to_69,
  t52.number AS number_70,
  t52.is_canceled AS is_canceled_71,
  t52.discount_without_tax AS discount_without_tax_72,
  t52.discount_without_tax_percent AS discount_without_tax_percent_73,
  t52.invoice_is_generated AS invoice_is_generated_74,
  t52.payment_url AS payment_url_75,
  t52.is_generate AS is_generate_76,
  t52.marge AS marge_77,
  t52.new_organization_phone_number AS new_organization_phone_number_78,
  t52.is_new_organization_prescribed AS is_new_organization_prescribed_79,
  t52.is_not_in_prescriber AS is_not_in_prescriber_80,
  t52.new_prescriber_legal_name AS new_prescriber_legal_name_81,
  t52.new_prescriber_vatid AS new_prescriber_vatid_82,
  t52.new_prescriber_user_email AS new_prescriber_user_email_83,
  t52.is_attached_to_prescriber AS is_attached_to_prescriber_84,
  t52.is_paid_by_stripe AS is_paid_by_stripe_85,
  t52.organization_id AS organization_id_86,
  t52.new_organization_address_id AS new_organization_address_id_87,
  t52.invoice_id AS invoice_id_88,
  t52.prescriber_id AS prescriber_id_89,
  t52.new_prescriber_address_id AS new_prescriber_address_id_90,
  t52.discount_code_id AS discount_code_id_91,
  t0.prescriber_id AS prescriber_id_92,
  t0.new_prescriber_address_id AS new_prescriber_address_id_93,
  t94.id AS id_95,
  t94.created_at AS created_at_96,
  t94.updated_at AS updated_at_97,
  t94.is_done AS is_done_98,
  t94.comment AS comment_99,
  t94.npai AS npai_100,
  t94.price_without_tax AS price_without_tax_101,
  t94.tracking_number AS tracking_number_102,
  t94.price AS price_103,
  t94.days_keep AS days_keep_104,
  t94.organization_id AS organization_id_105,
  t94.invoice_id AS invoice_id_106,
  t0.invoice_parent_id AS invoice_parent_id_107,
  t108.id AS id_109,
  t108.created_at AS created_at_110,
  t108.updated_at AS updated_at_111,
  t108.confirmation_number AS confirmation_number_112,
  t108.status AS status_113,
  t108.vatrate AS vatrate_114,
  t108.price_without_tax AS price_without_tax_115,
  t108.object AS object_116,
  t108.path AS path_117,
  t108.price AS price_118,
  t108.payment_recurrence AS payment_recurrence_119,
  t108.new_organization_legal_name AS new_organization_legal_name_120,
  t108.new_organization_vatid AS new_organization_vatid_121,
  t108.is_new_organization AS is_new_organization_122,
  t108.is_prescriber AS is_prescriber_123,
  t108.total_paid AS total_paid_124,
  t108.new_organization_user_email AS new_organization_user_email_125,
  t108.is_sent AS is_sent_126,
  t108.sent_date AS sent_date_127,
  t108.sent_to AS sent_to_128,
  t108.number AS number_129,
  t108.total_refund AS total_refund_130,
  t108.is_canceled AS is_canceled_131,
  t108.discount_without_tax AS discount_without_tax_132,
  t108.discount_without_tax_percent AS discount_without_tax_percent_133,
  t108.is_imported AS is_imported_134,
  t108.is_domiciliation AS is_domiciliation_135,
  t108.payment_url AS payment_url_136,
  t108.reference AS reference_137,
  t108.remaining_to_pay AS remaining_to_pay_138,
  t108.total_refunded_payment AS total_refunded_payment_139,
  t108.marge AS marge_140,
  t108.is_new_organization_prescribed AS is_new_organization_prescribed_141,
  t108.is_not_in_prescriber AS is_not_in_prescriber_142,
  t108.new_prescriber_legal_name AS new_prescriber_legal_name_143,
  t108.new_prescriber_vatid AS new_prescriber_vatid_144,
  t108.new_prescriber_user_email AS new_prescriber_user_email_145,
  t108.is_attached_to_prescriber AS is_attached_to_prescriber_146,
  t108.invoice_type AS invoice_type_147,
  t108.reference_stripe AS reference_stripe_148,
  t108.new_organization_phone_number AS new_organization_phone_number_149,
  t108.payment_deadline AS payment_deadline_150,
  t108.is_template AS is_template_151,
  t108.unique_key AS unique_key_152,
  t108.is_paid_by_stripe AS is_paid_by_stripe_153,
  t108.is_pack_invoice AS is_pack_invoice_154,
  t108.sync_billing_report AS sync_billing_report_155,
  t108.external_id AS external_id_156,
  t108.organization_id AS organization_id_157,
  t108.user_id AS user_id_158,
  t108.new_organization_address_id AS new_organization_address_id_159,
  t108.prescriber_id AS prescriber_id_160,
  t108.new_prescriber_address_id AS new_prescriber_address_id_161,
  t108.invoice_parent_id AS invoice_parent_id_162,
  t108.discount_code_id AS discount_code_id_163,
  t0.discount_code_id AS discount_code_id_164
FROM
  invoice t0
  LEFT JOIN quote t52 ON t52.invoice_id = t0.id
  LEFT JOIN letter_forward t94 ON t94.invoice_id = t0.id
  LEFT JOIN invoice t108 ON t108.invoice_parent_id = t0.id
WHERE
  t0.invoice_parent_id = ?