Query Metrics

8 Database Queries
7 Different statements
3.89 ms Query time
2 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= ?) AND (a0_.display_until IS NULL OR a0_.display_until >= ?) ORDER BY a0_.id ASC LIMIT 5
Parameters:
[
  "2026-02-27 12:14:48"
  "2026-02-27 12:14:48"
]
2 0.76 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.item_code AS item_code_3, t0.opened_at AS opened_at_4, t0.legacy_code AS legacy_code_5, t0.access_key AS access_key_6, t0.brand AS brand_7, t0.model AS model_8, t0.title AS title_9, t0.picture AS picture_10, t0.description AS description_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.date AS date_15, t0.date_accuracy AS date_accuracy_16, t0.date_estimated AS date_estimated_17, t0.gallery_id AS gallery_id_18 FROM item t0 WHERE t0.item_code = ? LIMIT 1
Parameters:
[
  "PETD7"
]
3 0.85 ms
SELECT t0.id AS id_1, t0.date_listed AS date_listed_2, t0.date_sold AS date_sold_3, t0.price AS price_4, t0.warranty AS warranty_5, t0.postage AS postage_6, t0.item_id AS item_id_7, t0.customer_id AS customer_id_8 FROM listing t0 WHERE t0.item_id = ?
Parameters:
[
  22
]
4 0.25 ms
SELECT l0_.id AS id_0, l0_.date_listed AS date_listed_1, l0_.date_sold AS date_sold_2, l0_.price AS price_3, l0_.warranty AS warranty_4, l0_.postage AS postage_5, l0_.item_id AS item_id_6, l0_.customer_id AS customer_id_7 FROM listing l0_ WHERE l0_.item_id = ? AND l0_.date_sold IS NULL
Parameters:
[
  22
]
5 0.42 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.position AS position_3, t0.caption AS caption_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.privacy AS privacy_7, t0.gallery_id AS gallery_id_8 FROM image t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
  38
]
6 0.34 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.performed_by AS performed_by_4, t0.title AS title_5, t0.summary AS summary_6, t0.actions AS actions_7, t0.conclusions AS conclusions_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.privacy AS privacy_12, t0.item_id AS item_id_13, t0.gallery_id AS gallery_id_14 FROM intervention t0 WHERE t0.item_id = ? ORDER BY t0.date ASC
Parameters:
[
  22
]
7 0.32 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.direction AS direction_3, t0.currency AS currency_4, t0.rate AS rate_5, t0.amount AS amount_6, t0.reference AS reference_7, t0.item_id AS item_id_8, t0.intervention_id AS intervention_id_9 FROM cashflow t0 WHERE t0.item_id = ? AND t0.intervention_id IS NULL ORDER BY t0.date ASC
Parameters:
[
  22
]
8 0.24 ms
SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= ?) AND (a0_.display_until IS NULL OR a0_.display_until >= ?) ORDER BY a0_.id ASC LIMIT 5
Parameters:
[
  "2026-02-27 12:14:48"
  "2026-02-27 12:14:48"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Gallery\Image 9
App\Entity\Gallery\Gallery 2
App\Entity\Item\Item 1
App\Entity\Listing\Listing 1
App\Entity\Intervention\Intervention 1
App\Entity\Money\CashFlow 1

Entities Mapping

Class Mapping errors
App\Entity\System\Alert No errors.
App\Entity\Item\Item No errors.
App\Entity\Gallery\Gallery
  • The field App\Entity\Gallery\Gallery#intervention is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervention\Intervention#gallery does not contain the required 'inversedBy: "intervention"' attribute.
App\Entity\Intervention\Intervention No errors.
App\Entity\Listing\Listing
  • The association App\Entity\Listing\Listing#customer refers to the inverse side field App\Entity\User\User#purchases which does not exist.
App\Entity\Money\CashFlow No errors.
App\Entity\User\User No errors.
App\Entity\Gallery\Image No errors.