GET https://stage.scananddine.com/?lang=tr&store_category=3

Query Metrics

7 Database Queries
7 Different statements
1.55 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.22 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.14 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.15 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.13 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.52 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.27 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.13 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.