https://deinev.com/dialvi-corporate/public/catalog

Query Metrics

5 Database Queries
4 Different statements
3.06 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.42 ms
SELECT t0.id AS id_1, t0.barcode AS barcode_2, t0.description AS description_3, t0.type AS type_4, t0.status AS status_5, t0.observations AS observations_6, t0.notes AS notes_7, t0.price AS price_8, t0.key_code AS key_code_9, t0.is_deleted AS is_deleted_10, t0.colors AS colors_11, t0.width AS width_12, t0.height AS height_13, t0.has_inventory AS has_inventory_14, t0.brand_id AS brand_id_15, t0.file_id AS file_id_16, t0.product_type_id AS product_type_id_17, t0.main_image_id AS main_image_id_18 FROM product t0 WHERE t0.status = ?
Parameters:
[
  "ACTIVE"
]
2 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.status AS status_5 FROM brand t0 WHERE t0.status = ?
Parameters:
[
  "ACTIVE"
]
3 0.50 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.path AS path_5, t0.size AS size_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.37 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.created AS created_3, t0.updated AS updated_4, t0.status AS status_5 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.22 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.path AS path_5, t0.size AS size_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\Product No errors.
App\Entity\Brand No errors.
App\Entity\File No errors.
App\Entity\ProductType No errors.