Query Metrics

8 Database Queries
8 Different statements
6.11 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.id AS id_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.password AS password_8, t0.status AS status_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.type, t1.identity_code AS identity_code_13, t1.address AS address_14, t1.phone_number AS phone_number_15, t1.city AS city_16, t1.zip_code AS zip_code_17, t3.phone_number AS phone_number_18 FROM account t0 LEFT JOIN practician t1 ON t0.id = t1.id LEFT JOIN administrator t2 ON t0.id = t2.id LEFT JOIN supervisor t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  1
]
2 0.71 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.type AS type_3, t0.status AS status_4, t0.tint AS tint_5, t0.notify AS notify_6, t0.steps AS steps_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.patient_id AS patient_id_10, t0.owner_id AS owner_id_11, t0.organization_id AS organization_id_12, t0.traceability_id AS traceability_id_13, t0.laboratory_id AS laboratory_id_14 FROM `order` t0 WHERE t0.number = ? LIMIT 1
Parameters:
[
  "V-20260705"
]
3 0.70 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM traceability t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 1.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.number AS number_3, t0.`order` AS order_4, t0.config_id AS config_id_5, t0.item_id AS item_id_6, t0.detail_id AS detail_id_7, t0.traceability_id AS traceability_id_8 FROM config_traceability t0 WHERE t0.traceability_id = ?
Parameters:
[
  3
]
5 0.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.count AS count_3, t0.detail AS detail_4, t0.number AS number_5, t0.`order` AS order_6, t0.config_traceability_id AS config_traceability_id_7 FROM act_traceability t0 WHERE t0.config_traceability_id = ?
Parameters:
[
  8
]
6 1.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.manufacturer AS manufacturer_4, t0.standard AS standard_5, t0.number AS number_6, t0.origin AS origin_7, t0.`order` AS order_8, t0.config_traceability_id AS config_traceability_id_9 FROM product_traceability t0 WHERE t0.config_traceability_id = ?
Parameters:
[
  8
]
7 0.23 ms
SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = ?
Parameters:
[
  34
]
8 0.34 ms
SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.email AS email_5, t1.password AS password_6, t1.status AS status_7, t1.roles AS roles_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.identity_code AS identity_code_11, t0.address AS address_12, t0.phone_number AS phone_number_13, t0.city AS city_14, t0.zip_code AS zip_code_15, t1.type FROM practician t0 INNER JOIN account t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  4
]

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\Account\Infrastructure\Doctrine\Entity\Account 2
App\Conformity\Infrastructure\Doctrine\Entity\ProductTraceability 2
App\Order\Infrastructure\Doctrine\Entity\Order 1
App\Order\Infrastructure\Doctrine\Entity\Patient 1
App\Conformity\Infrastructure\Doctrine\Entity\Traceability 1
App\Conformity\Infrastructure\Doctrine\Entity\Laboratory 1
App\Conformity\Infrastructure\Doctrine\Entity\ConfigTraceability 1
App\Configuration\Infrastructure\Doctrine\Entity\Config 1
App\Configuration\Infrastructure\Doctrine\Entity\ConfigItem 1
App\Configuration\Infrastructure\Doctrine\Entity\ConfigDetail 1
App\Conformity\Infrastructure\Doctrine\Entity\ActTraceability 1

Entities Mapping

Class Mapping errors
App\Account\Infrastructure\Doctrine\Entity\Account No errors.
App\Account\Infrastructure\Doctrine\Entity\Practician No errors.
App\Account\Infrastructure\Doctrine\Entity\Administrator No errors.
App\Account\Infrastructure\Doctrine\Entity\Supervisor No errors.
App\Account\Infrastructure\Doctrine\Entity\Token No errors.
App\Organization\Infrastructure\Doctrine\Entity\OrganizationMember No errors.
App\Media\Infrastructure\Doctrine\Entity\HasMedia No errors.
App\Order\Infrastructure\Doctrine\Entity\Order No errors.
App\Order\Infrastructure\Doctrine\Entity\Patient No errors.
App\Organization\Infrastructure\Doctrine\Entity\Organization No errors.
App\Conformity\Infrastructure\Doctrine\Entity\Traceability No errors.
App\Conformity\Infrastructure\Doctrine\Entity\Laboratory No errors.
App\Media\Infrastructure\Doctrine\Entity\Media No errors.
App\Order\Infrastructure\Doctrine\Entity\OrderConfig No errors.
App\Order\Infrastructure\Doctrine\Entity\OrderInvalidStep No errors.
App\Order\Infrastructure\Doctrine\Entity\OrderTranslation No errors.
App\Conformity\Infrastructure\Doctrine\Entity\ConfigTraceability No errors.
App\Configuration\Infrastructure\Doctrine\Entity\Config No errors.
App\Configuration\Infrastructure\Doctrine\Entity\ConfigItem No errors.
App\Configuration\Infrastructure\Doctrine\Entity\ConfigDetail No errors.
App\Conformity\Infrastructure\Doctrine\Entity\ActTraceability No errors.
App\Conformity\Infrastructure\Doctrine\Entity\ProductTraceability No errors.