Symfony Profiler

SELECT
  COUNT(*)
FROM
  objects
WHERE
  (
    objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1

SELECT COUNT(*) FROM objects WHERE ( objects.type IN ('object','variant','folder')) AND objects.published = 1;

INSERT INTO tmp_store (
  `id`, `data`, `tag`, `date`, `expiryDate`,
  `serialized`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO tmp_store (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES ('mt_5a2a17c2845ffd001e938b2cc41827dda1966314', 'God willing, the forecast continues to be moderate to heavy thunderstorms that lead to torrential runoff accompanied by showers of hail and active winds that cause dust and dust over parts of the regions of Makkah Al-Mukarramah, Medina, Riyadh, Qassim, Hail, Al-Jawf, Tabuk and the northern borders, while it will be moderate over parts of the regions of Al-Baha, Asir and Jazan as well as on the northern parts of the Eastern Province, with a chance of fog forming on parts of those areas.', 'translation', 1787140630, 1787227030, 0);

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 2050;

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 2050;

SELECT
  id
FROM
  documents d
WHERE
  parentId = ?
  AND published = 1
LIMIT
  1

SELECT id FROM documents d WHERE parentId = 5  AND published = 1 LIMIT 1;

DELETE FROM
  tmp_store
WHERE
  id = ?

DELETE FROM tmp_store WHERE id = 'mt_5a2a17c2845ffd001e938b2cc41827dda1966314';

SELECT
  *
FROM
  object_localized_data_Governorate
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_Governorate WHERE ooo_id = 195 AND language IN ('en','ar');

SELECT
  documents.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 53;

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 383;

SELECT
  *
FROM
  object_relations_Governorate
WHERE
  src_id = ?

SELECT * FROM object_relations_Governorate WHERE src_id = 195;

SELECT
  documents.*,
  documents_page.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 53;

SELECT
  *
FROM
  object_store_Governorate
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_Governorate WHERE oo_id = 195 FOR UPDATE;

INSERT INTO lock_keys (
  key_id, key_token, key_expiration
)
VALUES
  (
    ?,
    ?,
    UNIX_TIMESTAMP(
      NOW(6)
    ) + 300
  )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071', 'FmUf7jbnncM3Y10y4CbFzcipZEKKWrLWKW2ss1fFVQI=', UNIX_TIMESTAMP(NOW(6)) + 300);

SELECT
  *
FROM
  object_localized_data_manned_alert_notification
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_manned_alert_notification WHERE ooo_id = 417922 AND language IN ('en','ar');

SELECT
  *
FROM
  object_relations_manned_alert_notification
WHERE
  src_id = ?

SELECT * FROM object_relations_manned_alert_notification WHERE src_id = 417922;

SELECT
  *
FROM
  translations_messages
WHERE
  language = ?

SELECT * FROM translations_messages WHERE language = 'ar';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,5) AND inheritable = 1) OR cid = 6
                             ) AND ctype='document';

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'FmUf7jbnncM3Y10y4CbFzcipZEKKWrLWKW2ss1fFVQI=';

SELECT
  *
FROM
  object_store_manned_alert_notification
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_manned_alert_notification WHERE oo_id = 417922 FOR UPDATE;

SELECT
  documents.id,
  documents.type
FROM
  documents
WHERE
  (parentId = ?)
  AND published = 1
ORDER BY
  `index` ASC

