Symfony Profiler

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.alias AS alias_32,
  t0.conventionElectronique AS conventionElectronique_33,
  t0.aftElectronique AS aftElectronique_34,
  t0.contratInstallateur AS contratInstallateur_35,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_37,
  t0.`lead` AS lead_38,
  t0.`leadUrl` AS leadUrl_39,
  t0.`leadLogin` AS leadLogin_40,
  t0.`leadPassword` AS leadPassword_41,
  t0.relanceConventionClientUn AS relanceConventionClientUn_42,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_43,
  t0.alertConventionClient AS alertConventionClient_44,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46,
  t0.alertConventionInstallateur AS alertConventionInstallateur_47,
  t0.conventionFin AS conventionFin_48,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51,
  t0.questionnaireAftFin AS questionnaireAftFin_52,
  t0.relanceAftFacture AS relanceAftFacture_53,
  t0.alertAftFacture AS alertAftFacture_54,
  t0.aftFactureFin AS aftFactureFin_55,
  t0.mentionCnil AS mentionCnil_56,
  t0.serviceType AS serviceType_57,
  t0.precariteMode AS precariteMode_58,
  t0.precariteModeProgram AS precariteModeProgram_59,
  t0.blocked AS blocked_60,
  t0.blockedSimulation AS blockedSimulation_61,
  t0.resiliation AS resiliation_62,
  t0.archivageAuto AS archivageAuto_63,
  t0.travauxPostDevis AS travauxPostDevis_64,
  t0.emailFacturationPro AS emailFacturationPro_65,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66,
  t0.hiddenEmail AS hiddenEmail_67,
  t0.certificallCompanyId AS certificallCompanyId_68,
  t0.visibilityCommercials AS visibilityCommercials_69,
  t0.mandat AS mandat_70,
  t0.pricingMandatClassique AS pricingMandatClassique_71,
  t0.pricingMandatPreca AS pricingMandatPreca_72,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74,
  t0.originauxAdresse AS originauxAdresse_75,
  t0.originauxAdresseComplement AS originauxAdresseComplement_76,
  t0.originauxCodepostal AS originauxCodepostal_77,
  t0.originauxVille AS originauxVille_78,
  t0.eligible AS eligible_79,
  t0.satisfactionSurvey AS satisfactionSurvey_80,
  t0.surveyConfiguration AS surveyConfiguration_81,
  t0.autoPayment AS autoPayment_82,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83,
  t0.aiEnabled AS aiEnabled_84,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86,
  t0.emailVersion AS emailVersion_87,
  t0.validateBackwards AS validateBackwards_88,
  t0.displayTelConsoneo AS displayTelConsoneo_89,
  t0.allowedUniverSign AS allowedUniverSign_90,
  t0.allowedApplicationFees AS allowedApplicationFees_91,
  t0.displayApplicationFees AS displayApplicationFees_92,
  t0.programAutoAllowed AS programAutoAllowed_93,
  t0.mpr AS mpr_94,
  t0.isRibActivated AS isRibActivated_95,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96,
  t0.oblige_id AS oblige_id_97,
  t98.id AS id_99,
  t98.raison AS raison_100,
  t98.email AS email_101,
  t98.tel AS tel_102,
  t98.site_web AS site_web_103,
  t98.adresse AS adresse_104,
  t98.cp AS cp_105,
  t98.ville AS ville_106,
  t98.oblige_id AS oblige_id_107,
  t108.id AS id_109,
  t108.gender AS gender_110,
  t108.firstName AS firstName_111,
  t108.name AS name_112,
  t108.raison AS raison_113,
  t108.email AS email_114,
  t108.tel AS tel_115,
  t108.address AS address_116,
  t108.cp AS cp_117,
  t108.city AS city_118,
  t108.adminMandate AS adminMandate_119,
  t108.financialMandate AS financialMandate_120,
  t108.mixteMandate AS mixteMandate_121,
  t108.signature AS signature_122,
  t108.tutorial_admin AS tutorial_admin_123,
  t108.tutorial_mixte AS tutorial_mixte_124,
  t108.tutorial_financial AS tutorial_financial_125,
  t108.oblige_id AS oblige_id_126,
  t127.id AS id_128,
  t127.raison AS raison_129,
  t127.siret AS siret_130,
  t127.oblige_id AS oblige_id_131
FROM
  Oblige t0
  LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id
  LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id
  LEFT JOIN Mandataire t127 ON t127.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.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = 2;

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.main_declarant_id AS main_declarant_id_21,
  t0.secondAvis_id AS secondAvis_id_22,
  t0.campagneUser_id AS campagneUser_id_23
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.main_declarant_id AS main_declarant_id_21, t0.secondAvis_id AS secondAvis_id_22, t0.campagneUser_id AS campagneUser_id_23 FROM Justificatif t0 WHERE t0.token IS NULL 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
  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 = '1234' 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.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 = 'p' LIMIT 1;