Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.appKey AS appKey_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.report_auto_email AS report_auto_email_8,
  t0.logo AS logo_9,
  t0.smartName AS smartName_10,
  t0.prefixEmail AS prefixEmail_11,
  t0.`lead` AS lead_12,
  t0.`leadUrl` AS leadUrl_13,
  t0.`leadLogin` AS leadLogin_14,
  t0.`leadPassword` AS leadPassword_15,
  t0.recommanderProDefault AS recommanderProDefault_16,
  t0.actif AS actif_17,
  t0.allowMultiSubscription AS allowMultiSubscription_18,
  t0.teteReseau_id AS teteReseau_id_19,
  t0.branding AS branding_20
FROM
  IntegrationModule t0
WHERE
  t0.appKey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = 'm71k' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.username AS username_12,
  t0.nom AS nom_13,
  t0.prenom AS prenom_14,
  t0.fonction AS fonction_15,
  t0.tel AS tel_16,
  t0.mobile AS mobile_17,
  t0.activation AS activation_18,
  t0.createdAt AS createdAt_19,
  t0.updatedAt AS updatedAt_20,
  t0.optin AS optin_21,
  t0.dateActivation AS dateActivation_22,
  t0.emailValidatedDateTime AS emailValidatedDateTime_23,
  t0.emailCreatedDateTime AS emailCreatedDateTime_24,
  t0.mobileCreatedDatetime AS mobileCreatedDatetime_25,
  t0.sendEmail AS sendEmail_26,
  t0.reference AS reference_27,
  t0.currentSubscriptionStep AS currentSubscriptionStep_28,
  t0.dateRetourContratPartenariat AS dateRetourContratPartenariat_29,
  t0.token AS token_30,
  t0.dateActivationStep2 AS dateActivationStep2_31,
  t0.dateActivationStep4 AS dateActivationStep4_32,
  t0.dateActivationStep5 AS dateActivationStep5_33,
  t0.dateRefused AS dateRefused_34,
  t0.emailRequested AS emailRequested_35,
  t0.emailRequestedDate AS emailRequestedDate_36,
  t0.attributes AS attributes_37,
  t0.lastOffreDate AS lastOffreDate_38,
  t0.quicklyTraited AS quicklyTraited_39,
  t0.proType AS proType_40,
  t0.system_facturation AS system_facturation_41,
  t0.signataireAh AS signataireAh_42,
  t0.inscription_step AS inscription_step_43,
  t0.import_status AS import_status_44,
  t0.token_thermor AS token_thermor_45,
  t0.exclusiveEnabled AS exclusiveEnabled_46,
  t0.relanceSmsRegistration AS relanceSmsRegistration_47,
  t0.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_48,
  t0.company_id AS company_id_49,
  t0.workflow_id AS workflow_id_50,
  t0.obligeTarget_id AS obligeTarget_id_51,
  t0.identite_id AS identite_id_52,
  t0.integrationModule_id AS integrationModule_id_53
FROM
  InstallateurUser t0
