Superior triple room

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

_GET

array (
  'en/gallery-superior-triple-room' => '',
)

_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 02:10:07 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-superior-triple-room',
  'REDIRECT_HOSTNAME' => 'WebFront01',
  'REDIRECT_QUERY_STRING' => 'en/gallery-superior-triple-room',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/en/gallery-superior-triple-room',
  'REMOTE_ADDR' => '10.1.2.250',
  'REMOTE_PORT' => '33910',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/en/gallery-superior-triple-room',
  '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' => 1603192111.7612309,
  'REQUEST_TIME' => 1603192111,
)

_REQUEST

array (
  'en/gallery-superior-triple-room' => '',
)

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' => 1603192111.771065,
  '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-superior-triple-room',
  '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' => '1603191897',
  'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20',
  'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation-online',
  '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=1603192112,
prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-triple-room'
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='superior-triple-room'
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=9 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=9 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 = 9
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 <= 11 AND nright >= 12
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-superior-triple-room',
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-superior-triple-room',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8`	0.00064
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.00456
3	`UPDATE oktopusV2_core_users_online SET logged=1603192112, prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-triple-room' WHERE ident='3.238.4.24'`	0.00093
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00193
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00119
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.00126
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.00603
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00064
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00068
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.00213
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.00286
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00145
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00093
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00083
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00146
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00067
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00066
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00062
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00162
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00110
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00067
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00067
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00099
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00066
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00084
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00064
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00363
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00071
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00080
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00068
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00057
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.00114
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.00262
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='superior-triple-room' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00589
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=9 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00222
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=9 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00360
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 = 9`	0.00074
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 <= 11 AND nright >= 12 ORDER BY level`	0.00086
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-superior-triple-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00322
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-superior-triple-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00078

Mémoire utilisée par PHP : 9.64 MB
Pic mémoire allouée par PHP : 10.71 MB
Temps d'execution du script : 1.147 s

Lang : en
Path : gallery-superior-triple-room
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 02:10:07 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-superior-triple-room', 'REDIRECT_HOSTNAME' => 'WebFront01', 'REDIRECT_QUERY_STRING' => 'en/gallery-superior-triple-room', 'REDIRECT_STATUS' => '200', 'REDIRECT_URL' => '/en/gallery-superior-triple-room', 'REMOTE_ADDR' => '10.1.2.250', 'REMOTE_PORT' => '33910', 'REQUEST_METHOD' => 'GET', 'REQUEST_URI' => '/en/gallery-superior-triple-room', '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' => 1603192111.7612309, 'REQUEST_TIME' => 1603192111, )

array ( 'OKT_START_TIME' => 1603192111.771065, '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-superior-triple-room', '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' => '1603191897', 'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20', 'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation-online', 'is_guest' => true, 'is_admin' => false, 'is_superadmin' => false, )

ID	Query	Time
1	`SET NAMES utf8`	0.00064
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.00456
3	`UPDATE oktopusV2_core_users_online SET logged=1603192112, prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-triple-room' WHERE ident='3.238.4.24'`	0.00093
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00193
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00119
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.00126
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.00603
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00064
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00068
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.00213
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.00286
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00145
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00093
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00083
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00146
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00067
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00066
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00062
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00162
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00110
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00067
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00067
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00099
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00066
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00084
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00064
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00363
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00071
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00080
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00068
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00057
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.00114
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.00262
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='superior-triple-room' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00589
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=9 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00222
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=9 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00360
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 = 9`	0.00074
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 <= 11 AND nright >= 12 ORDER BY level`	0.00086
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-superior-triple-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00322
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-superior-triple-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00078

Query

Time

SET NAMES utf8

0.00064

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.00456

UPDATE oktopusV2_core_users_online SET logged=1603192112,
prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-triple-room'
WHERE ident='3.238.4.24'

0.00093

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

0.00193

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

0.00119

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.00126

 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.00603

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

0.00064

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

0.00068

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.00213

 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.00286

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

0.00145

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

0.00093

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

0.00083

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

0.00146

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

0.00067

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

0.00066

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

0.00062

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

0.00162

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

0.00110

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

0.00067

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

0.00067

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

0.00099

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

0.00066

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

0.00084

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

0.00064

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

0.00363

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

0.00071

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

0.00080

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

0.00068

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

0.00057

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.00114

 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.00262

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='superior-triple-room'
AND rl.language='en' AND r.active=1  GROUP BY r.id ORDER BY
nleft asc

0.00589

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=9 AND r.active=1  GROUP BY r.id ORDER BY nleft
asc

0.00222

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=9 AND il.language='en' AND i.active=1 ORDER BY
i.ord ASC

0.00360

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 = 9

0.00074

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 <= 11 AND nright >= 12
ORDER BY level

0.00086

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-superior-triple-room',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

0.00322

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-superior-triple-room',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

0.00078