Symfony Profiler

SELECT
  COUNT(*) AS total
FROM
  (
    SELECT
      che.entry,
      che.date,
      che.date as created,
      che.type,
      che.system_agent as systemAgent,
      che.email_history_entry_id as emailHistoryEntryId,
      ehe.subject as subject,
      ehe.content as content
    FROM
      customer_history_entry che
      LEFT JOIN email_history_entry ehe ON ehe.id = che.email_history_entry_id
    WHERE
      che.customer_id = :customer
    UNION
    SELECT
      '' as entry,
      i.invoice_date,
      i.invoice_date as date,
      i.created,
      IF(
        i.cancellation = 0, 'invoice', 'cancellation'
      ) as type,
      u.username,
      u.username as systemAgent,
      '' as emailHistoryEntryId
    FROM
      invoice i
      LEFT JOIN customer_order o ON o.id = i._order_id
      LEFT JOIN user u ON u.id = i.signed_by_id
    WHERE
      o.customer_id = :customer
  ) as history

SELECT COUNT(*) AS total FROM (SELECT 
            che.entry, 
            che.date, 
            che.date as created, 
            che.type, 
            che.system_agent as systemAgent, 
            che.email_history_entry_id as emailHistoryEntryId,
            ehe.subject as subject,
            ehe.content as content 
            
            FROM customer_history_entry che LEFT JOIN email_history_entry ehe ON ehe.id = che.email_history_entry_id WHERE che.customer_id = 1274  UNION SELECT '' as entry, i.invoice_date, i.invoice_date as date, i.created, IF(i.cancellation = 0, 'invoice', 'cancellation') as type, u.username, u.username as systemAgent, '' as emailHistoryEntryId FROM invoice i LEFT JOIN customer_order o ON o.id = i._order_id LEFT JOIN user u ON u.id = i.signed_by_id WHERE o.customer_id = 1274 ) as history;

SELECT
  t0.title AS title_1,
  t0.salutation AS salutation_2,
  t0.member AS member_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.date_of_birth AS date_of_birth_6,
  t0.city_of_birth AS city_of_birth_7,
  t0.comment AS comment_8,
  t0.is_main_contact AS is_main_contact_9,
  t0.is_speaker AS is_speaker_10,
  t0.is_customer AS is_customer_11,
  t0.street AS street_12,
  t0.street_number AS street_number_13,
  t0.postalcode AS postalcode_14,
  t0.city AS city_15,
  t0.contact_email AS contact_email_16,
  t0.web AS web_17,
  t0.country AS country_18,
  t0.phone AS phone_19,
  t0.mobile AS mobile_20,
  t0.delete_date AS delete_date_21,
  t0.iban AS iban_22,
  t0.bic AS bic_23,
  t0.bank AS bank_24,
  t0.debit_agree AS debit_agree_25,
  t0.debit_agree_source AS debit_agree_source_26,
  t0.debit_agree_date AS debit_agree_date_27,
  t0.email_invoice AS email_invoice_28,
  t0.privacy_policy_confirmed AS privacy_policy_confirmed_29,
  t0.receive_newsletter AS receive_newsletter_30,
  t0.debit_active AS debit_active_31,
  t0.is_invoice_recipient AS is_invoice_recipient_32,
  t0.company AS company_33,
  t0.id AS id_34,
  t0.created AS created_35,
  t0.modified AS modified_36,
  t0.user_id AS user_id_37,
  t0.family_member_of_id AS family_member_of_id_38,
  t39.image AS image_40,
  t39.id AS id_41,
  t39.created AS created_42,
  t39.modified AS modified_43,
  t39.person_id AS person_id_44
FROM
  person t0
  LEFT JOIN speaker t39 ON t39.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.date_of_birth AS date_of_birth_6, t0.city_of_birth AS city_of_birth_7, t0.comment AS comment_8, t0.is_main_contact AS is_main_contact_9, t0.is_speaker AS is_speaker_10, t0.is_customer AS is_customer_11, t0.street AS street_12, t0.street_number AS street_number_13, t0.postalcode AS postalcode_14, t0.city AS city_15, t0.contact_email AS contact_email_16, t0.web AS web_17, t0.country AS country_18, t0.phone AS phone_19, t0.mobile AS mobile_20, t0.delete_date AS delete_date_21, t0.iban AS iban_22, t0.bic AS bic_23, t0.bank AS bank_24, t0.debit_agree AS debit_agree_25, t0.debit_agree_source AS debit_agree_source_26, t0.debit_agree_date AS debit_agree_date_27, t0.email_invoice AS email_invoice_28, t0.privacy_policy_confirmed AS privacy_policy_confirmed_29, t0.receive_newsletter AS receive_newsletter_30, t0.debit_active AS debit_active_31, t0.is_invoice_recipient AS is_invoice_recipient_32, t0.company AS company_33, t0.id AS id_34, t0.created AS created_35, t0.modified AS modified_36, t0.user_id AS user_id_37, t0.family_member_of_id AS family_member_of_id_38, t39.image AS image_40, t39.id AS id_41, t39.created AS created_42, t39.modified AS modified_43, t39.person_id AS person_id_44 FROM person t0 LEFT JOIN speaker t39 ON t39.person_id = t0.id WHERE t0.id = '1274';

SELECT
  che.entry,
  che.date,
  che.date as created,
  che.type,
  che.system_agent as systemAgent,
  che.email_history_entry_id as emailHistoryEntryId,
  ehe.subject as subject,
  ehe.content as content
