Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.is_verified AS is_verified_6,
  t0.is_banned AS is_banned_7,
  t0.welcome_seen AS welcome_seen_8,
  t0.phone_verified AS phone_verified_9,
  t0.email_verification_token AS email_verification_token_10,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_11,
  t0.registration_ip AS registration_ip_12,
  t0.registration_country AS registration_country_13,
  t0.registration_city AS registration_city_14,
  t0.user_type AS user_type_15,
  t16.id AS id_17,
  t16.pseudo AS pseudo_18,
  t16.first_name AS first_name_19,
  t16.last_name AS last_name_20,
  t16.date_of_birth AS date_of_birth_21,
  t16.phone AS phone_22,
  t16.profile_picture AS profile_picture_23,
  t16.gender AS gender_24,
  t16.country AS country_25,
  t16.bio AS bio_26,
  t16.created_at AS created_at_27,
  t16.user_id AS user_id_28,
  t29.id AS id_30,
  t29.pseudo AS pseudo_31,
  t29.first_name AS first_name_32,
  t29.last_name AS last_name_33,
  t29.date_of_birth AS date_of_birth_34,
  t29.country AS country_35,
  t29.bio AS bio_36,
  t29.profile_picture AS profile_picture_37,
  t29.cover_picture AS cover_picture_38,
  t29.height AS height_39,
  t29.weight AS weight_40,
  t29.shoe_size AS shoe_size_41,
  t29.has_tattoo AS has_tattoo_42,
  t29.tattoo_description AS tattoo_description_43,
  t29.has_piercing AS has_piercing_44,
  t29.piercing_description AS piercing_description_45,
  t29.gender AS gender_46,
  t29.phone AS phone_47,
  t29.website AS website_48,
  t29.instagram AS instagram_49,
  t29.snapchat AS snapchat_50,
  t29.show_subscribers_count AS show_subscribers_count_51,
  t29.show_posts_count AS show_posts_count_52,
  t29.origin AS origin_53,
  t29.has_pedicure AS has_pedicure_54,
  t29.sexual_orientation AS sexual_orientation_55,
  t29.hair_color AS hair_color_56,
  t29.created_at AS created_at_57,
  t29.subscription_price AS subscription_price_58,
  t29.id_document_path AS id_document_path_59,
  t29.selfie_document_path AS selfie_document_path_60,
  t29.is_certified AS is_certified_61,
  t29.auto_message_enabled AS auto_message_enabled_62,
  t29.auto_message_content AS auto_message_content_63,
  t29.notif_new_subscriber AS notif_new_subscriber_64,
  t29.notif_new_message AS notif_new_message_65,
  t29.notif_new_like AS notif_new_like_66,
  t29.iban AS iban_67,
  t29.bic AS bic_68,
  t29.bank_account_name AS bank_account_name_69,
  t29.user_id AS user_id_70
FROM
  `user` t0
  LEFT JOIN fan_profile t16 ON t16.user_id = t0.id
  LEFT JOIN creator_profile t29 ON t29.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_verified AS is_verified_6, t0.is_banned AS is_banned_7, t0.welcome_seen AS welcome_seen_8, t0.phone_verified AS phone_verified_9, t0.email_verification_token AS email_verification_token_10, t0.email_verification_token_expires_at AS email_verification_token_expires_at_11, t0.registration_ip AS registration_ip_12, t0.registration_country AS registration_country_13, t0.registration_city AS registration_city_14, t0.user_type AS user_type_15, t16.id AS id_17, t16.pseudo AS pseudo_18, t16.first_name AS first_name_19, t16.last_name AS last_name_20, t16.date_of_birth AS date_of_birth_21, t16.phone AS phone_22, t16.profile_picture AS profile_picture_23, t16.gender AS gender_24, t16.country AS country_25, t16.bio AS bio_26, t16.created_at AS created_at_27, t16.user_id AS user_id_28, t29.id AS id_30, t29.pseudo AS pseudo_31, t29.first_name AS first_name_32, t29.last_name AS last_name_33, t29.date_of_birth AS date_of_birth_34, t29.country AS country_35, t29.bio AS bio_36, t29.profile_picture AS profile_picture_37, t29.cover_picture AS cover_picture_38, t29.height AS height_39, t29.weight AS weight_40, t29.shoe_size AS shoe_size_41, t29.has_tattoo AS has_tattoo_42, t29.tattoo_description AS tattoo_description_43, t29.has_piercing AS has_piercing_44, t29.piercing_description AS piercing_description_45, t29.gender AS gender_46, t29.phone AS phone_47, t29.website AS website_48, t29.instagram AS instagram_49, t29.snapchat AS snapchat_50, t29.show_subscribers_count AS show_subscribers_count_51, t29.show_posts_count AS show_posts_count_52, t29.origin AS origin_53, t29.has_pedicure AS has_pedicure_54, t29.sexual_orientation AS sexual_orientation_55, t29.hair_color AS hair_color_56, t29.created_at AS created_at_57, t29.subscription_price AS subscription_price_58, t29.id_document_path AS id_document_path_59, t29.selfie_document_path AS selfie_document_path_60, t29.is_certified AS is_certified_61, t29.auto_message_enabled AS auto_message_enabled_62, t29.auto_message_content AS auto_message_content_63, t29.notif_new_subscriber AS notif_new_subscriber_64, t29.notif_new_message AS notif_new_message_65, t29.notif_new_like AS notif_new_like_66, t29.iban AS iban_67, t29.bic AS bic_68, t29.bank_account_name AS bank_account_name_69, t29.user_id AS user_id_70 FROM `user` t0 LEFT JOIN fan_profile t16 ON t16.user_id = t0.id LEFT JOIN creator_profile t29 ON t29.user_id = t0.id WHERE t0.id = 1;

