Listing Sitemap

Total execution time: 1772703980.7029 sec.

Framework 1.50 v3.00

Cpu Usage 50606 sec.

Memory Usage 715.56kB

POST:
Array
(
)

                         
GET:
Array
(
)

                         
Array
(
    [segment] => Array
        (
            [0] => sitemap
        )

    [route] => /sitemap
    [template] => front/themes/master/sitemap.tpl.php
)

1. select | total: 1
SELECT * FROM `settings` WHERE (`id` = 1) ;

2. select | total: 7
SELECT slug, idx, nice_title FROM `listings` WHERE (`status` = 1) ORDER BY `created` DESC;

3. SELECT | total: 2
SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;

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, li.make_slug, li.category_slug, li.fuel_name, li.make_name, li.feature_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 = 9783298 AND l.slug = "2019-ford-f-150" ;
3. SELECT | total: 0. SELECT * FROM `stats` WHERE DATE(created) = "2026-03-05" AND listing_id = 10 LIMIT 1;
4. insert | total: 1. INSERT INTO `stats` (`created`,`visits`,`listing_id`) VALUES ("2026-03-05 03:46:20",1,10);
5. UPDATE | total: 1. UPDATE listings SET hits = hits+1 WHERE id = 10;
6. SELECT | total: 2.  SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;
2. select | total: 7. SELECT slug, idx, nice_title FROM `listings` WHERE (`status` = 1) ORDER BY `created` DESC;
3. SELECT | total: 2.  SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;