Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.29 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.21 ms
(93.20%)

SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.address AS address_4, b0_.city AS city_5, b0_.latitude AS latitude_6, b0_.longitude AS longitude_7, b0_.languages AS languages_8, b0_.transport_info AS transport_info_9, b0_.payment_methods AS payment_methods_10, b0_.subscription_plan AS subscription_plan_11, b0_.salon_type AS salon_type_12, b0_.salon_categories AS salon_categories_13, b0_.is_verified AS is_verified_14, b0_.is_active AS is_active_15, b0_.offer_home_visit AS offer_home_visit_16, b0_.home_visit_radius AS home_visit_radius_17, b0_.phone AS phone_18, b0_.website AS website_19, b0_.instagram AS instagram_20, b0_.facebook AS facebook_21, b0_.tiktok AS tiktok_22, b0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.first_name AS first_name_28, u1_.last_name AS last_name_29, u1_.phone AS phone_30, u1_.avatar AS avatar_31, u1_.preferred_language AS preferred_language_32, u1_.created_at AS created_at_33, u1_.is_active AS is_active_34, u1_.is_verified AS is_verified_35, b0_.user_id AS user_id_36 FROM barber_profile b0_ LEFT JOIN `user` u1_ ON b0_.user_id = u1_.id LEFT JOIN service s2_ ON b0_.id = s2_.barber_profile_id LEFT JOIN review r3_ ON b0_.id = r3_.barber_profile_id AND (r3_.is_hidden = 0) WHERE b0_.is_active = 1 AND ((b0_.salon_name LIKE ? OR b0_.description LIKE ? OR b0_.city LIKE ? OR s2_.name LIKE ? OR s2_.category LIKE ? OR s2_.sub_category LIKE ?)) AND LOWER(b0_.city) LIKE LOWER(?) GROUP BY b0_.id, u1_.id ORDER BY CASE WHEN b0_.subscription_plan = 'premium_plus' THEN 0 WHEN b0_.subscription_plan = 'premium' THEN 1 ELSE 2 END ASC, AVG(r3_.rating) DESC

Parameters:

