Terms and Conditions

Acceptance of Terms of Usage

 

These Terms of Usage govern your access and use of this Site. By accessing or using this Site you agree to be bound by these Terms of Usage and to any additional guidelines, restrictions, or rules that may be posted in connection with specific sections or services of this Site. All such additional posted guidelines, restrictions, or rules are hereby incorporated by reference into these Terms of Use.

 

Xumbaprinting Inc reserves the right to make changes to this Site and to these Terms of Usage at any time without prior notice. You should review these Terms of Usage each time you access this Site.

 

You also agree that we may provide all legal communications and notices to you electronically by posting them on our website or, at our election, by sending an e-mail to the e-mail address you provided to us when you registered at our website. You may withdraw your consent to receive communications from us electronically by contacting customer care. However, if you withdraw your consent to receive our communications electronically, you must discontinue your use of your account.

 


 

General

 

All the terms and conditions and/or any transactions occuring online at www.xumbaprinting.com or by phone are subject to the laws of the State of Florida.  Xumbaprinting Inc is not responsible for the delay and/or damages resulting from Machinery Breakdown, Acts of God, and from other actions, both governmental and otherwise, including but not limited to war, riot, seizure, and embargo.   The tools available on www.xumbaprinting.com to create document is the property of Xumbaprinting Inc and its affiliated companies.  The Buyer’s order shall be deemed an acceptance of the Seller's terms.  The Terms and conditions shall in all respects be governed by STATE OF FLORIDA law. 

 


 

Reservations

 

All orders are subject to acceptance by Xumbaprinting Inc. We reserve the right to reject any order at any time without recourse. We also reserve the right to change the price at any time even after we receive the order.

 


 

Returns

 

Due to the nature of the product, no returns can be made once the order is processed and/or shipped. Any claims for defects, damages, or shortages must be made in writing within two (2) business days after receipt of the merchandise. We will replace only those orders that were processed incorrectly. The replacement of the order will take place only after the receipt of returned merchandise. We will not replace the order if it is determined by us that the order was misused or mishandle by the buyer or part of the order was used by the buyer and part of the order is being returned. 

 


 

Credit Card

 

If the Buyer's credit card is declined, Xumbaprinting Inc will not process the Buyer’s order. If the order is shipped and should the Buyer's account become delinquent, Buyer agrees to pay a monthly finance charge of 2% (annual percentage rate of 24%) on the unpaid balance. If an account goes beyond the payment term's due date, unless specific arrangements are made, future purchases will require advance payment. In the event that Xumbaprinting Inc must commence legal action to enforce any terms of this agreement, the Buyer agrees to pay reasonable legal fees and costs.

 


 

Warranty

 

We reserve the right to update and revise this Returns/Refund/Reprint Policy without prior notice to reflect changes in our policies, services and/or in response to our customers' feedback. When we do make changes to this Policy we will revise the "last updated" date at the top of this Policy. Please make sure that you review it frequently as any time you place an order with Xumba Printing the current Returns/Refund/Reprint Policy will apply.

We guarantee that our printed products will not be defective in accordance with industry standards. You may contact our Customer Service Department and a Xumba Printing representative will be pleased to help address any general issues you may have with your print job.

If you believe your print job is defective or has not otherwise met your requirements please contact Xumba Printing, IN WRITING, within six (6) business days of receiving your order. If you do not contact us within this time frame we will assume that your job was satisfactory upon receipt and will be under no obligation to provide a refund or reprint. Once you have contacted us, we will then have five (5) business days to determine if a reprint or refund is appropriate, or to advise you that more information is needed to process your inquiry. If we request additional information to verify an inquiry and it is not provided within a reasonable time, we will be under no obligation to provide a refund or reprint. If we determined that a product is in fact defective or has not otherwise met our obligations, one of the following two resolutions will be offered:

1. We will reprint the print job.

2. We will refund the original order price.

We reserve the right to request samples of any allegedly defective merchandise prior to either of the above resolutions being agreed to.

