Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1736493963 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_a733050198d2de920e561da3e079c8a3', 'site_domain_a733050198d2de920e561da3e079c8a3');

UPDATE
  email_log
SET
  `id` = ?,
  `documentId` = ?,
  `params` = ?,
  `requestUri` = ?,
  `from` = ?,
  `replyTo` = ?,
  `to` = ?,
  `cc` = ?,
  `bcc` = ?,
  `sentDate` = ?,
  `subject` = ?,
  `error` = ?
WHERE
  `id` = ?

UPDATE email_log SET `id` = 812, `documentId` = 7, `params` = '[{\"key\":\"email\",\"data\":{\"type\":\"simple\",\"value\":\"ericjonesmyemail@gmail.com\"}},{\"key\":\"full_name\",\"data\":{\"type\":\"simple\",\"value\":\"Eric Jones\"}},{\"key\":\"message\",\"data\":{\"type\":\"simple\",\"value\":\"Hello Credimas Administrator,\\r\\n\\r\\nMy name is Eric and, unlike many emails you may receive, I would like to provide you with a word of congratulations \\u2013 well done!\\r\\n\\r\\nWhat for?\\r\\n\\r\\nPart of my job is to review websites, and the work you\\u2019ve done with Credimas certainly stands out.\\r\\n\\r\\nIt\\u2019s clear you have taken building a website seriously and made a real investment of effort into making it top quality.\\r\\n\\r\\nHowever, there is, indeed, a question\\u2026\\r\\n\\r\\nSo, when someone such as me stumbles upon your site \\u2013 maybe at the top of the search results (great job, by the way) or just through a random link, how do you know?\\r\\n\\r\\nMore importantly, how do you make a connection with that person?\\r\\n\\r\\nStudies show that 7 out of 10 visitors leave \\u2013 they\\u2019re there one second and then gone.\\r\\n\\r\\nHere\\u2019s a way to create immediate engagement that you may not have known about\\u2026\\r\\n\\r\\nWeb Visitors Into Leads is a software widget that works on your site, ready to gather any visitor\\u2019s Name, Email address, and Phone Number. It lets you know immediately that they\\u2019re interested \\u2013 so that you can speak to that lead while they\\u2019re actually browsing Credimas.\\r\\n\\r\\nPlease see this URL to experience a Live Demo with Web Visitors Into Leads now to see exactly how it works:  \\r\\nhttps:\\/\\/trustedleadgeneration.com\\r\\n\\r\\nIt can be a significant improvement for your business \\u2013 and it gets even better\\u2026 once you\\u2019ve gathered their phone number, with our new SMS Text With Lead feature, you can immediately start a text conversation \\u2013 right away (and there\\u2019s actually a notable difference between contacting someone within 5 minutes versus 30 minutes.)\\r\\n\\r\\nAdditionally, even if you don\\u2019t close a deal right away, you can follow up later on with text messages for new offers, content links, or just friendly notes to build a relationship.\\r\\n\\r\\nEverything I\\u2019ve described is straightforward, user-friendly, and effective.\\r\\n\\r\\nPlease see this URL to learn what Web Visitors Into Leads can do for your business:  \\r\\nhttps:\\/\\/trustedleadgeneration.com\\r\\n\\r\\nYou could be converting significantly more leads today!\\r\\n\\r\\nEric\\r\\n\\r\\nPS: Web Visitors Into Leads offers a 14-day trial \\u2013 and it even includes International Calling.  \\r\\nYou have customers ready to talk with you right now\\u2026 don\\u2019t keep them waiting.  \\r\\nPlease see this URL to use Web Visitors Into Leads now:  \\r\\nhttps:\\/\\/trustedleadgeneration.com\\r\\n\\r\\nJust a brief message - the names and email address used here, Eric and Jones, are placeholders and not actual contact information. We value honesty and wanted to ensure you are aware! If you want to get in touch with the actual person behind this message, please visit our site, and we\\u2019ll connect you with the appropriate individual.\\r\\n\\r\\n==================================================\\r\\n\\r\\nWe are strongly committed to protecting your privacy and providing a safe and high-quality online experience. We understand that you care about how the information you provide to us is used and shared. We have developed a Privacy Policy to inform you about the collection, use, and disclosure of information we receive from users of our website. We operate the website.\\r\\n\\r\\nOur Privacy Policy, along with our Terms & Conditions, governs your use of this site. By using the website, or by accepting the Terms of Use (via opt-in, checkbox, pop-up, or clicking an email link confirming the same), you agree to be bound by our Terms & Conditions and our Privacy Policy.\\r\\n\\r\\nIf you have provided any voluntarily given information, you may review and make changes to it via instructions found on the website. To manage your receipt of marketing and non-transactional communications, you may Want to receive less emails, or none whatsoever? Update your email preferences by clicking here. by visiting this URL directly:  \\r\\nhttps:\\/\\/trustedleadgeneration.com\\/unsubscribe.aspx?d=credimas.it\\r\\n\\r\\nEmails related to the purchase or delivery of orders are provided automatically \\u2013 customers are not able to opt out of transactional emails. We will try to address any requests related to the management of Personal Information in a timely manner. However, it may not always be possible to completely remove or modify information in our databases if we have a necessary reason to keep it for a certain timeframe. If you have any questions, simply see our website to view our official policies.\\r\\n\\r\\nOur primary goal is to help you have thriving lead generation. These emails are intended to give you guidance on that topic, or to highlight products that will help you have the kind of business success people talk about.\\r\\n\\r\\nIf you\'d like to Want to receive less emails, or none whatsoever? Update your email preferences by clicking here. click here https:\\/\\/trustedleadgeneration.com\\/unsubscribe.aspx?d=credimas.it\"}}]', `requestUri` = '/Contact', `from` = 'info@credimas.it', `replyTo` = 'info@credimas.it', `to` = 'djabloo@gmail.com', `cc` = NULL, `bcc` = NULL, `sentDate` = 1736493965, `subject` = 'da credimas', `error` = NULL WHERE `id` = 812;

INSERT INTO email_log ()
VALUES
  ()

INSERT INTO email_log () VALUES ();

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'Contact';

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(path)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7;

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/Contact'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/Contact' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/Contact' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/Contact' AND `type` = 'path_query') OR
                (source = 'https://credimas.it/Contact' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  *
FROM
  email_blacklist
WHERE
  address = ?

SELECT * FROM email_blacklist WHERE address = 'djabloo@gmail.com';