1.49 ms |
SELECT w.id AS websiteId, w.name AS websiteName, w.link, w.logo, w.favicon, w.contact, w.email, w.description, w.streetAddress, w.addressLocality, w.addressRegion, w.postalCode, w.addressCountry, w.latitude, w.longitude, w.map, w.googleAnalyticId, w.googleTagManagerId, w.googleWebMasterId,w.eCommerce, w.pxPayKey, w.pxPayUserId, w.stripePubKey, w.stripeSecretKey, t.name AS themeName, t.id AS themeId FROM `websites` AS w join `themes` AS t on t.id = w.themeId WHERE w.link = 'https://www.elegancedecor.co.nz' |
APPPATH/Controllers/BaseController.php:171 |
|
1 APPPATH/Controllers/BaseController.php:171
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:93
App\Controllers\BaseController->getTheme()
3 SYSTEMPATH/CodeIgniter.php:859
App\Controllers\BaseController->initController()
4 SYSTEMPATH/CodeIgniter.php:457
CodeIgniter\CodeIgniter->createController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.41 ms |
SELECT w.id AS websiteId, w.name AS websiteName, w.link, w.logo, w.favicon, w.contact, w.email, w.description, w.streetAddress, w.addressLocality, w.addressRegion, w.postalCode, w.addressCountry, w.latitude, w.longitude, w.map, w.googleAnalyticId, w.googleTagManagerId, w.googleWebMasterId,w.eCommerce, w.pxPayKey, w.pxPayUserId, w.stripePubKey, w.stripeSecretKey, t.name AS themeName, t.id AS themeId FROM `websites` AS w join `themes` AS t on t.id = w.themeId WHERE w.link = 'https://www.elegancedecor.co.nz' |
APPPATH/Controllers/BaseController.php:171 |
|
1 APPPATH/Controllers/BaseController.php:171
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:114
App\Controllers\BaseController->getTheme()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.29 ms |
SELECT w.id AS websiteId, w.name AS websiteName, w.link, w.logo, w.favicon, w.contact, w.email, w.description, w.streetAddress, w.addressLocality, w.addressRegion, w.postalCode, w.addressCountry, w.latitude, w.longitude, w.map, w.googleAnalyticId, w.googleTagManagerId, w.googleWebMasterId,w.eCommerce, w.pxPayKey, w.pxPayUserId, w.stripePubKey, w.stripeSecretKey, t.name AS themeName, t.id AS themeId FROM `websites` AS w join `themes` AS t on t.id = w.themeId WHERE w.link = 'https://www.elegancedecor.co.nz' |
APPPATH/Controllers/BaseController.php:171 |
|
1 APPPATH/Controllers/BaseController.php:171
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:360
App\Controllers\BaseController->getTheme()
3 APPPATH/Controllers/Home.php:122
App\Controllers\BaseController->menu()
4 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
5 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
7 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.34 ms |
SELECT w.id AS websiteId, w.name AS websiteName, w.link, w.logo, w.favicon, w.contact, w.email, w.description, w.streetAddress, w.addressLocality, w.addressRegion, w.postalCode, w.addressCountry, w.latitude, w.longitude, w.map, w.googleAnalyticId, w.googleTagManagerId, w.googleWebMasterId,w.eCommerce, w.pxPayKey, w.pxPayUserId, w.stripePubKey, w.stripeSecretKey, t.name AS themeName, t.id AS themeId FROM `websites` AS w join `themes` AS t on t.id = w.themeId WHERE w.link = 'https://www.elegancedecor.co.nz' |
APPPATH/Controllers/BaseController.php:171 |
|
1 APPPATH/Controllers/BaseController.php:171
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:382
App\Controllers\BaseController->getTheme()
3 APPPATH/Controllers/Home.php:123
App\Controllers\BaseController->footer_menu()
4 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
5 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
7 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.31 ms |
SELECT *
FROM `page`
WHERE `slugName` = 'sofa'
AND `status` = 0
AND `websiteId` = '42'
LIMIT 1 |
APPPATH/Controllers/Home.php:163 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1585
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:249
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:622
CodeIgniter\Model->doFirst()
4 APPPATH/Controllers/Home.php:163
CodeIgniter\BaseModel->first()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.12 ms |
SELECT *
FROM `page_private`
WHERE `pageId` = '12256'
LIMIT 1 |
APPPATH/Controllers/Home.php:172 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1585
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:249
CodeIgniter\Database\BaseBuilder->get()
3 SYSTEMPATH/BaseModel.php:622
CodeIgniter\Model->doFirst()
4 APPPATH/Controllers/Home.php:172
CodeIgniter\BaseModel->first()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.92 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12256', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:192
App\Controllers\BaseController->getParent()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.37 ms |
SELECT tl.file_name, tl.name, p.id FROM `themes_layout` AS tl LEFT JOIN `page` AS p ON p.themeLayoutId = tl.id WHERE tl.themeId = '25' AND p.status = 0 AND p.slugName LIKE 'sofa' |
APPPATH/Controllers/Home.php:202 |
|
1 APPPATH/Controllers/Home.php:202
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
3 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
5 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.24 ms |
SELECT w.id AS websiteId, w.name AS websiteName, w.link, w.logo, w.favicon, w.contact, w.email, w.description, w.streetAddress, w.addressLocality, w.addressRegion, w.postalCode, w.addressCountry, w.latitude, w.longitude, w.map, w.googleAnalyticId, w.googleTagManagerId, w.googleWebMasterId,w.eCommerce, w.pxPayKey, w.pxPayUserId, w.stripePubKey, w.stripeSecretKey, t.name AS themeName, t.id AS themeId FROM `websites` AS w join `themes` AS t on t.id = w.themeId WHERE w.link = 'https://www.elegancedecor.co.nz' |
APPPATH/Controllers/BaseController.php:171 |
|
1 APPPATH/Controllers/BaseController.php:171
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:217
App\Controllers\BaseController->getTheme()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.36 ms |
SELECT tl.file_name, tl.name, p.id FROM `themes_layout` AS tl LEFT JOIN `page` AS p ON p.themeLayoutId = tl.id WHERE tl.themeId = '25' AND p.status = 0 AND p.websiteId = '42' AND p.slugName LIKE 'sofa' |
APPPATH/Controllers/Home.php:228 |
|
1 APPPATH/Controllers/Home.php:228
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
3 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
4 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
5 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.17 ms |
SELECT p.id AS pageLiveId, p.name AS pageName,p.pageSubHeading AS pageSubHeading, p.slugName, p.description, p.metaTitle, p.metaDesc, p.metaKeywords, p.h1, p.h2, p.footer, p.pageTypeId, fl.imgName , f.name AS folderName, w.stripePubKey FROM `page` AS p left join `files` AS fl on fl.id = p.fileId left join `folder` AS f on f.id = fl.folderId join `websites` AS w ON p.websiteId = w.id where p.id = '12256' |
APPPATH/Controllers/BaseController.php:424 |
|
1 APPPATH/Controllers/BaseController.php:424
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:241
App\Controllers\BaseController->getPage()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.8 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12256', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:243
App\Controllers\BaseController->getParent()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.84 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12255', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:414
App\Controllers\BaseController->getParent()
3 APPPATH/Controllers/Home.php:246
App\Controllers\BaseController->getUrl()
4 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
5 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
7 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.73 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12256', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:414
App\Controllers\BaseController->getParent()
3 APPPATH/Controllers/Home.php:246
App\Controllers\BaseController->getUrl()
4 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
5 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
6 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
7 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
2.86 ms |
SELECT ep.id as productId,ep.slug_name,ep.name,ep.description,ep.price,ep.weight,ep.partNumber,
ep.discount,ep.subName as subHeading, ep.featured,ep.inStock, ep.stockQty, ecp.categoryId
FROM `ecommerce_product` AS ep
LEFT JOIN `ecommerce_category_product` AS ecp ON ecp.productId = ep.id
WHERE ecp.categoryId = '12256' ORDER BY ecp.priority |
APPPATH/Controllers/BaseController.php:592 |
|
1 APPPATH/Controllers/BaseController.php:592
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:268
App\Controllers\BaseController->getECommerceProductCategoryBased()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
2.51 ms |
SELECT epi.productImage, epi.featured
from `ecommerce_product_image` as epi WHERE epi.eCommerceProductId = '1982' |
APPPATH/Controllers/BaseController.php:596 |
|
1 APPPATH/Controllers/BaseController.php:596
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:268
App\Controllers\BaseController->getECommerceProductCategoryBased()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
2.36 ms |
SELECT epi.productImage, epi.featured
from `ecommerce_product_image` as epi WHERE epi.eCommerceProductId = '1983' |
APPPATH/Controllers/BaseController.php:596 |
|
1 APPPATH/Controllers/BaseController.php:596
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:268
App\Controllers\BaseController->getECommerceProductCategoryBased()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.47 ms |
SELECT DISTINCT p.id as pageLiveId, p.name,p.slugName, fl.imgName as categoryImage
from `page` as p
LEFT JOIN `files` as fl ON fl.id = p.fileId
WHERE p.websiteId = '42' and p.status = 0 and p.parentId='12256' |
APPPATH/Controllers/BaseController.php:701 |
|
1 APPPATH/Controllers/BaseController.php:701
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:269
App\Controllers\BaseController->getAllProductsCategory()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
2.35 ms |
SELECT COUNT(*) AS `numrows`
FROM `ecommerce_category_product`
WHERE `categoryId` = '12257' |
APPPATH/Controllers/BaseController.php:704 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1669
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:550
CodeIgniter\Database\BaseBuilder->countAllResults()
3 APPPATH/Controllers/BaseController.php:704
CodeIgniter\Model->countAllResults()
4 APPPATH/Controllers/Home.php:269
App\Controllers\BaseController->getAllProductsCategory()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.93 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12257', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:414
App\Controllers\BaseController->getParent()
3 APPPATH/Controllers/BaseController.php:705
App\Controllers\BaseController->getUrl()
4 APPPATH/Controllers/Home.php:269
App\Controllers\BaseController->getAllProductsCategory()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
2.37 ms |
SELECT COUNT(*) AS `numrows`
FROM `ecommerce_category_product`
WHERE `categoryId` = '12258' |
APPPATH/Controllers/BaseController.php:704 |
|
1 SYSTEMPATH/Database/BaseBuilder.php:1669
CodeIgniter\Database\BaseConnection->query()
2 SYSTEMPATH/Model.php:550
CodeIgniter\Database\BaseBuilder->countAllResults()
3 APPPATH/Controllers/BaseController.php:704
CodeIgniter\Model->countAllResults()
4 APPPATH/Controllers/Home.php:269
App\Controllers\BaseController->getAllProductsCategory()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
1.9 ms |
SELECT T2.id, T2.name AS pageName, T2.slugName, T3.pageId as isHome FROM ( SELECT @r AS _id, (SELECT @r := parentId FROM page WHERE id = _id) AS parentId, @l := @l + 1 AS lvl FROM (SELECT @r := '12258', @l := 0) vars, page m WHERE @r <> 0) T1 JOIN page T2 ON T1._id = T2.id LEFT JOIN page_home AS T3 ON T3.pageId = T2.id ORDER BY T1.lvl DESC |
APPPATH/Controllers/BaseController.php:407 |
|
1 APPPATH/Controllers/BaseController.php:407
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/BaseController.php:414
App\Controllers\BaseController->getParent()
3 APPPATH/Controllers/BaseController.php:705
App\Controllers\BaseController->getUrl()
4 APPPATH/Controllers/Home.php:269
App\Controllers\BaseController->getAllProductsCategory()
5 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
6 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
7 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
8 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|
3.67 ms |
SELECT s.id, s.content, s.backgroundColor, s.heading, s.subHeading, psp.priority, s.sectionTypeId, psp.pageId, s.altImg,
cs.heading AS csHeading, cs.subHeading AS csSubHeading, cs.linkType AS csLinkType, cs.linkLabel AS csLinkLabel,
cs.internalPageLiveId AS csInternalPageLiveId, cs.externalLink AS csExternalLink, cs.priority AS csPriority, cs.description AS csDescription,
cs.altImg AS csAltImg, fl1.imgName As csImage, f1.name AS csFolder
-- ,ep.name as csProductName,ep.id as csProductId,ec.name as csCategoryName , ec.id as csCategoryId
FROM `page_section` AS s
JOIN `page_section_page` AS psp ON psp.pageSectionId =s.id
LEFT JOIN `column_slider_section` AS cs ON cs.sectionId = s.id
-- LEFT JOIN `page` as ec ON ec.id = cs.eCommerceCategoryId
-- LEFT JOIN `ecommerce_product` as ep ON ep.id = cs.eCommerceProductId
LEFT JOIN `files` AS fl1 ON fl1.id = cs.fileId
LEFT JOIN `folder` AS f1 ON f1.id = fl1.folderId
WHERE s.id = (select min(ps1.id) from page_section ps1 join page_section_page psp1 ON psp1.pageSectionId = ps1.id where psp1.pageId = '12256' AND (ps1.sectionTypeId = 3 OR ps1.sectionTypeId = 6)) AND
psp.pageId = '12256' ORDER BY psp.priority ASC |
APPPATH/Controllers/BaseController.php:497 |
|
1 APPPATH/Controllers/BaseController.php:497
CodeIgniter\Database\BaseConnection->query()
2 APPPATH/Controllers/Home.php:298
App\Controllers\BaseController->getBanner()
3 SYSTEMPATH/CodeIgniter.php:896
App\Controllers\Home->inside()
4 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter->runController()
5 SYSTEMPATH/CodeIgniter.php:349
CodeIgniter\CodeIgniter->handleRequest()
6 FCPATH/index.php:55
CodeIgniter\CodeIgniter->run()
|