https://int.my.brunex.ch/api/notifications/unread?locale=de

Query Metrics

29 Database Queries
11 Different statements
26.77 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TRACKING"
]
2 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "OPTIONAL_ARTICLES"
]
3 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MODULE_DECLARATION"
]
4 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MODULE_TRANSLATION"
]
5 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MONTAGE_OBERFLAECHE_AUFSCHLAG"
]
6 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "677_MITTELLAGE"
]
7 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "SCHALLSCHUTZ_RECHNER"
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "STAHLZARGE1"
]
9 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "STAHLZARGE2"
]
10 4.43 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.registration_token AS registration_token_7, t0.security_token AS security_token_8, t0.active AS active_9, t0.admin AS admin_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.mobile AS mobile_13, t0.erp_reference AS erp_reference_14, t0.news_read_on AS news_read_on_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employee_of AS employee_of_18, t19.id AS id_20, t19.name AS name_21, t19.tax_id AS tax_id_22, t19.verified AS verified_23, t19.address_id AS address_id_24, t19.user_id AS user_id_25, t0.contact_through AS contact_through_26, t27.id AS id_28, t27.created AS created_29, t27.updated AS updated_30, t27.email AS email_31, t27.first_name AS first_name_32, t27.last_name AS last_name_33, t27.area AS area_34, t27.phone AS phone_35, t27.image AS image_36 FROM user t0 LEFT JOIN contact_validation t19 ON t19.user_id = t0.id LEFT JOIN company_person t27 ON t0.contact_through = t27.id WHERE t0.username = ? LIMIT 1
Parameters:
[
  "marc@roothirsch.com"
]
11 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.currency AS currency_4, t0.language AS language_5, t0.verified AS verified_6, t0.blocked AS blocked_7, t0.discount AS discount_8, t0.logo AS logo_9, t0.erp_reference AS erp_reference_10, t0.certification AS certification_11, t0.recipients AS recipients_12, t0.address_id AS address_id_13, t0.delivery_address_id AS delivery_address_id_14, t0.billing_address_id AS billing_address_id_15, t0.distributor_id AS distributor_id_16, t0.type FROM company t0 WHERE t0.id = ? AND t0.type IN ('core_company', 'company')
Parameters:
[
  2
]
12 2.86 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.active AS active_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM groups t0 INNER JOIN user_group ON t0.id = user_group.group_id WHERE user_group.user_id = ?
Parameters:
[
  152
]
13 1.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.active AS active_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM groups t0 INNER JOIN core_company_group ON t0.id = core_company_group.group_id WHERE core_company_group.company_id = ?
Parameters:
[
  2
]
14 0.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.maintenance_enabled AS maintenance_enabled_9, t0.maintenance_message AS maintenance_message_10, t0.settings AS settings_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.default_contact AS default_contact_14, t15.id AS id_16, t15.created AS created_17, t15.updated AS updated_18, t15.email AS email_19, t15.first_name AS first_name_20, t15.last_name AS last_name_21, t15.area AS area_22, t15.phone AS phone_23, t15.image AS image_24 FROM site t0 LEFT JOIN company_person t15 ON t0.default_contact = t15.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
15 0.52 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "1"
  "de"
  "Roothirsch\CoreBundle\Site\Entity\Site"
]
16 0.34 ms
SELECT t0.id AS id_1, t0.language_name AS language_name_2, t0.language_key AS language_key_3, t0.is_default_language AS is_default_language_4, t0.image AS image_5 FROM translation_language t0 WHERE t0.language_key = ? LIMIT 1
Parameters:
[
  "de"
]
17 1.46 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.user_id AS user_id_3 FROM notification_read_on t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  152
]
18 0.79 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.created_at AS created_at_3 FROM notification n0_ WHERE n0_.created_at BETWEEN ? AND ? ORDER BY n0_.created_at DESC LIMIT 10
Parameters:
[
  "2025-02-20 11:26:12"
  "2026-03-26 07:02:39"
]
19 0.39 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.created_at AS created_at_3 FROM notification n0_ WHERE n0_.created_at <= ? ORDER BY n0_.created_at DESC LIMIT 10
Parameters:
[
  "2025-02-20 11:26:12"
]
20 4.91 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "35"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
21 0.31 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "34"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
22 0.73 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "33"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
23 0.28 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "32"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
24 0.27 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "31"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
25 0.30 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "29"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
26 1.54 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "28"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
27 0.62 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "6"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
28 0.27 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "5"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]
29 0.60 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "de"
  "Roothirsch\NotificationBundle\Entity\Notification"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
my_brunex doctrine.dbal.my_brunex_connection

Entity Managers

Name Service
my_brunex doctrine.orm.my_brunex_entity_manager
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

my_brunex entity manager

No loaded entities.

default entity manager

Class Mapping errors
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
Roothirsch\CoreBundle\Site\Entity\Site No errors.
Roothirsch\CoreBundle\FeatureFlag\Entity\FeatureFlag No errors.
Roothirsch\PimBundle\Entity\Category
  • The mappings Roothirsch\PimBundle\Entity\Category#parent and Roothirsch\PimBundle\Entity\Category#children are inconsistent with each other.
  • The association Roothirsch\PimBundle\Entity\Category#children refers to the owning side field Roothirsch\PimBundle\Entity\Category#parent_id which does not exist.
  • The mappings Roothirsch\PimBundle\Entity\Category#productAttributeGroups and Roothirsch\PimBundle\Entity\AttributeGroup#categories are inconsistent with each other.
  • The mappings Roothirsch\PimBundle\Entity\Category#articleAttributeGroups and Roothirsch\PimBundle\Entity\AttributeGroup#categories are inconsistent with each other.
Roothirsch\CoreBundle\Entity\User No errors.
Roothirsch\CoreBundle\Entity\Company No errors.
Roothirsch\CoreBundle\Entity\ContactValidation No errors.
Roothirsch\CoreBundle\Entity\Address No errors.
Roothirsch\CoreBundle\Entity\ContactPerson No errors.
App\Entity\Company No errors.
Roothirsch\CoreBundle\Entity\Group No errors.
Roothirsch\CoreBundle\Entity\Company\CompanyAttributeValue No errors.
Roothirsch\CoreBundle\Translation\Entity\Language No errors.
Roothirsch\NotificationBundle\Entity\NotificationReadOn No errors.
Roothirsch\NotificationBundle\Entity\Notification No errors.