Query Metrics
2
Database Queries
2
Different statements
27.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.79 ms (95.90%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.salt AS salt_3, u0_.email AS email_4, u0_.name AS name_5, u0_.roles AS roles_6, u0_.verification_code AS verification_code_7, u0_.is_verified AS is_verified_8, u0_.is_active AS is_active_9 FROM users u0_ WHERE u0_.username = ? OR u0_.email = ?
Parameters:
[ "test@testuser.com" "test@testuser.com" ] |
|
1.15 ms (4.10%) |
1 |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14, p0_.idCategory AS idCategory_15, p0_.idSize AS idSize_16, p0_.unit_of_measurement_id AS unit_of_measurement_id_17 FROM product p0_ WHERE p0_.active = ? AND p0_.idCategory = ? AND p0_.publicSale = ? ORDER BY p0_.name ASC
Parameters:
[ 1 13 1 ] |
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\Authentication\Entity\User | No errors. |
| App\Product\Entity\Product | No errors. |
| App\Product\Entity\ProductCategory | No errors. |
| App\Product\Entity\ProductSize | No errors. |
| App\Product\Entity\UnitOfMeasurement | No errors. |