POST https://dionizos-stage.dev.szkla.pl/optical-salon/construction-choice

Query Metrics

29 Database Queries
10 Different statements
17.44 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.erp_id AS erp_id_9, t0.is_active AS is_active_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.60 ms
SELECT t0.visit_number AS visit_number_1, t0.has_application AS has_application_2, t0.lw_send AS lw_send_3, t0.lw_retry_count AS lw_retry_count_4, t0.lw_remark AS lw_remark_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.base_price AS base_price_9, t0.final_price AS final_price_10, t0.offer_status_id AS offer_status_id_11, t0.sale_place_id AS sale_place_id_12, t0.user_id AS user_id_13 FROM offer t0 WHERE t0.id = ?
Parameters:
[
  237
]
3 0.73 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM offer_status t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.69 ms
SELECT t0.id AS id_1, t0.offer_id AS offer_id_2, t0.eye_examination_id AS eye_examination_id_3 FROM offer_item t0 WHERE t0.offer_id = ?
Parameters:
[
  237
]
5 0.86 ms
SELECT t0.sku AS sku_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.id AS id_4, t0.base_price AS base_price_5, t0.final_price AS final_price_6, t0.offer_item_id AS offer_item_id_7 FROM offer_item_item t0 WHERE t0.offer_item_id = ?
Parameters:
[
  237
]
6 0.87 ms
SELECT t0.label AS label_1, t0.value AS value_2, t0.id AS id_3, t0.product_attribute_type_id AS product_attribute_type_id_4, t0.offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0.offer_item_item_id = ?
Parameters:
[
  685
]
7 0.63 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.67 ms
SELECT t0.label AS label_1, t0.value AS value_2, t0.id AS id_3, t0.product_attribute_type_id AS product_attribute_type_id_4, t0.offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0.offer_item_item_id = ?
Parameters:
[
  700
]
9 0.50 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  34
]
10 0.54 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  12
]
11 0.59 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  13
]
12 0.48 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  9
]
13 0.45 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  11
]
14 0.48 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  23
]
15 0.53 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  10
]
16 0.59 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  30
]
17 0.61 ms
SELECT t0.label AS label_1, t0.value AS value_2, t0.id AS id_3, t0.product_attribute_type_id AS product_attribute_type_id_4, t0.offer_item_item_id AS offer_item_item_id_5 FROM offer_item_item_attribute t0 WHERE t0.offer_item_item_id = ?
Parameters:
[
  701
]
18 0.83 ms
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.phone AS phone_3, t0.prescription_issue_date AS prescription_issue_date_4, t0.comment AS comment_5, t0.package_number AS package_number_6, t0.has_prism_to_the_distance AS has_prism_to_the_distance_7, t0.has_prism_for_near_vision AS has_prism_for_near_vision_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.oculist_id AS oculist_id_12, t0.eye_examination_type_id AS eye_examination_type_id_13 FROM eye_examination t0 WHERE t0.id = ?
Parameters:
[
  510
]
19 0.80 ms
SELECT t0.power AS power_1, t0.cylinder AS cylinder_2, t0.axis AS axis_3, t0.addition AS addition_4, t0.prism1 AS prism1_5, t0.prism_direction1 AS prism_direction1_6, t0.prism2 AS prism2_7, t0.prism_direction2 AS prism_direction2_8, t0.pd AS pd_9, t0.oc_height AS oc_height_10, t0.eye AS eye_11, t0.correction_type AS correction_type_12, t0.id AS id_13, t0.eye_examination_id AS eye_examination_id_14 FROM eye_examination_item t0 WHERE t0.eye_examination_id = ?
Parameters:
[
  510
]
20 0.83 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
21 0.48 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 0.41 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  5
]
23 0.49 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  21
]
24 0.40 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  7
]
25 0.45 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
26 0.39 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  35
]
27 0.36 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM product_attribute_type t0 WHERE t0.id = ?
Parameters:
[
  39
]
28 0.73 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM diameter_type t0
Parameters:
[]
29 0.55 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM diameter_type t0
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.