SELECT documents.id, documents.type FROM documents WHERE  (parentId = 5) AND published = 1 ORDER BY `index` ASC  ;

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/ar/weather/marine-forecast' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/ar/weather/marine-forecast' AND `type` = 'path_query') OR
                (source = 'https://devncmpublic.centricdxb.com/ar/weather/marine-forecast' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Region';

SELECT
  object_localized_manned_alert_notification_ar.id as id,
  object_localized_manned_alert_notification_ar.type as `type`
FROM
  object_localized_manned_alert_notification_ar
WHERE
  (
    IFNULL(isEws, 0) = ?
    AND (`toDate` >= ?)
    AND object_localized_manned_alert_notification_ar.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_manned_alert_notification_ar.published = 1
ORDER BY
  `alertId` DESC

SELECT object_localized_manned_alert_notification_ar.id as id, object_localized_manned_alert_notification_ar.type as `type` FROM object_localized_manned_alert_notification_ar WHERE (IFNULL(isEws, 0) = 0 AND (`toDate` >= 1787140629)  AND  object_localized_manned_alert_notification_ar.type IN ('object','variant','folder')) AND object_localized_manned_alert_notification_ar.published = 1 ORDER BY `alertId` DESC  ;

SELECT
  *
FROM
  object_localized_data_alert_hazard
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_alert_hazard WHERE ooo_id = 2067 AND language IN ('en','ar');

SELECT
  COUNT(*)
FROM
  object_localized_manned_alert_notification_ar
WHERE
  (
    IFNULL(isEws, 0) = ?
    AND (`toDate` >= ?)
    AND object_localized_manned_alert_notification_ar.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_manned_alert_notification_ar.published = 1

SELECT COUNT(*) FROM object_localized_manned_alert_notification_ar WHERE (IFNULL(isEws, 0) = 0 AND (`toDate` >= 1787140629)  AND  object_localized_manned_alert_notification_ar.type IN ('object','variant','folder')) AND object_localized_manned_alert_notification_ar.published = 1;

SHOW COLUMNS
FROM
  tmp_store

SHOW COLUMNS FROM tmp_store;

SELECT
  *
FROM
  object_localized_data_Region
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_Region WHERE ooo_id = 36 AND language IN ('en','ar');

SELECT
  *
FROM
  object_relations_alert_hazard
WHERE
  src_id = ?

SELECT * FROM object_relations_alert_hazard WHERE src_id = 2067;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 212, 196, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,212,196,5) AND inheritable = 1) OR cid = 210
                             ) AND ctype='document';

SELECT
  object_InternalMarineReport.id as id,
  object_InternalMarineReport.type as `type`
FROM
  object_InternalMarineReport
WHERE
  (
    (windAr != '')
    AND (waveHightAr != '')
    AND (seaStatusAr != '')
    AND object_InternalMarineReport.type IN ('object', 'variant', 'folder')
  )
  AND object_InternalMarineReport.published = 1

SELECT object_InternalMarineReport.id as id, object_InternalMarineReport.type as `type` FROM object_InternalMarineReport WHERE ((windAr != '')  AND (waveHightAr != '')  AND (seaStatusAr != '')  AND  object_InternalMarineReport.type IN ('object','variant','folder')) AND object_InternalMarineReport.published = 1;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 196, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,196,5) AND inheritable = 1) OR cid = 212
                             ) AND ctype='document';

SELECT
  *
FROM
  object_store_alert_hazard
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_alert_hazard WHERE oo_id = 2067 FOR UPDATE;

SELECT
  *
FROM
  object_relations_Region
WHERE
  src_id = ?

SELECT * FROM object_relations_Region WHERE src_id = 36;

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  object_store_Region
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_Region WHERE oo_id = 36 FOR UPDATE;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 690;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 90, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,90,5) AND inheritable = 1) OR cid = 91
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 136, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,136,5) AND inheritable = 1) OR cid = 41
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 93, 90, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,93,90,5) AND inheritable = 1) OR cid = 107
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 28, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,28,5) AND inheritable = 1) OR cid = 53
                             ) AND ctype='document';

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  (
    objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  `modificationDate` DESC
LIMIT
  1

SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `modificationDate` DESC   LIMIT 1;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 44, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,44,5) AND inheritable = 1) OR cid = 162
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 77, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,77,5) AND inheritable = 1) OR cid = 64
                             ) AND ctype='document';

SELECT
  *
FROM
  object_localized_data_alert_status
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_alert_status WHERE ooo_id = 2066 AND language IN ('en','ar');

SELECT
  *
FROM
  object_store_InternalMarineReport
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_InternalMarineReport WHERE oo_id = 276425 FOR UPDATE;

SELECT
  *
FROM
  object_relations_InternalMarineReport
WHERE
  src_id = ?

SELECT * FROM object_relations_InternalMarineReport WHERE src_id = 276425;

SELECT
  documents.*,
  documents_link.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN documents_link ON documents.id = documents_link.id
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, documents_link.*, tree_locks.locked FROM documents
            LEFT JOIN documents_link ON documents.id = documents_link.id
                LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 28;

SELECT
  *
FROM
  object_relations_alert_status
WHERE
  src_id = ?

SELECT * FROM object_relations_alert_status WHERE src_id = 2066;

SELECT
  documents.*,
  documents_snippet.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 7;

SELECT
  object_Suggestions.id as id,
  object_Suggestions.type as `type`
FROM
  object_Suggestions
WHERE
  (
    page LIKE ?
    AND object_Suggestions.type IN ('object', 'variant', 'folder')
  )
  AND object_Suggestions.published = 1

SELECT object_Suggestions.id as id, object_Suggestions.type as `type` FROM object_Suggestions WHERE (page LIKE '%/weather/marine-forecast' AND  object_Suggestions.type IN ('object','variant','folder')) AND object_Suggestions.published = 1;

SELECT
  object_SuggestionAndComments.id as id,
  object_SuggestionAndComments.type as `type`
FROM
  object_SuggestionAndComments
WHERE
  (
    page LIKE ?
    AND object_SuggestionAndComments.type IN ('object', 'variant', 'folder')
  )
  AND object_SuggestionAndComments.published = 1

SELECT object_SuggestionAndComments.id as id, object_SuggestionAndComments.type as `type` FROM object_SuggestionAndComments WHERE (page LIKE '%/weather/marine-forecast' AND  object_SuggestionAndComments.type IN ('object','variant','folder')) AND object_SuggestionAndComments.published = 1;

SELECT
  *
FROM
  object_store_alert_status
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_alert_status WHERE oo_id = 2066 FOR UPDATE;

SELECT
  *
FROM
  assets_metadata
WHERE
  cid = ?

SELECT * FROM assets_metadata WHERE cid = 1045;

SELECT
  object_Suggestions.id as id,
  object_Suggestions.type as `type`
FROM
  object_Suggestions
WHERE
  (
    page LIKE ?
    AND WasThisPageHelpful = ?
    AND object_Suggestions.type IN ('object', 'variant', 'folder')
  )
  AND object_Suggestions.published = 1

SELECT object_Suggestions.id as id, object_Suggestions.type as `type` FROM object_Suggestions WHERE (page LIKE '%/weather/marine-forecast' AND WasThisPageHelpful = 'yes' AND  object_Suggestions.type IN ('object','variant','folder')) AND object_Suggestions.published = 1;

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  (
    `key` = 'kingdom_weather'
    AND objects.type IN ('variant', 'object')
  )
  AND objects.published = 1
LIMIT
  1

SELECT objects.id as id, objects.type as `type` FROM objects WHERE (`key` = 'kingdom_weather'  AND  objects.type IN ('variant','object')) AND objects.published = 1 LIMIT 1;

SELECT
  object_localized_municipality_ar.id as id,
  object_localized_municipality_ar.type as `type`
FROM
  object_localized_municipality_ar
WHERE
  (
    `municipalityid` = '1369'
    AND object_localized_municipality_ar.type IN ('variant', 'object')
  )
  AND object_localized_municipality_ar.published = 1
LIMIT
  1

SELECT object_localized_municipality_ar.id as id, object_localized_municipality_ar.type as `type` FROM object_localized_municipality_ar WHERE (`municipalityid` = '1369'  AND  object_localized_municipality_ar.type IN ('variant','object')) AND object_localized_municipality_ar.published = 1 LIMIT 1;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 53;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 6, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,6,5) AND inheritable = 1) OR cid = 7
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 95, 90, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,95,90,5) AND inheritable = 1) OR cid = 102
                             ) AND ctype='document';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 91, 90, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,91,90,5) AND inheritable = 1) OR cid = 101
                             ) AND ctype='document';

SELECT
  *
FROM
  sites
WHERE
  mainDomain = ?
  OR domains LIKE ?

SELECT * FROM sites WHERE mainDomain = 'devncmpublic.centricdxb.com' OR domains LIKE '%\"devncmpublic.centricdxb.com\"%';

SELECT
  search_term,
  page_url,
  search_count
FROM
  most_searched_terms
ORDER BY
  search_count DESC
LIMIT
  10

SELECT search_term, page_url, search_count FROM most_searched_terms ORDER BY search_count DESC LIMIT 10;

SELECT
  *
FROM
  object_localized_data_aa
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_aa WHERE ooo_id = 2053 AND language IN ('en','ar');

SELECT
  *
FROM
  object_relations_aa
WHERE
  src_id = ?

SELECT * FROM object_relations_aa WHERE src_id = 2053;

SELECT
  object_localized_municipality_ar.id as id,
  object_localized_municipality_ar.type as `type`
FROM
  object_localized_municipality_ar
WHERE
  (
    `municipalityid` = '753'
    AND object_localized_municipality_ar.type IN ('variant', 'object')
  )
  AND object_localized_municipality_ar.published = 1
LIMIT
  1

