Query Metrics
46
Database Queries
15
Different statements
149.41 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 28.30 ms |
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 = ?
Parameters:
[ "stanislas@digidom.pro" "stanislas@digidom.pro" ] |
2 | 3.26 ms |
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_.period_start AS period_start_5, i0_.period_end AS period_end_6, i0_.period_length AS period_length_7, i0_.vatrate AS vatrate_8, i0_.price_without_tax AS price_without_tax_9, i0_.object AS object_10, i0_.path AS path_11, i0_.price AS price_12, i0_.payment_recurrence AS payment_recurrence_13, i0_.new_organization_legal_name AS new_organization_legal_name_14, i0_.new_organization_vatid AS new_organization_vatid_15, i0_.is_new_organization AS is_new_organization_16, i0_.is_prescriber AS is_prescriber_17, i0_.total_paid AS total_paid_18, i0_.new_organization_user_email AS new_organization_user_email_19, i0_.is_sent AS is_sent_20, i0_.sent_date AS sent_date_21, i0_.sent_to AS sent_to_22, i0_.number AS number_23, i0_.total_refund AS total_refund_24, i0_.is_canceled AS is_canceled_25, i0_.discount_without_tax AS discount_without_tax_26, i0_.discount_without_tax_percent AS discount_without_tax_percent_27, i0_.is_imported AS is_imported_28, i0_.is_domiciliation AS is_domiciliation_29, i0_.payment_url AS payment_url_30, i0_.reference AS reference_31, i0_.remaining_to_pay AS remaining_to_pay_32, i0_.total_refunded_payment AS total_refunded_payment_33, i0_.marge AS marge_34, i0_.is_new_organization_prescribed AS is_new_organization_prescribed_35, i0_.is_not_in_prescriber AS is_not_in_prescriber_36, i0_.new_prescriber_legal_name AS new_prescriber_legal_name_37, i0_.new_prescriber_vatid AS new_prescriber_vatid_38, i0_.new_prescriber_user_email AS new_prescriber_user_email_39, i0_.is_attached_to_prescriber AS is_attached_to_prescriber_40, i0_.invoice_type AS invoice_type_41, i0_.reference_stripe AS reference_stripe_42, i0_.new_organization_phone_number AS new_organization_phone_number_43, i0_.payment_deadline AS payment_deadline_44, i0_.is_template AS is_template_45, i0_.unique_key AS unique_key_46, i0_.is_paid_by_stripe AS is_paid_by_stripe_47, i0_.is_pack_invoice AS is_pack_invoice_48, i0_.sync_billing_report AS sync_billing_report_49, i0_.external_id AS external_id_50, i0_.organization_id AS organization_id_51, i0_.user_id AS user_id_52, i0_.new_organization_address_id AS new_organization_address_id_53, i0_.prescriber_id AS prescriber_id_54, i0_.new_prescriber_address_id AS new_prescriber_address_id_55, i0_.invoice_parent_id AS invoice_parent_id_56, i0_.discount_code_id AS discount_code_id_57 FROM invoice i0_ WHERE i0_.organization_id = ? ORDER BY i0_.id DESC LIMIT 12
Parameters:
[
"23797"
]
|
3 | 1.42 ms |
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 = ?
Parameters:
[
210725
]
|
4 | 1.32 ms |
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 = ?
Parameters:
[
210725
]
|
5 | 2.15 ms |
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.period_start AS period_start_6, t0.period_end AS period_end_7, t0.period_length AS period_length_8, t0.vatrate AS vatrate_9, t0.price_without_tax AS price_without_tax_10, t0.object AS object_11, t0.path AS path_12, t0.price AS price_13, t0.payment_recurrence AS payment_recurrence_14, t0.new_organization_legal_name AS new_organization_legal_name_15, t0.new_organization_vatid AS new_organization_vatid_16, t0.is_new_organization AS is_new_organization_17, t0.is_prescriber AS is_prescriber_18, t0.total_paid AS total_paid_19, t0.new_organization_user_email AS new_organization_user_email_20, t0.is_sent AS is_sent_21, t0.sent_date AS sent_date_22, t0.sent_to AS sent_to_23, t0.number AS number_24, t0.total_refund AS total_refund_25, t0.is_canceled AS is_canceled_26, t0.discount_without_tax AS discount_without_tax_27, t0.discount_without_tax_percent AS discount_without_tax_percent_28, t0.is_imported AS is_imported_29, t0.is_domiciliation AS is_domiciliation_30, t0.payment_url AS payment_url_31, t0.reference AS reference_32, t0.remaining_to_pay AS remaining_to_pay_33, t0.total_refunded_payment AS total_refunded_payment_34, t0.marge AS marge_35, t0.is_new_organization_prescribed AS is_new_organization_prescribed_36, t0.is_not_in_prescriber AS is_not_in_prescriber_37, t0.new_prescriber_legal_name AS new_prescriber_legal_name_38, t0.new_prescriber_vatid AS new_prescriber_vatid_39, t0.new_prescriber_user_email AS new_prescriber_user_email_40, t0.is_attached_to_prescriber AS is_attached_to_prescriber_41, t0.invoice_type AS invoice_type_42, t0.reference_stripe AS reference_stripe_43, t0.new_organization_phone_number AS new_organization_phone_number_44, t0.payment_deadline AS payment_deadline_45, t0.is_template AS is_template_46, t0.unique_key AS unique_key_47, t0.is_paid_by_stripe AS is_paid_by_stripe_48, t0.is_pack_invoice AS is_pack_invoice_49, t0.sync_billing_report AS sync_billing_report_50, t0.external_id AS external_id_51, t0.organization_id AS organization_id_52, t0.user_id AS user_id_53, t0.new_organization_address_id AS new_organization_address_id_54, t55.id AS id_56, t55.created_at AS created_at_57, t55.updated_at AS updated_at_58, t55.status AS status_59, t55.vatrate AS vatrate_60, t55.price_without_tax AS price_without_tax_61, t55.object AS object_62, t55.path AS path_63, t55.price AS price_64, t55.new_organization_legal_name AS new_organization_legal_name_65, t55.new_organization_vatid AS new_organization_vatid_66, t55.is_new_organization AS is_new_organization_67, t55.is_prescriber AS is_prescriber_68, t55.new_organization_user_email AS new_organization_user_email_69, t55.is_sent AS is_sent_70, t55.sent_date AS sent_date_71, t55.sent_to AS sent_to_72, t55.number AS number_73, t55.is_canceled AS is_canceled_74, t55.discount_without_tax AS discount_without_tax_75, t55.discount_without_tax_percent AS discount_without_tax_percent_76, t55.invoice_is_generated AS invoice_is_generated_77, t55.payment_url AS payment_url_78, t55.is_generate AS is_generate_79, t55.marge AS marge_80, t55.new_organization_phone_number AS new_organization_phone_number_81, t55.is_new_organization_prescribed AS is_new_organization_prescribed_82, t55.is_not_in_prescriber AS is_not_in_prescriber_83, t55.new_prescriber_legal_name AS new_prescriber_legal_name_84, t55.new_prescriber_vatid AS new_prescriber_vatid_85, t55.new_prescriber_user_email AS new_prescriber_user_email_86, t55.is_attached_to_prescriber AS is_attached_to_prescriber_87, t55.is_paid_by_stripe AS is_paid_by_stripe_88, t55.organization_id AS organization_id_89, t55.new_organization_address_id AS new_organization_address_id_90, t55.invoice_id AS invoice_id_91, t55.prescriber_id AS prescriber_id_92, t55.new_prescriber_address_id AS new_prescriber_address_id_93, t55.discount_code_id AS discount_code_id_94, t0.prescriber_id AS prescriber_id_95, t0.new_prescriber_address_id AS new_prescriber_address_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.updated_at AS updated_at_100, t97.is_done AS is_done_101, t97.comment AS comment_102, t97.npai AS npai_103, t97.price_without_tax AS price_without_tax_104, t97.tracking_number AS tracking_number_105, t97.price AS price_106, t97.days_keep AS days_keep_107, t97.organization_id AS organization_id_108, t97.invoice_id AS invoice_id_109, t0.invoice_parent_id AS invoice_parent_id_110, t111.id AS id_112, t111.created_at AS created_at_113, t111.updated_at AS updated_at_114, t111.confirmation_number AS confirmation_number_115, t111.status AS status_116, t111.period_start AS period_start_117, t111.period_end AS period_end_118, t111.period_length AS period_length_119, t111.vatrate AS vatrate_120, t111.price_without_tax AS price_without_tax_121, t111.object AS object_122, t111.path AS path_123, t111.price AS price_124, t111.payment_recurrence AS payment_recurrence_125, t111.new_organization_legal_name AS new_organization_legal_name_126, t111.new_organization_vatid AS new_organization_vatid_127, t111.is_new_organization AS is_new_organization_128, t111.is_prescriber AS is_prescriber_129, t111.total_paid AS total_paid_130, t111.new_organization_user_email AS new_organization_user_email_131, t111.is_sent AS is_sent_132, t111.sent_date AS sent_date_133, t111.sent_to AS sent_to_134, t111.number AS number_135, t111.total_refund AS total_refund_136, t111.is_canceled AS is_canceled_137, t111.discount_without_tax AS discount_without_tax_138, t111.discount_without_tax_percent AS discount_without_tax_percent_139, t111.is_imported AS is_imported_140, t111.is_domiciliation AS is_domiciliation_141, t111.payment_url AS payment_url_142, t111.reference AS reference_143, t111.remaining_to_pay AS remaining_to_pay_144, t111.total_refunded_payment AS total_refunded_payment_145, t111.marge AS marge_146, t111.is_new_organization_prescribed AS is_new_organization_prescribed_147, t111.is_not_in_prescriber AS is_not_in_prescriber_148, t111.new_prescriber_legal_name AS new_prescriber_legal_name_149, t111.new_prescriber_vatid AS new_prescriber_vatid_150, t111.new_prescriber_user_email AS new_prescriber_user_email_151, t111.is_attached_to_prescriber AS is_attached_to_prescriber_152, t111.invoice_type AS invoice_type_153, t111.reference_stripe AS reference_stripe_154, t111.new_organization_phone_number AS new_organization_phone_number_155, t111.payment_deadline AS payment_deadline_156, t111.is_template AS is_template_157, t111.unique_key AS unique_key_158, t111.is_paid_by_stripe AS is_paid_by_stripe_159, t111.is_pack_invoice AS is_pack_invoice_160, t111.sync_billing_report AS sync_billing_report_161, t111.external_id AS external_id_162, t111.organization_id AS organization_id_163, t111.user_id AS user_id_164, t111.new_organization_address_id AS new_organization_address_id_165, t111.prescriber_id AS prescriber_id_166, t111.new_prescriber_address_id AS new_prescriber_address_id_167, t111.invoice_parent_id AS invoice_parent_id_168, t111.discount_code_id AS discount_code_id_169, t0.discount_code_id AS discount_code_id_170 FROM invoice t0 LEFT JOIN quote t55 ON t55.invoice_id = t0.id LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = ?
Parameters:
[
210725
]
|
6 | 1.27 ms |
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 = ?
Parameters:
[
210298
]
|
7 | 2.66 ms |
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 = ?
Parameters:
[
210298
]
|
8 | 6.89 ms |
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.period_start AS period_start_6, t0.period_end AS period_end_7, t0.period_length AS period_length_8, t0.vatrate AS vatrate_9, t0.price_without_tax AS price_without_tax_10, t0.object AS object_11, t0.path AS path_12, t0.price AS price_13, t0.payment_recurrence AS payment_recurrence_14, t0.new_organization_legal_name AS new_organization_legal_name_15, t0.new_organization_vatid AS new_organization_vatid_16, t0.is_new_organization AS is_new_organization_17, t0.is_prescriber AS is_prescriber_18, t0.total_paid AS total_paid_19, t0.new_organization_user_email AS new_organization_user_email_20, t0.is_sent AS is_sent_21, t0.sent_date AS sent_date_22, t0.sent_to AS sent_to_23, t0.number AS number_24, t0.total_refund AS total_refund_25, t0.is_canceled AS is_canceled_26, t0.discount_without_tax AS discount_without_tax_27, t0.discount_without_tax_percent AS discount_without_tax_percent_28, t0.is_imported AS is_imported_29, t0.is_domiciliation AS is_domiciliation_30, t0.payment_url AS payment_url_31, t0.reference AS reference_32, t0.remaining_to_pay AS remaining_to_pay_33, t0.total_refunded_payment AS total_refunded_payment_34, t0.marge AS marge_35, t0.is_new_organization_prescribed AS is_new_organization_prescribed_36, t0.is_not_in_prescriber AS is_not_in_prescriber_37, t0.new_prescriber_legal_name AS new_prescriber_legal_name_38, t0.new_prescriber_vatid AS new_prescriber_vatid_39, t0.new_prescriber_user_email AS new_prescriber_user_email_40, t0.is_attached_to_prescriber AS is_attached_to_prescriber_41, t0.invoice_type AS invoice_type_42, t0.reference_stripe AS reference_stripe_43, t0.new_organization_phone_number AS new_organization_phone_number_44, t0.payment_deadline AS payment_deadline_45, t0.is_template AS is_template_46, t0.unique_key AS unique_key_47, t0.is_paid_by_stripe AS is_paid_by_stripe_48, t0.is_pack_invoice AS is_pack_invoice_49, t0.sync_billing_report AS sync_billing_report_50, t0.external_id AS external_id_51, t0.organization_id AS organization_id_52, t0.user_id AS user_id_53, t0.new_organization_address_id AS new_organization_address_id_54, t55.id AS id_56, t55.created_at AS created_at_57, t55.updated_at AS updated_at_58, t55.status AS status_59, t55.vatrate AS vatrate_60, t55.price_without_tax AS price_without_tax_61, t55.object AS object_62, t55.path AS path_63, t55.price AS price_64, t55.new_organization_legal_name AS new_organization_legal_name_65, t55.new_organization_vatid AS new_organization_vatid_66, t55.is_new_organization AS is_new_organization_67, t55.is_prescriber AS is_prescriber_68, t55.new_organization_user_email AS new_organization_user_email_69, t55.is_sent AS is_sent_70, t55.sent_date AS sent_date_71, t55.sent_to AS sent_to_72, t55.number AS number_73, t55.is_canceled AS is_canceled_74, t55.discount_without_tax AS discount_without_tax_75, t55.discount_without_tax_percent AS discount_without_tax_percent_76, t55.invoice_is_generated AS invoice_is_generated_77, t55.payment_url AS payment_url_78, t55.is_generate AS is_generate_79, t55.marge AS marge_80, t55.new_organization_phone_number AS new_organization_phone_number_81, t55.is_new_organization_prescribed AS is_new_organization_prescribed_82, t55.is_not_in_prescriber AS is_not_in_prescriber_83, t55.new_prescriber_legal_name AS new_prescriber_legal_name_84, t55.new_prescriber_vatid AS new_prescriber_vatid_85, t55.new_prescriber_user_email AS new_prescriber_user_email_86, t55.is_attached_to_prescriber AS is_attached_to_prescriber_87, t55.is_paid_by_stripe AS is_paid_by_stripe_88, t55.organization_id AS organization_id_89, t55.new_organization_address_id AS new_organization_address_id_90, t55.invoice_id AS invoice_id_91, t55.prescriber_id AS prescriber_id_92, t55.new_prescriber_address_id AS new_prescriber_address_id_93, t55.discount_code_id AS discount_code_id_94, t0.prescriber_id AS prescriber_id_95, t0.new_prescriber_address_id AS new_prescriber_address_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.updated_at AS updated_at_100, t97.is_done AS is_done_101, t97.comment AS comment_102, t97.npai AS npai_103, t97.price_without_tax AS price_without_tax_104, t97.tracking_number AS tracking_number_105, t97.price AS price_106, t97.days_keep AS days_keep_107, t97.organization_id AS organization_id_108, t97.invoice_id AS invoice_id_109, t0.invoice_parent_id AS invoice_parent_id_110, t111.id AS id_112, t111.created_at AS created_at_113, t111.updated_at AS updated_at_114, t111.confirmation_number AS confirmation_number_115, t111.status AS status_116, t111.period_start AS period_start_117, t111.period_end AS period_end_118, t111.period_length AS period_length_119, t111.vatrate AS vatrate_120, t111.price_without_tax AS price_without_tax_121, t111.object AS object_122, t111.path AS path_123, t111.price AS price_124, t111.payment_recurrence AS payment_recurrence_125, t111.new_organization_legal_name AS new_organization_legal_name_126, t111.new_organization_vatid AS new_organization_vatid_127, t111.is_new_organization AS is_new_organization_128, t111.is_prescriber AS is_prescriber_129, t111.total_paid AS total_paid_130, t111.new_organization_user_email AS new_organization_user_email_131, t111.is_sent AS is_sent_132, t111.sent_date AS sent_date_133, t111.sent_to AS sent_to_134, t111.number AS number_135, t111.total_refund AS total_refund_136, t111.is_canceled AS is_canceled_137, t111.discount_without_tax AS discount_without_tax_138, t111.discount_without_tax_percent AS discount_without_tax_percent_139, t111.is_imported AS is_imported_140, t111.is_domiciliation AS is_domiciliation_141, t111.payment_url AS payment_url_142, t111.reference AS reference_143, t111.remaining_to_pay AS remaining_to_pay_144, t111.total_refunded_payment AS total_refunded_payment_145, t111.marge AS marge_146, t111.is_new_organization_prescribed AS is_new_organization_prescribed_147, t111.is_not_in_prescriber AS is_not_in_prescriber_148, t111.new_prescriber_legal_name AS new_prescriber_legal_name_149, t111.new_prescriber_vatid AS new_prescriber_vatid_150, t111.new_prescriber_user_email AS new_prescriber_user_email_151, t111.is_attached_to_prescriber AS is_attached_to_prescriber_152, t111.invoice_type AS invoice_type_153, t111.reference_stripe AS reference_stripe_154, t111.new_organization_phone_number AS new_organization_phone_number_155, t111.payment_deadline AS payment_deadline_156, t111.is_template AS is_template_157, t111.unique_key AS unique_key_158, t111.is_paid_by_stripe AS is_paid_by_stripe_159, t111.is_pack_invoice AS is_pack_invoice_160, t111.sync_billing_report AS sync_billing_report_161, t111.external_id AS external_id_162, t111.organization_id AS organization_id_163, t111.user_id AS user_id_164, t111.new_organization_address_id AS new_organization_address_id_165, t111.prescriber_id AS prescriber_id_166, t111.new_prescriber_address_id AS new_prescriber_address_id_167, t111.invoice_parent_id AS invoice_parent_id_168, t111.discount_code_id AS discount_code_id_169, t0.discount_code_id AS discount_code_id_170 FROM invoice t0 LEFT JOIN quote t55 ON t55.invoice_id = t0.id LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = ?
Parameters:
[
210298
]
|
9 | 5.49 ms |
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 = ?
Parameters:
[
209626
]
|
10 | 3.80 ms |
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 = ?
Parameters:
[
209626
]
|
11 | 4.03 ms |
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.period_start AS period_start_6, t0.period_end AS period_end_7, t0.period_length AS period_length_8, t0.vatrate AS vatrate_9, t0.price_without_tax AS price_without_tax_10, t0.object AS object_11, t0.path AS path_12, t0.price AS price_13, t0.payment_recurrence AS payment_recurrence_14, t0.new_organization_legal_name AS new_organization_legal_name_15, t0.new_organization_vatid AS new_organization_vatid_16, t0.is_new_organization AS is_new_organization_17, t0.is_prescriber AS is_prescriber_18, t0.total_paid AS total_paid_19, t0.new_organization_user_email AS new_organization_user_email_20, t0.is_sent AS is_sent_21, t0.sent_date AS sent_date_22, t0.sent_to AS sent_to_23, t0.number AS number_24, t0.total_refund AS total_refund_25, t0.is_canceled AS is_canceled_26, t0.discount_without_tax AS discount_without_tax_27, t0.discount_without_tax_percent AS discount_without_tax_percent_28, t0.is_imported AS is_imported_29, t0.is_domiciliation AS is_domiciliation_30, t0.payment_url AS payment_url_31, t0.reference AS reference_32, t0.remaining_to_pay AS remaining_to_pay_33, t0.total_refunded_payment AS total_refunded_payment_34, t0.marge AS marge_35, t0.is_new_organization_prescribed AS is_new_organization_prescribed_36, t0.is_not_in_prescriber AS is_not_in_prescriber_37, t0.new_prescriber_legal_name AS new_prescriber_legal_name_38, t0.new_prescriber_vatid AS new_prescriber_vatid_39, t0.new_prescriber_user_email AS new_prescriber_user_email_40, t0.is_attached_to_prescriber AS is_attached_to_prescriber_41, t0.invoice_type AS invoice_type_42, t0.reference_stripe AS reference_stripe_43, t0.new_organization_phone_number AS new_organization_phone_number_44, t0.payment_deadline AS payment_deadline_45, t0.is_template AS is_template_46, t0.unique_key AS unique_key_47, t0.is_paid_by_stripe AS is_paid_by_stripe_48, t0.is_pack_invoice AS is_pack_invoice_49, t0.sync_billing_report AS sync_billing_report_50, t0.external_id AS external_id_51, t0.organization_id AS organization_id_52, t0.user_id AS user_id_53, t0.new_organization_address_id AS new_organization_address_id_54, t55.id AS id_56, t55.created_at AS created_at_57, t55.updated_at AS updated_at_58, t55.status AS status_59, t55.vatrate AS vatrate_60, t55.price_without_tax AS price_without_tax_61, t55.object AS object_62, t55.path AS path_63, t55.price AS price_64, t55.new_organization_legal_name AS new_organization_legal_name_65, t55.new_organization_vatid AS new_organization_vatid_66, t55.is_new_organization AS is_new_organization_67, t55.is_prescriber AS is_prescriber_68, t55.new_organization_user_email AS new_organization_user_email_69, t55.is_sent AS is_sent_70, t55.sent_date AS sent_date_71, t55.sent_to AS sent_to_72, t55.number AS number_73, t55.is_canceled AS is_canceled_74, t55.discount_without_tax AS discount_without_tax_75, t55.discount_without_tax_percent AS discount_without_tax_percent_76, t55.invoice_is_generated AS invoice_is_generated_77, t55.payment_url AS payment_url_78, t55.is_generate AS is_generate_79, t55.marge AS marge_80, t55.new_organization_phone_number AS new_organization_phone_number_81, t55.is_new_organization_prescribed AS is_new_organization_prescribed_82, t55.is_not_in_prescriber AS is_not_in_prescriber_83, t55.new_prescriber_legal_name AS new_prescriber_legal_name_84, t55.new_prescriber_vatid AS new_prescriber_vatid_85, t55.new_prescriber_user_email AS new_prescriber_user_email_86, t55.is_attached_to_prescriber AS is_attached_to_prescriber_87, t55.is_paid_by_stripe AS is_paid_by_stripe_88, t55.organization_id AS organization_id_89, t55.new_organization_address_id AS new_organization_address_id_90, t55.invoice_id AS invoice_id_91, t55.prescriber_id AS prescriber_id_92, t55.new_prescriber_address_id AS new_prescriber_address_id_93, t55.discount_code_id AS discount_code_id_94, t0.prescriber_id AS prescriber_id_95, t0.new_prescriber_address_id AS new_prescriber_address_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.updated_at AS updated_at_100, t97.is_done AS is_done_101, t97.comment AS comment_102, t97.npai AS npai_103, t97.price_without_tax AS price_without_tax_104, t97.tracking_number AS tracking_number_105, t97.price AS price_106, t97.days_keep AS days_keep_107, t97.organization_id AS organization_id_108, t97.invoice_id AS invoice_id_109, t0.invoice_parent_id AS invoice_parent_id_110, t111.id AS id_112, t111.created_at AS created_at_113, t111.updated_at AS updated_at_114, t111.confirmation_number AS confirmation_number_115, t111.status AS status_116, t111.period_start AS period_start_117, t111.period_end AS period_end_118, t111.period_length AS period_length_119, t111.vatrate AS vatrate_120, t111.price_without_tax AS price_without_tax_121, t111.object AS object_122, t111.path AS path_123, t111.price AS price_124, t111.payment_recurrence AS payment_recurrence_125, t111.new_organization_legal_name AS new_organization_legal_name_126, t111.new_organization_vatid AS new_organization_vatid_127, t111.is_new_organization AS is_new_organization_128, t111.is_prescriber AS is_prescriber_129, t111.total_paid AS total_paid_130, t111.new_organization_user_email AS new_organization_user_email_131, t111.is_sent AS is_sent_132, t111.sent_date AS sent_date_133, t111.sent_to AS sent_to_134, t111.number AS number_135, t111.total_refund AS total_refund_136, t111.is_canceled AS is_canceled_137, t111.discount_without_tax AS discount_without_tax_138, t111.discount_without_tax_percent AS discount_without_tax_percent_139, t111.is_imported AS is_imported_140, t111.is_domiciliation AS is_domiciliation_141, t111.payment_url AS payment_url_142, t111.reference AS reference_143, t111.remaining_to_pay AS remaining_to_pay_144, t111.total_refunded_payment AS total_refunded_payment_145, t111.marge AS marge_146, t111.is_new_organization_prescribed AS is_new_organization_prescribed_147, t111.is_not_in_prescriber AS is_not_in_prescriber_148, t111.new_prescriber_legal_name AS new_prescriber_legal_name_149, t111.new_prescriber_vatid AS new_prescriber_vatid_150, t111.new_prescriber_user_email AS new_prescriber_user_email_151, t111.is_attached_to_prescriber AS is_attached_to_prescriber_152, t111.invoice_type AS invoice_type_153, t111.reference_stripe AS reference_stripe_154, t111.new_organization_phone_number AS new_organization_phone_number_155, t111.payment_deadline AS payment_deadline_156, t111.is_template AS is_template_157, t111.unique_key AS unique_key_158, t111.is_paid_by_stripe AS is_paid_by_stripe_159, t111.is_pack_invoice AS is_pack_invoice_160, t111.sync_billing_report AS sync_billing_report_161, t111.external_id AS external_id_162, t111.organization_id AS organization_id_163, t111.user_id AS user_id_164, t111.new_organization_address_id AS new_organization_address_id_165, t111.prescriber_id AS prescriber_id_166, t111.new_prescriber_address_id AS new_prescriber_address_id_167, t111.invoice_parent_id AS invoice_parent_id_168, t111.discount_code_id AS discount_code_id_169, t0.discount_code_id AS discount_code_id_170 FROM invoice t0 LEFT JOIN quote t55 ON t55.invoice_id = t0.id LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = ?
Parameters:
[
209626
]
|
12 | 5.44 ms |
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 = ?
Parameters:
[
203381
]
|
13 | 1.13 ms |
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 = ?
Parameters:
[
203381
]
|
14 | 2.36 ms |
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.period_start AS period_start_6, t0.period_end AS period_end_7, t0.period_length AS period_length_8, t0.vatrate AS vatrate_9, t0.price_without_tax AS price_without_tax_10, t0.object AS object_11, t0.path AS path_12, t0.price AS price_13, t0.payment_recurrence AS payment_recurrence_14, t0.new_organization_legal_name AS new_organization_legal_name_15, t0.new_organization_vatid AS new_organization_vatid_16, t0.is_new_organization AS is_new_organization_17, t0.is_prescriber AS is_prescriber_18, t0.total_paid AS total_paid_19, t0.new_organization_user_email AS new_organization_user_email_20, t0.is_sent AS is_sent_21, t0.sent_date AS sent_date_22, t0.sent_to AS sent_to_23, t0.number AS number_24, t0.total_refund AS total_refund_25, t0.is_canceled AS is_canceled_26, t0.discount_without_tax AS discount_without_tax_27, t0.discount_without_tax_percent AS discount_without_tax_percent_28, t0.is_imported AS is_imported_29, t0.is_domiciliation AS is_domiciliation_30, t0.payment_url AS payment_url_31, t0.reference AS reference_32, t0.remaining_to_pay AS remaining_to_pay_33, t0.total_refunded_payment AS total_refunded_payment_34, t0.marge AS marge_35, t0.is_new_organization_prescribed AS is_new_organization_prescribed_36, t0.is_not_in_prescriber AS is_not_in_prescriber_37, t0.new_prescriber_legal_name AS new_prescriber_legal_name_38, t0.new_prescriber_vatid AS new_prescriber_vatid_39, t0.new_prescriber_user_email AS new_prescriber_user_email_40, t0.is_attached_to_prescriber AS is_attached_to_prescriber_41, t0.invoice_type AS invoice_type_42, t0.reference_stripe AS reference_stripe_43, t0.new_organization_phone_number AS new_organization_phone_number_44, t0.payment_deadline AS payment_deadline_45, t0.is_template AS is_template_46, t0.unique_key AS unique_key_47, t0.is_paid_by_stripe AS is_paid_by_stripe_48, t0.is_pack_invoice AS is_pack_invoice_49, t0.sync_billing_report AS sync_billing_report_50, t0.external_id AS external_id_51, t0.organization_id AS organization_id_52, t0.user_id AS user_id_53, t0.new_organization_address_id AS new_organization_address_id_54, t55.id AS id_56, t55.created_at AS created_at_57, t55.updated_at AS updated_at_58, t55.status AS status_59, t55.vatrate AS vatrate_60, t55.price_without_tax AS price_without_tax_61, t55.object AS object_62, t55.path AS path_63, t55.price AS price_64, t55.new_organization_legal_name AS new_organization_legal_name_65, t55.new_organization_vatid AS new_organization_vatid_66, t55.is_new_organization AS is_new_organization_67, t55.is_prescriber AS is_prescriber_68, t55.new_organization_user_email AS new_organization_user_email_69, t55.is_sent AS is_sent_70, t55.sent_date AS sent_date_71, t55.sent_to AS sent_to_72, t55.number AS number_73, t55.is_canceled AS is_canceled_74, t55.discount_without_tax AS discount_without_tax_75, t55.discount_without_tax_percent AS discount_without_tax_percent_76, t55.invoice_is_generated AS invoice_is_generated_77, t55.payment_url AS payment_url_78, t55.is_generate AS is_generate_79, t55.marge AS marge_80, t55.new_organization_phone_number AS new_organization_phone_number_81, t55.is_new_organization_prescribed AS is_new_organization_prescribed_82, t55.is_not_in_prescriber AS is_not_in_prescriber_83, t55.new_prescriber_legal_name AS new_prescriber_legal_name_84, t55.new_prescriber_vatid AS new_prescriber_vatid_85, t55.new_prescriber_user_email AS new_prescriber_user_email_86, t55.is_attached_to_prescriber AS is_attached_to_prescriber_87, t55.is_paid_by_stripe AS is_paid_by_stripe_88, t55.organization_id AS organization_id_89, t55.new_organization_address_id AS new_organization_address_id_90, t55.invoice_id AS invoice_id_91, t55.prescriber_id AS prescriber_id_92, t55.new_prescriber_address_id AS new_prescriber_address_id_93, t55.discount_code_id AS discount_code_id_94, t0.prescriber_id AS prescriber_id_95, t0.new_prescriber_address_id AS new_prescriber_address_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.updated_at AS updated_at_100, t97.is_done AS is_done_101, t97.comment AS comment_102, t97.npai AS npai_103, t97.price_without_tax AS price_without_tax_104, t97.tracking_number AS tracking_number_105, t97.price AS price_106, t97.days_keep AS days_keep_107, t97.organization_id AS organization_id_108, t97.invoice_id AS invoice_id_109, t0.invoice_parent_id AS invoice_parent_id_110, t111.id AS id_112, t111.created_at AS created_at_113, t111.updated_at AS updated_at_114, t111.confirmation_number AS confirmation_number_115, t111.status AS status_116, t111.period_start AS period_start_117, t111.period_end AS period_end_118, t111.period_length AS period_length_119, t111.vatrate AS vatrate_120, t111.price_without_tax AS price_without_tax_121, t111.object AS object_122, t111.path AS path_123, t111.price AS price_124, t111.payment_recurrence AS payment_recurrence_125, t111.new_organization_legal_name AS new_organization_legal_name_126, t111.new_organization_vatid AS new_organization_vatid_127, t111.is_new_organization AS is_new_organization_128, t111.is_prescriber AS is_prescriber_129, t111.total_paid AS total_paid_130, t111.new_organization_user_email AS new_organization_user_email_131, t111.is_sent AS is_sent_132, t111.sent_date AS sent_date_133, t111.sent_to AS sent_to_134, t111.number AS number_135, t111.total_refund AS total_refund_136, t111.is_canceled AS is_canceled_137, t111.discount_without_tax AS discount_without_tax_138, t111.discount_without_tax_percent AS discount_without_tax_percent_139, t111.is_imported AS is_imported_140, t111.is_domiciliation AS is_domiciliation_141, t111.payment_url AS payment_url_142, t111.reference AS reference_143, t111.remaining_to_pay AS remaining_to_pay_144, t111.total_refunded_payment AS total_refunded_payment_145, t111.marge AS marge_146, t111.is_new_organization_prescribed AS is_new_organization_prescribed_147, t111.is_not_in_prescriber AS is_not_in_prescriber_148, t111.new_prescriber_legal_name AS new_prescriber_legal_name_149, t111.new_prescriber_vatid AS new_prescriber_vatid_150, t111.new_prescriber_user_email AS new_prescriber_user_email_151, t111.is_attached_to_prescriber AS is_attached_to_prescriber_152, t111.invoice_type AS invoice_type_153, t111.reference_stripe AS reference_stripe_154, t111.new_organization_phone_number AS new_organization_phone_number_155, t111.payment_deadline AS payment_deadline_156, t111.is_template AS is_template_157, t111.unique_key AS unique_key_158, t111.is_paid_by_stripe AS is_paid_by_stripe_159, t111.is_pack_invoice AS is_pack_invoice_160, t111.sync_billing_report AS sync_billing_report_161, t111.external_id AS external_id_162, t111.organization_id AS organization_id_163, t111.user_id AS user_id_164, t111.new_organization_address_id AS new_organization_address_id_165, t111.prescriber_id AS prescriber_id_166, t111.new_prescriber_address_id AS new_prescriber_address_id_167, t111.invoice_parent_id AS invoice_parent_id_168, t111.discount_code_id AS discount_code_id_169, t0.discount_code_id AS discount_code_id_170 FROM invoice t0 LEFT JOIN quote t55 ON t55.invoice_id = t0.id LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = ?
Parameters:
[
203381
]
|
15 | 1.49 ms |
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 = ?
Parameters:
[
189096
]
|
16 | 1.01 ms |
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 = ?
Parameters:
[
189096
]
|
17 | 2.00 ms |
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.period_start AS period_start_6, t0.period_end AS period_end_7, t0.period_length AS period_length_8, t0.vatrate AS vatrate_9, t0.price_without_tax AS price_without_tax_10, t0.object AS object_11, t0.path AS path_12, t0.price AS price_13, t0.payment_recurrence AS payment_recurrence_14, t0.new_organization_legal_name AS new_organization_legal_name_15, t0.new_organization_vatid AS new_organization_vatid_16, t0.is_new_organization AS is_new_organization_17, t0.is_prescriber AS is_prescriber_18, t0.total_paid AS total_paid_19, t0.new_organization_user_email AS new_organization_user_email_20, t0.is_sent AS is_sent_21, t0.sent_date AS sent_date_22, t0.sent_to AS sent_to_23, t0.number AS number_24, t0.total_refund AS total_refund_25, t0.is_canceled AS is_canceled_26, t0.discount_without_tax AS discount_without_tax_27, t0.discount_without_tax_percent AS discount_without_tax_percent_28, t0.is_imported AS is_imported_29, t0.is_domiciliation AS is_domiciliation_30, t0.payment_url AS payment_url_31, t0.reference AS reference_32, t0.remaining_to_pay AS remaining_to_pay_33, t0.total_refunded_payment AS total_refunded_payment_34, t0.marge AS marge_35, t0.is_new_organization_prescribed AS is_new_organization_prescribed_36, t0.is_not_in_prescriber AS is_not_in_prescriber_37, t0.new_prescriber_legal_name AS new_prescriber_legal_name_38, t0.new_prescriber_vatid AS new_prescriber_vatid_39, t0.new_prescriber_user_email AS new_prescriber_user_email_40, t0.is_attached_to_prescriber AS is_attached_to_prescriber_41, t0.invoice_type AS invoice_type_42, t0.reference_stripe AS reference_stripe_43, t0.new_organization_phone_number AS new_organization_phone_number_44, t0.payment_deadline AS payment_deadline_45, t0.is_template AS is_template_46, t0.unique_key AS unique_key_47, t0.is_paid_by_stripe AS is_paid_by_stripe_48, t0.is_pack_invoice AS is_pack_invoice_49, t0.sync_billing_report AS sync_billing_report_50, t0.external_id AS external_id_51, t0.organization_id AS organization_id_52, t0.user_id AS user_id_53, t0.new_organization_address_id AS new_organization_address_id_54, t55.id AS id_56, t55.created_at AS created_at_57, t55.updated_at AS updated_at_58, t55.status AS status_59, t55.vatrate AS vatrate_60, t55.price_without_tax AS price_without_tax_61, t55.object AS object_62, t55.path AS path_63, t55.price AS price_64, t55.new_organization_legal_name AS new_organization_legal_name_65, t55.new_organization_vatid AS new_organization_vatid_66, t55.is_new_organization AS is_new_organization_67, t55.is_prescriber AS is_prescriber_68, t55.new_organization_user_email AS new_organization_user_email_69, t55.is_sent AS is_sent_70, t55.sent_date AS sent_date_71, t55.sent_to AS sent_to_72, t55.number AS number_73, t55.is_canceled AS is_canceled_74, t55.discount_without_tax AS discount_without_tax_75, t55.discount_without_tax_percent AS discount_without_tax_percent_76, t55.invoice_is_generated AS invoice_is_generated_77, t55.payment_url AS payment_url_78, t55.is_generate AS is_generate_79, t55.marge AS marge_80, t55.new_organization_phone_number AS new_organization_phone_number_81, t55.is_new_organization_prescribed AS is_new_organization_prescribed_82, t55.is_not_in_prescriber AS is_not_in_prescriber_83, t55.new_prescriber_legal_name AS new_prescriber_legal_name_84, t55.new_prescriber_vatid AS new_prescriber_vatid_85, t55.new_prescriber_user_email AS new_prescriber_user_email_86, t55.is_attached_to_prescriber AS is_attached_to_prescriber_87, t55.is_paid_by_stripe AS is_paid_by_stripe_88, t55.organization_id AS organization_id_89, t55.new_organization_address_id AS new_organization_address_id_90, t55.invoice_id AS invoice_id_91, t55.prescriber_id AS prescriber_id_92, t55.new_prescriber_address_id AS new_prescriber_address_id_93, t55.discount_code_id AS discount_code_id_94, t0.prescriber_id AS prescriber_id_95, t0.new_prescriber_address_id AS new_prescriber_address_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.updated_at AS updated_at_100, t97.is_done AS is_done_101, t97.comment AS comment_102, t97.npai AS npai_103, t97.price_without_tax AS price_without_tax_104, t97.tracking_number AS tracking_number_105, t97.price AS price_106, t97.days_keep AS days_keep_107, t97.organization_id AS organization_id_108, t97.invoice_id AS invoice_id_109, t0.invoice_parent_id AS invoice_parent_id_110, t111.id AS id_112, t111.created_at AS created_at_113, t111.updated_at AS updated_at_114, t111.confirmation_number AS confirmation_number_115, t111.status AS status_116, t111.period_start AS period_start_117, t111.period_end AS period_end_118, t111.period_length AS period_length_119, t111.vatrate AS vatrate_120, t111.price_without_tax AS price_without_tax_121, t111.object AS object_122, t111.path AS path_123, t111.price AS price_124, t111.payment_recurrence AS payment_recurrence_125, t111.new_organization_legal_name AS new_organization_legal_name_126, t111.new_organization_vatid AS new_organization_vatid_127, t111.is_new_organization AS is_new_organization_128, t111.is_prescriber AS is_prescriber_129, t111.total_paid AS total_paid_130, t111.new_organization_user_email AS new_organization_user_email_131, t111.is_sent AS is_sent_132, t111.sent_date AS sent_date_133, t111.sent_to AS sent_to_134, t111.number AS number_135, t111.total_refund AS total_refund_136, t111.is_canceled AS is_canceled_137, t111.discount_without_tax AS discount_without_tax_138, t111.discount_without_tax_percent AS discount_without_tax_percent_139, t111.is_imported AS is_imported_140, t111.is_domiciliation AS is_domiciliation_141, t111.payment_url AS payment_url_142, t111.reference AS reference_143, t111.remaining_to_pay AS remaining_to_pay_144, t111.total_refunded_payment AS total_refunded_payment_145, t111.marge AS marge_146, t111.is_new_organization_prescribed AS is_new_organization_prescribed_147, t111.is_not_in_prescriber AS is_not_in_prescriber_148, t111.new_prescriber_legal_name AS new_prescriber_legal_name_149, t111.new_prescriber_vatid AS new_prescriber_vatid_150, t111.new_prescriber_user_email AS new_prescriber_user_email_151, t111.is_attached_to_prescriber AS is_attached_to_prescriber_152, t111.invoice_type AS invoice_type_153, t111.reference_stripe AS reference_stripe_154, t111.new_organization_phone_number AS new_organization_phone_number_155, t111.payment_deadline AS payment_deadline_156, t111.is_template AS is_template_157, t111.unique_key AS unique_key_158, t111.is_paid_by_stripe AS is_paid_by_stripe_159, t111.is_pack_invoice AS is_pack_invoice_160, t111.sync_billing_report AS sync_billing_report_161, t111.external_id AS external_id_162, t111.organization_id AS organization_id_163, t111.user_id AS user_id_164, t111.new_organization_address_id AS new_organization_address_id_165, t111.prescriber_id AS prescriber_id_166, t111.new_prescriber_address_id AS new_prescriber_address_id_167, t111.invoice_parent_id AS invoice_parent_id_168, t111.discount_code_id AS discount_code_id_169, t0.discount_code_id AS discount_code_id_170 FROM invoice t0 LEFT JOIN quote t55 ON t55.invoice_id = t0.id LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id WHERE t0.invoice_parent_id = ?
Parameters:
[
189096
]
|
18 | 7.31 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.path AS path_5, t0.number AS number_6, t0.type AS type_7, t0.printable_note AS printable_note_8, t0.sync_billing_report AS sync_billing_report_9, t0.external_id AS external_id_10, t0.invoice_id AS invoice_id_11, t0.organization_id AS organization_id_12 FROM credit_note t0 WHERE t0.invoice_id = ?
Parameters:
[
210725
]
|
19 | 2.09 ms |
SELECT t0.id AS id_1, t0.legal_name AS legal_name_2, t0.telephone AS telephone_3, t0.vat_id AS vat_id_4, t0.legal_status AS legal_status_5, t0.purpose AS purpose_6, t0.founding_date AS founding_date_7, t0.fiscal_date AS fiscal_date_8, t0.fiscal_date_end AS fiscal_date_end_9, t0.first_fiscal_date AS first_fiscal_date_10, t0.first_fiscal_date_end AS first_fiscal_date_end_11, t0.head_quarters_address_type AS head_quarters_address_type_12, t0.legal_representative_address_type AS legal_representative_address_type_13, t0.share_capital AS share_capital_14, t0.share_capital_type AS share_capital_type_15, t0.share_capital_fixed_amount AS share_capital_fixed_amount_16, t0.shares_count AS shares_count_17, t0.bank_choice AS bank_choice_18, t0.registration_source AS registration_source_19, t0.commercial_court_registry AS commercial_court_registry_20, t0.sector_other AS sector_other_21, t0.rcs AS rcs_22, t0.status AS status_23, t0.email AS email_24, t0.mandatary AS mandatary_25, t0.bal AS bal_26, t0.forwarding_frequency AS forwarding_frequency_27, t0.forwarding_address_name AS forwarding_address_name_28, t0.alternate_name AS alternate_name_29, t0.domiciliation_start_date AS domiciliation_start_date_30, t0.created_at AS created_at_31, t0.termination_date AS termination_date_32, t0.termination_reason AS termination_reason_33, t0.termination_reason_other AS termination_reason_other_34, t0.siret AS siret_35, t0.is_new_immatriculation AS is_new_immatriculation_36, t0.is_new_domiciliation AS is_new_domiciliation_37, t0.mandat_id AS mandat_id_38, t0.conversion_reason AS conversion_reason_39, t0.status_is_forced AS status_is_forced_40, t0.uniq_id AS uniq_id_41, t0.iban AS iban_42, t0.reference_gocardless AS reference_gocardless_43, t0.is_forwarding_active AS is_forwarding_active_44, t0.vatrate AS vatrate_45, t0.is_imported AS is_imported_46, t0.credit_notes_amount AS credit_notes_amount_47, t0.available_credits AS available_credits_48, t0.invoice_token AS invoice_token_49, t0.share_capital_free_percentage AS share_capital_free_percentage_50, t0.is_prescriber AS is_prescriber_51, t0.have_accountant AS have_accountant_52, t0.status_immatriculation AS status_immatriculation_53, t0.is_exempt_tva AS is_exempt_tva_54, t0.project_stage AS project_stage_55, t0.status_invoice_payed AS status_invoice_payed_56, t0.date_max_unpaid AS date_max_unpaid_57, t0.is_have_auditor AS is_have_auditor_58, t0.benefit_imposition AS benefit_imposition_59, t0.benefit_imposition_option AS benefit_imposition_option_60, t0.vat_taxe_regim AS vat_taxe_regim_61, t0.vat_taxe_regime_option AS vat_taxe_regime_option_62, t0.prolongation_date_kyc AS prolongation_date_kyc_63, t0.status_transfert AS status_transfert_64, t0.is_new_transfert AS is_new_transfert_65, t0.special_request_bal AS special_request_bal_66, t0.trac_fin AS trac_fin_67, t0.trac_fin_note AS trac_fin_note_68, t0.pack_imat AS pack_imat_69, t0.is_authorize_prescriber AS is_authorize_prescriber_70, t0.is_attached_to_prescriber AS is_attached_to_prescriber_71, t0.is_emptybal AS is_emptybal_72, t0.is_authorized_debit AS is_authorized_debit_73, t0.history_nav_tunnel AS history_nav_tunnel_74, t0.note AS note_75, t0.reason_change AS reason_change_76, t0.previous_pack AS previous_pack_77, t0.zapier_hook_url AS zapier_hook_url_78, t0.sigle AS sigle_79, t0.enseigne AS enseigne_80, t0.corporate_object AS corporate_object_81, t0.place_know_digidom AS place_know_digidom_82, t0.other_place_known_digidom AS other_place_known_digidom_83, t0.bank_name AS bank_name_84, t0.titulaire AS titulaire_85, t0.is_invalid_email AS is_invalid_email_86, t0.is_invalid_phone_number AS is_invalid_phone_number_87, t0.special_customer_type AS special_customer_type_88, t0.encrypted_parent_id AS encrypted_parent_id_89, t0.is_referral_process_finished AS is_referral_process_finished_90, t0.is_digidom_accountant AS is_digidom_accountant_91, t0.is_surveillance AS is_surveillance_92, t0.beneficial_owners AS beneficial_owners_93, t0.accounts_submission_last_year AS accounts_submission_last_year_94, t0.address_id AS address_id_95, t0.accountant_id AS accountant_id_96, t0.sector_id AS sector_id_97, t0.store_id AS store_id_98, t0.forwarding_address_id AS forwarding_address_id_99, t0.prescriber_id AS prescriber_id_100, t0.notification_preference_id AS notification_preference_id_101, t0.discount_code_id AS discount_code_id_102, t103.id AS id_104, t103.given_name AS given_name_105, t103.family_name AS family_name_106, t103.phone_number AS phone_number_107, t103.email AS email_108, t103.service AS service_109, t103.created_at AS created_at_110, t103.note AS note_111, t103.status AS status_112, t103.generate_user AS generate_user_113, t103.call_time AS call_time_114, t103.priority AS priority_115, t103.date AS date_116, t103.step AS step_117, t103.source AS source_118, t103.legal_name AS legal_name_119, t103.pack AS pack_120, t103.manager_id AS manager_id_121, t103.formality_id AS formality_id_122, t103.organization_id AS organization_id_123, t0.prescriber_source_id AS prescriber_source_id_124, t0.reason_unpaid_id AS reason_unpaid_id_125, t0.reason_ribinactive_id AS reason_ribinactive_id_126, t127.id AS id_128, t127.alternate_name AS alternate_name_129, t127.legal_name AS legal_name_130, t127.name_legal_representative AS name_legal_representative_131, t127.organization_id AS organization_id_132, t0.activity_category_id AS activity_category_id_133, t0.referral_source_id AS referral_source_id_134, t0.activity_domain_id AS activity_domain_id_135, t136.id AS id_137, t136.signature_request_id AS signature_request_id_138, t136.created_at AS created_at_139, t136.external_file_id AS external_file_id_140, t136.last_uploaded_file_at AS last_uploaded_file_at_141, t136.organization_id AS organization_id_142 FROM organization t0 LEFT JOIN leads t103 ON t103.organization_id = t0.id LEFT JOIN ibml_organization_configuration t127 ON t127.organization_id = t0.id LEFT JOIN process_yousign t136 ON t136.organization_id = t0.id WHERE t0.id = ?
Parameters:
[
23797
]
|
20 | 4.79 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.price AS price_3, t0.type AS type_4, t0.subscription_deposit AS subscription_deposit_5, t0.created_at AS created_at_6, t0.discount_without_tax AS discount_without_tax_7, t0.payment_dates AS payment_dates_8, t0.price_without_tax AS price_without_tax_9, t0.stored_total_price_without_tax AS stored_total_price_without_tax_10, t0.is_updated_price AS is_updated_price_11, t0.next_payment AS next_payment_12, t0.pack_history AS pack_history_13, t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14, t0.invoice_generation_date AS invoice_generation_date_15, t0.month_number AS month_number_16, t0.authorized_reccurency AS authorized_reccurency_17, t0.is_cancel_using_offer AS is_cancel_using_offer_18, t0.is_digipack_offer AS is_digipack_offer_19, t0.deadline_offered AS deadline_offered_20, t0.prepaid_months AS prepaid_months_21, t0.has_blocked_service AS has_blocked_service_22, t0.document_recovery_delay AS document_recovery_delay_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t26.id AS id_27, t26.name AS name_28, t26.price AS price_29, t26.focus AS focus_30, t26.price_without_tax AS price_without_tax_31, t26.vat_rate AS vat_rate_32, t26.discount AS discount_33, t26.unique_key AS unique_key_34, t26.automation AS automation_35, t26.is_published AS is_published_36, t26.is_subscription AS is_subscription_37, t26.published_name AS published_name_38, t26.is_published_pack AS is_published_pack_39, t26.type AS type_40, t26.legal_status AS legal_status_41, t26.created_at AS created_at_42, t26.association_pack_id AS association_pack_id_43, t26.category_id AS category_id_44, t26.recurring_invoice_id AS recurring_invoice_id_45, t26.initial_invoice_id AS initial_invoice_id_46, t26.subscription_id AS subscription_id_47 FROM subscription t0 LEFT JOIN pack t26 ON t26.subscription_id = t0.id WHERE t0.organization_id = ?
Parameters:
[
23797
]
|
21 | 6.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_id = ?
Parameters:
[
35528
]
|
22 | 1.66 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.confirmation_number AS confirmation_number_5, t0.status AS status_6, t0.paid_out_at AS paid_out_at_7, t0.is_can_retry AS is_can_retry_8, t0.payment_date AS payment_date_9, t0.reference AS reference_10, t0.payment_note AS payment_note_11, t0.invoice_id AS invoice_id_12 FROM payment t0 WHERE t0.invoice_id = ?
Parameters:
[
210725
]
|
23 | 1.31 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
210725
]
|
24 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
17
]
|
25 | 2.61 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.status AS status_6, t0.refund_id AS refund_id_7, t0.invoice_id AS invoice_id_8 FROM refund t0 WHERE t0.invoice_id = ?
Parameters:
[
210725
]
|
26 | 1.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.type AS type_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
27 | 2.65 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.path AS path_5, t0.number AS number_6, t0.type AS type_7, t0.printable_note AS printable_note_8, t0.sync_billing_report AS sync_billing_report_9, t0.external_id AS external_id_10, t0.invoice_id AS invoice_id_11, t0.organization_id AS organization_id_12 FROM credit_note t0 WHERE t0.invoice_id = ?
Parameters:
[
210298
]
|
28 | 1.18 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.confirmation_number AS confirmation_number_5, t0.status AS status_6, t0.paid_out_at AS paid_out_at_7, t0.is_can_retry AS is_can_retry_8, t0.payment_date AS payment_date_9, t0.reference AS reference_10, t0.payment_note AS payment_note_11, t0.invoice_id AS invoice_id_12 FROM payment t0 WHERE t0.invoice_id = ?
Parameters:
[
210298
]
|
29 | 1.10 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
210298
]
|
30 | 1.09 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.status AS status_6, t0.refund_id AS refund_id_7, t0.invoice_id AS invoice_id_8 FROM refund t0 WHERE t0.invoice_id = ?
Parameters:
[
210298
]
|
31 | 8.89 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.path AS path_5, t0.number AS number_6, t0.type AS type_7, t0.printable_note AS printable_note_8, t0.sync_billing_report AS sync_billing_report_9, t0.external_id AS external_id_10, t0.invoice_id AS invoice_id_11, t0.organization_id AS organization_id_12 FROM credit_note t0 WHERE t0.invoice_id = ?
Parameters:
[
209626
]
|
32 | 1.41 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.confirmation_number AS confirmation_number_5, t0.status AS status_6, t0.paid_out_at AS paid_out_at_7, t0.is_can_retry AS is_can_retry_8, t0.payment_date AS payment_date_9, t0.reference AS reference_10, t0.payment_note AS payment_note_11, t0.invoice_id AS invoice_id_12 FROM payment t0 WHERE t0.invoice_id = ?
Parameters:
[
209626
]
|
33 | 1.23 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
209626
]
|
34 | 1.07 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.status AS status_6, t0.refund_id AS refund_id_7, t0.invoice_id AS invoice_id_8 FROM refund t0 WHERE t0.invoice_id = ?
Parameters:
[
209626
]
|
35 | 6.60 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.path AS path_5, t0.number AS number_6, t0.type AS type_7, t0.printable_note AS printable_note_8, t0.sync_billing_report AS sync_billing_report_9, t0.external_id AS external_id_10, t0.invoice_id AS invoice_id_11, t0.organization_id AS organization_id_12 FROM credit_note t0 WHERE t0.invoice_id = ?
Parameters:
[
203381
]
|
36 | 1.33 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.confirmation_number AS confirmation_number_5, t0.status AS status_6, t0.paid_out_at AS paid_out_at_7, t0.is_can_retry AS is_can_retry_8, t0.payment_date AS payment_date_9, t0.reference AS reference_10, t0.payment_note AS payment_note_11, t0.invoice_id AS invoice_id_12 FROM payment t0 WHERE t0.invoice_id = ?
Parameters:
[
203381
]
|
37 | 1.22 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
203381
]
|
38 | 1.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
169
]
|
39 | 1.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.status AS status_6, t0.refund_id AS refund_id_7, t0.invoice_id AS invoice_id_8 FROM refund t0 WHERE t0.invoice_id = ?
Parameters:
[
203381
]
|
40 | 1.04 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.type AS type_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
41 | 4.88 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.path AS path_5, t0.number AS number_6, t0.type AS type_7, t0.printable_note AS printable_note_8, t0.sync_billing_report AS sync_billing_report_9, t0.external_id AS external_id_10, t0.invoice_id AS invoice_id_11, t0.organization_id AS organization_id_12 FROM credit_note t0 WHERE t0.invoice_id = ?
Parameters:
[
189096
]
|
42 | 3.24 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.confirmation_number AS confirmation_number_5, t0.status AS status_6, t0.paid_out_at AS paid_out_at_7, t0.is_can_retry AS is_can_retry_8, t0.payment_date AS payment_date_9, t0.reference AS reference_10, t0.payment_note AS payment_note_11, t0.invoice_id AS invoice_id_12 FROM payment t0 WHERE t0.invoice_id = ?
Parameters:
[
189096
]
|
43 | 1.13 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
189096
]
|
44 | 1.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
106
]
|
45 | 2.45 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.status AS status_6, t0.refund_id AS refund_id_7, t0.invoice_id AS invoice_id_8 FROM refund t0 WHERE t0.invoice_id = ?
Parameters:
[
189096
]
|
46 | 2.26 ms |
SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE i0_.organization_id = ?
Parameters:
[
"23797"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Evo\Infrastructure\MappingORM\Product | No errors. |
Evo\Infrastructure\MappingORM\Invoice | No errors. |
Evo\Infrastructure\MappingORM\Subscription | No errors. |
Evo\Infrastructure\MappingORM\SubscriptionModel | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\Store | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |
Evo\Infrastructure\MappingORM\Category | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\UserUTM | No errors. |
Evo\Infrastructure\MappingORM\Lead | No errors. |
Evo\Infrastructure\MappingORM\ActivityLog | No errors. |
Evo\Infrastructure\MappingORM\CommercialGesture | No errors. |
Evo\Infrastructure\MappingORM\ActivityDomain | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\ProfessionDetail | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\PostalAddress | No errors. |
Evo\Infrastructure\MappingORM\DiscountCode | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\ProductHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |
Evo\Infrastructure\MappingORM\Payment | No errors. |
Evo\Infrastructure\MappingORM\LetterForward | No errors. |
Evo\Infrastructure\MappingORM\Refund | No errors. |
Evo\Infrastructure\MappingORM\PotentialCase | No errors. |
Evo\Infrastructure\MappingORM\Accountant | No errors. |
Evo\Infrastructure\MappingORM\OrganizationSector | No errors. |
Evo\Infrastructure\MappingORM\NotificationPreference | No errors. |
Evo\Infrastructure\MappingORM\PrescriberSource | No errors. |
Evo\Infrastructure\MappingORM\ReasonUnpaid | No errors. |
Evo\Infrastructure\MappingORM\ReasonRIBInactive | No errors. |
Evo\Infrastructure\MappingORM\IbmlOrganizationConfiguration | No errors. |
Evo\Infrastructure\MappingORM\ProcessYousign | No errors. |
Evo\Infrastructure\MappingORM\Associate | No errors. |
Evo\Infrastructure\MappingORM\LegalRepresentative | No errors. |
Evo\Infrastructure\MappingORM\Auditor | No errors. |
Evo\Infrastructure\MappingORM\Document | No errors. |
Evo\Infrastructure\MappingORM\Letter | No errors. |
Evo\Infrastructure\MappingORM\Mandatary | No errors. |
Evo\Infrastructure\MappingORM\Order | No errors. |
Evo\Infrastructure\MappingORM\DocumentHistory | No errors. |