Query Metrics

7 Database Queries
5 Different statements
1.83 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.75 ms
(41.04%)
3
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.api_key AS api_key_4, u0_.api_auth_token AS api_auth_token_5, u0_.selected_lang AS selected_lang_6, u0_.type AS type_7, u0_.system_id AS system_id_8, u0_.is_active AS is_active_9, u0_.added_at AS added_at_10, u0_.id_voucher_package_voucher AS id_voucher_package_voucher_11 FROM user u0_ INNER JOIN user_admin u1_ ON u0_.id = u1_.id_user WHERE u0_.type = ? AND u0_.is_active = 1 AND u1_.alias = ?
Parameters:
[
  2
  "celis"
]
0.32 ms
(17.30%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.prefix_code AS prefix_code_3, t0.voucher_type AS voucher_type_4, t0.am_value AS am_value_5, t0.vat_rate AS vat_rate_6, t0.handling_fee AS handling_fee_7, t0.currency_code AS currency_code_8, t0.deadline AS deadline_9, t0.name_in_cart AS name_in_cart_10, t0.description_in_cart AS description_in_cart_11, t0.description AS description_12, t0.template_name AS template_name_13, t0.qr_code_redirect_type AS qr_code_redirect_type_14, t0.for_sale AS for_sale_15, t0.sale_image AS sale_image_16, t0.refinement AS refinement_17, t0.individual_vouchers_limit AS individual_vouchers_limit_18, t0.reusable_voucher_usage_limit AS reusable_voucher_usage_limit_19, t0.recommendation_voucher_recommendations_number AS recommendation_voucher_recommendations_number_20, t0.recommendation_voucher_all_recommendations_required AS recommendation_voucher_all_recommendations_required_21, t0.background_image AS background_image_22, t0.front_image AS front_image_23, t0.back_image AS back_image_24, t0.id_contract_lead_config AS id_contract_lead_config_25, t0.id_target_package AS id_target_package_26, t0.id_added_by_user AS id_added_by_user_27 FROM voucher_package t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
0.26 ms
(14.40%)
1
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.alias AS alias_3, t0.tin AS tin_4, t0.phone AS phone_5, t0.logo AS logo_6, t0.active_modules AS active_modules_7, t0.max_partner_count AS max_partner_count_8, t0.available_voucher_count AS available_voucher_count_9, t0.id_user AS id_user_10 FROM user_admin t0 WHERE t0.id_user = ?
Parameters:
[
  23
]
0.25 ms
(13.90%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.delivery AS delivery_3, t0.terms AS terms_4, t0.id_admin_user AS id_admin_user_5, t0.id_voucher_package AS id_voucher_package_6 FROM amount_voucher_settings t0 WHERE t0.id_admin_user = ? LIMIT 1
Parameters:
[
  23
]
0.24 ms
(13.36%)
1
SELECT u0_.name AS name_0, u0_.value AS value_1, u0_.id_user AS id_user_2 FROM user_settings u0_ WHERE u0_.id_user = ? AND u0_.name = ?
Parameters:
[
  23
  "iframes.settings"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.