Symfony Profiler

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 = 'Tjp3' LIMIT 1;

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 = 'i' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.pricingType AS pricingType_3,
  t0.finalisationRequested AS finalisationRequested_4,
  t0.finalisationRequestDate AS finalisationRequestDate_5,
  t0.reference AS reference_6,
  t0.data AS data_7,
  t0.cofracData AS cofracData_8,
  t0.ip AS ip_9,
  t0.offre_auto_date AS offre_auto_date_10,
  t0.created_datetime AS created_datetime_11,
  t0.updated_datetime AS updated_datetime_12,
  t0.tel AS tel_13,
  t0.codepostal AS codepostal_14,
  t0.adresse AS adresse_15,
  t0.adresse_complement AS adresse_complement_16,
  t0.ville AS ville_17,
  t0.delai_souhaite AS delai_souhaite_18,
  t0.accept_recevoir_offre AS accept_recevoir_offre_19,
  t0.accept_recommandation AS accept_recommandation_20,
  t0.acceptLeadPromo AS acceptLeadPromo_21,
  t0.offre_cumac AS offre_cumac_22,
  t0.offre_cumac_client AS offre_cumac_client_23,
  t0.offre_cumac_precarite AS offre_cumac_precarite_24,
  t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25,
  t0.cumac AS cumac_26,
  t0.cumac_AFT AS cumac_AFT_27,
  t0.total_prime AS total_prime_28,
  t0.total_prime_AFT AS total_prime_AFT_29,
  t0.prime_pro AS prime_pro_30,
  t0.prime_pro_aft AS prime_pro_aft_31,
  t0.prime_client AS prime_client_32,
  t0.prime_client_aft AS prime_client_aft_33,
  t0.cumac_moyenne AS cumac_moyenne_34,
  t0.taux_actualise AS taux_actualise_35,
  t0.taux_accumule AS taux_accumule_36,
  t0.date_debut_chantier AS date_debut_chantier_37,
  t0.date_demande_offre AS date_demande_offre_38,
  t0.date_fin_chantier AS date_fin_chantier_39,
  t0.etat AS etat_40,
  t0.status AS status_41,
  t0.date_offre AS date_offre_42,
  t0.notification_date_chantier AS notification_date_chantier_43,
  t0.date_retour_conv AS date_retour_conv_44,
  t0.date_validation_conv AS date_validation_conv_45,
  t0.date_chantier_renseigne AS date_chantier_renseigne_46,
  t0.date_paiement AS date_paiement_47,
  t0.date_all_doc_valid AS date_all_doc_valid_48,
  t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49,
  t0.date_envoi_questionnaire AS date_envoi_questionnaire_50,
  t0.date_edition_questionnaire AS date_edition_questionnaire_51,
  t0.date_validation_final AS date_validation_final_52,
  t0.date_annulation AS date_annulation_53,
  t0.no_click_email_date_chantier AS no_click_email_date_chantier_54,
  t0.token AS token_55,
  t0.auto_installation AS auto_installation_56,
  t0.siret AS siret_57,
  t0.cancelReason AS cancelReason_58,
  t0.dateCommande AS dateCommande_59,
  t0.siteTravaux AS siteTravaux_60,
  t0.incitation AS incitation_61,
  t0.qualificationRecordDate AS qualificationRecordDate_62,
  t0.serviceType AS serviceType_63,
  t0.debutChantier AS debutChantier_64,
  t0.finChantier AS finChantier_65,
  t0.initiateCDP AS initiateCDP_66,
  t0.cdp AS cdp_67,
  t0.date_last_envoi_convention AS date_last_envoi_convention_68,
  t0.programStep AS programStep_69,
  t0.devisRestAPayer AS devisRestAPayer_70,
  t0.pricingMandatClassique AS pricingMandatClassique_71,
  t0.pricingMandatPreca AS pricingMandatPreca_72,
  t0.isCOFRAC AS isCOFRAC_73,
  t0.applicationFeesPrice AS applicationFeesPrice_74,
  t0.attributes AS attributes_75,
  t0.exclusive AS exclusive_76,
  t0.engineDocumentId AS engineDocumentId_77,
  t0.batchOffreProjet_id AS batchOffreProjet_id_78,
  t0.entrepriseUser_id AS entrepriseUser_id_79,
  t0.installateurUser_id AS installateurUser_id_80,
  t0.beUser_id AS beUser_id_81,
  t0.entrepriseUserContact_id AS entrepriseUserContact_id_82,
  t0.particulierUserContact_id AS particulierUserContact_id_83,
  t0.signataireEntreprise_id AS signataireEntreprise_id_84,
  t0.signataireInstallateur_id AS signataireInstallateur_id_85,
  t0.installateurUserContact_id AS installateurUserContact_id_86,
  t0.projet_id AS projet_id_87,
  t0.precariteCas2_id AS precariteCas2_id_88,
  t0.precarite_id AS precarite_id_89,
  t0.state_id AS state_id_90,
  t91.id AS id_92,
  t91.created_datetime AS created_datetime_93,
  t91.convention AS convention_94,
  t91.aft AS aft_95,
  t91.facture AS facture_96,
  t91.beneficiaire AS beneficiaire_97,
  t91.installateur AS installateur_98,
  t91.doc_obligatoire AS doc_obligatoire_99,
  t91.coherence_dossier AS coherence_dossier_100,
  t91.offre_id AS offre_id_101,
  t0.oblige_id AS oblige_id_102,
  t0.secteurActivite_id AS secteurActivite_id_103,
  t0.factureDetail_id AS factureDetail_id_104,
  t105.id AS id_106,
  t105.reference AS reference_107,
  t105.type AS type_108,
  t105.result AS result_109,
  t105.errors AS errors_110,
  t105.message AS message_111,
  t105.created_datetime AS created_datetime_112,
  t105.integrationModule_id AS integrationModule_id_113,
  t105.offre_id AS offre_id_114,
  t0.offreStatus_id AS offreStatus_id_115,
  t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116,
  t0.identiteInstallateur_id AS identiteInstallateur_id_117,
  t0.operation_id AS operation_id_118,
  t0.particulierUser_id AS particulierUser_id_119,
  t0.qualificationRecord_id AS qualificationRecord_id_120,
  t0.sousTraitant_id AS sousTraitant_id_121,
  t0.program_id AS program_id_122,
  t0.programCommercial_id AS programCommercial_id_123,
  t0.programManager_id AS programManager_id_124,
  t0.signatureAuto_id AS signatureAuto_id_125,
  t0.wasteCenter_id AS wasteCenter_id_126,
  t0.waste_id AS waste_id_127,
  t0.programAuto_id AS programAuto_id_128,
  t0.justificatif_id AS justificatif_id_129,
  t0.cappingRule_id AS cappingRule_id_130,
  t131.id AS id_132,
  t131.mprUuid AS mprUuid_133,
  t131.mprReference AS mprReference_134,
  t131.paymentDate AS paymentDate_135,
  t131.invoiceReference AS invoiceReference_136,
  t131.invoiceDate AS invoiceDate_137,
  t131.amount AS amount_138,
  t131.archive AS archive_139,
  t131.step AS step_140,
  t131.offreProjet_id AS offreProjet_id_141,
  t131.batchBankTransfer_id AS batchBankTransfer_id_142,
  t131.installateur_id AS installateur_id_143,
  t131.particulierUser_id AS particulierUser_id_144,
  t145.id AS id_146,
  t145.numero AS numero_147,
  t145.dateRealisation AS dateRealisation_148,
  t145.dateFinValidite AS dateFinValidite_149,
  t145.etiquetteBilan AS etiquetteBilan_150,
  t145.createdAt AS createdAt_151,
  t145.updatedAt AS updatedAt_152,
  t145.typeJustificatif AS typeJustificatif_153,
  t145.projet_id AS projet_id_154,
  t145.offreProjet_id AS offreProjet_id_155,
  t0.projectOwner_id AS projectOwner_id_156,
  t0.project_bundle_id AS project_bundle_id_157,
  t0.estate_id AS estate_id_158,
  t159.id AS id_160,
  t159.`value` AS value_161,
  t159.offreProjet_id AS offreProjet_id_162,
  t159.operation_id AS operation_id_163,
  t159.oblige_id AS oblige_id_164
