Profile Information
Application 0.000 seconds (+0.000); 0.25 MB (+0.252) - afterLoad
Application 0.138 seconds (+0.137); 1.39 MB (+1.134) - afterInitialise
Application 0.164 seconds (+0.026); 1.77 MB (+0.381) - afterRoute
Application 0.340 seconds (+0.177); 2.96 MB (+1.195) - afterDispatch
Application 0.379 seconds (+0.038); 3.30 MB (+0.338) - beforeRenderModule mod_custom (Logo)
Application 0.405 seconds (+0.027); 3.43 MB (+0.128) - afterRenderModule mod_custom (Logo)
Application 0.409 seconds (+0.004); 3.43 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.442 seconds (+0.032); 3.55 MB (+0.114) - afterRenderModule mod_menu (Main Menu)
Application 0.442 seconds (+0.000); 3.54 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.454 seconds (+0.012); 3.57 MB (+0.026) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.477 seconds (+0.023); 3.75 MB (+0.181) - beforeRenderModule mod_search (Search)
Application 0.488 seconds (+0.011); 3.78 MB (+0.032) - afterRenderModule mod_search (Search)
Application 0.494 seconds (+0.006); 3.78 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 0.504 seconds (+0.010); 3.80 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 0.505 seconds (+0.000); 3.80 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.514 seconds (+0.009); 3.81 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.527 seconds (+0.013); 3.82 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.535 seconds (+0.008); 3.83 MB (+0.008) - afterRenderModule mod_menu (Links:)
Application 0.535 seconds (+0.000); 3.83 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.546 seconds (+0.011); 3.84 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.546 seconds (+0.000); 3.83 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.555 seconds (+0.009); 3.84 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.556 seconds (+0.000); 3.84 MB (-0.005) - beforeRenderModule mod_jreviews_directories (Directory)
Application 0.799 seconds (+0.243); 5.88 MB (+2.045) - afterRenderModule mod_jreviews_directories (Directory)
Application 0.813 seconds (+0.015); 5.88 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 0.815 seconds (+0.002); 5.89 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 0.825 seconds (+0.010); 5.81 MB (-0.075) - afterRender
Memory Usage
5.84 MB (6,120,568 Bytes)
24 Queries Logged
- SELECT `data`
FROM `jtneb_session`
WHERE `session_id` = '1lqms0vmopb4k5nf4ddc5ivtm7' - SELECT `session_id`
FROM `jtneb_session`
WHERE `session_id` = '1lqms0vmopb4k5nf4ddc5ivtm7'
LIMIT 0, 1 - INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
VALUES ('1lqms0vmopb4k5nf4ddc5ivtm7', 0, 1679446048) - 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 *
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 - 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-22 00:47:28')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-22 00:47:28')
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' - 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:1679446048;s:18:\"session.timer.last\";i:1679446048;s:17:\"session.timer.now\";i:1679446048;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\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}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:\"f556ab4e4213b850a732395433a6d5ad\";}', `time` = 1679446048
WHERE `session_id` = '1lqms0vmopb4k5nf4ddc5ivtm7'
14 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
- 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
- 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 params FROM jtneb_extensions AS e
- 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 * FROM jtneb_languages
- 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.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 `session_id` FROM `jtneb_session`
- 1 × SELECT id, rules FROM `jtneb_viewlevels
- 1 × SELECT folder AS type, element AS name, params FROM jtneb_extensions
- 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
- 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679446048;s:18:\"session.timer.last\";i:1679446048;s:17:\"session.timer.now\";i:1679446048;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\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}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:\"f556ab4e4213b850a732395433a6d5ad\";}', `time` = 1679446048
- 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('1lqms0vmopb4k5nf4ddc5ivtm7', 0, 1679446048
