TrxShell [ woocommerce.addifypro.com ]

Name	Size	Permission
.config	[ DIR ]	drwx------
.cpaddons	[ DIR ]	drwxr-xr-x
.cpan	[ DIR ]	drwxr-xr-x
.cpanel	[ DIR ]	drwx------
.cphorde	[ DIR ]	drwx------
.htpasswds	[ DIR ]	drwxr-x---
.koality	[ DIR ]	drwxr-xr-x
.pkexec	[ DIR ]	drwxr-xr-x
.razor	[ DIR ]	drwxr-xr-x
.spamassassin	[ DIR ]	drwxr-xr-x
.subaccounts	[ DIR ]	drwx------
.trash	[ DIR ]	drwx------
.wp-cli	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
access-logs	[ DIR ]	drwxr-x---
addifypro.com	[ DIR ]	drwxr-xr-x
bin	[ DIR ]	drwxr-xr-x
cache	[ DIR ]	drwxr-xr-x
cpanel3-skel	[ DIR ]	drwxr-xr-x
cpmove_failed_mysql_dbs.163300...	[ DIR ]	drwx------
etc	[ DIR ]	drwxr-x---
home	[ DIR ]	drwxr-x---
logs	[ DIR ]	drwxr-xr-x
mail	[ DIR ]	drwxr-x--x
perl	[ DIR ]	drwxr-xr-x
perl5	[ DIR ]	drwxr-xr-x
php	[ DIR ]	drwxr-xr-x
public_ftp	[ DIR ]	drwxr-xr-x
public_html	[ DIR ]	drwxr-x---
quarantine	[ DIR ]	drwxr-xr-x
sessions	[ DIR ]	drwxr-xr-x
ssl	[ DIR ]	drwxr-xr-x
tmp	[ DIR ]	drwxr-xr-x
wordpress-backups	[ DIR ]	drwx------
www	[ DIR ]	drwxr-x---
.bash_history	8.85 KB	-rw-r--r--
.bash_logout	18 B	-rw-r--r--
.bash_profile	193 B	-rw-r--r--
.bashrc	636 B	-rw-r--r--
.contactemail	22 B	-rw-r--r--
.dns	13 B	-rw-r--r--
.lastlogin	634 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
.myimunify_id	102 B	-rw-rw----
.pearrc	598 B	-rw-r--r--
.rnd	1 KB	-rw-------
.spamassassinboxenable	0 B	-rw-r--r--
.spamassassinenable	0 B	-rw-r--r--
.viminfo	2.4 KB	-rw-------
.wp-toolkit-identifier	684 B	-rw-------
.zshrc	1.04 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
alf4.php	2.91 MB	-rw-r--r--
bcreate.php	5.86 KB	-rw-r--r--
bscan.php	28.1 KB	-rw-r--r--
hosts.sh	1.14 KB	-rw-rw-r--
malwarescan31-01.txt	55.73 MB	-rw-r--r--
propagation.sh	1.8 KB	-rw-rw-r--
pwnkit	10.99 KB	-rwxr-xr-x
slow-queries-06-Oct-2023.txt	23.89 KB	-rw-r--r--

Code Editor : slow-queries-06-Oct-2023.txt

