Terms & Conditions

This document is an electronic record in terms of Information Technology Act, 2000 and rules there under as applicable and the amended provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000. This electronic record is generated by a computer system and does not require any physical or digital signatures.

This document is published in accordance with the provisions of Rule 3 (1) of the Information Technology (Intermediaries guidelines) Rules, 2011 that require publishing the rules and regulations, privacy policy and Terms of Use for access or use of www.Shree Book Centre.com website.

Your use of the Website and services and tools are governed by the following terms and conditions ("Terms of Use") as applicable to the Website including the applicable policies which are incorporated herein by way of reference. If You transact with the Website, You shall be subject to the policies that are applicable to the Website for such transaction. By mere use of the Website, You shall be contracting with the Shree Book Centre and these terms and conditions, including the policies constitute Your binding obligations, with the Shree Book Centre.

For the purpose of these Terms of Use, wherever the context so requires "You" or "User" shall mean any natural or legal person who has agreed to become a buyer on the Website by providing Registration Data while registering on the Website as Registered User using the computer systems. Shree Book Centre allows the User to surf the Website or making purchases on the Website. The term "We", "Us", "Our" shall mean Shree Book Centre.

When You use any of the services provided by Us through the Website. You will be subject to the rules, guidelines, policies, terms, and conditions applicable to such service, and they shall be deemed to be incorporated into these Terms of Use and shall be considered as part and parcel of these Terms of Use. We reserve the right, at Our sole discretion, to change, modify, add or remove portions of these Terms of Use, at any time without any prior writien notice to You. It is Your responsibility to review these Terms of Use periodically for updates / changes. Your continued use of the Website following the posting of changes will mean that You accept and agree to the revisions. As long as You comply with these Terms of Use, We grant You a personal, non-exclusive, non-transferable, limited privilege to enter and use the Website.

ACCESSING, BROWSING OR OTHERWISE USING THE SITE INDICATES YOUR AGREEMENT TO ALL THE TERMS AND CONDITIONS UNDER THESE TERMS OF USE, SO PLEASE READ THE TERMS OF USE CAREFULLY BEFORE PROCEEDING. By impliedly or expressly accepting these Terms of Use, You also accept and agree to be bound by Shree Book Centre Policies as amended from time to time.

Membership Eligibility

Use of the Website is available only to persons who can form legally binding contracts under the Indian Contract Act, 1872. Persons who are "incompetent to contract" within the meaning of the Indian Contract Act, 1872 including minors, un-discharged insolvents etc. Are not eligible to use the Website. If you are a minor i.e. Under the age of 18 years, you shall not register as a User of the Shree Book Centre website and shall not transact on or use the website. As a minor if you wish to use or transact on the website, such use or transaction may be made by your legal guardian or parents on the Web site. The Shree Book Centre reserves the right to terminate your membership and / or refuse to provide you with access to the Website if it is brought to Shree Book Centre's notice or if it is discovered that you are under the age of 18 years.

Your Account and Registration Obligations

If You use the Website, You shall be responsible for maintaining the confidentiality of your Display Name and Password and You shall be responsible for all activities that occur under your Display Name and Password. You agree that if You provide any information that is untrue, inaccurate, not current or incomplete, or We have reasonable grounds to suspect that such information is untrue, inaccurate, not current or incomplete, or not in accordance with the this Terms of Use, We shall have the right to indefinitely suspend or terminate or block access of your membership to the Website and refuse to provide You with access to the Website.

Communications

When You use the Website or send e-mails or other data, information or communication to us, You agree and understand that You are communicating with Us through electronic records and You consent to receive communications via electronic records from Us periodically and as and when required. We may communicate with you by e-mail or by such other mode of communication, electronic or otherwise.

Charges

Membership of the Website is free for buyers. The Shree Book Centre does not charge any fee for browsing and buying on the Website. The Shree Book Centre reserves the right to change its Fee Policy from time to time. In particular, the Shree Book Centre may, at its sole discretion introduce new services and modify some or all of the existing services offered on the Website. In such an event Shree Book Centre reserves the right to introduce fees for the new services offered or amend/introduce fees for existing services, as the case may be. Changes to the Fee Policy shall be posted on the Website and such changes shall automatically become effective immediately after they are posted on the Website. Unless otherwise stated, all fees shall be quoted in Indian Rupees. You shall be solely responsible for compliance with all applicable laws, including those in India for making payments to the Shree Book Centre.

Use of the Website

You agree, undertake and confirm that Your use of the Website shall be strictly governed by the following binding principles:

