Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.flag_key AS flag_key_2,
  t0.enabled AS enabled_3
FROM
  feature_flag t0
WHERE
  t0.flag_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.flag_key AS flag_key_2, t0.enabled AS enabled_3 FROM feature_flag t0 WHERE t0.flag_key = 'auth_logs_enabled' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.splash_screen AS splash_screen_3
FROM
  brand t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.splash_screen AS splash_screen_3 FROM brand t0 WHERE t0.code = 'A';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.country_aware AS country_aware_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.brand_id AS brand_id_7
FROM
  channel t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.country_aware AS country_aware_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.brand_id AS brand_id_7 FROM channel t0 WHERE t0.slug = 'a-digital-retail' LIMIT 1;

SELECT
  count(*) AS sclr_0
FROM
  video v0_
WHERE
  v0_.brand_id = ?
  AND v0_.channel_id = ?

SELECT count(*) AS sclr_0 FROM video v0_ WHERE v0_.brand_id = 'A' AND v0_.channel_id = 1;

SELECT
  v0_.id AS id_0,
  v0_.uuid AS uuid_1,
  v0_.title AS title_2,
  v0_.description AS description_3,
  v0_.language AS language_4,
  v0_.created_at AS created_at_5,
  v0_.updated_at AS updated_at_6,
  v0_.product_key AS product_key_7,
  v0_.duration AS duration_8,
  v0_.vehicle_parts AS vehicle_parts_9,
  v0_.tags AS tags_10,
  v0_.additional_tags AS additional_tags_11,
  v0_.height AS height_12,
  v0_.width AS width_13,
  v0_.image_formats AS image_formats_14,
  v0_.source_formats AS source_formats_15,
  v0_.pr_numbers AS pr_numbers_16,
  v0_.kvps AS kvps_17,
  v0_.usage_from AS usage_from_18,
  v0_.usage_to AS usage_to_19,
  v0_.resolution AS resolution_20,
  v0_.video_type AS video_type_21,
  v0_.video_content AS video_content_22,
  v0_.video_language AS video_language_23,
  v0_.region AS region_24,
  v0_.stereoscopic AS stereoscopic_25,
  v0_.asset_path AS asset_path_26,
  v0_.fileinfo_file_source AS fileinfo_file_source_27,
  v0_.fileinfo_file_size AS fileinfo_file_size_28,
  v0_.fileinfo_file_extension AS fileinfo_file_extension_29,
  v0_.fileinfo_file_name AS fileinfo_file_name_30,
  v0_.channel_id AS channel_id_31,
  v0_.brand_id AS brand_id_32
FROM
  video v0_
WHERE
  v0_.brand_id = ?
  AND v0_.channel_id = ?
ORDER BY
  v0_.id ASC
LIMIT
  30

SELECT v0_.id AS id_0, v0_.uuid AS uuid_1, v0_.title AS title_2, v0_.description AS description_3, v0_.language AS language_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.product_key AS product_key_7, v0_.duration AS duration_8, v0_.vehicle_parts AS vehicle_parts_9, v0_.tags AS tags_10, v0_.additional_tags AS additional_tags_11, v0_.height AS height_12, v0_.width AS width_13, v0_.image_formats AS image_formats_14, v0_.source_formats AS source_formats_15, v0_.pr_numbers AS pr_numbers_16, v0_.kvps AS kvps_17, v0_.usage_from AS usage_from_18, v0_.usage_to AS usage_to_19, v0_.resolution AS resolution_20, v0_.video_type AS video_type_21, v0_.video_content AS video_content_22, v0_.video_language AS video_language_23, v0_.region AS region_24, v0_.stereoscopic AS stereoscopic_25, v0_.asset_path AS asset_path_26, v0_.fileinfo_file_source AS fileinfo_file_source_27, v0_.fileinfo_file_size AS fileinfo_file_size_28, v0_.fileinfo_file_extension AS fileinfo_file_extension_29, v0_.fileinfo_file_name AS fileinfo_file_name_30, v0_.channel_id AS channel_id_31, v0_.brand_id AS brand_id_32 FROM video v0_ WHERE v0_.brand_id = 'A' AND v0_.channel_id = 1 ORDER BY v0_.id ASC LIMIT 30;

SELECT
  t0.iso3 AS iso3_1,
  t0.iso2 AS iso2_2,
  t0.name AS name_3,
  t0.capital AS capital_4,
  t0.currency AS currency_5,
  t0.phone AS phone_6,
  t0.sanctioned AS sanctioned_7
FROM
  country t0
  INNER JOIN video_country ON t0.iso3 = video_country.country_iso3
WHERE
  video_country.video_id = ?

SELECT t0.iso3 AS iso3_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.capital AS capital_4, t0.currency AS currency_5, t0.phone AS phone_6, t0.sanctioned AS sanctioned_7 FROM country t0 INNER JOIN video_country ON t0.iso3 = video_country.country_iso3 WHERE video_country.video_id = 1;

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.country_restrictions AS country_restrictions_5,
  t0.brand_id AS brand_id_6
FROM
  module_type t0
  INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code
