Symfony Profiler

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

Query Metrics

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.is_active AS is_active_4, c0_.sort_order AS sort_order_5, c0_.created_at AS created_at_6, c0_.icon AS icon_7, c0_.color AS color_8 FROM category c0_ WHERE c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.name ASC

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.slug AS slug_3,
  c0_.is_active AS is_active_4,
  c0_.sort_order AS sort_order_5,
  c0_.created_at AS created_at_6,
  c0_.icon AS icon_7,
  c0_.color AS color_8
FROM
  category c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.is_active AS is_active_4, c0_.sort_order AS sort_order_5, c0_.created_at AS created_at_6, c0_.icon AS icon_7, c0_.color AS color_8 FROM category c0_ WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT COUNT(s0_.id) AS sclr_0 FROM service s0_ WHERE s0_.category_id = ? AND s0_.is_active = ?

[
  11
  1
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  service s0_
WHERE
  s0_.category_id = ?
  AND s0_.is_active = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM service s0_ WHERE s0_.category_id = 11 AND s0_.is_active = 1;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.rate AS rate_3, s0_.min_quantity AS min_quantity_4, s0_.max_quantity AS max_quantity_5, s0_.average_time AS average_time_6, s0_.is_active AS is_active_7, s0_.type AS type_8, s0_.api_parameters AS api_parameters_9, s0_.api_service_id AS api_service_id_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.position AS position_13, s0_.external_id AS external_id_14, s0_.original_rate AS original_rate_15, s0_.original_min AS original_min_16, s0_.original_max AS original_max_17, s0_.refill AS refill_18, s0_.cancel AS cancel_19, s0_.markup_percentage AS markup_percentage_20, s0_.last_api_sync AS last_api_sync_21, s0_.auto_update AS auto_update_22, s0_.api_custom_fields AS api_custom_fields_23, s0_.category_id AS category_id_24, s0_.provider_id AS provider_id_25, s0_.api_provider_id AS api_provider_id_26 FROM service s0_ WHERE s0_.is_active = ? ORDER BY s0_.position ASC

[
  1
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.rate AS rate_3,
  s0_.min_quantity AS min_quantity_4,
  s0_.max_quantity AS max_quantity_5,
  s0_.average_time AS average_time_6,
  s0_.is_active AS is_active_7,
  s0_.type AS type_8,
  s0_.api_parameters AS api_parameters_9,
  s0_.api_service_id AS api_service_id_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12,
  s0_.position AS position_13,
  s0_.external_id AS external_id_14,
  s0_.original_rate AS original_rate_15,
  s0_.original_min AS original_min_16,
  s0_.original_max AS original_max_17,
  s0_.refill AS refill_18,
  s0_.cancel AS cancel_19,
  s0_.markup_percentage AS markup_percentage_20,
  s0_.last_api_sync AS last_api_sync_21,
  s0_.auto_update AS auto_update_22,
  s0_.api_custom_fields AS api_custom_fields_23,
  s0_.category_id AS category_id_24,
  s0_.provider_id AS provider_id_25,
  s0_.api_provider_id AS api_provider_id_26
FROM
  service s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.rate AS rate_3, s0_.min_quantity AS min_quantity_4, s0_.max_quantity AS max_quantity_5, s0_.average_time AS average_time_6, s0_.is_active AS is_active_7, s0_.type AS type_8, s0_.api_parameters AS api_parameters_9, s0_.api_service_id AS api_service_id_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.position AS position_13, s0_.external_id AS external_id_14, s0_.original_rate AS original_rate_15, s0_.original_min AS original_min_16, s0_.original_max AS original_max_17, s0_.refill AS refill_18, s0_.cancel AS cancel_19, s0_.markup_percentage AS markup_percentage_20, s0_.last_api_sync AS last_api_sync_21, s0_.auto_update AS auto_update_22, s0_.api_custom_fields AS api_custom_fields_23, s0_.category_id AS category_id_24, s0_.provider_id AS provider_id_25, s0_.api_provider_id AS api_provider_id_26 FROM service s0_ WHERE s0_.is_active = 1 ORDER BY s0_.position ASC;