QUERY select value from sessions where sesskey = '4038ff806c1cce0c0a732f627cecbf78' and expiry > '1289918358' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1289917458' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '4038ff806c1cce0c0a732f627cecbf78' RESULT Resource id #37 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', '4038ff806c1cce0c0a732f627cecbf78', '91.211.16.126', 'cisco10k.didan.net.ua', '1289918358', '1289918358', '/index.php?cookies=1', '', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #48 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #51 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #55 QUERY select * from headertags_default where language_id = '4' RESULT Resource id #65 QUERY select * from headertags where page_name like 'index.php' and language_id = '4' RESULT Resource id #68 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name RESULT Resource id #79 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #82 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #85 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #91 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #94 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '61' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #118 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #121 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #154 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #172 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #175 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #181 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #184 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #193 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #208 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40' RESULT Resource id #211 QUERY select categories_id from categories where parent_id = '40' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #217 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #220 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #226 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28' RESULT Resource id #229 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #244 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #247 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #250 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #254 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10 RESULT Resource id #261 QUERY select products_name from products_description where products_id = '1142' and language_id = '4' RESULT Resource id #264 QUERY select specials_new_products_price from specials where products_id = '1142' and status RESULT Resource id #267 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #272 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit 9 RESULT Resource id #285 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #289 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #293 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #301 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #309 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #313 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #321 QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10 RESULT Resource id #325 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #336 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #341 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10 RESULT Resource id #347 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '12' and languages_id = '4' RESULT Resource id #350 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '2132485' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '4038ff806c1cce0c0a732f627cecbf78' RESULT Resource id #371 QUERY insert into sessions values ('4038ff806c1cce0c0a732f627cecbf78', '1289919798', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"svenska\";languages_id|s:1:\"4\";currency|s:3:\"SEK\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 16/11/2010 15:39:18 - /index.php?cookies=1 (0.062s) QUERY select value from sessions where sesskey = 'e03eae6a6ea8775ebe76c4d447c73737' and expiry > '1289918359' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1289917460' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'e03eae6a6ea8775ebe76c4d447c73737' RESULT Resource id #37 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'e03eae6a6ea8775ebe76c4d447c73737', '91.211.16.126', 'cisco10k.didan.net.ua', '1289918360', '1289918360', '/index.php?cookies=1', '', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #48 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #51 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #55 QUERY select * from headertags_default where language_id = '4' RESULT Resource id #65 QUERY select * from headertags where page_name like 'index.php' and language_id = '4' RESULT Resource id #68 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name RESULT Resource id #79 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #82 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #85 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #91 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #94 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '61' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #118 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #121 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #154 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #172 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #175 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #181 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #184 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #193 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #208 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40' RESULT Resource id #211 QUERY select categories_id from categories where parent_id = '40' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #217 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #220 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #226 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28' RESULT Resource id #229 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #244 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #247 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #250 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #254 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10 RESULT Resource id #261 QUERY select products_name from products_description where products_id = '1135' and language_id = '4' RESULT Resource id #264 QUERY select specials_new_products_price from specials where products_id = '1135' and status RESULT Resource id #267 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #272 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit 9 RESULT Resource id #285 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #289 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #293 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #301 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #309 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #313 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #321 QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10 RESULT Resource id #325 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #336 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #341 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10 RESULT Resource id #347 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '12' and languages_id = '4' RESULT Resource id #350 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '2132486' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'e03eae6a6ea8775ebe76c4d447c73737' RESULT Resource id #371 QUERY insert into sessions values ('e03eae6a6ea8775ebe76c4d447c73737', '1289919800', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"svenska\";languages_id|s:1:\"4\";currency|s:3:\"SEK\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 16/11/2010 15:39:20 - /index.php?cookies=1 (0.063s) QUERY select value from sessions where sesskey = '09e7a972acecf72f31215f1579509f13' and expiry > '1289918363' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1289917463' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '09e7a972acecf72f31215f1579509f13' RESULT Resource id #37 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', '09e7a972acecf72f31215f1579509f13', '91.211.16.126', 'cisco10k.didan.net.ua', '1289918363', '1289918363', '/index.php?cookies=1', '', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #48 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #51 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #55 QUERY select * from headertags_default where language_id = '4' RESULT Resource id #65 QUERY select * from headertags where page_name like 'index.php' and language_id = '4' RESULT Resource id #68 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name RESULT Resource id #79 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #82 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #85 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #91 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #94 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '61' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #118 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #121 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #154 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #172 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #175 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #181 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #184 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #193 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #208 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40' RESULT Resource id #211 QUERY select categories_id from categories where parent_id = '40' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #217 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #220 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #226 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28' RESULT Resource id #229 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #244 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #247 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #250 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #254 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10 RESULT Resource id #261 QUERY select products_name from products_description where products_id = '1139' and language_id = '4' RESULT Resource id #264 QUERY select specials_new_products_price from specials where products_id = '1139' and status RESULT Resource id #267 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #272 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit 9 RESULT Resource id #285 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #289 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #293 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #301 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #309 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #313 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #321 QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10 RESULT Resource id #325 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #336 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #341 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10 RESULT Resource id #347 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '12' and languages_id = '4' RESULT Resource id #350 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '2132487' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '09e7a972acecf72f31215f1579509f13' RESULT Resource id #371 QUERY insert into sessions values ('09e7a972acecf72f31215f1579509f13', '1289919803', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"svenska\";languages_id|s:1:\"4\";currency|s:3:\"SEK\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 16/11/2010 15:39:23 - /index.php?cookies=1 (0.061s) QUERY select value from sessions where sesskey = 'ce2cf768dfe18d989df8a67ecfb1a2ed' and expiry > '1289918365' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1289917465' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'ce2cf768dfe18d989df8a67ecfb1a2ed' RESULT Resource id #37 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'ce2cf768dfe18d989df8a67ecfb1a2ed', '91.211.16.126', 'cisco10k.didan.net.ua', '1289918365', '1289918365', '/index.php?cookies=1', '', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #48 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #51 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #55 QUERY select * from headertags_default where language_id = '4' RESULT Resource id #65 QUERY select * from headertags where page_name like 'index.php' and language_id = '4' RESULT Resource id #68 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name RESULT Resource id #79 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #82 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #85 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #91 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #94 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '61' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #118 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #121 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #154 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #172 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #175 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #181 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #184 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #193 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #208 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40' RESULT Resource id #211 QUERY select categories_id from categories where parent_id = '40' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #217 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #220 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #226 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28' RESULT Resource id #229 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #244 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #247 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #250 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #254 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10 RESULT Resource id #261 QUERY select products_name from products_description where products_id = '1129' and language_id = '4' RESULT Resource id #264 QUERY select specials_new_products_price from specials where products_id = '1129' and status RESULT Resource id #267 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #272 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit 9 RESULT Resource id #285 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #289 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #293 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #301 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #309 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #313 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #321 QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10 RESULT Resource id #325 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #336 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #341 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10 RESULT Resource id #347 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '12' and languages_id = '4' RESULT Resource id #350 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '2132488' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'ce2cf768dfe18d989df8a67ecfb1a2ed' RESULT Resource id #371 QUERY insert into sessions values ('ce2cf768dfe18d989df8a67ecfb1a2ed', '1289919805', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"svenska\";languages_id|s:1:\"4\";currency|s:3:\"SEK\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 16/11/2010 15:39:25 - /index.php?cookies=1 (0.065s) QUERY select value from sessions where sesskey = 'd41d82e89b89a0e7b31140699c3dd2c1' and expiry > '1289918368' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1289917468' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'd41d82e89b89a0e7b31140699c3dd2c1' RESULT Resource id #37 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'd41d82e89b89a0e7b31140699c3dd2c1', '91.211.16.126', 'cisco10k.didan.net.ua', '1289918368', '1289918368', '/index.php?cookies=1', '', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #48 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #51 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #55 QUERY select * from headertags_default where language_id = '4' RESULT Resource id #65 QUERY select * from headertags where page_name like 'index.php' and language_id = '4' RESULT Resource id #68 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name RESULT Resource id #79 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #82 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #85 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #91 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #94 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '61' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #118 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #121 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #154 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #172 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #175 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #181 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #184 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #193 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #208 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40' RESULT Resource id #211 QUERY select categories_id from categories where parent_id = '40' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #217 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #220 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #226 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28' RESULT Resource id #229 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #244 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #247 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #250 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #254 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10 RESULT Resource id #261 QUERY select products_name from products_description where products_id = '1139' and language_id = '4' RESULT Resource id #264 QUERY select specials_new_products_price from specials where products_id = '1139' and status RESULT Resource id #267 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #272 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_date_added desc limit 9 RESULT Resource id #285 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #289 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #293 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #301 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #309 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #313 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '203') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #321 QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10 RESULT Resource id #325 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #336 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #341 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10 RESULT Resource id #347 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '12' and languages_id = '4' RESULT Resource id #350 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '2132489' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'd41d82e89b89a0e7b31140699c3dd2c1' RESULT Resource id #371 QUERY insert into sessions values ('d41d82e89b89a0e7b31140699c3dd2c1', '1289919808', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"svenska\";languages_id|s:1:\"4\";currency|s:3:\"SEK\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 16/11/2010 15:39:28 - /index.php?cookies=1 (0.064s)