Home/
Listings
jeep used
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
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: 1 / Current Page: 1 of 1

Total execution time: 1716178689.6432 sec.

Framework 1.50 v3.00

Cpu Usage 12704 sec.

Memory Usage 753.27kB

POST: 
Array
(
)
GET: 
Array
(
    [make] => jeep
    [condition] => used
)

                         
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: 1
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.condition_name = 'used' AND li.make_slug = 'jeep';

3. SELECT | total: 1
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.condition_name = 'used' AND li.make_slug = 'jeep' 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. SELECT | total: 1.  SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.location_name, li.fuel_name, li.fuel_name, li.make_slug, li.category_slug, li.fuel_name, li.make_name, li.feature_name, u.username, u.avatar, l.* FROM `listings` AS l LEFT JOIN `listings_info` AS li ON li.listing_id = l.id LEFT JOIN `members` AS u ON u.id = l.user_id WHERE l.status = 1 AND l.idx = 8768478 AND l.slug = "2020-toyota-rav4" ;
3. SELECT | total: 1.  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.condition_name = 'used' AND li.make_slug = 'jeep' ORDER BY created DESC LIMIT 0,24;
4. UPDATE | total: 1. UPDATE `stats` SET visits = visits+1 WHERE listing_id = 15 AND DATE(created) = "2024-05-19";
5. UPDATE | total: 1. UPDATE listings SET hits = hits+1 WHERE id = 15;
6. 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;
2. count | total: 0. 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 = 'chevrolet' AND li.color_name = 'red';
3. SELECT | total: 0.  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 = 'chevrolet' AND li.color_name = 'red' ORDER BY created DESC;
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;
2. count | total: 1. 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.condition_name = 'used' AND li.make_slug = 'jeep';