Symfony Profiler

SELECT
  s0_.domain AS domain_0,
  s0_.label AS label_1,
  s1_.content AS content_2
FROM
  std_translations s0_
  INNER JOIN std_translations_content s1_ ON (s0_.id = s1_.translation_id)
WHERE
  s1_.language_code = ?
ORDER BY
  s0_.domain ASC,
  s0_.label ASC

SELECT s0_.domain AS domain_0, s0_.label AS label_1, s1_.content AS content_2 FROM std_translations s0_ INNER JOIN std_translations_content s1_ ON (s0_.id = s1_.translation_id) WHERE s1_.language_code = 'pt' ORDER BY s0_.domain ASC, s0_.label ASC;

SELECT
  s0_.id AS id_0,
  s0_.machine_name AS machine_name_1,
  s0_.description AS description_2,
  s0_.is_active AS is_active_3,
  s0_.created_date AS created_date_4,
  s0_.updated_date AS updated_date_5,
  s0_.erp_code AS erp_code_6,
  s0_.domain_type AS domain_type_7,
  s0_.icon AS icon_8,
  s0_.order_value AS order_value_9,
  s0_.updated_by AS updated_by_10,
  s0_.language_code AS language_code_11,
  s0_.created_by AS created_by_12,
  s0_.domain_id AS domain_id_13,
  s0_.parent_domain_value_id AS parent_domain_value_id_14,
  s0_.geo_map_id AS geo_map_id_15
FROM
  std_domains_values s0_
  LEFT JOIN std_geo_map s1_ ON s0_.geo_map_id = s1_.id
WHERE
  s0_.is_active = 1
  AND s1_.type IN (?, ?)
ORDER BY
  s0_.description ASC

SELECT s0_.id AS id_0, s0_.machine_name AS machine_name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.created_date AS created_date_4, s0_.updated_date AS updated_date_5, s0_.erp_code AS erp_code_6, s0_.domain_type AS domain_type_7, s0_.icon AS icon_8, s0_.order_value AS order_value_9, s0_.updated_by AS updated_by_10, s0_.language_code AS language_code_11, s0_.created_by AS created_by_12, s0_.domain_id AS domain_id_13, s0_.parent_domain_value_id AS parent_domain_value_id_14, s0_.geo_map_id AS geo_map_id_15 FROM std_domains_values s0_ LEFT JOIN std_geo_map s1_ ON s0_.geo_map_id = s1_.id WHERE s0_.is_active = 1 AND s1_.type IN ('municipality', 'district') ORDER BY s0_.description ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.created_date AS created_date_4,
  t0.updated_date AS updated_date_5,
  t0.order_value AS order_value_6,
  t0.publish_date AS publish_date_7,
  t0.expire_date AS expire_date_8,
  t0.layout AS layout_9,
  t0.machine_name AS machine_name_10,
  t0.include_sitemap AS include_sitemap_11,
  t0.content_type AS content_type_12,
  t0.template_id AS template_id_13,
  t14.id AS id_15,
  t14.status AS status_16,
  t14.page_id AS page_id_17,
  t14.last_approver_id AS last_approver_id_18,
  t0.created_by AS created_by_19,
  t0.updated_by AS updated_by_20
FROM
  std_pages t0
  LEFT JOIN std_pages_approval_status t14 ON t14.page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.order_value AS order_value_6, t0.publish_date AS publish_date_7, t0.expire_date AS expire_date_8, t0.layout AS layout_9, t0.machine_name AS machine_name_10, t0.include_sitemap AS include_sitemap_11, t0.content_type AS content_type_12, t0.template_id AS template_id_13, t14.id AS id_15, t14.status AS status_16, t14.page_id AS page_id_17, t14.last_approver_id AS last_approver_id_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20 FROM std_pages t0 LEFT JOIN std_pages_approval_status t14 ON t14.page_id = t0.id WHERE t0.id = 722;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.language_code AS language_code_3,
  t0.relation_tree AS relation_tree_4,
  t0.is_canonical AS is_canonical_5,
  t0.page_id AS page_id_6,
  t0.relation_id AS relation_id_7
