Product was successfully added to your shopping cart.

Soccer Color Tek Trophy

Quick Overview

start - 3 lines, max - 3 lines, 35 Characters

Availability: In stock

$19.50
  • Buy 25 for $18.14 each and save 7%
  • Buy 50 for $16.77 each and save 14%
  • Buy 100 for $15.60 each and save 20%
  • Buy 250 for $12.87 each and save 34%

* Required Fields

$19.50
[profiler]
Memory usage: real: 36962304, emalloc: 35881808
Code ProfilerTimeCntEmallocRealMem
Executed 57 queries in 0.072765350341797 seconds
Average query length: 0.0012765850937157 seconds
Queries per second: 783.3398689384
Longest query length: 0.037144899368286
Longest query:
SELECT `main_table`.`entity_id`, main_table.`name`, main_table.`path`, `main_table`.`is_active`, `main_table`.`is_anchor`, `url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS `main_table` LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.include_in_menu = '1') AND (main_table.is_active = '1') AND (main_table.path like '1/2/%') ORDER BY `main_table`.`position` ASC