Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

4.81 ms Query time

6 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.81 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.legal_status AS legal_status_4, t0.annual_turnover AS annual_turnover_5, t0.monthly_turnover AS monthly_turnover_6, t0.effective AS effective_7, t0.founder AS founder_8, t0.created_at AS created_at_9, t0.traded AS traded_10, t0.location AS location_11, t0.fax AS fax_12, t0.phone AS phone_13, t0.email AS email_14, t0.sector AS sector_15, t0.clientele AS clientele_16, t0.products AS products_17, t0.shop_addresses AS shop_addresses_18, t0.opening_hours AS opening_hours_19, t0.objectives AS objectives_20, t0.target_professional_revenue AS target_professional_revenue_21, t0.target_professional_location AS target_professional_location_22, t0.target_professional_type AS target_professional_type_23, t0.target_professional_purchase_behavior AS target_professional_purchase_behavior_24, t0.target_professional_purchase_frequency AS target_professional_purchase_frequency_25, t0.target_professional_sales_channels AS target_professional_sales_channels_26, t0.target_professional_price_sensitivity AS target_professional_price_sensitivity_27, t0.target_professional_needs AS target_professional_needs_28, t0.target_professional_motivations AS target_professional_motivations_29, t0.target_individual_age AS target_individual_age_30, t0.target_individual_gender AS target_individual_gender_31, t0.target_individual_revenue AS target_individual_revenue_32, t0.target_individual_social_economic_status AS target_individual_social_economic_status_33, t0.target_individual_location AS target_individual_location_34, t0.target_individual_purchase_behavior AS target_individual_purchase_behavior_35, t0.target_individual_purchase_frequency AS target_individual_purchase_frequency_36, t0.target_individual_sales_channels AS target_individual_sales_channels_37, t0.target_individual_price_sensitivity AS target_individual_price_sensitivity_38, t0.target_individual_needs AS target_individual_needs_39, t0.target_individual_motivations AS target_individual_motivations_40, t0.customer_number AS customer_number_41, t0.shop_number AS shop_number_42, t0.redirect_facebook AS redirect_facebook_43, t0.redirect_instagram AS redirect_instagram_44, t0.redirect_linkedin AS redirect_linkedin_45, t0.subscription_plan_id AS subscription_plan_id_46 FROM establishment t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.legal_status AS legal_status_4,
  t0.annual_turnover AS annual_turnover_5,
  t0.monthly_turnover AS monthly_turnover_6,
  t0.effective AS effective_7,
  t0.founder AS founder_8,
  t0.created_at AS created_at_9,
  t0.traded AS traded_10,
  t0.location AS location_11,
  t0.fax AS fax_12,
  t0.phone AS phone_13,
  t0.email AS email_14,
  t0.sector AS sector_15,
  t0.clientele AS clientele_16,
  t0.products AS products_17,
  t0.shop_addresses AS shop_addresses_18,
  t0.opening_hours AS opening_hours_19,
  t0.objectives AS objectives_20,
  t0.target_professional_revenue AS target_professional_revenue_21,
  t0.target_professional_location AS target_professional_location_22,
  t0.target_professional_type AS target_professional_type_23,
  t0.target_professional_purchase_behavior AS target_professional_purchase_behavior_24,
  t0.target_professional_purchase_frequency AS target_professional_purchase_frequency_25,
  t0.target_professional_sales_channels AS target_professional_sales_channels_26,
  t0.target_professional_price_sensitivity AS target_professional_price_sensitivity_27,
  t0.target_professional_needs AS target_professional_needs_28,
  t0.target_professional_motivations AS target_professional_motivations_29,
  t0.target_individual_age AS target_individual_age_30,
  t0.target_individual_gender AS target_individual_gender_31,
  t0.target_individual_revenue AS target_individual_revenue_32,
  t0.target_individual_social_economic_status AS target_individual_social_economic_status_33,
  t0.target_individual_location AS target_individual_location_34,
  t0.target_individual_purchase_behavior AS target_individual_purchase_behavior_35,
  t0.target_individual_purchase_frequency AS target_individual_purchase_frequency_36,
  t0.target_individual_sales_channels AS target_individual_sales_channels_37,
  t0.target_individual_price_sensitivity AS target_individual_price_sensitivity_38,
  t0.target_individual_needs AS target_individual_needs_39,
  t0.target_individual_motivations AS target_individual_motivations_40,
  t0.customer_number AS customer_number_41,
  t0.shop_number AS shop_number_42,
  t0.redirect_facebook AS redirect_facebook_43,
  t0.redirect_instagram AS redirect_instagram_44,
  t0.redirect_linkedin AS redirect_linkedin_45,
  t0.subscription_plan_id AS subscription_plan_id_46
