Query Metrics
70
Database Queries
20
Different statements
64.07 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 6.04 ms |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
2 | 9.51 ms |
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[] |
3 | 0.42 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
4 | 0.21 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
2
]
|
5 | 0.17 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
3
]
|
6 | 0.21 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
4
]
|
7 | 0.20 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
5
]
|
8 | 0.19 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
6
]
|
9 | 0.16 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
7
]
|
10 | 0.20 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
8
]
|
11 | 0.18 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
9
]
|
12 | 0.16 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
10
]
|
13 | 0.20 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
11
]
|
14 | 0.23 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
12
]
|
15 | 0.19 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
15
]
|
16 | 0.21 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
13
]
|
17 | 0.21 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
14
]
|
18 | 0.17 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
21
]
|
19 | 0.18 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
16
]
|
20 | 0.21 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
17
]
|
21 | 0.18 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
18
]
|
22 | 0.16 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
19
]
|
23 | 0.17 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
20
]
|
24 | 0.19 ms |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
22
]
|
25 | 0.49 ms |
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
]
|
26 | 1.06 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM comment c0_ WHERE c0_.visible = 1 ORDER BY c0_.tstamp DESC) dctrn_result) dctrn_table
Parameters:
[] |
27 | 1.16 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, tstamp_5 FROM (SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM comment c0_ WHERE c0_.visible = 1) dctrn_result_inner ORDER BY tstamp_5 DESC) dctrn_result LIMIT 50 OFFSET 100
Parameters:
[] |
28 | 0.92 ms |
SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM comment c0_ WHERE c0_.visible = 1 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.tstamp DESC
Parameters:
[ 3892 3891 3890 3886 3884 3882 3881 3880 3879 3878 3876 3874 3873 3872 3871 3870 3869 3868 1629 1628 ] |
29 | 0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
30 | 0.80 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
31 | 0.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
32 | 0.50 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
33 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
34 | 10.04 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
35 | 0.45 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
100222
]
|
36 | 0.88 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 100222 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
37 | 0.31 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
38 | 0.62 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
39 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
40 | 0.59 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
41 | 0.29 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
98211
]
|
42 | 0.52 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 98211 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
43 | 0.23 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
44 | 0.64 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
45 | 0.23 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
72737
]
|
46 | 0.48 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 72737 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
47 | 0.25 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
48 | 0.51 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
49 | 0.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
34257
]
|
50 | 0.65 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 34257 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
51 | 0.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
89905
]
|
52 | 0.57 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 89905 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
53 | 0.29 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
26470
]
|
54 | 0.65 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 26470 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
55 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
96626
]
|
56 | 0.47 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 96626 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
57 | 0.21 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
96597
]
|
58 | 0.62 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 96597 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
59 | 0.29 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
29927
]
|
60 | 0.48 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 29927 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
61 | 0.28 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
36623
]
|
62 | 0.51 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 36623 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
63 | 0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
94994
]
|
64 | 0.51 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 94994 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
65 | 0.31 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
36623
]
|
66 | 0.59 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 36623 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
67 | 0.26 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
81857
]
|
68 | 0.55 ms |
SELECT count(o0_.id) AS sclr_0 FROM `opt_order` o0_ WHERE o0_.user = 81857 AND 1760803681 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
69 | 13.07 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, tstamp_5 FROM (SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM comment c0_ WHERE c0_.visible = 1) dctrn_result_inner ORDER BY tstamp_5 DESC) dctrn_result LIMIT 50 OFFSET 100
Parameters:
[] |
70 | 0.80 ms |
SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM comment c0_ WHERE c0_.visible = 1 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.tstamp DESC
Parameters:
[ 3892 3891 3890 3886 3884 3882 3881 3880 3879 3878 3876 3874 3873 3872 3871 3870 3869 3868 1629 1628 ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Discount | No errors. |
App\Entity\Redirect | No errors. |
App\Entity\Page | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Banner | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Order | No errors. |
App\Entity\Sett | No errors. |
App\Entity\Translation\SettTranslation | No errors. |
App\Entity\Template | No errors. |
App\Entity\Translation\TemplateTranslation | No errors. |
App\Entity\Timer | No errors. |
App\Entity\Translation\TimerTranslation | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\Block | No errors. |
App\Entity\Translation\BlockTranslation | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Comment | No errors. |