Symfony Profiler

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 = ?

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 = 3;

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

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 = 'uzi-organov-bryushnoj-polosti-i-pochek-copy' LIMIT 1;

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 = ?

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 = 3;

"START TRANSACTION"

"START TRANSACTION";

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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 ('УЗИ органов брюшной полости и почек в Москве (Копия)', 'uzi-organov-bryushnoj-polosti-i-pochek-copy', 'УЗИ органов брюшной полости и почек в Москве. Клиника Hormone Life — точная ультразвуковая диагностика, опытные специалисты.', '{
    \"heading\": \"\",
    \"description\": \"\",
    \"features\": [],
    \"hero_image\": \"/analiz/uzi_hero.png\",
    \"what_shows_title\": \"\",
    \"what_shows\": [
        {
            \"icon\": \"/analiz/what_show1.svg\",
            \"title\": \"Пункт 1\",
            \"text\": \"Описание пункта 1.\"
        },
        {
            \"icon\": \"/analiz/what_show2.svg\",
            \"title\": \"Пункт 2\",
            \"text\": \"Описание пункта 2.\"
        }
    ],
    \"go_cabinet\": {
        \"icon\": \"/analiz/go_cabinet_icon.svg\",
        \"title\": \"Услуга оказана?\",
        \"subtitle\": \"Посмотрите результаты в личном кабинете.\",
        \"btn_text\": \"ЛИЧНЫЙ КАБИНЕТ\",
        \"btn_url\": \"https://cabinet.hltestsys.ru\"
    },
    \"doctors\": {
        \"title\": \"Наши специалисты\",
        \"subtitle\": \"Врачи с большим клиническим опытом.\",
        \"list\": [
            {
                \"name\": \"ФИО врача\",
                \"experience\": \"10 лет опыта\",
                \"description\": \"Краткое описание специалиста.\",
                \"photo\": \"/analiz/doctor.png\",
                \"url\": \"/doctors\"
            }
        ],
        \"type\": 1
    },
    \"contact_form\": true,
    \"hero_type\": 1,
    \"important\": {
        \"image\": \"/analiz/important1.png\",
        \"badge\": \"Важно!\",
        \"text\": \"Своевременная диагностика раз в год <strong>позволяет предотвратить 80% хронических заболеваний</strong> органов ЖКТ и мочевыделительной системы.\"
    },
    \"process\": {
        \"type\": 2,
        \"title\": \"Как проходит обследование\",
        \"description\": \"Процедура абсолютно безопасна, безболезненна и не имеет лучевой нагрузки.\",
        \"slides\": [
            {
                \"icon\": \"/analiz/process2_1.svg\",
                \"title\": \"Длительность\",
                \"text\": \"Обследование занимает <strong>20–30 минут.</strong>\",
                \"color\": \"#1C2258\"
            },
            {
                \"icon\": \"/analiz/process2_2.svg\",
                \"color\": \"#1C2258\",
                \"title\": \"Подготовка\",
                \"text\": \"Проводится <strong>строго натощак</strong> (последний прием пищи за 6–8 часов). За 2 дня до УЗИ рекомендуется исключить продукты, вызывающие газообразование (сырые овощи, бобовые, черный хлеб, молоко).\"
            },
            {
                \"icon\": \"/analiz/process3_4.svg\",
                \"color\": \"#1C2258\",
                \"title\": \"Результат\",
                \"text\": \"Вы получаете подробное <strong>заключение с протоколом исследования и снимками</strong> сразу после завершения процедуры. Врач прокомментирует ключевые показатели и подскажет, к какому профильному специалисту обратиться далее.\"
            }
        ]
    },
    \"title\": \"УЗИ органов брюшной полости и почек в Москве\",
    \"meta_description\": \"УЗИ органов брюшной полости и почек в Москве. Клиника Hormone Life — точная ультразвуковая диагностика, опытные специалисты.\"
}', '<span class=\"analiz-heading--accent\">Ультразвуковое исследование (УЗИ) органов брюшной полости и почек</span>', 'Безопасная и информативная диагностика внутренних органов без боли, облучения и специальной подготовки. Результат — сразу после процедуры.', '[]', '/analiz/uzi_hero.png', 'Что можно обнаружить', '[{\"icon\":\"\\/analiz\\/uzi_show1.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u041a\\u0430\\u043c\\u043d\\u0438 \\u0438<br>\\u043a\\u043e\\u043d\\u043a\\u0440\\u0435\\u043c\\u0435\\u043d\\u0442\\u044b\",\"text\":\"\\u0412\\u044b\\u044f\\u0432\\u043b\\u0435\\u043d\\u0438\\u0435 \\u043a\\u0430\\u043c\\u043d\\u0435\\u0439 \\u0432 \\u043f\\u043e\\u0447\\u043a\\u0430\\u0445, \\u0436\\u0435\\u043b\\u0447\\u043d\\u043e\\u043c \\u043f\\u0443\\u0437\\u044b\\u0440\\u0435 \\u0438 \\u043f\\u0440\\u043e\\u0442\\u043e\\u043a\\u0430\\u0445 \\u043d\\u0430 \\u0440\\u0430\\u043d\\u043d\\u0438\\u0445 \\u0441\\u0442\\u0430\\u0434\\u0438\\u044f\\u0445.\"},{\"icon\":\"\\/analiz\\/uzi_show2.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u0412\\u043e\\u0441\\u043f\\u0430\\u043b\\u0438\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0435 \\u0438\\u0437\\u043c\\u0435\\u043d\\u0435\\u043d\\u0438\\u044f\",\"text\":\"\\u0414\\u0438\\u0430\\u0433\\u043d\\u043e\\u0441\\u0442\\u0438\\u043a\\u0430 \\u0432\\u043e\\u0441\\u043f\\u0430\\u043b\\u0438\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0445 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0441\\u0441\\u043e\\u0432 \\u0432 \\u043f\\u0435\\u0447\\u0435\\u043d\\u0438, \\u043f\\u043e\\u0434\\u0436\\u0435\\u043b\\u0443\\u0434\\u043e\\u0447\\u043d\\u043e\\u0439 \\u0436\\u0435\\u043b\\u0435\\u0437\\u0435, \\u043f\\u043e\\u0447\\u043a\\u0430\\u0445 \\u0438 \\u0434\\u0440\\u0443\\u0433\\u0438\\u0445 \\u043e\\u0440\\u0433\\u0430\\u043d\\u0430\\u0445.\"},{\"icon\":\"\\/analiz\\/uzi_show3.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u041d\\u043e\\u0432\\u043e\\u043e\\u0431\\u0440\\u0430\\u0437\\u043e\\u0432\\u0430\\u043d\\u0438\\u044f\",\"text\":\"\\u041e\\u0431\\u043d\\u0430\\u0440\\u0443\\u0436\\u0435\\u043d\\u0438\\u0435 \\u043a\\u0438\\u0441\\u0442, \\u043f\\u043e\\u043b\\u0438\\u043f\\u043e\\u0432, \\u043e\\u043f\\u0443\\u0445\\u043e\\u043b\\u0435\\u0439 \\u0438 \\u0434\\u0440\\u0443\\u0433\\u0438\\u0445 \\u043e\\u0431\\u044a\\u0435\\u043c\\u043d\\u044b\\u0445 \\u043e\\u0431\\u0440\\u0430\\u0437\\u043e\\u0432\\u0430\\u043d\\u0438\\u0439 \\u043d\\u0430 \\u0440\\u0430\\u043d\\u043d\\u0438\\u0445 \\u0441\\u0442\\u0430\\u0434\\u0438\\u044f\\u0445.\"},{\"icon\":\"\\/analiz\\/uzi_show4.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u0410\\u043d\\u043e\\u043c\\u0430\\u043b\\u0438\\u0438<br>\\u0440\\u0430\\u0437\\u0432\\u0438\\u0442\\u0438\\u044f\",\"text\":\"\\u0412\\u044b\\u044f\\u0432\\u043b\\u0435\\u043d\\u0438\\u0435 \\u0432\\u0440\\u043e\\u0436\\u0434\\u0435\\u043d\\u043d\\u044b\\u0445 \\u0438 \\u043f\\u0440\\u0438\\u043e\\u0431\\u0440\\u0435\\u0442\\u0435\\u043d\\u043d\\u044b\\u0445 \\u0441\\u0442\\u0440\\u0443\\u043a\\u0442\\u0443\\u0440\\u043d\\u044b\\u0445 \\u0438\\u0437\\u043c\\u0435\\u043d\\u0435\\u043d\\u0438\\u0439 \\u0432\\u043d\\u0443\\u0442\\u0440\\u0435\\u043d\\u043d\\u0438\\u0445 \\u043e\\u0440\\u0433\\u0430\\u043d\\u043e\\u0432.\"}]', 'Как проходит обследование', 'Процедура абсолютно безопасна, безболезненна и не имеет лучевой нагрузки.', '[]', '[{\"icon\":\"\\/analiz\\/process2_1.svg\",\"color\":\"#1C2258\",\"title\":\"\\u0414\\u043b\\u0438\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0441\\u0442\\u044c\",\"text\":\"\\u041e\\u0431\\u0441\\u043b\\u0435\\u0434\\u043e\\u0432\\u0430\\u043d\\u0438\\u0435 \\u0437\\u0430\\u043d\\u0438\\u043c\\u0430\\u0435\\u0442 <strong>20\\u201330 \\u043c\\u0438\\u043d\\u0443\\u0442.<\\/strong>\"},{\"icon\":\"\\/analiz\\/process2_2.svg\",\"color\":\"#1C2258\",\"title\":\"\\u041f\\u043e\\u0434\\u0433\\u043e\\u0442\\u043e\\u0432\\u043a\\u0430\",\"text\":\"\\u041f\\u0440\\u043e\\u0432\\u043e\\u0434\\u0438\\u0442\\u0441\\u044f <strong>\\u0441\\u0442\\u0440\\u043e\\u0433\\u043e \\u043d\\u0430\\u0442\\u043e\\u0449\\u0430\\u043a<\\/strong> (\\u043f\\u043e\\u0441\\u043b\\u0435\\u0434\\u043d\\u0438\\u0439 \\u043f\\u0440\\u0438\\u0435\\u043c \\u043f\\u0438\\u0449\\u0438 \\u0437\\u0430 6\\u20138 \\u0447\\u0430\\u0441\\u043e\\u0432). \\u0417\\u0430 2 \\u0434\\u043d\\u044f \\u0434\\u043e \\u0423\\u0417\\u0418 \\u0440\\u0435\\u043a\\u043e\\u043c\\u0435\\u043d\\u0434\\u0443\\u0435\\u0442\\u0441\\u044f \\u0438\\u0441\\u043a\\u043b\\u044e\\u0447\\u0438\\u0442\\u044c \\u043f\\u0440\\u043e\\u0434\\u0443\\u043a\\u0442\\u044b, \\u0432\\u044b\\u0437\\u044b\\u0432\\u0430\\u044e\\u0449\\u0438\\u0435 \\u0433\\u0430\\u0437\\u043e\\u043e\\u0431\\u0440\\u0430\\u0437\\u043e\\u0432\\u0430\\u043d\\u0438\\u0435 (\\u0441\\u044b\\u0440\\u044b\\u0435 \\u043e\\u0432\\u043e\\u0449\\u0438, \\u0431\\u043e\\u0431\\u043e\\u0432\\u044b\\u0435, \\u0447\\u0435\\u0440\\u043d\\u044b\\u0439 \\u0445\\u043b\\u0435\\u0431, \\u043c\\u043e\\u043b\\u043e\\u043a\\u043e).\"},{\"icon\":\"\\/analiz\\/process3_4.svg\",\"color\":\"#1C2258\",\"title\":\"\\u0420\\u0435\\u0437\\u0443\\u043b\\u044c\\u0442\\u0430\\u0442\",\"text\":\"\\u0412\\u044b \\u043f\\u043e\\u043b\\u0443\\u0447\\u0430\\u0435\\u0442\\u0435 \\u043f\\u043e\\u0434\\u0440\\u043e\\u0431\\u043d\\u043e\\u0435 <strong>\\u0437\\u0430\\u043a\\u043b\\u044e\\u0447\\u0435\\u043d\\u0438\\u0435 \\u0441 \\u043f\\u0440\\u043e\\u0442\\u043e\\u043a\\u043e\\u043b\\u043e\\u043c \\u0438\\u0441\\u0441\\u043b\\u0435\\u0434\\u043e\\u0432\\u0430\\u043d\\u0438\\u044f \\u0438 \\u0441\\u043d\\u0438\\u043c\\u043a\\u0430\\u043c\\u0438<\\/strong> \\u0441\\u0440\\u0430\\u0437\\u0443 \\u043f\\u043e\\u0441\\u043b\\u0435 \\u0437\\u0430\\u0432\\u0435\\u0440\\u0448\\u0435\\u043d\\u0438\\u044f \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b. \\u0412\\u0440\\u0430\\u0447 \\u043f\\u0440\\u043e\\u043a\\u043e\\u043c\\u043c\\u0435\\u043d\\u0442\\u0438\\u0440\\u0443\\u0435\\u0442 \\u043a\\u043b\\u044e\\u0447\\u0435\\u0432\\u044b\\u0435 \\u043f\\u043e\\u043a\\u0430\\u0437\\u0430\\u0442\\u0435\\u043b\\u0438 \\u0438 \\u043f\\u043e\\u0434\\u0441\\u043a\\u0430\\u0436\\u0435\\u0442, \\u043a \\u043a\\u0430\\u043a\\u043e\\u043c\\u0443 \\u043f\\u0440\\u043e\\u0444\\u0438\\u043b\\u044c\\u043d\\u043e\\u043c\\u0443 \\u0441\\u043f\\u0435\\u0446\\u0438\\u0430\\u043b\\u0438\\u0441\\u0442\\u0443 \\u043e\\u0431\\u0440\\u0430\\u0442\\u0438\\u0442\\u044c\\u0441\\u044f \\u0434\\u0430\\u043b\\u0435\\u0435.\"}]', '/analiz/manager.png', '/services/service3.png', NULL, 'По запросу', '[\"\\u0411\\u0435\\u0437\\u043e\\u043f\\u0430\\u0441\\u043d\\u043e\\u0435 \\u043e\\u0431\\u0441\\u043b\\u0435\\u0434\\u043e\\u0432\\u0430\\u043d\\u0438\\u0435 \\u0431\\u0435\\u0437 \\u043b\\u0443\\u0447\\u0435\\u0432\\u043e\\u0439 \\u043d\\u0430\\u0433\\u0440\\u0443\\u0437\\u043a\\u0438\",\"\\u0422\\u043e\\u0447\\u043d\\u044b\\u0439 \\u0440\\u0435\\u0437\\u0443\\u043b\\u044c\\u0442\\u0430\\u0442 \\u0441\\u0440\\u0430\\u0437\\u0443 \\u043f\\u043e\\u0441\\u043b\\u0435 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b\",\"\\u0420\\u0435\\u043a\\u043e\\u043c\\u0435\\u043d\\u0434\\u0430\\u0446\\u0438\\u0438 \\u043f\\u0440\\u043e\\u0444\\u0438\\u043b\\u044c\\u043d\\u043e\\u0433\\u043e \\u0441\\u043f\\u0435\\u0446\\u0438\\u0430\\u043b\\u0438\\u0441\\u0442\\u0430\"]', 1, 30, 4);

INSERT INTO service_page_doctor (service_page_id, doctor_id)
VALUES
  (?, ?)

INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (1766, 21);

INSERT INTO service_page_doctor (service_page_id, doctor_id)
VALUES
  (?, ?)

INSERT INTO service_page_doctor (service_page_id, doctor_id) VALUES (1766, 22);

"COMMIT"

"COMMIT";