Thread: High CPU usage with mysql on classipress

( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:41:36.554277Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:     7
# Query_time: 52.882568  Lock_time: 0.000242 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403296;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:41:38.154851Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:     9
# Query_time: 52.291333  Lock_time: 0.000286 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403298;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:41:40.775005Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    13
# Query_time: 56.603852  Lock_time: 0.082935 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403300;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:41:43.559588Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    21
# Query_time: 57.195313  Lock_time: 0.000299 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403303;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:41:51.958568Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    22
# Query_time: 3.291108  Lock_time: 0.000281 Rows_sent: 0  Rows_examined: 0
SET timestamp=1626403311;
INSERT INTO `dl_yoast_indexable` (`object_id`, `object_type`, `permalink`, `title`, `description`, `is_cornerstone`, `is_robots_noindex`, `is_robots_nofollow`, `is_robots_noarchive`, `is_robots_noimageindex`, `is_robots_nosnippet`, `is_public`, `has_public_posts`, `blog_id`, `open_graph_image`, `open_graph_image_id`, `open_graph_image_source`, `open_graph_image_meta`, `twitter_image`, `twitter_image_id`, `twitter_image_source`, `permalink_hash`, `created_at`, `updated_at`) VALUES ('1085580', 'user', 'https://webraovat.com/author/alannahla38/', NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '0', '1', 'https://secure.gravatar.com/avatar/aae51f0933dcac03fd36e8439ec745af?s=500&d=mm&r=g', NULL, 'gravatar-image', NULL, 'https://secure.gravatar.com/avatar/aae51f0933dcac03fd36e8439ec745af?s=500&d=mm&r=g', NULL, 'gravatar-image', '41:59795c9bf32533c0d539ed7be6e0031a', '2021-07-16 02:41:48', '2021-07-16 02:41:48');
# Time: 2021-07-16T02:41:52.054456Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    18
# Query_time: 5.600036  Lock_time: 0.000285 Rows_sent: 0  Rows_examined: 0
SET timestamp=1626403312;
INSERT INTO `dl_yoast_indexable` (`object_id`, `object_type`, `permalink`, `title`, `description`, `is_cornerstone`, `is_robots_noindex`, `is_robots_nofollow`, `is_robots_noarchive`, `is_robots_noimageindex`, `is_robots_nosnippet`, `is_public`, `has_public_posts`, `blog_id`, `open_graph_image`, `open_graph_image_id`, `open_graph_image_source`, `open_graph_image_meta`, `twitter_image`, `twitter_image_id`, `twitter_image_source`, `permalink_hash`, `created_at`, `updated_at`) VALUES ('1085582', 'user', 'https://webraovat.com/author/garland89t1/', NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '0', '1', 'https://secure.gravatar.com/avatar/93fd7e1cf6c68c16180d4a154e2f2aaf?s=500&d=mm&r=g', NULL, 'gravatar-image', NULL, 'https://secure.gravatar.com/avatar/93fd7e1cf6c68c16180d4a154e2f2aaf?s=500&d=mm&r=g', NULL, 'gravatar-image', '41:8815f5a3445d35d210ff9e6b20835b46', '2021-07-16 02:41:46', '2021-07-16 02:41:46');
# Time: 2021-07-16T02:42:21.883870Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    10
# Query_time: 95.415669  Lock_time: 57.693438 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403341;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:42:22.273014Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    23
# Query_time: 38.008115  Lock_time: 0.000208 Rows_sent: 2  Rows_examined: 370864
SET timestamp=1626403342;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:43:47.666376Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:   109
# Query_time: 21.110741  Lock_time: 0.000297 Rows_sent: 30  Rows_examined: 1582
SET timestamp=1626403427;
SELECT SQL_CALC_FOUND_ROWS  dl_posts.ID FROM dl_posts  WHERE 1=1  AND dl_posts.post_type = 'ad_listing' AND (dl_posts.post_status = 'publish' OR dl_posts.post_status = 'tr_pending' OR dl_posts.post_status = 'tr_failed' OR dl_posts.post_status = 'tr_completed' OR dl_posts.post_status = 'tr_activated' OR dl_posts.post_author = 1081470 AND dl_posts.post_status = 'private')  ORDER BY dl_posts.post_date DESC LIMIT 0, 30;
# Time: 2021-07-16T02:44:19.565839Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    64
# Query_time: 78.180629  Lock_time: 0.188174 Rows_sent: 2  Rows_examined: 370867
SET timestamp=1626403459;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:44:23.062468Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    35
# Query_time: 81.987246  Lock_time: 0.380349 Rows_sent: 2  Rows_examined: 370867
SET timestamp=1626403463;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;
# Time: 2021-07-16T02:44:29.569124Z
# User@Host: sql_webraovat_co[sql_webraovat_co] @ localhost []  Id:    90
# Query_time: 89.804402  Lock_time: 0.000341 Rows_sent: 2  Rows_examined: 370867
SET timestamp=1626403469;
SELECT dl_users.user_login FROM dl_users INNER JOIN dl_usermeta ON ( dl_users.ID = dl_usermeta.user_id ) WHERE 1=1 AND ( 
  ( 
    ( dl_usermeta.meta_key = 'dl_capabilities' AND dl_usermeta.meta_value LIKE '%\"administrator\"%' )
  )
) ORDER BY user_login ASC;