Query Metrics

11 Database Queries
7 Different statements
4.00 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# 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.