Filters

Best Car Deals of The Month

Ford F 150
Jeep Wrangler Unlimited

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: 1714196150.7464 sec.

Framework 1.50 v3.00

Cpu Usage 12784 sec.

Memory Usage 732.58kB

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;