https://mixform.pl/user

Query Metrics

12 Database Queries
7 Different statements
18.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.97 ms
(31.60%)
1
SELECT o0_.id AS id_0, o0_.amount AS amount_1 FROM `order` o0_ WHERE o0_.opt = 0 AND (o0_.status = 1 OR o0_.status = 3 OR o0_.status = 7) AND o0_.user = 0
Parameters:
[]
3.57 ms
(18.92%)
1
SELECT t0.id AS id_1, t0.user AS user_2, t0.referal AS referal_3, t0.manager AS manager_4, t0.tstamp AS tstamp_5, t0.esystem AS esystem_6, t0.delivery AS delivery_7, t0.subdelivery AS subdelivery_8, t0.status AS status_9, t0.name AS name_10, t0.addr AS addr_11, t0.city AS city_12, t0.postcode AS postcode_13, t0.state AS state_14, t0.state_code AS state_code_15, t0.country AS country_16, t0.phone AS phone_17, t0.email AS email_18, t0.ip AS ip_19, t0.payment_method AS payment_method_20, t0.created AS created_21, t0.sklad AS sklad_22, t0.comment AS comment_23, t0.opt AS opt_24, t0.needcall AS needcall_25, t0.deliverycost AS deliverycost_26, t0.paylink AS paylink_27, t0.discount AS discount_28, t0.session AS session_29, t0.cookie AS cookie_30, t0.amount AS amount_31, t0.amount_without_discount AS amount_without_discount_32, t0.weight AS weight_33, t0.company_nip AS company_nip_34, t0.company_name AS company_name_35, t0.company_index AS company_index_36, t0.company_city AS company_city_37, t0.company_street AS company_street_38, t0.company_house AS company_house_39, t0.company_flat AS company_flat_40 FROM `order` t0 WHERE t0.user = ?
Parameters:
[
  0
]
3.08 ms
(16.29%)
5
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
2.54 ms
(13.44%)
1
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
2.49 ms
(13.16%)
2
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.value AS value_2, d0_.nakop AS nakop_3 FROM discount d0_ WHERE d0_.nakop > 0 ORDER BY d0_.nakop ASC LIMIT 1
Parameters:
[]
1.08 ms
(5.70%)
1
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.value AS value_2, d0_.nakop AS nakop_3 FROM discount d0_ WHERE d0_.nakop <= 0 ORDER BY d0_.nakop DESC LIMIT 1
Parameters:
[]
0.17 ms
(0.88%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.nakop AS nakop_4 FROM discount 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.