select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables WHERE TABLE_SCHEMA IN ('addify5_addifytestimonial','addify5_addifyclientlogin','addify5_addifyattpro','addify5_tax_exempt','addify5_abandoned_cart','addify5_woo_badge_management','addify5_addifypaymentfee','addify5_addifycombinationsasproduct','addify5_price_calculator','addify5_woo_seo_demo','addify5_addifyaddtocartlisitng','addify5_addifyb2bregistration','addify5_reserve_stock','addify5_addifyproductbundles','addify5_woo_registration_forms_builder','addify5_cartplugin','addify5_enhanced_ecommerce','addify5_mage812','addify5_single_variation','addify5_gift_registery','addify5_custom_messages','addify5_testingpresta','addify5_expanses','addify5_address_auto_complete_free','addify5_wholesale_tiered_pricing','addify5_addifyrequestaquote','addify5_addifyregaddress','addify5_addifypasswordprotected','addify5_addifyadvancedshipping','addify5_woo_watermark','addify5_variation_table','addify5_addifycheckoutfields','addify5_addifybuynow','addify5_dynamic_pricing','addify5_woo_dynamic_pricing','addify5_live_push_notification','addify5_prestashop_1.7.8.8','addify5_addifydonationpresta','addify5_qa_testing','addify5_prestashop_8.1.0','addify5_assign_order','addify5_woo_order','addify5_addifydemo4','addify5_product_tabs','addify5_magetest','addify5_testing_demo','addify5_addifylimitorderpre','addify5_addifytablelisting','addify5_addifysalecounter','addify5_woo_social_media_demo','addify5_addifyautorole','addify5_presta4','addify5_country_restriction','addify5_wc_background','addify5_advanceqty','addify5_product_quantity','addify5_addify_website','addify5_extendhideprice','addify5_addifyprestashopdemo_8.0.4','addify5_qa_testing4','addify5_addifystockalert','addify5_wordpress','addify5_addifydemo','addify5_chakbasawa','addify5_moduletesting','addify5_free_gifts','addify5_addifyinstocksort','addify5_addifyreservation','addify5_autoaddress','addify5_role_based_pricing','addify5_addifyaccountpagecustomizer','addify5_user_registration_woo','addify5_addifynews','addify5_woo_wholesale_order_form','addify5_woo_donations','addify5_addifycancelorder','addify5_addifyultimatepack','addify5_woo_product_options','addify5_addifydemo4new','addify5_addifydemo5','addify5_prestashop_dev','addify5_prestashop_1.7.8.9','addify5_custom_fields','addify5_addifydemonew','addify5_woo_price_calculator','addify5_addifywatermark','addify5_variation_visibility','addify5_prestashop_8.0.4','addify5_addifypricebycountry','addify5_addifydisclaimer','addify5_addifydualprice','addify5_membership','addify5_fullcartplugin','addify5_order_tracking','addify5_pre_order','addify5_addifyfreegift','addify5_wishlist','addify5_quick_buy','addify5_testing_demo3','addify5_addifyprivateshop','addify5_addifypreorder','addify5_addifymenu','addify5_order_number','addify5_addifycustomstockstatus','addify5_invoice_payment_method','addify5_seonofollow','addify5_wordpress_demos','addify5_product_videos2','addify5_addifyproductvariationtable','addify5_menu_visibility','addify5_dev_presta','addify5_magentodemo','addify5_addifylimitorder','addify5_addifyrefundpresta','addify5_single_variation_and_dropdown','addify5_addifydemo3','addify5_woo.new','addify5_back_in_stock','addify5_woo_hide_price','addify5_addifyshippingcalculator','addify5_support_demo','addify5_addifydemo1new','addify5_prestashop_8.0.0','addify5_addifygooglesheetconnector','addify5_addifypricebygroup','addify5_demofinaltesting','addify5_admin-prestadev','addify5_addifycustominvoicenumber','addify5_addifyprestatesting','addify5_addifydelieverydate','addify5_addifyrestrict','addify5_store_locator','addify5_addifyshippingcounter','addify5_addifyrolebasedtax','addify5_testing_demo2','addify5_addifydemo2','addify5_addifyinvoicepayment','addify5_addifycountryrestriction','addify5_products_visibility','addify5_b2b','addify5_php8testing','addify5_addifytestingprestademo','addify5_invoice_payment_gateway_free','addify5_addifyredirect','addify5_qa_testing3','addify5_multiple_email_addresses','addify5_woo_checkout_fields','addify5_edit_order','addify5_quick_view_free','addify5_qa_testing2','addify5_woo_brands','addify5_custom_stock_status','addify5_automatic_role_changer','addify5_addifytaxexempt','addify5_addifydemo6','addify5_woo_restrictions','addify5_addifygeolocationredirect','addify5_addifyhideprice','addify5_addifyadvanceurl','addify5_addifydemo1','addify5_advance_cod','addify5_addifydemo7','addify5_addifytextprice','addify5_addifydemo3new','addify5_addifydemo2new','addify5_addifytimer','addify5_order_and_cart_restrictions','addify5_addifyb2b','addify5_order_approval','addify5_addifyregistrationfields','addify5_addifycustomprice','addify5_addifyavailabilityscheduler','addify5_visionsoft_old','addify5_addifyquickordertable') GROUP BY TABLE_SCHEMA;
# Time: 2023-10-02T10:45:56.236227Z
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables WHERE TABLE_SCHEMA IN ('addify5_reserve_stock','addify5_addifyproductbundles','addify5_woo_registration_forms_builder','addify5_cartplugin','addify5_addifycombinationsasproduct','addify5_addifypaymentfee','addify5_price_calculator','addify5_woo_seo_demo','addify5_addifyaddtocartlisitng','addify5_addifyb2bregistration','addify5_addifyclientlogin','addify5_tax_exempt','addify5_addifyattpro','addify5_abandoned_cart','addify5_woo_badge_management','addify5_addifytestimonial','addify5_expanses','addify5_address_auto_complete_free','addify5_wholesale_tiered_pricing','addify5_addifyregaddress','addify5_addifyrequestaquote','addify5_single_variation','addify5_mage812','addify5_gift_registery','addify5_custom_messages','addify5_testingpresta','addify5_enhanced_ecommerce','addify5_assign_order','addify5_woo_order','addify5_product_tabs','addify5_addifydemo4','addify5_prestashop_1.7.8.8','addify5_addifydonationpresta','addify5_qa_testing','addify5_prestashop_8.1.0','addify5_woo_dynamic_pricing','addify5_dynamic_pricing','addify5_live_push_notification','addify5_addifypasswordprotected','addify5_addifyadvancedshipping','addify5_woo_watermark','addify5_variation_table','addify5_addifycheckoutfields','addify5_addifybuynow','addify5_advanceqty','addify5_product_quantity','addify5_addify_website','addify5_extendhideprice','addify5_wc_background','addify5_addifyautorole','addify5_presta4','addify5_country_restriction','addify5_magetest','addify5_addifylimitorderpre','addify5_testing_demo','addify5_addifytablelisting','addify5_addifysalecounter','addify5_woo_social_media_demo','addify5_autoaddress','addify5_role_based_pricing','addify5_addifyaccountpagecustomizer','addify5_user_registration_woo','addify5_moduletesting','addify5_free_gifts','addify5_addifyinstocksort','addify5_addifyreservation','addify5_addifystockalert','addify5_wordpress','addify5_addifydemo','addify5_chakbasawa','addify5_addifyprestashopdemo_8.0.4','addify5_qa_testing4','addify5_addifycancelorder','addify5_addifyultimatepack','addify5_addifyprestashop_8.1.0','addify5_woo_product_options','addify5_woo_wholesale_order_form','addify5_woo_donations','addify5_addifynews','addify5_woo_price_calculator','addify5_addifywatermark','addify5_variation_visibility','addify5_prestashop_1.7.8.9','addify5_addifydemonew','addify5_custom_fields','addify5_addifydemo5','addify5_prestashop_dev','addify5_addifydemo4new','addify5_wishlist','addify5_addifyfreegift','addify5_pre_order','addify5_order_tracking','addify5_prestashop_8.0.4','addify5_addifypricebycountry','addify5_addifydualprice','addify5_membership','addify5_addifydisclaimer','addify5_fullcartplugin','addify5_product_videos2','addify5_addifyproductvariationtable','addify5_invoice_payment_method','addify5_seonofollow','addify5_wordpress_demos','addify5_addifymenu','addify5_addifypreorder','addify5_order_number','addify5_addifycustomstockstatus','addify5_quick_buy','addify5_testing_demo3','addify5_addifyprivateshop','addify5_single_variation_and_dropdown','addify5_addifylimitorder','addify5_addifyrefundpresta','addify5_dev_presta','addify5_magentodemo','addify5_menu_visibility','addify5_addifygooglesheetconnector','addify5_addifypricebygroup','addify5_demofinaltesting','addify5_admin-prestadev','addify5_addifyshippingcalculator','addify5_support_demo','addify5_addifydemo1new','addify5_prestashop_8.0.0','addify5_woo.new','addify5_back_in_stock','addify5_woo_hide_price','addify5_addifydemo3','addify5_addifyrolebasedtax','addify5_addifyshippingcounter','addify5_testing_demo2','addify5_addifydemo2','addify5_addifydelieverydate','addify5_addifyprestatesting','addify5_addifyrestrict','addify5_store_locator','addify5_addifycustominvoicenumber','addify5_invoice_payment_gateway_free','addify5_addifyredirect','addify5_qa_testing3','addify5_php8testing','addify5_addifytestingprestademo','addify5_addifycountryrestriction','addify5_products_visibility','addify5_b2b','addify5_addifyinvoicepayment','addify5_addifytaxexempt','addify5_addifydemo6','addify5_woo_restrictions','addify5_custom_stock_status','addify5_automatic_role_changer','addify5_woo_brands','addify5_multiple_email_addresses','addify5_woo_checkout_fields','addify5_quick_view_free','addify5_edit_order','addify5_qa_testing2','addify5_addifydemo3new','addify5_addifytextprice','addify5_addifydemo1','addify5_advance_cod','addify5_addifydemo7','addify5_addifygeolocationredirect','addify5_addifyhideprice','addify5_addifyadvanceurl','addify5_visionsoft_old','addify5_addifyquickordertable','addify5_order_approval','addify5_addifyregistrationfields','addify5_addifycustomprice','addify5_addifyavailabilityscheduler','addify5_addifyb2b','addify5_addifydemo2new','addify5_addifytimer','addify5_order_and_cart_restrictions') GROUP BY TABLE_SCHEMA;
/usr/sbin/mysqld, Version: 5.7.43-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
# Time: 2023-10-02T13:36:54.256823Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3333
# Query_time: 3.970035  Lock_time: 0.000464 Rows_sent: 6656  Rows_examined: 173695
use addify5_testing_demo3;
SET timestamp=1696253814;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:37:02.995211Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3348
# Query_time: 3.999118  Lock_time: 0.000447 Rows_sent: 6539  Rows_examined: 171099
SET timestamp=1696253822;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND (((wp_posts.post_title LIKE '%l%') OR (wp_posts.post_excerpt LIKE '%l%') OR (wp_posts.post_content LIKE '%l%')))  AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:37:06.235195Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3357
# Query_time: 3.824415  Lock_time: 0.000335 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696253826;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:37:24.042201Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3377
# Query_time: 3.860422  Lock_time: 0.000523 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696253844;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:37:29.766049Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3384
# Query_time: 3.833336  Lock_time: 0.000188 Rows_sent: 6593  Rows_examined: 172425
SET timestamp=1696253849;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND (((wp_posts.post_title LIKE '%a%') OR (wp_posts.post_excerpt LIKE '%a%') OR (wp_posts.post_content LIKE '%a%')))  AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:40:11.395210Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3534
# Query_time: 4.144797  Lock_time: 0.000269 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696254011;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:40:11.924150Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3535
# Query_time: 3.939459  Lock_time: 0.000243 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696254011;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:42:13.285437Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  3702
# Query_time: 3.822329  Lock_time: 0.000240 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696254133;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
# Time: 2023-10-02T13:52:11.478950Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id:  4234
# Query_time: 3.868755  Lock_time: 0.000255 Rows_sent: 6656  Rows_examined: 173695
SET timestamp=1696254731;
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 (2,3,5) 
    OR 
    NOT EXISTS (
					SELECT 1
					FROM wp_term_relationships
					INNER JOIN wp_term_taxonomy
					ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
					WHERE wp_term_taxonomy.taxonomy = 'product_type'
					AND wp_term_relationships.object_id = wp_posts.ID
				)
  )
) AND wp_posts.post_type IN ('product_variation', 'product') AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.post_date DESC;
/usr/sbin/mysqld, Version: 5.7.43-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
# Time: 2023-10-05T12:15:15.550867Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63727
# Query_time: 8.050734  Lock_time: 1.069799 Rows_sent: 1  Rows_examined: 1
use addify5_qa_testing;
SET timestamp=1696508115;
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
# Time: 2023-10-05T12:16:26.523225Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63727
# Query_time: 70.701065  Lock_time: 39.707274 Rows_sent: 1  Rows_examined: 1
SET timestamp=1696508186;
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;
# Time: 2023-10-05T12:17:25.365430Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63727
# Query_time: 47.525619  Lock_time: 5.365698 Rows_sent: 1  Rows_examined: 1
SET timestamp=1696508245;
SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;
# Time: 2023-10-05T12:18:05.051718Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63731
# Query_time: 8.260477  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508285;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:18:31.908472Z
# User@Host: addify5_magento[addify5_magento] @ localhost []  Id: 63728
# Query_time: 186.470099  Lock_time: 77.088581 Rows_sent: 9  Rows_examined: 18
use addify5_magetest;
SET timestamp=1696508311;
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
# Time: 2023-10-05T12:18:35.632613Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63731
# Query_time: 22.366707  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508315;
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci';
# Time: 2023-10-05T12:18:42.703853Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63733
# Query_time: 18.914789  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508322;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:19:24.752806Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63731
# Query_time: 36.143537  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1696508364;
SELECT @@SESSION.sql_mode;
# Time: 2023-10-05T12:19:26.110523Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63733
# Query_time: 23.364435  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508366;
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci';
# Time: 2023-10-05T12:19:44.588204Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63731
# Query_time: 12.717546  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
use addify5_testing_demo3;
SET timestamp=1696508384;
# administrator command: Init DB;
# Time: 2023-10-05T12:20:06.789764Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63733
# Query_time: 25.494501  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1696508406;
SELECT @@SESSION.sql_mode;
# Time: 2023-10-05T12:20:54.010311Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63740
# Query_time: 5.508488  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508454;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:21:12.252687Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63740
# Query_time: 15.251636  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508472;
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci';
# Time: 2023-10-05T12:21:33.462581Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63741
# Query_time: 8.400080  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508493;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:21:38.946063Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63731
# Query_time: 95.240233  Lock_time: 11.635878 Rows_sent: 29  Rows_examined: 29
SET timestamp=1696508498;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 2023-10-05T12:21:53.680666Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63740
# Query_time: 36.457084  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1696508513;
SELECT @@SESSION.sql_mode;
# Time: 2023-10-05T12:22:08.929129Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63741
# Query_time: 8.006929  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1696508528;
SELECT @@SESSION.sql_mode;
# Time: 2023-10-05T12:22:23.128608Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63751
# Query_time: 10.408728  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508543;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:22:35.153345Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63750
# Query_time: 11.515938  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508555;
SET NAMES utf8mb4;
# Time: 2023-10-05T12:22:47.393674Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63751
# Query_time: 13.682479  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1696508567;
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci';
# Time: 2023-10-05T12:25:16.896767Z
# User@Host: addify5_demos[addify5_demos] @ localhost []  Id: 63741
# Query_time: 167.284718  Lock_time: 19.481778 Rows_sent: 147  Rows_examined: 147
SET timestamp=1696508716;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
/usr/sbin/mysqld, Version: 5.7.43-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.7.43-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument

${this.title}

Code Editor : slow-queries-06-Oct-2023.txt