Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.timezone AS timezone_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.company_name AS company_name_8, u0_.phone AS phone_9, u0_.city AS city_10, u0_.description AS description_11, u0_.avatar AS avatar_12, u0_.specialization AS specialization_13, u0_.hourly_rate AS hourly_rate_14, u0_.skills AS skills_15, u0_.portfolio AS portfolio_16, u0_.status AS status_17, u0_.is_active AS is_active_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.rating AS rating_21, u0_.reviews_count AS reviews_count_22, u0_.is_verified AS is_verified_23, u0_.whatsapp AS whatsapp_24, u0_.telegram AS telegram_25, u0_.region AS region_26, u0_.country AS country_27 FROM users u0_ WHERE u0_.roles LIKE ? AND u0_.status = ? AND u0_.is_active = ? ORDER BY u0_.rating DESC, u0_.reviews_count DESC LIMIT 6

[
  "%ROLE_SPECIALIST%"
  "approved"
  1
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.username AS username_2,
  u0_.timezone AS timezone_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.company_name AS company_name_8,
  u0_.phone AS phone_9,
  u0_.city AS city_10,
  u0_.description AS description_11,
  u0_.avatar AS avatar_12,
  u0_.specialization AS specialization_13,
  u0_.hourly_rate AS hourly_rate_14,
  u0_.skills AS skills_15,
  u0_.portfolio AS portfolio_16,
  u0_.status AS status_17,
  u0_.is_active AS is_active_18,
  u0_.created_at AS created_at_19,
  u0_.updated_at AS updated_at_20,
  u0_.rating AS rating_21,
  u0_.reviews_count AS reviews_count_22,
  u0_.is_verified AS is_verified_23,
  u0_.whatsapp AS whatsapp_24,
  u0_.telegram AS telegram_25,
  u0_.region AS region_26,
  u0_.country AS country_27
FROM
  users u0_
WHERE
  u0_.roles LIKE ?
  AND u0_.status = ?
  AND u0_.is_active = ?
ORDER BY
  u0_.rating DESC,
  u0_.reviews_count DESC
LIMIT
  6

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.timezone AS timezone_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.company_name AS company_name_8, u0_.phone AS phone_9, u0_.city AS city_10, u0_.description AS description_11, u0_.avatar AS avatar_12, u0_.specialization AS specialization_13, u0_.hourly_rate AS hourly_rate_14, u0_.skills AS skills_15, u0_.portfolio AS portfolio_16, u0_.status AS status_17, u0_.is_active AS is_active_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.rating AS rating_21, u0_.reviews_count AS reviews_count_22, u0_.is_verified AS is_verified_23, u0_.whatsapp AS whatsapp_24, u0_.telegram AS telegram_25, u0_.region AS region_26, u0_.country AS country_27 FROM users u0_ WHERE u0_.roles LIKE '%ROLE_SPECIALIST%' AND u0_.status = 'approved' AND u0_.is_active = 1 ORDER BY u0_.rating DESC, u0_.reviews_count DESC LIMIT 6;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.icon AS icon_7, t0.image AS image_8, t0.sort_order AS sort_order_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN user_categories ON t0.id = user_categories.category_id WHERE user_categories.user_id = ?

[
  65
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5,
  t0.synonyms AS synonyms_6,
  t0.icon AS icon_7,
  t0.image AS image_8,
  t0.sort_order AS sort_order_9,
  t0.is_active AS is_active_10,
  t0.created_at AS created_at_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
  INNER JOIN user_categories ON t0.id = user_categories.category_id
WHERE
  user_categories.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.icon AS icon_7, t0.image AS image_8, t0.sort_order AS sort_order_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN user_categories ON t0.id = user_categories.category_id WHERE user_categories.user_id = 65;