SELECT
  DATE(created_at) AS day,
  COUNT(id) AS cnt
FROM
  `user`
WHERE
  created_at >= ?
GROUP BY
  day
ORDER BY
  day ASC

SELECT DATE(created_at) AS day, COUNT(id) AS cnt
             FROM `user`
             WHERE created_at >= '2026-03-28 00:00:00'
             GROUP BY day
             ORDER BY day ASC;

SELECT
  c0_.created_at AS created_at_0,
  c0_.gross_amount AS gross_amount_1
FROM
  creator_earning c0_
WHERE
  c0_.created_at >= ?
ORDER BY
  c0_.created_at ASC

SELECT c0_.created_at AS created_at_0, c0_.gross_amount AS gross_amount_1 FROM creator_earning c0_ WHERE c0_.created_at >= '2025-05-01 00:00:00' ORDER BY c0_.created_at ASC;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_
WHERE
  u0_.user_type = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.user_type = 'fan';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_
WHERE
  u0_.user_type = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.user_type = 'creator';

SELECT
  t0.id AS id_1,
  t0.reason AS reason_2,
  t0.created_at AS created_at_3,
  t0.post_id AS post_id_4,
  t0.user_id AS user_id_5
FROM
  post_report t0

SELECT t0.id AS id_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.post_id AS post_id_4, t0.user_id AS user_id_5 FROM post_report t0;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  support_ticket s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM support_ticket s0_ WHERE s0_.status = 'open';

SELECT
  p0_.id AS id_0,
  p0_.reason AS reason_1,
  p0_.created_at AS created_at_2,
  p0_.post_id AS post_id_3,
  p0_.user_id AS user_id_4
FROM
  post_report p0_
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.reason AS reason_1, p0_.created_at AS created_at_2, p0_.post_id AS post_id_3, p0_.user_id AS user_id_4 FROM post_report p0_ ORDER BY p0_.created_at DESC LIMIT 5;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.email AS email_2,
  s0_.subject AS subject_3,
  s0_.message AS message_4,
  s0_.status AS status_5,
  s0_.admin_note AS admin_note_6,
  s0_.created_at AS created_at_7,
  s0_.closed_at AS closed_at_8,
  s0_.user_id AS user_id_9
FROM
  support_ticket s0_
ORDER BY
  s0_.created_at DESC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.email AS email_2, s0_.subject AS subject_3, s0_.message AS message_4, s0_.status AS status_5, s0_.admin_note AS admin_note_6, s0_.created_at AS created_at_7, s0_.closed_at AS closed_at_8, s0_.user_id AS user_id_9 FROM support_ticket s0_ ORDER BY s0_.created_at DESC LIMIT 5;

SELECT
  COALESCE(
    SUM(c0_.gross_amount),
    0
  ) AS sclr_0
FROM
  creator_earning c0_

SELECT COALESCE(SUM(c0_.gross_amount), 0) AS sclr_0 FROM creator_earning c0_;

SELECT
  p0_.id AS id_0,
  p0_.reason AS reason_1,
  p0_.created_at AS created_at_2,
  p0_.post_id AS post_id_3,
  p0_.user_id AS user_id_4
FROM
  post_report p0_
ORDER BY
  p0_.created_at DESC
LIMIT
  999

SELECT p0_.id AS id_0, p0_.reason AS reason_1, p0_.created_at AS created_at_2, p0_.post_id AS post_id_3, p0_.user_id AS user_id_4 FROM post_report p0_ ORDER BY p0_.created_at DESC LIMIT 999;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  support_ticket s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM support_ticket s0_ WHERE s0_.status = 'open';

SELECT
  v0_.id AS id_0,
  v0_.status AS status_1,
  v0_.full_name AS full_name_2,
  v0_.document_type AS document_type_3,
  v0_.document_note AS document_note_4,
  v0_.submitted_at AS submitted_at_5,
  v0_.reviewed_at AS reviewed_at_6,
  v0_.admin_note AS admin_note_7,
  v0_.creator_id AS creator_id_8
FROM
  verification_request v0_
WHERE
  v0_.status = ?
ORDER BY
  v0_.submitted_at ASC

SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.full_name AS full_name_2, v0_.document_type AS document_type_3, v0_.document_note AS document_note_4, v0_.submitted_at AS submitted_at_5, v0_.reviewed_at AS reviewed_at_6, v0_.admin_note AS admin_note_7, v0_.creator_id AS creator_id_8 FROM verification_request v0_ WHERE v0_.status = 'pending' ORDER BY v0_.submitted_at ASC;