Marie Tidqvist Lundin, Bloggare v.8
Bloggare v.8
Marie Tidqvist Lundin
Göteborg
|
"Mitt ledord när jag skapar är – bara gör! Som ett försök att släppa prestationen över att allt ska bli snyggt och perfekt. Det leder till projekt i alla möjliga material som jag vanligtvis visar på min blogg just go creative.
Det prestationslösa skapandet ger mig inspiration i mitt arbete som grafisk formgivare och också när jag som aktiveringspedagog är kursledare för personer med funktionsnedsättningar.
Just nu är jag mammaledig och försöker få tid över till att få skapa - en utmaning har det visat sig!"
www.justgocreative.blogspot.se
www.formkontakt.se
|
Joomlas felsökningskonsoll
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
4.41 MB (4,629,200 Bytes)
32 loggade SQL-frågor
SELECT `data`
FROM `AqD_session`
WHERE `session_id` = '7f845a762569f49df3aa585ff271ede5'
SELECT `session_id`
FROM `AqD_session`
WHERE `session_id` = '7f845a762569f49df3aa585ff271ede5'
LIMIT 0, 1
INSERT INTO `AqD_session`
(`session_id`, `client_id`, `time`)
VALUES
('7f845a762569f49df3aa585ff271ede5', 0, '1660757302')
SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM AqD_usergroups AS a
LEFT JOIN AqD_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `AqD_viewlevels`
SELECT folder AS type, element AS name, params
FROM AqD_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 AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'
SELECT *
FROM AqD_languages
WHERE published=1
ORDER BY ordering ASC
SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 AqD_menu AS m
LEFT JOIN AqD_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 `alias`,`newurl`
from `AqD_sh404sef_aliases`
where `alias` = 'https://kravallslojd.sePresentation-av-bloggare/marie-tidqvist-lundin-bloggare-v8/Print.html' or `alias` = 'Presentation-av-bloggare/marie-tidqvist-lundin-bloggare-v8/Print.html' or `alias` = 'Presentation-av-bloggare/marie-tidqvist-lundin-bloggare-v8/Print.html/'
order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd`
FROM AqD_sh404sef_urls
WHERE `oldurl`='Presentation-av-bloggare/marie-tidqvist-lundin-bloggare-v8/Print.html'
ORDER BY `rank`;
SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_snippets'
SELECT a.*
FROM `AqD_snippets` AS a
WHERE ( a.published IN ( 0,1,2 ) )
ORDER BY a.ordering asc
SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id, home, template, s.params
FROM AqD_template_styles as s
LEFT JOIN AqD_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 AqD_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM AqD_assets AS a
LEFT JOIN AqD_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
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,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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,(
SELECT MAX(contact.id) AS id
FROM AqD_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) 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, 0) AS rating, v.rating_count as rating_count
FROM AqD_content AS a
LEFT JOIN AqD_categories AS c
on c.id = a.catid
LEFT JOIN AqD_users AS u
on u.id = a.created_by
LEFT JOIN AqD_categories as parent
ON parent.id = c.parent_id
LEFT JOIN AqD_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM AqD_categories AS cat JOIN AqD_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 = 1456
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-17 17:28:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-17 17:28:22')
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 AqD_categories as c
LEFT JOIN AqD_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 AqD_categories AS cat JOIN AqD_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=111
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
UPDATE AqD_content
SET hits = hits + 1
WHERE id = 1456
SELECT params
FROM AqD_extensions AS e
WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
SELECT `oldurl`, `dateadd`
FROM AqD_sh404sef_urls
WHERE `newurl`='index.php?option=com_widgetkit&format=raw&id=&lang=sv';
SELECT `pageid`
FROM AqD_sh404sef_pageids
WHERE `newurl`='index.php?option=com_content&Itemid=100038&catid=111&id=1456&lang=sv&layout=default&page=&print=1&tmpl=component&view=article';
SELECT `id`, `title`, `alias`, `catid`, `language`
FROM AqD_content
WHERE `id`=1456;
SELECT *
FROM AqD_categories
WHERE parent_id > 0
and extension = 'com_content'
and path = 'uncategorised'
and level = 1;
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM AqD_categories as c
LEFT JOIN AqD_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 AqD_categories AS cat JOIN AqD_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 s.id=111
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SHOW FULL COLUMNS
FROM `AqD_sh404sef_metas`
SELECT *
FROM AqD_sh404sef_metas
WHERE `newurl`='index.php?option=com_content&Itemid=100038&catid=111&id=1456&lang=sv&layout=default&page=&print=1&tmpl=component&view=article';
UPDATE `AqD_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1660757302;s:18:\"session.timer.last\";i:1660757302;s:17:\"session.timer.now\";i:1660757302;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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;i: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;}}'
, `time` = '1660757303'
WHERE `session_id` = '7f845a762569f49df3aa585ff271ede5'
26 Loggade frågetyper. Sorterade efter förekomst
SELECT Tabeller:
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM AqD_extensions
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM AqD_categories as c
LEFT JOIN AqD_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 AqD_categories AS cat JOIN AqD_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT params
FROM AqD_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,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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,( SELECT MAX(contact.id) AS id
FROM AqD_contact_details AS contact
1 × SELECT `oldurl`, `dateadd`
FROM AqD_sh404sef_urls
1 × SELECT b.rules
FROM AqD_assets AS a
LEFT JOIN AqD_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `pageid`
FROM AqD_sh404sef_pageids
1 × SELECT *
FROM AqD_sh404sef_metas
1 × SELECT *
FROM AqD_categories
1 × SELECT `id`, `title`, `alias`, `catid`, `language`
FROM AqD_content
1 × SELECT a.rules
FROM AqD_assets AS a
1 × SELECT a.*
FROM `AqD_snippets` AS a
1 × SELECT folder AS type, element AS name, params
FROM AqD_extensions
1 × SELECT id, rules
FROM `AqD_viewlevels
1 × SELECT b.id
FROM AqD_usergroups AS a
LEFT JOIN AqD_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `AqD_session`
1 × SELECT *
FROM AqD_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 AqD_menu AS m
LEFT JOIN AqD_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `AqD_session`
1 × SELECT `oldurl`, `newurl`, `dateadd`
FROM AqD_sh404sef_urls
1 × select `alias`,`newurl`
from `AqD_sh404sef_aliases`
1 × SELECT id, home, template, s.params
FROM AqD_template_styles as s
LEFT JOIN AqD_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
OTHER Tabeller:
1 × UPDATE `AqD_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1660757302;s:18:\"session.timer.last\";i:1660757302;s:17:\"session.timer.now\";i:1660757302;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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;i: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;}}' , `time` = '1660757303'
1 × SHOW FULL COLUMNS
FROM `AqD_sh404sef_metas
1 × UPDATE AqD_content
SET hits = hits + 1
1 × INSERT INTO `AqD_session` (`session_id`, `client_id`, `time`)
VALUES ('7f845a762569f49df3aa585ff271ede5', 0, '1660757302'