Symfony Profiler

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.details AS details_2,
  t0_.address AS address_3,
  t0_.prices AS prices_4,
  t0_.surface AS surface_5,
  t0_.roomcount AS roomcount_6,
  t0_.operation_type AS operation_type_7,
  t0_.latitude AS latitude_8,
  t0_.longitude AS longitude_9,
  p1_.name AS name_10,
  m2_.name AS name_11,
  p3_.name AS name_12,
  p3_.path AS path_13
FROM
  the_property t0_
  LEFT JOIN property_type p1_ ON t0_.property_type_id = p1_.id
  LEFT JOIN property_image p3_ ON t0_.id = p3_.theproperty_id
  LEFT JOIN municipality m2_ ON t0_.municipality_id = m2_.id
WHERE
  t0_.status = ?
  AND t0_.operation_type = ?
  AND (
    t0_.address LIKE ?
    OR t0_.title LIKE ?
    OR t0_.details LIKE ?
    OR m2_.name LIKE ?
    OR p1_.name LIKE ?
  )
ORDER BY
  t0_.id DESC
LIMIT
  9 OFFSET 9

SELECT DISTINCT t0_.id AS id_0, t0_.title AS title_1, t0_.details AS details_2, t0_.address AS address_3, t0_.prices AS prices_4, t0_.surface AS surface_5, t0_.roomcount AS roomcount_6, t0_.operation_type AS operation_type_7, t0_.latitude AS latitude_8, t0_.longitude AS longitude_9, p1_.name AS name_10, m2_.name AS name_11, p3_.name AS name_12, p3_.path AS path_13 FROM the_property t0_ LEFT JOIN property_type p1_ ON t0_.property_type_id = p1_.id LEFT JOIN property_image p3_ ON t0_.id = p3_.theproperty_id LEFT JOIN municipality m2_ ON t0_.municipality_id = m2_.id WHERE t0_.status = 'valid' AND t0_.operation_type = 'sale' AND (t0_.address LIKE '%Rue%' OR t0_.title LIKE '%Rue%' OR t0_.details LIKE '%Rue%' OR m2_.name LIKE '%Rue%' OR p1_.name LIKE '%Rue%') ORDER BY t0_.id DESC LIMIT 9 OFFSET 9;

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  the_property t0_
  LEFT JOIN property_type p1_ ON t0_.property_type_id = p1_.id
  LEFT JOIN property_image p2_ ON t0_.id = p2_.theproperty_id
  LEFT JOIN municipality m3_ ON t0_.municipality_id = m3_.id
