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:16:30' 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;

SELECT
  v0_.id AS id_0,
  v0_.description AS description_1,
  v0_.max_weight AS max_weight_2,
  v0_.max_volume AS max_volume_3,
  v0_.max_height AS max_height_4,
  v0_.max_depth AS max_depth_5,
  v0_.max_length AS max_length_6,
  v0_.delivery_agent_payout_per_km AS delivery_agent_payout_per_km_7,
  v0_.shipper_charge_per_km AS shipper_charge_per_km_8,
  v0_.shipper_base_fare AS shipper_base_fare_9,
  v0_.shipper_min_km AS shipper_min_km_10,
  v0_.shipper_cancellation_fee AS shipper_cancellation_fee_11,
  v0_.delivery_agent_base_fare AS delivery_agent_base_fare_12,
  v0_.travel_threshold_km AS travel_threshold_km_13,
  v0_.shipper_travel_charge_per_km AS shipper_travel_charge_per_km_14,
  v0_.shipper_travel_base_fare AS shipper_travel_base_fare_15,
  v0_.delivery_agent_travel_payout_per_km AS delivery_agent_travel_payout_per_km_16,
  v0_.delivery_agent_travel_base_fare AS delivery_agent_travel_base_fare_17,
  v0_.active AS active_18,
  v0_.trip_customer_base_fare AS trip_customer_base_fare_19,
  v0_.trip_customer_per_km AS trip_customer_per_km_20,
  v0_.trip_customer_per_point AS trip_customer_per_point_21,
  v0_.trip_driver_base_fare AS trip_driver_base_fare_22,
  v0_.trip_driver_per_km AS trip_driver_per_km_23,
  v0_.trip_driver_per_point AS trip_driver_per_point_24,
  v0_.trip_driver_min_payout AS trip_driver_min_payout_25,
  v0_.owner_scope AS owner_scope_26,
  v0_.canonical_code AS canonical_code_27,
  v0_.display_order AS display_order_28,
  v0_.app_public_label AS app_public_label_29,
  v0_.app_public_subtitle AS app_public_subtitle_30,
  v0_.app_icon_key AS app_icon_key_31,
  v0_.app_image_path AS app_image_path_32,
  v0_.app_public_visible AS app_public_visible_33,
  v0_.owner_shipper_id AS owner_shipper_id_34
FROM
  vehicle_class v0_
WHERE
  v0_.active = ?
  AND v0_.owner_scope = ?
  AND v0_.owner_shipper_id IS NULL
ORDER BY
  v0_.id ASC

SELECT v0_.id AS id_0, v0_.description AS description_1, v0_.max_weight AS max_weight_2, v0_.max_volume AS max_volume_3, v0_.max_height AS max_height_4, v0_.max_depth AS max_depth_5, v0_.max_length AS max_length_6, v0_.delivery_agent_payout_per_km AS delivery_agent_payout_per_km_7, v0_.shipper_charge_per_km AS shipper_charge_per_km_8, v0_.shipper_base_fare AS shipper_base_fare_9, v0_.shipper_min_km AS shipper_min_km_10, v0_.shipper_cancellation_fee AS shipper_cancellation_fee_11, v0_.delivery_agent_base_fare AS delivery_agent_base_fare_12, v0_.travel_threshold_km AS travel_threshold_km_13, v0_.shipper_travel_charge_per_km AS shipper_travel_charge_per_km_14, v0_.shipper_travel_base_fare AS shipper_travel_base_fare_15, v0_.delivery_agent_travel_payout_per_km AS delivery_agent_travel_payout_per_km_16, v0_.delivery_agent_travel_base_fare AS delivery_agent_travel_base_fare_17, v0_.active AS active_18, v0_.trip_customer_base_fare AS trip_customer_base_fare_19, v0_.trip_customer_per_km AS trip_customer_per_km_20, v0_.trip_customer_per_point AS trip_customer_per_point_21, v0_.trip_driver_base_fare AS trip_driver_base_fare_22, v0_.trip_driver_per_km AS trip_driver_per_km_23, v0_.trip_driver_per_point AS trip_driver_per_point_24, v0_.trip_driver_min_payout AS trip_driver_min_payout_25, v0_.owner_scope AS owner_scope_26, v0_.canonical_code AS canonical_code_27, v0_.display_order AS display_order_28, v0_.app_public_label AS app_public_label_29, v0_.app_public_subtitle AS app_public_subtitle_30, v0_.app_icon_key AS app_icon_key_31, v0_.app_image_path AS app_image_path_32, v0_.app_public_visible AS app_public_visible_33, v0_.owner_shipper_id AS owner_shipper_id_34 FROM vehicle_class v0_ WHERE v0_.active = 1 AND v0_.owner_scope = 'XMOTO' AND v0_.owner_shipper_id IS NULL ORDER BY v0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.plan AS plan_3,
  t0.active AS active_4
