Query Metrics
102
Database Queries
51
Different statements
111.91 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
34.39 ms (30.73%) |
45 |
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.lastordertime AS lastordertime_30, t0.ordersum AS ordersum_31, t0.ordernum AS ordernum_32, t0.external_id AS external_id_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 user t0 WHERE t0.id = ?
Parameters:
[
12153
]
|
10.23 ms (9.14%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12153 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
9.78 ms (8.74%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6795 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
9.52 ms (8.50%) |
2 |
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 1300
Parameters:
[] |
5.37 ms (4.80%) |
1 |
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:
[] |
4.42 ms (3.95%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11794 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
3.53 ms (3.15%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11869 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
3.31 ms (2.96%) |
2 |
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:
[ 235 233 231 229 228 226 225 222 224 223 220 218 217 215 214 212 210 211 209 206 205 204 203 201 200 194 199 197 198 193 192 191 189 188 187 186 185 184 182 181 180 178 177 179 174 175 172 171 169 168 ] |
3.19 ms (2.85%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11697 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
2.40 ms (2.14%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11812 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
2.24 ms (2.01%) |
1 |
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:
[] |
1.65 ms (1.47%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 7600 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.55 ms (1.39%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 288 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.33 ms (1.19%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11443 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.28 ms (1.14%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 974 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.18 ms (1.05%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10990 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.18 ms (1.05%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11610 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.12 ms (1.00%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10991 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.07 ms (0.95%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12044 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.01 ms (0.91%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11499 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.99 ms (0.88%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11983 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.98 ms (0.87%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11783 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.83 ms (0.75%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11037 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.68 ms (0.60%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10729 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.64 ms (0.57%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11243 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.55 ms (0.49%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10324 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.51 ms (0.46%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11861 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.50 ms (0.45%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 2177 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.42 ms (0.38%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8889 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.42 ms (0.37%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11533 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.41 ms (0.37%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6446 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.39 ms (0.34%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11888 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.36 ms (0.32%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11742 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.35 ms (0.32%) |
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
]
|
0.35 ms (0.31%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8594 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.35 ms (0.31%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11757 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.33 ms (0.30%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11429 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.27 ms (0.24%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11972 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.26 ms (0.23%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11348 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.25 ms (0.23%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11902 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.25 ms (0.22%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10596 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.24 ms (0.21%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11316 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.22 ms (0.20%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11893 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.22 ms (0.20%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11494 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.21 ms (0.19%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11256 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.21 ms (0.18%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11778 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.20 ms (0.18%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11013 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.20 ms (0.18%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11041 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.20 ms (0.18%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10992 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.20 ms (0.18%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10632 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.19 ms (0.17%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10748 AND 1756337246 - o0_.tstamp < 60 * 60 * 24 * 365
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Discount | No errors. |
App\Entity\Block | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\BlockTranslation | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Order | No errors. |