Home/
Listings
sport-utility-vehicle
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
Toyota Rav4 5
Sport Utility Vehicle

Toyota Rav4

2020
Toyota Rav4

Gasoline

Toyota Rav4

97,402mi

Toyota Rav4

Automatic

Toyota Rav4

4 Doors

Top Speed: mi
Engine: 2.5L 4
Color: Black
Gasoline
97,402mi
Automatic
4 Doors
Sale Price

$23,995.00

$25,500.00

View More
Chevrolet Traverse 3
Sport Utility Vehicle

Chevrolet Traverse

2016
Chevrolet Traverse

Gasoline

Chevrolet Traverse

83,285mi

Chevrolet Traverse

Automatic

Chevrolet Traverse

4 Doors

Top Speed: mi
Engine: 3.6L 6
Color: Gray
Gasoline
83,285mi
Automatic
4 Doors
Sale Price

$16,998.00

$16,998.00

View More
Jeep Wrangler Unlimited 5
Sport Utility Vehicle

Jeep Wrangler Unlimited

2019
Jeep Wrangler Unlimited

Gasoline

Jeep Wrangler Unlimited

48,384mi

Jeep Wrangler Unlimited

Automatic

Jeep Wrangler Unlimited

4 Doors

Top Speed: mi
Engine: 3.6L 6
Color: Silver
Gasoline
48,384mi
Automatic
4 Doors
Sale Price

$35,495.00

$35,995.00

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

Total execution time: 1732357288.6565 sec.

Framework 1.50 v3.00

Cpu Usage 6560 sec.

Memory Usage 767.41kB

POST: 
Array
(
)
GET: 
Array
(
    [body] => sport-utility-vehicle
)

                         
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: 3
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.category_slug = 'sport-utility-vehicle';

3. SELECT | total: 3
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.category_slug = 'sport-utility-vehicle' 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: 3. 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.category_slug = 'sport-utility-vehicle';
3. SELECT | total: 3.  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.category_slug = 'sport-utility-vehicle' 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;