Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

4.52 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.74 ms	SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.roles AS roles_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.password AS password_7, u0_.created_at AS created_at_8 FROM user u0_ ORDER BY u0_.id ASC LIMIT 30 Parameters: [] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.roles AS roles_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.password AS password_7, u0_.created_at AS created_at_8 FROM user u0_ ORDER BY u0_.id ASC LIMIT 30 SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.roles AS roles_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.password AS password_7, u0_.created_at AS created_at_8 FROM user u0_ ORDER BY u0_.id ASC LIMIT 30;
2	3.78 ms	SELECT count(u0_.id) AS sclr_0 FROM user u0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(u0_.id) AS sclr_0 FROM user u0_ SELECT count(u0_.id) AS sclr_0 FROM user u0_;

#▲

Time

Info

0.74 ms

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.roles AS roles_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.password AS password_7, u0_.created_at AS created_at_8 FROM user u0_ ORDER BY u0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  u0_.id AS id_0,
  u0_.firstname AS firstname_1,
  u0_.lastname AS lastname_2,
  u0_.username AS username_3,
  u0_.roles AS roles_4,
  u0_.phone AS phone_5,
  u0_.email AS email_6,
  u0_.password AS password_7,
  u0_.created_at AS created_at_8
FROM
  user u0_
ORDER BY
  u0_.id ASC
LIMIT
  30

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.username AS username_3, u0_.roles AS roles_4, u0_.phone AS phone_5, u0_.email AS email_6, u0_.password AS password_7, u0_.created_at AS created_at_8 FROM user u0_ ORDER BY u0_.id ASC LIMIT 30;

3.78 ms

SELECT count(u0_.id) AS sclr_0 FROM user u0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_

SELECT count(u0_.id) AS sclr_0 FROM user u0_;

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\User	No errors.
App\Entity\ReservationPayment	No errors.
App\Entity\ReservationBedroom	If association App\Entity\ReservationBedroom#reservation is one-to-one, then the inversed side App\Entity\Reservation#reservationBedrooms has to be one-to-one as well. The field App\Entity\ReservationBedroom#reservationRestaurants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ReservationRestaurant#reservationBedroom does not contain the required 'inversedBy="reservationRestaurants"' attribute. The field App\Entity\ReservationBedroom#occupants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Occupant#reservationBedroom does not contain the required 'inversedBy="occupants"' attribute.
App\Entity\CustomerReservationEvent	No errors.
App\Entity\ReservationEventFomula	No errors.

Symfony Profiler

https://apihoges.novate-digital.com/users.jsonld

Configuration Settings

Theme