FROM
  std_friendly_url t0
WHERE
  t0.relation_id = ?
  AND t0.language_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.language_code AS language_code_3, t0.relation_tree AS relation_tree_4, t0.is_canonical AS is_canonical_5, t0.page_id AS page_id_6, t0.relation_id AS relation_id_7 FROM std_friendly_url t0 WHERE t0.relation_id = 197 AND t0.language_code = 'pt' LIMIT 1;

SELECT
  t0.machine_name AS machine_name_1,
  t0.label AS label_2,
  t0.value AS value_3,
  t0.description_machine_name AS description_machine_name_4,
  t0.details_machine_name AS details_machine_name_5,
  t0.parent_name AS parent_name_6,
  t0.variable_type AS variable_type_7,
  t0.order_value AS order_value_8,
  t0.is_hidden AS is_hidden_9,
  t0.is_active AS is_active_10,
  t0.created_date AS created_date_11,
  t0.updated_date AS updated_date_12,
  t0.content AS content_13,
  t0.language_code AS language_code_14,
  t0.roles AS roles_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17
FROM
  std_config t0
WHERE
  t0.machine_name = ?
  AND t0.language_code = ?
LIMIT
  1

SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = 'MAIL_DRIVER' AND t0.language_code = '' LIMIT 1;

SELECT
  t0.language_code AS language_code_1,
  t0.name AS name_2,
  t0.is_public AS is_public_3,
  t0.is_available_in_backoffice AS is_available_in_backoffice_4,
  t0.is_active AS is_active_5,
  t0.is_default AS is_default_6,
  t0.order_value AS order_value_7,
  t0.locale AS locale_8
FROM
  std_languages t0
WHERE
  t0.language_code = ?
LIMIT
  1

SELECT t0.language_code AS language_code_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.is_available_in_backoffice AS is_available_in_backoffice_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.order_value AS order_value_7, t0.locale AS locale_8 FROM std_languages t0 WHERE t0.language_code = 'pt' LIMIT 1;

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 > 1769388222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('pfOnV5ZbFG:std_features');

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.language_code AS language_code_3,
  t0.relation_tree AS relation_tree_4,
  t0.is_canonical AS is_canonical_5,
  t0.page_id AS page_id_6,
  t0.relation_id AS relation_id_7
FROM
  std_friendly_url t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.language_code AS language_code_3, t0.relation_tree AS relation_tree_4, t0.is_canonical AS is_canonical_5, t0.page_id AS page_id_6, t0.relation_id AS relation_id_7 FROM std_friendly_url t0 WHERE t0.url = '/pt/temas/ambiente-e-meteorologia/sustentabilidade/empresas-portuguesas-reforcam-investimento-e-superam-media-europeia' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.attributes AS attributes_3,
  t0.domain_value_id AS domain_value_id_4,
  t0.language_code AS language_code_5
FROM
  std_domains_values_content t0
