Query Metrics
3
Database Queries
3
Different statements
161.80 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
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. |