Query Metrics
4
Database Queries
4
Different statements
3.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.31 ms (72.18%) |
1 |
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 IN (?)
Parameters:
[
"stumblei_193"
]
|
|
0.34 ms (10.66%) |
1 |
SELECT p0_.ps_sent_date AS ps_sent_date_0, p0_.ps_id AS ps_id_1, p0_.ps_verification_code AS ps_verification_code_2, p0_.ps_respond_date AS ps_respond_date_3, p0_.ps_type AS ps_type_4, p0_.ps_status AS ps_status_5, a1_.al_id AS al_id_6 FROM push_sent p0_ INNER JOIN account_license a1_ ON (p0_.ps_license = a1_.al_id) WHERE p0_.ps_verification_code = 'LhIyqupBXkLutSjA'
Parameters:
[] |
|
0.29 ms (8.92%) |
1 |
SELECT t0.ac_id AS ac_id_1, t0.ac_name AS ac_name_2, t0.ac_legal_name AS ac_legal_name_3, t0.ac_nick_name AS ac_nick_name_4, t0.ac_phone_number AS ac_phone_number_5, t0.ac_email AS ac_email_6, t0.ac_contact_name AS ac_contact_name_7, t0.ac_date_created AS ac_date_created_8, t0.ac_suit_po_box AS ac_suit_po_box_9, t0.ac_address AS ac_address_10, t0.ac_address_public AS ac_address_public_11, t0.ac_deleted AS ac_deleted_12, t0.omt_sync AS omt_sync_13, t0.ac_ein_number AS ac_ein_number_14, t0.ac_suite AS ac_suite_15, t0.ac_number_locations AS ac_number_locations_16, t0.ac_internal_notes AS ac_internal_notes_17, t0.ac_corporate_type_business AS ac_corporate_type_business_18, t0.ac_is_lead_account AS ac_is_lead_account_19, t0.ac_account_quote AS ac_account_quote_20, t0.ac_is_testing AS ac_is_testing_21, t0.ac_user AS ac_user_22, t0.ac_city_id AS ac_city_id_23, t0.ac_zip_code_id AS ac_zip_code_id_24, t0.company AS company_25 FROM account t0 WHERE t0.ac_id = ?
Parameters:
[
32
]
|
|
0.26 ms (8.23%) |
1 |
SELECT t0.sl_is AS sl_is_1, t0.sl_name AS sl_name_2, t0.sl_device_uid AS sl_device_uid_3, t0.sl_android_vname AS sl_android_vname_4, t0.sl_pushy_key AS sl_pushy_key_5, t0.sl_real_name AS sl_real_name_6, t0.al_android_ip AS al_android_ip_7, t0.al_times_checked_ip AS al_times_checked_ip_8, t0.sl_license AS sl_license_9 FROM sub_license t0 WHERE t0.sl_name = ?
Parameters:
[
"stumblei_193"
]
|
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\SubLicense | No errors. |
| App\Entity\PushSent | No errors. |
| App\Entity\Partner | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\State | No errors. |
| App\Entity\Timezone | No errors. |