SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id
FROMv1ej2_usergroupsAS a
LEFTJOINv1ej2_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `v1ej2_viewlevels`
SELECT folder AS type, element AS name, params
FROMv1ej2_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_widgetkit'
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
FROMv1ej2_menuAS m
LEFTJOINv1ej2_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT* FROMv1ej2_languages WHERE published=1
ORDERBY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_menus'
SELECT id, home, template, s.params
FROMv1ej2_template_styles as s
LEFTJOINv1ej2_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 FROMv1ej2_extensionsAS e WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROMv1ej2_extensions WHERE `type` = 'component' AND `element` = 'com_media'
UPDATE `v1ej2_session`
SET `data` = 'nM8KQ60vKfvmyHfO8ei5-Nnq2FMvOOSJ6l9fKlRUKlMHw9M2ziU52v0ALty3Q278fsX5NEIcDnTNSfAE2S0hfAR53VfmPtuVqdqqyHTa2CoyZNYxMnkGs_tj2Xjur_DHIaYJOAydbwNjQZ18BkJ1ccPpFg0wjOoUqNZ84fjOAD8W1xU85DjsVBHTizFpix0EnSZx2T8Lk_l5-KCQXaWbveLhXhIn2JNbhfmenxt4txek8AQxuCKaQklDnrAxfKfO2WkqSFqJOzXYapoxz11SSr6t9MEHgYjvO9O0btMuzdE0AbkHQCLsV0p-Zdgp-_8vvrIx59aaaodzpGpfu9D28J6_UWrp3V1AcF5ML-B5cPwnlPZa4vWRm8q1j-zwh8mOnTsMUZ-itlHN36hWPjqheWp84PErvuuBk3nLB9kW_iRkP7_qJfeqUU5R5zmm_Twnx5BXUkdbgiR8sNnCTBIrabl9w799uvjgG9ddQ2DgkF_Dp69ozuUJuLZAQIco8lYP8mVMU694dERIsmkZUN32qnlSB562rWD2B6hcnY8Dy-sKKJPHU3XgbebhEp_SWFu4aYuK-KWVhUWrt8zn8g0mTLb9mmmTPq7jCpyaTXH4xB0ikzRe_Tc89V8JhNM5RvHELjgZn_ocz90RwJaOapLojxaepDLtK0Rwz3JGSUu9D2ilqWZQnhhUNM4ffUb6GZwt7IG4H4rqPQCZ15P3vwJeoL3PanE5YR1YLm2tvIakqXuhWMcHcENmlnskSde5lm79uqUNyqrTSAtN097AzilTluRM-JFd0Unu7MTm6HymQV5gwL7xvR3FOGBc1LLgSoMQFxqv_r0LwhrJRect-IlXMjeKKHzNR13Jg9sdaty4uYLen4s6ROdkYp8hsBb_ee3rUUJQx83_DlVleuMR5SYqHV_oVsrkdWRoL1S-XGCFMCVrvQmM0cg9I55xPVJ2gjbIA6ymUb3FB_rvZGGAfl_ltiIakALIziyZ7xr0rMDG_nvt_FMecbLj6JWHAmYHHBTfpVia392C6lxXUjcHIUDnTomj5ypyVRkweQGT1TviD8LplB3xYoC9F9EdTwP2W9nsveLsS10sjUVHMMr7stbOYvjc7EQ4dkaKDK_0b6obc6zbaYhwCwaiOy9_Cshj0ruRP4QBAKvTs29pBR-XRG0wzt6K2WTTAFKAWVubl_6JJST_t4EKEPybu2KGc0a1MPrI'
, `time` = '1765038539'
WHERE `session_id` = 's70r472dlvktk8sf9vr31l9l90'
12 zaznamenaných typov dotazov, zotriedené podľa výskytu.
VYBER tabuľku:
6 × SELECT extension_id AS id, element AS "option", params, enabled FROMv1ej2_extensions
1 × SELECT* FROMv1ej2_languages
1 × SELECT id, home, template, s.params FROMv1ej2_template_styles as s LEFTJOINv1ej2_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
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 FROMv1ej2_menuAS m LEFTJOINv1ej2_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT params FROMv1ej2_extensionsAS e
1 × SELECT id, rules FROM `v1ej2_viewlevels
1 × SELECT `session_id` FROM `v1ej2_session`
1 × SELECT b.id FROMv1ej2_usergroupsAS a LEFTJOINv1ej2_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `data` FROM `v1ej2_session`
1 × SELECT folder AS type, element AS name, params FROMv1ej2_extensions