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.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.interestedByCreditNote AS interestedByCreditNote_34,
  t0.financialMpr AS financialMpr_35,
  t0.mprAcceptFunding AS mprAcceptFunding_36,
  t0.sienna_id AS sienna_id_37,
  t0.logoFileName AS logoFileName_38,
  t0.cachetFileName AS cachetFileName_39,
  t0.tvaNumber AS tvaNumber_40,
  t0.decennalResponsibility AS decennalResponsibility_41,
  t0.acronyme AS acronyme_42,
  t0.companyStatus AS companyStatus_43,
  t0.codeApe AS codeApe_44,
  t0.capital AS capital_45,
  t46.id AS id_47,
  t46.type AS type_48,
  t46.detail AS detail_49,
  t46.token AS token_50,
  t46.installateur_id AS installateur_id_51,
  t46.particulierUser_id AS particulierUser_id_52,
  t46.entrepriseUser_id AS entrepriseUser_id_53,
  t46.particulierUserContact_id AS particulierUserContact_id_54,
  t46.entrepriseUserContact_id AS entrepriseUserContact_id_55,
  t0.user_id AS user_id_56,
  t57.id AS id_58,
  t57.tel AS tel_59,
  t57.mobile AS mobile_60,
  t57.username AS username_61,
  t57.fonction AS fonction_62,
  t57.nom AS nom_63,
  t57.prenom AS prenom_64,
  t57.company_id AS company_id_65,
  t66.id AS id_67,
  t66.mode AS mode_68,
  t66.targetType AS targetType_69,
  t66.classic AS classic_70,
  t66.preca AS preca_71,
  t66.enable AS enable_72,
  t66.raiType AS raiType_73,
  t66.contractSignedElectronically AS contractSignedElectronically_74,
  t66.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_75,
  t66.obligeTarget_id AS obligeTarget_id_76,
  t66.teteReseau_id AS teteReseau_id_77,
  t66.simulateur_id AS simulateur_id_78,
  t66.installateurTarget_id AS installateurTarget_id_79,
  t66.beTarget_id AS beTarget_id_80,
  t81.id AS id_82,
  t81.createdAt AS createdAt_83,
  t81.updatedAt AS updatedAt_84,
  t81.installateur_id AS installateur_id_85,
  t0.prestataireEffacement_id AS prestataireEffacement_id_86
FROM
  Installateur t0
  LEFT JOIN PaymentMethod t46 ON t46.installateur_id = t0.id
  LEFT JOIN SignataireInstallateur t57 ON t57.company_id = t0.id
  LEFT JOIN AffectationConsoneoRule t66 ON t66.installateurTarget_id = t0.id
  LEFT JOIN installateur_certificall_config t81 ON t81.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.interestedByCreditNote AS interestedByCreditNote_34, t0.financialMpr AS financialMpr_35, t0.mprAcceptFunding AS mprAcceptFunding_36, t0.sienna_id AS sienna_id_37, t0.logoFileName AS logoFileName_38, t0.cachetFileName AS cachetFileName_39, t0.tvaNumber AS tvaNumber_40, t0.decennalResponsibility AS decennalResponsibility_41, t0.acronyme AS acronyme_42, t0.companyStatus AS companyStatus_43, t0.codeApe AS codeApe_44, t0.capital AS capital_45, t46.id AS id_47, t46.type AS type_48, t46.detail AS detail_49, t46.token AS token_50, t46.installateur_id AS installateur_id_51, t46.particulierUser_id AS particulierUser_id_52, t46.entrepriseUser_id AS entrepriseUser_id_53, t46.particulierUserContact_id AS particulierUserContact_id_54, t46.entrepriseUserContact_id AS entrepriseUserContact_id_55, t0.user_id AS user_id_56, t57.id AS id_58, t57.tel AS tel_59, t57.mobile AS mobile_60, t57.username AS username_61, t57.fonction AS fonction_62, t57.nom AS nom_63, t57.prenom AS prenom_64, t57.company_id AS company_id_65, t66.id AS id_67, t66.mode AS mode_68, t66.targetType AS targetType_69, t66.classic AS classic_70, t66.preca AS preca_71, t66.enable AS enable_72, t66.raiType AS raiType_73, t66.contractSignedElectronically AS contractSignedElectronically_74, t66.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_75, t66.obligeTarget_id AS obligeTarget_id_76, t66.teteReseau_id AS teteReseau_id_77, t66.simulateur_id AS simulateur_id_78, t66.installateurTarget_id AS installateurTarget_id_79, t66.beTarget_id AS beTarget_id_80, t81.id AS id_82, t81.createdAt AS createdAt_83, t81.updatedAt AS updatedAt_84, t81.installateur_id AS installateur_id_85, t0.prestataireEffacement_id AS prestataireEffacement_id_86 FROM Installateur t0 LEFT JOIN PaymentMethod t46 ON t46.installateur_id = t0.id LEFT JOIN SignataireInstallateur t57 ON t57.company_id = t0.id LEFT JOIN AffectationConsoneoRule t66 ON t66.installateurTarget_id = t0.id LEFT JOIN installateur_certificall_config t81 ON t81.installateur_id = t0.id WHERE t0.id = 12766;

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.neoSpaceEnabled AS neoSpaceEnabled_28,
  t0.email_canonical AS email_canonical_29,
  t0.username_canonical AS username_canonical_30,
  t0.oblige_id AS oblige_id_31
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.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = 44;

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.id = ?

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.id = '14728';

SELECT
  t0.id AS id_1,
  t0.entrepriseUser_id AS entrepriseUser_id_2,
  t0.particulierUser_id AS particulierUser_id_3,
  t0.installateurUser_id AS installateurUser_id_4,
  t0.beUser_id AS beUser_id_5,
  t0.obligeUser_id AS obligeUser_id_6,
  t0.obligeRole_id AS obligeRole_id_7
FROM
  AffectationUser t0
WHERE
  t0.installateurUser_id IN (?)

SELECT t0.id AS id_1, t0.entrepriseUser_id AS entrepriseUser_id_2, t0.particulierUser_id AS particulierUser_id_3, t0.installateurUser_id AS installateurUser_id_4, t0.beUser_id AS beUser_id_5, t0.obligeUser_id AS obligeUser_id_6, t0.obligeRole_id AS obligeRole_id_7 FROM AffectationUser t0 WHERE t0.installateurUser_id IN (14728);

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.id = ?

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.id = 4791;