Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.gender AS gender_8,
  t0.is_diverse AS is_diverse_9,
  t0.organisation AS organisation_10,
  t0.area_interest AS area_interest_11,
  t0.account_salesforce_id AS account_salesforce_id_12,
  t0.is_aborigin AS is_aborigin_13,
  t0.is_success AS is_success_14,
  t0.is_guest AS is_guest_15,
  t16.id AS id_17,
  t16.description AS description_18,
  t16.short_description AS short_description_19,
  t16.long_description AS long_description_20,
  t16.profile_picture AS profile_picture_21,
  t16.user_roles AS user_roles_22,
  t16.reason_support_documentary AS reason_support_documentary_23,
  t16.user_id AS user_id_24,
  t25.id AS id_26,
  t25.street AS street_27,
  t25.city AS city_28,
  t25.state AS state_29,
  t25.postcode AS postcode_30,
  t25.country AS country_31,
  t25.user_id AS user_id_32,
  t33.id AS id_34,
  t33.website AS website_35,
  t33.facebook AS facebook_36,
  t33.twitter AS twitter_37,
  t33.xero_id AS xero_id_38,
  t33.salesforce_id AS salesforce_id_39,
  t33.wordpress_id AS wordpress_id_40,
  t33.user_id AS user_id_41
FROM
  user t0
  LEFT JOIN user_profile t16 ON t16.user_id = t0.id
  LEFT JOIN user_address t25 ON t25.user_id = t0.id
  LEFT JOIN user_information t33 ON t33.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.gender AS gender_8, t0.is_diverse AS is_diverse_9, t0.organisation AS organisation_10, t0.area_interest AS area_interest_11, t0.account_salesforce_id AS account_salesforce_id_12, t0.is_aborigin AS is_aborigin_13, t0.is_success AS is_success_14, t0.is_guest AS is_guest_15, t16.id AS id_17, t16.description AS description_18, t16.short_description AS short_description_19, t16.long_description AS long_description_20, t16.profile_picture AS profile_picture_21, t16.user_roles AS user_roles_22, t16.reason_support_documentary AS reason_support_documentary_23, t16.user_id AS user_id_24, t25.id AS id_26, t25.street AS street_27, t25.city AS city_28, t25.state AS state_29, t25.postcode AS postcode_30, t25.country AS country_31, t25.user_id AS user_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.twitter AS twitter_37, t33.xero_id AS xero_id_38, t33.salesforce_id AS salesforce_id_39, t33.wordpress_id AS wordpress_id_40, t33.user_id AS user_id_41 FROM user t0 LEFT JOIN user_profile t16 ON t16.user_id = t0.id LEFT JOIN user_address t25 ON t25.user_id = t0.id LEFT JOIN user_information t33 ON t33.user_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.expires AS expires_3,
  t0.tenant_id AS tenant_id_4,
  t0.refresh_token AS refresh_token_5,
  t0.id_token AS id_token_6,
  t0.tag AS tag_7
FROM
  xero_storage t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = 'primary' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.expires AS expires_3,
  t0.tenant_id AS tenant_id_4,
  t0.refresh_token AS refresh_token_5,
  t0.id_token AS id_token_6,
  t0.tag AS tag_7
FROM
  xero_storage t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = 'primary' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.expires AS expires_3,
  t0.tenant_id AS tenant_id_4,
  t0.refresh_token AS refresh_token_5,
  t0.id_token AS id_token_6,
  t0.tag AS tag_7
FROM
  xero_storage t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = 'primary' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.category AS category_1,
  p0_.title AS title_2,
  p0_.subtitle AS subtitle_3,
  p0_.created_at AS created_at_4,
  p0_.is_read AS is_read_5,
  p0_.link AS link_6
FROM
  project_notification p0_
  LEFT JOIN project_notification_user p2_ ON p0_.id = p2_.project_notification_id
  LEFT JOIN user u1_ ON u1_.id = p2_.user_id
WHERE
  u1_.id = ?
  AND (
    p0_.is_read IS NULL
    OR p0_.is_read = 0
  )
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.category AS category_1, p0_.title AS title_2, p0_.subtitle AS subtitle_3, p0_.created_at AS created_at_4, p0_.is_read AS is_read_5, p0_.link AS link_6 FROM project_notification p0_ LEFT JOIN project_notification_user p2_ ON p0_.id = p2_.project_notification_id LEFT JOIN user u1_ ON u1_.id = p2_.user_id WHERE u1_.id = 1 AND (p0_.is_read IS NULL OR p0_.is_read = 0) ORDER BY p0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3
FROM
  setting t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = 'is_progress_report' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3
FROM
  setting t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = 'default_film_product' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.gl_code AS gl_code_6,
  t0.account_id AS account_id_7,
  t0.refund_code AS refund_code_8
FROM
  product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.description AS description_4, t0.price AS price_5, t0.gl_code AS gl_code_6, t0.account_id AS account_id_7, t0.refund_code AS refund_code_8 FROM product t0 WHERE t0.id = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3
FROM
  setting t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = 'default_donation_product' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.gl_code AS gl_code_6,
  t0.account_id AS account_id_7,
  t0.refund_code AS refund_code_8
FROM
  product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.description AS description_4, t0.price AS price_5, t0.gl_code AS gl_code_6, t0.account_id AS account_id_7, t0.refund_code AS refund_code_8 FROM product t0 WHERE t0.id = '1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3
FROM
  setting t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = 'is_progress_report' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'daf_portal_staging'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();