GET https://app.hub2be.fr/sitemap.xml/privacy-policy

Query Metrics

25 Database Queries
19 Different statements
19.81 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.09 ms
(15.61%)
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"
]
2.24 ms
(11.31%)
3
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "app.hub2be.fr"
]
1.60 ms
(8.06%)
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"
]
0.91 ms
(4.58%)
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
]
0.88 ms
(4.45%)
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:
[]
0.87 ms
(4.37%)
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
]
0.83 ms
(4.20%)
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.83 ms
(4.19%)
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
]
0.82 ms
(4.15%)
1
SELECT module FROM organization_module WHERE organization_id = ?
Parameters:
[
  2
]
0.81 ms
(4.11%)
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.80 ms
(4.06%)
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.80 ms
(4.03%)
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
]
0.79 ms
(4.00%)
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.79 ms
(3.98%)
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
]
0.77 ms
(3.90%)
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
]
0.77 ms
(3.88%)
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:
[]
0.77 ms
(3.87%)
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.74 ms
(3.76%)
1
SELECT id FROM organization WHERE domain = ? AND status = 'active'
Parameters:
[
  "app.hub2be.fr"
]
0.69 ms
(3.48%)
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
]

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.