console-api |
log |
URL: https://discoveritallwv.com/(Line 264)
Message:
https://s3.amazonaws.com/discoveritallwv.com/videos/JC-home-video.mp4
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 433)
Message:
Application Log
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 435)
Message:
GET Info
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 436)
Message:
[19:36:33.145][info][application]
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 437)
Message:
console.groupEnd
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 438)
Message:
COOKIE Info
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 439)
Message:
[19:36:33.145][info][application]
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 440)
Message:
console.groupEnd
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 441)
Message:
SERVER Info
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 442)
Message:
[19:36:33.145][info][application]
$_SERVER=array (
'USER' => 'www-data',
'HOME' => '/var/www',
'HTTP_ACCEPT_LANGUAGE' => 'en-US',
'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br',
'HTTP_SEC_FETCH_DEST' => 'document',
'HTTP_SEC_FETCH_USER' => '?1',
'HTTP_SEC_FETCH_MODE' => 'navigate',
'HTTP_SEC_FETCH_SITE' => 'none',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9',
'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.109 Safari/537.36',
'HTTP_UPGRADE_INSECURE_REQUESTS' => '1',
'HTTP_CACHE_CONTROL' => 'no-cache',
'HTTP_PRAGMA' => 'no-cache',
'CRAFTENV_BASE_PATH' => 'REPLACE_ME',
'CRAFTENV_BASE_URL' => 'REPLACE_ME',
'CRAFTENV_SITE_URL' => 'REPLACE_ME',
'CRAFTENV_DB_PASS' => 'REPLACE_ME',
'CRAFTENV_DB_USER' => 'REPLACE_ME',
'CRAFTENV_DB_NAME' => 'REPLACE_ME',
'CRAFTENV_DB_HOST' => 'REPLACE_ME',
'CRAFTENV_CRAFT_ENVIRONMENT' => 'REPLACE_ME',
'HTTP_HOST' => 'discoveritallwv.com',
'PATH_INFO' => '',
'SCRIPT_FILENAME' => '/var/www/html/index.php',
'REDIRECT_STATUS' => '200',
'SERVER_NAME' => 'discoveritallwv.com',
'SERVER_PORT' => '443',
'SERVER_ADDR' => '142.93.78.233',
'REMOTE_PORT' => '20676',
'REMOTE_ADDR' => '185.210.217.121',
'SERVER_SOFTWARE' => 'nginx/1.10.3',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'HTTPS' => 'on',
'REQUEST_SCHEME' => 'https',
'SERVER_PROTOCOL' => 'HTTP/2.0',
'DOCUMENT_ROOT' => '/var/www/html',
'DOCUMENT_URI' => '/index.php',
'REQUEST_URI' => '/',
'SCRIPT_NAME' => '/index.php',
'CONTENT_LENGTH' => '',
'CONTENT_TYPE' => '',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => '',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1618947393.144979,
'REQUEST_TIME' => 1618947393,
)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 443)
Message:
console.groupEnd
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 444)
Message:
Logs
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 445)
Message:
[19:36:33.148][trace][system.CModule]
Loading "cache" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (138)
in /var/www/craft/app/bootstrap.php (190)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 446)
Message:
[19:36:33.148][trace][system.CModule]
Loading "path" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/cache/FileCache.php (41)
in /var/www/craft/app/services/CacheService.php (114)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 447)
Message:
[19:36:33.148][trace][system.CModule]
Loading "request" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (139)
in /var/www/craft/app/bootstrap.php (190)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 448)
Message:
[19:36:33.149][trace][system.caching.Craft\FileCache]
Serving "usePathInfo" from cache
in /var/www/craft/app/services/CacheService.php (180)
in /var/www/craft/app/services/ConfigService.php (392)
in /var/www/craft/app/services/HttpRequestService.php (1177)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 449)
Message:
[19:36:33.149][trace][system.CModule]
Loading "urlManager" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/services/HttpRequestService.php (1532)
in /var/www/craft/app/services/HttpRequestService.php (1184)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 450)
Message:
[19:36:33.149][trace][system.CModule]
Loading "log" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (140)
in /var/www/craft/app/bootstrap.php (190)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 451)
Message:
[19:36:33.149][trace][system.CModule]
Loading "coreMessages" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (143)
in /var/www/craft/app/bootstrap.php (190)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 452)
Message:
[19:36:33.149][trace][system.db.CDbConnection]
Opening DB connection
in /var/www/craft/app/etc/behaviors/AppBehavior.php (871)
in /var/www/craft/app/etc/web/WebApp.php (592)
in /var/www/craft/app/etc/behaviors/AppBehavior.php (80)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 453)
Message:
[19:36:33.150][trace][system.db.CDbCommand]
Querying SQL: SHOW TABLES LIKE 'craft_%'
in /var/www/craft/app/etc/db/schemas/MysqlSchema.php (312)
in /var/www/craft/app/etc/db/DbConnection.php (90)
in /var/www/craft/app/etc/behaviors/AppBehavior.php (98)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 454)
Message:
[19:36:33.150][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SHOW TABLES LIKE 'craft_%')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 455)
Message:
[19:36:33.151][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SHOW TABLES LIKE 'craft_%')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 456)
Message:
[19:36:33.151][trace][system.db.CDbCommand]
Querying SQL: SELECT *
FROM `craft_info` LIMIT 1
in /var/www/craft/app/etc/behaviors/AppBehavior.php (505)
in /var/www/craft/app/etc/behaviors/AppBehavior.php (200)
in /var/www/craft/app/etc/web/WebApp.php (772)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 457)
Message:
[19:36:33.151][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT *
FROM `craft_info` LIMIT 1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 458)
Message:
[19:36:33.151][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT *
FROM `craft_info` LIMIT 1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 459)
Message:
[19:36:33.151][trace][system.CModule]
Loading "userSession" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (168)
in /var/www/craft/app/index.php (73)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 460)
Message:
[19:36:33.151][trace][system.CModule]
Loading "httpSession" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (489)
in /var/www/craft/app/services/UserSessionService.php (93)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 461)
Message:
[19:36:33.152][trace][system.CModule]
Loading "session" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/services/UserSessionService.php (1068)
in /var/www/craft/app/services/UserSessionService.php (343)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 462)
Message:
[19:36:33.152][trace][system.CModule]
Loading "updates" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (216)
in /var/www/craft/app/index.php (73)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 463)
Message:
[19:36:33.152][trace][system.CModule]
Loading "plugins" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/WebApp.php (258)
in /var/www/craft/app/index.php (73)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 464)
Message:
[19:36:33.152][trace][system.db.CDbCommand]
Querying SQL: SELECT *
FROM `craft_plugins`
WHERE enabled=1
in /var/www/craft/app/services/PluginsService.php (104)
in /var/www/craft/app/etc/web/WebApp.php (258)
in /var/www/craft/app/index.php (73)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 465)
Message:
[19:36:33.152][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT *
FROM `craft_plugins`
WHERE enabled=1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 466)
Message:
[19:36:33.152][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT *
FROM `craft_plugins`
WHERE enabled=1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 467)
Message:
[19:36:33.157][trace][system.CModule]
Loading "messages" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/Craft.php (385)
in /var/www/craft/plugins/navee/NaveePlugin.php (8)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 468)
Message:
[19:36:33.157][trace][system.CModule]
Loading "i18n" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/behaviors/AppBehavior.php (831)
in /var/www/craft/app/etc/behaviors/AppBehavior.php (605)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 469)
Message:
[19:36:33.157][trace][system.db.CDbCommand]
Querying SQL: SELECT `locale`
FROM `craft_locales`
ORDER BY `sortOrder`
in /var/www/craft/app/services/LocalizationService.php (126)
in /var/www/craft/app/services/LocalizationService.php (150)
in /var/www/craft/app/services/LocalizationService.php (162)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 470)
Message:
[19:36:33.157][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `locale`
FROM `craft_locales`
ORDER BY `sortOrder`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 471)
Message:
[19:36:33.158][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `locale`
FROM `craft_locales`
ORDER BY `sortOrder`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 472)
Message:
[19:36:33.158][trace][system.CModule]
Loading "amForms_settings" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/plugins/amforms/AmFormsPlugin.php (18)
in /var/www/craft/app/services/PluginsService.php (1200)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 473)
Message:
[19:36:33.158][trace][system.db.ar.CActiveRecord]
Craft\AmForms_SettingRecord.findByAttributes()
in /var/www/craft/plugins/amforms/services/AmForms_SettingsService.php (63)
in /var/www/craft/plugins/amforms/AmFormsPlugin.php (18)
in /var/www/craft/app/services/PluginsService.php (1200)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 474)
Message:
[19:36:33.158][trace][system.db.CDbCommand]
Querying SQL: SHOW FULL COLUMNS FROM `craft_amforms_settings`
in /var/www/craft/plugins/amforms/services/AmForms_SettingsService.php (63)
in /var/www/craft/plugins/amforms/AmFormsPlugin.php (18)
in /var/www/craft/app/services/PluginsService.php (1200)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 475)
Message:
[19:36:33.158][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 476)
Message:
[19:36:33.159][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 477)
Message:
[19:36:33.159][trace][system.db.CDbCommand]
Querying SQL: SHOW CREATE TABLE `craft_amforms_settings`
in /var/www/craft/plugins/amforms/services/AmForms_SettingsService.php (63)
in /var/www/craft/plugins/amforms/AmFormsPlugin.php (18)
in /var/www/craft/app/services/PluginsService.php (1200)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 478)
Message:
[19:36:33.159][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SHOW CREATE TABLE `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 479)
Message:
[19:36:33.159][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SHOW CREATE TABLE `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 480)
Message:
[19:36:33.159][trace][system.db.CDbCommand]
Querying SQL: SELECT * FROM `craft_amforms_settings` `t` WHERE `t`.`type`=:yp0 AND `t`.`handle`=:yp1 LIMIT 1. Bound with :yp0='general', :yp1='pluginName'
in /var/www/craft/plugins/amforms/services/AmForms_SettingsService.php (63)
in /var/www/craft/plugins/amforms/AmFormsPlugin.php (18)
in /var/www/craft/app/services/PluginsService.php (1200)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 481)
Message:
[19:36:33.159][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT * FROM `craft_amforms_settings` `t` WHERE `t`.`type`=:yp0 AND `t`.`handle`=:yp1 LIMIT 1. Bound with :yp0='general', :yp1='pluginName')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 482)
Message:
[19:36:33.159][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT * FROM `craft_amforms_settings` `t` WHERE `t`.`type`=:yp0 AND `t`.`handle`=:yp1 LIMIT 1. Bound with :yp0='general', :yp1='pluginName')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 483)
Message:
[19:36:33.160][trace][system.CModule]
Loading "elements" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/web/UrlManager.php (278)
in /var/www/craft/app/etc/web/UrlManager.php (137)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 484)
Message:
[19:36:33.160][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
WHERE (elements_i18n.uri = :uri) AND (elements_i18n.locale = :locale) AND (elements_i18n.enabled = 1) AND (elements.enabled = 1) AND (elements.archived = 0). Bound with :uri='__home__', :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (157)
in /var/www/craft/app/etc/web/UrlManager.php (278)
in /var/www/craft/app/etc/web/UrlManager.php (137)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 485)
Message:
[19:36:33.160][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
WHERE (elements_i18n.uri = :uri) AND (elements_i18n.locale = :locale) AND (elements_i18n.enabled = 1) AND (elements.enabled = 1) AND (elements.archived = 0). Bound with :uri='__home__', :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 486)
Message:
[19:36:33.160][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
WHERE (elements_i18n.uri = :uri) AND (elements_i18n.locale = :locale) AND (elements_i18n.enabled = 1) AND (elements.enabled = 1) AND (elements.archived = 0). Bound with :uri='__home__', :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 487)
Message:
[19:36:33.160][trace][system.CModule]
Loading "components" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/services/ElementsService.php (2090)
in /var/www/craft/app/services/ElementsService.php (61)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 488)
Message:
[19:36:33.160][trace][system.CModule]
Loading "content" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/elementtypes/BaseElementType.php (443)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 489)
Message:
[19:36:33.160][trace][system.CModule]
Loading "fields" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/elementtypes/BaseElementType.php (447)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 490)
Message:
[19:36:33.160][trace][system.db.CDbCommand]
Querying SQL: SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('global')
ORDER BY `f`.`name`
in /var/www/craft/app/services/FieldsService.php (251)
in /var/www/craft/app/elementtypes/BaseElementType.php (447)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 491)
Message:
[19:36:33.160][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('global')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 492)
Message:
[19:36:33.161][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('global')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 493)
Message:
[19:36:33.163][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('2'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 494)
Message:
[19:36:33.163][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('2'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 495)
Message:
[19:36:33.164][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('2'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 496)
Message:
[19:36:33.165][trace][system.CModule]
Loading "sections" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/models/EntryModel.php (117)
in /var/www/craft/app/elementtypes/EntryElementType.php (893)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 497)
Message:
[19:36:33.165][trace][system.db.CDbCommand]
Querying SQL: SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`hasUrls`, `sections`.`template`, `sections`.`enableVersioning`, `structures`.`maxLevels`
FROM `craft_sections` `sections`
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
WHERE sections.id = :sectionId
ORDER BY `name`. Bound with :sectionId='1'
in /var/www/craft/app/services/SectionsService.php (227)
in /var/www/craft/app/models/EntryModel.php (117)
in /var/www/craft/app/elementtypes/EntryElementType.php (893)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 498)
Message:
[19:36:33.165][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`hasUrls`, `sections`.`template`, `sections`.`enableVersioning`, `structures`.`maxLevels`
FROM `craft_sections` `sections`
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
WHERE sections.id = :sectionId
ORDER BY `name`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 499)
Message:
[19:36:33.165][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`hasUrls`, `sections`.`template`, `sections`.`enableVersioning`, `structures`.`maxLevels`
FROM `craft_sections` `sections`
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
WHERE sections.id = :sectionId
ORDER BY `name`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 500)
Message:
[19:36:33.165][trace][system.db.CDbCommand]
Querying SQL: SELECT *
FROM `craft_sections_i18n` `sections_i18n`
JOIN `craft_locales` `locales` ON locales.locale = sections_i18n.locale
WHERE sections_i18n.sectionId = :sectionId
ORDER BY `locales`.`sortOrder`. Bound with :sectionId='1'
in /var/www/craft/app/services/SectionsService.php (285)
in /var/www/craft/app/models/SectionModel.php (63)
in /var/www/craft/app/elementtypes/EntryElementType.php (896)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 501)
Message:
[19:36:33.165][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT *
FROM `craft_sections_i18n` `sections_i18n`
JOIN `craft_locales` `locales` ON locales.locale = sections_i18n.locale
WHERE sections_i18n.sectionId = :sectionId
ORDER BY `locales`.`sortOrder`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 502)
Message:
[19:36:33.166][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT *
FROM `craft_sections_i18n` `sections_i18n`
JOIN `craft_locales` `locales` ON locales.locale = sections_i18n.locale
WHERE sections_i18n.sectionId = :sectionId
ORDER BY `locales`.`sortOrder`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 503)
Message:
[19:36:33.166][trace][system.CModule]
Loading "templates" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/controllers/TemplatesController.php (66)
in /var/www/craft/app/etc/web/WebApp.php (291)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 504)
Message:
[19:36:33.167][trace][system.CModule]
Loading "statePersister" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/plugins/backuppro/vendor/jaeger-app/platforms-craft/src/Platforms/Craft.php (123)
in /var/www/craft/plugins/backuppro/vendor/jaeger-app/bootstrap/src/Bootstrap.php (134)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 505)
Message:
[19:36:33.168][trace][system.caching.Craft\FileCache]
Serving "Yii.CStatePersister./var/www/craft/storage/runtime/state/state.bin" from cache
in /var/www/craft/app/services/CacheService.php (180)
in /var/www/craft/plugins/backuppro/vendor/jaeger-app/platforms-craft/src/Platforms/Craft.php (123)
in /var/www/craft/plugins/backuppro/vendor/jaeger-app/bootstrap/src/Bootstrap.php (134)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 506)
Message:
[19:36:33.170][trace][system.caching.Craft\FileCache]
Serving "omitScriptNameInUrls" from cache
in /var/www/craft/app/services/CacheService.php (180)
in /var/www/craft/app/services/ConfigService.php (303)
in /var/www/craft/app/helpers/UrlHelper.php (411)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 507)
Message:
[19:36:33.170][trace][system.CModule]
Loading "globals" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/etc/templating/twigextensions/CraftTwigExtension.php (597)
in /var/www/craft/app/vendor/twig/twig/lib/Twig/Environment.php (1465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 508)
Message:
[19:36:33.171][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `globalsets`.`name`, `globalsets`.`handle`, `globalsets`.`fieldLayoutId`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_globalsets` `globalsets` ON globalsets.id = elements.id
WHERE ((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)
GROUP BY `elements`.`id`
ORDER BY `name`. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/services/GlobalsService.php (97)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 509)
Message:
[19:36:33.171][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `globalsets`.`name`, `globalsets`.`handle`, `globalsets`.`fieldLayoutId`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_globalsets` `globalsets` ON globalsets.id = elements.id
WHERE ((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)
GROUP BY `elements`.`id`
ORDER BY `name`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 510)
Message:
[19:36:33.172][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `globalsets`.`name`, `globalsets`.`handle`, `globalsets`.`fieldLayoutId`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_globalsets` `globalsets` ON globalsets.id = elements.id
WHERE ((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)
GROUP BY `elements`.`id`
ORDER BY `name`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 511)
Message:
[19:36:33.174][trace][system.CModule]
Loading "navee" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/plugins/navee/variables/NaveeVariable.php (35)
in /var/www/craft/app/vendor/twig/twig/lib/Twig/Template.php (688)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 512)
Message:
[19:36:33.176][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('topnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/plugins/navee/services/NaveeService.php (53)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 513)
Message:
[19:36:33.176][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('topnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 514)
Message:
[19:36:33.177][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('topnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 515)
Message:
[19:36:33.182][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('bottomnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/plugins/navee/services/NaveeService.php (53)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 516)
Message:
[19:36:33.182][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('bottomnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 517)
Message:
[19:36:33.184][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('bottomnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 518)
Message:
[19:36:33.191][trace][system.db.CDbCommand]
Querying SQL: SELECT `handle`, `context`
FROM `craft_fields`
in /var/www/craft/app/services/FieldsService.php (395)
in /var/www/craft/app/services/FieldsService.php (355)
in /var/www/craft/app/models/BaseElementModel.php (1138)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 519)
Message:
[19:36:33.191][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `handle`, `context`
FROM `craft_fields`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 520)
Message:
[19:36:33.191][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `handle`, `context`
FROM `craft_fields`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 521)
Message:
[19:36:33.192][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='4', :descendantOf_rgt='25', :descendantOf_root='9', :descendantOf_level=2
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (81)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 522)
Message:
[19:36:33.192][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='4', :descendantOf_rgt='25', :descendantOf_root='9', :descendantOf_level=2)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 523)
Message:
[19:36:33.194][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='4', :descendantOf_rgt='25', :descendantOf_root='9', :descendantOf_level=2)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 524)
Message:
[19:36:33.198][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='5', :descendantOf_rgt='12', :descendantOf_root='9', :descendantOf_level=3
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (81)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 525)
Message:
[19:36:33.198][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='5', :descendantOf_rgt='12', :descendantOf_root='9', :descendantOf_level=3)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 526)
Message:
[19:36:33.199][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='5', :descendantOf_rgt='12', :descendantOf_root='9', :descendantOf_level=3)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 527)
Message:
[19:36:33.203][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 528)
Message:
[19:36:33.203][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 529)
Message:
[19:36:33.204][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 530)
Message:
[19:36:33.204][trace][system.CModule]
Loading "assetTransforms" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/models/AssetFileModel.php (69)
in /var/www/craft/app/vendor/twig/twig/lib/Twig/Template.php (580)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 531)
Message:
[19:36:33.204][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`
FROM `craft_assettransforms`
WHERE handle = :handle
ORDER BY `name`. Bound with :handle='url'
in /var/www/craft/app/services/AssetTransformsService.php (110)
in /var/www/craft/app/models/AssetFileModel.php (69)
in /var/www/craft/app/vendor/twig/twig/lib/Twig/Template.php (580)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 532)
Message:
[19:36:33.204][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`
FROM `craft_assettransforms`
WHERE handle = :handle
ORDER BY `name`. Bound with :handle='url')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 533)
Message:
[19:36:33.205][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`
FROM `craft_assettransforms`
WHERE handle = :handle
ORDER BY `name`. Bound with :handle='url')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 534)
Message:
[19:36:33.205][trace][system.CModule]
Loading "assetSources" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/models/AssetFileModel.php (398)
in /var/www/craft/app/models/AssetFileModel.php (255)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 535)
Message:
[19:36:33.205][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `fieldLayoutId`, `name`, `handle`, `type`, `settings`, `sortOrder`
FROM `craft_assetsources`
WHERE id = :id
ORDER BY `sortOrder`. Bound with :id='1'
in /var/www/craft/app/services/AssetSourcesService.php (368)
in /var/www/craft/app/models/AssetFileModel.php (230)
in /var/www/craft/app/models/AssetFileModel.php (398)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 536)
Message:
[19:36:33.205][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `fieldLayoutId`, `name`, `handle`, `type`, `settings`, `sortOrder`
FROM `craft_assetsources`
WHERE id = :id
ORDER BY `sortOrder`. Bound with :id='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 537)
Message:
[19:36:33.205][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `fieldLayoutId`, `name`, `handle`, `type`, `settings`, `sortOrder`
FROM `craft_assetsources`
WHERE id = :id
ORDER BY `sortOrder`. Bound with :id='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 538)
Message:
[19:36:33.205][trace][system.CModule]
Loading "assets" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/models/AssetFileModel.php (277)
in /var/www/craft/app/models/BaseModel.php (153)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 539)
Message:
[19:36:33.206][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 540)
Message:
[19:36:33.206][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 541)
Message:
[19:36:33.207][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 542)
Message:
[19:36:33.208][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 543)
Message:
[19:36:33.208][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 544)
Message:
[19:36:33.209][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 545)
Message:
[19:36:33.210][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 546)
Message:
[19:36:33.210][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 547)
Message:
[19:36:33.211][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 548)
Message:
[19:36:33.212][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 549)
Message:
[19:36:33.212][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 550)
Message:
[19:36:33.213][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 551)
Message:
[19:36:33.214][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 552)
Message:
[19:36:33.214][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 553)
Message:
[19:36:33.215][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 554)
Message:
[19:36:33.221][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 555)
Message:
[19:36:33.221][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 556)
Message:
[19:36:33.222][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 557)
Message:
[19:36:33.223][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 558)
Message:
[19:36:33.223][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 559)
Message:
[19:36:33.224][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 560)
Message:
[19:36:33.225][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 561)
Message:
[19:36:33.225][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 562)
Message:
[19:36:33.226][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 563)
Message:
[19:36:33.227][trace][system.CModule]
Loading "matrix" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (90)
in /var/www/craft/app/services/ElementsService.php (667)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 564)
Message:
[19:36:33.227][trace][system.db.CDbCommand]
Querying SQL: SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='9'
in /var/www/craft/app/services/MatrixService.php (983)
in /var/www/craft/app/services/MatrixService.php (682)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (90)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 565)
Message:
[19:36:33.227][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 566)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 567)
Message:
[19:36:33.228][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='9'
in /var/www/craft/app/services/MatrixService.php (75)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (104)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 568)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 569)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 570)
Message:
[19:36:33.228][trace][system.db.CDbCommand]
Querying SQL: SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:1')
ORDER BY `f`.`name`
in /var/www/craft/app/services/FieldsService.php (251)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (114)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 571)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:1')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 572)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:1')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 573)
Message:
[19:36:33.228][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='20'
in /var/www/craft/app/services/FieldsService.php (778)
in /var/www/craft/app/etc/behaviors/FieldLayoutBehavior.php (67)
in /var/www/craft/app/models/BaseModel.php (119)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 574)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 575)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 576)
Message:
[19:36:33.228][trace][system.db.CDbCommand]
Querying SQL: SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='20'
in /var/www/craft/app/services/FieldsService.php (874)
in /var/www/craft/app/models/FieldLayoutModel.php (65)
in /var/www/craft/app/models/MatrixBlockTypeModel.php (76)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 577)
Message:
[19:36:33.228][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 578)
Message:
[19:36:33.229][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 579)
Message:
[19:36:33.229][trace][system.CModule]
Loading "fruitLinkIt" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/plugins/fruitlinkit/models/FruitLinkIt_LinkSettingsModel.php (38)
in /var/www/craft/app/models/BaseModel.php (264)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 580)
Message:
[19:36:33.229][trace][system.db.CDbCommand]
Querying SQL: SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us'
in /var/www/craft/app/etc/db/DbCommand.php (90)
in /var/www/craft/app/services/ElementsService.php (581)
in /var/www/craft/app/models/ElementCriteriaModel.php (392)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 581)
Message:
[19:36:33.229][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 582)
Message:
[19:36:33.230][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 583)
Message:
[19:36:33.230][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 584)
Message:
[19:36:33.230][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 585)
Message:
[19:36:33.231][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 586)
Message:
[19:36:33.231][trace][system.CModule]
Loading "entries" application component
in /var/www/craft/app/etc/web/WebApp.php (596)
in /var/www/craft/plugins/fruitlinkit/models/FruitLinkIt_LinkModel.php (228)
in /var/www/craft/plugins/fruitlinkit/models/FruitLinkIt_LinkModel.php (86)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 587)
Message:
[19:36:33.232][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('776'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 588)
Message:
[19:36:33.232][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('776'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 589)
Message:
[19:36:33.233][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('776'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 590)
Message:
[19:36:33.234][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 591)
Message:
[19:36:33.234][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 592)
Message:
[19:36:33.234][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 593)
Message:
[19:36:33.235][trace][system.db.CDbCommand]
Querying SQL: SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='13'
in /var/www/craft/app/services/MatrixService.php (983)
in /var/www/craft/app/services/MatrixService.php (682)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (90)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 594)
Message:
[19:36:33.235][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 595)
Message:
[19:36:33.235][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 596)
Message:
[19:36:33.235][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='13'
in /var/www/craft/app/services/MatrixService.php (75)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (104)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 597)
Message:
[19:36:33.235][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 598)
Message:
[19:36:33.235][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 599)
Message:
[19:36:33.236][trace][system.db.CDbCommand]
Querying SQL: SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:2')
ORDER BY `f`.`name`
in /var/www/craft/app/services/FieldsService.php (251)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (114)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 600)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:2')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 601)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:2')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 602)
Message:
[19:36:33.236][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='27'
in /var/www/craft/app/services/FieldsService.php (778)
in /var/www/craft/app/etc/behaviors/FieldLayoutBehavior.php (67)
in /var/www/craft/app/models/BaseModel.php (119)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 603)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 604)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 605)
Message:
[19:36:33.236][trace][system.db.CDbCommand]
Querying SQL: SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='27'
in /var/www/craft/app/services/FieldsService.php (874)
in /var/www/craft/app/models/FieldLayoutModel.php (65)
in /var/www/craft/app/models/MatrixBlockTypeModel.php (76)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 606)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 607)
Message:
[19:36:33.236][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 608)
Message:
[19:36:33.237][trace][system.db.CDbCommand]
Querying SQL: SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us'
in /var/www/craft/app/etc/db/DbCommand.php (90)
in /var/www/craft/app/services/ElementsService.php (581)
in /var/www/craft/app/models/ElementCriteriaModel.php (392)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 609)
Message:
[19:36:33.237][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 610)
Message:
[19:36:33.237][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 611)
Message:
[19:36:33.238][trace][system.db.CDbCommand]
Querying SQL: SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='20'
in /var/www/craft/app/services/MatrixService.php (983)
in /var/www/craft/app/services/MatrixService.php (682)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (90)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 612)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 613)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 614)
Message:
[19:36:33.238][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='20'
in /var/www/craft/app/services/MatrixService.php (75)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (104)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 615)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 616)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 617)
Message:
[19:36:33.238][trace][system.db.CDbCommand]
Querying SQL: SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:3')
ORDER BY `f`.`name`
in /var/www/craft/app/services/FieldsService.php (251)
in /var/www/craft/app/elementtypes/MatrixBlockElementType.php (114)
in /var/www/craft/app/elementtypes/BaseElementType.php (465)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 618)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:3')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 619)
Message:
[19:36:33.238][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:3')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 620)
Message:
[19:36:33.239][trace][system.db.CDbCommand]
Querying SQL: SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='299'
in /var/www/craft/app/services/FieldsService.php (778)
in /var/www/craft/app/etc/behaviors/FieldLayoutBehavior.php (67)
in /var/www/craft/app/models/BaseModel.php (119)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 621)
Message:
[19:36:33.239][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 622)
Message:
[19:36:33.239][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 623)
Message:
[19:36:33.239][trace][system.db.CDbCommand]
Querying SQL: SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='299'
in /var/www/craft/app/services/FieldsService.php (874)
in /var/www/craft/app/models/FieldLayoutModel.php (65)
in /var/www/craft/app/models/MatrixBlockTypeModel.php (76)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 624)
Message:
[19:36:33.239][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 625)
Message:
[19:36:33.239][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 626)
Message:
[19:36:33.240][trace][system.db.CDbCommand]
Querying SQL: SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us'
in /var/www/craft/app/etc/db/DbCommand.php (90)
in /var/www/craft/app/services/ElementsService.php (581)
in /var/www/craft/app/models/ElementCriteriaModel.php (392)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 627)
Message:
[19:36:33.240][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 628)
Message:
[19:36:33.240][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 629)
Message:
[19:36:33.241][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_callout_headline`, `content`.`field_callout_description`, `content`.`field_callout_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (81)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 630)
Message:
[19:36:33.241][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_callout_headline`, `content`.`field_callout_description`, `content`.`field_callout_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 631)
Message:
[19:36:33.241][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_callout_headline`, `content`.`field_callout_description`, `content`.`field_callout_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 632)
Message:
[19:36:33.243][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1682')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 633)
Message:
[19:36:33.243][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1682')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 634)
Message:
[19:36:33.244][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1682')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 635)
Message:
[19:36:33.246][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1231')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 636)
Message:
[19:36:33.246][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1231')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 637)
Message:
[19:36:33.247][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1231')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 638)
Message:
[19:36:33.249][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('2240')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (311)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 639)
Message:
[19:36:33.249][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('2240')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 640)
Message:
[19:36:33.249][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('2240')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 641)
Message:
[19:36:33.251][trace][system.db.CDbCommand]
Querying SQL: SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_socialLink_socialType`, `content`.`field_socialLink_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us'
in /var/www/craft/app/services/ElementsService.php (224)
in /var/www/craft/app/models/ElementCriteriaModel.php (284)
in /var/www/craft/app/models/ElementCriteriaModel.php (81)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 642)
Message:
[19:36:33.251][profile][system.db.CDbCommand.query]
begin:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_socialLink_socialType`, `content`.`field_socialLink_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 643)
Message:
[19:36:33.251][profile][system.db.CDbCommand.query]
end:system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_socialLink_socialType`, `content`.`field_socialLink_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 644)
Message:
[19:36:33.255][trace][system.caching.Craft\FileCache]
Serving "useWriteFileLock" from cache
in /var/www/craft/app/services/CacheService.php (180)
in /var/www/craft/app/etc/logging/FileLogRoute.php (92)
in /var/www/craft/app/etc/web/WebApp.php (707)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 645)
Message:
console.groupEnd
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 647)
Message:
console.groupEnd
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 655)
Message:
Profiling Summary Report
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 656)
Message:
Time: 0.12917s
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 657)
Message:
Memory: 8,141Kb
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 658)
Message:
Total Queries: 47
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 659)
Message:
count total average min max
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 661)
Message:
5 0.00458 0.00092 0.00078 0.00106 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('4')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 662)
Message:
4 0.00344 0.00086 0.00072 0.00099 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('736')) AND (`sources1`.`fieldId` IN ('7')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 663)
Message:
1 0.00176 0.00176 0.00176 0.00176 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('bottomnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 664)
Message:
1 0.00175 0.00175 0.00175 0.00175 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='4', :descendantOf_rgt='25', :descendantOf_root='9', :descendantOf_level=2)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 665)
Message:
1 0.00162 0.00162 0.00162 0.00162 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`navigations`.`handle` IN ('topnav'))
GROUP BY `elements`.`id`
ORDER BY `lft`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 666)
Message:
1 0.00150 0.00150 0.00150 0.00150 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `nodes`.*, `i18nEntry`.`uri` AS `entryLink`, `i18nCategory`.`uri` AS `categoryLink`, `elementEntry`.`enabled` AS `entryEnabled`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_navee_nodes` `nodes` ON nodes.id = elements.id
JOIN `craft_navee_navigations` `navigations` ON navigations.id = nodes.navigationId
LEFT JOIN `craft_elements` `elementEntry` ON elementEntry.id = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nEntry` ON i18nEntry.elementId = nodes.entryId
LEFT JOIN `craft_elements_i18n` `i18nCategory` ON i18nCategory.elementId = nodes.categoryId
LEFT JOIN `craft_structures` `structures` ON structures.id = navigations.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = nodes.id)
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((structureelements.lft > :descendantOf_lft) AND (structureelements.rgt < :descendantOf_rgt) AND (structureelements.root = :descendantOf_root))) AND (structureelements.level <= :descendantOf_level)
GROUP BY `elements`.`id`
ORDER BY `lft` LIMIT 100. Bound with :locale='en_us', :descendantOf_lft='5', :descendantOf_rgt='12', :descendantOf_root='9', :descendantOf_level=3)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 667)
Message:
2 0.00105 0.00053 0.00048 0.00057 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_buttonLink_linkUrl`, `content`.`field_buttonLink_text`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 668)
Message:
1 0.00097 0.00097 0.00097 0.00097 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `globalsets`.`name`, `globalsets`.`handle`, `globalsets`.`fieldLayoutId`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_globalsets` `globalsets` ON globalsets.id = elements.id
WHERE ((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)
GROUP BY `elements`.`id`
ORDER BY `name`. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 669)
Message:
1 0.00092 0.00092 0.00092 0.00092 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('2'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 670)
Message:
1 0.00090 0.00090 0.00090 0.00090 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('2240')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 671)
Message:
1 0.00086 0.00086 0.00086 0.00086 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1682')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 672)
Message:
1 0.00081 0.00081 0.00081 0.00081 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `sources1`.`sortOrder`, `assetfiles`.`sourceId`, `assetfiles`.`folderId`, `assetfiles`.`filename`, `assetfiles`.`kind`, `assetfiles`.`width`, `assetfiles`.`height`, `assetfiles`.`size`, `assetfiles`.`dateModified`, `assetfolders`.`path` AS `folderPath`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
LEFT JOIN `craft_relations` `sources1` ON (sources1.targetId = elements.id) AND ((sources1.sourceLocale is null) OR (sources1.sourceLocale = :sourceLocale1))
JOIN `craft_assetfiles` `assetfiles` ON assetfiles.id = elements.id
JOIN `craft_assetfolders` `assetfolders` ON assetfolders.id = assetfiles.folderId
WHERE (((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND ((`sources1`.`sourceId` IN ('1231')) AND (`sources1`.`fieldId` IN ('21')))
GROUP BY `elements`.`id`
ORDER BY `sources1`.`sortOrder` LIMIT 1. Bound with :locale='en_us', :sourceLocale1='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 673)
Message:
1 0.00069 0.00069 0.00069 0.00069 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_socialLink_socialType`, `content`.`field_socialLink_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 674)
Message:
1 0.00057 0.00057 0.00057 0.00057 system.db.CDbCommand.query(SELECT *
FROM `craft_sections_i18n` `sections_i18n`
JOIN `craft_locales` `locales` ON locales.locale = sections_i18n.locale
WHERE sections_i18n.sectionId = :sectionId
ORDER BY `locales`.`sortOrder`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 675)
Message:
1 0.00055 0.00055 0.00055 0.00055 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_address`, `content`.`field_banquetSpace`, `content`.`field_body`, `content`.`field_businessName`, `content`.`field_conferenceSpace`, `content`.`field_daysClosed`, `content`.`field_firstHeadlineRow`, `content`.`field_googleMapsApiKey`, `content`.`field_imageAltText`, `content`.`field_info`, `content`.`field_mealType`, `content`.`field_numberOfRooms`, `content`.`field_onSiteRestaurant`, `content`.`field_openYearRound`, `content`.`field_parsedirectory`, `content`.`field_parseevents`, `content`.`field_parsegallery`, `content`.`field_parseinnercontent`, `content`.`field_petsPermitted`, `content`.`field_phone`, `content`.`field_phoneNumber`, `content`.`field_secondHeadlineRow`, `content`.`field_town`, `content`.`field_l_type`, `content`.`field_websiteUrl`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_content` `content` ON content.elementId = elements.id
JOIN `craft_entries` `entries` ON entries.id = elements.id
JOIN `craft_sections` `sections` ON sections.id = entries.sectionId
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
LEFT JOIN `craft_structureelements` `structureelements` ON (structureelements.structureId = structures.id) AND (structureelements.elementId = entries.id)
WHERE (((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (`elements`.`id` IN ('776'))) AND (elements.archived = 0)
GROUP BY `elements`.`id`
ORDER BY `lft`, `postDate` DESC LIMIT 1. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 676)
Message:
1 0.00054 0.00054 0.00054 0.00054 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_i18n`.`slug`, `elements_i18n`.`uri`, `elements_i18n`.`enabled` AS `localeEnabled`, `content`.`id` AS `contentId`, `content`.`field_callout_headline`, `content`.`field_callout_description`, `content`.`field_callout_linkUrl`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`
ORDER BY `matrixblocks`.`sortOrder` LIMIT 100. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 677)
Message:
1 0.00051 0.00051 0.00051 0.00051 system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_sociallist` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('13'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 678)
Message:
1 0.00051 0.00051 0.00051 0.00051 system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_callout` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('20'))) AND (`matrixblocks`.`ownerId` IN ('1230'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 679)
Message:
1 0.00051 0.00051 0.00051 0.00051 system.db.CDbCommand.query(SELECT count(`derivedElementsTable`.`elementsId`)
FROM (SELECT `elements`.`id` AS `elementsId`, `matrixblocks`.`fieldId`, `matrixblocks`.`ownerId`, `matrixblocks`.`ownerLocale`, `matrixblocks`.`typeId`, `matrixblocks`.`sortOrder`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
JOIN `craft_matrixcontent_button` `content` ON content.elementId = elements.id
JOIN `craft_matrixblocks` `matrixblocks` ON matrixblocks.id = elements.id
WHERE ((((((elements_i18n.locale = :locale) AND (content.locale = :locale)) AND (elements.archived = 0)) AND (elements.enabled = 1)) AND (elements_i18n.enabled = 1)) AND (`matrixblocks`.`fieldId` IN ('9'))) AND (`matrixblocks`.`ownerId` IN ('736'))
GROUP BY `elements`.`id`) derivedElementsTable. Bound with :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 680)
Message:
1 0.00045 0.00045 0.00045 0.00045 system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('global')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 681)
Message:
1 0.00045 0.00045 0.00045 0.00045 system.db.CDbCommand.query(SHOW TABLES LIKE 'craft_%')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 682)
Message:
1 0.00042 0.00042 0.00042 0.00042 system.db.CDbCommand.query(SELECT `handle`, `context`
FROM `craft_fields`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 683)
Message:
1 0.00041 0.00041 0.00041 0.00041 system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 684)
Message:
1 0.00033 0.00033 0.00033 0.00033 system.db.CDbCommand.query(SELECT *
FROM `craft_plugins`
WHERE enabled=1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 685)
Message:
1 0.00032 0.00032 0.00032 0.00032 system.db.CDbCommand.query(SELECT `locale`
FROM `craft_locales`
ORDER BY `sortOrder`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 686)
Message:
1 0.00032 0.00032 0.00032 0.00032 system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 687)
Message:
1 0.00029 0.00029 0.00029 0.00029 system.db.CDbCommand.query(SELECT *
FROM `craft_info` LIMIT 1)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 688)
Message:
1 0.00025 0.00025 0.00025 0.00025 system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 689)
Message:
1 0.00024 0.00024 0.00024 0.00024 system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 690)
Message:
1 0.00023 0.00023 0.00023 0.00023 system.db.CDbCommand.query(SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`hasUrls`, `sections`.`template`, `sections`.`enableVersioning`, `structures`.`maxLevels`
FROM `craft_sections` `sections`
LEFT JOIN `craft_structures` `structures` ON structures.id = sections.structureId
WHERE sections.id = :sectionId
ORDER BY `name`. Bound with :sectionId='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 691)
Message:
1 0.00023 0.00023 0.00023 0.00023 system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 692)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 693)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='299')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 694)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:3')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 695)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `id`, `fieldLayoutId`, `name`, `handle`, `type`, `settings`, `sortOrder`
FROM `craft_assetsources`
WHERE id = :id
ORDER BY `sortOrder`. Bound with :id='1')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 696)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `elements`.`id`, `elements`.`type`
FROM `craft_elements` `elements`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = elements.id
WHERE (elements_i18n.uri = :uri) AND (elements_i18n.locale = :locale) AND (elements_i18n.enabled = 1) AND (elements.enabled = 1) AND (elements.archived = 0). Bound with :uri='__home__', :locale='en_us')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 697)
Message:
1 0.00021 0.00021 0.00021 0.00021 system.db.CDbCommand.query(SELECT `fields`.`id`
FROM `craft_fields` `fields`
JOIN `craft_matrixblocktypes` `blocktypes` ON blocktypes.fieldId = fields.id
JOIN `craft_fieldlayoutfields` `fieldlayoutfields` ON fieldlayoutfields.layoutId = blocktypes.fieldLayoutId
WHERE fieldlayoutfields.fieldId = :matrixFieldId. Bound with :matrixFieldId='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 698)
Message:
1 0.00020 0.00020 0.00020 0.00020 system.db.CDbCommand.query(SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`
FROM `craft_assettransforms`
WHERE handle = :handle
ORDER BY `name`. Bound with :handle='url')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 699)
Message:
1 0.00018 0.00018 0.00018 0.00018 system.db.CDbCommand.query(SELECT `fieldlayoutfields`.`id`, `fieldlayoutfields`.`layoutId`, `fieldlayoutfields`.`tabId`, `fieldlayoutfields`.`fieldId`, `fieldlayoutfields`.`required`, `fieldlayoutfields`.`sortOrder`
FROM `craft_fieldlayoutfields` `fieldlayoutfields`
JOIN `craft_fieldlayouttabs` `fieldlayouttabs` ON fieldlayouttabs.id = fieldlayoutfields.tabId
WHERE fieldlayoutfields.layoutId = :layoutId
ORDER BY `fieldlayouttabs`.`sortOrder`, `fieldlayoutfields`.`sortOrder`. Bound with :layoutId='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 700)
Message:
1 0.00018 0.00018 0.00018 0.00018 system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:1')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 701)
Message:
1 0.00017 0.00017 0.00017 0.00017 system.db.CDbCommand.query(SELECT * FROM `craft_amforms_settings` `t` WHERE `t`.`type`=:yp0 AND `t`.`handle`=:yp1 LIMIT 1. Bound with :yp0='general', :yp1='pluginName')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 702)
Message:
1 0.00017 0.00017 0.00017 0.00017 system.db.CDbCommand.query(SELECT `f`.`id`, `f`.`groupId`, `f`.`name`, `f`.`handle`, `f`.`context`, `f`.`instructions`, `f`.`translatable`, `f`.`type`, `f`.`settings`
FROM `craft_fields` `f`
WHERE `f`.`context` IN ('matrixBlockType:2')
ORDER BY `f`.`name`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 703)
Message:
1 0.00016 0.00016 0.00016 0.00016 system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='20')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 704)
Message:
1 0.00016 0.00016 0.00016 0.00016 system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='13')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 705)
Message:
1 0.00015 0.00015 0.00015 0.00015 system.db.CDbCommand.query(SELECT `id`, `fieldId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`
FROM `craft_matrixblocktypes`
WHERE fieldId = :fieldId
ORDER BY `sortOrder`. Bound with :fieldId='9')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 706)
Message:
1 0.00011 0.00011 0.00011 0.00011 system.db.CDbCommand.query(SHOW CREATE TABLE `craft_amforms_settings`)
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 707)
Message:
1 0.00010 0.00010 0.00010 0.00010 system.db.CDbCommand.query(SELECT `id`, `type`
FROM `craft_fieldlayouts`
WHERE id = :id. Bound with :id='27')
|
console-api |
log |
URL: https://discoveritallwv.com/(Line 709)
Message:
console.groupEnd
|