Symfony Profiler

Query Metrics

14 Database Queries

8 Different statements

42.94 ms Query time

14 Invalid entities

Queries


SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.locataire_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ?
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.text AS text_2, t0_.params AS params_3, t0_.is_default AS is_default_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t1_.id AS id_7, t1_.name AS name_8, t1_.icon AS icon_9, t1_.service AS service_10, t1_.editor_template AS editor_template_11, t1_.status AS status_12, t0_.template_type_id AS template_type_id_13, t0_.marchand_id AS marchand_id_14, t0_.created_by_id AS created_by_id_15 FROM templates t0_ INNER JOIN template_types t1_ ON t0_.template_type_id = t1_.id INNER JOIN entreprise e2_ ON t0_.marchand_id = e2_.id WHERE e2_.id = ? AND t1_.name = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.status AS status_4 FROM payment_mode t0 WHERE t0.id = ?

#▲	Time	Info
1	11.07 ms	SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.code = ? LIMIT 1 Parameters: [`"Inv-TYR3BHW2VZ"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.code = 'Inv-TYR3BHW2VZ' LIMIT 1;
2	4.07 ms	SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? Parameters: [`1816`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = 1816;
3	5.59 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.id IN (?) Parameters: [`220`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.id IN (220);
4	1.98 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.locataire_id = ? Parameters: [`208`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.locataire_id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.status AS status_3, t0.occuper AS occuper_4, t0.commentaire AS commentaire_5, t0.garanty AS garanty_6, t0.max_garanty AS max_garanty_7, t0.payment_due_date AS payment_due_date_8, t0.price AS price_9, t0.end_location_at AS end_location_at_10, t0.commentaire2 AS commentaire2_11, t0.type AS type_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.location_usage AS location_usage_15, t0.duree AS duree_16, t0.payment_period AS payment_period_17, t0.type_garanty AS type_garanty_18, t0.reconduction AS reconduction_19, t0.garanty_tobepaid AS garanty_tobepaid_20, t0.mode AS mode_21, t0.uuid AS uuid_22, t0.reserver AS reserver_23, t0.location_type AS location_type_24, t0.last_expense_amount AS last_expense_amount_25, t0.occupants AS occupants_26, t0.is_tva_apply AS is_tva_apply_27, t0.tva AS tva_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locataire_id AS locataire_id_31, t32.id AS id_33, t32.name AS name_34, t32.lastname AS lastname_35, t32.firstname AS firstname_36, t32.identification_id AS identification_id_37, t32.status AS status_38, t32.code AS code_39, t32.phone AS phone_40, t32.occuper AS occuper_41, t32.email AS email_42, t32.salutation AS salutation_43, t32.type_identitfication AS type_identitfication_44, t32.note AS note_45, t32.notif AS notif_46, t32.is_login_generate AS is_login_generate_47, t32.picture AS picture_48, t32.created_at AS created_at_49, t32.updated_at AS updated_at_50, t32.createdby_id AS createdby_id_51, t32.marchand_id AS marchand_id_52, t0.habitat_id AS habitat_id_53, t0.created_by_id AS created_by_id_54, t0.marchand_id AS marchand_id_55, t56.id AS id_57, t56.code AS code_58, t56.verification_code AS verification_code_59, t56.status AS status_60, t56.step AS step_61, t56.paid AS paid_62, t56.closed AS closed_63, t56.reference AS reference_64, t56.token AS token_65, t56.sent AS sent_66, t56.depositeur AS depositeur_67, t56.paymentdate AS paymentdate_68, t56.commentaire AS commentaire_69, t56.total_amount AS total_amount_70, t56.single_amount AS single_amount_71, t56.type AS type_72, t56.generatortype AS generatortype_73, t56.cash_in_by AS cash_in_by_74, t56.partial_payment AS partial_payment_75, t56.partial_amount AS partial_amount_76, t56.paid_at AS paid_at_77, t56.monthly_notif AS monthly_notif_78, t56.month AS month_79, t56.year AS year_80, t56.dgi_currency_code AS dgi_currency_code_81, t56.dgi_currency_rate AS dgi_currency_rate_82, t56.dgi_currency_date AS dgi_currency_date_83, t56.dgi_amount_cdf AS dgi_amount_cdf_84, t56.dgi_tax_rate AS dgi_tax_rate_85, t56.dgi_tax_amount AS dgi_tax_amount_86, t56.created_at AS created_at_87, t56.updated_at AS updated_at_88, t56.annee_id AS annee_id_89, t56.paymentmode_id AS paymentmode_id_90, t56.created_by_id AS created_by_id_91, t56.marchand_id AS marchand_id_92, t56.location_id AS location_id_93, t0.residence_id AS residence_id_94 FROM location t0 LEFT JOIN locataire t32 ON t0.locataire_id = t32.id LEFT JOIN payment t56 ON t56.location_id = t0.id WHERE t0.locataire_id = 208;
5	1.63 ms	SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? Parameters: [`1817`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = 1817;
6	1.68 ms	SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? Parameters: [`1817`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = 1817;
7	2.61 ms	SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? Parameters: [`1817`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = 1817;
8	1.42 ms	SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? Parameters: [`1818`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date_of_payment AS date_of_payment_3, t0.status AS status_4, t0.cash_in AS cash_in_5, t0.code AS code_6, t0.notif AS notif_7, t0.currency AS currency_8, t0.month AS month_9, t0.year AS year_10, t0.depositor AS depositor_11, t0.mode AS mode_12, t0.marchand_id AS marchand_id_13, t0.payment_id AS payment_id_14, t15.id AS id_16, t15.code AS code_17, t15.verification_code AS verification_code_18, t15.status AS status_19, t15.step AS step_20, t15.paid AS paid_21, t15.closed AS closed_22, t15.reference AS reference_23, t15.token AS token_24, t15.sent AS sent_25, t15.depositeur AS depositeur_26, t15.paymentdate AS paymentdate_27, t15.commentaire AS commentaire_28, t15.total_amount AS total_amount_29, t15.single_amount AS single_amount_30, t15.type AS type_31, t15.generatortype AS generatortype_32, t15.cash_in_by AS cash_in_by_33, t15.partial_payment AS partial_payment_34, t15.partial_amount AS partial_amount_35, t15.paid_at AS paid_at_36, t15.monthly_notif AS monthly_notif_37, t15.month AS month_38, t15.year AS year_39, t15.dgi_currency_code AS dgi_currency_code_40, t15.dgi_currency_rate AS dgi_currency_rate_41, t15.dgi_currency_date AS dgi_currency_date_42, t15.dgi_amount_cdf AS dgi_amount_cdf_43, t15.dgi_tax_rate AS dgi_tax_rate_44, t15.dgi_tax_amount AS dgi_tax_amount_45, t15.created_at AS created_at_46, t15.updated_at AS updated_at_47, t15.annee_id AS annee_id_48, t15.paymentmode_id AS paymentmode_id_49, t15.created_by_id AS created_by_id_50, t15.marchand_id AS marchand_id_51, t15.location_id AS location_id_52, t0.paymentmode_id AS paymentmode_id_53 FROM pay t0 LEFT JOIN payment t15 ON t0.payment_id = t15.id WHERE t0.payment_id = 1818;
9	1.68 ms	SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? Parameters: [`1818`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = 1818;
10	1.12 ms	SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? Parameters: [`1818`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = 1818;
11	1.67 ms	SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? Parameters: [`1816`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.charge_type AS charge_type_2, t0.charge_scope AS charge_scope_3, t0.amount AS amount_4, t0.description AS description_5, t0.allocation_method AS allocation_method_6, t0.month AS month_7, t0.year AS year_8, t0.code AS code_9, t0.paid AS paid_10, t0.paid_at AS paid_at_11, t0.is_tva_apply AS is_tva_apply_12, t0.total_ht AS total_ht_13, t0.tva AS tva_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.habitat_id AS habitat_id_17, t0.residence_id AS residence_id_18, t0.location_id AS location_id_19, t0.marchand_id AS marchand_id_20, t21.id AS id_22, t21.code AS code_23, t21.name AS name_24, t21.adress AS adress_25, t21.email AS email_26, t21.phone AS phone_27, t21.pseudo AS pseudo_28, t21.description AS description_29, t21.rccm AS rccm_30, t21.icon AS icon_31, t21.status AS status_32, t21.smsservice AS smsservice_33, t21.invoiceservice AS invoiceservice_34, t21.idnat AS idnat_35, t21.numeroimpot AS numeroimpot_36, t21.city AS city_37, t21.province AS province_38, t21.nbrebiensimmobiliers AS nbrebiensimmobiliers_39, t21.free_trail AS free_trail_40, t21.period AS period_41, t21.recallpaymentnotification AS recallpaymentnotification_42, t21.smart_paykey AS smart_paykey_43, t21.make_journal AS make_journal_44, t21.default_fx_rate AS default_fx_rate_45, t21.is_default_fx_rate_apply AS is_default_fx_rate_apply_46, t21.tva AS tva_47, t21.dgi_nif AS dgi_nif_48, t21.dgi_isf AS dgi_isf_49, t21.dgi_token AS dgi_token_50, t21.dgi_env AS dgi_env_51, t21.dgi_default_tax_group AS dgi_default_tax_group_52, t21.dgi_default_item_type AS dgi_default_item_type_53, t21.dgi_service_enabled AS dgi_service_enabled_54, t21.dgi_tax_rate AS dgi_tax_rate_55, t21.created_at AS created_at_56, t21.updated_at AS updated_at_57, t21.admin_id AS admin_id_58, t21.country_id AS country_id_59, t21.package_id AS package_id_60, t21.owner_id AS owner_id_61, t21.currency_id AS currency_id_62, t0.payment_id AS payment_id_63, t64.id AS id_65, t64.code AS code_66, t64.verification_code AS verification_code_67, t64.status AS status_68, t64.step AS step_69, t64.paid AS paid_70, t64.closed AS closed_71, t64.reference AS reference_72, t64.token AS token_73, t64.sent AS sent_74, t64.depositeur AS depositeur_75, t64.paymentdate AS paymentdate_76, t64.commentaire AS commentaire_77, t64.total_amount AS total_amount_78, t64.single_amount AS single_amount_79, t64.type AS type_80, t64.generatortype AS generatortype_81, t64.cash_in_by AS cash_in_by_82, t64.partial_payment AS partial_payment_83, t64.partial_amount AS partial_amount_84, t64.paid_at AS paid_at_85, t64.monthly_notif AS monthly_notif_86, t64.month AS month_87, t64.year AS year_88, t64.dgi_currency_code AS dgi_currency_code_89, t64.dgi_currency_rate AS dgi_currency_rate_90, t64.dgi_currency_date AS dgi_currency_date_91, t64.dgi_amount_cdf AS dgi_amount_cdf_92, t64.dgi_tax_rate AS dgi_tax_rate_93, t64.dgi_tax_amount AS dgi_tax_amount_94, t64.created_at AS created_at_95, t64.updated_at AS updated_at_96, t64.annee_id AS annee_id_97, t64.paymentmode_id AS paymentmode_id_98, t64.created_by_id AS created_by_id_99, t64.marchand_id AS marchand_id_100, t64.location_id AS location_id_101 FROM charge t0 LEFT JOIN entreprise t21 ON t0.marchand_id = t21.id LEFT JOIN payment t64 ON t0.payment_id = t64.id WHERE t0.payment_id = 1816;
12	1.05 ms	SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? Parameters: [`1816`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = ? SELECT t0.id AS id_1, t0.status AS status_2, t0.uid AS uid_3, t0.qr_code AS qr_code_4, t0.code_def_dgi AS code_def_dgi_5, t0.counters AS counters_6, t0.currency_code AS currency_code_7, t0.currency_rate AS currency_rate_8, t0.currency_date AS currency_date_9, t0.amount_cdf AS amount_cdf_10, t0.tax_rate AS tax_rate_11, t0.tax_amount AS tax_amount_12, t0.confirmed_at AS confirmed_at_13, t0.error_code AS error_code_14, t0.error_desc AS error_desc_15, t0.request_payload AS request_payload_16, t0.request_response_payload AS request_response_payload_17, t0.confirm_response_payload AS confirm_response_payload_18, t0.cancel_response_payload AS cancel_response_payload_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.payment_id AS payment_id_22 FROM payment_dgi t0 WHERE t0.payment_id = 1816;
13	4.98 ms	SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.text AS text_2, t0_.params AS params_3, t0_.is_default AS is_default_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t1_.id AS id_7, t1_.name AS name_8, t1_.icon AS icon_9, t1_.service AS service_10, t1_.editor_template AS editor_template_11, t1_.status AS status_12, t0_.template_type_id AS template_type_id_13, t0_.marchand_id AS marchand_id_14, t0_.created_by_id AS created_by_id_15 FROM templates t0_ INNER JOIN template_types t1_ ON t0_.template_type_id = t1_.id INNER JOIN entreprise e2_ ON t0_.marchand_id = e2_.id WHERE e2_.id = ? AND t1_.name = ? Parameters: [`59 "TEMPLATE_INVOICE_PDF"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.text AS text_2, t0_.params AS params_3, t0_.is_default AS is_default_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t1_.id AS id_7, t1_.name AS name_8, t1_.icon AS icon_9, t1_.service AS service_10, t1_.editor_template AS editor_template_11, t1_.status AS status_12, t0_.template_type_id AS template_type_id_13, t0_.marchand_id AS marchand_id_14, t0_.created_by_id AS created_by_id_15 FROM templates t0_ INNER JOIN template_types t1_ ON t0_.template_type_id = t1_.id INNER JOIN entreprise e2_ ON t0_.marchand_id = e2_.id WHERE e2_.id = ? AND t1_.name = ? SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.text AS text_2, t0_.params AS params_3, t0_.is_default AS is_default_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t1_.id AS id_7, t1_.name AS name_8, t1_.icon AS icon_9, t1_.service AS service_10, t1_.editor_template AS editor_template_11, t1_.status AS status_12, t0_.template_type_id AS template_type_id_13, t0_.marchand_id AS marchand_id_14, t0_.created_by_id AS created_by_id_15 FROM templates t0_ INNER JOIN template_types t1_ ON t0_.template_type_id = t1_.id INNER JOIN entreprise e2_ ON t0_.marchand_id = e2_.id WHERE e2_.id = 59 AND t1_.name = 'TEMPLATE_INVOICE_PDF';
14	2.40 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.status AS status_4 FROM payment_mode t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.status AS status_4 FROM payment_mode t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.status AS status_4 FROM payment_mode t0 WHERE t0.id = 1;

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
App\Entity\Charge	No errors.
App\Entity\Habitat	The association App\Entity\Habitat#createdBy refers to the inverse side field App\Entity\User#habitats which does not exist. The association App\Entity\Habitat#marchand refers to the inverse side field App\Entity\Entreprise#habitats which does not exist.
App\Entity\Residence	The association App\Entity\Residence#createdBy refers to the inverse side field App\Entity\User#residences which does not exist. The association App\Entity\Residence#marchand refers to the inverse side field App\Entity\Entreprise#residences which does not exist.
App\Entity\Location	The association App\Entity\Location#marchand refers to the inverse side field App\Entity\Entreprise#locations which does not exist.
App\Entity\Entreprise	The association App\Entity\Entreprise#admin refers to the inverse side field App\Entity\Admin#entreprises which does not exist. The mappings App\Entity\Entreprise#subscriptions and App\Entity\Subscription#entreprise are inconsistent with each other.
App\Entity\Admin	The association App\Entity\Admin#role refers to the inverse side field App\Entity\Roles#admins which does not exist.
App\Entity\Country	No errors.
App\Entity\Package	No errors.
App\Entity\User	No errors.
App\Entity\Currency	No errors.
App\Entity\Payment	The association App\Entity\Payment#createdBy refers to the inverse side field App\Entity\User#payments which does not exist. The association App\Entity\Payment#marchand refers to the inverse side field App\Entity\Entreprise#payments which does not exist.
App\Entity\Annee	The association App\Entity\Annee#marchand refers to the inverse side field App\Entity\Entreprise#annees which does not exist.
App\Entity\PaymentMode	No errors.
App\Entity\ChargeAllocation	No errors.
App\Entity\Role	No errors.
App\Entity\CategoryResidence	The association App\Entity\CategoryResidence#createdBy refers to the inverse side field App\Entity\User#categoryResidences which does not exist.
App\Entity\ResidenceImmeuble	No errors.
App\Entity\PaymentGenerator	No errors.
App\Entity\Prestataire	No errors.
App\Entity\Incident	No errors.
App\Entity\Template	No errors.
App\Entity\PaymentGaranty	The association App\Entity\PaymentGaranty#modePayment refers to the inverse side field App\Entity\PaymentMode#paymentGaranties which does not exist. The association App\Entity\PaymentGaranty#createdBy refers to the inverse side field App\Entity\User#paymentGaranties which does not exist.
App\Entity\IncidentUpdate	No errors.
App\Entity\Service	No errors.
App\Entity\Subscription	The association App\Entity\Subscription#entreprise refers to the inverse side field App\Entity\Entreprise#entreprisePackages which does not exist.
App\Entity\Announcement	No errors.
App\Entity\CashJournal	No errors.
App\Entity\CashJournalEntry	No errors.
App\Entity\Log	No errors.
App\Entity\Reservation	The association App\Entity\Reservation#habitat refers to the inverse side field App\Entity\Habitat#reservations which does not exist.
App\Entity\UserEntreprise	No errors.
App\Entity\Mois	No errors.
App\Entity\Pay	The association App\Entity\Pay#marchand refers to the inverse side field App\Entity\Entreprise#pays which does not exist.
App\Entity\Locataire	The association App\Entity\Locataire#createdby refers to the inverse side field App\Entity\User#locataire which does not exist. The association App\Entity\Locataire#marchand refers to the inverse side field App\Entity\Entreprise#locataires which does not exist.
App\Entity\ContractBail	The association App\Entity\ContractBail#marchand refers to the inverse side field App\Entity\Entreprise#contractBails which does not exist.
App\Entity\PaymentDgi	No errors.
App\Entity\Societe	No errors.
App\Entity\LocataireUser	No errors.
App\Entity\NotificationView	No errors.
App\Entity\TemplateType	No errors.

Symfony Profiler

GET https://beta-downloader.smartimmo-app.com/invoice/pdf/Inv-TYR3BHW2VZ

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping