Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.surname AS surname_6,
  t0.company_name AS company_name_7,
  t0.city AS city_8,
  t0.postcode AS postcode_9,
  t0.province AS province_10,
  t0.address AS address_11,
  t0.address2 AS address2_12,
  t0.lat AS lat_13,
  t0.lng AS lng_14,
  t0.phone AS phone_15,
  t0.nif AS nif_16,
  t0.about AS about_17,
  t0.languages AS languages_18,
  t0.slogan AS slogan_19,
  t0.professional_self_employed AS professional_self_employed_20,
  t0.professional_representative_company AS professional_representative_company_21,
  t0.years_experience AS years_experience_22,
  t0.amount_from AS amount_from_23,
  t0.jobs_count AS jobs_count_24,
  t0.rating AS rating_25,
  t0.badge AS badge_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.google_id AS google_id_29,
  t0.apple_id AS apple_id_30,
  t0.preferred_locale AS preferred_locale_31,
  t0.is_active AS is_active_32,
  t0.activation_code AS activation_code_33,
  t0.can_login AS can_login_34,
  t0.admin_validation AS admin_validation_35,
  t0.full_access AS full_access_36,
  t0.connected_account_verified AS connected_account_verified_37,
  t0.has_active_subscription AS has_active_subscription_38,
  t0.invoice_sequence AS invoice_sequence_39,
  t0.fcm_token AS fcm_token_40,
  t0.deleted_at AS deleted_at_41,
  t42.id AS id_43,
  t42.created_at AS created_at_44,
  t42.user_id AS user_id_45,
  t46.id AS id_47,
  t46.customer_id AS customer_id_48,
  t46.connected_account_id AS connected_account_id_49,
  t46.created_at AS created_at_50,
  t46.updated_at AS updated_at_51,
  t46.professional_id AS professional_id_52
FROM
  "users" t0
  LEFT JOIN "chats_online_users" t42 ON t42.user_id = t0.id
  LEFT JOIN "professionals_payments_data" t46 ON t46.professional_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.company_name AS company_name_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.province AS province_10, t0.address AS address_11, t0.address2 AS address2_12, t0.lat AS lat_13, t0.lng AS lng_14, t0.phone AS phone_15, t0.nif AS nif_16, t0.about AS about_17, t0.languages AS languages_18, t0.slogan AS slogan_19, t0.professional_self_employed AS professional_self_employed_20, t0.professional_representative_company AS professional_representative_company_21, t0.years_experience AS years_experience_22, t0.amount_from AS amount_from_23, t0.jobs_count AS jobs_count_24, t0.rating AS rating_25, t0.badge AS badge_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.google_id AS google_id_29, t0.apple_id AS apple_id_30, t0.preferred_locale AS preferred_locale_31, t0.is_active AS is_active_32, t0.activation_code AS activation_code_33, t0.can_login AS can_login_34, t0.admin_validation AS admin_validation_35, t0.full_access AS full_access_36, t0.connected_account_verified AS connected_account_verified_37, t0.has_active_subscription AS has_active_subscription_38, t0.invoice_sequence AS invoice_sequence_39, t0.fcm_token AS fcm_token_40, t0.deleted_at AS deleted_at_41, t42.id AS id_43, t42.created_at AS created_at_44, t42.user_id AS user_id_45, t46.id AS id_47, t46.customer_id AS customer_id_48, t46.connected_account_id AS connected_account_id_49, t46.created_at AS created_at_50, t46.updated_at AS updated_at_51, t46.professional_id AS professional_id_52 FROM "users" t0 LEFT JOIN "chats_online_users" t42 ON t42.user_id = t0.id LEFT JOIN "professionals_payments_data" t46 ON t46.professional_id = t0.id WHERE t0.email = 'gonzalocalderon11@hotmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.subscription_id AS subscription_id_2,
  t0.status AS status_3,
  t0.billing_ends_at AS billing_ends_at_4,
  t0.card_brand AS card_brand_5,
  t0.card_last_four_digits AS card_last_four_digits_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.trial_ends_at AS trial_ends_at_9,
  t0.payment_link AS payment_link_10,
  t0.payment_link_id AS payment_link_id_11,
  t0.plan_id AS plan_id_12,
  t0.professional_payment_data_id AS professional_payment_data_id_13
FROM
  "subscriptions" t0
WHERE
  t0.professional_payment_data_id = ?

SELECT t0.id AS id_1, t0.subscription_id AS subscription_id_2, t0.status AS status_3, t0.billing_ends_at AS billing_ends_at_4, t0.card_brand AS card_brand_5, t0.card_last_four_digits AS card_last_four_digits_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.trial_ends_at AS trial_ends_at_9, t0.payment_link AS payment_link_10, t0.payment_link_id AS payment_link_id_11, t0.plan_id AS plan_id_12, t0.professional_payment_data_id AS professional_payment_data_id_13 FROM "subscriptions" t0 WHERE t0.professional_payment_data_id = '019afff7-75ca-778c-aadc-7f819184aa40';

SELECT
  t0.id AS id_1,
  t0.featured_id AS featured_id_2,
  t0.status AS status_3,
  t0.billing_ends_at AS billing_ends_at_4,
  t0.card_brand AS card_brand_5,
  t0.card_last_four_digits AS card_last_four_digits_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.trial_ends_at AS trial_ends_at_9,
  t0.advertising_id AS advertising_id_10,
  t0.professional_payment_data_id AS professional_payment_data_id_11,
  t0.province_id AS province_id_12,
  t0.skill_id AS skill_id_13,
  t0.user_id AS user_id_14
FROM
  "featured" t0
WHERE
  t0.professional_payment_data_id = ?

SELECT t0.id AS id_1, t0.featured_id AS featured_id_2, t0.status AS status_3, t0.billing_ends_at AS billing_ends_at_4, t0.card_brand AS card_brand_5, t0.card_last_four_digits AS card_last_four_digits_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.trial_ends_at AS trial_ends_at_9, t0.advertising_id AS advertising_id_10, t0.professional_payment_data_id AS professional_payment_data_id_11, t0.province_id AS province_id_12, t0.skill_id AS skill_id_13, t0.user_id AS user_id_14 FROM "featured" t0 WHERE t0.professional_payment_data_id = '019afff7-75ca-778c-aadc-7f819184aa40';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.surname AS surname_6,
  t0.company_name AS company_name_7,
  t0.city AS city_8,
  t0.postcode AS postcode_9,
  t0.province AS province_10,
  t0.address AS address_11,
  t0.address2 AS address2_12,
  t0.lat AS lat_13,
  t0.lng AS lng_14,
  t0.phone AS phone_15,
  t0.nif AS nif_16,
  t0.about AS about_17,
  t0.languages AS languages_18,
  t0.slogan AS slogan_19,
  t0.professional_self_employed AS professional_self_employed_20,
  t0.professional_representative_company AS professional_representative_company_21,
  t0.years_experience AS years_experience_22,
  t0.amount_from AS amount_from_23,
  t0.jobs_count AS jobs_count_24,
  t0.rating AS rating_25,
  t0.badge AS badge_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.google_id AS google_id_29,
  t0.apple_id AS apple_id_30,
  t0.preferred_locale AS preferred_locale_31,
  t0.is_active AS is_active_32,
  t0.activation_code AS activation_code_33,
  t0.can_login AS can_login_34,
  t0.admin_validation AS admin_validation_35,
  t0.full_access AS full_access_36,
  t0.connected_account_verified AS connected_account_verified_37,
  t0.has_active_subscription AS has_active_subscription_38,
  t0.invoice_sequence AS invoice_sequence_39,
  t0.fcm_token AS fcm_token_40,
  t0.deleted_at AS deleted_at_41,
  t42.id AS id_43,
  t42.created_at AS created_at_44,
  t42.user_id AS user_id_45,
  t46.id AS id_47,
  t46.customer_id AS customer_id_48,
  t46.connected_account_id AS connected_account_id_49,
  t46.created_at AS created_at_50,
  t46.updated_at AS updated_at_51,
  t46.professional_id AS professional_id_52
FROM
  "users" t0
  LEFT JOIN "chats_online_users" t42 ON t42.user_id = t0.id
  LEFT JOIN "professionals_payments_data" t46 ON t46.professional_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.company_name AS company_name_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.province AS province_10, t0.address AS address_11, t0.address2 AS address2_12, t0.lat AS lat_13, t0.lng AS lng_14, t0.phone AS phone_15, t0.nif AS nif_16, t0.about AS about_17, t0.languages AS languages_18, t0.slogan AS slogan_19, t0.professional_self_employed AS professional_self_employed_20, t0.professional_representative_company AS professional_representative_company_21, t0.years_experience AS years_experience_22, t0.amount_from AS amount_from_23, t0.jobs_count AS jobs_count_24, t0.rating AS rating_25, t0.badge AS badge_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.google_id AS google_id_29, t0.apple_id AS apple_id_30, t0.preferred_locale AS preferred_locale_31, t0.is_active AS is_active_32, t0.activation_code AS activation_code_33, t0.can_login AS can_login_34, t0.admin_validation AS admin_validation_35, t0.full_access AS full_access_36, t0.connected_account_verified AS connected_account_verified_37, t0.has_active_subscription AS has_active_subscription_38, t0.invoice_sequence AS invoice_sequence_39, t0.fcm_token AS fcm_token_40, t0.deleted_at AS deleted_at_41, t42.id AS id_43, t42.created_at AS created_at_44, t42.user_id AS user_id_45, t46.id AS id_47, t46.customer_id AS customer_id_48, t46.connected_account_id AS connected_account_id_49, t46.created_at AS created_at_50, t46.updated_at AS updated_at_51, t46.professional_id AS professional_id_52 FROM "users" t0 LEFT JOIN "chats_online_users" t42 ON t42.user_id = t0.id LEFT JOIN "professionals_payments_data" t46 ON t46.professional_id = t0.id WHERE t0.email = 'gonzalocalderon11@hotmail.com' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.surname AS surname_5,
  u0_.company_name AS company_name_6,
  u0_.city AS city_7,
  u0_.postcode AS postcode_8,
  u0_.province AS province_9,
  u0_.address AS address_10,
  u0_.address2 AS address2_11,
  u0_.lat AS lat_12,
  u0_.lng AS lng_13,
  u0_.phone AS phone_14,
  u0_.nif AS nif_15,
  u0_.about AS about_16,
  u0_.languages AS languages_17,
  u0_.slogan AS slogan_18,
  u0_.professional_self_employed AS professional_self_employed_19,
  u0_.professional_representative_company AS professional_representative_company_20,
  u0_.years_experience AS years_experience_21,
  u0_.amount_from AS amount_from_22,
  u0_.jobs_count AS jobs_count_23,
  u0_.rating AS rating_24,
  u0_.badge AS badge_25,
  u0_.created_at AS created_at_26,
  u0_.updated_at AS updated_at_27,
  u0_.google_id AS google_id_28,
  u0_.apple_id AS apple_id_29,
  u0_.preferred_locale AS preferred_locale_30,
  u0_.is_active AS is_active_31,
  u0_.activation_code AS activation_code_32,
  u0_.can_login AS can_login_33,
  u0_.admin_validation AS admin_validation_34,
  u0_.full_access AS full_access_35,
  u0_.connected_account_verified AS connected_account_verified_36,
  u0_.has_active_subscription AS has_active_subscription_37,
  u0_.invoice_sequence AS invoice_sequence_38,
  u0_.fcm_token AS fcm_token_39,
  u0_.deleted_at AS deleted_at_40
FROM
  "users" u0_
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.surname AS surname_5, u0_.company_name AS company_name_6, u0_.city AS city_7, u0_.postcode AS postcode_8, u0_.province AS province_9, u0_.address AS address_10, u0_.address2 AS address2_11, u0_.lat AS lat_12, u0_.lng AS lng_13, u0_.phone AS phone_14, u0_.nif AS nif_15, u0_.about AS about_16, u0_.languages AS languages_17, u0_.slogan AS slogan_18, u0_.professional_self_employed AS professional_self_employed_19, u0_.professional_representative_company AS professional_representative_company_20, u0_.years_experience AS years_experience_21, u0_.amount_from AS amount_from_22, u0_.jobs_count AS jobs_count_23, u0_.rating AS rating_24, u0_.badge AS badge_25, u0_.created_at AS created_at_26, u0_.updated_at AS updated_at_27, u0_.google_id AS google_id_28, u0_.apple_id AS apple_id_29, u0_.preferred_locale AS preferred_locale_30, u0_.is_active AS is_active_31, u0_.activation_code AS activation_code_32, u0_.can_login AS can_login_33, u0_.admin_validation AS admin_validation_34, u0_.full_access AS full_access_35, u0_.connected_account_verified AS connected_account_verified_36, u0_.has_active_subscription AS has_active_subscription_37, u0_.invoice_sequence AS invoice_sequence_38, u0_.fcm_token AS fcm_token_39, u0_.deleted_at AS deleted_at_40 FROM "users" u0_ WHERE u0_.id = 0x019AFFF6B14D7A4A9448AC1A7824570F;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.surname AS surname_5,
  u0_.company_name AS company_name_6,
  u0_.city AS city_7,
  u0_.postcode AS postcode_8,
  u0_.province AS province_9,
  u0_.address AS address_10,
  u0_.address2 AS address2_11,
  u0_.lat AS lat_12,
  u0_.lng AS lng_13,
  u0_.phone AS phone_14,
  u0_.nif AS nif_15,
  u0_.about AS about_16,
  u0_.languages AS languages_17,
  u0_.slogan AS slogan_18,
  u0_.professional_self_employed AS professional_self_employed_19,
  u0_.professional_representative_company AS professional_representative_company_20,
  u0_.years_experience AS years_experience_21,
  u0_.amount_from AS amount_from_22,
  u0_.jobs_count AS jobs_count_23,
  u0_.rating AS rating_24,
  u0_.badge AS badge_25,
  u0_.created_at AS created_at_26,
  u0_.updated_at AS updated_at_27,
  u0_.google_id AS google_id_28,
  u0_.apple_id AS apple_id_29,
  u0_.preferred_locale AS preferred_locale_30,
  u0_.is_active AS is_active_31,
  u0_.activation_code AS activation_code_32,
  u0_.can_login AS can_login_33,
  u0_.admin_validation AS admin_validation_34,
  u0_.full_access AS full_access_35,
  u0_.connected_account_verified AS connected_account_verified_36,
  u0_.has_active_subscription AS has_active_subscription_37,
  u0_.invoice_sequence AS invoice_sequence_38,
  u0_.fcm_token AS fcm_token_39,
  u0_.deleted_at AS deleted_at_40
