Tourism

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

_GET

array (
  'en/tourism' => '',
)

_SERVER

array (
  'DOCUMENT_ROOT' => '/www/2013/03/sa601/www',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HOSTNAME' => 'WebFront03',
  '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' => 'Tue, 29 Sep 2020 17:17:16 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/tourism',
  'REDIRECT_HOSTNAME' => 'WebFront03',
  'REDIRECT_QUERY_STRING' => 'en/tourism',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/en/tourism',
  'REMOTE_ADDR' => '10.1.2.250',
  'REMOTE_PORT' => '33668',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/en/tourism',
  'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php',
  'SCRIPT_NAME' => '/oktopus.php',
  'SERVER_ADDR' => '10.1.2.3',
  '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' => 1603194587.4129491,
  'REQUEST_TIME' => 1603194587,
)

_REQUEST

array (
  'en/tourism' => '',
)

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' => 1603194587.4172349,
  '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/tourism',
  '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' => '1603194529',
  'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20',
  'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation/superior-quadruple-room/12/0',
  'is_guest' => true,
  'is_admin' => false,
  'is_superadmin' => false,
)

#	type	fichier	ligne	classe	fonction	message


SET NAMES utf8
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='3.238.4.24' WHERE u.id=1
UPDATE oktopusV2_core_users_online SET logged=1603194587,
prev_url='https://www.hotel-lecanter.fr/en/tourism' 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 p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV2_mod_pages AS p  INNER JOIN
oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1  AND
pl.language='en'  AND pl.slug='tourism' AND p.active=1 ORDER
BY p.created_at 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.language='en' AND
r.active=1  GROUP BY r.id ORDER BY nleft asc 
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV2_mod_map AS m 
LEFT JOIN oktopusV2_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='en' WHERE 1  AND ml.language='en' AND
m.active=1 ORDER BY m.created_at DESC 
SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV2_mod_pages AS p  INNER JOIN
oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1  AND
pl.language='en' AND p.active=1 ORDER BY p.created_at DESC 
SELECT page_id, group_id, type FROM
oktopusV2_mod_pages_permissions WHERE page_id=6 
SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id,
f.bloc, f.colonne, f.picto, f.options, f.info_personnelle,
fl.language, fl.title, fl.description, fl.value, fl.legend
FROM oktopusV2_mod_pages_forms_fields AS f  LEFT JOIN
oktopusV2_mod_pages_forms_fields_locales AS fl ON
fl.field_id=f.id WHERE 1  AND active>0  AND page_id=6 AND
fl.language='en' ORDER BY ord ASC 
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/tourism',
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/tourism',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8`	0.00044
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.00375
3	`UPDATE oktopusV2_core_users_online SET logged=1603194587, prev_url='https://www.hotel-lecanter.fr/en/tourism' WHERE ident='3.238.4.24'`	0.00061
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00207
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00158
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.00094
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.00296
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00380
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00306
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.00057
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.00271
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00259
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00053
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00052
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00054
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00052
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00053
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00049
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00050
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00050
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00049
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00049
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00049
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00055
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00048
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00047
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00047
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00047
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00054
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00049
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00073
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.00089
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.00232
34	SELECT p.id, p.user_id, p.category_id, p.active, p.created_at, p.updated_at, p.images, p.files, p.tpl, p.position, pl.language, pl.title, pl.subtitle, pl.title_tag, pl.title_seo, pl.slug, pl.content, pl.meta_description, pl.meta_keywords, pl.words, rl.title AS category_title, rl.slug AS category_slug, rl.title_tag AS category_title_tag, r.items_tpl AS category_items_tpl, p.recipients_to, p.recipients_cc, p.recipients_bcc, p.from_to, p.captcha, p.conversion_google, p.from_copy, pl.subject FROM oktopusV2_mod_pages AS p INNER JOIN oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND pl.language='en' LEFT OUTER JOIN oktopusV2_mod_pages_categories AS r ON r.id=p.category_id LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND pl.language='en' AND pl.slug='tourism' AND p.active=1 ORDER BY p.created_at DESC	0.00488
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.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00408
36	`SELECT m.*, ml.language, ml.title, ml.title_tag, ml.title_seo, ml.slug, ml.meta_description, ml.meta_keywords, ml.content FROM oktopusV2_mod_map AS m LEFT JOIN oktopusV2_mod_map_locales AS ml ON m.id=ml.id_map AND ml.language='en' WHERE 1 AND ml.language='en' AND m.active=1 ORDER BY m.created_at DESC`	0.00134
37	SELECT p.id, p.user_id, p.category_id, p.active, p.created_at, p.updated_at, p.images, p.files, p.tpl, p.position, pl.language, pl.title, pl.subtitle, pl.title_tag, pl.title_seo, pl.slug, pl.content, pl.meta_description, pl.meta_keywords, pl.words, rl.title AS category_title, rl.slug AS category_slug, rl.title_tag AS category_title_tag, r.items_tpl AS category_items_tpl, p.recipients_to, p.recipients_cc, p.recipients_bcc, p.from_to, p.captcha, p.conversion_google, p.from_copy, pl.subject FROM oktopusV2_mod_pages AS p INNER JOIN oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND pl.language='en' LEFT OUTER JOIN oktopusV2_mod_pages_categories AS r ON r.id=p.category_id LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND pl.language='en' AND p.active=1 ORDER BY p.created_at DESC	0.00159
38	`SELECT page_id, group_id, type FROM oktopusV2_mod_pages_permissions WHERE page_id=6`	0.00098
39	`SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id, f.bloc, f.colonne, f.picto, f.options, f.info_personnelle, fl.language, fl.title, fl.description, fl.value, fl.legend FROM oktopusV2_mod_pages_forms_fields AS f LEFT JOIN oktopusV2_mod_pages_forms_fields_locales AS fl ON fl.field_id=f.id WHERE 1 AND active>0 AND page_id=6 AND fl.language='en' ORDER BY ord ASC`	0.00156
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/tourism', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00393
41	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/tourism', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00072