A Customer Service representative will generally contact you within 24-48 hours of us making the determination that a reprint or refund is appropriate in order to confirm the approved solution. If you do not make contact with our representative within five (5) business days of their first attempt to contact you with the approved solution we will assume that the issue has been otherwise resolved and no reprint or refund will be given. Once the approved solution is agreed then, unless we agree otherwise, you must return the entire original print order to us, at the address provided by our Customer Service representative, within 15 calendar days after the date the solution is approved. If you do not return it within this time frame you agree that the original order will be charged against your credit card on file with Xumba Printing.

A refund or reprint will only be possible after an approved solution has been authorized and, unless we agree otherwise, provided that the entire original print order has been returned to and received by us.

When applicable, a refund will be issued within 10 business days of our receipt of the original product order.

A reprint will begin production within one (1) business day of our confirmed receipt of the product or such earlier time as we may agree to.

The forgoing is Xumba Printing sole responsibility with respect to a defective order. To the maximum extent permitted by law, Xumba Printing is not responsible for any indirect, incidental, special, consequential or exemplary damages, including, but not limited to, damages for loss of profits, goodwill, use, data or other intangible losses (even if Xumba Printing has been advised of the possibility of such damages), resulting from the order.

The following are some guidelines and examples of issues that do not constitute grounds for a refund, or a return or reprint of a product:

  • An order that is refused at time of delivery or undeliverable orders. (We will reship the product at the customer's expense if requested).
  • The product is lost, delayed or returned to Xumba Printing due to an error made by the customer in submitting the proper shipping address. (For product that is later found or that is returned to us we will reship the package with a corrected address and charge an additional shipping fee for the shipment).
  • Product that is delayed in production and/or shipping as a result of the customer providing inaccurate information.
  • Product that incurs a higher shipping charge as a result of the customer providing inaccurate information.
  • Product that is delayed in production and/or shipping as a result of shipping company delays, acts of God, weather conditions, environmental or dangerous goods incidents, perils of the air, public enemies, public authorities acting with actual or apparent authority, acts or omissions of customs officials, authority of law, quarantine, riots, strikes, work stoppages or slowdowns, or other labor disputes or disturbances, civil commotions or hazards incident to a state of war, local or national disruptions in ground or air transportation networks or systems due to events beyond our control, disruption or failure of communication and information systems, disruption or failure of utilities, international customs issues, and any other circumstances that are beyond our direct control.
  • Product that has experienced a color shift during the conversion to CMYK format, for example as a result of having been submitted by the customer in RGB or PMS Pantone colors.
  • Errors that are contained in the uploaded customer file, e.g., misspelling, graphics, bleeds, grammar, damaged fonts, punctuation, wrong cuts, incorrect or missing folds, die lines, crop marks, transparency, overprint, and finished product size. Xumba Printing does not make any changes on customer files.
  • Product that experiences print or images that are fuzzy, pixilated or otherwise distorted as a result of the customer providing artwork that is not at a minimum of 300 DPI at 1:1 ratio (or 100%) and/or in CMYK mode.
  • Products that do not exactly match color or ink density. Xumba Printing does not color match or match customer specified ink density.
  • An inability to print or write on the product, unless the product description states otherwise. A typical UV coated product cannot be printed or written upon. Matte finished products may or may not accept printing or writing. We recommend that you order a sample from us and test it using the printer you will use before placing a final order. Xumba Printing is not responsible for an inability to print or write on a Product, unless the product specifically states that it is suitable for this purpose.
  • Orders that are duplicated as a result of customer error.
  • Orders that are canceled after the order has entered into production (or any process thereafter).
  • Orders that contain dated materials that arrive after the relevant date or with insufficient time to use the material as intended. It is a customer’s responsibility to allow sufficient time when placing an order for time sensitive materials.
  • A customer’s violation of any of the terms and conditions governing the use of Xumba Printing’s website and/or ordering of product.
  • Viruses, worms, trojan horses and other forms of harmful or malicious code that are not detected or removed using Xumba’s standard virus/malicious code detection procedures.
  • Loss, corruption of, or damage to your personal information, Customer Content, order history or related information that is stored by Xumba Printing.
  • Our failure to notify you of any delay, loss or damage in connection with your printed products or shipment or any inaccuracy in such notice.
  • The release of an order by the shipper without obtaining a signature.

Please note that Xumba Printing’s provision of advice, assistance or guidance either on this Website or via our Customer Service representatives does not constitute an acceptance of responsibility or liability for any problems that may arise in connection with any print order or services provided.

 

 


 

Shipping

 

Shipping terms are F.O.B. _________.  Xumbaprinting Inc will arrange for shipping with the carrier on behalf of the buyer.  The Buyer will be fully responsible for the shipping and handling cost.  Xumbaprinting Inc will not be responsible for the delay in delivery, loss or damage of the order while the order is with the shipping carrier.

 


 

Limitation of Liability:

 

Xumbaprinting Inc will not be liable in contract or in tort (including negligence) to the customer for incidental or consequential damages, arising out of or resulting from anybody’s performance or nonperformance of our obligations.  Xumbaprinting Inc shall not be liable to anyone for any kind of financial losses, cost, expenses, damages and/or other economic damages.  The Buyer agrees that the Buyer will not hold Xumbaprinting Inc responsible for any and all loss, cost, expense, and damages (including legal costs) on account of any and all manner of claims, demands, actions, and proceedings that may be instituted against Xumbaprinting Inc and its affiliated company (S) on grounds alleging that the said work violates any copyrights, trademarks, service marks, or is scandalous, or invades any person's right to privacy or other personal rights.

 


 

Cancellations and Refunds:

A print order can be canceled at any time prior to it entering into production. If you cancel an order prior to it entering into production a Xumba Printing Service representative will inform you of any cancellation charges incurred. (Please allow at least 10 business days for any refunded monies to be credited to your account). A print order cannot be canceled and no refund will be given once it has entered into production or any process thereafter. No refunds are issued for Logo and Graphic design services. All cancellations must be completed in writing by email sent to info@xumba.com.

If within forty five (45) days or later of you placing an order and Xumba Printing has not received any files or incomplete files from which to complete your job, Xumba Printing may at its option cancel the order and refund any payment charged to your credit card.

 

Tagging of Art Work:

 

The Xumbaprinting  is a discreet mark that we add to artwork designed and printed by us on the edge of the printed piece.  This is a sample of what our tag will look like:

Designed and Printed by Xumbaprinting.com 786-228-8510 (Printed on 5 PT arial)

Tagging your orders is the only reason we have been able to maintain such incredibly low prices in today's challenging environment.  We do understand that in some instances a customer feels more comfortable removing this tag.  We give you the option of removing our tag for a product dependent nominal fee.  If you are not clear on our tag options please contact us at 786-228-8510 so that a customer service representative can provide you with further information.

Total Queries : 37
Active Queries : 37
Cached Queries : 0
Duplicate Queries : 2
Total Query Time : 0.9952 sec (Cached 0.0089 sec )
Total Memory Usage : 16 mb

1. SELECT set_value, constant_name FROM configuration_master WHERE constant_name IN ('CORPORATE_MODUEL_ENABLE', 'COUNTRY_BASED_IP_SETTING') 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 116 -> ConfigurationMaster::getConfiguration
         ↳model/ConfigurationMaster.php : 138 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> 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 = '' OR corporate_user.main_url IN ('xumbaprinting.dev.radixweb.net', 'www.xumbaprinting.dev.radixweb.net')) ORDER BY corporate_user.corporate_type ASC 0.0007 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 213 -> RAccess\StoreAccess::__construct
         ↳lib/RAccess/StoreAccess.php : 45 -> RAccess\StoreAccess::getDomain
            ↳lib/RAccess/StoreAccess.php : 477 -> RAccess\StoreAccess::getStore
               ↳lib/RAccess/StoreAccess.php : 353 -> CorporateUserMaster::getCorporateUser
                  ↳model/CorporateUserMaster.php : 86 -> RMasterModel::exec_query
                     ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
