info

	
sql
success
backtrace
	
SET NAMES utf8
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->initFlexorm() at Application.php:85
#3 Flexorm->init() at Application.php:415
#4 MysqlAdapter->__construct() at Flexorm.php:72
#5 MysqlAdapter->connect() at MysqlAdapter.php:16
#6 MysqlAdapter->setCharset() at MysqlAdapter.php:41
#7 MysqlAdapter->executeQuery() at MysqlAdapter.php:51
#8 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->initFlexorm() at Application.php:85
#3 MysqlAdapter->executeQuery() at Application.php:421
#4 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
select id from Provider where shortName = "piklas";
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->auth() at Application.php:87
#3 AuthComponent->isLoggedIn() at Application.php:356
#4 AuthComponent->authenticate() at AuthComponent.php:193
#5 Application->FlexConfig() at AuthComponent.php:55
#6 PiklasFlexConfig->__construct() at Application.php:1631
#7 AppFlexConfig->__construct() at PiklasFlexConfig.php:10
#8 Application->provider() at AppFlexConfig.php:14
#9 Application->loadProvider() at Application.php:441
#10 ProviderMapper->getIdByShortName() at Application.php:467
#11 Adapter->findAllByQueryAsArray() at ProviderMapper.php:16
#12 MysqlAdapter->executeQuery() at Adapter.php:1622
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `Provider`.*, `ContactDetail`.*, `FinancingContactDetail`.*
FROM `Provider` 
LEFT JOIN `ContactDetail` ON `Provider`.`ContactDetail_id` = `ContactDetail`.`id`
LEFT JOIN `ContactDetail` AS `FinancingContactDetail` ON `Provider`.`FinancingContactDetail_id` = `FinancingContactDetail`.`id` 
WHERE `Provider`.`shortName` = "piklas"
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->auth() at Application.php:87
#3 AuthComponent->isLoggedIn() at Application.php:356
#4 AuthComponent->authenticate() at AuthComponent.php:193
#5 Application->FlexConfig() at AuthComponent.php:55
#6 PiklasFlexConfig->__construct() at Application.php:1631
#7 AppFlexConfig->__construct() at PiklasFlexConfig.php:10
#8 Application->provider() at AppFlexConfig.php:14
#9 Application->loadProvider() at Application.php:441
#10 ProviderMapper->getByShortName() at Application.php:475
#11 QueryBuilder->findByAdapter() at ProviderMapper.php:36
#12 Adapter->findByQueryBuilder() at QueryBuilder.php:494
#13 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#14 MysqlAdapter->executeQuery() at Adapter.php:1373
#15 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `ContactDetail`.*, `User`.*, `GroupContactDetail`.*, `DeliveryContactDetail`.*, `InvoiceContactDetail`.*
FROM `ContactDetail` 
LEFT JOIN `User` ON `ContactDetail`.`coach_User_id` = `User`.`id`
LEFT JOIN `ContactDetail` AS `GroupContactDetail` ON `ContactDetail`.`group_ContactDetail_id` = `GroupContactDetail`.`id`
LEFT JOIN `ContactDetail` AS `DeliveryContactDetail` ON `ContactDetail`.`deliveryContactDetail_id` = `DeliveryContactDetail`.`id`
LEFT JOIN `ContactDetail` AS `InvoiceContactDetail` ON `ContactDetail`.`invoiceContactDetail_id` = `InvoiceContactDetail`.`id` 
WHERE `ContactDetail`.`id` = "500000"
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->auth() at Application.php:87
#3 AuthComponent->isLoggedIn() at Application.php:356
#4 AuthComponent->authenticate() at AuthComponent.php:193
#5 Application->FlexConfig() at AuthComponent.php:55
#6 PiklasFlexConfig->__construct() at Application.php:1631
#7 AppFlexConfig->__construct() at PiklasFlexConfig.php:10
#8 Application->provider() at AppFlexConfig.php:14
#9 Application->loadProvider() at Application.php:441
#10 ProviderMapper->getByShortName() at Application.php:475
#11 Mapper->findWithRelations() at ProviderMapper.php:41
#12 Adapter->find() at Mapper.php:75
#13 Adapter->findByQueryBuilder() at Adapter.php:1104
#14 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#15 MysqlAdapter->executeQuery() at Adapter.php:1373
#16 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `User`.*, `ContactDetail`.*, `VaravalmentajaUser`.*, `CoachUser`.*, `RepairManUser`.*, `MeasurerUser`.*
FROM `User` 
LEFT JOIN `ContactDetail` ON `User`.`ContactDetail_id` = `ContactDetail`.`id`
LEFT JOIN `User` AS `VaravalmentajaUser` ON `User`.`varavalmentajaUser_id` = `VaravalmentajaUser`.`id`
LEFT JOIN `User` AS `CoachUser` ON `User`.`coachUser_id` = `CoachUser`.`id`
LEFT JOIN `User` AS `RepairManUser` ON `User`.`defaultRepairManUser_id` = `RepairManUser`.`id`
LEFT JOIN `User` AS `MeasurerUser` ON `User`.`defaultMeasurerUser_id` = `MeasurerUser`.`id` 
WHERE `User`.`id` = 2
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 Application->priceUser() at Application.php:267
#3 UserMapper->WebShopPriceUser() at Application.php:506
#4 UserMapper->findWithRelations() at UserMapper.php:855
#5 Adapter->find() at UserMapper.php:226
#6 Adapter->findByQueryBuilder() at Adapter.php:1104
#7 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#8 MysqlAdapter->executeQuery() at Adapter.php:1373
#9 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `FileType`.*
FROM `FileType` 
WHERE (
`FileType`.`optionalProvider_id` = "2"
OR
`FileType`.`optionalProvider_id` IS NULL
)
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->beforeAction() at ActionRunner.php:310
#7 AppController->beforeAction() at MediaFileController.php:11
#8 FileTypeMapper->getProvidersFiletypes() at AppController.php:191
#9 QueryBuilder->findAll() at FileTypeMapper.php:32
#10 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#11 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#12 MysqlAdapter->executeQuery() at Adapter.php:1373
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `ProductCategory`.*
FROM `ProductCategory`;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->beforeAction() at ActionRunner.php:310
#7 AppController->beforeAction() at MediaFileController.php:11
#8 ProductCategoryMapper->findAllByIds() at AppController.php:198
#9 Mapper->findAll() at ProductCategoryMapper.php:6
#10 Adapter->findAll() at Mapper.php:252
#11 Adapter->findAllByQueryBuilder() at Adapter.php:1138
#12 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#13 MysqlAdapter->executeQuery() at Adapter.php:1373
#14 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `FileType`.*
FROM `FileType` 
WHERE `FileType`.`id` = 13
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 Mapper->find() at MediaFileController.php:122
#8 Adapter->find() at Mapper.php:69
#9 Adapter->findByQueryBuilder() at Adapter.php:1104
#10 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#11 MysqlAdapter->executeQuery() at Adapter.php:1373
#12 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `FileType`.*
FROM `FileType` 
WHERE `FileType`.`optionalProvider_id` = "2"
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 QueryBuilder->getIterator() at MediaFileController.php:133
#8 QueryBuilder->findAllOnce() at QueryBuilder.php:598
#9 QueryBuilder->findAll() at QueryBuilder.php:618
#10 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#11 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#12 MysqlAdapter->executeQuery() at Adapter.php:1373
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `User`.*, `ContactDetail`.*, `VaravalmentajaUser`.*, `CoachUser`.*, `RepairManUser`.*, `MeasurerUser`.*
FROM `User` 
LEFT JOIN `ContactDetail` ON `User`.`ContactDetail_id` = `ContactDetail`.`id`
LEFT JOIN `User` AS `VaravalmentajaUser` ON `User`.`varavalmentajaUser_id` = `VaravalmentajaUser`.`id`
LEFT JOIN `User` AS `CoachUser` ON `User`.`coachUser_id` = `CoachUser`.`id`
LEFT JOIN `User` AS `RepairManUser` ON `User`.`defaultRepairManUser_id` = `RepairManUser`.`id`
LEFT JOIN `User` AS `MeasurerUser` ON `User`.`defaultMeasurerUser_id` = `MeasurerUser`.`id` 
WHERE `User`.`id` = 2
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:143
#8 UserMapper->findWithRelations() at MediaFileMapper.php:207
#9 Adapter->find() at UserMapper.php:226
#10 Adapter->findByQueryBuilder() at Adapter.php:1104
#11 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#12 MysqlAdapter->executeQuery() at Adapter.php:1373
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `UserHasRole`.* FROM `UserHasRole` WHERE UserHasRole.Provider_id = 2 and `UserHasRole`.`User_id` = 2
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:143
#8 User->userRoleIds() at MediaFileMapper.php:210
#9 User->UserHasRoles() at User.php:1302
#10 UserHasRoleMapper->UserHasRolesForUserId() at User.php:1261
#11 Adapter->findAllByQueryWithoutIndexingById() at UserHasRoleMapper.php:10
#12 MysqlAdapter->executeQuery() at Adapter.php:1582
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT MediaFile.* FROM MediaFile WHERE MediaFile.Provider_id = 2  AND MediaFile.FileType_id = 13 AND MediaFile.deleted_datetime IS NULL  AND (MediaFile.id IN
						(
							SELECT FileKeyword.MediaFile_id
							FROM FileKeyword
							JOIN KeywordHasRole ON FileKeyword.Keyword_id = KeywordHasRole.Keyword_id AND KeywordHasRole.Role_id IN (6)
						)) ORDER bY CASE WHEN MediaFile.sortOrder IS NULL THEN 1 ELSE 0 END, MediaFile.sortOrder ASC, MediaFile.added_datetime DESC LIMIT 24 OFFSET 0
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:143
#8 Adapter->findAllByQuery() at MediaFileMapper.php:342
#9 MysqlAdapter->executeQuery() at Adapter.php:1550
#10 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `FileKeyword`.*
FROM `FileKeyword` 
WHERE `FileKeyword`.`MediaFile_id` IN (920170, 920169)
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:143
#8 FileKeywordMapper->getFileKeywordsByMediaFileIDs() at MediaFileMapper.php:344
#9 Adapter->structurizeAndCheckUnique() at FileKeywordMapper.php:59
#10 QueryBuilder->getIterator() at Adapter.php:1907
#11 QueryBuilder->findAllOnce() at QueryBuilder.php:598
#12 QueryBuilder->findAll() at QueryBuilder.php:618
#13 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#14 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#15 MysqlAdapter->executeQuery() at Adapter.php:1373
#16 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `User`.*, `ContactDetail`.*, `VaravalmentajaUser`.*, `CoachUser`.*, `RepairManUser`.*, `MeasurerUser`.*
FROM `User` 
LEFT JOIN `ContactDetail` ON `User`.`ContactDetail_id` = `ContactDetail`.`id`
LEFT JOIN `User` AS `VaravalmentajaUser` ON `User`.`varavalmentajaUser_id` = `VaravalmentajaUser`.`id`
LEFT JOIN `User` AS `CoachUser` ON `User`.`coachUser_id` = `CoachUser`.`id`
LEFT JOIN `User` AS `RepairManUser` ON `User`.`defaultRepairManUser_id` = `RepairManUser`.`id`
LEFT JOIN `User` AS `MeasurerUser` ON `User`.`defaultMeasurerUser_id` = `MeasurerUser`.`id` 
WHERE `User`.`id` = 2
 LIMIT 1;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:146
