mysqldumpslow -s t -t 5

Reading mysql slow query log from /var/log/mariadb/slow_query.log
Count: 52305  Time=0.09s (4678s)  Lock=0.00s (3s)  Rows_sent=664.9 (34778098), Rows_examined=156717.0 (8197080631), Rows_affected=0.0 (0), 11users@localhost
  SELECT option_name, option_value FROM wp_options WHERE autoload = 'S'

Count: 27639  Time=0.02s (422s)  Lock=0.00s (1s)  Rows_sent=3503.8 (96841712), Rows_examined=4278.0 (118238764), Rows_affected=0.0 (0), 2users@localhost
  SELECT
  st.value AS tra,
  s.value AS org,
  s.domain_name_context_md5 AS ctx
  FROM wp_icl_strings s
  LEFT JOIN wp_icl_string_translations st
  ON s.id=st.string_id
  AND st.status=N
  AND st.language='S'
  AND s.language!='S'

Count: 9830  Time=0.02s (239s)  Lock=0.00s (3s)  Rows_sent=2537.3 (24942132), Rows_examined=15075.3 (148190103), Rows_affected=0.0 (0), tabaklae_wp1[tabaklae_wp1]@localhost
  SELECT slug, taxonomy FROM wp_posts
  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
  INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
  INNER JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id )
  WHERE wp_posts.ID IN ("S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S","S")
  ORDER BY wp_terms.name ASC

Count: 8747  Time=0.02s (142s)  Lock=0.00s (0s)  Rows_sent=2305.7 (20168189), Rows_examined=9782.8 (85569728), Rows_affected=0.0 (0), 2users@localhost
  SELECT t.element_id, tax.term_id, tax.taxonomy
  FROM wp_icl_translations t
  JOIN wp_term_taxonomy tax
  ON t.element_id = tax.term_taxonomy_id
  AND t.element_type = CONCAT('S', tax.taxonomy)
  JOIN wp_terms terms
  ON terms.term_id = tax.term_id
  WHERE tax.term_id != tax.term_taxonomy_id

Count: 9311  Time=0.01s (72s)  Lock=0.00s (0s)  Rows_sent=0.0 (0), Rows_examined=5353.0 (49841783), Rows_affected=0.0 (0), wp_highpassion[wp_highpassion]@localhost
  SELECT t.value, s.name
  FROM wp_icl_strings s
  JOIN wp_icl_string_translations t ON t.string_id = s.id
  WHERE s.name IN ('S')
  AND t.status = N
  AND t.value <> 'S'

root@panel [~]#