Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.88 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.22 ms	SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.route_name AS route_name_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.block_content AS block_content_14, s1_.title AS title_15, s1_.slug AS slug_16, s1_.is_active AS is_active_17, s1_.content AS content_18, c2_.id AS id_19, c2_.created_by AS created_by_20, c2_.updated_by AS updated_by_21, c2_.deleted_at AS deleted_at_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.template AS template_25, c2_.position AS position_26, c3_.id AS id_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.deleted_at AS deleted_at_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c4_.locale AS locale_39, c4_.site_name AS site_name_40, c4_.description AS description_41, c4_.keywords AS keywords_42, c4_.image AS image_43, c4_.title AS title_44, c4_.slug AS slug_45, s0_.meta_id AS meta_id_46, s1_.translatable_id AS translatable_id_47, c2_.slider_id AS slider_id_48, c4_.translatable_id AS translatable_id_49 FROM system_page s0_ INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id WHERE s0_.route_name = ? AND s1_.locale = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL ORDER BY c2_.position ASC LIMIT 1 Parameters: [`"application_home" "hu"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.route_name AS route_name_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.block_content AS block_content_14, s1_.title AS title_15, s1_.slug AS slug_16, s1_.is_active AS is_active_17, s1_.content AS content_18, c2_.id AS id_19, c2_.created_by AS created_by_20, c2_.updated_by AS updated_by_21, c2_.deleted_at AS deleted_at_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.template AS template_25, c2_.position AS position_26, c3_.id AS id_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.deleted_at AS deleted_at_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c4_.locale AS locale_39, c4_.site_name AS site_name_40, c4_.description AS description_41, c4_.keywords AS keywords_42, c4_.image AS image_43, c4_.title AS title_44, c4_.slug AS slug_45, s0_.meta_id AS meta_id_46, s1_.translatable_id AS translatable_id_47, c2_.slider_id AS slider_id_48, c4_.translatable_id AS translatable_id_49 FROM system_page s0_ INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id WHERE s0_.route_name = ? AND s1_.locale = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL ORDER BY c2_.position ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.route_name AS route_name_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.block_content AS block_content_14, s1_.title AS title_15, s1_.slug AS slug_16, s1_.is_active AS is_active_17, s1_.content AS content_18, c2_.id AS id_19, c2_.created_by AS created_by_20, c2_.updated_by AS updated_by_21, c2_.deleted_at AS deleted_at_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.template AS template_25, c2_.position AS position_26, c3_.id AS id_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.deleted_at AS deleted_at_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c4_.locale AS locale_39, c4_.site_name AS site_name_40, c4_.description AS description_41, c4_.keywords AS keywords_42, c4_.image AS image_43, c4_.title AS title_44, c4_.slug AS slug_45, s0_.meta_id AS meta_id_46, s1_.translatable_id AS translatable_id_47, c2_.slider_id AS slider_id_48, c4_.translatable_id AS translatable_id_49 FROM system_page s0_ INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id WHERE s0_.route_name = 'application_home' AND s1_.locale = 'hu' AND s1_.is_active = 1 AND s1_.deleted_at IS NULL ORDER BY c2_.position ASC LIMIT 1;
2	0.66 ms	SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.code AS code_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.title AS title_14, s1_.slug AS slug_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.created_by AS created_by_18, s2_.updated_by AS updated_by_19, s2_.deleted_at AS deleted_at_20, s2_.created_at AS created_at_21, s2_.updated_at AS updated_at_22, s2_.config_key AS config_key_23, s3_.id AS id_24, s3_.created_by AS created_by_25, s3_.updated_by AS updated_by_26, s3_.deleted_at AS deleted_at_27, s3_.created_at AS created_at_28, s3_.updated_at AS updated_at_29, s3_.locale AS locale_30, s3_.value AS value_31, s3_.file AS file_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.id AS id_39, c5_.created_by AS created_by_40, c5_.updated_by AS updated_by_41, c5_.deleted_at AS deleted_at_42, c5_.created_at AS created_at_43, c5_.updated_at AS updated_at_44, c5_.locale AS locale_45, c5_.site_name AS site_name_46, c5_.description AS description_47, c5_.keywords AS keywords_48, c5_.image AS image_49, c5_.title AS title_50, c5_.slug AS slug_51, s0_.meta_id AS meta_id_52, s1_.translatable_id AS translatable_id_53, s2_.application_id AS application_id_54, s3_.translatable_id AS translatable_id_55, c5_.translatable_id AS translatable_id_56 FROM system_application s0_ INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id WHERE s0_.code = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL LIMIT 1 Parameters: [`"default"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.code AS code_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.title AS title_14, s1_.slug AS slug_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.created_by AS created_by_18, s2_.updated_by AS updated_by_19, s2_.deleted_at AS deleted_at_20, s2_.created_at AS created_at_21, s2_.updated_at AS updated_at_22, s2_.config_key AS config_key_23, s3_.id AS id_24, s3_.created_by AS created_by_25, s3_.updated_by AS updated_by_26, s3_.deleted_at AS deleted_at_27, s3_.created_at AS created_at_28, s3_.updated_at AS updated_at_29, s3_.locale AS locale_30, s3_.value AS value_31, s3_.file AS file_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.id AS id_39, c5_.created_by AS created_by_40, c5_.updated_by AS updated_by_41, c5_.deleted_at AS deleted_at_42, c5_.created_at AS created_at_43, c5_.updated_at AS updated_at_44, c5_.locale AS locale_45, c5_.site_name AS site_name_46, c5_.description AS description_47, c5_.keywords AS keywords_48, c5_.image AS image_49, c5_.title AS title_50, c5_.slug AS slug_51, s0_.meta_id AS meta_id_52, s1_.translatable_id AS translatable_id_53, s2_.application_id AS application_id_54, s3_.translatable_id AS translatable_id_55, c5_.translatable_id AS translatable_id_56 FROM system_application s0_ INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id WHERE s0_.code = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL LIMIT 1 SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.code AS code_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.title AS title_14, s1_.slug AS slug_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.created_by AS created_by_18, s2_.updated_by AS updated_by_19, s2_.deleted_at AS deleted_at_20, s2_.created_at AS created_at_21, s2_.updated_at AS updated_at_22, s2_.config_key AS config_key_23, s3_.id AS id_24, s3_.created_by AS created_by_25, s3_.updated_by AS updated_by_26, s3_.deleted_at AS deleted_at_27, s3_.created_at AS created_at_28, s3_.updated_at AS updated_at_29, s3_.locale AS locale_30, s3_.value AS value_31, s3_.file AS file_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.id AS id_39, c5_.created_by AS created_by_40, c5_.updated_by AS updated_by_41, c5_.deleted_at AS deleted_at_42, c5_.created_at AS created_at_43, c5_.updated_at AS updated_at_44, c5_.locale AS locale_45, c5_.site_name AS site_name_46, c5_.description AS description_47, c5_.keywords AS keywords_48, c5_.image AS image_49, c5_.title AS title_50, c5_.slug AS slug_51, s0_.meta_id AS meta_id_52, s1_.translatable_id AS translatable_id_53, s2_.application_id AS application_id_54, s3_.translatable_id AS translatable_id_55, c5_.translatable_id AS translatable_id_56 FROM system_application s0_ INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id WHERE s0_.code = 'default' AND s1_.is_active = 1 AND s1_.deleted_at IS NULL LIMIT 1;

#▲

Time

Info

1.22 ms

SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.route_name AS route_name_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.block_content AS block_content_14, s1_.title AS title_15, s1_.slug AS slug_16, s1_.is_active AS is_active_17, s1_.content AS content_18, c2_.id AS id_19, c2_.created_by AS created_by_20, c2_.updated_by AS updated_by_21, c2_.deleted_at AS deleted_at_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.template AS template_25, c2_.position AS position_26, c3_.id AS id_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.deleted_at AS deleted_at_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c4_.locale AS locale_39, c4_.site_name AS site_name_40, c4_.description AS description_41, c4_.keywords AS keywords_42, c4_.image AS image_43, c4_.title AS title_44, c4_.slug AS slug_45, s0_.meta_id AS meta_id_46, s1_.translatable_id AS translatable_id_47, c2_.slider_id AS slider_id_48, c4_.translatable_id AS translatable_id_49 FROM system_page s0_ INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id WHERE s0_.route_name = ? AND s1_.locale = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL ORDER BY c2_.position ASC LIMIT 1

Parameters:

[
  "application_home"
  "hu"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.created_by AS created_by_1,
  s0_.updated_by AS updated_by_2,
  s0_.deleted_at AS deleted_at_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.route_name AS route_name_6,
  s1_.id AS id_7,
  s1_.created_by AS created_by_8,
  s1_.updated_by AS updated_by_9,
  s1_.deleted_at AS deleted_at_10,
  s1_.created_at AS created_at_11,
  s1_.updated_at AS updated_at_12,
  s1_.locale AS locale_13,
  s1_.block_content AS block_content_14,
  s1_.title AS title_15,
  s1_.slug AS slug_16,
  s1_.is_active AS is_active_17,
  s1_.content AS content_18,
  c2_.id AS id_19,
  c2_.created_by AS created_by_20,
  c2_.updated_by AS updated_by_21,
  c2_.deleted_at AS deleted_at_22,
  c2_.created_at AS created_at_23,
  c2_.updated_at AS updated_at_24,
  c2_.template AS template_25,
  c2_.position AS position_26,
  c3_.id AS id_27,
  c3_.created_by AS created_by_28,
  c3_.updated_by AS updated_by_29,
  c3_.deleted_at AS deleted_at_30,
  c3_.created_at AS created_at_31,
  c3_.updated_at AS updated_at_32,
  c4_.id AS id_33,
  c4_.created_by AS created_by_34,
  c4_.updated_by AS updated_by_35,
  c4_.deleted_at AS deleted_at_36,
  c4_.created_at AS created_at_37,
  c4_.updated_at AS updated_at_38,
  c4_.locale AS locale_39,
  c4_.site_name AS site_name_40,
  c4_.description AS description_41,
  c4_.keywords AS keywords_42,
  c4_.image AS image_43,
  c4_.title AS title_44,
  c4_.slug AS slug_45,
  s0_.meta_id AS meta_id_46,
  s1_.translatable_id AS translatable_id_47,
  c2_.slider_id AS slider_id_48,
  c4_.translatable_id AS translatable_id_49
FROM
  system_page s0_
  INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id
  LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id
  LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id
  LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id
  LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id
WHERE
  s0_.route_name = ?
  AND s1_.locale = ?
  AND s1_.is_active = 1
  AND s1_.deleted_at IS NULL
ORDER BY
  c2_.position ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.route_name AS route_name_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.block_content AS block_content_14, s1_.title AS title_15, s1_.slug AS slug_16, s1_.is_active AS is_active_17, s1_.content AS content_18, c2_.id AS id_19, c2_.created_by AS created_by_20, c2_.updated_by AS updated_by_21, c2_.deleted_at AS deleted_at_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.template AS template_25, c2_.position AS position_26, c3_.id AS id_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.deleted_at AS deleted_at_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c4_.locale AS locale_39, c4_.site_name AS site_name_40, c4_.description AS description_41, c4_.keywords AS keywords_42, c4_.image AS image_43, c4_.title AS title_44, c4_.slug AS slug_45, s0_.meta_id AS meta_id_46, s1_.translatable_id AS translatable_id_47, c2_.slider_id AS slider_id_48, c4_.translatable_id AS translatable_id_49 FROM system_page s0_ INNER JOIN system_page_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_page_to_block s5_ ON s0_.id = s5_.page_id LEFT JOIN common_layout_block c2_ ON c2_.id = s5_.block_id LEFT JOIN common_meta c3_ ON s0_.meta_id = c3_.id LEFT JOIN common_meta_translation c4_ ON c3_.id = c4_.translatable_id WHERE s0_.route_name = 'application_home' AND s1_.locale = 'hu' AND s1_.is_active = 1 AND s1_.deleted_at IS NULL ORDER BY c2_.position ASC LIMIT 1;

0.66 ms

SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.code AS code_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.title AS title_14, s1_.slug AS slug_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.created_by AS created_by_18, s2_.updated_by AS updated_by_19, s2_.deleted_at AS deleted_at_20, s2_.created_at AS created_at_21, s2_.updated_at AS updated_at_22, s2_.config_key AS config_key_23, s3_.id AS id_24, s3_.created_by AS created_by_25, s3_.updated_by AS updated_by_26, s3_.deleted_at AS deleted_at_27, s3_.created_at AS created_at_28, s3_.updated_at AS updated_at_29, s3_.locale AS locale_30, s3_.value AS value_31, s3_.file AS file_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.id AS id_39, c5_.created_by AS created_by_40, c5_.updated_by AS updated_by_41, c5_.deleted_at AS deleted_at_42, c5_.created_at AS created_at_43, c5_.updated_at AS updated_at_44, c5_.locale AS locale_45, c5_.site_name AS site_name_46, c5_.description AS description_47, c5_.keywords AS keywords_48, c5_.image AS image_49, c5_.title AS title_50, c5_.slug AS slug_51, s0_.meta_id AS meta_id_52, s1_.translatable_id AS translatable_id_53, s2_.application_id AS application_id_54, s3_.translatable_id AS translatable_id_55, c5_.translatable_id AS translatable_id_56 FROM system_application s0_ INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id WHERE s0_.code = ? AND s1_.is_active = 1 AND s1_.deleted_at IS NULL LIMIT 1

Parameters:

[
  "default"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.created_by AS created_by_1,
  s0_.updated_by AS updated_by_2,
  s0_.deleted_at AS deleted_at_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.code AS code_6,
  s1_.id AS id_7,
  s1_.created_by AS created_by_8,
  s1_.updated_by AS updated_by_9,
  s1_.deleted_at AS deleted_at_10,
  s1_.created_at AS created_at_11,
  s1_.updated_at AS updated_at_12,
  s1_.locale AS locale_13,
  s1_.title AS title_14,
  s1_.slug AS slug_15,
  s1_.is_active AS is_active_16,
  s2_.id AS id_17,
  s2_.created_by AS created_by_18,
  s2_.updated_by AS updated_by_19,
  s2_.deleted_at AS deleted_at_20,
  s2_.created_at AS created_at_21,
  s2_.updated_at AS updated_at_22,
  s2_.config_key AS config_key_23,
  s3_.id AS id_24,
  s3_.created_by AS created_by_25,
  s3_.updated_by AS updated_by_26,
  s3_.deleted_at AS deleted_at_27,
  s3_.created_at AS created_at_28,
  s3_.updated_at AS updated_at_29,
  s3_.locale AS locale_30,
  s3_.value AS value_31,
  s3_.file AS file_32,
  c4_.id AS id_33,
  c4_.created_by AS created_by_34,
  c4_.updated_by AS updated_by_35,
  c4_.deleted_at AS deleted_at_36,
  c4_.created_at AS created_at_37,
  c4_.updated_at AS updated_at_38,
  c5_.id AS id_39,
  c5_.created_by AS created_by_40,
  c5_.updated_by AS updated_by_41,
  c5_.deleted_at AS deleted_at_42,
  c5_.created_at AS created_at_43,
  c5_.updated_at AS updated_at_44,
  c5_.locale AS locale_45,
  c5_.site_name AS site_name_46,
  c5_.description AS description_47,
  c5_.keywords AS keywords_48,
  c5_.image AS image_49,
  c5_.title AS title_50,
  c5_.slug AS slug_51,
  s0_.meta_id AS meta_id_52,
  s1_.translatable_id AS translatable_id_53,
  s2_.application_id AS application_id_54,
  s3_.translatable_id AS translatable_id_55,
  c5_.translatable_id AS translatable_id_56
FROM
  system_application s0_
  INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id
  LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id
  LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id
  LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id
  LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id
WHERE
  s0_.code = ?
  AND s1_.is_active = 1
  AND s1_.deleted_at IS NULL
LIMIT
  1

SELECT s0_.id AS id_0, s0_.created_by AS created_by_1, s0_.updated_by AS updated_by_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.code AS code_6, s1_.id AS id_7, s1_.created_by AS created_by_8, s1_.updated_by AS updated_by_9, s1_.deleted_at AS deleted_at_10, s1_.created_at AS created_at_11, s1_.updated_at AS updated_at_12, s1_.locale AS locale_13, s1_.title AS title_14, s1_.slug AS slug_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.created_by AS created_by_18, s2_.updated_by AS updated_by_19, s2_.deleted_at AS deleted_at_20, s2_.created_at AS created_at_21, s2_.updated_at AS updated_at_22, s2_.config_key AS config_key_23, s3_.id AS id_24, s3_.created_by AS created_by_25, s3_.updated_by AS updated_by_26, s3_.deleted_at AS deleted_at_27, s3_.created_at AS created_at_28, s3_.updated_at AS updated_at_29, s3_.locale AS locale_30, s3_.value AS value_31, s3_.file AS file_32, c4_.id AS id_33, c4_.created_by AS created_by_34, c4_.updated_by AS updated_by_35, c4_.deleted_at AS deleted_at_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.id AS id_39, c5_.created_by AS created_by_40, c5_.updated_by AS updated_by_41, c5_.deleted_at AS deleted_at_42, c5_.created_at AS created_at_43, c5_.updated_at AS updated_at_44, c5_.locale AS locale_45, c5_.site_name AS site_name_46, c5_.description AS description_47, c5_.keywords AS keywords_48, c5_.image AS image_49, c5_.title AS title_50, c5_.slug AS slug_51, s0_.meta_id AS meta_id_52, s1_.translatable_id AS translatable_id_53, s2_.application_id AS application_id_54, s3_.translatable_id AS translatable_id_55, c5_.translatable_id AS translatable_id_56 FROM system_application s0_ INNER JOIN system_application_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN system_application_config s2_ ON s0_.id = s2_.application_id LEFT JOIN system_application_config_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN common_meta c4_ ON s0_.meta_id = c4_.id LEFT JOIN common_meta_translation c5_ ON c4_.id = c5_.translatable_id WHERE s0_.code = 'default' AND s1_.is_active = 1 AND s1_.deleted_at IS NULL LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Shared\AbstractEntity	No errors.
App\Entity\Shared\AbstractTranslatableEntity	No errors.
App\Entity\System\Page\Page	No errors.
App\Entity\Shared\AbstractTranslationEntity	No errors.
App\Entity\System\Page\PageTranslation	No errors.
App\Entity\Common\Layout\Block	No errors.
App\Entity\Common\Meta\Meta	No errors.
App\Entity\Common\Meta\MetaTranslation	No errors.
App\Entity\Common\Layout\Slider\Slider	No errors.
App\Entity\Common\Layout\BlockTranslation	No errors.
App\Entity\System\Application\Application	No errors.
App\Entity\System\Application\ApplicationTranslation	No errors.
App\Entity\System\Application\Config	No errors.
App\Entity\System\Application\ConfigTranslation	No errors.

Symfony Profiler

GET https://beta.apollomedia.hu/

Configuration Settings

Theme