WHERE
  t0.token IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.username AS username_12, t0.nom AS nom_13, t0.prenom AS prenom_14, t0.fonction AS fonction_15, t0.tel AS tel_16, t0.mobile AS mobile_17, t0.activation AS activation_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.optin AS optin_21, t0.dateActivation AS dateActivation_22, t0.emailValidatedDateTime AS emailValidatedDateTime_23, t0.emailCreatedDateTime AS emailCreatedDateTime_24, t0.mobileCreatedDatetime AS mobileCreatedDatetime_25, t0.sendEmail AS sendEmail_26, t0.reference AS reference_27, t0.currentSubscriptionStep AS currentSubscriptionStep_28, t0.dateRetourContratPartenariat AS dateRetourContratPartenariat_29, t0.token AS token_30, t0.dateActivationStep2 AS dateActivationStep2_31, t0.dateActivationStep4 AS dateActivationStep4_32, t0.dateActivationStep5 AS dateActivationStep5_33, t0.dateRefused AS dateRefused_34, t0.emailRequested AS emailRequested_35, t0.emailRequestedDate AS emailRequestedDate_36, t0.attributes AS attributes_37, t0.lastOffreDate AS lastOffreDate_38, t0.quicklyTraited AS quicklyTraited_39, t0.proType AS proType_40, t0.system_facturation AS system_facturation_41, t0.signataireAh AS signataireAh_42, t0.inscription_step AS inscription_step_43, t0.import_status AS import_status_44, t0.token_thermor AS token_thermor_45, t0.exclusiveEnabled AS exclusiveEnabled_46, t0.relanceSmsRegistration AS relanceSmsRegistration_47, t0.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_48, t0.company_id AS company_id_49, t0.workflow_id AS workflow_id_50, t0.obligeTarget_id AS obligeTarget_id_51, t0.identite_id AS identite_id_52, t0.integrationModule_id AS integrationModule_id_53 FROM InstallateurUser t0 WHERE t0.token IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.createdAt AS createdAt_3,
  t0.slug AS slug_4,
  t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5,
  t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6,
  t0.allow_curseur AS allow_curseur_7,
  t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8,
  t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9,
  t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10,
  t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11,
  t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12,
  t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13,
  t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14,
  t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15,
  t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16,
  t0.logo AS logo_17,
  t0.modePrime AS modePrime_18,
  t0.incitation AS incitation_19,
  t0.`lead` AS lead_20,
  t0.actif AS actif_21,
  t0.partenariatContract AS partenariatContract_22,
  t0.allowElectronicSign AS allowElectronicSign_23,
  t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24,
  t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25,
  t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26,
  t0.oblige_id AS oblige_id_27,
  t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28,
  t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29