FROM
  OffreProjet t0
  LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id
  LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id
  LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id
  LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id
  LEFT JOIN Recensement t159 ON t159.offreProjet_id = t0.id
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.offreProjet_id = t0.id WHERE t0.token = 'rJQCEnl5IIkpeaQ4C8XkP2rOTpSLLimAVnFDVpYEt0Q' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.dataSimulation AS dataSimulation_2,
  t0.dataAH AS dataAH_3,
  t0.cumac AS cumac_4,
  t0.tauxActualise AS tauxActualise_5,
  t0.tauxAccumule AS tauxAccumule_6,
  t0.cumacMoyenne AS cumacMoyenne_7,
  t0.initiateCDP AS initiateCDP_8,
  t0.cofracData AS cofracData_9,
  t0.operation_id AS operation_id_10,
  t0.projet_id AS projet_id_11,
  t0.program_id AS program_id_12,
  t0.offreProjet_id AS offreProjet_id_13
FROM
  OperationRecord t0
WHERE
  t0.offreProjet_id = ?

SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = 453208;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.version AS version_3,
  t0.code AS code_4,
  t0.duree AS duree_5,
  t0.auto_installation AS auto_installation_6,
  t0.conditions AS conditions_7,
  t0.conditionsRaw AS conditionsRaw_8,
  t0.conditionsFormater AS conditionsFormater_9,
  t0.documents_requis AS documents_requis_10,
  t0.nombre_documents AS nombre_documents_11,
  t0.nombre_conditions AS nombre_conditions_12,
  t0.question_details_type AS question_details_type_13,
  t0.question_details_value AS question_details_value_14,
  t0.periode AS periode_15,
  t0.informationTechnique AS informationTechnique_16,
  t0.informationTechniqueRaw AS informationTechniqueRaw_17,
  t0.informationTechniqueFormater AS informationTechniqueFormater_18,
  t0.informationDocSupplementaire AS informationDocSupplementaire_19,
  t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20,
  t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21,
  t0.informationfacture AS informationfacture_22,
  t0.informationfactureRaw AS informationfactureRaw_23,
  t0.informationfactureFormater AS informationfactureFormater_24,
  t0.informationfacture2 AS informationfacture2_25,
  t0.informationfacture2Raw AS informationfacture2Raw_26,
  t0.informationfacture2Formater AS informationfacture2Formater_27,
  t0.nbMateriau AS nbMateriau_28,
  t0.materiauSubtitle AS materiauSubtitle_29,
  t0.materiauTitle AS materiauTitle_30,
  t0.textForm AS textForm_31,
  t0.private AS private_32,
  t0.campagne AS campagne_33,
  t0.special AS special_34,
  t0.abrogation_datetime AS abrogation_datetime_35,
  t0.end_zni_date AS end_zni_date_36,
  t0.globalConfigurationHash AS globalConfigurationHash_37,
  t0.zni AS zni_38,
  t0.cdp_eligible AS cdp_eligible_39,
  t0.simulateur_id AS simulateur_id_40,
  t0.arrete_id AS arrete_id_41,
  t0.certification_id AS certification_id_42,
  t0.qualification_id AS qualification_id_43,
  t0.formConfigEngine_id AS formConfigEngine_id_44