#8 UserMapper->findWithRelations() at MediaFileMapper.php:207
#9 Adapter->find() at UserMapper.php:226
#10 Adapter->findByQueryBuilder() at Adapter.php:1104
#11 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#12 MysqlAdapter->executeQuery() at Adapter.php:1373
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `UserHasRole`.* FROM `UserHasRole` WHERE UserHasRole.Provider_id = 2 and `UserHasRole`.`User_id` = 2
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:146
#8 User->userRoleIds() at MediaFileMapper.php:210
#9 User->UserHasRoles() at User.php:1302
#10 UserHasRoleMapper->UserHasRolesForUserId() at User.php:1261
#11 Adapter->findAllByQueryWithoutIndexingById() at UserHasRoleMapper.php:10
#12 MysqlAdapter->executeQuery() at Adapter.php:1582
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT MediaFile.* FROM MediaFile WHERE MediaFile.Provider_id = 2  AND MediaFile.FileType_id = 13 AND MediaFile.deleted_datetime IS NULL  AND (MediaFile.id IN
						(
							SELECT FileKeyword.MediaFile_id
							FROM FileKeyword
							JOIN KeywordHasRole ON FileKeyword.Keyword_id = KeywordHasRole.Keyword_id AND KeywordHasRole.Role_id IN (6)
						)) ORDER bY CASE WHEN MediaFile.sortOrder IS NULL THEN 1 ELSE 0 END, MediaFile.sortOrder ASC, MediaFile.added_datetime DESC
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:146
#8 Adapter->findAllByQuery() at MediaFileMapper.php:342
#9 MysqlAdapter->executeQuery() at Adapter.php:1550
#10 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `FileKeyword`.*
FROM `FileKeyword` 
WHERE `FileKeyword`.`MediaFile_id` IN (920170, 920169)
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesBySearches() at MediaFileController.php:146
#8 FileKeywordMapper->getFileKeywordsByMediaFileIDs() at MediaFileMapper.php:344
#9 Adapter->structurizeAndCheckUnique() at FileKeywordMapper.php:59
#10 QueryBuilder->getIterator() at Adapter.php:1907
#11 QueryBuilder->findAllOnce() at QueryBuilder.php:598
#12 QueryBuilder->findAll() at QueryBuilder.php:618
#13 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#14 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#15 MysqlAdapter->executeQuery() at Adapter.php:1373
#16 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `Keyword`.*, `KeywordGroup`.*
FROM `Keyword` 
LEFT JOIN `KeywordGroup` ON `Keyword`.`KeywordGroup_id` = `KeywordGroup`.`id` 
WHERE `Keyword`.`optionalProvider_id` = "2"
AND
`Keyword`.`FileType_id` = 13
AND
`Keyword`.`isHidden` = 0
 
