GET https://www.badnii.com/ar/partner/expert/notifications/unread-count

Response
200 OK
Browse referrer URL
IP
5.36.200.146
Profiled on
Token
1b3cdc

Query Metrics

5 Database Queries
5 Different statements
2.32 ms Query time
9 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.78 ms 
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.phone_verified AS phone_verified_11, t0.otp_code AS otp_code_12, t0.otp_expires_at AS otp_expires_at_13, t0.otp_attempts AS otp_attempts_14, t0.gender AS gender_15, t0.preferred_unit AS preferred_unit_16, t0.current_weight AS current_weight_17, t0.target_weight AS target_weight_18, t0.height AS height_19, t0.password AS password_20, t0.last_seen AS last_seen_21, t0.country AS country_22, t0.city AS city_23, t0.date_of_birth AS date_of_birth_24, t0.avatar AS avatar_25, t0.description AS description_26, t0.description_ar AS description_ar_27, t0.is_approved AS is_approved_28, t0.is_available_for_request AS is_available_for_request_29, t0.accepted_terms AS accepted_terms_30, t0.reset_token AS reset_token_31, t0.reset_token_expires_at AS reset_token_expires_at_32, t0.facebook_id AS facebook_id_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.role_id AS role_id_36, t0.physical_activity_id AS physical_activity_id_37, t0.diet_goal_id AS diet_goal_id_38, t0.custom_role_id AS custom_role_id_39 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.58 ms 
SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (?)
Parameters: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.35 ms 
SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (?)
Parameters: 
[
  107
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.25 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.type AS type_4 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.35 ms 
SELECT COUNT(*) FROM notification t0 WHERE t0.user_id = ? AND t0.is_read = ?
Parameters: 
[
  107
  0
]
View formatted query    View runnable query    Explain query    View query backtrace

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
  • The mappings App\Entity\User#role and App\Entity\Role#users are inconsistent with each other.
  • The field App\Entity\User#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#user does not contain the required 'inversedBy="orders"' attribute.
  • The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which is not defined as association, but as field.
  • The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which does not exist.
App\Entity\Role
  • The association App\Entity\Role#users refers to the owning side field App\Entity\User#Role which does not exist.
App\Entity\PhysicalActivity No errors.
App\Entity\dietGoal No errors.
App\Entity\CustomRole No errors.
App\Entity\MealCategory
  • The association App\Entity\MealCategory#requests refers to the owning side field App\Entity\Request#mealCategories which does not exist.
App\Entity\MasterMenuItem No errors.
App\Entity\ProductCategory No errors.
App\Entity\Program
  • The mappings App\Entity\Program#programCategories and App\Entity\ProgramCategory#programs are inconsistent with each other.
  • If association App\Entity\Program#programCategories is many-to-many, then the inversed side App\Entity\ProgramCategory#programs has to be many-to-many as well.
  • The field App\Entity\Program#programPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProgramPrice#program does not contain the required 'inversedBy="programPrices"' attribute.
  • The field App\Entity\Program#restaurantProgramPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RestaurantProgramPrice#program does not contain the required 'inversedBy="restaurantProgramPrices"' attribute.
  • The mappings App\Entity\Program#programDiets and App\Entity\ProgramDiet#programs are inconsistent with each other.
  • If association App\Entity\Program#programDiets is many-to-many, then the inversed side App\Entity\ProgramDiet#programs has to be many-to-many as well.
App\Entity\Rate
  • The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Embeddable\AddressSnapshot No errors.
App\Entity\Order
  • The field 'App\Entity\Order#subtotalProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#programPriceMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#restaurantPriceMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#subtotalProgramRestaurantMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#adminFeeExclusiveMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#discountProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#deliveryFeeProgramRestMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#grandTotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Request No errors.
App\Entity\Message
  • The mappings App\Entity\Message#sentBy and App\Entity\User#messages are inconsistent with each other.
App\Entity\ProfileSetting No errors.
App\Entity\RateFood No errors.
App\Entity\Cart
  • The field 'App\Entity\Cart#productsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#subscriptionsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#discountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#deliveryFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#totalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Favorite No errors.
App\Entity\CollectionList No errors.
App\Entity\RecuringFood No errors.
App\Entity\Chat No errors.
App\Entity\Adresse No errors.
App\Entity\Coupon
  • The field 'App\Entity\Coupon#discountValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Coupon#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#coupon does not contain the required 'inversedBy="carts"' attribute.
  • The association App\Entity\Coupon#orders refers to the owning side field App\Entity\Order#coupon which does not exist.
App\Entity\Notification No errors.
App\Entity\UserDocument No errors.
App\Entity\Faq No errors.
App\Entity\Testimonial No errors.