Book Palace of Versailles Tour with Lunch

Versailles Day Tour with Skip-the-Line Access and Lunch

Duration: 7h

Group: Max 20 people

Jan 10, 2026

About This activity

Full-day trip to Versailles from Paris

Visit of the Castle Gardens

Professional Guide in the Chateau

3-course Lunch in the “La Flotilla” restaurant located at the foot of the Grand Canal

Skip-the-line ticket admissions the Palace of Versailles

Transport by air-conditioned minibus

Gratuities (optional)

Hotel pickup and drop-off

During this full-day tour, you will see the best that Versailles has to offer without having to wait in line. We will take you back to the Golden Age of France to the former residence of the ‘Sun King’ Louis XIV; a sumptuous royal palace which was home to three of France’s most illustrious Kings for over 100 years.

The tour of the palace includes the State Apartments of the King and Queen, Royal Chapel and Hall of Mirrors, a richly decorated gallery which boasts 357 mirrors, french bay windows, and crystal chandeliers.

Full-day trip to Versailles from Paris

Visit of the Castle Gardens

Professional Guide in the Chateau

3-course Lunch in the “La Flotilla” restaurant located at the foot of the Grand Canal

Skip-the-line ticket admissions the Palace of Versailles

Transport by air-conditioned minibus

Gratuities (optional)

Hotel pickup and drop-off

Before You Go

See Schedule of Musical Gardens in Musical Fountains work in the Description

Please, arrive at the meeting point 30 minutes before your chosen time so you do not lose your time slot.

Reviews

After having been dazzled by the splendors of the chateau you will discover the famous gardens à la française; a 2,000-acre park designed by André Le Notre with its magnificent groves, statues, and fountains. Beyond the formal gardens arranged in the Petit parc (185 acres), the extensive Grand Parc provides opportunities for pleasant strolls or long walks.

Savor your 3-course lunch in the “La Flotilla” restaurant located at the foot of the Grand Canal, a majestic setting which allows you to appreciate the beauty of the estate.

After lunch, your guide will take you to the Petit Trianon, a small chateau in the grounds of Versailles used by Marie Antoinette for festivities and to escape the overwhelming court etiquette. You will also discover the Queen’s Hamlet, a stylised Norman village and farm built for Marie Antoinette where she retreated with her closest friends to enjoy an intimately rustic life. Completed just a few years before the Revolution, the Hamlet remains a testament to the Queen’s desire for a simpler life over the cold marble vaults of the main palace.

Please Note:

The "Musical Gardens" run on Tuesdays and Fridays from April 2nd 2019 through October 29th 2019, EXCEPT on Friday April 19th 2019 as well as Tuesdays From May 21st through June 25th 2019. During this period, access to the gardens will be included.

The "Musical Fountains" run on Saturdays and Sundays from April 6th 2019 through October 27 2019, as well as Public Holidays (April 19th, May 8th, 30th, and August 15 2019) + Tuesdays From May 21st through June 25th 2019. During this period, access to the gardens will be included to see the fountains and groves spring to life to the rhythm of the music.

Full-day trip to Versailles from Paris with an expert local guide
Enjoy fast-track entrance to the Palace of Versailles with your skip-the-line ticket
Tour the State Apartments and gaze in awe at the Hall of Mirrors
Explore Versailles Gardens at leisure
Relax over a 3-course lunch in a restaurant near the Grand Canal
See the UNESCO World Heritage-listed Grand Trianon and the Queen’s Hamlet

#	Time	Query
1	7.09 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	12.67 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.94 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	242.45 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '2683' ORDER BY `id` DESC LIMIT 0 , 30
5	0.58 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2683 ORDER BY `id` DESC
6	0.72 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
7	0.71 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	0.74 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.26 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	1.01 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	2 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30
12	0.46 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2683 AND p.`status` = '23' ORDER BY `id` DESC
13	0.46 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.42 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30
15	0.8 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
16	1.38 ms	SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 2683 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	1.09 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30
18	1.77 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.59 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 2683 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.91 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 2683 ORDER BY s.`id_language` ASC
21	3.45 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 2683 ORDER BY `id` DESC
22	1.15 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30
23	0.56 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.41 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2683 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.63 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.4 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30
27	0.62 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 1169 ORDER BY `id` DESC LIMIT 0 , 30
28	0.34 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.55 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 4423 ORDER BY `id` DESC LIMIT 0 , 30
30	0.38 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.5 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.44 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30
33	1.07 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
34	0.61 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 1 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
35	0.5 ms	SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='2683'
36	0.5 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30
37	0.72 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30
38	0.67 ms	SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 2683 AND cm.`id_language` = 1...
39	0.55 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2683 ORDER BY `show_order` ASC LIMIT 0 , 30
40	0.67 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
41	1.48 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 41 ORDER BY `id` DESC LIMIT 0 , 30
42	1.19 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
43	0.41 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 40 ORDER BY `id` DESC LIMIT 0 , 30
44	0.8 ms	SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...
45	0.44 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 39 ORDER BY `id` DESC LIMIT 0 , 30
46	0.75 ms	SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 2683 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
47	42.15 ms	SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 3236,2683 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...
48	4.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
49	2.63 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
50	2.53 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
51	1.16 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
52	1.08 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
53	0.37 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
54	0.77 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3236 ORDER BY `id` DESC LIMIT 0 , 30
55	0.6 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3236 ORDER BY s.`id_language` ASC
56	0.95 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3236 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
57	0.91 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
58	1.27 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
59	1.49 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
60	0.77 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
61	0.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
62	0.67 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
63	0.67 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
64	0.82 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3690 ORDER BY `id` DESC LIMIT 0 , 30
65	0.57 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3690 ORDER BY s.`id_language` ASC
66	0.7 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3690 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
67	1.07 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
68	0.84 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
69	0.83 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
70	0.87 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
71	0.61 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
72	1.04 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
73	0.69 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4638 ORDER BY `id` DESC LIMIT 0 , 30
74	0.58 ms	SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4638 ORDER BY s.`id_language` ASC
75	0.76 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4638 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
76	0.69 ms	SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...
77	1.27 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
78	0.61 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
79	0.44 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 1169 ORDER BY `date` ASC LIMIT 0 , 30
80	0.7 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
81	1403.15 ms	SELECT * FROM `customer_productlog` WHERE TRUE
82	3.55 ms	INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"2683\",\"id_user\":\"NULL\",\"dateVisited\":1785179049}' )
83	0.33 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
84	0.52 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Time