3. 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.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 348 -> AdminSectionMaster::getAdminSectionDetail
            ↳model/AdminSectionMaster.php : 124 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
4. SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master WHERE (configuration_master.available_for_corporate LIKE '%%' OR configuration_master.available_for_corporate = '-1') ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 458 -> ConfigurationMaster::getConfiguration
            ↳model/ConfigurationMaster.php : 138 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
5. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'xumbaprinting' 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 500 -> SiteThemeMaster::getSiteTheme
            ↳model/SiteThemeMaster.php : 78 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
6. SELECT payment_method_id, directory FROM payment_method WHERE directory IN ('payon_account', 'partial_payment') ORDER BY sort_order ASC 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 563 -> PaymentMethodMaster::getPaymentMethod
            ↳model/PaymentMethodMaster.php : 63 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
7. SELECT external_services.*,external_service_section.section_name FROM external_services LEFT JOIN external_service_section ON external_services.section_id = external_service_section.section_id WHERE external_services.corporate_id = 0 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 647 -> ExternalServiceMaster::getExternalService
            ↳model/ExternalServiceMaster.php : 70 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
8. SELECT website_logos.* FROM website_logos WHERE website_logos.corporate_id IN ('0') ORDER BY FIELD(corporate_id, 0, 0, 0) 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 838 -> getWebSiteLogos
            ↳lib/functions.php : 4966 -> WebSiteLogoMaster::getWebSiteLogo
               ↳model/WebSiteLogoMaster.php : 87 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
