.::Undergrounds v3.3 Webshells::.

: / home / sc1jaqa5103 / tmp /
Filename : sess_4aeb04dbc50f4a5ddc39745aa60adf2b
back
 PMA_token |s:32:"4c6d626f4a2e6477214251417d66625e"; HMAC_secret |s:16:"5`c)*Yvv0{?0b{W{";auth_type|s:3:"env";browser_access_time|a:2:{s:7:"default";i:1777561262;s:36:"7de0e1a6-ddb7-a9bc-8799-2b667503523e";i:1777565529;}encryption_key|s:32:"�T�z��kMLc�K��z.����R�z�fNF�(";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:2:"fr";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1777561258;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1777561258;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1774501603;s:9:"userprefs";a:2:{s:4:"lang";s:2:"fr";s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:25:"server_1_cpses_sccd19wajf";a:18:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:2:{i:0;s:22:"sc1jaqa5103\_puv\_prod";i:1;s:20:"sc1jaqa5103\_wptgabc";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:17:"Bases de données";s:3:"sql";s:3:"SQL";s:6:"status";s:5:"État";s:6:"rights";s:12:"Utilisateurs";s:6:"export";s:8:"Exporter";s:6:"import";s:8:"Importer";s:8:"settings";s:11:"Paramètres";s:6:"binlog";s:15:"Journal binaire";s:11:"replication";s:12:"Réplication";s:4:"vars";s:9:"Variables";s:7:"charset";s:19:"Jeux de caractères";s:7:"plugins";s:10:"Extensions";s:6:"engine";s:7:"Moteurs";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:10:"Rechercher";s:5:"query";s:8:"Requête";s:6:"export";s:8:"Exporter";s:6:"import";s:8:"Importer";s:9:"operation";s:11:"Opérations";s:10:"privileges";s:11:"Privilèges";s:8:"routines";s:21:"Procédures stockées";s:6:"events";s:12:"Évènements";s:8:"triggers";s:13:"Déclencheurs";s:8:"tracking";s:5:"Suivi";s:8:"designer";s:10:"Concepteur";s:15:"central_columns";s:18:"Colonnes centrales";}s:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:9:"Parcourir";s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:10:"Rechercher";s:6:"insert";s:8:"Insérer";s:6:"export";s:8:"Exporter";s:6:"import";s:8:"Importer";s:10:"privileges";s:11:"Privilèges";s:9:"operation";s:11:"Opérations";s:8:"tracking";s:5:"Suivi";s:8:"triggers";s:13:"Déclencheurs";}s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:26:"cpses_sccd19wajf@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:1:{i:0;a:2:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:20:"sc1jaqa5103_puv_prod";s:5:"query";a:10:{s:32:"cfe35fdc13cae60849082eab49125a88";a:8:{s:3:"sql";s:269:"-- Nettoyage des transients périmés
DELETE a, b
FROM PUV_options a
INNER JOIN PUV_options b 
  ON b.option_name = REPLACE(a.option_name, '_transient_timeout_', '_transient_')
WHERE a.option_name LIKE '_transient_timeout_%'
AND a.option_value < UNIX_TIMESTAMP();";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"09601a11f9fb752bbb1ac7a116e33954";a:8:{s:3:"sql";s:289:"-- Nettoyage des site_transients périmés
DELETE a, b
FROM PUV_options a
INNER JOIN PUV_options b 
  ON b.option_name = REPLACE(a.option_name, '_site_transient_timeout_', '_site_transient_')
