Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.82 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.82 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ INNER JOIN address a1_ ON s0_.address_id = a1_.id INNER JOIN site s2_ ON s0_.site_id = s2_.id WHERE s2_.type = ? AND s0_.name LIKE ? AND s0_.service = ? AND s2_.status <> ? AND s0_.status = ? AND (s2_.no_display_reservation = ? OR s2_.no_display_reservation IS NULL) ORDER BY s0_.name ASC Parameters: [`"residence" "%CRF%" "coiffure" "closed" 1 0`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ INNER JOIN address a1_ ON s0_.address_id = a1_.id INNER JOIN site s2_ ON s0_.site_id = s2_.id WHERE s2_.type = ? AND s0_.name LIKE ? AND s0_.service = ? AND s2_.status <> ? AND s0_.status = ? AND ( s2_.no_display_reservation = ? OR s2_.no_display_reservation IS NULL ) ORDER BY s0_.name ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ INNER JOIN address a1_ ON s0_.address_id = a1_.id INNER JOIN site s2_ ON s0_.site_id = s2_.id WHERE s2_.type = 'residence' AND s0_.name LIKE '%CRF%' AND s0_.service = 'coiffure' AND s2_.status <> 'closed' AND s0_.status = 1 AND (s2_.no_display_reservation = 0 OR s2_.no_display_reservation IS NULL) ORDER BY s0_.name ASC;

#▲

Time

Info

0.82 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ INNER JOIN address a1_ ON s0_.address_id = a1_.id INNER JOIN site s2_ ON s0_.site_id = s2_.id WHERE s2_.type = ? AND s0_.name LIKE ? AND s0_.service = ? AND s2_.status <> ? AND s0_.status = ? AND (s2_.no_display_reservation = ? OR s2_.no_display_reservation IS NULL) ORDER BY s0_.name ASC

Parameters:

[
  "residence"
  "%CRF%"
  "coiffure"
  "closed"
  1
  0
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.service AS service_2,
  s0_.status AS status_3,
  s0_.openingDays AS openingDays_4,
  s0_.date_activity_end AS date_activity_end_5,
  s0_.specific_billing AS specific_billing_6,
  s0_.date_open AS date_open_7,
  s0_.date_end AS date_end_8,
  s0_.opening_time AS opening_time_9,
  s0_.closing_time AS closing_time_10,
  s0_.address_id AS address_id_11,
  s0_.gridprice_id AS gridprice_id_12,
  s0_.site_id AS site_id_13
FROM
  salon s0_
  INNER JOIN address a1_ ON s0_.address_id = a1_.id
  INNER JOIN site s2_ ON s0_.site_id = s2_.id
WHERE
  s2_.type = ?
  AND s0_.name LIKE ?
  AND s0_.service = ?
  AND s2_.status <> ?
  AND s0_.status = ?
  AND (
    s2_.no_display_reservation = ?
    OR s2_.no_display_reservation IS NULL
  )
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.service AS service_2, s0_.status AS status_3, s0_.openingDays AS openingDays_4, s0_.date_activity_end AS date_activity_end_5, s0_.specific_billing AS specific_billing_6, s0_.date_open AS date_open_7, s0_.date_end AS date_end_8, s0_.opening_time AS opening_time_9, s0_.closing_time AS closing_time_10, s0_.address_id AS address_id_11, s0_.gridprice_id AS gridprice_id_12, s0_.site_id AS site_id_13 FROM salon s0_ INNER JOIN address a1_ ON s0_.address_id = a1_.id INNER JOIN site s2_ ON s0_.site_id = s2_.id WHERE s2_.type = 'residence' AND s0_.name LIKE '%CRF%' AND s0_.service = 'coiffure' AND s2_.status <> 'closed' AND s0_.status = 1 AND (s2_.no_display_reservation = 0 OR s2_.no_display_reservation IS NULL) ORDER BY s0_.name ASC;

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\SessionSalon	The association App\Entity\SessionSalon#salon refers to the inverse side field App\Entity\Salon#session which does not exist. The association App\Entity\SessionSalon#intervenant refers to the inverse side field App\Entity\Intervenant#session which does not exist.
App\Entity\Salon	The field App\Entity\Salon#intervenantSalons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\IntervenantSalon#salon does not contain the required 'inversedBy="intervenantSalons"' attribute.
App\Entity\Address	No errors.
App\Entity\Site	The field App\Entity\Site#logistique is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Site\Logistique#site does not contain the required 'mappedBy="logistique"' attribute. The field App\Entity\Site#salons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Salon#site does not contain the required 'inversedBy="salons"' attribute. The field App\Entity\Site#othersContacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#site does not contain the required 'inversedBy="othersContacts"' attribute.
App\Entity\GridPrice	No errors.

Symfony Profiler

https://emmaconnect.fr/reservation/search/for/get-salons?salon=Crf&service=coiffure&type=residence

Configuration Settings

Theme