Redirect 302 redirect from GET @app_home (362b7e)

GET https://app.hub2be.fr/robots.txt/login

Query Metrics

26 Database Queries
20 Different statements
21.89 ms Query time
0 Invalid entities
2 Managed entities
1 Cache hits
6 Cache misses
12 Cache puts

Queries

Group similar statements

#▲ Time Info
1 0.66 ms
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "app.hub2be.fr"
]
2 0.71 ms
SELECT id FROM organization WHERE domain = ? AND status = 'active'
Parameters:
[
  "app.hub2be.fr"
]
3 0.79 ms
SELECT module FROM organization_module WHERE organization_id = ?
Parameters:
[
  2
]
4 0.76 ms
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "app.hub2be.fr"
]
5 0.91 ms
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:
[]
6 0.91 ms
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
]
7 0.78 ms
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "app.hub2be.fr"
]
8 0.80 ms
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"
]
9 0.72 ms
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:
[
  "new_message"
]
10 0.83 ms
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"
]
11 0.86 ms
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:
[
  "new_document"
]
12 0.93 ms
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:
[
  "planning_added"
  "planning_updated"
  "planning_removed"
]
13 0.83 ms
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"
]
14 0.88 ms
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:
[
  "rncp_expired"
]
15 0.85 ms
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:
[]
16 0.89 ms
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
]
17 0.91 ms
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:
[]
18 0.88 ms
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
]
19 0.89 ms
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:
[]
20 0.94 ms
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
]
21 0.93 ms
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:
[]
22 0.88 ms
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
]
23 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  4
]
24 0.79 ms
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:
[]
25 0.88 ms
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
]
26 0.84 ms
SELECT name FROM organization WHERE id = ?
Parameters:
[
  2
]

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.