GET https://app.hub2be.fr/sitemap.xml/recovery

Query Metrics

24 Database Queries
19 Different statements
23.67 ms Query time
0 Invalid entities
2 Managed entities
1 Cache hits
6 Cache misses
12 Cache puts

Grouped Statements

Show all queries

Time▼ Count Info
3.73 ms
(15.78%)
4
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL AND ((t0.organization_id = 2)) ORDER BY t0.date DESC
Parameters:
[
  "homework_to_do"
]
1.99 ms
(8.41%)
2
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "app.hub2be.fr"
]
1.92 ms
(8.11%)
2
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id IS NULL AND ((t0.organization_id = 2)) ORDER BY t0.date DESC
Parameters:
[
  "internship_approval"
  "internship_to_seal"
  "internship_rejected"
]
1.12 ms
(4.72%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_14 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
1.04 ms
(4.39%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_15 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.04 ms
(4.38%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_21 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.03 ms
(4.35%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_17 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.03 ms
(4.34%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_23 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.02 ms
(4.32%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_19 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.01 ms
(4.29%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_25 FROM site_settings t0 WHERE t0.organization_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
1.01 ms
(4.27%)
1
SELECT module FROM organization_module WHERE organization_id = ?
Parameters:
[
  2
]
1.01 ms
(4.26%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_16 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
0.98 ms
(4.16%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_18 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
0.98 ms
(4.15%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.98 ms
(4.12%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_22 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
0.96 ms
(4.07%)
1
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category IN (?, ?, ?, ?) AND t0.user_id IS NULL AND ((t0.organization_id = 2)) ORDER BY t0.date DESC
Parameters:
[
  "interview_due"
  "interview_overdue"
  "interview_done"
  "interview_ack"
]
0.96 ms
(4.04%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_24 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
0.94 ms
(3.97%)
1
SELECT id FROM organization WHERE domain = ? AND status = 'active'
Parameters:
[
  "app.hub2be.fr"
]
0.91 ms
(3.86%)
1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.mascot AS mascot_3, t0.logo_path AS logo_path_4, t0.logo_name AS logo_name_5, t0.platform_name AS platform_name_6, t0.primary_color AS primary_color_7, t0.secondary_color AS secondary_color_8, t0.tertiary_color AS tertiary_color_9, t0.quaternary_color AS quaternary_color_10, t0.lighten_color AS lighten_color_11, t0.darken_color AS darken_color_12, t0.organization_id AS organization_id_13, t0.theme_id AS theme_id_20 FROM site_settings t0 WHERE ((t0.organization_id = 2)) ORDER BY t0.id ASC LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

1 Hits
6 Misses
12 Puts

Number of cache hits

Region Hits
read_only 1

Number of cache misses

Region Misses
non_strict 6

Number of cache puts

Region Puts
non_strict 12

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SiteSettings 1
App\Entity\Theme 1

Entities Mapping

Class Mapping errors
App\Entity\SiteSettings No errors.
App\Entity\Theme No errors.
App\Entity\FeedbackCategory No errors.
App\Entity\Notification No errors.
App\Entity\User No errors.