Query Metrics
7
Database Queries
7
Different statements
1.06 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.17 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.12 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.16 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_translations AS name_translations_2, s0_.deleted_at AS deleted_at_3, s0_.is_active AS is_active_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM sta_store_type s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.14 ms |
SELECT count(s0_.id) AS sclr_0 FROM sta_store_type s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.19 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.postal_code AS postal_code_3, s0_.location AS location_4, s0_.waiter_call_sound AS waiter_call_sound_5, s0_.latitude AS latitude_6, s0_.longitude AS longitude_7, s0_.mail AS mail_8, s0_.phone AS phone_9, s0_.working_date AS working_date_10, s0_.logo_file_name AS logo_file_name_11, s0_.cover_file_name AS cover_file_name_12, s0_.allow_guest_order AS allow_guest_order_13, s0_.require_table_selection AS require_table_selection_14, s0_.kitchen_delayed_minutes AS kitchen_delayed_minutes_15, s0_.ready_not_served_minutes AS ready_not_served_minutes_16, s0_.dirty_minutes AS dirty_minutes_17, s0_.allow_waiter_call AS allow_waiter_call_18, s0_.service_fee_payer AS service_fee_payer_19, s0_.service_fee_fixed AS service_fee_fixed_20, s0_.service_fee_percent AS service_fee_percent_21, s0_.service_fee_waived AS service_fee_waived_22, s0_.service_fee_free_until AS service_fee_free_until_23, s0_.deleted_at AS deleted_at_24, s0_.is_active AS is_active_25, s0_.created_at AS created_at_26, s0_.updated_at AS updated_at_27, s0_.store_type_id AS store_type_id_28, s0_.company_id AS company_id_29, s0_.default_currency AS default_currency_30, s0_.language_code AS language_code_31 FROM store s0_ WHERE (s0_.is_active = ? AND s0_.store_type_id = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[ 1 "3" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.12 ms |
SELECT count(s0_.id) AS sclr_0 FROM store s0_ WHERE (s0_.is_active = ? AND s0_.store_type_id = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[ 1 "3" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.16 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.code ASC
Parameters:
[
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\StaLanguage | 3 |
| App\Entity\StaStoreType | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\StaLanguage | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\StaStoreType | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\StaCurrency | No errors. |