Symfony Profiler

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  InstallateurUser i0_
  INNER JOIN Installateur i1_ ON i0_.company_id = i1_.id
  INNER JOIN IntegrationModule i2_ ON i0_.integrationModule_id = i2_.id
  INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id
  INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id
  LEFT JOIN QualificationRecord q5_ ON i1_.id = q5_.installateur_id
  LEFT JOIN Qualification q6_ ON q5_.qualification_id = q6_.id
  LEFT JOIN AffectationUser a7_ ON i0_.id = a7_.installateurUser_id
  LEFT JOIN ObligeUser o8_ ON a7_.obligeUser_id = o8_.id
  LEFT JOIN ObligeRole o9_ ON a7_.obligeRole_id = o9_.id
  LEFT JOIN InstallateurUser i10_ ON i1_.id = i10_.company_id
  LEFT JOIN OffreProjet o11_ ON i10_.id = o11_.installateurUser_id
WHERE
  t3_.oblige_id = ?
  AND o9_.role = ?
  AND i0_.activation IN ('fully', 'siret_join')
  AND t3_.id IN (?, ?, ?)
GROUP BY
  i0_.id

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM InstallateurUser i0_ INNER JOIN Installateur i1_ ON i0_.company_id = i1_.id INNER JOIN IntegrationModule i2_ ON i0_.integrationModule_id = i2_.id INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id LEFT JOIN QualificationRecord q5_ ON i1_.id = q5_.installateur_id LEFT JOIN Qualification q6_ ON q5_.qualification_id = q6_.id LEFT JOIN AffectationUser a7_ ON i0_.id = a7_.installateurUser_id LEFT JOIN ObligeUser o8_ ON a7_.obligeUser_id = o8_.id LEFT JOIN ObligeRole o9_ ON a7_.obligeRole_id = o9_.id LEFT JOIN InstallateurUser i10_ ON i1_.id = i10_.company_id LEFT JOIN OffreProjet o11_ ON i10_.id = o11_.installateurUser_id WHERE t3_.oblige_id = 6 AND o9_.role = 'ROLE_COMMERCIAL_PRO' AND i0_.activation IN ('fully', 'siret_join') AND t3_.id IN (28, 1509, 1510) GROUP BY i0_.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.chantiersParMois AS chantiersParMois_13,
  t0.data AS data_14,
  t0.programmeValorisation AS programmeValorisation_15,
  t0.apartientProgrammeValorisation AS apartientProgrammeValorisation_16,
  t0.cgu AS cgu_17,
  t0.oldContract AS oldContract_18,
  t0.lastLogin AS lastLogin_19,
  t0.lastDemande AS lastDemande_20,
  t0.qualificationsRequested AS qualificationsRequested_21,
  t0.qualificationRequestDate AS qualificationRequestDate_22,
  t0.bd AS bd_23,
  t0.stationService AS stationService_24,
  t0.nbKit AS nbKit_25,
  t0.registreCommerceVille AS registreCommerceVille_26,
  t0.light AS light_27,
  t0.curseur AS curseur_28,
  t0.curseurMinClient AS curseurMinClient_29,
  t0.sendMailCEEValidated AS sendMailCEEValidated_30,
  t0.surveyAverage AS surveyAverage_31,
  t0.external_client_code AS external_client_code_32,
  t0.interestedByFinancialMpr AS interestedByFinancialMpr_33,
  t0.financialMpr AS financialMpr_34,
  t0.mprAcceptFunding AS mprAcceptFunding_35,
  t0.sienna_id AS sienna_id_36,
  t0.logoFileName AS logoFileName_37,
  t0.cachetFileName AS cachetFileName_38,
  t0.tvaNumber AS tvaNumber_39,
  t0.decennalResponsibility AS decennalResponsibility_40,
  t0.companyStatus AS companyStatus_41,
  t0.codeApe AS codeApe_42,
  t0.capital AS capital_43,
  t44.id AS id_45,
  t44.type AS type_46,
  t44.detail AS detail_47,
  t44.token AS token_48,
  t44.installateur_id AS installateur_id_49,
  t44.particulierUser_id AS particulierUser_id_50,
  t44.entrepriseUser_id AS entrepriseUser_id_51,
  t44.particulierUserContact_id AS particulierUserContact_id_52,
  t44.entrepriseUserContact_id AS entrepriseUserContact_id_53,
  t0.user_id AS user_id_54,
  t55.id AS id_56,
  t55.tel AS tel_57,
  t55.mobile AS mobile_58,
  t55.username AS username_59,
  t55.fonction AS fonction_60,
  t55.nom AS nom_61,
  t55.prenom AS prenom_62,
  t55.company_id AS company_id_63,
  t64.id AS id_65,
  t64.mode AS mode_66,
  t64.targetType AS targetType_67,
  t64.classic AS classic_68,
  t64.preca AS preca_69,
  t64.enable AS enable_70,
  t64.raiType AS raiType_71,
  t64.contractSignedElectronically AS contractSignedElectronically_72,
  t64.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_73,
  t64.obligeTarget_id AS obligeTarget_id_74,
  t64.teteReseau_id AS teteReseau_id_75,
  t64.simulateur_id AS simulateur_id_76,
  t64.installateurTarget_id AS installateurTarget_id_77,
  t64.beTarget_id AS beTarget_id_78,
  t79.id AS id_80,
  t79.createdAt AS createdAt_81,
  t79.updatedAt AS updatedAt_82,
  t79.installateur_id AS installateur_id_83,
  t0.prestataireEffacement_id AS prestataireEffacement_id_84
