#0 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling()
#1 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(390): Twig\Template->display()
#2 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Extension/CoreExtension.php(1290): Twig\Template->render()
#3 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Environment.php(418) : eval()'d code(710): twig_include()
#4 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(405): __TwigTemplate_604f21f4961bdf846178afacaeb2cda290b7afdf9f793b65c989a9d0fb969f7b->doDisplay()
#5 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling()
#6 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Environment.php(418) : eval()'d code(45): Twig\Template->display()
#7 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(405): __TwigTemplate_7cadfa4cc8e0597cd666c7f51b9ecb8970de1fc216bde37023794e111eb4d32c->doDisplay()
#8 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling()
#9 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Environment.php(418) : eval()'d code(44): Twig\Template->display()
#10 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(405): __TwigTemplate_894589f23893a7de8539da4533a8bd86c733e4f5bc8e041e4b6b5fe4edcd1c39->doDisplay()
#11 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling()
#12 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Template.php(390): Twig\Template->display()
#13 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render()
#14 /var/www/dev-priyantha.gptoday.net/public_html/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render()
#15 /var/www/dev-priyantha.gptoday.net/public_html/app/Services/ViewRenderer/TwigRenderer.php(115): Twig\Environment->render()
#16 /var/www/dev-priyantha.gptoday.net/public_html/app/ViewTrait.php(98): F1T\Services\ViewRenderer\TwigRenderer->render()
#17 /var/www/dev-priyantha.gptoday.net/public_html/app/ViewTrait.php(79): F1T\Controllers\BaseController->renderViewFile()
#18 /var/www/dev-priyantha.gptoday.net/public_html/app/website.php(261): F1T\Controllers\BaseController->render()
#19 /var/www/dev-priyantha.gptoday.net/public_html/index.php(11): require_once('...')
#20 {main}An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, d2_.iso AS iso_19, d2_.iso3 AS iso3_20, d2_.numcode AS numcode_21, p3_.PersonCareerId AS PersonCareerId_22, p3_.StartDate AS StartDate_23, p3_.EndDate AS EndDate_24, p3_.ProfilePhoto AS ProfilePhoto_25, p3_.StartNumber AS StartNumber_26, o4_.OrganisationHistoryId AS OrganisationHistoryId_27, o4_.Name AS Name_28, o4_.StartDate AS StartDate_29, o4_.EndDate AS EndDate_30, o4_.Photo AS Photo_31, o4_.SmallLogo AS SmallLogo_32, o4_.City AS City_33, o4_.Website AS Website_34, o5_.OrganisationId AS OrganisationId_35, o5_.Name AS Name_36, o5_.FoundingDate AS FoundingDate_37, o5_.Photo AS Photo_38, o6_.OrganisationId AS OrganisationId_39, o6_.Name AS Name_40, o6_.FoundingDate AS FoundingDate_41, o6_.Photo AS Photo_42, k7_.KeywordId AS KeywordId_43, k7_.Keyword AS Keyword_44, k7_.RewriteUrl AS RewriteUrl_45, k7_.Category AS Category_46, k7_.CommentCount AS CommentCount_47, p0_.Nationality AS Nationality_48, p0_.KeywordId AS KeywordId_49, p0_.PrimaryCareerId AS PrimaryCareerId_50, p0_.SiteId AS SiteId_51, k1_.ParentId AS ParentId_52, p3_.PersonRoleId AS PersonRoleId_53, p3_.OrganisationHistoryId AS OrganisationHistoryId_54, p3_.PersonId AS PersonId_55, o4_.OrganisationRoleId AS OrganisationRoleId_56, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_57, o4_.RacingSerieId AS RacingSerieId_58, o5_.KeywordId AS KeywordId_59, o5_.Nationality AS Nationality_60, o6_.KeywordId AS KeywordId_61, o6_.Nationality AS Nationality_62, k7_.ParentId AS ParentId_63 FROM Persons p0_ INNER JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId INNER JOIN db_countries d2_ ON p0_.Nationality = d2_.iso INNER JOIN db_countries_trnsl d8_ ON d2_.iso = d8_.ISO INNER JOIN PersonCareer p3_ ON p0_.PersonId = p3_.PersonId INNER JOIN OrganisationHistory o4_ ON p3_.OrganisationHistoryId = o4_.OrganisationHistoryId INNER JOIN OrganisationOrganisationHistory o9_ ON o4_.OrganisationHistoryId = o9_.OrganisationHistoryId INNER JOIN Organisations o5_ ON o5_.OrganisationId = o9_.OrganisationId INNER JOIN Organisations o6_ ON o4_.PrimaryOrganisationId = o6_.OrganisationId INNER JOIN Keywords k7_ ON o6_.KeywordId = k7_.KeywordId WHERE d8_.cntnlang = ? AND p0_.InHeaderList = 1 AND ((p3_.StartDate >= ? AND p3_.EndDate <= ?) AND p3_.PersonRoleId IN (?)) ORDER BY p0_.FirstName ASC, p0_.LastName ASC' with params ["en", "1900-01-01 00:00:00", "2199-01-01 00:00:00", 1]:
SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_426_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")").object(stdClass)#574 (13) {
["__CLASS__"]=>
string(23) "Twig\Error\RuntimeError"
["lineno:Twig\Error\Error:private"]=>
int(162)
["name:Twig\Error\Error:private"]=>
string(21) "structure/header.twig"
["rawMessage:Twig\Error\Error:private"]=>
string(3206) "An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, d2_.iso AS iso_19, d2_.iso3 AS iso3_20, d2_.numcode AS numcode_21, p3_.PersonCareerId AS PersonCareerId_22, p3_.StartDate AS StartDate_23, p3_.EndDate AS EndDate_24, p3_.ProfilePhoto AS ProfilePhoto_25, p3_.StartNumber AS StartNumber_26, o4_.OrganisationHistoryId AS OrganisationHistoryId_27, o4_.Name AS Name_28, o4_.StartDate AS StartDate_29, o4_.EndDate AS EndDate_30, o4_.Photo AS Photo_31, o4_.SmallLogo AS SmallLogo_32, o4_.City AS City_33, o4_.Website AS Website_34, o5_.OrganisationId AS OrganisationId_35, o5_.Name AS Name_36, o5_.FoundingDate AS FoundingDate_37, o5_.Photo AS Photo_38, o6_.OrganisationId AS OrganisationId_39, o6_.Name AS Name_40, o6_.FoundingDate AS FoundingDate_41, o6_.Photo AS Photo_42, k7_.KeywordId AS KeywordId_43, k7_.Keyword AS Keyword_44, k7_.RewriteUrl AS RewriteUrl_45, k7_.Category AS Category_46, k7_.CommentCount AS CommentCount_47, p0_.Nationality AS Nationality_48, p0_.KeywordId AS KeywordId_49, p0_.PrimaryCareerId AS PrimaryCareerId_50, p0_.SiteId AS SiteId_51, k1_.ParentId AS ParentId_52, p3_.PersonRoleId AS PersonRoleId_53, p3_.OrganisationHistoryId AS OrganisationHistoryId_54, p3_.PersonId AS PersonId_55, o4_.OrganisationRoleId AS OrganisationRoleId_56, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_57, o4_.RacingSerieId AS RacingSerieId_58, o5_.KeywordId AS KeywordId_59, o5_.Nationality AS Nationality_60, o6_.KeywordId AS KeywordId_61, o6_.Nationality AS Nationality_62, k7_.ParentId AS ParentId_63 FROM Persons p0_ INNER JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId INNER JOIN db_countries d2_ ON p0_.Nationality = d2_.iso INNER JOIN db_countries_trnsl d8_ ON d2_.iso = d8_.ISO INNER JOIN PersonCareer p3_ ON p0_.PersonId = p3_.PersonId INNER JOIN OrganisationHistory o4_ ON p3_.OrganisationHistoryId = o4_.OrganisationHistoryId INNER JOIN OrganisationOrganisationHistory o9_ ON o4_.OrganisationHistoryId = o9_.OrganisationHistoryId INNER JOIN Organisations o5_ ON o5_.OrganisationId = o9_.OrganisationId INNER JOIN Organisations o6_ ON o4_.PrimaryOrganisationId = o6_.OrganisationId INNER JOIN Keywords k7_ ON o6_.KeywordId = k7_.KeywordId WHERE d8_.cntnlang = ? AND p0_.InHeaderList = 1 AND ((p3_.StartDate >= ? AND p3_.EndDate | Total queries: 11 | ||||||
| Total time: 0.52978992462158 | ||||||
| time | sincestart | caller | annotate | bt | desc | |
| 0.009032 | instantiate query log (1Q - total module time: 0.06539202s) | "" | ||||
| 0.01899695 | 0.019558 | /var/www/dev-priyantha.gptoday.net/public_html/app/website.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:750(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:241(load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:47(findOneBy) {"function":"{closure}","args":[]} /var/www/dev-priyantha.gptoday.net/public_html/app/Services/Cache.php:144(call_user_func) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:48(lazyFetch) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT t0.SiteId AS SiteId_1, t0.Name AS Name_2 FROM Sites t0 WHERE t0.SiteId = ? LIMIT 1 | ["1"] | |
| 0.074433 | boot (1Q - total module time: 0.05270600s) | "" | ||||
| 0.00110197 | 0.121751 | /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Languages.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Languages.php:62(getResult) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:73(findVisible) {"function":"{closure}","args":[]} /var/www/dev-priyantha.gptoday.net/public_html/app/Services/Cache.php:144(call_user_func) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:74(lazyFetch) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT l0_.LanguageId AS LanguageId_0, l0_.Code AS Code_1, l0_.FlagCode AS FlagCode_2, l0_.LongName AS LongName_3, l0_.Visible AS Visible_4, l0_.Maintained AS Maintained_5, l0_.SortOrder AS SortOrder_6, l0_.SiteId AS SiteId_7 FROM Languages l0_ WHERE l0_.Visible = 1 AND l0_.SiteId IN (?) ORDER BY l0_.SortOrder ASC | [["1"]] | |
| 0.127146 | translation-init (1Q - total module time: 0.00794291s) | "" | ||||
| 0.00043082 | 0.134638 | /var/www/dev-priyantha.gptoday.net/public_html/index.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:189(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Redirect.php:105(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Entities/Redirect.php:112(findByOrigin) /var/www/dev-priyantha.gptoday.net/public_html/app/Services/Redirects.php:108(getRedirectOrFalse) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:115(checkForDBRedirects) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) |
SELECT
redirects.id,
redirects.origin,
redirects.referer
FROM
redirects
WHERE
redirects.origin = :origin
ORDER BY
id
| {"origin":"\/en\/results\/fp1\/2019\/06\/07\/grand-prix-of-canada"} | |
| 0.135095 | controller::results/fp1/2019/06/07/grand-prix-of-canada (2Q - total module time: 0.15941787s) | "" | ||||
| 0.08375502 | 0.137650 | /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:525(getResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:43(findByUrlAndDate) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT r0_.RaceSessionId AS RaceSessionId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.TrackTemperature AS TrackTemperature_3, r0_.AirTemperature AS AirTemperature_4, r0_.TrackFlag AS TrackFlag_5, r1_.RaceCalendarId AS RaceCalendarId_6, r1_.GridPosition AS GridPosition_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingSessionTypeId AS RacingSessionTypeId_11, r3_.RewriteUrl AS RewriteUrl_12, r3_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_13, r3_.SortingOrder AS SortingOrder_14, r3_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_15, r3_.MainEventAtBeginning AS MainEventAtBeginning_16, r3_.DefaultDuration AS DefaultDuration_17, r3_.ResultType AS ResultType_18, r3_.DefaultAdd AS DefaultAdd_19, r4_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_20, r4_.LanguageCode AS LanguageCode_21, r4_.Name AS Name_22, r5_.RaceSeasonId AS RaceSeasonId_23, r5_.Year AS Year_24, r6_.RaceTrackHistoryId AS RaceTrackHistoryId_25, r6_.LapLength AS LapLength_26, r6_.LapCount AS LapCount_27, r6_.Map AS Map_28, r6_.Impression AS Impression_29, r6_.StartDate AS StartDate_30, r6_.EndDate AS EndDate_31, r7_.RaceTrackId AS RaceTrackId_32, r7_.Name AS Name_33, r7_.RewriteUrl AS RewriteUrl_34, r7_.FoundingDate AS FoundingDate_35, r7_.Website AS Website_36, r7_.Description AS Description_37, c8_.CityId AS CityId_38, c8_.Latitude AS Latitude_39, c8_.Longitude AS Longitude_40, c8_.TimeOffsetFromUtc AS TimeOffsetFromUtc_41, c9_.CityTranslationId AS CityTranslationId_42, c9_.LanguageCode AS LanguageCode_43, c9_.Name AS Name_44, d10_.iso AS iso_45, d10_.iso3 AS iso3_46, d10_.numcode AS numcode_47, d11_.cntnlang AS cntnlang_48, d11_.printable_name AS printable_name_49, r12_.RacingEventsTranslationId AS RacingEventsTranslationId_50, r12_.LanguageCode AS LanguageCode_51, r12_.Name AS Name_52, r0_.RacingSessionTypeId AS RacingSessionTypeId_53, r0_.RaceCalendarId AS RaceCalendarId_54, r0_.WeatherTypeId AS WeatherTypeId_55, r0_.PhotoAlbumId AS PhotoAlbumId_56, r1_.RaceSeasonId AS RaceSeasonId_57, r1_.RacingEventId AS RacingEventId_58, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_59, r2_.CircuitId AS CircuitId_60, r2_.WinnerId AS WinnerId_61, r2_.RacingSerieId AS RacingSerieId_62, r2_.RacingEventTypeId AS RacingEventTypeId_63, r2_.CountryIso AS CountryIso_64, r3_.RacingSerieId AS RacingSerieId_65, r3_.RacingEventTypeId AS RacingEventTypeId_66, r4_.RacingSessionTypeId AS RacingSessionTypeId_67, r5_.SiteId AS SiteId_68, r5_.RacingSerieId AS RacingSerieId_69, r6_.RaceTrackId AS RaceTrackId_70, r7_.CityId AS CityId_71, c8_.Country AS Country_72, c9_.CityId AS CityId_73, d11_.ISO AS ISO_74, r12_.RacingEventId AS RacingEventId_75 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r1_.RacingEventId = r2_.RacingEventId INNER JOIN RacingSessionTypes r3_ ON r0_.RacingSessionTypeId = r3_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r4_ ON r3_.RacingSessionTypeId = r4_.RacingSessionTypeId AND (r4_.LanguageCode = 'en') INNER JOIN RaceSeasons r5_ ON r1_.RaceSeasonId = r5_.RaceSeasonId AND (r5_.SiteId IN ('1')) INNER JOIN RaceTrackHistory r6_ ON r1_.RaceTrackHistoryId = r6_.RaceTrackHistoryId INNER JOIN RaceTracks r7_ ON r6_.RaceTrackId = r7_.RaceTrackId INNER JOIN Cities c8_ ON r7_.CityId = c8_.CityId INNER JOIN CityTranslations c9_ ON c8_.CityId = c9_.CityId AND (c9_.LanguageCode = 'en') INNER JOIN db_countries d10_ ON c8_.Country = d10_.iso INNER JOIN db_countries_trnsl d11_ ON d10_.iso = d11_.ISO INNER JOIN RacingEventsTranslations r12_ ON r2_.RacingEventId = r12_.RacingEventId AND (r12_.LanguageCode = 'en') WHERE DATE(r0_.StartTime) = ? AND r3_.RewriteUrl = ? AND c9_.LanguageCode = ? AND d11_.cntnlang = ? | [{"date":"2019-06-07 00:00:00.000000","timezone_type":3,"timezone":"Europe\/Amsterdam"},"fp1","en","en"] | |
| 0.06667686 | 0.227782 | /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:319(fetchAll) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:75(findResultsByCriteria) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:123(findSingleRaceResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) |
/* findByCriteria01 */
SELECT
CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`,
CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`,
CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`,
res.`RaceResultId`,
res.`RaceParticipantId`,
res.`LapTime`,
res.`LapCount`,
res.`Position`,
res.`Result`,
res.`DidNotFinish`,
res.`DidNotStart`,
res.`Points`,
res.`Pitted`,
res.`MaxSpeed`,
res.`AverageSpeed`,
perc.`PersonCareerId` AS `PersonCareerId`,
perc.`StartDate` AS `CareerStartDate`,
perc.`EndDate` AS `CareerEndDate`,
perc.`ProfilePhoto` AS `CareerPhoto`,
perc.`StartNumber` AS `CareerStartNumber`,
perc.`PersonId` AS `PersonId`,
orgh.`PrimaryOrganisationId` AS `OrganisationId`,
rs.`RaceSessionId` AS `RaceSessionId`,
rst.`ResultType` AS `SessionTypeResultType`,
rc.`Name` AS `RacingClassName`,
rt.`Name` AS `TireName`,
rt.`Colour` AS `TireColour`,
eng.`Name` AS `EngineName`,
eng.`ReleaseDate` AS `EngineReleaseDate`,
eng.`CylinderCount` AS `EngineCylinderCount`,
eng.`EngineType` AS `EngineType`,
eng.`Volume` AS `EngineVolume`,
eman.`Name` AS `EngineManufacturerName`,
chas.`Name` AS `ChassisName`,
chas.`ReleaseDate` AS `ChassisReleaseDate`
FROM
`RaceResults` res
JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId`
JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId`
JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId
JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId`
JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId`
JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId`
JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId`
JOIN `Engines` eng ON eng.`EngineId` = par.`EngineId`
JOIN `Chassis` chas ON par.`ChassisId` = chas.`ChassisId`
JOIN `OrganisationHistory` eman ON eng.`ManufacturerOrganisationHistoryId` = eman.`OrganisationHistoryId`
JOIN `OrganisationHistory` cman ON chas.`ManufacturerOrganisationHistoryId` = cman.`OrganisationHistoryId`
JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId`
WHERE
1 = 1
AND rs.RaceSessionId = :param1 ORDER BY `SortOne` ASC, `res`.`LapTime` ASC, `res`.`LapCount` DESC | {":param1":1169} | |
| 0.294521 | query01 returned 20 rows (6Q - total module time: 0.23526311s) | "" | ||||
| 0.05550504 | 0.294528 | /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:385(fetchAll) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:75(findResultsByCriteria) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:123(findSingleRaceResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) |
/* findByCriteria02 */
SELECT
res.`RaceResultId`,
perc.`PersonCareerId` AS `PersonCareerId`,
perc.`StartDate` AS `CareerStartDate`,
perc.`EndDate` AS `CareerEndDate`,
perc.`ProfilePhoto` AS `CareerPhoto`,
perc.`StartNumber` AS `CareerStartNumber`,
prt.`Name` AS `CareerRoleName`,
per.`PersonId` AS `PersonId`,
per.`Nationality` AS `PersonNationality`,
per.`LastName` AS `PersonLastName`,
per.`FirstName` AS `PersonFirstName`,
per.`BirthDate` AS `PersonBirthDate`,
per.`DateOfDeath` AS `PersonDateOfDeath`,
per.`Residence` AS `PersonResidence`,
per.`ProfilePhoto` AS `PersonPhoto`,
per.`Height` AS `PersonHeight`,
per.`Website` AS `PersonWebsite`,
per.`Weight` AS `PersonWeight`,
per.`BirthCity` AS `PersonBirthCity`,
orgh.`OrganisationHistoryId` AS `OrganisationHistoryId`,
orgh.`Name` AS `OrghName`,
orgh.`StartDate` AS `OrghStartDate`,
orgh.`EndDate` AS `OrghEndDate`,
orgh.`Photo` AS `OrghPhoto`,
orgh.`City` AS `OrghCity`,
orgh.Website AS `OrghWebsite`,
orgh.`SmallLogo` AS `OrghSmallLogo`,
org.`OrganisationId`,
org.`Nationality` AS `OrgNationality`,
org.`Name` AS `OrgName`,
org.`FoundingDate` AS `OrgFoundingDate`,
org.`Photo` AS `OrgPhoto`,
kw1.`Keyword` AS `OrgKeyword`,
kw1.`RewriteUrl` AS `OrgRewriteUrl`,
kw2.`Keyword` AS `PersonKeyword`,
kw2.`RewriteUrl` AS `PersonRewriteUrl`
FROM
`RaceResults` res
JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId`
JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId`
JOIN `PersonRoles` pr ON perc.`PersonRoleId` = pr.`PersonRoleId`
JOIN `PersonRolesTranslations` prt ON pr.`PersonRoleId` = prt.`PersonRoleId` AND prt.`LanguageCode` = 'en'
JOIN `Persons` per ON per.PersonId = perc.PersonId
JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId
JOIN `Organisations` org ON org.OrganisationId = orgh.PrimaryOrganisationId
JOIN `db_countries` co1 ON co1.`iso` = org.`Nationality`
JOIN `db_countries` co2 ON co2.`iso` = per.`Nationality`
JOIN `Keywords` kw1 ON org.`KeywordId` = kw1.`KeywordId`
JOIN `Keywords` kw2 ON per.`KeywordId` = kw2.`KeywordId`
WHERE
res.`RaceParticipantId` IN (21797,21798,21791,21801,21792,21790,21795,21803,21800,21793,21796,21804,21802,21789,21794,21805,21799,21806,21807,23947)
| {":param1":1169} | |
| 0.00108886 | 0.350094 | /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:432(fetchAll) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:75(findResultsByCriteria) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:123(findSingleRaceResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) |
/* findByCriteria03 */
SELECT
res.`RaceParticipantId`,
res.`RaceResultId`,
rs.`RaceSessionId` AS `RaceSessionId`,
rs.`StartTime` AS `SessionStartTime`,
rs.`EndTime` AS `SessionEndTime`,
rs.`TrackTemperature` AS `TrackTemperature`,
rs.`AirTemperature` AS `AirTemperature`,
rs.`TrackFlag` AS `TrackFlag`,
cal.`RaceCalendarId` AS `RaceCalendarId`,
cal.`RaceSeasonId` AS `RaceSeasonId`,
cal.`GridPosition` AS `GridPosition`,
rs.`PhotoAlbumId` AS `SessionPhotoAlbumId`,
rst.`RewriteUrl` AS `SessionTypeRewriteUrl`,
rst.`ResultType` AS `SessionTypeResultType`,
re.`RewriteUrl` AS `RaceEventRewriteUrl`,
re.`CountryIso` AS `RaceEventIso`,
ret.`Name` AS `RaceEventName`,
rt.`Name` AS `TireName`,
rt.`Colour` AS `TireColour`,
rse.`RewriteUrl` AS `RacingSerieRewriteUrl`,
rset.`ShortName` AS `RacingSerieShortName`,
rset.`LongName` AS `RacingSeriesLongName`
FROM
`RaceResults` res
JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId`
JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId`
JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId`
JOIN `RacingSessionTypesTranslations` rstt ON rst.`RacingSessionTypeId` = rstt.`RacingSessionTypeId` AND rstt.`LanguageCode` = 'en'
JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId`
JOIN `RacingEvents` re ON re.`RacingEventId` = cal.`RacingEventId`
JOIN `RacingEventsTranslations` ret ON re.`RacingEventId` = ret.`RacingEventId` AND ret.`LanguageCode` = 'en'
JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId`
JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId`
JOIN `RacingSeries` rse ON rc.`RacingSerieId` = rse.`RacingSerieId`
JOIN `RacingSeriesTranslations` rset ON rse.`RacingSerieId` = rset.`RacingSerieId` AND rset.`LanguageCode` = 'en'
WHERE
res.`RaceParticipantId` IN (21797,21798,21791,21801,21792,21790,21795,21803,21800,21793,21796,21804,21802,21789,21794,21805,21799,21806,21807,23947)
| {":param1":1169} | |
| 0.00265694 | 0.352118 | /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php:54(getResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:439(findByParticipants) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:75(findResultsByCriteria) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:123(findSingleRaceResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT r0_.RaceSessionIncidentId AS RaceSessionIncidentId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.LapNumber AS LapNumber_3, r1_.RacingIncidentId AS RacingIncidentId_4, r1_.IncidentType AS IncidentType_5, r1_.PenaltyPoints AS PenaltyPoints_6, r1_.PenaltyPositions AS PenaltyPositions_7, r2_.RacingIncidentsTranslationId AS RacingIncidentsTranslationId_8, r2_.LanguageCode AS LanguageCode_9, r2_.Description AS Description_10, r3_.RaceParticipantId AS RaceParticipantId_11, p4_.PersonCareerId AS PersonCareerId_12, p4_.StartDate AS StartDate_13, p4_.EndDate AS EndDate_14, p4_.ProfilePhoto AS ProfilePhoto_15, p4_.StartNumber AS StartNumber_16, p5_.PersonId AS PersonId_17, p5_.LastName AS LastName_18, p5_.FirstName AS FirstName_19, p5_.Birthdate AS Birthdate_20, p5_.DateOfDeath AS DateOfDeath_21, p5_.Residence AS Residence_22, p5_.BirthCity AS BirthCity_23, p5_.ProfilePhoto AS ProfilePhoto_24, p5_.Height AS Height_25, p5_.Website AS Website_26, p5_.Weight AS Weight_27, p5_.InternalNotes AS InternalNotes_28, p5_.InHeaderList AS InHeaderList_29, p5_.InFooterList AS InFooterList_30, d6_.iso AS iso_31, d6_.iso3 AS iso3_32, d6_.numcode AS numcode_33, d7_.cntnlang AS cntnlang_34, d7_.printable_name AS printable_name_35, r0_.RacingIncidentId AS RacingIncidentId_36, r0_.RaceParticipantId AS RaceParticipantId_37, r0_.RacingIncidentLocationId AS RacingIncidentLocationId_38, r2_.RacingIncidentId AS RacingIncidentId_39, r3_.RaceSessionId AS RaceSessionId_40, r3_.PersonCareerId AS PersonCareerId_41, r3_.RacingClassId AS RacingClassId_42, r3_.EngineId AS EngineId_43, r3_.RacingTireId AS RacingTireId_44, r3_.ChassisId AS ChassisId_45, p4_.PersonRoleId AS PersonRoleId_46, p4_.OrganisationHistoryId AS OrganisationHistoryId_47, p4_.PersonId AS PersonId_48, p5_.Nationality AS Nationality_49, p5_.KeywordId AS KeywordId_50, p5_.PrimaryCareerId AS PrimaryCareerId_51, p5_.SiteId AS SiteId_52, d7_.ISO AS ISO_53 FROM RaceSessionIncidents r0_ INNER JOIN RacingIncidents r1_ ON r0_.RacingIncidentId = r1_.RacingIncidentId INNER JOIN RacingIncidentsTranslations r2_ ON r1_.RacingIncidentId = r2_.RacingIncidentId AND (r2_.LanguageCode = 'en') INNER JOIN RaceParticipants r3_ ON r0_.RaceParticipantId = r3_.RaceParticipantId INNER JOIN PersonCareer p4_ ON r3_.PersonCareerId = p4_.PersonCareerId INNER JOIN Persons p5_ ON p4_.PersonId = p5_.PersonId INNER JOIN db_countries d6_ ON p5_.Nationality = d6_.iso INNER JOIN db_countries_trnsl d7_ ON d6_.iso = d7_.ISO WHERE r0_.RaceParticipantId IN (?) | [{"21797":"21797","21798":"21798","21791":"21791","21801":"21801","21792":"21792","21790":"21790","21795":"21795","21803":"21803","21800":"21800","21793":"21793","21796":"21796","21804":"21804","21802":"21802","21789":"21789","21794":"21794","21805":"21805","21799":"21799","21806":"21806","21807":"21807","23947":"23947"}] | |
| 0.00388598 | 0.357026 | /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:321(fetchAll) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:124(findParticipants) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT
1 AS `SortOne`,
1 AS `SortTwo`,
9999 AS `SortThree`,
CONCAT(per.FirstName, ' ', per.LastName) AS `FullDriverName`,
per.`PersonId` AS `PersonId`,
per.`LastName` AS `DriverLastName`,
per.`Nationality` AS `DriverNationality`,
orgh.`Name` AS `TeamName`,
orgh.`SmallLogo` AS `SmallTeamLogo`,
par.`RaceParticipantId`,
par.`PersonCareerId`,
par.`ChassisId`,
par.`EngineId`,
par.`RacingClassId`,
par.`RacingTireId`,
orgh.`OrganisationHistoryId`,
0 AS `LapTime`,
0 AS `LapCount`,
0 AS `RacePosition`,
0 AS `RacePoints`,
'' AS `RaceResult`,
FALSE AS `DidNotFinish`,
FALSE AS `DidNotStart`,
FALSE AS `Pitted`,
0 AS `MaxSpeed`,
0 AS `AverageSpeed`,
NULL AS `RacingIncident`,
1 AS `HasResults`,
chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`,
ch.`Name` AS `ChassisName`
FROM
`RaceParticipants` par
JOIN `PersonCareer` perc ON perc.PersonCareerId = par.PersonCareerId
JOIN `Persons` per ON per.PersonId = perc.PersonId
JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId
JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId`
LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId`
LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId`
WHERE
par.`RaceSessionId` = :raceSessionId
UNION
SELECT
CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`,
CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`,
CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`,
CONCAT(per.`FirstName`, ' ', per.`LastName`) AS `FullDriverName`,
per.`PersonId` AS `PersonId`,
per.`LastName` AS `DriverLastName`,
per.`Nationality` AS `DriverNationality`,
orgh.`Name` AS `TeamName`,
orgh.`SmallLogo` AS `SmallTeamLogo`,
par.`RaceParticipantId`,
par.`PersonCareerId`,
par.`ChassisId`,
par.`EngineId`,
par.`RacingClassId`,
par.`RacingTireId`,
orgh.`OrganisationHistoryId`,
0 + `LapTime` AS `LapTime`,
0 + `LapCount` AS `LapCount`,
0 + `Position` AS `RacePosition`,
0 + `Points` AS `RacePoints`,
`Result` AS `RaceResult`,
`DidNotFinish` AS `DidNotFinish`,
`DidNotStart` AS `DidNotStart`,
`Pitted` AS `Pitted`,
0 + `MaxSpeed` AS `MaxSpeed`,
0 + `AverageSpeed` AS `AverageSpeed`,
`RacingIncidentId` AS `RacingIncident`,
2 AS `HasResults`,
chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`,
ch.`Name` AS `ChassisName`
FROM
`RaceResults` res
JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId`
JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId`
JOIN `Persons` per ON per.PersonId = perc.PersonId
JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId
JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId`
LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId`
LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId`
WHERE
`RaceSessionId` = :raceSessionId
ORDER BY
`HasResults` DESC,
SortOne ASC, LapTime ASC, LapCount DESC,`OrganisationHistoryId`,
`PersonCareerId` | {"raceSessionId":1169} | |
| 0.00172520 | 0.361606 | /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:124(getScalarResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:704(commonCriteria) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:159(findRaceReport) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1')) | ["Articles",["Nieuws","LiveRaceReport","Liveblog"],"en"] | |
| 0.03307796 | 0.364141 | /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php | /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache) /var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute) /var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:710(getResult) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:159(findRaceReport) /var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Results.php:24(handleRace) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch) /var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load) /var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute) /var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once) | 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 = 'en') WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.Category = ?) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100 | [["en"],["1"],true,{"date":"2025-08-08 15:25:00.000000","timezone_type":3,"timezone":"Europe\/Amsterdam"},["Nieuws","LiveRaceReport","Liveblog"],9,[1169]] | |
| 0.00000000 | -1,754,659,525.256242 | x | x | SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, d2_.iso AS iso_19, d2_.iso3 AS iso3_20, d2_.numcode AS numcode_21, p3_.PersonCareerId AS PersonCareerId_22, p3_.StartDate AS StartDate_23, p3_.EndDate AS EndDate_24, p3_.ProfilePhoto AS ProfilePhoto_25, p3_.StartNumber AS StartNumber_26, o4_.OrganisationHistoryId AS OrganisationHistoryId_27, o4_.Name AS Name_28, o4_.StartDate AS StartDate_29, o4_.EndDate AS EndDate_30, o4_.Photo AS Photo_31, o4_.SmallLogo AS SmallLogo_32, o4_.City AS City_33, o4_.Website AS Website_34, o5_.OrganisationId AS OrganisationId_35, o5_.Name AS Name_36, o5_.FoundingDate AS FoundingDate_37, o5_.Photo AS Photo_38, o6_.OrganisationId AS OrganisationId_39, o6_.Name AS Name_40, o6_.FoundingDate AS FoundingDate_41, o6_.Photo AS Photo_42, k7_.KeywordId AS KeywordId_43, k7_.Keyword AS Keyword_44, k7_.RewriteUrl AS RewriteUrl_45, k7_.Category AS Category_46, k7_.CommentCount AS CommentCount_47, p0_.Nationality AS Nationality_48, p0_.KeywordId AS KeywordId_49, p0_.PrimaryCareerId AS PrimaryCareerId_50, p0_.SiteId AS SiteId_51, k1_.ParentId AS ParentId_52, p3_.PersonRoleId AS PersonRoleId_53, p3_.OrganisationHistoryId AS OrganisationHistoryId_54, p3_.PersonId AS PersonId_55, o4_.OrganisationRoleId AS OrganisationRoleId_56, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_57, o4_.RacingSerieId AS RacingSerieId_58, o5_.KeywordId AS KeywordId_59, o5_.Nationality AS Nationality_60, o6_.KeywordId AS KeywordId_61, o6_.Nationality AS Nationality_62, k7_.ParentId AS ParentId_63 FROM Persons p0_ INNER JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId INNER JOIN db_countries d2_ ON p0_.Nationality = d2_.iso INNER JOIN db_countries_trnsl d8_ ON d2_.iso = d8_.ISO INNER JOIN PersonCareer p3_ ON p0_.PersonId = p3_.PersonId INNER JOIN OrganisationHistory o4_ ON p3_.OrganisationHistoryId = o4_.OrganisationHistoryId INNER JOIN OrganisationOrganisationHistory o9_ ON o4_.OrganisationHistoryId = o9_.OrganisationHistoryId INNER JOIN Organisations o5_ ON o5_.OrganisationId = o9_.OrganisationId INNER JOIN Organisations o6_ ON o4_.PrimaryOrganisationId = o6_.OrganisationId INNER JOIN Keywords k7_ ON o6_.KeywordId = k7_.KeywordId WHERE d8_.cntnlang = ? AND p0_.InHeaderList = 1 AND ((p3_.StartDate >= ? AND p3_.EndDate <= ?) AND p3_.PersonRoleId IN (?)) ORDER BY p0_.FirstName ASC, p0_.LastName ASC | ["en",{"date":"1900-01-01 00:00:00.000000","timezone_type":3,"timezone":"Europe\/Amsterdam"},{"date":"2199-01-01 00:00:00.000000","timezone_type":3,"timezone":"Europe\/Amsterdam"},[1]] | |
| 0.529788 | done | "" | ||||