Query Metrics
22
Database Queries
17
Different statements
97.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.93 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_id = ?
Parameters:
[
"1219"
]
|
| 2 | 12.06 ms |
SELECT t0.ms_id AS ms_id_1, t0.ms_type AS ms_type_2, t0.ms_status AS ms_status_3, t0.ms_has_error AS ms_has_error_4, t0.ms_block_db_update AS ms_block_db_update_5, t0.ms_date_sync_ask AS ms_date_sync_ask_6, t0.ms_omt_status AS ms_omt_status_7, t0.ms_omt_has_error AS ms_omt_has_error_8, t0.ms_where_it_comes AS ms_where_it_comes_9, t0.ms_license AS ms_license_10, t0.ms_sync AS ms_sync_11, t0.ms_web_sync AS ms_web_sync_12, t0.ms_push AS ms_push_13, t0.ms_massive_sync AS ms_massive_sync_14 FROM master_sync t0 WHERE t0.ms_license = ? AND t0.ms_type = ? AND t0.ms_status = ?
Parameters:
[ 1219 3 1 ] |
| 3 | 0.27 ms |
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:
[
506
]
|
| 4 | 9.19 ms |
SELECT m0_.ms_id AS ms_id_0, m0_.ms_type AS ms_type_1, m0_.ms_status AS ms_status_2, m0_.ms_has_error AS ms_has_error_3, m0_.ms_block_db_update AS ms_block_db_update_4, m0_.ms_date_sync_ask AS ms_date_sync_ask_5, m0_.ms_omt_status AS ms_omt_status_6, m0_.ms_omt_has_error AS ms_omt_has_error_7, m0_.ms_where_it_comes AS ms_where_it_comes_8, m0_.ms_license AS ms_license_9, m0_.ms_sync AS ms_sync_10, m0_.ms_web_sync AS ms_web_sync_11, m0_.ms_push AS ms_push_12, m0_.ms_massive_sync AS ms_massive_sync_13 FROM master_sync m0_ WHERE 1 = 1 AND m0_.ms_date_sync_ask > ? AND m0_.ms_license = ? AND m0_.ms_status = ? AND m0_.ms_type = ? ORDER BY m0_.ms_date_sync_ask DESC LIMIT 4
Parameters:
[ "2026-04-03 14:47:50" 1219 5 1 ] |
| 5 | 0.23 ms |
SELECT t0.rf_id AS rf_id_1, t0.rf_name_file AS rf_name_file_2, t0.rf_status AS rf_status_3, t0.rf_date_sinc_ask AS rf_date_sinc_ask_4, t0.rf_date_upload AS rf_date_upload_5, t0.rf_name_file_deliver AS rf_name_file_deliver_6, t0.rf_date_delivered AS rf_date_delivered_7, t0.rf_isreaded_server AS rf_isreaded_server_8, t0.rf_application_mode AS rf_application_mode_9, t0.rf_has_error AS rf_has_error_10, t0.rf_obtained_error AS rf_obtained_error_11, t0.rf_file_in_s3_uri AS rf_file_in_s3_uri_12, t0.rf_file_response_in_s3_uri AS rf_file_response_in_s3_uri_13, t0.rf_license_id AS rf_license_id_14 FROM read_files_data t0 WHERE t0.rf_id = ?
Parameters:
[
3921964
]
|
| 6 | 0.20 ms |
SELECT t0.rf_id AS rf_id_1, t0.rf_name_file AS rf_name_file_2, t0.rf_status AS rf_status_3, t0.rf_date_sinc_ask AS rf_date_sinc_ask_4, t0.rf_date_upload AS rf_date_upload_5, t0.rf_name_file_deliver AS rf_name_file_deliver_6, t0.rf_date_delivered AS rf_date_delivered_7, t0.rf_isreaded_server AS rf_isreaded_server_8, t0.rf_application_mode AS rf_application_mode_9, t0.rf_has_error AS rf_has_error_10, t0.rf_obtained_error AS rf_obtained_error_11, t0.rf_file_in_s3_uri AS rf_file_in_s3_uri_12, t0.rf_file_response_in_s3_uri AS rf_file_response_in_s3_uri_13, t0.rf_license_id AS rf_license_id_14 FROM read_files_data t0 WHERE t0.rf_id = ?
Parameters:
[
3921961
]
|
| 7 | 0.19 ms |
SELECT t0.rf_id AS rf_id_1, t0.rf_name_file AS rf_name_file_2, t0.rf_status AS rf_status_3, t0.rf_date_sinc_ask AS rf_date_sinc_ask_4, t0.rf_date_upload AS rf_date_upload_5, t0.rf_name_file_deliver AS rf_name_file_deliver_6, t0.rf_date_delivered AS rf_date_delivered_7, t0.rf_isreaded_server AS rf_isreaded_server_8, t0.rf_application_mode AS rf_application_mode_9, t0.rf_has_error AS rf_has_error_10, t0.rf_obtained_error AS rf_obtained_error_11, t0.rf_file_in_s3_uri AS rf_file_in_s3_uri_12, t0.rf_file_response_in_s3_uri AS rf_file_response_in_s3_uri_13, t0.rf_license_id AS rf_license_id_14 FROM read_files_data t0 WHERE t0.rf_id = ?
Parameters:
[
3921960
]
|
| 8 | 0.18 ms |
SELECT t0.rf_id AS rf_id_1, t0.rf_name_file AS rf_name_file_2, t0.rf_status AS rf_status_3, t0.rf_date_sinc_ask AS rf_date_sinc_ask_4, t0.rf_date_upload AS rf_date_upload_5, t0.rf_name_file_deliver AS rf_name_file_deliver_6, t0.rf_date_delivered AS rf_date_delivered_7, t0.rf_isreaded_server AS rf_isreaded_server_8, t0.rf_application_mode AS rf_application_mode_9, t0.rf_has_error AS rf_has_error_10, t0.rf_obtained_error AS rf_obtained_error_11, t0.rf_file_in_s3_uri AS rf_file_in_s3_uri_12, t0.rf_file_response_in_s3_uri AS rf_file_response_in_s3_uri_13, t0.rf_license_id AS rf_license_id_14 FROM read_files_data t0 WHERE t0.rf_id = ?
Parameters:
[
3921958
]
|
| 9 | 9.31 ms |
SELECT m0_.ms_id AS ms_id_0, m0_.ms_type AS ms_type_1, m0_.ms_status AS ms_status_2, m0_.ms_has_error AS ms_has_error_3, m0_.ms_block_db_update AS ms_block_db_update_4, m0_.ms_date_sync_ask AS ms_date_sync_ask_5, m0_.ms_omt_status AS ms_omt_status_6, m0_.ms_omt_has_error AS ms_omt_has_error_7, m0_.ms_where_it_comes AS ms_where_it_comes_8, m0_.ms_license AS ms_license_9, m0_.ms_sync AS ms_sync_10, m0_.ms_web_sync AS ms_web_sync_11, m0_.ms_push AS ms_push_12, m0_.ms_massive_sync AS ms_massive_sync_13 FROM master_sync m0_ WHERE m0_.ms_license = ? AND m0_.ms_status < ? AND m0_.ms_sync IS NOT NULL
Parameters:
[ 1219 5 ] |
| 10 | 0.23 ms |
SELECT MAX(r0_.rf_id) AS sclr_0 FROM read_files_data r0_ WHERE r0_.rf_license_id = ?
Parameters:
[
"1219"
]
|
| 11 | 0.22 ms |
SELECT t0.rf_id AS rf_id_1, t0.rf_name_file AS rf_name_file_2, t0.rf_status AS rf_status_3, t0.rf_date_sinc_ask AS rf_date_sinc_ask_4, t0.rf_date_upload AS rf_date_upload_5, t0.rf_name_file_deliver AS rf_name_file_deliver_6, t0.rf_date_delivered AS rf_date_delivered_7, t0.rf_isreaded_server AS rf_isreaded_server_8, t0.rf_application_mode AS rf_application_mode_9, t0.rf_has_error AS rf_has_error_10, t0.rf_obtained_error AS rf_obtained_error_11, t0.rf_file_in_s3_uri AS rf_file_in_s3_uri_12, t0.rf_file_response_in_s3_uri AS rf_file_response_in_s3_uri_13, t0.rf_license_id AS rf_license_id_14 FROM read_files_data t0 WHERE t0.rf_id = ? AND t0.rf_isreaded_server = ? AND t0.rf_has_error = ? AND t0.rf_status = ?
Parameters:
[ "3921964" 1 0 1 ] |
| 12 | 55.03 ms |
SELECT t0.ps_id AS ps_id_1, t0.ps_sent_date AS ps_sent_date_2, t0.ps_verification_code AS ps_verification_code_3, t0.ps_respond_date AS ps_respond_date_4, t0.ps_status AS ps_status_5, t0.ps_type AS ps_type_6, t0.ps_application_mode AS ps_application_mode_7, t0.ps_data AS ps_data_8, t0.ps_is_resend AS ps_is_resend_9, t0.ps_resend_date AS ps_resend_date_10, t0.ps_first_by AS ps_first_by_11, t0.ps_asked_response AS ps_asked_response_12, t0.ps_error_email AS ps_error_email_13, t0.ps_reset_completed AS ps_reset_completed_14, t0.ps_curl_send_date AS ps_curl_send_date_15, t0.ps_data_for_curl AS ps_data_for_curl_16, t0.ps_data_for_curl_response AS ps_data_for_curl_response_17, t0.ps_curl_updated_date AS ps_curl_updated_date_18, t0.ps_curl_status AS ps_curl_status_19, t0.ps_curl_type AS ps_curl_type_20, t0.ps_curl_omt_resend_counter AS ps_curl_omt_resend_counter_21, t0.ps_curl_resend_date AS ps_curl_resend_date_22, t0.ps_is_testing_push AS ps_is_testing_push_23, t0.ps_new_sended_stage AS ps_new_sended_stage_24, t0.ps_license AS ps_license_25, t0.ps_sub_license AS ps_sub_license_26 FROM push_sent t0 WHERE t0.ps_license = ? ORDER BY t0.ps_sent_date DESC LIMIT 1
Parameters:
[
1219
]
|
| 13 | 0.42 ms |
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 = '6ST6RGGFiqtNYwI8'
Parameters:
[] |
| 14 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 15 | 0.38 ms |
INSERT INTO push_sent (ps_sent_date, ps_verification_code, ps_respond_date, ps_status, ps_type, ps_application_mode, ps_data, ps_is_resend, ps_resend_date, ps_first_by, ps_asked_response, ps_error_email, ps_reset_completed, ps_curl_send_date, ps_data_for_curl, ps_data_for_curl_response, ps_curl_updated_date, ps_curl_status, ps_curl_type, ps_curl_omt_resend_counter, ps_curl_resend_date, ps_is_testing_push, ps_new_sended_stage, ps_license, ps_sub_license) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-04 13:34:26" "6ST6RGGFiqtNYwI8" null 1 1 0 null 0 null null null null null null null null null null null 0 null 0 1 1219 null ] |
| 16 | 3.67 ms |
"COMMIT"
Parameters:
[] |
| 17 | 0.30 ms |
SELECT t0.ps_id AS ps_id_1, t0.ps_sent_date AS ps_sent_date_2, t0.ps_verification_code AS ps_verification_code_3, t0.ps_respond_date AS ps_respond_date_4, t0.ps_status AS ps_status_5, t0.ps_type AS ps_type_6, t0.ps_application_mode AS ps_application_mode_7, t0.ps_data AS ps_data_8, t0.ps_is_resend AS ps_is_resend_9, t0.ps_resend_date AS ps_resend_date_10, t0.ps_first_by AS ps_first_by_11, t0.ps_asked_response AS ps_asked_response_12, t0.ps_error_email AS ps_error_email_13, t0.ps_reset_completed AS ps_reset_completed_14, t0.ps_curl_send_date AS ps_curl_send_date_15, t0.ps_data_for_curl AS ps_data_for_curl_16, t0.ps_data_for_curl_response AS ps_data_for_curl_response_17, t0.ps_curl_updated_date AS ps_curl_updated_date_18, t0.ps_curl_status AS ps_curl_status_19, t0.ps_curl_type AS ps_curl_type_20, t0.ps_curl_omt_resend_counter AS ps_curl_omt_resend_counter_21, t0.ps_curl_resend_date AS ps_curl_resend_date_22, t0.ps_is_testing_push AS ps_is_testing_push_23, t0.ps_new_sended_stage AS ps_new_sended_stage_24, t0.ps_license AS ps_license_25, t0.ps_sub_license AS ps_sub_license_26 FROM push_sent t0 WHERE t0.ps_verification_code = ?
Parameters:
[
"6ST6RGGFiqtNYwI8"
]
|
| 18 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
| 19 | 0.26 ms |
UPDATE push_sent SET ps_data = ? WHERE ps_id = ?
Parameters:
[ "{"data":"{\"status\":200,\"actions\":\"updatedb\",\"uploadurl\":\"https:\\\/\\\/licensor.levelpos.com\\\/ws\\\/uploadSyncService\",\"code\":\"6ST6RGGFiqtNYwI8\"}","status":200}" 7178890 ] |
| 20 | 3.10 ms |
"COMMIT"
Parameters:
[] |
| 21 | 0.25 ms |
SELECT t0.ps_id AS ps_id_1, t0.ps_sent_date AS ps_sent_date_2, t0.ps_verification_code AS ps_verification_code_3, t0.ps_respond_date AS ps_respond_date_4, t0.ps_status AS ps_status_5, t0.ps_type AS ps_type_6, t0.ps_application_mode AS ps_application_mode_7, t0.ps_data AS ps_data_8, t0.ps_is_resend AS ps_is_resend_9, t0.ps_resend_date AS ps_resend_date_10, t0.ps_first_by AS ps_first_by_11, t0.ps_asked_response AS ps_asked_response_12, t0.ps_error_email AS ps_error_email_13, t0.ps_reset_completed AS ps_reset_completed_14, t0.ps_curl_send_date AS ps_curl_send_date_15, t0.ps_data_for_curl AS ps_data_for_curl_16, t0.ps_data_for_curl_response AS ps_data_for_curl_response_17, t0.ps_curl_updated_date AS ps_curl_updated_date_18, t0.ps_curl_status AS ps_curl_status_19, t0.ps_curl_type AS ps_curl_type_20, t0.ps_curl_omt_resend_counter AS ps_curl_omt_resend_counter_21, t0.ps_curl_resend_date AS ps_curl_resend_date_22, t0.ps_is_testing_push AS ps_is_testing_push_23, t0.ps_new_sended_stage AS ps_new_sended_stage_24, t0.ps_license AS ps_license_25, t0.ps_sub_license AS ps_sub_license_26 FROM push_sent t0 WHERE t0.ps_verification_code = ? LIMIT 1
Parameters:
[
"6ST6RGGFiqtNYwI8"
]
|
| 22 | 0.42 ms |
SELECT t0_.tpar_id AS tpar_id_0, t0_.tpar_api_url AS tpar_api_url_1, t0_.tpar_api_name AS tpar_api_name_2, t0_.tpar_pusher_key AS tpar_pusher_key_3, t0_.tpar_pusher_app_id AS tpar_pusher_app_id_4, t0_.tpar_pusher_secret AS tpar_pusher_secret_5, t0_.tpar_pusher_cluster AS tpar_pusher_cluster_6, t0_.tpar_pushy_account_key AS tpar_pushy_account_key_7, t0_.tpar_twilio_auth_token AS tpar_twilio_auth_token_8, t0_.tpar_account_sid AS tpar_account_sid_9, t0_.tpar_whitelabel_package_name AS tpar_whitelabel_package_name_10, t0_.tpar_cloud_package_name AS tpar_cloud_package_name_11 FROM third_party_api_records t0_ WHERE t0_.tpar_license_id = ? AND (t0_.tpar_api_name LIKE ? OR t0_.tpar_api_name LIKE ?)
Parameters:
[ 1219 "pusher" "pushy" ] |
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\MasterSync | No errors. |
| App\Entity\ReadFilesData | No errors. |
| App\Entity\ReadFilesDataWeb | No errors. |
| App\Entity\PushSent | No errors. |
| App\Entity\FileSyncData | No errors. |
| App\Entity\SubLicense | No errors. |
| App\Entity\State | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Partner | No errors. |
| App\Entity\Timezone | No errors. |
| App\Entity\ThirdPartyAPIRecords | No errors. |