Symfony Profiler

SELECT
  DISTINCT w0_.uuid AS uuid_0,
  w0_.email AS email_1,
  w0_.created_at AS created_at_2,
  w0_.updated_at AS updated_at_3,
  w0_.is_enabled AS is_enabled_4,
  w0_.first_name AS first_name_5,
  w0_.last_name AS last_name_6,
  w0_.phone AS phone_7,
  w0_.public_comments AS public_comments_8,
  w0_.private_comments AS private_comments_9,
  w0_.is_deleted AS is_deleted_10,
  w0_.reset_token_hash AS reset_token_hash_11,
  w0_.reset_token_expire_at AS reset_token_expire_at_12,
  w0_.current_balance AS current_balance_13,
  w0_.stripe_customer_id AS stripe_customer_id_14,
  w0_.referral_code_used AS referral_code_used_15,
  w0_.auth_username AS auth_username_16,
  w0_.auth_password_hash AS auth_password_hash_17,
  w1_.uuid AS uuid_18,
  w1_.type AS type_19,
  w1_.is_enabled AS is_enabled_20,
  w1_.created_at AS created_at_21,
  w1_.updated_at AS updated_at_22,
  w2_.uuid AS uuid_23,
  w2_.type AS type_24,
  w2_.is_enabled AS is_enabled_25,
  w2_.created_at AS created_at_26,
  w2_.updated_at AS updated_at_27,
  w0_.default_role_uuid AS default_role_uuid_28,
  w0_.active_role_uuid AS active_role_uuid_29,
  w0_.town_uuid AS town_uuid_30,
  w0_.whater_organization_uuid AS whater_organization_uuid_31,
  w0_.referral_whater_organization_uuid AS referral_whater_organization_uuid_32,
  w1_.user AS user_33,
  w2_.user AS user_34
FROM
  wt_user w0_
  LEFT JOIN wt_user_role w1_ ON w0_.default_role_uuid = w1_.uuid
  LEFT JOIN wt_user_role w2_ ON w0_.active_role_uuid = w2_.uuid
WHERE
  w0_.email = ?
  AND w0_.is_deleted = 0

SELECT DISTINCT w0_.uuid AS uuid_0, w0_.email AS email_1, w0_.created_at AS created_at_2, w0_.updated_at AS updated_at_3, w0_.is_enabled AS is_enabled_4, w0_.first_name AS first_name_5, w0_.last_name AS last_name_6, w0_.phone AS phone_7, w0_.public_comments AS public_comments_8, w0_.private_comments AS private_comments_9, w0_.is_deleted AS is_deleted_10, w0_.reset_token_hash AS reset_token_hash_11, w0_.reset_token_expire_at AS reset_token_expire_at_12, w0_.current_balance AS current_balance_13, w0_.stripe_customer_id AS stripe_customer_id_14, w0_.referral_code_used AS referral_code_used_15, w0_.auth_username AS auth_username_16, w0_.auth_password_hash AS auth_password_hash_17, w1_.uuid AS uuid_18, w1_.type AS type_19, w1_.is_enabled AS is_enabled_20, w1_.created_at AS created_at_21, w1_.updated_at AS updated_at_22, w2_.uuid AS uuid_23, w2_.type AS type_24, w2_.is_enabled AS is_enabled_25, w2_.created_at AS created_at_26, w2_.updated_at AS updated_at_27, w0_.default_role_uuid AS default_role_uuid_28, w0_.active_role_uuid AS active_role_uuid_29, w0_.town_uuid AS town_uuid_30, w0_.whater_organization_uuid AS whater_organization_uuid_31, w0_.referral_whater_organization_uuid AS referral_whater_organization_uuid_32, w1_.user AS user_33, w2_.user AS user_34 FROM wt_user w0_ LEFT JOIN wt_user_role w1_ ON w0_.default_role_uuid = w1_.uuid LEFT JOIN wt_user_role w2_ ON w0_.active_role_uuid = w2_.uuid WHERE w0_.email = 'hostmaster@whater.es' AND w0_.is_deleted = 0;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.uuid AS uuid_22,
  t0.position AS position_23,
  t0.avatar_user_uuid AS avatar_user_uuid_24
