Warning: Use of undefined constant MCRYPT_RIJNDAEL_128 - assumed 'MCRYPT_RIJNDAEL_128' (this will throw an Error in a future version of PHP) in /home/keepsafe/liquidnation.com.au/classes/Rijndael.php on line 124

Warning: Use of undefined constant MCRYPT_RIJNDAEL_128 - assumed 'MCRYPT_RIJNDAEL_128' (this will throw an Error in a future version of PHP) in /home/keepsafe/liquidnation.com.au/classes/Rijndael.php on line 124

Warning: Use of undefined constant MCRYPT_RIJNDAEL_128 - assumed 'MCRYPT_RIJNDAEL_128' (this will throw an Error in a future version of PHP) in /home/keepsafe/liquidnation.com.au/classes/Rijndael.php on line 124
Terms and conditions of use - LIQUIDNATION

TERMS & CONDITIONS

Ownership of Website, mobile apps and Content

Liquidnation (VIC) ABN 91 769 041 326 owns this website and all Liquidnation mobile apps and; unless otherwise indicated, owns or is licensed to use all content and other material appearing on the website and mobile apps. The material on the website and mobile apps is protected by Australian copyright laws and may not be reproduced in any way without written permission by Liquidnation. No trade mark shown on the website or mobile apps may be used in any way without the prior written permission of Liquidnation or of the relevant trade mark owner.

The following terms and conditions govern the Service that we offer at the Sites ("User Agreement"). It covers "Buy Now" Sales.

1. General

1.1 Terms and conditions

Capitalised terms used throughout the User Agreement have the meaning given to them in clause 12.

The terms and conditions contained in the User Agreement set out what you must do and what you must not do when using the Service. It also sets out our obligations to you. If you breach any of these conditions, we may decide not to allow you to use the Service, or claim damages against you. However, we do not intend to act unreasonably. Please take time to read these terms and conditions and make sure you understand them. If you have any questions, please read our Help pages. If you still have questions, please contact our customer service team at info@makegoodprojects.com.au.

We may amend the User Agreement from time to time by posting new terms and conditions on this Site. These amendments will usually take effect 7 days after the changes have been posted on the Site. You should review this User Agreement from time to time for any amendments. Please ensure you are familiar with them as changes may have been made to previous versions. Continued use by you of the Service following any amendments to this User Agreement will constitute your acceptance of the new terms & conditions applying to the Service.

Please note that additional conditions governing the Service and your relationship with us are contained in other pages on the relevant Site and unless those conditions conflict with these terms and conditions, they will be incorporated into and will form part of the User Agreement. In particular, please carefully read all information relating to the Sale Overview, returns policy, or Item Page which contains important information relevant to each particular sale on the Site.

1.2 Obligation to maintain system integrity

You may not take any action that might interfere with the operation of the Service.

You must not use any device, software or instruction to interfere or attempt to interfere with the proper working of our Site or sale being conducted on or through a Site.

You must not take any action which imposes an unreasonable or disproportionately large burden on our infrastructure.

You are solely responsible for your transmissions through the Service. You must:

not forge communications or take any other action which would disguise the origin of the communications transmitted by you through the Service;

not allow another person to transmit communications that falsely identifies your account as the origin of such a communication;

not interfere with or disrupt networks connected to the Service;

not use the Service for illegal purposes; and

comply with all regulations, policies and procedures of networks connected to the Service which either apply by operation of law or are referred to in a Site.

We reserve the right to determine whether your conduct is consistent with the User Agreement and what we believe is good practice for the Sites, however, in exercising our rights, we do not intend to act unreasonably.

2. Registration

2.1 Your information

"Your information" includes any information you provide us at any time.

You are solely responsible for Your Information. However, we may deal with Your Information if we deem it necessary or appropriate for example; if we believe Your Information may create any liability for us. In dealing with Your Information, we will always act reasonably.

You must ensure that your information:

is true, accurate and complete;

is not false or misleading;

does not infringe any other person's rights (for example intellectual property rights) or privacy;

is not contrary to any applicable law or industry code of practice;

is not defamatory, threatening or harassing;

is not obscene or pornographic; and

does not contain any viruses, Trojan horses, worms, time bombs, cancelbots or other computer programming instructions that may damage, detrimentally interfere with, surreptitiously intercept or expropriate any system, data or personal information.

You must not do or allow to be done anything involving the Service which:
may be contrary to any applicable law or industry code of practice, or
is prohibited by the User Agreement.

3. Your rights and obligations

3.1 "Buy Now" Sales

You must pay the purchase price (including any GST) in full for a "Buy Now" Sale, together with any other applicable fees or charges, for example delivery charges.

You authorise us to debit your credit card for the total amount payable to us as a result of a "Buy Now" Sale.

5. Our rights

5.1 Suspension from use of service

We may refuse you the right to use the Service if you:

do not pay for the item and/or refuse delivery of the item;

give information which is untrue, inaccurate or incomplete.


5.2 False or Misleading Conduct

It is illegal to use a false name to use the Service or to buy items or make bids with an invalid or stolen credit card, even if our software initially accepts an order or bid. We intend to refer fraudulent users to the police and to your Internet Service Provider.

You may be sued for any losses suffered by any person arising out of any bid manipulation or illegal action.

If your credit card balance is insufficient to meet all money due to us, or a chargeback is made on the credit card then in addition to all other remedies available to us under the User Agreement, we may immediately institute proceedings against you for any amount owing to any person.

5.3 Rights as agent and/or seller

We may withdraw and/or re-offer an item for sale at any time if the item:

becomes unavailable due to damage;

in the case of auction items, has uncertain ownership, or is withdrawn by the manufacturer, distributor or Vendor;

in the case of "Buy Now" Sale, is no longer in stock or has uncertain ownership;

has been erroneously listed twice;

is incorrectly described; or

is incorrectly priced.

We also reserve the right to change the:

