Symfony Profiler

DELETE FROM
  re_references
WHERE
  referenceResourceKey = ?
  AND referenceResourceKey = ?
  AND referenceResourceId = ?
  AND referenceLocale = ?
  AND referenceContext = ?

DELETE FROM re_references WHERE referenceResourceKey = 'pages' AND referenceResourceKey = 'pages' AND referenceResourceId = '4178f463-da81-4e9b-becf-83612f69f014' AND referenceLocale = 'en' AND referenceContext = 'admin';

INSERT INTO ac_activities (
  type, context, timestamp, batch, resourceKey,
  resourceId, resourceLocale, resourceWebspaceKey,
  resourceTitle, resourceTitleLocale,
  resourceSecurityContext, resourceSecurityObjectType,
  resourceSecurityObjectId, userId
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ac_activities (type, context, timestamp, batch, resourceKey, resourceId, resourceLocale, resourceWebspaceKey, resourceTitle, resourceTitleLocale, resourceSecurityContext, resourceSecurityObjectType, resourceSecurityObjectId, userId) VALUES('modified', '[]', '2025-04-22 05:28:55', '68070cf7937ef6.44484168', 'pages', '4178f463-da81-4e9b-becf-83612f69f014', 'en', 'montcaud', 'kids and family', 'en', 'sulu.webspaces.montcaud', 'Sulu\\Component\\Content\\Document\\Behavior\\SecurityBehavior', '4178f463-da81-4e9b-becf-83612f69f014', 1);

"COMMIT"

"COMMIT";

UPDATE
  phpcr_nodes
SET
  props = ?,
  numerical_props = ?
WHERE
  id = ?

UPDATE phpcr_nodes SET props = '<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"jcr:primaryType\" sv:type=\"Name\" sv:multi-valued=\"0\"><sv:value length=\"15\">nt:unstructured</sv:value></sv:property><sv:property sv:name=\"jcr:mixinTypes\" sv:type=\"Name\" sv:multi-valued=\"1\"><sv:value length=\"9\">sulu:page</sv:value></sv:property><sv:property sv:name=\"jcr:uuid\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">4178f463-da81-4e9b-becf-83612f69f014</sv:value></sv:property><sv:property sv:name=\"i18n:en-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"15\">kids and family</sv:value></sv:property><sv:property sv:name=\"i18n:en-url\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"16\">/kids-and-family</sv:value></sv:property><sv:property sv:name=\"i18n:en-template\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"15\">kids-and-family</sv:value></sv:property><sv:property sv:name=\"i18n:en-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"sec:permissions\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:en-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:en-authored\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2025-01-22T13:11:49.000+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:en-author\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:en-created\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2025-01-22T13:11:49.679+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:en-changed\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2025-04-22T03:28:55.480+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:en-navContexts\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:en-nodeType\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"sulu:order\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"3\">140</sv:value></sv:property><sv:property sv:name=\"i18n:en-published\" sv:type=\"Date\" sv:multi-valued=\"0\"><sv:value length=\"29\">2025-01-22T13:11:49.720+00:00</sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-title\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-keywords\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-canonicalUrl\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-noIndex\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-noFollow\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:en-seo-hideInSitemap\" sv:type=\"Boolean\" sv:multi-valued=\"0\"><sv:value length=\"0\">0</sv:value></sv:property><sv:property sv:name=\"i18n:en-excerpt-description\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"0\"></sv:value></sv:property><sv:property sv:name=\"i18n:en-excerpt-categories\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:en-excerpt-tags\" sv:type=\"String\" sv:multi-valued=\"1\"/><sv:property sv:name=\"i18n:en-excerpt-icon\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"i18n:en-excerpt-images\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"10\">{\"ids\":[]}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">5</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"28\">kids-and-family-hero-section</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-cover#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":219,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-subTitle#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"47\">&lt;p&gt;A family-friendly luxury hotel&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-title#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"13\">Kids &amp; Family</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-description#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"286\">&lt;p&gt;Imagine yourself lying comfortably on a sunbed by the pool, finally reading THAT book. Or, your children playing in the park while you enjoy the peace and quiet around you: at Château de Montcaud we have made it our mission to satisfy both your needs and those of your children.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"34\">kids-and-family-left-infos-section</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"147\">{\"hidden\":false,\"schedules_enabled\":null,\"schedules\":null,\"segment_enabled\":null,\"segments\":null,\"target_groups_enabled\":null,\"target_groups\":null}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-cover#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":217,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-subTitle#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"32\">Children: welcome at the chateau</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-title#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"26\">The perfect family holiday</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-description#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"400\">&lt;p&gt;A chateau hotel is not a museum which is why children are more than welcome&lt;/p&gt;&lt;p&gt;to stay with us. There is plenty of room in the park for a game of hide-and-seek,&lt;/p&gt;&lt;p&gt;followed by a refreshing dip in the pool. The tennis court, ping-pong table and&lt;/p&gt;&lt;p&gt;boule pistes are also there to make our younger guests happy. Rackets, balls&lt;/p&gt;&lt;p&gt;and other outdoor toys are available at the reception.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-title#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"26\">The (room) choice is yours</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-description#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"323\">&lt;p&gt;Complimentary baby beds are available for babies and toddlers under three&lt;/p&gt;&lt;p&gt;years of age. We are happy to provide an extra bed for older children, at a&lt;/p&gt;&lt;p&gt;small daily rate (one per room as of Privilège category). In the Privilège&lt;/p&gt;&lt;p&gt;category, it is also possible to book two rooms with a connecting door.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-title#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"16\">Complete comfort</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-description#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"333\">&lt;p&gt;For the perfect family holiday, we particularly recommend our Duplex Suites: in&lt;/p&gt;&lt;p&gt;addition to the living room, mezzanine level with chaise longue and balcony&lt;/p&gt;&lt;p&gt;for the whole family, they include a spacious master bedroom with bathroom&lt;/p&gt;&lt;p&gt;for the parents and a second bedroom with private bathroom for your children.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-informationsText#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"7\">Prices:</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">infos</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-description#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"94\">&lt;p&gt;&lt;strong&gt;Baby cot:&lt;/strong&gt; free of charge&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Extra bed:&lt;/strong&gt; from EUR 60&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">infos</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-description#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"44\">&lt;p&gt;Room prices subject to period of stay&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">infos</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-description#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"177\">&lt;p&gt;&lt;strong&gt;Food and Beverage&lt;/strong&gt; (below 12-year-olds):&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Children’s Menu or 50% off the standard menu, breakfast free of charge for under 6-year-olds&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">infos</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-description#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"177\">&lt;p&gt;&lt;strong&gt;Food and Beverage&lt;/strong&gt; (below 12-year-olds):&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Children’s Menu or 50% off the standard menu, breakfast free of charge for under 6-year-olds&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"35\">kids-and-family-right-infos-section</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"147\">{\"hidden\":false,\"schedules_enabled\":null,\"schedules\":null,\"segment_enabled\":null,\"segments\":null,\"target_groups_enabled\":null,\"target_groups\":null}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-subTitle#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"12\">for children</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-title#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"14\">A Perfect Day </sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaText#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"22\">contact us for a quote</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-btnTarget#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">_blank</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaLink#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"132\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/google.com\",\"title\":null,\"rel\":null,\"locale\":\"en\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-defaultCtaText#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"13\">discover more</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-page#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">aba99b98-d103-47d4-91d9-14f41b6d5169</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-page#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">64853a06-a262-46e6-9576-c9d0920e167d</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-page#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">2a30d487-a4a9-4fbf-aabf-a20bb5c95054</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-description#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"136\">&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor&lt;/p&gt;&lt;p&gt;incididunt ut labore et dolore magna aliqua.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaTarget#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">_blank</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">kids-and-family-day-timeline-bloc</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"147\">{\"hidden\":false,\"schedules_enabled\":null,\"schedules\":null,\"segment_enabled\":null,\"segments\":null,\"target_groups_enabled\":null,\"target_groups\":null}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-subTitle#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"53\">&lt;p&gt;Fun and adventure for everyone&amp;nbsp;&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-title#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"39\">&lt;p&gt;the Perfect Family Day&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaText#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"22\">contact us for a quote</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-btnTarget#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">_blank</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaLink#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"132\">{\"provider\":\"external\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"https:\\/\\/google.com\",\"title\":null,\"rel\":null,\"locale\":\"en\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-defaultCtaText#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"13\">discover more</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">6</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-page#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">aba99b98-d103-47d4-91d9-14f41b6d5169</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-page#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">64853a06-a262-46e6-9576-c9d0920e167d</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-page#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">2a30d487-a4a9-4fbf-aabf-a20bb5c95054</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":227,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">8.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":229,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">12.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":228,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">14.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":226,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">16.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":225,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">20.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-type#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-settings#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-image#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":227,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-time#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">21.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-cover#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"34\">{\"id\":null,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-title#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"23\">Complete family comfort</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-description#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"325\">&lt;p&gt;For the perfect family holiday, we particularly recommend our Duplex Suites: in addition to the living room, mezzanine level with chaise longue and balcony for the whole family, they include a spacious master bedroom with bathroom for the parents and a second bedroom with private bathroom for your children.&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-title#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"21\">For extended families</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-description#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"337\">&lt;p&gt;A whole floor is available for families in Le Mas: L’Appartement and two Classic rooms are connected by a private corridor, which is separated from the public area by a lockable door. Thus, up to six people can benefit from a comfortable holiday apartment with three en-suite bedrooms, a living-room and a kitchenette.&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-title#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"24\">A house within the hotel</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-description#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"217\">&lt;p&gt;Families looking to self-cater can stay at the property’s charming former gatehouse La Maison, offering the comfort of a fully furnished home, with all the hotel’s services available upon request.&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-title#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"32\">Sunday brunch in the estate park</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-description#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"323\">&lt;p&gt;A special culinary highlight is our Sunday brunch, where no one has to sit at the table for a long time if their little legs are aching to move: between the individual courses to the buffet, it is easy to stop for a short while to listen to the music and admire the instruments or go for a quick run across the lawn.&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":227,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"4\">8.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":229,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">12.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":228,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">14.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":226,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">16.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":225,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">20.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-type#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-settings#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-image#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"33\">{\"id\":227,\"displayOption\":\"left\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-time#5\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">21.00</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-description#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"367\">&lt;p&gt;There is no need to lose any sleep over what you\'ll be doing on your family holiday in Provence: just ask our concierge, he has a list of fabulous things to do in our diverse region ready for you. And don\'t forget to factor in plenty of time to enjoy our little oasis - at Château de Montcaud, boredom is not on the cards for kids and their parents.&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaTarget#3\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">_blank</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-type#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"22\">related-offers-section</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-settings#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"147\">{\"hidden\":false,\"schedules_enabled\":null,\"schedules\":null,\"segment_enabled\":null,\"segments\":null,\"target_groups_enabled\":null,\"target_groups\":null}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-subTitle#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"21\">Unforgettable Moments</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-title#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"43\">&lt;p&gt;Family-friendly activities&lt;br&gt;&amp;nbsp;&lt;/p&gt;</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaText#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"14\">All activities</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-btnTarget#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"6\">_blank</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-ctaLink#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"144\">{\"provider\":\"page\",\"target\":null,\"anchor\":null,\"query\":null,\"href\":\"9b7230e0-6e77-4671-bbe7-a370d1698c02\",\"title\":null,\"rel\":null,\"locale\":\"en\"}</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-defaultCtaText#4\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"13\">discover more</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-type#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-settings#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-page#0\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">aba99b98-d103-47d4-91d9-14f41b6d5169</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-type#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-settings#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-page#1\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">64853a06-a262-46e6-9576-c9d0920e167d</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-type#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"5\">items</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-settings#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"2\">[]</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-page#2\" sv:type=\"String\" sv:multi-valued=\"0\"><sv:value length=\"36\">2a30d487-a4a9-4fbf-aabf-a20bb5c95054</sv:value></sv:property></sv:node>
', numerical_props = '<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<sv:node xmlns:mix=\"http://www.jcp.org/jcr/mix/1.0\" xmlns:nt=\"http://www.jcp.org/jcr/nt/1.0\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:jcr=\"http://www.jcp.org/jcr/1.0\" xmlns:sv=\"http://www.jcp.org/jcr/sv/1.0\" xmlns:rep=\"internal\"><sv:property sv:name=\"i18n:en-state\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:en-creator\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:en-changer\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"i18n:en-nodeType\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">1</sv:value></sv:property><sv:property sv:name=\"sulu:order\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"3\">140</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">5</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#1-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">2</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-infos#1-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#3-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">6</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#2-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">4</sv:value></sv:property><sv:property sv:name=\"i18n:en-blocks-items#4-length\" sv:type=\"Long\" sv:multi-valued=\"0\"><sv:value length=\"1\">3</sv:value></sv:property></sv:node>
' WHERE id = 232;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/montcaud/contents'
                AND workspace_name = 'default'
              ORDER BY depth, sort_order ASC;

INSERT INTO re_references (
  resourceKey, resourceId, referenceResourceKey,
  referenceResourceId, referenceLocale,
  referenceRouterAttributes, referenceTitle,
  referenceProperty, referenceContext,
  created, changed
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO re_references (resourceKey, resourceId, referenceResourceKey, referenceResourceId, referenceLocale, referenceRouterAttributes, referenceTitle, referenceProperty, referenceContext, created, changed) VALUES ('media', '219', 'pages', '4178f463-da81-4e9b-becf-83612f69f014', 'en', '{\"locale\":\"en\",\"webspace\":\"montcaud\"}', 'kids and family', 'blocks[0].cover', 'admin', '2025-04-22 05:28:55', '2025-04-22 05:28:55');

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default';

SELECT
  CONCAT(
    n.path, '/', r.source_property_name
  )
FROM
  phpcr_nodes n
  INNER JOIN phpcr_nodes_references r ON n.id = r.source_id
WHERE
  r.target_id = ?
  AND source_property_name = ?

SELECT CONCAT(n.path, '/', r.source_property_name) FROM phpcr_nodes n
               INNER JOIN phpcr_nodes_references r ON n.id = r.source_id
               WHERE r.target_id = 232 AND source_property_name = 'sulu:content';

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

DELETE FROM
  phpcr_nodes_weakreferences
WHERE
  source_id IN (?)

DELETE FROM phpcr_nodes_weakreferences WHERE source_id IN (232);

DELETE FROM
  phpcr_nodes_references
WHERE
  source_id IN (?)

DELETE FROM phpcr_nodes_references WHERE source_id IN (232);

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents/kids-and-family') AND workspace_name = 'default' ORDER BY sort_order ASC;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      n0.path LIKE '/cmf/montcaud/custom-urls/%'
      AND EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:custom_url"]) > 0'
      )
    )
    AND EXTRACTVALUE(
      n0.props, 'count(//sv:property[@sv:name="sulu:target"]/sv:value[text()="4178f463-da81-4e9b-becf-83612f69f014"]) > 0'
    )
  )

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((n0.path LIKE '/cmf/montcaud/custom-urls/%' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:custom_url"]) > 0')) AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="sulu:target"]/sv:value[text()="4178f463-da81-4e9b-becf-83612f69f014"]) > 0'));

SELECT
  id
FROM
  phpcr_nodes
WHERE
  path COLLATE utf8mb4_bin = ?
  AND workspace_name = ?

SELECT id FROM phpcr_nodes WHERE path COLLATE utf8mb4_bin = '/cmf/montcaud/contents/kids-and-family' AND workspace_name = 'default';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default' AND (path = '/cmf/montcaud/routes/en/kids-and-family') ORDER BY sort_order ASC;

SELECT
  s0_.username AS username_0,
  s0_.password AS password_1,
  s0_.locale AS locale_2,
  s0_.salt AS salt_3,
  s0_.locked AS locked_4,
  s0_.enabled AS enabled_5,
  s0_.lastLogin AS lastLogin_6,
  s0_.confirmationKey AS confirmationKey_7,
  s0_.passwordResetToken AS passwordResetToken_8,
  s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9,
  s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10,
  s0_.privateKey AS privateKey_11,
  s0_.apiKey AS apiKey_12,
  s0_.email AS email_13,
  s0_.id AS id_14,
  s0_.created AS created_15,
  s0_.changed AS changed_16,
  s1_.locale AS locale_17,
  s1_.id AS id_18,
  s2_.name AS name_19,
  s2_.role_key AS role_key_20,
  s2_.securitySystem AS securitySystem_21,
  s2_.anonymous AS anonymous_22,
  s2_.id AS id_23,
  s2_.created AS created_24,
  s2_.changed AS changed_25,
  s3_.context AS context_26,
  s3_.module AS module_27,
  s3_.permissions AS permissions_28,
  s3_.id AS id_29,
  s0_.idContacts AS idContacts_30,
  s0_.idUsersCreator AS idUsersCreator_31,
  s0_.idUsersChanger AS idUsersChanger_32,
  s1_.idUsers AS idUsers_33,
  s1_.idRoles AS idRoles_34,
  s2_.idSecurityTypes AS idSecurityTypes_35,
  s2_.idUsersCreator AS idUsersCreator_36,
  s2_.idUsersChanger AS idUsersChanger_37,
  s3_.idRoles AS idRoles_38
FROM
  se_users s0_
  LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers
  LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id
  LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles
WHERE
  s0_.id = ?

SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.id = 1;

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SELECT
  t0.method AS method_1,
  t0.options AS options_2,
  t0.id AS id_3,
  t0.idUsers AS idUsers_4
FROM
  se_user_two_factors t0
WHERE
  t0.idUsers = ?

SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = 1;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  identifier = ?
  AND workspace_name = ?

SELECT * FROM phpcr_nodes WHERE identifier = '4178f463-da81-4e9b-becf-83612f69f014' AND workspace_name = 'default';