Query Metrics
5
Database Queries
4
Different statements
1.68 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 ms |
SELECT t0.id AS id_1, t0.hero_text_line1 AS hero_text_line1_2, t0.hero_text_line2 AS hero_text_line2_3, t0.hero_text_line3 AS hero_text_line3_4, t0.hero_image_key AS hero_image_key_5, t0.hero_video_url AS hero_video_url_6, t0.home_intro_text AS home_intro_text_7, t0.about_text AS about_text_8, t0.about_image_key AS about_image_key_9, t0.before_after_title AS before_after_title_10, t0.before_after_text AS before_after_text_11, t0.before_image_key AS before_image_key_12, t0.after_image_key AS after_image_key_13, t0.email AS email_14, t0.phone AS phone_15, t0.address AS address_16, t0.instagram AS instagram_17, t0.linkedin AS linkedin_18, t0.behance AS behance_19, t0.facebook AS facebook_20, t0.cta_background_image_key AS cta_background_image_key_21, t0.cta_text AS cta_text_22, t0.testimonials_image_key AS testimonials_image_key_23, t0.testimonials_intro_text AS testimonials_intro_text_24, t0.hero_text_line1_en AS hero_text_line1_en_25, t0.hero_text_line2_en AS hero_text_line2_en_26, t0.hero_text_line3_en AS hero_text_line3_en_27, t0.home_intro_text_en AS home_intro_text_en_28, t0.about_text_en AS about_text_en_29, t0.before_after_title_en AS before_after_title_en_30, t0.before_after_text_en AS before_after_text_en_31, t0.cta_text_en AS cta_text_en_32, t0.testimonials_intro_text_en AS testimonials_intro_text_en_33 FROM site_settings t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 2 | 0.48 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.image_key AS image_key_4, p0_.type AS type_5, p0_.title_en AS title_en_6, p0_.description_en AS description_en_7, p0_.type_en AS type_en_8, p0_.year AS year_9, p0_.bg_color AS bg_color_10, p0_.position AS position_11, p0_.is_visible AS is_visible_12, p0_.updated_at AS updated_at_13 FROM project p0_ WHERE p0_.is_visible = 1 ORDER BY p0_.position ASC, p0_.id ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 0.32 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.image_key AS image_key_4, p0_.type AS type_5, p0_.title_en AS title_en_6, p0_.description_en AS description_en_7, p0_.type_en AS type_en_8, p0_.year AS year_9, p0_.bg_color AS bg_color_10, p0_.position AS position_11, p0_.is_visible AS is_visible_12, p0_.updated_at AS updated_at_13 FROM project p0_ WHERE p0_.is_visible = 1 ORDER BY p0_.position ASC, p0_.id ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 4 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.title_en AS title_en_4, t0.description_en AS description_en_5, t0.image_key AS image_key_6, t0.icon_class AS icon_class_7, t0.position AS position_8, t0.is_visible AS is_visible_9, t0.updated_at AS updated_at_10 FROM service t0 WHERE t0.is_visible = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 5 | 0.21 ms |
SELECT t0.id AS id_1, t0.client_name AS client_name_2, t0.client_title AS client_title_3, t0.content AS content_4, t0.client_title_en AS client_title_en_5, t0.content_en AS content_en_6, t0.avatar_key AS avatar_key_7, t0.rating AS rating_8, t0.is_visible AS is_visible_9, t0.position AS position_10, t0.updated_at AS updated_at_11 FROM testimonial t0 WHERE t0.is_visible = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
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\Service | 11 |
| App\Entity\Project | 3 |
| App\Entity\SiteSettings | 1 |
| App\Entity\Testimonial | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SiteSettings | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\ProjectAsset | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Testimonial | No errors. |