Superior double room

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

_GET

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

_SERVER

array (
  'DOCUMENT_ROOT' => '/www/2013/03/sa601/www',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HOSTNAME' => 'WebFront04',
  '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:03:06 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-double-room',
  'REDIRECT_HOSTNAME' => 'WebFront04',
  'REDIRECT_QUERY_STRING' => 'en/gallery-superior-double-room',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/en/gallery-superior-double-room',
  'REMOTE_ADDR' => '10.1.2.250',
  'REMOTE_PORT' => '53460',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/en/gallery-superior-double-room',
  'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php',
  'SCRIPT_NAME' => '/oktopus.php',
  'SERVER_ADDR' => '10.1.2.4',
  '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' => 1603195028.706408,
  'REQUEST_TIME' => 1603195028,
)

_REQUEST

array (
  'en/gallery-superior-double-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' => 1603195028.7141089,
  '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-double-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' => '1603195001',
  'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20',
  'prev_url' => 'https://www.hotel-lecanter.fr/fr/chambres-tarifs',
  '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=1603195028,
prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-double-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-double-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=6 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=6 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 = 6
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 <= 5 AND nright >= 6 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-double-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-double-room',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8`	0.00099
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.00034
3	`UPDATE oktopusV2_core_users_online SET logged=1603195028, prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-double-room' WHERE ident='3.238.4.24'`	0.00020
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00023
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00014
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.00017
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.00018
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00034
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00009
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.00015
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.00026
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00013
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00010
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00009
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00012
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00014
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00011
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00012
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00020
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00032
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00010
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00009
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00011
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00011
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00045
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00012
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00021
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00028
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00010
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00010
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00021
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.00020
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.00015
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-double-room' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00242
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=6 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00174
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=6 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00089
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 = 6`	0.00045
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 <= 5 AND nright >= 6 ORDER BY level`	0.00195
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-double-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00042
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-double-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00032

Mémoire utilisée par PHP : 9.73 MB
Pic mémoire allouée par PHP : 10.79 MB
Temps d'execution du script : 0.770 s

Lang : en
Path : gallery-superior-double-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' => 'WebFront04', '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:03:06 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-double-room', 'REDIRECT_HOSTNAME' => 'WebFront04', 'REDIRECT_QUERY_STRING' => 'en/gallery-superior-double-room', 'REDIRECT_STATUS' => '200', 'REDIRECT_URL' => '/en/gallery-superior-double-room', 'REMOTE_ADDR' => '10.1.2.250', 'REMOTE_PORT' => '53460', 'REQUEST_METHOD' => 'GET', 'REQUEST_URI' => '/en/gallery-superior-double-room', 'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php', 'SCRIPT_NAME' => '/oktopus.php', 'SERVER_ADDR' => '10.1.2.4', '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' => 1603195028.706408, 'REQUEST_TIME' => 1603195028, )

array ( 'OKT_START_TIME' => 1603195028.7141089, '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-double-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' => '1603195001', 'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20', 'prev_url' => 'https://www.hotel-lecanter.fr/fr/chambres-tarifs', 'is_guest' => true, 'is_admin' => false, 'is_superadmin' => false, )

ID	Query	Time
1	`SET NAMES utf8`	0.00099
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.00034
3	`UPDATE oktopusV2_core_users_online SET logged=1603195028, prev_url='https://www.hotel-lecanter.fr/en/gallery-superior-double-room' WHERE ident='3.238.4.24'`	0.00020
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00023
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00014
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.00017
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.00018
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00034
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00009
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.00015
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.00026
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00013
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00010
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00009
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00012
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00014
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00011
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00012
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00020
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00032
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00010
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00009
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00011
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00011
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00045
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00012
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00021
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00028
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00010
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00010
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00021
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.00020
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.00015
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-double-room' AND rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00242
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=6 AND r.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00174
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=6 AND il.language='en' AND i.active=1 ORDER BY i.ord ASC	0.00089
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 = 6`	0.00045
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 <= 5 AND nright >= 6 ORDER BY level`	0.00195
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-double-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00042
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-double-room', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00032

Query

Time

SET NAMES utf8

0.00099

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

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

0.00020

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

0.00023

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

0.00014

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

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

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

0.00034

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

0.00009

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

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

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

0.00013

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

0.00010

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

0.00009

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

0.00012

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

0.00014

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

0.00011

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

0.00012

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

0.00020

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

0.00032

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

0.00010

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

0.00009

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

0.00011

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

0.00011

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

0.00045

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

0.00012

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

0.00021

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

0.00028

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

0.00010

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

0.00010

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

0.00021

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

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

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

0.00242

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

0.00174

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

0.00089

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

0.00045

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 <= 5 AND nright >= 6 ORDER
BY level

0.00195

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

0.00042

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

0.00032