QUERY select value from sessions where sesskey = '4p873kb1j5ff8lurt3tob6at86' and expiry > '1289873420' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289872520' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '4p873kb1j5ff8lurt3tob6at86' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '4p873kb1j5ff8lurt3tob6at86', '91.211.16.126', '1289873420', '1289873420', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = '4p873kb1j5ff8lurt3tob6at86' RESULT Resource id #278 QUERY insert into sessions values ('4p873kb1j5ff8lurt3tob6at86', '1289874860', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 15/11/2010 21:10:20 - /index.php?cookies=1 (0.257s) QUERY select value from sessions where sesskey = 'avperm37bf3p9uic1e2o1kq8t1' and expiry > '1289873423' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289872523' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'avperm37bf3p9uic1e2o1kq8t1' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'avperm37bf3p9uic1e2o1kq8t1', '91.211.16.126', '1289873423', '1289873423', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'avperm37bf3p9uic1e2o1kq8t1' RESULT Resource id #278 QUERY insert into sessions values ('avperm37bf3p9uic1e2o1kq8t1', '1289874863', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 15/11/2010 21:10:23 - /index.php?cookies=1 (0.472s) QUERY select value from sessions where sesskey = '7gutfal43b90vh5s9v9jgq4c02' and expiry > '1289873428' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289872528' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '7gutfal43b90vh5s9v9jgq4c02' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '7gutfal43b90vh5s9v9jgq4c02', '91.211.16.126', '1289873428', '1289873428', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = '7gutfal43b90vh5s9v9jgq4c02' RESULT Resource id #278 QUERY insert into sessions values ('7gutfal43b90vh5s9v9jgq4c02', '1289874868', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 15/11/2010 21:10:28 - /index.php?cookies=1 (0.190s) QUERY select value from sessions where sesskey = 'cpcno77j979ddc9i089qk0ojk4' and expiry > '1289873433' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289872533' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'cpcno77j979ddc9i089qk0ojk4' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'cpcno77j979ddc9i089qk0ojk4', '91.211.16.126', '1289873433', '1289873433', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'cpcno77j979ddc9i089qk0ojk4' RESULT Resource id #278 QUERY insert into sessions values ('cpcno77j979ddc9i089qk0ojk4', '1289874873', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 15/11/2010 21:10:33 - /index.php?cookies=1 (0.361s) QUERY select value from sessions where sesskey = 'rub1ahjlsqnq1f0fb9uhsakjd3' and expiry > '1289873435' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289872535' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'rub1ahjlsqnq1f0fb9uhsakjd3' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'rub1ahjlsqnq1f0fb9uhsakjd3', '91.211.16.126', '1289873435', '1289873435', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'rub1ahjlsqnq1f0fb9uhsakjd3' RESULT Resource id #278 QUERY insert into sessions values ('rub1ahjlsqnq1f0fb9uhsakjd3', '1289874876', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 15/11/2010 21:10:36 - /index.php?cookies=1 (0.314s) QUERY select value from sessions where sesskey = '3kaa6cnes17n2rrsg8fvkmeum2' and expiry > '1289873442' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY select count(*) as count from products_attributes where products_id = '312' RESULT Resource id #55 QUERY select count(*) as count from products where products_parent_id = '312' RESULT Resource id #58 QUERY SELECT p.products_id FROM products p, products_description pd WHERE (p.products_status = 1 or (p.products_status <> 1 and p.products_parent_id <> 0)) and p.products_id = 312 and pd.products_id = 312 and pd.language_id = 1 RESULT Resource id #61 QUERY select count(*) as total from sessions where sesskey = '3kaa6cnes17n2rrsg8fvkmeum2' RESULT Resource id #64 QUERY insert into sessions values ('3kaa6cnes17n2rrsg8fvkmeum2', '1289874882', 'cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:1:{i:312;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;s:6:\"cartID\";s:5:\"73014\";}cre_RCI_data|a:1:{s:7:\"folders\";a:1:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:3:{s:6:\"action\";s:7:\"buy_now\";s:11:\"products_id\";s:3:\"312\";s:5:\"cPath\";s:1:\"2\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}new_products_id_in_cart|s:3:\"312\";') RESULT 1 QUERY select value from sessions where sesskey = '8ul54rdftq2mkrs6hlk1oshi81' and expiry > '1289884400' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289883500' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '8ul54rdftq2mkrs6hlk1oshi81' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '8ul54rdftq2mkrs6hlk1oshi81', '91.211.16.126', '1289884400', '1289884400', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = '8ul54rdftq2mkrs6hlk1oshi81' RESULT Resource id #278 QUERY insert into sessions values ('8ul54rdftq2mkrs6hlk1oshi81', '1289885840', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 00:13:20 - /index.php?cookies=1 (0.200s) QUERY select value from sessions where sesskey = 'bk9sojcs4302kfrnhlqcb7o7j5' and expiry > '1289884402' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289883502' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'bk9sojcs4302kfrnhlqcb7o7j5' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'bk9sojcs4302kfrnhlqcb7o7j5', '91.211.16.126', '1289884402', '1289884402', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'bk9sojcs4302kfrnhlqcb7o7j5' RESULT Resource id #278 QUERY insert into sessions values ('bk9sojcs4302kfrnhlqcb7o7j5', '1289885842', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 00:13:22 - /index.php?cookies=1 (0.245s) QUERY select value from sessions where sesskey = 'f9nmd6ba50211kengus9cjl5r2' and expiry > '1289884404' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289883505' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'f9nmd6ba50211kengus9cjl5r2' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'f9nmd6ba50211kengus9cjl5r2', '91.211.16.126', '1289884405', '1289884405', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'f9nmd6ba50211kengus9cjl5r2' RESULT Resource id #278 QUERY insert into sessions values ('f9nmd6ba50211kengus9cjl5r2', '1289885845', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 00:13:25 - /index.php?cookies=1 (0.193s) QUERY select value from sessions where sesskey = 'o7nclfeeftu06j2nkf8uvk59p4' and expiry > '1289884406' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289883506' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'o7nclfeeftu06j2nkf8uvk59p4' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'o7nclfeeftu06j2nkf8uvk59p4', '91.211.16.126', '1289884406', '1289884406', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'o7nclfeeftu06j2nkf8uvk59p4' RESULT Resource id #278 QUERY insert into sessions values ('o7nclfeeftu06j2nkf8uvk59p4', '1289885846', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 00:13:26 - /index.php?cookies=1 (0.197s) QUERY select value from sessions where sesskey = 'cjashhgsc6rnvactvoceiuqkd7' and expiry > '1289884412' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289883512' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'cjashhgsc6rnvactvoceiuqkd7' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'cjashhgsc6rnvactvoceiuqkd7', '91.211.16.126', '1289884412', '1289884412', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'cjashhgsc6rnvactvoceiuqkd7' RESULT Resource id #278 QUERY insert into sessions values ('cjashhgsc6rnvactvoceiuqkd7', '1289885852', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 00:13:32 - /index.php?cookies=1 (0.192s) QUERY select value from sessions where sesskey = 'kp0hb0a0cbpv44fs2ncqv6dn61' and expiry > '1289917892' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289916992' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'kp0hb0a0cbpv44fs2ncqv6dn61' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'kp0hb0a0cbpv44fs2ncqv6dn61', '91.211.16.126', '1289917892', '1289917892', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'kp0hb0a0cbpv44fs2ncqv6dn61' RESULT Resource id #278 QUERY insert into sessions values ('kp0hb0a0cbpv44fs2ncqv6dn61', '1289919332', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 09:31:32 - /index.php?cookies=1 (0.367s) QUERY select value from sessions where sesskey = '49dkk1o8je5jrphnb974fcjl02' and expiry > '1289917894' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289916994' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '49dkk1o8je5jrphnb974fcjl02' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '49dkk1o8je5jrphnb974fcjl02', '91.211.16.126', '1289917894', '1289917894', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = '49dkk1o8je5jrphnb974fcjl02' RESULT Resource id #278 QUERY insert into sessions values ('49dkk1o8je5jrphnb974fcjl02', '1289919334', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 09:31:34 - /index.php?cookies=1 (0.202s) QUERY select value from sessions where sesskey = 'bcprcreh173lv84jh8qnkqupm6' and expiry > '1289917899' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289916999' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'bcprcreh173lv84jh8qnkqupm6' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'bcprcreh173lv84jh8qnkqupm6', '91.211.16.126', '1289917899', '1289917899', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'bcprcreh173lv84jh8qnkqupm6' RESULT Resource id #278 QUERY insert into sessions values ('bcprcreh173lv84jh8qnkqupm6', '1289919339', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 09:31:39 - /index.php?cookies=1 (0.249s) QUERY select value from sessions where sesskey = 'casl54sagra1betqa8mvo62107' and expiry > '1289917901' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289917001' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'casl54sagra1betqa8mvo62107' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'casl54sagra1betqa8mvo62107', '91.211.16.126', '1289917901', '1289917901', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'casl54sagra1betqa8mvo62107' RESULT Resource id #278 QUERY insert into sessions values ('casl54sagra1betqa8mvo62107', '1289919341', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 09:31:41 - /index.php?cookies=1 (0.255s) QUERY select value from sessions where sesskey = 'fijtjco78pt83tth1lhoijo3s4' and expiry > '1289917903' RESULT Resource id #22 QUERY SELECT COUNT(*) AS numrows FROM languages RESULT Resource id #27 QUERY SELECT l.languages_id, c.configuration_value FROM languages l, configuration c WHERE l.code = c.configuration_value AND c.configuration_key = 'DEFAULT_LANGUAGE' RESULT Resource id #30 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #35 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #44 QUERY delete from whos_online where time_last_click < '1289917003' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'fijtjco78pt83tth1lhoijo3s4' RESULT Resource id #62 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'fijtjco78pt83tth1lhoijo3s4', '91.211.16.126', '1289917903', '1289917903', '/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #71 QUERY select * from template where template_name = 'Original' RESULT Resource id #77 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #82 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 #85 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #89 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #93 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #114 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "left" order by location RESULT Resource id #120 QUERY select box_heading from infobox_heading where infobox_id = '252' and languages_id = '1' RESULT Resource id #123 QUERY select box_heading from infobox_heading where infobox_id = '248' and languages_id = '1' RESULT Resource id #128 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #136 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '6' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #145 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '191' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '116' RESULT Resource id #154 QUERY select count(*) as count from categories where parent_id = '40' RESULT Resource id #157 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #160 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #166 QUERY select count(*) as count from categories where parent_id = '198' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #175 QUERY select count(*) as count from categories where parent_id = '190' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '200' RESULT Resource id #184 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #187 QUERY select count(*) as count from categories where parent_id = '193' RESULT Resource id #190 QUERY select box_heading from infobox_heading where infobox_id = '278' and languages_id = '1' RESULT Resource id #193 QUERY select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name RESULT Resource id #198 QUERY select count(*) as count from topics where parent_id = '4' RESULT Resource id #201 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '4' RESULT Resource id #204 QUERY select topics_id from topics where parent_id = '4' RESULT Resource id #207 QUERY select count(*) as count from topics where parent_id = '3' RESULT Resource id #210 QUERY select count(*) as total from articles a, articles_to_topics a2t where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a2t.topics_id = '3' RESULT Resource id #213 QUERY select topics_id from topics where parent_id = '3' RESULT Resource id #216 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and(a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = ad.articles_id and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) RESULT Resource id #219 QUERY select a.articles_id from articles a, authors au, articles_description ad, articles_to_topics a2t, topics_description td where a.articles_status = '1' and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a.articles_id = ad.articles_id and a2t.topics_id = td.topics_id and ad.language_id = '1' and td.language_id = '1' RESULT Resource id #222 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 7 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #229 QUERY select box_heading from infobox_heading where infobox_id = '264' and languages_id = '1' RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '265' and languages_id = '1' RESULT Resource id #238 QUERY select box_heading from infobox_heading where infobox_id = '268' and languages_id = '1' RESULT Resource id #242 QUERY select box_heading from infobox_heading where infobox_id = '259' and languages_id = '1' RESULT Resource id #246 QUERY select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(), featured_date_added DESC limit 10 RESULT Resource id #250 QUERY select box_heading from infobox_heading where infobox_id = '271' and languages_id = '1' RESULT Resource id #253 QUERY select box_heading from infobox_heading where infobox_id = '281' and languages_id = '1' RESULT Resource id #257 QUERY select ic.categories_id, icd.categories_name from faq_categories ic, faq_categories_description icd where icd.categories_id = ic.categories_id and icd.language_id = '1' and ic.categories_status = '1' order by ic.categories_sort_order, icd.categories_name RESULT Resource id #261 QUERY select ip.faq_id, ip.question from faq ip left join faq_to_categories ip2c on ip2c.faq_id = ip.faq_id where ip2c.categories_id = '0' and ip.language = '1' and ip.visible = '1' order by ip.v_order, ip.question RESULT Resource id #264 QUERY select box_heading from infobox_heading where infobox_id = '282' and languages_id = '1' RESULT Resource id #268 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #274 QUERY select count(*) as total from sessions where sesskey = 'fijtjco78pt83tth1lhoijo3s4' RESULT Resource id #278 QUERY insert into sessions values ('fijtjco78pt83tth1lhoijo3s4', '1289919343', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:5:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a: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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";cre_buySafe_unique_CartId|s:0:\"\";') RESULT 1 16/11/2010 09:31:43 - /index.php?cookies=1 (0.261s)