Home/
Listings
chevrolet black
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
Chevrolet Silverado Crew Cab 6
Pickup Truck

Chevrolet Silverado Crew Cab

2021
Chevrolet Silverado Crew Cab

Gasoline

Chevrolet Silverado Crew Cab

94,903mi

Chevrolet Silverado Crew Cab

Automatic

Chevrolet Silverado Crew Cab

4 Doors

Top Speed: mi
Engine: 5.3L
Color: Black
Gasoline
94,903mi
Automatic
4 Doors
Sale Price

$31,795.00

$32,200.00

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

Total execution time: 1716156822.0933 sec.

Framework 1.50 v3.00

Cpu Usage 17398 sec.

Memory Usage 740.56kB

POST: 
Array
(
)
GET: 
Array
(
    [make] => chevrolet
    [color] => black
)

                         
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 = 'chevrolet' AND li.color_name = 'black';

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 = 'chevrolet' AND li.color_name = 'black' 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: 7. SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;
3. SELECT | total: 7.  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.title, l.gallery, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured, li.feature_name, li.location_name FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY price DESC LIMIT 0,30; ;
4. select | total: 8. SELECT id, name FROM `categories`;
5. SELECT | total: 0. SELECT * FROM `advert` ORDER BY RAND() LIMIT 1;
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.make_slug = 'chevrolet' AND li.color_name = 'black';
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 = 'chevrolet' AND li.color_name = 'black' ORDER BY created DESC LIMIT 0,24;