Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Vite
• Configuration

Query Metrics

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.contact_number AS contact_number_3, t0.email AS email_4, t0.flag_email_verified AS flag_email_verified_5, t0.date_create AS date_create_6, t0.metadata AS metadata_7, t0.api_key AS api_key_8, t0.secret_key AS secret_key_9, t0.id AS id_10, t0.username AS username_11, t0.password AS password_12, t0.flag_enabled AS flag_enabled_13 FROM app_user t0 WHERE t0.id = ?

[
  18
]

SELECT
  t0.first_name AS first_name_1,
  t0.last_name AS last_name_2,
  t0.contact_number AS contact_number_3,
  t0.email AS email_4,
  t0.flag_email_verified AS flag_email_verified_5,
  t0.date_create AS date_create_6,
  t0.metadata AS metadata_7,
  t0.api_key AS api_key_8,
  t0.secret_key AS secret_key_9,
  t0.id AS id_10,
  t0.username AS username_11,
  t0.password AS password_12,
  t0.flag_enabled AS flag_enabled_13
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.contact_number AS contact_number_3, t0.email AS email_4, t0.flag_email_verified AS flag_email_verified_5, t0.date_create AS date_create_6, t0.metadata AS metadata_7, t0.api_key AS api_key_8, t0.secret_key AS secret_key_9, t0.id AS id_10, t0.username AS username_11, t0.password AS password_12, t0.flag_enabled AS flag_enabled_13 FROM app_user t0 WHERE t0.id = 18;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acl_attributes AS acl_attributes_4 FROM app_role t0 INNER JOIN app_user_role ON t0.id = app_user_role.role_id WHERE app_user_role.user_id = ?

