Symfony Profiler

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 = 21 ORDER BY t0.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.cadastral_id AS cadastral_id_2,
  ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3,
  ST_AsText(t0.multipolygon) AS multipolygon_4,
  ST_AsText(t0.centroid) AS centroid_5,
  t0.land_area AS land_area_6,
  t0.name AS name_7,
  t0.rcslug AS rcslug_8,
  t0.address AS address_9,
  t0.instagram_reel_id AS instagram_reel_id_10,
  t0.price_per_square_meter AS price_per_square_meter_11,
  t0.completion_date AS completion_date_12,
  t0.is_sold_out AS is_sold_out_13,
  t0.client_status AS client_status_14,
  t0.server_status AS server_status_15,
  t0.views AS views_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.company_id AS company_id_19,
  t0.locality_id AS locality_id_20
FROM
  ax_residential_complex t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.company_id = 21 ORDER BY t0.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 = 21 ORDER BY t0.created_at ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.legal_name AS legal_name_2,
  a0_.business_type AS business_type_3,
  a0_.nin AS nin_4,
  a0_.first_name AS first_name_5,
  a0_.last_name AS last_name_6,
  a0_.domain AS domain_7,
  a0_.email AS email_8,
  a0_.website AS website_9,
  a0_.facebook_page AS facebook_page_10,
  a0_.instagram_username AS instagram_username_11,
  a0_.xcorp_username AS xcorp_username_12,
  a0_.youtube_handle AS youtube_handle_13,
  a0_.cslug AS cslug_14,
  a0_.street AS street_15,
  a0_.postal_code AS postal_code_16,
  a0_.phone_number AS phone_number_17,
  a0_.username AS username_18,
  a0_.password AS password_19,
  a0_.client_status AS client_status_20,
  a0_.server_status AS server_status_21,
  a0_.phone_status AS phone_status_22,
  a0_.lat AS lat_23,
  a0_.lng AS lng_24,
  a0_.roles AS roles_25,
  a0_.views AS views_26,
  a0_.created_at AS created_at_27,
  a0_.updated_at AS updated_at_28,
  a0_.language_id AS language_id_29,
  a0_.locality_id AS locality_id_30
FROM
  ax_company a0_
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10
OFFSET
  10

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.legal_name AS legal_name_2, a0_.business_type AS business_type_3, a0_.nin AS nin_4, a0_.first_name AS first_name_5, a0_.last_name AS last_name_6, a0_.domain AS domain_7, a0_.email AS email_8, a0_.website AS website_9, a0_.facebook_page AS facebook_page_10, a0_.instagram_username AS instagram_username_11, a0_.xcorp_username AS xcorp_username_12, a0_.youtube_handle AS youtube_handle_13, a0_.cslug AS cslug_14, a0_.street AS street_15, a0_.postal_code AS postal_code_16, a0_.phone_number AS phone_number_17, a0_.username AS username_18, a0_.password AS password_19, a0_.client_status AS client_status_20, a0_.server_status AS server_status_21, a0_.phone_status AS phone_status_22, a0_.lat AS lat_23, a0_.lng AS lng_24, a0_.roles AS roles_25, a0_.views AS views_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.language_id AS language_id_29, a0_.locality_id AS locality_id_30 FROM ax_company a0_ WHERE a0_.business_type = 'developer' AND a0_.client_status = 'active' AND a0_.server_status = 'ok' ORDER BY a0_.name ASC LIMIT 10 OFFSET 10;

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_company a0_
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_company a0_ WHERE a0_.business_type = 'developer' AND a0_.client_status = 'active' AND a0_.server_status = 'ok';

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

SELECT count(*) AS sclr_0 FROM ax_company a0_ WHERE a0_.business_type = 'developer' AND a0_.client_status = 'active' AND a0_.server_status = 'ok';

SELECT
  a0_.id AS id_0,
  a0_.slug AS slug_1,
  a0_.name AS name_2
FROM
  ax_district a0_

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_;

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

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM ax_district t0 WHERE t0.id = '01';