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.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.signature AS signature_1,
  t0.logo AS logo_2,
  t0.formation_installateur_doc AS formation_installateur_doc_3,
  t0.pres_marketing_installateur AS pres_marketing_installateur_4,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7,
  t0.cgu AS cgu_8,
  t0.partenariatContract AS partenariatContract_9,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11,
  t0.tel_installateur AS tel_installateur_12,
  t0.tel_support_intern AS tel_support_intern_13,
  t0.fax_beneficiaire AS fax_beneficiaire_14,
  t0.fax_installateur AS fax_installateur_15,
  t0.adresse AS adresse_16,
  t0.adresse_complement AS adresse_complement_17,
  t0.codepostal AS codepostal_18,
  t0.ville AS ville_19,
  t0.email_beneficiaire AS email_beneficiaire_20,
  t0.email_installateur AS email_installateur_21,
  t0.is_consoneo AS is_consoneo_22,
  t0.slug AS slug_23,
  t0.conventionElectronique AS conventionElectronique_24,
  t0.aftElectronique AS aftElectronique_25,
  t0.contratInstallateur AS contratInstallateur_26,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_28,
  t0.`lead` AS lead_29,
  t0.`leadUrl` AS leadUrl_30,
  t0.`leadLogin` AS leadLogin_31,
  t0.`leadPassword` AS leadPassword_32,
  t0.relanceConventionClientUn AS relanceConventionClientUn_33,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_34,
  t0.alertConventionClient AS alertConventionClient_35,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37,
  t0.alertConventionInstallateur AS alertConventionInstallateur_38,
  t0.conventionFin AS conventionFin_39,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42,
  t0.questionnaireAftFin AS questionnaireAftFin_43,
  t0.relanceAftFacture AS relanceAftFacture_44,
  t0.alertAftFacture AS alertAftFacture_45,
  t0.aftFactureFin AS aftFactureFin_46,
  t0.mentionCnil AS mentionCnil_47,
  t0.serviceType AS serviceType_48,
  t0.precariteMode AS precariteMode_49,
  t0.precariteModeProgram AS precariteModeProgram_50,
  t0.blocked AS blocked_51,
  t0.blockedSimulation AS blockedSimulation_52,
  t0.resiliation AS resiliation_53,
  t0.archivageAuto AS archivageAuto_54,
  t0.travauxPostDevis AS travauxPostDevis_55,
  t0.emailFacturationPro AS emailFacturationPro_56,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57,
  t0.hiddenEmail AS hiddenEmail_58,
  t0.visibilityCommercials AS visibilityCommercials_59,
  t0.mandat AS mandat_60,
  t0.pricingMandatClassique AS pricingMandatClassique_61,
  t0.pricingMandatPreca AS pricingMandatPreca_62,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_63,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_64,
  t0.originauxAdresse AS originauxAdresse_65,
  t0.originauxAdresseComplement AS originauxAdresseComplement_66,
  t0.originauxCodepostal AS originauxCodepostal_67,
  t0.originauxVille AS originauxVille_68,
  t0.eligible AS eligible_69,
  t0.satisfactionSurvey AS satisfactionSurvey_70,
  t0.surveyConfiguration AS surveyConfiguration_71,
  t0.autoPayment AS autoPayment_72,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_73,
  t0.aiEnabled AS aiEnabled_74,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_75,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_76,
  t0.emailVersion AS emailVersion_77,
  t0.validateBackwards AS validateBackwards_78,
  t0.displayTelConsoneo AS displayTelConsoneo_79,
  t0.allowedUniverSign AS allowedUniverSign_80,
  t0.allowedApplicationFees AS allowedApplicationFees_81,
  t0.displayApplicationFees AS displayApplicationFees_82,
  t0.programAutoAllowed AS programAutoAllowed_83,
  t0.mpr AS mpr_84,
  t0.isRibActivated AS isRibActivated_85,
  t0.id AS id_86,
  t0.raison AS raison_87,
  t0.siret AS siret_88,
  t0.website AS website_89,
  t0.effectif AS effectif_90,
  t0.status AS status_91,
  t0.created_datetime AS created_datetime_92,
  t0.updated_datetime AS updated_datetime_93,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_94,
  t0.oblige_id AS oblige_id_95,
  t96.id AS id_97,
  t96.raison AS raison_98,
  t96.email AS email_99,
  t96.tel AS tel_100,
  t96.site_web AS site_web_101,
  t96.adresse AS adresse_102,
  t96.cp AS cp_103,
  t96.ville AS ville_104,
  t96.oblige_id AS oblige_id_105,
  t106.id AS id_107,
  t106.gender AS gender_108,
  t106.firstName AS firstName_109,
  t106.name AS name_110,
  t106.raison AS raison_111,
  t106.email AS email_112,
  t106.tel AS tel_113,
  t106.address AS address_114,
  t106.cp AS cp_115,
  t106.city AS city_116,
  t106.adminMandate AS adminMandate_117,
  t106.financialMandate AS financialMandate_118,
  t106.mixteMandate AS mixteMandate_119,
  t106.signature AS signature_120,
  t106.tutorial_admin AS tutorial_admin_121,
  t106.tutorial_mixte AS tutorial_mixte_122,
  t106.tutorial_financial AS tutorial_financial_123,
  t106.oblige_id AS oblige_id_124,
  t125.id AS id_126,
  t125.raison AS raison_127,
  t125.siret AS siret_128,
  t125.oblige_id AS oblige_id_129
