Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  ax_district t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM ax_district t0 WHERE t0.slug = 'mun-chisinau' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.business_type AS business_type_4,
  t0.nin AS nin_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.domain AS domain_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.facebook_page AS facebook_page_11,
  t0.instagram_username AS instagram_username_12,
  t0.xcorp_username AS xcorp_username_13,
  t0.youtube_handle AS youtube_handle_14,
  t0.cslug AS cslug_15,
  t0.street AS street_16,
  t0.postal_code AS postal_code_17,
  t0.phone_number AS phone_number_18,
  t0.username AS username_19,
  t0.password AS password_20,
  t0.client_status AS client_status_21,
  t0.server_status AS server_status_22,
  t0.phone_status AS phone_status_23,
  t0.lat AS lat_24,
  t0.lng AS lng_25,
  t0.roles AS roles_26,
  t0.views AS views_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.language_id AS language_id_30,
  t0.locality_id AS locality_id_31
FROM
  ax_company t0
WHERE
  t0.cslug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.cslug = 'horus' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3
FROM
  ax_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.district_id AS district_id_4
FROM
  ax_locality t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.district_id AS district_id_4 FROM ax_locality t0 WHERE t0.id = '0100';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  ax_property a0_
  INNER JOIN ax_user a1_ ON a0_.user_id = a1_.id
  INNER JOIN ax_company a2_ ON a1_.company_id = a2_.id
WHERE
  a2_.id = ?
  AND a1_.company_id = a2_.id
  AND a0_.user_id = a1_.id

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_property a0_ INNER JOIN ax_user a1_ ON a0_.user_id = a1_.id INNER JOIN ax_company a2_ ON a1_.company_id = a2_.id WHERE a2_.id = 14 AND a1_.company_id = a2_.id AND a0_.user_id = a1_.id;

SELECT
  a0_.id AS id_0,
  a0_.cadastral_id AS cadastral_id_1,
  ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2,
  ST_AsText(a0_.multipolygon) AS multipolygon_3,
  ST_AsText(a0_.centroid) AS centroid_4,
  a0_.land_area AS land_area_5,
  a0_.name AS name_6,
  a0_.rcslug AS rcslug_7,
  a0_.address AS address_8,
  a0_.instagram_reel_id AS instagram_reel_id_9,
  a0_.price_per_square_meter AS price_per_square_meter_10,
  a0_.completion_date AS completion_date_11,
  a0_.is_sold_out AS is_sold_out_12,
  a0_.client_status AS client_status_13,
  a0_.server_status AS server_status_14,
  a0_.views AS views_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.company_id AS company_id_18,
  a0_.locality_id AS locality_id_19
FROM
  ax_residential_complex a0_
WHERE
  a0_.company_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.company_id = 14 AND a0_.client_status = 'active' AND a0_.server_status = 'ok' ORDER BY a0_.name ASC LIMIT 10;

SELECT
  count(*) AS sclr_0
FROM
  ax_residential_complex a0_
WHERE
  a0_.company_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?

SELECT count(*) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.company_id = 14 AND a0_.client_status = 'active' AND a0_.server_status = 'ok';

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  ax_property_listing_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM ax_property_listing_type t0 WHERE t0.name = 'for-sale' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1
FROM
  ax_property_listing_type a0_

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM ax_property_listing_type a0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  ax_property_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM ax_property_type t0 WHERE t0.id = 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1
FROM
  ax_property_type a0_
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM ax_property_type a0_ ORDER BY a0_.id ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.property_type_id AS property_type_id_2
FROM
  ax_property_sub_type a0_
WHERE
  a0_.property_type_id = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.property_type_id AS property_type_id_2 FROM ax_property_sub_type a0_ WHERE a0_.property_type_id = 0 ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.google AS google_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.sex AS sex_7,
  t0.contact_hours AS contact_hours_8,
  t0.status AS status_9,
  t0.is_suspended AS is_suspended_10,
  t0.roles AS roles_11,
  t0.balance AS balance_12,
  t0.has_picture AS has_picture_13,
  t0.is_public_name AS is_public_name_14,
  t0.is_subscribed AS is_subscribed_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.language_id AS language_id_18,
  t0.company_id AS company_id_19,
  t20.id AS id_21,
  t20.phone_number AS phone_number_22,
  t20.status AS status_23,
  t20.code AS code_24,
  t20.ip_address AS ip_address_25,
  t20.created_at AS created_at_26,
  t20.updated_at AS updated_at_27,
  t20.user_id AS user_id_28
FROM
  ax_user t0
  LEFT JOIN ax_user_phone t20 ON t20.user_id = t0.id
WHERE
  t0.company_id = ?
ORDER BY
  t0.last_name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.sex AS sex_7, t0.contact_hours AS contact_hours_8, t0.status AS status_9, t0.is_suspended AS is_suspended_10, t0.roles AS roles_11, t0.balance AS balance_12, t0.has_picture AS has_picture_13, t0.is_public_name AS is_public_name_14, t0.is_subscribed AS is_subscribed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t0.company_id AS company_id_19, t20.id AS id_21, t20.phone_number AS phone_number_22, t20.status AS status_23, t20.code AS code_24, t20.ip_address AS ip_address_25, t20.created_at AS created_at_26, t20.updated_at AS updated_at_27, t20.user_id AS user_id_28 FROM ax_user t0 LEFT JOIN ax_user_phone t20 ON t20.user_id = t0.id WHERE t0.company_id = 14 ORDER BY t0.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.company_id AS company_id_5,
  t0.language_id AS language_id_6
FROM
  ax_company_description t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.company_id AS company_id_5, t0.language_id AS language_id_6 FROM ax_company_description t0 WHERE t0.company_id = 14 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3
FROM
  ax_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = 1;