ORDER BY `Keyword`.`KeywordGroup_id` ASC;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 QueryBuilder->findAll() at MediaFileController.php:151
#8 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#9 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#10 MysqlAdapter->executeQuery() at Adapter.php:1373
#11 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `Keyword`.*, `KeywordGroup`.*
FROM `Keyword` 
LEFT JOIN `KeywordGroup` ON `Keyword`.`KeywordGroup_id` = `KeywordGroup`.`id` 
WHERE `Keyword`.`optionalProvider_id` = "2"
AND
`Keyword`.`FileType_id` = 13
AND
`Keyword`.`isHidden` = 0
 
ORDER BY `Keyword`.`KeywordGroup_id` ASC;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 Mapper->structurizeAndCheckUnique() at MediaFileController.php:153
#8 Adapter->structurizeAndCheckUnique() at Mapper.php:548
#9 QueryBuilder->getIterator() at Adapter.php:1907
#10 QueryBuilder->findAllOnce() at QueryBuilder.php:598
#11 QueryBuilder->findAll() at QueryBuilder.php:618
#12 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#13 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#14 MysqlAdapter->executeQuery() at Adapter.php:1373
#15 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `KeywordGroup`.*
FROM `KeywordGroup` 
WHERE `KeywordGroup`.`Provider_id` = "2"
AND
`KeywordGroup`.`FileType_id` = 13
AND
`KeywordGroup`.`isHidden` = 0
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 QueryBuilder->findAll() at MediaFileController.php:157
#8 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#9 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#10 MysqlAdapter->executeQuery() at Adapter.php:1373
#11 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74

info

	
sql
success
backtrace
	
SELECT `MediaFile`.*
FROM `MediaFile` 
WHERE `MediaFile`.`Provider_id` = 2
AND
`MediaFile`.`deleted_datetime` IS NOT NULL
AND
`MediaFile`.`isHidden` = 0
AND
`MediaFile`.`Order_id` IS NULL
;
1
#0 require() at index.php:214
#1 Application->run() at init.php:55
#2 AbstractApplication->run() at Application.php:275
#3 ActionRunner->runActionByRequest() at AbstractApplication.php:34
#4 ActionRunner->runActionAndLayout() at ActionRunner.php:36
#5 ActionRunner->runAction() at ActionRunner.php:90
#6 MediaFileController->index() at ActionRunner.php:352
#7 MediaFileMapper->getReferenceMediaFilesWithDeletedDatetimeNotNull() at MediaFileController.php:253
#8 QueryBuilder->findAll() at MediaFileMapper.php:658
#9 Adapter->findAllByQueryBuilder() at QueryBuilder.php:511
#10 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1463
#11 MysqlAdapter->executeQuery() at Adapter.php:1373
#12 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74