Profile Information
Application 0.000 seconds (+0.000); 0.25 MB (+0.251) - afterLoad
Application 0.142 seconds (+0.141); 1.39 MB (+1.134) - afterInitialise
Application 0.181 seconds (+0.039); 1.83 MB (+0.449) - afterRoute
Application 0.766 seconds (+0.586); 5.80 MB (+3.966) - afterDispatch
Application 0.803 seconds (+0.037); 6.14 MB (+0.338) - beforeRenderModule mod_custom (Logo)
Application 0.811 seconds (+0.007); 6.16 MB (+0.024) - afterRenderModule mod_custom (Logo)
Application 0.815 seconds (+0.004); 6.17 MB (+0.006) - beforeRenderModule mod_menu (Main Menu)
Application 0.835 seconds (+0.020); 6.21 MB (+0.046) - afterRenderModule mod_menu (Main Menu)
Application 0.835 seconds (+0.000); 6.21 MB (-0.005) - beforeRenderModule mod_login (Login || To submit a new listing)
Application 0.850 seconds (+0.015); 6.23 MB (+0.022) - afterRenderModule mod_login (Login || To submit a new listing)
Application 0.874 seconds (+0.024); 6.42 MB (+0.185) - beforeRenderModule mod_search (Search)
Application 0.885 seconds (+0.011); 6.46 MB (+0.041) - afterRenderModule mod_search (Search)
Application 0.891 seconds (+0.006); 6.46 MB (-0.000) - beforeRenderModule mod_menu (Menu)
Application 0.902 seconds (+0.011); 6.48 MB (+0.020) - afterRenderModule mod_menu (Menu)
Application 0.902 seconds (+0.000); 6.47 MB (-0.004) - beforeRenderModule mod_menu (User Menu || Login first)
Application 0.912 seconds (+0.009); 6.49 MB (+0.018) - afterRenderModule mod_menu (User Menu || Login first)
Application 0.925 seconds (+0.013); 6.50 MB (+0.008) - beforeRenderModule mod_menu (Links:)
Application 0.933 seconds (+0.008); 6.51 MB (+0.009) - afterRenderModule mod_menu (Links:)
Application 0.934 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (2))
Application 0.945 seconds (+0.011); 6.51 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (2))
Application 0.945 seconds (+0.000); 6.51 MB (-0.004) - beforeRenderModule mod_menu (Menu Jos (3))
Application 0.954 seconds (+0.009); 6.52 MB (+0.009) - afterRenderModule mod_menu (Menu Jos (3))
Application 0.955 seconds (+0.000); 6.51 MB (-0.006) - beforeRenderModule mod_jreviews_directories (Directory)
Application 1.035 seconds (+0.080); 6.84 MB (+0.328) - afterRenderModule mod_jreviews_directories (Directory)
Application 1.050 seconds (+0.015); 6.84 MB (+0.001) - beforeRenderModule mod_custom (Footer)
Application 1.053 seconds (+0.002); 6.84 MB (+0.005) - afterRenderModule mod_custom (Footer)
Application 1.069 seconds (+0.017); 6.80 MB (-0.048) - afterRender
Memory Usage
6.84 MB (7,173,304 Bytes)
45 Queries Logged
- SELECT `data`
FROM `jtneb_session`
WHERE `session_id` = '30trpf7bb8fmiksjf0i3gs92e1' - DELETE
FROM `jtneb_session`
WHERE `time` < 1679441769 - SELECT `session_id`
FROM `jtneb_session`
WHERE `session_id` = '30trpf7bb8fmiksjf0i3gs92e1'
LIMIT 0, 1 - INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`)
VALUES ('30trpf7bb8fmiksjf0i3gs92e1', 0, 1679442669) - 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_content' - SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM jtneb_categories as c
LEFT JOIN jtneb_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=573
AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft - SELECT alias, catid
FROM jtneb_content
WHERE id = 573 - 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 a.rules
FROM jtneb_assets AS a
WHERE a.id = 1 - SELECT b.rules
FROM jtneb_assets AS a
LEFT JOIN jtneb_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.name = 'com_content'
ORDER BY b.lft - SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
FROM jtneb_content AS a
LEFT JOIN jtneb_categories AS c
on c.id = a.catid
LEFT JOIN jtneb_users AS u
on u.id = a.created_by
LEFT JOIN jtneb_contact_details AS contact
on contact.user_id = a.created_by
LEFT JOIN jtneb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jtneb_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 573
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-21 23:51:09')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-21 23:51:09')
AND (a.state = 1 OR a.state =2) - SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM jtneb_categories as c
LEFT JOIN jtneb_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jtneb_categories AS cat JOIN jtneb_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=18
AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft - SELECT
enabled AS published, params
FROM
jtneb_extensions
WHERE
element = 'jreviews'
AND type = 'plugin'
AND folder = 'content'
LIMIT 1 - SELECT catid
FROM jtneb_content
WHERE id = 573 - SELECT
count(*)
FROM
jtneb_jreviews_categories AS Category
WHERE
Category.option = 'com_content'
AND
Category.id = 18 - SELECT
count(*)
FROM
jtneb_jreviews_categories AS JreviewCategory
WHERE
JreviewCategory.id = 18
AND
JreviewCategory.option = 'com_content'
AND
JreviewCategory.criteriaid > 0 - (SELECT
ParentCategory.id AS `Category.cat_id`,
ParentCategory.lft AS `Category.lft`,
ParentCategory.title AS `Category.title`,
ParentCategory.alias AS `Category.slug`,
ParentCategory.level AS `Category.level`,
ParentCategory.published AS `Category.published`,
ParentCategory.access AS `Category.access`,
ParentCategory.params AS `Category.params`,
ParentCategory.parent_id AS `Category.parent_id`,
ParentCategory.metadesc AS `Category.metadesc`,
ParentCategory.metakey AS `Category.metakey`,
ParentCategory.description AS `Category.description`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
JreviewsCategory.dirid AS `Directory.dir_id`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`
FROM
jtneb_categories AS ParentCategory
INNER JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.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 ListingType.id = JreviewsCategory.criteriaid
WHERE
ParentCategory.id = 18
)
UNION
(SELECT
ParentCategory.id AS `Category.cat_id`,
ParentCategory.lft AS `Category.lft`,
ParentCategory.title AS `Category.title`,
ParentCategory.alias AS `Category.slug`,
ParentCategory.level AS `Category.level`,
ParentCategory.published AS `Category.published`,
ParentCategory.access AS `Category.access`,
ParentCategory.params AS `Category.params`,
ParentCategory.parent_id AS `Category.parent_id`,
ParentCategory.metadesc AS `Category.metadesc`,
ParentCategory.metakey AS `Category.metakey`,
ParentCategory.description AS `Category.description`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
JreviewsCategory.dirid AS `Directory.dir_id`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`
FROM
jtneb_categories AS Category,
jtneb_categories AS ParentCategory
INNER JOIN
jtneb_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = ParentCategory.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 ListingType.id = JreviewsCategory.criteriaid
WHERE
Category.published
AND Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
AND Category.id = 18
AND ParentCategory.parent_id > 0
)
ORDER BY
`Category.lft` - SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Category.alias AS `Category.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.fulltext AS `Listing.description`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.required AS `Criteria.required`,
Criteria.state AS `Criteria.state`,
Criteria.config AS `ListingType.config`,
`Field`.featured AS `Listing.featured`,
Frontpage.content_id AS `Listing.frontpage`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Claim.approved AS `Claim.approved`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`
FROM jtneb_content AS Listing
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN jtneb_categories AS ParentCategory
ON Category.lft BETWEEN ParentCategory.lft
AND ParentCategory.rgt
LEFT JOIN jtneb_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN jtneb_jreviews_content AS Field
ON Field.contentid = Listing.id
LEFT JOIN jtneb_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jtneb_users AS User
ON User.id = Listing.created_by
LEFT JOIN jtneb_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.approved = 1
LEFT JOIN jtneb_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
WHERE 1 = 1
AND (
Listing.id = 573
) - (
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
content_id AS listing_id, count(*) AS favored
FROM jtneb_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (573)
GROUP BY
listing_id - SELECT Review.id AS `Review.review_id`,
Review.pid AS `Review.listing_id`,
Review.mode AS `Review.extension`,
Review.created AS `Review.created`,
Review.modified AS `Review.modified`,
Review.userid AS `User.user_id`,
CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`,
CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`,
Review.email AS `User.email`,
Review.ipaddress AS `User.ipaddress`,
Rank.rank AS `User.review_rank`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
Review.posts AS `Review.posts`,
Review.author AS `Review.editor`,
Review.published AS `Review.published`,
Rating.ratings AS `Rating.ratings`,
(Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
Review.vote_helpful AS `Vote.yes`,
(Review.vote_total - Review.vote_helpful) AS `Vote.no`,
(Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
Review.owner_reply_text AS `Review.owner_reply_text`,
Review.owner_reply_approved AS `Review.owner_reply_approved`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.state AS `Criteria.state`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`
FROM jtneb_jreviews_comments AS Review
LEFT JOIN jtneb_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jtneb_users AS User
ON Review.userid = User.id
LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
ON Review.userid = Rank.user_id
LEFT JOIN jtneb_content AS Listing
ON Review.pid = Listing.id
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON Category.id = JreviewsCategory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid = 573
AND Review.author = 1
AND Review.published = 1
)
ORDER BY `Review.created` DESC
LIMIT 10 - SELECT COUNT(*)
FROM jtneb_jreviews_comments AS Review
LEFT JOIN jtneb_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jtneb_users AS User
ON Review.userid = User.id
LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
ON Review.userid = Rank.user_id
LEFT JOIN jtneb_content AS Listing
ON Review.pid = Listing.id
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON Category.id = JreviewsCategory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid = 573
AND Review.author = 1
AND Review.published = 1
) - SELECT Review.id AS `Review.review_id`,
Review.pid AS `Review.listing_id`,
Review.mode AS `Review.extension`,
Review.created AS `Review.created`,
Review.modified AS `Review.modified`,
Review.userid AS `User.user_id`,
CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`,
CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`,
Review.email AS `User.email`,
Review.ipaddress AS `User.ipaddress`,
Rank.rank AS `User.review_rank`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
Review.posts AS `Review.posts`,
Review.author AS `Review.editor`,
Review.published AS `Review.published`,
Rating.ratings AS `Rating.ratings`,
(Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
Review.vote_helpful AS `Vote.yes`,
(Review.vote_total - Review.vote_helpful) AS `Vote.no`,
(Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
Review.owner_reply_text AS `Review.owner_reply_text`,
Review.owner_reply_approved AS `Review.owner_reply_approved`,
Review.owner_reply_approved As `Review.owner_reply_approved`,
Review.owner_reply_text As `Review.owner_reply_text`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.state AS `Criteria.state`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`
FROM jtneb_jreviews_comments AS Review
LEFT JOIN jtneb_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jtneb_users AS User
ON Review.userid = User.id
LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
ON Review.userid = Rank.user_id
LEFT JOIN jtneb_content AS Listing
ON Review.pid = Listing.id
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON Category.id = JreviewsCategory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid= 573
AND Review.author = 0
AND Review.published = 1
AND Review.mode = 'com_content'
AND JreviewsCategory.`option` = 'com_content'
)
ORDER BY `Review.created` DESC
LIMIT 5 - SELECT COUNT(*)
FROM jtneb_jreviews_comments AS Review
LEFT JOIN jtneb_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jtneb_users AS User
ON Review.userid = User.id
LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
ON Review.userid = Rank.user_id
LEFT JOIN jtneb_content AS Listing
ON Review.pid = Listing.id
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON Category.id = JreviewsCategory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid= 573
AND Review.author = 0
AND Review.published = 1
AND Review.mode = 'com_content'
AND JreviewsCategory.`option` = 'com_content'
) - SELECT COUNT(*)
FROM jtneb_jreviews_comments AS Review
LEFT JOIN jtneb_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jtneb_users AS User
ON Review.userid = User.id
LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank
ON Review.userid = Rank.user_id
LEFT JOIN jtneb_content AS Listing
ON Review.pid = Listing.id
INNER JOIN jtneb_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jtneb_categories AS Category
ON Category.id = JreviewsCategory.id
LEFT JOIN jtneb_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid = 573
AND Review.ipaddress = '34.232.62.64'
AND Review.mode = 'com_content'
AND Review.author = 0
AND Review.published >= 0
) - UPDATE jtneb_content
SET hits = hits + 1
WHERE id = 573 - 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 23:51:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 23:51:09')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 175 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering - SELECT alias, catid
FROM jtneb_content
WHERE id = 573 - 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 = 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:1679442669;s:18:\"session.timer.last\";i:1679442669;s:17:\"session.timer.now\";i:1679442669;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\":25:{s:9:\"\0*\0isRoot\";b:0;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\";a:1:{i:0;s:1:\"1\";}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:16:\"duplicate_review\";b:0;}s:13:\"session.token\";s:32:\"b3481abeb4b112155e52fec73ac55586\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"a1ab4e9991afc08d756e52906bba71e9\";s:1:\"0\";s:32:\"6365eba9d73d874137205cba4e252315\";s:1:\"1\";s:32:\"f57f015814218871b8b6222c9b945037\";s:1:\"0\";}}', `time` = 1679442670
WHERE `session_id` = '30trpf7bb8fmiksjf0i3gs92e1'
31 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
- 5 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jtneb_extensions
- 3 × SELECT COUNT(*) FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
- 2 × SELECT alias, catid FROM jtneb_content
- 2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jtneb_categories as c LEFT JOIN jtneb_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
- 1 × SELECT content_id AS listing_id, count(*) AS favored FROM jtneb_jreviews_favorites AS Favorite
- 1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips` FROM jtneb_content AS Listing INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jtneb_categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt LEFT JOIN jtneb_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jtneb_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN jtneb_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jtneb_users AS User ON User.id = Listing.created_by LEFT JOIN jtneb_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jtneb_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id
- 1 × SELECT count(*) FROM jtneb_jreviews_categories AS JreviewCategory
- 1 × SELECT
count(*)
FROM
jtneb_jreviews_categories AS Category
- 1 × SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
- 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 Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.state AS `Criteria.state`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights` FROM jtneb_jreviews_comments AS Review LEFT JOIN jtneb_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jtneb_users AS User ON Review.userid = User.id LEFT JOIN jtneb_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN jtneb_content AS Listing ON Review.pid = Listing.id INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jtneb_categories AS Category ON Category.id = JreviewsCategory.id LEFT JOIN jtneb_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id
- 1 × SELECT catid FROM jtneb_content
- 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 params FROM jtneb_extensions AS e
- 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jtneb_content AS a LEFT JOIN jtneb_categories AS c on c.id = a.catid LEFT JOIN jtneb_users AS u on u.id = a.created_by LEFT JOIN jtneb_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jtneb_categories as parent ON parent.id = c.parent_id LEFT JOIN jtneb_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jtneb_categories AS cat JOIN jtneb_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
- 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 folder AS type, element AS name, params FROM jtneb_extensions
- 1 × SELECT id, rules FROM `jtneb_viewlevels
- 1 × SELECT `session_id` FROM `jtneb_session`
- 1 × SELECT * FROM jtneb_languages
- 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 `data` FROM `jtneb_session`
- 1 × SELECT b.rules FROM jtneb_assets AS a LEFT JOIN jtneb_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
- 1 × SELECT a.rules FROM jtneb_assets AS a
- 1 × SELECT
enabled AS published, params
FROM
jtneb_extensions
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_content SET hits = hits + 1
- 1 × UPDATE `jtneb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1679442669;s:18:\"session.timer.last\";i:1679442669;s:17:\"session.timer.now\";i:1679442669;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\":25:{s:9:\"\0*\0isRoot\";b:0;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\";a:1:{i:0;s:1:\"1\";}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:16:\"duplicate_review\";b:0;}s:13:\"session.token\";s:32:\"b3481abeb4b112155e52fec73ac55586\";}__findCount|a:1:{s:6:\"Review\";a:3:{s:32:\"a1ab4e9991afc08d756e52906bba71e9\";s:1:\"0\";s:32:\"6365eba9d73d874137205cba4e252315\";s:1:\"1\";s:32:\"f57f015814218871b8b6222c9b945037\";s:1:\"0\";}}', `time` = 1679442670
- 1 × (SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, ParentCategory.alias AS `Category.slug`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, ParentCategory.description AS `Category.description`, JreviewsCategory.criteriaid AS `Category.criteria_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.title AS `Directory.slug`, ListingType.config AS `ListingType.config` FROM jtneb_categories AS ParentCategory INNER JOIN jtneb_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.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 ListingType.id = JreviewsCategory.criteriaid
- 1 × INSERT INTO `jtneb_session` (`session_id`, `client_id`, `time`) VALUES ('30trpf7bb8fmiksjf0i3gs92e1', 0, 1679442669
- 1 × DELETE FROM `jtneb_session`
Hot