Query Metrics
4
Database Queries
4
Different statements
21.71 ms
Query time
0
Invalid entities
12
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.44 ms (34.26%) |
1 |
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.alt AS alt_2, c0_.caption_title AS caption_title_3, c0_.caption AS caption_4, c0_.url AS url_5, c0_.is_published AS is_published_6, c0_.modified AS modified_7, c0_.created AS created_8, c0_.order_by AS order_by_9, c0_.page AS page_10, c0_.brand AS brand_11, c0_.link AS link_12, c0_.display_rule AS display_rule_13, c0_.is_video AS is_video_14 FROM carousel c0_ WHERE c0_.is_published = ? AND c0_.page = ? ORDER BY c0_.order_by ASC
Parameters:
[ 1 "Home" ]
|
||||||||||||||||||||||||||||
|
5.71 ms (26.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.website AS website_4, t0.description AS description_5, t0.order_by AS order_by_6, t0.modified AS modified_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.api_name AS api_name_10, t0.is_menu AS is_menu_11, t0.has_otc AS has_otc_12, t0.has_published AS has_published_13, t0.banner_lg AS banner_lg_14, t0.banner_sm AS banner_sm_15, t0.featured_items AS featured_items_16, t0.video AS video_17, t0.meta_title_landing AS meta_title_landing_18, t0.meta_description_landing AS meta_description_landing_19, t0.meta_title_search AS meta_title_search_20, t0.meta_description_search AS meta_description_search_21 FROM brands t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
5.24 ms (24.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.is_published = ? AND t0.is_meta_data = ? AND t0.title = ? LIMIT 1
Parameters:
[ 1 1 "Home Page" ]
|
||||||||||||||||||||||||||||
|
3.32 ms (15.31%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.copy AS copy_4, t0.publish_date AS publish_date_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.modified AS modified_9, t0.created AS created_10, t0.alt AS alt_11, t0.is_home_page AS is_home_page_12, t0.home_image AS home_image_13, t0.home_image_alt AS home_image_alt_14, t0.home_title AS home_title_15, t0.excerpt_length AS excerpt_length_16, t0.url AS url_17 FROM blogs t0 WHERE t0.is_published = ? AND t0.is_home_page = ? LIMIT 1
Parameters:
[ 1 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\Brands | 6 |
| App\Entity\Carousel | 4 |
| App\Entity\Pages | 1 |
| App\Entity\Blogs | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Pages | No errors. |
| App\Entity\Accordion | No errors. |
| App\Entity\Carousel | No errors. |
| App\Entity\Brands | No errors. |
| App\Entity\Items | No errors. |
| App\Entity\BrandIcons | No errors. |
| App\Entity\BrandsCategories | No errors. |
| App\Entity\Blogs | No errors. |
| App\Entity\BlogCategories | No errors. |