Symfony Profiler

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 = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'de' AND e0_.object_class = 'Roothirsch\\CoreBundle\\Site\\Entity\\Site';

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = 'TRACKING' LIMIT 1;

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

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 = 'marc@roothirsch.com' LIMIT 1;

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 = ?

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 = 152;

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

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 = 1 LIMIT 1;

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.address_id AS address_id_12,
  t0.delivery_address_id AS delivery_address_id_13,
  t0.billing_address_id AS billing_address_id_14,
  t0.distributor_id AS distributor_id_15,
  t0.type
FROM
  company t0
WHERE
  t0.id = ?
  AND t0.type IN ('core_company', 'company')

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.address_id AS address_id_12, t0.delivery_address_id AS delivery_address_id_13, t0.billing_address_id AS billing_address_id_14, t0.distributor_id AS distributor_id_15, t0.type FROM company t0 WHERE t0.id = 2 AND t0.type IN ('core_company', 'company');

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 = ?

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 = 2;

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

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 = 152 LIMIT 1;

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

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 '2025-02-20 11:26:12' AND '2025-09-17 13:41:26' ORDER BY n0_.created_at DESC LIMIT 10;

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

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 <= '2025-02-20 11:26:12' ORDER BY n0_.created_at DESC LIMIT 10;

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

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 = 'de' LIMIT 1;