Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.86 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.04 ms
(56.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.visibility AS visibility_6, t0.public_phone AS public_phone_7, t0.view AS view_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.website AS website_12, t0.legal_name AS legal_name_13, t0.vat_number AS vat_number_14, t0.billing_adress AS billing_adress_15, t0.wifi_name AS wifi_name_16, t0.wifi_password AS wifi_password_17, t0.subscription_id AS subscription_id_18, t19.id AS id_20, t19.color1 AS color1_21, t19.color2 AS color2_22, t19.color3 AS color3_23, t19.color4 AS color4_24, t19.restaurant_id AS restaurant_id_25, t26.id AS id_27, t26.is_filter_price AS is_filter_price_28, t26.is_filter_tags AS is_filter_tags_29, t26.url_name AS url_name_30, t26.nb_translate AS nb_translate_31, t26.nb_qr_code_product_command AS nb_qr_code_product_command_32, t26.stripe_customer_id AS stripe_customer_id_33, t26.stripe_subscription_id AS stripe_subscription_id_34, t26.is_menu_auto_added AS is_menu_auto_added_35, t26.restaurant_id AS restaurant_id_36, t37.id AS id_38, t37.content AS content_39, t37.expire_date AS expire_date_40, t37.visibility AS visibility_41, t37.restaurant_id AS restaurant_id_42 FROM restaurant t0 LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.siret AS siret_3,
  t0.updated_at AS updated_at_4,
  t0.created_at AS created_at_5,
  t0.visibility AS visibility_6,
  t0.public_phone AS public_phone_7,
  t0.view AS view_8,
  t0.address AS address_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.website AS website_12,
  t0.legal_name AS legal_name_13,
  t0.vat_number AS vat_number_14,
  t0.billing_adress AS billing_adress_15,
  t0.wifi_name AS wifi_name_16,
  t0.wifi_password AS wifi_password_17,
  t0.subscription_id AS subscription_id_18,
  t19.id AS id_20,
  t19.color1 AS color1_21,
  t19.color2 AS color2_22,
  t19.color3 AS color3_23,
  t19.color4 AS color4_24,
  t19.restaurant_id AS restaurant_id_25,
  t26.id AS id_27,
  t26.is_filter_price AS is_filter_price_28,
  t26.is_filter_tags AS is_filter_tags_29,
  t26.url_name AS url_name_30,
  t26.nb_translate AS nb_translate_31,
  t26.nb_qr_code_product_command AS nb_qr_code_product_command_32,
  t26.stripe_customer_id AS stripe_customer_id_33,
  t26.stripe_subscription_id AS stripe_subscription_id_34,
  t26.is_menu_auto_added AS is_menu_auto_added_35,
  t26.restaurant_id AS restaurant_id_36,
  t37.id AS id_38,
  t37.content AS content_39,
  t37.expire_date AS expire_date_40,
  t37.visibility AS visibility_41,
  t37.restaurant_id AS restaurant_id_42
FROM
  restaurant t0
  LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id
  LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id
  LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.visibility AS visibility_6, t0.public_phone AS public_phone_7, t0.view AS view_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.website AS website_12, t0.legal_name AS legal_name_13, t0.vat_number AS vat_number_14, t0.billing_adress AS billing_adress_15, t0.wifi_name AS wifi_name_16, t0.wifi_password AS wifi_password_17, t0.subscription_id AS subscription_id_18, t19.id AS id_20, t19.color1 AS color1_21, t19.color2 AS color2_22, t19.color3 AS color3_23, t19.color4 AS color4_24, t19.restaurant_id AS restaurant_id_25, t26.id AS id_27, t26.is_filter_price AS is_filter_price_28, t26.is_filter_tags AS is_filter_tags_29, t26.url_name AS url_name_30, t26.nb_translate AS nb_translate_31, t26.nb_qr_code_product_command AS nb_qr_code_product_command_32, t26.stripe_customer_id AS stripe_customer_id_33, t26.stripe_subscription_id AS stripe_subscription_id_34, t26.is_menu_auto_added AS is_menu_auto_added_35, t26.restaurant_id AS restaurant_id_36, t37.id AS id_38, t37.content AS content_39, t37.expire_date AS expire_date_40, t37.visibility AS visibility_41, t37.restaurant_id AS restaurant_id_42 FROM restaurant t0 LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Twig\GlobalVariables->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 838)
7	Twig\Environment->getGlobals (line 383)
8	Twig\Template->yield (line 343)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 320)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
16	App\Controller\SecurityController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.44 ms
(23.77%)

SELECT COUNT(*) FROM product t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  product t0

SELECT COUNT(*) FROM product t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 36)
5	App\Twig\GlobalVariables->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 838)
7	Twig\Environment->getGlobals (line 383)
8	Twig\Template->yield (line 343)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 320)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
16	App\Controller\SecurityController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.37 ms
(20.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.nb_max_product AS nb_max_product_3, t0.nb_max_category AS nb_max_category_4, t0.nb_max_compte AS nb_max_compte_5, t0.nb_max_free_qr_code AS nb_max_free_qr_code_6, t0.nb_max_group AS nb_max_group_7, t0.nb_max_tag AS nb_max_tag_8, t0.img_max_width AS img_max_width_9, t0.img_max_height AS img_max_height_10 FROM subscription t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nb_max_product AS nb_max_product_3,
  t0.nb_max_category AS nb_max_category_4,
  t0.nb_max_compte AS nb_max_compte_5,
  t0.nb_max_free_qr_code AS nb_max_free_qr_code_6,
  t0.nb_max_group AS nb_max_group_7,
  t0.nb_max_tag AS nb_max_tag_8,
  t0.img_max_width AS img_max_width_9,
  t0.img_max_height AS img_max_height_10
FROM
  subscription t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.nb_max_product AS nb_max_product_3, t0.nb_max_category AS nb_max_category_4, t0.nb_max_compte AS nb_max_compte_5, t0.nb_max_free_qr_code AS nb_max_free_qr_code_6, t0.nb_max_group AS nb_max_group_7, t0.nb_max_tag AS nb_max_tag_8, t0.img_max_width AS img_max_width_9, t0.img_max_height AS img_max_height_10 FROM subscription t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Subscription::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Subscription->__get (line 75)
8	App\Entity\Subscription->getNbMaxProduct (line 37)
9	App\Twig\GlobalVariables->getGlobals (line 331)
10	Twig\ExtensionSet->getGlobals (line 838)
11	Twig\Environment->getGlobals (line 383)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
20	App\Controller\SecurityController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Restaurant	No errors.
App\Entity\Subscription	No errors.
App\Entity\CustomMenuRestaurant	No errors.
App\Entity\ConfigMenuRestaurant	No errors.
App\Entity\Ardoise	No errors.
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Group	No errors.
App\Entity\Language	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\GroupTranslation	No errors.
App\Entity\TagTranslation	No errors.
App\Entity\Tag	No errors.
App\Entity\Order	No errors.
App\Entity\DocumentMenu	No errors.

Symfony Profiler

GET https://carmelaa.qrcard.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping