1
0.78 ms
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . password AS password_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . phone AS phone_5 , u0_ . avatar AS avatar_6 , u0_ . is_verified AS is_verified_7 , u0_ . address AS address_8 , u0_ . address_box AS address_box_9 , u0_ . postal AS postal_10 , u0_ . city AS city_11 , u0_ . country AS country_12 , u0_ . company_id AS company_id_13 FROM `user` u0_ INNER JOIN user_role u2_ ON u0_ . id = u2_ . user_id INNER JOIN role r1_ ON r1_ . id = u2_ . role_id WHERE r1_ . title = ?
Parameters :
[
"ROLE_SHOPPER "
]
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . password AS password_2 , u0_ . first_name AS first_name_3 , u0_ . last_name AS last_name_4 , u0_ . phone AS phone_5 , u0_ . avatar AS avatar_6 , u0_ . is_verified AS is_verified_7 , u0_ . address AS address_8 , u0_ . address_box AS address_box_9 , u0_ . postal AS postal_10 , u0_ . city AS city_11 , u0_ . country AS country_12 , u0_ . company_id AS company_id_13 FROM `user` u0_ INNER JOIN user_role u2_ ON u0_ . id = u2_ . user_id INNER JOIN role r1_ ON r1_ . id = u2_ . role_id WHERE r1_ . title = 'ROLE_SHOPPER' ;
Copy
2
0.37 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . tva AS tva_3 , t0 . address AS address_4 , t0 . address_box AS address_box_5 , t0 . postal AS postal_6 , t0 . country AS country_7 , t0 . phone AS phone_8 , t0 . email AS email_9 , t0 . avatar AS avatar_10 , t0 . bio AS bio_11 , t0 . slug AS slug_12 , t0 . city AS city_13 , t14 . id AS id_15 , t14 . email AS email_16 , t14 . password AS password_17 , t14 . first_name AS first_name_18 , t14 . last_name AS last_name_19 , t14 . phone AS phone_20 , t14 . avatar AS avatar_21 , t14 . is_verified AS is_verified_22 , t14 . address AS address_23 , t14 . address_box AS address_box_24 , t14 . postal AS postal_25 , t14 . city AS city_26 , t14 . country AS country_27 , t14 . company_id AS company_id_28 FROM company t0 LEFT JOIN `user` t14 ON t14 . company_id = t0 . id WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . tva AS tva_3 , t0 . address AS address_4 , t0 . address_box AS address_box_5 , t0 . postal AS postal_6 , t0 . country AS country_7 , t0 . phone AS phone_8 , t0 . email AS email_9 , t0 . avatar AS avatar_10 , t0 . bio AS bio_11 , t0 . slug AS slug_12 , t0 . city AS city_13 , t14 . id AS id_15 , t14 . email AS email_16 , t14 . password AS password_17 , t14 . first_name AS first_name_18 , t14 . last_name AS last_name_19 , t14 . phone AS phone_20 , t14 . avatar AS avatar_21 , t14 . is_verified AS is_verified_22 , t14 . address AS address_23 , t14 . address_box AS address_box_24 , t14 . postal AS postal_25 , t14 . city AS city_26 , t14 . country AS country_27 , t14 . company_id AS company_id_28 FROM company t0 LEFT JOIN `user` t14 ON t14 . company_id = t0 . id WHERE t0 . id = 1 ;
Copy
3
0.43 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
4
0.17 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
5
0.16 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
6
0.14 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
7
0.13 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
8
0.13 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
9
0.13 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
10
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
11
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
12
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
13
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
14
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
15
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
16
0.12 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . price AS price_2 , p0_ . illustration AS illustration_3 , p0_ . weight AS weight_4 , p0_ . available AS available_5 , p0_ . short_description AS short_description_6 , p0_ . description AS description_7 , p0_ . tags AS tags_8 , p0_ . average_rating AS average_rating_9 , p0_ . ratings_count AS ratings_count_10 , p0_ . info AS info_11 , p0_ . stock AS stock_12 , p0_ . seller_id AS seller_id_13 FROM product p0_ LIMIT 12 ;
Copy
17
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . image AS image_4 FROM partner t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . image AS image_4 FROM partner t0 ;
Copy