1
1.08 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 . google_place_id AS google_place_id_56 , t0 . calendly_url AS calendly_url_57 , t0 . survey_client_requested AS survey_client_requested_58 , t0 . survey_client_activate AS survey_client_activate_59 , t0 . podcast_intro_filename AS podcast_intro_filename_60 , t0 . enable_podcast_private AS enable_podcast_private_61 , t0 . podcast_private_student AS podcast_private_student_62 , t0 . podcast_private_token AS podcast_private_token_63 , t0 . podcast_private_widget_url AS podcast_private_widget_url_64 , t0 . subscriber_podcast_private AS subscriber_podcast_private_65 , t0 . logo_pal_path AS logo_pal_path_66 , t0 . google_analytics_id AS google_analytics_id_67 , t0 . email_nl_actu_test AS email_nl_actu_test_68 , t0 . helpers_firms_token AS helpers_firms_token_69 , t0 . helpers_firms_widget_url AS helpers_firms_widget_url_70 , t0 . emailing_client_activate AS emailing_client_activate_71 , t0 . emailing_client_token_max AS emailing_client_token_max_72 , t0 . emailing_client_sender AS emailing_client_sender_73 , t0 . sms_client_activate AS sms_client_activate_74 , t0 . sms_client_credit_max AS sms_client_credit_max_75 , t0 . sms_client_sender AS sms_client_sender_76 , t0 . sms_client_sender_label AS sms_client_sender_label_77 , t0 . anniversaire_client_sender AS anniversaire_client_sender_78 , t0 . anniversaire_client_activate AS anniversaire_client_activate_79 , t0 . event_token AS event_token_80 , t0 . event_widget_url AS event_widget_url_81 , t0 . event_client_requested AS event_client_requested_82 , t0 . sponsorship_token AS sponsorship_token_83 , t0 . sponsorship_widget_url AS sponsorship_widget_url_84 , t0 . sponsorship_client_requested AS sponsorship_client_requested_85 , t0 . sponsorship_client_activate AS sponsorship_client_activate_86 , t0 . recommendation_token AS recommendation_token_87 , t0 . recommendation_widget_url AS recommendation_widget_url_88 , t0 . recommendation_client_requested AS recommendation_client_requested_89 , t0 . recommendation_client_activate AS recommendation_client_activate_90 , t0 . survey_token AS survey_token_91 , t0 . survey_widget_url AS survey_widget_url_92 , t0 . cjec_token AS cjec_token_93 , t0 . cjec_widget_url AS cjec_widget_url_94 , t0 . satisfaction_token AS satisfaction_token_95 , t0 . satisfaction_widget_url AS satisfaction_widget_url_96 , t0 . electronic_invoice_token AS electronic_invoice_token_97 , t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_98 , t0 . satisfaction_client_activate AS satisfaction_client_activate_99 , t0 . card_trello_event_create AS card_trello_event_create_100 , t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_101 , t0 . platform_enabled AS platform_enabled_102 , t0 . sepa_prelevement_date AS sepa_prelevement_date_103 , t0 . onboarding_replay_url AS onboarding_replay_url_104 , t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_105 , t0 . onboarding_replay_code AS onboarding_replay_code_106 , t0 . linkedin_username AS linkedin_username_107 , t0 . linkedin_password AS linkedin_password_108 , t0 . linkedin_password_updated_at AS linkedin_password_updated_at_109 , t110 . id AS id_111 , t110 . description AS description_112 , t110 . website AS website_113 , t110 . end_date_time AS end_date_time_114 , t110 . accounting_firm_id AS accounting_firm_id_115 , t116 . id AS id_117 , t116 . modules AS modules_118 , t116 . website_news_links AS website_news_links_119 , t116 . website_news_images AS website_news_images_120 , t116 . website_news_documents AS website_news_documents_121 , t116 . website_news_max_image_size AS website_news_max_image_size_122 , t116 . website_news_max_document_size AS website_news_max_document_size_123 , t116 . ebook_max_image_size AS ebook_max_image_size_124 , t116 . ebook_max_document_size AS ebook_max_document_size_125 , t116 . ebook_documents AS ebook_documents_126 , t116 . ebook_images AS ebook_images_127 , t116 . web_mail AS web_mail_128 , t116 . google_tag_manager AS google_tag_manager_129 , t116 . google_analytics AS google_analytics_130 , t116 . domain_type AS domain_type_131 , t116 . seo_meta_title AS seo_meta_title_132 , t116 . seo_meta_description AS seo_meta_description_133 , t116 . google_recaptcha_site_key AS google_recaptcha_site_key_134 , t116 . google_recaptcha_secret AS google_recaptcha_secret_135 , t116 . favicon AS favicon_136 , t116 . web_mail_recrutement AS web_mail_recrutement_137 , t116 . maintenance AS maintenance_138 , t116 . construction AS construction_139 , t116 . monetico_tpe AS monetico_tpe_140 , t116 . monetico_societe AS monetico_societe_141 , t116 . monetico_cle AS monetico_cle_142 , t116 . accounting_firm_id AS accounting_firm_id_143 , t116 . mailjetapi_id AS mailjetapi_id_144 , t116 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_145 , t146 . id AS id_147 , t146 . updated_at AS updated_at_148 , t146 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_149 , t146 . accounting_firm_id AS accounting_firm_id_150 , t0 . mailing_api_id AS mailing_api_id_151 , t0 . rgpd_expert_id AS rgpd_expert_id_152 , t0 . ce_expert_id AS ce_expert_id_153 , t0 . cir_expert_id AS cir_expert_id_154 , t0 . emailing_client_api_id AS emailing_client_api_id_155 , t156 . id AS id_157 , t156 . gmb_score AS gmb_score_158 , t156 . last_mail_sent_at AS last_mail_sent_at_159 , t156 . trello_card_id AS trello_card_id_160 , t156 . client_emails AS client_emails_161 , t156 . created_at AS created_at_162 , t156 . updated_at AS updated_at_163 , t156 . step AS step_164 , t156 . emails_sent_count AS emails_sent_count_165 , t156 . last_lot_sent_at AS last_lot_sent_at_166 , t156 . accounting_firm_id AS accounting_firm_id_167 FROM cabinet t0 LEFT JOIN primary_news t110 ON t110 . accounting_firm_id = t0 . id LEFT JOIN parameters t116 ON t116 . accounting_firm_id = t0 . id LEFT JOIN identite_visuelle t146 ON t146 . accounting_firm_id = t0 . id LEFT JOIN pipeline_gmb_avis t156 ON t156 . accounting_firm_id = t0 . id WHERE t0 . host = ? LIMIT 1
Parameters :
[
"fjconseils.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 . google_place_id AS google_place_id_56 ,
t0 . calendly_url AS calendly_url_57 ,
t0 . survey_client_requested AS survey_client_requested_58 ,
t0 . survey_client_activate AS survey_client_activate_59 ,
t0 . podcast_intro_filename AS podcast_intro_filename_60 ,
t0 . enable_podcast_private AS enable_podcast_private_61 ,
t0 . podcast_private_student AS podcast_private_student_62 ,
t0 . podcast_private_token AS podcast_private_token_63 ,
t0 . podcast_private_widget_url AS podcast_private_widget_url_64 ,
t0 . subscriber_podcast_private AS subscriber_podcast_private_65 ,
t0 . logo_pal_path AS logo_pal_path_66 ,
t0 . google_analytics_id AS google_analytics_id_67 ,
t0 . email_nl_actu_test AS email_nl_actu_test_68 ,
t0 . helpers_firms_token AS helpers_firms_token_69 ,
t0 . helpers_firms_widget_url AS helpers_firms_widget_url_70 ,
t0 . emailing_client_activate AS emailing_client_activate_71 ,
t0 . emailing_client_token_max AS emailing_client_token_max_72 ,
t0 . emailing_client_sender AS emailing_client_sender_73 ,
t0 . sms_client_activate AS sms_client_activate_74 ,
t0 . sms_client_credit_max AS sms_client_credit_max_75 ,
t0 . sms_client_sender AS sms_client_sender_76 ,
t0 . sms_client_sender_label AS sms_client_sender_label_77 ,
t0 . anniversaire_client_sender AS anniversaire_client_sender_78 ,
t0 . anniversaire_client_activate AS anniversaire_client_activate_79 ,
t0 . event_token AS event_token_80 ,
t0 . event_widget_url AS event_widget_url_81 ,
t0 . event_client_requested AS event_client_requested_82 ,
t0 . sponsorship_token AS sponsorship_token_83 ,
t0 . sponsorship_widget_url AS sponsorship_widget_url_84 ,
t0 . sponsorship_client_requested AS sponsorship_client_requested_85 ,
t0 . sponsorship_client_activate AS sponsorship_client_activate_86 ,
t0 . recommendation_token AS recommendation_token_87 ,
t0 . recommendation_widget_url AS recommendation_widget_url_88 ,
t0 . recommendation_client_requested AS recommendation_client_requested_89 ,
t0 . recommendation_client_activate AS recommendation_client_activate_90 ,
t0 . survey_token AS survey_token_91 ,
t0 . survey_widget_url AS survey_widget_url_92 ,
t0 . cjec_token AS cjec_token_93 ,
t0 . cjec_widget_url AS cjec_widget_url_94 ,
t0 . satisfaction_token AS satisfaction_token_95 ,
t0 . satisfaction_widget_url AS satisfaction_widget_url_96 ,
t0 . electronic_invoice_token AS electronic_invoice_token_97 ,
t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_98 ,
t0 . satisfaction_client_activate AS satisfaction_client_activate_99 ,
t0 . card_trello_event_create AS card_trello_event_create_100 ,
t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_101 ,
t0 . platform_enabled AS platform_enabled_102 ,
t0 . sepa_prelevement_date AS sepa_prelevement_date_103 ,
t0 . onboarding_replay_url AS onboarding_replay_url_104 ,
t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_105 ,
t0 . onboarding_replay_code AS onboarding_replay_code_106 ,
t0 . linkedin_username AS linkedin_username_107 ,
t0 . linkedin_password AS linkedin_password_108 ,
t0 . linkedin_password_updated_at AS linkedin_password_updated_at_109 ,
t110 . id AS id_111 ,
t110 . description AS description_112 ,
t110 . website AS website_113 ,
t110 . end_date_time AS end_date_time_114 ,
t110 . accounting_firm_id AS accounting_firm_id_115 ,
t116 . id AS id_117 ,
t116 . modules AS modules_118 ,
t116 . website_news_links AS website_news_links_119 ,
t116 . website_news_images AS website_news_images_120 ,
t116 . website_news_documents AS website_news_documents_121 ,
t116 . website_news_max_image_size AS website_news_max_image_size_122 ,
t116 . website_news_max_document_size AS website_news_max_document_size_123 ,
t116 . ebook_max_image_size AS ebook_max_image_size_124 ,
t116 . ebook_max_document_size AS ebook_max_document_size_125 ,
t116 . ebook_documents AS ebook_documents_126 ,
t116 . ebook_images AS ebook_images_127 ,
t116 . web_mail AS web_mail_128 ,
t116 . google_tag_manager AS google_tag_manager_129 ,
t116 . google_analytics AS google_analytics_130 ,
t116 . domain_type AS domain_type_131 ,
t116 . seo_meta_title AS seo_meta_title_132 ,
t116 . seo_meta_description AS seo_meta_description_133 ,
t116 . google_recaptcha_site_key AS google_recaptcha_site_key_134 ,
t116 . google_recaptcha_secret AS google_recaptcha_secret_135 ,
t116 . favicon AS favicon_136 ,
t116 . web_mail_recrutement AS web_mail_recrutement_137 ,
t116 . maintenance AS maintenance_138 ,
t116 . construction AS construction_139 ,
t116 . monetico_tpe AS monetico_tpe_140 ,
t116 . monetico_societe AS monetico_societe_141 ,
t116 . monetico_cle AS monetico_cle_142 ,
t116 . accounting_firm_id AS accounting_firm_id_143 ,
t116 . mailjetapi_id AS mailjetapi_id_144 ,
t116 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_145 ,
t146 . id AS id_147 ,
t146 . updated_at AS updated_at_148 ,
t146 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_149 ,
t146 . accounting_firm_id AS accounting_firm_id_150 ,
t0 . mailing_api_id AS mailing_api_id_151 ,
t0 . rgpd_expert_id AS rgpd_expert_id_152 ,
t0 . ce_expert_id AS ce_expert_id_153 ,
t0 . cir_expert_id AS cir_expert_id_154 ,
t0 . emailing_client_api_id AS emailing_client_api_id_155 ,
t156 . id AS id_157 ,
t156 . gmb_score AS gmb_score_158 ,
t156 . last_mail_sent_at AS last_mail_sent_at_159 ,
t156 . trello_card_id AS trello_card_id_160 ,
t156 . client_emails AS client_emails_161 ,
t156 . created_at AS created_at_162 ,
t156 . updated_at AS updated_at_163 ,
t156 . step AS step_164 ,
t156 . emails_sent_count AS emails_sent_count_165 ,
t156 . last_lot_sent_at AS last_lot_sent_at_166 ,
t156 . accounting_firm_id AS accounting_firm_id_167
FROM
cabinet t0
LEFT JOIN primary_news t110 ON t110 . accounting_firm_id = t0 . id
LEFT JOIN parameters t116 ON t116 . accounting_firm_id = t0 . id
LEFT JOIN identite_visuelle t146 ON t146 . accounting_firm_id = t0 . id
LEFT JOIN pipeline_gmb_avis t156 ON t156 . 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 . google_place_id AS google_place_id_56 , t0 . calendly_url AS calendly_url_57 , t0 . survey_client_requested AS survey_client_requested_58 , t0 . survey_client_activate AS survey_client_activate_59 , t0 . podcast_intro_filename AS podcast_intro_filename_60 , t0 . enable_podcast_private AS enable_podcast_private_61 , t0 . podcast_private_student AS podcast_private_student_62 , t0 . podcast_private_token AS podcast_private_token_63 , t0 . podcast_private_widget_url AS podcast_private_widget_url_64 , t0 . subscriber_podcast_private AS subscriber_podcast_private_65 , t0 . logo_pal_path AS logo_pal_path_66 , t0 . google_analytics_id AS google_analytics_id_67 , t0 . email_nl_actu_test AS email_nl_actu_test_68 , t0 . helpers_firms_token AS helpers_firms_token_69 , t0 . helpers_firms_widget_url AS helpers_firms_widget_url_70 , t0 . emailing_client_activate AS emailing_client_activate_71 , t0 . emailing_client_token_max AS emailing_client_token_max_72 , t0 . emailing_client_sender AS emailing_client_sender_73 , t0 . sms_client_activate AS sms_client_activate_74 , t0 . sms_client_credit_max AS sms_client_credit_max_75 , t0 . sms_client_sender AS sms_client_sender_76 , t0 . sms_client_sender_label AS sms_client_sender_label_77 , t0 . anniversaire_client_sender AS anniversaire_client_sender_78 , t0 . anniversaire_client_activate AS anniversaire_client_activate_79 , t0 . event_token AS event_token_80 , t0 . event_widget_url AS event_widget_url_81 , t0 . event_client_requested AS event_client_requested_82 , t0 . sponsorship_token AS sponsorship_token_83 , t0 . sponsorship_widget_url AS sponsorship_widget_url_84 , t0 . sponsorship_client_requested AS sponsorship_client_requested_85 , t0 . sponsorship_client_activate AS sponsorship_client_activate_86 , t0 . recommendation_token AS recommendation_token_87 , t0 . recommendation_widget_url AS recommendation_widget_url_88 , t0 . recommendation_client_requested AS recommendation_client_requested_89 , t0 . recommendation_client_activate AS recommendation_client_activate_90 , t0 . survey_token AS survey_token_91 , t0 . survey_widget_url AS survey_widget_url_92 , t0 . cjec_token AS cjec_token_93 , t0 . cjec_widget_url AS cjec_widget_url_94 , t0 . satisfaction_token AS satisfaction_token_95 , t0 . satisfaction_widget_url AS satisfaction_widget_url_96 , t0 . electronic_invoice_token AS electronic_invoice_token_97 , t0 . electronic_invoice_widget_url AS electronic_invoice_widget_url_98 , t0 . satisfaction_client_activate AS satisfaction_client_activate_99 , t0 . card_trello_event_create AS card_trello_event_create_100 , t0 . card_trello_satisfaction_create AS card_trello_satisfaction_create_101 , t0 . platform_enabled AS platform_enabled_102 , t0 . sepa_prelevement_date AS sepa_prelevement_date_103 , t0 . onboarding_replay_url AS onboarding_replay_url_104 , t0 . onboarding_replay_notified_at AS onboarding_replay_notified_at_105 , t0 . onboarding_replay_code AS onboarding_replay_code_106 , t0 . linkedin_username AS linkedin_username_107 , t0 . linkedin_password AS linkedin_password_108 , t0 . linkedin_password_updated_at AS linkedin_password_updated_at_109 , t110 . id AS id_111 , t110 . description AS description_112 , t110 . website AS website_113 , t110 . end_date_time AS end_date_time_114 , t110 . accounting_firm_id AS accounting_firm_id_115 , t116 . id AS id_117 , t116 . modules AS modules_118 , t116 . website_news_links AS website_news_links_119 , t116 . website_news_images AS website_news_images_120 , t116 . website_news_documents AS website_news_documents_121 , t116 . website_news_max_image_size AS website_news_max_image_size_122 , t116 . website_news_max_document_size AS website_news_max_document_size_123 , t116 . ebook_max_image_size AS ebook_max_image_size_124 , t116 . ebook_max_document_size AS ebook_max_document_size_125 , t116 . ebook_documents AS ebook_documents_126 , t116 . ebook_images AS ebook_images_127 , t116 . web_mail AS web_mail_128 , t116 . google_tag_manager AS google_tag_manager_129 , t116 . google_analytics AS google_analytics_130 , t116 . domain_type AS domain_type_131 , t116 . seo_meta_title AS seo_meta_title_132 , t116 . seo_meta_description AS seo_meta_description_133 , t116 . google_recaptcha_site_key AS google_recaptcha_site_key_134 , t116 . google_recaptcha_secret AS google_recaptcha_secret_135 , t116 . favicon AS favicon_136 , t116 . web_mail_recrutement AS web_mail_recrutement_137 , t116 . maintenance AS maintenance_138 , t116 . construction AS construction_139 , t116 . monetico_tpe AS monetico_tpe_140 , t116 . monetico_societe AS monetico_societe_141 , t116 . monetico_cle AS monetico_cle_142 , t116 . accounting_firm_id AS accounting_firm_id_143 , t116 . mailjetapi_id AS mailjetapi_id_144 , t116 . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_145 , t146 . id AS id_147 , t146 . updated_at AS updated_at_148 , t146 . send_mail_acces_client_tmp AS send_mail_acces_client_tmp_149 , t146 . accounting_firm_id AS accounting_firm_id_150 , t0 . mailing_api_id AS mailing_api_id_151 , t0 . rgpd_expert_id AS rgpd_expert_id_152 , t0 . ce_expert_id AS ce_expert_id_153 , t0 . cir_expert_id AS cir_expert_id_154 , t0 . emailing_client_api_id AS emailing_client_api_id_155 , t156 . id AS id_157 , t156 . gmb_score AS gmb_score_158 , t156 . last_mail_sent_at AS last_mail_sent_at_159 , t156 . trello_card_id AS trello_card_id_160 , t156 . client_emails AS client_emails_161 , t156 . created_at AS created_at_162 , t156 . updated_at AS updated_at_163 , t156 . step AS step_164 , t156 . emails_sent_count AS emails_sent_count_165 , t156 . last_lot_sent_at AS last_lot_sent_at_166 , t156 . accounting_firm_id AS accounting_firm_id_167 FROM cabinet t0 LEFT JOIN primary_news t110 ON t110 . accounting_firm_id = t0 . id LEFT JOIN parameters t116 ON t116 . accounting_firm_id = t0 . id LEFT JOIN identite_visuelle t146 ON t146 . accounting_firm_id = t0 . id LEFT JOIN pipeline_gmb_avis t156 ON t156 . accounting_firm_id = t0 . id WHERE t0 . host = 'fjconseils.fr' LIMIT 1 ;
Copy
2
0.29 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.78 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_ . google_place_id AS google_place_id_55 , c0_ . calendly_url AS calendly_url_56 , c0_ . survey_client_requested AS survey_client_requested_57 , c0_ . survey_client_activate AS survey_client_activate_58 , c0_ . podcast_intro_filename AS podcast_intro_filename_59 , c0_ . enable_podcast_private AS enable_podcast_private_60 , c0_ . podcast_private_student AS podcast_private_student_61 , c0_ . podcast_private_token AS podcast_private_token_62 , c0_ . podcast_private_widget_url AS podcast_private_widget_url_63 , c0_ . subscriber_podcast_private AS subscriber_podcast_private_64 , c0_ . logo_pal_path AS logo_pal_path_65 , c0_ . google_analytics_id AS google_analytics_id_66 , c0_ . email_nl_actu_test AS email_nl_actu_test_67 , c0_ . helpers_firms_token AS helpers_firms_token_68 , c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_69 , c0_ . emailing_client_activate AS emailing_client_activate_70 , c0_ . emailing_client_token_max AS emailing_client_token_max_71 , c0_ . emailing_client_sender AS emailing_client_sender_72 , c0_ . sms_client_activate AS sms_client_activate_73 , c0_ . sms_client_credit_max AS sms_client_credit_max_74 , c0_ . sms_client_sender AS sms_client_sender_75 , c0_ . sms_client_sender_label AS sms_client_sender_label_76 , c0_ . anniversaire_client_sender AS anniversaire_client_sender_77 , c0_ . anniversaire_client_activate AS anniversaire_client_activate_78 , c0_ . event_token AS event_token_79 , c0_ . event_widget_url AS event_widget_url_80 , c0_ . event_client_requested AS event_client_requested_81 , c0_ . sponsorship_token AS sponsorship_token_82 , c0_ . sponsorship_widget_url AS sponsorship_widget_url_83 , c0_ . sponsorship_client_requested AS sponsorship_client_requested_84 , c0_ . sponsorship_client_activate AS sponsorship_client_activate_85 , c0_ . recommendation_token AS recommendation_token_86 , c0_ . recommendation_widget_url AS recommendation_widget_url_87 , c0_ . recommendation_client_requested AS recommendation_client_requested_88 , c0_ . recommendation_client_activate AS recommendation_client_activate_89 , c0_ . survey_token AS survey_token_90 , c0_ . survey_widget_url AS survey_widget_url_91 , c0_ . cjec_token AS cjec_token_92 , c0_ . cjec_widget_url AS cjec_widget_url_93 , c0_ . satisfaction_token AS satisfaction_token_94 , c0_ . satisfaction_widget_url AS satisfaction_widget_url_95 , c0_ . electronic_invoice_token AS electronic_invoice_token_96 , c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_97 , c0_ . satisfaction_client_activate AS satisfaction_client_activate_98 , c0_ . card_trello_event_create AS card_trello_event_create_99 , c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_100 , c0_ . platform_enabled AS platform_enabled_101 , c0_ . sepa_prelevement_date AS sepa_prelevement_date_102 , c0_ . onboarding_replay_url AS onboarding_replay_url_103 , c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_104 , c0_ . onboarding_replay_code AS onboarding_replay_code_105 , c0_ . linkedin_username AS linkedin_username_106 , c0_ . linkedin_password AS linkedin_password_107 , c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_108 , p1_ . id AS id_109 , p1_ . modules AS modules_110 , p1_ . website_news_links AS website_news_links_111 , p1_ . website_news_images AS website_news_images_112 , p1_ . website_news_documents AS website_news_documents_113 , p1_ . website_news_max_image_size AS website_news_max_image_size_114 , p1_ . website_news_max_document_size AS website_news_max_document_size_115 , p1_ . ebook_max_image_size AS ebook_max_image_size_116 , p1_ . ebook_max_document_size AS ebook_max_document_size_117 , p1_ . ebook_documents AS ebook_documents_118 , p1_ . ebook_images AS ebook_images_119 , p1_ . web_mail AS web_mail_120 , p1_ . google_tag_manager AS google_tag_manager_121 , p1_ . google_analytics AS google_analytics_122 , p1_ . domain_type AS domain_type_123 , p1_ . seo_meta_title AS seo_meta_title_124 , p1_ . seo_meta_description AS seo_meta_description_125 , p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_126 , p1_ . google_recaptcha_secret AS google_recaptcha_secret_127 , p1_ . favicon AS favicon_128 , p1_ . web_mail_recrutement AS web_mail_recrutement_129 , p1_ . maintenance AS maintenance_130 , p1_ . construction AS construction_131 , p1_ . monetico_tpe AS monetico_tpe_132 , p1_ . monetico_societe AS monetico_societe_133 , p1_ . monetico_cle AS monetico_cle_134 , c0_ . mailing_api_id AS mailing_api_id_135 , c0_ . rgpd_expert_id AS rgpd_expert_id_136 , c0_ . ce_expert_id AS ce_expert_id_137 , c0_ . cir_expert_id AS cir_expert_id_138 , c0_ . emailing_client_api_id AS emailing_client_api_id_139 , p1_ . accounting_firm_id AS accounting_firm_id_140 , p1_ . mailjetapi_id AS mailjetapi_id_141 , p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_ . id = p1_ . accounting_firm_id WHERE c0_ . host = ?
Parameters :
[
"fjconseils.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_ . google_place_id AS google_place_id_55 ,
c0_ . calendly_url AS calendly_url_56 ,
c0_ . survey_client_requested AS survey_client_requested_57 ,
c0_ . survey_client_activate AS survey_client_activate_58 ,
c0_ . podcast_intro_filename AS podcast_intro_filename_59 ,
c0_ . enable_podcast_private AS enable_podcast_private_60 ,
c0_ . podcast_private_student AS podcast_private_student_61 ,
c0_ . podcast_private_token AS podcast_private_token_62 ,
c0_ . podcast_private_widget_url AS podcast_private_widget_url_63 ,
c0_ . subscriber_podcast_private AS subscriber_podcast_private_64 ,
c0_ . logo_pal_path AS logo_pal_path_65 ,
c0_ . google_analytics_id AS google_analytics_id_66 ,
c0_ . email_nl_actu_test AS email_nl_actu_test_67 ,
c0_ . helpers_firms_token AS helpers_firms_token_68 ,
c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_69 ,
c0_ . emailing_client_activate AS emailing_client_activate_70 ,
c0_ . emailing_client_token_max AS emailing_client_token_max_71 ,
c0_ . emailing_client_sender AS emailing_client_sender_72 ,
c0_ . sms_client_activate AS sms_client_activate_73 ,
c0_ . sms_client_credit_max AS sms_client_credit_max_74 ,
c0_ . sms_client_sender AS sms_client_sender_75 ,
c0_ . sms_client_sender_label AS sms_client_sender_label_76 ,
c0_ . anniversaire_client_sender AS anniversaire_client_sender_77 ,
c0_ . anniversaire_client_activate AS anniversaire_client_activate_78 ,
c0_ . event_token AS event_token_79 ,
c0_ . event_widget_url AS event_widget_url_80 ,
c0_ . event_client_requested AS event_client_requested_81 ,
c0_ . sponsorship_token AS sponsorship_token_82 ,
c0_ . sponsorship_widget_url AS sponsorship_widget_url_83 ,
c0_ . sponsorship_client_requested AS sponsorship_client_requested_84 ,
c0_ . sponsorship_client_activate AS sponsorship_client_activate_85 ,
c0_ . recommendation_token AS recommendation_token_86 ,
c0_ . recommendation_widget_url AS recommendation_widget_url_87 ,
c0_ . recommendation_client_requested AS recommendation_client_requested_88 ,
c0_ . recommendation_client_activate AS recommendation_client_activate_89 ,
c0_ . survey_token AS survey_token_90 ,
c0_ . survey_widget_url AS survey_widget_url_91 ,
c0_ . cjec_token AS cjec_token_92 ,
c0_ . cjec_widget_url AS cjec_widget_url_93 ,
c0_ . satisfaction_token AS satisfaction_token_94 ,
c0_ . satisfaction_widget_url AS satisfaction_widget_url_95 ,
c0_ . electronic_invoice_token AS electronic_invoice_token_96 ,
c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_97 ,
c0_ . satisfaction_client_activate AS satisfaction_client_activate_98 ,
c0_ . card_trello_event_create AS card_trello_event_create_99 ,
c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_100 ,
c0_ . platform_enabled AS platform_enabled_101 ,
c0_ . sepa_prelevement_date AS sepa_prelevement_date_102 ,
c0_ . onboarding_replay_url AS onboarding_replay_url_103 ,
c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_104 ,
c0_ . onboarding_replay_code AS onboarding_replay_code_105 ,
c0_ . linkedin_username AS linkedin_username_106 ,
c0_ . linkedin_password AS linkedin_password_107 ,
c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_108 ,
p1_ . id AS id_109 ,
p1_ . modules AS modules_110 ,
p1_ . website_news_links AS website_news_links_111 ,
p1_ . website_news_images AS website_news_images_112 ,
p1_ . website_news_documents AS website_news_documents_113 ,
p1_ . website_news_max_image_size AS website_news_max_image_size_114 ,
p1_ . website_news_max_document_size AS website_news_max_document_size_115 ,
p1_ . ebook_max_image_size AS ebook_max_image_size_116 ,
p1_ . ebook_max_document_size AS ebook_max_document_size_117 ,
p1_ . ebook_documents AS ebook_documents_118 ,
p1_ . ebook_images AS ebook_images_119 ,
p1_ . web_mail AS web_mail_120 ,
p1_ . google_tag_manager AS google_tag_manager_121 ,
p1_ . google_analytics AS google_analytics_122 ,
p1_ . domain_type AS domain_type_123 ,
p1_ . seo_meta_title AS seo_meta_title_124 ,
p1_ . seo_meta_description AS seo_meta_description_125 ,
p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_126 ,
p1_ . google_recaptcha_secret AS google_recaptcha_secret_127 ,
p1_ . favicon AS favicon_128 ,
p1_ . web_mail_recrutement AS web_mail_recrutement_129 ,
p1_ . maintenance AS maintenance_130 ,
p1_ . construction AS construction_131 ,
p1_ . monetico_tpe AS monetico_tpe_132 ,
p1_ . monetico_societe AS monetico_societe_133 ,
p1_ . monetico_cle AS monetico_cle_134 ,
c0_ . mailing_api_id AS mailing_api_id_135 ,
c0_ . rgpd_expert_id AS rgpd_expert_id_136 ,
c0_ . ce_expert_id AS ce_expert_id_137 ,
c0_ . cir_expert_id AS cir_expert_id_138 ,
c0_ . emailing_client_api_id AS emailing_client_api_id_139 ,
p1_ . accounting_firm_id AS accounting_firm_id_140 ,
p1_ . mailjetapi_id AS mailjetapi_id_141 ,
p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142
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_ . google_place_id AS google_place_id_55 , c0_ . calendly_url AS calendly_url_56 , c0_ . survey_client_requested AS survey_client_requested_57 , c0_ . survey_client_activate AS survey_client_activate_58 , c0_ . podcast_intro_filename AS podcast_intro_filename_59 , c0_ . enable_podcast_private AS enable_podcast_private_60 , c0_ . podcast_private_student AS podcast_private_student_61 , c0_ . podcast_private_token AS podcast_private_token_62 , c0_ . podcast_private_widget_url AS podcast_private_widget_url_63 , c0_ . subscriber_podcast_private AS subscriber_podcast_private_64 , c0_ . logo_pal_path AS logo_pal_path_65 , c0_ . google_analytics_id AS google_analytics_id_66 , c0_ . email_nl_actu_test AS email_nl_actu_test_67 , c0_ . helpers_firms_token AS helpers_firms_token_68 , c0_ . helpers_firms_widget_url AS helpers_firms_widget_url_69 , c0_ . emailing_client_activate AS emailing_client_activate_70 , c0_ . emailing_client_token_max AS emailing_client_token_max_71 , c0_ . emailing_client_sender AS emailing_client_sender_72 , c0_ . sms_client_activate AS sms_client_activate_73 , c0_ . sms_client_credit_max AS sms_client_credit_max_74 , c0_ . sms_client_sender AS sms_client_sender_75 , c0_ . sms_client_sender_label AS sms_client_sender_label_76 , c0_ . anniversaire_client_sender AS anniversaire_client_sender_77 , c0_ . anniversaire_client_activate AS anniversaire_client_activate_78 , c0_ . event_token AS event_token_79 , c0_ . event_widget_url AS event_widget_url_80 , c0_ . event_client_requested AS event_client_requested_81 , c0_ . sponsorship_token AS sponsorship_token_82 , c0_ . sponsorship_widget_url AS sponsorship_widget_url_83 , c0_ . sponsorship_client_requested AS sponsorship_client_requested_84 , c0_ . sponsorship_client_activate AS sponsorship_client_activate_85 , c0_ . recommendation_token AS recommendation_token_86 , c0_ . recommendation_widget_url AS recommendation_widget_url_87 , c0_ . recommendation_client_requested AS recommendation_client_requested_88 , c0_ . recommendation_client_activate AS recommendation_client_activate_89 , c0_ . survey_token AS survey_token_90 , c0_ . survey_widget_url AS survey_widget_url_91 , c0_ . cjec_token AS cjec_token_92 , c0_ . cjec_widget_url AS cjec_widget_url_93 , c0_ . satisfaction_token AS satisfaction_token_94 , c0_ . satisfaction_widget_url AS satisfaction_widget_url_95 , c0_ . electronic_invoice_token AS electronic_invoice_token_96 , c0_ . electronic_invoice_widget_url AS electronic_invoice_widget_url_97 , c0_ . satisfaction_client_activate AS satisfaction_client_activate_98 , c0_ . card_trello_event_create AS card_trello_event_create_99 , c0_ . card_trello_satisfaction_create AS card_trello_satisfaction_create_100 , c0_ . platform_enabled AS platform_enabled_101 , c0_ . sepa_prelevement_date AS sepa_prelevement_date_102 , c0_ . onboarding_replay_url AS onboarding_replay_url_103 , c0_ . onboarding_replay_notified_at AS onboarding_replay_notified_at_104 , c0_ . onboarding_replay_code AS onboarding_replay_code_105 , c0_ . linkedin_username AS linkedin_username_106 , c0_ . linkedin_password AS linkedin_password_107 , c0_ . linkedin_password_updated_at AS linkedin_password_updated_at_108 , p1_ . id AS id_109 , p1_ . modules AS modules_110 , p1_ . website_news_links AS website_news_links_111 , p1_ . website_news_images AS website_news_images_112 , p1_ . website_news_documents AS website_news_documents_113 , p1_ . website_news_max_image_size AS website_news_max_image_size_114 , p1_ . website_news_max_document_size AS website_news_max_document_size_115 , p1_ . ebook_max_image_size AS ebook_max_image_size_116 , p1_ . ebook_max_document_size AS ebook_max_document_size_117 , p1_ . ebook_documents AS ebook_documents_118 , p1_ . ebook_images AS ebook_images_119 , p1_ . web_mail AS web_mail_120 , p1_ . google_tag_manager AS google_tag_manager_121 , p1_ . google_analytics AS google_analytics_122 , p1_ . domain_type AS domain_type_123 , p1_ . seo_meta_title AS seo_meta_title_124 , p1_ . seo_meta_description AS seo_meta_description_125 , p1_ . google_recaptcha_site_key AS google_recaptcha_site_key_126 , p1_ . google_recaptcha_secret AS google_recaptcha_secret_127 , p1_ . favicon AS favicon_128 , p1_ . web_mail_recrutement AS web_mail_recrutement_129 , p1_ . maintenance AS maintenance_130 , p1_ . construction AS construction_131 , p1_ . monetico_tpe AS monetico_tpe_132 , p1_ . monetico_societe AS monetico_societe_133 , p1_ . monetico_cle AS monetico_cle_134 , c0_ . mailing_api_id AS mailing_api_id_135 , c0_ . rgpd_expert_id AS rgpd_expert_id_136 , c0_ . ce_expert_id AS ce_expert_id_137 , c0_ . cir_expert_id AS cir_expert_id_138 , c0_ . emailing_client_api_id AS emailing_client_api_id_139 , p1_ . accounting_firm_id AS accounting_firm_id_140 , p1_ . mailjetapi_id AS mailjetapi_id_141 , p1_ . mailjetapi_recrutement_id AS mailjetapi_recrutement_id_142 FROM cabinet c0_ LEFT JOIN parameters p1_ ON c0_ . id = p1_ . accounting_firm_id WHERE c0_ . host = 'fjconseils.fr' ;
Copy
4
0.84 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.19 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
Parameters :
[
"252 "
1
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 = '252' AND a0_ . website = 1 AND a0_ . is_primary = 1 ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
6
0.16 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
Parameters :
[
"252 "
1
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 = '252' AND a0_ . website = 1 AND a0_ . is_spontanee = 1 ORDER BY a0_ . id ASC LIMIT 1 ;
Copy
7
0.42 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
Parameters :
[
"252 "
1
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 = '252' AND a0_ . website = 1 AND a0_ . is_primary = 1 ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
8
0.25 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , CASE WHEN c0_ . slug = ? THEN 0 WHEN c0_ . slug = ? THEN 1 ELSE 2 END AS sclr_3 FROM contact_subject_type c0_ ORDER BY sclr_3 ASC , c0_ . id ASC
Parameters :
[
"demande_devise "
"prospect "
]
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , CASE WHEN c0_ . slug = 'demande_devise' THEN 0 WHEN c0_ . slug = 'prospect' THEN 1 ELSE 2 END AS sclr_3 FROM contact_subject_type c0_ ORDER BY sclr_3 ASC , c0_ . id ASC ;
Copy
9
0.24 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . data AS data_3 , t0 . dyn_data_id AS dyn_data_id_4 FROM dyn_data_collection t0 WHERE t0 . dyn_data_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . data AS data_3 , t0 . dyn_data_id AS dyn_data_id_4 FROM dyn_data_collection t0 WHERE t0 . dyn_data_id = 1 ;
Copy
10
0.11 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . data AS data_3 , t0 . dyn_data_id AS dyn_data_id_4 FROM dyn_data_collection t0 WHERE t0 . dyn_data_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . data AS data_3 , t0 . dyn_data_id AS dyn_data_id_4 FROM dyn_data_collection t0 WHERE t0 . dyn_data_id = 2 ;
Copy