WHERE a.option_name LIKE '_site_transient_timeout_%'
AND a.option_value < UNIX_TIMESTAMP();";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"1cb6e10ec674f69570b56e7825b659b4";a:8:{s:3:"sql";s:332:"-- Suppression des transient_timeout orphelins (sans transient correspondant)
DELETE FROM PUV_options 
WHERE option_name LIKE '_transient_timeout_%' 
AND NOT EXISTS (
  SELECT 1 FROM (SELECT option_name FROM PUV_options) AS o2 
  WHERE o2.option_name = REPLACE(PUV_options.option_name, '_transient_timeout_', '_transient_')
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"42c3d28f5c61bca11d9a98629fedd3a1";a:8:{s:3:"sql";s:215:"-- A. Combien de transients ont une date d'expiration ?
SELECT 
  COUNT(*) AS avec_expiration
FROM PUV_options 
WHERE option_name LIKE '_transient_timeout_%' 
   OR option_name LIKE '_site_transient_timeout_%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"029533df0511dfe14c6350269cbd2a31";a:8:{s:3:"sql";s:309:"-- B. Combien sont des transients "purs" (sans expiration) ?
SELECT 
  COUNT(*) AS sans_expiration
FROM PUV_options 
WHERE (option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%')
  AND option_name NOT LIKE '_transient_timeout_%' 
  AND option_name NOT LIKE '_site_transient_timeout_%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"838a715a30e156878bd0bb3ac90fa18d";a:8:{s:3:"sql";s:613:"-- C. Distribution des plus gros transients sans expiration
SELECT option_name, LENGTH(option_value) AS taille
FROM PUV_options 
WHERE (option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%')
  AND option_name NOT LIKE '_transient_timeout_%' 
  AND option_name NOT LIKE '_site_transient_timeout_%'
  AND NOT EXISTS (
    SELECT 1 FROM PUV_options o2 
    WHERE o2.option_name = CONCAT('_transient_timeout_', SUBSTRING(PUV_options.option_name, 12))
       OR o2.option_name = CONCAT('_site_transient_timeout_', SUBSTRING(PUV_options.option_name, 17))
  )
ORDER BY taille DESC
LIMIT 20;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"7a4a60bd4b45cca39dc4ece408325db7";a:8:{s:3:"sql";s:165:"-- 1. Suppression des rapports WC obsolètes (110+ Ko, se régénèrent automatiquement)
DELETE FROM PUV_options 
WHERE option_name LIKE '%_transient_wc_report_%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"52d76e0ca27dd3f56031467f0e85e188";a:8:{s:3:"sql";s:177:"-- 2. Suppression des notifications inbox WC (250 Ko de promos/news inutiles)  
DELETE FROM PUV_options 
WHERE option_name LIKE '%_transient_woocommerce_admin_remote_inbox_%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"768a99fb2dce3ef58f83cff8cc956b39";a:8:{s:3:"sql";s:140:"-- 3. Vieille version Elementor 4.0.4
DELETE FROM PUV_options 
WHERE option_name LIKE '%_transient_elementor_remote_info_api_data_4.0.4%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"08054fbab1f17a7ddfd319df1f1c2677";a:8:{s:3:"sql";s:140:"SELECT 
  COUNT(*) AS nb_transients,
  SUM(LENGTH(option_value)) AS poids_total
FROM PUV_options
WHERE option_name LIKE '%_transient_%';";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:3:"WKT";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:0;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:20:"sc1jaqa5103_puv_prod";a:1:{s:11:"PUV_options";a:0:{}}}}}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:74:"index.php?route=/table/structure&db=sc1jaqa5103_puv_prod&table=PUV_options";}is_multi_query|b:0;sql_from_query_box|b:1;sql_history|a:17:{i:0;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:85:"SELECT COUNT(*), SUM(LENGTH(option_value))
FROM PUV_options
WHERE autoload = 'yes';";}i:1;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:125:"SELECT option_name, LENGTH(option_value) AS taille
FROM PUV_options
WHERE autoload = 'yes'
ORDER BY taille DESC
LIMIT 30;";}i:2;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:73:"DELETE FROM PUV_options 
WHERE option_name = '_transient_dirsize_cache';";}i:3;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:72:"UPDATE PUV_options SET autoload='no' WHERE option_name='ws_menu_editor';";}i:4;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:107:"UPDATE PUV_options SET autoload='no' WHERE option_name IN ('wpseo_taxonomy_meta', 'wpseo_titles', 'wpseo');";}i:5;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:81:"DELETE FROM PUV_options 
WHERE option_name LIKE 'wp_all_import_product_stack_%';";}i:6;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:121:"UPDATE PUV_options SET autoload='no' WHERE option_name IN ('elementor_install_history', 'elementor_pro_install_history');";}i:7;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:85:"SELECT COUNT(*), SUM(LENGTH(option_value))
FROM PUV_options
WHERE autoload = 'yes';";}i:8;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:140:"SELECT 
  COUNT(*) AS nb_transients,
  SUM(LENGTH(option_value)) AS poids_total
FROM PUV_options
WHERE option_name LIKE '%_transient_%';";}i:9;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:151:"SELECT option_name, LENGTH(option_value) AS taille, autoload
FROM PUV_options
WHERE option_name LIKE '%_transient_%'
ORDER BY taille DESC
LIMIT 30;";}i:10;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:332:"-- Suppression des transient_timeout orphelins (sans transient correspondant)
DELETE FROM PUV_options 
WHERE option_name LIKE '_transient_timeout_%' 
AND NOT EXISTS (
  SELECT 1 FROM (SELECT option_name FROM PUV_options) AS o2 
  WHERE o2.option_name = REPLACE(PUV_options.option_name, '_transient_timeout_', '_transient_')
);";}i:11;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:140:"SELECT 
  COUNT(*) AS nb_transients,
  SUM(LENGTH(option_value)) AS poids_total
FROM PUV_options
WHERE option_name LIKE '%_transient_%';";}i:12;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:215:"-- A. Combien de transients ont une date d'expiration ?
SELECT 
  COUNT(*) AS avec_expiration
FROM PUV_options 
WHERE option_name LIKE '_transient_timeout_%' 
   OR option_name LIKE '_site_transient_timeout_%';";}i:13;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:309:"-- B. Combien sont des transients "purs" (sans expiration) ?
SELECT 
  COUNT(*) AS sans_expiration
FROM PUV_options 
WHERE (option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%')
  AND option_name NOT LIKE '_transient_timeout_%' 
  AND option_name NOT LIKE '_site_transient_timeout_%';";}i:14;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:613:"-- C. Distribution des plus gros transients sans expiration
SELECT option_name, LENGTH(option_value) AS taille
FROM PUV_options 
WHERE (option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%')
  AND option_name NOT LIKE '_transient_timeout_%' 
  AND option_name NOT LIKE '_site_transient_timeout_%'
  AND NOT EXISTS (
    SELECT 1 FROM PUV_options o2 
    WHERE o2.option_name = CONCAT('_transient_timeout_', SUBSTRING(PUV_options.option_name, 12))
       OR o2.option_name = CONCAT('_site_transient_timeout_', SUBSTRING(PUV_options.option_name, 17))
  )
ORDER BY taille DESC
LIMIT 20;";}i:15;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:140:"-- 3. Vieille version Elementor 4.0.4
DELETE FROM PUV_options 
WHERE option_name LIKE '%_transient_elementor_remote_info_api_data_4.0.4%';";}i:16;a:3:{s:2:"db";s:20:"sc1jaqa5103_puv_prod";s:5:"table";s:11:"PUV_options";s:8:"sqlquery";s:140:"SELECT 
  COUNT(*) AS nb_transients,
  SUM(LENGTH(option_value)) AS poids_total
FROM PUV_options
WHERE option_name LIKE '%_transient_%';";}}errors|a:0:{}