Forum

Thread tagged as: Problem, Runway, Shop

PHP7 update slowdown

Hi,

I have updated my staging site to PHP7, and it seems to be running a lot slower! My diagnostics pre and post update are below, along with debug from the same sample page. I am not sure if I am missing an extension or something, but it seems to be a lot worse. If you had any insight as to why that may be that would be great.

Many thanks

Mike

PHP5.6 - Diagnostics

Perch Runway: 2.8.34
Production mode: Development (10)
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0), perch_forms (1.8.3), perch_shop_orders (1.0.11), perch_shop_products (1.0.11), perch_shop (1.0.11), perch_members (1.5), perch_mailchimp (3.0.1), perch_twitter (3.6.2)
DB driver: PDO
DB tables: watches_backup_plans (1), watches_backup_resources (520), watches_backup_runs (113), watches_blog_authors (6), watches_blog_comments (0), watches_blog_index (1445), watches_blog_posts (41), watches_blog_posts_to_tags (0), watches_blog_sections (1), watches_blog_tags (0), watches_blogs (1), watches_categories (24), watches_category_counts (5), watches_category_sets (4), watches_collection_index (0), watches_collection_items (0), watches_collection_revisions (0), watches_collections (0), watches_content_index (5284), watches_content_items (215), watches_content_regions (45), watches_forms (0), watches_forms_responses (0), watches_mailchimp_campaigns (9), watches_mailchimp_imports (0), watches_mailchimp_lists (1), watches_mailchimp_subscribers (163), watches_mailchimp_subscriptions (163), watches_mailchimp_webhooks (4), watches_members (610), watches_members_forms (4), watches_members_member_tags (0), watches_members_sessions (6), watches_members_tags (2), watches_navigation (0), watches_navigation_pages (0), watches_page_routes (24), watches_page_templates (32), watches_pages (43), watches_resource_log (5360), watches_resource_tags (0), watches_resources (7531), watches_resources_to_tags (0), watches_scheduled_tasks (40), watches_settings (42), watches_shop_addresses (3853), watches_shop_admin_index (74), watches_shop_brands (1), watches_shop_cart (198488), watches_shop_cart_data (393), watches_shop_cart_items (1964), watches_shop_countries (250), watches_shop_currencies (152), watches_shop_customers (817), watches_shop_emails (1), watches_shop_index (10256), watches_shop_option_values (0), watches_shop_options (0), watches_shop_order_items (1214), watches_shop_order_promotions (230), watches_shop_order_statuses (11), watches_shop_orders (587), watches_shop_orders_meta (1), watches_shop_product_files (0), watches_shop_product_option_values (0), watches_shop_product_options (0), watches_shop_product_tags (0), watches_shop_products (77), watches_shop_promotions (7), watches_shop_search (84), watches_shop_shipping_zone_countries (206), watches_shop_shipping_zones (12), watches_shop_shippings (2), watches_shop_tax_exhibits (1917), watches_shop_tax_group_rates (1), watches_shop_tax_groups (2), watches_shop_tax_locations (1), watches_shop_tax_rates (1), watches_shop_variants (0), watches_twitter_scheduled_tweets (0), watches_twitter_settings (1), watches_twitter_tweets (0), watches_user_passwords (1), watches_user_privileges (81), watches_user_role_privileges (16), watches_user_roles (2), watches_users (13)
Users: 13
PHPMailer: 5.2.21
App runtimes:
<?php
    $apps_list = array(
        'content',
        'categories',
        'perch_forms',
        'perch_mailchimp',
        'perch_twitter',
        'perch_members',
        'perch_shop',
        'perch_blog'
    );
