Filters

Best Car Deals of The Month

Jeep Wrangler Unlimited
Ford F 150

Our Most Popular Brands

Browse inventory by Brand Name

Why choose us?

achievement
Wide range of brands

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

trust
Trusted by our clients

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

finance
Fast & easy financing

We can help with your financing plan, we can offer some tips and tricks. Drive off with this dream car of yours regardless of your credit history.

Total execution time: 1718593843.3852 sec.

Framework 1.50 v3.00

Cpu Usage 10764 sec.

Memory Usage 742.31kB

POST:
Array
(
)

                         
GET:
Array
(
)

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

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

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

2. select | total: 1
SELECT title, body, keywords, description FROM `pages` WHERE (`type` = "home") and (`active` = 1) ;

3. select | total: 0
SELECT thumb, body, caption, url FROM `slider` ORDER BY `sorting` ASC;

4. SELECT | total: 2
SELECT l.id, l.idx, l.nice_title, l.slug, l.price, l.price_sale, l.thumb, l.year, l.sold, l.drive_train, t.name AS transmission, f.name AS fuel FROM `listings` AS l LEFT JOIN `transmissions` AS t ON t.id = l.transmission LEFT JOIN `fuel` AS f ON f.id = l.fuel WHERE l.featured = 1 AND l.status = 1 ORDER BY RAND () LIMIT 5;

5. SELECT | total: 2
SELECT c.id, c.name, c.slug, c.image, COUNT(l.id) AS listings FROM `categories` AS c LEFT JOIN `listings` AS l ON l.category = c.id WHERE l.status = 1 AND l.featured = 1 GROUP BY c.id LIMIT 50;

6. SELECT | total: 2
SELECT idx, nice_title, slug, thumb, year, price, sold FROM `listings` WHERE status = 1 AND featured = 1 ORDER BY created DESC LIMIT 0, 50;

7. SELECT | total: 5
SELECT m.name, m.id, COUNT(m.id) as items FROM `makes` AS m INNER JOIN `listings` AS l ON l.make_id = m.id WHERE l.status = 1 GROUP BY m.id ORDER BY RAND() LIMIT 8;

8. SELECT | total: 0
SELECT r.*, CONCAT(m.fname,' ',m.lname) as name, m.avatar, m.id AS uid FROM `reviews` AS r LEFT JOIN `members` AS m ON m.id = r.user_id WHERE r.status = 1 ORDER BY r.created DESC;

9. 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 title, body, keywords, description FROM `pages` WHERE (`type` = "home") and (`active` = 1) ;
3. select | total: 0. SELECT thumb, body, caption, url FROM `slider` ORDER BY `sorting` ASC;
4. SELECT | total: 2.  SELECT l.id, l.idx, l.nice_title, l.slug, l.price, l.price_sale, l.thumb, l.year, l.sold, l.drive_train, t.name AS transmission, f.name AS fuel FROM `listings` AS l LEFT JOIN `transmissions` AS t ON t.id = l.transmission LEFT JOIN `fuel` AS f ON f.id = l.fuel WHERE l.featured = 1 AND l.status = 1 ORDER BY RAND () LIMIT 5;
5. SELECT | total: 2.  SELECT c.id, c.name, c.slug, c.image, COUNT(l.id) AS listings FROM `categories` AS c LEFT JOIN `listings` AS l ON l.category = c.id WHERE l.status = 1 AND l.featured = 1 GROUP BY c.id LIMIT 50;
6. SELECT | total: 2. SELECT idx, nice_title, slug, thumb, year, price, sold FROM `listings` WHERE status = 1 AND featured = 1 ORDER BY created DESC LIMIT 0, 50;
7. SELECT | total: 5.  SELECT m.name, m.id, COUNT(m.id) as items FROM `makes` AS m INNER JOIN `listings` AS l ON l.make_id = m.id WHERE l.status = 1 GROUP BY m.id ORDER BY RAND() LIMIT 8;
8. SELECT | total: 0.  SELECT r.*, CONCAT(m.fname,' ',m.lname) as name, m.avatar, m.id AS uid FROM `reviews` AS r LEFT JOIN `members` AS m ON m.id = r.user_id WHERE r.status = 1 ORDER BY r.created DESC;
9. 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;