$warning_header$

Shopping Cart: Search:                     Advanced Search Currencies:   Currencies Great Britsh Pound Languages            Categories Adult Tee Shirt-> (141) Kids Tee Shirts (12) Mugs (45) Mousemats (19) Hoodies (3) Misc Best Sellers (17) Blog Information Terms Size Guide Privacy Notice Contact Us Site Map Featured Diff'rent Strokes Tee Shirt £15.00 What's New? 12 Monkeys (Adult) Tee Shirt £15.00 Specials Banksy Mug Collection £13.00 £10.00 Cookie Usage Cookie Privacy and Security Cookies must be enabled to purchase online on this store to embrace privacy and security related issues regarding your visit to this site. By enabling cookie support on your browser, the communication between you and this site is strengthened to be certain it is you who are making transactions on your own behalf, and to prevent leakage of your privacy information. We have detected that your browser does not support cookies, or has set cookies to be disabled. To continue shopping online, we encourage you to enable cookies on your browser. For Internet Explorer browsers, please follow these instructions: Click on the Tools menubar, and select Internet Options Select the Security tab, and reset the security level to Medium We have taken this measurement of security for your benefit, and apologize upfront if any inconveniences are caused. Please contact the store owner if you have any questions relating to this requirement, or to continue purchasing products offline. Specials  |  Advanced Search  |  Reviews  |  Create an Account  |  Log In Copyright © 2009 osCommerce | Privacy Notice

