Home/
Listings
pickup-truck
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
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

Ford F 150 8
Pickup Truck
2019
Ford F 150
$27,490.00 $27,998.00
Ford F 150

Gasoline

Ford F 150

135,249mi

Ford F 150

Automatic

Total: 2 / Current Page: 1 of 1

Total execution time: 1732403921.5012 sec.

Framework 1.50 v3.00

Cpu Usage 5842 sec.

Memory Usage 751.34kB

POST: 
Array
(
)
GET: 
Array
(
    [body] => pickup-truck
    [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.category_slug = 'pickup-truck';

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.category_slug = 'pickup-truck' 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.category_slug = 'pickup-truck';
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.category_slug = 'pickup-truck' 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;