Query Metrics
98
Database Queries
51
Different statements
4368.37 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1229.00 ms (28.13%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1750489280 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
498.10 ms (11.40%) |
41 |
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:
[
118970
]
|
273.68 ms (6.27%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 41834 AND 1750489279 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
268.67 ms (6.15%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6795 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
178.17 ms (4.08%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 112369 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
168.86 ms (3.87%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 86841 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
148.69 ms (3.40%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 98109 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
138.72 ms (3.18%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 108571 AND 1750489280 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
109.69 ms (2.51%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 118970 AND 1750489279 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
108.41 ms (2.48%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 46691 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
104.07 ms (2.38%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 104501 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
98.08 ms (2.25%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 110265 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
84.54 ms (1.94%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11501 AND 1750489279 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
83.54 ms (1.91%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36623 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
73.58 ms (1.68%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 27758 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
72.19 ms (1.65%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37374 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
63.34 ms (1.45%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 111914 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
54.75 ms (1.25%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 115634 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
43.85 ms (1.00%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 96498 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
43.57 ms (1.00%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 110841 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
43.32 ms (0.99%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 110715 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
43.24 ms (0.99%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20129 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
42.86 ms (0.98%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 111391 AND 1750489282 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
38.13 ms (0.87%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 99991 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
32.89 ms (0.75%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 115135 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
31.61 ms (0.72%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 105140 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
29.12 ms (0.67%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 115252 AND 1750489280 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
28.53 ms (0.65%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 90729 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
28.42 ms (0.65%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 110893 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
23.10 ms (0.53%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 108379 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
20.23 ms (0.46%) |
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:
[] |
19.19 ms (0.44%) |
6 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
18.58 ms (0.43%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 113766 AND 1750489279 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
18.17 ms (0.42%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 111010 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
17.10 ms (0.39%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 115137 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
13.12 ms (0.30%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 111848 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
12.91 ms (0.30%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 114831 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
10.10 ms (0.23%) |
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:
[ 5130 5129 5128 5127 5126 5125 5124 5123 5122 5121 5120 5119 5118 5117 5116 5115 5114 5113 5112 5111 5110 5109 5108 5107 5106 5105 5104 5103 5102 5101 5100 5099 5098 5097 5096 5095 5094 5093 5092 5091 5090 5089 5088 5087 5086 5085 5084 5083 5082 5079 ] |
8.34 ms (0.19%) |
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
Parameters:
[] |
8.32 ms (0.19%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 112481 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
8.02 ms (0.18%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 115368 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
6.68 ms (0.15%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 96597 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
4.65 ms (0.11%) |
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
]
|
3.91 ms (0.09%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 119146 AND 1750489279 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
3.60 ms (0.08%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 117304 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
3.53 ms (0.08%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 117598 AND 1750489281 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
3.44 ms (0.08%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 111469 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.30 ms (0.03%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 41834 AND 1750489280 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
1.00 ms (0.02%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36623 AND 1750489283 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
0.79 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.page AS page_3, t0.intname AS intname_4, t0.mainpage AS mainpage_5, t0.name AS name_6, t0.href AS href_7, t0.short AS short_8, t0.cont AS cont_9, t0.prior AS prior_10, t0.visible AS visible_11, t0.title AS title_12, t0.h1 AS h1_13, t0.kw AS kw_14, t0.descr AS descr_15, t0.tstamp AS tstamp_16, t0.icon AS icon_17 FROM PAGE t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
"comments"
]
|
0.65 ms (0.01%) |
1 |
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 113766 AND 1750489283 - 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\Comment | No errors. |
App\Entity\Page | No errors. |
App\Entity\PagePhoto | No errors. |
App\Entity\PageBlock | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Order | No errors. |