SELECT object_localized_municipality_ar.id as id, object_localized_municipality_ar.type as `type` FROM object_localized_municipality_ar WHERE (`municipalityid` = '753'  AND  object_localized_municipality_ar.type IN ('variant','object')) AND object_localized_municipality_ar.published = 1 LIMIT 1;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 157, 196, 5)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,157,196,5) AND inheritable = 1) OR cid = 179
                             ) AND ctype='document';

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP(
    NOW(6)
  )

SELECT 1 FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'FmUf7jbnncM3Y10y4CbFzcipZEKKWrLWKW2ss1fFVQI=' AND key_expiration > UNIX_TIMESTAMP(NOW(6));

SELECT
  *
FROM
  object_store_aa
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_aa WHERE oo_id = 2053 FOR UPDATE;

SELECT
  *
FROM
  object_relations_SuggestionAndComments
WHERE
  src_id = ?

SELECT * FROM object_relations_SuggestionAndComments WHERE src_id = 365724;

SELECT
  *
FROM
  object_relations_Suggestions
WHERE
  src_id = ?

SELECT * FROM object_relations_Suggestions WHERE src_id = 169003;

SELECT
  *
FROM
  object_store_SuggestionAndComments
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_SuggestionAndComments WHERE oo_id = 365724 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_alert_type
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_alert_type WHERE ooo_id = 2043 AND language IN ('en','ar');

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  (
    parentId = ?
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  `key` ASC

SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 2050 AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC  ;

SELECT
  *
FROM
  object_localized_data_municipality
WHERE
  ooo_id = ?
  AND language IN ('en', 'ar')

SELECT * FROM object_localized_data_municipality WHERE ooo_id = 33779 AND language IN ('en','ar');

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = 5
                             ) AND ctype='document';

SELECT
  *
FROM
  object_store_Suggestions
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_Suggestions WHERE oo_id = 169003 FOR UPDATE;

SELECT
  *
FROM
  object_relations_MannedAlertLog
WHERE
  src_id = ?

SELECT * FROM object_relations_MannedAlertLog WHERE src_id = 417972;

SELECT
  *
FROM
  object_relations_alert_type
WHERE
  src_id = ?

SELECT * FROM object_relations_alert_type WHERE src_id = 2043;

SELECT
  COUNT(*)
FROM
  documents
WHERE
  published = 1

SELECT COUNT(*) FROM documents WHERE published = 1;

SELECT
  *
FROM
  object_store_MannedAlertLog
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_MannedAlertLog WHERE oo_id = 417972 FOR UPDATE;

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

SELECT id FROM documents WHERE `path` = BINARY '/ar/weather/' AND `key` = BINARY 'marine-forecast';

SELECT
  *
FROM
  object_relations_municipality
WHERE
  src_id = ?

SELECT * FROM object_relations_municipality WHERE src_id = 33779;

UPDATE
  lock_keys
SET
  key_expiration = UNIX_TIMESTAMP(
    NOW(6)
  ) + ?,
  key_token = ?
WHERE
  key_id = ?
  AND (
    key_token = ?
    OR key_expiration <= UNIX_TIMESTAMP(
      NOW(6)
    )
  )

UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + 300, key_token = 'FmUf7jbnncM3Y10y4CbFzcipZEKKWrLWKW2ss1fFVQI=' WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND (key_token = 'FmUf7jbnncM3Y10y4CbFzcipZEKKWrLWKW2ss1fFVQI=' OR key_expiration <= UNIX_TIMESTAMP(NOW(6)));

SELECT
  *
FROM
  object_store_alert_type
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_alert_type WHERE oo_id = 2043 FOR UPDATE;

SELECT
  *
FROM
  object_store_municipality
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_municipality WHERE oo_id = 33779 FOR UPDATE;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  *
FROM
  object_relations_KingdomWeather
WHERE
  src_id = ?

SELECT * FROM object_relations_KingdomWeather WHERE src_id = 30674;

SELECT
  *
FROM
  object_store_KingdomWeather
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_KingdomWeather WHERE oo_id = 30674 FOR UPDATE;

SELECT
  documents.id,
  documents.type
FROM
  documents
WHERE
  published = 1
ORDER BY
  `modificationDate` DESC
LIMIT
  1

SELECT documents.id, documents.type FROM documents WHERE published = 1 ORDER BY `modificationDate` DESC   LIMIT 1;

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

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

SELECT
  id
FROM
  redirects
WHERE
  active = 1
  AND regex = 1
ORDER BY
  `priority` DESC

SELECT id FROM redirects WHERE active = 1 AND regex = 1  ORDER BY `priority` DESC;