Query Metrics
7
Database Queries
7
Different statements
212.45 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.81 ms (92.64%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.bazyl AS bazyl_2, p0_.postac AS postac_3, p0_.dawka AS dawka_4, p0_.active AS active_5, p0_.psychotrop AS psychotrop_6, p0_.prescription_quantity_limit AS prescription_quantity_limit_7, p0_.slug AS slug_8, p0_.ean AS ean_9, p0_.title AS title_10, p0_.description AS description_11, p0_.excerpt AS excerpt_12, p0_.content AS content_13, p0_.substancje_czynne AS substancje_czynne_14, p0_.wielkosc AS wielkosc_15, p0_.jednostka_wielkosci AS jednostka_wielkosci_16, p0_.kod_atc AS kod_atc_17, p0_.kategoria_dostepnosci AS kategoria_dostepnosci_18, p0_.rm_id AS rm_id_19, p0_.hide_in_search AS hide_in_search_20, p0_.popularity AS popularity_21, p0_.addit_info AS addit_info_22, p0_.typ_procedury AS typ_procedury_23, p0_.meta_description AS meta_description_24, p0_.pojemnosc AS pojemnosc_25, p0_.jednostka_pojemnosci AS jednostka_pojemnosci_26, p0_.schema_drug AS schema_drug_27, p0_.only_continued_treatment AS only_continued_treatment_28, p0_.cart_warning AS cart_warning_29, p0_.nurse AS nurse_30, p0_.nurse_so AS nurse_so_31, p0_.created_at AS created_at_32, p0_.updated_at AS updated_at_33, CONCAT(COALESCE(p0_.name, ''), COALESCE(p0_.postac, ''), COALESCE(p0_.dawka, ''), COALESCE(p0_.wielkosc, ''), COALESCE(p0_.jednostka_wielkosci, ''), COALESCE(p0_.pojemnosc, ''), COALESCE(p0_.jednostka_pojemnosci, '')) AS sclr_34, p0_.form_id AS form_id_35, p0_.text_id AS text_id_36 FROM product p0_ WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? AND p0_.substancje_czynne LIKE ? AND p0_.slug <> ? GROUP BY p0_.slug ORDER BY p0_.popularity DESC, p0_.name ASC LIMIT 4
Parameters:
[ 1 0 "%Cefuroximum%" "zinnat" ]
|
||||||||||||||||||||||||||||
|
10.31 ms (4.85%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.bazyl AS bazyl_2, p0_.postac AS postac_3, p0_.dawka AS dawka_4, p0_.active AS active_5, p0_.psychotrop AS psychotrop_6, p0_.prescription_quantity_limit AS prescription_quantity_limit_7, p0_.slug AS slug_8, p0_.ean AS ean_9, p0_.title AS title_10, p0_.description AS description_11, p0_.excerpt AS excerpt_12, p0_.content AS content_13, p0_.substancje_czynne AS substancje_czynne_14, p0_.wielkosc AS wielkosc_15, p0_.jednostka_wielkosci AS jednostka_wielkosci_16, p0_.kod_atc AS kod_atc_17, p0_.kategoria_dostepnosci AS kategoria_dostepnosci_18, p0_.rm_id AS rm_id_19, p0_.hide_in_search AS hide_in_search_20, p0_.popularity AS popularity_21, p0_.addit_info AS addit_info_22, p0_.typ_procedury AS typ_procedury_23, p0_.meta_description AS meta_description_24, p0_.pojemnosc AS pojemnosc_25, p0_.jednostka_pojemnosci AS jednostka_pojemnosci_26, p0_.schema_drug AS schema_drug_27, p0_.only_continued_treatment AS only_continued_treatment_28, p0_.cart_warning AS cart_warning_29, p0_.nurse AS nurse_30, p0_.nurse_so AS nurse_so_31, p0_.created_at AS created_at_32, p0_.updated_at AS updated_at_33, p0_.form_id AS form_id_34, p0_.text_id AS text_id_35 FROM product p0_ WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? AND (p0_.slug = ? OR p0_.slug = ? OR p0_.slug = ? OR p0_.slug = ?) ORDER BY p0_.content DESC, p0_.description DESC, p0_.title DESC LIMIT 1
Parameters:
[ 1 0 "zinnat" "zinnat" "zinnat" "zinnat" ]
|
||||||||||||||||||||||||||||
|
1.43 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bazyl AS bazyl_3, t0.postac AS postac_4, t0.dawka AS dawka_5, t0.active AS active_6, t0.psychotrop AS psychotrop_7, t0.prescription_quantity_limit AS prescription_quantity_limit_8, t0.slug AS slug_9, t0.ean AS ean_10, t0.title AS title_11, t0.description AS description_12, t0.excerpt AS excerpt_13, t0.content AS content_14, t0.substancje_czynne AS substancje_czynne_15, t0.wielkosc AS wielkosc_16, t0.jednostka_wielkosci AS jednostka_wielkosci_17, t0.kod_atc AS kod_atc_18, t0.kategoria_dostepnosci AS kategoria_dostepnosci_19, t0.rm_id AS rm_id_20, t0.hide_in_search AS hide_in_search_21, t0.popularity AS popularity_22, t0.addit_info AS addit_info_23, t0.typ_procedury AS typ_procedury_24, t0.meta_description AS meta_description_25, t0.pojemnosc AS pojemnosc_26, t0.jednostka_pojemnosci AS jednostka_pojemnosci_27, t0.schema_drug AS schema_drug_28, t0.only_continued_treatment AS only_continued_treatment_29, t0.cart_warning AS cart_warning_30, t0.nurse AS nurse_31, t0.nurse_so AS nurse_so_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.form_id AS form_id_35, t0.text_id AS text_id_36 FROM product t0 WHERE t0.slug = ?
Parameters:
[
"zinnat"
]
|
||||||||||||||||||||||||||||
|
1.17 ms (0.55%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_text_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
152
]
|
||||||||||||||||||||||||||||
|
1.08 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.meta_description AS meta_description_7, t0.required_documentation AS required_documentation_8, t0.gender_requirements AS gender_requirements_9 FROM product_text t0 WHERE t0.id = ?
Parameters:
[
152
]
|
||||||||||||||||||||||||||||
|
0.90 ms (0.42%) |
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"
]
|
||||||||||||||||||||||||||||
|
0.75 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.author AS author_2, t0.content AS content_3, t0.accepted AS accepted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM medicines_comment t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.accepted = ?
Parameters:
[ 10231 10234 10235 10236 10237 10238 10239 24424 34139 34140 51166 51169 51170 51171 51172 73655 73656 73657 75048 81118 81119 82453 82454 95838 95839 118969 118970 118971 128533 139402 159493 159494 175692 176564 177502 177550 177551 219621 219622 219623 219624 219625 219626 219627 219628 219629 219630 219631 219632 219633 219634 219635 219636 219637 219638 219639 219640 219641 219642 219643 219644 220671 220672 220673 220674 220675 220676 220677 220678 221196 221197 221198 221199 240348 245105 250055 250056 250057 250058 251570 251571 252548 252549 258320 258321 258322 258475 258476 258477 260272 261476 261477 261478 262759 263358 263859 263860 263861 264296 278581 278582 278747 278835 279452 279453 279454 279932 279933 279934 281719 282506 438417 438418 438419 438420 438421 438422 438423 438424 438425 438426 438427 438428 438429 438430 438431 438432 438433 438434 438435 438436 438437 438438 438439 438440 439450 439451 439452 439453 439454 439455 439456 439457 439966 439967 439968 439969 458280 458281 458441 458527 459133 459134 459135 459588 459589 459590 461269 461270 462027 480249 484649 484650 484651 484652 486174 486175 487095 487096 492819 492820 492821 492975 492976 492977 494889 496278 496279 496280 497784 498684 499625 499626 499627 500783 1 ]
|
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\Form | No errors. |
| App\Entity\ProductText | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\MedicinesComment | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Translation\ProductTextTranslation | No errors. |