GET https://xn--1--3lc1a.xn--p1ai/perspektiva/3-komnatnye-kvartiry

Query Metrics

14 Database Queries
5 Different statements
5,64 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0,79 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
2 0,75 ms
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = ? AND a0_.residential_development = ?
Parameters:
[
  2
  "perspektiva"
]
3 0,54 ms
SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = ? AND a0_.residential_development = ? ORDER BY a0_.price ASC LIMIT 15
Parameters:
[
  2
  "perspektiva"
]
4 0,42 ms
SELECT DISTINCT a0_.room_count AS room_count_0 FROM apartment a0_ WHERE a0_.residential_development = ? ORDER BY room_count_0 ASC
Parameters:
[
  "perspektiva"
]
5 0,35 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = ?
Parameters:
[
  "perspektiva"
]
6 0,37 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
7 0,37 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
8 0,31 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
9 0,32 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
10 0,28 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
11 0,29 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
12 0,31 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
13 0,27 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]
14 0,28 ms
SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = ? LIMIT 1
Parameters:
[
  "perspektiva"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ResidentialDevData 1

Entities Mapping

Class Mapping errors
App\Entity\ResidentialDevData No errors.
App\Entity\Apartment No errors.