9. SELECT * FROM site_language 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 215 -> require_once
         ↳lib/siteconstants.php : 851 -> SiteLanguageMaster::getSiteLanguage
            ↳model/SiteLanguageMaster.php : 48 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
10. SELECT * FROM url_redirection_manage WHERE (old_url = 'http://xumbaprinting.dev.radixweb.net/cms.php?page=terms_of_use&popup=1' OR old_url = 'http://xumbaprinting.dev.radixweb.net/cms.php?page=terms_of_use&popup=1' OR old_url = 'http://xumbaprinting.dev.radixweb.net/cms.php?page=terms_of_use&popup=1') ORDER BY url_redirection_id ASC 0.0009 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 227 -> UrlRedirectionManageMaster::getUrlRedirectionManage
         ↳model/UrlRedirectionManageMaster.php : 79 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
11. SELECT * FROM site_currency WHERE default_currency = '1' 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 301 -> require_once
         ↳lib/config_language.php : 159 -> create_currency_session
            ↳lib/dbfunctions.php : 7016 -> CurrencyMaster::getCurrency
               ↳model/CurrencyMaster.php : 78 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
12. SET time_zone = '-04:00' 0.0002 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 304 -> set_timezone
         ↳lib/functions.php : 1809 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
13. SELECT product_category.category_id, product_category_description.category_url as caturl, product_category_description.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 WHERE product_category.status = '1' 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 439 -> require_once
         ↳lib/seo.php : 362 -> ProductCategoryMaster::get_product_category_details_header_search
            ↳model/ProductCategoryMaster.php : 274 -> ProductCategoryMaster::exec_query
               ↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
14. SELECT products.products_id, products_description.product_url as producturl, 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 WHERE ((products.user_type_id IN ('0', '1'))) 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 439 -> require_once
         ↳lib/seo.php : 378 -> ProductsMaster::getProducts
            ↳model/ProductsMaster.php : 177 -> ProductsMaster::exec_query
               ↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
15. 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 = 0 ORDER BY cms_pages.sort_order, cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0005 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 439 -> require_once
         ↳lib/seo.php : 442 -> CmsPagesMaster::getCmsPagesDetails
            ↳model/CmsPagesMaster.php : 159 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