1. You shall not host, display, upload, modify, publish, transmit, update or share any information which:

    (a) Belongs to another person and to which You do not have any right to;

    (b) Is grossly harmful, harassing, blasphemous, defamatory, obscene, pornographic, paedophilic, libelous, invasive of another's privacy, hateful, or racially, ethnically objectionable, disparaging, relating or encouraging money laundering or gambling, or otherwise unlawful in any manner whatever; or unlawfully threatening or unlawfully harassing, including but not limited to "indecent representation of women" within the meaning of the Indecent Representation of Women (Prohibition) Act, 1986;

    (c) Is misleading in any way;

    (d) Is patently offensive to the online community, such as sexually explicit content, or content that promotes obscenity, pedophilia, racism, bigotry, hatred or physical harm of any kind against any group or individual;

    (e) Harasses or advocates harassment of another person;

    (f) Involves the transmission of "junk mail", "chain letters", or unsolicited mass mailing or "spamming";

    (g) Promotes illegal activities or conduct that is abusive, threatening, obscene, defamatory or libellous;

    (h) Infringes upon or violates any third party's rights [including, but not limited to, intellectual property rights, rights of privacy (including, without limitation, unauthorized disclosure of a person's name, e-mail address, physical address or phone number) or rights of publicity];

    (i) Promotes an illegal or unauthorized copy of another person's copyrighted work (see "Copyright complaint" below for instructions on how to lodge a complaint about uploaded copyrighted material), such as providing pirated computer programs or links to them, providing information to circumvent manufacture-installed copy protect devices, or providing pirated music or links to pirated music files;

    (j) Contains restricted or password-only access pages, or hidden pages or images (those not linked to or from another accessible page);

    (k) Provides material that exploits people in a sexual, violent or otherwise inappropriate manner or solicits personal information from anyone;

    (l) Provides instructional information about illegal activities such as making or buying illegal weapons, violating someone's privacy, or providing or creating computer viruses;

    (m) Contains video, photographs, or images of another person (with a minor or an adult).

    (n) Tries to gain unauthorized access or exceeds the scope of authorized access to the Website or to profiles, blogs, communities, account information, bulletins, friend request, or other areas of the Website or solicits passwords or personal identifying information for commercial or unlawful purposes from other users;

    (o) Engages in commercial activities and/or sales without Our prior written consent such as contests, sweepstakes, barter, advertising, and pyramid schemes, or the buying or selling of "virtual" products related to the Website. Throughout these Terms of Use, Shree Book Centre's prior written consent means a communication coming from Shree Book Centre's Legal Department, specifically in response to Your request, and specifically addressing the activity or conduct for which You seek authorization;

    (p) Solicits gambling or engages in any gambling activity which We, in Our sole discretion, believes is or could be construed as being illegal;

    (q) Interferes with another USER's use and enjoyment of the Website or any other individual's User and enjoyment of similar services;

    (r) Refers to any website or URL that, in Our sole discretion, contains material that is inappropriate for the Website or any other website, contains content that would be prohibited or violates the letter or spirit of these Terms of Use.

    (s) Harm minors in any way;

    (t) Infringes any patent, trademark, copyright or other proprietary rights or third party's trade secrets or rights of publicity or privacy or shall not be fraudulent or involve the sale of counterfeit or stolen products;

    (u) Violates any law for the time being in force;

    (v) Deceives or misleads the addressee/ users about the origin of such messages or communicates any information which is grossly offensive or menacing in nature;

    (w) Impersonate another person;

    (x) Contains software viruses or any other computer code, files or programs designed to interrupt, destroy or limit the functionality of any computer resource; or contains any trojan horses, worms, time bombs, cancelbots, Easter eggs or other computer programming routines that may damage, detrimentally interfere with, diminish the value of, surreptitiously intercept or expropriate any system, data or personal information;

    (y) Threatens the unity, integrity, defence, security or sovereignty of India, friendly relations with foreign states, or public order or causes incitement to the commission of any cognizable offense or prevents investigation of any offense or is insulting any other nation.

    (z) Shall not be false, inaccurate or misleading; (aa) Shall not, directly or indirectly, offer, attempt to offer, trade or attempt to trade in any item, the dealing of which is prohibited or restricted in any manner under the provisions of any applicable law, rule, regulation or guideline for the time being in force.

    (ab) Shall not create liability for Us or cause Us to lose (in whole or in part) the services of Our internet service provider ("ISPs") or other suppliers;

2. You shall not use any "deep-link", "page-scrape", "robot", "spider" or other automatic device, program, algorithm or methodology, or any similar or equivalent manual process, to access, acquire, copy or monitor any portion of the Website or any Content, or in any way reproduce or circumvent the navigational structure or presentation of the Website or any Content, to obtain or attempt to obtain any materials, documents or information through any means not purposely made available through the Website. We reserve Our right to bar any such activity.

3. You shall not attempt to gain unauthorized access to any portion or feature of the Website, or any other systems or networks connected to the Website or to any server, computer, network, or to any of the services offered on or through the Website, by hacking, password "mining" or any other illegitimate means.

4. You shall not probe, scan or test the vulnerability of the Website or any network connected to the Website, nor breach the security or authentication measures on the Website or any network connected to the Website.

5. You shall not make any negative, denigrating or defamatory statement(s) or comment(s) about Us or the brand name or domain name used by Us, including the terms Shree Book Centre, Shree Book Centre.com, or otherwise engage in any conduct or action that might tarnish the image or reputation, of Shree Book Centre on platform or otherwise tarnish or dilute any Shree Book Centre's trade or service marks, trade name and/or goodwill associated with such trade or service marks, trade name as may be owned or used by us. You agree that You will not take any action that imposes an unreasonable or disproportionately large load on the infrastructure of the Website or Shree Book Centre's systems or networks, or any systems or networks connected to the Shree Book Centre.

6. You agree not to use any device, software or routine to interfere or attempt to interfere with the proper working of the Website or any transaction being conducted on the Website, or with any other person's use of the Website.

7. You may not forge headers or otherwise manipulate identifiers in order to disguise the origin of any message or transmittal You send to Us on or through the Website or any service offered on or through the Website. You may not pretend that You are, or that You represent, someone else, or impersonate any other individual or entity.

8. You may not use the Website or any content for any purpose that is unlawful or prohibited by these Terms of Use, or to solicit the performance of any illegal activity or other activity which infringes the rights of the Shree Book Centre and / or others.

9. You shall at all times ensure full compliance with the applicable provisions of the Information Technology Act, 2000 and rules thereunder as applicable and as amended from time to time and also all applicable Domestic laws, rules and regulations (including the provisions of any applicable Exchange Control Laws or Regulations in Force) and International Laws, Foreign Exchange Laws, Statutes, Ordinances and Regulations (including, but not limited to Sales Tax/VAT, Income Tax, Octroi, Service Tax, Central Excise, Custom Duty, Local Levies) regarding Your use of Our service and Your listing, purchase, solicitation of offers to purchase, and sale of products or services. You shall not engage in any transaction in an item or service, which is prohibited by the provisions of any applicable law including exchange control laws or regulations for the time being in force.

10. Solely to enable Us to use the information You supply Us with, so that we are not violating any rights You might have in Your Information, You agree to grant Us a non-exclusive, worldwide, perpetual, irrevocable, royalty-free, sub-licensable (through multiple tiers) right to exercise the copyright, publicity, database rights or any other rights You have in Your Information, in any media now known or not currently known, with respect to Your Information. We will only use Your information in accordance with the Terms of Use and Privacy Policy applicable to use of the Website.

