Query Metrics
7
Database Queries
7
Different statements
2.77 ms
Query time
7
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.76 ms (27.45%) |
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_.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:
[
"frontdev.lagence.expert"
]
|
|
0.69 ms (24.85%) |
1 |
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 = ?
Parameters:
[
82
]
|
|
0.38 ms (13.77%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.website AS website_3, t0.end_date_time AS end_date_time_4, t0.accounting_firm_id AS accounting_firm_id_5 FROM primary_news t0 WHERE t0.accounting_firm_id = ?
Parameters:
[
"69"
]
|
|
0.31 ms (11.05%) |
1 |
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 = ?
Parameters:
[
"69"
]
|
|
0.24 ms (8.61%) |
1 |
SELECT t0.id AS id_1, t0.modules AS modules_2, t0.website_news_links AS website_news_links_3, t0.website_news_images AS website_news_images_4, t0.website_news_documents AS website_news_documents_5, t0.website_news_max_image_size AS website_news_max_image_size_6, t0.website_news_max_document_size AS website_news_max_document_size_7, t0.ebook_max_image_size AS ebook_max_image_size_8, t0.ebook_max_document_size AS ebook_max_document_size_9, t0.ebook_documents AS ebook_documents_10, t0.ebook_images AS ebook_images_11, t0.web_mail AS web_mail_12, t0.google_tag_manager AS google_tag_manager_13, t0.google_analytics AS google_analytics_14, t0.domain_type AS domain_type_15, t0.seo_meta_title AS seo_meta_title_16, t0.seo_meta_description AS seo_meta_description_17, t0.google_recaptcha_site_key AS google_recaptcha_site_key_18, t0.google_recaptcha_secret AS google_recaptcha_secret_19, t0.favicon AS favicon_20, t0.web_mail_recrutement AS web_mail_recrutement_21, t0.maintenance AS maintenance_22, t0.construction AS construction_23, t0.monetico_tpe AS monetico_tpe_24, t0.monetico_societe AS monetico_societe_25, t0.monetico_cle AS monetico_cle_26, t0.accounting_firm_id AS accounting_firm_id_27, t0.mailjetapi_id AS mailjetapi_id_28, t0.mailjetapi_recrutement_id AS mailjetapi_recrutement_id_29 FROM parameters t0 WHERE t0.accounting_firm_id = ?
Parameters:
[
"69"
]
|
|
0.24 ms (8.56%) |
1 |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.send_mail_acces_client_tmp AS send_mail_acces_client_tmp_3, t0.accounting_firm_id AS accounting_firm_id_4 FROM identite_visuelle t0 WHERE t0.accounting_firm_id = ?
Parameters:
[
"69"
]
|
|
0.16 ms (5.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.parameter_id AS parameter_id_4 FROM alias t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"frontdev.lagence.expert"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\AccountingFirm |
|
| App\Entity\MailjetApi | No errors. |
| App\Entity\RgpdExpert | No errors. |
| App\Entity\CeExpert | No errors. |
| App\Entity\CirExpert | No errors. |
| App\Entity\Affiliate |
|
| App\Entity\ShortUrl | No errors. |
| App\Entity\Qrcode |
|
| App\Entity\Emailing | No errors. |
| App\Entity\EmailingCollab | No errors. |
| App\Entity\Actualitecabinet | No errors. |
| App\Entity\Announcement | No errors. |
| App\Entity\UsefulLink | No errors. |
| App\Entity\PrimaryNews | No errors. |
| App\Entity\Ebook | No errors. |
| App\Entity\WebsiteNews | No errors. |
| App\Entity\Parameters | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\SeoPageClient | No errors. |
| App\Entity\RedirectionClient | No errors. |
| App\Entity\Alias | No errors. |
| App\Entity\Partner | No errors. |
| App\Entity\Actualiters | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\ContactProfession | No errors. |
| App\Entity\ContactCustom | No errors. |
| App\Entity\DemandeCompany | No errors. |
| App\Entity\DemandeNewsletter | No errors. |
| App\Entity\AuthorizedDomain | No errors. |
| App\Entity\IdentiteVisuelle | No errors. |
| App\Entity\MailingTask | No errors. |
| App\Entity\VCards | No errors. |
| App\Entity\RgpdContact | No errors. |
| App\Entity\ContactParticipationPlaceExpert | No errors. |
| App\Entity\ContactEtreRappele | No errors. |
| App\Entity\VideoAppelleTonEc | No errors. |
| App\Entity\CeContact | No errors. |
| App\Entity\CirContact | No errors. |
| App\Entity\TousEnLigneContact | No errors. |
| App\Entity\ModuleType | No errors. |
| App\Entity\ModuleTypeValue | No errors. |
| App\Entity\RepportingTrimestrielle | No errors. |
| App\Entity\StatEcoutePodcast | No errors. |
| App\Entity\PodcastPrivateAccountingFirm | No errors. |
| App\Entity\PodcastPrivateTask | No errors. |
| App\Entity\ModuleVideo | No errors. |
| App\Entity\AffiliateClient | No errors. |
| App\Entity\EmailingClientList | No errors. |
| App\Entity\EmailingClientCampaign |
|
| App\Entity\EmailingClientDesabonnement | No errors. |
| App\Entity\SmsClientList | No errors. |
| App\Entity\SmsClientCampaign | No errors. |
| App\Entity\PipelineMailjet | No errors. |
| App\Entity\PipelineIdentiteVisuelle | No errors. |
| App\Entity\PipelineGmb | No errors. |
| App\Entity\ContactCreationSociete | No errors. |
| App\Entity\ContactInvestissementImmo | No errors. |
| App\Entity\Prescriber | No errors. |
| App\Entity\SatisfactionClientSurvey |
|
| App\Entity\Collaborator |
|
| App\Entity\IdentiteVisuelleCategory | No errors. |
| App\Entity\PipelineLinkedin | No errors. |
| App\Entity\AnniversaireClient |
|
| App\Entity\ElectronicInvoiceContact | No errors. |