[
  18
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.acl_attributes AS acl_attributes_4
FROM
  app_role t0
  INNER JOIN app_user_role ON t0.id = app_user_role.role_id
WHERE
  app_user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acl_attributes AS acl_attributes_4 FROM app_role t0 INNER JOIN app_user_role ON t0.id = app_user_role.role_id WHERE app_user_role.user_id = 18;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.address AS address_4, t0.store_type_id AS store_type_id_5, t0.asset_type_id AS asset_type_id_6 FROM store t0 WHERE t0.id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.address AS address_4,
  t0.store_type_id AS store_type_id_5,
  t0.asset_type_id AS asset_type_id_6
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.address AS address_4, t0.store_type_id AS store_type_id_5, t0.asset_type_id AS asset_type_id_6 FROM store t0 WHERE t0.id = '3';

SELECT DISTINCT date_apply, sum(sales_amount) as total_sales, sum(transaction_count) as total_transactions 
            FROM store_hourly_transaction
            WHERE DAYOFWEEK(date_apply) = ?
            AND store_id = ?
            GROUP by date_apply
            ORDER BY date_apply DESC
            LIMIT 6

[
  4
  3
]

SELECT
  DISTINCT date_apply,
  sum(sales_amount) as total_sales,
  sum(transaction_count) as total_transactions
FROM
  store_hourly_transaction
WHERE
  DAYOFWEEK(date_apply) = ?
  AND store_id = ?
GROUP by
  date_apply
ORDER BY
  date_apply DESC
LIMIT
  6

SELECT DISTINCT date_apply, sum(sales_amount) as total_sales, sum(transaction_count) as total_transactions 
            FROM store_hourly_transaction
            WHERE DAYOFWEEK(date_apply) = 4
            AND store_id = 3
            GROUP by date_apply
            ORDER BY date_apply DESC
            LIMIT 6
        ;

SELECT date_apply, hour, sales_amount, transaction_count
            FROM store_hourly_transaction
            WHERE date_apply in (?,?,?,?,?,?)
            AND store_id = ?

[
  "2025-12-03"
  "2025-11-26"
  "2025-11-19"
  "2025-11-12"
  "2025-11-05"
  "2025-10-29"
  3
]

SELECT
  date_apply,
  hour,
  sales_amount,
  transaction_count
FROM
  store_hourly_transaction
WHERE
  date_apply in (?, ?, ?, ?, ?, ?)
  AND store_id = ?

SELECT date_apply, hour, sales_amount, transaction_count
            FROM store_hourly_transaction
            WHERE date_apply in ('2025-12-03','2025-11-26','2025-11-19','2025-11-12','2025-11-05','2025-10-29')
            AND store_id = 3
        ;

SELECT t0.id AS id_1, t0.date_apply AS date_apply_2, t0.employee_rows AS employee_rows_3, t0.manager_rows AS manager_rows_4, t0.projected_sales AS projected_sales_5, t0.percentage_multiplier AS percentage_multiplier_6, t0.is_final AS is_final_7, t0.store_hour_start AS store_hour_start_8, t0.store_hour_end AS store_hour_end_9, t0.store_id AS store_id_10 FROM store_schedule t0 WHERE t0.store_id = ? AND t0.date_apply = ? LIMIT 1

[
  3
  "2025-12-17"
]

SELECT
  t0.id AS id_1,
  t0.date_apply AS date_apply_2,
  t0.employee_rows AS employee_rows_3,
  t0.manager_rows AS manager_rows_4,
  t0.projected_sales AS projected_sales_5,
  t0.percentage_multiplier AS percentage_multiplier_6,
  t0.is_final AS is_final_7,
  t0.store_hour_start AS store_hour_start_8,
  t0.store_hour_end AS store_hour_end_9,
  t0.store_id AS store_id_10
FROM
  store_schedule t0
WHERE
  t0.store_id = ?
  AND t0.date_apply = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_apply AS date_apply_2, t0.employee_rows AS employee_rows_3, t0.manager_rows AS manager_rows_4, t0.projected_sales AS projected_sales_5, t0.percentage_multiplier AS percentage_multiplier_6, t0.is_final AS is_final_7, t0.store_hour_start AS store_hour_start_8, t0.store_hour_end AS store_hour_end_9, t0.store_id AS store_id_10 FROM store_schedule t0 WHERE t0.store_id = 3 AND t0.date_apply = '2025-12-17' LIMIT 1;

SELECT t0.id AS id_1, t0.year AS year_2, t0.jan AS jan_3, t0.feb AS feb_4, t0.mar AS mar_5, t0.apr AS apr_6, t0.may AS may_7, t0.jun AS jun_8, t0.jul AS jul_9, t0.aug AS aug_10, t0.sep AS sep_11, t0.oct AS oct_12, t0.nov AS nov_13, t0.`dec` AS dec_14, t0.store_id AS store_id_15 FROM store_peculiarity t0 WHERE t0.store_id = ? AND t0.year = ? LIMIT 1

[
  3
  "2025"
]

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.jan AS jan_3,
  t0.feb AS feb_4,
  t0.mar AS mar_5,
  t0.apr AS apr_6,
  t0.may AS may_7,
  t0.jun AS jun_8,
  t0.jul AS jul_9,
  t0.aug AS aug_10,
  t0.sep AS sep_11,
  t0.oct AS oct_12,
  t0.nov AS nov_13,
  t0.`dec` AS dec_14,
  t0.store_id AS store_id_15
FROM
  store_peculiarity t0
WHERE
  t0.store_id = ?
  AND t0.year = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.year AS year_2, t0.jan AS jan_3, t0.feb AS feb_4, t0.mar AS mar_5, t0.apr AS apr_6, t0.may AS may_7, t0.jun AS jun_8, t0.jul AS jul_9, t0.aug AS aug_10, t0.sep AS sep_11, t0.oct AS oct_12, t0.nov AS nov_13, t0.`dec` AS dec_14, t0.store_id AS store_id_15 FROM store_peculiarity t0 WHERE t0.store_id = 3 AND t0.year = '2025' LIMIT 1;