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

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 = 'chekap-podgotovka-k-beremennosti-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 = 4;

"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 ('Чекап Подготовка к беременности (Копия)', 'chekap-podgotovka-k-beremennosti-copy', 'Чекап подготовка к беременности в Москве. Клиника Hormone Life — комплексная программа обследования для планирования материнства.', '{
    \"title\": \"Чекап Подготовка к беременности\",
    \"hero_type\": 1,
    \"heading\": \"<span class=\\\"analiz-heading--accent\\\">Чекап</span> Подготовка<br>к беременности\",
    \"description\": \"Программа разработана для женщин, которые планируют материнство и хотят подойти к этому этапу осознанно.\",
    \"features\": [
        \"Экономия времени и ресурсов\",
        \"Снижение тревожности\",
        \"Персонализированный подход\"
    ],
    \"hero_image\": \"/analiz/pregnant.png\",
    \"program\": {
        \"title\": \"Что входит в программу\",
        \"description\": \"Мы собрали все необходимые исследования в один пакет, чтобы вы не тратили время на лишние визиты.\",
        \"cards\": [
            {
                \"icon\": \"/analiz/program_lab.svg\",
                \"title\": \"Лабораторная диагностика\",
                \"items\": [
                    \"Клинический и биохимический анализы крови.\",
                    \"Оценка гормонального профиля (ТТГ, пролактин, ФСГ и др.).\",
                    \"Проверка на TORCH-инфекции и скрытые инфекции (ИППП).\",
                    \"Определение уровня ферритина, витамина D и фолиевой кислоты.\"
                ]
            },
            {
                \"icon\": \"/analiz/program_instr.svg\",
                \"title\": \"Инструментальная диагностика\",
                \"items\": [
                    \"УЗИ органов малого таза (мониторинг овуляции и состояния эндометрия).\",
                    \"УЗИ молочных желез.\"
                ]
            },
            {
                \"icon\": \"/analiz/program_consult.svg\",
                \"title\": \"Консультации экспертов\",
                \"items\": [
                    \"Прием гинеколога-репродуктолога (первичный и повторный по результатам).\",
                    \"Консультация терапевта для оценки общего состояния здоровья.\"
                ]
            }
        ]
    },
    \"what_shows_title\": \"Что вы получите в итоге\",
    \"what_shows\": [
        {
            \"icon\": \"/analiz/checkup_show1.svg\",
            \"color\": \"#000000\",
            \"number\": \"\",
            \"title\": \"Детальный<br>«паспорт здоровья»\",
            \"text\": \"Полная картина работы вашей репродуктивной и эндокринной систем.\"
        },
        {
            \"icon\": \"/analiz/checkup_show2.svg\",
            \"color\": \"#000000\",
            \"number\": \"\",
            \"title\": \"Коррекция<br>дефицитов\",
            \"text\": \"Индивидуальный план приема витаминов и нутрицевтиков для правильного развития плода.\"
        },
        {
            \"icon\": \"/analiz/checkup_show3.svg\",
            \"color\": \"#000000\",
            \"number\": \"\",
            \"title\": \"Снижение<br>рисков\",
            \"text\": \"Выявление и устранение факторов, которые могут осложнить течение беременности.\"
        },
        {
            \"icon\": \"/analiz/checkup_show4.svg\",
            \"color\": \"#000000\",
            \"number\": \"\",
            \"title\": \"План<br>действий\",
            \"text\": \"Пошаговая стратегия подготовки и рекомендации по образу жизни от команды врачей.\"
        }
    ],
    \"go_cabinet\": {
        \"icon\": \"/analiz/go_cabinet_icon.svg\",
        \"title\": \"Услуга оказана?\",
        \"subtitle\": \"Посмотрите результаты в личном кабинете.\",
        \"btn_text\": \"ЛИЧНЫЙ КАБИНЕТ\",
        \"btn_url\": \"https://cabinet.hltestsys.ru\"
    },
    \"doctors\": {
        \"title\": \"Команда вашего чекапа\",
        \"subtitle\": \"В нашей клинике врачи работают в тесной связке. Это значит, что специалисты обмениваются данными, чтобы составить для вас максимально точную рекомендацию.\",
        \"list\": [
            {
                \"name\": \"Греков Евгений Александрович\",
                \"experience\": \"16 лет опыта\",
                \"description\": \"Российский врач-уролог, андролог, эндокринолог, основатель и главный врач Клиники Hormone Life\",
                \"photo\": \"/analiz/doctor.png\",
                \"url\": \"/grekov-evgenij-aleksandrovich\"
            },
            {
                \"name\": \"Греков Евгений Александрович\",
                \"experience\": \"16 лет опыта\",
                \"description\": \"Российский врач-уролог, андролог, эндокринолог, основатель и главный врач Клиники Hormone Life\",
                \"photo\": \"/analiz/doctor.png\",
                \"url\": \"/grekov-evgenij-aleksandrovich\"
            },
            {
                \"name\": \"Греков Евгений Александрович\",
                \"experience\": \"16 лет опыта\",
                \"description\": \"Российский врач-уролог, андролог, эндокринолог, основатель и главный врач Клиники Hormone Life\",
                \"photo\": \"/analiz/doctor.png\",
                \"url\": \"/grekov-evgenij-aleksandrovich\"
            },
            {
                \"name\": \"Греков Евгений Александрович\",
                \"experience\": \"16 лет опыта\",
                \"description\": \"Российский врач-уролог, андролог, эндокринолог, основатель и главный врач Клиники Hormone Life\",
                \"photo\": \"/analiz/doctor.png\",
                \"url\": \"/grekov-evgenij-aleksandrovich\"
            }
        ]
    },
    \"contact_form\": true,
    \"contact_form_image\": \"/analiz/manager.png\",
    \"meta_description\": \"Чекап подготовка к беременности в Москве. Клиника Hormone Life — комплексная программа обследования для планирования материнства.\"
}', '<span class=\"analiz-heading--accent\">Чекап</span> Подготовка<br>к беременности', 'Программа разработана для женщин, которые планируют материнство и хотят подойти к этому этапу осознанно.', '[{\"icon\":\"\",\"text\":\"\\u042d\\u043a\\u043e\\u043d\\u043e\\u043c\\u0438\\u044f \\u0432\\u0440\\u0435\\u043c\\u0435\\u043d\\u0438 \\u0438 \\u0440\\u0435\\u0441\\u0443\\u0440\\u0441\\u043e\\u0432\",\"color\":\"#AD272B\"},{\"icon\":\"\",\"text\":\"\\u0421\\u043d\\u0438\\u0436\\u0435\\u043d\\u0438\\u0435 \\u0442\\u0440\\u0435\\u0432\\u043e\\u0436\\u043d\\u043e\\u0441\\u0442\\u0438\",\"color\":\"#AD272B\"},{\"icon\":\"\",\"text\":\"\\u041f\\u0435\\u0440\\u0441\\u043e\\u043d\\u0430\\u043b\\u0438\\u0437\\u0438\\u0440\\u043e\\u0432\\u0430\\u043d\\u043d\\u044b\\u0439 \\u043f\\u043e\\u0434\\u0445\\u043e\\u0434\",\"color\":\"#AD272B\"}]', '/analiz/pregnant.png', 'Что вы получите в итоге', '[{\"icon\":\"\\/analiz\\/checkup_show1.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u0414\\u0435\\u0442\\u0430\\u043b\\u044c\\u043d\\u044b\\u0439<br>\\u00ab\\u043f\\u0430\\u0441\\u043f\\u043e\\u0440\\u0442 \\u0437\\u0434\\u043e\\u0440\\u043e\\u0432\\u044c\\u044f\\u00bb\",\"text\":\"\\u041f\\u043e\\u043b\\u043d\\u0430\\u044f \\u043a\\u0430\\u0440\\u0442\\u0438\\u043d\\u0430 \\u0440\\u0430\\u0431\\u043e\\u0442\\u044b \\u0432\\u0430\\u0448\\u0435\\u0439 \\u0440\\u0435\\u043f\\u0440\\u043e\\u0434\\u0443\\u043a\\u0442\\u0438\\u0432\\u043d\\u043e\\u0439 \\u0438 \\u044d\\u043d\\u0434\\u043e\\u043a\\u0440\\u0438\\u043d\\u043d\\u043e\\u0439 \\u0441\\u0438\\u0441\\u0442\\u0435\\u043c.\"},{\"icon\":\"\\/analiz\\/checkup_show2.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u041a\\u043e\\u0440\\u0440\\u0435\\u043a\\u0446\\u0438\\u044f<br>\\u0434\\u0435\\u0444\\u0438\\u0446\\u0438\\u0442\\u043e\\u0432\",\"text\":\"\\u0418\\u043d\\u0434\\u0438\\u0432\\u0438\\u0434\\u0443\\u0430\\u043b\\u044c\\u043d\\u044b\\u0439 \\u043f\\u043b\\u0430\\u043d \\u043f\\u0440\\u0438\\u0435\\u043c\\u0430 \\u0432\\u0438\\u0442\\u0430\\u043c\\u0438\\u043d\\u043e\\u0432 \\u0438 \\u043d\\u0443\\u0442\\u0440\\u0438\\u0446\\u0435\\u0432\\u0442\\u0438\\u043a\\u043e\\u0432 \\u0434\\u043b\\u044f \\u043f\\u0440\\u0430\\u0432\\u0438\\u043b\\u044c\\u043d\\u043e\\u0433\\u043e \\u0440\\u0430\\u0437\\u0432\\u0438\\u0442\\u0438\\u044f \\u043f\\u043b\\u043e\\u0434\\u0430.\"},{\"icon\":\"\\/analiz\\/checkup_show3.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u0421\\u043d\\u0438\\u0436\\u0435\\u043d\\u0438\\u0435<br>\\u0440\\u0438\\u0441\\u043a\\u043e\\u0432\",\"text\":\"\\u0412\\u044b\\u044f\\u0432\\u043b\\u0435\\u043d\\u0438\\u0435 \\u0438 \\u0443\\u0441\\u0442\\u0440\\u0430\\u043d\\u0435\\u043d\\u0438\\u0435 \\u0444\\u0430\\u043a\\u0442\\u043e\\u0440\\u043e\\u0432, \\u043a\\u043e\\u0442\\u043e\\u0440\\u044b\\u0435 \\u043c\\u043e\\u0433\\u0443\\u0442 \\u043e\\u0441\\u043b\\u043e\\u0436\\u043d\\u0438\\u0442\\u044c \\u0442\\u0435\\u0447\\u0435\\u043d\\u0438\\u0435 \\u0431\\u0435\\u0440\\u0435\\u043c\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u0438.\"},{\"icon\":\"\\/analiz\\/checkup_show4.svg\",\"color\":\"#000000\",\"number\":\"\",\"title\":\"\\u041f\\u043b\\u0430\\u043d<br>\\u0434\\u0435\\u0439\\u0441\\u0442\\u0432\\u0438\\u0439\",\"text\":\"\\u041f\\u043e\\u0448\\u0430\\u0433\\u043e\\u0432\\u0430\\u044f \\u0441\\u0442\\u0440\\u0430\\u0442\\u0435\\u0433\\u0438\\u044f \\u043f\\u043e\\u0434\\u0433\\u043e\\u0442\\u043e\\u0432\\u043a\\u0438 \\u0438 \\u0440\\u0435\\u043a\\u043e\\u043c\\u0435\\u043d\\u0434\\u0430\\u0446\\u0438\\u0438 \\u043f\\u043e \\u043e\\u0431\\u0440\\u0430\\u0437\\u0443 \\u0436\\u0438\\u0437\\u043d\\u0438 \\u043e\\u0442 \\u043a\\u043e\\u043c\\u0430\\u043d\\u0434\\u044b \\u0432\\u0440\\u0430\\u0447\\u0435\\u0439.\"}]', NULL, NULL, '[]', '[]', '/analiz/manager.png', '/services/service4.png', NULL, 'По запросу', '[\"\\u041a\\u043e\\u043c\\u043f\\u043b\\u0435\\u043a\\u0441 \\u043b\\u0430\\u0431\\u043e\\u0440\\u0430\\u0442\\u043e\\u0440\\u043d\\u044b\\u0445 \\u0438 \\u0438\\u043d\\u0441\\u0442\\u0440\\u0443\\u043c\\u0435\\u043d\\u0442\\u0430\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0438\\u0441\\u0441\\u043b\\u0435\\u0434\\u043e\\u0432\\u0430\\u043d\\u0438\\u0439\",\"\\u041a\\u043e\\u043d\\u0441\\u0443\\u043b\\u044c\\u0442\\u0430\\u0446\\u0438\\u0438 \\u043f\\u0440\\u043e\\u0444\\u0438\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0432\\u0440\\u0430\\u0447\\u0435\\u0439\",\"\\u041f\\u0435\\u0440\\u0441\\u043e\\u043d\\u0430\\u043b\\u044c\\u043d\\u044b\\u0439 \\u043f\\u043b\\u0430\\u043d \\u043f\\u043e\\u0434\\u0433\\u043e\\u0442\\u043e\\u0432\\u043a\\u0438 \\u043a \\u0431\\u0435\\u0440\\u0435\\u043c\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u0438\"]', 1, 40, 8);

"COMMIT"

"COMMIT";