Total execution time: 0.021917 sec.
Framework CarDealerPro v2.01
Memory Usage 2.71 MB
POST:
Array
(
)
GET:
Array
(
[url] => listings/
)
Array
(
[_url] => Array
(
[0] => listings
)
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. count |
total: 11 SELECT COUNT(*) AS NUMROWS FROM `listings` WHERE status = 1 AND sold = 0;
3. SELECT |
total: 11 SELECT
li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, l.thumb, l.engine, l.gallery,
l.idx, l.nice_title, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.created, l.mileage, l.body, l.featured
FROM
`listings_info` AS li
LEFT JOIN `listings` AS l
ON l.id = li.listing_id
WHERE l.sold = 0 AND l.status = 1
ORDER BY l.featured DESC, l.created DESC LIMIT 0,12;
4. 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;
Array
(
[1. select | total: 1 ] => SELECT * FROM `settings` WHERE id = 1 ;
[2. count | total: 11 ] => SELECT COUNT(*) AS NUMROWS FROM `listings` WHERE status = 1 AND sold = 0;
[3. SELECT | total: 11 ] => SELECT
li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, l.thumb, l.engine, l.gallery,
l.idx, l.nice_title, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.created, l.mileage, l.body, l.featured
FROM
`listings_info` AS li
LEFT JOIN `listings` AS l
ON l.id = li.listing_id
WHERE l.sold = 0 AND l.status = 1
ORDER BY l.featured DESC, l.created DESC LIMIT 0,12;
[4. 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;
)
