NEES: CENSEIS: Centrifuge and Full-scale Modeling of Seismic Pore Pressures in Sands

By Tarek Abdoun, Waleed El-Sekelly, Ricardo Dobry, Sabanayagam Thevanayagam and Marcelo Gonzalez

View Data

Licensed under

Category

Databases

Published on

Abstract

Authors

The authors of this database are Tarek Abdoun (Rensselaer Polytechnic Institute), Waleed El-Sekelly (Rensselaer Polytechnic Institute), Ricardo Dobry (Rensselaer Polytechnic Institute), Sabanayagam Thevanayagam (University at Buffalo) and Marcelo Gonzalez (Corporacion del Cobre ). The database was published at NEEShub on January 30 2015 and has been reproduced here to preserve the data and ensure continued access.

Note: The NEEShub links in this database now point to warehouse project locations at DesignSafe where available. Column links for Sensor Description and Setup and Instrumentation point to the appropriate warehouse project at DesignSafe. Columns links for Soil Description and Grain Size Distribution can no longer be resolved.


Database Abstract

doi: 10.4231/D3GF0MX4F

Centrifuge and full-scale testing in geotechnical Engineering are very useful tools in modeling soil behavior under different loading conditions, particularly under earthquake loading. The database contains results of nine full-scale and centrifuge liquefaction experiments performed both at the geoctechnical centrifuge testing facility at Rensselaer Polytechnic Institute (RPI) and the full-scale testing facility at the University at Buffalo (UB). The database was generated using the online DataStore tool under the name CENSEIS: Centrifuge and full-scale Modeling of Seismic Pore Pressures in Sands

Database organization

The database is in the form of a table in which each row corresponds to an experiment. The database is composed of nine centrifuge and full-scale experiments. The columns of the database table provide detailed information about the characteristics of each experiment as follows:

  • Column A represents the test name as reported by the corresponding reference in column E. In this column, FF stands for Free Field, PF for Pile Foundation, V for Viscous fluid and P for water. The last two experiments are full-scale experiments in which LG stands for Level Ground and SG stands for Sloping Ground.
  • Column B represents the type of the experiment, C stands for Centrifuge and F for Full-scale.
  • Column C is the location of the testing facility. All centrifuge experiments in this database were performed at Rensselaer Polytechnic Institute (RPI). The full-scale experiments were performed at University at Buffalo (UB).
  • Column D is the year in which the experiment was performed.
  • Column E is the reference that include all the detailed procedures and analysis of the corresponding experiments.
  • Column F is the container that was used in the experiments. It has to be noted that all the centrifuge experiments were performed in the laminar container and the two full-scale experiments were performed in the full-scale laminar container, explained previously in the paper.
  • Column G indicates the presence of pile foundation in the experiments. Y stands for Yes and N stands for No.
  • Column H indicates the corrected inclination of the container in degrees. It has to be noted that several corrections needed to be applied to achieve these values of prototype inclination. Details about the corrections can be found in Gonzalez (2008).
  • Column I is a link to the schematic diagram of the set up and instrumentation of the each model.
  • Column J is a link to the detailed description of each sensor in each experiment. This includes, but not limited to, the type of the sensor, the units and the calibration factors. It has to be noted that the calibration factors are already applied to the data, so the user can use the data without the need to do a correction for calibration.
  • Column K is the actual model depth. It has to be noted that the prototype depth of all the centrifuge experiments was about 6.0 m (0.24 m * 25 g = 6 m, where g is the gravitational g level indicated in column L), which is about the same depth of the full-scale model.
  • Column L is the gravitational acceleration of the centrifuge model in (g)s. It must be noted that all the centrifuge experiments were performed at 25 g. For the full scale experiment, the g-level is the conventional field 1g gravitational acceleration.
  • Column M is the soil deposition method in the model. All the centrifuge experiment models were deposited by dry pluviation, while the full-scale model were deposited by hydraulically filling.
  • Column N is the overall relative density of the model, estimated using the standard techniques used in the centrifuge and full scale laboratory.  For the centrifuge models, careful weighing of the box with and without the dry soil is used to determine the average density and void ratio. For the full scale models, the soil density was determined by placing several steel buckets (15 cm in diameter and 15 cm in height) in the laminar container, and allowing them to be filled during the construction of the deposit, and then pulling them out for conventional density testing. The relative density is confirmed using cone penetration testing after the model is fully constructed.
  • Column O is the average normalized shear wave velocity estimated using an established System Identification (SI) technique of the weak shakings conducted specifically for this purpose at the beginning of the experiment, see Elgamal et al. (1995, 1996) and Zeghal et al. (1995). These values were adopted from Abdoun et al. (2013). 
  • Column P, Q, and R describe the soil used in each experiment. Two types of soils were used in the experiments; Ottawa F55 sand, and scaled sand.
  • Column S is the saturation fluid used in each experiment. As previously explained, all the experiments had about the same prototype permeability. In order to achieve that, centrifuge experiments on Ottawa F55 sand were saturated with viscous fluid, while centrifuge experiments on scaled sand were saturated with water. The two full-scale experiments were both saturated with water resulting in the same permeability of the centrifuge experiments.
  • Column T is the type of the base motion shaking. In all the cases the base motions were approximately sinusoidal. Typically, the base motion was composed of 15-30 sinusoidal cycles with increasing amplitude with time. The actual base motion applied in each experiment can be extracted from the accelerometer recording at the base of each model from the data file in column U.
  • Column U is a link to the data file of each experiment. Typically the data file is composed of several columns. The first column is always the time, which typically uniformly increase with a constant time step that was set by the experimentalist. The rest of the columns are the readings of each individual calibrated sensor, in the list of sensors in column J. These recordings can be used to generate acceleration, pore pressure or deformation time histories at several locations of the model. It has to be noted that the centrifuge results need to be corrected for g-level using the appropriate conventional centrifuge modeling scaling laws.

