Skip to content

Instantly share code, notes, and snippets.

@brandonkelly
Last active January 15, 2021 14:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brandonkelly/fa2f0338e11027fe5317fb16cd64bbbb to your computer and use it in GitHub Desktop.
Save brandonkelly/fa2f0338e11027fe5317fb16cd64bbbb to your computer and use it in GitHub Desktop.
How to capture DB query logs in Yii2
<?php
namespace foo\bar;
use yii\log\Target;
/**
* Define a LogTarget class that only collects the log messages, but never flushes them out anywhere
*/
class LogTarget extends Target
{
/**
* @var Module
*/
public $module;
public function export()
{
// We don't need to save the DB logs anywhere
}
public function collect($messages, $final)
{
// Only collet the messages; never export them.
$this->messages = array_merge($this->messages, static::filterMessages($messages, $this->getLevels(), $this->categories, $this->except));
}
}
<?php
namespace foo\bar;
use Yii;
use yii\base\Application;
use yii\base\BootstrapInterface;
use yii\log\Logger;
/**
* Register the log target when your module is bootstrapped, setting it to only capture DB queries
*/
class Module extends \yii\base\Module implements BootstrapInterface
{
/**
* @var LogTarget
*/
public $logTarget;
public function bootstrap($app)
{
/* @var $app Application */
$this->logTarget = $app->getLog()->targets['ray-db'] = Yii::createObject([
'class' => LogTarget::class,
'module' => $this,
'levels' => Logger::LEVEL_PROFILE,
'categories' => ['yii\db\Command::query', 'yii\db\Command::execute'],
]);
}
}
<?php
/**
* Here's what Module::$logTarget->messages will look like once some queries have been logged
*/
[
0 => [
0 => 'SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720842.865
4 => []
5 => 8406120
]
1 => [
0 => 'SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720842.8656
4 => []
5 => 8408272
]
2 => [
0 => 'SELECT `s`.`id`, `s`.`name`, `s`.`handle`, `s`.`language`, `s`.`primary`, `s`.`hasUrls`, `s`.`baseUrl`, `s`.`sortOrder`, `s`.`uid`, `s`.`dateCreated`, `s`.`dateUpdated`, `s`.`groupId`, `s`.`enabled`
FROM `sites` `s`
INNER JOIN `sitegroups` `sg` ON `sg`.`id` = `s`.`groupId`
WHERE (`s`.`dateDeleted` IS NULL) AND (`sg`.`dateDeleted` IS NULL)
ORDER BY `sg`.`name`, `s`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720842.9244
4 => []
5 => 8581216
]
3 => [
0 => 'SELECT `s`.`id`, `s`.`name`, `s`.`handle`, `s`.`language`, `s`.`primary`, `s`.`hasUrls`, `s`.`baseUrl`, `s`.`sortOrder`, `s`.`uid`, `s`.`dateCreated`, `s`.`dateUpdated`, `s`.`groupId`, `s`.`enabled`
FROM `sites` `s`
INNER JOIN `sitegroups` `sg` ON `sg`.`id` = `s`.`groupId`
WHERE (`s`.`dateDeleted` IS NULL) AND (`sg`.`dateDeleted` IS NULL)
ORDER BY `sg`.`name`, `s`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720842.9249
4 => []
5 => 8584064
]
4 => [
0 => 'SELECT `preferences`
FROM `userpreferences`
WHERE `userId`=1
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.0492
4 => []
5 => 9936296
]
5 => [
0 => 'SELECT `preferences`
FROM `userpreferences`
WHERE `userId`=1
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.0498
4 => []
5 => 9936824
]
6 => [
0 => 'SELECT `id`, `handle`, `version`, `schemaVersion`, `licenseKeyStatus`, `installDate`, `licensedEdition`
FROM `plugins`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.1582
4 => []
5 => 11401728
]
7 => [
0 => 'SELECT `id`, `handle`, `version`, `schemaVersion`, `licenseKeyStatus`, `installDate`, `licensedEdition`
FROM `plugins`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.1586
4 => []
5 => 11404160
]
8 => [
0 => 'SELECT `id`
FROM `sessions`
WHERE (`token`=\'7ELzHeOYEWODpDnJsHh_Wwhu50_Me23iy5lXBtr7YA4AxljMP9FT0u6v1VRbp-5T7ONdEzkEJEZtcUQgoXtRpTUxQLsvuRpvxsSR\') AND (`userId`=1)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.559
4 => []
5 => 15968528
]
9 => [
0 => 'SELECT `id`
FROM `sessions`
WHERE (`token`=\'7ELzHeOYEWODpDnJsHh_Wwhu50_Me23iy5lXBtr7YA4AxljMP9FT0u6v1VRbp-5T7ONdEzkEJEZtcUQgoXtRpTUxQLsvuRpvxsSR\') AND (`userId`=1)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.5605
4 => []
5 => 15969192
]
10 => [
0 => 'SHOW FULL COLUMNS FROM `sessions`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.5719
4 => []
5 => 15978776
]
11 => [
0 => 'SHOW FULL COLUMNS FROM `sessions`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.578
4 => []
5 => 15986256
]
12 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'sessions\' AND `kcu`.`TABLE_NAME` = \'sessions\''
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.5963
4 => []
5 => 16082840
]
13 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'sessions\' AND `kcu`.`TABLE_NAME` = \'sessions\''
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.5993
4 => []
5 => 16085536
]
14 => [
0 => 'UPDATE `sessions` SET `dateUpdated`=\'2021-01-15 14:27:23\' WHERE `id`=\'11\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720843.5994
4 => []
5 => 16083776
]
15 => [
0 => 'UPDATE `sessions` SET `dateUpdated`=\'2021-01-15 14:27:23\' WHERE `id`=\'11\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720843.6034
4 => []
5 => 16084304
]
16 => [
0 => 'SELECT COUNT(*)
FROM (SELECT 1
FROM `sites`
LIMIT 2) `x`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.6438
4 => []
5 => 16634824
]
17 => [
0 => 'SELECT COUNT(*)
FROM (SELECT 1
FROM `sites`
LIMIT 2) `x`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.6444
4 => []
5 => 16636576
]
18 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`
FROM `fields` `fields`
ORDER BY `fields`.`name`, `fields`.`handle`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.6517
4 => []
5 => 16664088
]
19 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`
FROM `fields` `fields`
ORDER BY `fields`.`name`, `fields`.`handle`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.653
4 => []
5 => 16732176
]
20 => [
0 => 'SHOW FULL COLUMNS FROM `elements`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.7669
4 => []
5 => 17490432
]
21 => [
0 => 'SHOW FULL COLUMNS FROM `elements`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.7687
4 => []
5 => 17502816
]
22 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'elements\' AND `kcu`.`TABLE_NAME` = \'elements\''
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.7689
4 => []
5 => 17504456
]
23 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'elements\' AND `kcu`.`TABLE_NAME` = \'elements\''
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.7704
4 => []
5 => 17508376
]
24 => [
0 => 'SELECT `users`.`password`, `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`id` AS `siteSettingsId`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `users`.`username`, `users`.`firstName`, `users`.`lastName`, `users`.`email`, `users`.`unverifiedEmail`, `users`.`admin`, `users`.`locked`, `users`.`pending`, `users`.`suspended`, `users`.`lastLoginDate`, `users`.`lockoutDate`, `users`.`photoId`, `users`.`hasDashboard`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_backgroundColor`, `content`.`field_body`, `content`.`field_contactUsLabel`, `content`.`field_copyrightNotice`, `content`.`field_email`, `content`.`field_featuredEntry`, `content`.`field_heading`, `content`.`field_indexHeading`, `content`.`field_linkUrl`, `content`.`field_shortDescription`, `content`.`field_subheading`
FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
FROM `elements` `elements`
INNER JOIN `users` `users` ON `users`.`id` = `elements`.`id`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
INNER JOIN `content` `content` ON `content`.`elementId` = `elements`.`id`
WHERE (`elements`.`id`=1) AND (`elements`.`archived`=FALSE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
ORDER BY `users`.`username`
LIMIT 1) `subquery`
INNER JOIN `users` `users` ON `users`.`id` = `subquery`.`elementsId`
INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
ORDER BY `users`.`username`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.7707
4 => []
5 => 17530216
]
25 => [
0 => 'SELECT `users`.`password`, `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`id` AS `siteSettingsId`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `users`.`username`, `users`.`firstName`, `users`.`lastName`, `users`.`email`, `users`.`unverifiedEmail`, `users`.`admin`, `users`.`locked`, `users`.`pending`, `users`.`suspended`, `users`.`lastLoginDate`, `users`.`lockoutDate`, `users`.`photoId`, `users`.`hasDashboard`, `content`.`id` AS `contentId`, `content`.`field_address`, `content`.`field_backgroundColor`, `content`.`field_body`, `content`.`field_contactUsLabel`, `content`.`field_copyrightNotice`, `content`.`field_email`, `content`.`field_featuredEntry`, `content`.`field_heading`, `content`.`field_indexHeading`, `content`.`field_linkUrl`, `content`.`field_shortDescription`, `content`.`field_subheading`
FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
FROM `elements` `elements`
INNER JOIN `users` `users` ON `users`.`id` = `elements`.`id`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
INNER JOIN `content` `content` ON `content`.`elementId` = `elements`.`id`
WHERE (`elements`.`id`=1) AND (`elements`.`archived`=FALSE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
ORDER BY `users`.`username`
LIMIT 1) `subquery`
INNER JOIN `users` `users` ON `users`.`id` = `subquery`.`elementsId`
INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
ORDER BY `users`.`username`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.7736
4 => []
5 => 17539432
]
26 => [
0 => 'SELECT `preferences`
FROM `userpreferences`
WHERE `userId`=1
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720843.8026
4 => []
5 => 17717280
]
27 => [
0 => 'SELECT `preferences`
FROM `userpreferences`
WHERE `userId`=1
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720843.803
4 => []
5 => 17717808
]
28 => [
0 => 'SELECT EXISTS(SELECT *
FROM `widgets`
WHERE (`userId`=1) AND (`type`=\'craft\\\\widgets\\\\CraftSupport\'))'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.1649
4 => []
5 => 21941976
]
29 => [
0 => 'SELECT EXISTS(SELECT *
FROM `widgets`
WHERE (`userId`=1) AND (`type`=\'craft\\\\widgets\\\\CraftSupport\'))'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.1671
4 => []
5 => 21942784
]
30 => [
0 => 'SELECT `id`, `name`, `handle`, `uid`, `description`
FROM `usergroups`
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.2209
4 => []
5 => 22182360
]
31 => [
0 => 'SELECT `id`, `name`, `handle`, `uid`, `description`
FROM `usergroups`
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.2222
4 => []
5 => 22187216
]
32 => [
0 => 'SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`enableVersioning`, `sections`.`uid`, `structures`.`maxLevels`, `sections`.`propagationMethod`, `sections`.`previewTargets`
FROM `sections` `sections`
LEFT JOIN `structures` `structures` ON (`structures`.`id` = `sections`.`structureId`) AND (`structures`.`dateDeleted` IS NULL)
WHERE `sections`.`dateDeleted` IS NULL
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.251
4 => []
5 => 22203016
]
33 => [
0 => 'SELECT `sections`.`id`, `sections`.`structureId`, `sections`.`name`, `sections`.`handle`, `sections`.`type`, `sections`.`enableVersioning`, `sections`.`uid`, `structures`.`maxLevels`, `sections`.`propagationMethod`, `sections`.`previewTargets`
FROM `sections` `sections`
LEFT JOIN `structures` `structures` ON (`structures`.`id` = `sections`.`structureId`) AND (`structures`.`dateDeleted` IS NULL)
WHERE `sections`.`dateDeleted` IS NULL
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.2562
4 => []
5 => 22212944
]
34 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=8)
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3065
4 => []
5 => 22779024
]
35 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=8)
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3114
4 => []
5 => 22781944
]
36 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=190)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3237
4 => []
5 => 22926536
]
37 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=190)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3243
4 => []
5 => 22927736
]
38 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=190
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3245
4 => []
5 => 22950704
]
39 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=190
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3265
4 => []
5 => 22962272
]
40 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=2)
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3326
4 => []
5 => 22969832
]
41 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=2)
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3339
4 => []
5 => 22973752
]
42 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=197)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3346
4 => []
5 => 22998600
]
43 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=197)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.335
4 => []
5 => 22999800
]
44 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=197
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3351
4 => []
5 => 23004304
]
45 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=197
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3357
4 => []
5 => 23020384
]
46 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=92)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3367
4 => []
5 => 23026112
]
47 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=92)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.337
4 => []
5 => 23027312
]
48 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=92
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3371
4 => []
5 => 23031816
]
49 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=92
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3375
4 => []
5 => 23041688
]
50 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=5)
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3385
4 => []
5 => 23040000
]
51 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=5)
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3388
4 => []
5 => 23042920
]
52 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=127)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3389
4 => []
5 => 23059064
]
53 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=127)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3391
4 => []
5 => 23060264
]
54 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=127
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3392
4 => []
5 => 23064768
]
55 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=127
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3397
4 => []
5 => 23079304
]
56 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=3)
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3409
4 => []
5 => 23072032
]
57 => [
0 => 'SELECT `id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `sortOrder`, `hasTitleField`, `titleFormat`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `entrytypes`
WHERE (`dateDeleted` IS NULL) AND (`sectionId`=3)
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3414
4 => []
5 => 23074936
]
58 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=120)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3415
4 => []
5 => 23089920
]
59 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=120)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3418
4 => []
5 => 23091120
]
60 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=120
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.3419
4 => []
5 => 23095624
]
61 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=120
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.3426
4 => []
5 => 23116624
]
62 => [
0 => 'SELECT EXISTS(SELECT *
FROM `widgets`
WHERE (`userId`=1) AND (`type`=\'craft\\\\widgets\\\\Updates\'))'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.401
4 => []
5 => 23244608
]
63 => [
0 => 'SELECT EXISTS(SELECT *
FROM `widgets`
WHERE (`userId`=1) AND (`type`=\'craft\\\\widgets\\\\Updates\'))'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.4016
4 => []
5 => 23245416
]
64 => [
0 => 'SELECT `id`, `name`, `handle`, `color`, `description`, `sortOrder`, `default`, `dateDeleted`, `uid`
FROM `commerce_orderstatuses`
WHERE `dateDeleted` IS NULL
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.7649
4 => []
5 => 23727592
]
65 => [
0 => 'SELECT `id`, `name`, `handle`, `color`, `description`, `sortOrder`, `default`, `dateDeleted`, `uid`
FROM `commerce_orderstatuses`
WHERE `dateDeleted` IS NULL
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.7656
4 => []
5 => 23729928
]
66 => [
0 => 'SHOW FULL COLUMNS FROM `resourcepaths`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.825
4 => []
5 => 24020520
]
67 => [
0 => 'SHOW FULL COLUMNS FROM `resourcepaths`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.8264
4 => []
5 => 24023880
]
68 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'resourcepaths\' AND `kcu`.`TABLE_NAME` = \'resourcepaths\''
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.8265
4 => []
5 => 24030344
]
69 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`,
`rc`.`DELETE_RULE`,
`rc`.`UPDATE_RULE`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = \'resourcepaths\' AND `kcu`.`TABLE_NAME` = \'resourcepaths\''
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.828
4 => []
5 => 24032120
]
70 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`tc`.`CONSTRAINT_TYPE` AS `type`,
CASE
WHEN NULL IS NULL AND `kcu`.`REFERENCED_TABLE_SCHEMA` = DATABASE() THEN NULL
ELSE `kcu`.`REFERENCED_TABLE_SCHEMA`
END AS `foreign_table_schema`,
`kcu`.`REFERENCED_TABLE_NAME` AS `foreign_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `foreign_column_name`,
`rc`.`UPDATE_RULE` AS `on_update`,
`rc`.`DELETE_RULE` AS `on_delete`,
`kcu`.`ORDINAL_POSITION` AS `position`
FROM
`information_schema`.`KEY_COLUMN_USAGE` AS `kcu`,
`information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`,
`information_schema`.`TABLE_CONSTRAINTS` AS `tc`
WHERE
`kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `kcu`.`TABLE_NAME` = \'resourcepaths\'
AND `rc`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `rc`.`TABLE_NAME` = \'resourcepaths\' AND `rc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME`
AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = \'resourcepaths\' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` = \'FOREIGN KEY\'
UNION
SELECT
`kcu`.`CONSTRAINT_NAME` AS `name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`tc`.`CONSTRAINT_TYPE` AS `type`,
NULL AS `foreign_table_schema`,
NULL AS `foreign_table_name`,
NULL AS `foreign_column_name`,
NULL AS `on_update`,
NULL AS `on_delete`,
`kcu`.`ORDINAL_POSITION` AS `position`
FROM
`information_schema`.`KEY_COLUMN_USAGE` AS `kcu`,
`information_schema`.`TABLE_CONSTRAINTS` AS `tc`
WHERE
`kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`TABLE_NAME` = \'resourcepaths\'
AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = \'resourcepaths\' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` IN (\'PRIMARY KEY\', \'UNIQUE\')
ORDER BY `position` ASC'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.8281
4 => []
5 => 24040616
]
71 => [
0 => 'SELECT
`kcu`.`CONSTRAINT_NAME` AS `name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`tc`.`CONSTRAINT_TYPE` AS `type`,
CASE
WHEN NULL IS NULL AND `kcu`.`REFERENCED_TABLE_SCHEMA` = DATABASE() THEN NULL
ELSE `kcu`.`REFERENCED_TABLE_SCHEMA`
END AS `foreign_table_schema`,
`kcu`.`REFERENCED_TABLE_NAME` AS `foreign_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `foreign_column_name`,
`rc`.`UPDATE_RULE` AS `on_update`,
`rc`.`DELETE_RULE` AS `on_delete`,
`kcu`.`ORDINAL_POSITION` AS `position`
FROM
`information_schema`.`KEY_COLUMN_USAGE` AS `kcu`,
`information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`,
`information_schema`.`TABLE_CONSTRAINTS` AS `tc`
WHERE
`kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `kcu`.`TABLE_NAME` = \'resourcepaths\'
AND `rc`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `rc`.`TABLE_NAME` = \'resourcepaths\' AND `rc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME`
AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = \'resourcepaths\' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` = \'FOREIGN KEY\'
UNION
SELECT
`kcu`.`CONSTRAINT_NAME` AS `name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`tc`.`CONSTRAINT_TYPE` AS `type`,
NULL AS `foreign_table_schema`,
NULL AS `foreign_table_name`,
NULL AS `foreign_column_name`,
NULL AS `on_update`,
NULL AS `on_delete`,
`kcu`.`ORDINAL_POSITION` AS `position`
FROM
`information_schema`.`KEY_COLUMN_USAGE` AS `kcu`,
`information_schema`.`TABLE_CONSTRAINTS` AS `tc`
WHERE
`kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`TABLE_NAME` = \'resourcepaths\'
AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = \'resourcepaths\' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` IN (\'PRIMARY KEY\', \'UNIQUE\')
ORDER BY `position` ASC'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.847
4 => []
5 => 24045448
]
72 => [
0 => 'SELECT
`s`.`INDEX_NAME` AS `name`,
`s`.`COLUMN_NAME` AS `column_name`,
`s`.`NON_UNIQUE` ^ 1 AS `index_is_unique`,
`s`.`INDEX_NAME` = \'PRIMARY\' AS `index_is_primary`
FROM `information_schema`.`STATISTICS` AS `s`
WHERE `s`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `s`.`INDEX_SCHEMA` = `s`.`TABLE_SCHEMA` AND `s`.`TABLE_NAME` = \'resourcepaths\'
ORDER BY `s`.`SEQ_IN_INDEX` ASC'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720844.854
4 => []
5 => 24044704
]
73 => [
0 => 'SELECT
`s`.`INDEX_NAME` AS `name`,
`s`.`COLUMN_NAME` AS `column_name`,
`s`.`NON_UNIQUE` ^ 1 AS `index_is_unique`,
`s`.`INDEX_NAME` = \'PRIMARY\' AS `index_is_primary`
FROM `information_schema`.`STATISTICS` AS `s`
WHERE `s`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `s`.`INDEX_SCHEMA` = `s`.`TABLE_SCHEMA` AND `s`.`TABLE_NAME` = \'resourcepaths\'
ORDER BY `s`.`SEQ_IN_INDEX` ASC'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720844.856
4 => []
5 => 24046696
]
74 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/src/web/assets/orderswidget/dist\', \'a8afc292\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/src/web/assets/orderswidget/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.8615
4 => []
5 => 24046096
]
75 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/src/web/assets/orderswidget/dist\', \'a8afc292\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/src/web/assets/orderswidget/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.8632
4 => []
5 => 24046736
]
76 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/cp/dist\', \'84f51488\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/cp/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9057
4 => []
5 => 24172256
]
77 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/cp/dist\', \'84f51488\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/cp/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9061
4 => []
5 => 24172832
]
78 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/axios\', \'49e651b6\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/axios\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9186
4 => []
5 => 24178680
]
79 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/axios\', \'49e651b6\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/axios\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.919
4 => []
5 => 24179256
]
80 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/d3\', \'c467f92a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/d3\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9292
4 => []
5 => 24194800
]
81 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/d3\', \'c467f92a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/d3\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9296
4 => []
5 => 24195376
]
82 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/element-resize-detector\', \'a18f35a8\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/element-resize-detector\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9408
4 => []
5 => 24201496
]
83 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/element-resize-detector\', \'a18f35a8\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/element-resize-detector\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9413
4 => []
5 => 24202104
]
84 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/garnishjs\', \'db2ed1d8\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/garnishjs\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9526
4 => []
5 => 24208264
]
85 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/garnishjs\', \'db2ed1d8\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/garnishjs\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.953
4 => []
5 => 24208840
]
86 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery\', \'44198f7a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9607
4 => []
5 => 24213504
]
87 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery\', \'44198f7a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9611
4 => []
5 => 24214080
]
88 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery-touch-events\', \'6334dcc7\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery-touch-events\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.972
4 => []
5 => 24219856
]
89 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery-touch-events\', \'6334dcc7\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery-touch-events\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9724
4 => []
5 => 24220464
]
90 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/velocity\', \'2ab79726\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/velocity\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9826
4 => []
5 => 24226184
]
91 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/velocity\', \'2ab79726\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/velocity\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9839
4 => []
5 => 24226760
]
92 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery-ui\', \'48cd4215\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery-ui\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9948
4 => []
5 => 24233704
]
93 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery-ui\', \'48cd4215\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery-ui\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720844.9952
4 => []
5 => 24234280
]
94 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery.payment\', \'2f53217d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery.payment\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0159
4 => []
5 => 24240240
]
95 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/jquery.payment\', \'2f53217d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/jquery.payment\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0169
4 => []
5 => 24240848
]
96 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/picturefill\', \'2e46fbb7\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/picturefill\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0373
4 => []
5 => 24254816
]
97 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/picturefill\', \'2e46fbb7\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/picturefill\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0378
4 => []
5 => 24255424
]
98 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/selectize\', \'e4126c0d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/selectize\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0489
4 => []
5 => 24261704
]
99 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/selectize\', \'e4126c0d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/selectize\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0494
4 => []
5 => 24262280
]
100 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/fileupload\', \'b70f67a3\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/fileupload\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0612
4 => []
5 => 24269024
]
101 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/fileupload\', \'b70f67a3\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/fileupload\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0622
4 => []
5 => 24269632
]
102 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/xregexp\', \'8a21eda2\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/xregexp\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.073
4 => []
5 => 24275424
]
103 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/xregexp\', \'8a21eda2\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/xregexp\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0735
4 => []
5 => 24276000
]
104 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/fabric\', \'61b2152\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/fabric\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0848
4 => []
5 => 24281816
]
105 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/fabric\', \'61b2152\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/fabric\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0854
4 => []
5 => 24282392
]
106 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/iframe-resizer\', \'91372845\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/iframe-resizer\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0959
4 => []
5 => 24289360
]
107 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/iframe-resizer\', \'91372845\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/iframe-resizer\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.0963
4 => []
5 => 24289968
]
108 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/src/web/assets/statwidgets/dist\', \'ec865dc4\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/src/web/assets/statwidgets/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1106
4 => []
5 => 24299592
]
109 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/src/web/assets/statwidgets/dist\', \'ec865dc4\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/src/web/assets/statwidgets/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.111
4 => []
5 => 24300200
]
110 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/lib/deepmerge\', \'ebe51740\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/lib/deepmerge\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1269
4 => []
5 => 24305656
]
111 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/lib/deepmerge\', \'ebe51740\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/lib/deepmerge\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1273
4 => []
5 => 24306232
]
112 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/lib\', \'90b7b569\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/lib\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.147
4 => []
5 => 24312120
]
113 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/commerce3/lib\', \'90b7b569\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/commerce3/lib\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1474
4 => []
5 => 24312696
]
114 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/admintable/dist\', \'2f3120e7\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/admintable/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.166
4 => []
5 => 24320272
]
115 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/admintable/dist\', \'2f3120e7\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/admintable/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1664
4 => []
5 => 24320848
]
116 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/vue\', \'ec639981\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/vue\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1797
4 => []
5 => 24326624
]
117 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/vue\', \'ec639981\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/vue\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720845.1801
4 => []
5 => 24327200
]
118 => [
0 => 'SELECT `id`, `dateCreated`, `dateUpdated`, `colspan`, `type`, `settings`
FROM `widgets`
WHERE `userId`=1
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.1794
4 => []
5 => 25191136
]
119 => [
0 => 'SELECT `id`, `dateCreated`, `dateUpdated`, `colspan`, `type`, `settings`
FROM `widgets`
WHERE `userId`=1
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.18
4 => []
5 => 25194976
]
120 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/quickpost/dist\', \'25f0b932\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/quickpost/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.1936
4 => []
5 => 25202544
]
121 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@app/web/assets/quickpost/dist\', \'25f0b932\') ON DUPLICATE KEY UPDATE `path`=\'@app/web/assets/quickpost/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.1941
4 => []
5 => 25203120
]
122 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=197
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.2039
4 => []
5 => 25279496
]
123 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=197
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.2046
4 => []
5 => 25283176
]
124 => [
0 => 'SELECT `id`, `dateCreated`, `dateUpdated`, `name`, `handle`, `hasUrls`, `url`, `sortOrder`, `fieldLayoutId`, `type`, `settings`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `volumes`
WHERE `dateDeleted` IS NULL
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.3243
4 => []
5 => 26212024
]
125 => [
0 => 'SELECT `id`, `dateCreated`, `dateUpdated`, `name`, `handle`, `hasUrls`, `url`, `sortOrder`, `fieldLayoutId`, `type`, `settings`, `uid`, `titleTranslationMethod`, `titleTranslationKeyFormat`
FROM `volumes`
WHERE `dateDeleted` IS NULL
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.3251
4 => []
5 => 26218736
]
126 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.3803
4 => []
5 => 26417512
]
127 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.3823
4 => []
5 => 26419432
]
128 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.3894
4 => []
5 => 26437224
]
129 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.3899
4 => []
5 => 26439144
]
130 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/prismjs\', \'382b867a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/prismjs\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.4106
4 => []
5 => 26533848
]
131 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-next/lib/prismjs\', \'382b867a\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-next/lib/prismjs\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.411
4 => []
5 => 26534424
]
132 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/field/dist\', \'4c83401d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/field/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.6528
4 => []
5 => 27470200
]
133 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/field/dist\', \'4c83401d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/field/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.6532
4 => []
5 => 27470808
]
134 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor/dist\', \'8702aabb\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor/dist\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.7119
4 => []
5 => 27501352
]
135 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor/dist\', \'8702aabb\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor/dist\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.7129
4 => []
5 => 27501960
]
136 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7742
4 => []
5 => 27731968
]
137 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.7747
4 => []
5 => 27734992
]
138 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7749
4 => []
5 => 27737200
]
139 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.7754
4 => []
5 => 27740848
]
140 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7755
4 => []
5 => 27736640
]
141 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.7761
4 => []
5 => 27739664
]
142 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7763
4 => []
5 => 27741872
]
143 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.7766
4 => []
5 => 27745520
]
144 => [
0 => 'SELECT `productTypes`.`id`, `productTypes`.`fieldLayoutId`, `productTypes`.`variantFieldLayoutId`, `productTypes`.`name`, `productTypes`.`handle`, `productTypes`.`hasDimensions`, `productTypes`.`hasVariants`, `productTypes`.`hasVariantTitleField`, `productTypes`.`titleFormat`, `productTypes`.`hasProductTitleField`, `productTypes`.`productTitleFormat`, `productTypes`.`skuFormat`, `productTypes`.`descriptionFormat`, `productTypes`.`uid`
FROM `commerce_producttypes` `productTypes`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7841
4 => []
5 => 27743896
]
145 => [
0 => 'SELECT `productTypes`.`id`, `productTypes`.`fieldLayoutId`, `productTypes`.`variantFieldLayoutId`, `productTypes`.`name`, `productTypes`.`handle`, `productTypes`.`hasDimensions`, `productTypes`.`hasVariants`, `productTypes`.`hasVariantTitleField`, `productTypes`.`titleFormat`, `productTypes`.`hasProductTitleField`, `productTypes`.`productTitleFormat`, `productTypes`.`skuFormat`, `productTypes`.`descriptionFormat`, `productTypes`.`uid`
FROM `commerce_producttypes` `productTypes`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.7862
4 => []
5 => 27746832
]
146 => [
0 => 'SELECT `id`, `productTypeId`, `siteId`, `uriFormat`, `hasUrls`, `template`
FROM `commerce_producttypes_sites`
WHERE `productTypeId`=\'1\''
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.7943
4 => []
5 => 27788400
]
147 => [
0 => 'SELECT `id`, `productTypeId`, `siteId`, `uriFormat`, `hasUrls`, `template`
FROM `commerce_producttypes_sites`
WHERE `productTypeId`=\'1\''
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.795
4 => []
5 => 27790320
]
148 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.8295
4 => []
5 => 28244480
]
149 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.83
4 => []
5 => 28247504
]
150 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.8302
4 => []
5 => 28249712
]
151 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.8306
4 => []
5 => 28253360
]
152 => [
0 => 'SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `interlace`, `dimensionChangeTime`, `uid`
FROM `assettransforms`
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.8308
4 => []
5 => 28252432
]
153 => [
0 => 'SELECT `id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `interlace`, `dimensionChangeTime`, `uid`
FROM `assettransforms`
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.832
4 => []
5 => 28257200
]
154 => [
0 => 'SELECT `bt`.`id`, `bt`.`fieldId`, `bt`.`fieldLayoutId`, `bt`.`name`, `bt`.`handle`, `bt`.`sortOrder`, `bt`.`uid`
FROM `matrixblocktypes` `bt`
WHERE `bt`.`fieldId`=4
ORDER BY `bt`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.877
4 => []
5 => 28545792
]
155 => [
0 => 'SELECT `bt`.`id`, `bt`.`fieldId`, `bt`.`fieldLayoutId`, `bt`.`name`, `bt`.`handle`, `bt`.`sortOrder`, `bt`.`uid`
FROM `matrixblocktypes` `bt`
WHERE `bt`.`fieldId`=4
ORDER BY `bt`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.8793
4 => []
5 => 28551688
]
156 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=179)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.8943
4 => []
5 => 28580192
]
157 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=179)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.8947
4 => []
5 => 28581400
]
158 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=179
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.8948
4 => []
5 => 28581744
]
159 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=179
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.8952
4 => []
5 => 28583856
]
160 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=179
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9024
4 => []
5 => 28604880
]
161 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=179
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.903
4 => []
5 => 28609704
]
162 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=180)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9196
4 => []
5 => 28708600
]
163 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=180)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.92
4 => []
5 => 28709808
]
164 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=180
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9202
4 => []
5 => 28710152
]
165 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=180
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9206
4 => []
5 => 28712264
]
166 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=180
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9208
4 => []
5 => 28718528
]
167 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=180
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9213
4 => []
5 => 28723336
]
168 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=181)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9218
4 => []
5 => 28725920
]
169 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=181)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9221
4 => []
5 => 28727128
]
170 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=181
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9222
4 => []
5 => 28727472
]
171 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=181
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9226
4 => []
5 => 28729808
]
172 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=181
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9228
4 => []
5 => 28735904
]
173 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=181
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9239
4 => []
5 => 28743184
]
174 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/fullscreen\', \'96ec098d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/fullscreen\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.9432
4 => []
5 => 28814824
]
175 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/fullscreen\', \'96ec098d\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/fullscreen\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.9437
4 => []
5 => 28815528
]
176 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/video\', \'47c0ef21\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/video\''
1 => 80
2 => 'yii\\db\\Command::execute'
3 => 1610720846.957
4 => []
5 => 28823304
]
177 => [
0 => 'INSERT INTO `resourcepaths` (`path`, `hash`) VALUES (\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/video\', \'47c0ef21\') ON DUPLICATE KEY UPDATE `path`=\'@rootUrl/app/craft3-redactor/src/assets/redactor-plugins/dist/video\''
1 => 96
2 => 'yii\\db\\Command::execute'
3 => 1610720846.9574
4 => []
5 => 28823944
]
178 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=8
ORDER BY `sites`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9607
4 => []
5 => 28830896
]
179 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=8
ORDER BY `sites`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9624
4 => []
5 => 28833120
]
180 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=2
ORDER BY `sites`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9693
4 => []
5 => 28856376
]
181 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=2
ORDER BY `sites`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9699
4 => []
5 => 28858680
]
182 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=5
ORDER BY `sites`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.97
4 => []
5 => 28859184
]
183 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=5
ORDER BY `sites`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9704
4 => []
5 => 28861488
]
184 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=3
ORDER BY `sites`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9705
4 => []
5 => 28861616
]
185 => [
0 => 'SELECT `sections_sites`.`id`, `sections_sites`.`sectionId`, `sections_sites`.`siteId`, `sections_sites`.`enabledByDefault`, `sections_sites`.`hasUrls`, `sections_sites`.`uriFormat`, `sections_sites`.`template`
FROM `sections_sites` `sections_sites`
INNER JOIN `sites` `sites` ON `sites`.`id` = `sections_sites`.`siteId`
WHERE `sections_sites`.`sectionId`=3
ORDER BY `sites`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9709
4 => []
5 => 28863920
]
186 => [
0 => 'SELECT *
FROM `categorygroups`
WHERE `categorygroups`.`dateDeleted` IS NULL
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9783
4 => []
5 => 28881552
]
187 => [
0 => 'SELECT *
FROM `categorygroups`
WHERE `categorygroups`.`dateDeleted` IS NULL
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9794
4 => []
5 => 28882632
]
188 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9795
4 => []
5 => 28885816
]
189 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9799
4 => []
5 => 28888840
]
190 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9802
4 => []
5 => 28891048
]
191 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9806
4 => []
5 => 28894696
]
192 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9807
4 => []
5 => 28888960
]
193 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9812
4 => []
5 => 28891984
]
194 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9813
4 => []
5 => 28894192
]
195 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9817
4 => []
5 => 28897840
]
196 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9819
4 => []
5 => 28893760
]
197 => [
0 => 'SELECT `uid`, `id`
FROM `volumes`
WHERE `uid` IN (\'0193dc64-5499-4e28-95dd-f8f603154851\', \'7d6a9bef-727c-4a0c-9791-4f423956de69\', \'3fc34ff2-8da7-4a35-8147-f0a2e01392b9\', \'1f0ea10d-2be0-4638-88da-105d232f4787\')'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9822
4 => []
5 => 28896784
]
198 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720846.9824
4 => []
5 => 28898992
]
199 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId` IN (\'1\', \'2\', \'3\', \'4\')) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720846.9827
4 => []
5 => 28902640
]
200 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=182)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0066
4 => []
5 => 28906568
]
201 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=182)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.007
4 => []
5 => 28907776
]
202 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=182
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0071
4 => []
5 => 28908440
]
203 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=182
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0075
4 => []
5 => 28910776
]
204 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=182
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0078
4 => []
5 => 28916872
]
205 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=182
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0083
4 => []
5 => 28923880
]
206 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=183)
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0091
4 => []
5 => 28933608
]
207 => [
0 => 'SELECT `id`, `type`, `uid`
FROM `fieldlayouts`
WHERE (`dateDeleted` IS NULL) AND (`id`=183)
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0095
4 => []
5 => 28934816
]
208 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=183
ORDER BY `sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0096
4 => []
5 => 28935160
]
209 => [
0 => 'SELECT `id`, `layoutId`, `name`, `sortOrder`, `uid`, `elements`
FROM `fieldlayouttabs`
WHERE `layoutId`=183
ORDER BY `sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0099
4 => []
5 => 28937688
]
210 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=183
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0102
4 => []
5 => 28943968
]
211 => [
0 => 'SELECT `fields`.`id`, `fields`.`dateCreated`, `fields`.`dateUpdated`, `fields`.`groupId`, `fields`.`name`, `fields`.`handle`, `fields`.`context`, `fields`.`instructions`, `fields`.`translationMethod`, `fields`.`translationKeyFormat`, `fields`.`type`, `fields`.`settings`, `fields`.`uid`, `fields`.`searchable`, `flf`.`layoutId`, `flf`.`tabId`, `flf`.`required`, `flf`.`sortOrder`
FROM `fields` `fields`
INNER JOIN `fieldlayoutfields` `flf` ON `flf`.`fieldId` = `fields`.`id`
INNER JOIN `fieldlayouttabs` `flt` ON `flt`.`id` = `flf`.`tabId`
WHERE `flf`.`layoutId`=183
ORDER BY `flt`.`sortOrder`, `flf`.`sortOrder`'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0107
4 => []
5 => 28953864
]
212 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0113
4 => []
5 => 28991568
]
213 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0117
4 => []
5 => 28993488
]
214 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 80
2 => 'yii\\db\\Command::query'
3 => 1610720847.0118
4 => []
5 => 28993504
]
215 => [
0 => 'SELECT `id`, `parentId`, `volumeId`, `name`, `path`, `uid`
FROM `volumefolders`
WHERE (`volumeId`=1) AND ((`parentId` IS NULL) OR (`parentId`=\'\'))
ORDER BY `name`
LIMIT 1'
1 => 96
2 => 'yii\\db\\Command::query'
3 => 1610720847.0121
4 => []
5 => 28995424
]
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment