https://heavenwavesmedia.com/media

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.18 ms
(46.82%)
1
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, v1_.youtube_video_id AS youtube_video_id_20, u2_.id AS id_21, u2_.username AS username_22, u2_.firstname AS firstname_23, u2_.lastname AS lastname_24, u2_.gender AS gender_25, u2_.dob AS dob_26, u2_.contact_number AS contact_number_27, u2_.email AS email_28, u2_.address AS address_29, u2_.city AS city_30, u2_.country AS country_31, u2_.postal_code AS postal_code_32, u2_.roles AS roles_33, u2_.password AS password_34, u2_.salt AS salt_35, u2_.account_status AS account_status_36, u2_.is_activated AS is_activated_37, u2_.created_at AS created_at_38, u2_.updated_at AS updated_at_39, u2_.thumbnail AS thumbnail_40, c0_.content_type AS content_type_41, u2_.user_type AS user_type_42 FROM video v1_ INNER JOIN contents c0_ ON v1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id WHERE c0_.status = ?) dctrn_result_inner ORDER BY date_created_13 DESC) dctrn_result LIMIT 10
Parameters:
[
  "published"
]
2.04 ms
(30.07%)
1
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, v1_.youtube_video_id AS youtube_video_id_20, u2_.id AS id_21, u2_.username AS username_22, u2_.firstname AS firstname_23, u2_.lastname AS lastname_24, u2_.gender AS gender_25, u2_.dob AS dob_26, u2_.contact_number AS contact_number_27, u2_.email AS email_28, u2_.address AS address_29, u2_.city AS city_30, u2_.country AS country_31, u2_.postal_code AS postal_code_32, u2_.roles AS roles_33, u2_.password AS password_34, u2_.salt AS salt_35, u2_.account_status AS account_status_36, u2_.is_activated AS is_activated_37, u2_.created_at AS created_at_38, u2_.updated_at AS updated_at_39, u2_.thumbnail AS thumbnail_40, c0_.content_type AS content_type_41, c0_.user_id AS user_id_42, c0_.term_id AS term_id_43, u2_.user_type AS user_type_44 FROM video v1_ INNER JOIN contents c0_ ON v1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id WHERE c0_.status = ? AND c0_.id IN (?) ORDER BY c0_.date_created DESC
Parameters:
[
  "published"
  [
    156
    155
    154
    153
    147
  ]
]
1.03 ms
(15.24%)
1
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:
[]
0.29 ms
(4.27%)
1
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:
[
  [
    12
  ]
]
0.24 ms
(3.59%)
1
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:
[]

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\Video 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.