Query Metrics

17 Database Queries
11 Different statements
33.76 ms Query time
8 Invalid entities
86 Managed entities

Grouped Statements

Show all queries

Time Count Info
12.25 ms
(36.29%)
1
"COMMIT"
Parameters:
[]
4.75 ms
(14.08%)
1
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 WHERE t0.published = ? ORDER BY t0.adddate DESC LIMIT 3
Parameters:
[
  1
]
4.64 ms
(13.73%)
3
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:
[]
4.61 ms
(13.66%)
1
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 WHERE t0.published = ? ORDER BY t0.views DESC LIMIT 3
Parameters:
[
  1
]
2.15 ms
(6.36%)
3
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
]
1.90 ms
(5.64%)
3
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:
[]
1.11 ms
(3.29%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.clicks AS clicks_4, t0.views AS views_5, t0.status AS status_6, t0.type AS type_7, t0.path AS path_8, t0.campaign_id AS campaign_id_9 FROM ad t0 INNER JOIN ad_current_menuitem ON t0.id = ad_current_menuitem.ad_id WHERE ad_current_menuitem.menuitem_id = ?
Parameters:
[
  4
]
0.84 ms
(2.48%)
1
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.alttitle AS alttitle_3, t0.promo AS promo_4, t0.showfrom AS showfrom_5, t0.showto AS showto_6, t0.published AS published_7, t0.patronage AS patronage_8, t0.url AS url_9, t0.startpage AS startpage_10, t0.name AS name_11, t0.email AS email_12, t0.town AS town_13, t0.metatitle AS metatitle_14, t0.metadesc AS metadesc_15, t0.metakeyw AS metakeyw_16, t0.description AS description_17, t0.fulldescription AS fulldescription_18, t0.program AS program_19, t0.info AS info_20, t0.datefrom AS datefrom_21, t0.dateto AS dateto_22, t0.hours AS hours_23, t0.price AS price_24, t0.fullprice AS fullprice_25, t0.priceinfo AS priceinfo_26, t0.deleted AS deleted_27, t0.promoaddress AS promoaddress_28, t0.promoname AS promoname_29, t0.promostreet AS promostreet_30, t0.promopostcode AS promopostcode_31, t0.promotown AS promotown_32, t0.views AS views_33, t0.adddate AS adddate_34, t0.likesno AS likesno_35, t0.lead AS lead_36, t0.content AS content_37, t0.path AS path_38, t0.category_id AS category_id_39, t0.mpd_id AS mpd_id_40, t0.subcategory_id AS subcategory_id_41, t0.gallery_id AS gallery_id_42 FROM eventitem t0 WHERE t0.id = ?
Parameters:
[
  "295"
]
0.78 ms
(2.30%)
1
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:
[
  "/e/295/warsztaty-masazu-shantala"
]
0.40 ms
(1.18%)
1
UPDATE eventitem SET views = ? WHERE id = ?
Parameters:
[
  5529
  295
]
0.33 ms
(0.99%)
1
"START TRANSACTION"
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.

Managed Entities

default entity manager

Class Amount of managed objects
TTT\DatabaseBundle\Entity\SubmenuCategory 51
TTT\DatabaseBundle\Entity\SubmenuItem 13
TTT\DatabaseBundle\Entity\Gallery 8
TTT\DatabaseBundle\Entity\ArticleItem 6
TTT\DatabaseBundle\Entity\MenuItem 3
TTT\DatabaseBundle\Entity\Author 3
TTT\DatabaseBundle\Entity\EventItem 1
TTT\DatabaseBundle\Entity\StaticItem 1

Entities Mapping

Class Mapping 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\SubmenuCategory No errors.
TTT\DatabaseBundle\Entity\MPD No errors.
TTT\DatabaseBundle\Entity\ItemSubcategory No errors.
TTT\DatabaseBundle\Entity\Gallery 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\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\EventItemDate 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\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\MenuItem No errors.
TTT\DatabaseBundle\Entity\Ad No errors.
TTT\DatabaseBundle\Entity\SubmenuItem No errors.
TTT\DatabaseBundle\Entity\StaticItem No errors.
TTT\DatabaseBundle\Entity\Skill No errors.
TTT\DatabaseBundle\Entity\ArtItem No errors.
TTT\DatabaseBundle\Entity\DownloadItem No errors.
TTT\DatabaseBundle\Entity\ArticleItem No errors.
TTT\DatabaseBundle\Entity\Tag No errors.
TTT\DatabaseBundle\Entity\AdCampaign 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.
FOS\UserBundle\Model\User No errors.
TTT\UserBundle\Entity\User 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\GalleryPhoto 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\PayU No errors.
TTT\DatabaseBundle\Entity\Meta No errors.
TTT\DatabaseBundle\Entity\MPDNewsletterItem No errors.
TTT\DatabaseBundle\Entity\MPDPromoPhoto No errors.
TTT\DatabaseBundle\Entity\MPDPromoTrainer No errors.
TTT\DatabaseBundle\Entity\MPDImportantInformationCategory 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\MPDNearbyCategory 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.
TTT\DatabaseBundle\Entity\Invoice No errors.
TTT\DatabaseBundle\Entity\DiaryPhoto No errors.
TTT\DatabaseBundle\Entity\ContestParticipation
  • The association TTT\DatabaseBundle\Entity\ContestParticipation#gallery refers to the inverse side field TTT\DatabaseBundle\Entity\PPGallery#participation which does not exist.
  • The association TTT\DatabaseBundle\Entity\ContestParticipation#diary refers to the inverse side field TTT\DatabaseBundle\Entity\Diary#participation which does not exist.
TTT\DatabaseBundle\Entity\BlogCategory No errors.
TTT\DatabaseBundle\Entity\PPGalleryPhoto No errors.