quantities of products posted;

maximum number of items which you may buy at any time before the sale is completed. For example, we will make these changes where processing errors, technological errors or other errors result in loading of incorrect information.

6 Liability and indemnities

6.1 Our liability to you

In an online auction we are not responsible for bids not received, processed or accepted due to technical difficulties, including those online bids placed by Autobid. In particular, we are not responsible for any loss, liability or damage incurred by you as a result of a bid not received, processed or accepted due to technical difficulties.

We provide the Sites and the Service without any express or implied warranty or condition concerning the capacity or availability of the Sites or the Service.

Neither we nor our suppliers will be liable for any lost profits or any special, incidental or consequential damages (however arising, including negligence) arising out of or in connection with the delivery of the Service or the sale of any goods.

We do not guarantee continuous, uninterrupted or secure access to the Service. Operation of the Sites may be restricted by factors outside of our control or during maintenance.

You acknowledge that the internet can be an unstable and, sometimes, insecure environment. At times the Service may not be available and offers may not be processed or accepted.

We cannot guarantee that we will notice or be able to prevent any illegal or inappropriate use of the Site.

6.2 Limitation of our liability to you

In relation to the items sold, and subject to the Australian Consumer Law, we will endeavour to:

provide accurate descriptions to fairly reflect each item;

pass clear title to the items to you; and

ensure that each item listed on the Site is available.

To the extent permitted by law, all express or implied conditions or warranties in connection with the Service, the Sites and the sale of any goods are excluded.

We do not exclude liability under any guarantee, condition or warranty which cannot be excluded by law. For example, we do not exclude guarantees under the Australian Consumer Law that apply to goods we sell. However, to the fullest extent permissible by law, we expressly limit our liability for breach of a guarantee, condition or warranty implied by virtue of any law at our option:

in the case of goods supplied to:

the replacement or repair of the goods;

the supply of equivalent goods; or

making a full refund to you.

in the case of services supplied to:

supply of the services again;

payment of the costs of having the services supplied again; or

making a full refund to you.

6.3 Indemnities

You waive, release, discharge and relinquish any and all claims that you now have or may have against us, our affiliates, subsidiaries, parents, shareholders, directors, officers, employees, agents and representatives which are connected with, arise out of, relate to or are incidental to the use of the Service.

You agree to indemnify and defend us, our affiliates, subsidiaries, parents, shareholders, directors, officers, employees, agents and representatives (the Indemnified Parties) harmless from and against any and all claims, loss, damage, tax, liability and/or expense that may be incurred by the Indemnified Parties arising out of or in connection with the performance of their obligations as described in the User Agreement including the legal costs, fees and expenses of defending ourselves against any claim by any or all of the parties to any transaction and/or by any other person and/or as a result of your negligent act or omission on a full indemnity basis.

You further agree to indemnify and hold us, and the Indemnified Parties harmless from any claim or demand, including legal fees on a full indemnity basis), made by any third party due to or arising out of a breach of the User Agreement by you.

The infringement by you, or other user of the Service using your user name and password, of any intellectual property or other right of any person or entity.

7. Collection delivery, insurance and risk

7.1 Collection and delivery

Please carefully familiarise yourself with the all details concerning collection and/or delivery of items following the conclusion of a transaction as set out in the Sale Overview, Item Page and in this clause.

We may withhold delivery of any item until you have paid everything owing to us.

Any collection times specified by us in an online auction in the Sale Overview, Item Page or otherwise are estimates only and we will not be liable to you for any loss or damage you suffer as a result of our failure to comply with such details.

In particular where items are not held by us on our premises, you must strictly observe and comply with collection times and arrangements specified by us in the Sale Overview, Item Page. Your failure to strictly adhere to those collection times and arrangements, may result in the item being removed from those premises and although we will exercise all reasonable care on your behalf, we do not have custody or control of those items and accordingly we will not be liable for the unavailability of the item or the fact that no refund of the purchase price is made to you.

Unless outlined in the Sale Overview, delivery of bulky goods (for example large TVs, furniture, and whitegoods) assumes ground floor front door delivery.

Whenever you visit any place where goods are stored to inspect or collect them, you must comply with:

any law relating to occupational health and safety;

any directions or warning we have given about goods or their location in the Sale Overview, item Page; and

any directions given by us or anyone authorised by us when inspecting or removing any goods from any location.

You acknowledge that you inspect or remove goods at any location at your own risk.

If we are unable to deliver an item or you don't collect it within 7 days of a sale we may charge you a storage fee in accordance with our usual rates.

We reserve the right to sell the item (if it was purchased for more than $100.00) upon terms we determine to be reasonable, if you do not collect the item within 14 days of a sale.

If we sell the item in accordance with clause 8.1i we will refund the proceeds of sale to you, less Buyer's Premium, a storage charge based on a fee of $5.00 per day of storage and an administration fee of $40.00.

Because of the administration costs involved, we reserve the right to sell or otherwise dispose of an item purchased for $100.00 or less, without refund to you.

7.2 Risk and title

If the item is to be delivered by us to a place nominated by you, the risk in it will pass to you:

when it is delivered; or

if we are unable to deliver the item to the place nominated by you for any reason, (for example if no one is present to accept delivery), when we or our carrier first attempts to deliver the item.

All items to be delivered must be delivered to a specified premises and receipt must be acknowledged by signature. After you provide delivery location details, you must not:

contact any carrier we use directly and authorise them to deliver the items to another address; or

arrange for collection from the carrier directly.

If you contravene this clause you will waive any right you may have had to personal delivery, and you will be deemed to have accepted all responsibility for any loss of or damage caused to the items by delivery, and you release us from any liability for any loss or damage caused as a result.

Title in any item will only pass to you when we receive the Invoice Amount in cleared funds.

If the item is withheld by us in accordance with the User Agreement, risk in the item will pass to you at such time as you would have been able to collect the item had we not been holding it.

