Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.app_name AS app_name_1,
  a0_.public_url AS public_url_2,
  a0_.support_email AS support_email_3,
  a0_.app_description AS app_description_4,
  a0_.favicon_path AS favicon_path_5,
  a0_.logo_path AS logo_path_6,
  a0_.logo_light_path AS logo_light_path_7,
  a0_.logo_dark_path AS logo_dark_path_8,
  a0_.logo_square_path AS logo_square_path_9,
  a0_.login_background_image AS login_background_image_10,
  a0_.footer_text AS footer_text_11,
  a0_.maintenance_message AS maintenance_message_12,
  a0_.company_name AS company_name_13,
  a0_.company_address AS company_address_14,
  a0_.company_phone AS company_phone_15,
  a0_.company_website AS company_website_16,
  a0_.company_email AS company_email_17,
  a0_.currency AS currency_18,
  a0_.timezone AS timezone_19,
  a0_.created_at AS created_at_20,
  a0_.updated_at AS updated_at_21,
  a1_.id AS id_22,
  a1_.enable_matomo AS enable_matomo_23,
  a1_.matomo_site_url AS matomo_site_url_24,
  a1_.matomo_site_id AS matomo_site_id_25,
  a1_.enable_google_analytics AS enable_google_analytics_26,
  a1_.google_analytics_id AS google_analytics_id_27,
  a1_.custom_head_scripts AS custom_head_scripts_28,
  a1_.custom_body_scripts AS custom_body_scripts_29,
  a1_.meta_title AS meta_title_30,
  a1_.meta_description AS meta_description_31,
  a1_.meta_keywords AS meta_keywords_32,
  a2_.id AS id_33,
  a2_.enable_cdn AS enable_cdn_34,
  a2_.cdn_endpoint AS cdn_endpoint_35,
  a2_.cdn_access_key AS cdn_access_key_36,
  a2_.cdn_secret_key AS cdn_secret_key_37,
  a2_.cdn_bucket AS cdn_bucket_38,
  a2_.cdn_region AS cdn_region_39,
  a2_.cdn_public_url AS cdn_public_url_40,
  a2_.created_at AS created_at_41,
  a2_.updated_at AS updated_at_42,
  a3_.id AS id_43,
  a3_.theme AS theme_44,
  a3_.primary_color AS primary_color_45,
  a3_.secondary_color AS secondary_color_46,
  a3_.debug_mode AS debug_mode_47,
  a3_.allow_registration AS allow_registration_48,
  a3_.require_email_verification AS require_email_verification_49,
  a3_.session_timeout AS session_timeout_50,
  a3_.maintenance_mode AS maintenance_mode_51,
  a3_.github_webhook_secret AS github_webhook_secret_52,
  a3_.github_token AS github_token_53,
  a3_.scheduler_billing_enabled AS scheduler_billing_enabled_54,
  a3_.scheduler_cleanup_enabled AS scheduler_cleanup_enabled_55,
  a3_.scheduler_content_enabled AS scheduler_content_enabled_56,
  a3_.scheduler_data_sync_enabled AS scheduler_data_sync_enabled_57,
  a3_.scheduler_maintenance_enabled AS scheduler_maintenance_enabled_58,
  a3_.login_max_attempts AS login_max_attempts_59,
  a3_.login_lockout_minutes AS login_lockout_minutes_60,
  a3_.admin_alerts AS admin_alerts_61,
  a3_.signup_form_lastname AS signup_form_lastname_62,
  a3_.signup_form_business_name AS signup_form_business_name_63,
  a3_.signup_form_phone AS signup_form_phone_64,
  a3_.signup_form_mobile_phone AS signup_form_mobile_phone_65,
  a3_.signup_form_postcode AS signup_form_postcode_66,
  a3_.signup_form_country AS signup_form_country_67,
  a3_.signup_form_website AS signup_form_website_68,
  a3_.signup_button_text AS signup_button_text_69,
  a3_.after_registration_redirect AS after_registration_redirect_70,
  a3_.terms_conditions_url AS terms_conditions_url_71,
  a3_.privacy_policy_url AS privacy_policy_url_72,
  a3_.cookie_policy_url AS cookie_policy_url_73,
  a3_.user_agreement_url AS user_agreement_url_74,
  a3_.membership_terms_url AS membership_terms_url_75,
  a3_.competition_terms_url AS competition_terms_url_76,
  a3_.ecommerce_terms AS ecommerce_terms_77,
  a3_.current_terms_version AS current_terms_version_78,
  a3_.cleantalk_api_key AS cleantalk_api_key_79,
  a1_.app_settings_id AS app_settings_id_80,
  a2_.app_settings_id AS app_settings_id_81,
  a3_.app_settings_id AS app_settings_id_82
FROM
  app_settings a0_
  LEFT JOIN app_settings_analytics a1_ ON a0_.id = a1_.app_settings_id
  LEFT JOIN app_settings_cdn a2_ ON a0_.id = a2_.app_settings_id
  LEFT JOIN app_settings_system a3_ ON a0_.id = a3_.app_settings_id
