Home/
Listings
jeep
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
2019
Jeep Wrangler Unlimited
$35,495.00 $35,995.00
Jeep Wrangler Unlimited

Gasoline

Jeep Wrangler Unlimited

48,384mi

Jeep Wrangler Unlimited

Automatic

Total: 1 / Current Page: 1 of 1

Total execution time: 1734866127.9543 sec.

Framework 1.50 v3.00

Cpu Usage 5090 sec.

Memory Usage 746.27kB

POST: 
Array
(
)
GET: 
Array
(
    [make] => jeep/
    [view] => grid
)

                         
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.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.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. 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.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.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;