chevrolet
Condition
Make
Exterior Color
Category
8500.00
35995.00
2011 2021
48384
164548
Chevrolet Traverse 3
Sport Utility Vehicle
2016
Chevrolet Traverse
$16,998.00 $16,998.00
Chevrolet Traverse

Gasoline

Chevrolet Traverse

83,285mi

Chevrolet Traverse

Automatic

Chevrolet Silverado Crew Cab 6
Pickup Truck
2021
Chevrolet Silverado Crew Cab
$31,795.00 $32,200.00
Chevrolet Silverado Crew Cab

Gasoline

Chevrolet Silverado Crew Cab

94,903mi

Chevrolet Silverado Crew Cab

Automatic

Total: 2 / Current Page: 1 of 1

Total execution time: 1732439601.0611 sec.

Framework 1.50 v3.00

Cpu Usage 9324 sec.

Memory Usage 749.46kB

POST:
Array
(
)

                         
GET:
Array
(
    [make] => chevrolet/
    [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: 2
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';

3. SELECT | total: 2
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' 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: 2. 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';
3. SELECT | total: 2.  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' 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;