FROM
  Installateur t0
  LEFT JOIN PaymentMethod t44 ON t44.installateur_id = t0.id
  LEFT JOIN SignataireInstallateur t55 ON t55.company_id = t0.id
  LEFT JOIN AffectationConsoneoRule t64 ON t64.installateurTarget_id = t0.id
  LEFT JOIN installateur_certificall_config t79 ON t79.installateur_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.chantiersParMois AS chantiersParMois_13, t0.data AS data_14, t0.programmeValorisation AS programmeValorisation_15, t0.apartientProgrammeValorisation AS apartientProgrammeValorisation_16, t0.cgu AS cgu_17, t0.oldContract AS oldContract_18, t0.lastLogin AS lastLogin_19, t0.lastDemande AS lastDemande_20, t0.qualificationsRequested AS qualificationsRequested_21, t0.qualificationRequestDate AS qualificationRequestDate_22, t0.bd AS bd_23, t0.stationService AS stationService_24, t0.nbKit AS nbKit_25, t0.registreCommerceVille AS registreCommerceVille_26, t0.light AS light_27, t0.curseur AS curseur_28, t0.curseurMinClient AS curseurMinClient_29, t0.sendMailCEEValidated AS sendMailCEEValidated_30, t0.surveyAverage AS surveyAverage_31, t0.external_client_code AS external_client_code_32, t0.interestedByFinancialMpr AS interestedByFinancialMpr_33, t0.financialMpr AS financialMpr_34, t0.mprAcceptFunding AS mprAcceptFunding_35, t0.sienna_id AS sienna_id_36, t0.logoFileName AS logoFileName_37, t0.cachetFileName AS cachetFileName_38, t0.tvaNumber AS tvaNumber_39, t0.decennalResponsibility AS decennalResponsibility_40, t0.companyStatus AS companyStatus_41, t0.codeApe AS codeApe_42, t0.capital AS capital_43, t44.id AS id_45, t44.type AS type_46, t44.detail AS detail_47, t44.token AS token_48, t44.installateur_id AS installateur_id_49, t44.particulierUser_id AS particulierUser_id_50, t44.entrepriseUser_id AS entrepriseUser_id_51, t44.particulierUserContact_id AS particulierUserContact_id_52, t44.entrepriseUserContact_id AS entrepriseUserContact_id_53, t0.user_id AS user_id_54, t55.id AS id_56, t55.tel AS tel_57, t55.mobile AS mobile_58, t55.username AS username_59, t55.fonction AS fonction_60, t55.nom AS nom_61, t55.prenom AS prenom_62, t55.company_id AS company_id_63, t64.id AS id_65, t64.mode AS mode_66, t64.targetType AS targetType_67, t64.classic AS classic_68, t64.preca AS preca_69, t64.enable AS enable_70, t64.raiType AS raiType_71, t64.contractSignedElectronically AS contractSignedElectronically_72, t64.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_73, t64.obligeTarget_id AS obligeTarget_id_74, t64.teteReseau_id AS teteReseau_id_75, t64.simulateur_id AS simulateur_id_76, t64.installateurTarget_id AS installateurTarget_id_77, t64.beTarget_id AS beTarget_id_78, t79.id AS id_80, t79.createdAt AS createdAt_81, t79.updatedAt AS updatedAt_82, t79.installateur_id AS installateur_id_83, t0.prestataireEffacement_id AS prestataireEffacement_id_84 FROM Installateur t0 LEFT JOIN PaymentMethod t44 ON t44.installateur_id = t0.id LEFT JOIN SignataireInstallateur t55 ON t55.company_id = t0.id LEFT JOIN AffectationConsoneoRule t64 ON t64.installateurTarget_id = t0.id LEFT JOIN installateur_certificall_config t79 ON t79.installateur_id = t0.id WHERE t0.id = 12766;

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 = 6;

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 = ?
  AND t0.is_default = ?
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` = 'enable_project_bundle' AND t0.object_id = 12766 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Installateur' AND t0.is_default = 0 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
  INNER JOIN obligeuser_tetereseau ON t0.id = obligeuser_tetereseau.tetereseauId
WHERE
  obligeuser_tetereseau.obligeuserId = ?

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 INNER JOIN obligeuser_tetereseau ON t0.id = obligeuser_tetereseau.tetereseauId WHERE obligeuser_tetereseau.obligeuserId = 44;

SELECT
  i0_.id AS id_0,
  i0_.username_canonical AS username_canonical_1,
  i0_.email AS email_2,
  i0_.email_canonical AS email_canonical_3,
  i0_.enabled AS enabled_4,
  i0_.salt AS salt_5,
  i0_.password AS password_6,
  i0_.last_login AS last_login_7,
  i0_.confirmation_token AS confirmation_token_8,
  i0_.password_requested_at AS password_requested_at_9,
  i0_.roles AS roles_10,
  i0_.username AS username_11,
  i0_.nom AS nom_12,
  i0_.prenom AS prenom_13,
  i0_.fonction AS fonction_14,
  i0_.tel AS tel_15,
  i0_.mobile AS mobile_16,
  i0_.activation AS activation_17,
  i0_.createdAt AS createdAt_18,
  i0_.updatedAt AS updatedAt_19,
  i0_.optin AS optin_20,
  i0_.dateActivation AS dateActivation_21,
  i0_.emailValidatedDateTime AS emailValidatedDateTime_22,
  i0_.emailCreatedDateTime AS emailCreatedDateTime_23,
  i0_.mobileCreatedDatetime AS mobileCreatedDatetime_24,
  i0_.sendEmail AS sendEmail_25,
  i0_.reference AS reference_26,
  i0_.currentSubscriptionStep AS currentSubscriptionStep_27,
  i0_.dateRetourContratPartenariat AS dateRetourContratPartenariat_28,
  i0_.token AS token_29,
  i0_.dateActivationStep2 AS dateActivationStep2_30,
  i0_.dateActivationStep4 AS dateActivationStep4_31,
  i0_.dateActivationStep5 AS dateActivationStep5_32,
  i0_.dateRefused AS dateRefused_33,
  i0_.emailRequested AS emailRequested_34,
  i0_.emailRequestedDate AS emailRequestedDate_35,
  i0_.attributes AS attributes_36,
  i0_.lastOffreDate AS lastOffreDate_37,
  i0_.quicklyTraited AS quicklyTraited_38,
  i0_.proType AS proType_39,
  i0_.system_facturation AS system_facturation_40,
  i0_.signataireAh AS signataireAh_41,
  i0_.inscription_step AS inscription_step_42,
  i0_.import_status AS import_status_43,
  i0_.token_thermor AS token_thermor_44,
  i0_.exclusiveEnabled AS exclusiveEnabled_45,
  i0_.relanceSmsRegistration AS relanceSmsRegistration_46,
  i0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_47,
  i0_.company_id AS company_id_48,
  i0_.workflow_id AS workflow_id_49,
  i0_.obligeTarget_id AS obligeTarget_id_50,
  i0_.identite_id AS identite_id_51,
  i0_.integrationModule_id AS integrationModule_id_52
FROM
  InstallateurUser i0_
  INNER JOIN Installateur i1_ ON i0_.company_id = i1_.id
  INNER JOIN IntegrationModule i2_ ON i0_.integrationModule_id = i2_.id
  INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id
  INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id
  LEFT JOIN QualificationRecord q5_ ON i1_.id = q5_.installateur_id
  LEFT JOIN Qualification q6_ ON q5_.qualification_id = q6_.id
  LEFT JOIN AffectationUser a7_ ON i0_.id = a7_.installateurUser_id
  LEFT JOIN ObligeUser o8_ ON a7_.obligeUser_id = o8_.id
  LEFT JOIN ObligeRole o9_ ON a7_.obligeRole_id = o9_.id
  LEFT JOIN InstallateurUser i10_ ON i1_.id = i10_.company_id
  LEFT JOIN OffreProjet o11_ ON i10_.id = o11_.installateurUser_id
WHERE
  t3_.oblige_id = ?
  AND o9_.role = ?
  AND i0_.activation IN ('fully', 'siret_join')
  AND t3_.id IN (?, ?, ?)
  AND i0_.id IN (?, ?, ?, ?, ?)
GROUP BY
  i0_.id
ORDER BY
  i0_.createdAt DESC

SELECT i0_.id AS id_0, i0_.username_canonical AS username_canonical_1, i0_.email AS email_2, i0_.email_canonical AS email_canonical_3, i0_.enabled AS enabled_4, i0_.salt AS salt_5, i0_.password AS password_6, i0_.last_login AS last_login_7, i0_.confirmation_token AS confirmation_token_8, i0_.password_requested_at AS password_requested_at_9, i0_.roles AS roles_10, i0_.username AS username_11, i0_.nom AS nom_12, i0_.prenom AS prenom_13, i0_.fonction AS fonction_14, i0_.tel AS tel_15, i0_.mobile AS mobile_16, i0_.activation AS activation_17, i0_.createdAt AS createdAt_18, i0_.updatedAt AS updatedAt_19, i0_.optin AS optin_20, i0_.dateActivation AS dateActivation_21, i0_.emailValidatedDateTime AS emailValidatedDateTime_22, i0_.emailCreatedDateTime AS emailCreatedDateTime_23, i0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, i0_.sendEmail AS sendEmail_25, i0_.reference AS reference_26, i0_.currentSubscriptionStep AS currentSubscriptionStep_27, i0_.dateRetourContratPartenariat AS dateRetourContratPartenariat_28, i0_.token AS token_29, i0_.dateActivationStep2 AS dateActivationStep2_30, i0_.dateActivationStep4 AS dateActivationStep4_31, i0_.dateActivationStep5 AS dateActivationStep5_32, i0_.dateRefused AS dateRefused_33, i0_.emailRequested AS emailRequested_34, i0_.emailRequestedDate AS emailRequestedDate_35, i0_.attributes AS attributes_36, i0_.lastOffreDate AS lastOffreDate_37, i0_.quicklyTraited AS quicklyTraited_38, i0_.proType AS proType_39, i0_.system_facturation AS system_facturation_40, i0_.signataireAh AS signataireAh_41, i0_.inscription_step AS inscription_step_42, i0_.import_status AS import_status_43, i0_.token_thermor AS token_thermor_44, i0_.exclusiveEnabled AS exclusiveEnabled_45, i0_.relanceSmsRegistration AS relanceSmsRegistration_46, i0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_47, i0_.company_id AS company_id_48, i0_.workflow_id AS workflow_id_49, i0_.obligeTarget_id AS obligeTarget_id_50, i0_.identite_id AS identite_id_51, i0_.integrationModule_id AS integrationModule_id_52 FROM InstallateurUser i0_ INNER JOIN Installateur i1_ ON i0_.company_id = i1_.id INNER JOIN IntegrationModule i2_ ON i0_.integrationModule_id = i2_.id INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id LEFT JOIN QualificationRecord q5_ ON i1_.id = q5_.installateur_id LEFT JOIN Qualification q6_ ON q5_.qualification_id = q6_.id LEFT JOIN AffectationUser a7_ ON i0_.id = a7_.installateurUser_id LEFT JOIN ObligeUser o8_ ON a7_.obligeUser_id = o8_.id LEFT JOIN ObligeRole o9_ ON a7_.obligeRole_id = o9_.id LEFT JOIN InstallateurUser i10_ ON i1_.id = i10_.company_id LEFT JOIN OffreProjet o11_ ON i10_.id = o11_.installateurUser_id WHERE t3_.oblige_id = 6 AND o9_.role = 'ROLE_COMMERCIAL_PRO' AND i0_.activation IN ('fully', 'siret_join') AND t3_.id IN (28, 1509, 1510) AND i0_.id IN (14728, 14727, 14725, 14724, 14721) GROUP BY i0_.id ORDER BY i0_.createdAt DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.enabled AS enabled_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.last_login AS last_login_6,
  t0.confirmation_token AS confirmation_token_7,
  t0.password_requested_at AS password_requested_at_8,
  t0.roles AS roles_9,
  t0.username AS username_10,
  t0.nom AS nom_11,
  t0.prenom AS prenom_12,
  t0.fonction AS fonction_13,
  t0.tel AS tel_14,
  t0.mobile AS mobile_15,
  t0.activation AS activation_16,
  t0.createdAt AS createdAt_17,
  t0.updatedAt AS updatedAt_18,
  t0.optin AS optin_19,
  t0.dateActivation AS dateActivation_20,
  t0.emailValidatedDateTime AS emailValidatedDateTime_21,
  t0.emailCreatedDateTime AS emailCreatedDateTime_22,
  t0.mobileCreatedDatetime AS mobileCreatedDatetime_23,
  t0.sendEmail AS sendEmail_24,
  t0.scope AS scope_25,
  t0.isArchived AS isArchived_26,
  t0.import AS import_27,
  t0.email_canonical AS email_canonical_28,
  t0.username_canonical AS username_canonical_29,
  t0.oblige_id AS oblige_id_30
FROM
  ObligeUser t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = 44;