FROM
  establishment t0

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.legal_status AS legal_status_4, t0.annual_turnover AS annual_turnover_5, t0.monthly_turnover AS monthly_turnover_6, t0.effective AS effective_7, t0.founder AS founder_8, t0.created_at AS created_at_9, t0.traded AS traded_10, t0.location AS location_11, t0.fax AS fax_12, t0.phone AS phone_13, t0.email AS email_14, t0.sector AS sector_15, t0.clientele AS clientele_16, t0.products AS products_17, t0.shop_addresses AS shop_addresses_18, t0.opening_hours AS opening_hours_19, t0.objectives AS objectives_20, t0.target_professional_revenue AS target_professional_revenue_21, t0.target_professional_location AS target_professional_location_22, t0.target_professional_type AS target_professional_type_23, t0.target_professional_purchase_behavior AS target_professional_purchase_behavior_24, t0.target_professional_purchase_frequency AS target_professional_purchase_frequency_25, t0.target_professional_sales_channels AS target_professional_sales_channels_26, t0.target_professional_price_sensitivity AS target_professional_price_sensitivity_27, t0.target_professional_needs AS target_professional_needs_28, t0.target_professional_motivations AS target_professional_motivations_29, t0.target_individual_age AS target_individual_age_30, t0.target_individual_gender AS target_individual_gender_31, t0.target_individual_revenue AS target_individual_revenue_32, t0.target_individual_social_economic_status AS target_individual_social_economic_status_33, t0.target_individual_location AS target_individual_location_34, t0.target_individual_purchase_behavior AS target_individual_purchase_behavior_35, t0.target_individual_purchase_frequency AS target_individual_purchase_frequency_36, t0.target_individual_sales_channels AS target_individual_sales_channels_37, t0.target_individual_price_sensitivity AS target_individual_price_sensitivity_38, t0.target_individual_needs AS target_individual_needs_39, t0.target_individual_motivations AS target_individual_motivations_40, t0.customer_number AS customer_number_41, t0.shop_number AS shop_number_42, t0.redirect_facebook AS redirect_facebook_43, t0.redirect_instagram AS redirect_instagram_44, t0.redirect_linkedin AS redirect_linkedin_45, t0.subscription_plan_id AS subscription_plan_id_46 FROM establishment t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 28)
6	App\Controller\DashboardClient\NavManager\NavController->navTest (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 99)
14	__TwigTemplate_d6220152906aa919e6b63954cb878f0e->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_d3b48629a83488c1c55b1771cbb2bb55->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
25	App\Controller\DashboardClient\LoginManager\SecurityController->login (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

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\Establishment	The association App\Entity\Establishment#massMessages refers to the owning side field App\Entity\MassMessage#establishment which does not exist. The association App\Entity\Establishment#benchmarks refers to the owning side field App\Entity\Benchmark#establishment which does not exist. The association App\Entity\Establishment#reviews refers to the owning side field App\Entity\Review#establishments which does not exist. The association App\Entity\Establishment#privateMessages refers to the owning side field App\Entity\PrivateMessage#establishment which does not exist.
App\Entity\SubscriptionPlan	No errors.
App\Entity\User	No errors.
App\Entity\MassMessage	The mappings App\Entity\MassMessage#establishments and App\Entity\Establishment#massMessages are inconsistent with each other.
App\Entity\Benchmark	The mappings App\Entity\Benchmark#establishments and App\Entity\Establishment#benchmarks are inconsistent with each other.
App\Entity\Identity	No errors.
App\Entity\Site	No errors.
App\Entity\Review	The mappings App\Entity\Review#establishment and App\Entity\Establishment#reviews are inconsistent with each other.
App\Entity\Analytic	No errors.
App\Entity\LinkAccount	No errors.
App\Entity\Planification	The mappings App\Entity\Planification#publications and App\Entity\Publication#planification are inconsistent with each other.
App\Entity\OnboardingResponse	No errors.
App\Entity\PrivateMessage	The mappings App\Entity\PrivateMessage#etablishment and App\Entity\Establishment#privateMessages are inconsistent with each other.
App\Entity\SocialMedia	No errors.
App\Entity\MediaLibrary	No errors.
App\Entity\Strategy	No errors.
App\Entity\MetaConnector	No errors.
App\Entity\Campaign	No errors.

Symfony Profiler

GET https://app.vizualeez.com/nav/test

Configuration Settings

Theme