This is a demo store. Any orders placed through this store will not be honored or fulfilled.

+1-505-839-0900CONTACT USABOUT US
0Item(s)

You have no items in your shopping cart.

Product was successfully added to your shopping cart.

AYSO Soccer League

AYSO Soccer League

Set Descending Direction

   

Items 1 to 12 of 53 total

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
Set Descending Direction

   

Items 1 to 12 of 53 total

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
[profiler]
Memory usage: real: 23068672, emalloc: 21421576
Code ProfilerTimeCntEmallocRealMem
Executed 381 queries in 0.20989871025085 seconds
Average query length: 0.00055091525000224 seconds
Queries per second: 1815.1612248816
Longest query length: 0.04170298576355
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