Symfony Profiler

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

Query Metrics

SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.filter_order AS filter_order_2, f0_.keywords AS keywords_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.deleted_at AS deleted_at_6, f1_.id AS id_7, f1_.label AS label_8, f1_.filter_order AS filter_order_9, f1_.keywords AS keywords_10, f1_.created_at AS created_at_11, f1_.updated_at AS updated_at_12, f1_.deleted_at AS deleted_at_13, f0_.filter_group_id AS filter_group_id_14, f1_.filter_group_id AS filter_group_id_15 FROM filter f0_ LEFT JOIN filter_group f2_ ON f0_.filter_group_id = f2_.id AND (f2_.deleted_at IS NULL) LEFT JOIN filter_filter f3_ ON f0_.id = f3_.filter_target LEFT JOIN filter f1_ ON f1_.id = f3_.filter_source AND (f1_.deleted_at IS NULL) WHERE (f0_.id IN (SELECT f4_.id FROM filter f4_ LEFT JOIN filter_group f5_ ON f4_.filter_group_id = f5_.id AND (f5_.deleted_at IS NULL) WHERE (f5_.value = ?) AND (f4_.deleted_at IS NULL))) AND (f0_.deleted_at IS NULL) ORDER BY f0_.filter_order ASC

[
  "MISSION_TYPE"
]

SELECT
  f0_.id AS id_0,
  f0_.label AS label_1,
  f0_.filter_order AS filter_order_2,
  f0_.keywords AS keywords_3,
  f0_.created_at AS created_at_4,
  f0_.updated_at AS updated_at_5,
  f0_.deleted_at AS deleted_at_6,
  f1_.id AS id_7,
  f1_.label AS label_8,
  f1_.filter_order AS filter_order_9,
  f1_.keywords AS keywords_10,
  f1_.created_at AS created_at_11,
  f1_.updated_at AS updated_at_12,
  f1_.deleted_at AS deleted_at_13,
  f0_.filter_group_id AS filter_group_id_14,
  f1_.filter_group_id AS filter_group_id_15
FROM
  filter f0_
  LEFT JOIN filter_group f2_ ON f0_.filter_group_id = f2_.id
  AND (f2_.deleted_at IS NULL)
  LEFT JOIN filter_filter f3_ ON f0_.id = f3_.filter_target
  LEFT JOIN filter f1_ ON f1_.id = f3_.filter_source
  AND (f1_.deleted_at IS NULL)
WHERE
  (
    f0_.id IN (
      SELECT
        f4_.id
      FROM
        filter f4_
        LEFT JOIN filter_group f5_ ON f4_.filter_group_id = f5_.id
        AND (f5_.deleted_at IS NULL)
      WHERE
        (f5_.value = ?)
        AND (f4_.deleted_at IS NULL)
    )
  )
  AND (f0_.deleted_at IS NULL)
ORDER BY
  f0_.filter_order ASC

SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.filter_order AS filter_order_2, f0_.keywords AS keywords_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.deleted_at AS deleted_at_6, f1_.id AS id_7, f1_.label AS label_8, f1_.filter_order AS filter_order_9, f1_.keywords AS keywords_10, f1_.created_at AS created_at_11, f1_.updated_at AS updated_at_12, f1_.deleted_at AS deleted_at_13, f0_.filter_group_id AS filter_group_id_14, f1_.filter_group_id AS filter_group_id_15 FROM filter f0_ LEFT JOIN filter_group f2_ ON f0_.filter_group_id = f2_.id AND (f2_.deleted_at IS NULL) LEFT JOIN filter_filter f3_ ON f0_.id = f3_.filter_target LEFT JOIN filter f1_ ON f1_.id = f3_.filter_source AND (f1_.deleted_at IS NULL) WHERE (f0_.id IN (SELECT f4_.id FROM filter f4_ LEFT JOIN filter_group f5_ ON f4_.filter_group_id = f5_.id AND (f5_.deleted_at IS NULL) WHERE (f5_.value = 'MISSION_TYPE') AND (f4_.deleted_at IS NULL))) AND (f0_.deleted_at IS NULL) ORDER BY f0_.filter_order ASC;

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?

[
  "2a25bd67a924ae578d801697ded1fd827aba490bab0dc291505aaf5543b723d8aeed6560cc6f2b14"
]

SELECT
  t0.identifier AS identifier_1,
  t0.expiry AS expiry_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.revoked AS revoked_5,
  t0.client AS client_6
FROM
  oauth2_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = '2a25bd67a924ae578d801697ded1fd827aba490bab0dc291505aaf5543b723d8aeed6560cc6f2b14';

SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.commission_rate_monthly AS commission_rate_monthly_3, t0.commission_rate_manager AS commission_rate_manager_4, t0.commission_rate_monthly_manager AS commission_rate_monthly_manager_5, t0.coefs AS coefs_6, t0.algo_conditions AS algo_conditions_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM setting t0 WHERE ((t0.deleted_at IS NULL))

[]

SELECT
  t0.id AS id_1,
  t0.commission_rate AS commission_rate_2,
  t0.commission_rate_monthly AS commission_rate_monthly_3,
  t0.commission_rate_manager AS commission_rate_manager_4,
  t0.commission_rate_monthly_manager AS commission_rate_monthly_manager_5,
  t0.coefs AS coefs_6,
  t0.algo_conditions AS algo_conditions_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  setting t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.commission_rate_monthly AS commission_rate_monthly_3, t0.commission_rate_manager AS commission_rate_manager_4, t0.commission_rate_monthly_manager AS commission_rate_monthly_manager_5, t0.coefs AS coefs_6, t0.algo_conditions AS algo_conditions_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM setting t0 WHERE ((t0.deleted_at IS NULL));