Query Metrics
3
Database Queries
3
Different statements
6.69 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vat_number AS vat_number_3, t0.legal_name AS legal_name_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.contact_email AS contact_email_9, t0.website AS website_10, t0.logo_filename AS logo_filename_11, t0.favicon_filename AS favicon_filename_12, t0.subdomain AS subdomain_13, t0.modules AS modules_14, t0.max_employees AS max_employees_15, t0.max_centers AS max_centers_16, t0.stripe_customer_id AS stripe_customer_id_17, t0.stripe_subscription_id AS stripe_subscription_id_18, t0.stripe_status AS stripe_status_19, t0.billing_period AS billing_period_20, t0.billing_email AS billing_email_21, t0.billing_discount_percent AS billing_discount_percent_22, t0.billing_note AS billing_note_23, t0.vacation_overlap_policy AS vacation_overlap_policy_24, t0.vacation_max_overlap AS vacation_max_overlap_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27 FROM company t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
"ferrva"
]
|
| 2 | 3.21 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.label AS label_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.center_id AS center_id_7 FROM kiosk_device t0 WHERE t0.token = ? AND t0.active = ? LIMIT 1
Parameters:
[ "92da5bdb996e98c80a8248aee37c672387f644408887e2d1" 1 ] |
| 3 | 2.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.timezone AS timezone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.geofence_radius_meters AS geofence_radius_meters_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.company_id AS company_id_10 FROM center t0 WHERE t0.id = ? AND ((t0.company_id = '2'))
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\Entity\Company | 1 |
| App\Entity\KioskDevice | 1 |
| App\Entity\Center | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Company | No errors. |
| App\Entity\Center | No errors. |
| App\Entity\KioskDevice | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\Employee | No errors. |