Symfony Profiler

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

Query Metrics

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.phone AS phone_5, u0_.address_line1 AS address_line1_6, u0_.address_line2 AS address_line2_7, u0_.city AS city_8, u0_.state AS state_9, u0_.postal_code AS postal_code_10, u0_.is_company AS is_company_11, c1_.id AS id_12, c1_.company_name AS company_name_13, c1_.logo_name AS logo_name_14, c1_.ein AS ein_15, c1_.status AS status_16, c1_.submitted_at AS submitted_at_17, c1_.reviewed_at AS reviewed_at_18, c1_.user_id AS user_id_19 FROM users u0_ INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id WHERE u0_.id = ? AND c1_.status = ?

[
  12
  "active"
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.is_verified AS is_verified_4,
  u0_.phone AS phone_5,
  u0_.address_line1 AS address_line1_6,
  u0_.address_line2 AS address_line2_7,
  u0_.city AS city_8,
  u0_.state AS state_9,
  u0_.postal_code AS postal_code_10,
  u0_.is_company AS is_company_11,
  c1_.id AS id_12,
  c1_.company_name AS company_name_13,
  c1_.logo_name AS logo_name_14,
  c1_.ein AS ein_15,
  c1_.status AS status_16,
  c1_.submitted_at AS submitted_at_17,
  c1_.reviewed_at AS reviewed_at_18,
  c1_.user_id AS user_id_19
FROM
  users u0_
  INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id
WHERE
  u0_.id = ?
  AND c1_.status = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.phone AS phone_5, u0_.address_line1 AS address_line1_6, u0_.address_line2 AS address_line2_7, u0_.city AS city_8, u0_.state AS state_9, u0_.postal_code AS postal_code_10, u0_.is_company AS is_company_11, c1_.id AS id_12, c1_.company_name AS company_name_13, c1_.logo_name AS logo_name_14, c1_.ein AS ein_15, c1_.status AS status_16, c1_.submitted_at AS submitted_at_17, c1_.reviewed_at AS reviewed_at_18, c1_.user_id AS user_id_19 FROM users u0_ INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id WHERE u0_.id = 12 AND c1_.status = 'active';

SELECT COUNT(s0_.id) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?

[
  12
  "active"
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.seller_id = u1_.id
WHERE
  u1_.id = ?
  AND s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = 12 AND s0_.status = 'active';

SELECT s0_.id AS id_0, s0_.rating AS rating_1, s0_.message AS message_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.is_verified AS is_verified_23, u2_.phone AS phone_24, u2_.address_line1 AS address_line1_25, u2_.address_line2 AS address_line2_26, u2_.city AS city_27, u2_.state AS state_28, u2_.postal_code AS postal_code_29, u2_.is_company AS is_company_30, o3_.id AS id_31, o3_.order_index AS order_index_32, o3_.delivery_address AS delivery_address_33, o3_.phone AS phone_34, o3_.email AS email_35, o3_.delivery_method AS delivery_method_36, o3_.delivery_price AS delivery_price_37, o3_.subtotal AS subtotal_38, o3_.total AS total_39, o3_.status AS status_40, o3_.created_at AS created_at_41, s0_.order_id AS order_id_42, s0_.buyer_id AS buyer_id_43, s0_.seller_id AS seller_id_44, o3_.buyer_id AS buyer_id_45 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.buyer_id = u1_.id INNER JOIN users u2_ ON s0_.seller_id = u2_.id INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id WHERE u2_.id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC LIMIT 20

[
  12
  "active"
]

SELECT
  s0_.id AS id_0,
  s0_.rating AS rating_1,
  s0_.message AS message_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.reviewed_at AS reviewed_at_6,
  u1_.id AS id_7,
  u1_.email AS email_8,
  u1_.roles AS roles_9,
  u1_.password AS password_10,
  u1_.is_verified AS is_verified_11,
  u1_.phone AS phone_12,
  u1_.address_line1 AS address_line1_13,
  u1_.address_line2 AS address_line2_14,
  u1_.city AS city_15,
  u1_.state AS state_16,
  u1_.postal_code AS postal_code_17,
  u1_.is_company AS is_company_18,
  u2_.id AS id_19,
  u2_.email AS email_20,
  u2_.roles AS roles_21,
  u2_.password AS password_22,
  u2_.is_verified AS is_verified_23,
  u2_.phone AS phone_24,
  u2_.address_line1 AS address_line1_25,
  u2_.address_line2 AS address_line2_26,
  u2_.city AS city_27,
  u2_.state AS state_28,
  u2_.postal_code AS postal_code_29,
  u2_.is_company AS is_company_30,
  o3_.id AS id_31,
  o3_.order_index AS order_index_32,
  o3_.delivery_address AS delivery_address_33,
  o3_.phone AS phone_34,
  o3_.email AS email_35,
  o3_.delivery_method AS delivery_method_36,
  o3_.delivery_price AS delivery_price_37,
  o3_.subtotal AS subtotal_38,
  o3_.total AS total_39,
  o3_.status AS status_40,
  o3_.created_at AS created_at_41,
  s0_.order_id AS order_id_42,
  s0_.buyer_id AS buyer_id_43,
  s0_.seller_id AS seller_id_44,
  o3_.buyer_id AS buyer_id_45
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.buyer_id = u1_.id
  INNER JOIN users u2_ ON s0_.seller_id = u2_.id
  INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id
WHERE
  u2_.id = ?
  AND s0_.status = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  20

SELECT s0_.id AS id_0, s0_.rating AS rating_1, s0_.message AS message_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.is_verified AS is_verified_23, u2_.phone AS phone_24, u2_.address_line1 AS address_line1_25, u2_.address_line2 AS address_line2_26, u2_.city AS city_27, u2_.state AS state_28, u2_.postal_code AS postal_code_29, u2_.is_company AS is_company_30, o3_.id AS id_31, o3_.order_index AS order_index_32, o3_.delivery_address AS delivery_address_33, o3_.phone AS phone_34, o3_.email AS email_35, o3_.delivery_method AS delivery_method_36, o3_.delivery_price AS delivery_price_37, o3_.subtotal AS subtotal_38, o3_.total AS total_39, o3_.status AS status_40, o3_.created_at AS created_at_41, s0_.order_id AS order_id_42, s0_.buyer_id AS buyer_id_43, s0_.seller_id AS seller_id_44, o3_.buyer_id AS buyer_id_45 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.buyer_id = u1_.id INNER JOIN users u2_ ON s0_.seller_id = u2_.id INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id WHERE u2_.id = 12 AND s0_.status = 'active' ORDER BY s0_.created_at DESC LIMIT 20;

SELECT COALESCE(AVG(s0_.rating), 0) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?

[
  12
  "active"
]

SELECT
  COALESCE(
    AVG(s0_.rating),
    0
  ) AS sclr_0
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.seller_id = u1_.id
WHERE
  u1_.id = ?
  AND s0_.status = ?

SELECT COALESCE(AVG(s0_.rating), 0) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = 12 AND s0_.status = 'active';