GET https://devb2b.webticari.net/checkout/pay

Query Metrics

11 Database Queries
7 Different statements
6.77 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 2.99 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1
Parameters:
[]
2 0.67 ms
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?
Parameters:
[
  "firstPageIsLogin"
]
3 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.73 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "USD"
]
5 0.21 ms
"START TRANSACTION"
Parameters:
[]
6 0.39 ms
UPDATE currency SET exchangeRate = ? WHERE id = ?
Parameters:
[
  "43.1660"
  2
]
7 0.22 ms
"COMMIT"
Parameters:
[]
8 0.39 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "EUR"
]
9 0.19 ms
"START TRANSACTION"
Parameters:
[]
10 0.33 ms
UPDATE currency SET exchangeRate = ? WHERE id = ?
Parameters:
[
  "50.1247"
  3
]
11 0.19 ms
"COMMIT"
Parameters:
[]

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\Setting 2
App\Entity\Currency 2
App\Entity\Store 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Setting No errors.
App\Entity\Store No errors.
App\Entity\Currency No errors.