YOURLS: Your Own URL Shortener

Sleeky theme for YOURLS

Short URL: https://short.ilg-spedition.de/6

Long URL: https://short.ilg-spedition.de/

SQL fetchPairs: SELECT option_name, option_value FROM yourls_options WHERE 1=1 (0.00033 s)
loaded /var/www/vhosts/ilg-spedition.de/subs/short/user/plugins/device-detail/plugin.php
loaded /var/www/vhosts/ilg-spedition.de/subs/short/user/plugins/hyphens-in-urls/plugin.php
loaded /var/www/vhosts/ilg-spedition.de/subs/short/user/plugins/uikit-skin/plugin.php
loaded /var/www/vhosts/ilg-spedition.de/subs/short/user/plugins/databaseusers/plugin.php
Check for new version: no
SQL fetchOne: SELECT option_value FROM yourls_options WHERE option_name = 'core_version_checks' LIMIT 1 (0.00024 s)
SQL fetchObject: SELECT * FROM `yourls_url` WHERE `keyword` = '6' (0.00018 s)
SQL fetchObjects: SELECT `referrer`, COUNT(*) AS `count` FROM `yourls_log` WHERE `shorturl` = '6' GROUP BY `referrer`; (0.00027 s)
SQL fetchObjects: SELECT `country_code`, COUNT(*) AS `count` FROM `yourls_log` WHERE `shorturl` = '6' GROUP BY `country_code`; (0.00022 s)
SQL fetchObjects: SELECT
        DATE_FORMAT(`click_time`, '%Y') AS `year`,
        DATE_FORMAT(`click_time`, '%m') AS `month`,
        DATE_FORMAT(`click_time`, '%d') AS `day`,
        COUNT(*) AS `count`
    FROM `yourls_log`
    WHERE `shorturl` = '6'
    GROUP BY `year`, `month`, `day`; (0.00024 s)
SQL fetchObjects: SELECT
        DATE_FORMAT(DATE_ADD(`click_time`, INTERVAL 0 HOUR), '%H %p') AS `time`,
        COUNT(*) AS `count`
    FROM `yourls_log`
    WHERE `shorturl` = '6' AND DATE_ADD(`click_time`, INTERVAL 0 HOUR) > (DATE_ADD(CURRENT_TIMESTAMP, INTERVAL 0 HOUR) - INTERVAL 1 DAY)
    GROUP BY `time`; (0.00031 s)
SQL fetchObjects: SELECT * FROM `yourls_log` WHERE shorturl = '6' ORDER BY click_id DESC LIMIT 1000 (0.00024 s)