http://licensor.levelpos.com/app_dev.php/ws/OMT/verificarServicesAndBrand

Method
POST
HTTP Status
200
IP
172.18.0.3
Profiled on
Token
14766f

Query Metrics

2 Database Queries
2 Different statements
2.00 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.72 ms 
SELECT t0.al_id AS al_id_1, t0.al_restaurant_name AS al_restaurant_name_2, t0.al_date_created AS al_date_created_3, t0.al_license_status AS al_license_status_4, t0.al_license_username AS al_license_username_5, t0.al_contac_name AS al_contac_name_6, t0.al_license_email AS al_license_email_7, t0.al_addres AS al_addres_8, t0.al_suit_po_box AS al_suit_po_box_9, t0.al_longitude AS al_longitude_10, t0.al_latitude AS al_latitude_11, t0.al_phone_number AS al_phone_number_12, t0.al_license_key AS al_license_key_13, t0.al_has_android AS al_has_android_14, t0.al_android_vname AS al_android_vname_15, t0.al_device_uid AS al_device_uid_16, t0.al_is_callcenter AS al_is_callcenter_17, t0.al_pushy_key AS al_pushy_key_18, t0.al_gcm_key AS al_gcm_key_19, t0.al_is_testing AS al_is_testing_20, t0.al_is_demo AS al_is_demo_21, t0.al_android_ip AS al_android_ip_22, t0.al_times_checked_ip AS al_times_checked_ip_23, t0.al_apk_install_code AS al_apk_install_code_24, t0.al_has_loged_omt AS al_has_loged_omt_25, t0.al_type_test_license AS al_type_test_license_26, t0.auth_seed AS auth_seed_27, t0.is_plus_license AS is_plus_license_28, t0.al_consecutive_android_drying AS al_consecutive_android_drying_29, t0.al_last_s3_dbupload AS al_last_s3_dbupload_30, t0.al_last_auto_cleanse_date AS al_last_auto_cleanse_date_31, t0.al_last_duplicated_invoice_check AS al_last_duplicated_invoice_check_32, t0.al_last_timeclock_out_check AS al_last_timeclock_out_check_33, t0.al_last_device_expiration_check AS al_last_device_expiration_check_34, t0.al_zipcodes_are_needed AS al_zipcodes_are_needed_35, t0.has_level_zero AS has_level_zero_36, t0.al_level_zero_percentage AS al_level_zero_percentage_37, t0.al_has_cash_discount AS al_has_cash_discount_38, t0.al_cash_discount_percentage AS al_cash_discount_percentage_39, t0.al_level_zero_gateway_percentage AS al_level_zero_gateway_percentage_40, t0.omt_sync AS omt_sync_41, t0.al_android_database_size AS al_android_database_size_42, t0.al_is_level_light AS al_is_level_light_43, t0.al_levellight_user AS al_levellight_user_44, t0.al_last_s3_web_dbupload AS al_last_s3_web_dbupload_45, t0.al_last_logued_device_kind AS al_last_logued_device_kind_46, t0.al_service_prices_already_run AS al_service_prices_already_run_47, t0.al_nonsynced_brandservice AS al_nonsynced_brandservice_48, t0.al_lastCleanseLeftDays AS al_lastCleanseLeftDays_49, t0.al_registaction_already_cleaned AS al_registaction_already_cleaned_50, t0.al_updated_date AS al_updated_date_51, t0.al_consecutive_android_drying_second_stage AS al_consecutive_android_drying_second_stage_52, t0.al_last_login_was_ok AS al_last_login_was_ok_53, t0.al_last_login_date AS al_last_login_date_54, t0.al_last_validated_login_date AS al_last_validated_login_date_55, t0.al_last_cleaning_of_licensor_database AS al_last_cleaning_of_licensor_database_56, t0.al_schedule_menu_checked AS al_schedule_menu_checked_57, t0.al_active_zipcodes AS al_active_zipcodes_58, t0.al_time_zone_restaurant AS al_time_zone_restaurant_59, t0.al_checked_delete_notify AS al_checked_delete_notify_60, t0.al_checked_scanned_dir AS al_checked_scanned_dir_61, t0.al_copy_menu_of_restaurant AS al_copy_menu_of_restaurant_62, t0.al_menu_copy_done AS al_menu_copy_done_63, t0.al_is_franquise AS al_is_franquise_64, t0.al_login_type AS al_login_type_65, t0.al_public_address AS al_public_address_66, t0.al_consecutive_record_checked AS al_consecutive_record_checked_67, t0.al_single_menu_sizes_checked AS al_single_menu_sizes_checked_68, t0.al_user_property_and_roles_checked AS al_user_property_and_roles_checked_69, t0.al_sync_record_checked AS al_sync_record_checked_70, t0.al_lic_parasite AS al_lic_parasite_71, t0.al_licensor_cleanse_checked AS al_licensor_cleanse_checked_72, t0.al_last_resync_cleanse_checked AS al_last_resync_cleanse_checked_73, t0.al_send_allowed_autocleanse AS al_send_allowed_autocleanse_74, t0.al_date_created_cleaning_configuration AS al_date_created_cleaning_configuration_75, t0.al_record_quantity_for_cleaning AS al_record_quantity_for_cleaning_76, t0.al_duplicated_regist_action_checking AS al_duplicated_regist_action_checking_77, t0.al_duplicated_regist_action_free AS al_duplicated_regist_action_free_78, t0.al_duplicated_registaction_check AS al_duplicated_registaction_check_79, t0.al_last_update_of_database_size AS al_last_update_of_database_size_80, t0.al_consecutive_android_drying_third_stage AS al_consecutive_android_drying_third_stage_81, t0.al_last_quantity_cleanse_update AS al_last_quantity_cleanse_update_82, t0.al_locked_by_infinite_sync AS al_locked_by_infinite_sync_83, t0.al_number_syncdata_records AS al_number_syncdata_records_84, t0.conf_status_stock AS conf_status_stock_85, t0.default_customer_checked AS default_customer_checked_86, t0.no_data_file_flag AS no_data_file_flag_87, t0.payment_gateway AS payment_gateway_88, t0.time_to_next_epx_batch AS time_to_next_epx_batch_89, t0.aws_push_endpoint AS aws_push_endpoint_90, t0.aws_topic_arn AS aws_topic_arn_91, t0.aws_subscription_arn AS aws_subscription_arn_92, t0.aws_device_token AS aws_device_token_93, t0.al_itemized_card_price AS al_itemized_card_price_94, t0.al_missmatch_invoice_check_running AS al_missmatch_invoice_check_running_95, t0.mismmatch_invoices_checked_until AS mismmatch_invoices_checked_until_96, t0.checked_prices_by_levelzero_status_date AS checked_prices_by_levelzero_status_date_97, t0.checked_prices_by_levelzero_status AS checked_prices_by_levelzero_status_98, t0.pusher_own_verification_token AS pusher_own_verification_token_99, t0.pusher_verified AS pusher_verified_100, t0.ws_resource_id AS ws_resource_id_101, t0.ws_resource_id_verified AS ws_resource_id_verified_102, t0.cloud_package_name AS cloud_package_name_103, t0.whitelabel_package_name AS whitelabel_package_name_104, t0.al_nonprocedent_registaction_check AS al_nonprocedent_registaction_check_105, t0.al_last_nonprocedent_cleanse_update AS al_last_nonprocedent_cleanse_update_106, t0.al_last_cleaned_nonprocedent_registaction AS al_last_cleaned_nonprocedent_registaction_107, t0.al_database_update_date AS al_database_update_date_108, t0.al_place_id AS al_place_id_109, t0.al_owner_status AS al_owner_status_110, t0.dbugflag_forceinfiniteloop AS dbugflag_forceinfiniteloop_111, t0.fix_needs_one_updaown_sync AS fix_needs_one_updaown_sync_112, t0.al_captive_portal_status AS al_captive_portal_status_113, t0.omada_controller_id AS omada_controller_id_114, t0.operator_name AS operator_name_115, t0.operator_pass AS operator_pass_116, t0.portal_redirection_url AS portal_redirection_url_117, t0.allowed_navigation_time AS allowed_navigation_time_118, t0.omada_port AS omada_port_119, t0.in_house_delivery_status AS in_house_delivery_status_120, t0.al_date_paid AS al_date_paid_121, t0.al_date_unpaid AS al_date_unpaid_122, t0.al_last_daterelease AS al_last_daterelease_123, t0.al_giftcard_status AS al_giftcard_status_124, t0.al_has_active_caller_id AS al_has_active_caller_id_125, t0.al_type_price_discount AS al_type_price_discount_126, t0.al_last_execute_stock_command AS al_last_execute_stock_command_127, t0.al_tax_exempt AS al_tax_exempt_128, t0.al_user_creator_id AS al_user_creator_id_129, t0.al_account_license_id AS al_account_license_id_130, t0.al_zip_code_id AS al_zip_code_id_131, t0.al_city_id AS al_city_id_132, t0.al_company_id AS al_company_id_133 FROM account_license t0 WHERE t0.al_license_username = ?
Parameters: 
[
  "potheads_1221"
]
View formatted query    View runnable query    Explain query
2 0.28 ms 
SELECT t0.lida_id AS lida_id_1, t0.lida_dbhost AS lida_dbhost_2, t0.lida_dbname AS lida_dbname_3, t0.lida_dbuser AS lida_dbuser_4, t0.lida_dbpass AS lida_dbpass_5, t0.lida_database_created AS lida_database_created_6, t0.lida_schema_created AS lida_schema_created_7, t0.lida_initial_insert_done AS lida_initial_insert_done_8, t0.lida_initial_data_configured AS lida_initial_data_configured_9, t0.lida_has_error AS lida_has_error_10, t0.lida_date_cron_last_schema AS lida_date_cron_last_schema_11, t0.lida_date_cron_last_procedure AS lida_date_cron_last_procedure_12, t0.lida_license_id AS lida_license_id_13 FROM license_database t0 WHERE t0.lida_license_id = ?
Parameters: 
[
  1221
]
View formatted query    View runnable query    Explain query

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\Entity\AccountLicense No errors.
App\Entity\User No errors.
App\Entity\Account No errors.
App\Entity\Zipcode No errors.
App\Entity\City No errors.
App\Entity\Company No errors.
App\Entity\LicenseDataBase No errors.