Query Metrics
7
Database Queries
7
Different statements
8.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.44 ms (17.41%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.content2 AS content2_3, t0.telephone AS telephone_4, t0.email_address AS email_address_5, t0.linked_in AS linked_in_6, t0.education AS education_7, t0.key_skills AS key_skills_8, t0.professional_interests AS professional_interests_9, t0.nickname AS nickname_10, t0.favourite_meal AS favourite_meal_11, t0.favourite_drink AS favourite_drink_12, t0.favourite_film AS favourite_film_13, t0.favourite_band AS favourite_band_14, t0.featured AS featured_15, t0.title AS title_16, t0.content AS content_17, t0.slug AS slug_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.ogImageAlt AS ogImageAlt_21, t0.ogImage AS ogImage_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.image AS image_25, t0.image2 AS image2_26, t0.sort_order AS sort_order_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM meettheteam t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"kirsty-wood"
]
|
|
1.37 ms (16.53%) |
1 |
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/kirsty-wood" 0 1 ] |
|
1.34 ms (16.18%) |
1 |
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
Parameters:
[] |
|
1.17 ms (14.21%) |
1 |
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_.active = 1 AND m0_.deleted = 0) AND m0_.sort_order >= ? AND m0_.id <> ? ORDER BY m0_.sort_order ASC LIMIT 1
Parameters:
[ 7 3 ] |
|
1.09 ms (13.13%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.content2 AS content2_3, t0.telephone AS telephone_4, t0.email_address AS email_address_5, t0.linked_in AS linked_in_6, t0.education AS education_7, t0.key_skills AS key_skills_8, t0.professional_interests AS professional_interests_9, t0.nickname AS nickname_10, t0.favourite_meal AS favourite_meal_11, t0.favourite_drink AS favourite_drink_12, t0.favourite_film AS favourite_film_13, t0.favourite_band AS favourite_band_14, t0.featured AS featured_15, t0.title AS title_16, t0.content AS content_17, t0.slug AS slug_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.ogImageAlt AS ogImageAlt_21, t0.ogImage AS ogImage_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.image AS image_25, t0.image2 AS image2_26, t0.sort_order AS sort_order_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM meettheteam t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[ "kirsty-wood" 0 1 ] |
|
1.01 ms (12.17%) |
1 |
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_.active = 1 AND m0_.deleted = 0) AND m0_.sort_order <= ? AND m0_.id <> ? ORDER BY m0_.sort_order DESC LIMIT 1
Parameters:
[ 7 3 ] |
|
0.86 ms (10.37%) |
1 |
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
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 |
|---|---|
| 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. |