Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.name AS name_1
FROM
  ax_company a0_
  LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id
  LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id
  LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id
  LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id
  LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id
  LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10
OFFSET
  10

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM ax_company a0_ LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id 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
  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,
  a1_.id AS id_29,
  a1_.slug AS slug_30,
  a1_.name AS name_31,
  a2_.id AS id_32,
  a2_.slug AS slug_33,
  a2_.name AS name_34,
  a3_.id AS id_35,
  a3_.name AS name_36,
  a3_.locale AS locale_37,
  a4_.id AS id_38,
  a4_.description AS description_39,
  a4_.created_at AS created_at_40,
  a4_.updated_at AS updated_at_41,
  a5_.id AS id_42,
  a5_.email AS email_43,
  a5_.google AS google_44,
  a5_.password AS password_45,
  a5_.first_name AS first_name_46,
  a5_.last_name AS last_name_47,
  a5_.sex AS sex_48,
  a5_.contact_hours AS contact_hours_49,
  a5_.status AS status_50,
  a5_.is_suspended AS is_suspended_51,
  a5_.roles AS roles_52,
  a5_.balance AS balance_53,
  a5_.has_picture AS has_picture_54,
  a5_.is_public_name AS is_public_name_55,
  a5_.is_subscribed AS is_subscribed_56,
  ST_AsText(a5_.location) AS location_57,
  a5_.created_at AS created_at_58,
  a5_.updated_at AS updated_at_59,
  a6_.id AS id_60,
  a6_.cadastral_id AS cadastral_id_61,
  a6_.cadastral_type AS cadastral_type_62,
  a6_.address AS address_63,
  a6_.use_for AS use_for_64,
  a6_.land_area AS land_area_65,
  a6_.area AS area_66,
  a6_.ownership AS ownership_67,
  ST_AsText(a6_.multipolygon_moldref) AS multipolygon_moldref_68,
  ST_AsText(a6_.multipolygon) AS multipolygon_69,
  ST_AsText(a6_.centroid) AS centroid_70,
  a6_.geohash AS geohash_71,
  a6_.country AS country_72,
  a6_.administrative_area_level_one AS administrative_area_level_one_73,
  a6_.administrative_area_level_one_slug AS administrative_area_level_one_slug_74,
  a6_.administrative_area_level_two AS administrative_area_level_two_75,
  a6_.locality_long_name AS locality_long_name_76,
  a6_.locality_long_name_slug AS locality_long_name_slug_77,
  a6_.sublocality AS sublocality_78,
  a6_.route AS route_79,
  a6_.street_number AS street_number_80,
  a6_.formatted_address AS formatted_address_81,
  a6_.lat AS lat_82,
  a6_.lng AS lng_83,
  a6_.place_id AS place_id_84,
  a6_.price AS price_85,
  a6_.price_per_square_meter AS price_per_square_meter_86,
  a6_.monthly_expenses AS monthly_expenses_87,
  a6_.orientation AS orientation_88,
  a6_.levels AS levels_89,
  a6_.bedrooms AS bedrooms_90,
  a6_.bathrooms AS bathrooms_91,
  a6_.wc AS wc_92,
  a6_.kitchens AS kitchens_93,
  a6_.livingrooms AS livingrooms_94,
  a6_.balconies AS balconies_95,
  a6_.heating_type AS heating_type_96,
  a6_.heating_medium AS heating_medium_97,
  a6_.ac AS ac_98,
  a6_.energy_class AS energy_class_99,
  a6_.new_development AS new_development_100,
  a6_.renovated AS renovated_101,
  a6_.requires_renovation AS requires_renovation_102,
  a6_.unfinished AS unfinished_103,
  a6_.under_construction AS under_construction_104,
  a6_.air_conditioning AS air_conditioning_105,
  a6_.heating_under_floor AS heating_under_floor_106,
  a6_.fireplace AS fireplace_107,
  a6_.alarm AS alarm_108,
  a6_.secure_door AS secure_door_109,
  a6_.storage_space AS storage_space_110,
  a6_.garden AS garden_111,
  a6_.garage AS garage_112,
  a6_.parking_space AS parking_space_113,
  a6_.solar_water_heater AS solar_water_heater_114,
  a6_.swimming_pool AS swimming_pool_115,
  a6_.floor AS floor_116,
  a6_.is_top_floor AS is_top_floor_117,
  a6_.elevator AS elevator_118,
  a6_.penthouse AS penthouse_119,
  a6_.zone AS zone_120,
  a6_.construction_year AS construction_year_121,
  a6_.furnished AS furnished_122,
  a6_.pets_allowed AS pets_allowed_123,
  a6_.land_classification AS land_classification_124,
  a6_.is_corner AS is_corner_125,
  a6_.youtube_video_id AS youtube_video_id_126,
  a6_.instagram_reel_id AS instagram_reel_id_127,
  a6_.client_status AS client_status_128,
  a6_.server_status AS server_status_129,
  a6_.views AS views_130,
  a6_.is_promoted AS is_promoted_131,
  a6_.available_date AS available_date_132,
  a6_.expiration_date AS expiration_date_133,
  a6_.created_at AS created_at_134,
  a6_.updated_at AS updated_at_135,
  a7_.id AS id_136,
  a7_.cadastral_id AS cadastral_id_137,
  ST_AsText(a7_.multipolygon_moldref) AS multipolygon_moldref_138,
  ST_AsText(a7_.multipolygon) AS multipolygon_139,
  ST_AsText(a7_.centroid) AS centroid_140,
  a7_.land_area AS land_area_141,
  a7_.name AS name_142,
  a7_.rcslug AS rcslug_143,
  a7_.address AS address_144,
  a7_.instagram_reel_id AS instagram_reel_id_145,
  a7_.price_per_square_meter AS price_per_square_meter_146,
  a7_.completion_date AS completion_date_147,
  a7_.is_sold_out AS is_sold_out_148,
  a7_.client_status AS client_status_149,
  a7_.server_status AS server_status_150,
  a7_.views AS views_151,
  a7_.created_at AS created_at_152,
  a7_.updated_at AS updated_at_153,
  a0_.language_id AS language_id_154,
  a0_.locality_id AS locality_id_155,
  a1_.district_id AS district_id_156,
  a4_.company_id AS company_id_157,
  a4_.language_id AS language_id_158,
  a5_.language_id AS language_id_159,
  a5_.company_id AS company_id_160,
  a6_.user_id AS user_id_161,
  a6_.locality_id AS locality_id_162,
  a6_.property_sub_type_id AS property_sub_type_id_163,
  a6_.property_listing_type_id AS property_listing_type_id_164,
  a6_.residential_complex_id AS residential_complex_id_165,
  a7_.company_id AS company_id_166,
  a7_.locality_id AS locality_id_167