FROM
  Operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 FROM Operation t0 WHERE t0.id = 871;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.nom AS nom_3,
  t0.nom_cd AS nom_cd_4,
  t0.cdiscount AS cdiscount_5,
  t0.pretty_name AS pretty_name_6,
  t0.status AS status_7,
  t0.slug AS slug_8,
  t0.form_lead_id AS form_lead_id_9,
  t0.active_operation_id AS active_operation_id_10,
  t11.id AS id_12,
  t11.nom AS nom_13,
  t11.version AS version_14,
  t11.code AS code_15,
  t11.duree AS duree_16,
  t11.auto_installation AS auto_installation_17,
  t11.conditions AS conditions_18,
  t11.conditionsRaw AS conditionsRaw_19,
  t11.conditionsFormater AS conditionsFormater_20,
  t11.documents_requis AS documents_requis_21,
  t11.nombre_documents AS nombre_documents_22,
  t11.nombre_conditions AS nombre_conditions_23,
  t11.question_details_type AS question_details_type_24,
  t11.question_details_value AS question_details_value_25,
  t11.periode AS periode_26,
  t11.informationTechnique AS informationTechnique_27,
  t11.informationTechniqueRaw AS informationTechniqueRaw_28,
  t11.informationTechniqueFormater AS informationTechniqueFormater_29,
  t11.informationDocSupplementaire AS informationDocSupplementaire_30,
  t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31,
  t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32,
  t11.informationfacture AS informationfacture_33,
  t11.informationfactureRaw AS informationfactureRaw_34,
  t11.informationfactureFormater AS informationfactureFormater_35,
  t11.informationfacture2 AS informationfacture2_36,
  t11.informationfacture2Raw AS informationfacture2Raw_37,
  t11.informationfacture2Formater AS informationfacture2Formater_38,
  t11.nbMateriau AS nbMateriau_39,
  t11.materiauSubtitle AS materiauSubtitle_40,
  t11.materiauTitle AS materiauTitle_41,
  t11.textForm AS textForm_42,
  t11.private AS private_43,
  t11.campagne AS campagne_44,
  t11.special AS special_45,
  t11.abrogation_datetime AS abrogation_datetime_46,
  t11.end_zni_date AS end_zni_date_47,
  t11.globalConfigurationHash AS globalConfigurationHash_48,
  t11.zni AS zni_49,
  t11.cdp_eligible AS cdp_eligible_50,
  t11.simulateur_id AS simulateur_id_51,
  t11.arrete_id AS arrete_id_52,
  t11.certification_id AS certification_id_53,
  t11.qualification_id AS qualification_id_54,
  t11.formConfigEngine_id AS formConfigEngine_id_55,
  t0.secteur_id AS secteur_id_56,
  t0.categorie_id AS categorie_id_57,
  t0.categorieCd_id AS categorieCd_id_58,
  t0.type_operation_id AS type_operation_id_59,
  t0.operation_specifique_id AS operation_specifique_id_60,
  t61.id AS id_62,
  t61.mode AS mode_63,
  t61.targetType AS targetType_64,
  t61.classic AS classic_65,
  t61.preca AS preca_66,
  t61.enable AS enable_67,
  t61.raiType AS raiType_68,
  t61.contractSignedElectronically AS contractSignedElectronically_69,
  t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70,
  t61.obligeTarget_id AS obligeTarget_id_71,
  t61.teteReseau_id AS teteReseau_id_72,
  t61.simulateur_id AS simulateur_id_73,
  t61.installateurTarget_id AS installateurTarget_id_74,
  t61.beTarget_id AS beTarget_id_75
FROM
  Simulateur t0
  LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id
  LEFT JOIN AffectationConsoneoRule t61 ON t61.simulateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.simulateur_id = t0.id WHERE t0.id = 243;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.status AS status_4
FROM
  Secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.status AS status_4
FROM
  TypeOperation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.slug AS slug_6,
  t0.human_title AS human_title_7,
  t0.position AS position_8
FROM
  SecteurActivite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = 9;

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