| 1 |
4.26 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
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 = 'm71k' LIMIT 1;
|
| 2 |
2.20 ms |
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 |
3.28 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 = ?
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 |
2.71 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 = ?
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 |
0.86 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
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 = 'm71k' LIMIT 1;
|
| 6 |
12.09 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.ip AS ip_110, t101.offre_auto_date AS offre_auto_date_111, t101.created_datetime AS created_datetime_112, t101.updated_datetime AS updated_datetime_113, t101.tel AS tel_114, t101.codepostal AS codepostal_115, t101.adresse AS adresse_116, t101.adresse_complement AS adresse_complement_117, t101.ville AS ville_118, t101.delai_souhaite AS delai_souhaite_119, t101.accept_recevoir_offre AS accept_recevoir_offre_120, t101.accept_recommandation AS accept_recommandation_121, t101.acceptLeadPromo AS acceptLeadPromo_122, t101.offre_cumac AS offre_cumac_123, t101.offre_cumac_client AS offre_cumac_client_124, t101.offre_cumac_precarite AS offre_cumac_precarite_125, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_126, t101.cumac AS cumac_127, t101.cumac_AFT AS cumac_AFT_128, t101.total_prime AS total_prime_129, t101.total_prime_AFT AS total_prime_AFT_130, t101.prime_pro AS prime_pro_131, t101.prime_pro_aft AS prime_pro_aft_132, t101.prime_client AS prime_client_133, t101.prime_client_aft AS prime_client_aft_134, t101.cumac_moyenne AS cumac_moyenne_135, t101.taux_actualise AS taux_actualise_136, t101.taux_accumule AS taux_accumule_137, t101.date_debut_chantier AS date_debut_chantier_138, t101.date_demande_offre AS date_demande_offre_139, t101.date_fin_chantier AS date_fin_chantier_140, t101.etat AS etat_141, t101.status AS status_142, t101.date_offre AS date_offre_143, t101.notification_date_chantier AS notification_date_chantier_144, t101.date_retour_conv AS date_retour_conv_145, t101.date_validation_conv AS date_validation_conv_146, t101.date_chantier_renseigne AS date_chantier_renseigne_147, t101.date_paiement AS date_paiement_148, t101.date_all_doc_valid AS date_all_doc_valid_149, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_150, t101.date_envoi_questionnaire AS date_envoi_questionnaire_151, t101.date_edition_questionnaire AS date_edition_questionnaire_152, t101.date_validation_final AS date_validation_final_153, t101.date_annulation AS date_annulation_154, t101.no_click_email_date_chantier AS no_click_email_date_chantier_155, t101.token AS token_156, t101.auto_installation AS auto_installation_157, t101.siret AS siret_158, t101.cancelReason AS cancelReason_159, t101.dateCommande AS dateCommande_160, t101.siteTravaux AS siteTravaux_161, t101.incitation AS incitation_162, t101.qualificationRecordDate AS qualificationRecordDate_163, t101.serviceType AS serviceType_164, t101.debutChantier AS debutChantier_165, t101.finChantier AS finChantier_166, t101.initiateCDP AS initiateCDP_167, t101.cdp AS cdp_168, t101.date_last_envoi_convention AS date_last_envoi_convention_169, t101.programStep AS programStep_170, t101.devisRestAPayer AS devisRestAPayer_171, t101.pricingMandatClassique AS pricingMandatClassique_172, t101.pricingMandatPreca AS pricingMandatPreca_173, t101.isCOFRAC AS isCOFRAC_174, t101.applicationFeesPrice AS applicationFeesPrice_175, t101.attributes AS attributes_176, t101.exclusive AS exclusive_177, t101.engineDocumentId AS engineDocumentId_178, t101.batchOffreProjet_id AS batchOffreProjet_id_179, t101.entrepriseUser_id AS entrepriseUser_id_180, t101.installateurUser_id AS installateurUser_id_181, t101.beUser_id AS beUser_id_182, t101.entrepriseUserContact_id AS entrepriseUserContact_id_183, t101.particulierUserContact_id AS particulierUserContact_id_184, t101.signataireEntreprise_id AS signataireEntreprise_id_185, t101.signataireInstallateur_id AS signataireInstallateur_id_186, t101.installateurUserContact_id AS installateurUserContact_id_187, t101.projet_id AS projet_id_188, t101.precariteCas2_id AS precariteCas2_id_189, t101.precarite_id AS precarite_id_190, t101.state_id AS state_id_191, t101.oblige_id AS oblige_id_192, t101.secteurActivite_id AS secteurActivite_id_193, t101.factureDetail_id AS factureDetail_id_194, t101.offreStatus_id AS offreStatus_id_195, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_196, t101.identiteInstallateur_id AS identiteInstallateur_id_197, t101.operation_id AS operation_id_198, t101.particulierUser_id AS particulierUser_id_199, t101.qualificationRecord_id AS qualificationRecord_id_200, t101.sousTraitant_id AS sousTraitant_id_201, t101.program_id AS program_id_202, t101.programCommercial_id AS programCommercial_id_203, t101.programManager_id AS programManager_id_204, t101.signatureAuto_id AS signatureAuto_id_205, t101.wasteCenter_id AS wasteCenter_id_206, t101.waste_id AS waste_id_207, t101.programAuto_id AS programAuto_id_208, t101.justificatif_id AS justificatif_id_209, t101.cappingRule_id AS cappingRule_id_210, t101.projectOwner_id AS projectOwner_id_211, t101.project_bundle_id AS project_bundle_id_212, t101.estate_id AS estate_id_213, t0.precarite_id AS precarite_id_214, t0.secteurActivite_id AS secteurActivite_id_215, t0.integrationModule_id AS integrationModule_id_216, t0.precariteCas2_id AS precariteCas2_id_217, t0.program_id AS program_id_218, t0.programCommercial_id AS programCommercial_id_219, t0.programManager_id AS programManager_id_220, t0.justificatif_id AS justificatif_id_221, t222.id AS id_223, t222.numero AS numero_224, t222.dateRealisation AS dateRealisation_225, t222.dateFinValidite AS dateFinValidite_226, t222.etiquetteBilan AS etiquetteBilan_227, t222.createdAt AS createdAt_228, t222.updatedAt AS updatedAt_229, t222.typeJustificatif AS typeJustificatif_230, t222.projet_id AS projet_id_231, t222.offreProjet_id AS offreProjet_id_232, t0.project_bundle_id AS project_bundle_id_233, t0.estate_id AS estate_id_234 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 t222 ON t222.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.ip AS ip_110,
t101.offre_auto_date AS offre_auto_date_111,
t101.created_datetime AS created_datetime_112,
t101.updated_datetime AS updated_datetime_113,
t101.tel AS tel_114,
t101.codepostal AS codepostal_115,
t101.adresse AS adresse_116,
t101.adresse_complement AS adresse_complement_117,
t101.ville AS ville_118,
t101.delai_souhaite AS delai_souhaite_119,
t101.accept_recevoir_offre AS accept_recevoir_offre_120,
t101.accept_recommandation AS accept_recommandation_121,
t101.acceptLeadPromo AS acceptLeadPromo_122,
t101.offre_cumac AS offre_cumac_123,
t101.offre_cumac_client AS offre_cumac_client_124,
t101.offre_cumac_precarite AS offre_cumac_precarite_125,
t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_126,
t101.cumac AS cumac_127,
t101.cumac_AFT AS cumac_AFT_128,
t101.total_prime AS total_prime_129,
t101.total_prime_AFT AS total_prime_AFT_130,
t101.prime_pro AS prime_pro_131,
t101.prime_pro_aft AS prime_pro_aft_132,
t101.prime_client AS prime_client_133,
t101.prime_client_aft AS prime_client_aft_134,
t101.cumac_moyenne AS cumac_moyenne_135,
t101.taux_actualise AS taux_actualise_136,
t101.taux_accumule AS taux_accumule_137,
t101.date_debut_chantier AS date_debut_chantier_138,
t101.date_demande_offre AS date_demande_offre_139,
t101.date_fin_chantier AS date_fin_chantier_140,
t101.etat AS etat_141,
t101.status AS status_142,
t101.date_offre AS date_offre_143,
t101.notification_date_chantier AS notification_date_chantier_144,
t101.date_retour_conv AS date_retour_conv_145,
t101.date_validation_conv AS date_validation_conv_146,
t101.date_chantier_renseigne AS date_chantier_renseigne_147,
t101.date_paiement AS date_paiement_148,
t101.date_all_doc_valid AS date_all_doc_valid_149,
t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_150,
t101.date_envoi_questionnaire AS date_envoi_questionnaire_151,
t101.date_edition_questionnaire AS date_edition_questionnaire_152,
t101.date_validation_final AS date_validation_final_153,
t101.date_annulation AS date_annulation_154,
t101.no_click_email_date_chantier AS no_click_email_date_chantier_155,
t101.token AS token_156,
t101.auto_installation AS auto_installation_157,
t101.siret AS siret_158,
t101.cancelReason AS cancelReason_159,
t101.dateCommande AS dateCommande_160,
t101.siteTravaux AS siteTravaux_161,
t101.incitation AS incitation_162,
t101.qualificationRecordDate AS qualificationRecordDate_163,
t101.serviceType AS serviceType_164,
t101.debutChantier AS debutChantier_165,
t101.finChantier AS finChantier_166,
t101.initiateCDP AS initiateCDP_167,
t101.cdp AS cdp_168,
t101.date_last_envoi_convention AS date_last_envoi_convention_169,
t101.programStep AS programStep_170,
t101.devisRestAPayer AS devisRestAPayer_171,
t101.pricingMandatClassique AS pricingMandatClassique_172,
t101.pricingMandatPreca AS pricingMandatPreca_173,
t101.isCOFRAC AS isCOFRAC_174,
t101.applicationFeesPrice AS applicationFeesPrice_175,
t101.attributes AS attributes_176,
t101.exclusive AS exclusive_177,
t101.engineDocumentId AS engineDocumentId_178,
t101.batchOffreProjet_id AS batchOffreProjet_id_179,
t101.entrepriseUser_id AS entrepriseUser_id_180,
t101.installateurUser_id AS installateurUser_id_181,
t101.beUser_id AS beUser_id_182,
t101.entrepriseUserContact_id AS entrepriseUserContact_id_183,
t101.particulierUserContact_id AS particulierUserContact_id_184,
t101.signataireEntreprise_id AS signataireEntreprise_id_185,
t101.signataireInstallateur_id AS signataireInstallateur_id_186,
t101.installateurUserContact_id AS installateurUserContact_id_187,
t101.projet_id AS projet_id_188,
t101.precariteCas2_id AS precariteCas2_id_189,
t101.precarite_id AS precarite_id_190,
t101.state_id AS state_id_191,
t101.oblige_id AS oblige_id_192,
t101.secteurActivite_id AS secteurActivite_id_193,
t101.factureDetail_id AS factureDetail_id_194,
t101.offreStatus_id AS offreStatus_id_195,
t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_196,
t101.identiteInstallateur_id AS identiteInstallateur_id_197,
t101.operation_id AS operation_id_198,
t101.particulierUser_id AS particulierUser_id_199,
t101.qualificationRecord_id AS qualificationRecord_id_200,
t101.sousTraitant_id AS sousTraitant_id_201,
t101.program_id AS program_id_202,
t101.programCommercial_id AS programCommercial_id_203,
t101.programManager_id AS programManager_id_204,
t101.signatureAuto_id AS signatureAuto_id_205,
t101.wasteCenter_id AS wasteCenter_id_206,
t101.waste_id AS waste_id_207,
t101.programAuto_id AS programAuto_id_208,
t101.justificatif_id AS justificatif_id_209,
t101.cappingRule_id AS cappingRule_id_210,
t101.projectOwner_id AS projectOwner_id_211,
t101.project_bundle_id AS project_bundle_id_212,
t101.estate_id AS estate_id_213,
t0.precarite_id AS precarite_id_214,
t0.secteurActivite_id AS secteurActivite_id_215,
t0.integrationModule_id AS integrationModule_id_216,
t0.precariteCas2_id AS precariteCas2_id_217,
t0.program_id AS program_id_218,
t0.programCommercial_id AS programCommercial_id_219,
t0.programManager_id AS programManager_id_220,
t0.justificatif_id AS justificatif_id_221,
t222.id AS id_223,
t222.numero AS numero_224,
t222.dateRealisation AS dateRealisation_225,
t222.dateFinValidite AS dateFinValidite_226,
t222.etiquetteBilan AS etiquetteBilan_227,
t222.createdAt AS createdAt_228,
t222.updatedAt AS updatedAt_229,
t222.typeJustificatif AS typeJustificatif_230,
t222.projet_id AS projet_id_231,
t222.offreProjet_id AS offreProjet_id_232,
t0.project_bundle_id AS project_bundle_id_233,
t0.estate_id AS estate_id_234
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 t222 ON t222.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.ip AS ip_110, t101.offre_auto_date AS offre_auto_date_111, t101.created_datetime AS created_datetime_112, t101.updated_datetime AS updated_datetime_113, t101.tel AS tel_114, t101.codepostal AS codepostal_115, t101.adresse AS adresse_116, t101.adresse_complement AS adresse_complement_117, t101.ville AS ville_118, t101.delai_souhaite AS delai_souhaite_119, t101.accept_recevoir_offre AS accept_recevoir_offre_120, t101.accept_recommandation AS accept_recommandation_121, t101.acceptLeadPromo AS acceptLeadPromo_122, t101.offre_cumac AS offre_cumac_123, t101.offre_cumac_client AS offre_cumac_client_124, t101.offre_cumac_precarite AS offre_cumac_precarite_125, t101.offre_cumac_client_precarite AS offre_cumac_client_precarite_126, t101.cumac AS cumac_127, t101.cumac_AFT AS cumac_AFT_128, t101.total_prime AS total_prime_129, t101.total_prime_AFT AS total_prime_AFT_130, t101.prime_pro AS prime_pro_131, t101.prime_pro_aft AS prime_pro_aft_132, t101.prime_client AS prime_client_133, t101.prime_client_aft AS prime_client_aft_134, t101.cumac_moyenne AS cumac_moyenne_135, t101.taux_actualise AS taux_actualise_136, t101.taux_accumule AS taux_accumule_137, t101.date_debut_chantier AS date_debut_chantier_138, t101.date_demande_offre AS date_demande_offre_139, t101.date_fin_chantier AS date_fin_chantier_140, t101.etat AS etat_141, t101.status AS status_142, t101.date_offre AS date_offre_143, t101.notification_date_chantier AS notification_date_chantier_144, t101.date_retour_conv AS date_retour_conv_145, t101.date_validation_conv AS date_validation_conv_146, t101.date_chantier_renseigne AS date_chantier_renseigne_147, t101.date_paiement AS date_paiement_148, t101.date_all_doc_valid AS date_all_doc_valid_149, t101.date_fin_chantier_repousse AS date_fin_chantier_repousse_150, t101.date_envoi_questionnaire AS date_envoi_questionnaire_151, t101.date_edition_questionnaire AS date_edition_questionnaire_152, t101.date_validation_final AS date_validation_final_153, t101.date_annulation AS date_annulation_154, t101.no_click_email_date_chantier AS no_click_email_date_chantier_155, t101.token AS token_156, t101.auto_installation AS auto_installation_157, t101.siret AS siret_158, t101.cancelReason AS cancelReason_159, t101.dateCommande AS dateCommande_160, t101.siteTravaux AS siteTravaux_161, t101.incitation AS incitation_162, t101.qualificationRecordDate AS qualificationRecordDate_163, t101.serviceType AS serviceType_164, t101.debutChantier AS debutChantier_165, t101.finChantier AS finChantier_166, t101.initiateCDP AS initiateCDP_167, t101.cdp AS cdp_168, t101.date_last_envoi_convention AS date_last_envoi_convention_169, t101.programStep AS programStep_170, t101.devisRestAPayer AS devisRestAPayer_171, t101.pricingMandatClassique AS pricingMandatClassique_172, t101.pricingMandatPreca AS pricingMandatPreca_173, t101.isCOFRAC AS isCOFRAC_174, t101.applicationFeesPrice AS applicationFeesPrice_175, t101.attributes AS attributes_176, t101.exclusive AS exclusive_177, t101.engineDocumentId AS engineDocumentId_178, t101.batchOffreProjet_id AS batchOffreProjet_id_179, t101.entrepriseUser_id AS entrepriseUser_id_180, t101.installateurUser_id AS installateurUser_id_181, t101.beUser_id AS beUser_id_182, t101.entrepriseUserContact_id AS entrepriseUserContact_id_183, t101.particulierUserContact_id AS particulierUserContact_id_184, t101.signataireEntreprise_id AS signataireEntreprise_id_185, t101.signataireInstallateur_id AS signataireInstallateur_id_186, t101.installateurUserContact_id AS installateurUserContact_id_187, t101.projet_id AS projet_id_188, t101.precariteCas2_id AS precariteCas2_id_189, t101.precarite_id AS precarite_id_190, t101.state_id AS state_id_191, t101.oblige_id AS oblige_id_192, t101.secteurActivite_id AS secteurActivite_id_193, t101.factureDetail_id AS factureDetail_id_194, t101.offreStatus_id AS offreStatus_id_195, t101.identiteBeneficiaire_id AS identiteBeneficiaire_id_196, t101.identiteInstallateur_id AS identiteInstallateur_id_197, t101.operation_id AS operation_id_198, t101.particulierUser_id AS particulierUser_id_199, t101.qualificationRecord_id AS qualificationRecord_id_200, t101.sousTraitant_id AS sousTraitant_id_201, t101.program_id AS program_id_202, t101.programCommercial_id AS programCommercial_id_203, t101.programManager_id AS programManager_id_204, t101.signatureAuto_id AS signatureAuto_id_205, t101.wasteCenter_id AS wasteCenter_id_206, t101.waste_id AS waste_id_207, t101.programAuto_id AS programAuto_id_208, t101.justificatif_id AS justificatif_id_209, t101.cappingRule_id AS cappingRule_id_210, t101.projectOwner_id AS projectOwner_id_211, t101.project_bundle_id AS project_bundle_id_212, t101.estate_id AS estate_id_213, t0.precarite_id AS precarite_id_214, t0.secteurActivite_id AS secteurActivite_id_215, t0.integrationModule_id AS integrationModule_id_216, t0.precariteCas2_id AS precariteCas2_id_217, t0.program_id AS program_id_218, t0.programCommercial_id AS programCommercial_id_219, t0.programManager_id AS programManager_id_220, t0.justificatif_id AS justificatif_id_221, t222.id AS id_223, t222.numero AS numero_224, t222.dateRealisation AS dateRealisation_225, t222.dateFinValidite AS dateFinValidite_226, t222.etiquetteBilan AS etiquetteBilan_227, t222.createdAt AS createdAt_228, t222.updatedAt AS updatedAt_229, t222.typeJustificatif AS typeJustificatif_230, t222.projet_id AS projet_id_231, t222.offreProjet_id AS offreProjet_id_232, t0.project_bundle_id AS project_bundle_id_233, t0.estate_id AS estate_id_234 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 t222 ON t222.projet_id = t0.id WHERE t0.reference IS NULL LIMIT 1;
|
| 7 |
1.07 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
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 = 'm71k' LIMIT 1;
|
| 8 |
0.88 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 = ?
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;
|
| 9 |
1.41 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 = ?
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;
|
| 10 |
1.00 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"
]
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;
|
