Query Metrics
54
Database Queries
10
Different statements
101.80 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 28.16 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 | 1.39 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.discount_amount AS discount_amount_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.is_active AS is_active_6, d0_.type AS type_7, d0_.usage_count AS usage_count_8, d0_.promo_code AS promo_code_9, d0_.discount_type AS discount_type_10, d0_.prepaid_months AS prepaid_months_11, d0_.for_frequency AS for_frequency_12, d0_.promo_code_history_id AS promo_code_history_id_13 FROM discount_code d0_ ORDER BY d0_.id ASC LIMIT 30
Parameters:
[] |
3 | 1.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
1
]
|
4 | 1.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
1
]
|
5 | 1.47 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.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.discount_code_id = ?
Parameters:
[
1
]
|
6 | 0.95 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
1
]
|
7 | 1.06 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
1
]
|
8 | 1.30 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
2
]
|
9 | 1.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
2
]
|
10 | 2.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
2
]
|
11 | 2.14 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alternate_name AS alternate_name_2, p0_.price_without_tax AS price_without_tax_3, p0_.description AS description_4, p0_.active AS active_5, p0_.meta_description AS meta_description_6, p0_.meta_title AS meta_title_7, p0_.url AS url_8, p0_.created_at AS created_at_9, p0_.subscription_type AS subscription_type_10, p0_.unique_key AS unique_key_11, p0_.is_displayed AS is_displayed_12, p0_.is_archived AS is_archived_13, p0_.is_subscription_component AS is_subscription_component_14, p0_.category_id AS category_id_15, p0_.category_for_billing_report_id AS category_for_billing_report_id_16 FROM product p0_ WHERE p0_.name LIKE ? AND p0_.active = 0
Parameters:
[
"%75008%"
]
|
12 | 2.32 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.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.discount_code_id = ?
Parameters:
[
2
]
|
13 | 2.24 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
2
]
|
14 | 1.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
2
]
|
15 | 1.13 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
3
]
|
16 | 4.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
3
]
|
17 | 1.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
3
]
|
18 | 3.55 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.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.discount_code_id = ?
Parameters:
[
3
]
|
19 | 1.02 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
3
]
|
20 | 0.94 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
3
]
|
21 | 0.92 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
4
]
|
22 | 0.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
4
]
|
23 | 0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
4
]
|
24 | 1.44 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.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.discount_code_id = ?
Parameters:
[
4
]
|
25 | 0.83 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
4
]
|
26 | 1.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
4
]
|
27 | 0.93 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
5
]
|
28 | 0.91 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
5
]
|
29 | 1.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
5
]
|
30 | 1.64 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.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.discount_code_id = ?
Parameters:
[
5
]
|
31 | 0.86 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
5
]
|
32 | 0.93 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
5
]
|
33 | 0.90 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
6
]
|
34 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
6
]
|
35 | 0.90 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
6
]
|
36 | 1.65 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alternate_name AS alternate_name_2, p0_.price_without_tax AS price_without_tax_3, p0_.description AS description_4, p0_.active AS active_5, p0_.meta_description AS meta_description_6, p0_.meta_title AS meta_title_7, p0_.url AS url_8, p0_.created_at AS created_at_9, p0_.subscription_type AS subscription_type_10, p0_.unique_key AS unique_key_11, p0_.is_displayed AS is_displayed_12, p0_.is_archived AS is_archived_13, p0_.is_subscription_component AS is_subscription_component_14, p0_.category_id AS category_id_15, p0_.category_for_billing_report_id AS category_for_billing_report_id_16 FROM product p0_ WHERE p0_.name LIKE ? AND p0_.active = 0
Parameters:
[
"%75008%"
]
|
37 | 1.57 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.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.discount_code_id = ?
Parameters:
[
6
]
|
38 | 0.91 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
6
]
|
39 | 0.92 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
6
]
|
40 | 0.94 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
7
]
|
41 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
7
]
|
42 | 0.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
7
]
|
43 | 1.73 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.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.discount_code_id = ?
Parameters:
[
7
]
|
44 | 1.14 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
7
]
|
45 | 0.84 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
7
]
|
46 | 1.02 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
8
]
|
47 | 1.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_key AS unique_key_3, t0.security_deposit AS security_deposit_4, t0.is_active AS is_active_5, t0.authorized_frequency AS authorized_frequency_6, t0.created_at AS created_at_7, t0.update_at AS update_at_8, t0.price_without_tax AS price_without_tax_9, t0.product_id AS product_id_10 FROM subscription_model t0 INNER JOIN discount_code_subscription_model ON t0.id = discount_code_subscription_model.subscription_model_id WHERE discount_code_subscription_model.discount_code_id = ?
Parameters:
[
8
]
|
48 | 0.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN discount_code_store ON t0.id = discount_code_store.store_id WHERE discount_code_store.discount_code_id = ?
Parameters:
[
8
]
|
49 | 2.65 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.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.discount_code_id = ?
Parameters:
[
8
]
|
50 | 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 INNER JOIN discount_code_product ON t0.id = discount_code_product.product_id WHERE discount_code_product.discount_code_id = ?
Parameters:
[
8
]
|
51 | 1.03 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.amount AS amount_4, t0.discount_code_id AS discount_code_id_5 FROM discount_configuration t0 WHERE t0.discount_code_id = ?
Parameters:
[
8
]
|
52 | 1.13 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
13
]
|
53 | 1.70 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 INNER JOIN discount_configuration_product ON t0.id = discount_configuration_product.product_id WHERE discount_configuration_product.discount_configuration_id = ?
Parameters:
[
14
]
|
54 | 2.60 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM discount_code d0_
Parameters:
[] |
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\DiscountCode | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\Store | 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\Sector | No errors. |
Evo\Infrastructure\MappingORM\BAL | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |
Evo\Infrastructure\MappingORM\Category | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\Payment | No errors. |
Evo\Infrastructure\MappingORM\PotentialCase | No errors. |
Evo\Infrastructure\MappingORM\Document | No errors. |
Evo\Infrastructure\MappingORM\DocumentRejectionMessage | No errors. |
Evo\Infrastructure\MappingORM\Person | No errors. |
Evo\Infrastructure\MappingORM\LegalRepresentative | No errors. |
Evo\Infrastructure\MappingORM\Associate | No errors. |
Evo\Infrastructure\MappingORM\ProcessYousign | No errors. |
Evo\Infrastructure\MappingORM\Signature | No errors. |
Evo\Infrastructure\MappingORM\LetterForward | No errors. |
Evo\Infrastructure\MappingORM\Letter | No errors. |
Evo\Infrastructure\MappingORM\LetterSignature | No errors. |
Evo\Infrastructure\MappingORM\LetterTag | No errors. |
Evo\Infrastructure\MappingORM\Refund | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |
Evo\Infrastructure\MappingORM\PromoCodeHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |
Evo\Infrastructure\MappingORM\ProductHistory | No errors. |