11. The Shree Book Centre shall have all the rights to take necessary action and claim damages that may occur due to your involvement/participation in any way on your own or through a group/s of people, intentionally or unintentionally in a DOS / DDoS (Distributed Denial of Services).

Contents Posted on Site

Except as expressly provided in these Terms of Use, no part of the Website and no Content may be copied, reproduced, republished, uploaded, posted, publicly displayed, encoded, translated, transmitted or distributed in any way (including "mirroring") to any other computer, server, Web site or other medium for publication or distribution or for any commercial enterprise, without Shree Book Centre's express prior written consent.

You may use information on the products purposely made available on the Website for downloading, provided that You

(1) do not remove any proprietary notice language in all copies of such documents,

(2) use such information only for your personal, non-commercial informational purpose and do not copy or post such information on any networked computer or broadcast it in any media,

(3) make no modifications to any such information, and

(4) do not make any additional representations or warranties relating to such documents.

You shall be responsible for any notes, messages, e-mails, opinions, ideas, information posted or transmitted to the Website (collectively, "Content"). Such Content will become Our property and You grant Us the worldwide, perpetual and transferable rights in such Content. We shall be entitled to, consistent with Our Privacy Policy, as adopted in accordance with applicable law, use the Content or any of its elements for any type of use forever, including but not limited to promotional and advertising purposes and in any media whether now known or hereafter devised, including the creation of derivative works that may include the Content You provide. You agree that any Content You post may be used by us, consistent with Our Privacy Policy and Rules of Conduct on Site as mentioned herein, and You are not entitled to any payment or other compensation for such use.

Privacy

We view protection of Your privacy as a very important principle. We understand clearly that You and Your Personal Information is one of Our most important assets. We store and process Your Information, including any sensitive financial information collected (as defined under the Information Technology Act, 2000), if any, on computers that may be protected by physical as well as reasonable technological security measures and procedures in accordance with Information Technology Act 2000 and Rules there under.. If You object to Your Information being transferred or used in this way please do not use the Website.

Disclaimer of Warranties and Liability

This Web site, all the materials and products (including but not limited to software) and services, included on or otherwise made available to You through this site are provided on "as is" and "as available" basis without any representation or warranties, express or implied except otherwise specified in writing. Without prejudice to the foregoing paragraph, the Shree Book Centre does not warrant that:

• This Website will be constantly available, or available at all; or

• The information on this Website is complete, true, accurate or non-misleading.

The Shree Book Centre will not be liable to You in any way or in relation to the Contents of, or use of, or otherwise in connection with, the Website. Shree Book Centre does not warrant that this site; information, Content, materials, product included on or otherwise made available to You through the Website; their servers; or electronic communication sent from Us are free of viruses or other harmful components.

Nothing on the Website constitutes, or is meant to constitute, advice of any kind. All the Products sold on the Website are governed by different state laws and if we are unable to deliver such Products due to the implications of different state laws, we will return or will give credit for the amount (if any) received in advance by us from the sale of such Product that could not be delivered to You. You will be required to enter a valid phone number while registering on the Website. By registering Your phone number with us, You consent to be contacted by Us via phone calls and/or SMS notifications, in case of any order or shipment or delivery related updates. We will not use your personal information to initiate any promotional phone calls or SMS.

Services Payment

While availing any of the payment method/s available on the Website, we will not be responsible or assume any liability, whatsoever in respect of any loss or damage arising directly or indirectly to You due to:

1. Lack of authorization for any transaction/s, or

2. Exceeding the present limit mutually agreed by You and between "Bank/s", or

3. Any payment issues arising out of the transaction, or

4. Decline of transaction for any other reason/s

All payments made against the purchases on the Website by you shall be compulsorily in Indian Rupees acceptable in the Republic of India. The website will not facilitate transactions with respect to any other form of currency with respect to the purchases made on the Website.

Further:

1. Transactions, Transaction Price and all commercial terms such as Delivery, Dispatch of products and/or services are as per principal to principal bipartite contractual obligations between Buyer and Seller and payment facility is merely used by the Buyer and Seller to facilitate the completion of the Transaction. Use of the payment facility shall not render Shree Book Centre liable or responsible for the non-delivery, non-receipt, non-payment, damage, breach of representations and warranties, non-provision of after sales or warranty services or fraud as regards the products and /or services listed on Shree Book Centre's Website.

2. You have specifically authorized Shree Book Centre or its service providers to collect, process, facilitate and remit payments and / or the Transaction Price electronically or through Cash on Delivery to and from other Users in respect of transactions through Payment Facility. Your relationship with Shree Book Centre is on a principal to principal basis and by accepting these Terms of Use you agree that Shree Book Centre is an independent contractor for all purposes, and does not have control of or liability for the products or services that are listed on Shree Book Centre's Website that are paid for by using the Payment Facility. Shree Book Centre does not guarantee the identity of any User nor does it ensure that a Buyer or a Seller will complete a transaction.

3. You understand, accept and agree that the payment facility provided by Shree Book Centre is neither a banking nor financial service but is merely a facilitator providing an electronic, automated online electronic payment, receiving payment through Cash On Delivery, collection and remittance facility for the Transactions on the Shree Book Centre Website using the existing authorized banking infrastructure and Credit Card payment gateway networks. Further, by providing Payment Facility, Shree Book Centre is neither acting as trustees nor acting in a fiduciary capacity with respect to the Transaction or the Transaction Price.

