| 0.6709 |
SELECT www_blogs.blog_id
FROM www_blogs
WHERE domain = 'martinedoyen.com'
AND path IN ( '/lespionne/', '/' )
ORDER BY CHAR_LENGTH(path) DESC
LIMIT 1
|
| 0.2990 |
SELECT *
FROM www_blogs
WHERE blog_id IN (1)
|
| 0.5460 |
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
|
| 3.3898 |
SELECT option_name, option_value
FROM www_options
WHERE autoload = 'yes'
|
| 0.4110 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-allowed-plugins'
LIMIT 1
|
| 0.2151 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-default-theme'
LIMIT 1
|
| 0.2091 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-current-theme'
LIMIT 1
|
| 0.2630 |
SELECT option_value
FROM www_options
WHERE option_name = 'wordpress_api_key'
LIMIT 1
|
| 0.2370 |
SELECT VERSION()
|
| 0.3610 |
SELECT option_value
FROM www_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
| 0.3190 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'oc_cu_consent'
AND site_id = 1
|
| 0.4151 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_notices'
LIMIT 1
|
| 0.1609 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_cache'
LIMIT 1
|
| 0.1509 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_accounts_data'
LIMIT 1
|
| 0.7679 |
SHOW FULL COLUMNS
FROM `www_options`
|
| 0.6988 |
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.3500 |
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.3040 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_w'
LIMIT 1
|
| 0.1640 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_h'
LIMIT 1
|
| 0.3059 |
SELECT option_value
FROM www_options
WHERE option_name = 'sbi_oembed_token'
LIMIT 1
|
| 0.3068 |
SELECT option_value
FROM www_options
WHERE option_name = 'sb_instagram_errors'
LIMIT 1
|
| 0.4308 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'wpseo_ms'
AND site_id = 1
|
| 0.4449 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient_timeout___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.3541 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.2449 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'varnish_caching_enable'
AND site_id = 1
|
| 0.3591 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_doing_cron'
LIMIT 1
|
| 0.1729 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_doing_cron'
LIMIT 1
|
| 0.5739 |
INSERT INTO `www_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1611110183.3107628822326660156250', 'yes')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.5031 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_hosts'
LIMIT 1
|
| 0.2959 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_dynamic_host'
LIMIT 1
|
| 0.1540 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_stats_json_file'
LIMIT 1
|
| 0.1330 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_menu_save'
LIMIT 1
|
| 0.1900 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_key'
LIMIT 1
|
| 0.1690 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_truncate_notice'
LIMIT 1
|
| 0.2880 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_override'
LIMIT 1
|
| 0.1590 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_ssl'
LIMIT 1
|
| 0.3679 |
DELETE
FROM `www_statistics_useronline`
WHERE timestamp < 1611113753
|
| 0.3181 |
UPDATE `www_options`
SET `option_value` = '1611113783'
WHERE `option_name` = 'wp_statistics_check_user_online'
|
| 1.2312 |
SELECT ID, post_name, post_parent, post_type
FROM www_posts
WHERE post_name IN ('lespionne')
AND post_type IN ('page','attachment')
|
| 0.7081 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.post_name = 'lespionne'
AND www_posts.post_type = 'post'
ORDER BY www_posts.post_date DESC
|
| 1.4720 |
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 (853)
ORDER BY t.name ASC
|
| 0.5500 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (853)
ORDER BY meta_id ASC
|
| 0.3200 |
SELECT option_value
FROM www_options
WHERE option_name = 'oc_cdn_enabled'
LIMIT 1
|
| 0.4549 |
SELECT *
FROM www_users
WHERE ID = '1'
LIMIT 1
|
| 0.5679 |
SELECT user_id, meta_key, meta_value
FROM www_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
|
| 0.8700 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '853'
AND `object_type` = 'post'
LIMIT 1
|
| 0.6852 |
SELECT *
FROM www_posts
WHERE ID = 583
LIMIT 1
|
| 0.5550 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (583)
ORDER BY meta_id ASC
|
| 1.3182 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_type` = 'home-page'
LIMIT 1
|
| 1.0400 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '804'
AND `object_type` = 'post'
LIMIT 1
|
| 0.8290 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '894'
AND `object_type` = 'post'
LIMIT 1
|
| 0.7021 |
SELECT `ancestor_id`
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '247'
ORDER BY `depth` DESC
|
| 0.3269 |
DELETE
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '247'
|
| 0.6320 |
SELECT *
FROM www_posts
WHERE ID = 965
LIMIT 1
|
| 0.5140 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (965)
ORDER BY meta_id ASC
|
| 0.3650 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (970)
ORDER BY meta_id ASC
|
| 0.2668 |
SELECT *
FROM www_posts
WHERE ID = 970
LIMIT 1
|
| 0.4380 |
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.3991 |
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.3800 |
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
|
| 3.3469 |
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.7019 |
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.8359 |
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.6719 |
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
|
| 0.8371 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (851,839,799,792,770,767,762,759,756,753,619,749,745)
ORDER BY meta_id ASC
|
| 0.4461 |
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.5791 |
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.4461 |
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.4671 |
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 (853)
ORDER BY t.name ASC
|
| 0.1891 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (63)
ORDER BY meta_id ASC
|
| 0.7851 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date < '2020-05-18 12:36:40'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
| 0.5391 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date > '2020-05-18 12:36:40'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
| 0.4160 |
SELECT *
FROM www_posts
WHERE ID = 866
LIMIT 1
|
| 0.8891 |
SELECT SQL_CALC_FOUND_ROWS www_comments.comment_ID
FROM www_comments
WHERE ( comment_approved = '1' )
AND comment_post_ID = 853
AND comment_parent = 0
ORDER BY www_comments.comment_date_gmt ASC, www_comments.comment_ID ASC
|
| 2.8498 |
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.5460 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (47,45,58,52,60,42,48,61,56,37,46,1,44,40,32,34)
ORDER BY meta_id ASC
|
| 0.4780 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_&sbi_delay_requests'
LIMIT 1
|
| 0.2592 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_&sbi_delay_requests'
LIMIT 1
|
| 0.2780 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_17841402078904351#20'
LIMIT 1
|
| 0.5341 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_17841402078904351#20'
LIMIT 1
|
| 0.2592 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_header_17841402078904351#20'
LIMIT 1
|
| 0.2010 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_header_17841402078904351#20'
LIMIT 1
|
| 1.0369 |
show tables like 'www_sbi_instagram_posts'
|
| 0.8931 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 2.1460 |
UPDATE www_sbi_instagram_posts
SET last_requested = '2021-01-20 02:36:23'
WHERE instagram_id IN ('17868284351223272','17880533945071925','18139835272192358','18151623922112739','17911838236597895','18088650334228636','17872952780179730','17870055404198956','17887009801937413','17901181627725415','17851668371475251','17904595885652117','17875416716109684','17890195516869251','18129999715147900','17869681145148386','18148460065118091','17953900312391081','17855436899359667','18133381675091435');
|
| 0.9019 |
show tables like 'www_sbi_instagram_posts'
|
| 0.9100 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 2.4729 |
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('17868284351223272','17880533945071925','18139835272192358','18151623922112739','17911838236597895','18088650334228636','17872952780179730','17870055404198956','17887009801937413','17901181627725415','17851668371475251','17904595885652117','17875416716109684','17890195516869251','18129999715147900','17869681145148386','18148460065118091','17953900312391081','17855436899359667','18133381675091435')
AND p.images_done = 1
|
| 0.3309 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.2031 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.6850 |
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
|
