Symfony Profiler

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

Query Metrics

SELECT
    plan.id AS plan_id,
    plan.name AS plan_name,
    plan.status AS plan_status,
    plan.description AS plan_description,
    plan.display_order AS plan_display_order,
    plan.is_most_popular AS plan_is_most_popular,
    plan.is_Enterprise AS plan_is_Enterprise,
    stripe_plan.id AS stripe_plan_id,
    stripe_plan.name AS stripe_plan_name,
    stripe_plan.stripe_plan_ids AS stripe_plan_ids,
    stripe_plan.statement_descriptor AS stripe_plan_statement_descriptor,
    month_period.id AS monthly_period_id,
    year_period.id AS yearly_period_id
FROM subscription_plan plan
LEFT JOIN subscription_stripe_plan stripe_plan
    ON stripe_plan.plan_id = plan.id
LEFT JOIN subscription_stripe_plan newer_stripe_plan
    ON newer_stripe_plan.plan_id = plan.id
   AND stripe_plan.id IS NOT NULL
   AND newer_stripe_plan.id > stripe_plan.id
INNER JOIN subscription_payment_period month_period
    ON month_period.status = ?
   AND month_period.period = 1
LEFT JOIN subscription_payment_period earlier_month_period
    ON earlier_month_period.status = month_period.status
   AND earlier_month_period.period = month_period.period
   AND earlier_month_period.id < month_period.id
INNER JOIN subscription_payment_period year_period
    ON year_period.status = ?
   AND year_period.period >= 12
LEFT JOIN subscription_payment_period better_year_period
    ON better_year_period.status = year_period.status
   AND better_year_period.period >= 12
   AND (
       better_year_period.period < year_period.period
       OR (
           better_year_period.period = year_period.period
           AND better_year_period.id < year_period.id
       )
   )
WHERE plan.status = ?
  AND newer_stripe_plan.id IS NULL
  AND earlier_month_period.id IS NULL
  AND better_year_period.id IS NULL
ORDER BY plan.display_order ASC, plan.id ASC

[
  1
  1
  1
]

SELECT
  plan.id AS plan_id,
  plan.name AS plan_name,
  plan.status AS plan_status,
  plan.description AS plan_description,
  plan.display_order AS plan_display_order,
  plan.is_most_popular AS plan_is_most_popular,
  plan.is_Enterprise AS plan_is_Enterprise,
  stripe_plan.id AS stripe_plan_id,
  stripe_plan.name AS stripe_plan_name,
  stripe_plan.stripe_plan_ids AS stripe_plan_ids,
  stripe_plan.statement_descriptor AS stripe_plan_statement_descriptor,
  month_period.id AS monthly_period_id,
  year_period.id AS yearly_period_id
FROM
  subscription_plan plan
  LEFT JOIN subscription_stripe_plan stripe_plan ON stripe_plan.plan_id = plan.id
  LEFT JOIN subscription_stripe_plan newer_stripe_plan ON newer_stripe_plan.plan_id = plan.id
  AND stripe_plan.id IS NOT NULL
  AND newer_stripe_plan.id > stripe_plan.id
  INNER JOIN subscription_payment_period month_period ON month_period.status = ?
  AND month_period.period = 1
  LEFT JOIN subscription_payment_period earlier_month_period ON earlier_month_period.status = month_period.status
  AND earlier_month_period.period = month_period.period
  AND earlier_month_period.id < month_period.id
  INNER JOIN subscription_payment_period year_period ON year_period.status = ?
  AND year_period.period >= 12
  LEFT JOIN subscription_payment_period better_year_period ON better_year_period.status = year_period.status
  AND better_year_period.period >= 12
  AND (
    better_year_period.period < year_period.period
    OR (
      better_year_period.period = year_period.period
      AND better_year_period.id < year_period.id
    )
  )
WHERE
  plan.status = ?
  AND newer_stripe_plan.id IS NULL
  AND earlier_month_period.id IS NULL
  AND better_year_period.id IS NULL
ORDER BY
  plan.display_order ASC,
  plan.id ASC

SELECT
    plan.id AS plan_id,
    plan.name AS plan_name,
    plan.status AS plan_status,
    plan.description AS plan_description,
    plan.display_order AS plan_display_order,
    plan.is_most_popular AS plan_is_most_popular,
    plan.is_Enterprise AS plan_is_Enterprise,
    stripe_plan.id AS stripe_plan_id,
    stripe_plan.name AS stripe_plan_name,
    stripe_plan.stripe_plan_ids AS stripe_plan_ids,
    stripe_plan.statement_descriptor AS stripe_plan_statement_descriptor,
    month_period.id AS monthly_period_id,
    year_period.id AS yearly_period_id
FROM subscription_plan plan
LEFT JOIN subscription_stripe_plan stripe_plan
    ON stripe_plan.plan_id = plan.id
LEFT JOIN subscription_stripe_plan newer_stripe_plan
    ON newer_stripe_plan.plan_id = plan.id
   AND stripe_plan.id IS NOT NULL
   AND newer_stripe_plan.id > stripe_plan.id
INNER JOIN subscription_payment_period month_period
    ON month_period.status = 1
   AND month_period.period = 1
LEFT JOIN subscription_payment_period earlier_month_period
    ON earlier_month_period.status = month_period.status
   AND earlier_month_period.period = month_period.period
   AND earlier_month_period.id < month_period.id
INNER JOIN subscription_payment_period year_period
    ON year_period.status = 1
   AND year_period.period >= 12
LEFT JOIN subscription_payment_period better_year_period
    ON better_year_period.status = year_period.status
   AND better_year_period.period >= 12
   AND (
       better_year_period.period < year_period.period
       OR (
           better_year_period.period = year_period.period
           AND better_year_period.id < year_period.id
       )
   )
WHERE plan.status = 1
  AND newer_stripe_plan.id IS NULL
  AND earlier_month_period.id IS NULL
  AND better_year_period.id IS NULL
ORDER BY plan.display_order ASC, plan.id ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.symbol_left AS symbol_left_3, c0_.symbol_right AS symbol_right_4, c0_.value AS value_5 FROM currency c0_ WHERE c0_.code IN (?)

[
  "USD"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.symbol_left AS symbol_left_3,
  c0_.symbol_right AS symbol_right_4,
  c0_.value AS value_5
FROM
  currency c0_
WHERE
  c0_.code IN (?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.symbol_left AS symbol_left_3, c0_.symbol_right AS symbol_right_4, c0_.value AS value_5 FROM currency c0_ WHERE c0_.code IN ('USD');