Eli's WordPress Blog

My WordPress Plugins, and other stuff.

Main menu

Skip to primary content
Skip to secondary content
  • All Posts
  • Anti-Malware
  • Google Analytics
  • Related Posts
  • SHORTcURL
  • SQL Reports

Category Archives: Google Analytics

New plugin – EZ Google Analytics

Posted on October 8, 2014 by Eli Scheetz
3

This plugin includes your Google Analytics tracking code on your pages and posts.

Download it here: wordpress.org

Posted in Google Analytics | Tagged analytics, Google, plugins, WordPress | 3 Replies

Archives

Recomended Software

  • SpiderOak SpiderOak
  • Ubuntu Ubuntu
Proudly powered by WordPress2011 Child Theme by
  Globals Profiler (1,034.74 ms) SQL (94 queries in 15.98 ms) Errors (0) Toggle Close
$_GET = array (
);

$_POST = array (
);

$_COOKIE = array (
);

$_SESSION = array (
  'GOTMLS_SESSION_LAST' => 0,
  'GOTMLS_SESSION_TIME' => 1701519285.830196,
  'GOTMLS_detected_attacks' => '',
  'GOTMLS_login_attempts' => 0,
);

$_SERVER = array (
  'SERVER_SOFTWARE' => 'Apache',
  'REQUEST_URI' => '/category/my-plugins/google-analytics/',
  'CONTEXT_DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html',
  'CONTEXT_PREFIX' => '',
  'DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_AUTHORIZATION' => '',
  'HTTP_CONNECTION' => 'Keep-Alive',
  'HTTP_HOST' => 'wordpress.ieonly.com',
  'HTTP_IF_MODIFIED_SINCE' => 'Sun, 28 May 2023 19:41:45 GMT',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'PATH' => '/bin',
  'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
  'QUERY_STRING' => '',
  'REDIRECT_HTTP_AUTHORIZATION' => '',
  'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_UNIQUE_ID' => 'ZWsftcdlohWMUQGaeFjaLgAAAIc',
  'REDIRECT_URL' => '/category/my-plugins/google-analytics/',
  'REMOTE_ADDR' => '44.220.249.141',
  'REMOTE_PORT' => '35966',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'http',
  'SCRIPT_FILENAME' => '/home/elijah/sites/wordpress.ieonly.com/public_html/index.php',
  'SCRIPT_NAME' => '/index.php',
  'SERVER_ADDR' => '158.69.23.200',
  'SERVER_ADMIN' => 'root@localhost',
  'SERVER_NAME' => 'wordpress.ieonly.com',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'UNIQUE_ID' => 'ZWsftcdlohWMUQGaeFjaLgAAAIc',
  'dont_vary' => '1',
  'no_gzip' => '1',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1701519285.813925,
  'REQUEST_TIME' => 1701519285,
);

Profiler Initiaded 0.0000 ms 37461 kB
Profiler Noise 0.0041 ms 37461 kB
Profiler Stopped 1,034.7421 ms 95892 kB
0.2499 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
0.1180 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
0.1309 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/1701519285.9452' LIMIT 1;
0.2320 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
0.1240 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
0.1738 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
0.2720 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
0.1659 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
0.1540 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
0.1440 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
0.1462 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
0.1190 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
0.1321 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
0.1490 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
0.0939 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
0.1121 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
0.1070 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
0.0899 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
0.0751 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
0.0880 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
0.0999 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
0.1650 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
0.0889 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
2.3980 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
0.1380 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
0.1400 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
0.2460 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
0.0932 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
0.1221 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
0.0858 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
0.0958 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
0.1678 [ms]
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
0.0980 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
0.0951 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
0.1180 [ms]
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
0.0951 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
0.0861 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
0.2060 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
0.1280 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
0.0811 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
0.1240 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
0.1290 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
0.0861 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
0.0560 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
0.0551 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
0.0529 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
0.0501 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
0.0620 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
0.0770 [ms]
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;
0.0730 [ms]
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
0.0808 [ms]
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
0.0861 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;
0.0839 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;
0.0820 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;
0.0820 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
0.0880 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
0.0560 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
0.0520 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
0.5150 [ms]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1701519286.3077030181884765625000', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
0.3219 [ms]

			SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('category') AND t.slug IN ('google-analytics')
			
			
		;
0.1838 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (103);
0.1450 [ms]

			SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('category') AND t.term_id IN ( 103 )
			
			
		;
0.1490 [ms]

			SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('category') AND t.slug IN ('google-analytics')
			
			LIMIT 1
		;
0.2770 [ms]

					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
					WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (106)
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')))
					GROUP BY wp_posts.ID
					ORDER BY wp_posts.post_date DESC
					LIMIT 0, 10
				;
0.0911 [ms]
SELECT FOUND_ROWS();
0.1440 [ms]
SELECT wp_posts.* FROM wp_posts WHERE ID IN (607);
0.1259 [ms]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (607) ORDER BY meta_id ASC;
0.2649 [ms]

			SELECT DISTINCT t.term_id, tr.object_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.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', 'post_format') AND tr.object_id IN (607)
			ORDER BY t.name ASC
			
		;
0.2360 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (54,17,16,108);
0.1390 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '44.220.249.141';
0.1180 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'CCBot/2.0 (https://commoncrawl.org/faq/)';
0.1090 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';
0.0751 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/category/my-plugins/google-analytics/';
0.6220 [ms]
INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-12',
46447, 7541, 16079, 220, '2023-12-02 12:14:46', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-12-02 12:14:46', wp_user = 0, hit_count = hit_count +
1;
0.1121 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
0.0880 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
0.0629 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
0.1280 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;
0.1061 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
0.1709 [ms]
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
0.1190 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
0.0958 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
0.1709 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 105;
0.2708 [ms]

			SELECT   wp_posts.*
			FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
			WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (108)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.menu_order ASC
			
		;
0.3710 [ms]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (620,623,624,626,628,629) ORDER BY meta_id ASC;
0.1979 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (44,21,84,35);
0.3080 [ms]
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
0.1321 [ms]
SELECT * FROM wp_users WHERE ID IN (1);
0.1860 [ms]

			SELECT DISTINCT t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
			WHERE tt.taxonomy IN ('category') AND tr.object_id IN (607)
			ORDER BY t.name ASC
			
		;
0.2341 [ms]
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 ;
0.1550 [ms]

					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts 
					WHERE 1=1  AND ( 
  ( YEAR( wp_posts.post_date ) = 2022 AND MONTH( wp_posts.post_date ) = 12 )
) AND ( 
  YEAR( wp_posts.post_date ) < 2023
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')))
					
					ORDER BY wp_posts.post_date ASC
					LIMIT 0, 15
				;
0.1509 [ms]

			SELECT  t.term_id
			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 t.term_id IN ( 43 ) AND tt.count > 0
			ORDER BY t.name ASC
			
		;
0.1540 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (43);
0.2482 [ms]
SELECT *    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 = 43 ) AND taxonomy = 'link_category'    ORDER BY
link_name ASC;