Query Metrics

3 Database Queries
3 Different statements
161.80 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
85.05 ms
(52.56%)
1
SELECT count(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? ORDER BY p0_.popularity DESC, p0_.name ASC
Parameters:
[
  1
  0
]
76.04 ms
(46.99%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.postac AS postac_2, p0_.dawka AS dawka_3, p0_.wielkosc AS wielkosc_4, p0_.jednostka_wielkosci AS jednostka_wielkosci_5, p0_.pojemnosc AS pojemnosc_6, p0_.jednostka_pojemnosci AS jednostka_pojemnosci_7, count(p0_.id) AS sclr_8, p0_.slug AS slug_9 FROM product p0_ INNER JOIN product_text p1_ ON (p1_.slug = p0_.slug) INNER JOIN product_text_translation p2_ ON p1_.id = p2_.translatable_id AND (p2_.locale = ?) WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? AND (p0_.text_id IS NOT NULL OR p2_.excerpt IS NOT NULL) GROUP BY p0_.name ORDER BY p0_.name ASC
Parameters:
[
  "pl"
  1
  0
]
0.72 ms
(0.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = ?
Parameters:
[
  "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.

Entities Mapping

Class Mapping errors
App\Entity\Site No errors.
App\Entity\File No errors.
App\Entity\Service
  • The association App\Entity\Service#banners refers to the owning side field App\Entity\Banner#service which does not exist.
App\Entity\PriceRate No errors.
App\Entity\Discount No errors.
App\Entity\Chat No errors.
App\Entity\Opinion No errors.
App\Entity\Embeddable\RegLegal No errors.
App\Entity\User No errors.
App\Entity\Product No errors.
App\Entity\ProductText No errors.
App\Entity\Translation\ProductTextTranslation No errors.