Profile Information
Application 0.001 seconds (+0.001); 0.25 MB (+0.252) - afterLoad
Application 0.143 seconds (+0.142); 1.39 MB (+1.134) - afterInitialise
Application 0.178 seconds (+0.035); 1.82 MB (+0.430) - afterRoute
Application 0.498 seconds (+0.320); 4.58 MB (+2.763) - afterDispatch
Application 0.561 seconds (+0.063); 5.13 MB (+0.546) - beforeRenderModule mod_custom (Logo)
Application 0.587 seconds (+0.026); 5.26 MB (+0.131) - afterRenderModule mod_custom (Logo)
Application 0.591 seconds (+0.004); 5.26 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.615 seconds (+0.024); 5.33 MB (+0.065) - afterRenderModule mod_menu (Main Menu)
Application 0.615 seconds (+0.000); 5.32 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.636 seconds (+0.021); 5.38 MB (+0.054) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.659 seconds (+0.023); 5.56 MB (+0.181) - beforeRenderModule mod_search (Search)
Application 0.669 seconds (+0.010); 5.59 MB (+0.032) - afterRenderModule mod_search (Search)
Application 0.675 seconds (+0.006); 5.59 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 0.685 seconds (+0.010); 5.61 MB (+0.019) - afterRenderModule mod_menu (Menu)
Application 0.686 seconds (+0.000); 5.60 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.694 seconds (+0.009); 5.62 MB (+0.017) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.707 seconds (+0.013); 5.63 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.715 seconds (+0.008); 5.64 MB (+0.008) - afterRenderModule mod_menu (Links:)
Application 0.715 seconds (+0.000); 5.63 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.725 seconds (+0.010); 5.64 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.725 seconds (+0.000); 5.64 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.734 seconds (+0.009); 5.65 MB (+0.008) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.735 seconds (+0.000); 5.64 MB (-0.005) - beforeRenderModule mod_jreviews_directories (Directory)
Application 0.833 seconds (+0.098); 6.09 MB (+0.453) - afterRenderModule mod_jreviews_directories (Directory)
Application 0.847 seconds (+0.014); 6.10 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 0.849 seconds (+0.002); 6.10 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 0.862 seconds (+0.014); 6.04 MB (-0.061) - afterRender
Memory Usage
6.08 MB (6,375,448 Bytes)
35 Queries Logged
- SELECT `data`
FROM `jtneb_session`
WHERE `session_id` = '2hp0alnlvak7r0si57d7s1sk04' - DELETE
FROM `jtneb_session`
WHERE `time` < 1679438559 - SELECT `session_id`
FROM `jtneb_session`
WHERE `session_id` = '2hp0alnlvak7r0si57d7s1sk04'
LIMIT 0, 1 - INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
VALUES ('2hp0alnlvak7r0si57d7s1sk04', 0, 1679439459) - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_users' - SELECT id, rules
FROM `jtneb_viewlevels` - SELECT folder AS type, element AS name, params
FROM jtneb_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages' - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit' - SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jtneb_menu AS m
LEFT JOIN jtneb_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_jreviews' - SELECT *
FROM jtneb_languages
WHERE published=1
ORDER BY ordering ASC - SELECT id, home, template, s.params
FROM jtneb_template_styles as s
LEFT JOIN jtneb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1 - UPDATE
jtneb_jreviews_config
SET
value= '1679439460'
WHERE
id = 'last_cache_clean' - SELECT
count(*)
FROM
jtneb_jreviews_config
WHERE
id = 'last_cache_clean' - SELECT id, value
FROM jtneb_jreviews_config - SELECT COUNT(*)
FROM jtneb_jreviews_reviewer_ranks - SELECT
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
Rank.reviews AS `Review.count`,
Rank.votes_percent_helpful AS `Vote.helpful`,
Rank.votes_total AS `Vote.count`
FROM
jtneb_users AS User
INNER JOIN
jtneb_jreviews_reviewer_ranks AS Rank
ON Rank.user_id = User.id
ORDER BY
Rank.rank
LIMIT
0, 10 - SELECT
id,
title AS name,
alias AS alias,
link AS menu_type,
link,
component_id AS componentid,
params,
access,
published,
language
FROM jtneb_menu
WHERE published = 1
ORDER BY link DESC - SELECT params
FROM jtneb_extensions AS e
WHERE e.element='com_widgetkit' - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_media' - SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jtneb_modules AS m
LEFT JOIN jtneb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jtneb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-21 22:57:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 22:57:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering - SELECT extension_id AS "id", element AS "option", params, enabled
FROM jtneb_extensions
WHERE `type` = 'component'
AND `element` = 'com_content' - UPDATE
jtneb_jreviews_config
SET
value= '1679439460'
WHERE
id = 'last_cache_clean' - SELECT
count(*)
FROM
jtneb_jreviews_config
WHERE
id = 'last_cache_clean' - SELECT id, value
FROM jtneb_jreviews_config - SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.level AS `Category.level`,
Category.params AS `Category.params`,
Category.parent_id AS `Category.parent_id`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`,
COUNT(Listing.id) AS `Category.listing_count`
FROM jtneb_categories AS Category
LEFT JOIN jtneb_categories AS ParentCategory
ON Category.lft <= ParentCategory.lft
AND Category.rgt >= ParentCategory.rgt
LEFT JOIN jtneb_content AS Listing
ON ParentCategory.id = Listing.catid
AND Listing.state = 1
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
AND JreviewsCategory.option = "com_content"
LEFT JOIN jtneb_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jtneb_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
WHERE 1 = 1
AND (
Category.published = 1
AND ParentCategory.access IN ( 1,1 )
AND Category.extension = "com_content"
AND Category.level <= 2
)
GROUP BY Category.id
ORDER BY Directory.desc,Category.lft - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 16
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 16
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 18
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 18
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 19
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 19
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 20
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 20
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 17
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 17
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 21
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 21
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - (
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
ParentCategory.id = 22
AND ParentCategory.published = 1
)
)
UNION
(
SELECT
ParentCategory.id AS cat_id,
ParentCategory.lft AS lft
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
LEFT JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.id
WHERE
(
Category.published = 1
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 22
AND ParentCategory.parent_id > 0
)
GROUP BY
ParentCategory.id
ORDER BY
ParentCategory.lft
) - UPDATE `jtneb_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679439459;s:18:\"session.timer.last\";i:1679439459;s:17:\"session.timer.now\";i:1679439459;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"643e9d9435fa46674cea3c2e670ef9ab\";}', `time` = 1679439460
WHERE `session_id` = '2hp0alnlvak7r0si57d7s1sk04'
21 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
- 6 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
- 2 × SELECT count(*) FROM jtneb_jreviews_config
- 2 × SELECT id, value FROM jtneb_jreviews_confi
- 1 × SELECT User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, Rank.reviews AS `Review.count`, Rank.votes_percent_helpful AS `Vote.helpful`, Rank.votes_total AS `Vote.count` FROM jtneb_users AS User INNER JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Rank.user_id = User.id
- 1 × SELECT COUNT(*) FROM jtneb_jreviews_reviewer_rank
- 1 × SELECT params FROM jtneb_extensions AS e
- 1 × SELECT STRAIGHT_JOIN Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config`, COUNT(Listing.id) AS `Category.listing_count` FROM jtneb_categories AS Category LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft <= ParentCategory.lft AND Category.rgt >= ParentCategory.rgt LEFT JOIN jtneb_content AS Listing ON ParentCategory.id = Listing.catid AND Listing.state = 1 INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id
- 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jtneb_modules AS m LEFT JOIN jtneb_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jtneb_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
- 1 × SELECT id, title AS name, alias AS alias, link AS menu_type, link, component_id AS componentid, params, access, published, language FROM jtneb_menu
- 1 × SELECT id, home, template, s.params FROM jtneb_template_styles as s LEFT JOIN jtneb_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
- 1 × SELECT id, rules FROM `jtneb_viewlevels
- 1 × SELECT `session_id` FROM `jtneb_session`
- 1 × SELECT folder AS type, element AS name, params FROM jtneb_extensions
- 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jtneb_menu AS m LEFT JOIN jtneb_extensions AS e ON m.component_id = e.extension_id
- 1 × SELECT * FROM jtneb_languages
- 1 × SELECT `data` FROM `jtneb_session`
OTHER Tables:
- 7 × ( SELECT ParentCategory.id AS cat_id, ParentCategory.lft AS lft FROM jtneb_categories AS Category, jtneb_categories AS ParentCategory LEFT JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id
- 2 × UPDATE jtneb_jreviews_config SET value= '1679439460'
- 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679439459;s:18:\"session.timer.last\";i:1679439459;s:17:\"session.timer.now\";i:1679439459;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:9:\"group_ids\";s:0:\"\";}s:13:\"session.token\";s:32:\"643e9d9435fa46674cea3c2e670ef9ab\";}', `time` = 1679439460
- 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('2hp0alnlvak7r0si57d7s1sk04', 0, 1679439459
- 1 × DELETE FROM `jtneb_session`
