Query Metrics
4
Database Queries
4
Different statements
1.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.47 ms (29.10%) |
1 |
SELECT u0_.id AS id_0, u0_.type AS type_1, u0_.roles AS roles_2 FROM user_type u0_ ORDER BY u0_.type ASC
Parameters:
[] |
|
0.47 ms (28.77%) |
1 |
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.firebase_id AS firebase_id_2, p0_.name AS name_3, p0_.cuit AS cuit_4, p0_.picture AS picture_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.business_name AS business_name_8, p0_.to_update AS to_update_9, p0_.created AS created_10, p0_.updated AS updated_11, p0_.deleted AS deleted_12, p0_.demo AS demo_13, p0_.renspa AS renspa_14, p0_.cuig AS cuig_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.deleted_at AS deleted_at_18, p0_.surname AS surname_19, p0_.user_id AS user_id_20, p0_.address_id AS address_id_21, p0_.organization_id AS organization_id_22 FROM producer p0_ LEFT JOIN organization o1_ ON p0_.organization_id = o1_.id WHERE p0_.deleted = 0 ORDER BY p0_.name ASC
Parameters:
[] |
|
0.34 ms (21.25%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.created AS created_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.deleted_at AS deleted_at_5, a0_.image AS image_6 FROM animal_specie a0_ ORDER BY a0_.name ASC
Parameters:
[] |
|
0.34 ms (20.88%) |
1 |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.type AS type_2, o0_.description AS description_3, o0_.logo AS logo_4, o0_.created AS created_5, o0_.cuit AS cuit_6, o0_.email AS email_7, o0_.phone AS phone_8, o0_.business_name AS business_name_9, o0_.list_type AS list_type_10, o0_.activity AS activity_11, o0_.created_at AS created_at_12, o0_.updated_at AS updated_at_13, o0_.deleted_at AS deleted_at_14, o0_.is_producer AS is_producer_15, o0_.user_type_id AS user_type_id_16, o0_.address_id AS address_id_17 FROM organization o0_
Parameters:
[] |
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\AnimalCategory | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\EventData | No errors. |
| App\Entity\Animal | No errors. |
| App\Entity\TreatmentType | No errors. |
| App\Entity\EventInputOption | No errors. |
| App\Entity\Vaccine | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Treatment | No errors. |
| App\Entity\EventCategory | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\UserType | No errors. |
| App\Entity\AnimalSpecie | No errors. |
| App\Entity\Producer | No errors. |
| App\Entity\Farm | No errors. |
| App\Entity\Event | No errors. |