References

Abdoun, T., Dobry, R., O'Rourke, T., and Goh, S. (2003). “Pile response to lateral spreads: Centrifuge modeling,” J. Geotech. and Geoenviron. Eng., 129(10), 869-878

Abdoun, T., Gonzalez, M. A., Thevanayagam, S., Dobry, R., Elgamal, A., Zeghal, M., Mercado, V. M., and El Shamy, U. (2013). “Centrifuge and Large Scale Modeling of Seismic Pore Pressures in Sands: a Cyclic Strain Interpretation.” J. of Geotech. and Geoenvir. Engng., 139(8),  1215-1234.

Andrus, R. D., and Stokoe II, K. H. (2000). “Liquefaction Resistance of Soils from Shear-Wave Velocity,” J. of Geotech. and Geoenvir. Engng., 126(11), 1015-1025.

Dobry, R. and Abdoun, T. (2011). “An Investigation Into Why Liquefaction Charts Work: A Necessary Step Toward Integrating the States of Art And Practice, Ishihara Lecture.” Proc., the 5th Int. Conf. on Earthquake Geotechnical Engng., Santiago, Chile, Jan. 10-13, 13-44.

Dobry, R., Abdoun, T., Thevanayagam, S., El-Ganainy, H., and Mercado, V. (2013). “Case Histories in Loose Sand Fills During the 1989 Loma Prieta Earthquake: Comparison with Large Scale and Centrifuge Shaking Tests,” Proc., the 7th Int. Conf. on Case Histories in Geotechnical Engng. (S. Prakash, ed.), April 29-May 4, Chicago, IL, Paper No. 4.15a, 1-4.

Dobry, R.,Abdoun, T.,Stokoe, K.H. II, Moss, R.E.S., Hatton, M., and El Ganainy, H. (2014). “Liquefaction Potential of Recent Fills versus Natural Sands Located in High Seismicity Regions Using Shear Wave Velocity,” J. of Geotech. and Geoenvir. Engng., in press.

