Total execution time: 0.016676 sec.
Framework CarDealerPro v2.01
Memory Usage 2.64 MB
POST:
Array
(
)
GET:
Array
(
[url] => listing/6746715/2011-porsche-boxster/
)
Array
(
[_url] => Array
(
[0] => listing
[1] => 6746715
[2] => 2011-porsche-boxster
)
)
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 = "6746715"
AND l.slug = "2011-porsche-boxster";
3. SELECT |
total: 0 SELECT * FROM `stats` WHERE DATE(created) = "2019-02-19" AND listing_id = 338 LIMIT 1
4. insert |
total: 1 INSERT INTO `stats` (created,visits,listing_id) VALUES ("2019-02-19 02:21:55",1,338);
5. UPDATE |
total: 1 UPDATE listings SET hits = hits+1 WHERE id = 338
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 = "6746715"
AND l.slug = "2011-porsche-boxster";
[3. SELECT | total: 0 ] => SELECT * FROM `stats` WHERE DATE(created) = "2019-02-19" AND listing_id = 338 LIMIT 1
[4. insert | total: 1 ] => INSERT INTO `stats` (created,visits,listing_id) VALUES ("2019-02-19 02:21:55",1,338);
[5. UPDATE | total: 1 ] => UPDATE listings SET hits = hits+1 WHERE id = 338
[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;
)