DEVELOPMENT MODE

LCD TVs

LCD TVs

Polaroid High-Quality LCD TVs bring you closer to the action than you ever thought possible. Flat-screen LCD TVs from Polaroid promise crystal-clear, true-to-life images and life-like sound quality. Enjoy your favorite movies and TV shows in unsurpassed, high-definition clarity on a new Polaroid LCD television.

  • Page:
    Showing 1-2 of 2 results
  • Sort by:

15.6" HD LCD TV

USD$ 499.00
  • Aspect ratio: 16:9
  • Digital compatibility: 1080i/720p/480i/480p
details

15.6" HD LCD TV

USD$ 499.00
  • Aspect ratio: 16:9
  • Digital compatibility: 1080i/720p/480i/480p

18.5" HD LCD TV

USD$ 699.00
  • Aspect ratio: 16:9
  • Digital compatibility: 1080i/720p/480i/480p
details

18.5" HD LCD TV

USD$ 699.00
  • Aspect ratio: 16:9
  • Digital compatibility: 1080i/720p/480i/480p
spacer
  • Page:
    Showing 1-2 of 2 results
  • Sort by:




SQL Execution Summary (Longest Time to Shortest)

Execution time SQL Chunk
0.005077 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.003846 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3094 AND m.active=1 AND m.site_id = s.site_id Show
0.004506 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.003760 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_6' AND cd.heade Show
0.003120 seconds SELECT * FROM pure_group Show
0.002629 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.001037 seconds SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_key, p.name, p.catalog_id , cp.assoc_key ,p.upc_code, p.short_description, p.mfg_part_number, p.image, p Show
0.000779 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2384 AND m.active=1 AND m.site_id = s.site_id Show
0.000803 seconds SELECT p.product_key, p.name, p.upc_code, p.mfg_part_number, p.short_description, p.description, p.availability, p.retail_price, p.map_price, p.mfg_of Show
0.000654 seconds SELECT SQL_CALC_FOUND_ROWS c.content_id,c.content_type,c.locked,cd.modify_date,cd.created_date,cd.approved,cd.header,cd.image_1,cd.custom_string_1,sc. Show
0.000468 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3099 AND m.active=1 AND m.site_id = s.site_id Show
0.000467 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=2383 AND m.active=1 AND m.site_id = s.site_id Show
0.000424 seconds SELECT cp.assoc_key, cd.cat_level, cd.cat_rank FROM cat_prod_dump cp, cat_dump cd WHERE cp.product_key='f3cf1bc079f7cea260bce52d6a04f2ac' AND cp.cat Show
0.000486 seconds SELECT s.name, s.description, s.spec_type, s.spec_file FROM spec_dump s WHERE s.product_key='78136a74929591fb78ecb0dd5916bc73' AND s.active=1 AND s Show
0.000419 seconds SELECT s.name, s.description, s.spec_type, s.spec_file FROM spec_dump s WHERE s.product_key='f3cf1bc079f7cea260bce52d6a04f2ac' AND s.active=1 AND s Show
0.000414 seconds SELECT og.group_id, og.name, og.description, og.master_group_id, og.master_option_id FROM option_group_dump og WHERE og.product_key='f3cf1bc079f7cea Show
0.000424 seconds SELECT cp.assoc_key, cd.cat_level, cd.cat_rank FROM cat_prod_dump cp, cat_dump cd WHERE cp.product_key='78136a74929591fb78ecb0dd5916bc73' AND cp.cat Show
0.000370 seconds SELECT image_name, image_order FROM product_image_dump WHERE product_key='f3cf1bc079f7cea260bce52d6a04f2ac' AND active=1 AND language_id = '1' ORDER Show
0.000453 seconds SELECT p.product_key, p.name, p.upc_code, p.mfg_part_number, p.short_description, p.description, p.availability, p.retail_price, p.map_price, p.mfg_of Show
0.000364 seconds SELECT pr.relation_product_key as product_key, pr.match_level, pr.match_strength, pr.qty_need, p.mfg_part_number, p.name, p.image, p.mfg_offer_price Show
0.000247 seconds SELECT sum(quantity) as qty, SUM(actual_price * quantity) as total FROM cart_items WHERE cart_id='0f00hervo7v99s4pm85giff5e7' Show
0.000353 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000318 seconds SELECT assoc_key FROM cat_dump WHERE active=1 AND cat_key1=58682 Show
0.000357 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000351 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000392 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000239 seconds SELECT FOUND_ROWS() as totalrows Show
0.000263 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1805 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000311 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=3000 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000250 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1807 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000000 seconds update pure_sessions set session_data ='current_catalog|i:3;language_id|i:1;currency_id|i:1;', session_expiration = '1269437462', user_id =null , si Show
0.000258 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1806 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000291 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1830 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000253 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3098 AND m.active=1 AND m.site_id = s.site_id Show
0.000295 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1394 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000263 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3097 AND m.active=1 AND m.site_id = s.site_id Show
0.000367 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1393 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000273 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3095 AND m.active=1 AND m.site_id = s.site_id Show
0.000273 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3096 AND m.active=1 AND m.site_id = s.site_id Show
0.000334 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1390 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000265 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1419 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000387 seconds SELECT sr.*, menu1.header as menu1_cat1, menu1.header as menu1_cat1, menu1.custom_string_1 as menu1_cat2, menu1.custom_string_2 as menu1_cat3, menu1. Show
0.000293 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3093 AND m.active=1 AND m.site_id = s.site_id Show
0.000337 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1804 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000335 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000290 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1391 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000419 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000376 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000268 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4332 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000372 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1406 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000288 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1851 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000337 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1838 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000289 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4340 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000341 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1405 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000715 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000352 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1411 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000297 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1409 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000353 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000302 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000355 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000294 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000434 seconds SELECT c.catalog_id, c.assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, cd.description, cd.num_ima Show
0.000292 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000336 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000273 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000282 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000336 seconds SELECT c.assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_key1, c.cat_key2, c.cat_key3, c.ca Show
0.000279 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000356 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000303 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000346 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000330 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1807 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000238 seconds SELECT c.catalog_id, c.assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, cd.description, cd.num_ima Show
0.000366 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000282 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1806 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000372 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000412 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000276 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=3000 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000293 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1830 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000263 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3097 AND m.active=1 AND m.site_id = s.site_id Show
0.000364 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000256 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1394 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000274 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1387 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000592 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000420 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000256 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3096 AND m.active=1 AND m.site_id = s.site_id Show
0.000586 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000370 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000264 seconds SELECT * FROM pure_media m, pure_site s WHERE file_id=3094 AND m.active=1 AND m.site_id = s.site_id Show
0.000262 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1393 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000363 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000382 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000257 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1392 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000264 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1389 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000331 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000570 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000370 seconds SELECT * FROM pure_content c, pure_content_data cd, pure_site_content sc WHERE c.content_id = sc.content_id AND c.content_id = cd.content_id AND c Show
0.000285 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4332 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000258 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1804 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000303 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1851 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000276 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1852 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000429 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1411 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000277 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=4340 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000423 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000241 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1839 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000299 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1409 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000223 seconds SELECT cs.*, c.content_type FROM pure_content_specs cs, pure_content c WHERE c.content_id=1838 AND c.content_id = cs.content_id AND cs.language_id = Show
0.000375 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000481 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_8' AND cd.heade Show
0.000363 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000337 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000309 seconds SELECT c.catalog_id, c.assoc_key, c.parent_assoc_key, c.cat_level, c.cat_rank, c.cat_name1, c.cat_name2, c.cat_name3, c.cat_name4, c.cat_name5, c.cat_ Show
0.000378 seconds SELECT currency_id, language_id FROM cat_lang_dump WHERE catalog_id = 3 AND default_language = 1 Show
0.000339 seconds SELECT DISTINCT language_id, language_name FROM cat_lang_dump WHERE catalog_id = 3 Show
0.000433 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_3' AND cd.heade Show
0.000294 seconds SELECT DISTINCT currency_id, currency_name FROM cat_lang_dump WHERE catalog_id = 3 Show
0.000277 seconds SELECT 1 FROM cat_lang_dump WHERE language_id = 1 AND currency_id = 1 Show
0.000273 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_4' AND cd.heade Show
0.000219 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_8' AND cd.heade Show
0.000214 seconds SELECT cd.content_id FROM pure_content c JOIN pure_content_data cd ON c.content_id=cd.content_id WHERE c.content_type='categorization_4' AND cd.heade Show