Query Metrics
10
Database Queries
8
Different statements
5.26 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.91 ms (36.26%) |
1 |
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" ] |
|
0.91 ms (17.29%) |
1 |
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"
]
|
|
0.87 ms (16.57%) |
1 |
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"
]
|
|
0.60 ms (11.38%) |
2 |
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 ] |
|
0.48 ms (9.18%) |
2 |
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 = ?
Parameters:
[
1
]
|
|
0.18 ms (3.44%) |
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 = ? LIMIT 1
Parameters:
[
1
]
|
|
0.17 ms (3.18%) |
1 |
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
Parameters:
[] |
|
0.14 ms (2.70%) |
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 = ? AND a0_.website = ? AND a0_.is_spontanee = ? ORDER BY a0_.id ASC LIMIT 1
Parameters:
[ "252" 1 1 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.