Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

4.38 ms Query time

5 Invalid entities

4 Managed entities

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.route_permissions AS route_permissions_4, t0.menu_permissions AS menu_permissions_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_verified AS is_verified_9, t0.picture AS picture_10, t0.phone AS phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.pwd_token AS pwd_token_14, t0.password_token_expires_at AS password_token_expires_at_15, t0.is_active AS is_active_16, t0.last_login AS last_login_17, t0.company_id AS company_id_18 FROM user t0 WHERE t0.email = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.draft_data AS draft_data_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.user_id AS user_id_5 FROM booking_draft b0_ WHERE b0_.user_id = ? ORDER BY b0_.updated_at DESC
"START TRANSACTION"
INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	0.40 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.route_permissions AS route_permissions_4, t0.menu_permissions AS menu_permissions_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_verified AS is_verified_9, t0.picture AS picture_10, t0.phone AS phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.pwd_token AS pwd_token_14, t0.password_token_expires_at AS password_token_expires_at_15, t0.is_active AS is_active_16, t0.last_login AS last_login_17, t0.company_id AS company_id_18 FROM user t0 WHERE t0.email = ? LIMIT 1 Parameters: [`"admin@blacksheep-van.com"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.route_permissions AS route_permissions_4, t0.menu_permissions AS menu_permissions_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_verified AS is_verified_9, t0.picture AS picture_10, t0.phone AS phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.pwd_token AS pwd_token_14, t0.password_token_expires_at AS password_token_expires_at_15, t0.is_active AS is_active_16, t0.last_login AS last_login_17, t0.company_id AS company_id_18 FROM user t0 WHERE t0.email = ? LIMIT 1 SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.route_permissions AS route_permissions_4, t0.menu_permissions AS menu_permissions_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_verified AS is_verified_9, t0.picture AS picture_10, t0.phone AS phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.pwd_token AS pwd_token_14, t0.password_token_expires_at AS password_token_expires_at_15, t0.is_active AS is_active_16, t0.last_login AS last_login_17, t0.company_id AS company_id_18 FROM user t0 WHERE t0.email = 'admin@blacksheep-van.com' LIMIT 1;
2	0.45 ms	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.draft_data AS draft_data_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.user_id AS user_id_5 FROM booking_draft b0_ WHERE b0_.user_id = ? ORDER BY b0_.updated_at DESC Parameters: [`1`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.draft_data AS draft_data_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.user_id AS user_id_5 FROM booking_draft b0_ WHERE b0_.user_id = ? ORDER BY b0_.updated_at DESC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.draft_data AS draft_data_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.user_id AS user_id_5 FROM booking_draft b0_ WHERE b0_.user_id = 1 ORDER BY b0_.updated_at DESC;
3	0.30 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	0.46 ms	INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"User "admin@blacksheep-van.com" performed GET /api/booking_drafts (HTTP 200)" "2026-01-21 00:12:46" "admin@blacksheep-van.com" "booking_drafts" "{"iat":1768950765,"exp":1768954365,"jti":"e2db012d34a36655fb3521a5815ebb89","roles":["ROLE_SUPER_ADMIN","ROLE_USER"],"username":"admin@blacksheep-van.com"}" "[]" "200"`] View formatted query View runnable query Explain query INSERT INTO app_log ( activity, created_at, user, module, session, response, code ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES ('User \"admin@blacksheep-van.com\" performed GET /api/booking_drafts (HTTP 200)', '2026-01-21 00:12:46', 'admin@blacksheep-van.com', 'booking_drafts', '{\"iat\":1768950765,\"exp\":1768954365,\"jti\":\"e2db012d34a36655fb3521a5815ebb89\",\"roles\":[\"ROLE_SUPER_ADMIN\",\"ROLE_USER\"],\"username\":\"admin@blacksheep-van.com\"}', '[]', '200');
5	1.34 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
6	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.33 ms	INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"User "admin@blacksheep-van.com" performed GET /api/booking_drafts (HTTP 200)" "2026-01-21 00:12:46" "admin@blacksheep-van.com" "booking_drafts" "{"iat":1768950765,"exp":1768954365,"jti":"e2db012d34a36655fb3521a5815ebb89","roles":["ROLE_SUPER_ADMIN","ROLE_USER"],"username":"admin@blacksheep-van.com"}" "[]" "200"`] View formatted query View runnable query Explain query INSERT INTO app_log ( activity, created_at, user, module, session, response, code ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES ('User \"admin@blacksheep-van.com\" performed GET /api/booking_drafts (HTTP 200)', '2026-01-21 00:12:46', 'admin@blacksheep-van.com', 'booking_drafts', '{\"iat\":1768950765,\"exp\":1768954365,\"jti\":\"e2db012d34a36655fb3521a5815ebb89\",\"roles\":[\"ROLE_SUPER_ADMIN\",\"ROLE_USER\"],\"username\":\"admin@blacksheep-van.com\"}', '[]', '200');
8	0.94 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

Database Connections

Name	Service
default	doctrine.dbal.default_connection
locpro	doctrine.dbal.locpro_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\Log	2
App\Entity\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Booking	The association App\Entity\Booking#products refers to the inverse side field App\Entity\Product#products which does not exist. The field App\Entity\Booking#payment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Payment#booking does not contain the required 'inversedBy="payment"' attribute.
App\Entity\Agency	The association App\Entity\Agency#productCategories refers to the inverse side field App\Entity\ProductCategory#agency which does not exist. The field App\Entity\Agency#productAliases is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product#AliasAgencies does not contain the required 'inversedBy="productAliases"' attribute. The field App\Entity\Agency#stripeKey is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StripeKey#agency does not contain the required 'inversedBy="stripeKey"' attribute.
App\Entity\Address	No errors.
App\Entity\Memo	No errors.
App\Entity\Estimate	The mappings App\Entity\Estimate#bookingAgencyTarget and App\Entity\Agency#estimates are inconsistent with each other.
App\Entity\Caution	No errors.
App\Entity\ProductEvent	The mappings App\Entity\ProductEvent#agencyTarget and App\Entity\Agency#productEvents are inconsistent with each other.
App\Entity\PaymentDetail	No errors.
App\Entity\Sinister	The mappings App\Entity\Sinister#productEventRepair and App\Entity\ProductEvent#sinisters are inconsistent with each other.
App\Entity\VehicleDocument	No errors.
App\Entity\Dealer	No errors.
App\Entity\BookingDraft	No errors.
App\Entity\Log	No errors.
App\Entity\EntityAuditLog	No errors.

Symfony Profiler

GET https://preprodapi.efel.app/api/booking_drafts

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping