Symfony Profiler

Query Metrics

160 Database Queries
16 Different statements
114.85 ms Query time
0 Invalid entities
82 Managed entities
Queries


SELECT COUNT(p0_.id) AS sclr_0 FROM prestataire p0_ WHERE p0_.status = ?
SELECT p0_.id AS id_0 FROM prestataire p0_
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.qualites AS qualites_3, p0_.abonnement_status AS abonnement_status_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.url_alias AS url_alias_7, p0_.auto_generate_alias AS auto_generate_alias_8, p0_.uuid AS uuid_9, p0_.approval_status AS approval_status_10, p0_.approved_at AS approved_at_11, p0_.status AS status_12, p0_.user_id AS user_id_13, p0_.localisation_id AS localisation_id_14, p0_.profile_image_id AS profile_image_id_15 FROM prestataire p0_ WHERE p0_.status = ? AND p0_.id IN (9, 14, 7, 15, 28, 23, 25, 39, 24, 37, 33, 12)
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT t0.id AS id_1, t0.total_orders AS total_orders_2, t0.completed_orders AS completed_orders_3, t0.in_progress_orders AS in_progress_orders_4, t0.cancel_orders AS cancel_orders_5, t0.total_reviews AS total_reviews_6, t0.average_rating AS average_rating_7, t0.positive_reviews AS positive_reviews_8, t0.negative_reviews AS negative_reviews_9, t0.average_response_time AS average_response_time_10, t0.total_earnings AS total_earnings_11, t0.completion_rate AS completion_rate_12, t0.last_updated AS last_updated_13, t0.uuid AS uuid_14, t0.prestataire_id AS prestataire_id_15 FROM prestataire_stats t0 WHERE t0.prestataire_id = ?
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.type AS type_2, l0_.latitude AS latitude_3, l0_.longitude AS longitude_4, l0_.osm_id AS osm_id_5, l0_.code_ivoire AS code_ivoire_6, l0_.uuid AS uuid_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l0_.url_alias AS url_alias_10, l0_.auto_generate_alias AS auto_generate_alias_11 FROM localisation l0_ WHERE l0_.type = ? ORDER BY l0_.name ASC
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
SELECT l0_.url_alias AS url_alias_0, l0_.id AS id_1 FROM localisation l0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = l0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE l0_.id = ? LIMIT 1
-- =============================================
-- OBJECTIF : Compter tous les prestataires situés dans une région,
--            y compris ses départements, communes et quartiers.
-- METHODE :  Utilisation d'une CTE (Common Table Expression) récursive
--            pour parcourir la hiérarchie géographique.
-- =============================================

-- Crée une table temporaire récursive nommée 'tem_hierarchy'
-- Elle va stocker progressivement tous les niveaux de la hiérarchie
WITH RECURSIVE tem_hierarchy AS (
    -- =========================================
    -- ÉTAPE 1 : POINT DE DÉPART (ANCRAGE)
    -- Sélectionne la région racine (niveau 0)
    -- =========================================
    SELECT 
        id,           -- ID de la localisation
        name,         -- Nom de la localisation
        type,         -- Type (région/département/commune/quartier)
        0 AS level    -- Niveau hiérarchique (0 = région)
    FROM 
        public.localisation
    WHERE 
        id = ?     -- ID de la localité
    
    -- =========================================
    -- UNION ALL combine les résultats avec...
    -- =========================================
    UNION ALL
    
    -- =========================================
    -- ÉTAPE 2 : RÉCURSION (DESCENTE DANS LA HIÉRARCHIE)
    -- Trouve tous les enfants du niveau précédent
    -- =========================================
    SELECT 
        l.id, 
        l.name, 
        l.type, 
        h.level + 1   -- Incrémente le niveau (+1 par rapport au parent)
    FROM 
        public.localisation l
    -- Jointure avec la table de hiérarchie pour trouver les enfants
    JOIN 
        public.localisation_hierarchie lh 
        ON lh.child_id = l.id  -- Lie l'enfant à sa localisation
    -- Jointure récursive : référence 'tem_hierarchy' elle-même
    JOIN 
        tem_hierarchy h 
        ON lh.parent_id = h.id  -- Lie l'enfant à son parent déjà exploré
    -- NOTE : PostgreSQL exécute cette boucle jusqu'à épuisement des niveaux
)

