GET https://stage.scananddine.com/

Query Metrics

8 Database Queries
7 Different statements
3.65 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 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.80 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.deleted_at AS deleted_at_2, s0_.is_active AS is_active_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sta_store_type s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
3 0.50 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
]
4 0.59 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_.mail AS mail_5, s0_.phone AS phone_6, s0_.working_date AS working_date_7, s0_.logo_file_name AS logo_file_name_8, s0_.cover_file_name AS cover_file_name_9, s0_.deleted_at AS deleted_at_10, s0_.is_active AS is_active_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.store_type_id AS store_type_id_14, s0_.company_id AS company_id_15, s0_.default_currency AS default_currency_16 FROM store s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
5 0.52 ms
SELECT count(s0_.id) AS sclr_0 FROM store s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
6 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.token AS token_9, t0.deleted_at AS deleted_at_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_type AS company_type_14 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2
]
7 0.26 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.iso_number AS iso_number_3, t0.unicode_sign AS unicode_sign_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.deleted_at AS deleted_at_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM sta_currency t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "EUR"
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.token AS token_9, t0.deleted_at AS deleted_at_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_type AS company_type_14 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3
]

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\StaStoreType 3
App\Entity\Store 2
App\Entity\Company 2
App\Entity\StaLanguage 1
App\Entity\StaCurrency 1
App\Entity\StaCompanyType 1

Entities Mapping

Class Mapping errors
App\Entity\StaLanguage No errors.
App\Entity\StaStoreType No errors.
App\Entity\Store No errors.
App\Entity\Company No errors.
App\Entity\StaCurrency No errors.
App\Entity\StoreTable No errors.
App\Entity\StaCompanyType No errors.