Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• 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.password AS password_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.locale AS locale_8, t0.type AS type_9, t0.company_name AS company_name_10, t0.vat_number AS vat_number_11, t0.pro_validated_at AS pro_validated_at_12, t0.pro_payment_terms AS pro_payment_terms_13, t0.pro_discount_percent AS pro_discount_percent_14, t0.manual_discount_percent AS manual_discount_percent_15, t0.disable_discount_stacking AS disable_discount_stacking_16, t0.oauth_ids AS oauth_ids_17, t0.last_login_at AS last_login_at_18, t0.stripe_customer_id AS stripe_customer_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.shipping_street AS shipping_street_22, t0.shipping_zip_code AS shipping_zip_code_23, t0.shipping_city AS shipping_city_24, t0.shipping_country AS shipping_country_25, t0.billing_street AS billing_street_26, t0.billing_zip_code AS billing_zip_code_27, t0.billing_city AS billing_city_28, t0.billing_country AS billing_country_29 FROM app_user t0 WHERE t0.id = ?

[
  9
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.locale AS locale_8,
  t0.type AS type_9,
  t0.company_name AS company_name_10,
  t0.vat_number AS vat_number_11,
  t0.pro_validated_at AS pro_validated_at_12,
  t0.pro_payment_terms AS pro_payment_terms_13,
  t0.pro_discount_percent AS pro_discount_percent_14,
  t0.manual_discount_percent AS manual_discount_percent_15,
  t0.disable_discount_stacking AS disable_discount_stacking_16,
  t0.oauth_ids AS oauth_ids_17,
  t0.last_login_at AS last_login_at_18,
  t0.stripe_customer_id AS stripe_customer_id_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.shipping_street AS shipping_street_22,
  t0.shipping_zip_code AS shipping_zip_code_23,
  t0.shipping_city AS shipping_city_24,
  t0.shipping_country AS shipping_country_25,
  t0.billing_street AS billing_street_26,
  t0.billing_zip_code AS billing_zip_code_27,
  t0.billing_city AS billing_city_28,
  t0.billing_country AS billing_country_29
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.locale AS locale_8, t0.type AS type_9, t0.company_name AS company_name_10, t0.vat_number AS vat_number_11, t0.pro_validated_at AS pro_validated_at_12, t0.pro_payment_terms AS pro_payment_terms_13, t0.pro_discount_percent AS pro_discount_percent_14, t0.manual_discount_percent AS manual_discount_percent_15, t0.disable_discount_stacking AS disable_discount_stacking_16, t0.oauth_ids AS oauth_ids_17, t0.last_login_at AS last_login_at_18, t0.stripe_customer_id AS stripe_customer_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.shipping_street AS shipping_street_22, t0.shipping_zip_code AS shipping_zip_code_23, t0.shipping_city AS shipping_city_24, t0.shipping_country AS shipping_country_25, t0.billing_street AS billing_street_26, t0.billing_zip_code AS billing_zip_code_27, t0.billing_city AS billing_city_28, t0.billing_country AS billing_country_29 FROM app_user t0 WHERE t0.id = 9;

SELECT p0_.id AS id_0, p0_.invoice_number AS invoice_number_1, p0_.subtotal AS subtotal_2, p0_.pro_discount AS pro_discount_3, p0_.amount_tax AS amount_tax_4, p0_.amount_total AS amount_total_5, p0_.reverse_charge AS reverse_charge_6, p0_.payment_method AS payment_method_7, p0_.payment_status AS payment_status_8, p0_.payment_due_at AS payment_due_at_9, p0_.paid_at AS paid_at_10, p0_.stripe_payment_intent_id AS stripe_payment_intent_id_11, p0_.invoice_pdf_path AS invoice_pdf_path_12, p0_.tracking_number AS tracking_number_13, p0_.tracking_carrier AS tracking_carrier_14, p0_.shipped_at AS shipped_at_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.shipping_street AS shipping_street_18, p0_.shipping_zip_code AS shipping_zip_code_19, p0_.shipping_city AS shipping_city_20, p0_.shipping_country AS shipping_country_21, p0_.user_id AS user_id_22 FROM pro_order p0_ WHERE p0_.user_id = ? ORDER BY p0_.created_at DESC LIMIT 5

[
  9
]

SELECT
  p0_.id AS id_0,
  p0_.invoice_number AS invoice_number_1,
  p0_.subtotal AS subtotal_2,
  p0_.pro_discount AS pro_discount_3,
  p0_.amount_tax AS amount_tax_4,
  p0_.amount_total AS amount_total_5,
  p0_.reverse_charge AS reverse_charge_6,
  p0_.payment_method AS payment_method_7,
  p0_.payment_status AS payment_status_8,
  p0_.payment_due_at AS payment_due_at_9,
  p0_.paid_at AS paid_at_10,
  p0_.stripe_payment_intent_id AS stripe_payment_intent_id_11,
  p0_.invoice_pdf_path AS invoice_pdf_path_12,
  p0_.tracking_number AS tracking_number_13,
  p0_.tracking_carrier AS tracking_carrier_14,
  p0_.shipped_at AS shipped_at_15,
  p0_.created_at AS created_at_16,
  p0_.updated_at AS updated_at_17,
  p0_.shipping_street AS shipping_street_18,
  p0_.shipping_zip_code AS shipping_zip_code_19,
  p0_.shipping_city AS shipping_city_20,
  p0_.shipping_country AS shipping_country_21,
  p0_.user_id AS user_id_22
FROM
  pro_order p0_
WHERE
  p0_.user_id = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.invoice_number AS invoice_number_1, p0_.subtotal AS subtotal_2, p0_.pro_discount AS pro_discount_3, p0_.amount_tax AS amount_tax_4, p0_.amount_total AS amount_total_5, p0_.reverse_charge AS reverse_charge_6, p0_.payment_method AS payment_method_7, p0_.payment_status AS payment_status_8, p0_.payment_due_at AS payment_due_at_9, p0_.paid_at AS paid_at_10, p0_.stripe_payment_intent_id AS stripe_payment_intent_id_11, p0_.invoice_pdf_path AS invoice_pdf_path_12, p0_.tracking_number AS tracking_number_13, p0_.tracking_carrier AS tracking_carrier_14, p0_.shipped_at AS shipped_at_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.shipping_street AS shipping_street_18, p0_.shipping_zip_code AS shipping_zip_code_19, p0_.shipping_city AS shipping_city_20, p0_.shipping_country AS shipping_country_21, p0_.user_id AS user_id_22 FROM pro_order p0_ WHERE p0_.user_id = 9 ORDER BY p0_.created_at DESC LIMIT 5;

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = ?

[
  9
]

SELECT
  COUNT(*)
FROM
  pro_order t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = 9;

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = ? AND t0.payment_status = ?

[
  9
  "pending"
]

SELECT
  COUNT(*)
FROM
  pro_order t0
WHERE
  t0.user_id = ?
  AND t0.payment_status = ?

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = 9 AND t0.payment_status = 'pending';

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = ? AND t0.payment_status = ?

[
  9
  "overdue"
]

SELECT
  COUNT(*)
FROM
  pro_order t0
WHERE
  t0.user_id = ?
  AND t0.payment_status = ?

SELECT COUNT(*) FROM pro_order t0 WHERE t0.user_id = 9 AND t0.payment_status = 'overdue';

SELECT t0.id AS id_1, t0.tier AS tier_2, t0.status AS status_3, t0.stripe_payment_method_id AS stripe_payment_method_id_4, t0.stripe_subscription_id AS stripe_subscription_id_5, t0.nb_boxes_received AS nb_boxes_received_6, t0.discount_tier AS discount_tier_7, t0.started_at AS started_at_8, t0.paused_at AS paused_at_9, t0.cancelled_at AS cancelled_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.gift_card_id AS gift_card_id_14 FROM subscription t0 WHERE t0.user_id = ? AND t0.status = ? LIMIT 1

[
  9
  "active"
]

SELECT
  t0.id AS id_1,
  t0.tier AS tier_2,
  t0.status AS status_3,
  t0.stripe_payment_method_id AS stripe_payment_method_id_4,
  t0.stripe_subscription_id AS stripe_subscription_id_5,
  t0.nb_boxes_received AS nb_boxes_received_6,
  t0.discount_tier AS discount_tier_7,
  t0.started_at AS started_at_8,
  t0.paused_at AS paused_at_9,
  t0.cancelled_at AS cancelled_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.user_id AS user_id_13,
  t0.gift_card_id AS gift_card_id_14
FROM
  subscription t0
WHERE
  t0.user_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tier AS tier_2, t0.status AS status_3, t0.stripe_payment_method_id AS stripe_payment_method_id_4, t0.stripe_subscription_id AS stripe_subscription_id_5, t0.nb_boxes_received AS nb_boxes_received_6, t0.discount_tier AS discount_tier_7, t0.started_at AS started_at_8, t0.paused_at AS paused_at_9, t0.cancelled_at AS cancelled_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.gift_card_id AS gift_card_id_14 FROM subscription t0 WHERE t0.user_id = 9 AND t0.status = 'active' LIMIT 1;