Elgamal, A. W., Zeghal, M., Tang, H. T., and Stepp, J. C. (1995). “Lotung Downhole Array. I: Evaluation of Site Dynamic Properties.” J. of Geotech. and Geoenvir. Engng., 121(4), 350-362.

Elgamal, A.-W., Zeghal., M., Taboada, V., and Dobry, R. (1996). “Analysis of Site Liquefaction and Lateral Spreading Using Centrifuge Testing Records.” Soils and Found., 36(2), 111-121.

Gonzalez, L. (2005). “Centrifuge modeling of permeability and pinning reinforcement effects on pile response to lateral spreading.”  PhD Thesis, Rensselaer Polytechnic Institute. Troy, NY.

Gonzalez, M.A. (2008). “Centrifuge Modeling of Pile Foundation Response to Liquefaction and Lateral Spreading: Study of Sand Permeability and Compressibility Effects Using Scaled Sand Techniques.” PhD Thesis, Rensselaer Polytechnic Institute, Troy, NY.

Sharp, M. and Dobry, R. (2002). “Sliding Block analysis of lateral spreading based in centrifuge results,” International Journal of Physical Modelling in Geotechnics,  2, 13-22

Taboada, V. (1995). “Centrifuge Modeling of Earthquakes – Induced Lateral Spreading in Sand using Laminar Box”. PhD Thesis, Rensselaer Polytechnic Institute, Troy, NY, USA

Thevanayagam, S., Kanagalingam, T., Reinhorn, A., Tharmendhira, R., Dobry, R., Pitman, M., Abdoun, T., Elgamal, A., Zeghal, M., Ecemis, N. and El Shamy, U., (2009), “Laminar Box System for 1-g Physical Modeling of Liquefaction and Lateral Spreading.” Geotech. Testing J., 32(5), 438-449.

Ubilla J. (2007). “Physical modeling of the effects of Natural Hazards on Soil- Structure Interaction.” PhD Thesis, Rensselaer Polytechnic Institute, Troy, NY.

Cite this work

Researchers should cite this work as follows:

  • Tarek Abdoun, Waleed El-Sekelly, Ricardo Dobry, Sabanayagam Thevanayagam and Marcelo Gonzalez (2015), "NEES: CENSEIS: Centrifuge and Full-scale Modeling of Seismic Pore Pressures in Sands," https://datacenterhub.org/resources/268.

    BibTex | EndNote

Tags

Debug Console

Close26 MBRequestSessionTimelineDatabase48Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /resources/268,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/268,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/268,
SCRIPT_URI => https://datacenterhub.org/resources/268,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Tue, 07 Apr 2020 02:30:46 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.235.62.151,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 51708,
REDIRECT_URL => /resources/268,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/268,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1594009350.4847,
REQUEST_TIME => 1594009350,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 9c0737be614b4a96cb9931bcef8ff009
tracker.ssid 9c0737be614b4a96cb9931bcef8ff009
tracker.rsid 9c0737be614b4a96cb9931bcef8ff009
  • site 0.769 seconds (+0.769); 12.25 MB (+12.250) - afterInitialise
  • site 0.788 seconds (+0.019); 13.50 MB (+1.250) - afterRoute
  • site 0.918 seconds (+0.131); 24.75 MB (+11.250) - afterDispatch
  • site 0.923 seconds (+0.005); 25.00 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.925 seconds (+0.002); 25.00 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.925 seconds (+0.000); 25.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.940 seconds (+0.015); 25.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.946 seconds (+0.005); 25.75 MB (+0.250) - onAfterRender
  • site 0.949 seconds (+0.003); 25.75 MB (0.000) - sessionStore
26 MB