-- =============================================
-- ÉTAPE 3 : COMPTAGE DES PRESTATAIRES
-- Compte tous les prestataires liés aux localisations trouvées
-- =============================================
SELECT 
    COUNT(p.id) as count_presta  -- Résultat final : nombre de prestataires
FROM 
    public.prestataire p
-- Jointure avec la hiérarchie complète
INNER JOIN 
    tem_hierarchy th 
    ON th.id = p.localisation_id  -- Filtre les prestataires de la zone
-- NOTE : INNER JOIN exclut les prestataires sans localisation valide
-- Count les prestataires et prestations definit dans un domaine d'activite
/*
SELECT COUNT(ad.id) as count, ad.name, ad.url_alias  FROM public.activity_domain as ad
INNER JOIN public.prestataire_activity_domain as ptrad ON ptrad.activity_domain_id = ad.id
INNER JOIN public.prestataire as ptr ON ptr.id = ptrad.prestataire_id and ptr.status = true
INNER JOIN public.prestation as pti ON ptr.id = pti.prestataire_id and ptr.status = true
GROUP BY ad.id
ORDER BY ad.name ASC 
limit :numbers offset 0
*/
select SUM(count_sub) as count, mc.name, mc.url_alias, mc.id
from (
	-- prestataires
	SELECT COUNT(ptr.id) as count_sub, ad.id, ad.name, ad.url_alias FROM public.activity_domain as ad
	INNER JOIN public.prestataire_activity_domain as ptrad ON ptrad.activity_domain_id = ad.id
	INNER JOIN public.prestataire as ptr ON ptr.id = ptrad.prestataire_id AND ptr.status = true
	WHERE ad.parent_id IS NULL
	GROUP BY ad.id, ad.name, ad.url_alias
	UNION ALL
	-- prestations
	SELECT COUNT(pti.id) as count_sub, ad.id, ad.name, ad.url_alias FROM public.activity_domain as ad
	INNER JOIN public.prestation as pti ON ad.id = pti.activity_domain_id AND pti.status = true
	WHERE ad.parent_id IS NULL
	GROUP BY ad.id, ad.name, ad.url_alias
) mc
GROUP BY mc.id, mc.name, mc.url_alias
ORDER BY mc.name ASC
limit ? offset 0
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.url_alias AS url_alias_2, a0_.icon AS icon_3, count(a0_.id) AS sclr_4, a0_.id AS id_5, a0_.uuid AS uuid_6, a0_.name AS name_7, a0_.description AS description_8, a0_.icon AS icon_9, a0_.level AS level_10, a0_.url_alias AS url_alias_11, a0_.auto_generate_alias AS auto_generate_alias_12, a0_.status AS status_13, a0_.parent_id AS parent_id_14 FROM activity_domain a0_ INNER JOIN prestataire_activity_domain p2_ ON a0_.id = p2_.activity_domain_id INNER JOIN prestataire p1_ ON p1_.id = p2_.prestataire_id WHERE a0_.status = ? AND p1_.status = ? AND a0_.parent_id IS NULL GROUP BY a0_.id ORDER BY a0_.name ASC LIMIT 20
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = ? AND m0_.region = ? ORDER BY m0_.id ASC, m0_.weight DESC
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = ? AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT r.id from public.review as r
        ORDER BY RANDOM()
        LIMIT ?
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = ? AND m0_.region = ? ORDER BY m0_.id ASC, m0_.weight DESC
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Localisation	28
App\Entity\User	13
App\Entity\Prestataire	12
App\Entity\MenuLink	11
App\Entity\ActivityDomain	10
App\Entity\Files	8
Entities Mapping

Class	Mapping errors
App\Entity\Prestataire	No errors.
App\Entity\User	No errors.
App\Entity\Localisation	No errors.
App\Entity\Files	No errors.
App\Entity\Client	No errors.
App\Entity\ServiceRequest	No errors.
App\Entity\ActivityDomain	No errors.
App\Entity\Prestation	No errors.
App\Entity\Favori	No errors.
App\Entity\PrestataireStats	No errors.
App\Entity\Proposition	No errors.
App\Entity\Order	No errors.
App\Entity\LocalisationHierarchie	No errors.
App\Entity\EntityUrlAlias	No errors.
App\Entity\EntityTypeAlias	No errors.
App\Entity\AppelOffre	No errors.
App\Entity\MenuLink	No errors.
App\Entity\LinkedinToken	No errors.
App\Entity\Review	No errors.
Symfony Profiler

GET https://preprod.linko.ci/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
