1.
SELECT set_value, constant_name
FROM configuration_master
WHERE constant_name
IN ('CORPORATE_MODUEL_ENABLE', 'COUNTRY_BASED_IP_SETTING')
0.0007 sec(Cached)23c4c596bd6ed98c168f1756c4bd368d
↳cms.php : 16 -> require_once
↳lib/common.php : 81 -> ConfigurationMaster::getConfiguration
↳model/ConfigurationMaster.php : 111 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
2. SELECT corporate_user.*, (SELECT pcu.corporate_settings FROM corporate_user pcu WHERE pcu.corporate_id = corporate_user.parent_corporate_id) AS parent_corporate_settings FROM corporate_user WHERE (corporate_user.directory_name = 'butterflygp' OR corporate_user.main_url IN ('butterflygp.com', 'www.butterflygp.com')) ORDER BY corporate_user.corporate_type ASC 0.0016 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 185 -> RAccess\StoreAccess::__construct
↳lib/RAccess/StoreAccess.php : 45 -> RAccess\StoreAccess::getDomain
↳lib/RAccess/StoreAccess.php : 471 -> RAccess\StoreAccess::getStore
↳lib/RAccess/StoreAccess.php : 347 -> CorporateUserMaster::getCorporateUser
↳model/CorporateUserMaster.php : 86 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
3. SELECT SQL_CALC_FOUND_ROWS theme_dir_name FROM site_theme WHERE site_theme_id = 3 0.0013 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 49 -> SiteThemeMaster::getSiteTheme
↳model/SiteThemeMaster.php : 78 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
4.
SELECT corporate_user.corporate_id, corporate_user.parent_corporate_id, pcu.corporate_name
AS parent_corporate_name, pcu.corporate_type
AS parent_corporate_type, corporate_user.inactive_external_services
AS parent_inactive_services, corporate_user.url_type, corporate_user.main_url, pcu.directory_name
AS parent_directory_name, pcu.main_url
AS parent_main_url, pcu.url_type
AS parent_url_type, pcu.inactive_external_services
AS parent_inactive_services, pcu.corporate_settings
AS parent_corporate_settings
FROM corporate_user
LEFT JOIN corporate_user pcu
ON corporate_user.parent_corporate_id = pcu.corporate_id
WHERE corporate_user.corporate_id = 9
0.0001 sec(Cached)49dba641a0d8941b382601c14c75ff32
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 192 -> RAccess\StoreAccess::getParentStoreDetails
↳lib/RAccess/StoreAccess.php : 1493 -> CorporateUserMaster::getCorporateUser
↳model/CorporateUserMaster.php : 86 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
5.
SELECT section_id, status
FROM admin_section
WHERE section_id
IN (
SELECT section_id
FROM admin_section_description
where site_language_id = '1'
AND LOWER(section_heading) = LOWER('Templates'))
0.0001 sec(Cached)92dd46f86c59b1ac5575508e01c5a6de
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 346 -> AdminSectionMaster::getAdminSectionDetail
↳model/AdminSectionMaster.php : 109 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
6. SELECT IF(corporate_configuration_setting.configuration_id > 0,corporate_configuration_setting.set_value,configuration_master.set_value) as set_value,configuration_master.default_value,configuration_master.setting_type,configuration_master.constant_name, configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type,corporate_configuration_setting.corporate_id,corporate_configuration_setting.set_value AS corporate_set_value FROM configuration_master LEFT JOIN corporate_configuration_setting ON (corporate_configuration_setting.configuration_id = configuration_master.configuration_id AND corporate_configuration_setting.corporate_id IN(9, 0) AND (configuration_master.available_for_corporate LIKE '%3Y%' OR configuration_master.available_for_corporate LIKE '%3N%' OR configuration_master.available_for_corporate = '-1')) WHERE (configuration_master.available_for_corporate LIKE '%3%' OR configuration_master.available_for_corporate = '-1') ORDER BY FIELD(corporate_id, 9, 0, 0), configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.002 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 456 -> ConfigurationMaster::getConfiguration
↳model/ConfigurationMaster.php : 111 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
7.
SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration
FROM site_theme
WHERE theme_dir_name = 'butterflygp'
0.0001 sec(Cached)0fd7253fad6cca03b348127d5144b068
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 572 -> SiteThemeMaster::getSiteTheme
↳model/SiteThemeMaster.php : 78 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
8.
SELECT payment_method_id, directory
FROM payment_method
WHERE directory
IN ('payon_account', 'partial_payment')
ORDER BY sort_order
ASC 0.0001 sec(Cached)e4e2b78166a96840443ba3ecc630401c
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 636 -> PaymentMethodMaster::getPaymentMethod
↳model/PaymentMethodMaster.php : 63 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
9.
SELECT external_services.*,external_service_section.section_name, external_services.directory,external_services.section_id, IF(es.service_id IS NOT NULL, es.service_id, IF(esp.service_id IS NOT NULL, esp.service_id, external_services.service_id))
AS service_id, IF(es.service_name IS NOT NULL, es.service_name, IF(esp.service_name IS NOT NULL, esp.service_name, external_services.service_name))
AS service_name, IF(es.service_details IS NOT NULL, es.service_details, IF(esp.service_details IS NOT NULL, esp.service_details, external_services.service_details))
AS service_details, IF(es.status IS NOT NULL, es.status, IF(esp.status IS NOT NULL, esp.status, external_services.status))
AS status, IF(es.corporate_id IS NOT NULL, es.corporate_id, IF(esp.corporate_id IS NOT NULL, esp.corporate_id, external_services.corporate_id))
AS corporate_id
FROM external_services
LEFT JOIN external_service_section
ON external_services.section_id = external_service_section.section_id
LEFT JOIN external_services es
ON external_services.directory = es.directory
AND es.corporate_id = 9
LEFT JOIN external_services esp
ON external_services.directory = esp.directory
AND esp.corporate_id = (
SELECT parent_corporate_id
FROM corporate_user
WHERE corporate_user.corporate_id = 9)
WHERE external_services.corporate_id = 0
0.0001 sec(Cached)86a90ab0ab8292939489aae18c92805c
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 714 -> ExternalServiceMaster::getExternalService
↳model/ExternalServiceMaster.php : 70 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
10. SELECT * FROM countries 0.0013 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 806 -> SmsManager::__construct
↳lib/sms.php : 19 -> CountryMaster::getCountry
↳model/CountryMaster.php : 82 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
11.
SELECT website_logos.*
FROM website_logos
WHERE website_logos.corporate_id
IN ('9', '0')
ORDER BY FIELD(corporate_id, 9, 0, 0)
0.0001 sec(Cached)c29450b76ae53a799b0dc212089ac3df
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 893 -> getWebSiteLogos
↳lib/functions.php : 4986 -> WebSiteLogoMaster::getWebSiteLogo
↳model/WebSiteLogoMaster.php : 87 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
12.
SELECT *
FROM site_language
0.0001 sec(Cached)d006a14cdb095c4bf9083702065fe3f4
↳cms.php : 16 -> require_once
↳lib/common.php : 187 -> require_once
↳lib/siteconstants.php : 906 -> SiteLanguageMaster::getSiteLanguage
↳model/SiteLanguageMaster.php : 48 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
13. SELECT * FROM url_redirection_manage WHERE (old_url = 'https://www.butterflygp.com/ca/en/career-opportunity.html' OR old_url = 'https://www.butterflygp.com/ca/en/career-opportunity.html' OR old_url = 'https://www.butterflygp.com/ca/en/career-opportunity.html') ORDER BY url_redirection_id ASC 0.0013 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 224 -> UrlRedirectionManageMaster::getUrlRedirectionManage
↳model/UrlRedirectionManageMaster.php : 79 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
14. SET time_zone = '-04:00' 0.0013 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 302 -> set_timezone
↳lib/functions.php : 1816 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
15. SELECT product_category.category_id, IF (corporate_product_category_description.category_url IS NOT NULL AND corporate_product_category_description.category_url != '', corporate_product_category_description.category_url, product_category_description.category_url) AS caturl, IF (corporate_product_category_description.description IS NOT NULL AND corporate_product_category_description.description != '', corporate_product_category_description.description, product_category_description.description) AS description,product_category_description.site_language_id FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id LEFT JOIN corporate_product_category_description ON product_category_description.category_id = corporate_product_category_description.category_id AND corporate_product_category_description.site_language_id = product_category_description.site_language_id AND corporate_product_category_description.corporate_id = 9 LEFT JOIN corporate_product_category ON product_category.category_id = corporate_product_category.category_id AND corporate_product_category.corporate_id = 9 WHERE IF (corporate_product_category.status IS NOT NULL AND corporate_product_category.status != '', corporate_product_category.status, product_category.status) = '1' AND product_category.corporate_id = 9 0.0014 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 420 -> require_once
↳lib/seo.php : 405 -> ProductCategoryMaster::get_product_category_details_header_search
↳model/ProductCategoryMaster.php : 284 -> ProductCategoryMaster::exec_query
↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
16.
SELECT products.products_id, IF (corporate_products_description.product_url IS NOT NULL
AND corporate_products_description.product_url != '', corporate_products_description.product_url, products_description.product_url)
AS producturl, IF (corporate_products_description.products_title IS NOT NULL
AND corporate_products_description.products_title != '', corporate_products_description.products_title, products_description.products_title)
AS productname, products_description.site_language_id
FROM products
LEFT JOIN products_description
on products_description.products_id = products.products_id
LEFT JOIN corporate_products_description
ON products_description.products_id = corporate_products_description.products_id
AND corporate_products_description.site_language_id = products_description.site_language_id
AND corporate_products_description.corporate_id = 9
0.0009 sec(Cached)a16fd9df839136a7d53fc21896f31957
↳cms.php : 16 -> require_once
↳lib/common.php : 420 -> require_once
↳lib/seo.php : 420 -> ProductsMaster::getProducts
↳model/ProductsMaster.php : 175 -> ProductsMaster::exec_query
↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
17. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages.type, cms_pages_description.page_id, cms_pages_description.page_url, cms_pages_description.site_language_id, cms_pages.corporate_id, cms_pages.category_id, cms_pages_description.page_heading, cms_pages_description.image_name, cms_pages_description.short_description, cms_pages.blog_page, cms_pages.sort_order, cms_pages.status, cms_pages_description.site_language_id, cms_pages.blog_page, category_cms_pages.page_name AS category_page_name, category_cms_pages_description.page_url AS category_page_url, category_cms_pages_description.page_heading AS category_page_heading FROM cms_pages LEFT JOIN cms_pages AS category_cms_pages ON category_cms_pages.page_id = cms_pages.category_id AND category_cms_pages.status = '1' LEFT JOIN cms_pages_description AS category_cms_pages_description ON category_cms_pages_description.page_id = category_cms_pages.page_id AND category_cms_pages_description.site_language_id = 1 LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.type != 'I' AND cms_pages.corporate_id IN ('9', '0') ORDER BY FIELD(cms_pages.corporate_id, 9, 0, 0) DESC, cms_pages.sort_order, cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0017 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 420 -> require_once
↳lib/seo.php : 478 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
18. SELECT IF(corporates_seo_description.seo_page_title != '', corporates_seo_description.seo_page_title, IF(PS.seo_page_title != '', PS.seo_page_title, site_seo_description.seo_page_title)) AS seo_page_title, IF(corporates_seo_description.seo_page_description != '', corporates_seo_description.seo_page_description, IF(PS.seo_page_description != '', PS.seo_page_description, site_seo_description.seo_page_description)) AS seo_page_description, IF(corporates_seo_description.corporate_id != '', corporates_seo_description.corporate_id, PS.corporate_id), site_seo.page_name FROM site_seo LEFT JOIN corporates_seo_description ON corporates_seo_description.seo_page_id = site_seo.page_id AND corporates_seo_description.corporate_id = "9" AND corporates_seo_description.section_type = "others" AND corporates_seo_description.site_language_id = "1" LEFT JOIN corporates_seo_description AS PS ON PS.seo_page_id = site_seo.page_id AND PS.corporate_id = "0" AND PS.section_type = "others" AND PS.site_language_id = "1" LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE IF(site_seo_description.site_language_id IS NOT NULL, site_seo_description.site_language_id = 1, 1) AND (site_seo.page_name = 'cms.php' OR site_seo.page_name = 'cms' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc 0.0028 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 421 -> require_once
↳lib/metatag.php : 53 -> seoPageMaster::getSeoPageDetails
↳model/seoPageMaster.php : 148 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
19. SELECT SQL_CALC_FOUND_ROWS IF(corporates_seo_description.seo_page_title != '', corporates_seo_description.seo_page_title, IF(PS.seo_page_title != '', PS.seo_page_title, cms_pages_description.seo_page_title)) AS seo_page_title, IF(corporates_seo_description.seo_page_description != '', corporates_seo_description.seo_page_description, IF(PS.seo_page_description != '', PS.seo_page_description, cms_pages_description.seo_page_description)) AS seo_page_description, cms_pages_description.page_heading, cms_pages_description.canonical_id, (IF(cms_pages_description.canonical_id > 0 , (select page_name from cms_pages where page_id = cms_pages_description.canonical_id), '')) AS canonical_page, cms_pages_description.image_name, cms_pages_description.custom_canonical FROM cms_pages LEFT JOIN corporates_seo_description ON corporates_seo_description.seo_page_id = cms_pages.page_id AND corporates_seo_description.corporate_id = "9" AND corporates_seo_description.section_type = "content" AND corporates_seo_description.site_language_id = "1" LEFT JOIN corporates_seo_description AS PS ON PS.seo_page_id = cms_pages.page_id AND PS.corporate_id = "0" AND PS.section_type = "content" AND PS.site_language_id = "1" LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND IF(cms_pages_description.page_url = 'career-opportunity', (cms_pages_description.page_url = 'career-opportunity' OR cms_pages_description.page_url = 'career opportunity'), (cms_pages.page_name = 'career-opportunity' OR cms_pages.page_name = 'career opportunity')) AND cms_pages.status = '1' AND cms_pages.corporate_id IN ('9', '0') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0017 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 421 -> require_once
↳lib/metatag.php : 126 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
20. SELECT corporate_name FROM corporate_user WHERE corporate_user.corporate_id = 9 0.0013 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 421 -> require_once
↳lib/metatag.php : 735 -> CorporateUserMaster::getCorporateUser
↳model/CorporateUserMaster.php : 86 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
21.
SELECT site_general_metatag.name, site_general_metatag.content, site_general_metatag.type, Concat(site_general_metatag.page_id, IF(site_general_metatag.corporate_id = 9, 2, IF(site_general_metatag.corporate_id != 0
AND site_general_metatag.corporate_id = 0, 1, 0)))
AS corporateid
FROM site_general_metatag
LEFT JOIN site_front_pages
on site_front_pages.front_pages_id = site_general_metatag.page_id
AND site_front_pages.seo_status = '1'
WHERE site_general_metatag.corporate_id
IN ('9', '0')
AND ((site_front_pages.front_pages_name = 'cms.php'
OR site_front_pages.front_pages_name = 'cms')
OR (site_general_metatag.page_id = 0))
GROUP BY name, corporateid
ORDER BY corporateid DESC, site_front_pages.front_pages_id
DESC 0.0001 sec(Cached)93f466a0ae8b55c51a18892c9c9e1e5d
↳cms.php : 16 -> require_once
↳lib/common.php : 421 -> require_once
↳lib/metatag.php : 921 -> SiteGeneralMetatagMaster::getMetatagDetails
↳model/SiteGeneralMetatagMaster.php : 106 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
22. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'cms' 0.0014 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 428 -> SiteFrontPagesMaster::getSiteFrontPages
↳model/SiteFrontPagesMaster.php : 77 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
23. SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants.constant_id, CONCAT(site_constants.constant_id, IF(site_constants_description.corporate_id = 9, 1, IF(site_constants_description.corporate_id != 0 AND site_constants_description.corporate_id = 0, 2, 0))) AS corporateid, site_constants_description.corporate_id FROM site_constants LEFT JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 LEFT JOIN site_front_page_group ON site_constants.front_group_id = site_front_page_group.front_group_id WHERE 1 AND site_constants.front_group_id IN ('1', '5') AND site_constants.available_to IN ('0', '-2') AND (site_constants_description.corporate_id IN ('9', '0') OR site_constants_description.corporate_id IS NULL ) GROUP BY corporateid, site_constants_description.constant_id ORDER BY FIELD(corporate_id, 9, 0, 0) 0.0031 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 450 -> SiteConstantMaster::getSiteConstantDetailsCustomQuery
↳model/SiteConstantMaster.php : 212 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
24. SELECT * FROM (SELECT menu_link.*, menu_link_description.menu_title,menu_link_description.menu_image,menu_link_description.site_language_id FROM menu_link LEFT JOIN menu_link_description ON menu_link_description.menu_id = menu_link.menu_id WHERE menu_link_description.site_language_id = 1 AND (link_display = '2' OR link_display = '0') AND (corporate_id = 9 OR menu_link_category = '8') AND status = '1' ORDER BY corporate_id DESC LIMIT 18446744073709551615) AS temp_table GROUP BY menu_title,menu_position ORDER BY sort_order ASC, menu_id ASC 0.0015 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 472 -> all_menu_data
↳lib/dbfunctions.php : 2845 -> MenuLinkMaster::getMenuLinkDescriptionWithCorporate
↳model/MenuLinkMaster.php : 257 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
25. SELECT * FROM side_menu_link WHERE function_name = 'getCMSCategory' 0.0014 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 524 -> require_once
↳lib/twig.php : 97 -> get_sidebox_details
↳lib/dbfunctions.php : 722 -> SideMenuLinkMaster::getSideMenuLink
↳model/SideMenuLinkMaster.php : 77 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
26.
SELECT *
FROM sidebar_management
WHERE section_pages LIKE '%||%'
AND corporate_id = IF(9 IN(
SELECT DISTINCT corporate_id
FROM sidebar_management ), 9, 0)
OR (`section_name` = 'Default'
AND corporate_id = IF(9 IN(
SELECT DISTINCT corporate_id
FROM sidebar_management ),9,0))
ORDER BY sidebar_id
DESC LIMIT 1
OFFSET 0
0.0001 sec(Cached)5fbd46f0ba9ac24369e08f4e15854732
↳cms.php : 16 -> require_once
↳lib/common.php : 524 -> require_once
↳lib/twig.php : 97 -> get_sidebox_details
↳lib/dbfunctions.php : 743 -> SidebarManagementMaster::getSidebarManagement
↳model/SidebarManagementMaster.php : 82 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
27. SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND side_menu_link.status = '1' AND menu_display IN ('0', '1') AND side_menu_id NOT IN ( SELECT `master_side_menu_id` FROM side_menu_link WHERE corporate_id = 9 AND status = '0') AND side_menu_id NOT IN ( SELECT `master_side_menu_id` FROM side_menu_link WHERE corporate_id = 9 AND menu_display='3') AND side_menu_link.corporate_id = 9 ORDER BY corporate_id DESC LIMIT 18446744073709551615 ) AS temp_table GROUP BY menu_title HAVING status = '1' ORDER BY sortorder ASC 0.0015 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 524 -> require_once
↳lib/twig.php : 97 -> get_sidebox_details
↳lib/dbfunctions.php : 779 -> SideMenuLinkMaster::getSideMenuLinkDescriptionWithCorporate
↳model/SideMenuLinkMaster.php : 132 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
28. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name IN ('cms_header', 'cms_middle_footer', 'cms_footer', 'contact_us_box', 'sidebar_content_left', 'sidebar_content_right', 'related_product_section_help', 'cms_social_media_links', 'cms_header_content', 'product_info_dispatch_countdown', 'cms_user_registration_success', 'cms_contact_detail') AND cms_pages.status = '1' AND cms_pages.corporate_id = 9 ORDER BY FIELD(cms_pages.corporate_id, 0, 0, 9), cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0015 sec
↳cms.php : 16 -> require_once
↳lib/common.php : 524 -> require_once
↳lib/twig.php : 204 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
29.
SELECT SQL_CALC_FOUND_ROWS *
FROM banner_image_setting
0.0001 sec(Cached)3032d2886e227e87f9c8146b7a2b4507
↳cms.php : 16 -> require_once
↳lib/common.php : 524 -> require_once
↳lib/twig.php : 327 -> BannerImageMaster::getBannerImageSetting
↳model/BannerImageMaster.php : 116 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
*******************************COMMON END*********************************
31. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content, cms_pages_description.page_url, category_cms_pages.page_name AS category_page_name, category_cms_pages_description.page_url AS category_page_url, cms_pages_description.short_description, IF(category_cms_pages_description.page_heading != '', category_cms_pages_description.page_heading, category_cms_pages_description.page_url) AS category_page_heading FROM cms_pages LEFT JOIN cms_pages AS category_cms_pages ON category_cms_pages.page_id = cms_pages.category_id AND category_cms_pages.status = '1' LEFT JOIN cms_pages_description AS category_cms_pages_description ON category_cms_pages_description.page_id = category_cms_pages.page_id AND category_cms_pages_description.site_language_id = 1 LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND IF(cms_pages_description.page_url = 'career-opportunity', (cms_pages_description.page_url = 'career-opportunity' OR cms_pages_description.page_url = 'career opportunity'), (cms_pages.page_name = 'career-opportunity' OR cms_pages.page_name = 'career opportunity')) AND cms_pages.corporate_id = 9 AND cms_pages.status = '1' GROUP BY cms_pages.page_id ORDER BY FIELD(cms_pages.corporate_id, 9, 0, 0), cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0016 sec
↳cms.php : 97 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
32 11
.
SELECT website_logos.*
FROM website_logos
WHERE website_logos.corporate_id
IN ('9', '0')
ORDER BY FIELD(corporate_id, 9, 0, 0)
0 sec(Cached)c29450b76ae53a799b0dc212089ac3df
↳cms.php : 188 -> getWebSiteLogos
↳lib/functions.php : 4986 -> WebSiteLogoMaster::getWebSiteLogo
↳model/WebSiteLogoMaster.php : 87 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
33. SELECT type, page_id, page_name FROM cms_pages WHERE page_id IN (128) ORDER BY cms_pages.sort_order ASC 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 46 -> get_menu_links
↳templates/include/html_helper.php : 29 -> CmsPagesMaster::getCmsPages
↳model/CmsPagesMaster.php : 122 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
34 2
. SELECT corporate_user.*, (SELECT pcu.corporate_settings FROM corporate_user pcu WHERE pcu.corporate_id = corporate_user.parent_corporate_id) AS parent_corporate_settings FROM corporate_user WHERE (corporate_user.directory_name = 'butterflygp' OR corporate_user.main_url IN ('butterflygp.com', 'www.butterflygp.com')) ORDER BY corporate_user.corporate_type ASC 0.0015 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 46 -> get_menu_links
↳templates/include/html_helper.php : 174 -> RAccess\StoreAccess::__construct
↳lib/RAccess/StoreAccess.php : 45 -> RAccess\StoreAccess::getDomain
↳lib/RAccess/StoreAccess.php : 471 -> RAccess\StoreAccess::getStore
↳lib/RAccess/StoreAccess.php : 347 -> CorporateUserMaster::getCorporateUser
↳model/CorporateUserMaster.php : 86 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
35. SELECT id, process_id, status FROM background_processes WHERE tag = 'Web Optimization' AND status = 'running' 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 46 -> get_menu_links
↳templates/include/html_helper.php : 190 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_dc39e14596b4bcf68bb13dd7b2aaf3f0::doDisplay
↳cache/4a/4adbbf7da441c461e64d7c86fd496549.php : 298 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_5f3bbab4ffff924a1bfba909d20b7d41::doDisplay
↳cache/51/51b7b4c43c0cb2d28bc1e418600b565b.php : 61 -> Twig\Extension\CoreExtension::callMacro
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1230 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::macro_image
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 657 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::{closure}
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 785 -> getOptimizedImage
↳templates/include/twig_functions.php : 2034 -> BackgroundProcessManager::getProcessFromTag
↳lib/Classes/BackgroundProcessManager.php : 103 -> BackgroundProcessMaster::getBackgroundProcesss
↳model/BackgroundProcessMaster.php : 58 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
36.
SELECT *
FROM site_currency
WHERE status = '1'
AND currency_id
IN (9)
0.0001 sec(Cached)2cb8607acf7c08c8fc1aeba3b83dd12e
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 46 -> get_menu_links
↳templates/include/html_helper.php : 190 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_dc39e14596b4bcf68bb13dd7b2aaf3f0::doDisplay
↳cache/4a/4adbbf7da441c461e64d7c86fd496549.php : 304 -> get_active_currency
↳templates/include/twig_functions.php : 266 -> CurrencyMaster::getCurrency
↳model/CurrencyMaster.php : 78 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
37. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name = 'cms_header_content' AND cms_pages.status = '1' AND cms_pages.corporate_id = 9 ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 51 -> get_header_content
↳templates/include/html_helper.php : 5261 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
38 35
. SELECT id, process_id, status FROM background_processes WHERE tag = 'Web Optimization' AND status = 'running' 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 67 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_5f3bbab4ffff924a1bfba909d20b7d41::doDisplay
↳cache/51/51b7b4c43c0cb2d28bc1e418600b565b.php : 61 -> Twig\Extension\CoreExtension::callMacro
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1230 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::macro_image
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 657 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::{closure}
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 785 -> getOptimizedImage
↳templates/include/twig_functions.php : 2034 -> BackgroundProcessManager::getProcessFromTag
↳lib/Classes/BackgroundProcessManager.php : 103 -> BackgroundProcessMaster::getBackgroundProcesss
↳model/BackgroundProcessMaster.php : 58 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
39 35
. SELECT id, process_id, status FROM background_processes WHERE tag = 'Web Optimization' AND status = 'running' 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 254 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_5f3bbab4ffff924a1bfba909d20b7d41::doDisplay
↳cache/51/51b7b4c43c0cb2d28bc1e418600b565b.php : 132 -> Twig\Extension\CoreExtension::callMacro
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1230 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::macro_image
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 657 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::{closure}
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 785 -> getOptimizedImage
↳templates/include/twig_functions.php : 2034 -> BackgroundProcessManager::getProcessFromTag
↳lib/Classes/BackgroundProcessManager.php : 103 -> BackgroundProcessMaster::getBackgroundProcesss
↳model/BackgroundProcessMaster.php : 58 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
40 33
. SELECT type, page_id, page_name FROM cms_pages WHERE page_id IN (128) ORDER BY cms_pages.sort_order ASC 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 29 -> CmsPagesMaster::getCmsPages
↳model/CmsPagesMaster.php : 122 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
41. CALL USPGetProductsDetail('product_category.category_id,products.category_id
AS cat_id,product_category.sort_order,product_category.display_in_menu,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category_description.megamenu_bg,(
select display_in_menu
from product_category
as a
where a.category_id = product_category.parent_id)
as parent_display_in_menu,product_category.parent_id,product_category_description.category_icon,product_category_description.category_header_content,product_category_description.metadata,products.products_id,products.predefined_product_type,products_description.product_url,products_description.products_title,products_description.product_promotional_text', '{\"status\":\"1\",\"visible\":1,\"include_kit\":\"false\",\"site_language_id\":1,\"corporate_id\":9,\"parent_corporate_id\":0,\"product_service_type\":1,\"store_access\":\"
AND ((((products.user_type_id
IN (\'0\',\'2\')
AND products.corporate_id = \'0\')
OR (products.corporate_id REGEXP \'(^|,)(9_0|9_1)(,|$)\'))))
AND products.products_id NOT
IN (\'887\',\'2019\',\'3316\',\'3317\',\'3318\',\'3417\',\'3883\',\'3934\',\'3935\',\'3936\',\'3937\',\'3938\',\'3939\',\'3940\',\'3941\',\'3942\',\'3943\',\'3944\',\'3945\',\'3946\',\'3947\',\'3948\',\'3949\',\'3950\',\'3951\',\'3952\',\'3953\',\'3954\',\'3955\',\'3956\',\'3957\',\'3958\',\'3959\',\'3960\',\'3961\',\'3962\',\'3963\',\'3964\',\'3965\',\'3966\',\'3967\',\'3968\',\'3969\',\'3970\',\'3971\',\'3972\',\'3973\',\'3974\',\'3975\',\'3976\',\'3977\',\'3978\',\'3979\',\'4029\',\'4030\',\'4031\',\'4032\',\'4033\',\'4034\',\'4096\',\'4097\',\'4098\',\'4106\',\'4135\',\'4270\',\'4271\',\'4272\',\'4299\',\'4300\',\'4301\',\'4302\',\'4303\',\'4304\',\'4305\',\'4306\',\'4307\',\'4308\',\'4309\',\'4310\',\'4311\',\'4312\',\'4313\',\'4314\',\'4315\',\'4316\',\'4317\',\'4318\',\'4319\',\'4320\',\'4321\',\'4322\',\'4323\',\'4324\',\'4325\',\'4326\',\'4327\',\'4328\',\'4329\',\'4330\',\'4331\',\'4332\',\'4333\',\'4334\',\'4335\',\'4336\',\'4337\',\'4338\',\'4339\',\'4340\',\'4341\',\'4342\',\'4343\',\'4344\')\",\"include_group\":\"group\",\"is_admin\":0,\"modules\":\"0,1\"}', '{\"orderby\":\"product_category.sort_order
ASC, product_category.parent_id
ASC, product_category.category_id ASC,products.sort_order ASC,products_description.products_title
ASC, products.products_id ASC\"}')
0.0002 sec(Cached)3d474fb0e19e982285813324eeb7ef50
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 160 -> get_product_listing
↳templates/include/html_helper.php : 251 -> ProductsMaster::getProductsDetail
↳model/ProductsMaster.php : 850 -> ProductsMaster::exec_query
↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
42.
SELECT *
FROM corporate_product_settings
WHERE corporate_product_settings.corporate_id
IN ('9', '0')
AND corporate_product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
ORDER BY setting_constant_name
ASC, FIELD(corporate_id, 9, 0)
0.0001 sec(Cached)ecf85b5e4f65ca64c8c72e7cefc5ea07
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 160 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7108 -> CorporateProductSettingsMaster::getCorporateProductSettings
↳model/CorporateProductSettingsMaster.php : 96 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
43.
SELECT *
FROM product_settings
WHERE product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
0.0003 sec(Cached)bbf87f8045e8db0bf5318438fb787874
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 160 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7133 -> ProductsSettingMaster::getProductSetting
↳model/ProductsSettingMaster.php : 80 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
44.
SELECT product_category.category_id, IF (corporate_product_category.category_pro_enable IS NOT NULL
AND corporate_product_category.category_pro_enable != '', corporate_product_category.category_pro_enable, product_category.category_pro_enable)
AS category_pro_enable,product_category.display_in_menu
as category_display, IF (corporate_product_category.category_pro_pattern IS NOT NULL
AND corporate_product_category.category_pro_pattern != '', corporate_product_category.category_pro_pattern, product_category.category_pro_pattern)
AS category_pro_pattern,IF (corporate_product_category_description.category_promotional_text IS NOT NULL
AND corporate_product_category_description.category_promotional_text != '', corporate_product_category_description.category_promotional_text, product_category_description.category_promotional_text)
AS category_promotional_text,IF (corporate_product_category_description.category_icon IS NOT NULL
AND corporate_product_category_description.category_icon != '', corporate_product_category_description.category_icon, product_category_description.category_icon)
AS category_icon, IF (corporate_product_category_description.category_header_content IS NOT NULL
AND corporate_product_category_description.category_header_content != '', corporate_product_category_description.category_header_content, product_category_description.category_header_content)
AS category_header_content, IF (corporate_product_category_description.metadata IS NOT NULL
AND corporate_product_category_description.metadata != '', corporate_product_category_description.metadata, product_category_description.metadata)
AS metadata,product_category_description.megamenu_bg, product_category.display_in_menu
as category_display
FROM product_category_description
LEFT JOIN product_category
ON product_category.category_id = product_category_description.category_id
LEFT JOIN corporate_product_category_description
ON product_category_description.category_id = corporate_product_category_description.category_id
AND corporate_product_category_description.site_language_id = 1
AND corporate_product_category_description.corporate_id = 9
LEFT JOIN corporate_product_category
ON product_category.category_id = corporate_product_category.category_id
AND corporate_product_category.corporate_id = 9
WHERE IF (corporate_product_category.status IS NOT NULL
AND corporate_product_category.status != '', corporate_product_category.status, product_category.status) = '1'
AND product_category.parent_id = '0'
AND product_category_description.site_language_id = 1
AND product_category.corporate_id = 9
0.0001 sec(Cached)508b6206429f2c2733cd12eaad7870d4
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 160 -> get_product_listing
↳templates/include/html_helper.php : 344 -> ProductCategoryMaster::get_group_list
↳model/ProductCategoryMaster.php : 249 -> ProductCategoryMaster::exec_query
↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
45.
SELECT SQL_CALC_FOUND_ROWS IF (corporate_products.sort_order IS NOT NULL
AND corporate_products.sort_order != '', corporate_products.sort_order, products.sort_order)
AS sort_order,IF (corporate_products_description.imagename IS NOT NULL
AND corporate_products_description.imagename != '', corporate_products_description.imagename, products_description.imagename)
AS imagename, IF (corporate_products_description.product_description IS NOT NULL
AND corporate_products_description.product_description != '', corporate_products_description.product_description, products_description.product_description)
AS product_description,IF (corporate_products_description.products_title IS NOT NULL
AND corporate_products_description.products_title != '', corporate_products_description.products_title, products_description.products_title)
AS products_title,products_description.products_id, IF (corporate_products_description.imagename_alt IS NOT NULL
AND corporate_products_description.imagename_alt != '', corporate_products_description.imagename_alt, products_description.imagename_alt)
AS imagename_alt, IF (corporate_products_description.product_desc_image_alt IS NOT NULL
AND corporate_products_description.product_desc_image_alt != '', corporate_products_description.product_desc_image_alt, products_description.product_desc_image_alt)
AS product_desc_image_alt, IF (corporate_products_description.metadata IS NOT NULL
AND corporate_products_description.metadata != '', corporate_products_description.metadata, products_description.metadata)
AS metadata
FROM product_kit
LEFT JOIN products
ON product_kit.product_id = products.products_id
LEFT JOIN products_description
ON products.products_id = products_description.products_id
AND products_description.site_language_id = 1
LEFT JOIN corporate_products_description
ON products_description.products_id = corporate_products_description.products_id
AND corporate_products_description.site_language_id = 1
AND corporate_products_description.corporate_id = 9
LEFT JOIN corporate_products
ON products.products_id = corporate_products.products_id
AND corporate_products.corporate_id = 9
WHERE products.kit_type_id != '1'
AND products.visible = '1'
AND ((((products.user_type_id
IN ('0', '2')
AND products.corporate_id = '0')
OR (products.corporate_id REGEXP '(^|,)(9_0|9_1)(,|$)'))))
ORDER BY product_kit.kit_id
ASC 0.0001 sec(Cached)d2c2daa3f6f45ac30a2bb4881333d9b7
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 163 -> get_kit_products
↳templates/include/html_helper.php : 639 -> KitMaster::getKit
↳model/KitMaster.php : 90 -> KitMaster::exec_query
↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
46. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 9 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all-products') AND cms_pages.status = '1' ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 0.0016 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 665 -> get_cms_content
↳templates/include/html_helper.php : 2387 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
47. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 9 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'shop-by-material-megamenu') AND cms_pages.status = '1' ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 0.0015 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 665 -> get_cms_content
↳templates/include/html_helper.php : 2387 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
48. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 9 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'shop-by-products') AND cms_pages.status = '1' ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 0.0015 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 665 -> get_cms_content
↳templates/include/html_helper.php : 2387 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
49. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 9 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'display-solution-menu') AND cms_pages.status = '1' ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 0.0015 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 665 -> get_cms_content
↳templates/include/html_helper.php : 2387 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
50 42
.
SELECT *
FROM corporate_product_settings
WHERE corporate_product_settings.corporate_id
IN ('9', '0')
AND corporate_product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
ORDER BY setting_constant_name
ASC, FIELD(corporate_id, 9, 0)
0 sec(Cached)ecf85b5e4f65ca64c8c72e7cefc5ea07
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 618 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7108 -> CorporateProductSettingsMaster::getCorporateProductSettings
↳model/CorporateProductSettingsMaster.php : 96 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
51 43
.
SELECT *
FROM product_settings
WHERE product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
0 sec(Cached)bbf87f8045e8db0bf5318438fb787874
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 618 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7133 -> ProductsSettingMaster::getProductSetting
↳model/ProductsSettingMaster.php : 80 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
52 42
.
SELECT *
FROM corporate_product_settings
WHERE corporate_product_settings.corporate_id
IN ('9', '0')
AND corporate_product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
ORDER BY setting_constant_name
ASC, FIELD(corporate_id, 9, 0)
0 sec(Cached)ecf85b5e4f65ca64c8c72e7cefc5ea07
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 618 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7108 -> CorporateProductSettingsMaster::getCorporateProductSettings
↳model/CorporateProductSettingsMaster.php : 96 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
53 43
.
SELECT *
FROM product_settings
WHERE product_settings.setting_constant_name
IN ('PRODUCT_PROMOTION_IN_TITLE')
0 sec(Cached)bbf87f8045e8db0bf5318438fb787874
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 618 -> get_product_listing
↳templates/include/html_helper.php : 256 -> getProductSetting
↳lib/dbfunctions.php : 7133 -> ProductsSettingMaster::getProductSetting
↳model/ProductsSettingMaster.php : 80 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
54. SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.corporate_id = 9 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'resources') AND cms_pages.status = '1' ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 0.0016 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 88 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_d8818550322633b336478f55e146403d::doDisplay
↳cache/5c/5c69d0be178ed521524a43bba195a299.php : 284 -> get_menu_links
↳templates/include/html_helper.php : 196 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_af4cb0aeccb6b440e87b312466bd0f37::doDisplay
↳cache/8f/8f50805361ec9486a37a220896af0e01.php : 652 -> get_cms_content
↳templates/include/html_helper.php : 2387 -> CmsPagesMaster::getCmsPagesDetails
↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
55. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2025-07-16 03:19:26' AND banner_image.banner_end_date >= '2025-07-16 03:19:26')) AND banner_image.banner_pages REGEXP '[[:<:]](career-opportunity|career_opportunity)[[:>:]]' AND banner_image.banner_display != '1' AND banner_image.corporate_id = 9 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0018 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 109 -> top_banner
↳templates/include/html_helper.php : 1042 -> BannerImageMaster::getBannerImage
↳model/BannerImageMaster.php : 104 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
56 55
. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2025-07-16 03:19:26' AND banner_image.banner_end_date >= '2025-07-16 03:19:26')) AND banner_image.banner_pages REGEXP '[[:<:]](career-opportunity|career_opportunity)[[:>:]]' AND banner_image.banner_display != '1' AND banner_image.corporate_id = 9 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0014 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 178 -> top_banner
↳templates/include/html_helper.php : 1042 -> BannerImageMaster::getBannerImage
↳model/BannerImageMaster.php : 104 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
57.
SELECT *
FROM breadcrumbs
WHERE status = '1'
0.0001 sec(Cached)cfc88bdad1d3c808679011331b88f107
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 192 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_847f47bc21548d759b95563b1d44dda0::doDisplay
↳cache/4a/4ad16835b779b07ecc41db1e9e5fe81f.php : 80 -> show_breadcrumb
↳templates/include/twig_functions.php : 937 -> include_once
↳lib/breadcrumbs.php : 43 -> BreadcrumbsMaster::getBreadcrumbs
↳model/BreadcrumbsMaster.php : 83 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
58 35
. SELECT id, process_id, status FROM background_processes WHERE tag = 'Web Optimization' AND status = 'running' 0.0014 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 192 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_847f47bc21548d759b95563b1d44dda0::doDisplay
↳cache/4a/4ad16835b779b07ecc41db1e9e5fe81f.php : 126 -> Twig\Extension\CoreExtension::callMacro
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1230 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::macro_image
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 657 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_13ca11e7abd84a4ff4b9871aacfee1ac::{closure}
↳cache/58/5872f921d4ab4fb98b9aa69def9e14ca.php : 785 -> getOptimizedImage
↳templates/include/twig_functions.php : 2034 -> BackgroundProcessManager::getProcessFromTag
↳lib/Classes/BackgroundProcessManager.php : 103 -> BackgroundProcessMaster::getBackgroundProcesss
↳model/BackgroundProcessMaster.php : 58 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
59 33
. SELECT type, page_id, page_name FROM cms_pages WHERE page_id IN (128) ORDER BY cms_pages.sort_order ASC 0.0013 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 271 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_f47fbaddc2e6868df90ec46cc547d873::doDisplay
↳cache/de/def9f9c36d9813455eaa325424556d63.php : 48 -> get_menu_links
↳templates/include/html_helper.php : 29 -> CmsPagesMaster::getCmsPages
↳model/CmsPagesMaster.php : 122 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger
60. SELECT * FROM (SELECT promotional_message.promotional_id,promotional_category,promotional_message_description.title,promotional_message_description.description,style_type,status,section_name,promo_cookie,promo_settings FROM promotional_message
LEFT JOIN promotional_message_description ON promotional_message_description.promotional_id = promotional_message.promotional_id WHERE 1 AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1' AND promotional_message.corporate_id = 9 AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2025-07-16 03:19:26' AND promotional_message.promotion_end_date >= '2025-07-16 03:19:26')) AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND (promotional_message.section_name LIKE 'cms.php?page=career_opportunity' OR ((promotional_message.promotional_category = '13' OR promotional_message.promotional_category = '14' ) AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2025-07-16 03:19:26' AND promotional_message.promotion_end_date >= '2025-07-16 03:19:26'))AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1')) ORDER BY promotional_category ASC , promotional_id DESC LIMIT 18446744073709551615) AS a GROUP BY style_type 0.0026 sec
↳cms.php : 201 -> OpsTwigEnvironment::render
↳lib/twig.php : 35 -> Twig\Environment::render
↳vendor/twig/twig/src/Environment.php : 307 -> Twig\TemplateWrapper::render
↳vendor/twig/twig/src/TemplateWrapper.php : 38 -> Twig\Template::render
↳vendor/twig/twig/src/Template.php : 335 -> Twig\Template::yield
↳vendor/twig/twig/src/Template.php : 360 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::doDisplay
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 40 -> Twig\Extension\CoreExtension::captureOutput
↳vendor/twig/twig/src/Extension/CoreExtension.php : 1827 -> __TwigTemplate_454d9856a44980237b8bfa0b542c5fb2::{closure}
↳cache/8a/8af653e6f0e21514346daf99bb5356c1.php : 295 -> addJS
↳templates/include/js.php : 536 -> require_once
↳templates/js/common_js.php : 89 -> getpromotionalmessage
↳templates/include/html_helper.php : 4947 -> PromotionalMessageMaster::getPromotionalMessagefordisplay
↳model/PromotionalMessageMaster.php : 137 -> RMasterModel::exec_query
↳lib/Classes/Models/RMasterModel.php : 85 -> RMasterModel::query_debugger