Het volledige schema voor de Gamma Racing Days 2017

instantiate query log (0Q - total module time: 0.00061989s)

boot (0Q - total module time: 0.00010610s)

translation-init (1Q - total module time: 0.00099301s)

SELECT redirects.id, redirects.origin, redirects.referer FROM redirects WHERE redirects.origin = :origin ORDER BY id

controller::nieuws/f1/229862/het-volledige-schema-voor-de-gamma-racing-days-2017 (2Q - total module time: 0.08170605s)

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId > :articleId ORDER BY Articles.ArticleId ASC LIMIT 1

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId < :articleId ORDER BY Articles.ArticleId DESC LIMIT 1

module:News\Result (0Q - total module time: 0.00021815s)

module:News\Trending (0Q - total module time: 0.00013399s)

module:News\Reply (1Q - total module time: 0.43760300s)

SELECT c0_.CommentId AS CommentId_0, c1_.Vote AS Vote_1 FROM Comments c0_ INNER JOIN CommentVotes c1_ ON (c1_.CommentId = c0_.CommentId) WHERE c0_.ArticleId = ? AND c1_.VoteIp = ?

module:RelatedNews (9Q - total module time: 0.01967597s)

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = k0_.KeywordId) WHERE k1_.nieuwsID = ?

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ WHERE k0_.KeywordId IN (?)

SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))

SELECT t0.RacingSerieId AS RacingSerieId_1, t0.RewriteUrl AS RewriteUrl_2, t0.IsDefault AS IsDefault_3, t0.SiteId AS SiteId_4, t0.CountryIso AS CountryIso_5 FROM RacingSeries t0 WHERE t0.RewriteUrl = ? AND t0.SiteId IN (?) AND ((t0.SiteId IN ('1'))) LIMIT 1

SELECT a0_.ArticleId AS ArticleId_0, a0_.RewriteUrl AS RewriteUrl_1, a0_.Title AS Title_2, a0_.SeoDescription AS SeoDescription_3, a0_.SeoTitle AS SeoTitle_4, a0_.coAuthor AS coAuthor_5, a0_.Icon AS Icon_6, a0_.Category AS Category_7, a0_.Content AS Content_8, a0_.PublishDate AS PublishDate_9, a0_.CreateDate AS CreateDate_10, a0_.CreateTime AS CreateTime_11, a0_.CommentType AS CommentType_12, a0_.AllowNewComments AS AllowNewComments_13, a0_.cntnlang AS cntnlang_14, a0_.LastUpdateDate AS LastUpdateDate_15, a0_.ArticleType AS ArticleType_16, a0_.CommentCount AS CommentCount_17, a0_.Activated AS Activated_18, a0_.StickyUntil AS StickyUntil_19, a0_.ViewCount AS ViewCount_20, a0_.PushEnabled AS PushEnabled_21, a0_.PushTitle AS PushTitle_22, a0_.PushMessage AS PushMessage_23, a0_.breaking AS breaking_24, a0_.breaking_title AS breaking_title_25, a0_.TestMode AS TestMode_26, r1_.RacingSerieId AS RacingSerieId_27, r1_.RewriteUrl AS RewriteUrl_28, r1_.IsDefault AS IsDefault_29, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_30, r2_.LanguageCode AS LanguageCode_31, r2_.ShortName AS ShortName_32, r2_.LongName AS LongName_33, a0_.SiteId AS SiteId_34, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_35, a0_.RacingSerieId AS RacingSerieId_36, a0_.PhotoAlbumId AS PhotoAlbumId_37, a0_.CmsAccountId AS CmsAccountId_38, a0_.PollId AS PollId_39, a0_.RaceSessionId AS RaceSessionId_40, r1_.SiteId AS SiteId_41, r1_.CountryIso AS CountryIso_42, r2_.RacingSerieId AS RacingSerieId_43 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'nl') INNER JOIN keyword_combinations k3_ ON (k3_.nieuwsID = a0_.ArticleId) WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RacingSerieId = ?) AND k3_.keywordID IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 15

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ WHERE k0_.KeywordId IN (?)

SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))

SELECT t0.RacingSerieId AS RacingSerieId_1, t0.RewriteUrl AS RewriteUrl_2, t0.IsDefault AS IsDefault_3, t0.SiteId AS SiteId_4, t0.CountryIso AS CountryIso_5 FROM RacingSeries t0 WHERE t0.RewriteUrl = ? AND t0.SiteId IN (?) AND ((t0.SiteId IN ('1'))) LIMIT 1

SELECT a0_.ArticleId AS ArticleId_0, a0_.RewriteUrl AS RewriteUrl_1, a0_.Title AS Title_2, a0_.SeoDescription AS SeoDescription_3, a0_.SeoTitle AS SeoTitle_4, a0_.coAuthor AS coAuthor_5, a0_.Icon AS Icon_6, a0_.Category AS Category_7, a0_.Content AS Content_8, a0_.PublishDate AS PublishDate_9, a0_.CreateDate AS CreateDate_10, a0_.CreateTime AS CreateTime_11, a0_.CommentType AS CommentType_12, a0_.AllowNewComments AS AllowNewComments_13, a0_.cntnlang AS cntnlang_14, a0_.LastUpdateDate AS LastUpdateDate_15, a0_.ArticleType AS ArticleType_16, a0_.CommentCount AS CommentCount_17, a0_.Activated AS Activated_18, a0_.StickyUntil AS StickyUntil_19, a0_.ViewCount AS ViewCount_20, a0_.PushEnabled AS PushEnabled_21, a0_.PushTitle AS PushTitle_22, a0_.PushMessage AS PushMessage_23, a0_.breaking AS breaking_24, a0_.breaking_title AS breaking_title_25, a0_.TestMode AS TestMode_26, r1_.RacingSerieId AS RacingSerieId_27, r1_.RewriteUrl AS RewriteUrl_28, r1_.IsDefault AS IsDefault_29, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_30, r2_.LanguageCode AS LanguageCode_31, r2_.ShortName AS ShortName_32, r2_.LongName AS LongName_33, a0_.SiteId AS SiteId_34, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_35, a0_.RacingSerieId AS RacingSerieId_36, a0_.PhotoAlbumId AS PhotoAlbumId_37, a0_.CmsAccountId AS CmsAccountId_38, a0_.PollId AS PollId_39, a0_.RaceSessionId AS RaceSessionId_40, r1_.SiteId AS SiteId_41, r1_.CountryIso AS CountryIso_42, r2_.RacingSerieId AS RacingSerieId_43 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'nl') INNER JOIN keyword_combinations k3_ ON (k3_.nieuwsID = a0_.ArticleId) WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RacingSerieId = ?) AND k3_.keywordID IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 15

module:Layout\Footer (0Q - total module time: 0.00765514s)