Goedkope brillen – onze top 3

eoapi: eoViewsFooter/getComponent?sLanguage=nl

2021-01-28T01:04:15+01:00 - Runtime: 0.21 seconds - IP: DE – DIGITALOCEAN (46.101.153.84) - eoApiReturns-89041

• /var/www/eo-dev/sources/modules/api/api.php:75

  Array
  (
      [sLanguage] => nl
  )
  

• REDIS: eoRedisCache::get(eoGeolocationDbIp, 46.101.153.84) 0
• HINT eoSystem::isDevelopmentEnvironment() = true
• HINT eoSystem::isLocalDevelopment() = false
• HINT eoSystem::isLocal() = false
• HINT eoSystem::getMachine() = dev
• HINT PHP Version = 7.4.12
• HINT eoSystem::getRootDir() = /var/www/eo-dev/
• ---------------------------------------------------
• HINT eoSystem::startSession() = 0.0012
• HINT eoSession::getSessionId() = dqlcashh2htoo75c0lgrf09m08
• HINT DB connection to "192.168.8.5" - "eo-dev" - "postgres" - search path: system, logs, "eoCompricePrices", public
• HINT eoBots::isBot2() = false
• HINT eoSystem::getPromotionId() =
• HINT Add memcached server on port 11211
• SQL /*0.0069 sec */ SELECT * FROM "eoUsers" WHERE ("usr_sName" = 'eoapi' OR "usr_sEmail" = 'eoapi') AND "usr_sPassword" = '2ff7ab9057d6d11aaa3f7dbaddc7e2c5c108e1ec' AND "usr_bActive" AND "usr_eType" = 'staff'
• HINT eoSystem::getLoggedInUserName() : eoapi
• HINT eoProductsStockLocation::getLocation() = ae1
• API /eoViewsFooter/getComponent?sLanguage=nl -
• Declaration of eoViews::getHtml($aParameters = Array, $sSubClassHtml = '', $bSkipThis = false) should be compatible with pxObject::getHtml(&$aParametersByRef = Array) eoViews.php:540
• SQL /*0.0063 sec */ select * from "eoCountries" Where 'nl' = ANY ("cnt_aLanguages") LIMIT 1;
• eoViewsFooterNew->getHtml#1386

  nl_BQ

• SQL /*0.0016 sec */ SELECT * FROM "eoCountries" WHERE "cnt_sId" = ''
• HINT eoTranslatorFactory::__construct:324 eoContentsTranslationsFrontend nl_BQ
• MEMCACHED eoMemcached::get(eoTranslatorFactory.sLocale, nl_BQ) 0
• SLOWSQL /*0.0477 sec */ SELECT unnest("cnt_aLocales") FROM "eoCountries" WHERE "cnt_aLanguages" @> ARRAY['nl'] :: character varying[] AND "cnt_bHasEdelOpticsDomain" ORDER BY array_length("cnt_aLocales", 1), "cnt_iSalesrank" LIMIT 1
• eoViewsSideviewContentHelpBox::getTelNumber#257

  en_  

• HINT eoTranslatorFactory::__construct:324 eoContentsTranslationsUrl de_DE
• NOTICE language loaded: nl_BQ for Indicator: kx-hd-buysafe - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• NOTICE language loaded: nl_BQ for Indicator: page-shipping-cost - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• SQL /*0.0016 sec */ select * from "eoArticles" WHERE "art_aTags"@>'{footer}' and "art_sLanguage" = 'nl'
• MEMCACHED eoMemcached::get(country-blacklist, blacklist) 1
• DUPLICATE SQL /*0.0035 sec */ SELECT "pbs_iBrand", "pbs_sBrand" AS "brand", "pbs_eoProductsGlassesSunglasses" AS "salesrank" FROM "eoProductsBrandsSalesranks" WHERE "pbs_eoProductsGlassesSunglasses" < 84 ORDER BY "pbs_eoProductsGlassesSunglasses" LIMIT 500
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-8) 1
• MEMCACHED eoMemcached::get(brand-mapping, brand-mapping) 2
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 2
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 3
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 4
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-794) 5
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-17) 6
• DUPLICATE SQL /*0.0021 sec */ SELECT "pbs_iBrand", "pbs_sBrand" AS "brand", "pbs_eoProductsGlassesPrescription" AS "salesrank" FROM "eoProductsBrandsSalesranks" WHERE "pbs_eoProductsGlassesPrescription" < 84 ORDER BY "pbs_eoProductsGlassesPrescription" LIMIT 72
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-708) 7
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-794) 8
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 9
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-8) 10
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 11
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-269) 12
• DUPLICATE SQL /*0.0089 sec */ SELECT "pbs_iBrand", "pbs_sBrand" AS "brand", "pbs_eoProductsGlassesSunglasses" AS "salesrank" FROM "eoProductsBrandsSalesranks" WHERE "pbs_eoProductsGlassesSunglasses" < 84 ORDER BY "pbs_eoProductsGlassesSunglasses" LIMIT 500
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-8) 13
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 14
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 15
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 16
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-794) 17
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-17) 18
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-42) 19
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-34) 20
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-38) 21
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-504) 22
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-9) 23
• DUPLICATE SQL /*0.002 sec */ SELECT "pbs_iBrand", "pbs_sBrand" AS "brand", "pbs_eoProductsGlassesPrescription" AS "salesrank" FROM "eoProductsBrandsSalesranks" WHERE "pbs_eoProductsGlassesPrescription" < 84 ORDER BY "pbs_eoProductsGlassesPrescription" LIMIT 72
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-708) 24
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-794) 25
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 26
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-8) 27
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 28
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-269) 29
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-693) 30
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 31
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-267) 32
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-602) 33
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-245) 34
• HINT eoViewsSideviewContentReviews::getHtml:186
• eoViewsFooterNew->getHtml#2316

  nl_BQ

  en_  

• NOTICE language loaded: nl_BQ for Indicator: kx-hd-buysafe - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• eoPaymentManager::__construct:124
• HINT eoPayment_cc_cic3DSecure2::__construct:119
• eoPayment_cc_cic3DSecure2->__construct#123

  eoPayment_cc_cic3DSecure2::__construct:123

• Using old Paypal
• eoPayment_paypal_restPaypal::__construct ENVIRONMENT: sandbox
• Using new Paypal_rest
• Using old Paypal
• Using old Paypal
• eoPayment_sofort
• eoPayment_sofort
• eoPayment_sofort
• eoPayment_ideal
• MEMCACHED eoMemcached::get(eoQuery::getFirstInstance, 6794aad61db655c0bf8a25ecfde12305) 3
• SQL /*0.0029 sec */ SELECT * FROM "eoCountries" WHERE "cnt_sTld" = '.'
• HINT eoApi::runDirectly:245
• EXCEPTION No Row Found: eoCountries WHERE cnt_sTld = $1 Array ( [0] => . )
• HINT Runtime since eoSystem::start() = 0.24 seconds
• HINT memory_get_usage() = 3 MB
• HINT memory_get_usage(true) = 2 MB
• eoApi->run#928

  array (
  )

  ?

• Totals

  Array
  (
      [REDIS] => 35
      [HINT] => 22
      [SQL] => 9
      [MEMCACHED] => 4
      [NOTICE] => 3
      [EXCEPTION] => 1
      [SLOW-SQL] => 1
      [API] => 1
  )