You cannot change or request to change your delivery address details after a "Buy Now" Sale has closed. We have no responsibility if an item is not delivered where you change your delivery address details in those circumstances.

8. Privacy

Our Privacy Statement (as it appears from time to time) is available on the Sites. We will take all reasonable steps to abide by this policy and all Users of the Sites agree to abide by the policy when using a Site.

If you do not agree to the collection of this information and the other information specified in the Privacy Statement, then you may not use the Sites.

By registering with the Service and accepting the User Agreement, you also consent to:

collection of a variety of personal information which is specified in greater detail in the Privacy Statement. This information includes your address, gender, and date of birth and contact details; in some cases, credit card details, bidding and buying activities; and your use of our Sites generally;

use of your personal information for certain purposes specified in greater detail in the Privacy Statement. These purposes include internal use for improving the Service; meeting our obligations under State or Federal law; statistical analysis of usage of our Sites to improve the Service; to utilise our content and product offerings and deliver promotional material to you (if you have opted for this service); and administrative purposes connected with the Sites; and
us disclosing your information in the circumstances specified in the Privacy Statement.

9. Governing law

This User Agreement is governed by and will be construed according to the law of Victoria and is subject to the jurisdiction of the courts of Victoria.

10. GST

The Sale Overview or Item Page will state whether the sale price of an item is inclusive of GST (GST Inclusive) or exclusive of GST (GST exclusive).
You acknowledge and agree that:

if the sale price is GST Inclusive, any Buyer's Premium will include GST and will be calculated as a percentage of the sale price (inclusive of GST) and payable by you at the same time as the sale price; or

if the sale price is GST Exclusive, GST will be calculated on and added to the sale price.

11. Definitions and interpretation

"Buy Now" Sale means a sale of anything located in the "Buy Now" section of Liquidnation.

Consumer Sale means a "Buy Now" Sale where clause 7.2c applies. That is, sales to consumers where guarantees and implied conditions or warranties cannot be excluded by law.

Liquidnation means the website located at www.makegoodprojects.com.au

Invoice Amount has the meaning given to it. For "Buy Now" Sales it means the purchase price together with any other applicable charges, for example delivery charges.

Item Page means the page that contains the special terms and conditions and attaching to a particular good for sale by "Buy Now" Sale.

Privacy Statement means that statement contained in the Privacy & Security Section of the Sites.

Product Information means any information posted by us on a Site in relation to any item posted by us for sale on the Site.

Returns Policy means that policy contained in the Returns Policy section.

Sale Overview means the special terms and conditions and specifications attaching to a particular good which are accessed by the potential buyer upon entry to the Item Page or Lot Page for that particular good.

Service means the services offered by Liquidnation.

Site means the Liquidnation.

User Agreement means these terms and conditions which you are deemed to have agreed to when you register for the Service.

Us/we/our means Liquidnation. ABN 91 769 041 326 of 25 Orange St, Williamstown 3016 Victoria
Vendor means the seller of any goods through manufacturer of goods sold through "Buy Now" Sales.