FROM
  "users" u0_
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.surname AS surname_5, u0_.company_name AS company_name_6, u0_.city AS city_7, u0_.postcode AS postcode_8, u0_.province AS province_9, u0_.address AS address_10, u0_.address2 AS address2_11, u0_.lat AS lat_12, u0_.lng AS lng_13, u0_.phone AS phone_14, u0_.nif AS nif_15, u0_.about AS about_16, u0_.languages AS languages_17, u0_.slogan AS slogan_18, u0_.professional_self_employed AS professional_self_employed_19, u0_.professional_representative_company AS professional_representative_company_20, u0_.years_experience AS years_experience_21, u0_.amount_from AS amount_from_22, u0_.jobs_count AS jobs_count_23, u0_.rating AS rating_24, u0_.badge AS badge_25, u0_.created_at AS created_at_26, u0_.updated_at AS updated_at_27, u0_.google_id AS google_id_28, u0_.apple_id AS apple_id_29, u0_.preferred_locale AS preferred_locale_30, u0_.is_active AS is_active_31, u0_.activation_code AS activation_code_32, u0_.can_login AS can_login_33, u0_.admin_validation AS admin_validation_34, u0_.full_access AS full_access_35, u0_.connected_account_verified AS connected_account_verified_36, u0_.has_active_subscription AS has_active_subscription_37, u0_.invoice_sequence AS invoice_sequence_38, u0_.fcm_token AS fcm_token_39, u0_.deleted_at AS deleted_at_40 FROM "users" u0_ WHERE u0_.id = 0x019C00C8049E7924B16A2707B3B87CF8;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.user_id AS user_id_3
FROM
  "chats_online_users" t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = '019c00c8-049e-7924-b16a-2707b3b87cf8';

SELECT
  t0.id AS id_1,
  t0.customer_id AS customer_id_2,
  t0.connected_account_id AS connected_account_id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.professional_id AS professional_id_6,
  t7.id AS id_8,
  t7.subscription_id AS subscription_id_9,
  t7.status AS status_10,
  t7.billing_ends_at AS billing_ends_at_11,
  t7.card_brand AS card_brand_12,
  t7.card_last_four_digits AS card_last_four_digits_13,
  t7.created_at AS created_at_14,
  t7.updated_at AS updated_at_15,
  t7.trial_ends_at AS trial_ends_at_16,
  t7.payment_link AS payment_link_17,
  t7.payment_link_id AS payment_link_id_18,
  t7.plan_id AS plan_id_19,
  t7.professional_payment_data_id AS professional_payment_data_id_20,
  t21.id AS id_22,
  t21.featured_id AS featured_id_23,
  t21.status AS status_24,
  t21.billing_ends_at AS billing_ends_at_25,
  t21.card_brand AS card_brand_26,
  t21.card_last_four_digits AS card_last_four_digits_27,
  t21.created_at AS created_at_28,
  t21.updated_at AS updated_at_29,
  t21.trial_ends_at AS trial_ends_at_30,
  t21.advertising_id AS advertising_id_31,
  t21.professional_payment_data_id AS professional_payment_data_id_32,
  t21.province_id AS province_id_33,
  t21.skill_id AS skill_id_34,
  t21.user_id AS user_id_35
FROM
  "professionals_payments_data" t0
  LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id
  LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id
WHERE
  t0.professional_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = '019c00c8-049e-7924-b16a-2707b3b87cf8';

SELECT
  DISTINCT id_0,
  MIN(sclr_103) AS dctrn_minrownum
