Outside View

_GET (1)
_SERVER (36)
_REQUEST (1)

_GET

array (
  'en/gallery-outside-view' => '',
)

_SERVER

array (
  'DOCUMENT_ROOT' => '/www/2013/03/sa601/www',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HOSTNAME' => 'WebFront01',
  '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' => 'close',
  'HTTP_HOST' => 'www.hotel-lecanter.fr',
  'HTTP_IF_MODIFIED_SINCE' => 'Thu, 13 Aug 2020 03:01:50 GMT',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_X_FORWARDED_FOR' => '3.238.4.24',
  'HTTP_X_FORWARDED_PORT' => '443',
  'HTTP_X_FORWARDED_PROTO' => 'https',
  'PATH' => '/bin:/usr/bin',
  'PHPRC' => '/home/phpini/hotel-lecanter.fr/php73',
  'QUERY_STRING' => 'en/gallery-outside-view',
  'REDIRECT_HOSTNAME' => 'WebFront01',
  'REDIRECT_QUERY_STRING' => 'en/gallery-outside-view',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/en/gallery-outside-view',
  'REMOTE_ADDR' => '10.1.2.250',
  'REMOTE_PORT' => '55584',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/en/gallery-outside-view',
  'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php',
  'SCRIPT_NAME' => '/oktopus.php',
  'SERVER_ADDR' => '10.1.2.1',
  'SERVER_ADMIN' => 'service-client@sitti.fr',
  'SERVER_NAME' => 'www.hotel-lecanter.fr',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => 'Apache/2.2.22 (Debian) Server at www.hotel-lecanter.fr Port 80
',
  'SERVER_SOFTWARE' => 'Apache/2.2.22 (Debian)',
  'PHP_SELF' => '/oktopus.php',
  'REQUEST_TIME_FLOAT' => 1603194976.626312,
  'REQUEST_TIME' => 1603194976,
)

_REQUEST

array (
  'en/gallery-outside-view' => '',
)

Variables (5)
Constantes (81)
Configuration (100)
Utilisateur (26)

Variables dans le scope global

array (
  0 => 'okt',
  1 => 'oktAutoloadPaths',
  2 => '__composer_autoload_files',
  3 => '__l10n',
  4 => '__l10n_files',
)

Constantes

array (
  'OKT_START_TIME' => 1603194976.6374719,
  'OKT_ROOT_PATH' => '/www/2013/03/sa601/www',
  'OKT_INC_DIR' => 'oktInc',
  'OKT_INC_PATH' => '/www/2013/03/sa601/www/oktInc',
  'OKT_UPLOAD_DIR' => 'upload',
  'OKT_UPLOAD_PATH' => '/www/2013/03/sa601/www/upload',
  'OKT_COMMON_DIR' => 'oktCommon',
  'OKT_COMMON_PATH' => '/www/2013/03/sa601/www/oktCommon',
  'OKT_MODULES_DIR' => 'oktModules',
  'OKT_MODULES_PATH' => '/www/2013/03/sa601/www/oktModules',
  'OKT_PUBLIC_DIR' => 'oktPublic',
  'OKT_PUBLIC_PATH' => '/www/2013/03/sa601/www/oktPublic',
  'OKT_CACHE_DIR' => 'oktCache',
  'OKT_CACHE_PATH' => '/www/2013/03/sa601/www/oktCache',
  'OKT_GLOBAL_CACHE_FILENAME' => 'static.php',
  'OKT_GLOBAL_CACHE_FILE' => '/www/2013/03/sa601/www/oktCache/static.php',
  'OKT_CONFIG_DIR' => 'oktConf',
  'OKT_CONFIG_PATH' => '/www/2013/03/sa601/www/oktConf',
  'OKT_LOG_DIR' => 'oktLog',
  'OKT_LOG_PATH' => '/www/2013/03/sa601/www/oktLog',
  'OKT_THEMES_DIR' => 'oktThemes',
  'OKT_THEMES_PATH' => '/www/2013/03/sa601/www/oktThemes',
  'OKT_CLASSES_PATH' => '/www/2013/03/sa601/www/oktInc/classes',
  'OKT_LOCALES_PATH' => '/www/2013/03/sa601/www/oktInc/locales',
  'OKT_VENDOR_PATH' => '/www/2013/03/sa601/www/oktInc/vendor',
  'OKT_MIN_DIR' => 'minify',
  'OKT_MIN_PATH' => '/www/2013/03/sa601/www/oktCache/minify',
  'OKT_MINGROUP_DIR' => 'groups',
  'OKT_MINGROUP_PATH' => '/www/2013/03/sa601/www/oktCache/minify/groups',
  'OKT_COOKIE_AUTH_NAME' => 'okt_auth',
  'OKT_COOKIE_AUTH_FROM' => 'okt_auth_from',
  'OKT_COOKIE_LANGUAGE' => 'okt_language',
  'OKT_COOKIE_CONSENT' => 'okt_consent',
  'OKT_ENVIRONMENT' => 'prod',
  'OKT_XDEBUG' => false,
  'OKT_FILENAME' => 'oktopus.php',
  'OKT_DIRNAME' => '/',
  'OKT_ADMIN_DIR' => 'administration',
  'OKT_ADMIN_HEADER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header.php',
  'OKT_ADMIN_HEADER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/header_ajax.php',
  'OKT_ADMIN_HEADER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/header_cnx.php',
  'OKT_ADMIN_FOOTER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer.php',
  'OKT_ADMIN_FOOTER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/footer_ajax.php',
  'OKT_ADMIN_FOOTER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/footer_cnx.php',
  'OKT_ADMIN_HEADER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header_simple.php',
  'OKT_ADMIN_FOOTER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer_simple.php',
  'OKT_ADMIN_LOGIN_PAGE' => 'connexion.php',
  'OKT_GOOGLE_GEOCODE_KEY' => 'AIzaSyAZsu4vldPq58x4FWGs35p3ytzrAZ67xVI',
  'OKT_THUMB_COMPRESSION' => 80,
  'OKT_SEO_LIMIT_TITLE' => 75,
  'OKT_SEO_LIMIT_DESCRIPTION' => 200,
  'OKT_DB_LOG_USER' => 'ledns-oktolog',
  'OKT_DB_LOG_PWD' => '7gv2536uGfiImFLl',
  'OKT_ROUND_HALF_UP' => 1,
  'OKT_ROUND_HALF_DOWN' => 2,
  'OKT_ROUND_HALF_EVEN' => 3,
  'OKT_ROUND_HALF_ODD' => 4,
  'OKT_ROUND_UP' => 5,
  'OKT_ROUND_DOWN' => 6,
  'JSON_ENCODE_ALL' => 271,
  'FILTER_VALIDATE_BOOL' => 258,
  'HTMLPURIFIER_PREFIX' => '/www/2013/03/sa601/www/oktInc/vendor/composer/vendor/ezyang/htmlpurifier/library',
  'OKT_DB_HOST' => 'sql5',
  'OKT_DB_NAME' => 'sa601',
  'OKT_DB_USER' => 'sa601',
  'OKT_DB_PWD' => 'GF6NAnxDTCogUrzE',
  'OKT_DB_PREFIX' => 'oktopusV2_',
  'OKT_MODULES_URL' => '/oktModules',
  'OKT_COMMON_URL' => '/oktCommon',
  'OKT_UPLOAD_URL' => '/upload',
  'OKT_DIGESTS' => '/www/2013/03/sa601/www/oktInc/digests',
  'OKT_THEME_DEFAULT_PATH' => '/www/2013/03/sa601/www/oktThemes/default',
  'OKT_THEME_DEFAULT' => '/oktThemes/default',
  'OKT_THEME' => '/oktThemes/ra154-s',
  'OKT_THEME_PATH' => '/www/2013/03/sa601/www/oktThemes/ra154-s',
  'OKT_MAX_UPLOAD_SIZE' => 52428800,
  'OKT_DEBUG' => true,
  'OKT_PART' => 'public',
  '__DB_PREFIX_TVA__' => 'oktopusV2_mod_tva_',
  '__DB_PREFIX_GEO__' => 'oktopusV2_mod_geographie_',
  '__DB_PREFIX_RESA__' => 'oktopusV2_mod_resa_',
)

Configuration

array (
  'title' => 
  array (
    'fr' => 'L\'hôtel Le Canter',
    'en' => '',
    'es' => '',
  ),
  'desc' => 
  array (
    'fr' => '',
    'en' => '',
    'es' => '',
  ),
  'title_tag' => 
  array (
    'fr' => 'L\'hôtel Le Canter',
    'en' => '',
    'es' => '',
  ),
  'meta_description' => 
  array (
    'fr' => 'L\'hôtel Le Canter est un hôtel d\'hébergement séminaire et petit déjeuner près de Saumur dans le Maine-et-Loire (49).',
    'en' => '',
    'es' => '',
  ),
  'meta_keywords' => 
  array (
    'fr' => 'hébergement séminaire saumur, chambres hotel saumur, hôtel séminaire et petit déjeuner saumur, hôtel séminaire saumur, réserver hôtel saumur, hébergement séminaire et petit déjeuner saumur, chambres hôtel et petit déjeuner saumur, hébergement séminaire 49, chambres hotel 49, hôtel séminaire et petit déjeuner 49, hôtel séminaire 49, réserver hôtel 49, hébergement séminaire et petit déjeuner 49, chambres hôtel et petit déjeuner 49, hébergement séminaire maine et loire, chambres hotel maine et loire, hôtel séminaire et petit déjeuner maine et loire, hôtel séminaire maine et loire, réserver hôtel maine et loire, hébergement séminaire et petit déjeuner maine et loire, chambres hôtel et petit déjeuner maine et loire',
    'en' => '',
    'es' => '',
  ),
  'list_address' => 
  array (
    0 => 
    array (
      'libelle' => '',
      'company_name' => '',
      'street' => '1 Place De La Sénatorerie',
      'street_2' => '',
      'code' => '49400',
      'city' => 'Saint-Hilaire-Saint-Florent',
      'country' => 'France',
      'tel' => '02 41 50 37 88',
      'mobile' => '',
      'fax' => '',
      'email' => 'contact@hotel-lecanter.fr',
      'lat' => '47.2647675',
      'long' => '-0.1000264',
      'config_address_1' => '1',
      'config_address_2' => '1',
    ),
  ),
  'list_schedule' => 
  array (
    0 => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
  ),
  'company' => 
  array (
    'name' => 'OSER',
    'com_name' => 'L\'hôtel Le Canter',
    'siret' => '853 210 250 00017',
    'tva_intra' => 'FR00853210250',
  ),
  'plan' => 
  array (
    'affichage' => 0,
    'lat' => '',
    'long' => '',
  ),
  'leader' => 
  array (
    'name' => 'SIGURET',
    'firstname' => 'Olivier',
  ),
  'courriel_address' => 'prodokto@gmail.com',
  'courriel_name' => 'L\'hôtel Le Canter',
  'courriel_transport' => 'sendmail',
  'courriel_smtp' => 
  array (
    'host' => '',
    'port' => 25,
    'username' => 'dev@sitti.fr',
    'password' => 'cMGhbnTL',
  ),
  'courriel_sendmail' => '/usr/sbin/sendmail -t -i',
  'courriel_theme' => '1',
  'theme' => 'ra154-s',
  'theme_mobile' => '',
  'theme_tablet' => '',
  'public_theme' => 'base',
  'form_theme' => 'jiro',
  'button' => 
  array (
    'primary_type' => 'couleur',
    'effect' => 'bouton_fade1',
    'shadow_text' => '1',
    'shadow_box' => 0,
    'secondary_type' => 'bordure',
    'bloc3' => '1',
    'diapo' => '1',
  ),
  'menu' => 
  array (
    'type' => '6',
    'orientation' => '1',
    'compatible' => 
    array (
      0 => '6',
    ),
  ),
  'menu_bas' => 
  array (
    'enable_menu_deroulant' => false,
    'show_rubrique_principale' => true,
  ),
  'enable_admin_bar' => true,
  'enable_backtop' => true,
  'set_theme_column' => '2',
  'admin_sidebar_position' => 0,
  'admin_dashboard' => 0,
  'admin_theme' => 'admin',
  'admin_compress_output' => false,
  'panel_construction' => 
  array (
    'enable' => 0,
    'text' => 'Découvrez prochainement notre site internet',
    'color' => '000000',
    'bgcolor' => 'ffffff',
  ),
  'language' => 'es',
  'timezone' => 'Europe/Madrid',
  'admin_lang_switcher' => true,
  'app_path' => '/',
  'domain' => 'www.hotel-lecanter.fr',
  'internal_router' => true,
  'default_route' => 
  array (
    'class' => 'pagesController',
    'method' => 'pagesItem',
    'args' => 'accueil',
  ),
  'custom_routes' => 
  array (
  ),
  'redirect_404_to_home' => false,
  'app_file' => 'oktopus.php',
  'public_maintenance_mode' => false,
  'admin_maintenance_mode' => false,
  'modules_repositories_enabled' => true,
  'modules_repositories' => 
  array (
    'SITTI modules' => 'http://oktopus.ledns.net/modules/%VERSION%/index.xml',
  ),
  'themes_repositories_enabled' => true,
  'themes_repositories' => 
  array (
    'SITTI thèmes' => 'http://oktopus.ledns.net/themes/%VERSION%/index.xml',
  ),
  'debug_enabled' => true,
  'stop_redirect_on_error' => true,
  'xdebug_enabled' => false,
  'antispam_filters' => 'a:0:{}',
  'use_admin_lang_switcher' => NULL,
  'update_enabled' => true,
  'update_url' => 'http://oktopus.ledns.net/packages/versions.xml',
  'update_type' => 'stable',
  'api_enabled' => true,
  'api_key' => '2285ff62ae73262abf78d40aa266e65cd12b7fbbb11cae988a1626c9cb760c3d',
  'auth_security' => 
  array (
    'enabled' => true,
    'allowed_retries' => 5,
    'lockout_duration' => 30,
    'valid_duration' => 12,
    'whitelist' => 
    array (
    ),
    'blacklist' => 
    array (
    ),
  ),
  'minify_complete_enable' => false,
  'minify_css_admin' => 
  array (
    0 => '%COMMON_URL%/css/bootstrap.3.2.0.min.css',
    1 => '%COMMON_URL%/ui-themes/%ADMIN_THEME%/jquery-ui.css',
    2 => '%COMMON_URL%/js/jquery/popup/jquery.popup.css',
    3 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.css',
    4 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.css',
  ),
  'minify_js_admin' => 
  array (
    0 => '%COMMON_URL%/js/jquery/jquery.min.js',
    1 => '%COMMON_URL%/js/jquery/jquery-migrate.min.js',
    2 => '%COMMON_URL%/js/jquery/cookie/jquery.cookie.min.js',
    3 => '%COMMON_URL%/js/jquery/metadata/jquery.metadata.min.js',
    4 => '%COMMON_URL%/js/jquery/ui/jquery-ui.min.js',
    5 => '%COMMON_URL%/js/jquery/ui/i18n/jquery-ui-i18n.min.js',
    6 => '%COMMON_URL%/js/jquery/popup/jquery.popup.js',
    7 => '%COMMON_URL%/js/jquery/validate/jquery.validate.min.js',
    8 => '%COMMON_URL%/js/jquery/validate/additional-methods.min.js',
    9 => '%COMMON_URL%/js/jquery/util/jquery.util.js',
    10 => '%COMMON_URL%/js/jquery/maxlength/jquery.maxlength.min.js',
    11 => '%COMMON_URL%/js/jquery/slimscroll.min.js',
    12 => '%COMMON_URL%/js/jquery/moment.js',
    13 => '%COMMON_URL%/js/jquery/util/jquery.util.js',
    14 => '%COMMON_URL%/js/jquery/alphanumeric/jquery.alphanumeric.js',
    15 => '%COMMON_URL%/js/jquery/validform/jquery.validform.js',
    16 => '%COMMON_URL%/js/jquery/sprintf/jquery.sprintf.js',
    17 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.js',
    18 => '%COMMON_URL%/js/jquery/form/jquery.form.js',
    19 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.js',
    20 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.js',
    21 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.pager.js',
    22 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.filter.js',
    23 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.total.js',
    24 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.customparser.js',
    25 => '%COMMON_URL%/js/jquery/maskinput/src/jquery.maskinput.js',
    26 => '%COMMON_URL%/js/common_admin.js',
  ),
  'minify_css_public' => 
  array (
  ),
  'minify_js_public' => 
  array (
  ),
  'log_admin' => 
  array (
    'ttl_months' => 3,
  ),
  'htmlpurifier_disabled' => false,
  'round' => 
  array (
    'rule' => 1,
    'precision' => 2,
  ),
  'slug_type' => 'ascii',
  'google_analytic' => 'UA-172001023-21',
  'google_conversion_id' => '',
  'google_conversion_label_contact' => '',
  'google_conversion_label_vente' => '',
  'google_code_appel_ak' => '',
  'google_code_appel_cl' => '',
  'google_phone' => '',
  'facebook_pixel_id' => '',
  'cnil_number' => '',
  'enable_logo_editeur' => false,
  'enable_w3c' => false,
  'enable_fixedMenu' => '2',
  'enable_rgpd' => 0,
  'activite' => 0,
  'format_date' => '%A %d %B %Y',
  'theme_vars' => 
  array (
    'titre_menu' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'titre_adresse' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'texte_tel' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'slogan1' => 
    array (
      'fr' => 'Bienvenue à l\'hôtel-bar Le Canter',
      'en' => 'Welcome to Le Canter hotel bar',
      'es' => 'Bienvenido al bar del hotel Le Canter',
    ),
    'slogan2' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'slogan3' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'btn1' => 
    array (
      'fr' => 'Réservez',
      'en' => 'Book',
      'es' => 'Libro',
    ),
    'btn2' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'titre_bas' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'texte_bas' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
  ),
  'breadcrumb' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'pager' => 
  array (
    'nb_page_display' => '3',
    'enable_group' => false,
    'templates' => 
    array (
      'default' => 'modele-1',
      'usables' => 
      array (
      ),
    ),
  ),
  'filter' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'error' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'debug_bar' => 
  array (
    'admin' => true,
    'public' => true,
    'tabs' => 
    array (
      'super_globales' => true,
      'app' => true,
      'logs' => true,
      'db' => true,
      'tools' => true,
    ),
  ),
  'enable_theme_multi' => false,
  'news_feed' => 
  array (
    'enabled' => false,
    'url' => '',
  ),
  'dpo' => 
  array (
    'name' => '',
  ),
  'app_host' => 'https://www.hotel-lecanter.fr',
  'app_url_court' => 'https://www.hotel-lecanter.fr/',
  'self_uri' => 'https://www.hotel-lecanter.fr/en/gallery-outside-view',
  'address' => 
  array (
    'libelle' => '',
    'company_name' => '',
    'street' => '1 Place De La Sénatorerie',
    'street_2' => '',
    'code' => '49400',
    'city' => 'Saint-Hilaire-Saint-Florent',
    'country' => 'France',
    'tel' => '02 41 50 37 88',
    'mobile' => '',
    'fax' => '',
    'email' => 'contact@hotel-lecanter.fr',
    'lat' => '47.2647675',
    'long' => '-0.1000264',
    'config_address_1' => '1',
    'config_address_2' => '1',
  ),
  'gps' => 
  array (
    'libelle' => '',
    'company_name' => '',
    'street' => '1 Place De La Sénatorerie',
    'street_2' => '',
    'code' => '49400',
    'city' => 'Saint-Hilaire-Saint-Florent',
    'country' => 'France',
    'tel' => '02 41 50 37 88',
    'mobile' => '',
    'fax' => '',
    'email' => 'contact@hotel-lecanter.fr',
    'lat' => '47.2647675',
    'long' => '-0.1000264',
    'config_address_1' => '1',
    'config_address_2' => '1',
  ),
  'schedule' => 
  array (
    'fr' => '',
    'en' => '',
    'es' => '',
  ),
  'company_name' => 'L\'hôtel Le Canter',
  'app_url' => 'https://www.hotel-lecanter.fr/en/',
)

