Pour vous aider à vous détendre après une journée d'excursion nous offrons une petit SPA dans un jardin agréable, avec des transats, un grand jacuzzi et un sauna. La SPA dans le jardin est gratuit pour nos clients et est ouvert du 15 Avril au 15 Octobre.
A quinze kilomètres de la Locanda del Borgo vous trouvez le célèbre parcours du golf de Rapallo. Le Golf de Rapallo et le Tennis Club sont situés dans un des quartiers les plus pittoresques du Golfe du Tigullio. Nos clients ont droit à un tarif spécial vert au club. Il suffit de contacter la réception de l'hôtel pour plus d'informations et pour la réservation.
A un seul kilomètre de notre hôtel se trouve le club de tennis “La Fattoria”. ( Nos clients bénéficient d’un tarif spécial.) En Ligurie on doit profiter des excellentes possibilités de plongée et de voile. Grâce à des accords avec des opérateurs locaux, nous sommes en mesure d'organiser des forfaits de plongée spéciaux pour nos clients afin d'explorer l'admirable parc naturel de Portofino et (les nombreuses épaves de navires qui ont coulé près de) Sestri Levante. On peut également réserver des excursions sur des bateaux à voile pour quelques heures ou pour un maximum de deux jours de croisière le long de la côte entre Camogli et Portovenere.
Trois nuits pour deux personnes compris de chambre et petit...
session.counter ⇒ 1
session.timer.start ⇒ 1550633852
session.timer.last ⇒ 1550633852
session.timer.now ⇒ 1550633852
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒
guest ⇒ 1
lastResetTime ⇒
resetCount ⇒
aid ⇒ 0
Application 0.000 seconds (+0.000); 0.79 MB (+0.789) - afterLoad
Application 0.127 seconds (+0.127); 2.18 MB (+1.387) - afterInitialise
Application 0.135 seconds (+0.007); 2.68 MB (+0.499) - afterRoute
Application 0.227 seconds (+0.093); 3.41 MB (+0.737) - afterDispatch
Application 0.241 seconds (+0.014); 3.52 MB (+0.110) - beforeRenderModule mod_custom (La taverna del Borgo)
Application 0.250 seconds (+0.008); 3.54 MB (+0.015) - afterRenderModule mod_custom (La taverna del Borgo)
Application 0.250 seconds (+0.000); 3.53 MB (-0.004) - beforeRenderModule mod_custom (Tripadvisor_fr)
Application 0.250 seconds (+0.000); 3.54 MB (+0.004) - afterRenderModule mod_custom (Tripadvisor_fr)
Application 0.250 seconds (+0.000); 3.54 MB (-0.003) - beforeRenderModule mod_custom (Facebook)
Application 0.251 seconds (+0.000); 3.54 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.251 seconds (+0.000); 3.54 MB (+0.004) - beforeRenderModule mod_articles_category (Last minute)
Application 0.266 seconds (+0.015); 3.69 MB (+0.147) - afterRenderModule mod_articles_category (Last minute)
Application 0.266 seconds (+0.000); 3.68 MB (-0.013) - beforeRenderModule mod_articles_category (Last minute_fr)
Application 0.275 seconds (+0.009); 3.75 MB (+0.070) - afterRenderModule mod_articles_category (Last minute_fr)
Application 0.275 seconds (+0.000); 3.70 MB (-0.049) - beforeRenderModule mod_custom (prenotazione_it)
Application 0.276 seconds (+0.000); 3.70 MB (+0.004) - afterRenderModule mod_custom (prenotazione_it)
Application 0.276 seconds (+0.000); 3.70 MB (-0.001) - beforeRenderModule mod_menu (menu_fr)
Application 0.290 seconds (+0.014); 3.74 MB (+0.036) - afterRenderModule mod_menu (menu_fr)
Application 0.290 seconds (+0.000); 3.75 MB (+0.012) - beforeRenderModule mod_PlimunNivoSlider (slider_spa)
Application 0.297 seconds (+0.007); 3.83 MB (+0.075) - afterRenderModule mod_PlimunNivoSlider (slider_spa)
Application 0.297 seconds (+0.000); 3.75 MB (-0.073) - beforeRenderModule mod_languages (Lingue)
Application 0.316 seconds (+0.019); 4.08 MB (+0.330) - afterRenderModule mod_languages (Lingue)
Application 0.316 seconds (+0.000); 4.08 MB (-0.006) - beforeRenderModule mod_custom (prenotazione_fr)
Application 0.317 seconds (+0.000); 4.08 MB (+0.004) - afterRenderModule mod_custom (prenotazione_fr)
Application 0.333 seconds (+0.016); 4.11 MB (+0.026) - afterRender
4.1 MB (4,300,592 Bytes)
SELECT `data`
FROM `axe3c_session`
WHERE `session_id` = 'icn9js7n0mu36tudsv9po349q3'
SELECT `session_id`
FROM `axe3c_session`
WHERE `session_id` = 'icn9js7n0mu36tudsv9po349q3'
LIMIT 0, 1
INSERT INTO `axe3c_session`
(`session_id`, `client_id`, `time`)
VALUES
('icn9js7n0mu36tudsv9po349q3', 0, '1550633852')
SELECT extension_id AS id, element AS "option", params, enabled
FROM axe3c_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM axe3c_usergroups AS a
LEFT JOIN axe3c_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `axe3c_viewlevels`
SELECT folder AS type, element AS name, params
FROM axe3c_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT *
FROM axe3c_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM axe3c_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM axe3c_menu AS m
LEFT JOIN axe3c_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM axe3c_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id, home, template, s.params
FROM axe3c_template_styles as s
LEFT JOIN axe3c_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM axe3c_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM axe3c_assets AS a
LEFT JOIN axe3c_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM axe3c_content AS a
LEFT JOIN axe3c_categories AS c
on c.id = a.catid
LEFT JOIN axe3c_users AS u
on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM axe3c_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN axe3c_categories as parent
ON parent.id = c.parent_id
LEFT JOIN axe3c_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 26
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-20 03:37:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-20 03:37:32')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM axe3c_categories as c
LEFT JOIN axe3c_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=10
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
UPDATE axe3c_content
SET hits = hits + 1
WHERE id = 26
SELECT m2.language, m2.id
FROM axe3c_menu as m
INNER JOIN axe3c_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN axe3c_associations as a2
ON a.key=a2.key
INNER JOIN axe3c_menu as m2
ON a2.id=m2.id
WHERE m.id=139
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM axe3c_modules AS m
LEFT JOIN axe3c_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN axe3c_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-20 03:37:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-20 03:37:32')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 139 OR mm.menuid <= 0)
AND m.language IN ('fr-FR','*')
ORDER BY m.position, m.ordering
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM axe3c_content AS a
LEFT JOIN axe3c_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN axe3c_categories AS c
ON c.id = a.catid
LEFT JOIN axe3c_users AS ua
ON ua.id = a.created_by
LEFT JOIN axe3c_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM axe3c_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN axe3c_categories as parent
ON parent.id = c.parent_id
LEFT JOIN axe3c_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-20 03:37:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-20 03:37:32')
AND a.language in ('fr-FR','*')
AND (contact.language in ('fr-FR','*') OR contact.language IS NULL)
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.title ASC
LIMIT 0, 4
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM axe3c_content AS a
LEFT JOIN axe3c_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN axe3c_categories AS c
ON c.id = a.catid
LEFT JOIN axe3c_users AS ua
ON ua.id = a.created_by
LEFT JOIN axe3c_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM axe3c_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN axe3c_categories as parent
ON parent.id = c.parent_id
LEFT JOIN axe3c_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 1
AND a.catid IN (13)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-20 03:37:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-20 03:37:32')
AND a.language in ('fr-FR','*')
AND (contact.language in ('fr-FR','*') OR contact.language IS NULL)
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.title ASC
LIMIT 0, 4
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM axe3c_categories as c
LEFT JOIN axe3c_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=13
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT `url`
FROM axe3c_m4j_sef
WHERE `cid`=''
AND `jid` = '0'
SELECT m2.language, m2.id
FROM axe3c_menu as m
INNER JOIN axe3c_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN axe3c_associations as a2
ON a.key=a2.key
INNER JOIN axe3c_menu as m2
ON a2.id=m2.id
WHERE m.id=139
UPDATE `axe3c_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550633852;s:18:\"session.timer.last\";i:1550633852;s:17:\"session.timer.now\";i:1550633852;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1550633852'
WHERE `session_id` = 'icn9js7n0mu36tudsv9po349q3'
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM axe3c_extensions
2 × SELECT m2.language, m2.id
FROM axe3c_menu as m
INNER JOIN axe3c_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN axe3c_associations as a2
ON a.key=a2.key
INNER JOIN axe3c_menu as m2
ON a2.id=m2.id
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM axe3c_content AS a
LEFT JOIN axe3c_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN axe3c_categories AS c
ON c.id = a.catid
LEFT JOIN axe3c_users AS ua
ON ua.id = a.created_by
LEFT JOIN axe3c_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM axe3c_contact_details AS contact
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM axe3c_categories as c
LEFT JOIN axe3c_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM axe3c_categories AS cat JOIN axe3c_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM axe3c_content AS a
LEFT JOIN axe3c_categories AS c
on c.id = a.catid
LEFT JOIN axe3c_users AS u
on u.id = a.created_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM axe3c_contact_details AS contact
1 × SELECT b.rules
FROM axe3c_assets AS a
LEFT JOIN axe3c_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM axe3c_modules AS m
LEFT JOIN axe3c_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN axe3c_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `url`
FROM axe3c_m4j_sef
1 × SELECT a.rules
FROM axe3c_assets AS a
1 × SELECT id, home, template, s.params
FROM axe3c_template_styles as s
LEFT JOIN axe3c_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.id
FROM axe3c_usergroups AS a
LEFT JOIN axe3c_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `axe3c_session`
1 × SELECT id, rules
FROM `axe3c_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM axe3c_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM axe3c_menu AS m
LEFT JOIN axe3c_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM axe3c_languages
1 × SELECT `data`
FROM `axe3c_session`
1 × UPDATE `axe3c_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550633852;s:18:\"session.timer.last\";i:1550633852;s:17:\"session.timer.now\";i:1550633852;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1550633852'
1 × UPDATE axe3c_content
SET hits = hits + 1
1 × INSERT INTO `axe3c_session` (`session_id`, `client_id`, `time`)
VALUES ('icn9js7n0mu36tudsv9po349q3', 0, '1550633852'