Symfony Profiler

Query Metrics

10 Database Queries

6 Different statements

58.82 ms Query time

0 Invalid entities

7 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection


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.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? 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.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.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.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.end_zni_date AS end_zni_date_88, t52.globalConfigurationHash AS globalConfigurationHash_89, t52.zni AS zni_90, t52.cdp_eligible AS cdp_eligible_91, t52.simulateur_id AS simulateur_id_92, t52.arrete_id AS arrete_id_93, t52.certification_id AS certification_id_94, t52.qualification_id AS qualification_id_95, t52.formConfigEngine_id AS formConfigEngine_id_96, t0.entrepriseUser_id AS entrepriseUser_id_97, t0.particulierUser_id AS particulierUser_id_98, t0.installateurUser_id AS installateurUser_id_99, t0.beUser_id AS beUser_id_100, t101.id AS id_102, t101.type AS type_103, t101.pricingType AS pricingType_104, t101.finalisationRequested AS finalisationRequested_105, t101.finalisationRequestDate AS finalisationRequestDate_106, t101.reference AS reference_107, t101.data AS data_108, t101.cofracData AS cofracData_109, t101.cofracEngineDocumentId AS cofracEngineDocumentId_110, t101.ip AS ip_111, t101.offre_auto_date AS offre_auto_date_112, t101.created_datetime AS created_datetime_113, t101.updated_datetime AS updated_datetime_114, t101.tel AS tel_115, t101.codepostal AS codepostal_116, t101.adresse AS adresse_117, t101.adresse_complement AS adresse_complement_118, t101.ville AS ville_119, t101.delai_souhaite AS delai_souhaite_120, t101.accept_recevoir_offre AS accept_recevoir_offre_121, t101.accept_recommandation AS accept_recommandation_122, t101.acceptLeadPromo AS acceptLeadPromo_123, t101.offre_cumac AS offre_cumac_124, t101.offre_cumac_client AS offre_cumac_client_125, t101.offre_cumac_precarite AS offre_cumac_precarite_126, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_127, t101.cumac AS cumac_128, t101.cumac_AFT AS cumac_AFT_129, t101.total_prime AS total_prime_130, t101.total_prime_AFT AS total_prime_AFT_131, t101.prime_pro AS prime_pro_132, t101.prime_pro_aft AS prime_pro_aft_133, t101.prime_client AS prime_client_134, t101.prime_client_aft AS prime_client_aft_135, t101.cumac_moyenne AS cumac_moyenne_136, t101.taux_actualise AS taux_actualise_137, t101.taux_accumule AS taux_accumule_138, t101.date_debut_chantier AS date_debut_chantier_139, t101.date_demande_offre AS date_demande_offre_140, t101.date_fin_chantier AS date_fin_chantier_141, t101.etat AS etat_142, t101.status AS status_143, t101.date_offre AS date_offre_144, t101.notification_date_chantier AS notification_date_chantier_145, t101.date_retour_conv AS date_retour_conv_146, t101.date_validation_conv AS date_validation_conv_147, t101.date_chantier_renseigne AS date_chantier_renseigne_148, t101.date_paiement AS date_paiement_149, t101.date_all_doc_valid AS date_all_doc_valid_150, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_151, t101.date_envoi_questionnaire AS date_envoi_questionnaire_152, t101.date_edition_questionnaire AS date_edition_questionnaire_153, t101.date_validation_final AS date_validation_final_154, t101.date_annulation AS date_annulation_155, t101.no_click_email_date_chantier AS no_click_email_date_chantier_156, t101.token AS token_157, t101.auto_installation AS auto_installation_158, t101.siret AS siret_159, t101.cancelReason AS cancelReason_160, t101.dateCommande AS dateCommande_161, t101.siteTravaux AS siteTravaux_162, t101.incitation AS incitation_163, t101.qualificationRecordDate AS qualificationRecordDate_164, t101.serviceType AS serviceType_165, t101.debutChantier AS debutChantier_166, t101.finChantier AS finChantier_167, t101.initiateCDP AS initiateCDP_168, t101.cdp AS cdp_169, t101.date_last_envoi_convention AS date_last_envoi_convention_170, t101.programStep AS programStep_171, t101.devisRestAPayer AS devisRestAPayer_172, t101.pricingMandatClassique AS pricingMandatClassique_173, t101.pricingMandatPreca AS pricingMandatPreca_174, t101.isCOFRAC AS isCOFRAC_175, t101.applicationFeesPrice AS applicationFeesPrice_176, t101.attributes AS attributes_177, t101.exclusive AS exclusive_178, t101.engineDocumentId AS engineDocumentId_179, t101.adresseTravaux AS adresseTravaux_180, t101.adresseTravauxCommentaire AS adresseTravauxCommentaire_181, t101.batchOffreProjet_id AS batchOffreProjet_id_182, t101.entrepriseUser_id AS entrepriseUser_id_183, t101.installateurUser_id AS installateurUser_id_184, t101.beUser_id AS beUser_id_185, t101.entrepriseUserContact_id AS entrepriseUserContact_id_186, t101.particulierUserContact_id AS particulierUserContact_id_187, t101.signataireEntreprise_id AS signataireEntreprise_id_188, t101.signataireInstallateur_id AS signataireInstallateur_id_189, t101.installateurUserContact_id AS installateurUserContact_id_190, t101.projet_id AS projet_id_191, t101.precariteCas2_id AS precariteCas2_id_192, t101.precarite_id AS precarite_id_193, t101.state_id AS state_id_194, t101.oblige_id AS oblige_id_195, t101.secteurActivite_id AS secteurActivite_id_196, t101.factureDetail_id AS factureDetail_id_197, t101.offreStatus_id AS offreStatus_id_198, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_199, t101.identiteInstallateur_id AS identiteInstallateur_id_200, t101.operation_id AS operation_id_201, t101.particulierUser_id AS particulierUser_id_202, t101.qualificationRecord_id AS qualificationRecord_id_203, t101.sousTraitant_id AS sousTraitant_id_204, t101.program_id AS program_id_205, t101.programCommercial_id AS programCommercial_id_206, t101.programManager_id AS programManager_id_207, t101.signatureAuto_id AS signatureAuto_id_208, t101.wasteCenter_id AS wasteCenter_id_209, t101.waste_id AS waste_id_210, t101.programAuto_id AS programAuto_id_211, t101.justificatif_id AS justificatif_id_212, t101.cappingRule_id AS cappingRule_id_213, t101.projectOwner_id AS projectOwner_id_214, t101.project_bundle_id AS project_bundle_id_215, t101.estate_id AS estate_id_216, t0.precarite_id AS precarite_id_217, t0.secteurActivite_id AS secteurActivite_id_218, t0.integrationModule_id AS integrationModule_id_219, t0.precariteCas2_id AS precariteCas2_id_220, t0.program_id AS program_id_221, t0.programCommercial_id AS programCommercial_id_222, t0.programManager_id AS programManager_id_223, t0.justificatif_id AS justificatif_id_224, t225.id AS id_226, t225.numero AS numero_227, t225.dateRealisation AS dateRealisation_228, t225.dateFinValidite AS dateFinValidite_229, t225.etiquetteBilan AS etiquetteBilan_230, t225.createdAt AS createdAt_231, t225.updatedAt AS updatedAt_232, t225.typeJustificatif AS typeJustificatif_233, t225.projet_id AS projet_id_234, t225.offreProjet_id AS offreProjet_id_235, t0.project_bundle_id AS project_bundle_id_236, t0.estate_id AS estate_id_237 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t225 ON t225.projet_id = t0.id WHERE t0.reference IS NULL 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.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? 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.`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

#▲	Time	Info
1	1.42 ms	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 Parameters: [`"1234"`] View formatted query View runnable query Explain query 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;
2	0.92 ms	SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1 Parameters: [`"p"`] View formatted query View runnable query Explain query 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;
3	0.85 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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;
4	1.55 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
5	1.03 ms	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 Parameters: [`"1234"`] View formatted query View runnable query Explain query 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;
6	30.35 ms	SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.end_zni_date AS end_zni_date_88, t52.globalConfigurationHash AS globalConfigurationHash_89, t52.zni AS zni_90, t52.cdp_eligible AS cdp_eligible_91, t52.simulateur_id AS simulateur_id_92, t52.arrete_id AS arrete_id_93, t52.certification_id AS certification_id_94, t52.qualification_id AS qualification_id_95, t52.formConfigEngine_id AS formConfigEngine_id_96, t0.entrepriseUser_id AS entrepriseUser_id_97, t0.particulierUser_id AS particulierUser_id_98, t0.installateurUser_id AS installateurUser_id_99, t0.beUser_id AS beUser_id_100, t101.id AS id_102, t101.type AS type_103, t101.pricingType AS pricingType_104, t101.finalisationRequested AS finalisationRequested_105, t101.finalisationRequestDate AS finalisationRequestDate_106, t101.reference AS reference_107, t101.data AS data_108, t101.cofracData AS cofracData_109, t101.cofracEngineDocumentId AS cofracEngineDocumentId_110, t101.ip AS ip_111, t101.offre_auto_date AS offre_auto_date_112, t101.created_datetime AS created_datetime_113, t101.updated_datetime AS updated_datetime_114, t101.tel AS tel_115, t101.codepostal AS codepostal_116, t101.adresse AS adresse_117, t101.adresse_complement AS adresse_complement_118, t101.ville AS ville_119, t101.delai_souhaite AS delai_souhaite_120, t101.accept_recevoir_offre AS accept_recevoir_offre_121, t101.accept_recommandation AS accept_recommandation_122, t101.acceptLeadPromo AS acceptLeadPromo_123, t101.offre_cumac AS offre_cumac_124, t101.offre_cumac_client AS offre_cumac_client_125, t101.offre_cumac_precarite AS offre_cumac_precarite_126, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_127, t101.cumac AS cumac_128, t101.cumac_AFT AS cumac_AFT_129, t101.total_prime AS total_prime_130, t101.total_prime_AFT AS total_prime_AFT_131, t101.prime_pro AS prime_pro_132, t101.prime_pro_aft AS prime_pro_aft_133, t101.prime_client AS prime_client_134, t101.prime_client_aft AS prime_client_aft_135, t101.cumac_moyenne AS cumac_moyenne_136, t101.taux_actualise AS taux_actualise_137, t101.taux_accumule AS taux_accumule_138, t101.date_debut_chantier AS date_debut_chantier_139, t101.date_demande_offre AS date_demande_offre_140, t101.date_fin_chantier AS date_fin_chantier_141, t101.etat AS etat_142, t101.status AS status_143, t101.date_offre AS date_offre_144, t101.notification_date_chantier AS notification_date_chantier_145, t101.date_retour_conv AS date_retour_conv_146, t101.date_validation_conv AS date_validation_conv_147, t101.date_chantier_renseigne AS date_chantier_renseigne_148, t101.date_paiement AS date_paiement_149, t101.date_all_doc_valid AS date_all_doc_valid_150, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_151, t101.date_envoi_questionnaire AS date_envoi_questionnaire_152, t101.date_edition_questionnaire AS date_edition_questionnaire_153, t101.date_validation_final AS date_validation_final_154, t101.date_annulation AS date_annulation_155, t101.no_click_email_date_chantier AS no_click_email_date_chantier_156, t101.token AS token_157, t101.auto_installation AS auto_installation_158, t101.siret AS siret_159, t101.cancelReason AS cancelReason_160, t101.dateCommande AS dateCommande_161, t101.siteTravaux AS siteTravaux_162, t101.incitation AS incitation_163, t101.qualificationRecordDate AS qualificationRecordDate_164, t101.serviceType AS serviceType_165, t101.debutChantier AS debutChantier_166, t101.finChantier AS finChantier_167, t101.initiateCDP AS initiateCDP_168, t101.cdp AS cdp_169, t101.date_last_envoi_convention AS date_last_envoi_convention_170, t101.programStep AS programStep_171, t101.devisRestAPayer AS devisRestAPayer_172, t101.pricingMandatClassique AS pricingMandatClassique_173, t101.pricingMandatPreca AS pricingMandatPreca_174, t101.isCOFRAC AS isCOFRAC_175, t101.applicationFeesPrice AS applicationFeesPrice_176, t101.attributes AS attributes_177, t101.exclusive AS exclusive_178, t101.engineDocumentId AS engineDocumentId_179, t101.adresseTravaux AS adresseTravaux_180, t101.adresseTravauxCommentaire AS adresseTravauxCommentaire_181, t101.batchOffreProjet_id AS batchOffreProjet_id_182, t101.entrepriseUser_id AS entrepriseUser_id_183, t101.installateurUser_id AS installateurUser_id_184, t101.beUser_id AS beUser_id_185, t101.entrepriseUserContact_id AS entrepriseUserContact_id_186, t101.particulierUserContact_id AS particulierUserContact_id_187, t101.signataireEntreprise_id AS signataireEntreprise_id_188, t101.signataireInstallateur_id AS signataireInstallateur_id_189, t101.installateurUserContact_id AS installateurUserContact_id_190, t101.projet_id AS projet_id_191, t101.precariteCas2_id AS precariteCas2_id_192, t101.precarite_id AS precarite_id_193, t101.state_id AS state_id_194, t101.oblige_id AS oblige_id_195, t101.secteurActivite_id AS secteurActivite_id_196, t101.factureDetail_id AS factureDetail_id_197, t101.offreStatus_id AS offreStatus_id_198, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_199, t101.identiteInstallateur_id AS identiteInstallateur_id_200, t101.operation_id AS operation_id_201, t101.particulierUser_id AS particulierUser_id_202, t101.qualificationRecord_id AS qualificationRecord_id_203, t101.sousTraitant_id AS sousTraitant_id_204, t101.program_id AS program_id_205, t101.programCommercial_id AS programCommercial_id_206, t101.programManager_id AS programManager_id_207, t101.signatureAuto_id AS signatureAuto_id_208, t101.wasteCenter_id AS wasteCenter_id_209, t101.waste_id AS waste_id_210, t101.programAuto_id AS programAuto_id_211, t101.justificatif_id AS justificatif_id_212, t101.cappingRule_id AS cappingRule_id_213, t101.projectOwner_id AS projectOwner_id_214, t101.project_bundle_id AS project_bundle_id_215, t101.estate_id AS estate_id_216, t0.precarite_id AS precarite_id_217, t0.secteurActivite_id AS secteurActivite_id_218, t0.integrationModule_id AS integrationModule_id_219, t0.precariteCas2_id AS precariteCas2_id_220, t0.program_id AS program_id_221, t0.programCommercial_id AS programCommercial_id_222, t0.programManager_id AS programManager_id_223, t0.justificatif_id AS justificatif_id_224, t225.id AS id_226, t225.numero AS numero_227, t225.dateRealisation AS dateRealisation_228, t225.dateFinValidite AS dateFinValidite_229, t225.etiquetteBilan AS etiquetteBilan_230, t225.createdAt AS createdAt_231, t225.updatedAt AS updatedAt_232, t225.typeJustificatif AS typeJustificatif_233, t225.projet_id AS projet_id_234, t225.offreProjet_id AS offreProjet_id_235, t0.project_bundle_id AS project_bundle_id_236, t0.estate_id AS estate_id_237 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t225 ON t225.projet_id = t0.id WHERE t0.reference IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.end_zni_date AS end_zni_date_88, t52.globalConfigurationHash AS globalConfigurationHash_89, t52.zni AS zni_90, t52.cdp_eligible AS cdp_eligible_91, t52.simulateur_id AS simulateur_id_92, t52.arrete_id AS arrete_id_93, t52.certification_id AS certification_id_94, t52.qualification_id AS qualification_id_95, t52.formConfigEngine_id AS formConfigEngine_id_96, t0.entrepriseUser_id AS entrepriseUser_id_97, t0.particulierUser_id AS particulierUser_id_98, t0.installateurUser_id AS installateurUser_id_99, t0.beUser_id AS beUser_id_100, t101.id AS id_102, t101.type AS type_103, t101.pricingType AS pricingType_104, t101.finalisationRequested AS finalisationRequested_105, t101.finalisationRequestDate AS finalisationRequestDate_106, t101.reference AS reference_107, t101.data AS data_108, t101.cofracData AS cofracData_109, t101.cofracEngineDocumentId AS cofracEngineDocumentId_110, t101.ip AS ip_111, t101.offre_auto_date AS offre_auto_date_112, t101.created_datetime AS created_datetime_113, t101.updated_datetime AS updated_datetime_114, t101.tel AS tel_115, t101.codepostal AS codepostal_116, t101.adresse AS adresse_117, t101.adresse_complement AS adresse_complement_118, t101.ville AS ville_119, t101.delai_souhaite AS delai_souhaite_120, t101.accept_recevoir_offre AS accept_recevoir_offre_121, t101.accept_recommandation AS accept_recommandation_122, t101.acceptLeadPromo AS acceptLeadPromo_123, t101.offre_cumac AS offre_cumac_124, t101.offre_cumac_client AS offre_cumac_client_125, t101.offre_cumac_precarite AS offre_cumac_precarite_126, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_127, t101.cumac AS cumac_128, t101.cumac_AFT AS cumac_AFT_129, t101.total_prime AS total_prime_130, t101.total_prime_AFT AS total_prime_AFT_131, t101.prime_pro AS prime_pro_132, t101.prime_pro_aft AS prime_pro_aft_133, t101.prime_client AS prime_client_134, t101.prime_client_aft AS prime_client_aft_135, t101.cumac_moyenne AS cumac_moyenne_136, t101.taux_actualise AS taux_actualise_137, t101.taux_accumule AS taux_accumule_138, t101.date_debut_chantier AS date_debut_chantier_139, t101.date_demande_offre AS date_demande_offre_140, t101.date_fin_chantier AS date_fin_chantier_141, t101.etat AS etat_142, t101.status AS status_143, t101.date_offre AS date_offre_144, t101.notification_date_chantier AS notification_date_chantier_145, t101.date_retour_conv AS date_retour_conv_146, t101.date_validation_conv AS date_validation_conv_147, t101.date_chantier_renseigne AS date_chantier_renseigne_148, t101.date_paiement AS date_paiement_149, t101.date_all_doc_valid AS date_all_doc_valid_150, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_151, t101.date_envoi_questionnaire AS date_envoi_questionnaire_152, t101.date_edition_questionnaire AS date_edition_questionnaire_153, t101.date_validation_final AS date_validation_final_154, t101.date_annulation AS date_annulation_155, t101.no_click_email_date_chantier AS no_click_email_date_chantier_156, t101.token AS token_157, t101.auto_installation AS auto_installation_158, t101.siret AS siret_159, t101.cancelReason AS cancelReason_160, t101.dateCommande AS dateCommande_161, t101.siteTravaux AS siteTravaux_162, t101.incitation AS incitation_163, t101.qualificationRecordDate AS qualificationRecordDate_164, t101.serviceType AS serviceType_165, t101.debutChantier AS debutChantier_166, t101.finChantier AS finChantier_167, t101.initiateCDP AS initiateCDP_168, t101.cdp AS cdp_169, t101.date_last_envoi_convention AS date_last_envoi_convention_170, t101.programStep AS programStep_171, t101.devisRestAPayer AS devisRestAPayer_172, t101.pricingMandatClassique AS pricingMandatClassique_173, t101.pricingMandatPreca AS pricingMandatPreca_174, t101.isCOFRAC AS isCOFRAC_175, t101.applicationFeesPrice AS applicationFeesPrice_176, t101.attributes AS attributes_177, t101.exclusive AS exclusive_178, t101.engineDocumentId AS engineDocumentId_179, t101.adresseTravaux AS adresseTravaux_180, t101.adresseTravauxCommentaire AS adresseTravauxCommentaire_181, t101.batchOffreProjet_id AS batchOffreProjet_id_182, t101.entrepriseUser_id AS entrepriseUser_id_183, t101.installateurUser_id AS installateurUser_id_184, t101.beUser_id AS beUser_id_185, t101.entrepriseUserContact_id AS entrepriseUserContact_id_186, t101.particulierUserContact_id AS particulierUserContact_id_187, t101.signataireEntreprise_id AS signataireEntreprise_id_188, t101.signataireInstallateur_id AS signataireInstallateur_id_189, t101.installateurUserContact_id AS installateurUserContact_id_190, t101.projet_id AS projet_id_191, t101.precariteCas2_id AS precariteCas2_id_192, t101.precarite_id AS precarite_id_193, t101.state_id AS state_id_194, t101.oblige_id AS oblige_id_195, t101.secteurActivite_id AS secteurActivite_id_196, t101.factureDetail_id AS factureDetail_id_197, t101.offreStatus_id AS offreStatus_id_198, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_199, t101.identiteInstallateur_id AS identiteInstallateur_id_200, t101.operation_id AS operation_id_201, t101.particulierUser_id AS particulierUser_id_202, t101.qualificationRecord_id AS qualificationRecord_id_203, t101.sousTraitant_id AS sousTraitant_id_204, t101.program_id AS program_id_205, t101.programCommercial_id AS programCommercial_id_206, t101.programManager_id AS programManager_id_207, t101.signatureAuto_id AS signatureAuto_id_208, t101.wasteCenter_id AS wasteCenter_id_209, t101.waste_id AS waste_id_210, t101.programAuto_id AS programAuto_id_211, t101.justificatif_id AS justificatif_id_212, t101.cappingRule_id AS cappingRule_id_213, t101.projectOwner_id AS projectOwner_id_214, t101.project_bundle_id AS project_bundle_id_215, t101.estate_id AS estate_id_216, t0.precarite_id AS precarite_id_217, t0.secteurActivite_id AS secteurActivite_id_218, t0.integrationModule_id AS integrationModule_id_219, t0.precariteCas2_id AS precariteCas2_id_220, t0.program_id AS program_id_221, t0.programCommercial_id AS programCommercial_id_222, t0.programManager_id AS programManager_id_223, t0.justificatif_id AS justificatif_id_224, t225.id AS id_226, t225.numero AS numero_227, t225.dateRealisation AS dateRealisation_228, t225.dateFinValidite AS dateFinValidite_229, t225.etiquetteBilan AS etiquetteBilan_230, t225.createdAt AS createdAt_231, t225.updatedAt AS updatedAt_232, t225.typeJustificatif AS typeJustificatif_233, t225.projet_id AS projet_id_234, t225.offreProjet_id AS offreProjet_id_235, t0.project_bundle_id AS project_bundle_id_236, t0.estate_id AS estate_id_237 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t225 ON t225.projet_id = t0.id WHERE t0.reference IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.end_zni_date AS end_zni_date_88, t52.globalConfigurationHash AS globalConfigurationHash_89, t52.zni AS zni_90, t52.cdp_eligible AS cdp_eligible_91, t52.simulateur_id AS simulateur_id_92, t52.arrete_id AS arrete_id_93, t52.certification_id AS certification_id_94, t52.qualification_id AS qualification_id_95, t52.formConfigEngine_id AS formConfigEngine_id_96, t0.entrepriseUser_id AS entrepriseUser_id_97, t0.particulierUser_id AS particulierUser_id_98, t0.installateurUser_id AS installateurUser_id_99, t0.beUser_id AS beUser_id_100, t101.id AS id_102, t101.type AS type_103, t101.pricingType AS pricingType_104, t101.finalisationRequested AS finalisationRequested_105, t101.finalisationRequestDate AS finalisationRequestDate_106, t101.reference AS reference_107, t101.data AS data_108, t101.cofracData AS cofracData_109, t101.cofracEngineDocumentId AS cofracEngineDocumentId_110, t101.ip AS ip_111, t101.offre_auto_date AS offre_auto_date_112, t101.created_datetime AS created_datetime_113, t101.updated_datetime AS updated_datetime_114, t101.tel AS tel_115, t101.codepostal AS codepostal_116, t101.adresse AS adresse_117, t101.adresse_complement AS adresse_complement_118, t101.ville AS ville_119, t101.delai_souhaite AS delai_souhaite_120, t101.accept_recevoir_offre AS accept_recevoir_offre_121, t101.accept_recommandation AS accept_recommandation_122, t101.acceptLeadPromo AS acceptLeadPromo_123, t101.offre_cumac AS offre_cumac_124, t101.offre_cumac_client AS offre_cumac_client_125, t101.offre_cumac_precarite AS offre_cumac_precarite_126, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_127, t101.cumac AS cumac_128, t101.cumac_AFT AS cumac_AFT_129, t101.total_prime AS total_prime_130, t101.total_prime_AFT AS total_prime_AFT_131, t101.prime_pro AS prime_pro_132, t101.prime_pro_aft AS prime_pro_aft_133, t101.prime_client AS prime_client_134, t101.prime_client_aft AS prime_client_aft_135, t101.cumac_moyenne AS cumac_moyenne_136, t101.taux_actualise AS taux_actualise_137, t101.taux_accumule AS taux_accumule_138, t101.date_debut_chantier AS date_debut_chantier_139, t101.date_demande_offre AS date_demande_offre_140, t101.date_fin_chantier AS date_fin_chantier_141, t101.etat AS etat_142, t101.status AS status_143, t101.date_offre AS date_offre_144, t101.notification_date_chantier AS notification_date_chantier_145, t101.date_retour_conv AS date_retour_conv_146, t101.date_validation_conv AS date_validation_conv_147, t101.date_chantier_renseigne AS date_chantier_renseigne_148, t101.date_paiement AS date_paiement_149, t101.date_all_doc_valid AS date_all_doc_valid_150, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_151, t101.date_envoi_questionnaire AS date_envoi_questionnaire_152, t101.date_edition_questionnaire AS date_edition_questionnaire_153, t101.date_validation_final AS date_validation_final_154, t101.date_annulation AS date_annulation_155, t101.no_click_email_date_chantier AS no_click_email_date_chantier_156, t101.token AS token_157, t101.auto_installation AS auto_installation_158, t101.siret AS siret_159, t101.cancelReason AS cancelReason_160, t101.dateCommande AS dateCommande_161, t101.siteTravaux AS siteTravaux_162, t101.incitation AS incitation_163, t101.qualificationRecordDate AS qualificationRecordDate_164, t101.serviceType AS serviceType_165, t101.debutChantier AS debutChantier_166, t101.finChantier AS finChantier_167, t101.initiateCDP AS initiateCDP_168, t101.cdp AS cdp_169, t101.date_last_envoi_convention AS date_last_envoi_convention_170, t101.programStep AS programStep_171, t101.devisRestAPayer AS devisRestAPayer_172, t101.pricingMandatClassique AS pricingMandatClassique_173, t101.pricingMandatPreca AS pricingMandatPreca_174, t101.isCOFRAC AS isCOFRAC_175, t101.applicationFeesPrice AS applicationFeesPrice_176, t101.attributes AS attributes_177, t101.exclusive AS exclusive_178, t101.engineDocumentId AS engineDocumentId_179, t101.adresseTravaux AS adresseTravaux_180, t101.adresseTravauxCommentaire AS adresseTravauxCommentaire_181, t101.batchOffreProjet_id AS batchOffreProjet_id_182, t101.entrepriseUser_id AS entrepriseUser_id_183, t101.installateurUser_id AS installateurUser_id_184, t101.beUser_id AS beUser_id_185, t101.entrepriseUserContact_id AS entrepriseUserContact_id_186, t101.particulierUserContact_id AS particulierUserContact_id_187, t101.signataireEntreprise_id AS signataireEntreprise_id_188, t101.signataireInstallateur_id AS signataireInstallateur_id_189, t101.installateurUserContact_id AS installateurUserContact_id_190, t101.projet_id AS projet_id_191, t101.precariteCas2_id AS precariteCas2_id_192, t101.precarite_id AS precarite_id_193, t101.state_id AS state_id_194, t101.oblige_id AS oblige_id_195, t101.secteurActivite_id AS secteurActivite_id_196, t101.factureDetail_id AS factureDetail_id_197, t101.offreStatus_id AS offreStatus_id_198, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_199, t101.identiteInstallateur_id AS identiteInstallateur_id_200, t101.operation_id AS operation_id_201, t101.particulierUser_id AS particulierUser_id_202, t101.qualificationRecord_id AS qualificationRecord_id_203, t101.sousTraitant_id AS sousTraitant_id_204, t101.program_id AS program_id_205, t101.programCommercial_id AS programCommercial_id_206, t101.programManager_id AS programManager_id_207, t101.signatureAuto_id AS signatureAuto_id_208, t101.wasteCenter_id AS wasteCenter_id_209, t101.waste_id AS waste_id_210, t101.programAuto_id AS programAuto_id_211, t101.justificatif_id AS justificatif_id_212, t101.cappingRule_id AS cappingRule_id_213, t101.projectOwner_id AS projectOwner_id_214, t101.project_bundle_id AS project_bundle_id_215, t101.estate_id AS estate_id_216, t0.precarite_id AS precarite_id_217, t0.secteurActivite_id AS secteurActivite_id_218, t0.integrationModule_id AS integrationModule_id_219, t0.precariteCas2_id AS precariteCas2_id_220, t0.program_id AS program_id_221, t0.programCommercial_id AS programCommercial_id_222, t0.programManager_id AS programManager_id_223, t0.justificatif_id AS justificatif_id_224, t225.id AS id_226, t225.numero AS numero_227, t225.dateRealisation AS dateRealisation_228, t225.dateFinValidite AS dateFinValidite_229, t225.etiquetteBilan AS etiquetteBilan_230, t225.createdAt AS createdAt_231, t225.updatedAt AS updatedAt_232, t225.typeJustificatif AS typeJustificatif_233, t225.projet_id AS projet_id_234, t225.offreProjet_id AS offreProjet_id_235, t0.project_bundle_id AS project_bundle_id_236, t0.estate_id AS estate_id_237 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t101 ON t101.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t225 ON t225.projet_id = t0.id WHERE t0.reference IS NULL LIMIT 1;
7	0.94 ms	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 Parameters: [`"1234"`] View formatted query View runnable query Explain query 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;
8	0.72 ms	SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1 Parameters: [`"p"`] View formatted query View runnable query Explain query 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;
9	0.81 ms	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 Parameters: [`"1234"`] View formatted query View runnable query Explain query 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;
10	20.21 ms	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 Parameters: [`"display_logo_in_header" 2 "Consoneo\Bundle\UserBundle\Entity\Oblige"`] View formatted query View runnable query Explain query 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` = 'display_logo_in_header' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
read	doctrine.dbal.read_connection
stats	doctrine.dbal.stats_connection
qrdecode	doctrine.dbal.qrdecode_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
read	doctrine.orm.read_entity_manager
stats	doctrine.orm.stats_entity_manager
qrdecode	doctrine.orm.qrdecode_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	3
Consoneo\Bundle\UserBundle\Entity\TeteReseau	1
Consoneo\Bundle\WorkflowBundle\Entity\Branding	1
Consoneo\Bundle\UserBundle\Entity\Oblige	1
Consoneo\Bundle\ObligeBundle\Entity\MprConfig	1

