https://heavenwavesmedia.com/posts

Query Metrics

5 Database Queries
5 Different statements
7.38 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.44 ms
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0
Parameters:
[]
2 0.31 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.path AS path_3, r0_.position AS position_4, r0_.date_created AS date_created_5, r0_.visibility AS visibility_6, r0_.parent_id AS parent_id_7, r0_.route_name AS route_name_8, r0_.template AS template_9, r0_.layout_type AS layout_type_10, r0_.controller AS controller_11, r0_.content_type AS content_type_12, r0_.controller AS controller_13, r0_.content_type AS content_type_14, r0_.url AS url_15, r0_.permanent AS permanent_16, r0_.route_type AS route_type_17 FROM route r0_ WHERE r0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY r0_.position ASC
Parameters:
[]
3 4.73 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_created_13 FROM (SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.thumbnail AS thumbnail_6, c0_.status AS status_7, c0_.is_featured AS is_featured_8, c0_.promoted AS promoted_9, c0_.publish_on_socialmedia AS publish_on_socialmedia_10, c0_.is_published_social_media AS is_published_social_media_11, c0_.is_home AS is_home_12, c0_.date_created AS date_created_13, c0_.date_published AS date_published_14, c0_.meta_keywords AS meta_keywords_15, c0_.meta_description AS meta_description_16, c0_.updated_at AS updated_at_17, c0_.position AS position_18, c0_.views AS views_19, u1_.id AS id_20, u1_.username AS username_21, u1_.firstname AS firstname_22, u1_.lastname AS lastname_23, u1_.gender AS gender_24, u1_.dob AS dob_25, u1_.contact_number AS contact_number_26, u1_.email AS email_27, u1_.address AS address_28, u1_.city AS city_29, u1_.country AS country_30, u1_.postal_code AS postal_code_31, u1_.roles AS roles_32, u1_.password AS password_33, u1_.salt AS salt_34, u1_.account_status AS account_status_35, u1_.is_activated AS is_activated_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.thumbnail AS thumbnail_39, c0_.content_type AS content_type_40, u1_.user_type AS user_type_41 FROM article a3_ INNER JOIN contents c0_ ON a3_.id = c0_.id LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN user_admin u2_ ON u1_.id = u2_.id WHERE c0_.status = ?) dctrn_result_inner ORDER BY date_created_13 DESC) dctrn_result LIMIT 10
Parameters:
[
  "published"
]
4 0.64 ms
SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.thumbnail AS thumbnail_6, c0_.status AS status_7, c0_.is_featured AS is_featured_8, c0_.promoted AS promoted_9, c0_.publish_on_socialmedia AS publish_on_socialmedia_10, c0_.is_published_social_media AS is_published_social_media_11, c0_.is_home AS is_home_12, c0_.date_created AS date_created_13, c0_.date_published AS date_published_14, c0_.meta_keywords AS meta_keywords_15, c0_.meta_description AS meta_description_16, c0_.updated_at AS updated_at_17, c0_.position AS position_18, c0_.views AS views_19, u1_.id AS id_20, u1_.username AS username_21, u1_.firstname AS firstname_22, u1_.lastname AS lastname_23, u1_.gender AS gender_24, u1_.dob AS dob_25, u1_.contact_number AS contact_number_26, u1_.email AS email_27, u1_.address AS address_28, u1_.city AS city_29, u1_.country AS country_30, u1_.postal_code AS postal_code_31, u1_.roles AS roles_32, u1_.password AS password_33, u1_.salt AS salt_34, u1_.account_status AS account_status_35, u1_.is_activated AS is_activated_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.thumbnail AS thumbnail_39, c0_.content_type AS content_type_40, c0_.user_id AS user_id_41, c0_.term_id AS term_id_42, u1_.user_type AS user_type_43 FROM article a3_ INNER JOIN contents c0_ ON a3_.id = c0_.id LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN user_admin u2_ ON u1_.id = u2_.id WHERE c0_.status = ? AND c0_.id IN (?) ORDER BY c0_.date_created DESC
Parameters:
[
  "published"
  [
    144
    143
    142
    141
    140
    139
    138
    137
    14
    13
  ]
]
5 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.weight AS weight_5, t0.path AS path_6, t0.lvl AS lvl_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.is_enable AS is_enable_10, t0.template AS template_11, t0.thumbnail AS thumbnail_12, t0.vid AS vid_13, t14.id AS id_15, t14.human_label AS human_label_16, t14.name AS name_17, t14.description AS description_18, t14.is_orderable AS is_orderable_19, t14.weight AS weight_20, t14.createdAt AS createdAt_21, t14.updatedAt AS updatedAt_22, t0.pid AS pid_23, t24.id AS id_25, t24.name AS name_26, t24.slug AS slug_27, t24.description AS description_28, t24.weight AS weight_29, t24.path AS path_30, t24.lvl AS lvl_31, t24.createdAt AS createdAt_32, t24.updatedAt AS updatedAt_33, t24.is_enable AS is_enable_34, t24.template AS template_35, t24.thumbnail AS thumbnail_36, t24.vid AS vid_37, t24.pid AS pid_38, t24.route_id AS route_id_39, t0.route_id AS route_id_40 FROM taxonomy_term t0 LEFT JOIN taxonomy_vocabulary t14 ON t0.vid = t14.id LEFT JOIN taxonomy_term t24 ON t0.pid = t24.id WHERE t0.id IN (?)
Parameters:
[
  [
    8
    3
  ]
]

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
Boab\CmsBundle\Entity\Route No errors.
Boab\CmsBundle\Entity\Content No errors.
Boab\CmsBundle\Entity\Event No errors.
Boab\CmsBundle\Entity\Block No errors.
Fbeen\SettingsBundle\Entity\Setting No errors.
Boab\CmsBundle\Entity\ListRoute No errors.
Boab\CmsBundle\Entity\PostRoute No errors.
Boab\CmsBundle\Entity\PageRoute No errors.
Boab\CmsBundle\Entity\TermRoute No errors.
Boab\CmsBundle\Entity\UrlRoute No errors.
Boab\CmsBundle\Entity\Term No errors.
Boab\CmsBundle\Entity\Article No errors.
Boab\CmsBundle\Entity\User No errors.
Boab\CmsBundle\Entity\Admin No errors.
Boab\CmsBundle\Entity\Photo No errors.
Boab\CmsBundle\Entity\Media No errors.
Boab\CmsBundle\Entity\ViewCounter No errors.
Boab\CmsBundle\Entity\Vocabulary No errors.