1
0.80 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . mail AS mail_3 , t0 . url AS url_4 , t0 . adresse AS adresse_5 , t0 . cp AS cp_6 , t0 . ville AS ville_7 , t0 . telephone AS telephone_8 , t0 . domain_activate AS domain_activate_9 , t0 . bAbonnementCalendrier AS bAbonnementCalendrier_10 , t0 . newsletterCouleur AS newsletterCouleur_11 , t0 . dateCreation AS dateCreation_12 , t0 . version AS version_13 , t0 . actuv2_token AS actuv2_token_14 , t0 . actuv2_referer AS actuv2_referer_15 , t0 . actuv2_widgetUrl AS actuv2_widgetUrl_16 , t0 . actuv2_colorPrimary AS actuv2_colorPrimary_17 , t0 . actuv2_colorSecondary AS actuv2_colorSecondary_18 , t0 . actuv2_urlContact AS actuv2_urlContact_19 , t0 . host AS host_20 , t0 . website_created_at AS website_created_at_21 , t0 . idsellsy AS idsellsy_22 , t0 . simulateur_token AS simulateur_token_23 , t0 . simulateur_widget_url AS simulateur_widget_url_24 , t0 . rgpd_token AS rgpd_token_25 , t0 . rgpd_widget_url AS rgpd_widget_url_26 , t0 . ce_token AS ce_token_27 , t0 . ce_widget_url AS ce_widget_url_28 , t0 . tous_en_ligne_token AS tous_en_ligne_token_29 , t0 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30 , t0 . rgpd_sender AS rgpd_sender_31 , t0 . rgpd_sender_name AS rgpd_sender_name_32 , t0 . rgpd_expert_externe_use AS rgpd_expert_externe_use_33 , t0 . ce_sender AS ce_sender_34 , t0 . ce_sender_name AS ce_sender_name_35 , t0 . ce_expert_externe_use AS ce_expert_externe_use_36 , t0 . cir_sender AS cir_sender_37 , t0 . cir_sender_name AS cir_sender_name_38 , t0 . cir_expert_externe_use AS cir_expert_externe_use_39 , t0 . cir_token AS cir_token_40 , t0 . cir_widget_url AS cir_widget_url_41 , t0 . mailing_module AS mailing_module_42 , t0 . mailing_sender AS mailing_sender_43 , t0 . mailing_header AS mailing_header_44 , t0 . logo_cabinet AS logo_cabinet_45 , t0 . vcard_access AS vcard_access_46 , t0 . last_update AS last_update_47 , t0 . dark_theme AS dark_theme_48 , t0 . appelle_ton_ec_token AS appelle_ton_ec_token_49 , t0 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50 , t0 . gmb_enable AS gmb_enable_51 , t0 . actuv2_not_ec AS actuv2_not_ec_52 , t0 . actuv2_only_podcast AS actuv2_only_podcast_53 , t0 . gmb_url AS gmb_url_54 , t0 . gmb_name AS gmb_name_55 , t0 . calendly_url AS calendly_url_56 , t0 . survey_client_requested AS survey_client_requested_57 , t0 . survey_client_activate AS survey_client_activate_58 , t0 . podcast_intro_filename AS podcast_intro_filename_59 , t0 . enable_podcast_private AS enable_podcast_private_60 , t0 . podcast_private_student AS podcast_private_student_61 , t0 . podcast_private_token AS podcast_private_token_62 , t0 . podcast_private_widget_url AS podcast_private_widget_url_63 , t0 . subscriber_podcast_private AS subscriber_podcast_private_64 , t0 . logo_pal_path AS logo_pal_path_65 , t0 . google_analytics_id AS google_analytics_id_66 , t0 . email_nl_actu_test AS email_nl_actu_test_67 , t0 . helpers_firms_token AS helpers_firms_token_68 , t0 . helpers_firms_widget_url AS helpers_firms_widget_url_69 , t0 . emailing_client_activate AS emailing_client_activate_70 , t0 . emailing_client_token_max AS emailing_client_token_max_71 , t0 . emailing_client_sender AS emailing_client_sender_72 , t0 . sms_client_activate AS sms_client_activate_73 , t0 . sms_client_credit_max AS sms_client_credit_max_74 , t0 . sms_client_sender AS sms_client_sender_75 , t0 . sms_client_sender_label AS sms_client_sender_label_76 , t0 . anniversaire_client_sender AS anniversaire_client_sender_77 , t0 . anniversaire_client_activate AS anniversaire_client_activate_78 , t0 . event_token AS event_token_79 , t0 . event_widget_url AS event_widget_url_80 , t0 . event_client_requested AS event_client_requested_81 , t0 . sponsorship_token AS sponsorship_token_82 , t0 . sponsorship_widget_url AS sponsorship_widget_url_83 , t0 . sponsorship_client_requested AS sponsorship_client_requested_84 , t0 . sponsorship_client_activate AS sponsorship_client_activate_85 , t0 . recommendation_token AS recommendation_token_86 , t0 . recommendation_widget_url AS recommendation_widget_url_87 , t0 . recommendation_client_requested AS recommendation_client_requested_88 , t0 . recommendation_client_activate AS recommendation_client_activate_89 , t0 . survey_token AS survey_token_90 , t0 . survey_widget_url AS survey_widget_url_91 , t0 . satisfaction_token AS satisfaction_token_92 , t0 . satisfaction_widget_url AS satisfaction_widget_url_93 , t0 . electronic_invoice_token AS electronic_invoice_token_94 , t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_95 , t0 . satisfaction_client_activate AS satisfaction_client_activate_96 , t0 . card_trello_event_create AS card_trello_event_create_97 , t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_98 , t0 . platform_enabled AS platform_enabled_99 , t0 . sepa_prelevement_date AS sepa_prelevement_date_100 , t0 . onboarding_replay_url AS onboarding_replay_url_101 , t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_102 , t0 . onboarding_replay_code AS onboarding_replay_code_103 , t0 . linkedin_username AS linkedin_username_104 , t0 . linkedin_password AS linkedin_password_105 , t0 . linkedin_password_updated_at AS linkedin_password_updated_at_106 , t107 . id AS id_108 , t107 . description AS description_109 , t107 . website AS website_110 , t107 . end_date_time AS end_date_time_111 , t107 . accounting_firm_id AS accounting_firm_id_112 , t113 . id AS id_114 , t113 . modules AS modules_115 , t113 . website_news_links AS website_news_links_116 , t113 . website_news_images AS website_news_images_117 , t113 . website_news_documents AS website_news_documents_118 , t113 . website_news_max_image_size AS website_news_max_image_size_119 , t113 . website_news_max_document_size AS website_news_max_document_size_120 , t113 . ebook_max_image_size AS ebook_max_image_size_121 , t113 . ebook_max_document_size AS ebook_max_document_size_122 , t113 . ebook_documents AS ebook_documents_123 , t113 . ebook_images AS ebook_images_124 , t113 . web_mail AS web_mail_125 , t113 . google_tag_manager AS google_tag_manager_126 , t113 . google_analytics AS google_analytics_127 , t113 . domain_type AS domain_type_128 , t113 . seo_meta_title AS seo_meta_title_129 , t113 . seo_meta_description AS seo_meta_description_130 , t113 . google_recaptcha_site_key AS google_recaptcha_site_key_131 , t113 . google_recaptcha_secret AS google_recaptcha_secret_132 , t113 . favicon AS favicon_133 , t113 . web_mail_recrutement AS web_mail_recrutement_134 , t113 . maintenance AS maintenance_135 , t113 . construction AS construction_136 , t113 . monetico_tpe AS monetico_tpe_137 , t113 . monetico_societe AS monetico_societe_138 , t113 . monetico_cle AS monetico_cle_139 , t113 . accounting_firm_id AS accounting_firm_id_140 , t113 . mailjetapi_id AS mailjetapi_id_141 , t113 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142 , t143 . id AS id_144 , t143 . updated_at AS updated_at_145 , t143 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146 , t143 . accounting_firm_id AS accounting_firm_id_147 , t0 . mailing_api_id AS mailing_api_id_148 , t0 . rgpd_expert_id AS rgpd_expert_id_149 , t0 . ce_expert_id AS ce_expert_id_150 , t0 . cir_expert_id AS cir_expert_id_151 , t0 . emailing_client_api_id AS emailing_client_api_id_152 FROM cabinet t0 LEFT JOIN primary_news t107 ON t107 . accounting_firm_id = t0 . id LEFT JOIN parameters t113 ON t113 . accounting_firm_id = t0 . id LEFT JOIN identite_visuelle t143 ON t143 . accounting_firm_id = t0 . id WHERE t0 . host = ? LIMIT 1
Parameters :
[
"fidecca.fr "
]
SELECT
t0 . id AS id_1 ,
t0 . nom AS nom_2 ,
t0 . mail AS mail_3 ,
t0 . url AS url_4 ,
t0 . adresse AS adresse_5 ,
t0 . cp AS cp_6 ,
t0 . ville AS ville_7 ,
t0 . telephone AS telephone_8 ,
t0 . domain_activate AS domain_activate_9 ,
t0 . bAbonnementCalendrier AS bAbonnementCalendrier_10 ,
t0 . newsletterCouleur AS newsletterCouleur_11 ,
t0 . dateCreation AS dateCreation_12 ,
t0 . version AS version_13 ,
t0 . actuv2_token AS actuv2_token_14 ,
t0 . actuv2_referer AS actuv2_referer_15 ,
t0 . actuv2_widgetUrl AS actuv2_widgetUrl_16 ,
t0 . actuv2_colorPrimary AS actuv2_colorPrimary_17 ,
t0 . actuv2_colorSecondary AS actuv2_colorSecondary_18 ,
t0 . actuv2_urlContact AS actuv2_urlContact_19 ,
t0 . host AS host_20 ,
t0 . website_created_at AS website_created_at_21 ,
t0 . idsellsy AS idsellsy_22 ,
t0 . simulateur_token AS simulateur_token_23 ,
t0 . simulateur_widget_url AS simulateur_widget_url_24 ,
t0 . rgpd_token AS rgpd_token_25 ,
t0 . rgpd_widget_url AS rgpd_widget_url_26 ,
t0 . ce_token AS ce_token_27 ,
t0 . ce_widget_url AS ce_widget_url_28 ,
t0 . tous_en_ligne_token AS tous_en_ligne_token_29 ,
t0 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30 ,
t0 . rgpd_sender AS rgpd_sender_31 ,
t0 . rgpd_sender_name AS rgpd_sender_name_32 ,
t0 . rgpd_expert_externe_use AS rgpd_expert_externe_use_33 ,
t0 . ce_sender AS ce_sender_34 ,
t0 . ce_sender_name AS ce_sender_name_35 ,
t0 . ce_expert_externe_use AS ce_expert_externe_use_36 ,
t0 . cir_sender AS cir_sender_37 ,
t0 . cir_sender_name AS cir_sender_name_38 ,
t0 . cir_expert_externe_use AS cir_expert_externe_use_39 ,
t0 . cir_token AS cir_token_40 ,
t0 . cir_widget_url AS cir_widget_url_41 ,
t0 . mailing_module AS mailing_module_42 ,
t0 . mailing_sender AS mailing_sender_43 ,
t0 . mailing_header AS mailing_header_44 ,
t0 . logo_cabinet AS logo_cabinet_45 ,
t0 . vcard_access AS vcard_access_46 ,
t0 . last_update AS last_update_47 ,
t0 . dark_theme AS dark_theme_48 ,
t0 . appelle_ton_ec_token AS appelle_ton_ec_token_49 ,
t0 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50 ,
t0 . gmb_enable AS gmb_enable_51 ,
t0 . actuv2_not_ec AS actuv2_not_ec_52 ,
t0 . actuv2_only_podcast AS actuv2_only_podcast_53 ,
t0 . gmb_url AS gmb_url_54 ,
t0 . gmb_name AS gmb_name_55 ,
t0 . calendly_url AS calendly_url_56 ,
t0 . survey_client_requested AS survey_client_requested_57 ,
t0 . survey_client_activate AS survey_client_activate_58 ,
t0 . podcast_intro_filename AS podcast_intro_filename_59 ,
t0 . enable_podcast_private AS enable_podcast_private_60 ,
t0 . podcast_private_student AS podcast_private_student_61 ,
t0 . podcast_private_token AS podcast_private_token_62 ,
t0 . podcast_private_widget_url AS podcast_private_widget_url_63 ,
t0 . subscriber_podcast_private AS subscriber_podcast_private_64 ,
t0 . logo_pal_path AS logo_pal_path_65 ,
t0 . google_analytics_id AS google_analytics_id_66 ,
t0 . email_nl_actu_test AS email_nl_actu_test_67 ,
t0 . helpers_firms_token AS helpers_firms_token_68 ,
t0 . helpers_firms_widget_url AS helpers_firms_widget_url_69 ,
t0 . emailing_client_activate AS emailing_client_activate_70 ,
t0 . emailing_client_token_max AS emailing_client_token_max_71 ,
t0 . emailing_client_sender AS emailing_client_sender_72 ,
t0 . sms_client_activate AS sms_client_activate_73 ,
t0 . sms_client_credit_max AS sms_client_credit_max_74 ,
t0 . sms_client_sender AS sms_client_sender_75 ,
t0 . sms_client_sender_label AS sms_client_sender_label_76 ,
t0 . anniversaire_client_sender AS anniversaire_client_sender_77 ,
t0 . anniversaire_client_activate AS anniversaire_client_activate_78 ,
t0 . event_token AS event_token_79 ,
t0 . event_widget_url AS event_widget_url_80 ,
t0 . event_client_requested AS event_client_requested_81 ,
t0 . sponsorship_token AS sponsorship_token_82 ,
t0 . sponsorship_widget_url AS sponsorship_widget_url_83 ,
t0 . sponsorship_client_requested AS sponsorship_client_requested_84 ,
t0 . sponsorship_client_activate AS sponsorship_client_activate_85 ,
t0 . recommendation_token AS recommendation_token_86 ,
t0 . recommendation_widget_url AS recommendation_widget_url_87 ,
t0 . recommendation_client_requested AS recommendation_client_requested_88 ,
t0 . recommendation_client_activate AS recommendation_client_activate_89 ,
t0 . survey_token AS survey_token_90 ,
t0 . survey_widget_url AS survey_widget_url_91 ,
t0 . satisfaction_token AS satisfaction_token_92 ,
t0 . satisfaction_widget_url AS satisfaction_widget_url_93 ,
t0 . electronic_invoice_token AS electronic_invoice_token_94 ,
t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_95 ,
t0 . satisfaction_client_activate AS satisfaction_client_activate_96 ,
t0 . card_trello_event_create AS card_trello_event_create_97 ,
t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_98 ,
t0 . platform_enabled AS platform_enabled_99 ,
t0 . sepa_prelevement_date AS sepa_prelevement_date_100 ,
t0 . onboarding_replay_url AS onboarding_replay_url_101 ,
t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_102 ,
t0 . onboarding_replay_code AS onboarding_replay_code_103 ,
t0 . linkedin_username AS linkedin_username_104 ,
t0 . linkedin_password AS linkedin_password_105 ,
t0 . linkedin_password_updated_at AS linkedin_password_updated_at_106 ,
t107 . id AS id_108 ,
t107 . description AS description_109 ,
t107 . website AS website_110 ,
t107 . end_date_time AS end_date_time_111 ,
t107 . accounting_firm_id AS accounting_firm_id_112 ,
t113 . id AS id_114 ,
t113 . modules AS modules_115 ,
t113 . website_news_links AS website_news_links_116 ,
t113 . website_news_images AS website_news_images_117 ,
t113 . website_news_documents AS website_news_documents_118 ,
t113 . website_news_max_image_size AS website_news_max_image_size_119 ,
t113 . website_news_max_document_size AS website_news_max_document_size_120 ,
t113 . ebook_max_image_size AS ebook_max_image_size_121 ,
t113 . ebook_max_document_size AS ebook_max_document_size_122 ,
t113 . ebook_documents AS ebook_documents_123 ,
t113 . ebook_images AS ebook_images_124 ,
t113 . web_mail AS web_mail_125 ,
t113 . google_tag_manager AS google_tag_manager_126 ,
t113 . google_analytics AS google_analytics_127 ,
t113 . domain_type AS domain_type_128 ,
t113 . seo_meta_title AS seo_meta_title_129 ,
t113 . seo_meta_description AS seo_meta_description_130 ,
t113 . google_recaptcha_site_key AS google_recaptcha_site_key_131 ,
t113 . google_recaptcha_secret AS google_recaptcha_secret_132 ,
t113 . favicon AS favicon_133 ,
t113 . web_mail_recrutement AS web_mail_recrutement_134 ,
t113 . maintenance AS maintenance_135 ,
t113 . construction AS construction_136 ,
t113 . monetico_tpe AS monetico_tpe_137 ,
t113 . monetico_societe AS monetico_societe_138 ,
t113 . monetico_cle AS monetico_cle_139 ,
t113 . accounting_firm_id AS accounting_firm_id_140 ,
t113 . mailjetapi_id AS mailjetapi_id_141 ,
t113 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142 ,
t143 . id AS id_144 ,
t143 . updated_at AS updated_at_145 ,
t143 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146 ,
t143 . accounting_firm_id AS accounting_firm_id_147 ,
t0 . mailing_api_id AS mailing_api_id_148 ,
t0 . rgpd_expert_id AS rgpd_expert_id_149 ,
t0 . ce_expert_id AS ce_expert_id_150 ,
t0 . cir_expert_id AS cir_expert_id_151 ,
t0 . emailing_client_api_id AS emailing_client_api_id_152
FROM
cabinet t0
LEFT JOIN primary_news t107 ON t107 . accounting_firm_id = t0 . id
LEFT JOIN parameters t113 ON t113 . accounting_firm_id = t0 . id
LEFT JOIN identite_visuelle t143 ON t143 . accounting_firm_id = t0 . id
WHERE
t0 . host = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . mail AS mail_3 , t0 . url AS url_4 , t0 . adresse AS adresse_5 , t0 . cp AS cp_6 , t0 . ville AS ville_7 , t0 . telephone AS telephone_8 , t0 . domain_activate AS domain_activate_9 , t0 . bAbonnementCalendrier AS bAbonnementCalendrier_10 , t0 . newsletterCouleur AS newsletterCouleur_11 , t0 . dateCreation AS dateCreation_12 , t0 . version AS version_13 , t0 . actuv2_token AS actuv2_token_14 , t0 . actuv2_referer AS actuv2_referer_15 , t0 . actuv2_widgetUrl AS actuv2_widgetUrl_16 , t0 . actuv2_colorPrimary AS actuv2_colorPrimary_17 , t0 . actuv2_colorSecondary AS actuv2_colorSecondary_18 , t0 . actuv2_urlContact AS actuv2_urlContact_19 , t0 . host AS host_20 , t0 . website_created_at AS website_created_at_21 , t0 . idsellsy AS idsellsy_22 , t0 . simulateur_token AS simulateur_token_23 , t0 . simulateur_widget_url AS simulateur_widget_url_24 , t0 . rgpd_token AS rgpd_token_25 , t0 . rgpd_widget_url AS rgpd_widget_url_26 , t0 . ce_token AS ce_token_27 , t0 . ce_widget_url AS ce_widget_url_28 , t0 . tous_en_ligne_token AS tous_en_ligne_token_29 , t0 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_30 , t0 . rgpd_sender AS rgpd_sender_31 , t0 . rgpd_sender_name AS rgpd_sender_name_32 , t0 . rgpd_expert_externe_use AS rgpd_expert_externe_use_33 , t0 . ce_sender AS ce_sender_34 , t0 . ce_sender_name AS ce_sender_name_35 , t0 . ce_expert_externe_use AS ce_expert_externe_use_36 , t0 . cir_sender AS cir_sender_37 , t0 . cir_sender_name AS cir_sender_name_38 , t0 . cir_expert_externe_use AS cir_expert_externe_use_39 , t0 . cir_token AS cir_token_40 , t0 . cir_widget_url AS cir_widget_url_41 , t0 . mailing_module AS mailing_module_42 , t0 . mailing_sender AS mailing_sender_43 , t0 . mailing_header AS mailing_header_44 , t0 . logo_cabinet AS logo_cabinet_45 , t0 . vcard_access AS vcard_access_46 , t0 . last_update AS last_update_47 , t0 . dark_theme AS dark_theme_48 , t0 . appelle_ton_ec_token AS appelle_ton_ec_token_49 , t0 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_50 , t0 . gmb_enable AS gmb_enable_51 , t0 . actuv2_not_ec AS actuv2_not_ec_52 , t0 . actuv2_only_podcast AS actuv2_only_podcast_53 , t0 . gmb_url AS gmb_url_54 , t0 . gmb_name AS gmb_name_55 , t0 . calendly_url AS calendly_url_56 , t0 . survey_client_requested AS survey_client_requested_57 , t0 . survey_client_activate AS survey_client_activate_58 , t0 . podcast_intro_filename AS podcast_intro_filename_59 , t0 . enable_podcast_private AS enable_podcast_private_60 , t0 . podcast_private_student AS podcast_private_student_61 , t0 . podcast_private_token AS podcast_private_token_62 , t0 . podcast_private_widget_url AS podcast_private_widget_url_63 , t0 . subscriber_podcast_private AS subscriber_podcast_private_64 , t0 . logo_pal_path AS logo_pal_path_65 , t0 . google_analytics_id AS google_analytics_id_66 , t0 . email_nl_actu_test AS email_nl_actu_test_67 , t0 . helpers_firms_token AS helpers_firms_token_68 , t0 . helpers_firms_widget_url AS helpers_firms_widget_url_69 , t0 . emailing_client_activate AS emailing_client_activate_70 , t0 . emailing_client_token_max AS emailing_client_token_max_71 , t0 . emailing_client_sender AS emailing_client_sender_72 , t0 . sms_client_activate AS sms_client_activate_73 , t0 . sms_client_credit_max AS sms_client_credit_max_74 , t0 . sms_client_sender AS sms_client_sender_75 , t0 . sms_client_sender_label AS sms_client_sender_label_76 , t0 . anniversaire_client_sender AS anniversaire_client_sender_77 , t0 . anniversaire_client_activate AS anniversaire_client_activate_78 , t0 . event_token AS event_token_79 , t0 . event_widget_url AS event_widget_url_80 , t0 . event_client_requested AS event_client_requested_81 , t0 . sponsorship_token AS sponsorship_token_82 , t0 . sponsorship_widget_url AS sponsorship_widget_url_83 , t0 . sponsorship_client_requested AS sponsorship_client_requested_84 , t0 . sponsorship_client_activate AS sponsorship_client_activate_85 , t0 . recommendation_token AS recommendation_token_86 , t0 . recommendation_widget_url AS recommendation_widget_url_87 , t0 . recommendation_client_requested AS recommendation_client_requested_88 , t0 . recommendation_client_activate AS recommendation_client_activate_89 , t0 . survey_token AS survey_token_90 , t0 . survey_widget_url AS survey_widget_url_91 , t0 . satisfaction_token AS satisfaction_token_92 , t0 . satisfaction_widget_url AS satisfaction_widget_url_93 , t0 . electronic_invoice_token AS electronic_invoice_token_94 , t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_95 , t0 . satisfaction_client_activate AS satisfaction_client_activate_96 , t0 . card_trello_event_create AS card_trello_event_create_97 , t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_98 , t0 . platform_enabled AS platform_enabled_99 , t0 . sepa_prelevement_date AS sepa_prelevement_date_100 , t0 . onboarding_replay_url AS onboarding_replay_url_101 , t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_102 , t0 . onboarding_replay_code AS onboarding_replay_code_103 , t0 . linkedin_username AS linkedin_username_104 , t0 . linkedin_password AS linkedin_password_105 , t0 . linkedin_password_updated_at AS linkedin_password_updated_at_106 , t107 . id AS id_108 , t107 . description AS description_109 , t107 . website AS website_110 , t107 . end_date_time AS end_date_time_111 , t107 . accounting_firm_id AS accounting_firm_id_112 , t113 . id AS id_114 , t113 . modules AS modules_115 , t113 . website_news_links AS website_news_links_116 , t113 . website_news_images AS website_news_images_117 , t113 . website_news_documents AS website_news_documents_118 , t113 . website_news_max_image_size AS website_news_max_image_size_119 , t113 . website_news_max_document_size AS website_news_max_document_size_120 , t113 . ebook_max_image_size AS ebook_max_image_size_121 , t113 . ebook_max_document_size AS ebook_max_document_size_122 , t113 . ebook_documents AS ebook_documents_123 , t113 . ebook_images AS ebook_images_124 , t113 . web_mail AS web_mail_125 , t113 . google_tag_manager AS google_tag_manager_126 , t113 . google_analytics AS google_analytics_127 , t113 . domain_type AS domain_type_128 , t113 . seo_meta_title AS seo_meta_title_129 , t113 . seo_meta_description AS seo_meta_description_130 , t113 . google_recaptcha_site_key AS google_recaptcha_site_key_131 , t113 . google_recaptcha_secret AS google_recaptcha_secret_132 , t113 . favicon AS favicon_133 , t113 . web_mail_recrutement AS web_mail_recrutement_134 , t113 . maintenance AS maintenance_135 , t113 . construction AS construction_136 , t113 . monetico_tpe AS monetico_tpe_137 , t113 . monetico_societe AS monetico_societe_138 , t113 . monetico_cle AS monetico_cle_139 , t113 . accounting_firm_id AS accounting_firm_id_140 , t113 . mailjetapi_id AS mailjetapi_id_141 , t113 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142 , t143 . id AS id_144 , t143 . updated_at AS updated_at_145 , t143 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_146 , t143 . accounting_firm_id AS accounting_firm_id_147 , t0 . mailing_api_id AS mailing_api_id_148 , t0 . rgpd_expert_id AS rgpd_expert_id_149 , t0 . ce_expert_id AS ce_expert_id_150 , t0 . cir_expert_id AS cir_expert_id_151 , t0 . emailing_client_api_id AS emailing_client_api_id_152 FROM cabinet t0 LEFT JOIN primary_news t107 ON t107 . accounting_firm_id = t0 . id LEFT JOIN parameters t113 ON t113 . accounting_firm_id = t0 . id LEFT JOIN identite_visuelle t143 ON t143 . accounting_firm_id = t0 . id WHERE t0 . host = 'fidecca.fr' LIMIT 1 ;
Copy
2
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . username AS username_3 , t0 . password AS password_4 , t0 . type_id AS type_id_5 FROM mailjet_api t0 WHERE t0 . id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . username AS username_3 , t0 . password AS password_4 , t0 . type_id AS type_id_5 FROM mailjet_api t0 WHERE t0 . id = 1 LIMIT 1 ;
Copy
3
0.79 ms
SELECT c0_ . id AS id_0 , c0_ . nom AS nom_1 , c0_ . mail AS mail_2 , c0_ . url AS url_3 , c0_ . adresse AS adresse_4 , c0_ . cp AS cp_5 , c0_ . ville AS ville_6 , c0_ . telephone AS telephone_7 , c0_ . domain_activate AS domain_activate_8 , c0_ . bAbonnementCalendrier AS bAbonnementCalendrier_9 , c0_ . newsletterCouleur AS newsletterCouleur_10 , c0_ . dateCreation AS dateCreation_11 , c0_ . version AS version_12 , c0_ . actuv2_token AS actuv2_token_13 , c0_ . actuv2_referer AS actuv2_referer_14 , c0_ . actuv2_widgetUrl AS actuv2_widgetUrl_15 , c0_ . actuv2_colorPrimary AS actuv2_colorPrimary_16 , c0_ . actuv2_colorSecondary AS actuv2_colorSecondary_17 , c0_ . actuv2_urlContact AS actuv2_urlContact_18 , c0_ . host AS host_19 , c0_ . website_created_at AS website_created_at_20 , c0_ . idsellsy AS idsellsy_21 , c0_ . simulateur_token AS simulateur_token_22 , c0_ . simulateur_widget_url AS simulateur_widget_url_23 , c0_ . rgpd_token AS rgpd_token_24 , c0_ . rgpd_widget_url AS rgpd_widget_url_25 , c0_ . ce_token AS ce_token_26 , c0_ . ce_widget_url AS ce_widget_url_27 , c0_ . tous_en_ligne_token AS tous_en_ligne_token_28 , c0_ . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29 , c0_ . rgpd_sender AS rgpd_sender_30 , c0_ . rgpd_sender_name AS rgpd_sender_name_31 , c0_ . rgpd_expert_externe_use AS rgpd_expert_externe_use_32 , c0_ . ce_sender AS ce_sender_33 , c0_ . ce_sender_name AS ce_sender_name_34 , c0_ . ce_expert_externe_use AS ce_expert_externe_use_35 , c0_ . cir_sender AS cir_sender_36 , c0_ . cir_sender_name AS cir_sender_name_37 , c0_ . cir_expert_externe_use AS cir_expert_externe_use_38 , c0_ . cir_token AS cir_token_39 , c0_ . cir_widget_url AS cir_widget_url_40 , c0_ . mailing_module AS mailing_module_41 , c0_ . mailing_sender AS mailing_sender_42 , c0_ . mailing_header AS mailing_header_43 , c0_ . logo_cabinet AS logo_cabinet_44 , c0_ . vcard_access AS vcard_access_45 , c0_ . last_update AS last_update_46 , c0_ . dark_theme AS dark_theme_47 , c0_ . appelle_ton_ec_token AS appelle_ton_ec_token_48 , c0_ . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49 , c0_ . gmb_enable AS gmb_enable_50 , c0_ . actuv2_not_ec AS actuv2_not_ec_51 , c0_ . actuv2_only_podcast AS actuv2_only_podcast_52 , c0_ . gmb_url AS gmb_url_53 , c0_ . gmb_name AS gmb_name_54 , c0_ . calendly_url AS calendly_url_55 , c0_ . survey_client_requested AS survey_client_requested_56 , c0_ . survey_client_activate AS survey_client_activate_57 , c0_ . podcast_intro_filename AS podcast_intro_filename_58 , c0_ . enable_podcast_private AS enable_podcast_private_59 , c0_ . podcast_private_student AS podcast_private_student_60 , c0_ . podcast_private_token AS podcast_private_token_61 , c0_ . podcast_private_widget_url AS podcast_private_widget_url_62 , c0_ . subscriber_podcast_private AS subscriber_podcast_private_63 , c0_ . logo_pal_path AS logo_pal_path_64 , c0_ . google_analytics_id AS google_analytics_id_65 , c0_ . email_nl_actu_test AS email_nl_actu_test_66 , c0_ . helpers_firms_token AS helpers_firms_token_67 , c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_68 , c0_ . emailing_client_activate AS emailing_client_activate_69 , c0_ . emailing_client_token_max AS emailing_client_token_max_70 , c0_ . emailing_client_sender AS emailing_client_sender_71 , c0_ . sms_client_activate AS sms_client_activate_72 , c0_ . sms_client_credit_max AS sms_client_credit_max_73 , c0_ . sms_client_sender AS sms_client_sender_74 , c0_ . sms_client_sender_label AS sms_client_sender_label_75 , c0_ . anniversaire_client_sender AS anniversaire_client_sender_76 , c0_ . anniversaire_client_activate AS anniversaire_client_activate_77 , c0_ . event_token AS event_token_78 , c0_ . event_widget_url AS event_widget_url_79 , c0_ . event_client_requested AS event_client_requested_80 , c0_ . sponsorship_token AS sponsorship_token_81 , c0_ . sponsorship_widget_url AS sponsorship_widget_url_82 , c0_ . sponsorship_client_requested AS sponsorship_client_requested_83 , c0_ . sponsorship_client_activate AS sponsorship_client_activate_84 , c0_ . recommendation_token AS recommendation_token_85 , c0_ . recommendation_widget_url AS recommendation_widget_url_86 , c0_ . recommendation_client_requested AS recommendation_client_requested_87 , c0_ . recommendation_client_activate AS recommendation_client_activate_88 , c0_ . survey_token AS survey_token_89 , c0_ . survey_widget_url AS survey_widget_url_90 , c0_ . satisfaction_token AS satisfaction_token_91 , c0_ . satisfaction_widget_url AS satisfaction_widget_url_92 , c0_ . electronic_invoice_token AS electronic_invoice_token_93 , c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_94 , c0_ . satisfaction_client_activate AS satisfaction_client_activate_95 , c0_ . card_trello_event_create AS card_trello_event_create_96 , c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_97 , c0_ . platform_enabled AS platform_enabled_98 , c0_ . sepa_prelevement_date AS sepa_prelevement_date_99 , c0_ . onboarding_replay_url AS onboarding_replay_url_100 , c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_101 , c0_ . onboarding_replay_code AS onboarding_replay_code_102 , c0_ . linkedin_username AS linkedin_username_103 , c0_ . linkedin_password AS linkedin_password_104 , c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_105 , p1_ . id AS id_106 , p1_ . modules AS modules_107 , p1_ . website_news_links AS website_news_links_108 , p1_ . website_news_images AS website_news_images_109 , p1_ . website_news_documents AS website_news_documents_110 , p1_ . website_news_max_image_size AS website_news_max_image_size_111 , p1_ . website_news_max_document_size AS website_news_max_document_size_112 , p1_ . ebook_max_image_size AS ebook_max_image_size_113 , p1_ . ebook_max_document_size AS ebook_max_document_size_114 , p1_ . ebook_documents AS ebook_documents_115 , p1_ . ebook_images AS ebook_images_116 , p1_ . web_mail AS web_mail_117 , p1_ . google_tag_manager AS google_tag_manager_118 , p1_ . google_analytics AS google_analytics_119 , p1_ . domain_type AS domain_type_120 , p1_ . seo_meta_title AS seo_meta_title_121 , p1_ . seo_meta_description AS seo_meta_description_122 , p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_123 , p1_ . google_recaptcha_secret AS google_recaptcha_secret_124 , p1_ . favicon AS favicon_125 , p1_ . web_mail_recrutement AS web_mail_recrutement_126 , p1_ . maintenance AS maintenance_127 , p1_ . construction AS construction_128 , p1_ . monetico_tpe AS monetico_tpe_129 , p1_ . monetico_societe AS monetico_societe_130 , p1_ . monetico_cle AS monetico_cle_131 , c0_ . mailing_api_id AS mailing_api_id_132 , c0_ . rgpd_expert_id AS rgpd_expert_id_133 , c0_ . ce_expert_id AS ce_expert_id_134 , c0_ . cir_expert_id AS cir_expert_id_135 , c0_ . emailing_client_api_id AS emailing_client_api_id_136 , p1_ . accounting_firm_id AS accounting_firm_id_137 , p1_ . mailjetapi_id AS mailjetapi_id_138 , p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_ . id = p1_ . accounting_firm_id WHERE c0_ . host = ?
Parameters :
[
"fidecca.fr "
]
SELECT
c0_ . id AS id_0 ,
c0_ . nom AS nom_1 ,
c0_ . mail AS mail_2 ,
c0_ . url AS url_3 ,
c0_ . adresse AS adresse_4 ,
c0_ . cp AS cp_5 ,
c0_ . ville AS ville_6 ,
c0_ . telephone AS telephone_7 ,
c0_ . domain_activate AS domain_activate_8 ,
c0_ . bAbonnementCalendrier AS bAbonnementCalendrier_9 ,
c0_ . newsletterCouleur AS newsletterCouleur_10 ,
c0_ . dateCreation AS dateCreation_11 ,
c0_ . version AS version_12 ,
c0_ . actuv2_token AS actuv2_token_13 ,
c0_ . actuv2_referer AS actuv2_referer_14 ,
c0_ . actuv2_widgetUrl AS actuv2_widgetUrl_15 ,
c0_ . actuv2_colorPrimary AS actuv2_colorPrimary_16 ,
c0_ . actuv2_colorSecondary AS actuv2_colorSecondary_17 ,
c0_ . actuv2_urlContact AS actuv2_urlContact_18 ,
c0_ . host AS host_19 ,
c0_ . website_created_at AS website_created_at_20 ,
c0_ . idsellsy AS idsellsy_21 ,
c0_ . simulateur_token AS simulateur_token_22 ,
c0_ . simulateur_widget_url AS simulateur_widget_url_23 ,
c0_ . rgpd_token AS rgpd_token_24 ,
c0_ . rgpd_widget_url AS rgpd_widget_url_25 ,
c0_ . ce_token AS ce_token_26 ,
c0_ . ce_widget_url AS ce_widget_url_27 ,
c0_ . tous_en_ligne_token AS tous_en_ligne_token_28 ,
c0_ . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29 ,
c0_ . rgpd_sender AS rgpd_sender_30 ,
c0_ . rgpd_sender_name AS rgpd_sender_name_31 ,
c0_ . rgpd_expert_externe_use AS rgpd_expert_externe_use_32 ,
c0_ . ce_sender AS ce_sender_33 ,
c0_ . ce_sender_name AS ce_sender_name_34 ,
c0_ . ce_expert_externe_use AS ce_expert_externe_use_35 ,
c0_ . cir_sender AS cir_sender_36 ,
c0_ . cir_sender_name AS cir_sender_name_37 ,
c0_ . cir_expert_externe_use AS cir_expert_externe_use_38 ,
c0_ . cir_token AS cir_token_39 ,
c0_ . cir_widget_url AS cir_widget_url_40 ,
c0_ . mailing_module AS mailing_module_41 ,
c0_ . mailing_sender AS mailing_sender_42 ,
c0_ . mailing_header AS mailing_header_43 ,
c0_ . logo_cabinet AS logo_cabinet_44 ,
c0_ . vcard_access AS vcard_access_45 ,
c0_ . last_update AS last_update_46 ,
c0_ . dark_theme AS dark_theme_47 ,
c0_ . appelle_ton_ec_token AS appelle_ton_ec_token_48 ,
c0_ . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49 ,
c0_ . gmb_enable AS gmb_enable_50 ,
c0_ . actuv2_not_ec AS actuv2_not_ec_51 ,
c0_ . actuv2_only_podcast AS actuv2_only_podcast_52 ,
c0_ . gmb_url AS gmb_url_53 ,
c0_ . gmb_name AS gmb_name_54 ,
c0_ . calendly_url AS calendly_url_55 ,
c0_ . survey_client_requested AS survey_client_requested_56 ,
c0_ . survey_client_activate AS survey_client_activate_57 ,
c0_ . podcast_intro_filename AS podcast_intro_filename_58 ,
c0_ . enable_podcast_private AS enable_podcast_private_59 ,
c0_ . podcast_private_student AS podcast_private_student_60 ,
c0_ . podcast_private_token AS podcast_private_token_61 ,
c0_ . podcast_private_widget_url AS podcast_private_widget_url_62 ,
c0_ . subscriber_podcast_private AS subscriber_podcast_private_63 ,
c0_ . logo_pal_path AS logo_pal_path_64 ,
c0_ . google_analytics_id AS google_analytics_id_65 ,
c0_ . email_nl_actu_test AS email_nl_actu_test_66 ,
c0_ . helpers_firms_token AS helpers_firms_token_67 ,
c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_68 ,
c0_ . emailing_client_activate AS emailing_client_activate_69 ,
c0_ . emailing_client_token_max AS emailing_client_token_max_70 ,
c0_ . emailing_client_sender AS emailing_client_sender_71 ,
c0_ . sms_client_activate AS sms_client_activate_72 ,
c0_ . sms_client_credit_max AS sms_client_credit_max_73 ,
c0_ . sms_client_sender AS sms_client_sender_74 ,
c0_ . sms_client_sender_label AS sms_client_sender_label_75 ,
c0_ . anniversaire_client_sender AS anniversaire_client_sender_76 ,
c0_ . anniversaire_client_activate AS anniversaire_client_activate_77 ,
c0_ . event_token AS event_token_78 ,
c0_ . event_widget_url AS event_widget_url_79 ,
c0_ . event_client_requested AS event_client_requested_80 ,
c0_ . sponsorship_token AS sponsorship_token_81 ,
c0_ . sponsorship_widget_url AS sponsorship_widget_url_82 ,
c0_ . sponsorship_client_requested AS sponsorship_client_requested_83 ,
c0_ . sponsorship_client_activate AS sponsorship_client_activate_84 ,
c0_ . recommendation_token AS recommendation_token_85 ,
c0_ . recommendation_widget_url AS recommendation_widget_url_86 ,
c0_ . recommendation_client_requested AS recommendation_client_requested_87 ,
c0_ . recommendation_client_activate AS recommendation_client_activate_88 ,
c0_ . survey_token AS survey_token_89 ,
c0_ . survey_widget_url AS survey_widget_url_90 ,
c0_ . satisfaction_token AS satisfaction_token_91 ,
c0_ . satisfaction_widget_url AS satisfaction_widget_url_92 ,
c0_ . electronic_invoice_token AS electronic_invoice_token_93 ,
c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_94 ,
c0_ . satisfaction_client_activate AS satisfaction_client_activate_95 ,
c0_ . card_trello_event_create AS card_trello_event_create_96 ,
c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_97 ,
c0_ . platform_enabled AS platform_enabled_98 ,
c0_ . sepa_prelevement_date AS sepa_prelevement_date_99 ,
c0_ . onboarding_replay_url AS onboarding_replay_url_100 ,
c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_101 ,
c0_ . onboarding_replay_code AS onboarding_replay_code_102 ,
c0_ . linkedin_username AS linkedin_username_103 ,
c0_ . linkedin_password AS linkedin_password_104 ,
c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_105 ,
p1_ . id AS id_106 ,
p1_ . modules AS modules_107 ,
p1_ . website_news_links AS website_news_links_108 ,
p1_ . website_news_images AS website_news_images_109 ,
p1_ . website_news_documents AS website_news_documents_110 ,
p1_ . website_news_max_image_size AS website_news_max_image_size_111 ,
p1_ . website_news_max_document_size AS website_news_max_document_size_112 ,
p1_ . ebook_max_image_size AS ebook_max_image_size_113 ,
p1_ . ebook_max_document_size AS ebook_max_document_size_114 ,
p1_ . ebook_documents AS ebook_documents_115 ,
p1_ . ebook_images AS ebook_images_116 ,
p1_ . web_mail AS web_mail_117 ,
p1_ . google_tag_manager AS google_tag_manager_118 ,
p1_ . google_analytics AS google_analytics_119 ,
p1_ . domain_type AS domain_type_120 ,
p1_ . seo_meta_title AS seo_meta_title_121 ,
p1_ . seo_meta_description AS seo_meta_description_122 ,
p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_123 ,
p1_ . google_recaptcha_secret AS google_recaptcha_secret_124 ,
p1_ . favicon AS favicon_125 ,
p1_ . web_mail_recrutement AS web_mail_recrutement_126 ,
p1_ . maintenance AS maintenance_127 ,
p1_ . construction AS construction_128 ,
p1_ . monetico_tpe AS monetico_tpe_129 ,
p1_ . monetico_societe AS monetico_societe_130 ,
p1_ . monetico_cle AS monetico_cle_131 ,
c0_ . mailing_api_id AS mailing_api_id_132 ,
c0_ . rgpd_expert_id AS rgpd_expert_id_133 ,
c0_ . ce_expert_id AS ce_expert_id_134 ,
c0_ . cir_expert_id AS cir_expert_id_135 ,
c0_ . emailing_client_api_id AS emailing_client_api_id_136 ,
p1_ . accounting_firm_id AS accounting_firm_id_137 ,
p1_ . mailjetapi_id AS mailjetapi_id_138 ,
p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139
FROM
cabinet c0_
LEFT JOIN parameters p1_ ON c0_ . id = p1_ . accounting_firm_id
WHERE
c0_ . host = ?
Copy
SELECT c0_ . id AS id_0 , c0_ . nom AS nom_1 , c0_ . mail AS mail_2 , c0_ . url AS url_3 , c0_ . adresse AS adresse_4 , c0_ . cp AS cp_5 , c0_ . ville AS ville_6 , c0_ . telephone AS telephone_7 , c0_ . domain_activate AS domain_activate_8 , c0_ . bAbonnementCalendrier AS bAbonnementCalendrier_9 , c0_ . newsletterCouleur AS newsletterCouleur_10 , c0_ . dateCreation AS dateCreation_11 , c0_ . version AS version_12 , c0_ . actuv2_token AS actuv2_token_13 , c0_ . actuv2_referer AS actuv2_referer_14 , c0_ . actuv2_widgetUrl AS actuv2_widgetUrl_15 , c0_ . actuv2_colorPrimary AS actuv2_colorPrimary_16 , c0_ . actuv2_colorSecondary AS actuv2_colorSecondary_17 , c0_ . actuv2_urlContact AS actuv2_urlContact_18 , c0_ . host AS host_19 , c0_ . website_created_at AS website_created_at_20 , c0_ . idsellsy AS idsellsy_21 , c0_ . simulateur_token AS simulateur_token_22 , c0_ . simulateur_widget_url AS simulateur_widget_url_23 , c0_ . rgpd_token AS rgpd_token_24 , c0_ . rgpd_widget_url AS rgpd_widget_url_25 , c0_ . ce_token AS ce_token_26 , c0_ . ce_widget_url AS ce_widget_url_27 , c0_ . tous_en_ligne_token AS tous_en_ligne_token_28 , c0_ . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_29 , c0_ . rgpd_sender AS rgpd_sender_30 , c0_ . rgpd_sender_name AS rgpd_sender_name_31 , c0_ . rgpd_expert_externe_use AS rgpd_expert_externe_use_32 , c0_ . ce_sender AS ce_sender_33 , c0_ . ce_sender_name AS ce_sender_name_34 , c0_ . ce_expert_externe_use AS ce_expert_externe_use_35 , c0_ . cir_sender AS cir_sender_36 , c0_ . cir_sender_name AS cir_sender_name_37 , c0_ . cir_expert_externe_use AS cir_expert_externe_use_38 , c0_ . cir_token AS cir_token_39 , c0_ . cir_widget_url AS cir_widget_url_40 , c0_ . mailing_module AS mailing_module_41 , c0_ . mailing_sender AS mailing_sender_42 , c0_ . mailing_header AS mailing_header_43 , c0_ . logo_cabinet AS logo_cabinet_44 , c0_ . vcard_access AS vcard_access_45 , c0_ . last_update AS last_update_46 , c0_ . dark_theme AS dark_theme_47 , c0_ . appelle_ton_ec_token AS appelle_ton_ec_token_48 , c0_ . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_49 , c0_ . gmb_enable AS gmb_enable_50 , c0_ . actuv2_not_ec AS actuv2_not_ec_51 , c0_ . actuv2_only_podcast AS actuv2_only_podcast_52 , c0_ . gmb_url AS gmb_url_53 , c0_ . gmb_name AS gmb_name_54 , c0_ . calendly_url AS calendly_url_55 , c0_ . survey_client_requested AS survey_client_requested_56 , c0_ . survey_client_activate AS survey_client_activate_57 , c0_ . podcast_intro_filename AS podcast_intro_filename_58 , c0_ . enable_podcast_private AS enable_podcast_private_59 , c0_ . podcast_private_student AS podcast_private_student_60 , c0_ . podcast_private_token AS podcast_private_token_61 , c0_ . podcast_private_widget_url AS podcast_private_widget_url_62 , c0_ . subscriber_podcast_private AS subscriber_podcast_private_63 , c0_ . logo_pal_path AS logo_pal_path_64 , c0_ . google_analytics_id AS google_analytics_id_65 , c0_ . email_nl_actu_test AS email_nl_actu_test_66 , c0_ . helpers_firms_token AS helpers_firms_token_67 , c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_68 , c0_ . emailing_client_activate AS emailing_client_activate_69 , c0_ . emailing_client_token_max AS emailing_client_token_max_70 , c0_ . emailing_client_sender AS emailing_client_sender_71 , c0_ . sms_client_activate AS sms_client_activate_72 , c0_ . sms_client_credit_max AS sms_client_credit_max_73 , c0_ . sms_client_sender AS sms_client_sender_74 , c0_ . sms_client_sender_label AS sms_client_sender_label_75 , c0_ . anniversaire_client_sender AS anniversaire_client_sender_76 , c0_ . anniversaire_client_activate AS anniversaire_client_activate_77 , c0_ . event_token AS event_token_78 , c0_ . event_widget_url AS event_widget_url_79 , c0_ . event_client_requested AS event_client_requested_80 , c0_ . sponsorship_token AS sponsorship_token_81 , c0_ . sponsorship_widget_url AS sponsorship_widget_url_82 , c0_ . sponsorship_client_requested AS sponsorship_client_requested_83 , c0_ . sponsorship_client_activate AS sponsorship_client_activate_84 , c0_ . recommendation_token AS recommendation_token_85 , c0_ . recommendation_widget_url AS recommendation_widget_url_86 , c0_ . recommendation_client_requested AS recommendation_client_requested_87 , c0_ . recommendation_client_activate AS recommendation_client_activate_88 , c0_ . survey_token AS survey_token_89 , c0_ . survey_widget_url AS survey_widget_url_90 , c0_ . satisfaction_token AS satisfaction_token_91 , c0_ . satisfaction_widget_url AS satisfaction_widget_url_92 , c0_ . electronic_invoice_token AS electronic_invoice_token_93 , c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_94 , c0_ . satisfaction_client_activate AS satisfaction_client_activate_95 , c0_ . card_trello_event_create AS card_trello_event_create_96 , c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_97 , c0_ . platform_enabled AS platform_enabled_98 , c0_ . sepa_prelevement_date AS sepa_prelevement_date_99 , c0_ . onboarding_replay_url AS onboarding_replay_url_100 , c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_101 , c0_ . onboarding_replay_code AS onboarding_replay_code_102 , c0_ . linkedin_username AS linkedin_username_103 , c0_ . linkedin_password AS linkedin_password_104 , c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_105 , p1_ . id AS id_106 , p1_ . modules AS modules_107 , p1_ . website_news_links AS website_news_links_108 , p1_ . website_news_images AS website_news_images_109 , p1_ . website_news_documents AS website_news_documents_110 , p1_ . website_news_max_image_size AS website_news_max_image_size_111 , p1_ . website_news_max_document_size AS website_news_max_document_size_112 , p1_ . ebook_max_image_size AS ebook_max_image_size_113 , p1_ . ebook_max_document_size AS ebook_max_document_size_114 , p1_ . ebook_documents AS ebook_documents_115 , p1_ . ebook_images AS ebook_images_116 , p1_ . web_mail AS web_mail_117 , p1_ . google_tag_manager AS google_tag_manager_118 , p1_ . google_analytics AS google_analytics_119 , p1_ . domain_type AS domain_type_120 , p1_ . seo_meta_title AS seo_meta_title_121 , p1_ . seo_meta_description AS seo_meta_description_122 , p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_123 , p1_ . google_recaptcha_secret AS google_recaptcha_secret_124 , p1_ . favicon AS favicon_125 , p1_ . web_mail_recrutement AS web_mail_recrutement_126 , p1_ . maintenance AS maintenance_127 , p1_ . construction AS construction_128 , p1_ . monetico_tpe AS monetico_tpe_129 , p1_ . monetico_societe AS monetico_societe_130 , p1_ . monetico_cle AS monetico_cle_131 , c0_ . mailing_api_id AS mailing_api_id_132 , c0_ . rgpd_expert_id AS rgpd_expert_id_133 , c0_ . ce_expert_id AS ce_expert_id_134 , c0_ . cir_expert_id AS cir_expert_id_135 , c0_ . emailing_client_api_id AS emailing_client_api_id_136 , p1_ . accounting_firm_id AS accounting_firm_id_137 , p1_ . mailjetapi_id AS mailjetapi_id_138 , p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_139 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_ . id = p1_ . accounting_firm_id WHERE c0_ . host = 'fidecca.fr' ;
Copy
4
0.19 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . data AS data_3 , t0 . type AS type_4 FROM dyn_data t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . data AS data_3 , t0 . type AS type_4 FROM dyn_data t0 ;
Copy
5
0.24 ms
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . website AS website_3 , a0_ . reference AS reference_4 , a0_ . slug AS slug_5 , a0_ . is_primary AS is_primary_6 , a0_ . is_spontanee AS is_spontanee_7 , a0_ . img AS img_8 , a0_ . info2 AS info2_9 , a0_ . info3 AS info3_10 , a0_ . info4 AS info4_11 , a0_ . info5 AS info5_12 , a0_ . contrat AS contrat_13 , a0_ . rythme AS rythme_14 , a0_ . date_debut AS date_debut_15 , a0_ . diplome AS diplome_16 , a0_ . annee_experience AS annee_experience_17 , a0_ . outils_logiciels AS outils_logiciels_18 , a0_ . softs AS softs_19 , a0_ . salaire AS salaire_20 , a0_ . a_propos_cabinet AS a_propos_cabinet_21 , a0_ . teletravail AS teletravail_22 , a0_ . accounting_firm_id AS accounting_firm_id_23 FROM announcement a0_ WHERE a0_ . accounting_firm_id = ? AND a0_ . website = ? AND a0_ . is_primary = ? ORDER BY a0_ . id DESC LIMIT 1
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . website AS website_3 , a0_ . reference AS reference_4 , a0_ . slug AS slug_5 , a0_ . is_primary AS is_primary_6 , a0_ . is_spontanee AS is_spontanee_7 , a0_ . img AS img_8 , a0_ . info2 AS info2_9 , a0_ . info3 AS info3_10 , a0_ . info4 AS info4_11 , a0_ . info5 AS info5_12 , a0_ . contrat AS contrat_13 , a0_ . rythme AS rythme_14 , a0_ . date_debut AS date_debut_15 , a0_ . diplome AS diplome_16 , a0_ . annee_experience AS annee_experience_17 , a0_ . outils_logiciels AS outils_logiciels_18 , a0_ . softs AS softs_19 , a0_ . salaire AS salaire_20 , a0_ . a_propos_cabinet AS a_propos_cabinet_21 , a0_ . teletravail AS teletravail_22 , a0_ . accounting_firm_id AS accounting_firm_id_23 FROM announcement a0_ WHERE a0_ . accounting_firm_id = '69' AND a0_ . website = 1 AND a0_ . is_primary = 1 ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
6
0.15 ms
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . website AS website_3 , a0_ . reference AS reference_4 , a0_ . slug AS slug_5 , a0_ . is_primary AS is_primary_6 , a0_ . is_spontanee AS is_spontanee_7 , a0_ . img AS img_8 , a0_ . info2 AS info2_9 , a0_ . info3 AS info3_10 , a0_ . info4 AS info4_11 , a0_ . info5 AS info5_12 , a0_ . contrat AS contrat_13 , a0_ . rythme AS rythme_14 , a0_ . date_debut AS date_debut_15 , a0_ . diplome AS diplome_16 , a0_ . annee_experience AS annee_experience_17 , a0_ . outils_logiciels AS outils_logiciels_18 , a0_ . softs AS softs_19 , a0_ . salaire AS salaire_20 , a0_ . a_propos_cabinet AS a_propos_cabinet_21 , a0_ . teletravail AS teletravail_22 , a0_ . accounting_firm_id AS accounting_firm_id_23 FROM announcement a0_ WHERE a0_ . accounting_firm_id = ? AND a0_ . website = ? AND a0_ . is_spontanee = ? ORDER BY a0_ . id ASC LIMIT 1
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . description AS description_2 , a0_ . website AS website_3 , a0_ . reference AS reference_4 , a0_ . slug AS slug_5 , a0_ . is_primary AS is_primary_6 , a0_ . is_spontanee AS is_spontanee_7 , a0_ . img AS img_8 , a0_ . info2 AS info2_9 , a0_ . info3 AS info3_10 , a0_ . info4 AS info4_11 , a0_ . info5 AS info5_12 , a0_ . contrat AS contrat_13 , a0_ . rythme AS rythme_14 , a0_ . date_debut AS date_debut_15 , a0_ . diplome AS diplome_16 , a0_ . annee_experience AS annee_experience_17 , a0_ . outils_logiciels AS outils_logiciels_18 , a0_ . softs AS softs_19 , a0_ . salaire AS salaire_20 , a0_ . a_propos_cabinet AS a_propos_cabinet_21 , a0_ . teletravail AS teletravail_22 , a0_ . accounting_firm_id AS accounting_firm_id_23 FROM announcement a0_ WHERE a0_ . accounting_firm_id = '69' AND a0_ . website = 1 AND a0_ . is_spontanee = 1 ORDER BY a0_ . id ASC LIMIT 1 ;
Copy
7
0.67 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . firstname AS firstname_3 , t0 . roles AS roles_4 , t0 . password AS password_5 , t0 . avatar AS avatar_6 , t0 . activation_token AS activation_token_7 , t0 . notification_sent AS notification_sent_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . accounting_firm_id AS accounting_firm_id_11 , t12 . id AS id_13 , t12 . nom AS nom_14 , t12 . mail AS mail_15 , t12 . url AS url_16 , t12 . adresse AS adresse_17 , t12 . cp AS cp_18 , t12 . ville AS ville_19 , t12 . telephone AS telephone_20 , t12 . domain_activate AS domain_activate_21 , t12 . bAbonnementCalendrier AS bAbonnementCalendrier_22 , t12 . newsletterCouleur AS newsletterCouleur_23 , t12 . dateCreation AS dateCreation_24 , t12 . version AS version_25 , t12 . actuv2_token AS actuv2_token_26 , t12 . actuv2_referer AS actuv2_referer_27 , t12 . actuv2_widgetUrl AS actuv2_widgetUrl_28 , t12 . actuv2_colorPrimary AS actuv2_colorPrimary_29 , t12 . actuv2_colorSecondary AS actuv2_colorSecondary_30 , t12 . actuv2_urlContact AS actuv2_urlContact_31 , t12 . host AS host_32 , t12 . website_created_at AS website_created_at_33 , t12 . idsellsy AS idsellsy_34 , t12 . simulateur_token AS simulateur_token_35 , t12 . simulateur_widget_url AS simulateur_widget_url_36 , t12 . rgpd_token AS rgpd_token_37 , t12 . rgpd_widget_url AS rgpd_widget_url_38 , t12 . ce_token AS ce_token_39 , t12 . ce_widget_url AS ce_widget_url_40 , t12 . tous_en_ligne_token AS tous_en_ligne_token_41 , t12 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_42 , t12 . rgpd_sender AS rgpd_sender_43 , t12 . rgpd_sender_name AS rgpd_sender_name_44 , t12 . rgpd_expert_externe_use AS rgpd_expert_externe_use_45 , t12 . ce_sender AS ce_sender_46 , t12 . ce_sender_name AS ce_sender_name_47 , t12 . ce_expert_externe_use AS ce_expert_externe_use_48 , t12 . cir_sender AS cir_sender_49 , t12 . cir_sender_name AS cir_sender_name_50 , t12 . cir_expert_externe_use AS cir_expert_externe_use_51 , t12 . cir_token AS cir_token_52 , t12 . cir_widget_url AS cir_widget_url_53 , t12 . mailing_module AS mailing_module_54 , t12 . mailing_sender AS mailing_sender_55 , t12 . mailing_header AS mailing_header_56 , t12 . logo_cabinet AS logo_cabinet_57 , t12 . vcard_access AS vcard_access_58 , t12 . last_update AS last_update_59 , t12 . dark_theme AS dark_theme_60 , t12 . appelle_ton_ec_token AS appelle_ton_ec_token_61 , t12 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_62 , t12 . gmb_enable AS gmb_enable_63 , t12 . actuv2_not_ec AS actuv2_not_ec_64 , t12 . actuv2_only_podcast AS actuv2_only_podcast_65 , t12 . gmb_url AS gmb_url_66 , t12 . gmb_name AS gmb_name_67 , t12 . calendly_url AS calendly_url_68 , t12 . survey_client_requested AS survey_client_requested_69 , t12 . survey_client_activate AS survey_client_activate_70 , t12 . podcast_intro_filename AS podcast_intro_filename_71 , t12 . enable_podcast_private AS enable_podcast_private_72 , t12 . podcast_private_student AS podcast_private_student_73 , t12 . podcast_private_token AS podcast_private_token_74 , t12 . podcast_private_widget_url AS podcast_private_widget_url_75 , t12 . subscriber_podcast_private AS subscriber_podcast_private_76 , t12 . logo_pal_path AS logo_pal_path_77 , t12 . google_analytics_id AS google_analytics_id_78 , t12 . email_nl_actu_test AS email_nl_actu_test_79 , t12 . helpers_firms_token AS helpers_firms_token_80 , t12 . helpers_firms_widget_url AS helpers_firms_widget_url_81 , t12 . emailing_client_activate AS emailing_client_activate_82 , t12 . emailing_client_token_max AS emailing_client_token_max_83 , t12 . emailing_client_sender AS emailing_client_sender_84 , t12 . sms_client_activate AS sms_client_activate_85 , t12 . sms_client_credit_max AS sms_client_credit_max_86 , t12 . sms_client_sender AS sms_client_sender_87 , t12 . sms_client_sender_label AS sms_client_sender_label_88 , t12 . anniversaire_client_sender AS anniversaire_client_sender_89 , t12 . anniversaire_client_activate AS anniversaire_client_activate_90 , t12 . event_token AS event_token_91 , t12 . event_widget_url AS event_widget_url_92 , t12 . event_client_requested AS event_client_requested_93 , t12 . sponsorship_token AS sponsorship_token_94 , t12 . sponsorship_widget_url AS sponsorship_widget_url_95 , t12 . sponsorship_client_requested AS sponsorship_client_requested_96 , t12 . sponsorship_client_activate AS sponsorship_client_activate_97 , t12 . recommendation_token AS recommendation_token_98 , t12 . recommendation_widget_url AS recommendation_widget_url_99 , t12 . recommendation_client_requested AS recommendation_client_requested_100 , t12 . recommendation_client_activate AS recommendation_client_activate_101 , t12 . survey_token AS survey_token_102 , t12 . survey_widget_url AS survey_widget_url_103 , t12 . satisfaction_token AS satisfaction_token_104 , t12 . satisfaction_widget_url AS satisfaction_widget_url_105 , t12 . electronic_invoice_token AS electronic_invoice_token_106 , t12 . electronic_invoice_widget_url AS electronic_invoice_widget_url_107 , t12 . satisfaction_client_activate AS satisfaction_client_activate_108 , t12 . card_trello_event_create AS card_trello_event_create_109 , t12 . card_trello_satisfaction_create AS card_trello_satisfaction_create_110 , t12 . platform_enabled AS platform_enabled_111 , t12 . sepa_prelevement_date AS sepa_prelevement_date_112 , t12 . onboarding_replay_url AS onboarding_replay_url_113 , t12 . onboarding_replay_notified_at AS onboarding_replay_notified_at_114 , t12 . onboarding_replay_code AS onboarding_replay_code_115 , t12 . linkedin_username AS linkedin_username_116 , t12 . linkedin_password AS linkedin_password_117 , t12 . linkedin_password_updated_at AS linkedin_password_updated_at_118 , t12 . mailing_api_id AS mailing_api_id_119 , t12 . rgpd_expert_id AS rgpd_expert_id_120 , t12 . ce_expert_id AS ce_expert_id_121 , t12 . cir_expert_id AS cir_expert_id_122 , t12 . emailing_client_api_id AS emailing_client_api_id_123 , t0 . affiliate_id AS affiliate_id_124 FROM user t0 LEFT JOIN cabinet t12 ON t0 . accounting_firm_id = t12 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . email AS email_2 ,
t0 . firstname AS firstname_3 ,
t0 . roles AS roles_4 ,
t0 . password AS password_5 ,
t0 . avatar AS avatar_6 ,
t0 . activation_token AS activation_token_7 ,
t0 . notification_sent AS notification_sent_8 ,
t0 . created_at AS created_at_9 ,
t0 . updated_at AS updated_at_10 ,
t0 . accounting_firm_id AS accounting_firm_id_11 ,
t12 . id AS id_13 ,
t12 . nom AS nom_14 ,
t12 . mail AS mail_15 ,
t12 . url AS url_16 ,
t12 . adresse AS adresse_17 ,
t12 . cp AS cp_18 ,
t12 . ville AS ville_19 ,
t12 . telephone AS telephone_20 ,
t12 . domain_activate AS domain_activate_21 ,
t12 . bAbonnementCalendrier AS bAbonnementCalendrier_22 ,
t12 . newsletterCouleur AS newsletterCouleur_23 ,
t12 . dateCreation AS dateCreation_24 ,
t12 . version AS version_25 ,
t12 . actuv2_token AS actuv2_token_26 ,
t12 . actuv2_referer AS actuv2_referer_27 ,
t12 . actuv2_widgetUrl AS actuv2_widgetUrl_28 ,
t12 . actuv2_colorPrimary AS actuv2_colorPrimary_29 ,
t12 . actuv2_colorSecondary AS actuv2_colorSecondary_30 ,
t12 . actuv2_urlContact AS actuv2_urlContact_31 ,
t12 . host AS host_32 ,
t12 . website_created_at AS website_created_at_33 ,
t12 . idsellsy AS idsellsy_34 ,
t12 . simulateur_token AS simulateur_token_35 ,
t12 . simulateur_widget_url AS simulateur_widget_url_36 ,
t12 . rgpd_token AS rgpd_token_37 ,
t12 . rgpd_widget_url AS rgpd_widget_url_38 ,
t12 . ce_token AS ce_token_39 ,
t12 . ce_widget_url AS ce_widget_url_40 ,
t12 . tous_en_ligne_token AS tous_en_ligne_token_41 ,
t12 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_42 ,
t12 . rgpd_sender AS rgpd_sender_43 ,
t12 . rgpd_sender_name AS rgpd_sender_name_44 ,
t12 . rgpd_expert_externe_use AS rgpd_expert_externe_use_45 ,
t12 . ce_sender AS ce_sender_46 ,
t12 . ce_sender_name AS ce_sender_name_47 ,
t12 . ce_expert_externe_use AS ce_expert_externe_use_48 ,
t12 . cir_sender AS cir_sender_49 ,
t12 . cir_sender_name AS cir_sender_name_50 ,
t12 . cir_expert_externe_use AS cir_expert_externe_use_51 ,
t12 . cir_token AS cir_token_52 ,
t12 . cir_widget_url AS cir_widget_url_53 ,
t12 . mailing_module AS mailing_module_54 ,
t12 . mailing_sender AS mailing_sender_55 ,
t12 . mailing_header AS mailing_header_56 ,
t12 . logo_cabinet AS logo_cabinet_57 ,
t12 . vcard_access AS vcard_access_58 ,
t12 . last_update AS last_update_59 ,
t12 . dark_theme AS dark_theme_60 ,
t12 . appelle_ton_ec_token AS appelle_ton_ec_token_61 ,
t12 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_62 ,
t12 . gmb_enable AS gmb_enable_63 ,
t12 . actuv2_not_ec AS actuv2_not_ec_64 ,
t12 . actuv2_only_podcast AS actuv2_only_podcast_65 ,
t12 . gmb_url AS gmb_url_66 ,
t12 . gmb_name AS gmb_name_67 ,
t12 . calendly_url AS calendly_url_68 ,
t12 . survey_client_requested AS survey_client_requested_69 ,
t12 . survey_client_activate AS survey_client_activate_70 ,
t12 . podcast_intro_filename AS podcast_intro_filename_71 ,
t12 . enable_podcast_private AS enable_podcast_private_72 ,
t12 . podcast_private_student AS podcast_private_student_73 ,
t12 . podcast_private_token AS podcast_private_token_74 ,
t12 . podcast_private_widget_url AS podcast_private_widget_url_75 ,
t12 . subscriber_podcast_private AS subscriber_podcast_private_76 ,
t12 . logo_pal_path AS logo_pal_path_77 ,
t12 . google_analytics_id AS google_analytics_id_78 ,
t12 . email_nl_actu_test AS email_nl_actu_test_79 ,
t12 . helpers_firms_token AS helpers_firms_token_80 ,
t12 . helpers_firms_widget_url AS helpers_firms_widget_url_81 ,
t12 . emailing_client_activate AS emailing_client_activate_82 ,
t12 . emailing_client_token_max AS emailing_client_token_max_83 ,
t12 . emailing_client_sender AS emailing_client_sender_84 ,
t12 . sms_client_activate AS sms_client_activate_85 ,
t12 . sms_client_credit_max AS sms_client_credit_max_86 ,
t12 . sms_client_sender AS sms_client_sender_87 ,
t12 . sms_client_sender_label AS sms_client_sender_label_88 ,
t12 . anniversaire_client_sender AS anniversaire_client_sender_89 ,
t12 . anniversaire_client_activate AS anniversaire_client_activate_90 ,
t12 . event_token AS event_token_91 ,
t12 . event_widget_url AS event_widget_url_92 ,
t12 . event_client_requested AS event_client_requested_93 ,
t12 . sponsorship_token AS sponsorship_token_94 ,
t12 . sponsorship_widget_url AS sponsorship_widget_url_95 ,
t12 . sponsorship_client_requested AS sponsorship_client_requested_96 ,
t12 . sponsorship_client_activate AS sponsorship_client_activate_97 ,
t12 . recommendation_token AS recommendation_token_98 ,
t12 . recommendation_widget_url AS recommendation_widget_url_99 ,
t12 . recommendation_client_requested AS recommendation_client_requested_100 ,
t12 . recommendation_client_activate AS recommendation_client_activate_101 ,
t12 . survey_token AS survey_token_102 ,
t12 . survey_widget_url AS survey_widget_url_103 ,
t12 . satisfaction_token AS satisfaction_token_104 ,
t12 . satisfaction_widget_url AS satisfaction_widget_url_105 ,
t12 . electronic_invoice_token AS electronic_invoice_token_106 ,
t12 . electronic_invoice_widget_url AS electronic_invoice_widget_url_107 ,
t12 . satisfaction_client_activate AS satisfaction_client_activate_108 ,
t12 . card_trello_event_create AS card_trello_event_create_109 ,
t12 . card_trello_satisfaction_create AS card_trello_satisfaction_create_110 ,
t12 . platform_enabled AS platform_enabled_111 ,
t12 . sepa_prelevement_date AS sepa_prelevement_date_112 ,
t12 . onboarding_replay_url AS onboarding_replay_url_113 ,
t12 . onboarding_replay_notified_at AS onboarding_replay_notified_at_114 ,
t12 . onboarding_replay_code AS onboarding_replay_code_115 ,
t12 . linkedin_username AS linkedin_username_116 ,
t12 . linkedin_password AS linkedin_password_117 ,
t12 . linkedin_password_updated_at AS linkedin_password_updated_at_118 ,
t12 . mailing_api_id AS mailing_api_id_119 ,
t12 . rgpd_expert_id AS rgpd_expert_id_120 ,
t12 . ce_expert_id AS ce_expert_id_121 ,
t12 . cir_expert_id AS cir_expert_id_122 ,
t12 . emailing_client_api_id AS emailing_client_api_id_123 ,
t0 . affiliate_id AS affiliate_id_124
FROM
user t0
LEFT JOIN cabinet t12 ON t0 . accounting_firm_id = t12 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . firstname AS firstname_3 , t0 . roles AS roles_4 , t0 . password AS password_5 , t0 . avatar AS avatar_6 , t0 . activation_token AS activation_token_7 , t0 . notification_sent AS notification_sent_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . accounting_firm_id AS accounting_firm_id_11 , t12 . id AS id_13 , t12 . nom AS nom_14 , t12 . mail AS mail_15 , t12 . url AS url_16 , t12 . adresse AS adresse_17 , t12 . cp AS cp_18 , t12 . ville AS ville_19 , t12 . telephone AS telephone_20 , t12 . domain_activate AS domain_activate_21 , t12 . bAbonnementCalendrier AS bAbonnementCalendrier_22 , t12 . newsletterCouleur AS newsletterCouleur_23 , t12 . dateCreation AS dateCreation_24 , t12 . version AS version_25 , t12 . actuv2_token AS actuv2_token_26 , t12 . actuv2_referer AS actuv2_referer_27 , t12 . actuv2_widgetUrl AS actuv2_widgetUrl_28 , t12 . actuv2_colorPrimary AS actuv2_colorPrimary_29 , t12 . actuv2_colorSecondary AS actuv2_colorSecondary_30 , t12 . actuv2_urlContact AS actuv2_urlContact_31 , t12 . host AS host_32 , t12 . website_created_at AS website_created_at_33 , t12 . idsellsy AS idsellsy_34 , t12 . simulateur_token AS simulateur_token_35 , t12 . simulateur_widget_url AS simulateur_widget_url_36 , t12 . rgpd_token AS rgpd_token_37 , t12 . rgpd_widget_url AS rgpd_widget_url_38 , t12 . ce_token AS ce_token_39 , t12 . ce_widget_url AS ce_widget_url_40 , t12 . tous_en_ligne_token AS tous_en_ligne_token_41 , t12 . tous_en_ligne_widget_url AS tous_en_ligne_widget_url_42 , t12 . rgpd_sender AS rgpd_sender_43 , t12 . rgpd_sender_name AS rgpd_sender_name_44 , t12 . rgpd_expert_externe_use AS rgpd_expert_externe_use_45 , t12 . ce_sender AS ce_sender_46 , t12 . ce_sender_name AS ce_sender_name_47 , t12 . ce_expert_externe_use AS ce_expert_externe_use_48 , t12 . cir_sender AS cir_sender_49 , t12 . cir_sender_name AS cir_sender_name_50 , t12 . cir_expert_externe_use AS cir_expert_externe_use_51 , t12 . cir_token AS cir_token_52 , t12 . cir_widget_url AS cir_widget_url_53 , t12 . mailing_module AS mailing_module_54 , t12 . mailing_sender AS mailing_sender_55 , t12 . mailing_header AS mailing_header_56 , t12 . logo_cabinet AS logo_cabinet_57 , t12 . vcard_access AS vcard_access_58 , t12 . last_update AS last_update_59 , t12 . dark_theme AS dark_theme_60 , t12 . appelle_ton_ec_token AS appelle_ton_ec_token_61 , t12 . appelle_ton_ec_widget_url AS appelle_ton_ec_widget_url_62 , t12 . gmb_enable AS gmb_enable_63 , t12 . actuv2_not_ec AS actuv2_not_ec_64 , t12 . actuv2_only_podcast AS actuv2_only_podcast_65 , t12 . gmb_url AS gmb_url_66 , t12 . gmb_name AS gmb_name_67 , t12 . calendly_url AS calendly_url_68 , t12 . survey_client_requested AS survey_client_requested_69 , t12 . survey_client_activate AS survey_client_activate_70 , t12 . podcast_intro_filename AS podcast_intro_filename_71 , t12 . enable_podcast_private AS enable_podcast_private_72 , t12 . podcast_private_student AS podcast_private_student_73 , t12 . podcast_private_token AS podcast_private_token_74 , t12 . podcast_private_widget_url AS podcast_private_widget_url_75 , t12 . subscriber_podcast_private AS subscriber_podcast_private_76 , t12 . logo_pal_path AS logo_pal_path_77 , t12 . google_analytics_id AS google_analytics_id_78 , t12 . email_nl_actu_test AS email_nl_actu_test_79 , t12 . helpers_firms_token AS helpers_firms_token_80 , t12 . helpers_firms_widget_url AS helpers_firms_widget_url_81 , t12 . emailing_client_activate AS emailing_client_activate_82 , t12 . emailing_client_token_max AS emailing_client_token_max_83 , t12 . emailing_client_sender AS emailing_client_sender_84 , t12 . sms_client_activate AS sms_client_activate_85 , t12 . sms_client_credit_max AS sms_client_credit_max_86 , t12 . sms_client_sender AS sms_client_sender_87 , t12 . sms_client_sender_label AS sms_client_sender_label_88 , t12 . anniversaire_client_sender AS anniversaire_client_sender_89 , t12 . anniversaire_client_activate AS anniversaire_client_activate_90 , t12 . event_token AS event_token_91 , t12 . event_widget_url AS event_widget_url_92 , t12 . event_client_requested AS event_client_requested_93 , t12 . sponsorship_token AS sponsorship_token_94 , t12 . sponsorship_widget_url AS sponsorship_widget_url_95 , t12 . sponsorship_client_requested AS sponsorship_client_requested_96 , t12 . sponsorship_client_activate AS sponsorship_client_activate_97 , t12 . recommendation_token AS recommendation_token_98 , t12 . recommendation_widget_url AS recommendation_widget_url_99 , t12 . recommendation_client_requested AS recommendation_client_requested_100 , t12 . recommendation_client_activate AS recommendation_client_activate_101 , t12 . survey_token AS survey_token_102 , t12 . survey_widget_url AS survey_widget_url_103 , t12 . satisfaction_token AS satisfaction_token_104 , t12 . satisfaction_widget_url AS satisfaction_widget_url_105 , t12 . electronic_invoice_token AS electronic_invoice_token_106 , t12 . electronic_invoice_widget_url AS electronic_invoice_widget_url_107 , t12 . satisfaction_client_activate AS satisfaction_client_activate_108 , t12 . card_trello_event_create AS card_trello_event_create_109 , t12 . card_trello_satisfaction_create AS card_trello_satisfaction_create_110 , t12 . platform_enabled AS platform_enabled_111 , t12 . sepa_prelevement_date AS sepa_prelevement_date_112 , t12 . onboarding_replay_url AS onboarding_replay_url_113 , t12 . onboarding_replay_notified_at AS onboarding_replay_notified_at_114 , t12 . onboarding_replay_code AS onboarding_replay_code_115 , t12 . linkedin_username AS linkedin_username_116 , t12 . linkedin_password AS linkedin_password_117 , t12 . linkedin_password_updated_at AS linkedin_password_updated_at_118 , t12 . mailing_api_id AS mailing_api_id_119 , t12 . rgpd_expert_id AS rgpd_expert_id_120 , t12 . ce_expert_id AS ce_expert_id_121 , t12 . cir_expert_id AS cir_expert_id_122 , t12 . emailing_client_api_id AS emailing_client_api_id_123 , t0 . affiliate_id AS affiliate_id_124 FROM user t0 LEFT JOIN cabinet t12 ON t0 . accounting_firm_id = t12 . id WHERE t0 . id = 82 ;
Copy
8
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . cfid_parent AS cfid_parent_3 , t0 . id_sellsy AS id_sellsy_4 , t0 . parent_name AS parent_name_5 , t0 . type_field AS type_field_6 FROM module_type t0 INNER JOIN accounting_firm_module_type ON t0 . id = accounting_firm_module_type . module_type_id WHERE accounting_firm_module_type . accounting_firm_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . cfid_parent AS cfid_parent_3 , t0 . id_sellsy AS id_sellsy_4 , t0 . parent_name AS parent_name_5 , t0 . type_field AS type_field_6 FROM module_type t0 INNER JOIN accounting_firm_module_type ON t0 . id = accounting_firm_module_type . module_type_id WHERE accounting_firm_module_type . accounting_firm_id = '69' ;
Copy