[
  "%coiffure%"
  "%coiffure%"
  "%coiffure%"
  "%coiffure%"
  "%coiffure%"
  "%coiffure%"
  "%Québec%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.salon_name AS salon_name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.address AS address_4,
  b0_.city AS city_5,
  b0_.latitude AS latitude_6,
  b0_.longitude AS longitude_7,
  b0_.languages AS languages_8,
  b0_.transport_info AS transport_info_9,
  b0_.payment_methods AS payment_methods_10,
  b0_.subscription_plan AS subscription_plan_11,
  b0_.salon_type AS salon_type_12,
  b0_.salon_categories AS salon_categories_13,
  b0_.is_verified AS is_verified_14,
  b0_.is_active AS is_active_15,
  b0_.offer_home_visit AS offer_home_visit_16,
  b0_.home_visit_radius AS home_visit_radius_17,
  b0_.phone AS phone_18,
  b0_.website AS website_19,
  b0_.instagram AS instagram_20,
  b0_.facebook AS facebook_21,
  b0_.tiktok AS tiktok_22,
  b0_.created_at AS created_at_23,
  u1_.id AS id_24,
  u1_.email AS email_25,
  u1_.roles AS roles_26,
  u1_.password AS password_27,
  u1_.first_name AS first_name_28,
  u1_.last_name AS last_name_29,
  u1_.phone AS phone_30,
  u1_.avatar AS avatar_31,
  u1_.preferred_language AS preferred_language_32,
  u1_.created_at AS created_at_33,
  u1_.is_active AS is_active_34,
  u1_.is_verified AS is_verified_35,
  b0_.user_id AS user_id_36
FROM
  barber_profile b0_
  LEFT JOIN `user` u1_ ON b0_.user_id = u1_.id
  LEFT JOIN service s2_ ON b0_.id = s2_.barber_profile_id
  LEFT JOIN review r3_ ON b0_.id = r3_.barber_profile_id
  AND (r3_.is_hidden = 0)
WHERE
  b0_.is_active = 1
  AND (
    (
      b0_.salon_name LIKE ?
      OR b0_.description LIKE ?
      OR b0_.city LIKE ?
      OR s2_.name LIKE ?
      OR s2_.category LIKE ?
      OR s2_.sub_category LIKE ?
    )
  )
  AND LOWER(b0_.city) LIKE LOWER(?)
GROUP BY
  b0_.id,
  u1_.id
ORDER BY
  CASE WHEN b0_.subscription_plan = 'premium_plus' THEN
    0
  WHEN b0_.subscription_plan = 'premium' THEN
    1
  ELSE
    2
  END ASC,
  AVG(r3_.rating) DESC

SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.address AS address_4, b0_.city AS city_5, b0_.latitude AS latitude_6, b0_.longitude AS longitude_7, b0_.languages AS languages_8, b0_.transport_info AS transport_info_9, b0_.payment_methods AS payment_methods_10, b0_.subscription_plan AS subscription_plan_11, b0_.salon_type AS salon_type_12, b0_.salon_categories AS salon_categories_13, b0_.is_verified AS is_verified_14, b0_.is_active AS is_active_15, b0_.offer_home_visit AS offer_home_visit_16, b0_.home_visit_radius AS home_visit_radius_17, b0_.phone AS phone_18, b0_.website AS website_19, b0_.instagram AS instagram_20, b0_.facebook AS facebook_21, b0_.tiktok AS tiktok_22, b0_.created_at AS created_at_23, u1_.id AS id_24, u1_.email AS email_25, u1_.roles AS roles_26, u1_.password AS password_27, u1_.first_name AS first_name_28, u1_.last_name AS last_name_29, u1_.phone AS phone_30, u1_.avatar AS avatar_31, u1_.preferred_language AS preferred_language_32, u1_.created_at AS created_at_33, u1_.is_active AS is_active_34, u1_.is_verified AS is_verified_35, b0_.user_id AS user_id_36 FROM barber_profile b0_ LEFT JOIN `user` u1_ ON b0_.user_id = u1_.id LEFT JOIN service s2_ ON b0_.id = s2_.barber_profile_id LEFT JOIN review r3_ ON b0_.id = r3_.barber_profile_id AND (r3_.is_hidden = 0) WHERE b0_.is_active = 1 AND ((b0_.salon_name LIKE '%coiffure%' OR b0_.description LIKE '%coiffure%' OR b0_.city LIKE '%coiffure%' OR s2_.name LIKE '%coiffure%' OR s2_.category LIKE '%coiffure%' OR s2_.sub_category LIKE '%coiffure%')) AND LOWER(b0_.city) LIKE LOWER('%Québec%') GROUP BY b0_.id, u1_.id ORDER BY CASE WHEN b0_.subscription_plan = 'premium_plus' THEN 0 WHEN b0_.subscription_plan = 'premium' THEN 1 ELSE 2 END ASC, AVG(r3_.rating) DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Public\HomeController->search (line 90)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.09 ms
(6.80%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "maintenance_mode"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.setting_type AS setting_type_4,
  t0.setting_group AS setting_group_5,
  t0.label AS label_6,
  t0.description AS description_7,
  t0.updated_at AS updated_at_8
FROM
  setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.setting_key = 'maintenance_mode' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\SettingRepository->findByKey (line 23)
5	App\Repository\SettingRepository->getValue (line 28)
6	App\Service\SettingService->get (line 79)
7	App\Service\SettingService->isMaintenanceMode (line 97)
8	App\EventSubscriber\MaintenanceModeSubscriber->onKernelRequest (line 51)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Setting	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\BarberProfile	No errors.
App\Entity\User	No errors.
App\Entity\Service	No errors.
App\Entity\Review	No errors.

Symfony Profiler

GET https://mybarber.softsquareit.com/search?city=Qu%C3%A9bec&q=coiffure

Configuration Settings

Theme

Page Width