Symfony Profiler

SELECT
  count(q0_.id) AS sclr_0
FROM
  `query_cache` q0_
WHERE
  q0_.token = ?

SELECT count(q0_.id) AS sclr_0 FROM `query_cache` q0_ WHERE q0_.token = '5c47b3ff408bdee5b4655072e1cbccc2';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.search_criteria AS search_criteria_3,
  t0.result AS result_4,
  t0.ttl AS ttl_5
FROM
  `query_cache` t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.search_criteria AS search_criteria_3, t0.result AS result_4, t0.ttl AS ttl_5 FROM `query_cache` t0 WHERE t0.token = '5c47b3ff408bdee5b4655072e1cbccc2' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.value AS value_1,
  l0_.tariff_id AS tariff_id_2,
  l0_.partner_id AS partner_id_3
FROM
  `loyality_bonus_tariffs` l0_
WHERE
  l0_.tariff_id = ?
  AND l0_.partner_id = ?

SELECT l0_.id AS id_0, l0_.value AS value_1, l0_.tariff_id AS tariff_id_2, l0_.partner_id AS partner_id_3 FROM `loyality_bonus_tariffs` l0_ WHERE l0_.tariff_id = 40 AND l0_.partner_id = 1;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.zip AS zip_3,
  t0.city AS city_4,
  t0.website AS website_5,
  t0.email AS email_6,
  t0.hotline AS hotline_7,
  t0.provider_comment AS provider_comment_8,
  t0.availability_check AS availability_check_9,
  t0.allow_different_account_holder AS allow_different_account_holder_10,
  t0.show_important_info AS show_important_info_11,
  t0.important_info_text AS important_info_text_12,
  t0.must_have_mobile_number AS must_have_mobile_number_13,
  t0.min_days_to_activate AS min_days_to_activate_14,
  t0.max_days_to_activate AS max_days_to_activate_15,
  t0.number_portability AS number_portability_16,
  t0.provider_logo AS provider_logo_17,
  t0.documents_terms AS documents_terms_18,
  t0.documents_cancellation_text AS documents_cancellation_text_19,
  t0.rating AS rating_20,
  t0.`rating_count` AS rating_count_21,
  t0.name_public AS name_public_22,
  t0.name_internal AS name_internal_23,
  t24.id AS id_25,
  t24.api_provider1 AS api_provider1_26,
  t24.api_provider2 AS api_provider2_27,
  t24.api_provider3 AS api_provider3_28,
  t24.api_provider4 AS api_provider4_29,
  t24.api_provider5 AS api_provider5_30,
  t24.provider_id AS provider_id_31,
  t32.id AS id_33,
  t32.show_type_of_building AS show_type_of_building_34,
  t32.show_activation_date AS show_activation_date_35,
  t32.show_itemized_phone_bill AS show_itemized_phone_bill_36,
  t32.show_phonebook_entry AS show_phonebook_entry_37,
  t32.show_number_portability AS show_number_portability_38,
  t32.show_portable_number AS show_portable_number_39,
  t32.different_shipping_address AS different_shipping_address_40,
  t32.provider_id AS provider_id_41,
  t42.id AS id_43,
  t42.api_id AS api_id_44,
  t42.provider_id AS provider_id_45
FROM
  `providers` t0
  LEFT JOIN `external_provider_ids` t24 ON t24.provider_id = t0.id
  LEFT JOIN connection_location_details t32 ON t32.provider_id = t0.id
  LEFT JOIN provider_api_assignment t42 ON t42.provider_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.city AS city_4, t0.website AS website_5, t0.email AS email_6, t0.hotline AS hotline_7, t0.provider_comment AS provider_comment_8, t0.availability_check AS availability_check_9, t0.allow_different_account_holder AS allow_different_account_holder_10, t0.show_important_info AS show_important_info_11, t0.important_info_text AS important_info_text_12, t0.must_have_mobile_number AS must_have_mobile_number_13, t0.min_days_to_activate AS min_days_to_activate_14, t0.max_days_to_activate AS max_days_to_activate_15, t0.number_portability AS number_portability_16, t0.provider_logo AS provider_logo_17, t0.documents_terms AS documents_terms_18, t0.documents_cancellation_text AS documents_cancellation_text_19, t0.rating AS rating_20, t0.`rating_count` AS rating_count_21, t0.name_public AS name_public_22, t0.name_internal AS name_internal_23, t24.id AS id_25, t24.api_provider1 AS api_provider1_26, t24.api_provider2 AS api_provider2_27, t24.api_provider3 AS api_provider3_28, t24.api_provider4 AS api_provider4_29, t24.api_provider5 AS api_provider5_30, t24.provider_id AS provider_id_31, t32.id AS id_33, t32.show_type_of_building AS show_type_of_building_34, t32.show_activation_date AS show_activation_date_35, t32.show_itemized_phone_bill AS show_itemized_phone_bill_36, t32.show_phonebook_entry AS show_phonebook_entry_37, t32.show_number_portability AS show_number_portability_38, t32.show_portable_number AS show_portable_number_39, t32.different_shipping_address AS different_shipping_address_40, t32.provider_id AS provider_id_41, t42.id AS id_43, t42.api_id AS api_id_44, t42.provider_id AS provider_id_45 FROM `providers` t0 LEFT JOIN `external_provider_ids` t24 ON t24.provider_id = t0.id LEFT JOIN connection_location_details t32 ON t32.provider_id = t0.id LEFT JOIN provider_api_assignment t42 ON t42.provider_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.tracking_link AS tracking_link_2,
  t0.postview_link AS postview_link_3,
  t0.active AS active_4,
  t0.enable_api_submission AS enable_api_submission_5,
  t0.enable_offer_id AS enable_offer_id_6,
  t0.enable_eecc AS enable_eecc_7,
  t0.partner_id AS partner_id_8,
  t0.provider_id AS provider_id_9
