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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_03fae95109d52e1bb2ce82f8f1af9d87');

SELECT
  *
FROM
  object_relations_AWS_PROD
WHERE
  src_id = ?

SELECT * FROM object_relations_AWS_PROD WHERE src_id = 9998;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_258
tags
', 'class_AWS_CATEGORY
tags
', 'asset_2001
tags
', 'asset_24
tags
');

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT
  *
FROM
  object_relations_AWS_SER
WHERE
  src_id = ?

SELECT * FROM object_relations_AWS_SER WHERE src_id = 9997;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_9998
tags
', 'class_AWS_PROD
tags
', 'asset_3387
tags
', 'asset_3388
tags
', 'asset_3389
tags
');

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_592
tags
', 'class_AWS_PROD
tags
', 'asset_4715
tags
', 'asset_4716
tags
', 'asset_4717
tags
', 'asset_4718
tags
');

SELECT
  DISTINCT series
FROM
  object_localized_AWS_PROD_es
WHERE
  (
    (`showEuro` = ?)
    AND object_localized_AWS_PROD_es.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_AWS_PROD_es.published = 1

SELECT DISTINCT series FROM object_localized_AWS_PROD_es WHERE ((`showEuro` = 1)  AND  object_localized_AWS_PROD_es.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_es.published = 1;

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

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

SELECT
  *
FROM
  object_metadata_AWS_SETTINGS
WHERE
  object_metadata_AWS_SETTINGS.id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND `type` = 'asset'

SELECT * FROM object_metadata_AWS_SETTINGS WHERE object_metadata_AWS_SETTINGS.id = 4 AND dest_id = 1874 AND fieldname = 'footerLinks' AND ownertype = 'localizedfield' AND ownername = 'localizedfield' and position = 'es' and `index` = 1  AND `type` = 'asset';

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

SELECT object_localized_AWS_PROD_es.id as id, object_localized_AWS_PROD_es.type as `type` FROM object_localized_AWS_PROD_es WHERE ((`id` IN (9999, 10002, 10005, 10008, 393, 396, 404, 520, 522, 524, 527, 532, 533, 538, 413, 604, 547, 428, 557, 585, 584, 582, 565, 568, 570, 456, 579, 437, 445, 449, 461, 464, 468, 471, 472, 473, 476, 486, 487, 490, 493, 512, 511, 503, 501, 379, 380, 10001, 390, 391, 519, 401, 406, 505, 408, 534, 536, 542, 421, 420, 425, 591, 546, 550, 551, 559, 562, 432, 575, 441, 450, 451, 452, 462, 465, 603, 608, 494, 376, 499, 381, 377, 10000, 10004, 10006, 405, 518, 402, 407, 525, 397, 515, 535, 540, 414, 416, 422, 593, 594, 601, 549, 427, 586, 566, 504, 571, 434, 576, 460, 458, 578, 373, 439, 443, 454, 469, 466, 482, 480, 606, 484, 488, 510, 508, 500, 382, 9998, 10007, 513, 517, 609, 400, 521, 398, 541, 605, 411, 418, 423, 419, 417, 424, 426, 429, 592, 595, 596, 598, 543, 545, 548, 552, 560, 561, 588, 587, 564, 569, 455, 574, 457, 459, 435, 580, 436, 438, 447, 448, 453, 463, 474, 481, 607, 483, 485, 496, 507, 509, 384, 497, 502, 383, 378, 10003, 389, 392, 514, 394, 395, 516, 403, 523, 526, 399, 537, 539, 409, 410, 412, 415, 430, 590, 597, 600, 544, 553, 554, 555, 556, 558, 602, 583, 563, 567, 572, 573, 433, 431, 577, 442, 444, 440, 446, 581, 467, 470, 477, 479, 475, 478, 599, 489, 491, 492, 495, 498))  AND (`showEuro` = 1)  AND  object_localized_AWS_PROD_es.type IN ('object','variant','folder')) AND object_localized_AWS_PROD_es.published = 1 ORDER BY `priority` ASC  ;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10006
tags
', 'class_AWS_PROD
tags
', 'asset_4354
tags
', 'asset_4355
tags
', 'asset_4356
tags
', 'asset_4357
tags
', 'asset_4358
tags
', 'asset_4359
tags
', 'asset_4360
tags
');

SELECT
  DISTINCT categories
FROM
  object_localized_AWS_SER_es
WHERE
  (
    (
      `id` IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND object_localized_AWS_SER_es.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_AWS_SER_es.published = 1

SELECT DISTINCT categories FROM object_localized_AWS_SER_es WHERE ((`id` IN (9991, 307, 325, 324, 301, 303, 340, 342, 343, 344, 345, 347, 349, 350, 351, 355, 356, 352, 337, 299, 311, 365, 298, 297, 296, 310, 279, 277, 336, 326, 278, 327, 332, 328, 329, 331, 318, 317, 313, 360, 272, 346, 348, 292, 291, 353, 354, 357, 358, 359, 280, 361, 362, 306, 338, 333, 364, 9995, 339, 285, 9997, 9993, 9988, 9987, 9996))  AND  object_localized_AWS_SER_es.type IN ('object','variant','folder')) AND object_localized_AWS_SER_es.published = 1;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2001;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 2001;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_409
tags
', 'class_AWS_PROD
tags
', 'asset_3633
tags
', 'asset_3634
tags
', 'asset_3635
tags
', 'asset_3636
tags
', 'asset_3637
tags
', 'asset_3638
tags
', 'asset_3639
tags
', 'asset_3640
tags
', 'asset_3641
tags
', 'asset_3642
tags
', 'asset_3643
tags
');

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

SELECT object_localized_AWS_CATEGORY_es.id as id, object_localized_AWS_CATEGORY_es.type as `type` FROM object_localized_AWS_CATEGORY_es WHERE ((`id` IN (258, 263, 259, 262, 269, 265, 266, 264, 268, 261))  AND  object_localized_AWS_CATEGORY_es.type IN ('object','variant','folder')) AND object_localized_AWS_CATEGORY_es.published = 1 ORDER BY `orderPriority` ASC  ;

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

SELECT object_localized_AWS_SER_es.id as id, object_localized_AWS_SER_es.type as `type` FROM object_localized_AWS_SER_es WHERE ((`id` IN (9991, 307, 325, 324, 301, 303, 340, 342, 343, 344, 345, 347, 349, 350, 351, 355, 356, 352, 337, 299, 311, 365, 298, 297, 296, 310, 279, 277, 336, 326, 278, 327, 332, 328, 329, 331, 318, 317, 313, 360, 272, 346, 348, 292, 291, 353, 354, 357, 358, 359, 280, 361, 362, 306, 338, 333, 364, 9995, 339, 285, 9997, 9993, 9988, 9987, 9996))  AND  object_localized_AWS_SER_es.type IN ('object','variant','folder')) AND object_localized_AWS_SER_es.published = 1 ORDER BY `orderPriority` ASC  ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'AWS_PROD';

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_425
tags
', 'class_AWS_PROD
tags
', 'asset_3758
tags
', 'asset_3759
tags
', 'asset_3760
tags
', 'asset_3761
tags
', 'asset_3762
tags
', 'asset_3763
tags
');

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'productPriorityOrder'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_593
tags
', 'class_AWS_PROD
tags
', 'asset_4722
tags
', 'asset_4723
tags
', 'asset_4724
tags
', 'asset_4725
tags
', 'asset_4726
tags
', 'asset_4727
tags
', 'asset_4728
tags
', 'asset_4729
tags
');

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 = '/es/productos' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/es/productos' AND `type` = 'path_query') OR
                (source = 'https://sunny.test.awebsys.cz/es/productos' 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
  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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_516
tags
', 'class_AWS_PROD
tags
', 'asset_4258
tags
', 'asset_4259
tags
', 'asset_4260
tags
', 'asset_4261
tags
', 'asset_4262
tags
', 'asset_4263
tags
', 'asset_4264
tags
', 'asset_4265
tags
', 'asset_4266
tags
', 'asset_4267
tags
', 'asset_4268
tags
', 'asset_4269
tags
');

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

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

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

SELECT id FROM objects WHERE `path` = BINARY '/Filters/' AND `key` = BINARY 'ProductFilter';

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 3;

SELECT
  *
FROM
  object_relations_AWS_SETTINGS
WHERE
  src_id = ?

SELECT * FROM object_relations_AWS_SETTINGS WHERE src_id = 4;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 63;

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_609
tags
', 'class_AWS_PROD
tags
', 'asset_4839
tags
', 'asset_4840
tags
', 'asset_4841
tags
', 'asset_4842
tags
', 'asset_4843
tags
', 'asset_4844
tags
', 'asset_4845
tags
', 'asset_4846
tags
', 'asset_4847
tags
', 'asset_4848
tags
', 'asset_4849
tags
', 'asset_4850
tags
', 'asset_4851
tags
');

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 > 1765781438 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_598
tags
', 'class_AWS_PROD
tags
', 'asset_4771
tags
', 'asset_4772
tags
', 'asset_4773
tags
', 'asset_4774
tags
', 'asset_4775
tags
', 'asset_4776
tags
', 'asset_4777
tags
', 'asset_4778
tags
', 'asset_4779
tags
', 'asset_4780
tags
');

SELECT
  *
FROM
  object_relations_EF_FD
WHERE
  src_id = ?

SELECT * FROM object_relations_EF_FD WHERE src_id = 611;

SELECT
  id
FROM
  assets
WHERE
  id IN (
    1874, 1879, 1878, 1877, 1875, 1876, 1880,
    2078
  )

SELECT id FROM assets WHERE id IN (1874,1879,1878,1877,1875,1876,1880,2078);

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/es/productos';

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';