https://frontdev-w-actu.lagence.expert/press.php

Query Metrics

5 Database Queries
4 Different statements
2.82 ms Query time
14 Invalid entities

Queries

Group similar statements

# Time Info
1 0.89 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:
[
  "frontdev-w-actu.lagence.expert"
]
2 0.26 ms
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-actu.lagence.expert"
]
3 0.18 ms
SELECT DATABASE()
Parameters:
[]
4 1.41 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "expert57_actualite_frontdev"
]
5 0.08 ms
SELECT DATABASE()
Parameters:
[]

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 No errors.
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.
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 No errors.
App\Entity\ElectronicInvoiceContact No errors.
App\Entity\PipelineGmbAvis 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\CjecContact 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.