FROM
  TeteReseau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.createdAt AS createdAt_3, t0.slug AS slug_4, t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5, t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6, t0.allow_curseur AS allow_curseur_7, t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8, t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9, t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10, t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11, t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12, t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13, t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14, t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15, t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16, t0.logo AS logo_17, t0.modePrime AS modePrime_18, t0.incitation AS incitation_19, t0.`lead` AS lead_20, t0.actif AS actif_21, t0.partenariatContract AS partenariatContract_22, t0.allowElectronicSign AS allowElectronicSign_23, t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24, t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25, t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26, t0.oblige_id AS oblige_id_27, t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28, t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29 FROM TeteReseau t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.raison AS raison_2,
  t0.siret AS siret_3,
  t0.adresse AS adresse_4,
  t0.adresse_complement AS adresse_complement_5,
  t0.codepostal AS codepostal_6,
  t0.ville AS ville_7,
  t0.website AS website_8,
  t0.effectif AS effectif_9,
  t0.status AS status_10,
  t0.created_datetime AS created_datetime_11,
  t0.updated_datetime AS updated_datetime_12,
  t0.signature AS signature_13,
  t0.logo AS logo_14,
  t0.formation_installateur_doc AS formation_installateur_doc_15,
  t0.pres_marketing_installateur AS pres_marketing_installateur_16,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19,
  t0.cgu AS cgu_20,
  t0.partenariatContract AS partenariatContract_21,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23,
  t0.tel_installateur AS tel_installateur_24,
  t0.tel_support_intern AS tel_support_intern_25,
  t0.fax_beneficiaire AS fax_beneficiaire_26,
  t0.fax_installateur AS fax_installateur_27,
  t0.email_beneficiaire AS email_beneficiaire_28,
  t0.email_installateur AS email_installateur_29,
  t0.is_consoneo AS is_consoneo_30,
  t0.slug AS slug_31,
  t0.conventionElectronique AS conventionElectronique_32,
  t0.aftElectronique AS aftElectronique_33,
  t0.contratInstallateur AS contratInstallateur_34,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_36,
  t0.`lead` AS lead_37,
  t0.`leadUrl` AS leadUrl_38,
  t0.`leadLogin` AS leadLogin_39,
  t0.`leadPassword` AS leadPassword_40,
  t0.relanceConventionClientUn AS relanceConventionClientUn_41,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_42,
  t0.alertConventionClient AS alertConventionClient_43,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45,
  t0.alertConventionInstallateur AS alertConventionInstallateur_46,
  t0.conventionFin AS conventionFin_47,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50,
  t0.questionnaireAftFin AS questionnaireAftFin_51,
  t0.relanceAftFacture AS relanceAftFacture_52,
  t0.alertAftFacture AS alertAftFacture_53,
  t0.aftFactureFin AS aftFactureFin_54,
  t0.mentionCnil AS mentionCnil_55,
  t0.serviceType AS serviceType_56,
  t0.precariteMode AS precariteMode_57,
  t0.precariteModeProgram AS precariteModeProgram_58,
  t0.blocked AS blocked_59,
  t0.blockedSimulation AS blockedSimulation_60,
  t0.resiliation AS resiliation_61,
  t0.archivageAuto AS archivageAuto_62,
  t0.travauxPostDevis AS travauxPostDevis_63,
  t0.emailFacturationPro AS emailFacturationPro_64,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65,
  t0.hiddenEmail AS hiddenEmail_66,
  t0.certificallCompanyId AS certificallCompanyId_67,
  t0.visibilityCommercials AS visibilityCommercials_68,
  t0.mandat AS mandat_69,
  t0.pricingMandatClassique AS pricingMandatClassique_70,
  t0.pricingMandatPreca AS pricingMandatPreca_71,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73,
  t0.originauxAdresse AS originauxAdresse_74,
  t0.originauxAdresseComplement AS originauxAdresseComplement_75,
  t0.originauxCodepostal AS originauxCodepostal_76,
  t0.originauxVille AS originauxVille_77,
  t0.eligible AS eligible_78,
  t0.satisfactionSurvey AS satisfactionSurvey_79,
  t0.surveyConfiguration AS surveyConfiguration_80,
  t0.autoPayment AS autoPayment_81,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82,
  t0.aiEnabled AS aiEnabled_83,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85,
  t0.emailVersion AS emailVersion_86,
  t0.validateBackwards AS validateBackwards_87,
  t0.displayTelConsoneo AS displayTelConsoneo_88,
  t0.allowedUniverSign AS allowedUniverSign_89,
  t0.allowedApplicationFees AS allowedApplicationFees_90,
  t0.displayApplicationFees AS displayApplicationFees_91,
  t0.programAutoAllowed AS programAutoAllowed_92,
  t0.mpr AS mpr_93,
  t0.isRibActivated AS isRibActivated_94,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95,
  t0.oblige_id AS oblige_id_96,
  t97.id AS id_98,
  t97.raison AS raison_99,
  t97.email AS email_100,
  t97.tel AS tel_101,
  t97.site_web AS site_web_102,
  t97.adresse AS adresse_103,
  t97.cp AS cp_104,
  t97.ville AS ville_105,
  t97.oblige_id AS oblige_id_106,
  t107.id AS id_108,
  t107.gender AS gender_109,
  t107.firstName AS firstName_110,
  t107.name AS name_111,
  t107.raison AS raison_112,
  t107.email AS email_113,
  t107.tel AS tel_114,
  t107.address AS address_115,
  t107.cp AS cp_116,
  t107.city AS city_117,
  t107.adminMandate AS adminMandate_118,
  t107.financialMandate AS financialMandate_119,
  t107.mixteMandate AS mixteMandate_120,
  t107.signature AS signature_121,
  t107.tutorial_admin AS tutorial_admin_122,
  t107.tutorial_mixte AS tutorial_mixte_123,
  t107.tutorial_financial AS tutorial_financial_124,
  t107.oblige_id AS oblige_id_125,
  t126.id AS id_127,
  t126.raison AS raison_128,
  t126.siret AS siret_129,
  t126.oblige_id AS oblige_id_130