FROM
  Oblige t0
  LEFT JOIN Mediateur t96 ON t96.oblige_id = t0.id
  LEFT JOIN MprConfig t106 ON t106.oblige_id = t0.id
  LEFT JOIN Mandataire t125 ON t125.oblige_id = t0.id
WHERE
  t0.id = ?

SELECT t0.signature AS signature_1, t0.logo AS logo_2, t0.formation_installateur_doc AS formation_installateur_doc_3, t0.pres_marketing_installateur AS pres_marketing_installateur_4, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7, t0.cgu AS cgu_8, t0.partenariatContract AS partenariatContract_9, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11, t0.tel_installateur AS tel_installateur_12, t0.tel_support_intern AS tel_support_intern_13, t0.fax_beneficiaire AS fax_beneficiaire_14, t0.fax_installateur AS fax_installateur_15, t0.adresse AS adresse_16, t0.adresse_complement AS adresse_complement_17, t0.codepostal AS codepostal_18, t0.ville AS ville_19, t0.email_beneficiaire AS email_beneficiaire_20, t0.email_installateur AS email_installateur_21, t0.is_consoneo AS is_consoneo_22, t0.slug AS slug_23, t0.conventionElectronique AS conventionElectronique_24, t0.aftElectronique AS aftElectronique_25, t0.contratInstallateur AS contratInstallateur_26, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27, t0.modeByPassSuperviseur AS modeByPassSuperviseur_28, t0.`lead` AS lead_29, t0.`leadUrl` AS leadUrl_30, t0.`leadLogin` AS leadLogin_31, t0.`leadPassword` AS leadPassword_32, t0.relanceConventionClientUn AS relanceConventionClientUn_33, t0.relanceConventionClientDeux AS relanceConventionClientDeux_34, t0.alertConventionClient AS alertConventionClient_35, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37, t0.alertConventionInstallateur AS alertConventionInstallateur_38, t0.conventionFin AS conventionFin_39, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42, t0.questionnaireAftFin AS questionnaireAftFin_43, t0.relanceAftFacture AS relanceAftFacture_44, t0.alertAftFacture AS alertAftFacture_45, t0.aftFactureFin AS aftFactureFin_46, t0.mentionCnil AS mentionCnil_47, t0.serviceType AS serviceType_48, t0.precariteMode AS precariteMode_49, t0.precariteModeProgram AS precariteModeProgram_50, t0.blocked AS blocked_51, t0.blockedSimulation AS blockedSimulation_52, t0.resiliation AS resiliation_53, t0.archivageAuto AS archivageAuto_54, t0.travauxPostDevis AS travauxPostDevis_55, t0.emailFacturationPro AS emailFacturationPro_56, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57, t0.hiddenEmail AS hiddenEmail_58, t0.visibilityCommercials AS visibilityCommercials_59, t0.mandat AS mandat_60, t0.pricingMandatClassique AS pricingMandatClassique_61, t0.pricingMandatPreca AS pricingMandatPreca_62, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_63, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_64, t0.originauxAdresse AS originauxAdresse_65, t0.originauxAdresseComplement AS originauxAdresseComplement_66, t0.originauxCodepostal AS originauxCodepostal_67, t0.originauxVille AS originauxVille_68, t0.eligible AS eligible_69, t0.satisfactionSurvey AS satisfactionSurvey_70, t0.surveyConfiguration AS surveyConfiguration_71, t0.autoPayment AS autoPayment_72, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_73, t0.aiEnabled AS aiEnabled_74, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_75, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_76, t0.emailVersion AS emailVersion_77, t0.validateBackwards AS validateBackwards_78, t0.displayTelConsoneo AS displayTelConsoneo_79, t0.allowedUniverSign AS allowedUniverSign_80, t0.allowedApplicationFees AS allowedApplicationFees_81, t0.displayApplicationFees AS displayApplicationFees_82, t0.programAutoAllowed AS programAutoAllowed_83, t0.mpr AS mpr_84, t0.isRibActivated AS isRibActivated_85, t0.id AS id_86, t0.raison AS raison_87, t0.siret AS siret_88, t0.website AS website_89, t0.effectif AS effectif_90, t0.status AS status_91, t0.created_datetime AS created_datetime_92, t0.updated_datetime AS updated_datetime_93, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_94, t0.oblige_id AS oblige_id_95, t96.id AS id_97, t96.raison AS raison_98, t96.email AS email_99, t96.tel AS tel_100, t96.site_web AS site_web_101, t96.adresse AS adresse_102, t96.cp AS cp_103, t96.ville AS ville_104, t96.oblige_id AS oblige_id_105, t106.id AS id_107, t106.gender AS gender_108, t106.firstName AS firstName_109, t106.name AS name_110, t106.raison AS raison_111, t106.email AS email_112, t106.tel AS tel_113, t106.address AS address_114, t106.cp AS cp_115, t106.city AS city_116, t106.adminMandate AS adminMandate_117, t106.financialMandate AS financialMandate_118, t106.mixteMandate AS mixteMandate_119, t106.signature AS signature_120, t106.tutorial_admin AS tutorial_admin_121, t106.tutorial_mixte AS tutorial_mixte_122, t106.tutorial_financial AS tutorial_financial_123, t106.oblige_id AS oblige_id_124, t125.id AS id_126, t125.raison AS raison_127, t125.siret AS siret_128, t125.oblige_id AS oblige_id_129 FROM Oblige t0 LEFT JOIN Mediateur t96 ON t96.oblige_id = t0.id LEFT JOIN MprConfig t106 ON t106.oblige_id = t0.id LEFT JOIN Mandataire t125 ON t125.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` = 'sirene_api_enabled' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.type AS type_3,
  t0.source AS source_4,
  t0.choice AS choice_5,
  t0.declared_year AS declared_year_6,
  t0.declared_tax_income AS declared_tax_income_7,
  t0.nb_people_declared AS nb_people_declared_8,
  t0.tax_year AS tax_year_9,
  t0.address AS address_10,
  t0.zip_code AS zip_code_11,
  t0.city AS city_12,
  t0.country AS country_13,
  t0.nb_dependents AS nb_dependents_14,
  t0.reference_tax_income AS reference_tax_income_15,
  t0.address_supplement AS address_supplement_16,
  t0.doc_iua AS doc_iua_17,
  t0.createdAt AS createdAt_18,
  t0.updatedAt AS updatedAt_19,
  t0.cas1_id AS cas1_id_20,
  t0.secondAvis_id AS secondAvis_id_21,
  t0.campagneUser_id AS campagneUser_id_22
FROM
  Justificatif t0
WHERE
  t0.token IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.type AS type_3, t0.source AS source_4, t0.choice AS choice_5, t0.declared_year AS declared_year_6, t0.declared_tax_income AS declared_tax_income_7, t0.nb_people_declared AS nb_people_declared_8, t0.tax_year AS tax_year_9, t0.address AS address_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.country AS country_13, t0.nb_dependents AS nb_dependents_14, t0.reference_tax_income AS reference_tax_income_15, t0.address_supplement AS address_supplement_16, t0.doc_iua AS doc_iua_17, t0.createdAt AS createdAt_18, t0.updatedAt AS updatedAt_19, t0.cas1_id AS cas1_id_20, t0.secondAvis_id AS secondAvis_id_21, t0.campagneUser_id AS campagneUser_id_22 FROM Justificatif t0 WHERE t0.token IS NULL LIMIT 1;