Symfony Profiler

SELECT
  1
FROM
  customer_portal_session
LIMIT
  1

SELECT 1 FROM customer_portal_session LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.token_hash AS token_hash_1,
  c0_.issued_at AS issued_at_2,
  c0_.expires_at AS expires_at_3,
  c0_.revoked_at AS revoked_at_4,
  c0_.last_seen_at AS last_seen_at_5,
  c0_.ip_address AS ip_address_6,
  c0_.user_agent AS user_agent_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c1_.id AS id_10,
  c1_.email AS email_11,
  c1_.name AS name_12,
  c1_.phone_number AS phone_number_13,
  c1_.terms_accepted_at AS terms_accepted_at_14,
  c1_.terms_version AS terms_version_15,
  c1_.created_channel AS created_channel_16,
  c1_.password_hash AS password_hash_17,
  c1_.active AS active_18,
  c1_.api_token_hash AS api_token_hash_19,
  c1_.api_token_issued_at AS api_token_issued_at_20,
  c1_.api_token_expires_at AS api_token_expires_at_21,
  c1_.last_login_at AS last_login_at_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  s2_.id AS id_25,
  s2_.cnpj AS cnpj_26,
  s2_.company_name AS company_name_27,
  s2_.address AS address_28,
  s2_.district AS district_29,
  s2_.city AS city_30,
  s2_.zip_code AS zip_code_31,
  s2_.lat_lng AS lat_lng_32,
  s2_.email AS email_33,
  s2_.phone_number AS phone_number_34,
  s2_.person_type AS person_type_35,
  s2_.document_type AS document_type_36,
  s2_.document_digits AS document_digits_37,
  s2_.legal_name AS legal_name_38,
  s2_.trade_name AS trade_name_39,
  s2_.contact_name AS contact_name_40,
  s2_.contact_phone AS contact_phone_41,
  s2_.customer_origin AS customer_origin_42,
  s2_.customer_relationship AS customer_relationship_43,
  s2_.customer_status AS customer_status_44,
  s2_.registration_channel AS registration_channel_45,
  s2_.self_registered_at AS self_registered_at_46,
  s2_.review_status AS review_status_47,
  s2_.reviewed_at AS reviewed_at_48,
  s2_.reviewed_by AS reviewed_by_49,
  s2_.duplicate_of_shipper_id AS duplicate_of_shipper_id_50,
  s2_.blocked_reason AS blocked_reason_51,
  s2_.daily_control_applicable AS daily_control_applicable_52,
  s2_.charge_method AS charge_method_53,
  s2_.active AS active_54,
  s2_.rate_adjustment_percent AS rate_adjustment_percent_55,
  s2_.auto_assign_open_delivery_on_email_import AS auto_assign_open_delivery_on_email_import_56,
  s2_.uses_scheduled_routing_base AS uses_scheduled_routing_base_57,
  s2_.scheduled_routing_cutoff_time AS scheduled_routing_cutoff_time_58,
  s2_.scheduled_routing_use_ai AS scheduled_routing_use_ai_59,
  s2_.scheduled_base_daily_control_visibility AS scheduled_base_daily_control_visibility_60,
  s2_.operational_routing_policy AS operational_routing_policy_61,
  s2_.direct_auto_routing_window_minutes AS direct_auto_routing_window_minutes_62,
  s2_.direct_auto_routing_auto_approve AS direct_auto_routing_auto_approve_63,
  s2_.customer_portal_route_experience AS customer_portal_route_experience_64,
  s2_.customer_portal_feature_profile AS customer_portal_feature_profile_65,
  s2_.customer_default_order_responsibility AS customer_default_order_responsibility_66,
  s2_.route_grouping_policy AS route_grouping_policy_67,
  s2_.route_customer_financial_scope_override AS route_customer_financial_scope_override_68,
  s2_.fixed_post_enabled AS fixed_post_enabled_69,
  s2_.fixed_post_required_headcount AS fixed_post_required_headcount_70,
  s2_.fixed_post_shift_start_time AS fixed_post_shift_start_time_71,
  c0_.customer_user_id AS customer_user_id_72,
  c1_.shipper_id AS shipper_id_73,
  s2_.carrier_id AS carrier_id_74,
  s2_.rate_plan_id AS rate_plan_id_75
FROM
  customer_portal_session c0_
  INNER JOIN customer_user c1_ ON c0_.customer_user_id = c1_.id
  INNER JOIN shipper s2_ ON c1_.shipper_id = s2_.id
