Query Metrics

12 Database Queries
6 Different statements
9.86 ms Query time
7 Invalid entities
114 Managed entities

Queries

Group similar statements

# Time Info
1 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 WHERE t0.id = ?
Parameters:
[
  "334"
]
2 0.60 ms
SELECT t0.id AS id_1, t0.css AS css_2, t0.url AS url_3, t0.visible AS visible_4, t0.redirecturl AS redirecturl_5, t0.priority AS priority_6, t0.adfactor AS adfactor_7, t0.name AS name_8 FROM menuitem t0 WHERE t0.visible = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
3 0.40 ms
SELECT t0.id AS id_1, t0.menuitem_id AS menuitem_id_2, t0.name AS name_3, t0.url AS url_4, t0.type AS type_5, t0.priority AS priority_6, t0.menuitem_id AS menuitem_id_7 FROM submenuitem t0 ORDER BY t0.priority ASC
Parameters:
[]
4 0.88 ms
SELECT t0.id AS id_1, t0.submenuitem_id AS submenuitem_id_2, t0.name AS name_3, t0.css AS css_4, t0.url AS url_5, t0.hideskill AS hideskill_6, t0.type AS type_7, t0.priority AS priority_8, t0.submenuitem_id AS submenuitem_id_9, t10.id AS id_11, t10.url AS url_12, t10.name AS name_13, t10.metatitle AS metatitle_14, t10.metadesc AS metadesc_15, t10.metakeyw AS metakeyw_16, t10.age AS age_17, t10.ageto AS ageto_18, t10.lead AS lead_19, t10.views AS views_20, t10.adddate AS adddate_21, t10.content AS content_22, t10.likesno AS likesno_23, t10.path AS path_24, t10.category_id AS category_id_25, t10.skill_id AS skill_id_26, t10.author_id AS author_id_27, t10.gallery_id AS gallery_id_28 FROM submenucategory t0 LEFT JOIN staticitem t10 ON t10.category_id = t0.id ORDER BY t0.priority ASC
Parameters:
[]
5 0.59 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM meta t0 WHERE t0.path = ?
Parameters:
[
  "/tag/334"
]
6 0.72 ms
SELECT t0.id AS id_1, t0.css AS css_2, t0.url AS url_3, t0.visible AS visible_4, t0.redirecturl AS redirecturl_5, t0.priority AS priority_6, t0.adfactor AS adfactor_7, t0.name AS name_8 FROM menuitem t0 WHERE t0.visible = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
7 0.67 ms
SELECT t0.id AS id_1, t0.menuitem_id AS menuitem_id_2, t0.name AS name_3, t0.url AS url_4, t0.type AS type_5, t0.priority AS priority_6, t0.menuitem_id AS menuitem_id_7 FROM submenuitem t0 ORDER BY t0.priority ASC
Parameters:
[]
8 0.79 ms
SELECT t0.id AS id_1, t0.submenuitem_id AS submenuitem_id_2, t0.name AS name_3, t0.css AS css_4, t0.url AS url_5, t0.hideskill AS hideskill_6, t0.type AS type_7, t0.priority AS priority_8, t0.submenuitem_id AS submenuitem_id_9, t10.id AS id_11, t10.url AS url_12, t10.name AS name_13, t10.metatitle AS metatitle_14, t10.metadesc AS metadesc_15, t10.metakeyw AS metakeyw_16, t10.age AS age_17, t10.ageto AS ageto_18, t10.lead AS lead_19, t10.views AS views_20, t10.adddate AS adddate_21, t10.content AS content_22, t10.likesno AS likesno_23, t10.path AS path_24, t10.category_id AS category_id_25, t10.skill_id AS skill_id_26, t10.author_id AS author_id_27, t10.gallery_id AS gallery_id_28 FROM submenucategory t0 LEFT JOIN staticitem t10 ON t10.category_id = t0.id ORDER BY t0.priority ASC
Parameters:
[]
9 0.63 ms
SELECT t0.id AS id_1, t0.css AS css_2, t0.url AS url_3, t0.visible AS visible_4, t0.redirecturl AS redirecturl_5, t0.priority AS priority_6, t0.adfactor AS adfactor_7, t0.name AS name_8 FROM menuitem t0 WHERE t0.visible = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
10 0.71 ms
SELECT t0.id AS id_1, t0.menuitem_id AS menuitem_id_2, t0.name AS name_3, t0.url AS url_4, t0.type AS type_5, t0.priority AS priority_6, t0.menuitem_id AS menuitem_id_7 FROM submenuitem t0 ORDER BY t0.priority ASC
Parameters:
[]
11 1.76 ms
SELECT t0.id AS id_1, t0.submenuitem_id AS submenuitem_id_2, t0.name AS name_3, t0.css AS css_4, t0.url AS url_5, t0.hideskill AS hideskill_6, t0.type AS type_7, t0.priority AS priority_8, t0.submenuitem_id AS submenuitem_id_9, t10.id AS id_11, t10.url AS url_12, t10.name AS name_13, t10.metatitle AS metatitle_14, t10.metadesc AS metadesc_15, t10.metakeyw AS metakeyw_16, t10.age AS age_17, t10.ageto AS ageto_18, t10.lead AS lead_19, t10.views AS views_20, t10.adddate AS adddate_21, t10.content AS content_22, t10.likesno AS likesno_23, t10.path AS path_24, t10.category_id AS category_id_25, t10.skill_id AS skill_id_26, t10.author_id AS author_id_27, t10.gallery_id AS gallery_id_28 FROM submenucategory t0 LEFT JOIN staticitem t10 ON t10.category_id = t0.id ORDER BY t0.priority ASC
Parameters:
[]
12 1.31 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.promo AS promo_3, t0.startpage AS startpage_4, t0.alttitle AS alttitle_5, t0.category_id AS category_id_6, t0.name AS name_7, t0.metatitle AS metatitle_8, t0.metadesc AS metadesc_9, t0.metakeyw AS metakeyw_10, t0.age AS age_11, t0.ageto AS ageto_12, t0.lead AS lead_13, t0.views AS views_14, t0.adddate AS adddate_15, t0.showfrom AS showfrom_16, t0.showto AS showto_17, t0.showrepeated AS showrepeated_18, t0.published AS published_19, t0.content AS content_20, t0.likesno AS likesno_21, t0.path AS path_22, t0.rss_published AS rss_published_23, t0.category_id AS category_id_24, t0.author_id AS author_id_25, t0.gallery_id AS gallery_id_26 FROM articleitem t0 INNER JOIN articleitem_tags ON t0.id = articleitem_tags.articleitem_id WHERE articleitem_tags.tag_id = ?
Parameters:
[
  334
]

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
TTT\DatabaseBundle\Entity\SubmenuCategory 51
TTT\DatabaseBundle\Entity\Gallery 17
TTT\DatabaseBundle\Entity\ArticleItem 16
TTT\DatabaseBundle\Entity\SubmenuItem 13
TTT\DatabaseBundle\Entity\Author 12
TTT\DatabaseBundle\Entity\MenuItem 3
TTT\DatabaseBundle\Entity\Tag 1
TTT\DatabaseBundle\Entity\StaticItem 1