Query

7.09 ms

SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1

12.67 ms

INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...

0.94 ms

SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'

242.45 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '2683' ORDER BY `id` DESC LIMIT 0 , 30

0.58 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2683 ORDER BY `id` DESC

0.72 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30

0.71 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30

0.74 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 ORDER BY `id_language` DESC LIMIT 0 , 30

0.26 ms

SELECT * FROM `languages` WHERE TRUE AND `id` = 1

1.01 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30

2 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30

0.46 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2683 AND p.`status` = '23' ORDER BY `id` DESC

0.46 ms

SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC

0.42 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30

0.8 ms

SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...

1.38 ms

SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 2683 ORDER BY `rating_overall` desc LIMIT 20 , 30

1.09 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30

1.77 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000

0.59 ms

SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 2683 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30

0.91 ms

SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 2683 ORDER BY s.`id_language` ASC

3.45 ms

SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 2683 ORDER BY `id` DESC

1.15 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30

0.56 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30

0.41 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2683 ORDER BY `show_order` asc LIMIT 0 , 30

0.63 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.4 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30

0.62 ms

SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 1169 ORDER BY `id` DESC LIMIT 0 , 30

0.34 ms

SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.55 ms

SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 4423 ORDER BY `id` DESC LIMIT 0 , 30

0.38 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30

0.5 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2683 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.44 ms

SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30

1.07 ms

SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.61 ms

SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 1 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.5 ms

SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='2683'

0.5 ms

SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 2683 ORDER BY `id` DESC LIMIT 0 , 30

0.72 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30

0.67 ms

SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 2683 AND cm.`id_language` = 1...

0.55 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2683 ORDER BY `show_order` ASC LIMIT 0 , 30

0.67 ms

SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'

1.48 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 41 ORDER BY `id` DESC LIMIT 0 , 30

1.19 ms

SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...

0.41 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 40 ORDER BY `id` DESC LIMIT 0 , 30

0.8 ms

0.44 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 39 ORDER BY `id` DESC LIMIT 0 , 30

0.75 ms

SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 2683 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3

42.15 ms

SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 3236,2683 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...

4.39 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

2.63 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

2.53 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

1.16 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

1.08 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.37 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30

0.77 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3236 ORDER BY `id` DESC LIMIT 0 , 30

0.6 ms

0.95 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3236 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.91 ms

1.27 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

1.49 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

0.77 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

0.58 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

0.67 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3690 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.67 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.82 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3690 ORDER BY `id` DESC LIMIT 0 , 30

0.57 ms

0.7 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3690 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

1.07 ms

0.84 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

0.83 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

0.87 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

0.61 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

1.04 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4638 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.69 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4638 ORDER BY `id` DESC LIMIT 0 , 30

0.58 ms

0.76 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4638 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.69 ms

1.27 ms

SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?

0.61 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30

0.44 ms

SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 1169 ORDER BY `date` ASC LIMIT 0 , 30

0.7 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2683 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30

1403.15 ms

SELECT * FROM `customer_productlog` WHERE TRUE

3.55 ms

INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"2683\",\"id_user\":\"NULL\",\"dateVisited\":1785179049}' )

0.33 ms

SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC

0.52 ms

SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Versailles Day Tour with Skip-the-Line Access and Lunch

Versailles Day Tour with Skip-the-Line Access and Lunch

About This activity

Meeting Point

Reviews

You might also like

Skip-the-line: Louvre Museum Masterpieces Tour

Louvre Museum Skip-the-Line Electronic Ticket

French Revolution Truths & Myths | Private Walking Tour