Scheduled tasks for perch_twitter: post_tweets (1 mins)
Scheduled tasks for perch_mailchimp: import_data (1 mins)
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Scheduled tasks for Backup: plan_1 (10 mins)
Editor plug-ins: markitup
H1: fa6195f1bb69ec2df63932ad0bf2d19d
L1: 5a46b657baffcbfca32f8fe1d2036f54
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
headerColour: #ca0000
content_singlePageEdit: 1
helpURL:
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.31: done
perch_twitter_update: 3.5
headerScheme: dark
update_runway_2.8.31: done
latest_version: 2.8.15
on_sale_version: 2.8.34
hide_pwd_reset: 1
dashboard: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
perch_shop_update: 1.0.11
perch_mailchimp_api_key: b8e0b18debe717ba1efe75f01703f85b-us12
perch_mailchimp_campaign_url: /mailchimp/campaign/{campaignSlug}
perch_shop_price_tax_mode: inc
perch_shop_trade_price_tax_mode: exc
perch_shop_site_url: https://newgatewatches.com
perch_shop_product_url: /shop/products/{slug}
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: #%d
perch_members_login_page: /members/login.php?r={returnURL}
perch_mailchimp_secret: 1c40981
perch_members_update: 1.4
logoPath: /admin/resources/perch-logo-1.png
perch_blog_update: 5.0.1
perch_blog_post_url: /magazine/{postSlug}
perch_blog_site_name:
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
perch_blog_max_spam_days: 0
perch_blog_comment_notify: 0
update_runway_2.8.32: done
siteURL: https://newgatewatches.com
update_runway_2.8.34: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: /Volumes/Data/g Websites/newgatewatches/newgate-watches
PERCH_SCHEDULE_SECRET: UehFD0ambiReSATQ
PERCH_DB_USERNAME: newgated_watches
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: newgated_watches
PERCH_EMAIL_METHOD: smtp
PERCH_EMAIL_HOST: mailtrap.io
PERCH_EMAIL_SECURE: tls
PERCH_EMAIL_AUTH: 1
PERCH_EMAIL_PORT: 2525
PERCH_EMAIL_USERNAME: 42004aa368a4f9d32
PERCH_DEBUG: 1
PERCH_PRODUCTION_MODE: 10
PERCH_DB_PREFIX: watches_
PERCH_EMAIL_FROM: sales@newgatewatches.com
PERCH_EMAIL_FROM_NAME: Newgate Watches
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/newgatedev/public_html/watches/admin
PERCH_CORE: /home/newgatedev/public_html/watches/admin/core
PERCH_RESFILEPATH: /home/newgatedev/public_html/watches/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_HTML5: 1
PERCH_TZ: UTC
PERCH_SSL: 1
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/newgatedev/public_html/watches/admin/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_SHOP_VERSION: 1.0.11
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.6.29
Zend: 2.6.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.5.52-cll
Free disk space: 3.32 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, bcmath, calendar, ctype, curl, dom, fileinfo, ftp, gd, iconv, imap, json, mbstring, mysqlnd, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, SimpleXML, sockets, sqlite3, tokenizer, xml, wddx, xmlreader, xmlwriter, xsl, mhash, ionCube Loader
GD: Yes
ImageMagick: No
PHP max upload size: 128M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 8M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
CONTEXT_DOCUMENT_ROOT: /home/newgatedev/public_html/watches
DOCUMENT_ROOT: /home/newgatedev/public_html/watches
GATEWAY_INTERFACE: CGI/1.1
HTTPS: on
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch, br
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8,fr;q=0.6,it;q=0.4
HTTP_CACHE_CONTROL: no-cache
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: cookieconsent_dismissed=yes; cmsa=1; cpsession=newgatedev%3aUti59eWH6IwGfzKJ%2cfef28841187cb038d46331c7022237a9; _gat=1; _ga=GA1.3.461211912.1485259148; timezone=Europe/London; whostmgrsession=root%3ay3BgfFFJM0OMhC71%2c542b939e059f42d0b0bd2a28a05d4552; PHPSESSID=dj1oguac80f3t4kkln5s3na511
HTTP_HOST: watches.newgatedevelopment.co.uk
HTTP_PRAGMA: no-cache
HTTP_REFERER: https://watches.newgatedevelopment.co.uk/admin/core/settings/diagnostics/
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36
PATH: /bin:/usr/bin
QUERY_STRING: extended
REDIRECT_STATUS: 200
REMOTE_ADDR: 81.149.203.81
REMOTE_PORT: 56985
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_URI: /admin/core/settings/diagnostics/?extended
SCRIPT_FILENAME: /home/newgatedev/public_html/watches/admin/core/settings/diagnostics/index.php
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
SERVER_ADDR: 70.32.82.107
SERVER_ADMIN: webmaster@watches.newgatedevelopment.co.uk
SERVER_NAME: watches.newgatedevelopment.co.uk
SERVER_PORT: 443
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: Apache
SSL_TLS_SNI: watches.newgatedevelopment.co.uk
UNIQUE_ID: WIiQFFurhLLGxcgPDYRJ@gAAAEI
PHP_SELF: /admin/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1485344788.84
REQUEST_TIME: 1485344788
argc: 1