Entities Mapping

Class Mapping errors
TTT\DatabaseBundle\Entity\Tag No errors.
TTT\DatabaseBundle\Entity\ArtItem No errors.
TTT\DatabaseBundle\Entity\DownloadItem No errors.
TTT\DatabaseBundle\Entity\EventItem
  • The association TTT\DatabaseBundle\Entity\EventItem#tags refers to the inverse side field TTT\DatabaseBundle\Entity\EventItemTag#eventitems which does not exist.
  • The association TTT\DatabaseBundle\Entity\EventItem#authors refers to the inverse side field TTT\DatabaseBundle\Entity\Author#eventItems which does not exist.
TTT\DatabaseBundle\Entity\ArticleItem No errors.
TTT\DatabaseBundle\Entity\StaticItem No errors.
TTT\DatabaseBundle\Entity\MenuItem No errors.
TTT\DatabaseBundle\Entity\Ad No errors.
TTT\DatabaseBundle\Entity\SubmenuItem No errors.
TTT\DatabaseBundle\Entity\SubmenuCategory No errors.
TTT\DatabaseBundle\Entity\Skill No errors.
TTT\DatabaseBundle\Entity\Author
  • The association TTT\DatabaseBundle\Entity\Author#downloaditems refers to the owning side field TTT\DatabaseBundle\Entity\DownloadItem#author which does not exist.
  • The mappings TTT\DatabaseBundle\Entity\Author#eventitems and TTT\DatabaseBundle\Entity\EventItem#authors are inconsistent with each other.
