GET https://testcode.website/

Query Metrics

3 Database Queries
3 Different statements
19.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.19 ms
(58.88%)
1
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.description AS description_2, p0_.area AS area_3, p0_.price AS price_4, p0_.image_primary AS image_primary_5, p0_.longitude AS longitude_6, p0_.latitude AS latitude_7, p0_.city AS city_8, i1_.image AS image_9, r2_.name AS name_10, t3_.name AS name_11 FROM property p0_ LEFT JOIN image_property i1_ ON p0_.id = i1_.property_id LEFT JOIN regions r2_ ON p0_.regions_id = r2_.id LEFT JOIN transactions t3_ ON p0_.transactions_id = t3_.id WHERE p0_.published = ? AND p0_.special_offer = ?
Parameters:
[
  1
  1
]
5.15 ms
(27.08%)
1
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.price AS price_2, p0_.area AS area_3, p0_.city AS city_4, p0_.image_primary AS image_primary_5, t1_.name AS name_6, r2_.name AS name_7, t3_.name AS name_8, p4_.name AS name_9, s5_.name AS name_10, s5_.typecolor AS typecolor_11, s5_.typebackground AS typebackground_12 FROM property p0_ LEFT JOIN TYPE t1_ ON p0_.type_id = t1_.id LEFT JOIN room r2_ ON p0_.room_id = r2_.id LEFT JOIN transactions t3_ ON p0_.transactions_id = t3_.id LEFT JOIN price_type p4_ ON p0_.price_type_id = p4_.id LEFT JOIN STATUS s5_ ON p0_.status_id = s5_.id WHERE p0_.published = ? ORDER BY p0_.id DESC LIMIT 4
Parameters:
[
  1
]
2.67 ms
(14.04%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1 FROM news n0_ WHERE n0_.published = ? ORDER BY n0_.id DESC LIMIT 5
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Property No errors.
App\Entity\ImageProperty No errors.
App\Entity\Regions No errors.
App\Entity\Transactions No errors.
App\Entity\Type No errors.
App\Entity\Room No errors.
App\Entity\PriceType No errors.
App\Entity\Status No errors.
App\Entity\News No errors.