Book Palace of versailles half day Trip| DoTravel

Versailles Half-Day Trip with Transportation from Paris and Audio-Guide

Duration: 4h

Group: Max 20 people

Jan 10, 2026

About This activity

Individual audio guide in the palace available in: English, French, German, Italian, Spanish, Portuguese, Japanese, Russian, Korean, Polish and Mandarin Chinese

Skip the line entrance into the Palace (Hall of Mirrors, Queen's Apartment, State Apartments

Hostess in coach

Transport to and from Paris by air-conditioned coach

Individual audio guide in the palace available in: English, French, German, Italian, Spanish, Portuguese, Japanese, Russian, Korean, Polish and Mandarin Chinese

Skip the line entrance into the Palace (Hall of Mirrors, Queen's Apartment, State Apartments

Hostess in coach

Transport to and from Paris by air-conditioned coach

Gratuities (optional)

Food and drinks

Hotel pickup and drop-off

Gratuities (optional)

Food and drinks

Hotel pickup and drop-off

DoTravel

Meeting Point

41 Avenue de la Bourdonnais, Paris, France

You will be transported back to the Golden Age of France with a Palace of Versailles Tour, a UNESCO World Heritage Site and emblem of French royalty and extravagance. You will be guaranteed fast-track entry, allowing you to jump the queue and travel in comfort on one of our fully air-conditioned coaches. You will marvel at the breathtaking royal chateau, transformed by the ‘Sun King’ Louis XIV in the 1660s from a hunting lodge. Playground of the French monarchs, Versailles was the centre of royal and political power until the French Revolution in 1789 which saw Louis XVI and Marie Antoinette forced to return to the capital.

Individual audio guide in the palace available in: English, French, German, Italian, Spanish, Portuguese, Japanese, Russian, Korean, Polish and Mandarin Chinese

Skip the line entrance into the Palace (Hall of Mirrors, Queen's Apartment, State Apartments

Hostess in coach

Transport to and from Paris by air-conditioned coach

Individual audio guide in the palace available in: English, French, German, Italian, Spanish, Portuguese, Japanese, Russian, Korean, Polish and Mandarin Chinese

Skip the line entrance into the Palace (Hall of Mirrors, Queen's Apartment, State Apartments

Hostess in coach

Transport to and from Paris by air-conditioned coach

Gratuities (optional)

Food and drinks

Hotel pickup and drop-off

Gratuities (optional)

Food and drinks

Hotel pickup and drop-off

Before You Go

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

Reviews

Your audio guide will enable you to discover the State apartments of the King and Queen, the Royal Chapel and Hall of Mirrors, the epitome of French opulence: three hundred and fifty-seven mirrors line the gold-adorned hall and crystal chandeliers hang from the ceiling.

You will also be given time to explore the manicured gardens “à la française”, which mirrors the splendor of the interior. Designed by the French landscaper André Le Nôtre in 1661 for the King Louis XIV, the 2,000-acre park is an architectural expanse of perspectives, parterres, fountains and groves that since its inception has defined what a French garden should be.

Please note: The "Musical Gardens" run every Tuesday from March 27 through May 15 2018 (Except May 1st and May 8) as well as every Tuesday From July 3rd Through October 30th 2018, and every Friday from April 6th through October 26 2018. 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.

The "Musical Fountains" run every Saturday and Sunday from March 31st though October 28 2018 as well as Public Holidays (May 8, May 10 and August 15 2018) plus Friday, March 30 and Tuesdays from May 22nd Through June 26 2018. 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.

Choice of morning or afternoon departure
Excellent value for money
Skip the line admission tickets
You will be transported back to the Golden Age of France with a trip to the Palace of Versailles
Audio-guide included

#	Time	Query
1	1.3 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	3.72 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.41 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	192.53 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '2682' ORDER BY `id` DESC LIMIT 0 , 30
5	0.46 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2682 ORDER BY `id` DESC
6	0.34 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30
7	0.4 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30
8	0.36 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2682 ORDER BY `id_language` DESC LIMIT 0 , 30
9	0.22 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
10	0.25 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
11	0.46 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.37 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 2682 AND p.`status` = '23' ORDER BY `id` DESC
13	0.25 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
14	0.28 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.7 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	0.7 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` = 2682 ORDER BY `rating_overall` desc LIMIT 20 , 30
17	0.31 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	0.59 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2682 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
19	0.5 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 2682 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
20	0.41 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` = 2682 ORDER BY s.`id_language` ASC
21	0.29 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 2682 ORDER BY `id` DESC
22	0.34 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.35 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2682 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
24	0.36 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2682 ORDER BY `show_order` asc LIMIT 0 , 30
25	0.38 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2682 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
26	0.28 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2682 ORDER BY `id` DESC LIMIT 0 , 30
27	0.3 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 1168 ORDER BY `id` DESC LIMIT 0 , 30
28	0.26 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
29	0.27 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 4422 ORDER BY `id` DESC LIMIT 0 , 30
30	0.3 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
31	0.34 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2682 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
32	0.36 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 2682 ORDER BY `id` DESC LIMIT 0 , 30
33	0.44 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.34 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` = 5 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
35	0.32 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` = 4 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
36	0.34 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
37	0.35 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 ='2682'
38	0.26 ms	SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 2682 ORDER BY `id` DESC LIMIT 0 , 30
39	0.3 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '48' ORDER BY `id` DESC LIMIT 0 , 30
40	0.41 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` = 2682 AND cm.`id_language` = 1...
41	0.29 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2682 ORDER BY `show_order` ASC LIMIT 0 , 30
42	0.24 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
43	0.32 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 41 ORDER BY `id` DESC LIMIT 0 , 30
44	0.42 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.26 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 40 ORDER BY `id` DESC LIMIT 0 , 30
46	0.38 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 =...
47	0.3 ms	SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 39 ORDER BY `id` DESC LIMIT 0 , 30
48	0.53 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` = 2682 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3
49	21.52 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,2682 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...
50	0.81 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
51	0.62 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
52	0.48 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
53	0.52 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
54	0.37 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3236 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
55	0.33 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
56	0.3 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3236 ORDER BY `id` DESC LIMIT 0 , 30
57	0.42 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
58	0.6 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3236 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
59	0.48 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...
60	0.44 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4694 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
61	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4694 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
62	0.41 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4694 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
63	0.37 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4694 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
64	0.31 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4694 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
65	0.22 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
66	0.28 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4694 ORDER BY `id` DESC LIMIT 0 , 30
67	0.39 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` = 4694 ORDER BY s.`id_language` ASC
68	0.65 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4694 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
69	0.52 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...
70	0.48 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4704 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30
71	0.42 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4704 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30
72	0.39 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4704 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30
73	0.4 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4704 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30
74	0.33 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4704 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
75	0.31 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4704 ORDER BY `id` DESC LIMIT 0 , 30
76	0.41 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` = 4704 ORDER BY s.`id_language` ASC
77	0.68 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4704 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
78	0.52 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...
79	0.91 ms	SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?
80	0.34 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30
81	0.33 ms	SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 1168 ORDER BY `date` ASC LIMIT 0 , 30
82	0.58 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2682 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30
83	0.28 ms	SELECT * FROM `customer_productlog` WHERE TRUE AND `id` = 711140
84	3.87 ms	UPDATE `customer_productlog` SET `id` = 711140 , `content` = '[{\"id_product\":\"3670\",\"id_user\":\"NULL\",\"dateVisited\":1785173507},{\"id_product\":\"2682\",\"id_user\":\"NULL\",\"dateVisited\":1785173510}]' WHERE `id` = 711140
85	0.35 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
86	0.45 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

Time

Query

1.3 ms

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

3.72 ms

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

0.41 ms

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

192.53 ms

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

0.46 ms

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

0.34 ms

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

0.4 ms

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

0.36 ms

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

0.22 ms

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

0.25 ms

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

0.46 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.37 ms

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

0.25 ms

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

0.28 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.7 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...

0.7 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` = 2682 ORDER BY `rating_overall` desc LIMIT 20 , 30

0.31 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

0.59 ms

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

0.5 ms

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

0.41 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` = 2682 ORDER BY s.`id_language` ASC

0.29 ms

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

0.34 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.35 ms

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

0.36 ms

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

0.38 ms

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

0.28 ms

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

0.3 ms

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

0.26 ms

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

0.27 ms

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

0.3 ms

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

0.34 ms

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

0.36 ms

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

0.44 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.34 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` = 5 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.32 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` = 4 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.34 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.35 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 ='2682'

0.26 ms

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

0.3 ms

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

0.41 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` = 2682 AND cm.`id_language` = 1...

0.29 ms

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

0.24 ms

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

0.32 ms

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

0.42 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.26 ms

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

0.38 ms

0.3 ms

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

0.53 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` = 2682 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3

21.52 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,2682 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination...

0.81 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

0.62 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

0.48 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

0.52 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

0.37 ms

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

0.33 ms

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

0.3 ms

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

0.42 ms

0.6 ms

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

0.48 ms

0.44 ms

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

0.4 ms

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

0.41 ms

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

0.37 ms

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

0.31 ms

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

0.22 ms

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

0.28 ms

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

0.39 ms

0.65 ms

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

0.52 ms

0.48 ms

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

0.42 ms

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

0.39 ms

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

0.4 ms

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

0.33 ms

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

0.31 ms

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

0.41 ms

0.68 ms

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

0.52 ms

0.91 ms

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

0.34 ms

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

0.33 ms

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

0.58 ms

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

0.28 ms

SELECT * FROM `customer_productlog` WHERE TRUE AND `id` = 711140

3.87 ms

UPDATE `customer_productlog` SET `id` = 711140 , `content` = '[{\"id_product\":\"3670\",\"id_user\":\"NULL\",\"dateVisited\":1785173507},{\"id_product\":\"2682\",\"id_user\":\"NULL\",\"dateVisited\":1785173510}]' WHERE `id` = 711140

0.35 ms

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

0.45 ms

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

Versailles Half-Day Trip with Transportation from Paris and Audio-Guide

Versailles Half-Day Trip with Transportation from Paris and Audio-Guide

About This activity

Meeting Point

Reviews

You might also like

Skip-the-line: Louvre Museum Masterpieces Tour

Déjeuners Spectacle - Lunch & Show

Soirée du Nouvel An, Catégorie Gold