PHP5.6 - Debug

Time    Δ   Debug Message
0.0695  0   [51] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM watches_pages p LEFT JOIN watches_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
0.0719  0.0024  Matched route: shop/products/[slug:product]
0.072   0.0001  Using master page: /templates/pages/product.php
0.0721  0.0001  Page arguments:
Array
(
    [0] => /shop/products/the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
    [product] => the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
    [1] => the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
)
0.078   0.0059  [1] SELECT * FROM watches_pages WHERE pagePath='/shop/product' LIMIT 1
0.0854  0.0074  [1] SELECT * FROM watches_shop_cart WHERE cartID=199448
0.0858  0.0004  [1] SELECT * FROM watches_shop_cart WHERE cartID=199448
0.087   0.0013  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.0915  0.0045  [40] SELECT DISTINCT settingID, settingValue FROM watches_settings WHERE userID=0
0.0933  0.0017  Using template: /templates/shop/products/product.html
0.0945  0.0012  [24] SELECT catID, catPath FROM watches_categories
0.0951  0.0006  Using cart from cache.
0.0955  0.0004  Using template: /templates/pages/attributes/default.html
0.0991  0.0036  [5] SELECT regionKey, regionHTML FROM watches_content_regions WHERE regionPage='/shop/product' OR regionPage='*' ORDER BY regionPage DESC
0.0995  0.0004  Using cart from cache.
0.1001  0.0006  [3] SELECT currencyID, currencyCode FROM watches_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
0.1005  0.0004  Using template: /templates/shop/currencies/selected-gbp.html
0.105   0.0045  [1] SELECT setID FROM watches_category_sets WHERE setSlug='products' LIMIT 1
0.1053  0.0002  [11] SELECT main.* FROM watches_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
0.1064  0.0012  [11] Using template: /templates/categories/product_categories.html
0.1136  0.0071  [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM watches_pages WHERE pagePath='/information' OR pageSortPath='/information' LIMIT 1
0.1138  0.0003  [5] SELECT * FROM watches_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-008%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
0.1143  0.0004  [1] SELECT pageTreePosition FROM watches_pages WHERE pagePath='/shop/product' LIMIT 1
0.1145  0.0002  [2] SELECT pageID FROM watches_pages WHERE pageTreePosition IN ('000-003-001', '000-003', '000') ORDER BY pageTreePosition DESC
0.1149  0.0003  [4] Using template: /templates/navigation/dropdown-item.html
0.1168  0.002   Using template: /templates/search/search-form.html
0.1179  0.0011  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1201  0.0022  [5] Using template: /templates/shop/products/main_product.html
0.1354  0.0153  [1] SELECT * FROM watches_shop_currencies WHERE currencyID=47 LIMIT 1
0.14    0.0046  [20] SELECT DISTINCT idx.itemID FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/blip/%' OR idx.indexKey='_category' AND idx.indexValue='products/blip/'))
0.1412  0.0012  [3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('337', '339', '340', '341', '342', '343', '344', '345', '346', '338', '355', '348', '350', '351', '354', '349', '347', '352', '353', '356') WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue != 'the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 3
0.148   0.0068  [3] Using template: /templates/shop/products/more_from_family.html
0.1537  0.0057  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1558  0.0021  [1] Using template: /templates/shop/products/additional_product_information.html
0.1605  0.0046  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1627  0.0023  [1] Using template: /templates/shop/products/json_feed.html
0.1651  0.0024  Request time: 0.1651
0.1651  0   Process time: 0.1645
0.1651  0   Memory: 6.8399

PHP7.0 - Diagnostics

Perch Runway: 2.8.34
Production mode: Development (10)
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0), perch_forms (1.8.3), perch_shop_orders (1.0.11), perch_shop_products (1.0.11), perch_shop (1.0.11), perch_members (1.5), perch_mailchimp (3.0.1), perch_twitter (3.6.2)
DB driver: PDO
DB tables: watches_backup_plans (1), watches_backup_resources (520), watches_backup_runs (113), watches_blog_authors (6), watches_blog_comments (0), watches_blog_index (1445), watches_blog_posts (41), watches_blog_posts_to_tags (0), watches_blog_sections (1), watches_blog_tags (0), watches_blogs (1), watches_categories (24), watches_category_counts (5), watches_category_sets (4), watches_collection_index (0), watches_collection_items (0), watches_collection_revisions (0), watches_collections (0), watches_content_index (5284), watches_content_items (215), watches_content_regions (45), watches_forms (0), watches_forms_responses (0), watches_mailchimp_campaigns (9), watches_mailchimp_imports (0), watches_mailchimp_lists (1), watches_mailchimp_subscribers (163), watches_mailchimp_subscriptions (163), watches_mailchimp_webhooks (4), watches_members (610), watches_members_forms (4), watches_members_member_tags (0), watches_members_sessions (6), watches_members_tags (2), watches_navigation (0), watches_navigation_pages (0), watches_page_routes (24), watches_page_templates (32), watches_pages (43), watches_resource_log (5360), watches_resource_tags (0), watches_resources (7531), watches_resources_to_tags (0), watches_scheduled_tasks (40), watches_settings (42), watches_shop_addresses (3853), watches_shop_admin_index (74), watches_shop_brands (1), watches_shop_cart (198488), watches_shop_cart_data (393), watches_shop_cart_items (1964), watches_shop_countries (250), watches_shop_currencies (152), watches_shop_customers (817), watches_shop_emails (1), watches_shop_index (10256), watches_shop_option_values (0), watches_shop_options (0), watches_shop_order_items (1214), watches_shop_order_promotions (230), watches_shop_order_statuses (11), watches_shop_orders (587), watches_shop_orders_meta (1), watches_shop_product_files (0), watches_shop_product_option_values (0), watches_shop_product_options (0), watches_shop_product_tags (0), watches_shop_products (77), watches_shop_promotions (7), watches_shop_search (84), watches_shop_shipping_zone_countries (206), watches_shop_shipping_zones (12), watches_shop_shippings (2), watches_shop_tax_exhibits (1917), watches_shop_tax_group_rates (1), watches_shop_tax_groups (2), watches_shop_tax_locations (1), watches_shop_tax_rates (1), watches_shop_variants (0), watches_twitter_scheduled_tweets (0), watches_twitter_settings (1), watches_twitter_tweets (0), watches_user_passwords (1), watches_user_privileges (81), watches_user_role_privileges (16), watches_user_roles (2), watches_users (13)
Users: 13
PHPMailer: 5.2.21
App runtimes:
<?php
    $apps_list = array(
        'content',
        'categories',
        'perch_forms',
        'perch_mailchimp',
        'perch_twitter',
        'perch_members',
        'perch_shop',
        'perch_blog'
    );
Scheduled tasks for perch_twitter: post_tweets (1 mins)
Scheduled tasks for perch_mailchimp: import_data (1 mins)
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Scheduled tasks for Backup: plan_1 (10 mins)
Editor plug-ins: markitup
H1: fa6195f1bb69ec2df63932ad0bf2d19d
L1: 5a46b657baffcbfca32f8fe1d2036f54
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
headerColour: #ca0000
content_singlePageEdit: 1
helpURL:
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.31: done
perch_twitter_update: 3.5
headerScheme: dark
update_runway_2.8.31: done
latest_version: 2.8.15
on_sale_version: 2.8.34
hide_pwd_reset: 1
dashboard: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
perch_shop_update: 1.0.11
perch_mailchimp_api_key: b8e0b18debe717ba1efe75f01703f85b-us12
perch_mailchimp_campaign_url: /mailchimp/campaign/{campaignSlug}
perch_shop_price_tax_mode: inc
perch_shop_trade_price_tax_mode: exc
perch_shop_site_url: https://newgatewatches.com
perch_shop_product_url: /shop/products/{slug}
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: #%d
perch_members_login_page: /members/login.php?r={returnURL}
perch_mailchimp_secret: 1c40981
perch_members_update: 1.4
logoPath: /admin/resources/perch-logo-1.png
perch_blog_update: 5.0.1
perch_blog_post_url: /magazine/{postSlug}
perch_blog_site_name:
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
perch_blog_max_spam_days: 0
perch_blog_comment_notify: 0
update_runway_2.8.32: done
siteURL: https://newgatewatches.com
update_runway_2.8.34: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: /Volumes/Data/g Websites/newgatewatches/newgate-watches
PERCH_SCHEDULE_SECRET: UehFD0ambiReSATQ
PERCH_DB_USERNAME: newgated_watches
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: newgated_watches
PERCH_EMAIL_METHOD: smtp
PERCH_EMAIL_HOST: mailtrap.io
PERCH_EMAIL_SECURE: tls
PERCH_EMAIL_AUTH: 1
PERCH_EMAIL_PORT: 2525
PERCH_EMAIL_USERNAME: 42004aa368a4f9d32
PERCH_DEBUG: 1
PERCH_PRODUCTION_MODE: 10
PERCH_DB_PREFIX: watches_
PERCH_EMAIL_FROM: sales@newgatewatches.com
PERCH_EMAIL_FROM_NAME: Newgate Watches
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/newgatedev/public_html/watches/admin
PERCH_CORE: /home/newgatedev/public_html/watches/admin/core
PERCH_RESFILEPATH: /home/newgatedev/public_html/watches/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_HTML5: 1
PERCH_TZ: UTC
PERCH_SSL: 1
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/newgatedev/public_html/watches/admin/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_SHOP_VERSION: 1.0.11
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 7.0.14
Zend: 3.0.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
MySQL server: 5.5.52-cll
Free disk space: 3.32 GB
Extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, ctype, dom, ftp, gd, iconv, json, mysqlnd, PDO, Phar, posix, SimpleXML, sqlite3, tokenizer, xml, xmlwriter, xsl, mysqli, pdo_mysql, pdo_sqlite, wddx, xmlreader, Zend OPcache
GD: Yes
ImageMagick: No
PHP max upload size: 128M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 8M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
CONTEXT_DOCUMENT_ROOT: /home/newgatedev/public_html/watches
DOCUMENT_ROOT: /home/newgatedev/public_html/watches
GATEWAY_INTERFACE: CGI/1.1
HTTPS: on
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch, br
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8,fr;q=0.6,it;q=0.4
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: cookieconsent_dismissed=yes; cmsa=1; timezone=Europe/London; cpsession=newgatedev%3aUti59eWH6IwGfzKJ%2cfef28841187cb038d46331c7022237a9; _ga=GA1.3.461211912.1485259148; _gat=1; PHPSESSID=dj1oguac80f3t4kkln5s3na511
HTTP_HOST: watches.newgatedevelopment.co.uk
HTTP_REFERER: https://watches.newgatedevelopment.co.uk/admin/core/settings/diagnostics/
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36
PATH: /bin:/usr/bin
QUERY_STRING: extended
REDIRECT_STATUS: 200
REMOTE_ADDR: 81.149.203.81
REMOTE_PORT: 56263
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_URI: /admin/core/settings/diagnostics/?extended
SCRIPT_FILENAME: /home/newgatedev/public_html/watches/admin/core/settings/diagnostics/index.php
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
SERVER_ADDR: 70.32.82.107
SERVER_ADMIN: webmaster@watches.newgatedevelopment.co.uk
SERVER_NAME: watches.newgatedevelopment.co.uk
SERVER_PORT: 443
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: Apache
SSL_TLS_SNI: watches.newgatedevelopment.co.uk
UNIQUE_ID: WIiPZj80AVyzu8HzKiMjnQAAAAM
PHP_SELF: /admin/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1485344614.5969
REQUEST_TIME: 1485344614
argc: 1

PHP7.0 - Debug

0.1552  0   [51] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM watches_pages p LEFT JOIN watches_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
0.1579  0.0027  Matched route: shop/products/[slug:product]
0.158   0.0001  Using master page: /templates/pages/product.php
0.158   0   Page arguments:
Array
(
    [0] => /shop/products/the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
    [product] => the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
    [1] => the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion
)
0.167   0.009   [1] SELECT * FROM watches_pages WHERE pagePath='/shop/product' LIMIT 1
0.1775  0.0105  [1] SELECT * FROM watches_shop_cart WHERE cartID=199448
0.178   0.0005  [1] SELECT * FROM watches_shop_cart WHERE cartID=199448
0.18    0.002   [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1917  0.0117  [40] SELECT DISTINCT settingID, settingValue FROM watches_settings WHERE userID=0
0.1961  0.0044  Using template: /templates/shop/products/product.html
0.198   0.0019  [24] SELECT catID, catPath FROM watches_categories
0.1984  0.0004  Using cart from cache.
0.1993  0.0009  Using template: /templates/pages/attributes/default.html
0.6218  0.4226  [5] SELECT regionKey, regionHTML FROM watches_content_regions WHERE regionPage='/shop/product' OR regionPage='*' ORDER BY regionPage DESC
0.6225  0.0007  Using cart from cache.
0.6233  0.0007  [3] SELECT currencyID, currencyCode FROM watches_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
0.6237  0.0005  Using template: /templates/shop/currencies/selected-gbp.html
0.6429  0.0192  [1] SELECT setID FROM watches_category_sets WHERE setSlug='products' LIMIT 1
0.6433  0.0004  [11] SELECT main.* FROM watches_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
0.6447  0.0014  [11] Using template: /templates/categories/product_categories.html
0.7602  0.1155  [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM watches_pages WHERE pagePath='/information' OR pageSortPath='/information' LIMIT 1
0.7608  0.0005  [5] SELECT * FROM watches_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-008%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
0.7612  0.0005  [1] SELECT pageTreePosition FROM watches_pages WHERE pagePath='/shop/product' LIMIT 1
0.7614  0.0002  [2] SELECT pageID FROM watches_pages WHERE pageTreePosition IN ('000-003-001', '000-003', '000') ORDER BY pageTreePosition DESC
0.7618  0.0004  [4] Using template: /templates/navigation/dropdown-item.html
0.788   0.0261  Using template: /templates/search/search-form.html
0.7888  0.0008  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.8009  0.0121  [5] Using template: /templates/shop/products/main_product.html
11.1061 10.3052 [1] SELECT * FROM watches_shop_currencies WHERE currencyID=47 LIMIT 1
11.1085 0.0023  [20] SELECT DISTINCT idx.itemID FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/blip/%' OR idx.indexKey='_category' AND idx.indexValue='products/blip/'))
11.1098 0.0013  [3] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' AND idx.itemID IN ('337', '339', '340', '341', '342', '343', '344', '345', '346', '338', '355', '348', '350', '351', '354', '349', '347', '352', '353', '356') WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue != 'the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 3
11.1172 0.0074  [3] Using template: /templates/shop/products/more_from_family.html
11.1652 0.048   [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
11.1679 0.0027  [1] Using template: /templates/shop/products/additional_product_information.html
11.1911 0.0231  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM watches_shop_index idx JOIN watches_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN watches_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='the-blip-wwmblpvs026mvs-contemporary-steel-watch-mesh-strap-mens-womens-fashion')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
11.1939 0.0028  [1] Using template: /templates/shop/products/json_feed.html
11.229  0.0351  Request time: 11.229
11.2291 0   Process time: 11.2271
11.2291 0   Memory: 1.7452
Mike Harrison

Mike Harrison 37 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

4 years ago

You'd be better asking the person responsible for your server. That's not something we can be expected to cover as part of Perch support.
Mike Harrison

Mike Harrison 37 points

4 years ago

No worries, I will ping them a message

UPDATE

I have been set up for a MediaTemple "CloudTech performance analysis". If they work out what the issue is and it is pertinent I will post here in case anyone else has an issue.

UPDATE

Looking again it is this query that is slowing everything down on that page, but will see what Media Temple come back with:

9.5115  [1] SELECT * FROM watches_shop_currencies WHERE currencyID=47 LIMIT 1

And this on my list view, which is run a few times:

12.4653 [0] SELECT setID FROM watches_category_sets WHERE setSlug='' LIMIT 1