WHERE
  (
    t0.language_code = ?
    AND t0.domain_value_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.attributes AS attributes_3, t0.domain_value_id AS domain_value_id_4, t0.language_code AS language_code_5 FROM std_domains_values_content t0 WHERE (t0.language_code = 'pt' AND t0.domain_value_id = 826) LIMIT 1;

SELECT
  t0.is_active AS is_active_1,
  t0.created_date AS created_date_2,
  t0.updated_date AS updated_date_3,
  t0.title AS title_4,
  t0.url AS url_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.og_title AS og_title_9,
  t0.og_image AS og_image_10,
  t0.og_description AS og_description_11,
  t0.og_url AS og_url_12,
  t0.canonical_url AS canonical_url_13,
  t0.scripts_head AS scripts_head_14,
  t0.scripts_body AS scripts_body_15,
  t0.scripts_footer AS scripts_footer_16,
  t0.content AS content_17,
  t0.page_id AS page_id_18,
  t0.language_code AS language_code_19,
  t0.created_by AS created_by_20,
  t0.updated_by AS updated_by_21
FROM
  std_pages_content t0
WHERE
  t0.page_id = ?
  AND t0.language_code = ?
LIMIT
  1

SELECT t0.is_active AS is_active_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.title AS title_4, t0.url AS url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.og_title AS og_title_9, t0.og_image AS og_image_10, t0.og_description AS og_description_11, t0.og_url AS og_url_12, t0.canonical_url AS canonical_url_13, t0.scripts_head AS scripts_head_14, t0.scripts_body AS scripts_body_15, t0.scripts_footer AS scripts_footer_16, t0.content AS content_17, t0.page_id AS page_id_18, t0.language_code AS language_code_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM std_pages_content t0 WHERE t0.page_id = 157 AND t0.language_code = 'pt' LIMIT 1;

SELECT
  MIN(s0_.relation_id) AS sclr_0,
  s0_.page_id AS sclr_1,
  MIN(s0_.id) AS sclr_2,
  MIN(s0_.order_value) AS sclr_3,
  s1_.name AS name_4,
  s2_.machine_name AS machine_name_5
FROM
  std_pages_pages s0_
  INNER JOIN std_pages s1_ ON s0_.page_id = s1_.id
  INNER JOIN std_content_types s2_ ON s1_.content_type = s2_.id
  INNER JOIN std_pages_content s3_
WHERE
  s1_.is_active = 1
  AND (
    (
      s1_.publish_date IS NULL
      OR s1_.publish_date <= ?
    )
  )
  AND (
    (
      s1_.expire_date IS NULL
      OR s1_.expire_date > ?
    )
  )
  AND s3_.page_id = s1_.id
  AND s3_.language_code = ?
  AND (
    s0_.relation_id = ?
    OR s0_.relation_id IN (
      SELECT
        DISTINCT s4_.id
      FROM
        std_pages_pages s4_
      WHERE
        s4_.relation_id = ?
    )
  )
  AND s1_.id <> ?
  AND s1_.content_type IN ('101', '294')
GROUP BY
  s1_.id,
  s1_.name,
  s2_.machine_name
ORDER BY
  s1_.order_value ASC,
  s1_.publish_date DESC
LIMIT
  3

SELECT MIN(s0_.relation_id) AS sclr_0, s0_.page_id AS sclr_1, MIN(s0_.id) AS sclr_2, MIN(s0_.order_value) AS sclr_3, s1_.name AS name_4, s2_.machine_name AS machine_name_5 FROM std_pages_pages s0_ INNER JOIN std_pages s1_ ON s0_.page_id = s1_.id INNER JOIN std_content_types s2_ ON s1_.content_type = s2_.id INNER JOIN std_pages_content s3_ WHERE s1_.is_active = 1 AND ((s1_.publish_date IS NULL OR s1_.publish_date <= '2026-01-26 00:43:43')) AND ((s1_.expire_date IS NULL OR s1_.expire_date > '2026-01-26 00:43:43')) AND s3_.page_id = s1_.id AND s3_.language_code = 'pt' AND (s0_.relation_id = 282 OR s0_.relation_id IN (SELECT DISTINCT s4_.id FROM std_pages_pages s4_ WHERE s4_.relation_id = 282)) AND s1_.id <> 722 AND s1_.content_type IN ('101', '294') GROUP BY s1_.id, s1_.name, s2_.machine_name ORDER BY s1_.order_value ASC, s1_.publish_date DESC LIMIT 3;

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('wGziWeNk0O:std_redirects_237f5cf822b2bb7e8e0c37a829ee2435', 'N;', 1800, 1769388222) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.machine_name AS machine_name_2,
  s0_.type AS type_3,
  s0_.is_active AS is_active_4,
  s0_.created_date AS created_date_5,
  s0_.updated_date AS updated_date_6,
  s0_.order_value AS order_value_7,
  s1_.id AS id_8,
  s1_.attribute_machine_name AS attribute_machine_name_9,
  s1_.label AS label_10,
  s1_.value AS value_11,
  s1_.order_value AS order_value_12,
  s1_.color AS color_13,
  s1_.image AS image_14,
  s1_.created_date AS created_date_15,
  s1_.updated_date AS updated_date_16,
  s0_.created_by AS created_by_17,
  s0_.updated_by AS updated_by_18,
  s1_.attribute_id AS attribute_id_19,
  s1_.created_by AS created_by_20,
  s1_.updated_by AS updated_by_21
FROM
  std_pages_attributes_values s2_
  INNER JOIN std_attributes s0_ ON (
    s2_.attribute_machine_name = s0_.machine_name
  )
  INNER JOIN std_attributes_values s1_ ON (
    s0_.id = s1_.attribute_id
    AND s2_.value = s1_.value
  )
WHERE
  s2_.page_id = ?
ORDER BY
  s0_.order_value ASC,
  s1_.order_value ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.machine_name AS machine_name_2, s0_.type AS type_3, s0_.is_active AS is_active_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.order_value AS order_value_7, s1_.id AS id_8, s1_.attribute_machine_name AS attribute_machine_name_9, s1_.label AS label_10, s1_.value AS value_11, s1_.order_value AS order_value_12, s1_.color AS color_13, s1_.image AS image_14, s1_.created_date AS created_date_15, s1_.updated_date AS updated_date_16, s0_.created_by AS created_by_17, s0_.updated_by AS updated_by_18, s1_.attribute_id AS attribute_id_19, s1_.created_by AS created_by_20, s1_.updated_by AS updated_by_21 FROM std_pages_attributes_values s2_ INNER JOIN std_attributes s0_ ON (s2_.attribute_machine_name = s0_.machine_name) INNER JOIN std_attributes_values s1_ ON (s0_.id = s1_.attribute_id AND s2_.value = s1_.value) WHERE s2_.page_id = 722 ORDER BY s0_.order_value ASC, s1_.order_value ASC;

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'studio5'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'studio5' AND t.TABLE_SCHEMA = 'studio5' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'studio5' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'studio5' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'studio5' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.page_id AS page_id_2,
  t0.domain_value_id AS domain_value_id_3,
  t4.id AS id_5,
  t4.machine_name AS machine_name_6,
  t4.description AS description_7,
  t4.is_active AS is_active_8,
  t4.created_date AS created_date_9,
  t4.updated_date AS updated_date_10,
  t4.erp_code AS erp_code_11,
  t4.domain_type AS domain_type_12,
  t4.icon AS icon_13,
  t4.order_value AS order_value_14,
  t4.updated_by AS updated_by_15,
  t4.language_code AS language_code_16,
  t4.created_by AS created_by_17,
  t4.domain_id AS domain_id_18,
  t4.parent_domain_value_id AS parent_domain_value_id_19,
  t4.geo_map_id AS geo_map_id_20
FROM
  std_pages_tags t0
  INNER JOIN std_domains_values t4 ON t0.domain_value_id = t4.id
WHERE
  t0.page_id IN (?)

SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.domain_value_id AS domain_value_id_3, t4.id AS id_5, t4.machine_name AS machine_name_6, t4.description AS description_7, t4.is_active AS is_active_8, t4.created_date AS created_date_9, t4.updated_date AS updated_date_10, t4.erp_code AS erp_code_11, t4.domain_type AS domain_type_12, t4.icon AS icon_13, t4.order_value AS order_value_14, t4.updated_by AS updated_by_15, t4.language_code AS language_code_16, t4.created_by AS created_by_17, t4.domain_id AS domain_id_18, t4.parent_domain_value_id AS parent_domain_value_id_19, t4.geo_map_id AS geo_map_id_20 FROM std_pages_tags t0 INNER JOIN std_domains_values t4 ON t0.domain_value_id = t4.id WHERE t0.page_id IN (722);

SELECT
  t0.id AS id_1,
  t0.relation_id AS relation_id_2,
  t0.order_value AS order_value_3,
  t0.page_id AS page_id_4,
  t0.content_type AS content_type_5
FROM
  std_pages_pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.order_value AS order_value_3, t0.page_id AS page_id_4, t0.content_type AS content_type_5 FROM std_pages_pages t0 WHERE t0.id = '-2';

INSERT INTO std_tag_tracking (tag_id, tracking_id)
VALUES
  (?, ?)

INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (1844, 61978);

SELECT
  s0_.id AS id_0,
  s0_.url AS url_1,
  s0_.language_code AS language_code_2,
  s0_.relation_tree AS relation_tree_3,
  s0_.is_canonical AS is_canonical_4,
  s0_.page_id AS page_id_5,
  s0_.relation_id AS relation_id_6
FROM
  std_friendly_url s0_
WHERE
  s0_.relation_tree NOT LIKE '[]'
  AND s0_.page_id = ?
  AND s0_.language_code = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.language_code AS language_code_2, s0_.relation_tree AS relation_tree_3, s0_.is_canonical AS is_canonical_4, s0_.page_id AS page_id_5, s0_.relation_id AS relation_id_6 FROM std_friendly_url s0_ WHERE s0_.relation_tree NOT LIKE '[]' AND s0_.page_id = 448 AND s0_.language_code = 'pt' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.machine_name AS machine_name_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.width AS width_5,
  t0.height AS height_6,
  t0.position AS position_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  std_ads_zones t0
WHERE
  t0.machine_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.machine_name AS machine_name_2, t0.name AS name_3, t0.description AS description_4, t0.width AS width_5, t0.height AS height_6, t0.position AS position_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM std_ads_zones t0 WHERE t0.machine_name = 'halfpage' LIMIT 1;

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'studio5' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  t0.is_active AS is_active_1,
  t0.created_date AS created_date_2,
  t0.updated_date AS updated_date_3,
  t0.content AS content_4,
  t0.snippet_id AS snippet_id_5,
  t0.language_code AS language_code_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  std_snippets_content t0
WHERE
  (
    t0.language_code = ?
    AND t0.snippet_id = ?
  )
LIMIT
  1

SELECT t0.is_active AS is_active_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.content AS content_4, t0.snippet_id AS snippet_id_5, t0.language_code AS language_code_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM std_snippets_content t0 WHERE (t0.language_code = 'pt' AND t0.snippet_id = 2) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.created_date AS created_date_4,
  t0.updated_date AS updated_date_5,
  t0.machine_name AS machine_name_6,
  t0.description AS description_7,
  t0.is_hidden AS is_hidden_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10
FROM
  std_snippets t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.machine_name AS machine_name_6, t0.description AS description_7, t0.is_hidden AS is_hidden_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM std_snippets t0 WHERE t0.id = '2';

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'studio5' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  t0.language_code AS language_code_1,
  t0.name AS name_2,
  t0.is_public AS is_public_3,
  t0.is_available_in_backoffice AS is_available_in_backoffice_4,
  t0.is_active AS is_active_5,
  t0.is_default AS is_default_6,
  t0.order_value AS order_value_7,
  t0.locale AS locale_8
FROM
  std_languages t0
WHERE
  t0.is_active = ?
  AND t0.is_public = ?

SELECT t0.language_code AS language_code_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.is_available_in_backoffice AS is_available_in_backoffice_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.order_value AS order_value_7, t0.locale AS locale_8 FROM std_languages t0 WHERE t0.is_active = 1 AND t0.is_public = 1;

SELECT
  t0.id AS id_1,
  t0.visited_at AS visited_at_2,
  t0.session_hash AS session_hash_3,
  t0.tracking_id AS tracking_id_4,
  t0.hashed_ip AS hashed_ip_5,
  t0.fingerprint AS fingerprint_6,
  t0.country AS country_7,
  t0.city AS city_8,
  t0.precise_country AS precise_country_9,
  t0.precise_city AS precise_city_10,
  t0.event AS event_11,
  t0.page_id AS page_id_12,
  t0.web_user_id AS web_user_id_13
FROM
  std_pages_tracking t0
WHERE
  t0.tracking_id = ?
  AND t0.page_id = ?
  AND t0.event = ?
ORDER BY
  t0.visited_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.visited_at AS visited_at_2, t0.session_hash AS session_hash_3, t0.tracking_id AS tracking_id_4, t0.hashed_ip AS hashed_ip_5, t0.fingerprint AS fingerprint_6, t0.country AS country_7, t0.city AS city_8, t0.precise_country AS precise_country_9, t0.precise_city AS precise_city_10, t0.event AS event_11, t0.page_id AS page_id_12, t0.web_user_id AS web_user_id_13 FROM std_pages_tracking t0 WHERE t0.tracking_id = '92e2ba94c12570a751135d5d6bfee750cee823107fc76e9edbcb801fe3a9f020' AND t0.page_id = 722 AND t0.event = 'open_page' ORDER BY t0.visited_at DESC LIMIT 1;

SELECT
  t0.is_active AS is_active_1,
  t0.created_date AS created_date_2,
  t0.updated_date AS updated_date_3,
  t0.title AS title_4,
  t0.url AS url_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.og_title AS og_title_9,
  t0.og_image AS og_image_10,
  t0.og_description AS og_description_11,
  t0.og_url AS og_url_12,
  t0.canonical_url AS canonical_url_13,
  t0.scripts_head AS scripts_head_14,
  t0.scripts_body AS scripts_body_15,
  t0.scripts_footer AS scripts_footer_16,
  t0.content AS content_17,
  t0.page_id AS page_id_18,
  t0.language_code AS language_code_19,
  t0.created_by AS created_by_20,
  t0.updated_by AS updated_by_21
FROM
  std_pages_content t0
WHERE
  t0.title = ?
  AND t0.language_code = ?
LIMIT
  1

SELECT t0.is_active AS is_active_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.title AS title_4, t0.url AS url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.og_title AS og_title_9, t0.og_image AS og_image_10, t0.og_description AS og_description_11, t0.og_url AS og_url_12, t0.canonical_url AS canonical_url_13, t0.scripts_head AS scripts_head_14, t0.scripts_body AS scripts_body_15, t0.scripts_footer AS scripts_footer_16, t0.content AS content_17, t0.page_id AS page_id_18, t0.language_code AS language_code_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM std_pages_content t0 WHERE t0.title = 'Temas' AND t0.language_code = 'pt' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.created_date AS created_date_4,
  t0.updated_date AS updated_date_5,
  t0.order_value AS order_value_6,
  t0.publish_date AS publish_date_7,
  t0.expire_date AS expire_date_8,
  t0.layout AS layout_9,
  t0.machine_name AS machine_name_10,
  t0.include_sitemap AS include_sitemap_11,
  t0.content_type AS content_type_12,
  t0.template_id AS template_id_13,
  t14.id AS id_15,
  t14.status AS status_16,
  t14.page_id AS page_id_17,
  t14.last_approver_id AS last_approver_id_18,
  t0.created_by AS created_by_19,
  t0.updated_by AS updated_by_20
FROM
  std_pages t0
  LEFT JOIN std_pages_approval_status t14 ON t14.page_id = t0.id
WHERE
  t0.machine_name = ?
LIMIT
  1