GET https://apka.zyrardow.pl/api/sticky

Query Metrics

4 Database Queries
4 Different statements
71.72 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 69.64 ms
SELECT t0.user_id AS user_id_1, t0.user_outside_id AS user_outside_id_2, t0.user_type AS user_type_3, t0.user_api_type AS user_api_type_4, t0.user_login AS user_login_5, t0.user_password AS user_password_6, t0.user_checksum AS user_checksum_7, t0.user_status AS user_status_8, t0.user_token AS user_token_9, t0.user_token_exp AS user_token_exp_10, t0.user_last_login AS user_last_login_11, t0.user_created_at AS user_created_at_12, t0.user_updated_at AS user_updated_at_13, t0.user_deleted_at AS user_deleted_at_14, t0.user_public_approved AS user_public_approved_15, t0.user_public_blocked AS user_public_blocked_16, t0.user_public_app_code AS user_public_app_code_17, t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18, t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19, t0.user_option AS user_option_20, t0.user_public_app_code_hash AS user_public_app_code_hash_21, t0.user_api_setting_sms AS user_api_setting_sms_22, t0.user_api_setting_email AS user_api_setting_email_23, t0.user_api_setting_mobile AS user_api_setting_mobile_24, t0.user_special AS user_special_25, t0.google_authenticator_secret AS google_authenticator_secret_26, t27.user_detail_id AS user_detail_id_28, t27.user_detail_name AS user_detail_name_29, t27.user_detail_surname AS user_detail_surname_30, t27.user_detail_sex AS user_detail_sex_31, t27.user_detail_personal_id_type AS user_detail_personal_id_type_32, t27.user_detail_personal_id AS user_detail_personal_id_33, t27.user_detail_birthday AS user_detail_birthday_34, t27.user_detail_email AS user_detail_email_35, t27.user_detail_phone AS user_detail_phone_36, t27.user_detail_street AS user_detail_street_37, t27.user_detail_street_no AS user_detail_street_no_38, t27.user_detail_post_code AS user_detail_post_code_39, t27.user_detail_state AS user_detail_state_40, t27.user_detail_province AS user_detail_province_41, t27.user_detail_comunity AS user_detail_comunity_42, t27.user_detail_city AS user_detail_city_43, t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44, t27.user_detail_surname_hash AS user_detail_surname_hash_45, t27.user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id WHERE t0.user_login = ? LIMIT 1
Parameters:
[
  "contento"
]
2 0.38 ms
SELECT t0.user_to_role_id AS user_to_role_id_1, t0.read_perm AS read_perm_2, t0.write_perm AS write_perm_3, t0.user_to_role_created_at AS user_to_role_created_at_4, t0.user_to_role_updated_at AS user_to_role_updated_at_5, t0.user_id AS user_id_6, t0.user_role_id AS user_role_id_7 FROM user_to_role t0 WHERE t0.user_id = ?
Parameters:
[
  2
]
3 1.02 ms
SELECT t0.user_mob_device_id AS user_mob_device_id_1, t0.user_mob_device_uuid AS user_mob_device_uuid_2, t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3, t0.user_mob_device_created_at AS user_mob_device_created_at_4, t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5, t0.user_mob_device_default_lang AS user_mob_device_default_lang_6, t0.user_mob_device_sec_token AS user_mob_device_sec_token_7, t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8, t0.user_mob_device_app_version AS user_mob_device_app_version_9, t0.user_mob_device_model AS user_mob_device_model_10, t0.user_mob_device_os AS user_mob_device_os_11, t0.user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0.user_mob_device_uuid = ? AND t0.user_mob_device_sec_token = ? LIMIT 1
Parameters:
[
  "B77DFBB6-91D0-4279-A743-758702F67B63"
  "ddfbcc6f-c8ae-42fb-b8db-5be8e298ec9d-34132613dad844f7e85745aa74744ebb530d762c-916edb70-209b-4b73-ac29-8d3d383de348"
]
4 0.67 ms
SELECT s0_.id AS id_0, s0_.sticky_title AS sticky_title_1, s0_.sticky_message AS sticky_message_2, s0_.sticky_availability AS sticky_availability_3, s0_.sticky_type AS sticky_type_4, s0_.sticky_can_close AS sticky_can_close_5, s0_.sticky_can_permanently_close AS sticky_can_permanently_close_6, s0_.sticky_show_once AS sticky_show_once_7, s0_.sticky_link AS sticky_link_8, s0_.sticky_close_on_link AS sticky_close_on_link_9, s0_.sticky_created_by AS sticky_created_by_10, s0_.sticky_created_at AS sticky_created_at_11, s0_.sticky_updated_by AS sticky_updated_by_12, s0_.sticky_updated_at AS sticky_updated_at_13 FROM sticky s0_ WHERE s0_.sticky_availability >= ? ORDER BY s0_.id DESC, s0_.sticky_availability DESC
Parameters:
[
  1752960104
]

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\User No errors.
App\Entity\UserDetail No errors.
App\Entity\UserToRole No errors.
App\Entity\SendMethod No errors.
App\Entity\Category No errors.
App\Entity\Fault No errors.
App\Entity\UserGroup No errors.
App\Entity\UserMobDevice
  • The mappings App\Entity\UserMobDevice#userMobDeviceConfigs and App\Entity\UserMobDeviceConfig#user_mob_device are inconsistent with each other.
App\Entity\SendQueue No errors.
App\Entity\Notice No errors.
App\Entity\TerytHistory No errors.
App\Entity\Unit No errors.
App\Entity\UserToPartner No errors.
App\Entity\UserToCityCard No errors.
App\Entity\FormData No errors.
App\Entity\UserToStatute No errors.
App\Entity\UserToOutsideSystem No errors.
App\Entity\UserRole No errors.
App\Entity\UserMobDeviceToCategory No errors.
App\Entity\UserMobDeviceToGarbage No errors.
App\Entity\CityCardCode No errors.
App\Entity\UserMobDeviceToken No errors.
App\Entity\UserMobDeviceConfig
  • The association App\Entity\UserMobDeviceConfig#user_mob_device refers to the inverse side field App\Entity\UserMobDevice#userMobDeviceConfig which does not exist.
  • The association App\Entity\UserMobDeviceConfig#key refers to the inverse side field App\Entity\UserMobDeviceConfigKey#userMobDeviceConfig which does not exist.
App\Entity\ContentLikesToUserMobDevice No errors.
App\Entity\Sticky No errors.