QUERY select value from sessions where sesskey = '0d9304f919e8b9e1904245f2bf6ca0f5' and expiry > '1290435843' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1290434943' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '0d9304f919e8b9e1904245f2bf6ca0f5' RESULT Resource id #44 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '0d9304f919e8b9e1904245f2bf6ca0f5', '91.211.16.126', '1290435843', '1290435843', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #55 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 #58 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #62 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #72 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 #76 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 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'FreeShip' RESULT Resource id #81 QUERY select count(*) as count from banners_history where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #85 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #101 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #107 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #110 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #119 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #122 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #131 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #134 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #144 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #147 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #156 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #165 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #174 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #177 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #183 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #194 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #203 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #209 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #212 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #221 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #227 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #250 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #259 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #269 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #272 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #275 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #290 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #293 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #299 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #302 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #308 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #311 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #314 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #317 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #320 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #323 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #329 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #332 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #335 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #342 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #345 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #348 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #351 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #354 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #357 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #360 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #363 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #366 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #369 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #372 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #375 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #378 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #381 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #384 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #387 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #390 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #393 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #396 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #399 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #402 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #405 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #409 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #412 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #415 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #418 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #421 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #424 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #427 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #430 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #434 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 3 RESULT Resource id #448 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #460 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #463 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #479 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #482 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #498 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #501 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 3 RESULT Resource id #505 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 #510 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #528 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #531 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #534 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #537 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 3 RESULT Resource id #541 QUERY select products_name from products_description where products_id = '492' and language_id = '1' RESULT Resource id #544 QUERY select specials_new_products_price from specials where products_id = '492' and status RESULT Resource id #547 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #552 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #555 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #571 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #607 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #610 QUERY select startdate, counter from counter RESULT Resource id #629 QUERY update counter set counter = '47283' 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 #635 QUERY select count(*) as total from sessions where sesskey = '0d9304f919e8b9e1904245f2bf6ca0f5' RESULT Resource id #639 QUERY insert into sessions values ('0d9304f919e8b9e1904245f2bf6ca0f5', '1290437283', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.358s) QUERY select value from sessions where sesskey = 'c75b414db65308bf4fef70d731b13d14' and expiry > '1290435846' RESULT Resource id #18 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #22 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #28 QUERY delete from whos_online where time_last_click < '1290434946' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'c75b414db65308bf4fef70d731b13d14' RESULT Resource id #44 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'c75b414db65308bf4fef70d731b13d14', '91.211.16.126', '1290435846', '1290435846', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #55 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 #58 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #62 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #71 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 #75 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'FreeShip' RESULT Resource id #80 QUERY select count(*) as count from banners_history where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #84 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #96 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #137 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #182 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #186 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #230 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #237 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #255 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #258 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #334 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #337 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #341 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #401 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #408 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #426 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #429 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #433 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 #449 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #467 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #470 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #473 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #476 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 3 RESULT Resource id #480 QUERY select products_name from products_description where products_id = '489' and language_id = '1' RESULT Resource id #483 QUERY select specials_new_products_price from specials where products_id = '489' and status RESULT Resource id #486 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #491 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #494 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #514 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #550 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '3' and languages_id = '1' RESULT Resource id #553 QUERY select startdate, counter from counter RESULT Resource id #568 QUERY update counter set counter = '47284' 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 #574 QUERY select count(*) as total from sessions where sesskey = 'c75b414db65308bf4fef70d731b13d14' RESULT Resource id #578 QUERY insert into sessions values ('c75b414db65308bf4fef70d731b13d14', '1290437286', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.086s) Adaptive Technology for Independent Living in the Denver Metro of Colorado
Skip to Main Content
  Home » Catalog » Cookie Usage Bookmark Us   
Categories
Offers
Enter Code
Information
  Discount Codes
  About Us
  Press Room
  Contact Us
  Downloads
  Resources
  Meet the Staff
  Shipping & Returns
  Privacy Notice
Beyond Sight
Please call to schedule an appointment or to discuss your low vision needs.
We are the experts and can help you find the best product to help with your low vision goals.
All Major Credit Cards Accepted
Cookie Usage Cookie Usage
Cookie Privacy and Security
Cookies must be enabled to purchase online on this store to embrace privacy and security related issues regarding your visit to this site.

By enabling cookie support on your browser, the communication between you and this site is strengthened to be certain it is you who are making transactions on your own behalf, and to prevent leakage of your privacy information.
We have detected that your browser does not support cookies, or has set cookies to be disabled.

To continue shopping online, we encourage you to enable cookies on your browser.

