https://app.istammergh.org/success?username=Y64EIEOE

Query Metrics

3 Database Queries
3 Different statements
19.49 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.61 ms
(49.32%)
1
SELECT t0.id AS id_4, t0.username AS username_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.gender AS gender_8, t0.dob AS dob_9, t0.contact_number AS contact_number_10, t0.email AS email_11, t0.address AS address_12, t0.city AS city_13, t0.country AS country_14, t0.postal_code AS postal_code_15, t0.roles AS roles_16, t0.password AS password_17, t0.salt AS salt_18, t0.account_status AS account_status_19, t0.is_activated AS is_activated_20, t0.is_verified AS is_verified_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bio AS bio_24, t0.thumbnail AS thumbnail_25, t0.user_type, t1.clinic_name AS clinic_name_26, t1.clinic_address AS clinic_address_27, t1.services AS services_28, t1.ip_address AS ip_address_29, t1.pricing AS pricing_30, t1.longitude AS longitude_31, t1.latitude AS latitude_32, t1.whatsapp_number AS whatsapp_number_33, t1.pricing_plan_id AS pricing_plan_id_34, t2.longitude AS longitude_35, t2.latitude AS latitude_36, t2.whatsapp_number AS whatsapp_number_37 FROM users t0 LEFT JOIN doctor t1 ON t0.id = t1.id LEFT JOIN patient t2 ON t0.id = t2.id LEFT JOIN user_admin t3 ON t0.id = t3.id WHERE t0.username = ? LIMIT 1
Parameters:
[
  "Y64EIEOE"
]
8.94 ms
(45.90%)
1
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.path AS path_3, r0_.position AS position_4, r0_.date_created AS date_created_5, r0_.visibility AS visibility_6, r0_.parent_id AS parent_id_7, r0_.route_name AS route_name_8, r0_.template AS template_9, r0_.layout_type AS layout_type_10, r0_.controller AS controller_11, r0_.content_type AS content_type_12, r0_.controller AS controller_13, r0_.content_type AS content_type_14, r0_.url AS url_15, r0_.permanent AS permanent_16, r0_.route_type AS route_type_17 FROM route r0_ WHERE r0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY r0_.position ASC
Parameters:
[]
0.93 ms
(4.79%)
1
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0
Parameters:
[]

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
Boab\CmsBundle\Entity\Route No errors.
Boab\CmsBundle\Entity\Content No errors.
Boab\CmsBundle\Entity\Event No errors.
Boab\CmsBundle\Entity\Block No errors.
Fbeen\SettingsBundle\Entity\Setting No errors.
Boab\CmsBundle\Entity\ListRoute No errors.
Boab\CmsBundle\Entity\PostRoute No errors.
Boab\CmsBundle\Entity\PageRoute No errors.
Boab\CmsBundle\Entity\TermRoute No errors.
Boab\CmsBundle\Entity\UrlRoute No errors.
Boab\CmsBundle\Entity\User No errors.
App\Entity\Doctor No errors.
App\Entity\Patient No errors.
Boab\CmsBundle\Entity\Admin No errors.
App\Entity\PricingPlan No errors.
Boab\CmsBundle\Entity\Term No errors.
Boab\CmsBundle\Entity\Photo No errors.
Boab\CmsBundle\Entity\Media No errors.
Tchoulom\ViewCounterBundle\Entity\ViewCounter No errors.
Boab\CmsBundle\Entity\ViewCounter No errors.
App\Entity\Appointment No errors.
App\Entity\TimeSlot
  • The association App\Entity\TimeSlot#createdBy refers to the inverse side field Boab\CmsBundle\Entity\User#timeSlots which does not exist.
App\Entity\Specialty No errors.
App\Entity\Review No errors.