Deprecated: Function create_function() is deprecated in /home/keepsafe/liquidnation.com.au/tools/profiling/Controller.php on line 358
Load Time2022 ms - You'd better run your shop on a toaster
Querying Time176 ms
Queries431
Memory Peak Usage52.4 Mb
Included Files502 files - 10.09 Mb
PrestaShop Cache- Mb
Global vars1.48 Mb
PrestaShop Version1.6.1.24
PHP Version7.2.24 (OK)
MySQL Version10.2.27-MariaDB-cll-lve (OK)
Memory Limit2048M
Max Execution Time259200s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 160 ms 160 ms 11.67 Mb 11.90 Mb
__construct 0 ms 160 ms - Mb 11.90 Mb
init 43 ms 203 ms 3.64 Mb 15.79 Mb
checkAccess 0 ms 203 ms - Mb 15.79 Mb
setMedia 2 ms 205 ms 0.16 Mb 15.79 Mb
postProcess 0 ms 205 ms - Mb 15.79 Mb
initHeader 0 ms 205 ms - Mb 15.79 Mb
initContent 444 ms 649 ms 25.05 Mb 40.62 Mb
initFooter 628 ms 1277 ms 0.85 Mb 41.44 Mb
display 745 ms 2022 ms 10.71 Mb 52.39 Mb
Hook Time Memory Usage
hooktmMegaLayoutHome 654 ms 6.00 Mb
hookdisplayHome 637 ms 6.00 Mb
hookdisplayFooter 595 ms - Mb
__construct 278 ms 24.25 Mb
hooktmMegaLayoutHeader 55 ms 2.00 Mb
hookdisplayNav 34 ms - Mb
hookheader 24 ms - Mb
hookdisplayHeader 23 ms 2.00 Mb
hooktmMegaLayoutFooter 22 ms - Mb
hookfooter 20 ms - Mb
hookdisplayTop 9 ms - Mb
hooktop 7 ms - Mb
hookdisplayProductListFunctionalButtons 4 ms - Mb
hookdisplayCustomerAccountForm 2 ms - Mb
hookdisplayCustomerAccount 2 ms - Mb
hookcustomeraccount 1 ms - Mb
hookdisplayHeaderLoginButtons 1 ms - Mb
hookdisplayProductPriceBlock 1 ms - Mb
hookdisplayCustomerAccountFormTop 1 ms - Mb
hookcreateaccountform 1 ms - Mb
hookactionDispatcher 1 ms - Mb
hookrcBeforeBodyClosingTag 0 ms - Mb
hookmoduleRoutes - ms - Mb
hookdisplayBanner - ms - Mb
24 hooks 2374 ms 40.25 Mb
Module Time Memory Usage
tmsocialfeeds 996 ms - Mb
tmmegalayout 740 ms 8.00 Mb
tmlookbookhomepage 221 ms 6.00 Mb
advancedreports 57 ms 10.25 Mb
tmheaderaccount 38 ms 2.00 Mb
newsletterpro 32 ms 2.00 Mb
hspointofsalepro 31 ms - Mb
roja45productrental 21 ms 2.00 Mb
filterproductspro 18 ms - Mb
motopressslider 13 ms 2.00 Mb
tmsearch 11 ms 2.00 Mb
paypal 11 ms - Mb
rcpganalytics 10 ms - Mb
tmmegamenu 9 ms - Mb
spinstagramgallery 9 ms - Mb
tmmosaicproducts 8 ms - Mb
statsdata 8 ms - Mb
blocknewsletter 8 ms - Mb
blockwishlist 7 ms - Mb
blocklayered 7 ms 2.00 Mb
tmcategoryproducts 6 ms - Mb
blockcart 6 ms - Mb
recaptchapro 6 ms - Mb
tmproductlistgallery 6 ms - Mb
smartblog 6 ms - Mb
tmcollections 5 ms - Mb
themeconfigurator 5 ms - Mb
tmnewsletter 4 ms 2.00 Mb
tmmanufacturerblock 4 ms - Mb
blockcms 4 ms - Mb
afterpay 4 ms - Mb
tmlookbook 4 ms - Mb
tmmediaparallax 4 ms - Mb
tmhtmlcontent 3 ms - Mb
sizeconversion 3 ms - Mb
bonpopup 3 ms 2.00 Mb
blockcategories 3 ms - Mb
loyalty 3 ms - Mb
homeslider 3 ms - Mb
blocksocial 2 ms - Mb
blockmyaccountfooter 2 ms - Mb
blocklanguages 2 ms - Mb
blocksearch 2 ms - Mb
blockcontactinfos 2 ms - Mb
tmproductvideos 2 ms 2.00 Mb
sekeywords 1 ms - Mb
tmproductzoomer 1 ms - Mb
tmhomepagecategorygallery 1 ms - Mb
tmolarkchat 1 ms - Mb
blockuserinfo 1 ms - Mb
homefeatured 1 ms - Mb
blockcurrencies 1 ms - Mb
codegenerator 1 ms - Mb
blockpermanentlinks 1 ms - Mb
tmrelatedproducts 1 ms - Mb
pagesnotfound 1 ms - Mb
blockbestsellers 1 ms - Mb
blocktags 1 ms - Mb
blockviewed 1 ms - Mb
blockstore 1 ms - Mb
blocknewproducts 1 ms - Mb
blocksupplier 1 ms - Mb
blockspecials 1 ms - Mb
socialsharing 1 ms - Mb
productpaymentlogos 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockpaymentlogo 1 ms - Mb
blockcontact 1 ms - Mb
smartbloghomelatestnews 1 ms - Mb
blockmyaccount 1 ms - Mb
sendtoafriend 0 ms - Mb
blockfacebook 0 ms - Mb
smartblogtag 0 ms - Mb
73 modules 2374 ms 40.25 Mb