Payment Facility for Buyers:

    • You, as a Buyer, understand that upon initiating a Transaction You are entering into a legally binding and enforceable contract with us to purchase the products from us using the Payment Facility, and You shall pay the Transaction Price through Your Issuing Bank using Payment Facility.

    • You, as a Buyer, may agree with us through electronic communication and electronic records and using the automated features as may be provided by Payment Facility on any extension / increase in the Dispatch and/or Delivery time and the Transaction shall stand amended to such extent. Any such extension / increase of Dispatch / Delivery time or subsequent novation / variation of the Transaction should be in compliance with Payment Facility Rules and Policies.

    • You, as a Buyer, shall electronically notify Payment Facility using the appropriate Shree Book Centre Website features immediately upon Delivery or non Delivery within the time period as provided in Policies. Non notification by You of Delivery or non Delivery within the time period specified in the Policies shall be construed as a deemed Delivery in respect of that Transaction. In case of Cash On Delivery transactions, Buyer is not required to confirm the receipt of products.

    • You, as a Buyer, shall be entitled to claim a refund of the Transaction Price (as Your sole and exclusive remedy) in case You do not receive the Delivery within the time period agreed in the Transaction or within the time period as provided in the Policies, whichever is earlier. In case you do not raise a refund claim using Website features within the stipulated time than this would make You ineligible for a refund.

    • You, as a Buyer, understand that the Payment Facility may not be available in full or in part for certain category of products and/or Transactions as mentioned in the Policies and hence You may not be entitled to a refund in respect of the Transactions for those products

    • Refund shall be made in Indian Rupees only and shall be equivalent to the Transaction Price received in Indian Rupees.

    • For electronics payments, refund shall be made through payment facility using NEFT / RTGS or any other online banking / electronic funds transfer system approved by Reserve Bank India (RBI).

    • Refund shall be conditional and shall be with recourse available to Shree Book Centre in case of any misuse by Buyer.

    • Refund shall be subject to Buyer complying with Policies.

4. Shree Book Centre reserves the right to impose limits on the number of Transactions or Transaction Price which Shree Book Centre may receive from on an individual Valid Credit/Debit/ Cash Card / Valid Bank Account/ and such other infrastructure or any other financial instrument directly or indirectly through payment aggregator or through any such facility authorized by Reserve Bank of India to provide enabling support facility for collection and remittance of payment or by an individual Buyer during any time period, and reserves the right to refuse to process Transactions exceeding such limit.

5. Shree Book Centre reserves the right to refuse to process Transactions by Buyers with a prior history of questionable charges including without limitation breach of any agreements by Buyer with Shree Book Centre or breach/violation of any law or any charges imposed by Issuing Bank or breach of any policy. Compliance with Laws:

6. Buyer shall comply with all the applicable laws (including without limitation Foreign Exchange Management Act, 1999 and the rules made and notifications issued thereunder and the Exchange Control Manual as may be issued by Reserve Bank of India from time to time, Customs Act, Information and Technology Act, 2000 as amended by the Information Technology (Amendment) Act 2008, Prevention of Money Laundering Act, 2002 and the rules made there under, Foreign Contribution Regulation Act, 1976 and the rules made there under, Income Tax Act, 1961 and the rules made there under, Export Import Policy of government of India) applicable to them respectively for using Payment Facility and Shree Book Centre Website. Buyer's arrangement with Issuing Bank:

7. All Valid Credit / Debit/ Cash Card/ and other payment instruments are processed using a Credit Card payment gateway or appropriate payment system infrastructure and the same will also be governed by the terms and conditions agreed to between the Buyer and the respective Issuing Bank and payment instrument issuing company. 8. All Online Bank Transfers from Valid Bank Accounts are processed using the gateway provided by the respective Issuing Bank which support Payment Facility to provide these services to the Users. All such Online Bank Transfers on Payment Facility are also governed by the terms and conditions agreed to between Buyer and the respective Issuing Bank.

Indemnity

You shall indemnify and hold harmless Shree Book Centre, its owner, licensee, affiliates, subsidiaries, group companies (as applicable) and their respective officers, directors, agents, and employees, from any claim or demand, or actions including reasonable attorneys' fees, made by any third party or penalty imposed due to or arising out of Your breach of this Terms of Use, privacy Policy and other Policies, or Your violation of any law, rules or regulations or the rights (including infringement of intellectual property rights) of a third party.

Note

Prices may change Without Prior Notice or may vary due to market conditions. Books availability are subject to their availability in stock.

Applicable Law

Terms of Use shall be governed by and interpreted and construed in accordance with the laws of India. The place of jurisdiction shall be exclusively in Mumbai.

TERMS AND CONDITIONS