FROM
  Oblige t0
  LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id
  LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id
  LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
  AND t0.object_class = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'allow_financial_mpr' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
  AND t0.object_class = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'sirene_api_enabled' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.appKey AS appKey_1,
  i0_.label AS label_2,
  i0_.description AS description_3,
  i0_.url AS url_4,
  i0_.status AS status_5,
  i0_.created_at AS created_at_6,
  i0_.report_auto_email AS report_auto_email_7,
  i0_.logo AS logo_8,
  i0_.smartName AS smartName_9,
  i0_.prefixEmail AS prefixEmail_10,
  i0_.`lead` AS lead_11,
  i0_.`leadUrl` AS leadUrl_12,
  i0_.`leadLogin` AS leadLogin_13,
  i0_.`leadPassword` AS leadPassword_14,
  i0_.recommanderProDefault AS recommanderProDefault_15,
  i0_.actif AS actif_16,
  i0_.allowMultiSubscription AS allowMultiSubscription_17,
  i0_.teteReseau_id AS teteReseau_id_18,
  i0_.branding AS branding_19
FROM
  IntegrationModule i0_
WHERE
  i0_.branding = ?
  AND i0_.teteReseau_id = ?
  AND i0_.actif = ?
LIMIT
  1

SELECT i0_.id AS id_0, i0_.appKey AS appKey_1, i0_.label AS label_2, i0_.description AS description_3, i0_.url AS url_4, i0_.status AS status_5, i0_.created_at AS created_at_6, i0_.report_auto_email AS report_auto_email_7, i0_.logo AS logo_8, i0_.smartName AS smartName_9, i0_.prefixEmail AS prefixEmail_10, i0_.`lead` AS lead_11, i0_.`leadUrl` AS leadUrl_12, i0_.`leadLogin` AS leadLogin_13, i0_.`leadPassword` AS leadPassword_14, i0_.recommanderProDefault AS recommanderProDefault_15, i0_.actif AS actif_16, i0_.allowMultiSubscription AS allowMultiSubscription_17, i0_.teteReseau_id AS teteReseau_id_18, i0_.branding AS branding_19 FROM IntegrationModule i0_ WHERE i0_.branding = 'i' AND i0_.teteReseau_id = 2 AND i0_.actif = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.appKey AS appKey_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.report_auto_email AS report_auto_email_8,
  t0.logo AS logo_9,
  t0.smartName AS smartName_10,
  t0.prefixEmail AS prefixEmail_11,
  t0.`lead` AS lead_12,
  t0.`leadUrl` AS leadUrl_13,
  t0.`leadLogin` AS leadLogin_14,
  t0.`leadPassword` AS leadPassword_15,
  t0.recommanderProDefault AS recommanderProDefault_16,
  t0.actif AS actif_17,
  t0.allowMultiSubscription AS allowMultiSubscription_18,
  t0.teteReseau_id AS teteReseau_id_19,
  t0.branding AS branding_20
FROM
  IntegrationModule t0
WHERE
  t0.appKey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = 'm71k' LIMIT 1;

SELECT
  t0.branding AS branding_1,
  t0.title AS title_2
FROM
  Branding t0
WHERE
  t0.branding = ?
LIMIT
  1

SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = 'i' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.appKey AS appKey_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.report_auto_email AS report_auto_email_8,
  t0.logo AS logo_9,
  t0.smartName AS smartName_10,
  t0.prefixEmail AS prefixEmail_11,
  t0.`lead` AS lead_12,
  t0.`leadUrl` AS leadUrl_13,
  t0.`leadLogin` AS leadLogin_14,
  t0.`leadPassword` AS leadPassword_15,
  t0.recommanderProDefault AS recommanderProDefault_16,
  t0.actif AS actif_17,
  t0.allowMultiSubscription AS allowMultiSubscription_18,
  t0.teteReseau_id AS teteReseau_id_19,
  t0.branding AS branding_20
FROM
  IntegrationModule t0
WHERE
  t0.appKey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = 'm71k' LIMIT 1;