Home/
Listings
subaru
Condition
On Special Right Now
Used
(7)
Make
Chevrolet
(2)
Ford
(1)
Jeep
(1)
Subaru
(2)
Toyota
(1)
Exterior Color
Black
(2)
Gray
(1)
Red
(2)
Silver
(1)
White
(1)
Category
Pickup Truck
(2)
Sedan
(1)
Sport Utility Vehicle
(3)
Wagon
(1)
8500.00
35995.00
2011 2021
48384
164548
Subaru Outback 12
Wagon

Subaru Outback

2011
Subaru Outback

Gasoline

Subaru Outback

156,737mi

Subaru Outback

Automatic

Subaru Outback

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Red
Gasoline
156,737mi
Automatic
4 Doors
Sale Price

$8,995.00

$9,600.00

View More
Subaru Legacy 6
Sedan

Subaru Legacy

2012
Subaru Legacy

Gasoline

Subaru Legacy

164,548mi

Subaru Legacy

Automatic

Subaru Legacy

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Red
Gasoline
164,548mi
Automatic
4 Doors
Sale Price

$8,500.00

$8,500.00

View More
Total: 2 / Current Page: 1 of 1

Total execution time: 1732406854.1335 sec.

Framework 1.50 v3.00

Cpu Usage 4970 sec.

Memory Usage 767.73kB

POST: 
Array
(
)
GET: 
Array
(
    [make] => subaru/
)

                         
Array
(
    [segment] => Array
        (
            [0] => listings
        )

    [route] => /listings
    [template] => front/themes/master/listings.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE (`id` = 1) ;

2. count | total: 2
SELECT COUNT(*) AS items FROM `listings` AS l LEFT JOIN `listings_info` li ON l.id = li.listing_id WHERE li.lstatus = 1 AND li.make_slug = 'subaru';

3. SELECT | total: 2
SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 AND li.make_slug = 'subaru' ORDER BY created DESC LIMIT 0,24;

4. SELECT | total: 2
SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;

1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. count | total: 2. SELECT COUNT(*) AS items FROM `listings` AS l LEFT JOIN `listings_info` li ON l.id = li.listing_id WHERE li.lstatus = 1 AND li.make_slug = 'subaru';
3. SELECT | total: 2.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 AND li.make_slug = 'subaru' ORDER BY created DESC LIMIT 0,24;
4. SELECT | total: 2.  SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;