FROM
  rate_plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.plan AS plan_3, t0.active AS active_4 FROM rate_plan t0 WHERE t0.id = 1;

SELECT
  r0_.city AS city_0,
  r0_.district AS district_1
FROM
  region r0_
WHERE
  r0_.city IS NOT NULL
  AND TRIM(r0_.city) <> ''

SELECT r0_.city AS city_0, r0_.district AS district_1 FROM region r0_ WHERE r0_.city IS NOT NULL AND TRIM(r0_.city) <> '';

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.district AS district_3,
  t0.type AS type_4,
  t0.route_id AS route_id_5
FROM
  region t0
WHERE
  t0.city = ?
  AND t0.district = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.city AS city_2, t0.district AS district_3, t0.type AS type_4, t0.route_id AS route_id_5 FROM region t0 WHERE t0.city = 'CURITIBA' AND t0.district = 'Sitio Cercado' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.macroregion AS macroregion_2,
  p0_.charge_percentage AS charge_percentage_3,
  p0_.min_charge AS min_charge_4,
  p0_.toll AS toll_5,
  p0_.min_km AS min_km_6,
  p0_.max_km AS max_km_7,
  p0_.region_id AS region_id_8,
  p0_.vehicle_class_id AS vehicle_class_id_9,
  p0_.rate_plan_id AS rate_plan_id_10
FROM
  pricing_rule p0_
WHERE
  p0_.rate_plan_id = ?
  AND p0_.macroregion = ?
  AND p0_.vehicle_class_id = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.macroregion AS macroregion_2, p0_.charge_percentage AS charge_percentage_3, p0_.min_charge AS min_charge_4, p0_.toll AS toll_5, p0_.min_km AS min_km_6, p0_.max_km AS max_km_7, p0_.region_id AS region_id_8, p0_.vehicle_class_id AS vehicle_class_id_9, p0_.rate_plan_id AS rate_plan_id_10 FROM pricing_rule p0_ WHERE p0_.rate_plan_id = 1 AND p0_.macroregion = 'CENTRAL' AND p0_.vehicle_class_id = 1 ORDER BY p0_.id DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.macroregion AS macroregion_2,
  p0_.charge_percentage AS charge_percentage_3,
  p0_.min_charge AS min_charge_4,
  p0_.toll AS toll_5,
  p0_.min_km AS min_km_6,
  p0_.max_km AS max_km_7,
  p0_.region_id AS region_id_8,
  p0_.vehicle_class_id AS vehicle_class_id_9,
  p0_.rate_plan_id AS rate_plan_id_10
FROM
  pricing_rule p0_
WHERE
  p0_.rate_plan_id = ?
  AND p0_.macroregion = ?
  AND p0_.vehicle_class_id IS NULL
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.macroregion AS macroregion_2, p0_.charge_percentage AS charge_percentage_3, p0_.min_charge AS min_charge_4, p0_.toll AS toll_5, p0_.min_km AS min_km_6, p0_.max_km AS max_km_7, p0_.region_id AS region_id_8, p0_.vehicle_class_id AS vehicle_class_id_9, p0_.rate_plan_id AS rate_plan_id_10 FROM pricing_rule p0_ WHERE p0_.rate_plan_id = 1 AND p0_.macroregion = 'CENTRAL' AND p0_.vehicle_class_id IS NULL ORDER BY p0_.id DESC LIMIT 1;