48 Queries Logged: 0.73413753509521 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '0c9e8f0aac235f8c81b492efa3e0a461'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '0c9e8f0aac235f8c81b492efa3e0a461'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '9c0737be614b4a96cb9931bcef8ff009'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '9c0737be614b4a96cb9931bcef8ff009'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('9c0737be614b4a96cb9931bcef8ff009','0','1594009350','3.235.62.151')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. 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 `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  16. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`id` = '268'
  17. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  18. SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`label` != 'badge'
      AND `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '268'
      AND `jos_tags`.`admin` = '0'
  19. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '268'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  21. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '268'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  23. SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
      WHERE `jos_citations`.`published` = '1'
      AND `jos_citations_assoc`.`tbl` = 'resource'
      AND `jos_citations_assoc`.`oid` = '268'
      ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESC
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  25. SELECT jos_answers_questions.*
      FROM `jos_answers_questions`
      INNER JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_answers_questions.id
      INNER JOIN jos_tags
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`tbl` = 'answers'
      AND `jos_tags`.`tag` IN ('resource268')
      AND `jos_answers_questions`.`state` < '2'
  26. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-63'
  27. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '0'
  28. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-63'
  30. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  31. SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
      WHERE `jos_resource_assoc`.`parent_id` = '268'
      AND `jos_resources`.`standalone` = '0'
      AND `jos_resources`.`published` = '1'
      ORDER BY `ordering` ASC
  32. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '0'
  33. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '11'
  34. SELECT *
      FROM `jos_resource_licenses`
      WHERE `jos_resource_licenses`.`name` = NULL
      LIMIT 1
  35. SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
      WHERE v.approved=1
      AND wl.scope='resource'
      AND wl.scope_id='268'
      AND w.access!=1
      GROUP BY w.id, v.pagetext
      ORDER BY ranking DESC, title
      LIMIT 10) UNION (SELECT DISTINCT r.id, r.title, r.alias, r.introtext, r.type, r.published, r.publish_up, NULL AS scope, r.rating, r.times_rated, r.ranking, rt.type AS section
      FROM `jos_resource_types` AS rt, `jos_resources` AS r JOIN `jos_resource_assoc` AS a
      ON r.id=a.parent_id
      LEFT JOIN `jos_resource_types` AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.child_id='268'
      AND r.type=rt.id
      AND r.type!=8
      AND r.access=0
      ORDER BY r.ranking
      LIMIT 10)) AS k
      ORDER BY ranking DESC
      LIMIT 10
  36. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  37. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '268'
      GROUP BY jos_tags_object.label,jos_tags.id
  38. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  39. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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` IS NULL OR `m`.`publish_up` <= '2020-07-06 04:22:31' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-07-06 04:22:31' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '88' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  48. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594009350;s:18:\"session.timer.last\";i:1594009350;s:17:\"session.timer.now\";i:1594009350;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";s:12:\"tracker.ssid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";s:12:\"tracker.rsid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";}',`time` = '1594009351',`ip` = '3.235.62.151'
      WHERE `session_id` = '9c0737be614b4a96cb9931bcef8ff009'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 4 × SELECT *
      FROM `jos_resource_types`
  3. 3 × SELECT *
      FROM `jos_users`
  4. 2 × SELECT data
      FROM `jos_session`
  5. 1 × SELECT *
      FROM `jos_user_profiles`
  6. 1 × SELECT jos_answers_questions.*
      FROM `jos_answers_questions`
      INNER JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_answers_questions.id
      INNER JOIN jos_tags
      ON jos_tags.id = jos_tags_object.tagid
  7. 1 × SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
  8. 1 × SELECT *
      FROM `jos_resource_licenses`
  9. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  10. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  11. 1 × SELECT *
      FROM `jos_resource_sponsors`
  12. 1 × SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
  13. 1 × SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
  14. 1 × SELECT *
      FROM `jos_author_assoc`
  15. 1 × SELECT *
      FROM `jos_viewlevels
  16. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  17. 1 × SELECT session_id
      FROM `jos_session`
  18. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  19. 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 `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  20. 1 × SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
  21. 1 × SELECT *
      FROM `jos_resources`
  22. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
  23. 1 × SELECT *
      FROM `jos_resource_ratings`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594009350;s:18:\"session.timer.last\";i:1594009350;s:17:\"session.timer.now\";i:1594009350;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";s:12:\"tracker.ssid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";s:12:\"tracker.rsid\";s:32:\"9c0737be614b4a96cb9931bcef8ff009\";}',`time` = '1594009351',`ip` = '3.235.62.151'
  2. 1 × SHOW FULL COLUMNS
      FROM `jos_resource_assoc
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('9c0737be614b4a96cb9931bcef8ff009','0','1594009350','3.235.62.151'
  4. 1 × DELETE
      FROM `jos_session`
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onResourcesAreas Method plgResourcesAbout::onResourcesAreas /core/plugins/resources/about/about.php:32
  • onResourcesAreas Method plgResourcesReviews::onResourcesAreas /core/plugins/resources/reviews/reviews.php:43
  • onResourcesAreas Method plgResourcesUsage::onResourcesAreas /core/plugins/resources/usage/usage.php:29
  • onResourcesAreas Method plgResourcesVersions::onResourcesAreas /core/plugins/resources/versions/versions.php:29
  • onResourcesAreas Method plgResourcesShare::onResourcesAreas /core/plugins/resources/share/share.php:29
  • onResourcesAreas Method plgResourcesCitations::onResourcesAreas /core/plugins/resources/citations/citations.php:29
  • onResourcesAreas Method plgResourcesQuestions::onResourcesAreas /core/plugins/resources/questions/questions.php:29
  • onResourcesAreas Method plgResourcesSupportingDocs::onResourcesAreas /core/plugins/resources/supportingdocs/supportingdocs.php:30
  • onResourcesAreas Method plgResourcesWishlist::onResourcesAreas /core/plugins/resources/wishlist/wishlist.php:29
  • onResourcesAreas Method plgResourcesFindThisText::onResourcesAreas /core/plugins/resources/findthistext/findthistext.php:29
  • onResourcesAreas Method plgResourcesWindowstools::onResourcesAreas /core/plugins/resources/windowstools/windowstools.php:214
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onResources Method plgResourcesAbout::onResources /core/plugins/resources/about/about.php:54
  • onResources Method plgResourcesReviews::onResources /core/plugins/resources/reviews/reviews.php:91
  • onResources Method plgResourcesUsage::onResources /core/plugins/resources/usage/usage.php:51
  • onResources Method plgResourcesVersions::onResources /core/plugins/resources/versions/versions.php:50
  • onResources Method plgResourcesShare::onResources /core/plugins/resources/share/share.php:50
  • onResources Method plgResourcesCitations::onResources /core/plugins/resources/citations/citations.php:51
  • onResources Method plgResourcesQuestions::onResources /core/plugins/resources/questions/questions.php:60
  • onResources Method plgResourcesSupportingDocs::onResources /core/plugins/resources/supportingdocs/supportingdocs.php:52
  • onResources Method plgResourcesWishlist::onResources /core/plugins/resources/wishlist/wishlist.php:50
  • onResources Method plgResourcesFindThisText::onResources /core/plugins/resources/findthistext/findthistext.php:51
  • onResources Method plgResourcesWindowstools::onResources /core/plugins/resources/windowstools/windowstools.php:235
  • onResources Method plgResourcesGooglescholar::onResources /core/plugins/resources/googlescholar/googlescholar.php:25
  • onResources Method plgResourcesOpengraph::onResources /core/plugins/resources/opengraph/opengraph.php:25
  • onResources Method plgResourcesDublincore::onResources /core/plugins/resources/dublincore/dublincore.php:25
  • onResources Method plgResourcesCoins::onResources /core/plugins/resources/coins/coins.php:25
  • onResourcesSub Method plgResourcesGroups::onResourcesSub /core/plugins/resources/groups/groups.php:45
  • onResourcesSub Method plgResourcesRelated::onResourcesSub /core/plugins/resources/related/related.php:45
  • onResourcesSub Method plgResourcesSponsors::onResourcesSub /core/plugins/resources/sponsors/sponsors.php:45
  • onResourcesSub Method plgResourcesWatch::onResourcesSub /core/plugins/resources/watch/watch.php:46
  • onResourcesSub Method plgResourcesCollections::onResourcesSub /core/plugins/resources/collections/collections.php:31
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21