Query Metrics

3 Database Queries
3 Different statements
2.76 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.75 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.roles AS roles_3, t0.password AS password_4, t0.verification_status AS verification_status_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user_entity t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "966566405643"
]
2 1.29 ms
SELECT s0_.id AS id_0 FROM store_owner_profile_entity s0_ WHERE s0_.store_owner_id = ?
Parameters:
[
  788
]
3 0.72 ms
SELECT b0_.status AS status_0, s1_.auto_whatsapp_order AS auto_whatsapp_order_1 FROM bot_subscriber_entity b0_ LEFT JOIN store_owner_branch_entity s2_ ON (s2_.id = b0_.store_branch_id) LEFT JOIN store_owner_preference_entity s1_ ON (s1_.store_owner_profile_id = s2_.store_owner_id) WHERE s2_.store_owner_id = ?
Parameters:
[
  361
]

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\UserEntity No errors.
App\Entity\RateEntity
  • The mappings App\Entity\RateEntity#rated and App\Entity\UserEntity#rateEntities are inconsistent with each other.
App\Entity\VerificationEntity No errors.
App\Entity\ResetPasswordOrderEntity No errors.
App\Entity\NotificationFirebaseTokenEntity No errors.
App\Entity\StoreOwnerProfileEntity
  • The mappings App\Entity\StoreOwnerProfileEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerProfile are inconsistent with each other.
App\Entity\BotSubscriberEntity
  • The mappings App\Entity\BotSubscriberEntity#storeCatalog and App\Entity\StoreCatalogEntity#botSubscriber are inconsistent with each other.
App\Entity\StoreOwnerBranchEntity
  • The mappings App\Entity\StoreOwnerBranchEntity#orderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerBranch are inconsistent with each other.
  • The mappings App\Entity\StoreOwnerBranchEntity#cityId and App\Entity\CityEntity#stores are inconsistent with each other.
App\Entity\StoreOwnerPreferenceEntity No errors.