FROM
  (
    SELECT
      c0_.id AS id_0,
      c0_.message_text AS message_text_1,
      c0_.sent_at AS sent_at_2,
      c0_.read_at AS read_at_3,
      c0_.metadata AS metadata_4,
      u1_.id AS id_5,
      u1_.email AS email_6,
      u1_.roles AS roles_7,
      u1_.password AS password_8,
      u1_.name AS name_9,
      u1_.surname AS surname_10,
      u1_.company_name AS company_name_11,
      u1_.city AS city_12,
      u1_.postcode AS postcode_13,
      u1_.province AS province_14,
      u1_.address AS address_15,
      u1_.address2 AS address2_16,
      u1_.lat AS lat_17,
      u1_.lng AS lng_18,
      u1_.phone AS phone_19,
      u1_.nif AS nif_20,
      u1_.about AS about_21,
      u1_.languages AS languages_22,
      u1_.slogan AS slogan_23,
      u1_.professional_self_employed AS professional_self_employed_24,
      u1_.professional_representative_company AS professional_representative_company_25,
      u1_.years_experience AS years_experience_26,
      u1_.amount_from AS amount_from_27,
      u1_.jobs_count AS jobs_count_28,
      u1_.rating AS rating_29,
      u1_.badge AS badge_30,
      u1_.created_at AS created_at_31,
      u1_.updated_at AS updated_at_32,
      u1_.google_id AS google_id_33,
      u1_.apple_id AS apple_id_34,
      u1_.preferred_locale AS preferred_locale_35,
      u1_.is_active AS is_active_36,
      u1_.activation_code AS activation_code_37,
      u1_.can_login AS can_login_38,
      u1_.admin_validation AS admin_validation_39,
      u1_.full_access AS full_access_40,
      u1_.connected_account_verified AS connected_account_verified_41,
      u1_.has_active_subscription AS has_active_subscription_42,
      u1_.invoice_sequence AS invoice_sequence_43,
      u1_.fcm_token AS fcm_token_44,
      u1_.deleted_at AS deleted_at_45,
      u2_.id AS id_46,
      u2_.email AS email_47,
      u2_.roles AS roles_48,
      u2_.password AS password_49,
      u2_.name AS name_50,
      u2_.surname AS surname_51,
      u2_.company_name AS company_name_52,
      u2_.city AS city_53,
      u2_.postcode AS postcode_54,
      u2_.province AS province_55,
      u2_.address AS address_56,
      u2_.address2 AS address2_57,
      u2_.lat AS lat_58,
      u2_.lng AS lng_59,
      u2_.phone AS phone_60,
      u2_.nif AS nif_61,
      u2_.about AS about_62,
      u2_.languages AS languages_63,
      u2_.slogan AS slogan_64,
      u2_.professional_self_employed AS professional_self_employed_65,
      u2_.professional_representative_company AS professional_representative_company_66,
      u2_.years_experience AS years_experience_67,
      u2_.amount_from AS amount_from_68,
      u2_.jobs_count AS jobs_count_69,
      u2_.rating AS rating_70,
      u2_.badge AS badge_71,
      u2_.created_at AS created_at_72,
      u2_.updated_at AS updated_at_73,
      u2_.google_id AS google_id_74,
      u2_.apple_id AS apple_id_75,
      u2_.preferred_locale AS preferred_locale_76,
      u2_.is_active AS is_active_77,
      u2_.activation_code AS activation_code_78,
      u2_.can_login AS can_login_79,
      u2_.admin_validation AS admin_validation_80,
      u2_.full_access AS full_access_81,
      u2_.connected_account_verified AS connected_account_verified_82,
      u2_.has_active_subscription AS has_active_subscription_83,
      u2_.invoice_sequence AS invoice_sequence_84,
      u2_.fcm_token AS fcm_token_85,
      u2_.deleted_at AS deleted_at_86,
      m3_.id AS id_87,
      m3_.filename AS filename_88,
      m3_.mime_type AS mime_type_89,
      m3_.size AS size_90,
      m3_.collection_name AS collection_name_91,
      m3_.conversions AS conversions_92,
      m3_.display_order AS display_order_93,
      m3_.created_at AS created_at_94,
      m4_.id AS id_95,
      m4_.filename AS filename_96,
      m4_.mime_type AS mime_type_97,
      m4_.size AS size_98,
      m4_.collection_name AS collection_name_99,
      m4_.conversions AS conversions_100,
      m4_.display_order AS display_order_101,
      m4_.created_at AS created_at_102,
      ROW_NUMBER() OVER(
        ORDER BY
          c0_.sent_at DESC
      ) AS sclr_103
    FROM
      "chats_messages" c0_
      INNER JOIN "users" u1_ ON c0_.sender_id = u1_.id
      INNER JOIN "users" u2_ ON c0_.recipient_id = u2_.id
      LEFT JOIN media m3_ ON u1_.id = m3_.user_id
      LEFT JOIN media m4_ ON u2_.id = m4_.user_id
    WHERE
      (
        c0_.sender_id = ?
        AND c0_.recipient_id = ?
      )
      OR (
        c0_.sender_id = ?
        AND c0_.recipient_id = ?
      )
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10