Symfony Profiler

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  ax_property a0_
  INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id
  AND (
    a0_.property_sub_type_id = a1_.id
  )
  INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id
  AND (a1_.property_type_id = a2_.id)
  INNER JOIN ax_user a3_ ON a0_.user_id = a3_.id
  INNER JOIN ax_company a4_ ON a3_.company_id = a4_.id
WHERE
  a0_.property_listing_type_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
  AND a4_.id = ?
  AND a2_.id = ?
  AND a3_.company_id = a4_.id
  AND a0_.user_id = a3_.id

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_property a0_ INNER JOIN ax_property_sub_type a1_ ON a0_.property_sub_type_id = a1_.id AND (a0_.property_sub_type_id = a1_.id) INNER JOIN ax_property_type a2_ ON a1_.property_type_id = a2_.id AND (a1_.property_type_id = a2_.id) INNER JOIN ax_user a3_ ON a0_.user_id = a3_.id INNER JOIN ax_company a4_ ON a3_.company_id = a4_.id WHERE a0_.property_listing_type_id = 1 AND a0_.client_status = 'active' AND a0_.server_status = 'ok' AND a4_.id = 18 AND a2_.id = 1 AND a3_.company_id = a4_.id AND a0_.user_id = a3_.id;

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.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 = 18 ORDER BY t0.created_at ASC;

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 = 'remark' LIMIT 1;

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 = 18 AND a1_.company_id = a2_.id AND a0_.user_id = a1_.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 = ?

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
  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.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
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
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
  a0_.user_id = a1_.id
  AND a0_.client_status = ?
  AND a0_.server_status = ?
  AND a1_.company_id = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 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 a0_.user_id = a1_.id AND a0_.client_status = 'active' AND a0_.server_status = 'ok' AND a1_.company_id = 18 ORDER BY a0_.created_at DESC LIMIT 10;

SELECT
  count(DISTINCT 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
  a0_.user_id = a1_.id
  AND a0_.client_status = ?
  AND a0_.server_status = ?
  AND a1_.company_id = ?

SELECT count(DISTINCT 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 a0_.user_id = a1_.id AND a0_.client_status = 'active' AND a0_.server_status = 'ok' AND a1_.company_id = 18;

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_listing_type a0_

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,
  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
  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;