Symfony Profiler

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.id AS id_1
FROM
  client c0_
  LEFT JOIN container c1_ ON c0_.id = c1_.client_id
  LEFT JOIN language l2_ ON c1_.id = l2_.container_id
WHERE
  c0_.is_show_public = 1
  AND c0_.id = ?
ORDER BY
  c0_.id ASC
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = 59 ORDER BY c0_.id ASC LIMIT 12;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.notes AS notes_2,
  c0_.storage AS storage_3,
  c0_.bucket_key AS bucket_key_4,
  c0_.bucket_secret AS bucket_secret_5,
  c0_.bucket_name AS bucket_name_6,
  c0_.bucket_region AS bucket_region_7,
  c0_.bucket_endpoint AS bucket_endpoint_8,
  c0_.configuration AS configuration_9,
  c0_.domain AS domain_10,
  c0_.is_show_public AS is_show_public_11,
  c0_.is_community_sharing_enable AS is_community_sharing_enable_12,
  c0_.course_commission AS course_commission_13,
  c0_.sync_containers AS sync_containers_14,
  c0_.is_sync_container_changed AS is_sync_container_changed_15,
  c0_.created_at AS created_at_16,
  c0_.updated_at AS updated_at_17,
  c1_.id AS id_18,
  c1_.domain AS domain_19,
  c1_.name AS name_20,
  c1_.container_group AS container_group_21,
  c1_.storage AS storage_22,
  c1_.bucket_key AS bucket_key_23,
  c1_.bucket_secret AS bucket_secret_24,
  c1_.bucket_name AS bucket_name_25,
  c1_.bucket_region AS bucket_region_26,
  c1_.bucket_endpoint AS bucket_endpoint_27,
  c1_.is_active AS is_active_28,
  c1_.configuration AS configuration_29,
  c1_.design_configuration AS design_configuration_30,
  c1_.description AS description_31,
  c1_.image_name AS image_name_32,
  c1_.navigation AS navigation_33,
  c1_.is_live_now AS is_live_now_34,
  c1_.video_gallery_ids AS video_gallery_ids_35,
  c1_.user_static_fields AS user_static_fields_36,
  c1_.logo_image_name AS logo_image_name_37,
  c1_.is_show_public AS is_show_public_38,
  c1_.is_main_container AS is_main_container_39,
  c1_.is_show_public_container AS is_show_public_container_40,
  c1_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_41,
  c1_.old_id AS old_id_42,
  c1_.is_login_container AS is_login_container_43,
  c1_.course_commission AS course_commission_44,
  c1_.created_at AS created_at_45,
  c1_.updated_at AS updated_at_46,
  l2_.id AS id_47,
  l2_.name AS name_48,
  l2_.is_active AS is_active_49,
  l2_.is_default AS is_default_50,
  l2_.locale AS locale_51,
  l2_.created_at AS created_at_52,
  l2_.updated_at AS updated_at_53,
  c1_.client_id AS client_id_54,
  c1_.container_category_id AS container_category_id_55,
  l2_.container_id AS container_id_56
FROM
  client c0_
  LEFT JOIN container c1_ ON c0_.id = c1_.client_id
  LEFT JOIN language l2_ ON c1_.id = l2_.container_id
WHERE
  c0_.is_show_public = 1
  AND c0_.id = ?
  AND c0_.id IN (?)
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.notes AS notes_2, c0_.storage AS storage_3, c0_.bucket_key AS bucket_key_4, c0_.bucket_secret AS bucket_secret_5, c0_.bucket_name AS bucket_name_6, c0_.bucket_region AS bucket_region_7, c0_.bucket_endpoint AS bucket_endpoint_8, c0_.configuration AS configuration_9, c0_.domain AS domain_10, c0_.is_show_public AS is_show_public_11, c0_.is_community_sharing_enable AS is_community_sharing_enable_12, c0_.course_commission AS course_commission_13, c0_.sync_containers AS sync_containers_14, c0_.is_sync_container_changed AS is_sync_container_changed_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, c1_.id AS id_18, c1_.domain AS domain_19, c1_.name AS name_20, c1_.container_group AS container_group_21, c1_.storage AS storage_22, c1_.bucket_key AS bucket_key_23, c1_.bucket_secret AS bucket_secret_24, c1_.bucket_name AS bucket_name_25, c1_.bucket_region AS bucket_region_26, c1_.bucket_endpoint AS bucket_endpoint_27, c1_.is_active AS is_active_28, c1_.configuration AS configuration_29, c1_.design_configuration AS design_configuration_30, c1_.description AS description_31, c1_.image_name AS image_name_32, c1_.navigation AS navigation_33, c1_.is_live_now AS is_live_now_34, c1_.video_gallery_ids AS video_gallery_ids_35, c1_.user_static_fields AS user_static_fields_36, c1_.logo_image_name AS logo_image_name_37, c1_.is_show_public AS is_show_public_38, c1_.is_main_container AS is_main_container_39, c1_.is_show_public_container AS is_show_public_container_40, c1_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_41, c1_.old_id AS old_id_42, c1_.is_login_container AS is_login_container_43, c1_.course_commission AS course_commission_44, c1_.created_at AS created_at_45, c1_.updated_at AS updated_at_46, l2_.id AS id_47, l2_.name AS name_48, l2_.is_active AS is_active_49, l2_.is_default AS is_default_50, l2_.locale AS locale_51, l2_.created_at AS created_at_52, l2_.updated_at AS updated_at_53, c1_.client_id AS client_id_54, c1_.container_category_id AS container_category_id_55, l2_.container_id AS container_id_56 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = 59 AND c0_.id IN (59) ORDER BY c0_.id ASC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  client c0_
  LEFT JOIN container c1_ ON c0_.id = c1_.client_id
  LEFT JOIN language l2_ ON c1_.id = l2_.container_id
WHERE
  c0_.is_show_public = 1
  AND c0_.id = ?

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = 59;