Query Metrics

9 Database Queries
6 Different statements
2.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.20 ms
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"
]
2 0.29 ms
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
]
3 0.30 ms
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
]
4 0.29 ms
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"
]
5 0.29 ms
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"
]
6 0.28 ms
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"
]
7 0.32 ms
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"
]
8 0.28 ms
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"
]
9 0.25 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.prefix_code AS prefix_code_2, v0_.voucher_type AS voucher_type_3, v0_.am_value AS am_value_4, v0_.vat_rate AS vat_rate_5, v0_.handling_fee AS handling_fee_6, v0_.currency_code AS currency_code_7, v0_.deadline AS deadline_8, v0_.name_in_cart AS name_in_cart_9, v0_.description_in_cart AS description_in_cart_10, v0_.description AS description_11, v0_.template_name AS template_name_12, v0_.qr_code_redirect_type AS qr_code_redirect_type_13, v0_.for_sale AS for_sale_14, v0_.sale_image AS sale_image_15, v0_.refinement AS refinement_16, v0_.individual_vouchers_limit AS individual_vouchers_limit_17, v0_.reusable_voucher_usage_limit AS reusable_voucher_usage_limit_18, v0_.recommendation_voucher_recommendations_number AS recommendation_voucher_recommendations_number_19, v0_.recommendation_voucher_all_recommendations_required AS recommendation_voucher_all_recommendations_required_20, v0_.background_image AS background_image_21, v0_.front_image AS front_image_22, v0_.back_image AS back_image_23, v0_.id_contract_lead_config AS id_contract_lead_config_24, v0_.id_target_package AS id_target_package_25, v0_.id_added_by_user AS id_added_by_user_26 FROM voucher_package v0_ WHERE v0_.id_added_by_user = ? AND v0_.voucher_type = ? AND v0_.for_sale = 1 ORDER BY v0_.am_value ASC
Parameters:
[
  23
  1
]

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.

Entities Mapping

Class Mapping errors
App\Modules\User\Entity\User No errors.
App\Admin\Modules\User\Entity\UserAdmin No errors.
App\Admin\Modules\Voucher\Entity\VoucherPackageVoucher No errors.
App\Admin\Modules\Partner\Entity\UserPartner No errors.
App\Admin\SuperAdmin\Modules\Trader\Entity\UserTrader No errors.
App\Admin\Modules\Contract\Entity\UserContractTrader No errors.
App\Admin\Modules\Contract\Entity\UserContractSubstantiveDepartmentEmployee No errors.
App\Admin\Modules\AmountVoucherSettings\Entity\AmountVoucherSettings No errors.
App\Admin\Modules\Voucher\Entity\VoucherPackage No errors.
App\Admin\Modules\AmountVoucherSettings\Entity\AmountVoucherSettingsAmount No errors.
App\Admin\Modules\Contract\Entity\ContractLeadConfig No errors.
App\Modules\User\Entity\UserSettings No errors.
App\Admin\Modules\Voucher\Entity\VoucherPackageVoucherNote No errors.
App\Modules\VoucherCart\Entity\VoucherOrderVoucher No errors.
App\Admin\Modules\Store\Entity\StoreOrder No errors.
App\Modules\TicketCart\Entity\TicketOrderTicket No errors.
App\Admin\Modules\Contract\Entity\Contract No errors.
App\Admin\Modules\Contract\Entity\ContractLead No errors.
App\Admin\Modules\MeetingScheduler\Entity\Meeting No errors.
App\Modules\RecommendationVoucherForm\Entity\RecommendationVoucherForm No errors.
App\Admin\Modules\Contract\Entity\ContractLeadConfigParam No errors.
App\Admin\Modules\Contract\Entity\ContractLeadConfigFlag No errors.
App\Modules\VoucherCart\Entity\VoucherOrder No errors.
App\Admin\Modules\Store\Entity\StoreOrderProduct No errors.
App\Modules\TicketCart\Entity\TicketOrder No errors.
App\Admin\Modules\Contract\Entity\ContractTemplate No errors.
App\Admin\Modules\Contract\Entity\ContractDocumentsSet No errors.
App\Admin\Modules\Contract\Entity\ContractClient No errors.
App\Admin\Modules\Contract\Entity\ContractInstallment No errors.
App\Admin\Modules\Contract\Entity\ContractTasksDepartment No errors.
App\Admin\Modules\Contract\Entity\ContractLeadParam No errors.
App\Admin\Modules\MeetingScheduler\Entity\MeetingCategory No errors.
App\Modules\RecommendationVoucherForm\Entity\RecommendationVoucherFormField No errors.