Query Metrics
12
Database Queries
6
Different statements
9.86 ms
Query time
5
Invalid entities
114
Managed entities
Queries
| #▲ | 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 |
|
| 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 |
|
| TTT\DatabaseBundle\Entity\Gallery | No errors. |
| TTT\DatabaseBundle\Entity\ItemSubcategory | No errors. |
| TTT\DatabaseBundle\Entity\Comment | No errors. |
| TTT\DatabaseBundle\Entity\UserLike |
|
| TTT\DatabaseBundle\Entity\Meta | No errors. |
| TTT\DatabaseBundle\Entity\UserVisit |
|
| TTT\DatabaseBundle\Entity\MPD | No errors. |
| TTT\DatabaseBundle\Entity\EventItemTag |
|
| 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. |