WordPress.org
Get WordPress

Make WordPress Core

Ticket #11081: mysql.log

File mysql.log, 12.1 KB (added by maribge, 15 years ago)
Line 
1mysqld, Version: 5.1.34-community-log (MySQL Community Server (GPL)). started with:
2TCP Port: 3306, Named Pipe: (null)
3Time                 Id Command    Argument
4091105 16:18:00    1 Connect    admin@localhost on
5                    1 Query     SET NAMES utf8
6                    1 Init DB   wordpress
7                    1 Query     SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
8                    1 Query     UPDATE `wp_options` SET `option_value` = '1257427080' WHERE `option_name` = '_transient_doing_cron'
9                    2 Connect   admin@localhost on
10                    2 Query     SET NAMES utf8
11                    2 Init DB   wordpress
12                    2 Query     SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
13                    2 Query     SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1
14                    2 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title' AND post_type = 'post' AND ID != 0 LIMIT 1
15                    2 Query     INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_date_gmt`,`post_content`,`post_content_filtered`,`post_title`,`post_excerpt`,`post_status`,`post_type`,`comment_status`,`ping_status`,`post_password`,`post_name`,`to_ping`,`pinged`,`post_modified`,`post_modified_gmt`,`post_parent`,`menu_order`,`guid`) VALUES ('1','2009-11-05 16:18:00','2009-11-05 13:18:00','test content','','test title','','publish','post','open','open','','test-title','','','2009-11-05 16:18:00','2009-11-05 13:18:00','0','0','somethingsss')
16                    2 Query     SELECT tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (3) AND tt.taxonomy IN ('category')
17                    2 Query     SELECT * FROM wp_posts WHERE ID = 3 LIMIT 1
18                    2 Query     SELECT ID FROM wp_posts WHERE post_parent = 3
19                    2 Query     SELECT * FROM wp_posts WHERE ID = 3 LIMIT 1
20                    2 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('3','1','_pingme')
21                    2 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('3','1','_encloseme')
22                    2 Query     SELECT ID FROM wp_posts WHERE post_parent = 3
23                    2 Query     UPDATE `wp_options` SET `option_value` = 'a:2:{i:1257467774;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron'
24                    2 Query     SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_pingme' LIMIT 1
25                    2 Query     DELETE FROM wp_postmeta WHERE post_id = 3 AND meta_key = '_pingme'
26                    2 Query     SELECT pinged FROM wp_posts WHERE ID = 3
27                    2 Query     SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_pingme' LIMIT 1
28                    2 Query     SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_encloseme' LIMIT 1
29                    2 Query     DELETE FROM wp_postmeta WHERE post_id = 3 AND meta_key = '_encloseme'
30                    2 Query     SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (3)
31                    2 Query     SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_encloseme' LIMIT 1
32                    2 Query     SELECT ID FROM wp_posts WHERE to_ping <> '' AND post_status = 'publish'
33091105 16:18:01    2 Quit       
34                    1 Query     SELECT * FROM wp_users WHERE user_login = 'admin'
35                    1 Query     SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1
36                    1 Query     SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1
37                    1 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title' AND post_type = 'post' AND ID != 0 LIMIT 1
38                    1 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title-2' AND post_type = 'post' AND ID != 0 LIMIT 1
39                    1 Query     INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_date_gmt`,`post_content`,`post_content_filtered`,`post_title`,`post_excerpt`,`post_status`,`post_type`,`comment_status`,`ping_status`,`post_password`,`post_name`,`to_ping`,`pinged`,`post_modified`,`post_modified_gmt`,`post_parent`,`menu_order`,`guid`) VALUES ('1','2009-11-05 16:18:01','2009-11-05 13:18:01','test content','','test title','','publish','post','open','open','','test-title-2','','','2009-11-05 16:18:01','2009-11-05 13:18:01','0','0','somethingsss')
40                    1 Query     SELECT tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (4) AND tt.taxonomy IN ('category')
41                    1 Query     SELECT * FROM wp_posts WHERE ID = 4 LIMIT 1
42                    1 Query     SELECT ID FROM wp_posts WHERE post_parent = 4
43                    1 Query     SELECT * FROM wp_posts WHERE ID = 4 LIMIT 1
44                    1 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('4','1','_pingme')
45                    1 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('4','1','_encloseme')
46                    1 Query     SELECT ID FROM wp_posts WHERE post_parent = 4
47                    1 Query     SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10
48                    1 Query     SELECT FOUND_ROWS()
49                    1 Query     SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (4, 3) ORDER BY t.name ASC
50                    1 Query     SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4,3)
51                    1 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_image' LIMIT 1
52                    1 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_color' LIMIT 1
53                    1 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_display' LIMIT 1
54                    1 Query     SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY menu_order, post_title ASC
55                    1 Query     SELECT option_value FROM wp_options WHERE option_name = 'page_for_posts' LIMIT 1
56                    1 Query     SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
57                    1 Query     SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  ORDER BY t.name ASC
58                    1 Query     SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category')  AND tt.count > 0 ORDER BY t.name ASC
59                    1 Query     SELECT *  , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated   FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 2 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC
60                    1 Quit     
61091105 16:18:05    3 Connect    admin@localhost on
62                    3 Query     SET NAMES utf8
63                    3 Init DB   wordpress
64                    3 Query     SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
65                    3 Query     SELECT * FROM wp_users WHERE user_login = 'admin'
66                    3 Query     SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1
67                    3 Query     SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1
68                    3 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title' AND post_type = 'post' AND ID != 0 LIMIT 1
69                    3 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title-2' AND post_type = 'post' AND ID != 0 LIMIT 1
70                    3 Query     SELECT post_name FROM wp_posts WHERE post_name = 'test-title-3' AND post_type = 'post' AND ID != 0 LIMIT 1
71                    3 Query     INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_date_gmt`,`post_content`,`post_content_filtered`,`post_title`,`post_excerpt`,`post_status`,`post_type`,`comment_status`,`ping_status`,`post_password`,`post_name`,`to_ping`,`pinged`,`post_modified`,`post_modified_gmt`,`post_parent`,`menu_order`,`guid`) VALUES ('1','2009-11-05 16:18:05','2009-11-05 13:18:05','test content','','test title','','publish','post','open','open','','test-title-3','','','2009-11-05 16:18:05','2009-11-05 13:18:05','0','0','somethingsss')
72                    3 Query     SELECT tr.term_taxonomy_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id IN (5) AND tt.taxonomy IN ('category')
73                    3 Query     SELECT * FROM wp_posts WHERE ID = 5 LIMIT 1
74                    3 Query     SELECT ID FROM wp_posts WHERE post_parent = 5
75                    3 Query     SELECT * FROM wp_posts WHERE ID = 5 LIMIT 1
76                    3 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('5','1','_pingme')
77                    3 Query     INSERT INTO `wp_postmeta` (`post_id`,`meta_value`,`meta_key`) VALUES ('5','1','_encloseme')
78                    3 Query     UPDATE `wp_options` SET `option_value` = 'a:3:{i:1257427085;a:1:{s:8:\"do_pings\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:0:{}}}}i:1257467774;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron'
79                    3 Query     SELECT ID FROM wp_posts WHERE post_parent = 5
80                    3 Query     SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10
81                    3 Query     SELECT FOUND_ROWS()
82                    3 Query     SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (5, 4, 3) ORDER BY t.name ASC
83                    3 Query     SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (5,4,3)
84                    3 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_image' LIMIT 1
85                    3 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_color' LIMIT 1
86                    3 Query     SELECT option_value FROM wp_options WHERE option_name = 'kubrick_header_display' LIMIT 1
87                    3 Query     SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY menu_order, post_title ASC
88                    3 Query     SELECT option_value FROM wp_options WHERE option_name = 'page_for_posts' LIMIT 1
89                    3 Query     SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
90                    3 Query     SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  ORDER BY t.name ASC
91                    3 Query     SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category')  AND tt.count > 0 ORDER BY t.name ASC
92                    3 Query     SELECT *  , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated   FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 2 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC
93                    3 Quit