Total execution time: 0.01757 sec.
Framework CarDealerPro v2.01
Memory Usage 2.68 MB
POST:
Array
(
)
GET:
Array
(
[url] => sold/
[pg] => 5
)
Array
(
[_url] => Array
(
[0] => sold
)
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. count |
total: 263 SELECT COUNT(*) FROM `listings` WHERE status = 1 AND sold = 1
3. SELECT |
total: 12 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.status = 1
AND l.sold = 1
ORDER BY l.created DESC LIMIT 48,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: 263 ] => SELECT COUNT(*) FROM `listings` WHERE status = 1 AND sold = 1
[3. SELECT | total: 12 ] => 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.status = 1
AND l.sold = 1
ORDER BY l.created DESC LIMIT 48,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;
)