FROM
  `tracking_links` t0
WHERE
  t0.provider_id = ?
  AND t0.active = ?
  AND t0.partner_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tracking_link AS tracking_link_2, t0.postview_link AS postview_link_3, t0.active AS active_4, t0.enable_api_submission AS enable_api_submission_5, t0.enable_offer_id AS enable_offer_id_6, t0.enable_eecc AS enable_eecc_7, t0.partner_id AS partner_id_8, t0.provider_id AS provider_id_9 FROM `tracking_links` t0 WHERE t0.provider_id = 1 AND t0.active = 1 AND t0.partner_id = 1 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.name_public AS name_public_1,
  t0_.name_internal AS name_internal_2,
  t0_.comment AS comment_3,
  t0_.connection_type AS connection_type_4,
  t0_.upload_speed AS upload_speed_5,
  t0_.download_speed AS download_speed_6,
  t0_.min_contract_time AS min_contract_time_7,
  t0_.cancellation_time AS cancellation_time_8,
  t0_.extension_period AS extension_period_9,
  t0_.productsheet AS productsheet_10,
  t0_.vvi_document AS vvi_document_11,
  t0_.speed_throttled AS speed_throttled_12,
  t0_.data_volume AS data_volume_13,
  t0_.connection_cost_initial AS connection_cost_initial_14,
  t0_.connection_cost_changer AS connection_cost_changer_15,
  t0_.shipping_cost AS shipping_cost_16,
  t0_.monthly_cost AS monthly_cost_17,
  t0_.initial_balance AS initial_balance_18,
  t0_.max_free_months AS max_free_months_19,
  t0_.api_tariff_id AS api_tariff_id_20,
  t0_.tv_override AS tv_override_21,
  t0_.banderole_show AS banderole_show_22,
  t0_.banderole_color AS banderole_color_23,
  t0_.banderole_name AS banderole_name_24,
  t0_.availability_check AS availability_check_25,
  t0_.always_visible AS always_visible_26,
  t0_.tripleplay_internet AS tripleplay_internet_27,
  t0_.tripleplay_telephone AS tripleplay_telephone_28,
  t0_.tripleplay_tv AS tripleplay_tv_29,
  t0_.max_age AS max_age_30,
  t0_.rating AS rating_31,
  t0_.rating_count AS rating_count_32,
  t0_.download_normal AS download_normal_33,
  t0_.download_min AS download_min_34,
  t0_.upload_normal AS upload_normal_35,
  t0_.upload_min AS upload_min_36,
  t0_.api_tariff_id2 AS api_tariff_id2_37,
  t0_.eins_und_eins_api_tariff_id AS eins_und_eins_api_tariff_id_38,
  t0_.eins_und_eins_api_config_id AS eins_und_eins_api_config_id_39,
  t0_.cashback_reduction AS cashback_reduction_40,
  t0_.provider_id AS provider_id_41,
  t0_.area_code_block_id AS area_code_block_id_42
FROM
  `tariffs` t0_
WHERE
  t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0_.id AS id_0, t0_.name_public AS name_public_1, t0_.name_internal AS name_internal_2, t0_.comment AS comment_3, t0_.connection_type AS connection_type_4, t0_.upload_speed AS upload_speed_5, t0_.download_speed AS download_speed_6, t0_.min_contract_time AS min_contract_time_7, t0_.cancellation_time AS cancellation_time_8, t0_.extension_period AS extension_period_9, t0_.productsheet AS productsheet_10, t0_.vvi_document AS vvi_document_11, t0_.speed_throttled AS speed_throttled_12, t0_.data_volume AS data_volume_13, t0_.connection_cost_initial AS connection_cost_initial_14, t0_.connection_cost_changer AS connection_cost_changer_15, t0_.shipping_cost AS shipping_cost_16, t0_.monthly_cost AS monthly_cost_17, t0_.initial_balance AS initial_balance_18, t0_.max_free_months AS max_free_months_19, t0_.api_tariff_id AS api_tariff_id_20, t0_.tv_override AS tv_override_21, t0_.banderole_show AS banderole_show_22, t0_.banderole_color AS banderole_color_23, t0_.banderole_name AS banderole_name_24, t0_.availability_check AS availability_check_25, t0_.always_visible AS always_visible_26, t0_.tripleplay_internet AS tripleplay_internet_27, t0_.tripleplay_telephone AS tripleplay_telephone_28, t0_.tripleplay_tv AS tripleplay_tv_29, t0_.max_age AS max_age_30, t0_.rating AS rating_31, t0_.rating_count AS rating_count_32, t0_.download_normal AS download_normal_33, t0_.download_min AS download_min_34, t0_.upload_normal AS upload_normal_35, t0_.upload_min AS upload_min_36, t0_.api_tariff_id2 AS api_tariff_id2_37, t0_.eins_und_eins_api_tariff_id AS eins_und_eins_api_tariff_id_38, t0_.eins_und_eins_api_config_id AS eins_und_eins_api_config_id_39, t0_.cashback_reduction AS cashback_reduction_40, t0_.provider_id AS provider_id_41, t0_.area_code_block_id AS area_code_block_id_42 FROM `tariffs` t0_ WHERE t0_.id IN (40, 327, 18, 39, 82, 230, 186, 201, 74, 17);

DELETE FROM
  `query_cache`
WHERE
  id = ?

DELETE FROM `query_cache` WHERE id = 4546857;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.postal_code AS postal_code_1,
  c0_.city_name AS city_name_2
FROM
  city c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.postal_code AS postal_code_1, c0_.city_name AS city_name_2 FROM city c0_ WHERE c0_.id IN ('1545');

INSERT INTO `query_cache` (
  token, search_criteria, result, ttl
)
VALUES
  (?, ?, ?, ?)

INSERT INTO `query_cache` (token, search_criteria, result, ttl) VALUES ('5c47b3ff408bdee5b4655072e1cbccc2', '[]', '[105,106,108,109,110,114,115,116,117,118,119,228,229,233,255,17,18,23,24,25,26,39,40,186,198,199,201,202,230,231,272,298,337,6,98,101,102,212,213,216,217,220,221,223,252,256,264,279,285,45,46,59,63,324,114,115,116,117,118,119,194,228,229,74,75,82,87,88,327,330,291]', '2026-06-02 10:51:27');

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.number_of_tarifs_per_site AS number_of_tarifs_per_site_2,
  p0_.hotline_number AS hotline_number_3,
  p0_.public_name AS public_name_4,
  p0_.contact_email AS contact_email_5,
  p0_.logo AS logo_6,
  p0_.cashback_redemption_days AS cashback_redemption_days_7
FROM
  `partners` p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.number_of_tarifs_per_site AS number_of_tarifs_per_site_2, p0_.hotline_number AS hotline_number_3, p0_.public_name AS public_name_4, p0_.contact_email AS contact_email_5, p0_.logo AS logo_6, p0_.cashback_redemption_days AS cashback_redemption_days_7 FROM `partners` p0_ WHERE p0_.id IN ('1');

SELECT
  t0_.id AS id_0
FROM
  `tariffs` t0_
WHERE
  t0_.always_visible = ?

SELECT t0_.id AS id_0 FROM `tariffs` t0_ WHERE t0_.always_visible = 1;

SELECT
  t0.id AS id_1,
  t0.postal_code AS postal_code_2,
  t0.city_name AS city_name_3
FROM
  city t0
WHERE
  t0.postal_code = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.postal_code AS postal_code_2, t0.city_name AS city_name_3 FROM city t0 WHERE t0.postal_code = '27239' AND t0.id = 1545 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number_of_tarifs_per_site AS number_of_tarifs_per_site_3,
  t0.hotline_number AS hotline_number_4,
  t0.public_name AS public_name_5,
  t0.contact_email AS contact_email_6,
  t0.logo AS logo_7,
  t0.cashback_redemption_days AS cashback_redemption_days_8
FROM
  `partners` t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_of_tarifs_per_site AS number_of_tarifs_per_site_3, t0.hotline_number AS hotline_number_4, t0.public_name AS public_name_5, t0.contact_email AS contact_email_6, t0.logo AS logo_7, t0.cashback_redemption_days AS cashback_redemption_days_8 FROM `partners` t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.street_name AS street_name_1,
  s0_.city_id AS city_id_2
FROM
  street s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.street_name AS street_name_1, s0_.city_id AS city_id_2 FROM street s0_ WHERE s0_.id IN ('3228440');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.api_id AS api_id_2,
  t0.provider_id AS provider_id_3
FROM
  provider_api_assignment t0

SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.provider_id AS provider_id_3 FROM provider_api_assignment t0;

SELECT
  t0.id AS id_1,
  t0.street_name AS street_name_2,
  t0.city_id AS city_id_3
FROM
  street t0
WHERE
  t0.id = ?
  AND t0.city_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.street_name AS street_name_2, t0.city_id AS city_id_3 FROM street t0 WHERE t0.id = 3228440 AND t0.city_id = 1545 LIMIT 1;