GET https://books.kin.dp.ua/

Query Metrics

9 Database Queries
4 Different statements
7.78 ms Query time
0 Invalid entities
0 Cache hits
1 Cache misses
7 Cache puts

Queries

Group similar statements

# Time Info
1 2.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.isocode AS isocode_3, t0.title AS title_4, t0.defaultlang AS defaultlang_5, t0.active AS active_6 FROM lang t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
2 1.09 ms
SELECT t0.id AS id_1, t0.sysname AS sysname_2, t0.weight AS weight_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM delivery t0
Parameters:
[]
3 1.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  1
]
4 0.68 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.isocode AS isocode_3, t0.title AS title_4, t0.defaultlang AS defaultlang_5, t0.active AS active_6 FROM lang t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  2
]
6 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  3
]
7 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  4
]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  5
]
9 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.detail AS detail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery_id AS delivery_id_6, t0.lang_id AS lang_id_7 FROM delivery_translate t0 WHERE t0.delivery_id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
1 Misses
7 Puts

Number of cache misses

Region Misses
app_entity_delivery 1

Number of cache puts

Region Puts
app_entity_delivery 7

Entities Mapping

Class Mapping errors
App\Entity\Lang No errors.
App\Entity\GoodslangTranslate No errors.
App\Entity\Delivery No errors.
App\Entity\DeliveryTranslate No errors.
App\Entity\DeliveryPrice No errors.