| 0 | 1 |
|---|
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 ProductController->beforeAction() at ActionRunner.php:310
#7 AppController->beforeAction() at ProductController.php:18
#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 ProductController->beforeAction() at ActionRunner.php:310
#7 AppController->beforeAction() at ProductController.php:18
#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 * from Vero; |
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 ProductController->show() at ActionRunner.php:352
#7 User->Vero() at ProductController.php:215
#8 VeroMapper->Vero() at User.php:1336
#9 VeroMapper->kaikkiVerot() at VeroMapper.php:30
#10 Adapter->findAllByQuery() at VeroMapper.php:11
#11 MysqlAdapter->executeQuery() at Adapter.php:1550
#12 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `Product`.*, `Product`.*, `ProductCategory`.*, `SubProductCategory`.*, `ProductDetail`.*, `FactoryContactDetail`.*
FROM `Product`
LEFT JOIN `ProductCategory` ON `Product`.`ProductCategory_id` = `ProductCategory`.`id`
LEFT JOIN `SubProductCategory` ON `Product`.`SubProductCategory_id` = `SubProductCategory`.`id`
JOIN `ProductDetail` ON `ProductDetail`.`Product_id` = `Product`.`id` AND `ProductDetail`.`Provider_id` = "2"
LEFT JOIN `ContactDetail` AS `FactoryContactDetail` ON `ProductDetail`.`factoryContactDetail_id` = `FactoryContactDetail`.`id`
WHERE `Product`.`id` = 326
AND
`ProductDetail`.`isActive` <> "false"
AND
`ProductDetail`.`isActive` <> "inProgress"
AND
`ProductDetail`.`isActive` <> "notWebstore"
AND
`ProductDetail`.`virtualProvider` is NULL
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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->find() at ProductController.php:243
#8 Adapter->findByQueryBuilder() at ProductMapper.php:61
#9 Adapter->executeQueryBuilderFirstQuery() at Adapter.php:1213
#10 MysqlAdapter->executeQuery() at Adapter.php:1373
#11 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "326"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->find() at ProductController.php:243
#8 Adapter->findByQueryBuilder() at ProductMapper.php:61
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1218
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | queryName | backtrace |
|---|
SELECT `Product`.*, `ProductCategory`.*, `SubProductCategory`.*, `ProductDetail`.*, `FactoryContactDetail`.*
FROM `Product`
LEFT JOIN `ProductCategory` ON `Product`.`ProductCategory_id` = `ProductCategory`.`id`
LEFT JOIN `SubProductCategory` ON `Product`.`SubProductCategory_id` = `SubProductCategory`.`id`
JOIN `ProductDetail` ON `ProductDetail`.`Product_id` = `Product`.`id` AND `ProductDetail`.`Provider_id` = "2"
LEFT JOIN `ContactDetail` AS `FactoryContactDetail` ON `ProductDetail`.`factoryContactDetail_id` = `FactoryContactDetail`.`id`
WHERE `ProductDetail`.`Provider_id` = "2"
AND
`ProductDetail`.`isActive` <> "false"
AND
`ProductDetail`.`isActive` <> "inProgress"
AND
`ProductDetail`.`isActive` <> "notWebstore"
AND
`ProductDetail`.`virtualProvider` is NULL
ORDER BY `Product`.`kind` ASC, `Product`.`kind` ASC, `ProductDetail`.`sortOrder` ASC, `Product`.`name` ASC; |
1 |
findAllByCategory |
#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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#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 `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "1"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "2"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "3"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "6"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "13"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "12"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "81"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "82"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "34"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "326"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "417"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "40"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "327"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "35"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "45"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "41"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "37"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "48"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "47"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "38"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "328"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "44"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "46"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "329"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "43"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "39"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "243"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
SELECT `TechInfo`.*
FROM `TechInfo`
WHERE (
`TechInfo`.`Product_id` = "377"
AND
(
`TechInfo`.`Provider_id` = "2"
OR
`TechInfo`.`Provider_id` = NULL
)
)
ORDER BY `TechInfo`.`sortOrder` ASC, `TechInfo`.`property` 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 ProductController->show() at ActionRunner.php:352
#7 ProductMapper->findAllByCategory() at ProductController.php:545
#8 Adapter->findAllByQueryBuilder() at ProductMapper.php:234
#9 Adapter->fetchRelatedObjectsFor() at Adapter.php:1488
#10 Adapter->executeQueryBuilderRestQueries() at Adapter.php:1429
#11 Adapter->executeQueries() at Adapter.php:1400
#12 MysqlAdapter->executeQuery() at Adapter.php:1412
#13 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | queryName | backtrace |
|---|
SELECT DISTINCT `Option`.*, OptionPrice.innerGlass+0 as innerGlassFromOptionPrice, OptionPrice.outerGlass+0 as outerGlassFromOptionPrice, OptionPrice.innerGlassPartDetail_id+0 as innerGlassPartDetailIdFromOptionPrice, OptionPrice.outerGlassPartDetail_id+0 as outerGlassPartDetailIdFromOptionPrice, OptionPrice.innerGlassPartDetail_id_96+0 as innerGlassPartDetailId96FromOptionPrice, `RelativeOption`.*
FROM `Option`
LEFT JOIN `Option` AS `RelativeOption` ON `Option`.`relativeOptionId` = `RelativeOption`.`id`
LEFT JOIN OptionPrice on `Option`.`id` = OptionPrice.Option_id
and (
OptionPrice.Provider_id = 2
OR
(
(
OptionPrice.includedProviders = 'ALL'
OR OptionPrice.includedProviders Like '%,2,%'
)
AND
(
OptionPrice.excludedProviders NOT Like '%,2,%'
OR OptionPrice.excludedProviders IS null
)
)
)
WHERE (
`Option`.`Product_id` IN (326)
OR
`Option`.`Products_id` LIKE "%,326,%"
)
AND
`Option`.`Order_id` is NULL
AND
(
(
`Option`.`includedProviders` LIKE "%,2,%"
OR
`Option`.`includedProviders` = "ALL"
)
AND
(
`Option`.`excludedProviders` <> "REMOVED"
AND
(
`Option`.`excludedProviders` = "NONE"
OR
`Option`.`excludedProviders` NOT LIKE "%,2,%"
)
)
)
AND
`Option`.`onlySeller` <> 1
AND
`Option`.`optionLevel` <= "10"
GROUP BY `Option`.`id`
ORDER BY `Option`.`usage` ASC, `Option`.`sortOrder` ASC, `Option`.`id` ASC; |
1 |
findAllOptionsByProduct |
#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 ProductController->show() at ActionRunner.php:352
#7 OptionMapper->findAllOptionsForConfigPageRR() at ProductController.php:1085
#8 OptionMapper->findAllOptionsByProduct() at OptionMapper.php:1763
#9 Adapter->findAllByQueryBuilderCheckingIdUniquity() at OptionMapper.php:245
#10 Adapter->findAllByQueryBuilder() at Adapter.php:1451
#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 id, Option_id, infoText, readMoreText, pic, width from OptionInfo where Provider_id=2 and `target`='option' and Option_id in (17676,17677,17678,17679,17680,24274,24275,24276,24277,24278,24279,40383,19119,21159,17593,17594,17595,17643,17650,17652,17649,17653,17656,17659,17648,17655,17660,17647,17654,17661,17657,17662,17645,17663,17646,17664,17641,17638,17639,17640,17044,17644,17642,17637,17665,17667,17668,17669,17670,17671,17690,17601,17602,17603,17600,17604,17605,17606,17599,17608,17609,17691,16766,16767,17693,17694,17698,17696,17695,17697,17699,17692,17723,21773,25433,21775,25434,25435,25436,25493,21776,25641,25643,25437,25652,25646,25654,26261) |
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 ProductController->show() at ActionRunner.php:352
#7 OptionInfoMapper->getMiniOptionInfosByOptions() at ProductController.php:1358
#8 Adapter->findAllByQueryAsArrayByIndexing() at OptionInfoMapper.php:37
#9 MysqlAdapter->executeQuery() at Adapter.php:1645
#10 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
select id, `usage`, infoText, readMoreText, pic, width from OptionInfo where Provider_id=2 and `target`='usage' and `usage` in ('asennus','innerGlass','karmireika','karmisyvyys','lock','turvalasi','vari','varuste','workOption') |
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 ProductController->show() at ActionRunner.php:352
#7 OptionInfoMapper->getMiniOptionInfosByOptions() at ProductController.php:1358
#8 Adapter->findAllByQueryAsArrayByIndexing() at OptionInfoMapper.php:52
#9 MysqlAdapter->executeQuery() at Adapter.php:1645
#10 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
select * from StreamLog where
eventId = 130
and Provider_id = 2
and web = 1
and subProviderId IS NULL
and sessIdNum = 4202930897
and `date` >= "2025-04-22"
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 ProductController->show() at ActionRunner.php:352
#7 AppController->saveSessionStreamLog() at ProductController.php:1686
#8 StreamLogComponent->saveSessionStreamLog() at AppController.php:811
#9 StreamLogMapper->findOldBy() at StreamLogComponent.php:59
#10 Adapter->findAllByQuery() at StreamLogMapper.php:387
#11 MysqlAdapter->executeQuery() at Adapter.php:1550
#12 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | queryName | backtrace |
|---|
SELECT * FROM `StreamLog` LIMIT 1 |
1 |
getColumnNamesForTable |
#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 ProductController->show() at ActionRunner.php:352
#7 AppController->saveSessionStreamLog() at ProductController.php:1686
#8 StreamLogComponent->saveSessionStreamLog() at AppController.php:811
#9 Mapper->save() at StreamLogComponent.php:78
#10 Adapter->save() at Mapper.php:579
#11 Adapter->insert() at Adapter.php:1283
#12 Adapter->executeQueryBuilder() at Adapter.php:1305
#13 MysqlQueryCompiler->compile() at Adapter.php:1351
#14 MysqlQueryCompiler->compileInsert() at MysqlQueryCompiler.php:82
#15 MysqlQueryCompiler->getColumnNamesForTable() at MysqlQueryCompiler.php:572
#16 MysqlAdapter->getColumnNamesForTable() at MysqlQueryCompiler.php:768
#17 MysqlAdapter->executeQuery() at MysqlAdapter.php:306
#18 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | backtrace |
|---|
INSERT INTO `StreamLog`(`Provider_id`, `eventId`, `Order_id`, `dateTime`, `amount`, `subProviderId`, `web`, `sessIdNum`, `yearAndWeek`, `year`, `month`, `date`, `hour`) VALUES ("2", 130, NULL, "2025-04-29 21:52:42", 1, NULL, 1, 4202930897, 202518, 2025, 4, "2025-04-29", 21) |
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 ProductController->show() at ActionRunner.php:352
#7 AppController->saveSessionStreamLog() at ProductController.php:1686
#8 StreamLogComponent->saveSessionStreamLog() at AppController.php:811
#9 Mapper->save() at StreamLogComponent.php:78
#10 Adapter->save() at Mapper.php:579
#11 Adapter->insert() at Adapter.php:1283
#12 Adapter->executeQueryBuilder() at Adapter.php:1305
#13 MysqlAdapter->executeQuery() at Adapter.php:1355
#14 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
info |
| sql | success | queryName | backtrace |
|---|
SELECT * FROM `Usage` where Provider_id = 2 OR Provider_id is null ORDER BY Provider_id ASC; |
1 |
Usages_cached |
#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 View->__toString() at ActionRunner.php:369
#7 SmartyRenderer->render() at View.php:171
#8 Smarty_Internal_TemplateBase->display() at SmartyRenderer.php:64
#9 Smarty_Internal_TemplateBase->_execute() at smarty_internal_templatebase.php:134
#10 Smarty_Internal_Template->render() at smarty_internal_templatebase.php:232
#11 Smarty_Template_Compiled->render() at smarty_internal_template.php:216
#12 Smarty_Template_Resource_Base->getRenderedTemplateCode() at smarty_template_compiled.php:114
#13 content_66388abde17e82_12295681() at smarty_template_resource_base.php:123
#14 Smarty_Internal_Template->_subTemplateRender() at 560a0d0ddebe6412f2a2d2dd752552cd235cdd48_0.file.Product_show.tpl.php:1612
#15 Smarty_Internal_Template->render() at smarty_internal_template.php:385
#16 Smarty_Template_Compiled->render() at smarty_internal_template.php:216
#17 Smarty_Template_Resource_Base->getRenderedTemplateCode() at smarty_template_compiled.php:114
#18 content_6638989258d176_93157698() at smarty_template_resource_base.php:123
#19 ProductDomainModel->foundOuterPartDetailIdText_door() at 2b47bad3297c9912a35003915535667a59d6ab2a_0.file.doorEquipment.tpl.php:395
#20 UsageMapper->usageLocalizedWithExceptions() at ProductDomainModel.php:107
#21 UsageMapper->usageLocalized() at UsageMapper.php:112
#22 UsageMapper->usages() at UsageMapper.php:122
#23 UsageMapper->Usages_cached() at UsageMapper.php:197
#24 Adapter->findAllByQuery() at UsageMapper.php:170
#25 MysqlAdapter->executeQuery() at Adapter.php:1550
#26 MysqlAdapter->addExecutedQueryToLog() at MysqlAdapter.php:74
|
|
suomeksi
