Wagon
2011
Subaru Outback
$8,995.00 $9,600.00Gasoline
156,737mi
Automatic
You're almost there, select at least one more listing to compare!
Total execution time: 1716154349.8935 sec.
Framework 1.50 v3.00
Cpu Usage 9507 sec.
Memory Usage 769.41kB
POST:Array ( )GET:
Array ( [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. SELECT | total: 1. SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.location_name, li.fuel_name, li.fuel_name, li.make_slug, li.category_slug, li.fuel_name, li.make_name, li.feature_name, u.username, u.avatar, l.* FROM `listings` AS l LEFT JOIN `listings_info` AS li ON li.listing_id = l.id LEFT JOIN `members` AS u ON u.id = l.user_id WHERE l.status = 1 AND l.idx = 7739374 AND l.slug = "2012-subaru-legacy" ;
3. SELECT | total: 0. SELECT * FROM `stats` WHERE DATE(created) = "2024-05-19" AND listing_id = 16 LIMIT 1;
4. insert | total: 1. INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2024-05-19 16:32:29",1,16);
5. UPDATE | total: 1. UPDATE listings SET hits = hits+1 WHERE id = 16;
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: 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.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 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;