WHERE
  video_module_type.video_id = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.slug AS slug_3, t0.category AS category_4, t0.country_restrictions AS country_restrictions_5, t0.brand_id AS brand_id_6 FROM module_type t0 INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code WHERE video_module_type.video_id = 1;

SELECT
  t0.id AS id_1,
  t0.model AS model_2,
  t0.type AS type_3,
  t0.production_year AS production_year_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  car_specification t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.model AS model_2, t0.type AS type_3, t0.production_year AS production_year_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM car_specification t0 WHERE t0.video_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.expiration AS expiration_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  licence t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.expiration AS expiration_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM licence t0 WHERE t0.video_id = 1;

SELECT
  t0.iso3 AS iso3_1,
  t0.iso2 AS iso2_2,
  t0.name AS name_3,
  t0.capital AS capital_4,
  t0.currency AS currency_5,
  t0.phone AS phone_6,
  t0.sanctioned AS sanctioned_7
FROM
  country t0
  INNER JOIN video_country ON t0.iso3 = video_country.country_iso3
WHERE
  video_country.video_id = ?

SELECT t0.iso3 AS iso3_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.capital AS capital_4, t0.currency AS currency_5, t0.phone AS phone_6, t0.sanctioned AS sanctioned_7 FROM country t0 INNER JOIN video_country ON t0.iso3 = video_country.country_iso3 WHERE video_country.video_id = 2;

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.country_restrictions AS country_restrictions_5,
  t0.brand_id AS brand_id_6
FROM
  module_type t0
  INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code
WHERE
  video_module_type.video_id = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.slug AS slug_3, t0.category AS category_4, t0.country_restrictions AS country_restrictions_5, t0.brand_id AS brand_id_6 FROM module_type t0 INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code WHERE video_module_type.video_id = 2;

SELECT
  t0.id AS id_1,
  t0.model AS model_2,
  t0.type AS type_3,
  t0.production_year AS production_year_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  car_specification t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.model AS model_2, t0.type AS type_3, t0.production_year AS production_year_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM car_specification t0 WHERE t0.video_id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.expiration AS expiration_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  licence t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.expiration AS expiration_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM licence t0 WHERE t0.video_id = 2;

SELECT
  t0.iso3 AS iso3_1,
  t0.iso2 AS iso2_2,
  t0.name AS name_3,
  t0.capital AS capital_4,
  t0.currency AS currency_5,
  t0.phone AS phone_6,
  t0.sanctioned AS sanctioned_7
FROM
  country t0
  INNER JOIN video_country ON t0.iso3 = video_country.country_iso3
WHERE
  video_country.video_id = ?

SELECT t0.iso3 AS iso3_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.capital AS capital_4, t0.currency AS currency_5, t0.phone AS phone_6, t0.sanctioned AS sanctioned_7 FROM country t0 INNER JOIN video_country ON t0.iso3 = video_country.country_iso3 WHERE video_country.video_id = 3;

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.country_restrictions AS country_restrictions_5,
  t0.brand_id AS brand_id_6
FROM
  module_type t0
  INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code
WHERE
  video_module_type.video_id = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.slug AS slug_3, t0.category AS category_4, t0.country_restrictions AS country_restrictions_5, t0.brand_id AS brand_id_6 FROM module_type t0 INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code WHERE video_module_type.video_id = 3;

SELECT
  t0.id AS id_1,
  t0.model AS model_2,
  t0.type AS type_3,
  t0.production_year AS production_year_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  car_specification t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.model AS model_2, t0.type AS type_3, t0.production_year AS production_year_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM car_specification t0 WHERE t0.video_id = 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.expiration AS expiration_4,
  t0.audio_id AS audio_id_5,
  t0.document_id AS document_id_6,
  t0.image_id AS image_id_7,
  t0.video_id AS video_id_8
FROM
  licence t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.expiration AS expiration_4, t0.audio_id AS audio_id_5, t0.document_id AS document_id_6, t0.image_id AS image_id_7, t0.video_id AS video_id_8 FROM licence t0 WHERE t0.video_id = 3;

SELECT
  t0.iso3 AS iso3_1,
  t0.iso2 AS iso2_2,
  t0.name AS name_3,
  t0.capital AS capital_4,
  t0.currency AS currency_5,
  t0.phone AS phone_6,
  t0.sanctioned AS sanctioned_7
FROM
  country t0
  INNER JOIN video_country ON t0.iso3 = video_country.country_iso3
WHERE
  video_country.video_id = ?

SELECT t0.iso3 AS iso3_1, t0.iso2 AS iso2_2, t0.name AS name_3, t0.capital AS capital_4, t0.currency AS currency_5, t0.phone AS phone_6, t0.sanctioned AS sanctioned_7 FROM country t0 INNER JOIN video_country ON t0.iso3 = video_country.country_iso3 WHERE video_country.video_id = 4;

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.country_restrictions AS country_restrictions_5,
  t0.brand_id AS brand_id_6
FROM
  module_type t0
  INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code
WHERE
  video_module_type.video_id = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.slug AS slug_3, t0.category AS category_4, t0.country_restrictions AS country_restrictions_5, t0.brand_id AS brand_id_6 FROM module_type t0 INNER JOIN video_module_type ON t0.code = video_module_type.module_type_code WHERE video_module_type.video_id = 4;