GET https://symfonybrothers.com/ponuda/posno-slano-pecivo/368

Query Metrics

11 Database Queries
7 Different statements
4.41 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.contract_number AS contract_number_4, t0.title_tag AS title_tag_5, t0.keywords AS keywords_6, t0.meta_description AS meta_description_7, t0.newsletter_title AS newsletter_title_8, t0.newsletter_description AS newsletter_description_9, t0.available_from AS available_from_10, t0.available_to AS available_to_11, t0.usable_until AS usable_until_12, t0.reset_countdown_days AS reset_countdown_days_13, t0.public_coupon_display AS public_coupon_display_14, t0.gender AS gender_15, t0.expire_date_visible AS expire_date_visible_16, t0.require_check_availability AS require_check_availability_17, t0.description AS description_18, t0.text AS text_19, t0.image AS image_20, t0.active AS active_21, t0.super_price AS super_price_22, t0.exclusive AS exclusive_23, t0.kupime_id AS kupime_id_24, t0.sub_title AS sub_title_25, t0.full_price AS full_price_26, t0.discounted_price AS discounted_price_27, t0.discount_percentage AS discount_percentage_28, t0.saving_price AS saving_price_29, t0.offer_includes AS offer_includes_30, t0.offer_usage AS offer_usage_31, t0.offer_note AS offer_note_32, t0.offer_location AS offer_location_33, t0.ad_guid AS ad_guid_34, t0.user_id AS user_id_35, t0.company_id AS company_id_36, t0.single_partner_id AS single_partner_id_37 FROM offer t0 WHERE t0.url = ? AND t0.id = ? LIMIT 1
Parameters:
[
  "posno-slano-pecivo"
  "368"
]
2 0.80 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.created AS created_3, t0.old_filename AS old_filename_4, t0.kupime_id AS kupime_id_5, t0.offer_id AS offer_id_6 FROM offer_image t0 WHERE t0.kupime_id = ? ORDER BY t0.id ASC LIMIT 20
Parameters:
[
  102360
]
3 0.41 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.sequence AS sequence_3, t0.title AS title_4, t0.full_price AS full_price_5, t0.price_before_discount AS price_before_discount_6, t0.discount AS discount_7, t0.our_fee AS our_fee_8, t0.vat AS vat_9, t0.quantity AS quantity_10, t0.max_coupons_per_user AS max_coupons_per_user_11, t0.sold AS sold_12, t0.active AS active_13, t0.saving AS saving_14, t0.offer_id AS offer_id_15 FROM offer_price t0 WHERE t0.offer_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  368
]
4 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[
  1
  1
]
5 0.30 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.sequence AS sequence_3, t0.title AS title_4, t0.full_price AS full_price_5, t0.price_before_discount AS price_before_discount_6, t0.discount AS discount_7, t0.our_fee AS our_fee_8, t0.vat AS vat_9, t0.quantity AS quantity_10, t0.max_coupons_per_user AS max_coupons_per_user_11, t0.sold AS sold_12, t0.active AS active_13, t0.saving AS saving_14, t0.offer_id AS offer_id_15 FROM offer_price t0 WHERE t0.offer_id = ?
Parameters:
[
  368
]
6 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.pin AS pin_4, t0.phone AS phone_5, t0.email AS email_6, t0.created AS created_7, t0.iban AS iban_8, t0.payment_model AS payment_model_9 FROM company t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.21 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.created AS created_3, t0.old_filename AS old_filename_4, t0.kupime_id AS kupime_id_5, t0.offer_id AS offer_id_6 FROM offer_image t0 WHERE t0.offer_id = ?
Parameters:
[
  368
]
8 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[
  1
  "4"
]
9 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[
  1
  "1"
]
10 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[
  1
  "2"
]
11 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.is_active AS is_active_6, t0.type AS type_7 FROM page t0 WHERE t0.is_active = ? AND t0.type = ? ORDER BY t0.id ASC
Parameters:
[
  1
  "3"
]

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.