Query Metrics
2
Database Queries
2
Different statements
1.39 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.97 ms (69.85%) |
1 |
SELECT p0_.id AS id_0, p0_.post_content AS post_content_1, p0_.post_date AS post_date_2, p0_.post_excerpt AS post_excerpt_3, p0_.comment_status AS comment_status_4, p0_.site_type AS site_type_5, p0_.site_img AS site_img_6, p0_.excerpt_limit AS excerpt_limit_7, p0_.extra_css AS extra_css_8, p0_.position AS position_9, p0_.post_status AS post_status_10, p0_.builder AS builder_11, p0_.post_slug AS post_slug_12, p0_.header AS header_13, p0_.footer AS footer_14, p0_.post_gallery AS post_gallery_15, p1_.id AS id_16, p1_.title AS title_17, p1_.description AS description_18, p1_.position AS position_19, p1_.type AS type_20, p1_.cat_img AS cat_img_21, p1_.slug AS slug_22, p1_.category_design AS category_design_23, p1_.post_design AS post_design_24, p1_.post_loop AS post_loop_25, p1_.category_header AS category_header_26, p1_.category_footer AS category_footer_27, p1_.post_header AS post_header_28, p1_.post_footer AS post_footer_29, p1_.created_at AS created_at_30, s2_.id AS id_31, s2_.seo_title AS seo_title_32, s2_.seo_content AS seo_content_33, s2_.no_index AS no_index_34, s2_.no_follow AS no_follow_35, s2_.fb_active AS fb_active_36, s2_.og_type AS og_type_37, s2_.og_title AS og_title_38, s2_.og_content AS og_content_39, s2_.og_image AS og_image_40, s2_.x_active AS x_active_41, s2_.x_type AS x_type_42, s2_.x_site AS x_site_43, s2_.x_creator AS x_creator_44, s2_.fb_app_id AS fb_app_id_45, s2_.fb_admins AS fb_admins_46, s2_.title_prefix AS title_prefix_47, s2_.title_suffix AS title_suffix_48, s2_.title_separator AS title_separator_49, s2_.reading_time AS reading_time_50, s2_.created_at AS created_at_51, s2_.last_update AS last_update_52 FROM post_sites p0_ LEFT JOIN post_category p1_ ON p0_.post_category_id = p1_.id LEFT JOIN site_seo s2_ ON p0_.siteSeo = s2_.id WHERE p0_.post_status = ? ORDER BY p0_.position ASC
Parameters:
[
"publish"
]
|
||||||||||||||||||||||||||||
|
0.42 ms (30.15%) |
1 |
SELECT a0_.id AS id_0, a0_.site_slug AS site_slug_1, a0_.route_name AS route_name_2, a0_.site_content AS site_content_3, a0_.site_date AS site_date_4, a0_.site_excerpt AS site_excerpt_5, a0_.site_status AS site_status_6, a0_.comment_status AS comment_status_7, a0_.site_type AS site_type_8, a0_.site_img AS site_img_9, a0_.site_user AS site_user_10, a0_.site_password AS site_password_11, a0_.excerpt_limit AS excerpt_limit_12, a0_.extra_css AS extra_css_13, a0_.position AS position_14, a0_.header AS header_15, a0_.footer AS footer_16, a0_.builder_active AS builder_active_17, a0_.custom AS custom_18, a0_.form_builder AS form_builder_19, s1_.id AS id_20, s1_.title AS title_21, s1_.description AS description_22, s1_.position AS position_23, s1_.type AS type_24, s1_.cat_img AS cat_img_25, s1_.slug AS slug_26, s1_.created_at AS created_at_27, s2_.id AS id_28, s2_.seo_title AS seo_title_29, s2_.seo_content AS seo_content_30, s2_.no_index AS no_index_31, s2_.no_follow AS no_follow_32, s2_.fb_active AS fb_active_33, s2_.og_type AS og_type_34, s2_.og_title AS og_title_35, s2_.og_content AS og_content_36, s2_.og_image AS og_image_37, s2_.x_active AS x_active_38, s2_.x_type AS x_type_39, s2_.x_site AS x_site_40, s2_.x_creator AS x_creator_41, s2_.fb_app_id AS fb_app_id_42, s2_.fb_admins AS fb_admins_43, s2_.title_prefix AS title_prefix_44, s2_.title_suffix AS title_suffix_45, s2_.title_separator AS title_separator_46, s2_.reading_time AS reading_time_47, s2_.created_at AS created_at_48, s2_.last_update AS last_update_49 FROM app_sites a0_ LEFT JOIN site_category s1_ ON a0_.site_category_id = s1_.id LEFT JOIN site_seo s2_ ON a0_.siteSeo = s2_.id WHERE a0_.site_status = ? AND a0_.site_type = ? ORDER BY a0_.position ASC
Parameters:
[ "publish" "page" ]
|
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\Media | No errors. |
| App\Entity\PostSites |
|
| App\Entity\PostCategory |
|
| App\Entity\SiteSeo | No errors. |
| App\Entity\AppSites |
|
| App\Entity\SiteCategory |
|