Mémoire utilisée par PHP : 9.66 MB
Pic mémoire allouée par PHP : 10.74 MB
Temps d'execution du script : 0.569 s

Lang : en
Path : tourism
Route : pagesItem

$okt->page->module : pages
$okt->page->action : item

array ( 'DOCUMENT_ROOT' => '/www/2013/03/sa601/www', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HOSTNAME' => 'WebFront03', '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' => 'Tue, 29 Sep 2020 17:17:16 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/tourism', 'REDIRECT_HOSTNAME' => 'WebFront03', 'REDIRECT_QUERY_STRING' => 'en/tourism', 'REDIRECT_STATUS' => '200', 'REDIRECT_URL' => '/en/tourism', 'REMOTE_ADDR' => '10.1.2.250', 'REMOTE_PORT' => '33668', 'REQUEST_METHOD' => 'GET', 'REQUEST_URI' => '/en/tourism', 'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php', 'SCRIPT_NAME' => '/oktopus.php', 'SERVER_ADDR' => '10.1.2.3', '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' => 1603194587.4129491, 'REQUEST_TIME' => 1603194587, )

array ( 'OKT_START_TIME' => 1603194587.4172349, '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/tourism', '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' => '1603194529', 'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20', 'prev_url' => 'https://www.hotel-lecanter.fr/en/reservation/superior-quadruple-room/12/0', 'is_guest' => true, 'is_admin' => false, 'is_superadmin' => false, )

ID	Query	Time
1	`SET NAMES utf8`	0.00044
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.00375
3	`UPDATE oktopusV2_core_users_online SET logged=1603194587, prev_url='https://www.hotel-lecanter.fr/en/tourism' WHERE ident='3.238.4.24'`	0.00061
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00207
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00158
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.00094
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.00296
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00380
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00306
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.00057
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.00271
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00259
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00053
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00052
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00054
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00052
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00053
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00049
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00050
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00050
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00049
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00049
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00049
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00055
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00048
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00047
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00047
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00047
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00054
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00049
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00073
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.00089
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.00232
34	SELECT p.id, p.user_id, p.category_id, p.active, p.created_at, p.updated_at, p.images, p.files, p.tpl, p.position, pl.language, pl.title, pl.subtitle, pl.title_tag, pl.title_seo, pl.slug, pl.content, pl.meta_description, pl.meta_keywords, pl.words, rl.title AS category_title, rl.slug AS category_slug, rl.title_tag AS category_title_tag, r.items_tpl AS category_items_tpl, p.recipients_to, p.recipients_cc, p.recipients_bcc, p.from_to, p.captcha, p.conversion_google, p.from_copy, pl.subject FROM oktopusV2_mod_pages AS p INNER JOIN oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND pl.language='en' LEFT OUTER JOIN oktopusV2_mod_pages_categories AS r ON r.id=p.category_id LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND pl.language='en' AND pl.slug='tourism' AND p.active=1 ORDER BY p.created_at DESC	0.00488
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.active=1 GROUP BY r.id ORDER BY nleft asc`	0.00408
36	`SELECT m.*, ml.language, ml.title, ml.title_tag, ml.title_seo, ml.slug, ml.meta_description, ml.meta_keywords, ml.content FROM oktopusV2_mod_map AS m LEFT JOIN oktopusV2_mod_map_locales AS ml ON m.id=ml.id_map AND ml.language='en' WHERE 1 AND ml.language='en' AND m.active=1 ORDER BY m.created_at DESC`	0.00134
37	SELECT p.id, p.user_id, p.category_id, p.active, p.created_at, p.updated_at, p.images, p.files, p.tpl, p.position, pl.language, pl.title, pl.subtitle, pl.title_tag, pl.title_seo, pl.slug, pl.content, pl.meta_description, pl.meta_keywords, pl.words, rl.title AS category_title, rl.slug AS category_slug, rl.title_tag AS category_title_tag, r.items_tpl AS category_items_tpl, p.recipients_to, p.recipients_cc, p.recipients_bcc, p.from_to, p.captcha, p.conversion_google, p.from_copy, pl.subject FROM oktopusV2_mod_pages AS p INNER JOIN oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND pl.language='en' LEFT OUTER JOIN oktopusV2_mod_pages_categories AS r ON r.id=p.category_id LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1 AND pl.language='en' AND p.active=1 ORDER BY p.created_at DESC	0.00159
38	`SELECT page_id, group_id, type FROM oktopusV2_mod_pages_permissions WHERE page_id=6`	0.00098
39	`SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id, f.bloc, f.colonne, f.picto, f.options, f.info_personnelle, fl.language, fl.title, fl.description, fl.value, fl.legend FROM oktopusV2_mod_pages_forms_fields AS f LEFT JOIN oktopusV2_mod_pages_forms_fields_locales AS fl ON fl.field_id=f.id WHERE 1 AND active>0 AND page_id=6 AND fl.language='en' ORDER BY ord ASC`	0.00156
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/tourism', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00393
41	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/tourism', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00072

Query

Time

SET NAMES utf8

0.00044

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

UPDATE oktopusV2_core_users_online SET logged=1603194587,
prev_url='https://www.hotel-lecanter.fr/en/tourism' WHERE
ident='3.238.4.24'

0.00061

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

0.00207

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

0.00158

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

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

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

0.00380

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

0.00306

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

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

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

0.00259

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

0.00053

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

0.00052

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

0.00054

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

0.00052

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

0.00053

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

0.00049

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

0.00050

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

0.00050

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

0.00049

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

0.00049

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

0.00049

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

0.00055

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

0.00048

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

0.00047

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

0.00047

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

0.00047

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

0.00054

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

0.00049

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

0.00073

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

0.00089

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

SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV2_mod_pages AS p  INNER JOIN
oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1  AND
pl.language='en'  AND pl.slug='tourism' AND p.active=1 ORDER
BY p.created_at DESC

0.00488

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

0.00408

SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV2_mod_map AS m 
LEFT JOIN oktopusV2_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='en' WHERE 1  AND ml.language='en' AND
m.active=1 ORDER BY m.created_at DESC

0.00134

SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject FROM oktopusV2_mod_pages AS p  INNER JOIN
oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_mod_pages_categories_locales AS rl
ON r.id=rl.category_id AND rl.language='en' WHERE 1  AND
pl.language='en' AND p.active=1 ORDER BY p.created_at DESC

0.00159

SELECT page_id, group_id, type FROM
oktopusV2_mod_pages_permissions WHERE page_id=6

0.00098

SELECT f.id, f.page_id, f.active, f.type, f.ord, f.html_id,
f.bloc, f.colonne, f.picto, f.options, f.info_personnelle,
fl.language, fl.title, fl.description, fl.value, fl.legend
FROM oktopusV2_mod_pages_forms_fields AS f  LEFT JOIN
oktopusV2_mod_pages_forms_fields_locales AS fl ON
fl.field_id=f.id WHERE 1  AND active>0  AND page_id=6 AND
fl.language='en' ORDER BY ord ASC

0.00156

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

0.00393

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

0.00072