Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.gender AS gender_2,
  t0.fname AS fname_3,
  t0.lname AS lname_4,
  t0.email AS email_5,
  t0.email_token AS email_token_6,
  t0.username AS username_7,
  t0.password AS password_8,
  t0.password_token AS password_token_9,
  t0.roles AS roles_10,
  t0.birthday AS birthday_11,
  t0.phone AS phone_12,
  t0.phone_token AS phone_token_13,
  t0.avatar AS avatar_14,
  t0.type AS type_15,
  t0.status AS status_16,
  t0.lang AS lang_17,
  t0.address1 AS address1_18,
  t0.address2 AS address2_19,
  t0.zipcode AS zipcode_20,
  t0.city AS city_21,
  t0.social_brand AS social_brand_22,
  t0.social_id AS social_id_23,
  t0.country AS country_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.last_login AS last_login_27,
  t0.trusted_version AS trusted_version_28,
  t0.is_verified AS is_verified_29,
  t0.description AS description_30,
  t0.location AS location_31,
  t0.is_vip AS is_vip_32,
  t0.is_seller AS is_seller_33,
  t0.company_id AS company_id_34,
  t0.groupe_id AS groupe_id_35,
  t0.team_id AS team_id_36
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = 1;

SELECT u.id AS id0, u.gender AS gender1, u.fname AS fname2, u.lname AS lname3, u.email AS email4, u.email_token AS email_token5, u.username AS username6, u.password AS password7, u.password_token AS password_token8, u.roles AS roles9, u.birthday AS birthday10, u.phone AS phone11, u.phone_token AS phone_token12, u.avatar AS avatar13, u.type AS type14, u.status AS status15, u.lang AS lang16, u.address1 AS address117, u.address2 AS address218, u.zipcode AS zipcode19, u.city AS city20, u.social_brand AS social_brand21, u.social_id AS social_id22, u.country AS country23, u.created_at AS created_at24, u.updated_at AS updated_at25, u.last_login AS last_login26, u.trusted_version AS trusted_version27, u.is_verified AS is_verified28, u.description AS description29, u.location AS location30, u.is_vip AS is_vip31, u.is_seller AS is_seller32, u.company_id AS company_id33, u.groupe_id AS groupe_id34, u.team_id AS team_id35
        FROM user u 
        WHERE JSON_SEARCH(u.roles, "one", ?) IS NOT NULL

[
  "ROLE_REVENDEUR"
]

SELECT
  u.id AS id0,
  u.gender AS gender1,
  u.fname AS fname2,
  u.lname AS lname3,
  u.email AS email4,
  u.email_token AS email_token5,
  u.username AS username6,
  u.password AS password7,
  u.password_token AS password_token8,
  u.roles AS roles9,
  u.birthday AS birthday10,
  u.phone AS phone11,
  u.phone_token AS phone_token12,
  u.avatar AS avatar13,
  u.type AS type14,
  u.status AS status15,
  u.lang AS lang16,
  u.address1 AS address117,
  u.address2 AS address218,
  u.zipcode AS zipcode19,
  u.city AS city20,
  u.social_brand AS social_brand21,
  u.social_id AS social_id22,
  u.country AS country23,
  u.created_at AS created_at24,
  u.updated_at AS updated_at25,
  u.last_login AS last_login26,
  u.trusted_version AS trusted_version27,
  u.is_verified AS is_verified28,
  u.description AS description29,
  u.location AS location30,
  u.is_vip AS is_vip31,
  u.is_seller AS is_seller32,
  u.company_id AS company_id33,
  u.groupe_id AS groupe_id34,
  u.team_id AS team_id35
FROM
  user u
WHERE
  JSON_SEARCH(u.roles, "one", ?) IS NOT NULL

SELECT u.id AS id0, u.gender AS gender1, u.fname AS fname2, u.lname AS lname3, u.email AS email4, u.email_token AS email_token5, u.username AS username6, u.password AS password7, u.password_token AS password_token8, u.roles AS roles9, u.birthday AS birthday10, u.phone AS phone11, u.phone_token AS phone_token12, u.avatar AS avatar13, u.type AS type14, u.status AS status15, u.lang AS lang16, u.address1 AS address117, u.address2 AS address218, u.zipcode AS zipcode19, u.city AS city20, u.social_brand AS social_brand21, u.social_id AS social_id22, u.country AS country23, u.created_at AS created_at24, u.updated_at AS updated_at25, u.last_login AS last_login26, u.trusted_version AS trusted_version27, u.is_verified AS is_verified28, u.description AS description29, u.location AS location30, u.is_vip AS is_vip31, u.is_seller AS is_seller32, u.company_id AS company_id33, u.groupe_id AS groupe_id34, u.team_id AS team_id35
        FROM user u 
        WHERE JSON_SEARCH(u.roles, "one", 'ROLE_REVENDEUR') IS NOT NULL;