Skip to content

Instantly share code, notes, and snippets.

@cras4202tw
Created May 25, 2018 01:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cras4202tw/909b224166d4f2b98a35bc791fc53700 to your computer and use it in GitHub Desktop.
Save cras4202tw/909b224166d4f2b98a35bc791fc53700 to your computer and use it in GitHub Desktop.
# Time: 2018-05-25T01:30:11.363316Z
# User@Host: wbf[wbf] @ localhost [] Id: 312
# Query_time: 1.326857 Lock_time: 0.000138 Rows_sent: 1 Rows_examined: 134833
SET timestamp=1527211811;
SELECT post_id FROM wp_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2017/11/1511901570-bd5a83967c7a54ca7508bfcbf95c8d05.jpg';
# Time: 2018-05-25T01:30:12.474078Z
# User@Host: wbf[wbf] @ localhost [] Id: 319
# Query_time: 1.181308 Lock_time: 0.000069 Rows_sent: 1 Rows_examined: 134833
SET timestamp=1527211812;
SELECT post_id FROM wp_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2017/11/1511901569-f68d8859ed43b8cff4fe4fd97d845fb2.jpg';
# Time: 2018-05-25T01:30:12.485017Z
# User@Host: wbf[wbf] @ localhost [] Id: 312
# Query_time: 1.121400 Lock_time: 0.000060 Rows_sent: 1 Rows_examined: 134833
SET timestamp=1527211812;
SELECT post_id FROM wp_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2017/11/1511901571-20684d89fd55dd1d1cc950fa9582dff6.jpg';
# Time: 2018-05-25T01:32:34.551411Z
# User@Host: wbf[wbf] @ localhost [] Id: 518
# Query_time: 2.348824 Lock_time: 0.000055 Rows_sent: 3 Rows_examined: 134836
SET timestamp=1527211954;
SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = 'attachment';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment