Query Metrics
7
Database Queries
7
Different statements
146.90 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.95 ms (92.54%) |
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 "%Bisoprololi fumaras%" "concor-cor" ]
|
||||||||||||||||||||||||||||
|
7.69 ms (5.24%) |
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 "concor-cor" "concor-cor" "concor-cor" "concor-cor" ]
|
||||||||||||||||||||||||||||
|
1.29 ms (0.88%) |
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:
[
"concor-cor"
]
|
||||||||||||||||||||||||||||
|
0.74 ms (0.50%) |
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.59 ms (0.40%) |
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:
[ 440698 440699 440700 440701 440702 440703 440704 440705 440706 440707 440708 440709 440710 440711 440712 440713 440714 440715 458535 458536 462275 462276 462277 462290 462291 462292 462868 462869 463084 463085 463196 463197 463724 463725 463726 463727 463728 464738 464739 464748 464749 477912 477913 477917 477918 478148 478149 480402 480403 480434 480435 480827 480828 480829 480830 480831 480832 480833 480834 480835 482431 482432 482433 482438 482439 482440 482441 482442 482443 482444 482445 482446 483059 483060 483061 483065 483066 483067 483715 483716 483717 483999 484000 484099 484100 484101 484277 484278 484295 484296 484495 484496 484497 484498 484625 484626 484678 484679 484680 484681 484682 484683 485282 485283 486450 486451 486461 486462 487110 487111 487112 487424 487425 487990 487991 487992 487993 489537 489538 489686 489687 489698 489699 490387 490388 490389 490628 490629 490630 490631 490632 490983 490984 491502 491503 491813 491814 491818 491819 491820 491857 491858 491859 492201 492202 492894 492895 492896 492897 492898 493061 493062 493063 493064 493065 494466 494467 495329 495385 495537 495538 496910 496911 496912 496916 496917 496918 497598 497599 497864 497869 499089 499090 499091 499092 499621 499622 499868 499869 499870 499871 500958 500959 500960 500961 501159 501160 501162 501163 501325 501326 501327 501328 501329 501330 501357 501358 501429 501430 501431 501432 501559 501560 501561 501562 501928 501929 501930 502171 502172 502809 502810 502811 1 ]
|
||||||||||||||||||||||||||||
|
0.36 ms (0.24%) |
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:
[
116
]
|
||||||||||||||||||||||||||||
|
0.29 ms (0.20%) |
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:
[
116
]
|
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. |