QUERY select value from sessions where sesskey = '883a52297407293dc946bd04600189c2' and expiry > '1290937891' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290936991' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '883a52297407293dc946bd04600189c2' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '883a52297407293dc946bd04600189c2', '91.211.16.126', '1290937891', '1290937891', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '830' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '830' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038533' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '883a52297407293dc946bd04600189c2' RESULT Resource id #371 QUERY insert into sessions values ('883a52297407293dc946bd04600189c2', '1290939331', '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:{}}') RESULT 1 28/11/2010 09:51:31 - /index.php?cookies=1 (0.095s) QUERY select value from sessions where sesskey = '4985d364e15610f3da174d0b813c00f3' and expiry > '1290937892' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290936992' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '4985d364e15610f3da174d0b813c00f3' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '4985d364e15610f3da174d0b813c00f3', '91.211.16.126', '1290937892', '1290937892', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '836' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '836' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038534' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '4985d364e15610f3da174d0b813c00f3' RESULT Resource id #371 QUERY insert into sessions values ('4985d364e15610f3da174d0b813c00f3', '1290939332', '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:{}}') RESULT 1 28/11/2010 09:51:32 - /index.php?cookies=1 (0.068s) QUERY select value from sessions where sesskey = '3c8b0c45d16383183322c6ce5c7ec92d' and expiry > '1290937893' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290936993' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '3c8b0c45d16383183322c6ce5c7ec92d' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '3c8b0c45d16383183322c6ce5c7ec92d', '91.211.16.126', '1290937893', '1290937893', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '831' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '831' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038535' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '3c8b0c45d16383183322c6ce5c7ec92d' RESULT Resource id #371 QUERY insert into sessions values ('3c8b0c45d16383183322c6ce5c7ec92d', '1290939333', '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:{}}') RESULT 1 28/11/2010 09:51:33 - /index.php?cookies=1 (0.052s) QUERY select value from sessions where sesskey = '12cb460849b24fa10e7df246f951d20e' and expiry > '1290937894' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290936994' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '12cb460849b24fa10e7df246f951d20e' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '12cb460849b24fa10e7df246f951d20e', '91.211.16.126', '1290937894', '1290937894', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '838' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '838' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038536' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '12cb460849b24fa10e7df246f951d20e' RESULT Resource id #371 QUERY insert into sessions values ('12cb460849b24fa10e7df246f951d20e', '1290939335', '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:{}}') RESULT 1 28/11/2010 09:51:35 - /index.php?cookies=1 (0.066s) QUERY select value from sessions where sesskey = 'a159ca6cee6c188936f8ad322b1777d1' and expiry > '1290937896' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290936996' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'a159ca6cee6c188936f8ad322b1777d1' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'a159ca6cee6c188936f8ad322b1777d1', '91.211.16.126', '1290937896', '1290937896', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '835' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '835' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038537' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'a159ca6cee6c188936f8ad322b1777d1' RESULT Resource id #371 QUERY insert into sessions values ('a159ca6cee6c188936f8ad322b1777d1', '1290939336', '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:{}}') RESULT 1 28/11/2010 09:51:36 - /index.php?cookies=1 (0.069s) QUERY select value from sessions where sesskey = '53cbfb73235a8ab49d9c214faf5d1521' and expiry > '1290972364' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290971464' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '53cbfb73235a8ab49d9c214faf5d1521' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '53cbfb73235a8ab49d9c214faf5d1521', '91.211.16.126', '1290972364', '1290972364', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '829' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '829' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038729' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '53cbfb73235a8ab49d9c214faf5d1521' RESULT Resource id #371 QUERY insert into sessions values ('53cbfb73235a8ab49d9c214faf5d1521', '1290973804', '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:{}}') RESULT 1 28/11/2010 19:26:04 - /index.php?cookies=1 (0.082s) QUERY select value from sessions where sesskey = 'f40c9cd288a0b954a2d4470c7283e462' and expiry > '1290972366' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290971466' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'f40c9cd288a0b954a2d4470c7283e462' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'f40c9cd288a0b954a2d4470c7283e462', '91.211.16.126', '1290972366', '1290972366', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '836' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '836' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038730' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'f40c9cd288a0b954a2d4470c7283e462' RESULT Resource id #371 QUERY insert into sessions values ('f40c9cd288a0b954a2d4470c7283e462', '1290973806', '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:{}}') RESULT 1 28/11/2010 19:26:06 - /index.php?cookies=1 (0.048s) QUERY select value from sessions where sesskey = '518d09525127a9243cddff4d0f60318f' and expiry > '1290972368' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290971468' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '518d09525127a9243cddff4d0f60318f' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '518d09525127a9243cddff4d0f60318f', '91.211.16.126', '1290972368', '1290972368', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '835' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '835' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038731' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '518d09525127a9243cddff4d0f60318f' RESULT Resource id #371 QUERY insert into sessions values ('518d09525127a9243cddff4d0f60318f', '1290973808', '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:{}}') RESULT 1 28/11/2010 19:26:08 - /index.php?cookies=1 (0.049s) QUERY select value from sessions where sesskey = '21d9272dc68afead67a509125e935bff' and expiry > '1290972370' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290971470' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '21d9272dc68afead67a509125e935bff' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '21d9272dc68afead67a509125e935bff', '91.211.16.126', '1290972370', '1290972370', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '835' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '835' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038732' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = '21d9272dc68afead67a509125e935bff' RESULT Resource id #371 QUERY insert into sessions values ('21d9272dc68afead67a509125e935bff', '1290973810', '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:{}}') RESULT 1 28/11/2010 19:26:10 - /index.php?cookies=1 (0.051s) QUERY select value from sessions where sesskey = 'c57299baae0ceba563704a671038d945' and expiry > '1290972374' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #26 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #32 QUERY delete from whos_online where time_last_click < '1290971474' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'c57299baae0ceba563704a671038d945' RESULT Resource id #39 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'c57299baae0ceba563704a671038d945', '91.211.16.126', '1290972374', '1290972374', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #49 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 #52 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #56 QUERY describe categories status RESULT Resource id #67 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #70 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #73 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #76 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #79 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #82 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #85 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #88 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #97 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '114' RESULT Resource id #106 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #115 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '112' RESULT Resource id #124 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #133 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #142 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #151 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '110' RESULT Resource id #160 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '111' RESULT Resource id #169 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #178 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '92' RESULT Resource id #187 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '97' RESULT Resource id #196 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #205 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #214 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '29' RESULT Resource id #223 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #232 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #241 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #250 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '16' RESULT Resource id #259 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '113' RESULT Resource id #268 QUERY select c.categories_id, cd.categories_name, c.parent_id, c.categories_image from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '0' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #277 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #281 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 #286 QUERY select products_name from products_description where products_id = '837' and language_id = '1' RESULT Resource id #289 QUERY select specials_new_products_price from specials where products_id = '837' and status RESULT Resource id #292 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 = '1' group by tr.tax_priority RESULT Resource id #297 QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #308 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 = '1' group by tr.tax_priority RESULT Resource id #311 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 = '1' group by tr.tax_priority RESULT Resource id #314 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 = '1' group by tr.tax_priority RESULT Resource id #317 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '222') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #320 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 = '1' group by tr.tax_priority RESULT Resource id #323 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 = '1' group by tr.tax_priority RESULT Resource id #326 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 = '1' group by tr.tax_priority RESULT Resource id #329 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 = '1' group by tr.tax_priority RESULT Resource id #332 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 #336 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 #344 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 #349 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 = '1' group by tr.tax_priority RESULT Resource id #354 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 = '1' group by tr.tax_priority RESULT Resource id #357 QUERY select startdate, counter from counter RESULT Resource id #362 QUERY update counter set counter = '1038733' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #367 QUERY select count(*) as total from sessions where sesskey = 'c57299baae0ceba563704a671038d945' RESULT Resource id #371 QUERY insert into sessions values ('c57299baae0ceba563704a671038d945', '1290973814', '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:{}}') RESULT 1 28/11/2010 19:26:14 - /index.php?cookies=1 (0.054s)