https://frontdev-w-helpers-firms.lagence.expert/166.php

Query Metrics

5 Database Queries
4 Different statements
3.27 ms Query time
16 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.43 ms
(43.73%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "expert57_actualite_frontdev"
]
1.24 ms
(38.07%)
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-w-helpers-firms.lagence.expert"
]
0.38 ms
(11.52%)
2
SELECT DATABASE()
Parameters:
[]
0.22 ms
(6.68%)
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-w-helpers-firms.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\AccountingFirm
  • The mappings App\Entity\AccountingFirm#anniversaireClients and App\Entity\AnniversaireClient#accountingFirm are inconsistent with each other.
App\Entity\Parameters No errors.
App\Entity\MailjetApi No errors.
App\Entity\RgpdExpert No errors.
App\Entity\CeExpert No errors.
App\Entity\CirExpert No errors.
App\Entity\Alias No errors.
App\Entity\User No errors.
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\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
  • The association App\Entity\EmailingClientCampaign#satisfactionClientSurvey refers to the inverse side field App\Entity\SatisfactionClientSurvey#surveys which does not exist.
  • The association App\Entity\EmailingClientCampaign#survey refers to the inverse side field App\Entity\Survey#surveys which does not exist.
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
  • The association App\Entity\SatisfactionClientSurvey#user refers to the inverse side field App\Entity\User#survey which does not exist.
App\Entity\Collaborator
  • The field App\Entity\Collaborator#surveys is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionClientSurvey#collaborators does not contain the required 'inversedBy="surveys"' attribute.
App\Entity\IdentiteVisuelleCategory No errors.
App\Entity\PipelineLinkedin No errors.
App\Entity\AnniversaireClient
  • The association App\Entity\AnniversaireClient#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#anniversaireClient which does not exist.
App\Entity\ElectronicInvoiceContact No errors.
App\Entity\Page No errors.
App\Entity\SeoPageClient No errors.
App\Entity\RedirectionClient No errors.
App\Entity\MailjetApiType No errors.
App\Entity\Affiliate
  • The association App\Entity\Affiliate#accountingFirms refers to the owning side field App\Entity\AccountingFirm#affiliate which does not exist.
App\Entity\ShortUrl No errors.
App\Entity\Qrcode
  • The association App\Entity\Qrcode#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#qrcode which does not exist.
App\Entity\ApplyRequest No errors.
App\Entity\Image No errors.
App\Entity\Document No errors.
App\Entity\Link No errors.
App\Entity\ContactSubjectType No errors.
App\Entity\ContactPipelineStep No errors.
App\Entity\IdentiteVisuelleFile No errors.
App\Entity\MailingLog No errors.
App\Entity\MailingCommunication No errors.
App\Entity\VCardPhone No errors.
App\Entity\VCardAddress No errors.
App\Entity\PodcastPrivate No errors.
App\Entity\PodcastPrivateLog No errors.
App\Entity\PodcastEpisode No errors.
App\Entity\AffiliateClientService No errors.
App\Entity\EmailingClientListEmail No errors.
App\Entity\Survey
  • The association App\Entity\Survey#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#surveys which does not exist.
App\Entity\SmsClientListNumber No errors.
App\Entity\PipelineMailjetDate No errors.
App\Entity\PipelineIdentiteVisuelleVisitCardPhoto No errors.
App\Entity\PipelineIdentiteVisuelleProposal No errors.
App\Entity\PipelineIdentiteVisuelleProposalReturn No errors.
App\Entity\PipelineIdentiteVisuelleVisitCardDeclination No errors.
App\Entity\PipelineGmbDate No errors.
App\Entity\PipelineContact No errors.
App\Entity\ContactCreationSocieteCharge No errors.
App\Entity\ContactCreationSocieteSalaryEmployee No errors.
App\Entity\ContactInvestissementImmoProperty No errors.
App\Entity\SatisfactionClientQuestion No errors.
App\Entity\SatisfactionClientSurveyResponse No errors.
App\Entity\PipelineLinkedinDates No errors.
App\Entity\Stakeholder
  • The association App\Entity\Stakeholder#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#stakeholders which does not exist.
App\Entity\SeoPage No errors.
App\Entity\PageClientService No errors.
App\Entity\TypeSeoPage No errors.
App\Entity\EmailingPal No errors.
App\Entity\SponsorshipRegistration No errors.
App\Entity\PipelineLinkedinGlobal No errors.
App\Entity\Actuv2Help No errors.
App\Entity\PipelineIdentiteVisuelleMajMessage No errors.
App\Entity\PipelineMajWebAttachment No errors.
App\Entity\Redirection No errors.
App\Entity\MailjetStatus No errors.
App\Entity\Actuv2QuizAnswer No errors.
App\Entity\CatImage No errors.
App\Entity\EmailingProspect No errors.
App\Entity\Event
  • The association App\Entity\Event#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#events which does not exist.
App\Entity\Diaporama
  • The association App\Entity\Diaporama#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#diaporama which does not exist.
App\Entity\Question No errors.
App\Entity\PodcastExpertComptable
  • The association App\Entity\PodcastExpertComptable#podcastEpisodes refers to the owning side field App\Entity\PodcastEpisode#podcastExpert which does not exist.
App\Entity\Actuv2Citation No errors.
App\Entity\Actuv2InfographieRseCarouselMobileFile No errors.
App\Entity\Actuv2ElectronicInvoice No errors.
App\Entity\StakeholderSubscription No errors.
App\Entity\RecommendationRegistration No errors.
App\Entity\PipelineIdentiteVisuelleMaj No errors.
App\Entity\NewsletterProspect No errors.
App\Entity\Actuv2Podcast No errors.
App\Entity\Actuv2Infographie No errors.
App\Entity\AffiliateRequest No errors.
App\Entity\StakeholderTag
  • The association App\Entity\StakeholderTag#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#stakeholderTags which does not exist.
App\Entity\InAppAnnouncement No errors.
App\Entity\PipelineIdentiteVisuelleMajProposal No errors.
App\Entity\Actuv2Sondage No errors.
App\Entity\CommunicationImage No errors.
App\Entity\Actuv2VoteUseful No errors.
App\Entity\Actuv2Calendrier No errors.
App\Entity\PipelineGmbGlobal No errors.
App\Entity\Actuv2ElectronicInvoiceAnswer No errors.
App\Entity\Actuv2QuizVote
  • The association App\Entity\Actuv2QuizVote#answer refers to the inverse side field App\Entity\Actuv2QuizAnswer#id which is not defined as association.
  • The association App\Entity\Actuv2QuizVote#answer refers to the inverse side field App\Entity\Actuv2QuizAnswer#id which does not exist.
  • The association App\Entity\Actuv2QuizVote#quiz refers to the inverse side field App\Entity\Actuv2Quiz#id which is not defined as association.
  • The association App\Entity\Actuv2QuizVote#quiz refers to the inverse side field App\Entity\Actuv2Quiz#id which does not exist.
App\Entity\PipelineMajWebMessage No errors.
App\Entity\Actuv2Bienetre No errors.
App\Entity\Category No errors.
App\Entity\StakeholderSubscriptionType No errors.
App\Entity\StakeholderCategory No errors.
App\Entity\PipelineIdentiteVisuelleVisistCardDeclination No errors.
App\Entity\PodcastPrivateTheme No errors.
App\Entity\PipelineIdentiteVisuelleGlobal No errors.
App\Entity\Partenaire No errors.
App\Entity\TrelloList
  • The mappings App\Entity\TrelloList#pipelineLinkedinGlobals and App\Entity\PipelineLinkedinGlobal#trelloListClientReturnOptimisation are inconsistent with each other.
App\Entity\AffiliateService No errors.
App\Entity\MailingSpecific No errors.
App\Entity\PodcastPrivateGlobal No errors.
App\Entity\Actuv2Actualite No errors.
App\Entity\Recommendation No errors.
App\Entity\Actuv2ElectronicInvoiceVote No errors.
App\Entity\FraisKilometriques No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\BoiteIdee
  • The association App\Entity\BoiteIdee#accountingFirm refers to the inverse side field App\Entity\AccountingFirm#boiteidee which does not exist.
App\Entity\CommunicationDesabonnement No errors.
App\Entity\SurveyResponse No errors.
App\Entity\PipelineMailjetGlobal No errors.
App\Entity\EmailBlacklist No errors.
App\Entity\PipelineIdentiteVisuelleMajItem No errors.
App\Entity\Actuv2Sondagevote No errors.
App\Entity\DynData No errors.
App\Entity\Actuv2Quiz No errors.
App\Entity\QrcodeCategories No errors.
App\Entity\Actuv2Journal No errors.
App\Entity\QuestionOption No errors.
App\Entity\DynDataCollection No errors.
App\Entity\EventRegistration No errors.
App\Entity\Actuv2Chiffredumois No errors.
App\Entity\Sponsorship No errors.
App\Entity\SatisfactionClientAnswer No errors.
App\Entity\Actuv2InfographieRse No errors.
App\Entity\PageService No errors.
App\Entity\Actuv2Utilisateur No errors.
App\Entity\PipelineMajWeb No errors.
App\Entity\InAppAnnouncementUser No errors.
App\Entity\PodcastExpert No errors.
App\Entity\PodcastHost No errors.
App\Entity\ContactInvestissementImmoPropertyCharge No errors.
App\Entity\Actuv2NewYear No errors.
App\Entity\NewsletterProspectPartner No errors.
App\Entity\Actuv2Transformationdigitale No errors.
App\Entity\QuestionResponse No errors.
Vich\UploaderBundle\Entity\File No errors.