Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 4
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN review r1_ ON u0_.id = r1_.user_id INNER JOIN user_category u3_ ON u0_.id = u3_.user_id INNER JOIN category c2_ ON c2_.id = u3_.category_id WHERE (u0_.latitude IS NOT NULL AND u0_.longitude IS NOT NULL AND LOWER(c2_.name) LIKE LOWER(?)) OR LOWER(u0_.name) LIKE LOWER(?) OR LOWER(u0_.surname) LIKE LOWER(?)

[
  "%дробилка%"
  "%дробилка%"
  "%дробилка%"
]

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.surname AS surname_2,
  u0_.birthday AS birthday_3,
  u0_.gender AS gender_4,
  u0_.img AS img_5,
  u0_.phone_number AS phone_number_6,
  u0_.balance AS balance_7,
  u0_.work_experience AS work_experience_8,
  u0_.self AS self_9,
  u0_.role AS role_10,
  u0_.token AS token_11,
  u0_.latitude AS latitude_12,
  u0_.longitude AS longitude_13,
  u0_.push_token AS push_token_14,
  u0_.work_imgs AS work_imgs_15,
  u0_.city_name AS city_name_16,
  u0_.register_date AS register_date_17,
  u0_.ban_text AS ban_text_18,
  u0_.b AS b_19,
  u0_.city_id AS city_id_20,
  u0_.lang_id AS lang_id_21
FROM
  user u0_
  INNER JOIN review r1_ ON u0_.id = r1_.user_id
  INNER JOIN user_category u3_ ON u0_.id = u3_.user_id
  INNER JOIN category c2_ ON c2_.id = u3_.category_id
WHERE
  (
    u0_.latitude IS NOT NULL
    AND u0_.longitude IS NOT NULL
    AND LOWER(c2_.name) LIKE LOWER(?)
  )
  OR LOWER(u0_.name) LIKE LOWER(?)
  OR LOWER(u0_.surname) LIKE LOWER(?)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN review r1_ ON u0_.id = r1_.user_id INNER JOIN user_category u3_ ON u0_.id = u3_.user_id INNER JOIN category c2_ ON c2_.id = u3_.category_id WHERE (u0_.latitude IS NOT NULL AND u0_.longitude IS NOT NULL AND LOWER(c2_.name) LIKE LOWER('%дробилка%')) OR LOWER(u0_.name) LIKE LOWER('%дробилка%') OR LOWER(u0_.surname) LIKE LOWER('%дробилка%');