16. SELECT site_seo_description.seo_page_title, site_seo.page_name,site_seo_description.seo_page_description, 0 AS corporate_id FROM site_seo 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.0012 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 440 -> require_once
         ↳lib/metatag.php : 51 -> seoPageMaster::getSeoPageDetails
            ↳model/seoPageMaster.php : 148 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
17. SELECT SQL_CALC_FOUND_ROWS cms_pages_description.site_language_id, cms_pages_description.seo_page_title,cms_pages_description.seo_page_description, cms_pages_description.seo_page_metatags, 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.schema_markup, cms_pages_description.image_name, cms_pages.blog_page 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 IF(cms_pages_description.page_url = 'terms_of_use', (cms_pages_description.page_url = 'terms_of_use' OR cms_pages_description.page_url = 'terms_of_use'), (cms_pages.page_name = 'terms_of_use' OR cms_pages.page_name = 'terms_of_use')) AND cms_pages.status = '1' AND cms_pages.corporate_id IN ('0') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0015 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 440 -> require_once
         ↳lib/metatag.php : 117 -> CmsPagesMaster::getCmsPagesDetails
            ↳model/CmsPagesMaster.php : 159 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
18. SELECT site_general_metatag.name, site_general_metatag.content, site_general_metatag.type 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 = 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)) ORDER BY site_front_pages.front_pages_id DESC 0.0007 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 440 -> require_once
         ↳lib/metatag.php : 648 -> SiteGeneralMetatagMaster::getMetatagDetails
            ↳model/SiteGeneralMetatagMaster.php : 106 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
19. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'cms' 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 447 -> SiteFrontPagesMaster::getSiteFrontPages
         ↳model/SiteFrontPagesMaster.php : 77 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
20. SELECT * FROM(SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants.constant_id, ROW_NUMBER() OVER(PARTITION BY site_constants.constant_id ORDER BY FIELD(site_constants_description.constant_id, 0)) AS rank, site_constants_description.corporate_id FROM site_constants INNER JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 INNER 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 = 0 OR site_constants_description.corporate_id IS NULL )) AS ranked WHERE rank = 1 0.3572 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 469 -> SiteConstantMaster::getSiteConstantDetailsCustomQuery
         ↳model/SiteConstantMaster.php : 222 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
21. 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 menu_link.status = '1' AND (link_display = '2' OR link_display = '0') AND menu_link.corporate_id = 0 ORDER BY sort_order ASC, menu_id ASC 0.0005 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 491 -> all_menu_data
         ↳lib/dbfunctions.php : 2865 -> MenuLinkMaster::getMenuLinkDescriptionWithCorporate
            ↳model/MenuLinkMaster.php : 234 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
22. SELECT * FROM side_menu_link WHERE function_name = 'getCMSCategory' 0.0778 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 105 -> get_sidebox_details
            ↳lib/dbfunctions.php : 755 -> SideMenuLinkMaster::getSideMenuLink
               ↳model/SideMenuLinkMaster.php : 77 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
23. SELECT * FROM sidebar_management WHERE section_pages LIKE '%||%' AND sidebar_management.corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0007 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 105 -> get_sidebox_details
            ↳lib/dbfunctions.php : 776 -> SidebarManagementMaster::getSidebarManagement
               ↳model/SidebarManagementMaster.php : 82 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
24. SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND side_menu_link.corporate_id = 0 GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC LIMIT 18446744073709551615 ) AS temp_table ORDER BY sortorder ASC, status ASC, menu_title ASC 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 105 -> get_sidebox_details
            ↳lib/dbfunctions.php : 812 -> SideMenuLinkMaster::getSideMenuLinkDescriptionWithCorporate
               ↳model/SideMenuLinkMaster.php : 132 -> RMasterModel::exec_query
                  ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