FROM
  customer_history_entry che
  LEFT JOIN email_history_entry ehe ON ehe.id = che.email_history_entry_id
WHERE
  che.customer_id = :customer
UNION
SELECT
  '' as entry,
  i.invoice_date,
  i.invoice_date as date,
  i.created,
  IF(
    i.cancellation = 0, 'invoice', 'cancellation'
  ) as type,
  u.username,
  u.username as systemAgent,
  '' as emailHistoryEntryId
FROM
  invoice i
  LEFT JOIN customer_order o ON o.id = i._order_id
  LEFT JOIN user u ON u.id = i.signed_by_id
WHERE
  o.customer_id = :customer
ORDER BY
  date DESC,
  created asc
LIMIT
  0, 25

SELECT 
            che.entry, 
            che.date, 
            che.date as created, 
            che.type, 
            che.system_agent as systemAgent, 
            che.email_history_entry_id as emailHistoryEntryId,
            ehe.subject as subject,
            ehe.content as content 
            
            FROM customer_history_entry che LEFT JOIN email_history_entry ehe ON ehe.id = che.email_history_entry_id WHERE che.customer_id = 1274  UNION SELECT '' as entry, i.invoice_date, i.invoice_date as date, i.created, IF(i.cancellation = 0, 'invoice', 'cancellation') as type, u.username, u.username as systemAgent, '' as emailHistoryEntryId FROM invoice i LEFT JOIN customer_order o ON o.id = i._order_id LEFT JOIN user u ON u.id = i.signed_by_id WHERE o.customer_id = 1274 ORDER BY date DESC , created asc LIMIT 0, 25 ;

SELECT
  t0.username AS username_1,
  t0.password AS password_2,
  t0.role AS role_3,
  t0.password_reset_token AS password_reset_token_4,
  t0.password_requested_at AS password_requested_at_5,
  t0.password_reset_at AS password_reset_at_6,
  t0.activate_token AS activate_token_7,
  t0.activate_requested_at AS activate_requested_at_8,
  t0.activated_at AS activated_at_9,
  t0.email_confirm_token AS email_confirm_token_10,
  t0.email_confirm_requested_at AS email_confirm_requested_at_11,
  t0.email_confirmed_at AS email_confirmed_at_12,
  t0.facebook_id AS facebook_id_13,
  t0.google_id AS google_id_14,
  t0.id AS id_15,
  t0.created AS created_16,
  t0.modified AS modified_17,
  t0.clientId AS clientId_18,
  t19.name AS name_20,
  t19.street AS street_21,
  t19.street_number AS street_number_22,
  t19.addressAddition AS addressAddition_23,
  t19.postalcode AS postalcode_24,
  t19.city AS city_25,
  t19.country AS country_26,
  t19.email AS email_27,
  t19.web AS web_28,
  t19.phone AS phone_29,
  t19.fax AS fax_30,
  t19.from_email AS from_email_31,
  t19.id AS id_32,
  t19.created AS created_33,
  t19.modified AS modified_34
FROM
  user t0
  LEFT JOIN client t19 ON t0.clientId = t19.id
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.password AS password_2, t0.role AS role_3, t0.password_reset_token AS password_reset_token_4, t0.password_requested_at AS password_requested_at_5, t0.password_reset_at AS password_reset_at_6, t0.activate_token AS activate_token_7, t0.activate_requested_at AS activate_requested_at_8, t0.activated_at AS activated_at_9, t0.email_confirm_token AS email_confirm_token_10, t0.email_confirm_requested_at AS email_confirm_requested_at_11, t0.email_confirmed_at AS email_confirmed_at_12, t0.facebook_id AS facebook_id_13, t0.google_id AS google_id_14, t0.id AS id_15, t0.created AS created_16, t0.modified AS modified_17, t0.clientId AS clientId_18, t19.name AS name_20, t19.street AS street_21, t19.street_number AS street_number_22, t19.addressAddition AS addressAddition_23, t19.postalcode AS postalcode_24, t19.city AS city_25, t19.country AS country_26, t19.email AS email_27, t19.web AS web_28, t19.phone AS phone_29, t19.fax AS fax_30, t19.from_email AS from_email_31, t19.id AS id_32, t19.created AS created_33, t19.modified AS modified_34 FROM user t0 LEFT JOIN client t19 ON t0.clientId = t19.id WHERE t0.id = 2143;

SELECT
  t0.name AS name_1,
  t0.secret AS secret_2,
  t0.redirect_uris AS redirect_uris_3,
  t0.grants AS grants_4,
  t0.scopes AS scopes_5,
  t0.active AS active_6,
  t0.allow_plain_text_pkce AS allow_plain_text_pkce_7,
  t0.identifier AS identifier_8,
  t0.activation_url AS activation_url_9,
  t0.confirm_email_url AS confirm_email_url_10,
  t0.reset_password_url AS reset_password_url_11,
  t0.google_client_id AS google_client_id_12,
  t0.application_client_id AS application_client_id_13
FROM
  oauth_client t0
WHERE
  t0.application_client_id = ?

SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8, t0.activation_url AS activation_url_9, t0.confirm_email_url AS confirm_email_url_10, t0.reset_password_url AS reset_password_url_11, t0.google_client_id AS google_client_id_12, t0.application_client_id AS application_client_id_13 FROM oauth_client t0 WHERE t0.application_client_id = 2;