Query Metrics
19
Database Queries
19
Different statements
47.54 ms
Query time
6
Invalid entities
274
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.67 ms (26.65%) |
1 |
SELECT e0_.id AS id_0, e0_.category_id AS category_id_1, e0_.alttitle AS alttitle_2, e0_.promo AS promo_3, e0_.showfrom AS showfrom_4, e0_.showto AS showto_5, e0_.published AS published_6, e0_.patronage AS patronage_7, e0_.url AS url_8, e0_.startpage AS startpage_9, e0_.name AS name_10, e0_.email AS email_11, e0_.town AS town_12, e0_.metatitle AS metatitle_13, e0_.metadesc AS metadesc_14, e0_.metakeyw AS metakeyw_15, e0_.description AS description_16, e0_.fulldescription AS fulldescription_17, e0_.program AS program_18, e0_.info AS info_19, e0_.datefrom AS datefrom_20, e0_.dateto AS dateto_21, e0_.hours AS hours_22, e0_.price AS price_23, e0_.fullprice AS fullprice_24, e0_.priceinfo AS priceinfo_25, e0_.deleted AS deleted_26, e0_.promoaddress AS promoaddress_27, e0_.promoname AS promoname_28, e0_.promostreet AS promostreet_29, e0_.promopostcode AS promopostcode_30, e0_.promotown AS promotown_31, e0_.views AS views_32, e0_.adddate AS adddate_33, e0_.likesno AS likesno_34, e0_.lead AS lead_35, e0_.content AS content_36, e0_.path AS path_37, e0_.category_id AS category_id_38, e0_.mpd_id AS mpd_id_39, e0_.subcategory_id AS subcategory_id_40, e0_.gallery_id AS gallery_id_41 FROM eventitem e0_ WHERE e0_.category_id IN (69, 84, 85) AND e0_.published = 1 ORDER BY e0_.adddate DESC LIMIT 4
Parameters:
[] |
|
8.14 ms (17.12%) |
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.published = ? AND t0.promo = ? AND t0.category_id = ? ORDER BY t0.datefrom DESC LIMIT 1
Parameters:
[ 1 1 69 ] |
|
5.93 ms (12.47%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lead AS lead_3, t0.url AS url_4, t0.adddate AS adddate_5, t0.height AS height_6, t0.likesno AS likesno_7, t0.views AS views_8, t0.path AS path_9, t0.blog_id AS blog_id_10 FROM blogentry t0 ORDER BY t0.adddate DESC LIMIT 6
Parameters:
[] |
|
4.30 ms (9.05%) |
1 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569) AND a0_.published = 1 ORDER BY a0_.showfrom DESC LIMIT 8
Parameters:
[] |
|
4.12 ms (8.66%) |
1 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822) AND a0_.published = 1 AND a0_.promo = 1 ORDER BY a0_.showfrom DESC LIMIT 3
Parameters:
[] |
|
1.68 ms (3.54%) |
1 |
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:
[] |
|
1.25 ms (2.63%) |
1 |
SELECT m0_.id AS id_0, m0_.promo AS promo_1, m0_.name AS name_2, m0_.contactname AS contactname_3, m0_.promocode AS promocode_4, m0_.sellercode AS sellercode_5, m0_.longdescription AS longdescription_6, m0_.description AS description_7, m0_.street AS street_8, m0_.postcode AS postcode_9, m0_.email AS email_10, m0_.province AS province_11, m0_.plan AS plan_12, m0_.townname AS townname_13, m0_.vatid AS vatid_14, m0_.phone AS phone_15, m0_.mobile AS mobile_16, m0_.fax AS fax_17, m0_.website AS website_18, m0_.rules AS rules_19, m0_.marketing AS marketing_20, m0_.vat AS vat_21, m0_.vatname AS vatname_22, m0_.vatstreet AS vatstreet_23, m0_.vatpostcode AS vatpostcode_24, m0_.vattown AS vattown_25, m0_.visible AS visible_26, m0_.approved AS approved_27, m0_.examplary AS examplary_28, m0_.regacceptlego AS regacceptlego_29, m0_.recommended AS recommended_30, m0_.paid AS paid_31, m0_.deleted AS deleted_32, m0_.hasrealpromos AS hasrealpromos_33, m0_.hasowner AS hasowner_34, m0_.mark AS mark_35, m0_.pricefrom AS pricefrom_36, m0_.pricefor AS pricefor_37, m0_.age AS age_38, m0_.ageto AS ageto_39, m0_.lng AS lng_40, m0_.lat AS lat_41, m0_.likesno AS likesno_42, m0_.x AS x_43, m0_.y AS y_44, m0_.iiothers AS iiothers_45, m0_.path AS path_46, m0_.adddate AS adddate_47, m0_.editdate AS editdate_48, m0_.errordate AS errordate_49, m0_.visits AS visits_50, m0_.listshow AS listshow_51, m0_.town_id AS town_id_52, m0_.category_id AS category_id_53, m0_.user_id AS user_id_54, m0_.adduser_id AS adduser_id_55 FROM mpd m0_ WHERE m0_.deleted = 0 AND m0_.visible = 1 AND m0_.approved = 1 AND m0_.path IS NOT NULL ORDER BY m0_.adddate DESC LIMIT 9
Parameters:
[] |
|
1.19 ms (2.50%) |
1 |
SELECT d0_.id AS id_0, d0_.alttitle AS alttitle_1, d0_.url AS url_2, d0_.showfrom AS showfrom_3, d0_.showto AS showto_4, d0_.showrepeated AS showrepeated_5, d0_.published AS published_6, d0_.startpage AS startpage_7, d0_.difficulty AS difficulty_8, d0_.age AS age_9, d0_.ageto AS ageto_10, d0_.name AS name_11, d0_.premium AS premium_12, d0_.logged AS logged_13, d0_.price AS price_14, d0_.views AS views_15, d0_.adddate AS adddate_16, d0_.likesno AS likesno_17, d0_.path AS path_18, d0_.pdfpath AS pdfpath_19, d0_.category_id AS category_id_20 FROM downloaditem d0_ WHERE d0_.published = 1 AND d0_.logged = 0 ORDER BY d0_.adddate ASC LIMIT 50
Parameters:
[] |
|
1.11 ms (2.33%) |
1 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569, 1814, 1813) AND a0_.published = 1 AND a0_.category_id IN (35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72, 74, 25, 26, 27, 32) ORDER BY a0_.id DESC LIMIT 12
Parameters:
[] |
|
0.98 ms (2.07%) |
1 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569) AND a0_.published = 1 AND a0_.promo = 1 AND a0_.category_id IN (35, 36, 37, 38, 39, 40, 42, 30, 31, 86, 72, 74, 25, 26, 27, 32) ORDER BY a0_.id DESC LIMIT 2
Parameters:
[] |
|
0.92 ms (1.93%) |
1 |
SELECT MAX(a0_.id) AS sclr_0 FROM articleitem a0_ WHERE a0_.category_id IN (74, 25, 26, 27, 32) AND a0_.id NOT IN (1825, 1824, 1823, 1822, 1738, 1722, 1569, 1814, 1813) GROUP BY a0_.category_id LIMIT 4
Parameters:
[] |
|
0.88 ms (1.85%) |
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.startpage = ? AND t0.published = ? ORDER BY t0.id DESC LIMIT 4
Parameters:
[ 1 1 ] |
|
0.78 ms (1.64%) |
1 |
SELECT p0_.views AS views_0, p0_.id AS id_1, p0_.title AS title_2, p0_.subtitle AS subtitle_3, p0_.town AS town_4, p0_.url AS url_5, p0_.description AS description_6, p0_.privacy AS privacy_7, p0_.height AS height_8, p0_.likesno AS likesno_9, p0_.path AS path_10, p0_.user_id AS user_id_11 FROM photopage p0_ WHERE p0_.privacy = 1 AND p0_.path IS NOT NULL ORDER BY p0_.id DESC LIMIT 50
Parameters:
[] |
|
0.73 ms (1.53%) |
1 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.email AS email_2, f0_.url AS url_3, f0_.town AS town_4, f0_.description AS description_5, f0_.priority AS priority_6, f0_.path AS path_7 FROM foundation f0_ ORDER BY f0_.priority DESC
Parameters:
[] |
|
0.65 ms (1.36%) |
1 |
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
]
|
|
0.60 ms (1.27%) |
1 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.promo AS promo_2, a0_.startpage AS startpage_3, a0_.alttitle AS alttitle_4, a0_.category_id AS category_id_5, a0_.name AS name_6, a0_.metatitle AS metatitle_7, a0_.metadesc AS metadesc_8, a0_.metakeyw AS metakeyw_9, a0_.age AS age_10, a0_.ageto AS ageto_11, a0_.lead AS lead_12, a0_.views AS views_13, a0_.adddate AS adddate_14, a0_.showfrom AS showfrom_15, a0_.showto AS showto_16, a0_.showrepeated AS showrepeated_17, a0_.published AS published_18, a0_.content AS content_19, a0_.likesno AS likesno_20, a0_.path AS path_21, a0_.rss_published AS rss_published_22, a0_.category_id AS category_id_23, a0_.author_id AS author_id_24, a0_.gallery_id AS gallery_id_25 FROM articleitem a0_ WHERE a0_.id IN (1811, 1810, 1809, 1808)
Parameters:
[] |
|
0.55 ms (1.16%) |
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:
[
"/"
]
|
|
0.55 ms (1.15%) |
1 |
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:
[] |
|
0.52 ms (1.09%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.email AS email_2, p0_.url AS url_3, p0_.town AS town_4, p0_.description AS description_5, p0_.priority AS priority_6, p0_.path AS path_7 FROM partner p0_ ORDER BY p0_.priority DESC
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\DownloadItem | 50 |
| TTT\DatabaseBundle\Entity\Gallery | 34 |
| TTT\DatabaseBundle\Entity\ArticleItem | 29 |
| TTT\DatabaseBundle\Entity\Photopage | 24 |
| TTT\UserBundle\Entity\User | 22 |
| TTT\DatabaseBundle\Entity\SubmenuItem | 13 |
| TTT\DatabaseBundle\Entity\MPD | 9 |
| TTT\DatabaseBundle\Entity\Town | 7 |
| TTT\DatabaseBundle\Entity\BlogEntry | 6 |
| TTT\DatabaseBundle\Entity\Blog | 6 |
| TTT\DatabaseBundle\Entity\MPDCategory | 6 |
| TTT\DatabaseBundle\Entity\EventItem | 4 |
| TTT\DatabaseBundle\Entity\MenuItem | 3 |
| TTT\DatabaseBundle\Entity\Author | 3 |
| TTT\DatabaseBundle\Entity\Foundation | 3 |
| TTT\DatabaseBundle\Entity\Partner | 2 |
| TTT\DatabaseBundle\Entity\StaticItem | 1 |
| TTT\DatabaseBundle\Entity\ItemSubcategory | 1 |
Entities Mapping
| Class | Mapping 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\StaticItem | No errors. |
| TTT\DatabaseBundle\Entity\Skill | No errors. |
| TTT\DatabaseBundle\Entity\Author |
|
| TTT\DatabaseBundle\Entity\Gallery | 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\ItemSubcategory | No errors. |
| TTT\DatabaseBundle\Entity\Tag | No errors. |
| TTT\DatabaseBundle\Entity\Comment | No errors. |
| TTT\DatabaseBundle\Entity\UserLike |
|
| TTT\DatabaseBundle\Entity\UserVisit |
|
| TTT\DatabaseBundle\Entity\MPD | No errors. |
| TTT\DatabaseBundle\Entity\EventItemTag |
|
| TTT\DatabaseBundle\Entity\EventItemDate | No errors. |
| TTT\DatabaseBundle\Entity\BlogEntry | No errors. |
| TTT\DatabaseBundle\Entity\Blog | No errors. |
| TTT\DatabaseBundle\Entity\Photopage | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| TTT\UserBundle\Entity\User | No errors. |
| TTT\DatabaseBundle\Entity\PPChild | No errors. |
| TTT\DatabaseBundle\Entity\PPGallery |
|
| TTT\DatabaseBundle\Entity\Town | No errors. |
| TTT\DatabaseBundle\Entity\MPDCategory | 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\MPDPhoto | No errors. |
| TTT\DatabaseBundle\Entity\MPDFacilityCategory | No errors. |
| TTT\DatabaseBundle\Entity\MPDImportantInformationSubcategory | No errors. |
| TTT\DatabaseBundle\Entity\MPDNearby | No errors. |
| TTT\DatabaseBundle\Entity\Foundation | No errors. |
| TTT\DatabaseBundle\Entity\Partner | No errors. |
| TTT\DatabaseBundle\Entity\Meta | No errors. |