Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.sync_flag AS sync_flag_2,
  t0.name AS name_3,
  t0.image AS image_4,
  t0.app_id AS app_id_5,
  t0.owner_id AS owner_id_6,
  t0.stripe_customer_id AS stripe_customer_id_7,
  t0.manage_user_ids AS manage_user_ids_8,
  t0.post_dated_job_active AS post_dated_job_active_9,
  t0.address AS address_10,
  t0.shipping_address AS shipping_address_11,
  t0.billing_address AS billing_address_12,
  t0.motto AS motto_13,
  t0.invoice_footer AS invoice_footer_14,
  t0.general_footer AS general_footer_15,
  t0.company_allowed AS company_allowed_16,
  t0.company_allocated AS company_allocated_17,
  t0.country_id AS country_id_18,
  t0.locale AS locale_19,
  t0.company_remaining AS company_remaining_20,
  t0.user_allowed AS user_allowed_21,
  t0.user_allocated AS user_allocated_22,
  t0.user_remaining AS user_remaining_23,
  t0.admin_user_allowed AS admin_user_allowed_24,
  t0.admin_user_allocated AS admin_user_allocated_25,
  t0.admin_user_remaining AS admin_user_remaining_26,
  t0.contact_number AS contact_number_27,
  t0.email AS email_28,
  t0.db_name AS db_name_29,
  t0.db_pass AS db_pass_30,
  t0.db_user AS db_user_31,
  t0.db_host AS db_host_32,
  t0.company_group_hash AS company_group_hash_33,
  t0.company_group_unique_code AS company_group_unique_code_34,
  t0.enabled_module_id_list AS enabled_module_id_list_35,
  t0.company_group_server_id AS company_group_server_id_36,
  t0.company_group_server_hash AS company_group_server_hash_37,
  t0.company_group_server_address AS company_group_server_address_38,
  t0.company_group_server_port AS company_group_server_port_39,
  t0.company_bin AS company_bin_40,
  t0.company_tin AS company_tin_41,
  t0.company_reg AS company_reg_42,
  t0.company_tl AS company_tl_43,
  t0.initiate_flag AS initiate_flag_44,
  t0.current_server_id AS current_server_id_45,
  t0.current_server_hash AS current_server_hash_46,
  t0.current_server_address AS current_server_address_47,
  t0.current_server_port AS current_server_port_48,
  t0.usage_valid_upto_date AS usage_valid_upto_date_49,
  t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50,
  t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51,
  t0.current_server_domain_full_link AS current_server_domain_full_link_52,
  t0.company_group_billing_info AS company_group_billing_info_53,
  t0.company_group_next_bill_date AS company_group_next_bill_date_54,
  t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55,
  t0.company_group_billing_frequency AS company_group_billing_frequency_56,
  t0.cash AS cash_57,
  t0.sales AS sales_58,
  t0.expense AS expense_59,
  t0.payable AS payable_60,
  t0.net_worth AS net_worth_61,
  t0.monthly_growth AS monthly_growth_62,
  t0.active AS active_63,
  t0.read_only_mode AS read_only_mode_64,
  t0.company_status AS company_status_65,
  t0.package_type AS package_type_66,
  t0.subscription_expiry AS subscription_expiry_67,
  t0.last_activity_at AS last_activity_at_68,
  t0.current_subscription_package_id AS current_subscription_package_id_69,
  t0.subscription_month AS subscription_month_70,
  t0.billing_amount AS billing_amount_71,
  t0.subscription_details AS subscription_details_72,
  t0.company_type AS company_type_73,
  t0.company_description AS company_description_74,
  t0.skip_in_web_flag AS skip_in_web_flag_75,
  t0.skip_in_app_flag AS skip_in_app_flag_76,
  t0.schema_update_pending_flag AS schema_update_pending_flag_77,
  t0.created_at AS created_at_78,
  t0.updated_at AS updated_at_79
FROM
  company_group t0
WHERE
  t0.app_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 WHERE t0.app_id = 51 LIMIT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id IS NULL
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id IS NULL LIMIT 1;

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id = ?
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id = 51 LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

INSERT INTO user_activity_logs (
  user_id, session_id, route, action_type,
  metadata, duration_seconds, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_activity_logs (user_id, session_id, route, action_type, metadata, duration_seconds, created_at, updated_at) VALUES (27, '51317742-b6f7-4c04-a9a6-96c28d1ec92d', '/inventory/inventory', 'page_visit', '{\"route\":\"\\/inventory\\/inventory\",\"page_title\":\"Inventory\",\"page_url\":\"http:\\/\\/172.16.18.15\\/inventory\\/inventory\",\"referrer\":\"http:\\/\\/172.16.18.15\\/inventory_dashboard\",\"session_id\":\"51317742-b6f7-4c04-a9a6-96c28d1ec92d\",\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/150.0.0.0 Safari\\/537.36\",\"visibility_state\":\"visible\",\"tracker\":\"activity_tracker\",\"navigation_reason\":\"initial_load\",\"previous_route\":\"\",\"event\":\"visit\"}', NULL, '2026-08-04 12:14:25', '2026-08-04 12:14:25');

"START TRANSACTION"

"START TRANSACTION";