Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.credit_balance AS credit_balance_7, t0.stripe_customer_id AS stripe_customer_id_8 FROM `user` t0 WHERE t0.email = ? LIMIT 1

[
  "gra@shipio.co.uk"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.created_at AS created_at_6,
  t0.credit_balance AS credit_balance_7,
  t0.stripe_customer_id AS stripe_customer_id_8
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.credit_balance AS credit_balance_7, t0.stripe_customer_id AS stripe_customer_id_8 FROM `user` t0 WHERE t0.email = 'gra@shipio.co.uk' LIMIT 1;

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_

[]

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_;

SELECT COUNT(t0_.id) AS sclr_0 FROM tuning_file t0_

[]

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  tuning_file t0_

SELECT COUNT(t0_.id) AS sclr_0 FROM tuning_file t0_;

SELECT COUNT(f0_.id) AS sclr_0 FROM file_modification_job f0_ WHERE f0_.status = ?

[
  "completed"
]

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  file_modification_job f0_
WHERE
  f0_.status = ?

SELECT COUNT(f0_.id) AS sclr_0 FROM file_modification_job f0_ WHERE f0_.status = 'completed';

SELECT COALESCE(SUM(u0_.credit_balance), 0) AS sclr_0 FROM `user` u0_

[]

SELECT
  COALESCE(
    SUM(u0_.credit_balance),
    0
  ) AS sclr_0
FROM
  `user` u0_

SELECT COALESCE(SUM(u0_.credit_balance), 0) AS sclr_0 FROM `user` u0_;

SELECT COUNT(c0_.id) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = ?

[
  "completed"
]

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  credit_purchase c0_
WHERE
  c0_.status = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = 'completed';

SELECT COALESCE(SUM(c0_.credit_amount), 0) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = ?

[
  "completed"
]

SELECT
  COALESCE(
    SUM(c0_.credit_amount),
    0
  ) AS sclr_0
FROM
  credit_purchase c0_
WHERE
  c0_.status = ?

SELECT COALESCE(SUM(c0_.credit_amount), 0) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = 'completed';

SELECT COALESCE(SUM(c0_.price_pence), 0) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = ?

[
  "completed"
]

SELECT
  COALESCE(
    SUM(c0_.price_pence),
    0
  ) AS sclr_0
FROM
  credit_purchase c0_
WHERE
  c0_.status = ?

SELECT COALESCE(SUM(c0_.price_pence), 0) AS sclr_0 FROM credit_purchase c0_ WHERE c0_.status = 'completed';

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.deleted AS deleted_5, t0.enabled AS enabled_6, t0.credit_amount AS credit_amount_7, t0.price_pence AS price_pence_8, t0.currency AS currency_9, t0.status AS status_10, t0.stripe_checkout_session_id AS stripe_checkout_session_id_11, t0.stripe_payment_intent_id AS stripe_payment_intent_id_12, t0.stripe_event_id AS stripe_event_id_13, t0.completed_at AS completed_at_14, t0.user_id AS user_id_15, t0.credit_pack_id AS credit_pack_id_16 FROM credit_purchase t0 ORDER BY t0.created_date DESC LIMIT 8

[]

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.created_date AS created_date_3,
  t0.updated_date AS updated_date_4,
  t0.deleted AS deleted_5,
  t0.enabled AS enabled_6,
  t0.credit_amount AS credit_amount_7,
  t0.price_pence AS price_pence_8,
  t0.currency AS currency_9,
  t0.status AS status_10,
  t0.stripe_checkout_session_id AS stripe_checkout_session_id_11,
  t0.stripe_payment_intent_id AS stripe_payment_intent_id_12,
  t0.stripe_event_id AS stripe_event_id_13,
  t0.completed_at AS completed_at_14,
  t0.user_id AS user_id_15,
  t0.credit_pack_id AS credit_pack_id_16
FROM
  credit_purchase t0
ORDER BY
  t0.created_date DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.deleted AS deleted_5, t0.enabled AS enabled_6, t0.credit_amount AS credit_amount_7, t0.price_pence AS price_pence_8, t0.currency AS currency_9, t0.status AS status_10, t0.stripe_checkout_session_id AS stripe_checkout_session_id_11, t0.stripe_payment_intent_id AS stripe_payment_intent_id_12, t0.stripe_event_id AS stripe_event_id_13, t0.completed_at AS completed_at_14, t0.user_id AS user_id_15, t0.credit_pack_id AS credit_pack_id_16 FROM credit_purchase t0 ORDER BY t0.created_date DESC LIMIT 8;

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.deleted AS deleted_5, t0.enabled AS enabled_6, t0.name AS name_7, t0.category AS category_8, t0.description AS description_9 FROM modification_type t0 WHERE t0.category IS NULL ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.created_date AS created_date_3,
  t0.updated_date AS updated_date_4,
  t0.deleted AS deleted_5,
  t0.enabled AS enabled_6,
  t0.name AS name_7,
  t0.category AS category_8,
  t0.description AS description_9
FROM
  modification_type t0
WHERE
  t0.category IS NULL
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.deleted AS deleted_5, t0.enabled AS enabled_6, t0.name AS name_7, t0.category AS category_8, t0.description AS description_9 FROM modification_type t0 WHERE t0.category IS NULL ORDER BY t0.name ASC;

SELECT COUNT(s0_.id) AS sclr_0 FROM stripe_admin_notices s0_ WHERE s0_.resolved = 0

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  stripe_admin_notices s0_
WHERE
  s0_.resolved = 0

SELECT COUNT(s0_.id) AS sclr_0 FROM stripe_admin_notices s0_ WHERE s0_.resolved = 0;

SELECT s0_.id AS id_0, s0_.hash AS hash_1, s0_.created_date AS created_date_2, s0_.updated_date AS updated_date_3, s0_.deleted AS deleted_4, s0_.enabled AS enabled_5, s0_.type AS type_6, s0_.stripe_object_id AS stripe_object_id_7, s0_.stripe_charge_id AS stripe_charge_id_8, s0_.stripe_payment_intent_id AS stripe_payment_intent_id_9, s0_.stripe_event_type AS stripe_event_type_10, s0_.amount_pence AS amount_pence_11, s0_.currency AS currency_12, s0_.status AS status_13, s0_.reason AS reason_14, s0_.message AS message_15, s0_.last_event_id AS last_event_id_16, s0_.occurred_at AS occurred_at_17, s0_.resolved AS resolved_18, s0_.resolved_at AS resolved_at_19, s0_.credit_purchase_id AS credit_purchase_id_20, s0_.user_id AS user_id_21, s0_.resolved_by_id AS resolved_by_id_22 FROM stripe_admin_notices s0_ WHERE s0_.resolved = ? ORDER BY s0_.occurred_at DESC LIMIT 5

[
  0
]

SELECT
  s0_.id AS id_0,
  s0_.hash AS hash_1,
  s0_.created_date AS created_date_2,
  s0_.updated_date AS updated_date_3,
  s0_.deleted AS deleted_4,
  s0_.enabled AS enabled_5,
  s0_.type AS type_6,
  s0_.stripe_object_id AS stripe_object_id_7,
  s0_.stripe_charge_id AS stripe_charge_id_8,
  s0_.stripe_payment_intent_id AS stripe_payment_intent_id_9,
  s0_.stripe_event_type AS stripe_event_type_10,
  s0_.amount_pence AS amount_pence_11,
  s0_.currency AS currency_12,
  s0_.status AS status_13,
  s0_.reason AS reason_14,
  s0_.message AS message_15,
  s0_.last_event_id AS last_event_id_16,
  s0_.occurred_at AS occurred_at_17,
  s0_.resolved AS resolved_18,
  s0_.resolved_at AS resolved_at_19,
  s0_.credit_purchase_id AS credit_purchase_id_20,
  s0_.user_id AS user_id_21,
  s0_.resolved_by_id AS resolved_by_id_22
FROM
  stripe_admin_notices s0_
WHERE
  s0_.resolved = ?
ORDER BY
  s0_.occurred_at DESC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.hash AS hash_1, s0_.created_date AS created_date_2, s0_.updated_date AS updated_date_3, s0_.deleted AS deleted_4, s0_.enabled AS enabled_5, s0_.type AS type_6, s0_.stripe_object_id AS stripe_object_id_7, s0_.stripe_charge_id AS stripe_charge_id_8, s0_.stripe_payment_intent_id AS stripe_payment_intent_id_9, s0_.stripe_event_type AS stripe_event_type_10, s0_.amount_pence AS amount_pence_11, s0_.currency AS currency_12, s0_.status AS status_13, s0_.reason AS reason_14, s0_.message AS message_15, s0_.last_event_id AS last_event_id_16, s0_.occurred_at AS occurred_at_17, s0_.resolved AS resolved_18, s0_.resolved_at AS resolved_at_19, s0_.credit_purchase_id AS credit_purchase_id_20, s0_.user_id AS user_id_21, s0_.resolved_by_id AS resolved_by_id_22 FROM stripe_admin_notices s0_ WHERE s0_.resolved = 0 ORDER BY s0_.occurred_at DESC LIMIT 5;