LIMIT
  1

SELECT a0_.id AS id_0, a0_.app_name AS app_name_1, a0_.public_url AS public_url_2, a0_.support_email AS support_email_3, a0_.app_description AS app_description_4, a0_.favicon_path AS favicon_path_5, a0_.logo_path AS logo_path_6, a0_.logo_light_path AS logo_light_path_7, a0_.logo_dark_path AS logo_dark_path_8, a0_.logo_square_path AS logo_square_path_9, a0_.login_background_image AS login_background_image_10, a0_.footer_text AS footer_text_11, a0_.maintenance_message AS maintenance_message_12, a0_.company_name AS company_name_13, a0_.company_address AS company_address_14, a0_.company_phone AS company_phone_15, a0_.company_website AS company_website_16, a0_.company_email AS company_email_17, a0_.currency AS currency_18, a0_.timezone AS timezone_19, a0_.created_at AS created_at_20, a0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.enable_matomo AS enable_matomo_23, a1_.matomo_site_url AS matomo_site_url_24, a1_.matomo_site_id AS matomo_site_id_25, a1_.enable_google_analytics AS enable_google_analytics_26, a1_.google_analytics_id AS google_analytics_id_27, a1_.custom_head_scripts AS custom_head_scripts_28, a1_.custom_body_scripts AS custom_body_scripts_29, a1_.meta_title AS meta_title_30, a1_.meta_description AS meta_description_31, a1_.meta_keywords AS meta_keywords_32, a2_.id AS id_33, a2_.enable_cdn AS enable_cdn_34, a2_.cdn_endpoint AS cdn_endpoint_35, a2_.cdn_access_key AS cdn_access_key_36, a2_.cdn_secret_key AS cdn_secret_key_37, a2_.cdn_bucket AS cdn_bucket_38, a2_.cdn_region AS cdn_region_39, a2_.cdn_public_url AS cdn_public_url_40, a2_.created_at AS created_at_41, a2_.updated_at AS updated_at_42, a3_.id AS id_43, a3_.theme AS theme_44, a3_.primary_color AS primary_color_45, a3_.secondary_color AS secondary_color_46, a3_.debug_mode AS debug_mode_47, a3_.allow_registration AS allow_registration_48, a3_.require_email_verification AS require_email_verification_49, a3_.session_timeout AS session_timeout_50, a3_.maintenance_mode AS maintenance_mode_51, a3_.github_webhook_secret AS github_webhook_secret_52, a3_.github_token AS github_token_53, a3_.scheduler_billing_enabled AS scheduler_billing_enabled_54, a3_.scheduler_cleanup_enabled AS scheduler_cleanup_enabled_55, a3_.scheduler_content_enabled AS scheduler_content_enabled_56, a3_.scheduler_data_sync_enabled AS scheduler_data_sync_enabled_57, a3_.scheduler_maintenance_enabled AS scheduler_maintenance_enabled_58, a3_.login_max_attempts AS login_max_attempts_59, a3_.login_lockout_minutes AS login_lockout_minutes_60, a3_.admin_alerts AS admin_alerts_61, a3_.signup_form_lastname AS signup_form_lastname_62, a3_.signup_form_business_name AS signup_form_business_name_63, a3_.signup_form_phone AS signup_form_phone_64, a3_.signup_form_mobile_phone AS signup_form_mobile_phone_65, a3_.signup_form_postcode AS signup_form_postcode_66, a3_.signup_form_country AS signup_form_country_67, a3_.signup_form_website AS signup_form_website_68, a3_.signup_button_text AS signup_button_text_69, a3_.after_registration_redirect AS after_registration_redirect_70, a3_.terms_conditions_url AS terms_conditions_url_71, a3_.privacy_policy_url AS privacy_policy_url_72, a3_.cookie_policy_url AS cookie_policy_url_73, a3_.user_agreement_url AS user_agreement_url_74, a3_.membership_terms_url AS membership_terms_url_75, a3_.competition_terms_url AS competition_terms_url_76, a3_.ecommerce_terms AS ecommerce_terms_77, a3_.current_terms_version AS current_terms_version_78, a3_.cleantalk_api_key AS cleantalk_api_key_79, a1_.app_settings_id AS app_settings_id_80, a2_.app_settings_id AS app_settings_id_81, a3_.app_settings_id AS app_settings_id_82 FROM app_settings a0_ LEFT JOIN app_settings_analytics a1_ ON a0_.id = a1_.app_settings_id LEFT JOIN app_settings_cdn a2_ ON a0_.id = a2_.app_settings_id LEFT JOIN app_settings_system a3_ ON a0_.id = a3_.app_settings_id LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.integration_category AS integration_category_2,
  i0_.type AS type_3,
  i0_.config AS config_4,
  i0_.host AS host_5,
  i0_.port AS port_6,
  i0_.database AS database_7,
  i0_.username AS username_8,
  i0_.password AS password_9,
  i0_.is_active AS is_active_10,
  i0_.created_at AS created_at_11,
  i0_.last_tested_at AS last_tested_at_12,
  i0_.last_test_result AS last_test_result_13,
  i0_.media_base_url AS media_base_url_14,
  i0_.cdn_access_key AS cdn_access_key_15,
  i0_.cdn_secret_key AS cdn_secret_key_16,
  i0_.cdn_region AS cdn_region_17,
  i0_.cdn_bucket AS cdn_bucket_18,
  i0_.is_shared_in_tenant AS is_shared_in_tenant_19,
  i1_.id AS id_20,
  i1_.code AS code_21,
  i1_.name AS name_22,
  i1_.description AS description_23,
  i1_.category AS category_24,
  i1_.logo_url AS logo_url_25,
  i1_.website_url AS website_url_26,
  i1_.config_schema AS config_schema_27,
  i1_.setup_instructions AS setup_instructions_28,
  i1_.is_active AS is_active_29,
  i1_.is_popular AS is_popular_30,
  i1_.is_admin_only AS is_admin_only_31,
  i1_.allow_multiple_instances AS allow_multiple_instances_32,
  i1_.created_at AS created_at_33,
  i1_.updated_at AS updated_at_34,
  i0_.tenant_id AS tenant_id_35,
  i0_.integration_type_id AS integration_type_id_36,
  i0_.user_id AS user_id_37,
  i1_.tenant_id AS tenant_id_38
