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', '1679410769.3784060478210449218750', '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_IF_MODIFIED_SINCE' => 'Tue, 29 Nov 2022 11:48:45 GMT', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'ZBnGULSDYz-IRmyrQz-PgwAAAIk', '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' => 'ZBnGULSDYz-IRmyrQz-PgwAAAIk', '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' => '34.239.152.207', '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' => '49872', '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' => 1679410768.804378986358642578125, 'REQUEST_TIME' => 1679410768, );

1.0478	`SELECT option_value FROM aoit_wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1`
1.3661	INSERT INTO `aoit_wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1679410769.3784060478210449218750', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
1.0679	`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`
5.2929	`SELECT * FROM aoit_wp_posts WHERE ID = 1090 LIMIT 1`
0.6039	`SELECT post_id, meta_key, meta_value FROM aoit_wp_postmeta WHERE post_id IN (1090) ORDER BY meta_id ASC`
0.2029	`SELECT post_id, meta_key, meta_value FROM aoit_wp_postmeta WHERE post_id IN (4104) ORDER BY meta_id ASC`
0.5150	`SELECT * FROM aoit_wp_posts WHERE ID = 4104 LIMIT 1`
0.4430	`SELECT * FROM aoit_wp_posts WHERE ID = 3359 LIMIT 1`
1.6599	`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`
0.4699	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (62) ORDER BY meta_id ASC`
0.2332	`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`
1.1780	`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`
0.7792	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (50) ORDER BY meta_id ASC`
1.6689	`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`
1.1771	`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`
1.0409	`SELECT term_id, meta_key, meta_value FROM aoit_wp_termmeta WHERE term_id IN (64,66,63,65) ORDER BY meta_id ASC`
1.6191	`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.2601	`SELECT * FROM aoit_wp_ays_pb`

Share this:

Leave a Reply Cancel reply