Warning: error_log(../images/img64625b6.php) [function.error-log]: failed to open stream: No such file or directory in /home/can7of/public_html/includes/application_bottom.php on line 26
Parse Time: 0.121sQUERY select value from sessions where sesskey = '8b9d2deab25713306b9208f288efdf16' and expiry > '1291394450' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393550' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '8b9d2deab25713306b9208f288efdf16' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '8b9d2deab25713306b9208f288efdf16', '91.211.16.126', '1291394450', '1291394450', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #68 QUERY select information_title, information_description from information where language_id = '1' and information_group_id = '2' RESULT Resource id #86 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #95 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies 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='1' order by sort_order, cd.categories_name RESULT Resource id #21 RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #108 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 #111 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #114 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 = '29' QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #27 RESULT Resource id #117 QUERY select categories_id from categories where parent_id = '29' RESULT Resource id #120 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 = '30' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #126 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 #129 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #132 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 = '32' RESULT Resource id #135 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #138 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 #141 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #144 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 #147 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '34' 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 = '34' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #164 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 #167 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #174 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 #177 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #184 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 #187 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #194 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 #197 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #204 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 #207 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #210 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #214 QUERY delete from whos_online where time_last_click < '1291393550' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #44 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '66.249.65.124', time_last_click = '1291394450', last_page_url = '/astro-adults-shirt-pi-180.html?invis=0' where session_id = '' 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 #219 QUERY select products_name from products_description where products_id = '183' and language_id = '1' RESULT 1 RESULT Resource id #222 QUERY select specials_new_products_price from specials where products_id = '183' and status RESULT Resource id #225 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #230 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #54 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 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #238 RESULT Resource id #57 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #61 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #65 RESULT Resource id #248 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #253 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #258 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #261 QUERY select pd.products_name, p.products_image from products p left join products_description pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '180' and pd.language_id = '1' RESULT Resource id #82 03/12/2010 16:40:50 - /astro-adults-shirt-pi-180.html?invis=0 (0.043s) 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #272 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #275 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #282 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #288 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #293 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #299 QUERY select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, pd.products_name from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1331763502) DESC limit 6 RESULT Resource id #302 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #307 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #310 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #313 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 = '1' order by date_expected desc limit 10 RESULT Resource id #317 QUERY select startdate, counter from counter RESULT Resource id #326 QUERY update counter set counter = '108957' 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 #331 QUERY select count(*) as count from banners_history where banners_id = '11' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #334 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '11' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #352 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #355 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #358 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #361 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #364 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #367 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #370 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #373 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #376 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #379 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #383 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #388 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #396 QUERY select count(*) as total from sessions where sesskey = '8b9d2deab25713306b9208f288efdf16' RESULT Resource id #399 QUERY insert into sessions values ('8b9d2deab25713306b9208f288efdf16', '1291395890', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:50 - /index.php?cookies=1 (0.245s) QUERY select value from sessions where sesskey = '55f38e730340de001c4bab9a9dd74a5f' and expiry > '1291394450' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393550' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '55f38e730340de001c4bab9a9dd74a5f' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '55f38e730340de001c4bab9a9dd74a5f', '91.211.16.126', '1291394450', '1291394450', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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='1' order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #97 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 #100 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #103 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 = '29' RESULT Resource id #106 QUERY select categories_id from categories where parent_id = '29' 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 = '30' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #115 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 #118 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #121 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 = '32' RESULT Resource id #124 QUERY select categories_id from categories where parent_id = '32' 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 = '27' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #133 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 #136 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #143 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 = '34' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #153 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 #156 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '23' 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 = '23' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #173 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 #176 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #183 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 #186 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #193 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 #196 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #199 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #203 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 #208 QUERY select products_name from products_description where products_id = '192' and language_id = '1' RESULT Resource id #211 QUERY select specials_new_products_price from specials where products_id = '192' and status RESULT Resource id #214 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #219 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #227 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #237 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #242 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #247 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #250 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #261 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #264 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #271 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #277 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #282 QUERY select startdate, counter from counter RESULT Resource id #296 QUERY update counter set counter = '108958' 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 #301 QUERY select count(*) as count from banners_history where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #304 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #310 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #313 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #316 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #319 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #322 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #325 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #328 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #331 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #334 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #337 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #353 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #358 QUERY select count(*) as total from sessions where sesskey = '55f38e730340de001c4bab9a9dd74a5f' RESULT Resource id #366 QUERY insert into sessions values ('55f38e730340de001c4bab9a9dd74a5f', '1291395891', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:51 - /cookie_usage.php?cookies=1 (0.131s) QUERY select value from sessions where sesskey = '90dc66da547d3225a723f843195b9955' and expiry > '1291394451' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393551' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '90dc66da547d3225a723f843195b9955' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '90dc66da547d3225a723f843195b9955', '91.211.16.126', '1291394451', '1291394451', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #68 QUERY select information_title, information_description from information where language_id = '1' and information_group_id = '2' RESULT Resource id #86 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #95 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='1' order by sort_order, cd.categories_name RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #108 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 #111 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #114 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 = '29' RESULT Resource id #117 QUERY select categories_id from categories where parent_id = '29' RESULT Resource id #120 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 = '30' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #126 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 #129 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #132 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 = '32' RESULT Resource id #135 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #138 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 #141 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #144 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 #147 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '34' 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 = '34' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #164 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 #167 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #174 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 #177 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #184 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 #187 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #194 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 #197 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #204 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 #207 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #210 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #214 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 #219 QUERY select products_name from products_description where products_id = '188' and language_id = '1' RESULT Resource id #222 QUERY select specials_new_products_price from specials where products_id = '188' and status RESULT Resource id #225 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #230 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #238 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #248 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #253 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #258 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #261 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #272 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #275 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #282 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #288 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #293 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #299 QUERY select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, pd.products_name from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1846397617) DESC limit 6 RESULT Resource id #302 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #307 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #310 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #313 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 = '1' order by date_expected desc limit 10 RESULT Resource id #317 QUERY select startdate, counter from counter RESULT Resource id #326 QUERY update counter set counter = '108959' 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 #331 QUERY select count(*) as count from banners_history where banners_id = '4' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #334 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '4' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #352 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #355 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #358 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #361 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #364 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #367 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #370 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #373 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #376 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #379 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #383 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #388 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #396 QUERY select count(*) as total from sessions where sesskey = '90dc66da547d3225a723f843195b9955' RESULT Resource id #399 QUERY insert into sessions values ('90dc66da547d3225a723f843195b9955', '1291395891', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:51 - /index.php?cookies=1 (0.102s) QUERY select value from sessions where sesskey = 'b337dbfa224d787d87d7c3cd374a000f' and expiry > '1291394452' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393552' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'b337dbfa224d787d87d7c3cd374a000f' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'b337dbfa224d787d87d7c3cd374a000f', '91.211.16.126', '1291394452', '1291394452', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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='1' order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #97 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 #100 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #103 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 = '29' RESULT Resource id #106 QUERY select categories_id from categories where parent_id = '29' 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 = '30' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #115 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 #118 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #121 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 = '32' RESULT Resource id #124 QUERY select categories_id from categories where parent_id = '32' 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 = '27' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #133 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 #136 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #143 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 = '34' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #153 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 #156 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '23' 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 = '23' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #173 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 #176 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #183 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 #186 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #193 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 #196 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #199 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #203 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 #208 QUERY select products_name from products_description where products_id = '189' and language_id = '1' RESULT Resource id #211 QUERY select specials_new_products_price from specials where products_id = '189' and status RESULT Resource id #214 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #219 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #227 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #237 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #242 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #247 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #250 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #261 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #264 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #271 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #277 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #282 QUERY select startdate, counter from counter RESULT Resource id #296 QUERY update counter set counter = '108960' 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 #301 QUERY select count(*) as count from banners_history where banners_id = '4' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #304 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '4' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #310 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #313 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #316 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #319 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #322 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #325 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #328 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #331 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #334 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #337 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #353 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #358 QUERY select count(*) as total from sessions where sesskey = 'b337dbfa224d787d87d7c3cd374a000f' RESULT Resource id #366 QUERY insert into sessions values ('b337dbfa224d787d87d7c3cd374a000f', '1291395892', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:52 - /cookie_usage.php?cookies=1 (0.097s) QUERY select value from sessions where sesskey = '05f7c5a3c6a3fa809bea6f37dbdd149b' and expiry > '1291394456' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393556' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '05f7c5a3c6a3fa809bea6f37dbdd149b' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '05f7c5a3c6a3fa809bea6f37dbdd149b', '91.211.16.126', '1291394456', '1291394456', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #68 QUERY select information_title, information_description from information where language_id = '1' and information_group_id = '2' RESULT Resource id #86 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #95 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='1' order by sort_order, cd.categories_name RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #108 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 #111 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #114 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 = '29' RESULT Resource id #117 QUERY select categories_id from categories where parent_id = '29' RESULT Resource id #120 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 = '30' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #126 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 #129 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #132 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 = '32' RESULT Resource id #135 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #138 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 #141 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #144 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 #147 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '34' 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 = '34' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #164 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 #167 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #174 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 #177 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #184 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 #187 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #194 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 #197 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #204 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 #207 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #210 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #214 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 #219 QUERY select products_name from products_description where products_id = '186' and language_id = '1' RESULT Resource id #222 QUERY select specials_new_products_price from specials where products_id = '186' and status RESULT Resource id #225 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #230 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #238 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #248 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #253 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #258 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #261 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #272 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #275 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #282 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #288 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #293 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #299 QUERY select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, pd.products_name from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(365135701) DESC limit 6 RESULT Resource id #302 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #307 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #310 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #313 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 = '1' order by date_expected desc limit 10 RESULT Resource id #317 QUERY select startdate, counter from counter RESULT Resource id #326 QUERY update counter set counter = '108961' 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 #331 QUERY select count(*) as count from banners_history where banners_id = '7' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #334 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '7' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #352 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #355 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #358 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #361 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #364 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #367 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #370 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #373 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #376 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #379 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #383 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #388 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #396 QUERY select count(*) as total from sessions where sesskey = '05f7c5a3c6a3fa809bea6f37dbdd149b' RESULT Resource id #399 QUERY insert into sessions values ('05f7c5a3c6a3fa809bea6f37dbdd149b', '1291395896', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:56 - /index.php?cookies=1 (0.107s) QUERY select value from sessions where sesskey = 'fc37753a295edff605960c0b3d4c3a7b' and expiry > '1291394457' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393557' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'fc37753a295edff605960c0b3d4c3a7b' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'fc37753a295edff605960c0b3d4c3a7b', '91.211.16.126', '1291394457', '1291394457', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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='1' order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #97 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 #100 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #103 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 = '29' RESULT Resource id #106 QUERY select categories_id from categories where parent_id = '29' 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 = '30' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #115 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 #118 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #121 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 = '32' RESULT Resource id #124 QUERY select categories_id from categories where parent_id = '32' 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 = '27' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #133 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 #136 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #143 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 = '34' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #153 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 #156 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '23' 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 = '23' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #173 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 #176 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #183 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 #186 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #193 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 #196 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #199 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #203 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 #208 QUERY select products_name from products_description where products_id = '184' and language_id = '1' RESULT Resource id #211 QUERY select specials_new_products_price from specials where products_id = '184' and status RESULT Resource id #214 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #219 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #227 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #237 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #242 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #247 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #250 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #261 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #264 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #271 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #277 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #282 QUERY select startdate, counter from counter RESULT Resource id #296 QUERY update counter set counter = '108962' 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 #301 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #304 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #310 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #313 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #316 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #319 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #322 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #325 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #328 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #331 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #334 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #337 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #353 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #358 QUERY select count(*) as total from sessions where sesskey = 'fc37753a295edff605960c0b3d4c3a7b' RESULT Resource id #366 QUERY insert into sessions values ('fc37753a295edff605960c0b3d4c3a7b', '1291395897', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:57 - /cookie_usage.php?cookies=1 (0.094s) QUERY select value from sessions where sesskey = '9d27487818bf779b36f626e8d3d8e965' and expiry > '1291394458' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393558' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '9d27487818bf779b36f626e8d3d8e965' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '9d27487818bf779b36f626e8d3d8e965', '91.211.16.126', '1291394458', '1291394458', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #68 QUERY select information_title, information_description from information where language_id = '1' and information_group_id = '2' RESULT Resource id #86 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #95 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='1' order by sort_order, cd.categories_name RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #108 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 #111 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #114 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 = '29' RESULT Resource id #117 QUERY select categories_id from categories where parent_id = '29' RESULT Resource id #120 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 = '30' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #126 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 #129 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #132 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 = '32' RESULT Resource id #135 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #138 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 #141 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #144 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 #147 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '34' 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 = '34' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #164 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 #167 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #174 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 #177 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #184 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 #187 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #194 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 #197 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #204 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 #207 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #210 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #214 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 #219 QUERY select products_name from products_description where products_id = '190' and language_id = '1' RESULT Resource id #222 QUERY select specials_new_products_price from specials where products_id = '190' and status RESULT Resource id #225 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #230 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #238 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #248 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #253 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #258 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #261 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #272 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #275 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #282 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #288 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #293 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #299 QUERY select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, pd.products_name from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(377079995) DESC limit 6 RESULT Resource id #302 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #307 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #310 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #313 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 = '1' order by date_expected desc limit 10 RESULT Resource id #317 QUERY select startdate, counter from counter RESULT Resource id #326 QUERY update counter set counter = '108963' 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 #331 QUERY select count(*) as count from banners_history where banners_id = '6' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #334 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '6' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #352 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #355 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #358 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #361 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #364 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #367 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #370 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #373 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #376 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #379 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #383 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #388 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #396 QUERY select count(*) as total from sessions where sesskey = '9d27487818bf779b36f626e8d3d8e965' RESULT Resource id #399 QUERY insert into sessions values ('9d27487818bf779b36f626e8d3d8e965', '1291395898', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:58 - /index.php?cookies=1 (0.116s) QUERY select value from sessions where sesskey = '2929d3811943a0a708d317e2db4a81a4' and expiry > '1291394459' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393559' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '2929d3811943a0a708d317e2db4a81a4' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '2929d3811943a0a708d317e2db4a81a4', '91.211.16.126', '1291394459', '1291394459', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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='1' order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #97 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 #100 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #103 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 = '29' RESULT Resource id #106 QUERY select categories_id from categories where parent_id = '29' 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 = '30' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #115 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 #118 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #121 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 = '32' RESULT Resource id #124 QUERY select categories_id from categories where parent_id = '32' 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 = '27' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #133 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 #136 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #143 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 = '34' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #153 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 #156 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '23' 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 = '23' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #173 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 #176 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #183 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 #186 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #193 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 #196 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #199 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #203 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 #208 QUERY select products_name from products_description where products_id = '184' and language_id = '1' RESULT Resource id #211 QUERY select specials_new_products_price from specials where products_id = '184' and status RESULT Resource id #214 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #219 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #227 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #237 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #242 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #247 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #250 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #261 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #264 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #271 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #277 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #282 QUERY select startdate, counter from counter RESULT Resource id #296 QUERY update counter set counter = '108964' 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 #301 QUERY select count(*) as count from banners_history where banners_id = '8' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #304 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '8' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #310 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #313 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #316 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #319 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #322 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #325 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #328 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #331 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #334 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #337 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #353 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #358 QUERY select count(*) as total from sessions where sesskey = '2929d3811943a0a708d317e2db4a81a4' RESULT Resource id #366 QUERY insert into sessions values ('2929d3811943a0a708d317e2db4a81a4', '1291395899', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:40:59 - /cookie_usage.php?cookies=1 (0.100s) QUERY select value from sessions where sesskey = '76017e6f5dd993cff79cf0d378e44458' and expiry > '1291394461' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393561' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '76017e6f5dd993cff79cf0d378e44458' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '76017e6f5dd993cff79cf0d378e44458', '91.211.16.126', '1291394461', '1291394461', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #68 QUERY select information_title, information_description from information where language_id = '1' and information_group_id = '2' RESULT Resource id #86 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #95 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='1' order by sort_order, cd.categories_name RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #108 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 #111 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #114 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 = '29' RESULT Resource id #117 QUERY select categories_id from categories where parent_id = '29' RESULT Resource id #120 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 = '30' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #126 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 #129 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #132 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 = '32' RESULT Resource id #135 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #138 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 #141 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #144 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 #147 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '34' 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 = '34' RESULT Resource id #157 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #164 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 #167 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #174 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 #177 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #184 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 #187 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #194 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 #197 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #204 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 #207 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #210 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #214 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 #219 QUERY select products_name from products_description where products_id = '188' and language_id = '1' RESULT Resource id #222 QUERY select specials_new_products_price from specials where products_id = '188' and status RESULT Resource id #225 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #230 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #238 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #248 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #253 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #258 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #261 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #272 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #275 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #282 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #288 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #293 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #299 QUERY select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, pd.products_name from products p left join specials s on p.products_id = s.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1378130593) DESC limit 6 RESULT Resource id #302 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #307 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #310 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #313 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 = '1' order by date_expected desc limit 10 RESULT Resource id #317 QUERY select startdate, counter from counter RESULT Resource id #326 QUERY update counter set counter = '108965' 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 #331 QUERY select count(*) as count from banners_history where banners_id = '9' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #334 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '9' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #352 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #355 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #358 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #361 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #364 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #367 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #370 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #373 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #376 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #379 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #383 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #388 QUERY select categories_name as name, categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #396 QUERY select count(*) as total from sessions where sesskey = '76017e6f5dd993cff79cf0d378e44458' RESULT Resource id #399 QUERY insert into sessions values ('76017e6f5dd993cff79cf0d378e44458', '1291395901', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:41:01 - /index.php?cookies=1 (0.110s) QUERY select value from sessions where sesskey = 'd2f2e6a328811aec3c576892b2258d04' and expiry > '1291394462' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291393562' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'd2f2e6a328811aec3c576892b2258d04' RESULT Resource id #47 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'd2f2e6a328811aec3c576892b2258d04', '91.211.16.126', '1291394462', '1291394462', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 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 #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 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='1' order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #97 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 #100 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #103 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 = '29' RESULT Resource id #106 QUERY select categories_id from categories where parent_id = '29' 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 = '30' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #115 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 #118 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #121 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 = '32' RESULT Resource id #124 QUERY select categories_id from categories where parent_id = '32' 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 = '27' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '27' RESULT Resource id #133 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 #136 QUERY select categories_id from categories where parent_id = '28' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #143 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 = '34' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #153 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 #156 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '23' 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 = '23' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #173 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 #176 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #183 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 #186 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #193 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 #196 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #199 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #203 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 #208 QUERY select products_name from products_description where products_id = '184' and language_id = '1' RESULT Resource id #211 QUERY select specials_new_products_price from specials where products_id = '184' and status RESULT Resource id #214 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #219 QUERY SELECT information_id, information_title, parent_id FROM information WHERE visible='1' and language_id='1' and information_group_id = '1' ORDER BY sort_order RESULT Resource id #227 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 = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #237 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 = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #242 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #247 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #250 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 = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #261 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #264 QUERY select * FROM customer_testimonials WHERE status = 1 ORDER BY rand() LIMIT 1 RESULT Resource id #271 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #277 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #282 QUERY select startdate, counter from counter RESULT Resource id #296 QUERY update counter set counter = '108966' 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 #301 QUERY select count(*) as count from banners_history where banners_id = '6' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #304 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '6' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #310 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '21' order by c.sort_order, cd.categories_name RESULT Resource id #313 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '27' order by c.sort_order, cd.categories_name RESULT Resource id #316 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '32' order by c.sort_order, cd.categories_name RESULT Resource id #319 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '28' order by c.sort_order, cd.categories_name RESULT Resource id #322 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '29' order by c.sort_order, cd.categories_name RESULT Resource id #325 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '31' order by c.sort_order, cd.categories_name RESULT Resource id #328 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '30' order by c.sort_order, cd.categories_name RESULT Resource id #331 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '34' order by c.sort_order, cd.categories_name RESULT Resource id #334 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '22' order by c.sort_order, cd.categories_name RESULT Resource id #337 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name RESULT Resource id #340 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '33' order by c.sort_order, cd.categories_name RESULT Resource id #343 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '24' order by c.sort_order, cd.categories_name RESULT Resource id #346 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '25' order by c.sort_order, cd.categories_name RESULT Resource id #349 QUERY select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 RESULT Resource id #353 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 = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #358 QUERY select count(*) as total from sessions where sesskey = 'd2f2e6a328811aec3c576892b2258d04' RESULT Resource id #366 QUERY insert into sessions values ('d2f2e6a328811aec3c576892b2258d04', '1291395902', '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:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;') RESULT 1 03/12/2010 16:41:02 - /cookie_usage.php?cookies=1 (0.098s)