GET https://symfonybrothers.com/ponuda/lasersko-uklanjanje-celulita/395

Query Metrics

12 Database Queries
8 Different statements
6.57 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 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:
[
  "lasersko-uklanjanje-celulita"
  "395"
]
2 2.07 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:
[
  102388
]
3 0.70 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:
[
  395
]
4 0.65 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.25 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:
[
  395
]
6 0.18 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.45 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:
[
  395
]
8 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company AS company_3, t0.pin AS pin_4, t0.country AS country_5, t0.zipcode AS zipcode_6, t0.place AS place_7, t0.house_number AS house_number_8, t0.gm_longitude AS gm_longitude_9, t0.gm_latitude AS gm_latitude_10, t0.notices AS notices_11, t0.contact_number AS contact_number_12, t0.contact_email AS contact_email_13, t0.website AS website_14, t0.bank_name AS bank_name_15, t0.iban AS iban_16, t0.logo AS logo_17, t0.gzoom AS gzoom_18, t0.city_id AS city_id_19, t0.brand_id AS brand_id_20 FROM partner t0 WHERE t0.id = ?
Parameters:
[
  65
]
9 0.23 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"
]
10 0.32 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"
]
11 0.35 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"
]
12 0.23 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.