FROM
  integrations i0_
  LEFT JOIN integration_types i1_ ON i0_.integration_type_id = i1_.id
WHERE
  i1_.code = ?
  AND i0_.tenant_id = ?
  AND i0_.is_active = ?
LIMIT
  1

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.integration_category AS integration_category_2, i0_.type AS type_3, i0_.config AS config_4, i0_.host AS host_5, i0_.port AS port_6, i0_.database AS database_7, i0_.username AS username_8, i0_.password AS password_9, i0_.is_active AS is_active_10, i0_.created_at AS created_at_11, i0_.last_tested_at AS last_tested_at_12, i0_.last_test_result AS last_test_result_13, i0_.media_base_url AS media_base_url_14, i0_.cdn_access_key AS cdn_access_key_15, i0_.cdn_secret_key AS cdn_secret_key_16, i0_.cdn_region AS cdn_region_17, i0_.cdn_bucket AS cdn_bucket_18, i0_.is_shared_in_tenant AS is_shared_in_tenant_19, i1_.id AS id_20, i1_.code AS code_21, i1_.name AS name_22, i1_.description AS description_23, i1_.category AS category_24, i1_.logo_url AS logo_url_25, i1_.website_url AS website_url_26, i1_.config_schema AS config_schema_27, i1_.setup_instructions AS setup_instructions_28, i1_.is_active AS is_active_29, i1_.is_popular AS is_popular_30, i1_.is_admin_only AS is_admin_only_31, i1_.allow_multiple_instances AS allow_multiple_instances_32, i1_.created_at AS created_at_33, i1_.updated_at AS updated_at_34, i0_.tenant_id AS tenant_id_35, i0_.integration_type_id AS integration_type_id_36, i0_.user_id AS user_id_37, i1_.tenant_id AS tenant_id_38 FROM integrations i0_ LEFT JOIN integration_types i1_ ON i0_.integration_type_id = i1_.id WHERE i1_.code = 'aws-s3' AND i0_.tenant_id = 1 AND i0_.is_active = 1 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.domain AS domain_1,
  m0_.base_path AS base_path_2,
  m0_.is_active AS is_active_3,
  m0_.ssl_enabled AS ssl_enabled_4,
  m0_.verification_token AS verification_token_5,
  m0_.is_verified AS is_verified_6,
  m0_.verified_at AS verified_at_7,
  m0_.notes AS notes_8,
  m0_.created_at AS created_at_9,
  m0_.updated_at AS updated_at_10,
  m0_.tenant_id AS tenant_id_11,
  m0_.mobile_app_id AS mobile_app_id_12,
  m0_.registry_id AS registry_id_13
FROM
  mobile_app_domain m0_
WHERE
  m0_.domain = ?
  AND (
    (
      m0_.base_path = ?
      OR m0_.base_path IS NULL
    )
  )
  AND m0_.is_active = ?

SELECT m0_.id AS id_0, m0_.domain AS domain_1, m0_.base_path AS base_path_2, m0_.is_active AS is_active_3, m0_.ssl_enabled AS ssl_enabled_4, m0_.verification_token AS verification_token_5, m0_.is_verified AS is_verified_6, m0_.verified_at AS verified_at_7, m0_.notes AS notes_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.tenant_id AS tenant_id_11, m0_.mobile_app_id AS mobile_app_id_12, m0_.registry_id AS registry_id_13 FROM mobile_app_domain m0_ WHERE m0_.domain = 'dev.evolvepreneuriq.app' AND ((m0_.base_path = '' OR m0_.base_path IS NULL)) AND m0_.is_active = 1;