WHERE
  c0_.token_hash = ?
  AND c0_.revoked_at IS NULL
  AND c0_.expires_at > ?
  AND c1_.active = ?
  AND s2_.active = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.token_hash AS token_hash_1, c0_.issued_at AS issued_at_2, c0_.expires_at AS expires_at_3, c0_.revoked_at AS revoked_at_4, c0_.last_seen_at AS last_seen_at_5, c0_.ip_address AS ip_address_6, c0_.user_agent AS user_agent_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.email AS email_11, c1_.name AS name_12, c1_.phone_number AS phone_number_13, c1_.terms_accepted_at AS terms_accepted_at_14, c1_.terms_version AS terms_version_15, c1_.created_channel AS created_channel_16, c1_.password_hash AS password_hash_17, c1_.active AS active_18, c1_.api_token_hash AS api_token_hash_19, c1_.api_token_issued_at AS api_token_issued_at_20, c1_.api_token_expires_at AS api_token_expires_at_21, c1_.last_login_at AS last_login_at_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, s2_.id AS id_25, s2_.cnpj AS cnpj_26, s2_.company_name AS company_name_27, s2_.address AS address_28, s2_.district AS district_29, s2_.city AS city_30, s2_.zip_code AS zip_code_31, s2_.lat_lng AS lat_lng_32, s2_.email AS email_33, s2_.phone_number AS phone_number_34, s2_.person_type AS person_type_35, s2_.document_type AS document_type_36, s2_.document_digits AS document_digits_37, s2_.legal_name AS legal_name_38, s2_.trade_name AS trade_name_39, s2_.contact_name AS contact_name_40, s2_.contact_phone AS contact_phone_41, s2_.customer_origin AS customer_origin_42, s2_.customer_relationship AS customer_relationship_43, s2_.customer_status AS customer_status_44, s2_.registration_channel AS registration_channel_45, s2_.self_registered_at AS self_registered_at_46, s2_.review_status AS review_status_47, s2_.reviewed_at AS reviewed_at_48, s2_.reviewed_by AS reviewed_by_49, s2_.duplicate_of_shipper_id AS duplicate_of_shipper_id_50, s2_.blocked_reason AS blocked_reason_51, s2_.daily_control_applicable AS daily_control_applicable_52, s2_.charge_method AS charge_method_53, s2_.active AS active_54, s2_.rate_adjustment_percent AS rate_adjustment_percent_55, s2_.auto_assign_open_delivery_on_email_import AS auto_assign_open_delivery_on_email_import_56, s2_.uses_scheduled_routing_base AS uses_scheduled_routing_base_57, s2_.scheduled_routing_cutoff_time AS scheduled_routing_cutoff_time_58, s2_.scheduled_routing_use_ai AS scheduled_routing_use_ai_59, s2_.scheduled_base_daily_control_visibility AS scheduled_base_daily_control_visibility_60, s2_.operational_routing_policy AS operational_routing_policy_61, s2_.direct_auto_routing_window_minutes AS direct_auto_routing_window_minutes_62, s2_.direct_auto_routing_auto_approve AS direct_auto_routing_auto_approve_63, s2_.customer_portal_route_experience AS customer_portal_route_experience_64, s2_.customer_portal_feature_profile AS customer_portal_feature_profile_65, s2_.customer_default_order_responsibility AS customer_default_order_responsibility_66, s2_.route_grouping_policy AS route_grouping_policy_67, s2_.route_customer_financial_scope_override AS route_customer_financial_scope_override_68, s2_.fixed_post_enabled AS fixed_post_enabled_69, s2_.fixed_post_required_headcount AS fixed_post_required_headcount_70, s2_.fixed_post_shift_start_time AS fixed_post_shift_start_time_71, c0_.customer_user_id AS customer_user_id_72, c1_.shipper_id AS shipper_id_73, s2_.carrier_id AS carrier_id_74, s2_.rate_plan_id AS rate_plan_id_75 FROM customer_portal_session c0_ INNER JOIN customer_user c1_ ON c0_.customer_user_id = c1_.id INNER JOIN shipper s2_ ON c1_.shipper_id = s2_.id WHERE c0_.token_hash = '17caf743104e674f045fb8c9c966351739b1423b3b6b0d7afc69fbeb6fb9aafb' AND c0_.revoked_at IS NULL AND c0_.expires_at > '2026-07-02 17:27:53' AND c1_.active = 1 AND s2_.active = 1 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 = 'app'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;