25. 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') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY FIELD(cms_pages.corporate_id, 0, 0, 0), cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 246 -> CmsPagesMaster::getCmsPagesDetails
            ↳model/CmsPagesMaster.php : 159 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
26. SELECT SQL_CALC_FOUND_ROWS product_category.category_id, product_category_description.category_name, product_category_description.category_image FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.status = '1' AND product_category_description.site_language_id = 1 AND product_category.parent_id != 0 0.0005 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e582dd06cf6335dc06e5755676d644fb::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 44 -> get_category_list_custom
                                          ↳themes/xumbaprinting/include/html_helper.php : 12 -> ProductCategoryMaster::get_product_category_details
                                             ↳model/ProductCategoryMaster.php : 188 -> ProductCategoryMaster::exec_query
                                                ↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
                                                   ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
27. CALL USPGetProductsDetail('product_category.category_id,products.category_id AS cat_id,product_category.sort_order,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id,product_category_description.category_icon,product_category_description.category_header_content,product_category_description.metadata,product_category.display_category,products.products_id,products.predefined_product_type,products_description.product_url,products_description.products_title,products_description.product_promotional_text', '{\"status\":\"1\",\"visible\":1,\"hidden_product\":\"yes\",\"include_kit\":\"false\",\"site_language_id\":1,\"corporate_id\":0,\"parent_corporate_id\":0,\"product_service_type\":1,\"store_access\":\" AND ((products.user_type_id IN (\'0\',\'1\')))\",\"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.0146 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e582dd06cf6335dc06e5755676d644fb::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 46 -> get_product_listing
                                          ↳templates/include/html_helper.php : 237 -> ProductsMaster::getProductsDetail
                                             ↳model/ProductsMaster.php : 929 -> ProductsMaster::exec_query
                                                ↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
                                                   ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
28. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') 0.0004 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e582dd06cf6335dc06e5755676d644fb::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 46 -> get_product_listing
                                          ↳templates/include/html_helper.php : 242 -> getProductSetting
                                             ↳lib/dbfunctions.php : 7337 -> ProductsSettingMaster::getProductSetting
                                                ↳model/ProductsSettingMaster.php : 80 -> RMasterModel::exec_query
                                                   ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
29. SELECT product_category.category_id, product_category.category_pro_enable, product_category.category_pro_pattern, product_category_description.category_promotional_text, product_category_description.category_icon, product_category_description.category_header_content, product_category_description.metadata, product_category.status FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.parent_id = '0' AND product_category_description.site_language_id = 1 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e582dd06cf6335dc06e5755676d644fb::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 46 -> get_product_listing
                                          ↳templates/include/html_helper.php : 325 -> ProductCategoryMaster::get_group_list
                                             ↳model/ProductCategoryMaster.php : 241 -> ProductCategoryMaster::exec_query
                                                ↳model/CorporateProductsTrait.php : 344 -> RMasterModel::exec_query
                                                   ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
30. SELECT id, process_id, status FROM background_processes WHERE tag = 'products_product_gallery' AND status = 'running' 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e582dd06cf6335dc06e5755676d644fb::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 73 -> __TwigTemplate_ca152179d70ab97add101389339c8ad9::macro_image
                                          ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 671 -> Twig\Extension\CoreExtension::captureOutput
                                             ↳vendor/twig/twig/src/Extension/CoreExtension.php : 2058 -> __TwigTemplate_ca152179d70ab97add101389339c8ad9::{closure}
                                                ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 796 -> getOptimizedImage
                                                   ↳templates/include/twig_functions.php : 2093 -> BackgroundProcessManager::getProcessFromTag
                                                      ↳lib/Classes/BackgroundProcessManager.php : 103 -> BackgroundProcessMaster::getBackgroundProcesss
                                                         ↳model/BackgroundProcessMaster.php : 58 -> RMasterModel::exec_query
                                                            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
31 28. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_b83132bc9e5931122beabf36ceed83c3::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 42 -> Twig\Template::yield
                                          ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_d4c5232201420d9a9064737d19ec21ee::doDisplay
                                             ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 44 -> get_product_listing
                                                ↳templates/include/html_helper.php : 242 -> getProductSetting
                                                   ↳lib/dbfunctions.php : 7337 -> ProductsSettingMaster::getProductSetting
                                                      ↳model/ProductsSettingMaster.php : 80 -> RMasterModel::exec_query
                                                         ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
32. SELECT type, page_id, page_name FROM cms_pages WHERE page_id IN (9, 10) ORDER BY cms_pages.sort_order ASC 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_e62d47dcc43ca46e65674a3ff31a94fc::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 42 -> get_menu_links
                                          ↳templates/include/html_helper.php : 29 -> CmsPagesMaster::getCmsPages
                                             ↳model/CmsPagesMaster.php : 121 -> RMasterModel::exec_query
                                                ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
33. SELECT * FROM testimonial INNER JOIN testimonial_description ON (testimonial.testimonial_id = testimonial_description.testimonial_id) WHERE testimonial.corporate_id = 0 AND testimonial.status = '1' AND testimonial_description.site_language_id = 1 ORDER BY RAND() LIMIT 2 OFFSET 0 0.0014 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 264 -> render_cms
            ↳templates/include/html_helper.php : 2424 -> preg_replace_callback
               ↳ : -> {closure}
                  ↳templates/include/html_helper.php : 2645 -> OpsTwigEnvironment::render
                     ↳lib/twig.php : 35 -> Twig\Environment::render
                        ↳vendor/twig/twig/src/Environment.php : 320 -> Twig\TemplateWrapper::render
                           ↳vendor/twig/twig/src/TemplateWrapper.php : 35 -> Twig\Template::render
                              ↳vendor/twig/twig/src/Template.php : 358 -> Twig\Template::display
                                 ↳vendor/twig/twig/src/Template.php : 343 -> Twig\Template::yield
                                    ↳vendor/twig/twig/src/Template.php : 387 -> __TwigTemplate_5490d9711589ad71e9ba74293f6e5874::doDisplay
                                       ↳vendor/twig/twig/src/Environment.php(407) : eval()'d code : 53 -> get_testimonials
                                          ↳templates/include/html_helper.php : 764 -> TestimonialMaster::getTestimonialdata
                                             ↳model/TestimonialMaster.php : 138 -> RMasterModel::exec_query
                                                ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
34. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting 0.0003 sec
   ↳cms.php : 16 -> require_once
      ↳lib/common.php : 543 -> require_once
         ↳lib/twig.php : 369 -> BannerImageMaster::getBannerImageSetting
            ↳model/BannerImageMaster.php : 116 -> RMasterModel::exec_query
               ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
*******************************COMMON END*********************************
36. 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, 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 = 'terms_of_use', (cms_pages_description.page_url = 'terms_of_use' OR cms_pages_description.page_url = 'terms_of_use'), (cms_pages.page_name = 'terms_of_use' OR cms_pages.page_name = 'terms_of_use')) AND cms_pages.corporate_id = 0 AND cms_pages.status = '1' GROUP BY cms_pages.page_id ORDER BY cms_pages.corporate_id ASC, cms_pages.corporate_id DESC, cms_pages.sort_order ASC 0.5214 sec
   ↳cms.php : 106 -> CmsPagesMaster::getCmsPagesDetails
      ↳model/CmsPagesMaster.php : 159 -> RMasterModel::exec_query
         ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger
37 8. SELECT website_logos.* FROM website_logos WHERE website_logos.corporate_id IN ('0') ORDER BY FIELD(corporate_id, 0, 0, 0) 0.0089 sec
   ↳cms.php : 236 -> getWebSiteLogos
      ↳lib/functions.php : 4966 -> WebSiteLogoMaster::getWebSiteLogo
         ↳model/WebSiteLogoMaster.php : 87 -> RMasterModel::exec_query
            ↳lib/Classes/Models/RMasterModel.php : 185 -> RMasterModel::query_debugger