Audi Tts Coupe

Debug: General | Params (1) | Warnings (0) | Errors (0) | SQL Queries (8)

Total execution time: 0.015077 sec.
Framework CarDealerPro v2.01
Memory Usage 2.65 MB
POST:

Array
(
)

GET:

Array
(
    [url] => listing/6247395/2012-audi-tts-coupe/
)

Array
(
    [_url] => Array
        (
            [0] => listing
            [1] => 6247395
            [2] => 2012-audi-tts-coupe
        )

)

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, 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 = "6247395" AND l.slug = "2012-audi-tts-coupe";

3. SELECT | total: 0
SELECT * FROM `stats` WHERE DATE(created) = "2019-02-19" AND listing_id = 340 LIMIT 1

4. insert | total: 1
INSERT INTO `stats` (created,visits,listing_id) VALUES ("2019-02-19 02:46:07",1,340);

5. UPDATE | total: 1
UPDATE listings SET hits = hits+1 WHERE id = 340

6. SELECT | total: 4
SELECT m.*, p.slug AS pslug, p.home_page FROM `menus` AS m LEFT JOIN `pages` AS p ON m.page_id = p.id WHERE m.active = 1 ORDER BY m.position;

7. SELECT | total: 0
SELECT * FROM `features` WHERE id IN(0) ORDER BY name

8. SELECT | total: 10
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 items DESC LIMIT 10;

Array
(
    [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, 
            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 = "6247395"
          AND l.slug = "2012-audi-tts-coupe";
    [3. SELECT | total: 0 ] => SELECT * FROM `stats` WHERE DATE(created) = "2019-02-19" AND listing_id = 340 LIMIT 1
    [4. insert | total: 1 ] => INSERT INTO `stats` (created,visits,listing_id) VALUES ("2019-02-19 02:46:07",1,340);
    [5. UPDATE | total: 1 ] => UPDATE listings SET hits = hits+1 WHERE id = 340
    [6. SELECT | total: 4 ] => SELECT 
			m.*,
			p.slug AS pslug,
			p.home_page 
		  FROM
			`menus` AS m 
			LEFT JOIN `pages` AS p 
			  ON m.page_id = p.id 
		  WHERE m.active = 1 
		  ORDER BY m.position;
    [7. SELECT | total: 0 ] => SELECT * FROM `features` WHERE id IN(0) ORDER BY name
    [8. SELECT | total: 10 ] => 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 items DESC
          LIMIT 10;
)

2012 - White

Explore Our Cars

Treat yourself to an extraordinary drive