Total execution time: 0.024371 sec.
Framework CarDealerPro v2.01
Memory Usage 3.32 MB
POST:
Array
(
)
GET:
Array
(
[url] => make/nissan/
)
Array
(
[_url] => Array
(
[0] => make
[1] => nissan
)
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT name, name_slug, id FROM `makes` WHERE name_slug = "nissan" LIMIT 1;
3. SELECT |
total: 2 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;
4. count |
total: 1 SELECT COUNT(*) FROM `listings` WHERE status = 1 AND make_id = 94
5. SELECT |
total: 1 SELECT
li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name,
l.idx, l.nice_title, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.thumb, l.created, l.featured, l.body, l.mileage
FROM
`listings_info` AS li
LEFT JOIN `listings` AS l
ON l.id = li.listing_id
WHERE l.status = 1
AND l.make_id = 94
ORDER BY l.featured DESC, l.created DESC
LIMIT 0,30;
6. select |
total: 124 SELECT * FROM `models` WHERE make_id = 94 ORDER BY name;
7. select |
total: 13 SELECT make_name, category_name FROM `listings_info` ORDER BY make_name;
Array
(
[1. select | total: 1 ] => SELECT * FROM `settings` WHERE id = 1 ;
[2. select | total: 1 ] => SELECT name, name_slug, id FROM `makes` WHERE name_slug = "nissan" LIMIT 1;
[3. SELECT | total: 2 ] => 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;
[4. count | total: 1 ] => SELECT COUNT(*) FROM `listings` WHERE status = 1 AND make_id = 94
[5. SELECT | total: 1 ] => SELECT
li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name,
l.idx, l.nice_title, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.thumb, l.created, l.featured, l.body, l.mileage
FROM
`listings_info` AS li
LEFT JOIN `listings` AS l
ON l.id = li.listing_id
WHERE l.status = 1
AND l.make_id = 94
ORDER BY l.featured DESC, l.created DESC
LIMIT 0,30;
[6. select | total: 124 ] => SELECT * FROM `models` WHERE make_id = 94 ORDER BY name;
[7. select | total: 13 ] => SELECT make_name, category_name FROM `listings_info` ORDER BY make_name;
)