Tech Tips: Saving Time

Did you know all of these little hacks?

Are they really helpful? Or is taking the “long way” just as easy? Tell us what you think!

INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1632739906.1410260200500488281250', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

SELECT aoit_wp_posts.* FROM aoit_wp_posts WHERE 1=1 AND ( ( YEAR( aoit_wp_posts.post_date ) = 2015 AND MONTH( aoit_wp_posts.post_date ) = 11 AND DAYOFMONTH( aoit_wp_posts.post_date ) = 4 ) ) AND aoit_wp_posts.post_name = 'tech-tips-november-4-saving-time' AND aoit_wp_posts.post_type = 'post' ORDER BY aoit_wp_posts.post_date DESC

SELECT t.*, tt.* FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (1090) ORDER BY t.name ASC

SELECT aoit_wp_posts.* FROM aoit_wp_posts WHERE 1=1 AND aoit_wp_posts.ID IN (4416,4417,4421,4422,4431,4432,4433,4434,4435,4436,4439,4443,4447,4458,4466,4467,4478,4479,4480,4483,4571,4609,4716,4717,4718) AND aoit_wp_posts.post_type = 'nav_menu_item' AND ((aoit_wp_posts.post_status = 'publish')) ORDER BY aoit_wp_posts.menu_order ASC

SELECT t.term_id, tt.parent, tt.count, tt.taxonomy FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1090) ORDER BY t.name ASC

SELECT t.*, tt.* FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1090) ORDER BY t.name ASC

SELECT t.*, tt.* FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (1090) ORDER BY t.name ASC

SELECT SQL_CALC_FOUND_ROWS aoit_wp_comments.comment_ID FROM aoit_wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1090 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY aoit_wp_comments.comment_date_gmt ASC, aoit_wp_comments.comment_ID ASC

[0] => themes/onepress/inc/class-config.php [1] => themes/onepress/inc/sanitize.php [2] => themes/onepress/inc/metabox.php [3] => themes/onepress/inc/template-tags.php [4] => themes/onepress/inc/extras.php [5] => themes/onepress/inc/class-sections-navigation.php [6] => themes/onepress/inc/customizer.php [7] => themes/onepress/inc/customizer-selective-refresh.php [8] => themes/onepress/inc/admin/dashboard.php [9] => themes/onepress/inc/admin/class-editor.php [10] => themes/onepress/single.php [11] => themes/onepress/header.php [12] => themes/onepress/template-parts/content-single.php [13] => themes/onepress/comments.php [14] => themes/onepress/footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/2015/11/04/tech-tips-november-4-saving-time/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', '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_CONNECTION' => 'Keep-Alive', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.apexaoit.com', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'YVGiP-XwGRJ9ObQYyIUHKwAAAMw', 'REDIRECT_SCRIPT_URL' => '/2015/11/04/tech-tips-november-4-saving-time/', 'REDIRECT_SCRIPT_URI' => 'https://www.apexaoit.com/2015/11/04/tech-tips-november-4-saving-time/', 'REDIRECT_GD-USERNAME' => 'apexaoit', 'REDIRECT_W3TC_SSL' => '_ssl', 'REDIRECT_W3TC_ENC' => '_gzip', 'REDIRECT_HTTP_AUTHORIZATION' => '', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'www.apexaoit.com', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'YVGiP-XwGRJ9ObQYyIUHKwAAAMw', 'SCRIPT_URL' => '/2015/11/04/tech-tips-november-4-saving-time/', 'SCRIPT_URI' => 'https://www.apexaoit.com/2015/11/04/tech-tips-november-4-saving-time/', 'GD-USERNAME' => 'apexaoit', 'W3TC_SSL' => '_ssl', 'W3TC_ENC' => '_gzip', 'HTTP_AUTHORIZATION' => '', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.apexaoit.com', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.apexaoit.com', 'SERVER_ADDR' => '107.180.24.236', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '35.172.203.87', 'DOCUMENT_ROOT' => '/home/apexaoit/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home/apexaoit/public_html', 'SERVER_ADMIN' => 'webmaster@apexaoit.com', 'SCRIPT_FILENAME' => '/home/apexaoit/public_html/index.php', 'REMOTE_PORT' => '48880', 'REDIRECT_URL' => '/2015/11/04/tech-tips-november-4-saving-time/', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1632739903.738339900970458984375, 'REQUEST_TIME' => 1632739903, );

0.4320	`SELECT option_value FROM aoit_wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1`
0.7000	INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1632739906.1410260200500488281250', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
10.5181	`SELECT aoit_wp_posts.* FROM aoit_wp_posts WHERE 1=1 AND ( ( YEAR( aoit_wp_posts.post_date ) = 2015 AND MONTH( aoit_wp_posts.post_date ) = 11 AND DAYOFMONTH( aoit_wp_posts.post_date ) = 4 ) ) AND aoit_wp_posts.post_name = 'tech-tips-november-4-saving-time' AND aoit_wp_posts.post_type = 'post' ORDER BY aoit_wp_posts.post_date DESC`
0.8721	`SELECT * FROM aoit_wp_posts WHERE ID = 1090 LIMIT 1`
0.7360	`SELECT post_id, meta_key, meta_value FROM aoit_wp_postmeta WHERE post_id IN (1090) ORDER BY meta_id ASC`
0.8061	`SELECT post_id, meta_key, meta_value FROM aoit_wp_postmeta WHERE post_id IN (4104) ORDER BY meta_id ASC`
0.5031	`SELECT * FROM aoit_wp_posts WHERE ID = 4104 LIMIT 1`
8.2879	`SELECT t., tt. FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (1090) ORDER BY t.name ASC`
1.0219	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (62) ORDER BY meta_id ASC`
8.6958	`SELECT aoit_wp_posts.* FROM aoit_wp_posts WHERE 1=1 AND aoit_wp_posts.ID IN (4416,4417,4421,4422,4431,4432,4433,4434,4435,4436,4439,4443,4447,4458,4466,4467,4478,4479,4480,4483,4571,4609,4716,4717,4718) AND aoit_wp_posts.post_type = 'nav_menu_item' AND ((aoit_wp_posts.post_status = 'publish')) ORDER BY aoit_wp_posts.menu_order ASC`
2.7790	`SELECT t.term_id, tt.parent, tt.count, tt.taxonomy FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1090) ORDER BY t.name ASC`
8.2860	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (50) ORDER BY meta_id ASC`
1.1132	`SELECT t., tt. FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1090) ORDER BY t.name ASC`
0.9470	`SELECT t., tt. FROM aoit_wp_terms AS t INNER JOIN aoit_wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN aoit_wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (1090) ORDER BY t.name ASC`
0.6239	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (64,66,63,65) ORDER BY meta_id ASC`
0.9370	`SELECT SQL_CALC_FOUND_ROWS aoit_wp_comments.comment_ID FROM aoit_wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1090 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY aoit_wp_comments.comment_date_gmt ASC, aoit_wp_comments.comment_ID ASC`
10.8919	`SELECT * FROM aoit_wp_ays_pb`

Share this:

Leave a Reply Cancel reply