FROM
  wt_media t0
WHERE
  t0.avatar_user_uuid = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.uuid AS uuid_22, t0.position AS position_23, t0.avatar_user_uuid AS avatar_user_uuid_24 FROM wt_media t0 WHERE t0.avatar_user_uuid = '4d5518a7-53d7-471e-91ff-be6f7c548a49';

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  w0_.uuid AS uuid_0,
  w0_.email AS email_1,
  w0_.created_at AS created_at_2,
  w0_.updated_at AS updated_at_3,
  w0_.is_enabled AS is_enabled_4,
  w0_.first_name AS first_name_5,
  w0_.last_name AS last_name_6,
  w0_.phone AS phone_7,
  w0_.public_comments AS public_comments_8,
  w0_.private_comments AS private_comments_9,
  w0_.is_deleted AS is_deleted_10,
  w0_.reset_token_hash AS reset_token_hash_11,
  w0_.reset_token_expire_at AS reset_token_expire_at_12,
  w0_.current_balance AS current_balance_13,
  w0_.stripe_customer_id AS stripe_customer_id_14,
  w0_.referral_code_used AS referral_code_used_15,
  w0_.auth_username AS auth_username_16,
  w0_.auth_password_hash AS auth_password_hash_17,
  w0_.default_role_uuid AS default_role_uuid_18,
  w0_.active_role_uuid AS active_role_uuid_19,
  w0_.town_uuid AS town_uuid_20,
  w0_.whater_organization_uuid AS whater_organization_uuid_21,
  w0_.referral_whater_organization_uuid AS referral_whater_organization_uuid_22
FROM
  wt_user w0_
  LEFT JOIN wt_user_role w1_ ON w0_.uuid = w1_.user
WHERE
  w0_.is_deleted = 0
  AND (w0_.first_name LIKE ?)
ORDER BY
  w0_.created_at DESC
LIMIT
  10

SELECT w0_.uuid AS uuid_0, w0_.email AS email_1, w0_.created_at AS created_at_2, w0_.updated_at AS updated_at_3, w0_.is_enabled AS is_enabled_4, w0_.first_name AS first_name_5, w0_.last_name AS last_name_6, w0_.phone AS phone_7, w0_.public_comments AS public_comments_8, w0_.private_comments AS private_comments_9, w0_.is_deleted AS is_deleted_10, w0_.reset_token_hash AS reset_token_hash_11, w0_.reset_token_expire_at AS reset_token_expire_at_12, w0_.current_balance AS current_balance_13, w0_.stripe_customer_id AS stripe_customer_id_14, w0_.referral_code_used AS referral_code_used_15, w0_.auth_username AS auth_username_16, w0_.auth_password_hash AS auth_password_hash_17, w0_.default_role_uuid AS default_role_uuid_18, w0_.active_role_uuid AS active_role_uuid_19, w0_.town_uuid AS town_uuid_20, w0_.whater_organization_uuid AS whater_organization_uuid_21, w0_.referral_whater_organization_uuid AS referral_whater_organization_uuid_22 FROM wt_user w0_ LEFT JOIN wt_user_role w1_ ON w0_.uuid = w1_.user WHERE w0_.is_deleted = 0 AND (w0_.first_name LIKE '%isra%') ORDER BY w0_.created_at DESC LIMIT 10;

SELECT
  count(DISTINCT w0_.uuid) AS sclr_0
FROM
  wt_user w0_
  LEFT JOIN wt_user_role w1_ ON w0_.uuid = w1_.user
WHERE
  w0_.is_deleted = 0
  AND (w0_.first_name LIKE ?)

SELECT count(DISTINCT w0_.uuid) AS sclr_0 FROM wt_user w0_ LEFT JOIN wt_user_role w1_ ON w0_.uuid = w1_.user WHERE w0_.is_deleted = 0 AND (w0_.first_name LIKE '%isra%');