Snarlster Posted June 20, 2014 Share Posted June 20, 2014 (edited) Hi all, Im using prestashop 1.5.4.1 and all was working well until I started having some serious problems with my store snyrtivorur.is which describes itself by super long loading times at order creation and at order status changes in the BO. The configuration Information page also takes about 30-40 sec's to load. I've enabled "_PS_MODE_DEV_" and "_PS_DEBUG_PROFILING_" in the defines.inc.php file and got these screenshots from the Configuration information report. I also took screenshots of the status change but that was 15 images and it looks like my attachment size is limited here so i cant post them all, but here is the first page: I see that initContent is taking 33 seconds on the configuration page (attachment 1), but im not sure how to go from there. Most of my problems relate to orders or the order process and my guess is that its some sql error, but I really don't know how to problemsolve from here.. any help greatly appreciated Feel free to make an order under a fake account and pay with wire transfer, its at the point of payment (order creation) that the page hangs. My configuration information is as follows: Quote Information about your configuration. Server informationServer information: Linux #1 SMP Tue Jan 10 05:01:58 UTC 2012 x86_64 Server software version: Apache PHP version: 5.3.3-7+squeeze19 Memory limit: 512M Max execution time: 240Database informationMySQL version: 5.5.35-0+wheezy1 MySQL engine: InnoDB Tables prefix: pr_Store informationPrestaShop version: 1.5.4.1 Shop URL: http://snyrtivorur.is/ Current theme in use: warehouseMail configurationMail method: You are using your own SMTP parameters. SMTP server: smtp.gmail.com SMTP user: Defined SMTP password: Defined Encryption: ssl Port: 465Your informationYour web browser: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36 Check your configurationRequired parameters: OK Optional parameters: Please fix the following error(s) magicquotes List of changed files Changed/missing files have been detected.Missing files (91) README.md 987/autoupgrade/index.php modules/blockadvertising/advertising.jpg modules/blockadvertising/blockadvertising.php modules/blockadvertising/blockadvertising.tpl modules/blockadvertising/index.php modules/blockadvertising/logo.gif modules/blockadvertising/logo.png modules/blockadvertising/translations/index.php modules/blocklayered/blocklayered-15.css modules/blocklayered/blocklayered-ajax-back.php modules/blocklayered/blocklayered-ajax.php modules/blocklayered/blocklayered-attribute-indexer.php modules/blocklayered/blocklayered-no-products.tpl modules/blocklayered/blocklayered-price-indexer.php modules/blocklayered/blocklayered-url-indexer.php modules/blocklayered/blocklayered.css modules/blocklayered/blocklayered.js modules/blocklayered/blocklayered.php modules/blocklayered/blocklayered.tpl modules/blocklayered/delete.gif modules/blocklayered/index.php modules/blocklayered/logo.gif modules/blocklayered/logo.png modules/blocklayered/img/index.php modules/blocklayered/img/icon/index.php modules/blocklayered/img/icon/less.gif modules/blocklayered/img/icon/more.gif modules/blocklink/add.png modules/blocklink/blocklink.php modules/blocklink/blocklink.tpl modules/blocklink/index.php modules/blocklink/logo.gif modules/blocklink/logo.png modules/blocklink/prefs.gif modules/blocklink/img/arrow_right_2.png modules/blocklink/img/index.php modules/blocklink/translations/index.php modules/blocksearch/blocksearch-instantsearch.tpl modules/blocksearch/blocksearch-top.tpl modules/blocksearch/blocksearch.css modules/blocksearch/blocksearch.php modules/blocksearch/blocksearch.tpl modules/blocksearch/index.php modules/blocksearch/logo.gif modules/blocksearch/logo.png modules/blocksearch/img/bg_search_input.png modules/blocksearch/img/bg_search_submit.png modules/blocksearch/img/index.php modules/blocksearch/translations/index.php modules/importerosc/ajax.php modules/importerosc/importerosc.php modules/importerosc/index.php modules/importerosc/logo.gif modules/importerosc/logo.png modules/importerosc/passwordhash.php modules/importerosc/translations/index.php modules/shopimporter/ajax.php modules/shopimporter/index.php modules/shopimporter/logo.gif modules/shopimporter/logo.png modules/shopimporter/shopimporter.js modules/shopimporter/shopimporter.php modules/shopimporter/img/ajax-loader.gif modules/shopimporter/img/delete.gif modules/shopimporter/img/error.png modules/shopimporter/img/file.png modules/shopimporter/img/force.gif modules/shopimporter/img/index.php modules/shopimporter/img/ok.png modules/shopimporter/img/skip.png modules/shopimporter/img/stop.png modules/shopimporter/img/warn.png modules/shopimporter/translations/index.php override/classes/cache/index.php override/classes/controller/index.php override/classes/db/index.php override/classes/exception/index.php override/classes/helper/index.php override/classes/log/index.php override/classes/module/index.php override/classes/order/index.php override/classes/pdf/index.php override/classes/range/index.php override/classes/shop/index.php override/classes/stock/index.php override/classes/tax/index.php override/classes/webservice/index.php override/controllers/admin/index.php override/controllers/admin/templates/index.php override/controllers/front/index.php Updated files (28) 987/themes/default/template/controllers/modules/list.tpl 987/themes/default/template/helpers/form/form.tpl config/defines.inc.php modules/blockcms/blockcms.tpl modules/blocknewsletter/mails/index.php modules/blocknewsletter/mails/en/index.php modules/blockwishlist/mails/index.php modules/blockwishlist/mails/en/index.php modules/cashondelivery/cashondelivery.php modules/cashondelivery/index.php modules/cashondelivery/logo.png modules/editorial/EditorialClass.php modules/editorial/editorial.php modules/editorial/editorial.tpl modules/editorial/homepage_logo_1.jpg modules/editorial/index.php modules/editorial/translations/index.php modules/followup/mails/index.php modules/followup/mails/en/index.php modules/mailalerts/mails/index.php modules/mailalerts/mails/en/index.php modules/referralprogram/mails/index.php modules/referralprogram/mails/en/index.php modules/sendtoafriend/mails/index.php modules/sendtoafriend/mails/en/index.php override/index.php override/classes/index.php override/controllers/index.php Edited June 20, 2014 by Snarlster (see edit history) Link to comment Share on other sites More sharing options...
JPresta.com Posted June 20, 2014 Share Posted June 20, 2014 The configuration page is slow because it is fetching lot of informations (not built to be fast). What you should do is making an order (your slow page) with the profiling enabled and show us the result. Link to comment Share on other sites More sharing options...
El Patron Posted June 20, 2014 Share Posted June 20, 2014 we have seen similar issues with front office order creation caused by sending email confirmation. Are you using smtp rather than php for mail? Link to comment Share on other sites More sharing options...
Snarlster Posted June 20, 2014 Author Share Posted June 20, 2014 On 6/20/2014 at 2:35 PM, joemartin said: The configuration page is slow because it is fetching lot of informations (not built to be fast). What you should do is making an order (your slow page) with the profiling enabled and show us the result. Hi, thank you for your reply... You mean the information configuration page is slow because it is built to be slow? Does 33 seconds seem normal as is the case in the first image? Im doing an order as you suggested, and as I arrive on the "choose payment method", I get a this Fatal error: Quote Fatal error: Uncaught exception 'Exception' with message 'Serialization of 'SimpleXMLElement' is not allowed' in /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php:267 Stack trace: #0 /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php(267): serialize(Object(Context)) #1 /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php(310): Controller->sizeofvar(Object(Context)) #2 /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php(237): Controller->displayDebug() #3 /var/www/virtual/snyrtivorur.is/htdocs/classes/Dispatcher.php(349): Controller->run() #4 /var/www/virtual/snyrtivorur.is/htdocs/index.php(28): DispatcherCore->dispatch() #5 {main} Next exception 'Exception' with message 'Serialization of 'SimpleXMLElement' is not allowed' in /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php:267 Stack trace: #0 /var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php(0): serialize() #1 /var/www/virtual/snyrtivorur.is/htdocs/tools/pro in/var/www/virtual/snyrtivorur.is/htdocs/tools/profiling/Controller.php on line 267 as I arrive on the 5th step, it loads very fast, but for some reason it say's that some update sql command is taking almost 14 secs... here is the first part of that report: Quote Load time: 481msGood boy! That's what I call a webserver! config: 97ms constructor: 0ms init: 28ms checkAccess: 0ms setMedia: 2ms postProcess: 0ms initHeader: 0ms initContent: 223ms initFooter: 49ms display: 83ms Hook processing: 282ms / 22.06 MbdisplayTop: 111ms / 6.38 Mb displayHeader: 94ms / 13.06 Mb displayFooter: 48ms / 1.34 Mb displayRightColumn: 16ms / 0.51 Mb moduleRoutes: 7ms / 0.58 Mb maxHeader: 2ms / 0.14 Mb freeFblock: 2ms / 0.04 Mb maxInfos2: 1ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb Memory peak usage: 41.26 Mbconfig: 12.62 Mb constructor: 0 Mb init: 4.23 Mb checkAccess: 0 Mb setMedia: 0.26 Mb postProcess: 0 Mb initHeader: 0.01 Mb initContent: 19.98 Mb initFooter: 1.36 Mb display: 1.03 Mb Total cache size (in Cache class): 1.5 Mb DB type: DbPDO SQL Queries: 150 queries Time spent querying: 85ms Included files: 242Size of included files: 2.66 Mb Globals (> 1 Ko only): 169 KoFBPSC_MONTH ≈ 32.6 Ko HTTP_SERVER_VARS ≈ 16.2 Ko _SERVER ≈ 16.2 Ko _ENV ≈ 15.1 Ko HTTP_ENV_VARS ≈ 15.1 Ko FBPSC_REF_LANG ≈ 13.7 Ko FBPSC_ZONE ≈ 13.3 Ko FBPSC_CONNECTORS ≈ 10.3 Ko FBPSC_HOOKS ≈ 8.8 Ko _MODULES ≈ 4.7 Ko _REQUEST ≈ 3.3 Ko HTTP_COOKIE_VARS ≈ 3.3 Ko _COOKIE ≈ 3.3 Ko FBPSC_JS_MSG ≈ 2.4 Ko _GET ≈ 1.6 Ko FBPSC_CONFIGURATION ≈ 1.6 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Stopwatch (with SQL_NO_CACHE) (total = 150)13.891 ms UPDATE `pr_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 632 AND `id_page` = 159 AND `id_shop` = 1in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:116 4.489 ms 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 `pr_hook` h INNER JOIN `pr_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:187 USING FILESORT - 89 rows browsed3.007 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `pr_module` m INNER JOIN `pr_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM pr_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:296 USING FILESORT - 445 rows browsed Then as I press the "Place My Order", it takes a long time 30+ seconds, then I get a "redirect in 5 seconds" in french for some reason which I think interrupts the report because the report say's that Im a good boy... which I cant be with a 30+ sec delay as customers press the buy button. I've had a couple of impatient customers that refresh or go back and create a couple of orders because of this problem, here's the report: Quote Load time: 474msGood boy! That's what I call a webserver! config: 69ms constructor: 0ms init: 40ms checkAccess: 0ms setMedia: 2ms postProcess: 0ms initHeader: 0ms initContent: 242ms initFooter: 35ms display: 85ms Hook processing: 287ms / 21.56 MbdisplayLeftColumn: 99ms / 3.73 Mb displayHeader: 91ms / 13.04 Mb displayFooter: 35ms / 1.34 Mb displayTop: 22ms / 1.43 Mb displayRightColumn: 11ms / 0.43 Mb displayOrderConfirmation: 9ms / 0.73 Mb displayPaymentReturn: 8ms / 0.08 Mb moduleRoutes: 6ms / 0.58 Mb maxHeader: 2ms / 0.14 Mb freeFblock: 2ms / 0.04 Mb maxInfos2: 1ms / 0 Mb actionDispatcher: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb Memory peak usage: 42.24 Mbconfig: 10.74 Mb constructor: 0 Mb init: 7.54 Mb checkAccess: 0 Mb setMedia: 0.26 Mb postProcess: 0 Mb initHeader: 0.01 Mb initContent: 19.49 Mb initFooter: 1.36 Mb display: 1.06 Mb Total cache size (in Cache class): 1.51 Mb DB type: DbPDO SQL Queries: 148 queries Time spent querying: 99ms Included files: 250Size of included files: 2.74 Mb Globals (> 1 Ko only): 175 KoFBPSC_MONTH ≈ 32.8 Ko _SERVER ≈ 17.1 Ko HTTP_SERVER_VARS ≈ 17.1 Ko HTTP_ENV_VARS ≈ 15.6 Ko _ENV ≈ 15.6 Ko FBPSC_REF_LANG ≈ 13.7 Ko FBPSC_ZONE ≈ 13.3 Ko FBPSC_CONNECTORS ≈ 10.3 Ko FBPSC_HOOKS ≈ 8.8 Ko _MODULES ≈ 4.7 Ko _REQUEST ≈ 4.5 Ko HTTP_COOKIE_VARS ≈ 3.3 Ko _COOKIE ≈ 3.3 Ko FBPSC_JS_MSG ≈ 2.4 Ko _GET ≈ 2.2 Ko FBPSC_CONFIGURATION ≈ 1.6 Ko HTTP_GET_VARS ≈ 1.5 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Stopwatch (with SQL_NO_CACHE) (total = 148)35.07 ms SELECT SQL_NO_CACHE p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category FROM `pr_product_sale` ps LEFT JOIN `pr_product` p ON ps.`id_product` = p.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pr_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = 1 AND cl.id_shop = 1 WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (1) ) GROUP BY product_shop.id_product ORDER BY sales DESC LIMIT 0, 5in /var/www/virtual/snyrtivorur.is/htdocs/classes/ProductSale.php:162 USING FILESORT - 483 rows browsed6.06 ms UPDATE `pr_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 632 AND `id_page` = 491 AND `id_shop` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:116 3.989 ms 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 `pr_hook` h INNER JOIN `pr_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:187 USING FILESORT - 89 rows browsed3.113 ms INSERT INTO `pr_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('632', '491', '1', '1', '1') in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:126 2.63 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `pr_module` m INNER JOIN `pr_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM pr_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:296 USING FILESORT - 445 rows browsed2.368 ms SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = 9 AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_lang` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockcms/BlockCMSModel.php:323 1 row browsed1.765 ms 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 `pr_configuration` c LEFT JOIN `pr_configuration_lang` cl ON (c.id_configuration = cl.id_configuration) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Configuration.php:116 621 rows browsed1.572 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:16:17' >= `from` AND '2014-06-20 19:16:17' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2213) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed1.468 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:16:17' >= `from` AND '2014-06-20 19:16:17' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2079) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed1.374 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:16:17' >= `from` AND '2014-06-20 19:16:17' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2203) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed1.326 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:16:17' >= `from` AND '2014-06-20 19:16:17' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2151) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed1.32 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:16:17' >= `from` AND '2014-06-20 19:16:17' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2114) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:16:17' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed1.104 ms SELECT SQL_NO_CACHE `id_date_range`, `time_end` FROM `pr_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `pr_date_range`) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/DateRange.php:49 149769 rows browsed0.741 ms SELECT SQL_NO_CACHE * FROM `pr_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 1 AND `id_state` IN (0, 47) AND ('98238' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '98238'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/tax/TaxRulesTaxManager.php:92 USING FILESORT - 2 rows browsed0.645 ms SELECT SQL_NO_CACHE t.*, d.`tax_computation_method` FROM `pr_order_detail_tax` t LEFT JOIN `pr_order_detail` d ON (d.`id_order_detail` = t.`id_order_detail`) WHERE d.`id_order_detail` = 1083 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/OrderDetail.php:314 1229 rows browsed0.619 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM pr_shop_url su LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'snyrtivorur.is' OR su.domain_ssl = 'snyrtivorur.is') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:317 USING FILESORT - 1 row browsed0.578 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2203 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed0.522 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `pr_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `pr_module` m in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:163 89 rows browsed0.518 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2203) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.504 ms SELECT SQL_NO_CACHE wp.`id_product`, wp.`quantity`, p.`quantity` AS product_quantity, pl.`name`, wp.`id_product_attribute`, wp.`priority`, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM `pr_wishlist_product` wp LEFT JOIN `pr_product` p ON p.`id_product` = wp.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_lang` pl ON pl.`id_product` = wp.`id_product` AND pl.id_shop = 1 LEFT JOIN `pr_wishlist` w ON w.`id_wishlist` = wp.`id_wishlist` LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.id_lang=1 AND cl.id_shop = 1 WHERE w.`id_customer` = 3 AND pl.`id_lang` = 1 AND wp.`id_wishlist` = 1 AND wp.`quantity` != 0 GROUP BY p.id_product, wp.id_product_attribute in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:284 USING FILESORT - 31 rows browsed Useless GROUP BY need to be removed0.489 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pr_lang` l INNER JOIN pr_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:774 9 rows browsed0.469 ms SELECT SQL_NO_CACHE * FROM `pr_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 47) AND ('98238' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '98238'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/tax/TaxRulesTaxManager.php:92 USING FILESORT - 1 row browsed0.453 ms SELECT SQL_NO_CACHE `id_address` FROM `pr_address` WHERE `id_customer` = 3 AND `deleted` = 0 AND `active` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Address.php:328 4 rows browsed0.448 ms SELECT SQL_NO_CACHE * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Meta.php:141 1 row browsed0.444 ms SELECT SQL_NO_CACHE * FROM `pr_order_detail` od LEFT JOIN `pr_product` p ON (p.id_product = od.product_id) LEFT JOIN `pr_product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = 300 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:490 1 row browsed0.433 ms SELECT SQL_NO_CACHE t.name, COUNT(pt.id_tag) AS times FROM `pr_product_tag` pt LEFT JOIN `pr_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `pr_product` p ON (p.id_product = pt.id_product) INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (1) ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 0, 10 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Tag.php:150 USING FILESORT - 1 row browsed0.425 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `pr_meta` m LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Dispatcher.php:426 USING FILESORT - 25 rows browsed0.411 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2203) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed0.407 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.391 ms SELECT SQL_NO_CACHE * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 8) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.383 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `pr_lang` l LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:670 3 rows browsed0.383 ms SELECT SQL_NO_CACHE * FROM `pr_currency` c INNER JOIN pr_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 GROUP BY c.id_currency ORDER BY `name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:208 USING FILESORT - 25 rows browsed Useless GROUP BY need to be removed0.368 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2079) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed0.367 ms SELECT SQL_NO_CACHE * FROM `pr_tax_lang` WHERE `id_tax` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed0.365 ms SELECT SQL_NO_CACHE * FROM `pr_tax` a WHERE (a.id_tax = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.365 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2213) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.362 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2114 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed0.361 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2203 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed0.361 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2203 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed0.356 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2114) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.355 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.353 ms 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 pr_shop_group gs LEFT JOIN pr_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:602 USING FILESORT - 1 row browsed0.35 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2079 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed0.343 ms SELECT SQL_NO_CACHE al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_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 pac.`id_product_attribute` = 0 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:301 0 rows browsed0.34 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.339 ms SELECT SQL_NO_CACHE * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order-confirmation' OR m.page='orderconfirmation') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Meta.php:141 2 rows browsed0.338 ms SELECT SQL_NO_CACHE * FROM `pr_currency` c INNER JOIN pr_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 GROUP BY c.id_currency ORDER BY `name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:208 USING FILESORT - 25 rows browsed Useless GROUP BY need to be removed0.337 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.328 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2079) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.321 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2151) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.306 ms SELECT SQL_NO_CACHE id_shop FROM `pr_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1184 1 row browsed0.301 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'freeFblock' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.291 ms SELECT SQL_NO_CACHE * FROM `pr_country` a LEFT JOIN `pr_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 7 LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 109) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.289 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2114) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed0.283 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.283 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_group` WHERE `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Group.php:125 1 row browsed0.278 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2213 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed0.278 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2151) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed0.274 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.269 ms SELECT SQL_NO_CACHE * FROM `pr_group` a LEFT JOIN `pr_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.267 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2079 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed0.266 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_medium' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed0.266 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:200 1 row browsed0.264 ms SELECT SQL_NO_CACHE SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = 0 AND `id_cart` = 1403 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1632 1 row browsed0.263 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `pr_tab` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Tab.php:260 104 rows browsed0.262 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:200 1 row browsed0.259 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'medium_warehouse' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed0.254 ms SELECT SQL_NO_CACHE al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_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 pac.`id_product_attribute` = 0 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:301 0 rows browsed0.253 ms SELECT SQL_NO_CACHE image_shop.id_image FROM pr_image i INNER JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) WHERE id_product = 2743 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:645 1 row browsed0.247 ms SELECT SQL_NO_CACHE * FROM `pr_customer` a WHERE (a.id_customer = 3) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.238 ms SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = 8 AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_lang` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockcms/BlockCMSModel.php:323 1 row browsed0.237 ms SELECT SQL_NO_CACHE `width`, `height` FROM pr_image_type WHERE `name` = 'medium_default' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Image.php:367 1 row browsed0.237 ms SELECT SQL_NO_CACHE COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 146 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1574 0 rows browsed0.237 ms SELECT SQL_NO_CACHE id_page_type FROM pr_page_type WHERE name = 'orderconfirmation' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:96 1 row browsed0.236 ms SELECT SQL_NO_CACHE `id_country`, `id_state`, `vat_number`, `postcode` FROM `pr_address` WHERE `id_address` = 9 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Address.php:294 1 row browsed0.234 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.23 ms SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = 'paypal' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1546 1 row browsed0.229 ms SELECT SQL_NO_CACHE * FROM `pr_hook_alias` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:142 86 rows browsed0.228 ms SELECT SQL_NO_CACHE w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter` FROM `pr_wishlist` w WHERE `id_customer` = 3 AND id_shop = 1 ORDER BY w.`name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:188 USING FILESORT - 4 rows browsed0.227 ms SELECT SQL_NO_CACHE * FROM `pr_currency` a LEFT JOIN `pr_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 4) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.227 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.226 ms SELECT SQL_NO_CACHE * FROM `pr_cart` a WHERE (a.id_cart = 1403) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.224 ms SELECT SQL_NO_CACHE SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = 0 AND `id_cart` = 1403 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1632 1 row browsed0.224 ms SELECT SQL_NO_CACHE * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 9) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.224 ms SELECT SQL_NO_CACHE * FROM `pr_lang` a LEFT JOIN `pr_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.222 ms SELECT SQL_NO_CACHE `width`, `height` FROM pr_image_type WHERE `name` = 'small_default' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Image.php:367 1 row browsed0.222 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_small' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed0.221 ms SELECT SQL_NO_CACHE * FROM `pr_image` a LEFT JOIN `pr_image_shop` `c` ON a.id_image = c.id_image AND c.id_shop = 1 WHERE (a.id_image = 705) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.221 ms SELECT SQL_NO_CACHE * FROM `pr_orders` a WHERE (a.id_order = 300) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.22 ms SELECT SQL_NO_CACHE name FROM `pr_category_lang` , pr_product WHERE `id_product` = 2743 AND `id_category_default` = `id_category` AND `id_lang` = 7 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/ganalytics/ganalytics.php:220 3 rows browsed0.219 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2151 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed0.219 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2114 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed0.218 ms SELECT SQL_NO_CACHE COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 131 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1574 0 rows browsed0.215 ms SELECT SQL_NO_CACHE domain FROM pr_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/ShopUrl.php:151 1 row browsed0.214 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.212 ms SELECT SQL_NO_CACHE * FROM `pr_country` a LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.21 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.208 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2114 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed0.208 ms SELECT SQL_NO_CACHE `id_module`, `name` FROM `pr_module` in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:898 89 rows browsed0.207 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.207 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2151 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed0.206 ms SELECT SQL_NO_CACHE id_group FROM pr_customer_group WHERE id_customer = 3 in /var/www/virtual/snyrtivorur.is/htdocs/classes/controller/FrontController.php:893 1 row browsed0.201 ms SELECT SQL_NO_CACHE `id_order` FROM `pr_orders` WHERE `id_cart` = 1403 AND id_shop IN (1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1007 1 row browsed0.201 ms SELECT SQL_NO_CACHE `is_guest` FROM `pr_customer` cu LEFT JOIN `pr_cart` ca ON (ca.`id_customer` = cu.`id_customer`) WHERE ca.`id_cart` = 1403 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Cart.php:3540 1 row browsed0.2 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2213 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed0.197 ms SELECT SQL_NO_CACHE cg.`id_group` FROM pr_customer_group cg WHERE cg.`id_customer` = 3 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:627 1 row browsed0.197 ms SELECT SQL_NO_CACHE * FROM `pr_address` a WHERE (a.id_address = 137) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.196 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.194 ms SELECT SQL_NO_CACHE * FROM `pr_module_currency` WHERE `id_module` = 6 AND `id_shop` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:268 2 rows browsed0.189 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2213) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed0.189 ms SELECT SQL_NO_CACHE * FROM `pr_image_lang` WHERE `id_image` = 705 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed0.189 ms SELECT SQL_NO_CACHE * FROM `pr_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.188 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayPaymentReturn' OR `name` = 'paymentreturn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.188 ms SELECT SQL_NO_CACHE * FROM `pr_group_lang` WHERE `id_group` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed0.185 ms SELECT SQL_NO_CACHE * FROM `pr_shop` a WHERE (a.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed0.185 ms SELECT SQL_NO_CACHE count(*) FROM `pr_orders` WHERE `id_cart` = 1403 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Cart.php:1090 1 row browsed0.183 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.183 ms SELECT SQL_NO_CACHE * FROM `pr_country_lang` WHERE `id_country` = 21 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed0.182 ms SELECT SQL_NO_CACHE `title`, `content` FROM pr_freeblock WHERE `id_lang`=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/freeblock/freeblock.php:102 1 row browsed0.181 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = 131 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:692 1 row browsed0.179 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `pr_stock_available` WHERE (id_product = 2743) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/stock/StockAvailable.php:361 1 row browsed0.178 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'maxInfos2' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.178 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = 146 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:692 1 row browsed0.176 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.176 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayOrderConfirmation' OR `name` = 'orderconfirmation' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.176 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = '3' AND active = 1 AND `deleted` = 0 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:370 1 row browsed0.175 ms SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:612 1 row browsed0.173 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 280 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed0.172 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'maxHeader' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed0.172 ms SELECT SQL_NO_CACHE version FROM `pr_module` WHERE name = 'paypal' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/paypal/paypal.php:215 1 row browsed0.167 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'small_warehouse' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed0.166 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.165 ms SELECT SQL_NO_CACHE domain_ssl FROM pr_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/ShopUrl.php:163 1 row browsed0.164 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed0.164 ms SELECT SQL_NO_CACHE `id_page` FROM `pr_page` WHERE `id_page_type` = 71 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:78 1 row browsed0.163 ms SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:612 1 row browsed0.16 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 283 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed0.159 ms SELECT SQL_NO_CACHE `name` FROM `pr_country_lang` WHERE `id_lang` = 7 AND `id_country` = 109 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Country.php:202 1 row browsed0.159 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 453 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed0.159 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 268 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed0.156 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM pr_required_field in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1143 1 row browsed0.155 ms SELECT SQL_NO_CACHE `id_wishlist`, `name`, `token` FROM `pr_wishlist` WHERE `id_wishlist` = 1 AND `id_customer` = 3 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:140 1 row browsed0.155 ms SELECT SQL_NO_CACHE * FROM `pr_hook_module_exceptions` WHERE `id_shop` IN (1) in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1507 1 row browsed0.151 ms SELECT SQL_NO_CACHE id_shop FROM `pr_currency_shop` WHERE `id_currency` = 4 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1184 1 row browsed0.147 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2079 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed0.144 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2213 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed0.143 ms SELECT SQL_NO_CACHE `price_display_method` FROM `pr_group` WHERE `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Group.php:136 1 row browsed0.141 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2151 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed Doubles (IDs replaced by "XX") (total = 102)10 SELECT `id_customer` FROM `pr_customer` WHERE `id_customer` = XX AND `passwd` = 'fXXaXXcXXbcXXfXXbdXXcXX' LIMIT XX5 SELECT `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX5 SELECT `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX5 SELECT `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX5 SELECT product_shop.`price`, product_shop.`ecotax`, XX as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop =XX) WHERE (p.`id_product` = XX)5 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (XX, XX) AND `id_product_attribute` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_customer` IN (XX, XX) AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND id_cart IN (XX, XX) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= IF(id_product_attribute=XX,XX ,XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT XX5 SELECT * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX4 SELECT cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX2 SELECT al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pac.`id_product_attribute` = XX2 SELECT * FROM `pr_currency` c INNER JOIN pr_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX GROUP BY c.id_currency ORDER BY `name` ASC2 SELECT * FROM `pr_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC2 SELECT hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = XX AND h.`id_hook` = XX AND h.`id_hook` = hm.`id_hook` AND `id_shop` = XX LIMIT XX2 SELECT COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = XX LIMIT XX2 SELECT SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = XX AND `id_cart` = XX LIMIT XX2 SELECT * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = XX LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = XX WHERE (a.id_cms = XX) LIMIT XX2 SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX2 SELECT `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT XX2 SELECT cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = XX AND (c.`active` = XX OR c.`id_cms` = XX) AND cl.`id_lang` = XX LIMIT XX1 SELECT `id_page` FROM `pr_page` WHERE `id_page_type` = XX LIMIT XX1 SELECT `reduction` FROM `pr_group` WHERE `id_group` = XX LIMIT XX1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_medium' LIMIT XX1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'small_warehouse' LIMIT XX1 SELECT `width`, `height` FROM pr_image_type WHERE `name` = 'medium_default' LIMIT XX1 SELECT * FROM `pr_tax_lang` WHERE `id_tax` = XX1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'medium_warehouse' LIMIT XX1 UPDATE `pr_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = XX AND `id_shop` = XX1 SELECT id_tab, class_name FROM `pr_tab`1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'freeFblock' OR `name` = '' LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'maxHeader' OR `name` = '' LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'maxInfosXX' OR `name` = '' LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT XX1 SELECT 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 `pr_hook` h INNER JOIN `pr_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = XX) INNER JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_small' LIMIT XX1 SELECT * FROM `pr_tax` a WHERE (a.id_tax = XX) LIMIT XX1 INSERT INTO `pr_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('XX', 'XX', 'XX', 'XX', 'XX')1 SELECT `id_date_range`, `time_end` FROM `pr_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `pr_date_range`) LIMIT XX1 SELECT `title`, `content` FROM pr_freeblock WHERE `id_lang`=XX LIMIT XX1 SELECT * FROM `pr_image_lang` WHERE `id_image` = XX1 SELECT * FROM `pr_image` a LEFT JOIN `pr_image_shop` `c` ON a.id_image = c.id_image AND c.id_shop = XX WHERE (a.id_image = XX) LIMIT XX1 SELECT image_shop.id_image FROM pr_image i INNER JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX AND image_shop.cover=XX) WHERE id_product = XX LIMIT XX1 SELECT SUM(quantity) FROM `pr_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX1 SELECT t.*, d.`tax_computation_method` FROM `pr_order_detail_tax` t LEFT JOIN `pr_order_detail` d ON (d.`id_order_detail` = t.`id_order_detail`) WHERE d.`id_order_detail` = XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayPaymentReturn' OR `name` = 'paymentreturn' LIMIT XX1 SELECT name FROM `pr_category_lang` , pr_product WHERE `id_product` = XX AND `id_category_default` = `id_category` AND `id_lang` = XX LIMIT XX1 SELECT * FROM `pr_order_detail` od LEFT JOIN `pr_product` p ON (p.id_product = od.product_id) LEFT JOIN `pr_product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = XX1 SELECT `name` FROM `pr_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX1 SELECT w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter` FROM `pr_wishlist` w WHERE `id_customer` = XX AND id_shop = XX ORDER BY w.`name` ASC1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT XX1 SELECT id_page_type FROM pr_page_type WHERE name = 'orderconfirmation' LIMIT XX1 SELECT `id_wishlist`, `name`, `token` FROM `pr_wishlist` WHERE `id_wishlist` = XX AND `id_customer` = XX LIMIT XX1 SELECT wp.`id_product`, wp.`quantity`, p.`quantity` AS product_quantity, pl.`name`, wp.`id_product_attribute`, wp.`priority`, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM `pr_wishlist_product` wp LEFT JOIN `pr_product` p ON p.`id_product` = wp.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pr_product_lang` pl ON pl.`id_product` = wp.`id_product` AND pl.id_shop = XX LEFT JOIN `pr_wishlist` w ON w.`id_wishlist` = wp.`id_wishlist` LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.id_lang=XX AND cl.id_shop = XX WHERE w.`id_customer` = XX AND pl.`id_lang` = XX AND wp.`id_wishlist` = XX AND wp.`quantity` != XX GROUP BY p.id_product, wp.id_product_attribute1 SELECT * FROM `pr_address` a WHERE (a.id_address = XX) LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayOrderConfirmation' OR `name` = 'orderconfirmation' LIMIT XX1 SELECT `width`, `height` FROM pr_image_type WHERE `name` = 'small_default' LIMIT XX1 SELECT id_group FROM pr_customer_group WHERE id_customer = XX1 SELECT id_shop FROM `pr_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX1 SELECT m.page, ml.url_rewrite, ml.id_lang FROM `pr_meta` m LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC1 SELECT * FROM `pr_hook_alias`1 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `pr_module` m INNER JOIN `pr_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM pr_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (XX)) =XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) AND (mg.`id_group` IN (XX)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`1 SELECT * FROM `pr_currency` a LEFT JOIN `pr_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX1 SELECT id_shop FROM `pr_currency_shop` WHERE `id_currency` = XX AND id_shop = XX LIMIT XX1 SELECT * FROM `pr_group_lang` WHERE `id_group` = XX1 SELECT * FROM `pr_group` a LEFT JOIN `pr_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = XX WHERE (a.id_group = XX) LIMIT XX1 SELECT * FROM `pr_cart` a WHERE (a.id_cart = XX) LIMIT XX1 SELECT `id_customer` FROM `pr_customer` WHERE `id_customer` = 'XX' AND active = XX AND `deleted` = XX LIMIT XX1 SELECT cg.`id_group` FROM pr_customer_group cg WHERE cg.`id_customer` = XX1 SELECT COUNT(DISTINCT l.id_lang) FROM `pr_lang` l INNER JOIN pr_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = XX) WHERE l.`active` = XX LIMIT XX1 SELECT l.*, ls.`id_shop` FROM `pr_lang` l LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang)1 SELECT 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 `pr_configuration` c LEFT JOIN `pr_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)1 SELECT id_required_field, object_name, field_name FROM pr_required_field1 SELECT * FROM `pr_shop` a WHERE (a.id_shop = XX) LIMIT XX1 SELECT * FROM `pr_country` a LEFT JOIN `pr_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX1 SELECT * FROM `pr_shop_group` a WHERE (a.id_shop_group = XX) LIMIT XX1 SELECT domain_ssl FROM pr_shop_url WHERE main = XX AND id_shop=XX LIMIT XX1 SELECT domain FROM pr_shop_url WHERE main=XX AND id_shop = XX LIMIT XX1 SELECT * FROM `pr_customer` a WHERE (a.id_customer = XX) LIMIT XX1 SELECT * FROM `pr_lang` a LEFT JOIN `pr_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX1 SELECT `price_display_method` FROM `pr_group` WHERE `id_group` = XX LIMIT XX1 SELECT count(*) FROM `pr_orders` WHERE `id_cart` = XX LIMIT XX1 SELECT * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = XX AND ml.id_shop = XX LIMIT XX1 SELECT * FROM `pr_hook_module_exceptions` WHERE `id_shop` IN (XX)1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT XX1 SELECT * FROM `pr_module_currency` WHERE `id_module` = XX AND `id_shop` = XX1 SELECT `id_module` FROM `pr_module` WHERE `name` = 'paypal' LIMIT XX1 SELECT version FROM `pr_module` WHERE name = 'paypal' LIMIT XX1 SELECT t.name, COUNT(pt.id_tag) AS times FROM `pr_product_tag` pt LEFT JOIN `pr_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `pr_product` p ON (p.id_product = pt.id_product) INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE t.`id_lang` = XX AND product_shop.`active` = XX AND product_shop.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (XX) ) GROUP BY t.id_tag ORDER BY times DESC LIMIT XX, XX1 SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM pr_shop_url su LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'snyrtivorur.is' OR su.domain_ssl = 'snyrtivorur.is') AND s.active = XX AND s.deleted = XX ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT XX1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT XX1 SELECT m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `pr_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX) as total FROM `pr_module` m1 SELECT `id_module`, `name` FROM `pr_module`1 SELECT * FROM `pr_country` a LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX1 SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `pr_address` WHERE `id_address` = XX LIMIT XX1 SELECT * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order-confirmation' OR m.page='orderconfirmation') AND ml.id_lang = XX AND ml.id_shop = XX LIMIT XX1 SELECT `id_address` FROM `pr_address` WHERE `id_customer` = XX AND `deleted` = XX AND `active` = XX LIMIT XX1 SELECT * FROM `pr_country_lang` WHERE `id_country` = XX1 SELECT `is_guest` FROM `pr_customer` cu LEFT JOIN `pr_cart` ca ON (ca.`id_customer` = cu.`id_customer`) WHERE ca.`id_cart` = XX LIMIT XX1 SELECT * FROM `pr_orders` a WHERE (a.id_order = XX) LIMIT XX1 SELECT `id_order` FROM `pr_orders` WHERE `id_cart` = XX AND id_shop IN (XX) LIMIT XX1 SELECT 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 pr_shop_group gs LEFT JOIN pr_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN pr_shop_url su ON s.id_shop = su.id_shop AND su.main = XX WHERE s.deleted = XX AND gs.deleted = XX ORDER BY gs.name, s.name1 SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`eanXX`, p.`upc`, cl.`link_rewrite` AS category FROM `pr_product_sale` ps LEFT JOIN `pr_product` p ON ps.`id_product` = p.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pr_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `pr_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX AND image_shop.cover=XX) LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = XX AND cl.id_shop = XX WHERE product_shop.`active` = XX AND p.`visibility` != 'none' AND p.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (XX) ) GROUP BY product_shop.id_product ORDER BY sales DESC LIMIT XX, XX Tables stress19 product_shop15 hook14 product13 customer7 product_lang7 category_lang6 module6 image_type6 hook_module6 shop_url5 specific_price_priority5 shop5 orders5 specific_price5 lang5 product_group_reduction_cache4 cms_lang4 lang_shop4 cms4 currency_shop3 address3 image_shop3 group3 wishlist3 image3 meta3 country_lang3 meta_lang3 currency2 order_detail2 image_lang2 theme2 module_shop2 tax_rule2 country2 product_attribute2 cart2 country_shop2 product_attribute_shop2 category_product2 customer_group2 attribute_group2 date_range2 product_attribute_combination2 cms_shop2 shop_group2 attribute_lang2 attribute_group_lang2 category_group2 attribute1 stock_available1 tab1 page1 page_type1 order_detail_tax1 tax1 product_tag1 tag1 hook_module_exceptions1 module_currency1 group_shop1 group_lang1 configuration_lang1 product_sale1 required_field1 freeblock1 tax_lang1 module_group1 configuration1 hook_alias1 wishlist_product ObjectModel instances5 Customer5 Product4 Currency3 Order2 Tax2 Shop2 Address2 Cart2 Country2 CMS2 ShopGroup2 Language1 ConnectionsSource1 Group1 Image Included files1 ./index.php2 config/config.inc.php 3 config/defines.inc.php 4 config/settings.inc.php 5 config/autoload.php 6 config/alias.php 7 classes/Autoload.php 8 cache/class_index.php 9 tools/profiling/Controller.php 10 classes/controller/Controller.php 11 tools/profiling/ObjectModel.php 12 classes/ObjectModel.php 13 tools/profiling/Hook.php 14 classes/Hook.php 15 tools/profiling/Db.php 16 classes/db/Db.php 17 tools/profiling/Tools.php 18 classes/Tools.php 19 classes/Context.php 20 classes/shop/Shop.php 21 classes/db/DbPDO.php 22 classes/cache/Cache.php 23 classes/Validate.php 24 classes/db/DbQuery.php 25 config/defines_uri.inc.php 26 classes/Configuration.php 27 classes/Language.php 28 classes/Country.php 29 classes/Collection.php 30 classes/shop/ShopGroup.php 31 classes/Cookie.php 32 classes/Rijndael.php 33 classes/Customer.php 34 classes/Link.php 35 classes/shop/ShopUrl.php 36 config/smarty.config.inc.php 37 tools/smarty/Smarty.class.php 38 tools/smarty/sysplugins/smarty_internal_data.php 39 tools/smarty/sysplugins/smarty_internal_templatebase.php 40 tools/smarty/sysplugins/smarty_internal_template.php 41 tools/smarty/sysplugins/smarty_resource.php 42 tools/smarty/sysplugins/smarty_internal_resource_file.php 43 tools/smarty/sysplugins/smarty_cacheresource.php 44 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 45 config/smartyfront.config.inc.php 46 classes/Dispatcher.php 47 classes/Group.php 48 controllers/front/OrderConfirmationController.php 49 classes/controller/FrontController.php 50 themes/warehouse/lang/en.php 51 classes/Currency.php 52 classes/Cart.php 53 classes/Address.php 54 classes/CartRule.php 55 classes/Meta.php 56 classes/Product.php 57 override/classes/Product.php 58 classes/order/Order.php 59 classes/module/Module.php 60 modules/bankwire/bankwire.php 61 classes/PaymentModule.php 62 classes/Translate.php 63 modules/bankwire/translations/en.php 64 classes/Media.php 65 modules/pluginadder/pluginadder.php 66 modules/pluginadder/translations/en.php 67 modules/blockmyaccount/blockmyaccount.php 68 modules/blockmyaccount/translations/en.php 69 modules/blockcurrencies/blockcurrencies.php 70 themes/warehouse/modules/blockcurrencies/translations/en.php 71 modules/blockcurrencies/translations/en.php 72 modules/blockmyaccountfooter/blockmyaccountfooter.php 73 themes/warehouse/modules/blockmyaccountfooter/en.php 74 modules/blockmyaccountfooter/translations/en.php 75 modules/blockcms/blockcms.php 76 modules/blockcms/BlockCMSModel.php 77 themes/warehouse/modules/blockcms/translations/en.php 78 modules/blockcms/translations/en.php 79 modules/blocktags/blocktags.php 80 themes/warehouse/modules/blocktags/translations/en.php 81 modules/blocktags/translations/en.php 82 modules/favoriteproducts/favoriteproducts.php 83 modules/favoriteproducts/translations/en.php 84 cache/smarty/compile/57/f9/9c/57f99cb18d2190e1a3b3e5b8eea2f9b5b4078ccb.file.favoriteproducts-header.tpl.php 85 tools/smarty/sysplugins/smarty_internal_filter_handler.php 86 tools/minify_html/minify_html.class.php 87 modules/feeder/feeder.php 88 modules/feeder/translations/en.php 89 cache/smarty/compile/6d/de/aa/6ddeaab2bad1782f1d0e68ca279fb7f0775defdf.file.feederHeader.tpl.php 90 tools/smarty/plugins/modifier.escape.php 91 modules/blockuserinfo/blockuserinfo.php 92 themes/warehouse/modules/blockuserinfo/translations/en.php 93 modules/blockuserinfo/translations/en.php 94 modules/blockcart/blockcart.php 95 themes/warehouse/modules/blockcart/en.php 96 modules/blockcart/translations/en.php 97 modules/blocksearch_mod/blocksearch_mod.php 98 modules/blocksearch_mod/translations/en.php 99 modules/manufactuterslider/manufactuterslider.php 100 modules/manufactuterslider/translations/en.php 101 modules/homefeatured_mod/homefeatured_mod.php 102 modules/homefeatured_mod/translations/en.php 103 modules/columnadverts/columnadverts.php 104 modules/columnadverts/en.php 105 modules/blocklanguages/blocklanguages.php 106 themes/warehouse/modules/blocklanguages/translations/en.php 107 modules/blocklanguages/translations/en.php 108 modules/blocksocial_mod/blocksocial_mod.php 109 modules/blocksocial_mod/translations/en.php 110 modules/ganalytics/ganalytics.php 111 modules/ganalytics/translations/en.php 112 modules/ganalytics/backward_compatibility/backward.php 113 modules/ganalytics/backward_compatibility/Display.php 114 cache/smarty/compile/23/69/ac/2369ac5c9c752bfc4696164df7e6e478ca12252a.file.header.tpl.php 115 modules/productscategory/productscategory.php 116 themes/warehouse/modules/productscategory/translations/en.php 117 modules/productscategory/translations/en.php 118 modules/blockbestsellers/blockbestsellers.php 119 themes/warehouse/modules/blockbestsellers/translations/en.php 120 modules/blockbestsellers/translations/en.php 121 modules/productcomments/productcomments.php 122 themes/warehouse/modules/productcomments/translations/en.php 123 modules/productcomments/translations/en.php 124 modules/blocknewsletter/blocknewsletter.php 125 modules/blocknewsletter/translations/en.php 126 modules/blockwishlist/blockwishlist.php 127 themes/warehouse/modules/blockwishlist/en.php 128 modules/blockwishlist/translations/en.php 129 modules/specialslider/specialslider.php 130 modules/specialslider/translations/en.php 131 modules/blockcategories/blockcategories.php 132 themes/warehouse/modules/blockcategories/translations/en.php 133 modules/blockcategories/translations/en.php 134 modules/mailalerts/mailalerts.php 135 modules/mailalerts/MailAlert.php 136 themes/warehouse/modules/mailalerts/en.php 137 modules/mailalerts/translations/en.php 138 modules/homepageadvertise/homepageadvertise.php 139 modules/homepageadvertise/en.php 140 modules/facebookslide/facebookslide.php 141 modules/facebookslide/translations/en.php 142 modules/simpleslideshow/simpleslideshow.php 143 modules/simpleslideshow/en.php 144 modules/facebookpsconnect/facebookpsconnect.php 145 modules/facebookpsconnect/conf/common.conf.php 146 modules/facebookpsconnect/lib/warnings_class.php 147 modules/facebookpsconnect/lib/module-tools_class.php 148 modules/facebookpsconnect/en.php 149 modules/facebookpsconnect/conf/hook.conf.php 150 modules/facebookpsconnect/lib/hook/hook-ctrl_class.php 151 modules/facebookpsconnect/lib/hook/i-hook_class.php 152 modules/facebookpsconnect/lib/hook/hook-display_class.php 153 cache/smarty/compile/65/20/ac/6520ac84a3f79bfcd0dab3d6397700e61ad5a6aa.file.header.tpl.php 154 modules/paypal/paypal.php 155 modules/paypal/api/paypal_lib.php 156 modules/paypal/api/paypal_connect.php 157 modules/paypal/paypal_logos.php 158 modules/paypal/paypal_orders.php 159 modules/paypal/paypal_tools.php 160 modules/paypal/translations/en.php 161 cache/smarty/compile/48/3f/3d/483f3d6987e35823a4f29b99e4a72d0ab3df3cdb.file.paypal.js.php 162 modules/editorial/editorial.php 163 themes/warehouse/modules/editorial/translations/en.php 164 modules/editorial/translations/en.php 165 modules/editorial/EditorialClass.php 166 modules/crossselling_mod/crossselling_mod.php 167 modules/crossselling_mod/translations/en.php 168 modules/megamenuiqit/megamenuiqit.php 169 modules/megamenuiqit/megamenutoplinks.class.php 170 modules/megamenuiqit/megamenutab.class.php 171 modules/megamenuiqit/translations/en.php 172 modules/textbanners/textbanners.php 173 modules/textbanners/TextBanner.php 174 modules/textbanners/translations/en.php 175 modules/categoryslider/categoryslider.php 176 modules/categoryslider/translations/en.php 177 modules/blocklayered_mod/blocklayered_mod.php 178 modules/blocklayered_mod/en.php 179 modules/headerlinks/headerlinks.php 180 modules/headerlinks/translations/en.php 181 modules/quickviewiqit/quickviewiqit.php 182 modules/themeeditor/themeeditor.php 183 modules/themeeditor/translations/en.php 184 cache/smarty/compile/4c/4f/8c/4c4f8c0d665d99094414c955f05dea289d238a56.file.blockcurrencies.tpl.php 185 cache/smarty/compile/9e/50/c9/9e50c901f69c2176666d33a5e4e4474adb81df82.file.blockuserinfo.tpl.php 186 cache/smarty/compile/0b/75/fd/0b75fdf0bb9a7078372f2c12b4a29557a843c0d5.file.blocksearch-top_mod.tpl.php 187 cache/smarty/compile/ff/20/07/ff2007db4af1268cae1a47990da8a75cb968bae4.file.blocksearch-instantsearch_mod.tpl.php 188 classes/Customization.php 189 cache/smarty/compile/7b/74/f4/7b74f4099fe5b0cc97f3a2673b1400a708026066.file.blockcart.tpl.php 190 tools/smarty/plugins/modifier.replace.php 191 modules/pagesnotfound/pagesnotfound.php 192 modules/pagesnotfound/translations/en.php 193 modules/sekeywords/sekeywords.php 194 classes/module/ModuleGraph.php 195 modules/sekeywords/translations/en.php 196 cache/smarty/compile/37/80/cd/3780cdd09b7a0cc506c786dc404ce4fc516af069.file.blocklanguages.tpl.php 197 cache/smarty/compile/a2/6b/8b/a26b8b0d9ebbf798f3ee93af241205edfdb6f935.file.connector-buttons-js.tpl.php 198 cache/smarty/compile/7e/82/2c/7e822c48def52da29619f37f2594a3ed8c71f2dd.file.connector-buttons.tpl.php 199 cache/smarty/cache/headerlinks/0/1/1/1/99/76/40/997640a94d5469dc76135a5e0b33e506b90dee70.headerlinks.tpl.php 200 cache/smarty/cache/blockcategories/0/1/1/1/0/0/79/bb/d8/79bbd875b5f5983e29cc2e03ce25b816b4c85cb6.blockcategories.tpl.php 201 cache/smarty/cache/columnadverts/0/1/1/1/3e/43/02/3e4302371351c05aa899f009e804accbb0f01ba6.columnadverts.tpl.php 202 classes/Tag.php 203 classes/ProductSale.php 204 classes/Category.php 205 classes/tax/Tax.php 206 classes/Combination.php 207 classes/SpecificPrice.php 208 classes/tax/TaxManagerFactory.php 209 classes/tax/TaxRulesTaxManager.php 210 classes/tax/TaxManagerInterface.php 211 classes/tax/TaxCalculator.php 212 classes/GroupReduction.php 213 classes/Image.php 214 classes/ImageType.php 215 cache/smarty/compile/0b/5c/15/0b5c15c863498ee7fe21452c19664876a28cb0ee.file.blockbestsellers.tpl.php 216 cache/smarty/compile/df/b2/ba/dfb2ba31fed8e891541d9b2659cdb049d9bb80cc.file.block-account.tpl.php 217 modules/freeblock/freeblock.php 218 modules/freeblock/en.php 219 cache/smarty/compile/40/49/0b/40490b0553f6887e47a1e8eca8e34a5fe6f52c11.file.freeblock.tpl.php 220 modules/blockwishlist/WishList.php 221 cache/smarty/compile/de/8d/fc/de8dfcbe9b787e1cf567fa2660a49d3383851f05.file.blockwishlist.tpl.php 222 cache/smarty/compile/43/c6/d6/43c6d669d0ee449cb6e1ceb045c7f7ffb750f28b.file.column.tpl.php 223 classes/stock/StockAvailable.php 224 classes/order/OrderDetail.php 225 cache/smarty/compile/29/7f/2b/297f2b9e323264d823343c11d280b505ae35bb53.file.payment_return.tpl.php 226 cache/smarty/cache/blockmyaccountfooter/0/1/1/1/5e/2e/87/5e2e87399bf3bea6c42a9a86b2204c2cd1b0e0ac.blockmyaccountfooter.tpl.php 227 classes/CMS.php 228 cache/smarty/compile/94/4b/d0/944bd0a432819a8a00d15e3ae88e9d3b5e7a6c9b.file.blockcms.tpl.php 229 modules/statsdata/statsdata.php 230 modules/statsdata/translations/en.php 231 classes/Connection.php 232 classes/Page.php 233 classes/ConnectionsSource.php 234 classes/DateRange.php 235 cache/smarty/cache/blocksocial_mod/0/1/1/1/4a/3c/98/4a3c988c55f4435778e0c59e4a64330e2389ecdf.blocksocial_mod.tpl.php 236 modules/blockfooterhtml/blockfooterhtml.php 237 modules/blockfooterhtml/translations/en.php 238 cache/smarty/cache/blockfooterhtml/0/1/1/1/da/b9/4d/dab94d15e3af0ac7f590ad0945923deaa0ca01b1.blockfooterhtml.tpl.php 239 cache/smarty/compile/09/9d/4e/099d4ea712516fb3e4a30b3fd3dc6162ae86fb1e.file.blocknewsletter.tpl.php 240 cache/smarty/compile/b7/d0/cc/b7d0cc1ec453ee73c3bfa4ad5f01f3ed344f4fb8.file.buttons-content.tpl.php 241 classes/Tab.php 242 cache/smarty/compile/d5/ca/e6/d5cae6ca66fe72ac265d0c9a04486d9af3b8ae78.file.order-confirmation.tpl.php 243 cache/smarty/compile/d3/5a/db/d35adb15d9286ac987a0733374386674955eff51.file.order-steps.tpl.php 244 cache/smarty/compile/44/a7/47/44a7473a53f771ffcf3edf42e5a58938bb241a16.file.errors.tpl.php 245 cache/smarty/compile/d6/ba/a1/d6baa17abde216bece1954957d69645e4025d49d.file.layout.tpl.php 246 cache/smarty/compile/59/36/bb/5936bbdc1ba30915eac123e6da2774b27c1bdbe6.file.header.tpl.php 247 cache/smarty/cache/facebookslide/0/1/1/1/e3/b7/10/e3b71060641cddecf9d13f3e9a8dd05e1df9a6e5.facebookslide.tpl.php 248 cache/smarty/cache/megamenuiqit/0/1/1/1/82/45/db/8245db56215ea4b671ae4f4f93d0672defe87d3e.megamenuiqit.tpl.php 249 cache/smarty/compile/68/bd/e7/68bde75678f7315632567d489d22155a65e4df38.file.breadcrumb1.tpl.php 250 cache/smarty/compile/34/af/49/34af49b826079d9dd757868d00877bab20287cc0.file.footer.tpl.php Ps, is there some better way to paste the reports to the forum? Link to comment Share on other sites More sharing options...
Snarlster Posted June 20, 2014 Author Share Posted June 20, 2014 (edited) On 6/20/2014 at 2:50 PM, El Patron said: we have seen similar issues with front office order creation caused by sending email confirmation. Are you using smtp rather than php for mail? Yes, I am using smtp... I would have thought that would be better?? Im using google apps for my email and I have a dedicated email for the website. I just tried using php instead of smtp and its much much faster! I still get the fatal error on step 3 as described in my reply to JoeMartin. The Order change AND Order creation takes much shorter now though... its only about 10 seconds to load now instead of 30-40 before! So this did help a lot. Still seems like there is some problem, 10 sec is also a little to long isn't it? Here is the error report when sending email with php + profiling set to true: Quote Load time: 458ms Good boy! That's what I call a webserver!config: 62ms constructor: 0ms init: 39ms checkAccess: 0ms setMedia: 2ms postProcess: 0ms initHeader: 0ms initContent: 249ms initFooter: 25ms display: 80ms Hook processing: 284ms / 21.55 MbdisplayLeftColumn: 105ms / 3.73 Mb displayHeader: 93ms / 13.04 Mb displayFooter: 25ms / 1.34 Mb displayTop: 23ms / 1.43 Mb displayRightColumn: 12ms / 0.43 Mb displayOrderConfirmation: 10ms / 0.73 Mb moduleRoutes: 6ms / 0.58 Mb displayPaymentReturn: 3ms / 0.08 Mb maxHeader: 2ms / 0.14 Mb freeFblock: 2ms / 0.04 Mb maxInfos2: 1ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb Memory peak usage: 42.22 Mbconfig: 10.74 Mb constructor: 0 Mb init: 7.52 Mb checkAccess: 0 Mb setMedia: 0.26 Mb postProcess: 0 Mb initHeader: 0.01 Mb initContent: 19.49 Mb initFooter: 1.36 Mb display: 1.06 Mb Total cache size (in Cache class): 1.5 Mb DB type: DbPDO SQL Queries: 145 queries Time spent querying: 98ms Included files: 250Size of included files: 2.74 Mb Globals (> 1 Ko only): 175 KoFBPSC_MONTH ≈ 32.9 Ko _SERVER ≈ 17.1 Ko HTTP_SERVER_VARS ≈ 17.1 Ko HTTP_ENV_VARS ≈ 15.6 Ko _ENV ≈ 15.6 Ko FBPSC_REF_LANG ≈ 13.7 Ko FBPSC_ZONE ≈ 13.3 Ko FBPSC_CONNECTORS ≈ 10.3 Ko FBPSC_HOOKS ≈ 8.8 Ko _MODULES ≈ 4.7 Ko _REQUEST ≈ 4.5 Ko HTTP_COOKIE_VARS ≈ 3.4 Ko _COOKIE ≈ 3.4 Ko FBPSC_JS_MSG ≈ 2.4 Ko _GET ≈ 2.2 Ko FBPSC_CONFIGURATION ≈ 1.6 Ko HTTP_GET_VARS ≈ 1.5 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Stopwatch (with SQL_NO_CACHE) (total = 145) 31.538 ms SELECT SQL_NO_CACHE p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category FROM `pr_product_sale` ps LEFT JOIN `pr_product` p ON ps.`id_product` = p.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pr_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = 1 AND cl.id_shop = 1 WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (1) ) GROUP BY product_shop.id_product ORDER BY sales DESC LIMIT 0, 5in /var/www/virtual/snyrtivorur.is/htdocs/classes/ProductSale.php:162 USING FILESORT - 483 rows browsed 13.199 ms 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 `pr_hook` h INNER JOIN `pr_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:187 USING FILESORT - 89 rows browsed 2.631 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `pr_module` m INNER JOIN `pr_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM pr_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:296 USING FILESORT - 445 rows browsed 2.386 ms UPDATE `pr_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 632 AND `id_page` = 491 AND `id_shop` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:116 2.228 ms 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 `pr_configuration` c LEFT JOIN `pr_configuration_lang` cl ON (c.id_configuration = cl.id_configuration) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Configuration.php:116 621 rows browsed 1.295 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:49:47' >= `from` AND '2014-06-20 19:49:47' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2114) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed 1.211 ms SELECT SQL_NO_CACHE `id_date_range`, `time_end` FROM `pr_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `pr_date_range`) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/DateRange.php:49 149769 rows browsed 1.153 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:49:47' >= `from` AND '2014-06-20 19:49:47' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2151) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed 1.132 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:49:47' >= `from` AND '2014-06-20 19:49:47' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2203) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed 1.105 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:49:47' >= `from` AND '2014-06-20 19:49:47' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2079) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed 1.056 ms SELECT SQL_NO_CACHE *, ( IF ('2014-06-20 19:49:47' >= `from` AND '2014-06-20 19:49:47' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 21, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 3, 32, 0)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (0, 2213) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 4) AND `id_country` IN (0, 21) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 3) AND ( (`from` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2014-06-20 19:49:47' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:232 USING FILESORT - 7 rows browsed 0.731 ms SELECT SQL_NO_CACHE * FROM `pr_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 1 AND `id_state` IN (0, 47) AND ('98238' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '98238'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/tax/TaxRulesTaxManager.php:92 USING FILESORT - 2 rows browsed 0.666 ms SELECT SQL_NO_CACHE t.*, d.`tax_computation_method` FROM `pr_order_detail_tax` t LEFT JOIN `pr_order_detail` d ON (d.`id_order_detail` = t.`id_order_detail`) WHERE d.`id_order_detail` = 1084 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/OrderDetail.php:314 1230 rows browsed 0.661 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `pr_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `pr_module` m in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:163 89 rows browsed 0.631 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM pr_shop_url su LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'snyrtivorur.is' OR su.domain_ssl = 'snyrtivorur.is') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:317 USING FILESORT - 1 row browsed 0.617 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pr_lang` l INNER JOIN pr_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:774 9 rows browsed 0.577 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2079 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed 0.56 ms SELECT SQL_NO_CACHE * FROM `pr_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 47) AND ('98238' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '98238'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/tax/TaxRulesTaxManager.php:92 USING FILESORT - 1 row browsed 0.544 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2213 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed 0.519 ms SELECT SQL_NO_CACHE wp.`id_product`, wp.`quantity`, p.`quantity` AS product_quantity, pl.`name`, wp.`id_product_attribute`, wp.`priority`, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM `pr_wishlist_product` wp LEFT JOIN `pr_product` p ON p.`id_product` = wp.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_lang` pl ON pl.`id_product` = wp.`id_product` AND pl.id_shop = 1 LEFT JOIN `pr_wishlist` w ON w.`id_wishlist` = wp.`id_wishlist` LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.id_lang=1 AND cl.id_shop = 1 WHERE w.`id_customer` = 3 AND pl.`id_lang` = 1 AND wp.`id_wishlist` = 1 AND wp.`quantity` != 0 GROUP BY p.id_product, wp.id_product_attribute in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:284 USING FILESORT - 31 rows browsed Useless GROUP BY need to be removed 0.51 ms SELECT SQL_NO_CACHE * FROM `pr_order_detail` od LEFT JOIN `pr_product` p ON (p.id_product = od.product_id) LEFT JOIN `pr_product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = 301 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:490 1 row browsed 0.499 ms SELECT SQL_NO_CACHE * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Meta.php:141 1 row browsed 0.48 ms SELECT SQL_NO_CACHE * FROM `pr_country` a LEFT JOIN `pr_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 7 LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 109) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.48 ms SELECT SQL_NO_CACHE `id_page` FROM `pr_page` WHERE `id_page_type` = 71 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:78 1 row browsed 0.472 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2203) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.459 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.425 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `pr_tab` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Tab.php:260 104 rows browsed 0.422 ms SELECT SQL_NO_CACHE t.name, COUNT(pt.id_tag) AS times FROM `pr_product_tag` pt LEFT JOIN `pr_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `pr_product` p ON (p.id_product = pt.id_product) INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (1) ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 0, 10 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Tag.php:150 USING FILESORT - 1 row browsed 0.422 ms SELECT SQL_NO_CACHE `id_order` FROM `pr_orders` WHERE `id_cart` = 1404 AND id_shop IN (1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1007 1 row browsed 0.415 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.413 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `pr_meta` m LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Dispatcher.php:426 USING FILESORT - 25 rows browsed 0.403 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2203) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed 0.398 ms SELECT SQL_NO_CACHE SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = 0 AND `id_cart` = 1404 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1632 1 row browsed 0.395 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'freeFblock' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.394 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = 146 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:692 1 row browsed 0.394 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.386 ms SELECT SQL_NO_CACHE * FROM `pr_currency` c INNER JOIN pr_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 GROUP BY c.id_currency ORDER BY `name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:208 USING FILESORT - 25 rows browsed Useless GROUP BY need to be removed 0.384 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2213) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.367 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.365 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2079) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.362 ms SELECT SQL_NO_CACHE * FROM `pr_tax` a WHERE (a.id_tax = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.36 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2114) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed 0.358 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2114 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed 0.349 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2151) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.338 ms 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 pr_shop_group gs LEFT JOIN pr_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:602 USING FILESORT - 1 row browsed 0.336 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2151) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed 0.334 ms SELECT SQL_NO_CACHE * FROM `pr_currency` c INNER JOIN pr_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 GROUP BY c.id_currency ORDER BY `name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:208 USING FILESORT - 25 rows browsed Useless GROUP BY need to be removed 0.334 ms SELECT SQL_NO_CACHE al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_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 pac.`id_product_attribute` = 0 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:301 0 rows browsed 0.334 ms SELECT SQL_NO_CACHE * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 2114) AND (b.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.332 ms SELECT SQL_NO_CACHE id_page_type FROM pr_page_type WHERE name = 'orderconfirmation' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Page.php:96 1 row browsed 0.325 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2079) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed 0.32 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2079 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed 0.315 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2203 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed 0.315 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2203 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed 0.315 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2151 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed 0.31 ms SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, 0 as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) WHERE (p.`id_product` = 2213) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:2628 1 row browsed 0.306 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_group` WHERE `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Group.php:125 1 row browsed 0.304 ms SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = 'paypal' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1546 1 row browsed 0.304 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2079 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed 0.303 ms SELECT SQL_NO_CACHE COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 146 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1574 0 rows browsed 0.3 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2151 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed 0.299 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2213 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed 0.297 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `pr_lang` l LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang) in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:670 3 rows browsed 0.296 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:200 1 row browsed 0.295 ms SELECT SQL_NO_CACHE * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 8) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.293 ms SELECT SQL_NO_CACHE * FROM `pr_tax_lang` WHERE `id_tax` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed 0.288 ms SELECT SQL_NO_CACHE SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = 0 AND `id_cart` = 1404 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:1632 1 row browsed 0.287 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.285 ms SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = 2203 ORDER BY `id_specific_price_priority` DESC LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/SpecificPrice.php:189 0 rows browsed 0.278 ms SELECT SQL_NO_CACHE * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order-confirmation' OR m.page='orderconfirmation') AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Meta.php:141 2 rows browsed 0.276 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 280 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed 0.276 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_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 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/Shop.php:200 1 row browsed 0.273 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.271 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2213 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed 0.266 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.262 ms SELECT SQL_NO_CACHE al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_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 pac.`id_product_attribute` = 0 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:301 0 rows browsed 0.259 ms SELECT SQL_NO_CACHE `title`, `content` FROM pr_freeblock WHERE `id_lang`=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/freeblock/freeblock.php:102 1 row browsed 0.259 ms SELECT SQL_NO_CACHE id_group FROM pr_customer_group WHERE id_customer = 3 in /var/www/virtual/snyrtivorur.is/htdocs/classes/controller/FrontController.php:893 1 row browsed 0.252 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.249 ms SELECT SQL_NO_CACHE name FROM `pr_category_lang` , pr_product WHERE `id_product` = 1314 AND `id_category_default` = `id_category` AND `id_lang` = 7 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/ganalytics/ganalytics.php:220 3 rows browsed 0.241 ms SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = 8 AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_lang` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockcms/BlockCMSModel.php:323 1 row browsed 0.241 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'maxInfos2' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.239 ms SELECT SQL_NO_CACHE * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 9) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.239 ms SELECT SQL_NO_CACHE image_shop.id_image FROM pr_image i INNER JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) WHERE id_product = 1314 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/order/Order.php:645 1 row browsed 0.236 ms SELECT SQL_NO_CACHE * FROM `pr_address` a WHERE (a.id_address = 137) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.234 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.234 ms SELECT SQL_NO_CACHE * FROM `pr_orders` a WHERE (a.id_order = 301) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.231 ms SELECT SQL_NO_CACHE * FROM `pr_customer` a WHERE (a.id_customer = 3) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.226 ms SELECT SQL_NO_CACHE * FROM `pr_image_lang` WHERE `id_image` = 1079 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed 0.223 ms SELECT SQL_NO_CACHE * FROM `pr_currency` a LEFT JOIN `pr_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 4) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.223 ms SELECT SQL_NO_CACHE w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter` FROM `pr_wishlist` w WHERE `id_customer` = 3 AND id_shop = 1 ORDER BY w.`name` ASC in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:188 USING FILESORT - 4 rows browsed 0.223 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayOrderConfirmation' OR `name` = 'orderconfirmation' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.223 ms SELECT SQL_NO_CACHE * FROM `pr_hook_alias` in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:142 86 rows browsed 0.221 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.221 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.221 ms SELECT SQL_NO_CACHE * FROM `pr_image` a LEFT JOIN `pr_image_shop` `c` ON a.id_image = c.id_image AND c.id_shop = 1 WHERE (a.id_image = 1079) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.217 ms SELECT SQL_NO_CACHE COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = 131 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1574 0 rows browsed 0.216 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2151 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed 0.211 ms SELECT SQL_NO_CACHE * FROM `pr_group` a LEFT JOIN `pr_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.21 ms SELECT SQL_NO_CACHE `id_address` FROM `pr_address` WHERE `id_customer` = 3 AND `deleted` = 0 AND `active` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Address.php:328 4 rows browsed 0.21 ms SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = 2114 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Product.php:4353 1 row browsed 0.204 ms SELECT SQL_NO_CACHE * FROM `pr_module_currency` WHERE `id_module` = 6 AND `id_shop` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Currency.php:268 2 rows browsed 0.204 ms SELECT SQL_NO_CACHE SUM(quantity) FROM `pr_stock_available` WHERE (id_product = 1314) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/stock/StockAvailable.php:361 1 row browsed 0.203 ms SELECT SQL_NO_CACHE cg.`id_group` FROM pr_customer_group cg WHERE cg.`id_customer` = 3 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:627 1 row browsed 0.203 ms SELECT SQL_NO_CACHE `id_module`, `name` FROM `pr_module` in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:898 89 rows browsed 0.203 ms SELECT SQL_NO_CACHE * FROM `pr_shop` a WHERE (a.id_shop = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.203 ms SELECT SQL_NO_CACHE * FROM `pr_country` a LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.202 ms SELECT SQL_NO_CACHE domain FROM pr_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/ShopUrl.php:151 1 row browsed 0.2 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'maxHeader' OR `name` = '' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.198 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.196 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'medium_warehouse' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed 0.196 ms SELECT SQL_NO_CACHE `id_country`, `id_state`, `vat_number`, `postcode` FROM `pr_address` WHERE `id_address` = 9 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Address.php:294 1 row browsed 0.195 ms SELECT SQL_NO_CACHE `id_hook` FROM `pr_hook` WHERE `name` = 'displayPaymentReturn' OR `name` = 'paymentreturn' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Hook.php:125 2 rows browsed 0.193 ms SELECT SQL_NO_CACHE * FROM `pr_lang` a LEFT JOIN `pr_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.19 ms SELECT SQL_NO_CACHE `is_guest` FROM `pr_customer` cu LEFT JOIN `pr_cart` ca ON (ca.`id_customer` = cu.`id_customer`) WHERE ca.`id_cart` = 1404 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Cart.php:3540 1 row browsed 0.189 ms SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = 9 AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_lang` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockcms/BlockCMSModel.php:323 1 row browsed 0.189 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 283 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed 0.179 ms SELECT SQL_NO_CACHE * FROM `pr_hook_module_exceptions` WHERE `id_shop` IN (1) in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:1507 1 row browsed 0.179 ms SELECT SQL_NO_CACHE * FROM `pr_group_lang` WHERE `id_group` = 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed 0.177 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.176 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.176 ms SELECT SQL_NO_CACHE hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = 131 AND h.`id_hook` = 9 AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/module/Module.php:692 1 row browsed 0.175 ms SELECT SQL_NO_CACHE version FROM `pr_module` WHERE name = 'paypal' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/paypal/paypal.php:215 1 row browsed 0.175 ms SELECT SQL_NO_CACHE * FROM `pr_country_lang` WHERE `id_country` = 21 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:219 3 rows browsed 0.175 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.17 ms SELECT SQL_NO_CACHE id_shop FROM `pr_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1184 1 row browsed 0.169 ms SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:612 1 row browsed 0.168 ms SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Language.php:612 1 row browsed 0.168 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = '3' AND active = 1 AND `deleted` = 0 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:370 1 row browsed 0.166 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 268 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed 0.164 ms SELECT SQL_NO_CACHE * FROM `pr_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:212 1 row browsed 0.163 ms SELECT SQL_NO_CACHE domain_ssl FROM pr_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/shop/ShopUrl.php:163 1 row browsed 0.163 ms SELECT SQL_NO_CACHE `name` FROM `pr_country_lang` WHERE `id_lang` = 7 AND `id_country` = 109 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Country.php:202 1 row browsed 0.163 ms SELECT SQL_NO_CACHE `id_customer` FROM `pr_customer` WHERE `id_customer` = 3 AND `passwd` = 'f149a17c78101762bc6f5086bd0978c4' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Customer.php:484 1 row browsed 0.162 ms SELECT SQL_NO_CACHE `id_wishlist`, `name`, `token` FROM `pr_wishlist` WHERE `id_wishlist` = 1 AND `id_customer` = 3 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/modules/blockwishlist/WishList.php:140 1 row browsed 0.162 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'small_warehouse' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed 0.161 ms SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 453 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Category.php:844 1 row browsed 0.159 ms SELECT SQL_NO_CACHE `width`, `height` FROM pr_image_type WHERE `name` = 'small_default' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Image.php:367 1 row browsed 0.152 ms SELECT SQL_NO_CACHE id_shop FROM `pr_currency_shop` WHERE `id_currency` = 4 AND id_shop = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1184 1 row browsed 0.152 ms SELECT SQL_NO_CACHE `width`, `height` FROM pr_image_type WHERE `name` = 'medium_default' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Image.php:367 1 row browsed 0.15 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_small' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed 0.149 ms SELECT SQL_NO_CACHE `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = 2114 AND `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/GroupReduction.php:139 0 rows browsed 0.146 ms SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_medium' LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/ImageType.php:137 0 rows browsed 0.144 ms SELECT SQL_NO_CACHE `price_display_method` FROM `pr_group` WHERE `id_group` = 1 LIMIT 1 in /var/www/virtual/snyrtivorur.is/htdocs/classes/Group.php:136 1 row browsed 0.141 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM pr_required_field in /var/www/virtual/snyrtivorur.is/htdocs/classes/ObjectModel.php:1143 1 row browsed Doubles (IDs replaced by "XX") (total = 99) 10 SELECT `id_customer` FROM `pr_customer` WHERE `id_customer` = XX AND `passwd` = 'fXXaXXcXXbcXXfXXbdXXcXX' LIMIT XX 5 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `pr_specific_price` WHERE `id_product` IN (XX, XX) AND `id_product_attribute` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_customer` IN (XX, XX) AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND id_cart IN (XX, XX) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= IF(id_product_attribute=XX,XX ,XX) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT XX 5 SELECT `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX 5 SELECT `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX 5 SELECT product_shop.`price`, product_shop.`ecotax`, XX as id_product_attribute FROM `pr_product` p INNER JOIN `pr_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop =XX) WHERE (p.`id_product` = XX) 5 SELECT * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `pr_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX 5 SELECT `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX 4 SELECT cl.`link_rewrite` FROM `pr_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX 2 SELECT * FROM `pr_currency` c INNER JOIN pr_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX GROUP BY c.id_currency ORDER BY `name` ASC 2 SELECT al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity" FROM `pr_product_attribute_combination` pac LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `pr_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pac.`id_product_attribute` = XX 2 SELECT * FROM `pr_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC 2 SELECT hm.`id_module` FROM `pr_hook_module` hm, `pr_hook` h WHERE hm.`id_module` = XX AND h.`id_hook` = XX AND h.`id_hook` = hm.`id_hook` AND `id_shop` = XX LIMIT XX 2 SELECT COUNT(*) FROM `pr_hook_module` hm LEFT JOIN `pr_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'header' AND hm.`id_module` = XX LIMIT XX 2 SELECT SUM(total_paid_tax_incl) FROM `pr_orders` WHERE `reference` = XX AND `id_cart` = XX LIMIT XX 2 SELECT cl.`meta_title`, cl.`link_rewrite` FROM `pr_cms_lang` cl INNER JOIN `pr_cms` c ON (cl.`id_cms` = c.`id_cms`) WHERE cl.`id_cms` = XX AND (c.`active` = XX OR c.`id_cms` = XX) AND cl.`id_lang` = XX LIMIT XX 2 SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM pr_shop s LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN pr_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX 2 SELECT * FROM `pr_cms` a LEFT JOIN `pr_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = XX LEFT JOIN `pr_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = XX WHERE (a.id_cms = XX) LIMIT XX 2 SELECT `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT XX 1 SELECT `width`, `height` FROM pr_image_type WHERE `name` = 'medium_default' LIMIT XX 1 SELECT `id_page` FROM `pr_page` WHERE `id_page_type` = XX LIMIT XX 1 SELECT id_page_type FROM pr_page_type WHERE name = 'orderconfirmation' LIMIT XX 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'medium_warehouse' LIMIT XX 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_medium' LIMIT XX 1 SELECT `id_date_range`, `time_end` FROM `pr_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `pr_date_range`) LIMIT XX 1 SELECT `reduction` FROM `pr_group` WHERE `id_group` = XX LIMIT XX 1 SELECT * FROM `pr_tax_lang` WHERE `id_tax` = XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'freeFblock' OR `name` = '' LIMIT XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'maxHeader' OR `name` = '' LIMIT XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'maxInfosXX' OR `name` = '' LIMIT XX 1 SELECT id_tab, class_name FROM `pr_tab` 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'taxManager' OR `name` = 'actionTaxManager' LIMIT XX 1 SELECT * FROM `pr_tax` a WHERE (a.id_tax = XX) LIMIT XX 1 UPDATE `pr_page_viewed` SET `counter` = `counter` + XX WHERE `id_date_range` = XX AND `id_page` = XX AND `id_shop` = XX 1 SELECT 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 `pr_hook` h INNER JOIN `pr_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = XX) INNER JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'small_warehouse' LIMIT XX 1 SELECT `title`, `content` FROM pr_freeblock WHERE `id_lang`=XX LIMIT XX 1 SELECT * FROM `pr_image` a LEFT JOIN `pr_image_shop` `c` ON a.id_image = c.id_image AND c.id_shop = XX WHERE (a.id_image = XX) LIMIT XX 1 SELECT image_shop.id_image FROM pr_image i INNER JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX AND image_shop.cover=XX) WHERE id_product = XX LIMIT XX 1 SELECT * FROM `pr_order_detail` od LEFT JOIN `pr_product` p ON (p.id_product = od.product_id) LEFT JOIN `pr_product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = XX 1 SELECT * FROM `pr_image_lang` WHERE `id_image` = XX 1 SELECT SUM(quantity) FROM `pr_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayPaymentReturn' OR `name` = 'paymentreturn' LIMIT XX 1 SELECT name FROM `pr_category_lang` , pr_product WHERE `id_product` = XX AND `id_category_default` = `id_category` AND `id_lang` = XX LIMIT XX 1 SELECT t.*, d.`tax_computation_method` FROM `pr_order_detail_tax` t LEFT JOIN `pr_order_detail` d ON (d.`id_order_detail` = t.`id_order_detail`) WHERE d.`id_order_detail` = XX 1 SELECT `name` FROM `pr_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX 1 SELECT * FROM `pr_address` a WHERE (a.id_address = XX) LIMIT XX 1 SELECT w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter` FROM `pr_wishlist` w WHERE `id_customer` = XX AND id_shop = XX ORDER BY w.`name` ASC 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayRightColumn' OR `name` = 'rightcolumn' LIMIT XX 1 SELECT `width`, `height` FROM pr_image_type WHERE `name` = 'small_default' LIMIT XX 1 SELECT `id_wishlist`, `name`, `token` FROM `pr_wishlist` WHERE `id_wishlist` = XX AND `id_customer` = XX LIMIT XX 1 SELECT wp.`id_product`, wp.`quantity`, p.`quantity` AS product_quantity, pl.`name`, wp.`id_product_attribute`, wp.`priority`, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM `pr_wishlist_product` wp LEFT JOIN `pr_product` p ON p.`id_product` = wp.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pr_product_lang` pl ON pl.`id_product` = wp.`id_product` AND pl.id_shop = XX LEFT JOIN `pr_wishlist` w ON w.`id_wishlist` = wp.`id_wishlist` LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.id_lang=XX AND cl.id_shop = XX WHERE w.`id_customer` = XX AND pl.`id_lang` = XX AND wp.`id_wishlist` = XX AND wp.`quantity` != XX GROUP BY p.id_product, wp.id_product_attribute 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayOrderConfirmation' OR `name` = 'orderconfirmation' LIMIT XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayFooter' OR `name` = 'footer' LIMIT XX 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `pr_image_type` WHERE `name` = 'warehouse_small' LIMIT XX 1 SELECT t.name, COUNT(pt.id_tag) AS times FROM `pr_product_tag` pt LEFT JOIN `pr_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `pr_product` p ON (p.id_product = pt.id_product) INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE t.`id_lang` = XX AND product_shop.`active` = XX AND product_shop.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (XX) ) GROUP BY t.id_tag ORDER BY times DESC LIMIT XX, XX 1 SELECT m.page, ml.url_rewrite, ml.id_lang FROM `pr_meta` m LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC 1 SELECT * FROM `pr_hook_alias` 1 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `pr_module` m INNER JOIN `pr_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE ((SELECT COUNT(*) FROM pr_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (XX)) =XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) AND (mg.`id_group` IN (XX)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 1 SELECT cg.`id_group` FROM pr_customer_group cg WHERE cg.`id_customer` = XX 1 SELECT id_shop FROM `pr_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX 1 SELECT * FROM `pr_currency` a LEFT JOIN `pr_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX 1 SELECT * FROM `pr_group_lang` WHERE `id_group` = XX 1 SELECT * FROM `pr_group` a LEFT JOIN `pr_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = XX WHERE (a.id_group = XX) LIMIT XX 1 SELECT `id_customer` FROM `pr_customer` WHERE `id_customer` = 'XX' AND active = XX AND `deleted` = XX LIMIT XX 1 SELECT id_shop FROM `pr_currency_shop` WHERE `id_currency` = XX AND id_shop = XX LIMIT XX 1 SELECT COUNT(DISTINCT l.id_lang) FROM `pr_lang` l INNER JOIN pr_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = XX) WHERE l.`active` = XX LIMIT XX 1 SELECT domain_ssl FROM pr_shop_url WHERE main = XX AND id_shop=XX LIMIT XX 1 SELECT l.*, ls.`id_shop` FROM `pr_lang` l LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang) 1 SELECT 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 `pr_configuration` c LEFT JOIN `pr_configuration_lang` cl ON (c.id_configuration = cl.id_configuration) 1 SELECT id_required_field, object_name, field_name FROM pr_required_field 1 SELECT * FROM `pr_shop` a WHERE (a.id_shop = XX) LIMIT XX 1 SELECT * FROM `pr_country` a LEFT JOIN `pr_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX 1 SELECT * FROM `pr_shop_group` a WHERE (a.id_shop_group = XX) LIMIT XX 1 SELECT domain FROM pr_shop_url WHERE main=XX AND id_shop = XX LIMIT XX 1 SELECT * FROM `pr_customer` a WHERE (a.id_customer = XX) LIMIT XX 1 SELECT * FROM `pr_lang` a LEFT JOIN `pr_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX 1 SELECT `price_display_method` FROM `pr_group` WHERE `id_group` = XX LIMIT XX 1 SELECT `id_address` FROM `pr_address` WHERE `id_customer` = XX AND `deleted` = XX AND `active` = XX LIMIT XX 1 SELECT `id_module` FROM `pr_module` WHERE `name` = 'paypal' LIMIT XX 1 SELECT * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order' OR m.page='order') AND ml.id_lang = XX AND ml.id_shop = XX LIMIT XX 1 SELECT * FROM `pr_hook_module_exceptions` WHERE `id_shop` IN (XX) 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayHeader' OR `name` = 'header' LIMIT XX 1 SELECT version FROM `pr_module` WHERE name = 'paypal' LIMIT XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayTop' OR `name` = 'top' LIMIT XX 1 SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM pr_shop_url su LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'snyrtivorur.is' OR su.domain_ssl = 'snyrtivorur.is') AND s.active = XX AND s.deleted = XX ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC 1 SELECT id_group FROM pr_customer_group WHERE id_customer = XX 1 SELECT `id_hook` FROM `pr_hook` WHERE `name` = 'displayLeftColumn' OR `name` = 'leftcolumn' LIMIT XX 1 SELECT * FROM `pr_module_currency` WHERE `id_module` = XX AND `id_shop` = XX 1 SELECT m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `pr_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX) as total FROM `pr_module` m 1 SELECT * FROM `pr_country_lang` WHERE `id_country` = XX 1 SELECT * FROM `pr_country` a LEFT JOIN `pr_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX 1 SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `pr_address` WHERE `id_address` = XX LIMIT XX 1 SELECT * FROM pr_meta m LEFT JOIN pr_meta_lang ml on (m.id_meta = ml.id_meta) WHERE (m.page = 'order-confirmation' OR m.page='orderconfirmation') AND ml.id_lang = XX AND ml.id_shop = XX LIMIT XX 1 SELECT `is_guest` FROM `pr_customer` cu LEFT JOIN `pr_cart` ca ON (ca.`id_customer` = cu.`id_customer`) WHERE ca.`id_cart` = XX LIMIT XX 1 SELECT 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 pr_shop_group gs LEFT JOIN pr_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN pr_shop_url su ON s.id_shop = su.id_shop AND su.main = XX WHERE s.deleted = XX AND gs.deleted = XX ORDER BY gs.name, s.name 1 SELECT `id_module`, `name` FROM `pr_module` 1 SELECT * FROM `pr_orders` a WHERE (a.id_order = XX) LIMIT XX 1 SELECT `id_order` FROM `pr_orders` WHERE `id_cart` = XX AND id_shop IN (XX) LIMIT XX 1 SELECT p.id_product, pl.`link_rewrite`, pl.`name`, pl.`description_short`, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`eanXX`, p.`upc`, cl.`link_rewrite` AS category FROM `pr_product_sale` ps LEFT JOIN `pr_product` p ON ps.`id_product` = p.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pr_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `pr_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX AND image_shop.cover=XX) LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `pr_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = XX AND cl.id_shop = XX WHERE product_shop.`active` = XX AND p.`visibility` != 'none' AND p.`id_product` IN ( SELECT cp.`id_product` FROM `pr_category_group` cg LEFT JOIN `pr_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` IN (XX) ) GROUP BY product_shop.id_product ORDER BY sales DESC LIMIT XX, XX Tables stress 19 product_shop 15 hook 14 product 13 customer 7 product_lang 7 category_lang 6 module 6 image_type 6 hook_module 6 shop_url 5 specific_price 5 specific_price_priority 5 shop 5 product_group_reduction_cache 5 lang 4 lang_shop 4 cms_lang 4 orders 4 currency_shop 4 cms 3 address 3 image_shop 3 group 3 wishlist 3 image 3 meta_lang 3 meta 3 currency 3 country_lang 2 image_lang 2 order_detail 2 country_shop 2 theme 2 product_attribute_shop 2 attribute_group_lang 2 product_attribute 2 tax_rule 2 product_attribute_combination 2 module_shop 2 category_group 2 customer_group 2 date_range 2 attribute 2 attribute_group 2 cms_shop 2 category_product 2 country 2 shop_group 2 attribute_lang 1 stock_available 1 tab 1 page 1 page_type 1 order_detail_tax 1 tax 1 product_tag 1 tag 1 configuration_lang 1 hook_module_exceptions 1 module_currency 1 group_lang 1 cart 1 product_sale 1 configuration 1 required_field 1 freeblock 1 tax_lang 1 group_shop 1 hook_alias 1 module_group 1 wishlist_product ObjectModel instances 5 Product 5 Customer 4 Currency 3 Order 2 Country 2 Tax 2 Address 2 Shop 2 CMS 2 Language 2 ShopGroup 1 ConnectionsSource 1 Group 1 Cart 1 Image Included files 1 ./index.php2 config/config.inc.php 3 config/defines.inc.php 4 config/settings.inc.php 5 config/autoload.php 6 config/alias.php 7 classes/Autoload.php 8 cache/class_index.php 9 tools/profiling/Controller.php 10 classes/controller/Controller.php 11 tools/profiling/ObjectModel.php 12 classes/ObjectModel.php 13 tools/profiling/Hook.php 14 classes/Hook.php 15 tools/profiling/Db.php 16 classes/db/Db.php 17 tools/profiling/Tools.php 18 classes/Tools.php 19 classes/Context.php 20 classes/shop/Shop.php 21 classes/db/DbPDO.php 22 classes/cache/Cache.php 23 classes/Validate.php 24 classes/db/DbQuery.php 25 config/defines_uri.inc.php 26 classes/Configuration.php 27 classes/Language.php 28 classes/Country.php 29 classes/Collection.php 30 classes/shop/ShopGroup.php 31 classes/Cookie.php 32 classes/Rijndael.php 33 classes/Customer.php 34 classes/Link.php 35 classes/shop/ShopUrl.php 36 config/smarty.config.inc.php 37 tools/smarty/Smarty.class.php 38 tools/smarty/sysplugins/smarty_internal_data.php 39 tools/smarty/sysplugins/smarty_internal_templatebase.php 40 tools/smarty/sysplugins/smarty_internal_template.php 41 tools/smarty/sysplugins/smarty_resource.php 42 tools/smarty/sysplugins/smarty_internal_resource_file.php 43 tools/smarty/sysplugins/smarty_cacheresource.php 44 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 45 config/smartyfront.config.inc.php 46 classes/Dispatcher.php 47 classes/Group.php 48 controllers/front/OrderConfirmationController.php 49 classes/controller/FrontController.php 50 themes/warehouse/lang/en.php 51 classes/Currency.php 52 classes/Cart.php 53 classes/Address.php 54 classes/CartRule.php 55 classes/Meta.php 56 classes/Product.php 57 override/classes/Product.php 58 classes/order/Order.php 59 classes/module/Module.php 60 modules/bankwire/bankwire.php 61 classes/PaymentModule.php 62 classes/Translate.php 63 modules/bankwire/translations/en.php 64 classes/Media.php 65 modules/pluginadder/pluginadder.php 66 modules/pluginadder/translations/en.php 67 modules/blockmyaccount/blockmyaccount.php 68 modules/blockmyaccount/translations/en.php 69 modules/blockcurrencies/blockcurrencies.php 70 themes/warehouse/modules/blockcurrencies/translations/en.php 71 modules/blockcurrencies/translations/en.php 72 modules/blockmyaccountfooter/blockmyaccountfooter.php 73 themes/warehouse/modules/blockmyaccountfooter/en.php 74 modules/blockmyaccountfooter/translations/en.php 75 modules/blockcms/blockcms.php 76 modules/blockcms/BlockCMSModel.php 77 themes/warehouse/modules/blockcms/translations/en.php 78 modules/blockcms/translations/en.php 79 modules/blocktags/blocktags.php 80 themes/warehouse/modules/blocktags/translations/en.php 81 modules/blocktags/translations/en.php 82 modules/favoriteproducts/favoriteproducts.php 83 modules/favoriteproducts/translations/en.php 84 cache/smarty/compile/57/f9/9c/57f99cb18d2190e1a3b3e5b8eea2f9b5b4078ccb.file.favoriteproducts-header.tpl.php 85 tools/smarty/sysplugins/smarty_internal_filter_handler.php 86 tools/minify_html/minify_html.class.php 87 modules/feeder/feeder.php 88 modules/feeder/translations/en.php 89 cache/smarty/compile/6d/de/aa/6ddeaab2bad1782f1d0e68ca279fb7f0775defdf.file.feederHeader.tpl.php 90 tools/smarty/plugins/modifier.escape.php 91 modules/blockuserinfo/blockuserinfo.php 92 themes/warehouse/modules/blockuserinfo/translations/en.php 93 modules/blockuserinfo/translations/en.php 94 modules/blockcart/blockcart.php 95 themes/warehouse/modules/blockcart/en.php 96 modules/blockcart/translations/en.php 97 modules/blocksearch_mod/blocksearch_mod.php 98 modules/blocksearch_mod/translations/en.php 99 modules/manufactuterslider/manufactuterslider.php 100 modules/manufactuterslider/translations/en.php 101 modules/homefeatured_mod/homefeatured_mod.php 102 modules/homefeatured_mod/translations/en.php 103 modules/columnadverts/columnadverts.php 104 modules/columnadverts/en.php 105 modules/blocklanguages/blocklanguages.php 106 themes/warehouse/modules/blocklanguages/translations/en.php 107 modules/blocklanguages/translations/en.php 108 modules/blocksocial_mod/blocksocial_mod.php 109 modules/blocksocial_mod/translations/en.php 110 modules/ganalytics/ganalytics.php 111 modules/ganalytics/translations/en.php 112 modules/ganalytics/backward_compatibility/backward.php 113 modules/ganalytics/backward_compatibility/Display.php 114 cache/smarty/compile/23/69/ac/2369ac5c9c752bfc4696164df7e6e478ca12252a.file.header.tpl.php 115 modules/productscategory/productscategory.php 116 themes/warehouse/modules/productscategory/translations/en.php 117 modules/productscategory/translations/en.php 118 modules/blockbestsellers/blockbestsellers.php 119 themes/warehouse/modules/blockbestsellers/translations/en.php 120 modules/blockbestsellers/translations/en.php 121 modules/productcomments/productcomments.php 122 themes/warehouse/modules/productcomments/translations/en.php 123 modules/productcomments/translations/en.php 124 modules/blocknewsletter/blocknewsletter.php 125 modules/blocknewsletter/translations/en.php 126 modules/blockwishlist/blockwishlist.php 127 themes/warehouse/modules/blockwishlist/en.php 128 modules/blockwishlist/translations/en.php 129 modules/specialslider/specialslider.php 130 modules/specialslider/translations/en.php 131 modules/blockcategories/blockcategories.php 132 themes/warehouse/modules/blockcategories/translations/en.php 133 modules/blockcategories/translations/en.php 134 modules/mailalerts/mailalerts.php 135 modules/mailalerts/MailAlert.php 136 themes/warehouse/modules/mailalerts/en.php 137 modules/mailalerts/translations/en.php 138 modules/homepageadvertise/homepageadvertise.php 139 modules/homepageadvertise/en.php 140 modules/facebookslide/facebookslide.php 141 modules/facebookslide/translations/en.php 142 modules/simpleslideshow/simpleslideshow.php 143 modules/simpleslideshow/en.php 144 modules/facebookpsconnect/facebookpsconnect.php 145 modules/facebookpsconnect/conf/common.conf.php 146 modules/facebookpsconnect/lib/warnings_class.php 147 modules/facebookpsconnect/lib/module-tools_class.php 148 modules/facebookpsconnect/en.php 149 modules/facebookpsconnect/conf/hook.conf.php 150 modules/facebookpsconnect/lib/hook/hook-ctrl_class.php 151 modules/facebookpsconnect/lib/hook/i-hook_class.php 152 modules/facebookpsconnect/lib/hook/hook-display_class.php 153 cache/smarty/compile/65/20/ac/6520ac84a3f79bfcd0dab3d6397700e61ad5a6aa.file.header.tpl.php 154 modules/paypal/paypal.php 155 modules/paypal/api/paypal_lib.php 156 modules/paypal/api/paypal_connect.php 157 modules/paypal/paypal_logos.php 158 modules/paypal/paypal_orders.php 159 modules/paypal/paypal_tools.php 160 modules/paypal/translations/en.php 161 cache/smarty/compile/48/3f/3d/483f3d6987e35823a4f29b99e4a72d0ab3df3cdb.file.paypal.js.php 162 modules/editorial/editorial.php 163 themes/warehouse/modules/editorial/translations/en.php 164 modules/editorial/translations/en.php 165 modules/editorial/EditorialClass.php 166 modules/crossselling_mod/crossselling_mod.php 167 modules/crossselling_mod/translations/en.php 168 modules/megamenuiqit/megamenuiqit.php 169 modules/megamenuiqit/megamenutoplinks.class.php 170 modules/megamenuiqit/megamenutab.class.php 171 modules/megamenuiqit/translations/en.php 172 modules/textbanners/textbanners.php 173 modules/textbanners/TextBanner.php 174 modules/textbanners/translations/en.php 175 modules/categoryslider/categoryslider.php 176 modules/categoryslider/translations/en.php 177 modules/blocklayered_mod/blocklayered_mod.php 178 modules/blocklayered_mod/en.php 179 modules/headerlinks/headerlinks.php 180 modules/headerlinks/translations/en.php 181 modules/quickviewiqit/quickviewiqit.php 182 modules/themeeditor/themeeditor.php 183 modules/themeeditor/translations/en.php 184 cache/smarty/compile/4c/4f/8c/4c4f8c0d665d99094414c955f05dea289d238a56.file.blockcurrencies.tpl.php 185 cache/smarty/compile/9e/50/c9/9e50c901f69c2176666d33a5e4e4474adb81df82.file.blockuserinfo.tpl.php 186 cache/smarty/compile/0b/75/fd/0b75fdf0bb9a7078372f2c12b4a29557a843c0d5.file.blocksearch-top_mod.tpl.php 187 cache/smarty/compile/ff/20/07/ff2007db4af1268cae1a47990da8a75cb968bae4.file.blocksearch-instantsearch_mod.tpl.php 188 classes/Customization.php 189 cache/smarty/compile/7b/74/f4/7b74f4099fe5b0cc97f3a2673b1400a708026066.file.blockcart.tpl.php 190 tools/smarty/plugins/modifier.replace.php 191 modules/pagesnotfound/pagesnotfound.php 192 modules/pagesnotfound/translations/en.php 193 modules/sekeywords/sekeywords.php 194 classes/module/ModuleGraph.php 195 modules/sekeywords/translations/en.php 196 cache/smarty/compile/37/80/cd/3780cdd09b7a0cc506c786dc404ce4fc516af069.file.blocklanguages.tpl.php 197 cache/smarty/compile/a2/6b/8b/a26b8b0d9ebbf798f3ee93af241205edfdb6f935.file.connector-buttons-js.tpl.php 198 cache/smarty/compile/7e/82/2c/7e822c48def52da29619f37f2594a3ed8c71f2dd.file.connector-buttons.tpl.php 199 cache/smarty/cache/headerlinks/0/1/1/1/99/76/40/997640a94d5469dc76135a5e0b33e506b90dee70.headerlinks.tpl.php 200 cache/smarty/cache/blockcategories/0/1/1/1/0/0/79/bb/d8/79bbd875b5f5983e29cc2e03ce25b816b4c85cb6.blockcategories.tpl.php 201 cache/smarty/cache/columnadverts/0/1/1/1/3e/43/02/3e4302371351c05aa899f009e804accbb0f01ba6.columnadverts.tpl.php 202 classes/Tag.php 203 classes/ProductSale.php 204 classes/Category.php 205 classes/tax/Tax.php 206 classes/Combination.php 207 classes/SpecificPrice.php 208 classes/tax/TaxManagerFactory.php 209 classes/tax/TaxRulesTaxManager.php 210 classes/tax/TaxManagerInterface.php 211 classes/tax/TaxCalculator.php 212 classes/GroupReduction.php 213 classes/Image.php 214 classes/ImageType.php 215 cache/smarty/compile/0b/5c/15/0b5c15c863498ee7fe21452c19664876a28cb0ee.file.blockbestsellers.tpl.php 216 cache/smarty/compile/df/b2/ba/dfb2ba31fed8e891541d9b2659cdb049d9bb80cc.file.block-account.tpl.php 217 modules/freeblock/freeblock.php 218 modules/freeblock/en.php 219 cache/smarty/compile/40/49/0b/40490b0553f6887e47a1e8eca8e34a5fe6f52c11.file.freeblock.tpl.php 220 modules/blockwishlist/WishList.php 221 cache/smarty/compile/de/8d/fc/de8dfcbe9b787e1cf567fa2660a49d3383851f05.file.blockwishlist.tpl.php 222 cache/smarty/compile/43/c6/d6/43c6d669d0ee449cb6e1ceb045c7f7ffb750f28b.file.column.tpl.php 223 classes/stock/StockAvailable.php 224 classes/order/OrderDetail.php 225 cache/smarty/compile/29/7f/2b/297f2b9e323264d823343c11d280b505ae35bb53.file.payment_return.tpl.php 226 cache/smarty/cache/blockmyaccountfooter/0/1/1/1/5e/2e/87/5e2e87399bf3bea6c42a9a86b2204c2cd1b0e0ac.blockmyaccountfooter.tpl.php 227 classes/CMS.php 228 cache/smarty/compile/94/4b/d0/944bd0a432819a8a00d15e3ae88e9d3b5e7a6c9b.file.blockcms.tpl.php 229 modules/statsdata/statsdata.php 230 modules/statsdata/translations/en.php 231 classes/Connection.php 232 classes/Page.php 233 classes/ConnectionsSource.php 234 classes/DateRange.php 235 cache/smarty/cache/blocksocial_mod/0/1/1/1/4a/3c/98/4a3c988c55f4435778e0c59e4a64330e2389ecdf.blocksocial_mod.tpl.php 236 modules/blockfooterhtml/blockfooterhtml.php 237 modules/blockfooterhtml/translations/en.php 238 cache/smarty/cache/blockfooterhtml/0/1/1/1/da/b9/4d/dab94d15e3af0ac7f590ad0945923deaa0ca01b1.blockfooterhtml.tpl.php 239 cache/smarty/compile/09/9d/4e/099d4ea712516fb3e4a30b3fd3dc6162ae86fb1e.file.blocknewsletter.tpl.php 240 cache/smarty/compile/b7/d0/cc/b7d0cc1ec453ee73c3bfa4ad5f01f3ed344f4fb8.file.buttons-content.tpl.php 241 classes/Tab.php 242 cache/smarty/compile/d5/ca/e6/d5cae6ca66fe72ac265d0c9a04486d9af3b8ae78.file.order-confirmation.tpl.php 243 cache/smarty/compile/d3/5a/db/d35adb15d9286ac987a0733374386674955eff51.file.order-steps.tpl.php 244 cache/smarty/compile/44/a7/47/44a7473a53f771ffcf3edf42e5a58938bb241a16.file.errors.tpl.php 245 cache/smarty/compile/d6/ba/a1/d6baa17abde216bece1954957d69645e4025d49d.file.layout.tpl.php 246 cache/smarty/compile/59/36/bb/5936bbdc1ba30915eac123e6da2774b27c1bdbe6.file.header.tpl.php 247 cache/smarty/cache/facebookslide/0/1/1/1/e3/b7/10/e3b71060641cddecf9d13f3e9a8dd05e1df9a6e5.facebookslide.tpl.php 248 cache/smarty/cache/megamenuiqit/0/1/1/1/82/45/db/8245db56215ea4b671ae4f4f93d0672defe87d3e.megamenuiqit.tpl.php 249 cache/smarty/compile/68/bd/e7/68bde75678f7315632567d489d22155a65e4df38.file.breadcrumb1.tpl.php 250 cache/smarty/compile/34/af/49/34af49b826079d9dd757868d00877bab20287cc0.file.footer.tpl.php Edited June 20, 2014 by Snarlster (see edit history) Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts