https://kasscaffolding.thetlb.dev/team

Query Metrics

8 Database Queries
6 Different statements
64.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.21 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
2 57.65 ms
SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.content2 AS content2_9, t0.kicker AS kicker_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.ogImageAlt AS ogImageAlt_16, t0.ogImage AS ogImage_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.image2 AS image2_21, t0.image3 AS image3_22, t0.file AS file_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.update_by AS update_by_26, t0.parent AS parent_27, t0.template_id AS template_id_28, t0.gallery_id AS gallery_id_29 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "team"
  0
  1
]
3 1.40 ms
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM meettheteam m0_ WHERE m0_.deleted = 0 AND m0_.active = 1
Parameters:
[]
4 0.90 ms
SELECT DISTINCT m0_.id AS id_0, m0_.sort_order AS sort_order_1 FROM meettheteam m0_ WHERE m0_.deleted = 0 AND m0_.active = 1 ORDER BY m0_.sort_order ASC LIMIT 9
Parameters:
[]
5 1.30 ms
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.content2 AS content2_2, m0_.telephone AS telephone_3, m0_.email_address AS email_address_4, m0_.linked_in AS linked_in_5, m0_.education AS education_6, m0_.key_skills AS key_skills_7, m0_.professional_interests AS professional_interests_8, m0_.nickname AS nickname_9, m0_.favourite_meal AS favourite_meal_10, m0_.favourite_drink AS favourite_drink_11, m0_.favourite_film AS favourite_film_12, m0_.favourite_band AS favourite_band_13, m0_.featured AS featured_14, m0_.title AS title_15, m0_.content AS content_16, m0_.slug AS slug_17, m0_.meta_title AS meta_title_18, m0_.meta_description AS meta_description_19, m0_.ogImageAlt AS ogImageAlt_20, m0_.ogImage AS ogImage_21, m0_.active AS active_22, m0_.deleted AS deleted_23, m0_.image AS image_24, m0_.image2 AS image2_25, m0_.sort_order AS sort_order_26, m0_.created_at AS created_at_27, m0_.updated_at AS updated_at_28 FROM meettheteam m0_ WHERE m0_.deleted = 0 AND m0_.active = 1 AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.sort_order ASC
Parameters:
[
  1
  2
  5
  4
  7
  9
  3
  6
  8
]
6 0.80 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
Parameters:
[
  10
]
7 0.53 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
Parameters:
[
  10
]
8 0.61 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
Parameters:
[
  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.

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\User No errors.
App\Entity\Templates No errors.
App\Entity\Gallery No errors.
App\Entity\MenuItems No errors.
App\Entity\Slider No errors.
App\Entity\PagePreview No errors.
App\Entity\ImageTextGrid No errors.
App\Entity\TeamMember No errors.
App\Entity\Setting No errors.