FROM
  ax_company a0_
  LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id
  LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id
  LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id
  LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id
  LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id
  LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.name ASC,
  a4_.created_at ASC,
  a5_.last_name ASC,
  a6_.id ASC,
  a7_.name 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, a1_.id AS id_29, a1_.slug AS slug_30, a1_.name AS name_31, a2_.id AS id_32, a2_.slug AS slug_33, a2_.name AS name_34, a3_.id AS id_35, a3_.name AS name_36, a3_.locale AS locale_37, a4_.id AS id_38, a4_.description AS description_39, a4_.created_at AS created_at_40, a4_.updated_at AS updated_at_41, a5_.id AS id_42, a5_.email AS email_43, a5_.google AS google_44, a5_.password AS password_45, a5_.first_name AS first_name_46, a5_.last_name AS last_name_47, a5_.sex AS sex_48, a5_.contact_hours AS contact_hours_49, a5_.status AS status_50, a5_.is_suspended AS is_suspended_51, a5_.roles AS roles_52, a5_.balance AS balance_53, a5_.has_picture AS has_picture_54, a5_.is_public_name AS is_public_name_55, a5_.is_subscribed AS is_subscribed_56, ST_AsText(a5_.location) AS location_57, a5_.created_at AS created_at_58, a5_.updated_at AS updated_at_59, a6_.id AS id_60, a6_.cadastral_id AS cadastral_id_61, a6_.cadastral_type AS cadastral_type_62, a6_.address AS address_63, a6_.use_for AS use_for_64, a6_.land_area AS land_area_65, a6_.area AS area_66, a6_.ownership AS ownership_67, ST_AsText(a6_.multipolygon_moldref) AS multipolygon_moldref_68, ST_AsText(a6_.multipolygon) AS multipolygon_69, ST_AsText(a6_.centroid) AS centroid_70, a6_.geohash AS geohash_71, a6_.country AS country_72, a6_.administrative_area_level_one AS administrative_area_level_one_73, a6_.administrative_area_level_one_slug AS administrative_area_level_one_slug_74, a6_.administrative_area_level_two AS administrative_area_level_two_75, a6_.locality_long_name AS locality_long_name_76, a6_.locality_long_name_slug AS locality_long_name_slug_77, a6_.sublocality AS sublocality_78, a6_.route AS route_79, a6_.street_number AS street_number_80, a6_.formatted_address AS formatted_address_81, a6_.lat AS lat_82, a6_.lng AS lng_83, a6_.place_id AS place_id_84, a6_.price AS price_85, a6_.price_per_square_meter AS price_per_square_meter_86, a6_.monthly_expenses AS monthly_expenses_87, a6_.orientation AS orientation_88, a6_.levels AS levels_89, a6_.bedrooms AS bedrooms_90, a6_.bathrooms AS bathrooms_91, a6_.wc AS wc_92, a6_.kitchens AS kitchens_93, a6_.livingrooms AS livingrooms_94, a6_.balconies AS balconies_95, a6_.heating_type AS heating_type_96, a6_.heating_medium AS heating_medium_97, a6_.ac AS ac_98, a6_.energy_class AS energy_class_99, a6_.new_development AS new_development_100, a6_.renovated AS renovated_101, a6_.requires_renovation AS requires_renovation_102, a6_.unfinished AS unfinished_103, a6_.under_construction AS under_construction_104, a6_.air_conditioning AS air_conditioning_105, a6_.heating_under_floor AS heating_under_floor_106, a6_.fireplace AS fireplace_107, a6_.alarm AS alarm_108, a6_.secure_door AS secure_door_109, a6_.storage_space AS storage_space_110, a6_.garden AS garden_111, a6_.garage AS garage_112, a6_.parking_space AS parking_space_113, a6_.solar_water_heater AS solar_water_heater_114, a6_.swimming_pool AS swimming_pool_115, a6_.floor AS floor_116, a6_.is_top_floor AS is_top_floor_117, a6_.elevator AS elevator_118, a6_.penthouse AS penthouse_119, a6_.zone AS zone_120, a6_.construction_year AS construction_year_121, a6_.furnished AS furnished_122, a6_.pets_allowed AS pets_allowed_123, a6_.land_classification AS land_classification_124, a6_.is_corner AS is_corner_125, a6_.youtube_video_id AS youtube_video_id_126, a6_.instagram_reel_id AS instagram_reel_id_127, a6_.client_status AS client_status_128, a6_.server_status AS server_status_129, a6_.views AS views_130, a6_.is_promoted AS is_promoted_131, a6_.available_date AS available_date_132, a6_.expiration_date AS expiration_date_133, a6_.created_at AS created_at_134, a6_.updated_at AS updated_at_135, a7_.id AS id_136, a7_.cadastral_id AS cadastral_id_137, ST_AsText(a7_.multipolygon_moldref) AS multipolygon_moldref_138, ST_AsText(a7_.multipolygon) AS multipolygon_139, ST_AsText(a7_.centroid) AS centroid_140, a7_.land_area AS land_area_141, a7_.name AS name_142, a7_.rcslug AS rcslug_143, a7_.address AS address_144, a7_.instagram_reel_id AS instagram_reel_id_145, a7_.price_per_square_meter AS price_per_square_meter_146, a7_.completion_date AS completion_date_147, a7_.is_sold_out AS is_sold_out_148, a7_.client_status AS client_status_149, a7_.server_status AS server_status_150, a7_.views AS views_151, a7_.created_at AS created_at_152, a7_.updated_at AS updated_at_153, a0_.language_id AS language_id_154, a0_.locality_id AS locality_id_155, a1_.district_id AS district_id_156, a4_.company_id AS company_id_157, a4_.language_id AS language_id_158, a5_.language_id AS language_id_159, a5_.company_id AS company_id_160, a6_.user_id AS user_id_161, a6_.locality_id AS locality_id_162, a6_.property_sub_type_id AS property_sub_type_id_163, a6_.property_listing_type_id AS property_listing_type_id_164, a6_.residential_complex_id AS residential_complex_id_165, a7_.company_id AS company_id_166, a7_.locality_id AS locality_id_167 FROM ax_company a0_ LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id WHERE a0_.business_type = 'developer' AND a0_.client_status = 'active' AND a0_.server_status = 'ok' AND a0_.id IN (21, 14, 10, 15, 30, 12, 26, 6) ORDER BY a0_.name ASC, a4_.created_at ASC, a5_.last_name ASC, a6_.id ASC, a7_.name ASC;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  ax_company a0_
  LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id
  LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id
  LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id
  LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id
  LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id
  LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_company a0_ LEFT JOIN ax_locality a1_ ON a0_.locality_id = a1_.id LEFT JOIN ax_district a2_ ON a1_.district_id = a2_.id LEFT JOIN ax_language a3_ ON a0_.language_id = a3_.id LEFT JOIN ax_company_description a4_ ON a0_.id = a4_.company_id LEFT JOIN ax_user a5_ ON a0_.id = a5_.company_id LEFT JOIN ax_property a6_ ON a5_.id = a6_.user_id LEFT JOIN ax_residential_complex a7_ ON a0_.id = a7_.company_id 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_;