For Internet Explorer browsers, please follow these instructions:
  1. Click on the Tools menubar, and select Internet Options
  2. Select the Security tab, and reset the security level to Medium
We have taken this measurement of security for your benefit, and apologize upfront if any inconveniences are caused.

Please contact the store owner if you have any questions relating to this requirement, or to continue purchasing products offline.
Continue
Search Store
 
Advanced Search
What's New?
Merlin Ultra HD 22-inch

Merlin Ultra HD 22-inch

$2,995.00
Catalog
Beyond Sight Product Spotlight Catalog
Product Spotlight Catalog
Click to Open a PDF Version of a Magnification Test
Monday 20 February, 2017
6199609 - Website Requests Since - Saturday 11 September, 2010

QUERY select value from sessions where sesskey = '1ea3e13dc0fc83769711d90f49ea0ba3' and expiry > '1291526962' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291526062' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '1ea3e13dc0fc83769711d90f49ea0ba3' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '1ea3e13dc0fc83769711d90f49ea0ba3', '91.211.16.126', '1291526962', '1291526962', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #74 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 #78 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 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'FreeShip' RESULT Resource id #83 QUERY select count(*) as count from banners_history where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #87 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #96 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #99 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #182 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #189 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #192 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #223 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #226 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #229 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #236 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #255 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #258 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #261 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #334 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #337 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #340 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #401 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #407 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #426 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #429 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #432 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #436 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 3 RESULT Resource id #450 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #466 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #469 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #481 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #484 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #496 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #499 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 3 RESULT Resource id #503 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 #508 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #526 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #529 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #532 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #535 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 3 RESULT Resource id #539 QUERY select products_name from products_description where products_id = '495' and language_id = '1' RESULT Resource id #542 QUERY select specials_new_products_price from specials where products_id = '495' and status RESULT Resource id #545 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #550 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #553 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #573 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #609 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #612 QUERY select startdate, counter from counter RESULT Resource id #631 QUERY update counter set counter = '85551' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '1ea3e13dc0fc83769711d90f49ea0ba3' RESULT Resource id #638 QUERY insert into sessions values ('1ea3e13dc0fc83769711d90f49ea0ba3', '1291528402', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.090s) QUERY select value from sessions where sesskey = '7799f7b93aa793aa782a384b56459aa3' and expiry > '1291526964' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1291526064' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '7799f7b93aa793aa782a384b56459aa3' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '7799f7b93aa793aa782a384b56459aa3', '91.211.16.126', '1291526964', '1291526964', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #73 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 #77 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'FreeShip' RESULT Resource id #82 QUERY select count(*) as count from banners_history where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #86 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '3' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #102 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #108 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #111 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #114 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #117 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #120 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #126 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #129 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #132 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #135 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #188 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #191 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #195 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #198 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #201 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #204 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #210 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #213 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #216 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #219 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #222 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #225 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #228 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #239 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #242 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #245 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #248 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #251 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #254 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #257 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #260 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #264 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #267 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #270 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #276 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #279 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #282 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #285 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #288 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #291 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #294 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #297 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #300 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #303 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #306 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #309 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #312 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #315 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #318 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #321 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #324 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #327 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #330 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #333 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #336 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #339 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #343 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #346 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #349 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #352 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #355 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #358 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #361 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #364 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #367 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #370 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #373 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #376 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #379 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #382 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #385 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #388 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #391 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #394 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #397 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #400 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #403 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #406 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #410 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #413 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #416 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #419 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #422 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #425 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #428 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #431 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #435 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 #451 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #461 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #464 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #467 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #470 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 3 RESULT Resource id #474 QUERY select products_name from products_description where products_id = '493' and language_id = '1' RESULT Resource id #477 QUERY select specials_new_products_price from specials where products_id = '493' and status RESULT Resource id #480 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #485 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #488 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #504 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #540 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #543 QUERY select startdate, counter from counter RESULT Resource id #562 QUERY update counter set counter = '85552' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '7799f7b93aa793aa782a384b56459aa3' RESULT Resource id #569 QUERY insert into sessions values ('7799f7b93aa793aa782a384b56459aa3', '1291528404', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.192s) QUERY select value from sessions where sesskey = '98eb47f6121149ea493d35b0efe345d6' and expiry > '1294129146' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294128246' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '98eb47f6121149ea493d35b0efe345d6' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '98eb47f6121149ea493d35b0efe345d6', '91.211.16.126', '1294129146', '1294129146', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #74 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #81 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #84 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #101 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #107 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #110 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #119 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #122 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #132 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #135 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #144 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #147 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #156 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #165 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #174 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #177 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #188 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #191 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #194 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #203 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #209 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #212 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #221 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #225 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #228 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #250 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #257 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #260 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #269 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #272 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #275 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #290 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #293 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #299 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #302 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #308 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #311 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #314 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #317 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #320 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #323 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #329 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #332 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #336 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #339 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #342 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #345 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #348 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #351 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #354 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #357 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #360 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #363 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #366 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #369 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #372 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #375 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #378 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #381 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #384 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #387 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #390 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #393 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #396 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #399 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #403 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #406 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #409 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #412 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #415 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #418 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #421 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #424 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #428 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 3 RESULT Resource id #442 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #454 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #457 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #473 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #476 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #488 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #491 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 3 RESULT Resource id #495 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 #500 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #510 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #513 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #516 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #519 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 3 RESULT Resource id #523 QUERY select products_name from products_description where products_id = '496' and language_id = '1' RESULT Resource id #526 QUERY select specials_new_products_price from specials where products_id = '496' and status RESULT Resource id #529 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #534 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #537 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #553 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #587 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '3' and languages_id = '1' RESULT Resource id #590 QUERY select startdate, counter from counter RESULT Resource id #605 QUERY update counter set counter = '190530' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '98eb47f6121149ea493d35b0efe345d6' RESULT Resource id #612 QUERY insert into sessions values ('98eb47f6121149ea493d35b0efe345d6', '1294130586', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.091s) QUERY select value from sessions where sesskey = 'ba4132e7cce5d07587b9f6adbee3412d' and expiry > '1294129148' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294128248' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'ba4132e7cce5d07587b9f6adbee3412d' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'ba4132e7cce5d07587b9f6adbee3412d', '91.211.16.126', '1294129148', '1294129148', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #73 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #80 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #83 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #87 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #90 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #131 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #134 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #137 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #183 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #227 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #237 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #259 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #335 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #341 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #402 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #405 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #408 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #427 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 #443 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #456 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #462 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 3 RESULT Resource id #466 QUERY select products_name from products_description where products_id = '494' and language_id = '1' RESULT Resource id #469 QUERY select specials_new_products_price from specials where products_id = '494' and status RESULT Resource id #472 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #477 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #480 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #496 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #530 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #533 QUERY select startdate, counter from counter RESULT Resource id #552 QUERY update counter set counter = '190531' RESULT 1 QUERY select count(*) as total from sessions where sesskey = 'ba4132e7cce5d07587b9f6adbee3412d' RESULT Resource id #559 QUERY insert into sessions values ('ba4132e7cce5d07587b9f6adbee3412d', '1294130588', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.105s) QUERY select value from sessions where sesskey = '88f9875df238311d817008b0eb04c82e' and expiry > '1294258696' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294257796' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '88f9875df238311d817008b0eb04c82e' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '88f9875df238311d817008b0eb04c82e', '91.211.16.126', '1294258696', '1294258696', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #74 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #81 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #84 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #101 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #107 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #110 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #119 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #122 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #132 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #135 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #144 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #147 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #156 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #165 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #174 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #177 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #188 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #191 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #194 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #203 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #209 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #212 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #221 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #225 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #228 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #250 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #257 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #260 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #269 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #272 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #275 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #290 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #293 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #299 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #302 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #308 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #311 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #314 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #317 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #320 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #323 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #329 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #332 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #336 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #339 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #342 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #345 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #348 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #351 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #354 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #357 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #360 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #363 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #366 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #369 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #372 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #375 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #378 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #381 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #384 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #387 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #390 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #393 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #396 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #399 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #403 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #406 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #409 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #412 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #415 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #418 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #421 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #424 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #428 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 3 RESULT Resource id #442 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #454 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #457 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #473 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #476 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #488 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #491 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 3 RESULT Resource id #495 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 #500 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #510 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #513 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #516 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #519 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 3 RESULT Resource id #523 QUERY select products_name from products_description where products_id = '494' and language_id = '1' RESULT Resource id #526 QUERY select specials_new_products_price from specials where products_id = '494' and status RESULT Resource id #529 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #534 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #537 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #553 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #587 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #590 QUERY select startdate, counter from counter RESULT Resource id #605 QUERY update counter set counter = '194640' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '88f9875df238311d817008b0eb04c82e' RESULT Resource id #612 QUERY insert into sessions values ('88f9875df238311d817008b0eb04c82e', '1294260136', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.307s) QUERY select value from sessions where sesskey = '110cd524e32a77310201eb11c6ca9afa' and expiry > '1294258697' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294257797' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '110cd524e32a77310201eb11c6ca9afa' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '110cd524e32a77310201eb11c6ca9afa', '91.211.16.126', '1294258697', '1294258697', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #73 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #80 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #83 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #87 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #90 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #131 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #134 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #137 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #183 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #227 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #237 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #259 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #335 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #341 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #402 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #405 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #408 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #427 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 #443 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #456 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #462 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 3 RESULT Resource id #466 QUERY select products_name from products_description where products_id = '494' and language_id = '1' RESULT Resource id #469 QUERY select specials_new_products_price from specials where products_id = '494' and status RESULT Resource id #472 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #477 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #480 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #496 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #530 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '3' and languages_id = '1' RESULT Resource id #533 QUERY select startdate, counter from counter RESULT Resource id #548 QUERY update counter set counter = '194641' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '110cd524e32a77310201eb11c6ca9afa' RESULT Resource id #555 QUERY insert into sessions values ('110cd524e32a77310201eb11c6ca9afa', '1294260137', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.080s) QUERY select value from sessions where sesskey = 'b8361100e88fecbab240b5bb1da12c16' and expiry > '1294307418' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294306518' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'b8361100e88fecbab240b5bb1da12c16' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'b8361100e88fecbab240b5bb1da12c16', '91.211.16.126', '1294307418', '1294307418', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #74 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #81 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #84 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #101 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #107 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #110 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #119 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #122 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #132 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #135 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #144 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #147 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #156 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #165 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #174 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #177 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #188 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #191 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #194 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #203 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #209 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #212 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #221 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #225 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #228 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #250 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #257 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #260 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #269 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #272 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #275 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #290 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #293 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #299 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #302 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #308 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #311 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #314 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #317 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #320 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #323 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #329 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #332 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #336 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #339 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #342 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #345 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #348 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #351 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #354 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #357 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #360 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #363 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #366 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #369 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #372 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #375 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #378 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #381 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #384 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #387 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #390 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #393 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #396 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #399 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #403 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #406 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #409 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #412 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #415 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #418 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #421 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #424 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #428 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 3 RESULT Resource id #442 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #454 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #457 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #473 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #476 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #488 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #491 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 3 RESULT Resource id #495 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 #500 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #510 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #513 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #516 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #519 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 3 RESULT Resource id #523 QUERY select products_name from products_description where products_id = '495' and language_id = '1' RESULT Resource id #526 QUERY select specials_new_products_price from specials where products_id = '495' and status RESULT Resource id #529 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #534 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #537 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #557 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #591 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '3' and languages_id = '1' RESULT Resource id #594 QUERY select startdate, counter from counter RESULT Resource id #609 QUERY update counter set counter = '196335' RESULT 1 QUERY select count(*) as total from sessions where sesskey = 'b8361100e88fecbab240b5bb1da12c16' RESULT Resource id #616 QUERY insert into sessions values ('b8361100e88fecbab240b5bb1da12c16', '1294308858', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.144s) QUERY select value from sessions where sesskey = '06b784dcf416247119cb762a7a98584c' and expiry > '1294307420' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294306520' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '06b784dcf416247119cb762a7a98584c' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '06b784dcf416247119cb762a7a98584c', '91.211.16.126', '1294307420', '1294307420', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #73 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #80 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #83 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #87 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #90 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #131 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #134 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #137 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #183 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #227 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #237 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #259 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #335 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #341 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #402 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #405 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #408 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #427 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 #443 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #456 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #462 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 3 RESULT Resource id #466 QUERY select products_name from products_description where products_id = '494' and language_id = '1' RESULT Resource id #469 QUERY select specials_new_products_price from specials where products_id = '494' and status RESULT Resource id #472 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #477 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #480 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #496 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #530 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #533 QUERY select startdate, counter from counter RESULT Resource id #552 QUERY update counter set counter = '196336' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '06b784dcf416247119cb762a7a98584c' RESULT Resource id #559 QUERY insert into sessions values ('06b784dcf416247119cb762a7a98584c', '1294308860', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.085s) QUERY select value from sessions where sesskey = 'a909f47081d6d2af263b35c54eb4b815' and expiry > '1294337832' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294336933' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'a909f47081d6d2af263b35c54eb4b815' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'a909f47081d6d2af263b35c54eb4b815', '91.211.16.126', '1294337833', '1294337833', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #74 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #81 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #84 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #91 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #101 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #104 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #107 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #110 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #119 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #122 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #132 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #135 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #144 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #147 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #150 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #156 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #165 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #174 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #177 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #188 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #191 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #194 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #200 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #203 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #209 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #212 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #221 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #225 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #228 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #232 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #235 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #238 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #247 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #250 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #257 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #260 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #269 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #272 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #275 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #290 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #293 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #299 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #302 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #308 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #311 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #314 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #317 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #320 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #323 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #329 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #332 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #336 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #339 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #342 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #345 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #348 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #351 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #354 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #357 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #360 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #363 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #366 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #369 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #372 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #375 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #378 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #381 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #384 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #387 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #390 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #393 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #396 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #399 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #403 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #406 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #409 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #412 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #415 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #418 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #421 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #424 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #428 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 3 RESULT Resource id #442 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #454 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #457 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #473 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #476 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #488 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #491 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 3 RESULT Resource id #495 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 #500 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #510 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #513 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #516 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #519 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 3 RESULT Resource id #523 QUERY select products_name from products_description where products_id = '496' and language_id = '1' RESULT Resource id #526 QUERY select specials_new_products_price from specials where products_id = '496' and status RESULT Resource id #529 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #534 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #537 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #553 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #587 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '4' and languages_id = '1' RESULT Resource id #590 QUERY select startdate, counter from counter RESULT Resource id #609 QUERY update counter set counter = '197195' RESULT 1 QUERY select count(*) as total from sessions where sesskey = 'a909f47081d6d2af263b35c54eb4b815' RESULT Resource id #616 QUERY insert into sessions values ('a909f47081d6d2af263b35c54eb4b815', '1294339273', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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.088s) QUERY select value from sessions where sesskey = '0a26d28f3396f5b7952247c02279befd' and expiry > '1294337834' RESULT Resource id #20 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #24 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #30 QUERY delete from whos_online where time_last_click < '1294336934' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '0a26d28f3396f5b7952247c02279befd' RESULT Resource id #46 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '0a26d28f3396f5b7952247c02279befd', '91.211.16.126', '1294337834', '1294337834', '/cookie_usage.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #57 QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id RESULT Resource id #60 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #64 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '148x144' RESULT Resource id #73 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id="1" order by sort_order, cd.categories_name RESULT Resource id #80 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #83 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #87 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #90 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #94 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #97 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #100 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #109 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #112 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #121 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #131 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #134 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #137 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #140 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #146 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #164 QUERY select count(*) as count from categories where parent_id = '70' RESULT Resource id #167 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #170 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #176 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #180 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #183 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #190 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #193 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #196 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #199 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #202 QUERY select count(*) as count from categories where parent_id = '18' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #211 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #214 QUERY select count(*) as count from categories where parent_id = '61' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #220 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #227 QUERY select count(*) as count from categories where parent_id = '3' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #237 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #240 QUERY select count(*) as count from categories where parent_id = '13' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #246 QUERY select count(*) as count from categories where parent_id = '11' RESULT Resource id #249 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #252 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #256 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #259 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #262 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #265 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #268 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #277 QUERY select count(*) as count from categories where parent_id = '28' RESULT Resource id #280 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '27' RESULT Resource id #286 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #289 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #292 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #295 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #298 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #301 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #304 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #307 QUERY select count(*) as count from categories where parent_id = '65' RESULT Resource id #310 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #313 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #316 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #319 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #322 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #325 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #328 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #331 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #335 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #341 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #344 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #350 QUERY select count(*) as count from categories where parent_id = '41' RESULT Resource id #353 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #356 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #359 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #362 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #365 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #368 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #371 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '42' RESULT Resource id #377 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #380 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #383 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #389 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #392 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #398 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #402 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #405 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #408 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #411 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #414 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #417 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #420 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #423 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #427 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 #443 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #456 QUERY select zip_tax_rate from ziptax where zip_code = '' 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #462 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 3 RESULT Resource id #466 QUERY select products_name from products_description where products_id = '496' and language_id = '1' RESULT Resource id #469 QUERY select specials_new_products_price from specials where products_id = '496' and status RESULT Resource id #472 QUERY select zip_tax_rate from ziptax where zip_code = '' RESULT Resource id #477 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_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 = '13') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #480 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 6 RESULT Resource id #496 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 15 RESULT Resource id #530 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '2' and languages_id = '1' RESULT Resource id #533 QUERY select startdate, counter from counter RESULT Resource id #548 QUERY update counter set counter = '197196' RESULT 1 QUERY select count(*) as total from sessions where sesskey = '0a26d28f3396f5b7952247c02279befd' RESULT Resource id #555 QUERY insert into sessions values ('0a26d28f3396f5b7952247c02279befd', '1294339274', 'SESSION_USER_AGENT|s:145:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; WebMoney Advisor; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)\";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:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 - /cookie_usage.php?cookies=1 (0.098s)