Query Metrics
11
Database Queries
7
Different statements
4.00 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.40 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.id = ?
Parameters:
[
1131
]
|
||||||||||||||||||||||||||||||
| 2 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ferritin-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-2-copy-copy-copy-copy"
]
|
||||||||||||||||||||||||||||||
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id WHERE service_page_doctor.service_page_id = ?
Parameters:
[
1131
]
|
||||||||||||||||||||||||||||||
| 4 | 0.13 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 0.52 ms |
INSERT INTO service_page (title, slug, meta_description, content_json, page_heading, short_description, hero_feature_lines, hero_image, what_shows_title, what_shows_cards, process_title, process_description, process_steps, process_slides, contact_form_image, catalog_image, checkup_preview_image, catalog_price, catalog_features, is_published, sort_order, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Анализ на Ферритин в Москве (Копия)" "ferritin-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-copy-2-copy-copy-copy-copy" "Анализ на ферритин в Москве. Точная диагностика и консультация специалиста." """ {\n "heading": "",\n "description": "",\n "features": [],\n "hero_image": "",\n "what_shows_title": "",\n "what_shows": [],\n "go_cabinet": [],\n "doctors": {\n "title": "Врачи, которые работают с результатами",\n "subtitle": "Более 10 лет опыта за плечами каждого врача клиники",\n "list": [],\n "type": 1\n },\n "contact_form": true,\n "hero_type": 1,\n "process": {\n "type": 1,\n "title": "",\n "description": "",\n "steps": []\n },\n "title": "Анализ на Ферритин в Москве",\n "meta_description": "Анализ на ферритин в Москве. Точная диагностика и консультация специалиста."\n } """ "Анализ <span class="analiz-heading--accent">на ферритин</span><br>в Москве" "Сдайте анализ на ферритин в клинике и узнайте уровень запасов железа и причины скрытого дефицита железа в организме." "[{"icon":"icon-check","text":"\u0414\u0438\u0430\u0433\u043d\u043e\u0441\u0442\u0438\u043a\u0430 \u0434\u0435\u0444\u0438\u0446\u0438\u0442\u0430","color":"#FFFFFF"},{"icon":"icon-check","text":"\u041e\u0446\u0435\u043d\u043a\u0430 \u0437\u0430\u043f\u0430\u0441\u043e\u0432 \u0436\u0435\u043b\u0435\u0437\u0430","color":"#FFFFFF"},{"icon":"icon-check","text":"\u041a\u043e\u043d\u0442\u0440\u043e\u043b\u044c \u0441\u0430\u043c\u043e\u0447\u0443\u0432\u0441\u0442\u0432\u0438\u044f","color":"#FFFFFF"}]" "/uploads/services/hero/pexels-tima-miroshnichenko-5452292-1-photoroom-hero-1773222628.png" "Что показывает анализ" "[{"icon":"icon-arm","color":"#FFFFFF","number":"","title":"\u0417\u0430\u043f\u0430\u0441\u044b \u0436\u0435\u043b\u0435\u0437\u0430","text":"\u0424\u0435\u0440\u0440\u0438\u0442\u0438\u043d \u043e\u0442\u0440\u0430\u0436\u0430\u0435\u0442 \u0443\u0440\u043e\u0432\u0435\u043d\u044c \u0437\u0430\u043f\u0430\u0441\u043e\u0432 \u0436\u0435\u043b\u0435\u0437\u0430 \u0432 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043c\u0435 \u0438 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u0445\u0432\u0430\u0442\u0430\u0435\u0442 \u043b\u0438 \u0435\u0433\u043e \u0434\u043b\u044f \u043d\u043e\u0440\u043c\u0430\u043b\u044c\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u044b \u043a\u043b\u0435\u0442\u043e\u043a."},{"icon":"icon-first_aid_kit","color":"#000000","number":"","title":"\u0421\u043a\u0440\u044b\u0442\u044b\u0439 \u0434\u0435\u0444\u0438\u0446\u0438\u0442 \u0436\u0435\u043b\u0435\u0437\u0430","text":"\u041f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0432\u044b\u044f\u0432\u0438\u0442\u044c \u0434\u0435\u0444\u0438\u0446\u0438\u0442 \u0436\u0435\u043b\u0435\u0437\u0430 \u0435\u0449\u0451 \u0434\u043e \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u044f \u0430\u043d\u0435\u043c\u0438\u0438 \u0438 \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u044f \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u043d\u044b\u0445 \u0441\u0438\u043c\u043f\u0442\u043e\u043c\u043e\u0432."},{"icon":"icon-medical_face_mask_treatment","color":"#000000","number":"","title":"\u041f\u0440\u0438\u0447\u0438\u043d\u044b \u0441\u043b\u0430\u0431\u043e\u0441\u0442\u0438 \u0438 \u0443\u0441\u0442\u0430\u043b\u043e\u0441\u0442\u0438","text":"\u041d\u0438\u0437\u043a\u0438\u0439 \u0444\u0435\u0440\u0440\u0438\u0442\u0438\u043d \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0440\u0438\u0447\u0438\u043d\u043e\u0439 \u0445\u0440\u043e\u043d\u0438\u0447\u0435\u0441\u043a\u043e\u0439 \u0443\u0441\u0442\u0430\u043b\u043e\u0441\u0442\u0438, \u0441\u043d\u0438\u0436\u0435\u043d\u0438\u044f \u044d\u043d\u0435\u0440\u0433\u0438\u0438, \u0432\u044b\u043f\u0430\u0434\u0435\u043d\u0438\u044f \u0432\u043e\u043b\u043e\u0441 \u0438 \u0443\u0445\u0443\u0434\u0448\u0435\u043d\u0438\u044f \u0441\u0430\u043c\u043e\u0447\u0443\u0432\u0441\u0442\u0432\u0438\u044f."},{"icon":"icon-assay","color":"#000000","number":"","title":"\u0420\u0438\u0441\u043a\u0438 \u0430\u043d\u0435\u043c\u0438\u0438","text":"\u0410\u043d\u0430\u043b\u0438\u0437 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0432\u043e\u0432\u0440\u0435\u043c\u044f \u043e\u0431\u043d\u0430\u0440\u0443\u0436\u0438\u0442\u044c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u0432\u0435\u0441\u0442\u0438 \u043a \u0436\u0435\u043b\u0435\u0437\u043e\u0434\u0435\u0444\u0438\u0446\u0438\u0442\u043d\u043e\u0439 \u0430\u043d\u0435\u043c\u0438\u0438 \u0438 \u043d\u0430\u0440\u0443\u0448\u0435\u043d\u0438\u044f\u043c \u0440\u0430\u0431\u043e\u0442\u044b \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043c\u0430."}]" "Как проходит исследование" "Процедура занимает не более 10 минут и состоит из простых шагов." "[{"card_title":"2","theme":"dark","note":"","items":[]}]" "[]" null "/uploads/services/catalog/pexels-pixabay-260352-catalog-1773222628.jpg" "/uploads/services/checkup-preview/pexels-pixabay-260352-checkup-preview-1773222628.jpg" null "["\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430 1 \u0434\u0435\u043d\u044c","\u042d\u043a\u0441\u043f\u0435\u0440\u0442\u043d\u0430\u044f \u0440\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u043a\u0430"]" 1 100 5 ]
|
||||||||||||||||||||||||||||||
| 6 | 0.15 ms |
INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (?, ?)
Parameters:
[ 1138 17 ]
|
||||||||||||||||||||||||||||||
| 7 | 0.14 ms |
INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (?, ?)
Parameters:
[ 1138 18 ]
|
||||||||||||||||||||||||||||||
| 8 | 0.15 ms |
INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (?, ?)
Parameters:
[ 1138 19 ]
|
||||||||||||||||||||||||||||||
| 9 | 0.15 ms |
INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (?, ?)
Parameters:
[ 1138 21 ]
|
||||||||||||||||||||||||||||||
| 10 | 0.11 ms |
INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (?, ?)
Parameters:
[ 1138 22 ]
|
||||||||||||||||||||||||||||||
| 11 | 1.71 ms |
"COMMIT"
Parameters:
[]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Doctor | 5 |
| App\Entity\ServicePage | 2 |
| App\Entity\ServiceCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ServicePage | No errors. |
| App\Entity\ServiceCategory | No errors. |
| App\Entity\Doctor | No errors. |
| App\Entity\DoctorDiploma | No errors. |