TTT\DatabaseBundle\Entity\Gallery No errors.
TTT\DatabaseBundle\Entity\ItemSubcategory No errors.
TTT\DatabaseBundle\Entity\Comment No errors.
TTT\DatabaseBundle\Entity\UserLike
  • The mappings TTT\DatabaseBundle\Entity\UserLike#downloaditem and TTT\DatabaseBundle\Entity\DownloadItem#likes are inconsistent with each other.
TTT\DatabaseBundle\Entity\Meta No errors.
TTT\DatabaseBundle\Entity\UserVisit
  • The mappings TTT\DatabaseBundle\Entity\UserVisit#downloaditem and TTT\DatabaseBundle\Entity\DownloadItem#visits are inconsistent with each other.
  • The association TTT\DatabaseBundle\Entity\UserVisit#staticitem refers to the inverse side field TTT\DatabaseBundle\Entity\StaticItem#visits which does not exist.
TTT\DatabaseBundle\Entity\MPD No errors.
TTT\DatabaseBundle\Entity\EventItemTag
  • The mappings TTT\DatabaseBundle\Entity\EventItemTag#eventItems and TTT\DatabaseBundle\Entity\EventItem#tags are inconsistent with each other.
TTT\DatabaseBundle\Entity\EventItemDate No errors.
TTT\DatabaseBundle\Entity\AdCampaign No errors.
TTT\DatabaseBundle\Entity\GalleryPhoto No errors.
FOS\UserBundle\Model\User No errors.
TTT\UserBundle\Entity\User No errors.
TTT\DatabaseBundle\Entity\BlogEntry No errors.
TTT\DatabaseBundle\Entity\Firstname No errors.
TTT\DatabaseBundle\Entity\Institution No errors.
TTT\DatabaseBundle\Entity\Photopage No errors.
TTT\DatabaseBundle\Entity\MPDNewsletter No errors.
TTT\DatabaseBundle\Entity\MPDLike No errors.
TTT\DatabaseBundle\Entity\MPDMark No errors.
TTT\DatabaseBundle\Entity\MPDPromo No errors.
TTT\DatabaseBundle\Entity\MPDRealPromo No errors.
TTT\DatabaseBundle\Entity\MPDPlan No errors.
TTT\DatabaseBundle\Entity\Town No errors.
TTT\DatabaseBundle\Entity\MPDCategory No errors.
TTT\DatabaseBundle\Entity\MPDPhoto No errors.
TTT\DatabaseBundle\Entity\MPDFacilityCategory No errors.
TTT\DatabaseBundle\Entity\MPDImportantInformationSubcategory No errors.
TTT\DatabaseBundle\Entity\MPDNearby No errors.
TTT\DatabaseBundle\Entity\PayU No errors.
TTT\DatabaseBundle\Entity\Diary
  • The mappings TTT\DatabaseBundle\Entity\Diary#participations and TTT\DatabaseBundle\Entity\ContestParticipation#diary are inconsistent with each other.
TTT\DatabaseBundle\Entity\FamilyMember No errors.
TTT\DatabaseBundle\Entity\Friend No errors.
TTT\DatabaseBundle\Entity\Plan No errors.
TTT\DatabaseBundle\Entity\Blog No errors.
TTT\DatabaseBundle\Entity\FirstnameCategory No errors.
TTT\DatabaseBundle\Entity\InstitutionCategory No errors.
TTT\DatabaseBundle\Entity\InstitutionType No errors.
TTT\DatabaseBundle\Entity\Province No errors.
TTT\DatabaseBundle\Entity\PPChild No errors.
TTT\DatabaseBundle\Entity\PPGallery
  • The mappings TTT\DatabaseBundle\Entity\PPGallery#participations and TTT\DatabaseBundle\Entity\ContestParticipation#gallery are inconsistent with each other.