GET https://makaan.developpeurweb.net/

Query Metrics

17 Database Queries
5 Different statements
3.32 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 LIMIT 6
Parameters:
[]
2 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img_url AS img_url_3, t0.img_alt AS img_alt_4 FROM property_type t0
Parameters:
[]
3 0.23 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.img_url AS img_url_2, p0_.img_alt AS img_alt_3 FROM property_type p0_
Parameters:
[]
4 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img_url AS img_url_3, t0.img_alt AS img_alt_4 FROM property_type t0
Parameters:
[]
5 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  1
]
6 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  2
]
7 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  3
]
8 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  4
]
9 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  5
]
10 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  6
]
11 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.address AS address_5, t0.created_at AS created_at_6, t0.room AS room_7, t0.bed AS bed_8, t0.area AS area_9, t0.purpose AS purpose_10, t0.bathroom AS bathroom_11, t0.type_id AS type_id_12, t0.created_by_id AS created_by_id_13, t0.owned_by_id AS owned_by_id_14 FROM property t0 WHERE t0.type_id = ?
Parameters:
[
  7
]
12 0.20 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  1
]
13 0.13 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  2
]
14 0.12 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  3
]
15 0.11 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  4
]
16 0.10 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  5
]
17 0.10 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.property_id AS property_id_5 FROM image t0 WHERE t0.property_id = ?
Parameters:
[
  6
]

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\Property 19
App\Entity\PropertyType 7
App\Entity\Image 7
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Property No errors.
App\Entity\PropertyType No errors.
App\Entity\User No errors.
App\Entity\Image No errors.
Vich\UploaderBundle\Entity\File No errors.