Symfony Profiler

SELECT
  is_active :: int
FROM
  public.tenants
WHERE
  slug = ?

SELECT is_active::int FROM public.tenants WHERE slug = 'dc';

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT IN (
    'information_schema', 'pg_catalog',
    'pg_toast', 'public'
  )
  AND schema_name NOT LIKE 'pg_temp_%'

SELECT schema_name 
            FROM information_schema.schemata 
            WHERE schema_name NOT IN ('information_schema', 'pg_catalog', 'pg_toast', 'public')
            AND schema_name NOT LIKE 'pg_temp_%'
        ;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.name AS name_4,
  t0.password AS password_5,
  t0.is_verified AS is_verified_6,
  t0.invitation_sent_at AS invitation_sent_at_7,
  t0.invitation_accepted_at AS invitation_accepted_at_8,
  t0.invitation_token AS invitation_token_9,
  t0.invitation_token_expires_at AS invitation_token_expires_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.last_login_ip AS last_login_ip_12,
  t0.must_change_password AS must_change_password_13,
  t0.working_hours AS working_hours_14
FROM
  "user" t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.name AS name_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.invitation_sent_at AS invitation_sent_at_7, t0.invitation_accepted_at AS invitation_accepted_at_8, t0.invitation_token AS invitation_token_9, t0.invitation_token_expires_at AS invitation_token_expires_at_10, t0.last_login_at AS last_login_at_11, t0.last_login_ip AS last_login_ip_12, t0.must_change_password AS must_change_password_13, t0.working_hours AS working_hours_14 FROM "user" t0 WHERE t0.email = 'manager@aenor.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.vehicle_id AS vehicle_id_5
FROM
  vehicle_assignments t0
ORDER BY
  t0.start_date DESC

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.vehicle_id AS vehicle_id_5 FROM vehicle_assignments t0 ORDER BY t0.start_date DESC;

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.model AS model_3,
  t0.plate AS plate_4,
  t0.fiscal_power AS fiscal_power_5,
  t0.engine_type AS engine_type_6,
  t0.status AS status_7,
  t0.last_telemetry_at AS last_telemetry_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  vehicles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.plate AS plate_4, t0.fiscal_power AS fiscal_power_5, t0.engine_type AS engine_type_6, t0.status AS status_7, t0.last_telemetry_at AS last_telemetry_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM vehicles t0 WHERE t0.id = 2;

SHOW search_path

SHOW search_path;

SET
  search_path TO dc,
  public

SET search_path TO dc, public;

SELECT
  *
FROM
  "user" u
WHERE
  u.roles :: text LIKE ?

SELECT * FROM "user" u WHERE u.roles::text LIKE '%\"ROLE_DRIVER\"%';

SELECT
  1
FROM
  "user"
WHERE
  email = ?

SELECT 1 FROM "user" WHERE email = 'manager@aenor.fr';

SET
  search_path TO public

SET search_path TO public;