QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882339'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = 'f20ffdb260b51003084b1e0ead17e70a'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'f20ffdb260b51003084b1e0ead17e70a', '91.211.16.126', '1289883239', '1289883239', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '171' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '824765'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:53:59 - /shopping/index.php?cookies=1 (0.078s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882343'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '20bec07fc0271e7cdbea54fc911ed3e6'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '20bec07fc0271e7cdbea54fc911ed3e6', '91.211.16.126', '1289883243', '1289883243', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '167' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '824766'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:54:03 - /shopping/index.php?cookies=1 (0.069s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882346'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '3a336715d592ea2a93a5a777945063c5'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '3a336715d592ea2a93a5a777945063c5', '91.211.16.126', '1289883246', '1289883246', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '173' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '824767'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:54:06 - /shopping/index.php?cookies=1 (0.070s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882348'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '62fc772e2787cb1553e27609a7b3bbda'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '62fc772e2787cb1553e27609a7b3bbda', '118.166.218.95', '1289883248', '1289883248', '/shopping/reviews.php')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '166' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '166' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select count(*) as total  from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '4' and rd.languages_id = '4'
RESULT Resource id #417 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #426 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #431 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #437 
QUERY select startdate, counter from counter
RESULT Resource id #449 
QUERY update counter set counter = '824768'
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 #454 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #458 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:54:08 - /shopping/reviews.php (0.067s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882351'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '2c893225d8ccaf5e4597d2c2d435bc4e'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '2c893225d8ccaf5e4597d2c2d435bc4e', '91.211.16.126', '1289883251', '1289883251', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '170' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '824769'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:54:11 - /shopping/index.php?cookies=1 (0.070s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289882359'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = 'bf29930df30791ee341dc29e1796bfd6'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'bf29930df30791ee341dc29e1796bfd6', '91.211.16.126', '1289883259', '1289883259', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '172' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '824770'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 12:54:19 - /shopping/index.php?cookies=1 (0.078s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289915025'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '5b87321622bca0eccf8b3287064a172c'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '5b87321622bca0eccf8b3287064a172c', '91.211.16.126', '1289915925', '1289915925', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '167' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '825059'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 21:58:45 - /shopping/index.php?cookies=1 (0.074s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289915034'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '1615a7609d89e5f4d820d37877e23958'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '1615a7609d89e5f4d820d37877e23958', '91.211.16.126', '1289915934', '1289915934', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '173' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '825060'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 21:58:54 - /shopping/index.php?cookies=1 (0.070s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289915044'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = 'b2f8c75060c1145e3b2cc31692e4ddee'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'b2f8c75060c1145e3b2cc31692e4ddee', '91.211.16.126', '1289915944', '1289915944', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '173' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '825061'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 21:59:04 - /shopping/index.php?cookies=1 (0.080s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289915057'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '643795af92985f96da714e2d545a7f36'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '643795af92985f96da714e2d545a7f36', '91.211.16.126', '1289915957', '1289915957', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '171' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '825062'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 21:59:17 - /shopping/index.php?cookies=1 (0.070s)
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #21 
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1289915076'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '19d018329974ad12b77b2265e166c8dc'
RESULT Resource id #35 
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '19d018329974ad12b77b2265e166c8dc', '91.211.16.126', '1289915976', '1289915976', '/shopping/index.php?cookies=1')
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #45 
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 #48 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #52 
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name
RESULT Resource id #66 
QUERY select count(*) as count from categories where parent_id = '39'
RESULT Resource id #69 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'
RESULT Resource id #72 
QUERY select categories_id from categories where parent_id = '39'
RESULT Resource id #75 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'
RESULT Resource id #78 
QUERY select categories_id from categories where parent_id = '41'
RESULT Resource id #81 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'
RESULT Resource id #84 
QUERY select categories_id from categories where parent_id = '42'
RESULT Resource id #87 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'
RESULT Resource id #90 
QUERY select categories_id from categories where parent_id = '43'
RESULT Resource id #93 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'
RESULT Resource id #96 
QUERY select categories_id from categories where parent_id = '44'
RESULT Resource id #99 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'
RESULT Resource id #102 
QUERY select categories_id from categories where parent_id = '45'
RESULT Resource id #105 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'
RESULT Resource id #108 
QUERY select categories_id from categories where parent_id = '46'
RESULT Resource id #111 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'
RESULT Resource id #114 
QUERY select categories_id from categories where parent_id = '49'
RESULT Resource id #117 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'
RESULT Resource id #120 
QUERY select categories_id from categories where parent_id = '50'
RESULT Resource id #123 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'
RESULT Resource id #126 
QUERY select categories_id from categories where parent_id = '51'
RESULT Resource id #129 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'
RESULT Resource id #132 
QUERY select categories_id from categories where parent_id = '52'
RESULT Resource id #135 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'
RESULT Resource id #138 
QUERY select categories_id from categories where parent_id = '53'
RESULT Resource id #141 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'
RESULT Resource id #144 
QUERY select categories_id from categories where parent_id = '72'
RESULT Resource id #147 
QUERY select count(*) as count from categories where parent_id = '54'
RESULT Resource id #150 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'
RESULT Resource id #153 
QUERY select categories_id from categories where parent_id = '54'
RESULT Resource id #156 
QUERY select count(*) as count from categories where parent_id = '37'
RESULT Resource id #159 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'
RESULT Resource id #162 
QUERY select categories_id from categories where parent_id = '37'
RESULT Resource id #165 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'
RESULT Resource id #168 
QUERY select categories_id from categories where parent_id = '32'
RESULT Resource id #171 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'
RESULT Resource id #174 
QUERY select categories_id from categories where parent_id = '31'
RESULT Resource id #177 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'
RESULT Resource id #180 
QUERY select categories_id from categories where parent_id = '33'
RESULT Resource id #183 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'
RESULT Resource id #186 
QUERY select categories_id from categories where parent_id = '34'
RESULT Resource id #189 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'
RESULT Resource id #192 
QUERY select categories_id from categories where parent_id = '21'
RESULT Resource id #195 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'
RESULT Resource id #198 
QUERY select categories_id from categories where parent_id = '22'
RESULT Resource id #201 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'
RESULT Resource id #204 
QUERY select categories_id from categories where parent_id = '30'
RESULT Resource id #207 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'
RESULT Resource id #210 
QUERY select categories_id from categories where parent_id = '29'
RESULT Resource id #213 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'
RESULT Resource id #216 
QUERY select categories_id from categories where parent_id = '23'
RESULT Resource id #219 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'
RESULT Resource id #222 
QUERY select categories_id from categories where parent_id = '25'
RESULT Resource id #225 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'
RESULT Resource id #228 
QUERY select categories_id from categories where parent_id = '27'
RESULT Resource id #231 
QUERY select count(*) as count from categories where parent_id = '63'
RESULT Resource id #234 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'
RESULT Resource id #237 
QUERY select categories_id from categories where parent_id = '63'
RESULT Resource id #240 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'
RESULT Resource id #243 
QUERY select categories_id from categories where parent_id = '64'
RESULT Resource id #246 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'
RESULT Resource id #249 
QUERY select categories_id from categories where parent_id = '65'
RESULT Resource id #252 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'
RESULT Resource id #255 
QUERY select categories_id from categories where parent_id = '66'
RESULT Resource id #258 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'
RESULT Resource id #261 
QUERY select categories_id from categories where parent_id = '67'
RESULT Resource id #264 
QUERY select count(*) as count from categories where parent_id = '57'
RESULT Resource id #267 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'
RESULT Resource id #270 
QUERY select categories_id from categories where parent_id = '57'
RESULT Resource id #273 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'
RESULT Resource id #276 
QUERY select categories_id from categories where parent_id = '58'
RESULT Resource id #279 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'
RESULT Resource id #282 
QUERY select categories_id from categories where parent_id = '59'
RESULT Resource id #285 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'
RESULT Resource id #288 
QUERY select categories_id from categories where parent_id = '60'
RESULT Resource id #291 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'
RESULT Resource id #294 
QUERY select categories_id from categories where parent_id = '61'
RESULT Resource id #297 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'
RESULT Resource id #300 
QUERY select categories_id from categories where parent_id = '62'
RESULT Resource id #303 
QUERY select count(*) as count from categories where parent_id = '24'
RESULT Resource id #306 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'
RESULT Resource id #309 
QUERY select categories_id from categories where parent_id = '24'
RESULT Resource id #312 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'
RESULT Resource id #315 
QUERY select categories_id from categories where parent_id = '35'
RESULT Resource id #318 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'
RESULT Resource id #321 
QUERY select categories_id from categories where parent_id = '36'
RESULT Resource id #324 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'
RESULT Resource id #327 
QUERY select categories_id from categories where parent_id = '68'
RESULT Resource id #330 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'
RESULT Resource id #333 
QUERY select categories_id from categories where parent_id = '28'
RESULT Resource id #336 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'
RESULT Resource id #339 
QUERY select categories_id from categories where parent_id = '38'
RESULT Resource id #342 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'
RESULT Resource id #345 
QUERY select categories_id from categories where parent_id = '40'
RESULT Resource id #348 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'
RESULT Resource id #351 
QUERY select categories_id from categories where parent_id = '69'
RESULT Resource id #354 
QUERY select count(*) as count from categories where parent_id = '26'
RESULT Resource id #357 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'
RESULT Resource id #360 
QUERY select categories_id from categories where parent_id = '26'
RESULT Resource id #363 
QUERY select count(*) as count from categories where parent_id = '71'
RESULT Resource id #366 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'
RESULT Resource id #369 
QUERY select categories_id from categories where parent_id = '71'
RESULT Resource id #372 
QUERY select count(*) as count from categories where parent_id = '73'
RESULT Resource id #375 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'
RESULT Resource id #378 
QUERY select categories_id from categories where parent_id = '73'
RESULT Resource id #381 
QUERY select count(*) as count from categories where parent_id = '70'
RESULT Resource id #384 
QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'
RESULT Resource id #387 
QUERY select categories_id from categories where parent_id = '70'
RESULT Resource id #390 
QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
RESULT Resource id #394 
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 #399 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #402 
QUERY select specials_new_products_price from specials where products_id = '168' and status
RESULT Resource id #405 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #410 
QUERY select p.products_id, p.products_image, p.products_tax_class_id, 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 where products_status = '1' order by p.products_date_added desc limit 9
RESULT Resource id #420 
QUERY select products_name from products_description where products_id = '176' and language_id = '4'
RESULT Resource id #423 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #426 
QUERY select products_name from products_description where products_id = '175' and language_id = '4'
RESULT Resource id #429 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #432 
QUERY select products_name from products_description where products_id = '174' and language_id = '4'
RESULT Resource id #435 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #438 
QUERY select products_name from products_description where products_id = '173' and language_id = '4'
RESULT Resource id #441 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #444 
QUERY select products_name from products_description where products_id = '172' and language_id = '4'
RESULT Resource id #447 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #450 
QUERY select products_name from products_description where products_id = '171' and language_id = '4'
RESULT Resource id #453 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #456 
QUERY select products_name from products_description where products_id = '170' and language_id = '4'
RESULT Resource id #459 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #462 
QUERY select products_name from products_description where products_id = '168' and language_id = '4'
RESULT Resource id #465 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #468 
QUERY select products_name from products_description where products_id = '167' and language_id = '4'
RESULT Resource id #471 
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 = '206') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '0' group by tr.tax_priority
RESULT Resource id #474 
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit 10
RESULT Resource id #478 
QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10
RESULT Resource id #487 
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '4' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #492 
QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '4' and p.products_id = pd.products_id and pd.language_id = '4' order by r.reviews_id desc limit 10
RESULT Resource id #498 
QUERY select startdate, counter from counter
RESULT Resource id #510 
QUERY update counter set counter = '825063'
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 #515 
QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT Resource id #519 
QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
RESULT 1 
16/11/2010 21:59:36 - /shopping/index.php?cookies=1 (0.090s)