Symfony Profiler

SELECT
  *
FROM
  bolt_microservice
WHERE
  active = 1

SELECT * FROM bolt_microservice WHERE active=1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

UPDATE
  bolt_content
SET
  STATUS = 'published',
  published_at = :now
WHERE
  STATUS = 'timed'
  AND published_at < :now

UPDATE bolt_content SET STATUS = 'published', published_at = :now  WHERE STATUS = 'timed' AND published_at < :now;

UPDATE
  bolt_content
SET
  STATUS = 'held',
  depublished_at = :now
WHERE
  STATUS = 'published'
  AND depublished_at < :now

UPDATE bolt_content SET STATUS = 'held', depublished_at = :now WHERE STATUS = 'published' AND depublished_at < :now;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  b0_.id AS id_0,
  b0_.url_from AS url_from_1,
  b0_.url_to AS url_to_2,
  b0_.active AS active_3,
  b0_.is_short_link AS is_short_link_4,
  b0_.created AS created_5,
  b0_.modified AS modified_6
FROM
  bolt_redirection b0_
WHERE
  b0_.active = 1
  AND (
    b0_.url_from = ?
    OR b0_.url_from = ?
  )
  AND b0_.url_to <> ?

SELECT b0_.id AS id_0, b0_.url_from AS url_from_1, b0_.url_to AS url_to_2, b0_.active AS active_3, b0_.is_short_link AS is_short_link_4, b0_.created AS created_5, b0_.modified AS modified_6 FROM bolt_redirection b0_ WHERE b0_.active = 1 AND (b0_.url_from = '/edukacja-finansowa/budzet-domowy/www.santanderconsumer.pl' OR b0_.url_from = '/edukacja-finansowa/budzet-domowy/www.santanderconsumer.pl/') AND b0_.url_to <> '/edukacja-finansowa/budzet-domowy/www.santanderconsumer.pl';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.author_id AS author_id_7
FROM
  bolt_content b0_
  INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'block', 'checkbox',
    'collection', 'data', 'date', 'email',
    'embed', 'file', 'filelist', 'hidden',
    'html', 'image', 'imagelist', 'markdown',
    'number', 'set', 'slug', 'templateselect',
    'text', 'textarea', 'article', 'redactor'
  )
  INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id)
  AND b2_.type IN ('slug')
  INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id
WHERE
  CAST(
    JSON_UNQUOTE(
      JSON_EXTRACT(b3_.value, '$[0]')
    ) AS CHAR
  ) = ?
LIMIT
  1

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.author_id AS author_id_7 FROM bolt_content b0_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id) AND b2_.type IN ('slug') INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id WHERE CAST(JSON_UNQUOTE(JSON_EXTRACT(b3_.value, '$[0]')) AS CHAR) = 'www.santanderconsumer.pl' LIMIT 1;