GET https://www.school.quicksellsbd.com/people

Query Metrics

4 Database Queries
4 Different statements
3.91 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.05 ms
(26.82%)
1
SELECT t0_.id AS id_0, t0_.teacher_id AS teacher_id_1, t0_.name AS name_2, t0_.phone AS phone_3, t0_.email AS email_4, t0_.gender AS gender_5, t0_.date_of_birth AS date_of_birth_6, t0_.joining_date AS joining_date_7, t0_.qualification AS qualification_8, t0_.designation AS designation_9, t0_.address AS address_10, t0_.photo AS photo_11, t0_.specialization AS specialization_12, t0_.salary AS salary_13, t0_.status AS status_14, t0_.created_by AS created_by_15, t0_.created_time AS created_time_16, t0_.updated_by AS updated_by_17, t0_.updated_time AS updated_time_18, t0_.company_id AS company_id_19, t0_.user_id AS user_id_20 FROM teacher t0_ WHERE t0_.company_id = ? AND t0_.status = 1 ORDER BY t0_.name ASC
Parameters:
[
  1
]
1.02 ms
(25.96%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.logo AS logo_3, c0_.expiry_date AS expiry_date_4, c0_.status AS status_5, c0_.subdomain AS subdomain_6, c0_.name_bn AS name_bn_7, c0_.contact_mobile AS contact_mobile_8, c0_.contact_phone AS contact_phone_9, c0_.contact_email AS contact_email_10, c0_.module AS module_11, c0_.go_code AS go_code_12, c0_.sms_end_point AS sms_end_point_13, c0_.sms_api_key AS sms_api_key_14, c0_.sms_sender_id AS sms_sender_id_15, c0_.api_vendor AS api_vendor_16 FROM companies c0_ WHERE c0_.status = 1 AND c0_.module IN (?, ?) ORDER BY c0_.id ASC LIMIT 1
Parameters:
[
  "education"
  "school"
]
0.97 ms
(24.92%)
1
SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type IN (?, ?, ?, ?, ?, ?) ORDER BY w0_.type ASC, w0_.id ASC
Parameters:
[
  1
  1
  2
  3
  4
  5
  6
  7
]
0.87 ms
(22.31%)
1
SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 40
Parameters:
[
  1
  1
  10
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Website\WebsitePost 5
App\Entity\Companies 1

Entities Mapping

Class Mapping errors
App\Entity\Companies No errors.
App\Entity\Website\WebsitePost No errors.
App\Entity\Education\Teacher\Teacher No errors.
App\Entity\User No errors.