eoapi: eoViewsFooter/getComponent?sLanguage=fr

2020-11-24T01:00:49+01:00 - Runtime: 0.55 seconds - IP: DE – DIGITALOCEAN (46.101.153.84) - eoApiReturns-73005

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

  Array
  (
      [sLanguage] => fr
  )
  

• 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 eoSystem::getRootDir() = /var/www/eo-dev/
• ---------------------------------------------------
• HINT eoSystem::startSession() = 0.0009
• HINT eoSession::getSessionId() = c4vulk15ii07t2v7hle3ihda6j
• 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.0072 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=fr -
• Declaration of eoViews::getHtml($aParameters = Array, $sSubClassHtml = '', $bSkipThis = false) should be compatible with pxObject::getHtml(&$aParametersByRef = Array) eoViews.php:540
• SLOWSQL /*0.0721 sec */ select * from "eoCountries" Where 'fr' = ANY ("cnt_aLanguages") LIMIT 1;
• eoViewsFooterNew->getHtml#1386

  fr_MC

• SQL /*0.0026 sec */ SELECT * FROM "eoCountries" WHERE "cnt_sId" = ''
• HINT eoTranslatorFactory::__construct:324 eoContentsTranslationsFrontend fr_MC
• MEMCACHED eoMemcached::get(eoTranslatorFactory.sLocale, fr_MC) 0
• SLOWSQL /*0.3659 sec */ SELECT unnest("cnt_aLocales") FROM "eoCountries" WHERE "cnt_aLanguages" @> ARRAY['fr'] :: 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: fr_MC for Indicator: kx-hd-buysafe - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• NOTICE language loaded: fr_MC for Indicator: page-shipping-cost - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• SQL /*0.0031 sec */ select * from "eoArticles" WHERE "art_aTags"@>'{footer}' and "art_sLanguage" = 'fr'
• 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-14) 2
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 3
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 4
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-17) 5
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-42) 6
• DUPLICATE SQL /*0.0019 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-693) 11
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 12
• DUPLICATE SQL /*0.002 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-14) 14
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 15
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-211) 16
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-17) 17
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-42) 18
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-504) 19
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-38) 20
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-794) 21
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-34) 22
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-33) 23
• DUPLICATE SQL /*0.0018 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-693) 28
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-14) 29
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-269) 30
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-2) 31
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-245) 32
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-267) 33
• REDIS: eoRedisCache::get(eoProductsBrands, eoProductsBrands-190) 34
• HINT eoViewsSideviewContentReviews::getHtml:186
• eoViewsFooterNew->getHtml#2316

  fr_MC

  en_  

• NOTICE language loaded: fr_MC for Indicator: kx-hd-buysafe - eoUrls->getText / eoUrls->getStaticPageLink / eoViewsFooterNew->getHtml / eoViewsFooter->getComponent / eoApi->runDirectly / eoApi->run / eoApi->handleCall
• eoPaymentManager::__construct:122
• HINT eoPayment_cc_cic3DSecure2::__construct:112
• eoPayment_cc_cic3DSecure2->__construct#116

  eoPayment_cc_cic3DSecure2::__construct:116

• 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.0036 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.58 seconds
• HINT memory_get_usage() = 3 MB
• HINT memory_get_usage(true) = 2 MB

• Totals

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