Symfony Profiler

[
  "route" => "list_real_estate_agencies"
  "route_parameters" => [
    "_route" => "list_real_estate_agencies"
    "_controller" => "App\Controller\AgencyController::listAgencies"
    "_locale" => "ro"
  ]
  "request_uri" => "https://land.n46.net/ro/agentii-imobiliare?page=1"
  "method" => "GET"
]

[
  "firewall_name" => "user_secured_area"
  "authenticators" => 2
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "1007-land"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "mariadb-10.11.15"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
      "engine" => "InnoDB"
    ]
    "dbname" => "1007-land"
  ]
]

[
  "sql" => "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 WHERE a0_.business_type = ? AND a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"
  "params" => [
    1 => "agency"
    2 => "active"
    3 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1217}
    3 => Doctrine\DBAL\ParameterType {#1217}
  ]
]

[
  "sql" => "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, a0_.language_id AS language_id_136, a0_.locality_id AS locality_id_137, a1_.district_id AS district_id_138, a4_.company_id AS company_id_139, a4_.language_id AS language_id_140, a5_.language_id AS language_id_141, a5_.company_id AS company_id_142, a6_.user_id AS user_id_143, a6_.locality_id AS locality_id_144, a6_.property_sub_type_id AS property_sub_type_id_145, a6_.property_listing_type_id AS property_listing_type_id_146, a6_.residential_complex_id AS residential_complex_id_147 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 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"
  "params" => [
    1 => "agency"
    2 => "active"
    3 => "ok"
    4 => 1
    5 => 4
    6 => 31
    7 => 3
    8 => 28
    9 => 17
    10 => 19
    11 => 27
    12 => 33
    13 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1217}
    3 => Doctrine\DBAL\ParameterType {#1217}
    4 => Doctrine\DBAL\ParameterType {#1233
      +name: "INTEGER"
    }
    5 => Doctrine\DBAL\ParameterType {#1233}
    6 => Doctrine\DBAL\ParameterType {#1233}
    7 => Doctrine\DBAL\ParameterType {#1233}
    8 => Doctrine\DBAL\ParameterType {#1233}
    9 => Doctrine\DBAL\ParameterType {#1233}
    10 => Doctrine\DBAL\ParameterType {#1233}
    11 => Doctrine\DBAL\ParameterType {#1233}
    12 => Doctrine\DBAL\ParameterType {#1233}
    13 => Doctrine\DBAL\ParameterType {#1233}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone_number AS phone_number_2, t0.status AS status_3, t0.code AS code_4, t0.ip_address AS ip_address_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM ax_user_phone t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1233
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone_number AS phone_number_2, t0.status AS status_3, t0.code AS code_4, t0.ip_address AS ip_address_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM ax_user_phone t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1233
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 WHERE a0_.business_type = ? AND a0_.client_status = ? AND a0_.server_status = ?"
  "params" => [
    1 => "agency"
    2 => "active"
    3 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1217
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1217}
    3 => Doctrine\DBAL\ParameterType {#1217}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_"
]