Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Migrations
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT NEXTVAL('source_api_call_id_seq')

[]

SELECT
  NEXTVAL('source_api_call_id_seq')

SELECT NEXTVAL('source_api_call_id_seq');

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO source_api_call (pubid, clickid, visitor_tag, is_test, id, created_at, updated_at, headers, body, ip, path, url, status_code, method, array_response, string_response, request_parameters, query_parameters, input_id, source_id, product_id, input_type_id, subscription_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  null
  null
  null
  0
  679882
  "2025-07-14 14:53:39"
  null
  "{"cache-control":["no-cache"],"connection":["close"],"accept-language":["en-US,en;q=0.9"],"accept":["*\/*"],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/58.0.3029.110 Safari\/537.3"],"accept-encoding":["gzip, deflate"],"host":["dev-sub.fonigames.com"],"x-php-ob-level":["1"]}"
  null
  "185.177.72.37"
  "/api/.env"
  "http://dev-sub.fonigames.com/api/.env"
  200
  "GET"
  null
  null
  "[]"
  "[]"
  null
  null
  null
  null
  null
]

INSERT INTO source_api_call (
  pubid, clickid, visitor_tag, is_test,
  id, created_at, updated_at, headers,
  body, ip, path, url, status_code, method,
  array_response, string_response,
  request_parameters, query_parameters,
  input_id, source_id, product_id,
  input_type_id, subscription_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO source_api_call (pubid, clickid, visitor_tag, is_test, id, created_at, updated_at, headers, body, ip, path, url, status_code, method, array_response, string_response, request_parameters, query_parameters, input_id, source_id, product_id, input_type_id, subscription_id) VALUES (NULL, NULL, NULL, 0, 679882, '2025-07-14 14:53:39', NULL, '{\"cache-control\":[\"no-cache\"],\"connection\":[\"close\"],\"accept-language\":[\"en-US,en;q=0.9\"],\"accept\":[\"*\\/*\"],\"user-agent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/58.0.3029.110 Safari\\/537.3\"],\"accept-encoding\":[\"gzip, deflate\"],\"host\":[\"dev-sub.fonigames.com\"],\"x-php-ob-level\":[\"1\"]}', NULL, '185.177.72.37', '/api/.env', 'http://dev-sub.fonigames.com/api/.env', 200, 'GET', NULL, NULL, '[]', '[]', NULL, NULL, NULL, NULL, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT CURRENT_DATABASE()

[]

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

[
  "sub_phonismart_dev"
]

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'sub_phonismart_dev'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'

[]

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SHOW search_path

[]

SHOW search_path

SHOW search_path;

SELECT CURRENT_DATABASE()

[]

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();