Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT d0_.id AS id_0, d0_.external_id AS external_id_1, d0_.surname AS surname_2, d0_.name AS name_3, d0_.patronymic AS patronymic_4, d0_.online_recording_information AS online_recording_information_5, d0_.sex AS sex_6, d0_.image AS image_7, d0_.image_locked AS image_locked_8, d0_.specialities AS specialities_9, d0_.near_record AS near_record_10, d0_.service_external_ids AS service_external_ids_11, d0_.is_active AS is_active_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14 FROM doctor d0_ WHERE d0_.is_active = ? AND (LOWER(d0_.name) LIKE ? OR LOWER(d0_.surname) LIKE ? OR LOWER(d0_.patronymic) LIKE ? OR CONCAT(LOWER(d0_.surname), ' ', LOWER(d0_.name), ' ', LOWER(d0_.patronymic)) LIKE ?) LIMIT 10

[
  1
  "%тест%"
  "%тест%"
  "%тест%"
  "%тест%"
]

SELECT
  d0_.id AS id_0,
  d0_.external_id AS external_id_1,
  d0_.surname AS surname_2,
  d0_.name AS name_3,
  d0_.patronymic AS patronymic_4,
  d0_.online_recording_information AS online_recording_information_5,
  d0_.sex AS sex_6,
  d0_.image AS image_7,
  d0_.image_locked AS image_locked_8,
  d0_.specialities AS specialities_9,
  d0_.near_record AS near_record_10,
  d0_.service_external_ids AS service_external_ids_11,
  d0_.is_active AS is_active_12,
  d0_.created_at AS created_at_13,
  d0_.updated_at AS updated_at_14
FROM
  doctor d0_
WHERE
  d0_.is_active = ?
  AND (
    LOWER(d0_.name) LIKE ?
    OR LOWER(d0_.surname) LIKE ?
    OR LOWER(d0_.patronymic) LIKE ?
    OR CONCAT(
      LOWER(d0_.surname),
      ' ',
      LOWER(d0_.name),
      ' ',
      LOWER(d0_.patronymic)
    ) LIKE ?
  )
LIMIT
  10

SELECT d0_.id AS id_0, d0_.external_id AS external_id_1, d0_.surname AS surname_2, d0_.name AS name_3, d0_.patronymic AS patronymic_4, d0_.online_recording_information AS online_recording_information_5, d0_.sex AS sex_6, d0_.image AS image_7, d0_.image_locked AS image_locked_8, d0_.specialities AS specialities_9, d0_.near_record AS near_record_10, d0_.service_external_ids AS service_external_ids_11, d0_.is_active AS is_active_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14 FROM doctor d0_ WHERE d0_.is_active = 1 AND (LOWER(d0_.name) LIKE '%тест%' OR LOWER(d0_.surname) LIKE '%тест%' OR LOWER(d0_.patronymic) LIKE '%тест%' OR CONCAT(LOWER(d0_.surname), ' ', LOWER(d0_.name), ' ', LOWER(d0_.patronymic)) LIKE '%тест%') LIMIT 10;

SELECT COUNT(d0_.id) AS sclr_0 FROM doctor d0_ WHERE d0_.is_active = ? AND (LOWER(d0_.name) LIKE ? OR LOWER(d0_.surname) LIKE ? OR LOWER(d0_.patronymic) LIKE ? OR CONCAT(LOWER(d0_.surname), ' ', LOWER(d0_.name), ' ', LOWER(d0_.patronymic)) LIKE ?)

[
  1
  "%тест%"
  "%тест%"
  "%тест%"
  "%тест%"
]

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  doctor d0_
WHERE
  d0_.is_active = ?
  AND (
    LOWER(d0_.name) LIKE ?
    OR LOWER(d0_.surname) LIKE ?
    OR LOWER(d0_.patronymic) LIKE ?
    OR CONCAT(
      LOWER(d0_.surname),
      ' ',
      LOWER(d0_.name),
      ' ',
      LOWER(d0_.patronymic)
    ) LIKE ?
  )

SELECT COUNT(d0_.id) AS sclr_0 FROM doctor d0_ WHERE d0_.is_active = 1 AND (LOWER(d0_.name) LIKE '%тест%' OR LOWER(d0_.surname) LIKE '%тест%' OR LOWER(d0_.patronymic) LIKE '%тест%' OR CONCAT(LOWER(d0_.surname), ' ', LOWER(d0_.name), ' ', LOWER(d0_.patronymic)) LIKE '%тест%');