1
1.96 ms
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM prestataire p0_ WHERE p0_ . status = ?
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM prestataire p0_ WHERE p0_ . status = 1 ;
Copy
2
0.93 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . created_at AS created_at_1 FROM prestataire p0_ WHERE p0_ . status = ? ORDER BY p0_ . created_at DESC LIMIT 24 OFFSET 24
SELECT DISTINCT p0_ . id AS id_0 , p0_ . created_at AS created_at_1 FROM prestataire p0_ WHERE p0_ . status = 1 ORDER BY p0_ . created_at DESC LIMIT 24 OFFSET 24 ;
Copy
3
1.09 ms
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 (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY p0_ . created_at DESC
Parameters :
[
1
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
]
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 = 1 AND p0_ . id IN (25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40 ) ORDER BY p0_ . created_at DESC ;
Copy
4
0.91 ms
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 = 26 ;
Copy
5
0.45 ms
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 = 28 ;
Copy
6
0.40 ms
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 = 29 ;
Copy
7
0.46 ms
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 = 31 ;
Copy
8
0.44 ms
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 = 33 ;
Copy
9
0.47 ms
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 = 34 ;
Copy
10
0.42 ms
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 = 36 ;
Copy
11
0.37 ms
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 = 37 ;
Copy
12
0.36 ms
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 = 38 ;
Copy
13
0.35 ms
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 = 39 ;
Copy
14
0.35 ms
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 = 25 ;
Copy
15
0.37 ms
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 = 27 ;
Copy
16
0.42 ms
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 = 30 ;
Copy
17
0.41 ms
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 = 32 ;
Copy
18
0.34 ms
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 = 35 ;
Copy
19
0.36 ms
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 = 40 ;
Copy
20
2.31 ms
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
Parameters :
[
1
"header "
]
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 = 1 AND m0_ . region = 'header' ORDER BY m0_ . id ASC , m0_ . weight DESC ;
Copy
21
1.52 ms
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 = 26 LIMIT 1 ;
Copy
22
0.77 ms
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 = 26 LIMIT 1 ;
Copy
23
0.70 ms
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 . 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 = 11 ;
Copy
24
2.75 ms
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
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 = ?
Copy
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 = 38 ;
Copy
25
0.81 ms
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 = 28 LIMIT 1 ;
Copy
26
0.58 ms
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 = 28 LIMIT 1 ;
Copy
27
0.36 ms
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 . 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 = 2 ;
Copy
28
1.06 ms
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
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 = ?
Copy
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 = 40 ;
Copy
29
0.65 ms
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 = 29 LIMIT 1 ;
Copy
30
0.69 ms
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 = 29 LIMIT 1 ;
Copy
31
0.39 ms
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 . 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 = 8 ;
Copy
32
1.07 ms
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
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 = ?
Copy
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 = 41 ;
Copy
33
4.07 ms
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 = 31 LIMIT 1 ;
Copy
34
0.93 ms
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 = 31 LIMIT 1 ;
Copy
35
1.04 ms
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
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 = ?
Copy
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 = 43 ;
Copy
36
0.67 ms
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 = 33 LIMIT 1 ;
Copy
37
0.55 ms
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 = 33 LIMIT 1 ;
Copy
38
0.38 ms
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 . 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 = 3 ;
Copy
39
1.01 ms
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
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 = ?
Copy
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 = 45 ;
Copy
40
0.61 ms
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 = 34 LIMIT 1 ;
Copy
41
0.63 ms
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 = 34 LIMIT 1 ;
Copy
42
0.95 ms
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
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 = ?
Copy
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 = 46 ;
Copy
43
0.61 ms
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 = 36 LIMIT 1 ;
Copy
44
0.56 ms
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 = 36 LIMIT 1 ;
Copy
45
0.42 ms
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 . 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 = 1 ;
Copy
46
1.00 ms
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
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 = ?
Copy
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 = 48 ;
Copy
47
0.64 ms
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 = 37 LIMIT 1 ;
Copy
48
0.57 ms
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 = 37 LIMIT 1 ;
Copy
49
1.09 ms
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
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 = ?
Copy
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 = 49 ;
Copy
50
0.60 ms
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 = 38 LIMIT 1 ;
Copy
51
0.60 ms
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 = 38 LIMIT 1 ;
Copy
52
0.39 ms
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 . 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 = 10 ;
Copy
53
1.64 ms
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
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 = ?
Copy
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 = 50 ;
Copy
54
0.72 ms
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 = 39 LIMIT 1 ;
Copy
55
0.61 ms
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 = 39 LIMIT 1 ;
Copy
56
0.99 ms
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
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 = ?
Copy
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 = 51 ;
Copy
57
0.59 ms
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 = 25 LIMIT 1 ;
Copy
58
2.71 ms
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 = 25 LIMIT 1 ;
Copy
59
1.12 ms
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
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 = ?
Copy
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 = 37 ;
Copy
60
0.65 ms
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 = 27 LIMIT 1 ;
Copy
61
0.61 ms
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 = 27 LIMIT 1 ;
Copy
62
0.40 ms
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 . 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 = 6 ;
Copy
63
1.07 ms
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
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 = ?
Copy
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 = 39 ;
Copy
64
0.71 ms
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 = 30 LIMIT 1 ;
Copy
65
0.58 ms
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 = 30 LIMIT 1 ;
Copy
66
0.40 ms
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 . 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 = 13 ;
Copy
67
0.98 ms
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
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 = ?
Copy
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 = 42 ;
Copy
68
0.61 ms
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 = 32 LIMIT 1 ;
Copy
69
0.62 ms
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 = 32 LIMIT 1 ;
Copy
70
0.95 ms
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
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 = ?
Copy
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 = 44 ;
Copy
71
0.57 ms
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 = 35 LIMIT 1 ;
Copy
72
0.57 ms
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 = 35 LIMIT 1 ;
Copy
73
0.99 ms
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
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 = ?
Copy
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 = 47 ;
Copy
74
0.58 ms
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 = 40 LIMIT 1 ;
Copy
75
0.59 ms
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 = 40 LIMIT 1 ;
Copy
76
0.95 ms
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
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 = ?
Copy
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 = 52 ;
Copy
77
0.61 ms
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
Parameters :
[
1
"footer "
]
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 = 1 AND m0_ . region = 'footer' ORDER BY m0_ . id ASC , m0_ . weight DESC ;
Copy
78
1.28 ms
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_ . 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 = 1 AND a0_ . parent_id IS NULL ORDER BY a0_ . name ASC LIMIT 9 ;
Copy
79
0.68 ms
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 = 8 LIMIT 1 ;
Copy
80
0.58 ms
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 = 8 LIMIT 1 ;
Copy
81
0.50 ms
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 = 3 LIMIT 1 ;
Copy
82
0.47 ms
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 = 3 LIMIT 1 ;
Copy
83
0.51 ms
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 = 2 LIMIT 1 ;
Copy
84
0.49 ms
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 = 2 LIMIT 1 ;
Copy
85
0.50 ms
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 = 10 LIMIT 1 ;
Copy
86
0.51 ms
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 = 10 LIMIT 1 ;
Copy
87
0.47 ms
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 = 6 LIMIT 1 ;
Copy
88
0.49 ms
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 = 6 LIMIT 1 ;
Copy
89
0.48 ms
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 = 7 LIMIT 1 ;
Copy
90
0.49 ms
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 = 7 LIMIT 1 ;
Copy
91
0.49 ms
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 = 9 LIMIT 1 ;
Copy
92
0.49 ms
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 = 9 LIMIT 1 ;
Copy
93
0.50 ms
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 = 1 LIMIT 1 ;
Copy
94
0.53 ms
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 = 1 LIMIT 1 ;
Copy
95
0.46 ms
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 = 4 LIMIT 1 ;
Copy
96
0.53 ms
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 = 4 LIMIT 1 ;
Copy