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

Query Metrics

12 Database Queries
10 Different statements
2.31 ms Query time
0 Invalid entities
18 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.34 ms
(14.87%)
2
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
]
0.33 ms
(14.44%)
2
SELECT t0.id AS id_1, t0.payment_type_code AS payment_type_code_2, t0.store_id AS store_id_3 FROM store_payment_type t0 WHERE t0.store_id = ?
Parameters:
[
  5
]
0.29 ms
(12.37%)
1
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
]
0.24 ms
(10.46%)
1
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_.allow_guest_order AS allow_guest_order_10, s0_.deleted_at AS deleted_at_11, s0_.is_active AS is_active_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.store_type_id AS store_type_id_15, s0_.company_id AS company_id_16, s0_.default_currency AS default_currency_17, s0_.language_code AS language_code_18 FROM store s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
0.22 ms
(9.52%)
1
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
]
0.19 ms
(8.31%)
1
SELECT count(s0_.id) AS sclr_0 FROM sta_store_type s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
0.19 ms
(8.04%)
1
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
]
0.19 ms
(8.00%)
1
SELECT count(s0_.id) AS sclr_0 FROM store s0_ WHERE (s0_.is_active = ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  1
]
0.18 ms
(7.88%)
1
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"
]
0.14 ms
(6.10%)
1
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\StorePaymentType 6
App\Entity\StaLanguage 3
App\Entity\StaStoreType 3
App\Entity\Store 2
App\Entity\Company 2
App\Entity\StaCurrency 1
App\Entity\StaCompanyType 1

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.
App\Entity\StoreTable No errors.
App\Entity\StorePaymentType No errors.
App\Entity\StaCompanyType No errors.