| 0.7989 |
SELECT www_blogs.blog_id
FROM www_blogs
WHERE domain = 'martinedoyen.com'
AND path IN ( '/paquesautison/', '/' )
ORDER BY CHAR_LENGTH(path) DESC
LIMIT 1
|
| 0.3769 |
SELECT *
FROM www_blogs
WHERE blog_id IN (1)
|
| 0.7691 |
SELECT meta_key, meta_value
FROM www_sitemeta
WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'can_compress_scripts', 'global_terms_enabled', 'ms_files_rewriting')
AND site_id = 1
|
| 1.9748 |
SELECT option_name, option_value
FROM www_options
WHERE autoload = 'yes'
|
| 0.3600 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-allowed-plugins'
LIMIT 1
|
| 0.2229 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-default-theme'
LIMIT 1
|
| 0.2110 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-current-theme'
LIMIT 1
|
| 0.2320 |
SELECT option_value
FROM www_options
WHERE option_name = 'wordpress_api_key'
LIMIT 1
|
| 0.2160 |
SELECT VERSION()
|
| 0.3698 |
SELECT option_value
FROM www_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
| 0.2480 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_notices'
LIMIT 1
|
| 0.1762 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_cache'
LIMIT 1
|
| 0.1850 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_accounts_data'
LIMIT 1
|
| 0.8850 |
SHOW FULL COLUMNS
FROM `www_options`
|
| 0.5419 |
UPDATE `www_options`
SET `option_value` = 'a:3:{s:33:\"instagram-feed/instagram-feed.php\";s:22:\"sb_instagram_uninstall\";s:59:\"ultimate-social-media-icons/ultimate_social_media_icons.php\";a:2:{i:0;s:15:\"Account\\Account\";i:1;s:25:\"onUninstallPluginListener\";}s:26:\"onecom-vcache/vcaching.php\";s:26:\"oc_vcache_plugin_uninstall\";}'
WHERE `option_name` = 'uninstall_plugins'
|
| 0.4082 |
UPDATE `www_options`
SET `option_value` = 'a:3:{s:33:\"instagram-feed/instagram-feed.php\";s:22:\"sb_instagram_uninstall\";s:59:\"ultimate-social-media-icons/ultimate_social_media_icons.php\";s:20:\"sfsi_Unistall_plugin\";s:26:\"onecom-vcache/vcaching.php\";s:26:\"oc_vcache_plugin_uninstall\";}'
WHERE `option_name` = 'uninstall_plugins'
|
| 0.3932 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_w'
LIMIT 1
|
| 0.1750 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_h'
LIMIT 1
|
| 0.2680 |
SELECT option_value
FROM www_options
WHERE option_name = 'sbi_oembed_token'
LIMIT 1
|
| 0.4299 |
SELECT option_value
FROM www_options
WHERE option_name = 'sb_instagram_errors'
LIMIT 1
|
| 0.5100 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'wpseo_ms'
AND site_id = 1
|
| 0.4640 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient_timeout___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.2589 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.2379 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'varnish_caching_enable'
AND site_id = 1
|
| 0.6719 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_hosts'
LIMIT 1
|
| 0.3822 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_dynamic_host'
LIMIT 1
|
| 0.2620 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_stats_json_file'
LIMIT 1
|
| 0.3231 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_menu_save'
LIMIT 1
|
| 0.3190 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_key'
LIMIT 1
|
| 0.2708 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_truncate_notice'
LIMIT 1
|
| 0.3121 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_override'
LIMIT 1
|
| 0.3250 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_ssl'
LIMIT 1
|
| 0.7122 |
SELECT ID, post_name, post_parent, post_type
FROM www_posts
WHERE post_name IN ('paquesautison')
AND post_type IN ('page','attachment')
|
| 0.5560 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.post_name = 'paquesautison'
AND www_posts.post_type = 'post'
ORDER BY www_posts.post_date DESC
|
| 1.2920 |
SELECT t.*, tt.*, tr.object_id
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN www_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format')
AND tr.object_id IN (753)
ORDER BY t.name ASC
|
| 0.3850 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (753)
ORDER BY meta_id ASC
|
| 0.3381 |
SELECT option_value
FROM www_options
WHERE option_name = 'oc_cdn_enabled'
LIMIT 1
|
| 0.5200 |
SELECT *
FROM www_users
WHERE ID = '1'
LIMIT 1
|
| 0.6480 |
SELECT user_id, meta_key, meta_value
FROM www_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
|
| 0.6502 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '753'
AND `object_type` = 'post'
LIMIT 1
|
| 0.6471 |
SELECT *
FROM `www_yoast_indexable`
WHERE `permalink_hash` = '86:1355e3bbab26b6765e4d8d47fceb3f1a'
AND `permalink` = 'https://martinedoyen.com/wp-content/uploads/2018/10/20181029_161514-e1545840733186.jpg'
LIMIT 1
|
| 0.3259 |
SELECT *
FROM www_posts
WHERE ID = 259
LIMIT 1
|
| 0.6800 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (259)
ORDER BY meta_id ASC
|
| 0.5569 |
SELECT *
FROM `www_yoast_indexable`
WHERE `permalink_hash` = '86:1355e3bbab26b6765e4d8d47fceb3f1a'
AND `permalink` = 'https://martinedoyen.com/wp-content/uploads/2018/10/20181029_161514-e1545840733186.jpg'
LIMIT 1
|
| 0.5591 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '804'
AND `object_type` = 'post'
LIMIT 1
|
| 0.3910 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '894'
AND `object_type` = 'post'
LIMIT 1
|
| 0.3972 |
SELECT `ancestor_id`
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '154'
ORDER BY `depth` DESC
|
| 0.2100 |
DELETE
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '154'
|
| 0.4959 |
SELECT *
FROM www_posts
WHERE ID = 965
LIMIT 1
|
| 0.2992 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (965)
ORDER BY meta_id ASC
|
| 0.4160 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (970)
ORDER BY meta_id ASC
|
| 0.2809 |
SELECT *
FROM www_posts
WHERE ID = 970
LIMIT 1
|
| 0.3932 |
SELECT t.*, tt.*
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 2
|
| 0.3560 |
SELECT tr.object_id
FROM www_term_relationships AS tr
INNER JOIN www_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu')
AND tt.term_id IN ('2')
ORDER BY tr.object_id ASC
|
| 1.1940 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.ID IN (634,808,835,889,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,957,963,974,975,998,1039)
AND www_posts.post_type = 'nav_menu_item'
AND ((www_posts.post_status = 'publish'))
ORDER BY www_posts.menu_order ASC
|
| 2.8939 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (808,998,634,889,835,943,939,945,940,937,936,935,933,963,942,938,929,928,941,932,934,927,944,931,930,975,957,1039,974)
ORDER BY meta_id ASC
|
| 0.7632 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.ID IN (804,894,2,888,834,1036,26)
AND www_posts.post_type = 'page'
AND ((www_posts.post_status = 'publish'))
ORDER BY www_posts.post_date DESC
|
| 0.9768 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (1036,894,888,834,804,26,2)
ORDER BY meta_id ASC
|
| 0.7079 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.ID IN (749,745,753,756,759,767,619,839,851,770,762,853,792,799)
AND www_posts.post_type = 'post'
AND ((www_posts.post_status = 'publish'))
ORDER BY www_posts.post_date DESC
|
| 2.6400 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (853,851,839,799,792,770,767,762,759,756,619,749,745)
ORDER BY meta_id ASC
|
| 0.7010 |
SELECT t.*, tt.*
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('category')
AND t.term_id IN ( 41,43,51,62,50,59,38 )
AND tt.count > 0
ORDER BY t.name ASC
|
| 0.4139 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (43,62,51,41,50,59)
ORDER BY meta_id ASC
|
| 0.5660 |
SELECT t.*, tt.*
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 38
|
| 0.7851 |
SELECT t.term_id, tt.parent, tt.count, tt.taxonomy
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN www_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category')
AND tr.object_id IN (753)
ORDER BY t.name ASC
|
| 0.2441 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (45,44)
ORDER BY meta_id ASC
|
| 0.5581 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.post_name = '0e13271f1922e488b52376faf18dc92a'
AND www_posts.post_type = 'oembed_cache'
AND ((www_posts.post_status = 'publish'))
ORDER BY www_posts.post_date DESC
|
| 0.5338 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date < '2020-05-15 11:52:54'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
| 0.4239 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date > '2020-05-15 11:52:54'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
| 0.6270 |
SELECT SQL_CALC_FOUND_ROWS www_comments.comment_ID
FROM www_comments
WHERE ( comment_approved = '1' )
AND comment_post_ID = 753
AND comment_parent = 0
ORDER BY www_comments.comment_date_gmt ASC, www_comments.comment_ID ASC
|
| 1.6360 |
SELECT t.*, tt.*
FROM www_terms AS t
INNER JOIN www_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('category')
AND tt.count > 0
ORDER BY t.name ASC
|
| 0.3622 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (47,58,52,60,42,63,48,61,56,37,46,1,40,32,34)
ORDER BY meta_id ASC
|
| 0.3428 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_&sbi_delay_requests'
LIMIT 1
|
| 0.1800 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_&sbi_delay_requests'
LIMIT 1
|
| 0.1919 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_17841402078904351#20'
LIMIT 1
|
| 0.2930 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_17841402078904351#20'
LIMIT 1
|
| 0.2220 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_header_17841402078904351#20'
LIMIT 1
|
| 0.1888 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_header_17841402078904351#20'
LIMIT 1
|
| 0.7200 |
show tables like 'www_sbi_instagram_posts'
|
| 0.5839 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 0.9191 |
UPDATE www_sbi_instagram_posts
SET last_requested = '2020-10-20 13:31:38'
WHERE instagram_id IN ('18125151481192656','17953968247367754','17893846588646752','17893804621640232','17962477204348666','18166711741060453','18012947974290134','17905425277542724','17903077330538751','17860195109179863','17850945416333128','17870811988991641','17901002068570317','18046824892266890','17866516373041166','17900983051566804','17866326995042095','17857579121212790','17898545773592937','17879149009827389');
|
| 0.5300 |
show tables like 'www_sbi_instagram_posts'
|
| 0.4959 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 1.1570 |
SELECT p.media_id, p.instagram_id, p.aspect_ratio, p.sizes
FROM www_sbi_instagram_posts AS p
INNER JOIN www_sbi_instagram_feeds_posts AS f ON p.id = f.id
WHERE f.feed_id = 'sbi_17841402078904351'
AND p.instagram_id IN('18125151481192656','17953968247367754','17893846588646752','17893804621640232','17962477204348666','18166711741060453','18012947974290134','17905425277542724','17903077330538751','17860195109179863','17850945416333128','17870811988991641','17901002068570317','18046824892266890','17866516373041166','17900983051566804','17866326995042095','17857579121212790','17898545773592937','17879149009827389')
AND p.images_done = 1
|
| 0.3591 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.6042 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.6640 |
SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts
FROM www_posts
WHERE post_type = 'post'
AND post_status = 'publish'
GROUP BY YEAR(post_date), MONTH(post_date)
ORDER BY post_date DESC
|