This document is an electronic record in terms of Information Technology Act, 2000 and Rules there under as applicable and the amended provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000. This electronic record is generated by a computer system and does not require any physical or digital signatures. This document is published in accordance with the provisions of Rule 3 (1) of the Information Technology (Intermediaries guidelines) Rules, 2011 that require publishing the rules and regulations, privacy policy and Terms of Use for access or usage of www.shreebookcentre.com website. The domain name www.shreebookcentre.com (hereinafter referred to as "Website") is owned by M/s Shree Book Centre, a partnership firm registered under the provisions of the Indian Partnership Act 1932 having its office at 8, Kakad Industrial Estate, S. Keer Marg, Off. L.J. Road, Matunga (West), Mumbai – 400016. India. (“SBC").

TERMS OF USE

 Please read the following Terms and Conditions of use carefully before using this Website. By using and/or visiting this website “www.shreebookcentre.com”, (collectively, including all content available through the www.shreebookcentre.com--domain name, Shree Book Centre or the “Website”,) you signify your assent to both these terms and conditions (“Terms of Use”) and the terms and conditions of the Website’s Privacy Policy, which are published, and which are incorporated herein for reference. If you continue to browse and use this Website you are agreeing to comply with and be bound by the following Terms of Use, which together with our Privacy policy govern SBC’s relationship with you in relation to this Website. If you do not agree to these Terms of Use, you are not entitled to use the Website and any use thereafter shall be unauthorized.

The Content on the Websites, except all User Submissions (as defined below), including without limitation, the text, software, scripts, graphics, photos, sounds, music, videos, interactive features and the like; and the trademarks, service marks and logos contained therein (“Marks”), are owned by or licensed to SBC, subject to copyright and other intellectual property rights under Indian laws and conventions. Content on the Website is provided to you “AS IS” and “AS AVAILABLE” for your information and personal use only and may not be used, copied, reproduced, distributed, transmitted, broadcast, displayed, sold, licensed, or otherwise exploited for any other purposes whatsoever without the prior written consent of the respective owners and Website. SBC reserves all rights, which are not expressly granted in and to the Website and the Content. You agree not to engage in the use, copying, or distribution of any of the Content other than expressly permitted herein, including any use, copying, or distribution of User Submissions of third parties obtained through the Website for any commercial purposes. You agree not to circumvent, disable or otherwise interfere with security related features of the Website or features that prevent or restrict use or copying of any Content or enforce limitations on use of the Website or the Content therein.

The Website including the services provided on the Website are for the personal use of members only and may not be used in connection with any commercial endeavors except those that are specifically endorsed or approved by the Website. Illegal and/or unauthorized use of the Website, including collecting usernames and/or email addresses of Users by electronic or other means for the purpose of sending unsolicited email or unauthorized framing of or linking to the Website is prohibited. Commercial advertisements, affiliate links, and other forms of solicitation may be removed from User profiles without notice and may result in termination of membership privileges. Appropriate legal action will be taken for any illegal or unauthorized use of the Website’s service.

ORDERING AND REGISTERING

In order to access some features of the Website, you will have to create an account. You may never use another User's account without permission. When creating your account, you must provide accurate and complete information regarding your personal data. You are solely responsible for the activity that occurs on your account, and you must keep your account password secure and not share the same with any third party. You are solely responsible for maintaining the confidentiality of your password, and agree not to transfer your use of or access to the Website or services to any third party. You are fully responsible for all the activities that occur under your password or your user name, including, without limitation, purchases. You agree to (a) immediately notify us of any unauthorized use of your password or user name or any other breach of security, and (b) ensure that you exit from your account at the end of each session. We are not liable for any loss or damage arising from your failure to comply with all of the foregoing obligations. You agree to notify the Website immediately of any breach of security or unauthorized use of your account by any party that is not you. Although the Website will not be liable for your losses caused by any unauthorized use of your account, you may be liable for the losses of Website and/or Company or others due to such unauthorized use and agree to indemnify the Website and/or Company against such losses. In consideration of your use of the Website and services provided by the Website, you agree, where information is requested, to provide true, accurate, current, and complete information about yourself, and to maintain and update it promptly. You agree that if any information you provide is false, inaccurate, not current, or incomplete, we may terminate your use of the Website and/or the services.

We reserve the right at any time to: change the terms of this Agreement; change the services, including eliminating or modifying any content on or feature of the Website; or change/charge any fees or charges for use of the services on the Website. Any changes we make will be effective immediately on Notice, which we may give either by posting the new Agreement on the Website or via electronic mail. Your use of the services after such Notice will be deemed acceptance of such changes.

Be sure to review this Agreement periodically to ensure your familiarity with the most current version. You will always be able to tell when the version was last updated by checking the "Last Revised" date in the header of this Agreement.

Shree Book Centre is committed to providing exceptional customer service and quality products. We endeavor to make sure that all products listed on our website are currently in stock and pricing is true and correct. Standard delivery time frames within India are between 7-14 days. In the event that an order item is not available or has gone to backorder, we will notify you on your invoice.

Export customers will be notified within 4-6 business days regarding a freight fee in addition to the cost of the order.

We will replace the book or give you credit, at our discretion, if the book you purchased is lost or damaged in transit, is faulty, or is significantly different to the one shown on the Website. Please allow 7-14 days for delivery depending on location, but take into account that it may take longer for us to deliver books in some circumstances outside our control, such as natural disasters or transport disruptions.

Please wrap the items securely to return them, with your order number on the address lable to:

Shree Book Centre, 8, Kakad Industrial Estate, S.Keer Marg, Off L. J. Road, Matunga (W), Mumbai 400016. Maharashtra. India. Your Shree Book Centre online order number must be included in the parcel.

Please also include your name, telephone number, and address, plus a note explaining, your reason for return of the item. For further information on the same, please call our customer service on +91 22 24377516 or write to us on Shree Book Centre, 8, Kakad Industrial Estate, S.Keer Marg, Off L. J. Road, Matunga (W), Mumbai 400016. Maharashtra. India.

We take security seriously and process all financial details using industry standard encryption. We also adhere to cardholder information security program (CISP) and payment card industry data security standard (PCI) specifications to ensure the protection of any credit card details handled by our Website.

Depending on where you transact with us, the type of payment method used and where your payment method was issued, your transaction with us may be subject to foreign exchange fees or differences in prices, including because of exchange rates. We do not support all payment methods, currencies or locations for payment.

Whilst every effort is made to ensure accuracy of prices and availability of the titles featured on this Website, this cannot be guaranteed and price and availability information may change without notice.

USER OBLIGATIONS

If Website allows You to post and upload any material on the Website, You hereby undertake to ensure that such material is not offensive and in accordance with applicable laws. Further, You undertake not to:

Defame, abuse, harass, threaten or otherwise violate the legal rights of users and/or others;

Impersonate any person or entity, or falsely state or otherwise misrepresent Your affiliation with a person or entity;

Publish, post, upload, distribute or disseminate any inappropriate, profane, defamatory, infringing, obscene, indecent or unlawful topic, name, material or information through any bookmark, tag or keyword;

Upload files that contain software or other material protected by applicable intellectual property laws unless You own or control the rights thereto or have received all necessary consents;

Upload or distribute files that contain viruses, corrupted files, or any other similar software or programs that may damage the operation of the Website or another's computer;

Engage in any activity that interferes with or disrupts access to the Website or the Services (or the servers and networks which are connected to the Website);

Attempt to gain unauthorized access to any portion or feature of the Website, any other systems or networks connected to the Website, to any SBC server, or to any of the Services offered on or through the Website, by hacking, password mining or any other illegitimate means;

Probe, scan or test the vulnerability of the Website or any network connected to the Website, nor breach the security or authentication measures on the Website or any network connected to the Website. You may not reverse look-up, trace or seek to trace any information on any other user, of or visitor to, the Website, or any other customer of SBC including any SBC Account not owned by You, to its source, or exploit the Website or Service or information made available or offered by or through the Website, in any way whether or not the purpose is to reveal any information, including but not limited to personal identification information, other than Your own information, as provided for by the Website;

Disrupt or interfere with the security of, or otherwise cause harm to, the Website, systems resources, accounts, passwords, servers or networks connected to or accessible through the Websites or any affiliated or linked sites;

Collect or store data about other users in connection with the prohibited conduct and activities set forth in this Section.

Use any device or software to interfere or attempt to interfere with the proper working of the Website or any transaction being conducted on the Website, or with any other person's use of the Website;

Use the Website or any material or Content for any purpose that is unlawful or prohibited by these Terms of Use, or to solicit the performance of any illegal activity or other activity which infringes the rights of SBC or other third parties;

Conduct or forward surveys, contests, pyramid schemes or chain letters, including any marketing or promotion activities of any manner; Download any file posted by another user of a Service that you know, or reasonably should know, cannot be legally distributed in such manner; Falsify or delete any author attributions, legal or other proper notices or proprietary designations or labels of the origin or source of software or other material contained in a file that is uploaded;

Violate any code of conduct or other guidelines, which may be applicable for or to any particular Service; Violate any applicable laws or regulations for the time being in force within or outside India;

Reverse engineer, modify, copy, distribute, transmit, display, perform, reproduce, publish, license, create derivative works from, transfer, or sell any information or software obtained from the Website.

You agree that You are solely responsible to SBC and to any third party for any breach of Your obligations under the Terms of Use and for the consequences (including any loss or damage which SBC or its affiliates or its vendors may suffer) for any such breach.

MEMBERSHIP ELIGIBILITY

Use of the Website is available only to persons who can form legally binding contracts under Indian Contract Act, 1872. Persons who are "incompetent to contract" within the meaning of the Indian Contract Act, 1872 including minors, un-discharged insolvents etc. are not eligible to use the Website. If you are a minor i.e. under the age of 18 years, you shall not register as a User of the Website and shall not transact on or use the website. As a minor if you wish to use or transact on website, such use or transaction may be made by your legal guardian or parents on the Website. SBC reserves the right to terminate your membership and / or refuse to provide you with access to the Website if it is brought to SBC's notice or if it is discovered that you are under the age of 18 years.

INTELLECTUAL PROPERTY RIGHTS

The Website and the processes, and their selection and arrangement, including but not limited to all text, graphics, user interfaces, visual interfaces, sounds and music (if any), artwork and computer code (collectively, the "Content") on the Website is owned and controlled by SBC and the design, structure, selection, coordination, expression, look and feel and arrangement of such Content is protected by copyright, patent and trademark laws, and various other intellectual property rights.

The trademarks, logos and service marks displayed on the Website ("Marks") are the property of SBC or their vendors or respective third parties. You are not permitted to use the Marks without the prior consent of SBC, the vendor or the third party that may own the Marks.

Unless otherwise indicated or anything contained to the contrary or any proprietary material owned by a third party and so expressly mentioned, SBC owns all intellectual property rights to and into the trademark "Shree Book Centre", and the Website, including, without limitation, any and all rights, title and interest in and to copyright, related rights, patents, utility models, designs, know-how, trade secrets and inventions (patent pending), goodwill, source code, meta tags, databases, text, content, graphics, icons, and hyperlinks.

Except as expressly provided herein, You acknowledge and agree that You shall not copy, republish, post, display, translate, transmit, reproduce or distribute any Content through any medium without obtaining the necessary authorization from SBC or thirty party owner of such Content.

SUPPORT

If you have any questions, complaints or claims with respect to the Website then such correspondence should be directed to the address as given below.

Shree Book Centre: The contact information: Shree Book Centre, 8, Kakad Industrial Estate, S.Keer Marg, Off L. J. Road, Matunga (W), Mumbai 400016. Maharashtra. India. +91 22 24377516. sales@shreebookcentre.com

DISCLAIMER OF WARRANTIES

You agree that use of the services is at Your own risk. The services including the Website, the Content, User Material, any third party links, or any other website links, other new media initiatives endorsed by Website and contents therein and any other materials contained on or provided through the Website are provided “AS IS” and “AS AVAILABLE” basis, to the fullest extent permitted by law, are provided without warranties of any kind, either express or implied. Without limiting the foregoing, Website does not make any warranties of fitness for a particular purpose, title, merchantability, completeness, availability, security, compatibility or non-infringement; or that the services will be uninterrupted, free of viruses and other harmful components, accurate, error free or reliable.

LIMITATION OF LIABILITY

IN NO CASE SHALL COMPANY/WEBSITE, ITS DIRECTORS, OFFICERS, EMPLOYEES, AFFILIATES, AGENTS, CONTRACTORS, PRINCIPALS, OR LICENSORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, PUNITIVE, SPECIAL, OR CONSEQUENTIAL DAMAGES ARISING FROM YOUR USE OF THE SERVICES OR ANY CONTENT OR MATERIAL THEREOF OR FOR ANY OTHER CLAIM RELATED IN ANY WAY TO YOUR USE OF THE SERVICES OR ANY CONTENT OR MATERIAL THEREOF, INCLUDING, BUT NOT LIMITED TO, ANY ERRORS OR OMISSIONS IN ANY CONTENT OR MATERIAL, OR ANY LOSS OR DAMAGE OF ANY KIND INCURRED AS A RESULT OF THE USE OF THE SERVICES OR ANY CONTENT OR MATERIAL THEREOF, EVEN IF ADVISED OF THEIR POSSIBILITY. WHERE THE LAWS DO NOT ALLOW THE EXCLUSION OR THE LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, IN SUCH JURISDICTIONS, SHREE BOOK CENTRE'S LIABILITY SHALL BE LIMITED TO THE EXTENT PERMITTED BY LAW.

There is no guarantee that the Site will be free of infection by viruses or anything else which may be harmful or destructive.

To the extent permitted by law, SBC hereby disclaims all liability (howsoever arising) in connection with any loss and/or damage, arising out of or in connection with any use of, or inability to use, all or any part of the Content, the Website and/or any website to which the Site is linked, or any action taken (or refrained from being taken) as a result of using any of these.

LINKS TO THIRD PARTY WEB SITES

The Website may include links to third party internet websites which are controlled and maintained by others. These links are included solely for the convenience of users and do not constitute any endorsement by SBC of the sites linked or referred to, nor does SBC have any control over the content of any such sites.

INDEMNITY

You agree to defend, indemnify and hold harmless the Website, its affiliates, officers, directors, employees and agents, from and against any and all claims, damages, obligations, losses, liabilities, costs or debt, and expenses (including but not limited to attorney's fees) arising from: (i) Your use of and access to the services; (ii) Your violation of any term of these Terms of Use ; (iii) Your violation of any third party right, including without limitation any copyright, property, or privacy right; and (iv) Your breach of any applicable laws. This indemnification obligation will survive the expiry or termination of Terms of Use and Your use of the service.

ENTIRE AGREEMENT

These Terms and Conditions and Privacy Policy constitute the entire agreement between You and Shree Book Centre governing Your use of the Services, superseding any prior agreements between You and Shree Book Centre regarding such use.

SEVERABILITY

If any provision of these Terms and Conditions is held invalid, void, or unenforceable, then that provision shall be considered severable from the remaining provisions, and the remaining provisions given full force and effect.

PRIVACY POLICY

At SBC we recognise the importance of protecting the personal information of our customers. We do not give out any personal information nor do we participate in reselling lists.

When you purchase publications from www.shreebookcentre.com we require certain personal Information to ensure that we fulfil your shopping requirements. We do not provide this information to third parties, but reserve the right to contact you in case we require any additional information about your order or to clarify details about your order.

When you sign up for our e-mail services we require certain personal information to enable us to provide you with personalized information about our new products, special proposals or information about our new services. To unsubscribe please contact us at:

sales@shreebookcentre.com

We reserve the right to change our policy at any time and any changes shall be displayed on our Privacy Policy page. For any clarifications please contact us by phone at +91 22 24377516 or email at sales@shreebookcentre.com GOVERNING LAW

The relationship between You and Shree Book Centre/Website shall be governed by the laws of India without regard to its conflict of law provisions and for resolution of any dispute arising out of Your use of the Services. Notwithstanding the foregoing, You agree that the Website has the right to bring any proceedings before any court/forum of competent jurisdiction and You irrevocably submit to the jurisdiction of such courts or forum.

Queries: 259, Total time: 591.978 ms [By time] [By id] [By file]
1 (0.370)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/openbay.php:117
2 (0.248)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://shreebookcentre.com/'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/controller/startup/startup.php:8
3 (1.474)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/controller/startup/startup.php:25
4 (0.244)
SELECT *
FROM oc_currency
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/currency.php:10
5 (0.702)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '2' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1493')
ORDER BY tr1.priority ASC
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/system/library/cart/tax.php:23
6 (0.301)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '2' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1493')
ORDER BY tr1.priority ASC
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/system/library/cart/tax.php:51
7 (0.313)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/weight.php:10
8 (0.264)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/length.php:10
9 (0.267)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:15
10 (0.177)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/openbay.php:117
11 (0.282)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/extension/event.php:4
12 (0.221)
SELECT *
FROM oc_url_alias
WHERE keyword = 'terms-conditions'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:29
13 (0.173)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/home'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
14 (0.453)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:4
15 (0.138)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
16 (0.222)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
17 (0.127)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/home'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
18 (0.181)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '5' AND store_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:16
19 (0.236)
SELECT *
FROM oc_layout_route
WHERE 'information/information' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:4
20 (0.187)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'column_left'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
21 (0.145)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/register'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
22 (0.128)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/login'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
23 (0.136)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/logout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
24 (0.158)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/forgotten'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
25 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
26 (0.143)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/edit'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
27 (0.141)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/password'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
28 (0.207)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/address'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
29 (0.171)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/wishlist'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
30 (0.156)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/order'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
31 (0.140)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/download'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
32 (0.659)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/reward'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
33 (0.277)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/return'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
34 (0.279)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/transaction'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
35 (0.147)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/newsletter'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
36 (0.149)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/recurring'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
37 (0.251)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '5' AND store_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:16
38 (0.200)
SELECT *
FROM oc_layout_route
WHERE 'information/information' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:4
39 (0.153)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'column_right'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
40 (0.144)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '5' AND store_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:16
41 (0.152)
SELECT *
FROM oc_layout_route
WHERE 'information/information' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:4
42 (0.183)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'content_top'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
43 (0.159)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '5' AND store_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:16
44 (0.159)
SELECT *
FROM oc_layout_route
WHERE 'information/information' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:4
45 (0.168)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
46 (0.147)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '5' AND store_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:16
47 (0.173)
SELECT *
FROM oc_layout_route
WHERE 'information/information' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:4
48 (0.150)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/themecontrol.php:22
49 (0.184)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/register'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
50 (0.149)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/login'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
51 (0.136)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/logout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
52 (0.135)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/forgotten'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
53 (0.140)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
54 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/edit'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
55 (0.135)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/password'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
56 (0.140)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/address'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
57 (0.131)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/wishlist'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
58 (0.141)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/order'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
59 (0.136)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/download'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
60 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/reward'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
61 (0.140)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/return'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
62 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/transaction'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
63 (0.167)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/newsletter'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
64 (0.133)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/recurring'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
65 (0.161)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_top'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
66 (0.143)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_center'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
67 (0.140)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_bottom'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
68 (0.941)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/information.php:10
69 (0.177)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
70 (0.157)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
71 (0.138)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
72 (0.166)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
73 (0.121)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
74 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=3'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
75 (0.124)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
76 (0.134)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
77 (0.137)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/contact'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
78 (0.121)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/return/add'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
79 (0.124)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/sitemap'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
80 (0.123)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/manufacturer'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
81 (0.124)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/voucher'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
82 (0.118)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=affiliate/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
83 (0.127)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/special'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
84 (0.208)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
85 (0.148)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/order'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
86 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/wishlist'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
87 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/newsletter'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
88 (0.230)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_top'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
89 (0.143)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_center'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
90 (0.205)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'footer_bottom'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
91 (0.139)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'mass_bottom'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
92 (0.137)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'footer_bottom'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
93 (0.170)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/extension/extension.php:4
94 (0.220)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
95 (0.139)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/logout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
96 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/home'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
97 (0.125)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/wishlist'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
98 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/account'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
99 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/register'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
100 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/login'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
101 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/order'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
102 (0.130)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/transaction'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
103 (0.143)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/download'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
104 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=account/logout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
105 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=checkout/cart'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
106 (0.160)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=checkout/checkout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
107 (0.134)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/contact'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
108 (0.726)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/category.php:10
109 (0.548)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '678' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/category.php:10
110 (22.431)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '681'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
111 (0.277)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
112 (0.153)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
113 (0.135)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
114 (20.947)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '806'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
115 (0.373)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
116 (0.222)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
117 (0.199)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=806'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
118 (20.820)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '683'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
119 (0.331)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
120 (0.160)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
121 (0.146)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=683'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
122 (22.124)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '834'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
123 (0.286)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
124 (0.155)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
125 (0.143)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=834'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
126 (21.099)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '685'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
127 (0.277)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
128 (0.154)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
129 (0.175)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
130 (21.778)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '832'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
131 (0.320)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
132 (0.154)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
133 (0.147)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
134 (21.920)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '836'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
135 (0.277)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
136 (0.152)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
137 (0.139)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
138 (21.366)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '822'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
139 (0.297)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
140 (0.206)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
141 (0.153)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
142 (21.056)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '810'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
143 (0.319)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
144 (0.157)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
145 (0.146)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=810'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
146 (21.469)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '679'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
147 (0.282)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
148 (0.150)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
149 (0.142)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
150 (22.063)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '828'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
151 (0.299)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
152 (0.238)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
153 (0.181)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
154 (0.157)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
155 (0.154)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
156 (0.774)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '594' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/category.php:10
157 (18.032)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '633'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
158 (0.275)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
159 (0.147)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
160 (0.131)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=633'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
161 (18.239)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '808'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
162 (0.298)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
163 (0.174)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
164 (0.138)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=808'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
165 (18.559)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '690'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
166 (0.263)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
167 (0.196)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
168 (0.157)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=690'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
169 (18.676)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '694'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
170 (0.273)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
171 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
172 (0.131)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=694'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
173 (17.814)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '647'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
174 (0.278)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
175 (0.145)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
176 (0.131)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=647'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
177 (18.361)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '817'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
178 (0.283)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
179 (0.180)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
180 (0.158)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=817'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
181 (18.974)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '710'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
182 (0.313)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
183 (0.158)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
184 (0.137)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=710'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
185 (19.173)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '595'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
186 (0.291)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
187 (0.256)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
188 (0.138)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=595'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
189 (18.710)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '630'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
190 (0.283)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
191 (0.211)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
192 (0.230)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=630'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
193 (17.511)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '604'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
194 (0.246)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
195 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
196 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=604'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
197 (17.411)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '624'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
198 (0.251)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
199 (0.142)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
200 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=624'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
201 (17.118)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '627'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
202 (0.248)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
203 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
204 (0.130)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=627'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
205 (17.087)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '615'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
206 (0.358)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
207 (0.165)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
208 (0.141)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=615'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
209 (18.535)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '650'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
210 (0.262)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
211 (0.151)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
212 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=650'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
213 (18.085)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '672'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
214 (0.260)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
215 (0.152)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
216 (0.173)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=672'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
217 (18.311)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '692'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
218 (0.240)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
219 (0.185)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
220 (0.172)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=692'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
221 (0.142)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
222 (0.138)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
223 (0.564)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '662' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/category.php:10
224 (17.650)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '663'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/catalog/product.php:549
225 (0.249)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
226 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=662'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
227 (0.130)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=663'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
228 (0.122)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
229 (0.123)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=662'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
230 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/language/language'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
231 (0.127)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
232 (0.141)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
233 (0.129)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/currency/currency'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
234 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=information/information'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
235 (0.137)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:132
236 (0.251)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'othanuk9cc45koads39jdljrf5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:36
237 (0.165)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/extension/extension.php:4
238 (0.153)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'othanuk9cc45koads39jdljrf5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:36
239 (0.145)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'othanuk9cc45koads39jdljrf5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:36
240 (0.199)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/customer.php:137
241 (0.160)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'othanuk9cc45koads39jdljrf5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:36
242 (0.170)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'othanuk9cc45koads39jdljrf5'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/library/cart/cart.php:36
243 (0.142)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=checkout/cart'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
244 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=checkout/checkout'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
245 (0.210)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
ORDER BY code
/var/www/vhosts/shreebookcentre.com/httpdocs/system/pavothemes/framework.php:850
246 (0.496)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'pavmegamenu_params'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/setting/setting.php:6
247 (0.499)
SHOW TABLES LIKE 'oc_megamenu'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/menu/megamenu.php:567
248 (0.353)
SELECT m.*, md.title,md.description
FROM oc_megamenu m
LEFT JOIN oc_megamenu_description md ON m.megamenu_id=md.megamenu_id AND language_id=1
WHERE m.`published`=1 AND store_id=0
ORDER BY `position`
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/menu/megamenu.php:47
249 (0.119)
SELECT `parent_id`
FROM `oc_category`
WHERE `category_id` = '594'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/menu/megamenu.php:493
250 (0.134)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
251 (0.130)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
252 (0.100)
SELECT `parent_id`
FROM `oc_category`
WHERE `category_id` = '662'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/menu/megamenu.php:493
253 (0.137)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
254 (0.123)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=662'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
255 (0.094)
SELECT `parent_id`
FROM `oc_category`
WHERE `category_id` = '678'
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/menu/megamenu.php:493
256 (0.113)
SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:142
257 (0.121)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'
/var/www/vhosts/shreebookcentre.com/httpdocs/system/storage/modification/catalog/controller/startup/seo_url.php:155
258 (0.146)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'slideshow'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14
259 (0.130)
SELECT *
FROM oc_layout_module
WHERE layout_id = '11' AND position = 'showcase'
ORDER BY sort_order
/var/www/vhosts/shreebookcentre.com/httpdocs/catalog/model/design/layout.php:14