read entity manager

Class	Amount of managed objects

stats entity manager

Class	Amount of managed objects

qrdecode entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract	No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic	No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch	No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeUser	No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring	No errors.
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Branding	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Lead	No errors.
C2eCoreBundle\Entity\Certificall\Certilink	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige	No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PricingGroup	No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule	No errors.
Consoneo\Bundle\UserBundle\Entity\ApplicationFees	No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfigurationRecord	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ConfigurationPaymentRecord	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Mediateur	No errors.
Consoneo\Bundle\ObligeBundle\Entity\MprConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\Mandataire	No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige	No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeBlockedTimetable	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\CoupDePouce	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto	No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule	No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Product	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Projet	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Secteur	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Categorie	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationSpecifique	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Certification	No errors.
Consoneo\Bundle\UserBundle\Entity\Qualification	No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser	No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser	No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser	No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUserContact	No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact	No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireEntreprise	No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireInstallateur	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUserContact	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\PrecariteCas2	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Precarite	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	No errors.
Consoneo\Bundle\ObligeBundle\Entity\FactureDetail	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus	No errors.
Consoneo\Bundle\UserBundle\Entity\Identite	No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord	No errors.
Consoneo\Bundle\UserBundle\Entity\SousTraitantRGE	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Program	No errors.
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto	No errors.
Consoneo\Bundle\ObligeBundle\Entity\WasteCenter	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Waste	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif	No errors.
Consoneo\Bundle\UserBundle\Entity\ProjectOwner	No errors.
C2eCoreBundle\Entity\Internal\ProjectBundle	No errors.
C2eCoreBundle\Entity\Internal\Estate	No errors.
Consoneo\Bundle\ObligeBundle\Entity\JustificatifPerformanceEnergetique	No errors.

read entity manager

Class	Mapping errors
Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration	No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class	Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode	No errors.

Symfony Profiler

GET https://preprod-orion.dossier-c2e.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DConsoneo%255CBundle%255CPublicBundle%255CController%255CDefau…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

read entity manager

stats entity manager

qrdecode entity manager

Entities Mapping

default entity manager

read entity manager

stats entity manager

qrdecode entity manager