Stopwatch SQL - 431 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
6.1 246 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
4.2 1064 /classes/Configuration.php:148
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.3 662 /classes/Hook.php:235
SHOW TABLES
2.6 1 /modules/tmlookbook/classes/TMLookBookTabs.php:124
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.5 244 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.2 47 Yes /classes/Category.php:584
SHOW TABLES
2.2 1 /modules/tmlookbook/classes/TMLookBookHotSpots.php:149
SELECT SQL_NO_CACHE *
FROM `ps_cms_category` a
LEFT JOIN `ps_cms_category_lang` `b` ON a.`id_cms_category` = b.`id_cms_category` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1
WHERE (a.`id_cms_category` = 1) AND (b.`id_shop` = 1) LIMIT 1
2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /Adapter/Adapter_EntityMapper.php:61
SHOW TABLES
1.4 1 /modules/tmlookbook/classes/TMLookBookHotSpots.php:149
SHOW TABLES
1.3 1 /modules/tmlookbook/classes/TMLookBookHotSpots.php:149
SHOW TABLES
1.3 1 /modules/tmlookbook/classes/TMLookBookHotSpots.php:149
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.2 133 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.2 133 /classes/module/Module.php:277
SELECT SQL_NO_CACHE tlhp.id, tlhp.active, tlhp.sort_order, tlhp.type, tlhp.id_page, tlhp.hook_name, tlkl.name, tlkl.description, tlk.image
FROM ps_tmlookbook_homepage tlhp
INNER JOIN ps_tmlookbook tlk
ON tlhp.id_page = tlk.id_page
AND tlhp.hook_name = 'hookHome'
JOIN ps_tmlookbook_lang tlkl
ON tlk.id_page = tlkl.id_page
AND tlkl.id_lang = 1
AND tlk.id_shop = 1 AND tlhp.`active` = 1 ORDER BY tlhp.`sort_order`
1.2 5 Yes /modules/tmlookbookhomepage/classes/TMLookBookHomePageBlocks.php:46
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.2 320 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.1 320 Yes /classes/Country.php:137
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 133 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 133 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 133 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 133 /classes/module/Module.php:277
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='dc22574a3ed145e3778aaae813b1e587' AND cache_id LIKE "spinstagramgallery_displayTop|1|1|1|1%"
1 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1 112 Yes /classes/Dispatcher.php:452
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='fb0593d2c1cfc590f792b05f5b56fab7' AND cache_id LIKE "tmmosaicproducts|1|1|1|1|3|21%"
1 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='dc22574a3ed145e3778aaae813b1e587' AND cache_id LIKE "spinstagramgallery_displayFooter|1|1|1|1%"
1 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1 0 /classes/Hook.php:131
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
1 1 /classes/ObjectModel.php:487
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='dd485175c7d214ba7dd3e754d1c2e357' AND cache_id LIKE "tmcategoryproducts|1|1|1|1|3|21%"
0.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='ace651d12b23d8f4b8a618d7e1f4be20' AND cache_id LIKE "tmproductlistgallery|1|1|1|1|3|21|0%"
0.9 1 /classes/SmartyCustom.php:295
SELECT SQL_NO_CACHE *
FROM ps_tmlookbook_tabs tlkt
JOIN ps_tmlookbook_tabs_lang tlktl
ON tlkt.id_tab = tlktl.id_tab
AND tlktl.id_lang = 1
AND tlkt.id_page =1 AND `active` = 1 ORDER BY `sort_order`
0.9 80 Yes /modules/tmlookbook/classes/TMLookBookTabs.php:66
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
0.9 244 Yes /classes/Country.php:130
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10895
ORDER BY f.position ASC
0.9 4 Yes /classes/Product.php:4456
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('156855', '20', '598420827', '', '1', '1', '2019-11-14 22:16:22')
0.8 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.8 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "seoredirect" LIMIT 1
0.7 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'liquidnation.com.au' OR su.domain_ssl = 'liquidnation.com.au')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.7 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10960
ORDER BY f.position ASC
0.6 8 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10895) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout_items
WHERE `id_layout` =4
0.6 253 /modules/tmmegalayout/classes/TMMegaLayoutItems.php:86
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 10771) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 5 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10959
ORDER BY f.position ASC
0.5 8 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10895
AND image_shop.`cover` = 1 LIMIT 1
0.5 6 /classes/Product.php:2747
SELECT SQL_NO_CACHE *
FROM `ps_tmsocialfeed`
WHERE id_shop = 1
AND hook = "footer"
AND active = 1
ORDER BY item_order ASC
0.5 3 Yes /modules/tmsocialfeeds/tmsocialfeeds.php:358
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10958
ORDER BY f.position ASC
0.5 8 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout_items
WHERE `id_layout` =7
0.5 253 /modules/tmmegalayout/classes/TMMegaLayoutItems.php:86
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10967
ORDER BY f.position ASC
0.5 8 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 10771) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 5 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10904) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 24) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5d5e07286b5cc57747750aff03cf479d' AND cache_id="blocksearch-top|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.5 16 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10960) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.5 231 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite`
FROM `ps_cms_lang` AS c
LEFT JOIN  `ps_lang` AS l ON c.`id_lang` = l.`id_lang`
WHERE c.`id_cms` = 3
AND l.`active` = 1
0.5 25 /classes/CMS.php:240
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 156855
AND `date_add` > '2019-11-14 21:46:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.5 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10965
ORDER BY f.position ASC
0.5 7 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10895
0.5 2 /classes/Product.php:4475
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout_items
WHERE `id_layout` =15
0.5 253 /modules/tmmegalayout/classes/TMMegaLayoutItems.php:86
SELECT SQL_NO_CACHE *
FROM `ps_roja45_productrental_workingday` wd
LEFT JOIN `ps_roja45_productrental_workingday_lang` `wdl` ON wd.id_roja45_product_rental_workingday = wdl.id_roja45_product_rental_workingday
WHERE (wdl.id_lang=1)
0.5 7 /modules/roja45productrental/classes/ProductRentalWorkingDay.php:106
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10895 LIMIT 1
0.5 1 /classes/Product.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10874
ORDER BY f.position ASC
0.5 5 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10771
ORDER BY f.position ASC
0.5 6 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10894
ORDER BY f.position ASC
0.5 4 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10771) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10904
ORDER BY f.position ASC
0.5 5 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.5 4 /classes/Currency.php:470
SELECT SQL_NO_CACHE *
FROM ps_tmlookbook_hotspots tlhs
JOIN ps_tmlookbook_hotspots_lang tlhsl
ON tlhs.id_spot = tlhsl.id_spot
AND tlhsl.id_lang = 1
AND tlhs.id_tab =1
0.5 75 /modules/tmlookbook/classes/TMLookBookHotSpots.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10959) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.5 5 /classes/Language.php:777
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 61 AND `id_shop` = 1
0.5 330 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 10966
ORDER BY f.position ASC
0.5 6 Yes /classes/Product.php:4456
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.5 25 /classes/Language.php:892
SELECT SQL_NO_CACHE *
FROM `ps_module_currency`
WHERE `id_module` = 234
AND `id_shop` = 1
0.5 4 /classes/Currency.php:295
SELECT SQL_NO_CACHE i.`id_newsletter_pro_list_of_interest`, il.`name`, iss.`id_shop`, iss.`active`, iss.`position` 
FROM `ps_newsletter_pro_list_of_interest` i
LEFT JOIN `ps_newsletter_pro_list_of_interest_lang` il 
ON (i.`id_newsletter_pro_list_of_interest` = il.`id_newsletter_pro_list_of_interest`)
LEFT JOIN `ps_newsletter_pro_list_of_interest_shop` iss
ON (i.`id_newsletter_pro_list_of_interest` = iss.`id_newsletter_pro_list_of_interest`
AND il.`id_shop` = iss.`id_shop`)
WHERE il.`id_lang` = 1
AND il.`id_shop` = 1  AND iss.`active` = 1   ORDER BY iss.`position`
0.5 1 Yes /modules/newsletterpro/classes/NewsletterProListOfInterest.php:171
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 156855
AND `date_add` > '2019-11-14 21:46:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.5 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10874) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 24) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10967) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tmc.`id_collection`, tmc.`name`, tmc.`token`
FROM `ps_tmcollections` tmc
WHERE `id_customer` = 0
AND `id_shop` = 1
ORDER BY tmc.`name` ASC
0.4 1 Yes /modules/tmcollections/classes/ClassTmCollections.php:98
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 3, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 3) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-11-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'top' AND active = 1
ORDER BY item_order ASC
0.4 19 Yes /modules/tmhtmlcontent/tmhtmlcontent.php:214
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 24
0.4 5 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 61) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8f894a7def03f3892c7596e85233ef54' AND cache_id="blockcategories|1|1|1|1|3|21|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10895
0.4 6 /classes/Tag.php:205
SELECT SQL_NO_CACHE id_product
FROM `ps_roja45_productrental_details` prd
LEFT JOIN `ps_roja45_productrental_details_shop` `prds` ON prd.id_roja45_product = prds.id_roja45_product
WHERE (prds.`enabled` = 1) AND (prds.`id_shop` = 1)
0.4 9 /modules/roja45productrental/classes/ProductRentalDetails.php:171
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.4 17 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3a2a53beca256a383bbf3bf142c65d13' AND cache_id="blocksocial|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "cms" LIMIT 1
0.4 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE b.`id_spinstagramgallery`
FROM `ps_spinstagramgallery` b
LEFT JOIN `ps_spinstagramgallery_shop` bs ON (b.`id_spinstagramgallery` = bs.`id_spinstagramgallery`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1) AND b.`hook` = 26
ORDER BY b.`ordering`
0.4 1 Yes /modules/spinstagramgallery/spinstagramgallery.php:1188
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'home' AND active = 1
ORDER BY item_order ASC
0.4 30 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.4 30 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10895)
0.4 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_gender` a0
LEFT JOIN `ps_gender_lang` `a1` ON (a0.`id_gender` = a1.`id_gender`)
WHERE (a1.`id_lang` = 1)
0.4 2 /classes/PrestaShopCollection.php:358
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10958) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.4 1 /classes/shop/Shop.php:202
SELECT SQL_NO_CACHE *
FROM `ps_roja45_productrental_searchcategory` sc
LEFT JOIN `ps_roja45_productrental_searchcategory_lang` `scl` ON sc.id_roja45_product_searchcategory = scl.id_roja45_product_searchcategory
WHERE (sc.`enabled` = 1) AND (scl.`id_lang` = 1)
0.4 1 /modules/roja45productrental/classes/ProductRentalSearchCategory.php:76
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10894) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='c5d7012e898857ca92f70d27796b3a7d' AND cache_id="blockcms|2|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_tmlookbook_hotspots tlhs
JOIN ps_tmlookbook_hotspots_lang tlhsl
ON tlhs.id_spot = tlhsl.id_spot
AND tlhsl.id_lang = 1
AND tlhs.id_tab =2
0.4 75 /modules/tmlookbook/classes/TMLookBookHotSpots.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ace651d12b23d8f4b8a618d7e1f4be20' AND cache_id="tmproductlistgallery|1|1|1|1|3|21|0" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10965) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10966) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE b.`id_spinstagramgallery`
FROM `ps_spinstagramgallery` b
LEFT JOIN `ps_spinstagramgallery_shop` bs ON (b.`id_spinstagramgallery` = bs.`id_spinstagramgallery`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1) AND b.`hook` = 15
ORDER BY b.`ordering`
0.4 1 Yes /modules/spinstagramgallery/spinstagramgallery.php:1188
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.4 178 /classes/Tab.php:296
SELECT SQL_NO_CACHE *
FROM ps_bonpopup bonp
JOIN ps_bonpopup_lang bonpl
ON bonp.id_tab = bonpl.id_tab
WHERE bonpl.id_lang = 1
AND bonp.`data_end` >= '2019-11-14 22:16:00'
AND bonp.`data_start` <= '2019-11-14 22:16:00'
AND bonp.id_shop =1
0.4 1 /modules/bonpopup/classes/ClassPopup.php:82
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='88d45e271d8d27f6dcf4333ac2a8112b' AND cache_id="tmmanufacturerblock|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4674699559be69e6d715adbc09f95176' AND cache_id="tmmegamenu|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10960
AND image_shop.`cover` = 1 LIMIT 1
0.4 4 /classes/Product.php:2747
SELECT SQL_NO_CACHE *
FROM `ps_tmsocialfeed`
WHERE id_shop = 1
AND hook = "home"
AND active = 1
ORDER BY item_order ASC
0.4 3 Yes /modules/tmsocialfeeds/tmsocialfeeds.php:358
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10874)
0.4 4 /classes/Product.php:3002
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.4 1 /classes/Country.php:173
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1
0.4 1 /modules/paypal/paypal.php:276
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10895) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
0.4 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM ps_tmlookbook_hotspots tlhs
JOIN ps_tmlookbook_hotspots_lang tlhsl
ON tlhs.id_spot = tlhsl.id_spot
AND tlhsl.id_lang = 1
AND tlhs.id_tab =3
0.4 75 /modules/tmlookbook/classes/TMLookBookHotSpots.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "themeconfigurator" LIMIT 1
0.4 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.4 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "cms"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayHeader"
AND tmlp.`status` = 1 LIMIT 1
0.4 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e5c0eb91d03a541491bca9fb04636e98' AND cache_id="tmproductlistgallery|1|1|1|1|3|21|0" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dc35857811e82c67622634eb58f22a17' AND cache_id="blockmyaccountfooter|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10960
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5102 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10771)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10960)
0.3 3 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.3 19 Yes /modules/tmhtmlcontent/tmhtmlcontent.php:214
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE *
FROM ps_tmlookbook_hotspots tlhs
JOIN ps_tmlookbook_hotspots_lang tlhsl
ON tlhs.id_spot = tlhsl.id_spot
AND tlhsl.id_lang = 1
AND tlhs.id_tab =5
0.3 75 /modules/tmlookbook/classes/TMLookBookHotSpots.php:61
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10959
0.3 7 /classes/Tag.php:205
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10959)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d86a8e87f87dd859adf6d5fc4f74b84a' AND cache_id="tmsearch|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10960
0.3 6 /classes/Tag.php:205
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout
WHERE `hook_name` = "displayHeader"
AND `id_shop` =1
AND `status` = 1 LIMIT 1
0.3 20 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:63
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='07f8bd99ea289573db154eaf0f9265fc' AND cache_id="blockcontactinfos|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10967)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10959
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dc22574a3ed145e3778aaae813b1e587' AND cache_id="spinstagramgallery_displayTop|1|1|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_layout`, `layout_name`, `hook_name`, `status`
FROM ps_tmmegalayout
WHERE `id_shop` = 1
0.3 20 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:124
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10960 LIMIT 1
0.3 3 /classes/Product.php:752
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 12 LIMIT 1
0.3 1 /classes/Page.php:77
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10904
0.3 4 /classes/Product.php:4475
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.3 5 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10904)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10771
0.3 4 /classes/Product.php:4475
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10965)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 61 AND id_shop=1 LIMIT 1
0.3 1 /classes/Carrier.php:1075
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10874
0.3 4 /classes/Product.php:4475
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4e2762e64ce51a2019bbee2ea89a2933' AND cache_id="tmheaderaccount|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.3 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5009 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d9cc4aabba693e374169175df4e65f5f' AND cache_id="tmmediaparallax|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10965
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10771 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "subpages"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayHeader"
AND tmlp.`status` = 1 LIMIT 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10895
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10894)
0.3 2 /classes/Product.php:3002
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:173
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.3 5 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10904 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 21 LIMIT 1
0.3 1 /classes/AddressFormat.php:558
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
0.3 1 /classes/Language.php:680
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10958)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10874
AND image_shop.`cover` = 1 LIMIT 1
0.3 11 /classes/Product.php:2747
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "cms"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayFooter"
AND tmlp.`status` = 1 LIMIT 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10874
0.3 5 /classes/Tag.php:205
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "cms"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayHome"
AND tmlp.`status` = 1 LIMIT 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "filterproductspro" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 10966)
0.3 1 /classes/Product.php:3002
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "spinstagramgallery" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.3 30 Yes /modules/themeconfigurator/themeconfigurator.php:375
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10959 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10894
AND image_shop.`cover` = 1 LIMIT 1
0.3 6 /classes/Product.php:2747
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "roja45productrental" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10894
0.3 2 /classes/Product.php:4475
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10958 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10967
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE COUNT(*) n
FROM `ps_module_shop`
WHERE id_module=20 AND id_shop IN (1)
GROUP BY id_module
HAVING n=1 LIMIT 1
0.3 1 /classes/module/Module.php:2209
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.3 1 /classes/ObjectModel.php:1376
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'cms' LIMIT 1
0.3 1 /classes/Page.php:96
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dc22574a3ed145e3778aaae813b1e587' AND cache_id="spinstagramgallery_displayHome|1|1|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.3 16 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10895
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckout" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10966
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10965
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10967
0.3 5 /classes/Tag.php:205
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 6098 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10967
AND image_shop.`cover` = 1 LIMIT 1
0.3 5 /classes/Product.php:2747
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10895 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10771) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 0 LIMIT 1
0.3 2 /modules/tmnewsletter/tmnewsletter.php:496
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10904
AND image_shop.`cover` = 1 LIMIT 1
0.3 4 /classes/Product.php:2747
SELECT SQL_NO_CACHE * FROM ps_seor WHERE (old="https://liquidnation.com.au/en/content/3-terms-and-conditions-of-use" OR old="/en/content/3-terms-and-conditions-of-use" OR old="https://liquidnation.com.au/en/content/3-terms-and-conditions-of-use" ) AND active=1 AND id_shop="1"
0.3 1 /override/classes/controller/FrontController.php:94
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='692c924b89fbc19dedc2eb07b795d7f9' AND cache_id="tmheaderaccount|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10904
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10959
AND image_shop.`cover` = 1 LIMIT 1
0.3 4 /classes/Product.php:2747
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 1)
WHERE pa.id_product = 10958
0.3 3 /classes/Product.php:4475
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10966 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10959
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 239 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10874 LIMIT 1
0.3 4 /classes/Product.php:765
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10904
0.3 7 /classes/Tag.php:205
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10960 LIMIT 1
0.3 3 /classes/Product.php:765
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10904 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout
WHERE `hook_name` = "displayFooter"
AND `id_shop` =1
AND `status` = 1 LIMIT 1
0.3 20 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:63
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 22
AND `active` = 1 LIMIT 1
0.3 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10904) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockpermanentlinks" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10959 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcontactinfos" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10771
AND image_shop.`cover` = 1 LIMIT 1
0.3 5 /classes/Product.php:2747
SELECT SQL_NO_CACHE * FROM ps_rec_whitelist WHERE ip_address = "35.171.45.91"
0.3 1 /modules/recaptchapro/recaptchapro.php:1198
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "subpages"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayFooter"
AND tmlp.`status` = 1 LIMIT 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10960) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE * FROM ps_rec_whitelist WHERE ip_address = "35.171.45.91"
0.3 1 /modules/recaptchapro/recaptchapro.php:1198
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10874 LIMIT 1
0.3 4 /classes/Product.php:752
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='bc27d909e0c4984a245fc893f402739d' AND cache_id="tmmosaicproducts|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10965
AND image_shop.`cover` = 1 LIMIT 1
0.3 7 /classes/Product.php:2747
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklanguages" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 4877 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dd485175c7d214ba7dd3e754d1c2e357' AND cache_id="tmcategoryproducts|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10958
0.3 6 /classes/Tag.php:205
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 11
AND `status` = 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fb0593d2c1cfc590f792b05f5b56fab7' AND cache_id="tmmosaicproducts|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10958
AND image_shop.`cover` = 1 LIMIT 1
0.3 6 /classes/Product.php:2747
SELECT SQL_NO_CACHE `id_newsletter_pro_customer_list_of_interests`
FROM `ps_newsletter_pro_customer_list_of_interests`
WHERE `id_customer` = 0 LIMIT 1
0.3 0 /modules/newsletterpro/classes/NewsletterProCustomerListOfInterests.php:49
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10894 LIMIT 1
0.3 2 /classes/Product.php:765
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10960
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockmyaccountfooter" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmmegamenu" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10771 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 10966
AND image_shop.`cover` = 1 LIMIT 1
0.3 7 /classes/Product.php:2747
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcms" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 10 LIMIT 1
0.3 1 /classes/Supplier.php:192
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10967 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10965 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter
WHERE `id_guest` =0 LIMIT 1
0.3 1 /modules/tmnewsletter/tmnewsletter.php:801
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcurrencies" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10958 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmlookbookhomepage" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-11-14 00:00:00' AND '2019-11-14 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmsearch" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10967 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10965 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10874
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 10958 LIMIT 1
0.3 1 /classes/Product.php:765
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10960) AND (id_product_attribute = 6098) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10894 LIMIT 1
0.3 2 /classes/Product.php:752
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmheaderaccount" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5308 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a5c8ed3ca73932d5a923c1f94c82e8ea' AND cache_id="tmcategoryproducts|1|1|1|1|3|21" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10895 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 177 LIMIT 1
0.3 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.3 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 10966 LIMIT 1
0.3 1 /classes/Product.php:752
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.3 1 /classes/Group.php:133
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10958
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_cms_lang`
WHERE id_lang = 1
AND id_cms = 3 AND id_shop = 1 LIMIT 1
0.3 1 /classes/Meta.php:393
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tml.`id_layout`
FROM ps_tmmegalayout tml
LEFT JOIN ps_tmmegalayout_pages tmlp
ON(tml.`id_layout` = tmlp.`id_layout`)
WHERE tmlp.`page_name` = "subpages"
AND tml.`id_shop` = 1
AND tml.`hook_name` = "displayHome"
AND tmlp.`status` = 1 LIMIT 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:341
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10771
0.3 5 /classes/Tag.php:205
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dc22574a3ed145e3778aaae813b1e587' AND cache_id="spinstagramgallery_displayFooter|1|1|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5287 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmnewsletter" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcart" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10894
0.3 6 /classes/Tag.php:205
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10966
0.3 6 /classes/Tag.php:205
SELECT SQL_NO_CACHE id_shop
FROM `ps_cms_shop`
WHERE `id_cms` = 3
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2019-11-14 00:00:00' AND '2019-11-14 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:306
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10904 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmolarkchat" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmmanufacturerblock" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 1
AND `status` = 1
0.3 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=10965
0.3 4 /classes/Tag.php:205
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5290 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmmosaicproducts" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10967
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10895) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sekeywords" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10874) AND (id_product_attribute = 4877) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM ps_tmmegalayout
WHERE `hook_name` = "displayHome"
AND `id_shop` =1
AND `status` = 1 LIMIT 1
0.3 20 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:63
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocksocial" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10965
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10874) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10771
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
0.3 5 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10895) AND (id_product_attribute = 5009) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagesnotfound" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5305 LIMIT 1
0.3 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10966
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 10894
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2019-11-14 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmsocialfeeds" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmcategoryproducts" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "statsdata" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 14
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10965) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 3
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10904) AND (id_product_attribute = 5102) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 0 LIMIT 1
0.2 2 /modules/tmnewsletter/tmnewsletter.php:496
SELECT SQL_NO_CACHE *
FROM `ps_tmlookbook` a
WHERE (a.`id_page` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5004 LIMIT 1
0.2 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE * FROM ps_rec_whitelist WHERE ip_address = "35.171.45.91"
0.2 1 /modules/recaptchapro/recaptchapro.php:1198
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10895) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10967
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10959) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 13
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10959) AND (id_product_attribute = 5290) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10960 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10967) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 16
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 18
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "klarnaofficial" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmlookbook" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10965 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 145 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 183 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10771
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10965) AND (id_product_attribute = 5303) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 184 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "supercheckout" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 6
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5303 LIMIT 1
0.2 1 /classes/Combination.php:343
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10874 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `ps_tmlookbook_lang`
WHERE `id_page` = 1
0.2 5 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10874) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10904
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10960) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10894) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkout_klarna" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10904) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10959) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10959) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10904) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10960) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10895 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10874) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 19
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 17
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 18
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10959
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 20
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10960
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 170 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10966) AND (id_product_attribute = 5305) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10967) AND (id_product_attribute = 5308) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10894) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10874
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10894) AND (id_product_attribute = 5004) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10965) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10959 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10958) AND (id_product_attribute = 5287) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10958) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10966) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `status`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 1 LIMIT 1
0.2 2 /modules/tmnewsletter/tmnewsletter.php:496
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 14 LIMIT 1
0.2 1 /classes/Supplier.php:192
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10958
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10967 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10771 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `ft_delay`
FROM ps_tmnewsletter_settings
WHERE `id_shop` = 1
AND `is_guest` = 1 LIMIT 1
0.2 2 /modules/tmnewsletter/tmnewsletter.php:529
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10771) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10894) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10965) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10958) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10958) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 9
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10967) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 10966) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10966) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10771) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 10967) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 20 LIMIT 1
0.2 1 /classes/Supplier.php:192
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 175 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 20
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 169 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10966 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10894
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10960 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10904 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10894 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10894 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10874 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 2
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 179 LIMIT 1
0.2 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10959 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 12
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10966
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 12 LIMIT 1
0.2 1 /classes/Supplier.php:192
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 10966 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 40
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 5
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 8
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `page_name`
FROM ps_tmmegalayout_pages
WHERE `id_layout` = 10
AND `status` = 1
0.2 1 /modules/tmmegalayout/classes/TMMegaLayoutLayouts.php:136
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10958 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 33
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:246
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10967 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10965 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10771 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149

Doubles

21
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
15
SELECT `page_name`
                        FROM ps_tmmegalayout_pages
                        WHERE `id_layout` = XX
                        AND `status` = XX
11
		SELECT *
		FROM ps_product_attachment pa
		LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
		LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX)
		WHERE pa.id_product