Symfony Profiler

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

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  ObligeUser o0_
WHERE
  o0_.oblige_id = ?
  AND o0_.isArchived = ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM ObligeUser o0_ WHERE o0_.oblige_id = 2 AND o0_.isArchived = 0;

SELECT
  DISTINCT o0_.id AS id_0
FROM
  ObligeUser o0_
WHERE
  o0_.oblige_id = ?
  AND o0_.isArchived = ?
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0 FROM ObligeUser o0_ WHERE o0_.oblige_id = 2 AND o0_.isArchived = 0 LIMIT 30;

SELECT
  o0_.id AS id_0,
  o0_.email AS email_1,
  o0_.enabled AS enabled_2,
  o0_.salt AS salt_3,
  o0_.password AS password_4,
  o0_.last_login AS last_login_5,
  o0_.confirmation_token AS confirmation_token_6,
  o0_.password_requested_at AS password_requested_at_7,
  o0_.roles AS roles_8,
  o0_.username AS username_9,
  o0_.nom AS nom_10,
  o0_.prenom AS prenom_11,
  o0_.fonction AS fonction_12,
  o0_.tel AS tel_13,
  o0_.mobile AS mobile_14,
  o0_.activation AS activation_15,
  o0_.createdAt AS createdAt_16,
  o0_.updatedAt AS updatedAt_17,
  o0_.optin AS optin_18,
  o0_.dateActivation AS dateActivation_19,
  o0_.emailValidatedDateTime AS emailValidatedDateTime_20,
  o0_.emailCreatedDateTime AS emailCreatedDateTime_21,
  o0_.mobileCreatedDatetime AS mobileCreatedDatetime_22,
  o0_.sendEmail AS sendEmail_23,
  o0_.scope AS scope_24,
  o0_.isArchived AS isArchived_25,
  o0_.import AS import_26,
  o0_.neoSpaceEnabled AS neoSpaceEnabled_27,
  o0_.email_canonical AS email_canonical_28,
  o0_.username_canonical AS username_canonical_29,
  o0_.oblige_id AS oblige_id_30
FROM
  ObligeUser o0_
WHERE
  o0_.oblige_id = ?
  AND o0_.isArchived = ?
  AND o0_.id IN (?, ?, ?)

SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.enabled AS enabled_2, o0_.salt AS salt_3, o0_.password AS password_4, o0_.last_login AS last_login_5, o0_.confirmation_token AS confirmation_token_6, o0_.password_requested_at AS password_requested_at_7, o0_.roles AS roles_8, o0_.username AS username_9, o0_.nom AS nom_10, o0_.prenom AS prenom_11, o0_.fonction AS fonction_12, o0_.tel AS tel_13, o0_.mobile AS mobile_14, o0_.activation AS activation_15, o0_.createdAt AS createdAt_16, o0_.updatedAt AS updatedAt_17, o0_.optin AS optin_18, o0_.dateActivation AS dateActivation_19, o0_.emailValidatedDateTime AS emailValidatedDateTime_20, o0_.emailCreatedDateTime AS emailCreatedDateTime_21, o0_.mobileCreatedDatetime AS mobileCreatedDatetime_22, o0_.sendEmail AS sendEmail_23, o0_.scope AS scope_24, o0_.isArchived AS isArchived_25, o0_.import AS import_26, o0_.neoSpaceEnabled AS neoSpaceEnabled_27, o0_.email_canonical AS email_canonical_28, o0_.username_canonical AS username_canonical_29, o0_.oblige_id AS oblige_id_30 FROM ObligeUser o0_ WHERE o0_.oblige_id = 2 AND o0_.isArchived = 0 AND o0_.id IN (2, 420, 1843);

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.`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` = 'enable_project_bundle' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

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
  INNER JOIN obligeuser_obligeuser ON t0.id = obligeuser_obligeuser.obligeuser_target
WHERE
  obligeuser_obligeuser.obligeuser_source = ?

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 INNER JOIN obligeuser_obligeuser ON t0.id = obligeuser_obligeuser.obligeuser_target WHERE obligeuser_obligeuser.obligeuser_source = 2;