| 0.9971 |
SELECT www_blogs.blog_id
FROM www_blogs
WHERE domain = 'martinedoyen.com'
AND path IN ( '/linsoupconnable/', '/' )
ORDER BY CHAR_LENGTH(path) DESC
LIMIT 1
|
| 0.4330 |
SELECT *
FROM www_blogs
WHERE blog_id IN (1)
|
| 1.3902 |
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.5791 |
SELECT option_name, option_value
FROM www_options
WHERE autoload = 'yes'
|
| 0.4230 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-allowed-plugins'
LIMIT 1
|
| 0.2201 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-default-theme'
LIMIT 1
|
| 0.1931 |
SELECT option_value
FROM www_options
WHERE option_name = 'health-check-current-theme'
LIMIT 1
|
| 0.4678 |
SELECT option_value
FROM www_options
WHERE option_name = 'wordpress_api_key'
LIMIT 1
|
| 0.3231 |
SELECT VERSION()
|
| 0.5441 |
SELECT option_value
FROM www_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
|
| 0.3641 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_notices'
LIMIT 1
|
| 0.2141 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_cache'
LIMIT 1
|
| 0.1900 |
SELECT option_value
FROM www_options
WHERE option_name = 'analyst_accounts_data'
LIMIT 1
|
| 0.9658 |
SHOW FULL COLUMNS
FROM `www_options`
|
| 0.5851 |
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.7670 |
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.2570 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_w'
LIMIT 1
|
| 0.2129 |
SELECT option_value
FROM www_options
WHERE option_name = 'embed_size_h'
LIMIT 1
|
| 0.3948 |
SELECT option_value
FROM www_options
WHERE option_name = 'sbi_oembed_token'
LIMIT 1
|
| 0.4468 |
SELECT option_value
FROM www_options
WHERE option_name = 'sb_instagram_errors'
LIMIT 1
|
| 0.4008 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'wpseo_ms'
AND site_id = 1
|
| 0.4940 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient_timeout___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.2429 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = '_site_transient___onecom_allowed_onecom-vcache'
AND site_id = 1
|
| 0.2389 |
SELECT meta_value
FROM www_sitemeta
WHERE meta_key = 'varnish_caching_enable'
AND site_id = 1
|
| 0.7021 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_doing_cron'
LIMIT 1
|
| 0.3130 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_doing_cron'
LIMIT 1
|
| 0.7701 |
INSERT INTO `www_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1603190519.6966319084167480468750', 'yes')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
| 0.2811 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_hosts'
LIMIT 1
|
| 0.1769 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_dynamic_host'
LIMIT 1
|
| 0.1462 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_stats_json_file'
LIMIT 1
|
| 0.1481 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_menu_save'
LIMIT 1
|
| 0.1731 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_purge_key'
LIMIT 1
|
| 0.1538 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_truncate_notice'
LIMIT 1
|
| 0.2019 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_override'
LIMIT 1
|
| 0.1540 |
SELECT option_value
FROM www_options
WHERE option_name = 'varnish_caching_ssl'
LIMIT 1
|
| 0.7460 |
DELETE
FROM `www_statistics_useronline`
WHERE timestamp < 1603197690
|
| 0.6270 |
UPDATE `www_options`
SET `option_value` = '1603197720'
WHERE `option_name` = 'wp_statistics_check_useronline'
|
| 0.6449 |
SELECT ID, post_name, post_parent, post_type
FROM www_posts
WHERE post_name IN ('linsoupconnable')
AND post_type IN ('page','attachment')
|
| 0.5341 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.post_name = 'linsoupconnable'
AND www_posts.post_type = 'post'
ORDER BY www_posts.post_date DESC
|
| 1.1969 |
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 (759)
ORDER BY t.name ASC
|
| 0.5350 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (759)
ORDER BY meta_id ASC
|
| 0.3371 |
SELECT option_value
FROM www_options
WHERE option_name = 'oc_cdn_enabled'
LIMIT 1
|
| 0.4702 |
SELECT *
FROM www_users
WHERE ID = '1'
LIMIT 1
|
| 0.4649 |
SELECT user_id, meta_key, meta_value
FROM www_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
|
| 0.7250 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '759'
AND `object_type` = 'post'
LIMIT 1
|
| 0.4580 |
SELECT *
FROM www_posts
WHERE ID = 582
LIMIT 1
|
| 0.3450 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (582)
ORDER BY meta_id ASC
|
| 0.9871 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '804'
AND `object_type` = 'post'
LIMIT 1
|
| 0.8330 |
SELECT *
FROM `www_yoast_indexable`
WHERE `object_id` = '894'
AND `object_type` = 'post'
LIMIT 1
|
| 0.6981 |
SELECT `ancestor_id`
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '163'
ORDER BY `depth` DESC
|
| 0.3271 |
DELETE
FROM `www_yoast_indexable_hierarchy`
WHERE `indexable_id` = '163'
|
| 0.3798 |
SELECT *
FROM www_posts
WHERE ID = 965
LIMIT 1
|
| 0.3240 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (965)
ORDER BY meta_id ASC
|
| 0.3669 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (970)
ORDER BY meta_id ASC
|
| 0.3169 |
SELECT *
FROM www_posts
WHERE ID = 970
LIMIT 1
|
| 0.3481 |
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.3140 |
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.1668 |
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.6109 |
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.5710 |
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.7770 |
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.7548 |
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
|
| 1.5259 |
SELECT post_id, meta_key, meta_value
FROM www_postmeta
WHERE post_id IN (853,851,839,799,792,770,767,762,756,753,619,749,745)
ORDER BY meta_id ASC
|
| 0.4439 |
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.2699 |
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.5469 |
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.6790 |
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 (759)
ORDER BY t.name ASC
|
| 0.2661 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (47,45,48)
ORDER BY meta_id ASC
|
| 0.5429 |
SELECT www_posts.*
FROM www_posts
WHERE 1=1
AND www_posts.post_name = '6c795fda60044e2890532e45b595ce09'
AND www_posts.post_type = 'oembed_cache'
AND ((www_posts.post_status = 'publish'))
ORDER BY www_posts.post_date DESC
|
| 0.3648 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date < '2020-05-15 11:59:38'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
| 0.3529 |
SELECT p.ID
FROM www_posts AS p
WHERE p.post_date > '2020-05-15 11:59:38'
AND p.post_type = 'post'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
| 0.8020 |
SELECT SQL_CALC_FOUND_ROWS www_comments.comment_ID
FROM www_comments
WHERE ( comment_approved = '1' )
AND comment_post_ID = 759
AND comment_parent = 0
ORDER BY www_comments.comment_date_gmt ASC, www_comments.comment_ID ASC
|
| 1.8520 |
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.4492 |
SELECT term_id, meta_key, meta_value
FROM www_termmeta
WHERE term_id IN (58,52,60,42,63,61,56,37,46,1,44,40,32,34)
ORDER BY meta_id ASC
|
| 0.3829 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_&sbi_delay_requests'
LIMIT 1
|
| 0.2351 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_&sbi_delay_requests'
LIMIT 1
|
| 0.3090 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_17841402078904351#20'
LIMIT 1
|
| 0.3979 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_17841402078904351#20'
LIMIT 1
|
| 0.2890 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_sbi_header_17841402078904351#20'
LIMIT 1
|
| 0.2730 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_sbi_header_17841402078904351#20'
LIMIT 1
|
| 0.8440 |
show tables like 'www_sbi_instagram_posts'
|
| 0.8318 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 1.5960 |
UPDATE www_sbi_instagram_posts
SET last_requested = '2020-10-20 10:42:01'
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.9789 |
show tables like 'www_sbi_instagram_posts'
|
| 0.9351 |
show tables like 'www_sbi_instagram_feeds_posts'
|
| 1.8740 |
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.3259 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_timeout_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.2151 |
SELECT option_value
FROM www_options
WHERE option_name = '_transient_wpmi-user-alfreda-hitchcock_and_sisters-1'
LIMIT 1
|
| 0.7231 |
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
|
