Query Metrics
103
Database Queries
52
Different statements
150.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
27.01 ms (17.90%) |
46 |
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:
[
21728
]
|
|
12.00 ms (7.95%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21144 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
9.53 ms (6.31%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20550 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
8.19 ms (5.43%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 19816 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
6.43 ms (4.26%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21168 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
5.28 ms (3.50%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21166 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
5.27 ms (3.49%) |
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 950
Parameters:
[] |
|
4.76 ms (3.15%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21192 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
4.09 ms (2.71%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 17833 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
3.91 ms (2.59%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21246 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
3.47 ms (2.30%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20519 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
3.19 ms (2.12%) |
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:
[] |
|
3.17 ms (2.10%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20677 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
3.12 ms (2.07%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 19589 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.96 ms (1.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:
[ 716 715 714 712 711 713 710 709 705 704 703 702 701 699 700 698 697 696 695 694 693 691 692 690 689 688 684 687 685 683 682 680 679 681 678 676 677 675 674 673 672 671 670 669 668 667 665 666 663 664 ] |
|
2.94 ms (1.95%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 18837 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.77 ms (1.84%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20737 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.74 ms (1.82%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20196 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.31 ms (1.53%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21446 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.29 ms (1.52%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21747 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.21 ms (1.47%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21401 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.17 ms (1.44%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21161 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
2.09 ms (1.38%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21278 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.86 ms (1.24%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21334 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.66 ms (1.10%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21327 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.65 ms (1.09%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21773 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.59 ms (1.06%) |
2 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20755 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.53 ms (1.02%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21728 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.51 ms (1.00%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21434 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.49 ms (0.99%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21590 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.47 ms (0.97%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21698 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.30 ms (0.86%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21782 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.22 ms (0.81%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21063 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.17 ms (0.78%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21469 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.12 ms (0.74%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21370 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
1.09 ms (0.72%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 18142 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.99 ms (0.66%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21551 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.89 ms (0.59%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21572 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.85 ms (0.56%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21489 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.77 ms (0.51%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20452 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.76 ms (0.50%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21788 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.69 ms (0.46%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21623 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.65 ms (0.43%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21289 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.64 ms (0.42%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20987 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.63 ms (0.42%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21591 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.63 ms (0.41%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21002 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.58 ms (0.39%) |
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:
[] |
|
0.55 ms (0.37%) |
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.54 ms (0.36%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21216 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.44 ms (0.29%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21808 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.36 ms (0.24%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21368 AND 1766049265 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[] |
|
0.35 ms (0.23%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21164 AND 1766049265 - 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. |