Variables utilisateur

array (
  'id' => '1',
  'group_id' => '3',
  'civility' => '0',
  'active' => '1',
  'username' => 'Guest',
  'lastname' => '',
  'firstname' => '',
  'password' => 'Guest',
  'salt' => NULL,
  'email' => '',
  'timezone' => 'Europe/Madrid',
  'language' => 'en',
  'registered' => '0',
  'registration_ip' => '0.0.0.0',
  'last_visit' => '1595008738',
  'activate_string' => NULL,
  'activate_key' => NULL,
  'title' => 'Invité',
  'perms' => 
  array (
  ),
  'group_type' => 'C',
  'logged' => '1603194876',
  'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20',
  'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation/standard-single-room-for-one-person/6/0',
  'is_guest' => true,
  'is_admin' => false,
  'is_superadmin' => false,
)

#	type	fichier	ligne	classe	fonction	message


SET NAMES utf8
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='3.238.4.24' WHERE u.id=1
UPDATE oktopusV2_core_users_online SET logged=1603194976,
prev_url='https://www.hotel-lecanter.fr/en/gallery-outside-view'
WHERE ident='3.238.4.24'
SELECT id_selection FROM oktopusV2_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '81'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '80'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '79'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '78'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '76'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '75'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '74'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '73'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '72'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '39'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '37'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '26'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '24'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '23'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '21'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '20'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '19'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '18'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '15'  ORDER BY index_selection,
libelle 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC 
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV2_mod_galleries AS r LEFT JOIN
oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV2_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.slug='outside-view' AND
rl.language='en' AND r.active=1  GROUP BY r.id ORDER BY
nleft asc 
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV2_mod_galleries AS r LEFT JOIN
oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV2_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.language='en' AND
r.parent_id=2 AND r.active=1  GROUP BY r.id ORDER BY nleft
asc 
SELECT i.id, i.user_id, i.gallery_id, i.active,
i.created_at, i.updated_at, i.image, i.tpl, i.ord,
il.language, il.title, il.subtitle, il.title_tag,
il.title_seo, il.slug, il.content, il.meta_description,
il.meta_keywords, il.words, gl.title AS gallery_title,
gl.slug AS gallery_slug, g.items_tpl AS gallery_items_tpl
FROM oktopusV2_mod_galleries_items AS i  INNER JOIN
oktopusV2_mod_galleries_items_locales AS il ON
i.id=il.item_id AND il.language='en'  LEFT OUTER JOIN
oktopusV2_mod_galleries AS g ON g.id=i.gallery_id  LEFT
OUTER JOIN oktopusV2_mod_galleries_locales AS gl ON
g.id=gl.gallery_id AND gl.language='en' WHERE 1  AND
i.gallery_id=2 AND il.language='en' AND i.active=1 ORDER BY
i.ord ASC 
SELECT t.active, t.ord, t.locked, t.password, t.tpl,
t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level,
l.title, l.title_tag, l.title_seo, l.slug, l.content,
l.meta_description, l.meta_keywords FROM
oktopusV2_mod_galleries AS t JOIN
oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id
AND l.language = "en" WHERE t.id = 2
SELECT t.active, t.ord, t.locked, t.password, t.tpl,
t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level,
l.title, l.title_tag, l.title_seo, l.slug, l.content,
l.meta_description, l.meta_keywords FROM
oktopusV2_mod_galleries AS t JOIN
oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id
AND l.language = "en" WHERE nleft <= 1 AND nright >= 2 ORDER
BY level
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) >
0) ORDER BY p.rubrique DESC
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) >
0) ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8`	0.00042
2	`SELECT u., g., o.logged, o.csrf_token, o.prev_url FROM oktopusV2_core_users AS u INNER JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id LEFT JOIN oktopusV2_core_users_online AS o ON o.ident='3.238.4.24' WHERE u.id=1`	0.00378
3	`UPDATE oktopusV2_core_users_online SET logged=1603194976, prev_url='https://www.hotel-lecanter.fr/en/gallery-outside-view' WHERE ident='3.238.4.24'`	0.00155
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00261
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00234
6	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00143
7	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut = '1' AND c.moyen_paiement IN('cheque','virement','telephone') ORDER BY date_reservation DESC	0.00465
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00420
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00073
10	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00207
11	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut IN (1,11) ORDER BY date_reservation DESC	0.00313
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00200
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00154
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00091
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00139
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00062
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00068
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00069
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00061
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00067
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00062
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00060
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00058
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00070
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00058
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00067
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00059
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00063
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00062
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00059
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00055
32	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00067
33	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND acompte != 0 AND mail_2eme_paiement IS NULL AND cl.id_reservation_statut = '11' ORDER BY date_reservation DESC	0.00381
34	`SELECT r., rl., COUNT(p.id) AS num_items FROM oktopusV2_mod_galleries AS r LEFT JOIN oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id LEFT JOIN oktopusV2_mod_galleries_items AS p ON r.id=p.gallery_id WHERE 1 AND rl.slug='outside-view' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00509
35	`SELECT r., rl., COUNT(p.id) AS num_items FROM oktopusV2_mod_galleries AS r LEFT JOIN oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id LEFT JOIN oktopusV2_mod_galleries_items AS p ON r.id=p.gallery_id WHERE 1 AND rl.language='en' AND r.parent_id=2 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00188
36	SELECT i.id, i.user_id, i.gallery_id, i.active, i.created_at, i.updated_at, i.image, i.tpl, i.ord, il.language, il.title, il.subtitle, il.title_tag, il.title_seo, il.slug, il.content, il.meta_description, il.meta_keywords, il.words, gl.title AS gallery_title, gl.slug AS gallery_slug, g.items_tpl AS gallery_items_tpl FROM oktopusV2_mod_galleries_items AS i INNER JOIN oktopusV2_mod_galleries_items_locales AS il ON i.id=il.item_id AND il.language='en' LEFT OUTER JOIN oktopusV2_mod_galleries AS g ON g.id=i.gallery_id LEFT OUTER JOIN oktopusV2_mod_galleries_locales AS gl ON g.id=gl.gallery_id AND gl.language='en' WHERE 1 AND i.gallery_id=2 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00347
37	`SELECT t.active, t.ord, t.locked, t.password, t.tpl, t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level, l.title, l.title_tag, l.title_seo, l.slug, l.content, l.meta_description, l.meta_keywords FROM oktopusV2_mod_galleries AS t JOIN oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id AND l.language = "en" WHERE t.id = 2`	0.00072
38	`SELECT t.active, t.ord, t.locked, t.password, t.tpl, t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level, l.title, l.title_tag, l.title_seo, l.slug, l.content, l.meta_description, l.meta_keywords FROM oktopusV2_mod_galleries AS t JOIN oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id AND l.language = "en" WHERE nleft <= 1 AND nright >= 2 ORDER BY level`	0.00116
39	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00488
40	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00075

Mémoire utilisée par PHP : 9.65 MB
Pic mémoire allouée par PHP : 10.72 MB
Temps d'execution du script : 0.830 s

Lang : en
Path : gallery-outside-view
Route : galleriesGallery

$okt->page->module : galleries
$okt->page->action : gallery

array ( 'DOCUMENT_ROOT' => '/www/2013/03/sa601/www', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HOSTNAME' => 'WebFront01', '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' => 'close', 'HTTP_HOST' => 'www.hotel-lecanter.fr', 'HTTP_IF_MODIFIED_SINCE' => 'Thu, 13 Aug 2020 03:01:50 GMT', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'HTTP_X_FORWARDED_FOR' => '3.238.4.24', 'HTTP_X_FORWARDED_PORT' => '443', 'HTTP_X_FORWARDED_PROTO' => 'https', 'PATH' => '/bin:/usr/bin', 'PHPRC' => '/home/phpini/hotel-lecanter.fr/php73', 'QUERY_STRING' => 'en/gallery-outside-view', 'REDIRECT_HOSTNAME' => 'WebFront01', 'REDIRECT_QUERY_STRING' => 'en/gallery-outside-view', 'REDIRECT_STATUS' => '200', 'REDIRECT_URL' => '/en/gallery-outside-view', 'REMOTE_ADDR' => '10.1.2.250', 'REMOTE_PORT' => '55584', 'REQUEST_METHOD' => 'GET', 'REQUEST_URI' => '/en/gallery-outside-view', 'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php', 'SCRIPT_NAME' => '/oktopus.php', 'SERVER_ADDR' => '10.1.2.1', 'SERVER_ADMIN' => 'service-client@sitti.fr', 'SERVER_NAME' => 'www.hotel-lecanter.fr', 'SERVER_PORT' => '80', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'SERVER_SIGNATURE' => '

Apache/2.2.22 (Debian) Server at www.hotel-lecanter.fr Port 80

', 'SERVER_SOFTWARE' => 'Apache/2.2.22 (Debian)', 'PHP_SELF' => '/oktopus.php', 'REQUEST_TIME_FLOAT' => 1603194976.626312, 'REQUEST_TIME' => 1603194976, )

array ( 'OKT_START_TIME' => 1603194976.6374719, 'OKT_ROOT_PATH' => '/www/2013/03/sa601/www', 'OKT_INC_DIR' => 'oktInc', 'OKT_INC_PATH' => '/www/2013/03/sa601/www/oktInc', 'OKT_UPLOAD_DIR' => 'upload', 'OKT_UPLOAD_PATH' => '/www/2013/03/sa601/www/upload', 'OKT_COMMON_DIR' => 'oktCommon', 'OKT_COMMON_PATH' => '/www/2013/03/sa601/www/oktCommon', 'OKT_MODULES_DIR' => 'oktModules', 'OKT_MODULES_PATH' => '/www/2013/03/sa601/www/oktModules', 'OKT_PUBLIC_DIR' => 'oktPublic', 'OKT_PUBLIC_PATH' => '/www/2013/03/sa601/www/oktPublic', 'OKT_CACHE_DIR' => 'oktCache', 'OKT_CACHE_PATH' => '/www/2013/03/sa601/www/oktCache', 'OKT_GLOBAL_CACHE_FILENAME' => 'static.php', 'OKT_GLOBAL_CACHE_FILE' => '/www/2013/03/sa601/www/oktCache/static.php', 'OKT_CONFIG_DIR' => 'oktConf', 'OKT_CONFIG_PATH' => '/www/2013/03/sa601/www/oktConf', 'OKT_LOG_DIR' => 'oktLog', 'OKT_LOG_PATH' => '/www/2013/03/sa601/www/oktLog', 'OKT_THEMES_DIR' => 'oktThemes', 'OKT_THEMES_PATH' => '/www/2013/03/sa601/www/oktThemes', 'OKT_CLASSES_PATH' => '/www/2013/03/sa601/www/oktInc/classes', 'OKT_LOCALES_PATH' => '/www/2013/03/sa601/www/oktInc/locales', 'OKT_VENDOR_PATH' => '/www/2013/03/sa601/www/oktInc/vendor', 'OKT_MIN_DIR' => 'minify', 'OKT_MIN_PATH' => '/www/2013/03/sa601/www/oktCache/minify', 'OKT_MINGROUP_DIR' => 'groups', 'OKT_MINGROUP_PATH' => '/www/2013/03/sa601/www/oktCache/minify/groups', 'OKT_COOKIE_AUTH_NAME' => 'okt_auth', 'OKT_COOKIE_AUTH_FROM' => 'okt_auth_from', 'OKT_COOKIE_LANGUAGE' => 'okt_language', 'OKT_COOKIE_CONSENT' => 'okt_consent', 'OKT_ENVIRONMENT' => 'prod', 'OKT_XDEBUG' => false, 'OKT_FILENAME' => 'oktopus.php', 'OKT_DIRNAME' => '/', 'OKT_ADMIN_DIR' => 'administration', 'OKT_ADMIN_HEADER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header.php', 'OKT_ADMIN_HEADER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/header_ajax.php', 'OKT_ADMIN_HEADER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/header_cnx.php', 'OKT_ADMIN_FOOTER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer.php', 'OKT_ADMIN_FOOTER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/footer_ajax.php', 'OKT_ADMIN_FOOTER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/footer_cnx.php', 'OKT_ADMIN_HEADER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header_simple.php', 'OKT_ADMIN_FOOTER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer_simple.php', 'OKT_ADMIN_LOGIN_PAGE' => 'connexion.php', 'OKT_GOOGLE_GEOCODE_KEY' => 'AIzaSyAZsu4vldPq58x4FWGs35p3ytzrAZ67xVI', 'OKT_THUMB_COMPRESSION' => 80, 'OKT_SEO_LIMIT_TITLE' => 75, 'OKT_SEO_LIMIT_DESCRIPTION' => 200, 'OKT_DB_LOG_USER' => 'ledns-oktolog', 'OKT_DB_LOG_PWD' => '7gv2536uGfiImFLl', 'OKT_ROUND_HALF_UP' => 1, 'OKT_ROUND_HALF_DOWN' => 2, 'OKT_ROUND_HALF_EVEN' => 3, 'OKT_ROUND_HALF_ODD' => 4, 'OKT_ROUND_UP' => 5, 'OKT_ROUND_DOWN' => 6, 'JSON_ENCODE_ALL' => 271, 'FILTER_VALIDATE_BOOL' => 258, 'HTMLPURIFIER_PREFIX' => '/www/2013/03/sa601/www/oktInc/vendor/composer/vendor/ezyang/htmlpurifier/library', 'OKT_DB_HOST' => 'sql5', 'OKT_DB_NAME' => 'sa601', 'OKT_DB_USER' => 'sa601', 'OKT_DB_PWD' => 'GF6NAnxDTCogUrzE', 'OKT_DB_PREFIX' => 'oktopusV2_', 'OKT_MODULES_URL' => '/oktModules', 'OKT_COMMON_URL' => '/oktCommon', 'OKT_UPLOAD_URL' => '/upload', 'OKT_DIGESTS' => '/www/2013/03/sa601/www/oktInc/digests', 'OKT_THEME_DEFAULT_PATH' => '/www/2013/03/sa601/www/oktThemes/default', 'OKT_THEME_DEFAULT' => '/oktThemes/default', 'OKT_THEME' => '/oktThemes/ra154-s', 'OKT_THEME_PATH' => '/www/2013/03/sa601/www/oktThemes/ra154-s', 'OKT_MAX_UPLOAD_SIZE' => 52428800, 'OKT_DEBUG' => true, 'OKT_PART' => 'public', '__DB_PREFIX_TVA__' => 'oktopusV2_mod_tva_', '__DB_PREFIX_GEO__' => 'oktopusV2_mod_geographie_', '__DB_PREFIX_RESA__' => 'oktopusV2_mod_resa_', )

array ( 'title' => array ( 'fr' => 'L\'hôtel Le Canter', 'en' => '', 'es' => '', ), 'desc' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'title_tag' => array ( 'fr' => 'L\'hôtel Le Canter', 'en' => '', 'es' => '', ), 'meta_description' => array ( 'fr' => 'L\'hôtel Le Canter est un hôtel d\'hébergement séminaire et petit déjeuner près de Saumur dans le Maine-et-Loire (49).', 'en' => '', 'es' => '', ), 'meta_keywords' => array ( 'fr' => 'hébergement séminaire saumur, chambres hotel saumur, hôtel séminaire et petit déjeuner saumur, hôtel séminaire saumur, réserver hôtel saumur, hébergement séminaire et petit déjeuner saumur, chambres hôtel et petit déjeuner saumur, hébergement séminaire 49, chambres hotel 49, hôtel séminaire et petit déjeuner 49, hôtel séminaire 49, réserver hôtel 49, hébergement séminaire et petit déjeuner 49, chambres hôtel et petit déjeuner 49, hébergement séminaire maine et loire, chambres hotel maine et loire, hôtel séminaire et petit déjeuner maine et loire, hôtel séminaire maine et loire, réserver hôtel maine et loire, hébergement séminaire et petit déjeuner maine et loire, chambres hôtel et petit déjeuner maine et loire', 'en' => '', 'es' => '', ), 'list_address' => array ( 0 => array ( 'libelle' => '', 'company_name' => '', 'street' => '1 Place De La Sénatorerie', 'street_2' => '', 'code' => '49400', 'city' => 'Saint-Hilaire-Saint-Florent', 'country' => 'France', 'tel' => '02 41 50 37 88', 'mobile' => '', 'fax' => '', 'email' => 'contact@hotel-lecanter.fr', 'lat' => '47.2647675', 'long' => '-0.1000264', 'config_address_1' => '1', 'config_address_2' => '1', ), ), 'list_schedule' => array ( 0 => array ( 'fr' => '', 'en' => '', 'es' => '', ), ), 'company' => array ( 'name' => 'OSER', 'com_name' => 'L\'hôtel Le Canter', 'siret' => '853 210 250 00017', 'tva_intra' => 'FR00853210250', ), 'plan' => array ( 'affichage' => 0, 'lat' => '', 'long' => '', ), 'leader' => array ( 'name' => 'SIGURET', 'firstname' => 'Olivier', ), 'courriel_address' => 'prodokto@gmail.com', 'courriel_name' => 'L\'hôtel Le Canter', 'courriel_transport' => 'sendmail', 'courriel_smtp' => array ( 'host' => '', 'port' => 25, 'username' => 'dev@sitti.fr', 'password' => 'cMGhbnTL', ), 'courriel_sendmail' => '/usr/sbin/sendmail -t -i', 'courriel_theme' => '1', 'theme' => 'ra154-s', 'theme_mobile' => '', 'theme_tablet' => '', 'public_theme' => 'base', 'form_theme' => 'jiro', 'button' => array ( 'primary_type' => 'couleur', 'effect' => 'bouton_fade1', 'shadow_text' => '1', 'shadow_box' => 0, 'secondary_type' => 'bordure', 'bloc3' => '1', 'diapo' => '1', ), 'menu' => array ( 'type' => '6', 'orientation' => '1', 'compatible' => array ( 0 => '6', ), ), 'menu_bas' => array ( 'enable_menu_deroulant' => false, 'show_rubrique_principale' => true, ), 'enable_admin_bar' => true, 'enable_backtop' => true, 'set_theme_column' => '2', 'admin_sidebar_position' => 0, 'admin_dashboard' => 0, 'admin_theme' => 'admin', 'admin_compress_output' => false, 'panel_construction' => array ( 'enable' => 0, 'text' => 'Découvrez prochainement notre site internet', 'color' => '000000', 'bgcolor' => 'ffffff', ), 'language' => 'es', 'timezone' => 'Europe/Madrid', 'admin_lang_switcher' => true, 'app_path' => '/', 'domain' => 'www.hotel-lecanter.fr', 'internal_router' => true, 'default_route' => array ( 'class' => 'pagesController', 'method' => 'pagesItem', 'args' => 'accueil', ), 'custom_routes' => array ( ), 'redirect_404_to_home' => false, 'app_file' => 'oktopus.php', 'public_maintenance_mode' => false, 'admin_maintenance_mode' => false, 'modules_repositories_enabled' => true, 'modules_repositories' => array ( 'SITTI modules' => 'http://oktopus.ledns.net/modules/%VERSION%/index.xml', ), 'themes_repositories_enabled' => true, 'themes_repositories' => array ( 'SITTI thèmes' => 'http://oktopus.ledns.net/themes/%VERSION%/index.xml', ), 'debug_enabled' => true, 'stop_redirect_on_error' => true, 'xdebug_enabled' => false, 'antispam_filters' => 'a:0:{}', 'use_admin_lang_switcher' => NULL, 'update_enabled' => true, 'update_url' => 'http://oktopus.ledns.net/packages/versions.xml', 'update_type' => 'stable', 'api_enabled' => true, 'api_key' => '2285ff62ae73262abf78d40aa266e65cd12b7fbbb11cae988a1626c9cb760c3d', 'auth_security' => array ( 'enabled' => true, 'allowed_retries' => 5, 'lockout_duration' => 30, 'valid_duration' => 12, 'whitelist' => array ( ), 'blacklist' => array ( ), ), 'minify_complete_enable' => false, 'minify_css_admin' => array ( 0 => '%COMMON_URL%/css/bootstrap.3.2.0.min.css', 1 => '%COMMON_URL%/ui-themes/%ADMIN_THEME%/jquery-ui.css', 2 => '%COMMON_URL%/js/jquery/popup/jquery.popup.css', 3 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.css', 4 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.css', ), 'minify_js_admin' => array ( 0 => '%COMMON_URL%/js/jquery/jquery.min.js', 1 => '%COMMON_URL%/js/jquery/jquery-migrate.min.js', 2 => '%COMMON_URL%/js/jquery/cookie/jquery.cookie.min.js', 3 => '%COMMON_URL%/js/jquery/metadata/jquery.metadata.min.js', 4 => '%COMMON_URL%/js/jquery/ui/jquery-ui.min.js', 5 => '%COMMON_URL%/js/jquery/ui/i18n/jquery-ui-i18n.min.js', 6 => '%COMMON_URL%/js/jquery/popup/jquery.popup.js', 7 => '%COMMON_URL%/js/jquery/validate/jquery.validate.min.js', 8 => '%COMMON_URL%/js/jquery/validate/additional-methods.min.js', 9 => '%COMMON_URL%/js/jquery/util/jquery.util.js', 10 => '%COMMON_URL%/js/jquery/maxlength/jquery.maxlength.min.js', 11 => '%COMMON_URL%/js/jquery/slimscroll.min.js', 12 => '%COMMON_URL%/js/jquery/moment.js', 13 => '%COMMON_URL%/js/jquery/util/jquery.util.js', 14 => '%COMMON_URL%/js/jquery/alphanumeric/jquery.alphanumeric.js', 15 => '%COMMON_URL%/js/jquery/validform/jquery.validform.js', 16 => '%COMMON_URL%/js/jquery/sprintf/jquery.sprintf.js', 17 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.js', 18 => '%COMMON_URL%/js/jquery/form/jquery.form.js', 19 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.js', 20 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.js', 21 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.pager.js', 22 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.filter.js', 23 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.total.js', 24 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.customparser.js', 25 => '%COMMON_URL%/js/jquery/maskinput/src/jquery.maskinput.js', 26 => '%COMMON_URL%/js/common_admin.js', ), 'minify_css_public' => array ( ), 'minify_js_public' => array ( ), 'log_admin' => array ( 'ttl_months' => 3, ), 'htmlpurifier_disabled' => false, 'round' => array ( 'rule' => 1, 'precision' => 2, ), 'slug_type' => 'ascii', 'google_analytic' => 'UA-172001023-21', 'google_conversion_id' => '', 'google_conversion_label_contact' => '', 'google_conversion_label_vente' => '', 'google_code_appel_ak' => '', 'google_code_appel_cl' => '', 'google_phone' => '', 'facebook_pixel_id' => '', 'cnil_number' => '', 'enable_logo_editeur' => false, 'enable_w3c' => false, 'enable_fixedMenu' => '2', 'enable_rgpd' => 0, 'activite' => 0, 'format_date' => '%A %d %B %Y', 'theme_vars' => array ( 'titre_menu' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'titre_adresse' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'texte_tel' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'slogan1' => array ( 'fr' => 'Bienvenue à l\'hôtel-bar Le Canter', 'en' => 'Welcome to Le Canter hotel bar', 'es' => 'Bienvenido al bar del hotel Le Canter', ), 'slogan2' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'slogan3' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'btn1' => array ( 'fr' => 'Réservez', 'en' => 'Book', 'es' => 'Libro', ), 'btn2' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'titre_bas' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'texte_bas' => array ( 'fr' => '', 'en' => '', 'es' => '', ), ), 'breadcrumb' => array ( 'default' => 'modele-1', 'usables' => array ( ), ), 'pager' => array ( 'nb_page_display' => '3', 'enable_group' => false, 'templates' => array ( 'default' => 'modele-1', 'usables' => array ( ), ), ), 'filter' => array ( 'default' => 'modele-1', 'usables' => array ( ), ), 'error' => array ( 'default' => 'modele-1', 'usables' => array ( ), ), 'debug_bar' => array ( 'admin' => true, 'public' => true, 'tabs' => array ( 'super_globales' => true, 'app' => true, 'logs' => true, 'db' => true, 'tools' => true, ), ), 'enable_theme_multi' => false, 'news_feed' => array ( 'enabled' => false, 'url' => '', ), 'dpo' => array ( 'name' => '', ), 'app_host' => 'https://www.hotel-lecanter.fr', 'app_url_court' => 'https://www.hotel-lecanter.fr/', 'self_uri' => 'https://www.hotel-lecanter.fr/en/gallery-outside-view', 'address' => array ( 'libelle' => '', 'company_name' => '', 'street' => '1 Place De La Sénatorerie', 'street_2' => '', 'code' => '49400', 'city' => 'Saint-Hilaire-Saint-Florent', 'country' => 'France', 'tel' => '02 41 50 37 88', 'mobile' => '', 'fax' => '', 'email' => 'contact@hotel-lecanter.fr', 'lat' => '47.2647675', 'long' => '-0.1000264', 'config_address_1' => '1', 'config_address_2' => '1', ), 'gps' => array ( 'libelle' => '', 'company_name' => '', 'street' => '1 Place De La Sénatorerie', 'street_2' => '', 'code' => '49400', 'city' => 'Saint-Hilaire-Saint-Florent', 'country' => 'France', 'tel' => '02 41 50 37 88', 'mobile' => '', 'fax' => '', 'email' => 'contact@hotel-lecanter.fr', 'lat' => '47.2647675', 'long' => '-0.1000264', 'config_address_1' => '1', 'config_address_2' => '1', ), 'schedule' => array ( 'fr' => '', 'en' => '', 'es' => '', ), 'company_name' => 'L\'hôtel Le Canter', 'app_url' => 'https://www.hotel-lecanter.fr/en/', )

array ( 'id' => '1', 'group_id' => '3', 'civility' => '0', 'active' => '1', 'username' => 'Guest', 'lastname' => '', 'firstname' => '', 'password' => 'Guest', 'salt' => NULL, 'email' => '', 'timezone' => 'Europe/Madrid', 'language' => 'en', 'registered' => '0', 'registration_ip' => '0.0.0.0', 'last_visit' => '1595008738', 'activate_string' => NULL, 'activate_key' => NULL, 'title' => 'Invité', 'perms' => array ( ), 'group_type' => 'C', 'logged' => '1603194876', 'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20', 'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation/standard-single-room-for-one-person/6/0', 'is_guest' => true, 'is_admin' => false, 'is_superadmin' => false, )

ID	Query	Time
1	`SET NAMES utf8`	0.00042
2	`SELECT u., g., o.logged, o.csrf_token, o.prev_url FROM oktopusV2_core_users AS u INNER JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id LEFT JOIN oktopusV2_core_users_online AS o ON o.ident='3.238.4.24' WHERE u.id=1`	0.00378
3	`UPDATE oktopusV2_core_users_online SET logged=1603194976, prev_url='https://www.hotel-lecanter.fr/en/gallery-outside-view' WHERE ident='3.238.4.24'`	0.00155
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00261
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00234
6	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00143
7	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut = '1' AND c.moyen_paiement IN('cheque','virement','telephone') ORDER BY date_reservation DESC	0.00465
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00420
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00073
10	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00207
11	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut IN (1,11) ORDER BY date_reservation DESC	0.00313
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00200
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00154
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00091
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00139
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00062
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00068
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00069
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00061
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00067
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00062
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00060
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00058
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00070
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00058
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00067
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00059
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00063
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00062
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00059
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00055
32	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00067
33	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND acompte != 0 AND mail_2eme_paiement IS NULL AND cl.id_reservation_statut = '11' ORDER BY date_reservation DESC	0.00381
34	`SELECT r., rl., COUNT(p.id) AS num_items FROM oktopusV2_mod_galleries AS r LEFT JOIN oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id LEFT JOIN oktopusV2_mod_galleries_items AS p ON r.id=p.gallery_id WHERE 1 AND rl.slug='outside-view' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00509
35	`SELECT r., rl., COUNT(p.id) AS num_items FROM oktopusV2_mod_galleries AS r LEFT JOIN oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id LEFT JOIN oktopusV2_mod_galleries_items AS p ON r.id=p.gallery_id WHERE 1 AND rl.language='en' AND r.parent_id=2 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00188
36	SELECT i.id, i.user_id, i.gallery_id, i.active, i.created_at, i.updated_at, i.image, i.tpl, i.ord, il.language, il.title, il.subtitle, il.title_tag, il.title_seo, il.slug, il.content, il.meta_description, il.meta_keywords, il.words, gl.title AS gallery_title, gl.slug AS gallery_slug, g.items_tpl AS gallery_items_tpl FROM oktopusV2_mod_galleries_items AS i INNER JOIN oktopusV2_mod_galleries_items_locales AS il ON i.id=il.item_id AND il.language='en' LEFT OUTER JOIN oktopusV2_mod_galleries AS g ON g.id=i.gallery_id LEFT OUTER JOIN oktopusV2_mod_galleries_locales AS gl ON g.id=gl.gallery_id AND gl.language='en' WHERE 1 AND i.gallery_id=2 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00347
37	`SELECT t.active, t.ord, t.locked, t.password, t.tpl, t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level, l.title, l.title_tag, l.title_seo, l.slug, l.content, l.meta_description, l.meta_keywords FROM oktopusV2_mod_galleries AS t JOIN oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id AND l.language = "en" WHERE t.id = 2`	0.00072
38	`SELECT t.active, t.ord, t.locked, t.password, t.tpl, t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level, l.title, l.title_tag, l.title_seo, l.slug, l.content, l.meta_description, l.meta_keywords FROM oktopusV2_mod_galleries AS t JOIN oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id AND l.language = "en" WHERE nleft <= 1 AND nright >= 2 ORDER BY level`	0.00116
39	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00488
40	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00075

Query

Time

SET NAMES utf8

0.00042

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='3.238.4.24' WHERE u.id=1

0.00378

UPDATE oktopusV2_core_users_online SET logged=1603194976,
prev_url='https://www.hotel-lecanter.fr/en/gallery-outside-view'
WHERE ident='3.238.4.24'

0.00155

SELECT id_selection FROM oktopusV2_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP()

0.00261

SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

0.00234

SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC

0.00143

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC

0.00465

SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

0.00420

SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

0.00073

SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC

0.00207

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC

0.00313

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '81'  ORDER BY index_selection,
libelle

0.00200

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '80'  ORDER BY index_selection,
libelle

0.00154

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '79'  ORDER BY index_selection,
libelle

0.00091

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '78'  ORDER BY index_selection,
libelle

0.00139

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '76'  ORDER BY index_selection,
libelle

0.00062

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '75'  ORDER BY index_selection,
libelle

0.00068

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '74'  ORDER BY index_selection,
libelle

0.00069

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '73'  ORDER BY index_selection,
libelle

0.00061

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '72'  ORDER BY index_selection,
libelle

0.00067

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '39'  ORDER BY index_selection,
libelle

0.00062

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '37'  ORDER BY index_selection,
libelle

0.00060

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '26'  ORDER BY index_selection,
libelle

0.00058

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '24'  ORDER BY index_selection,
libelle

0.00070

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '23'  ORDER BY index_selection,
libelle

0.00058

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '21'  ORDER BY index_selection,
libelle

0.00067

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '20'  ORDER BY index_selection,
libelle

0.00059

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '19'  ORDER BY index_selection,
libelle

0.00063

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '18'  ORDER BY index_selection,
libelle

0.00062

 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '15'  ORDER BY index_selection,
libelle

0.00059

SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'

0.00055

SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC

0.00067

 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC

0.00381

SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV2_mod_galleries AS r LEFT JOIN
oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV2_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.slug='outside-view' AND
rl.language='en' AND r.active=1  GROUP BY r.id ORDER BY
nleft asc

0.00509

SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV2_mod_galleries AS r LEFT JOIN
oktopusV2_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV2_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.language='en' AND
r.parent_id=2 AND r.active=1  GROUP BY r.id ORDER BY nleft
asc

0.00188

SELECT i.id, i.user_id, i.gallery_id, i.active,
i.created_at, i.updated_at, i.image, i.tpl, i.ord,
il.language, il.title, il.subtitle, il.title_tag,
il.title_seo, il.slug, il.content, il.meta_description,
il.meta_keywords, il.words, gl.title AS gallery_title,
gl.slug AS gallery_slug, g.items_tpl AS gallery_items_tpl
FROM oktopusV2_mod_galleries_items AS i  INNER JOIN
oktopusV2_mod_galleries_items_locales AS il ON
i.id=il.item_id AND il.language='en'  LEFT OUTER JOIN
oktopusV2_mod_galleries AS g ON g.id=i.gallery_id  LEFT
OUTER JOIN oktopusV2_mod_galleries_locales AS gl ON
g.id=gl.gallery_id AND gl.language='en' WHERE 1  AND
i.gallery_id=2 AND il.language='en' AND i.active=1 ORDER BY
i.ord ASC

0.00347

SELECT t.active, t.ord, t.locked, t.password, t.tpl,
t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level,
l.title, l.title_tag, l.title_seo, l.slug, l.content,
l.meta_description, l.meta_keywords FROM
oktopusV2_mod_galleries AS t JOIN
oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id
AND l.language = "en" WHERE t.id = 2

0.00072

SELECT t.active, t.ord, t.locked, t.password, t.tpl,
t.items_tpl, t.id, t.parent_id, t.nleft, t.nright, t.level,
l.title, l.title_tag, l.title_seo, l.slug, l.content,
l.meta_description, l.meta_keywords FROM
oktopusV2_mod_galleries AS t JOIN
oktopusV2_mod_galleries_locales AS l ON t.id = l.gallery_id
AND l.language = "en" WHERE nleft <= 1 AND nright >= 2 ORDER
BY level

0.00116

SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) >
0) ORDER BY p.rubrique DESC

0.00488

SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/gallery-outside-view', pl.rubrique_slug) >
0) ORDER BY p.rubrique DESC

0.00075