GET https://57.128.16.253/?XDEBUG_SESSION_START=phpstorm

Query Metrics

6 Database Queries
2 Different statements
3.59 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.25 ms
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.latitude AS latitude_2, l0_.longitude AS longitude_3, l0_.city AS city_4, l0_.accommodation_category AS accommodation_category_5, l0_.night_price AS night_price_6, l0_.max_guests AS max_guests_7, l1_.path AS path_8 FROM listing l0_ LEFT JOIN listing_photo l1_ ON l0_.id = l1_.listing_id WHERE l0_.max_guests >= ? AND l0_.status = ?
Parameters:
[
  0
  "on"
]
2 0.37 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "fr"
  "house"
]
3 1.17 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "fr"
  "house"
]
4 0.26 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "fr"
  "house"
]
5 0.25 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "fr"
  "house"
]
6 0.30 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "fr"
  "house"
]

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\Listing
  • The field App\Entity\Listing#photos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ListingPhoto#listing does not contain the required 'inversedBy="photos"' attribute.
App\Entity\ListingPhoto No errors.
App\Entity\TextFront No errors.