QUERY select value from sessions where sesskey = '6shm0ens319avi6bvifvdr1ir0' and expiry > '1290430760'
RESULT Resource id #15
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #19
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #25
QUERY delete from whos_online where time_last_click < '1290429860'
RESULT 1
QUERY select count(*) as count from whos_online where session_id = '6shm0ens319avi6bvifvdr1ir0'
RESULT Resource id #32
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '6shm0ens319avi6bvifvdr1ir0', '91.211.16.126', '1290430760', '1290430760', '/index.php?cookies=1')
RESULT 1
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #42
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 #45
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #49
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
RESULT Resource id #84
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #88
QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 4
RESULT Resource id #95
QUERY select products_name from products_description where products_id = '112' and language_id = '1'
RESULT Resource id #98
QUERY select products_description, products_id from products_description where products_id = '112' and language_id = '1'
RESULT Resource id #101
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #104
QUERY select products_name from products_description where products_id = '111' and language_id = '1'
RESULT Resource id #119
QUERY select products_description, products_id from products_description where products_id = '111' and language_id = '1'
RESULT Resource id #122
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #125
QUERY select products_name from products_description where products_id = '110' and language_id = '1'
RESULT Resource id #140
QUERY select products_description, products_id from products_description where products_id = '110' and language_id = '1'
RESULT Resource id #143
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #146
QUERY select products_name from products_description where products_id = '109' and language_id = '1'
RESULT Resource id #161
QUERY select products_description, products_id from products_description where products_id = '109' and language_id = '1'
RESULT Resource id #164
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #167
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10
RESULT Resource id #183
QUERY select startdate, counter from counter
RESULT Resource id #192
QUERY update counter set counter = '88667'
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 #198
QUERY select count(*) as total from sessions where sesskey = '6shm0ens319avi6bvifvdr1ir0'
RESULT Resource id #202
QUERY insert into sessions values ('6shm0ens319avi6bvifvdr1ir0', '1290432201', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')
RESULT 1
- /index.php?cookies=1 (0.817s)
QUERY select value from sessions where sesskey = 'cgsbi6cvn4tdrianlj3v5ucai5' and expiry > '1290430765'
RESULT Resource id #15
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #19
QUERY select languages_id, name, code, image, directory from languages order by sort_order
RESULT Resource id #25
QUERY delete from whos_online where time_last_click < '1290429865'
RESULT 1
QUERY select count(*) as count from whos_online where session_id = 'cgsbi6cvn4tdrianlj3v5ucai5'
RESULT Resource id #32
QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'cgsbi6cvn4tdrianlj3v5ucai5', '91.211.16.126', '1290430765', '1290430765', '/index.php?cookies=1')
RESULT 1
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #42
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 #45
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #49
QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
RESULT Resource id #84
QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10
RESULT Resource id #88
QUERY select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 4
RESULT Resource id #95
QUERY select products_name from products_description where products_id = '112' and language_id = '1'
RESULT Resource id #98
QUERY select products_description, products_id from products_description where products_id = '112' and language_id = '1'
RESULT Resource id #101
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #104
QUERY select products_name from products_description where products_id = '111' and language_id = '1'
RESULT Resource id #119
QUERY select products_description, products_id from products_description where products_id = '111' and language_id = '1'
RESULT Resource id #122
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #125
QUERY select products_name from products_description where products_id = '110' and language_id = '1'
RESULT Resource id #140
QUERY select products_description, products_id from products_description where products_id = '110' and language_id = '1'
RESULT Resource id #143
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #146
QUERY select products_name from products_description where products_id = '109' and language_id = '1'
RESULT Resource id #161
QUERY select products_description, products_id from products_description where products_id = '109' and language_id = '1'
RESULT Resource id #164
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '12') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #167
QUERY select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10
RESULT Resource id #183
QUERY select startdate, counter from counter
RESULT Resource id #192
QUERY update counter set counter = '88668'
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 #198
QUERY select count(*) as total from sessions where sesskey = 'cgsbi6cvn4tdrianlj3v5ucai5'
RESULT Resource id #202
QUERY insert into sessions values ('cgsbi6cvn4tdrianlj3v5ucai5', '1290432206', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')
RESULT 1
- /index.php?cookies=1 (0.809s)