WHERE
  t0_.status = ?
  AND t0_.operation_type = ?
  AND (
    t0_.address LIKE ?
    OR t0_.title LIKE ?
    OR t0_.details LIKE ?
    OR m3_.name LIKE ?
    OR p1_.name LIKE ?
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM the_property t0_ LEFT JOIN property_type p1_ ON t0_.property_type_id = p1_.id LEFT JOIN property_image p2_ ON t0_.id = p2_.theproperty_id LEFT JOIN municipality m3_ ON t0_.municipality_id = m3_.id WHERE t0_.status = 'valid' AND t0_.operation_type = 'sale' AND (t0_.address LIKE '%Rue%' OR t0_.title LIKE '%Rue%' OR t0_.details LIKE '%Rue%' OR m3_.name LIKE '%Rue%' OR p1_.name LIKE '%Rue%');

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.two_factor_code AS two_factor_code_6,
  t0.two_factor_code_expires_at AS two_factor_code_expires_at_7,
  t0.two_factor_temp_token AS two_factor_temp_token_8,
  t0.name AS name_9,
  t0.firstname AS firstname_10,
  t0.telephone AS telephone_11,
  t0.address AS address_12,
  t0.status AS status_13,
  t0.resettoken AS resettoken_14,
  t0.tradingname AS tradingname_15,
  t0.sir AS sir_16,
  t0.tva AS tva_17,
  t0.dispomon AS dispomon_18,
  t0.dispotue AS dispotue_19,
  t0.dispowed AS dispowed_20,
  t0.dispothu AS dispothu_21,
  t0.dispofri AS dispofri_22,
  t0.disposat AS disposat_23,
  t0.disposun AS disposun_24,
  t0.stripe_customer_id AS stripe_customer_id_25,
  t0.mgp_user_id AS mgp_user_id_26,
  t0.mgp_wallet_id AS mgp_wallet_id_27,
  t0.mgp_card_id AS mgp_card_id_28,
  t0.logo AS logo_29,
  t0.gender AS gender_30,
  t0.num_national_register AS num_national_register_31,
  t0.iban AS iban_32,
  t0.longitude AS longitude_33,
  t0.latitude AS latitude_34,
  t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35,
  t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36,
  t0.committee_avatar AS committee_avatar_37,
  t0.committee_surname AS committee_surname_38,
  t0.is_admin AS is_admin_39,
  t0.admin_id AS admin_id_40,
  t0.house_number AS house_number_41,
  t0.house_addition AS house_addition_42,
  t0.last_notification AS last_notification_43,
  t0.device_token AS device_token_44,
  t0.region AS region_45,
  t0.municipality AS municipality_46,
  t0.country AS country_47,
  t0.imported AS imported_48,
  t0.is_moving_company AS is_moving_company_49,
  t0.mail_id AS mail_id_50,
  t0.mail_mini AS mail_mini_51,
  t0.check_sum AS check_sum_52,
  t0.personnal_abonnement AS personnal_abonnement_53,
  t0.certification_area AS certification_area_54,
  t0.inbox_id AS inbox_id_55,
  t0.inbox_email AS inbox_email_56,
  t0.supplier_id AS supplier_id_57,
  t0.code_client AS code_client_58,
  t0.created AS created_59,
  t0.updated AS updated_60,
  t61.id AS id_62,
  t61.created AS created_63,
  t61.updated AS updated_64,
  t61.syndic_id AS syndic_id_65,
  t66.id AS id_67,
  t66.study AS study_68,
  t66.associate_name AS associate_name_69,
  t66.associate_firstname AS associate_firstname_70,
  t66.associate_email AS associate_email_71,
  t66.address AS address_72,
  t66.fax AS fax_73,
  t66.site AS site_74,
  t66.telephone AS telephone_75,
  t66.bce AS bce_76,
  t66.check_sum AS check_sum_77,
  t66.name AS name_78,
  t66.firstname AS firstname_79,
  t66.email AS email_80,
  t66.postal_code AS postal_code_81,
  t66.municipality AS municipality_82,
  t66.street AS street_83,
  t66.country AS country_84,
  t66.latitude AS latitude_85,
  t66.longitude AS longitude_86,
  t66.region AS region_87,
  t66.user_id AS user_id_88
FROM
  user t0
  LEFT JOIN co_ownership t61 ON t61.syndic_id = t0.id
  LEFT JOIN notary t66 ON t66.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.two_factor_code AS two_factor_code_6, t0.two_factor_code_expires_at AS two_factor_code_expires_at_7, t0.two_factor_temp_token AS two_factor_temp_token_8, t0.name AS name_9, t0.firstname AS firstname_10, t0.telephone AS telephone_11, t0.address AS address_12, t0.status AS status_13, t0.resettoken AS resettoken_14, t0.tradingname AS tradingname_15, t0.sir AS sir_16, t0.tva AS tva_17, t0.dispomon AS dispomon_18, t0.dispotue AS dispotue_19, t0.dispowed AS dispowed_20, t0.dispothu AS dispothu_21, t0.dispofri AS dispofri_22, t0.disposat AS disposat_23, t0.disposun AS disposun_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.mgp_user_id AS mgp_user_id_26, t0.mgp_wallet_id AS mgp_wallet_id_27, t0.mgp_card_id AS mgp_card_id_28, t0.logo AS logo_29, t0.gender AS gender_30, t0.num_national_register AS num_national_register_31, t0.iban AS iban_32, t0.longitude AS longitude_33, t0.latitude AS latitude_34, t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35, t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36, t0.committee_avatar AS committee_avatar_37, t0.committee_surname AS committee_surname_38, t0.is_admin AS is_admin_39, t0.admin_id AS admin_id_40, t0.house_number AS house_number_41, t0.house_addition AS house_addition_42, t0.last_notification AS last_notification_43, t0.device_token AS device_token_44, t0.region AS region_45, t0.municipality AS municipality_46, t0.country AS country_47, t0.imported AS imported_48, t0.is_moving_company AS is_moving_company_49, t0.mail_id AS mail_id_50, t0.mail_mini AS mail_mini_51, t0.check_sum AS check_sum_52, t0.personnal_abonnement AS personnal_abonnement_53, t0.certification_area AS certification_area_54, t0.inbox_id AS inbox_id_55, t0.inbox_email AS inbox_email_56, t0.supplier_id AS supplier_id_57, t0.code_client AS code_client_58, t0.created AS created_59, t0.updated AS updated_60, t61.id AS id_62, t61.created AS created_63, t61.updated AS updated_64, t61.syndic_id AS syndic_id_65, t66.id AS id_67, t66.study AS study_68, t66.associate_name AS associate_name_69, t66.associate_firstname AS associate_firstname_70, t66.associate_email AS associate_email_71, t66.address AS address_72, t66.fax AS fax_73, t66.site AS site_74, t66.telephone AS telephone_75, t66.bce AS bce_76, t66.check_sum AS check_sum_77, t66.name AS name_78, t66.firstname AS firstname_79, t66.email AS email_80, t66.postal_code AS postal_code_81, t66.municipality AS municipality_82, t66.street AS street_83, t66.country AS country_84, t66.latitude AS latitude_85, t66.longitude AS longitude_86, t66.region AS region_87, t66.user_id AS user_id_88 FROM user t0 LEFT JOIN co_ownership t61 ON t61.syndic_id = t0.id LEFT JOIN notary t66 ON t66.user_id = t0.id WHERE t0.email = 'hasin@yopmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.stripe_subscription_id AS stripe_subscription_id_2,
  t0.status AS status_3,
  t0.current_period_start AS current_period_start_4,
  t0.current_period_end AS current_period_end_5,
  t0.cancel_at_period_end AS cancel_at_period_end_6,
  t0.cancellation_reason AS cancellation_reason_7,
  t0.canceled_at AS canceled_at_8,
  t0.plan_id AS plan_id_9,
  t0.user_id AS user_id_10
FROM
  plan_subscription t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.status AS status_3, t0.current_period_start AS current_period_start_4, t0.current_period_end AS current_period_end_5, t0.cancel_at_period_end AS cancel_at_period_end_6, t0.cancellation_reason AS cancellation_reason_7, t0.canceled_at AS canceled_at_8, t0.plan_id AS plan_id_9, t0.user_id AS user_id_10 FROM plan_subscription t0 WHERE t0.user_id = 201;