Comedy

Show: 

Product Name+ Price Buy Now
There's Something About Mary There's Something About Mary $49.99 Buy Now
You've Got Mail You've Got Mail $34.99 Buy Now

Result Pages:  1  Displaying 1 to 2 (of 2 products)
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
What's New?
Unreal Tournament
Unreal Tournament
$89.99
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Shopping Cart
0 items
Reviews
There's Something About Mary
This has to be one of the funniest movies released for 1999! ..
5 of 5 Stars!
Currencies

Copyright © 2025 jQuery/Ajax Advanced Caching System 2.3.3
Powered by osCommerce

Parse Time: 0.020s

FWR MEDIA
KissER Query Output:
Total Queries: 17
Slowest Query Number 1
Time: 0.0009 Seconds.
Total query Time 0.0052 Seconds.
Number: 1
Time: 0.0009 Seconds.
Query: select configuration_key as cfgKey, configuration_value as cfgValue from configuration
Number: 2
Time: 0.0002 Seconds.
Query: select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
Number: 3
Time: 0.0002 Seconds.
Query: select languages_id, name, code, image, directory from languages order by sort_order
Number: 4
Time: 0.0004 Seconds.
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
Number: 5
Time: 0.0003 Seconds.
Query: select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '3' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Number: 6
Time: 0.0002 Seconds.
Query: select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '12' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Number: 7
Time: 0.0002 Seconds.
Query: select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10
Number: 8
Time: 0.0002 Seconds.
Query: select products_name from products_description where products_id = '22' and language_id = '1'
Number: 9
Time: 0.0003 Seconds.
Query: select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '18') and tr.tax_class_id = '1' group by tr.tax_priority
Number: 10
Time: 0.0003 Seconds.
Query: select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '12' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10
Number: 11
Time: 0.0003 Seconds.
Query: select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.reviews_status = 1 order by r.reviews_id desc limit 10
Number: 12
Time: 0.0002 Seconds.
Query: select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1'
Number: 13
Time: 0.0002 Seconds.
Query: select categories_name from categories_description where categories_id = '12' and language_id = '1' limit 1
Number: 14
Time: 0.0002 Seconds.
Query: select c.categories_image, cd.categories_name as catname from categories c, categories_description cd where c.categories_id = '12' and c.categories_id = cd.categories_id and cd.language_id = '1'
Number: 15
Time: 0.0003 Seconds.
Query: select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '12' order by m.manufacturers_name
Number: 16
Time: 0.0004 Seconds.
Query: select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '12'
Number: 17
Time: 0.0004 Seconds.
Query: select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '12' order by pd.products_name limit 0, 20
FWR MEDIA
KissER Error Handling:
Unique error code: 8192 Error Count: 1
Error: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
File: includes/functions/database.php
Line: 19
E_WARNING Error Count: 42
Error: fopen(/tmp/jholmster/configuration_cache.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/configuration_cache_arrays.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/application_top.php
Line: 515
Error: array_flip() expects parameter 1 to be array, null given
File: index.php
Line: 19
Error: array_key_exists() expects parameter 2 to be array, null given
File: index.php
Line: 20
Error: constant(): Couldn't find constant SUBCATCOUNT_12
File: index.php
Line: 23
Error: fopen(/tmp/jholmster/categories_box-english.cache3_12): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: constant(): Couldn't find constant SUBCATCOUNT_1
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_1
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_2
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_2
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_3
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_3
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_10
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_10
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_13
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_13
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_12
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_12
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_15
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_15
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_11
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_11
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_14
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_14
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_21
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_21
File: includes/functions/general.php
Line: 422
Error: fopen(/tmp/jholmster/categories_box-english.cache3_12): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/functions/general.php
Line: 105
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_best_sellers_box-12-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/bm_best_sellers_box-12-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/reviews_box-english.cache3_12): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/reviews_box-english.cache3_12): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/index.php-cPath-3_12-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/index.php-cPath-3_12-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: error_log(/tmp/jholmster/page_parse_time.log): failed to open stream: No such file or directory
File: includes/application_bottom.php
Line: 20
E_NOTICE Error Count: 1
Error: Undefined index: products_id
File: includes/application_top.php
Line: 515