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

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 = 'lazernaya-korrekciya-stressovogo-nederzhaniya-mochi-copy-copy' 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 = ?
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 = 'lazernaya-korrekciya-stressovogo-nederzhaniya-mochi-copy-copy-2' 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 = 1767;

"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 ('Лазерная коррекция стрессового недержания мочи (Копия)', 'lazernaya-korrekciya-stressovogo-nederzhaniya-mochi-copy-copy-2', 'Лазерная коррекция стрессового недержания мочи в клинике Hormone Life в Москве. Современные методики, опытные специалисты.', '{
    \"heading\": \"\",
    \"description\": \"\",
    \"features\": [],
    \"hero_image\": null,
    \"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\": 2
    },
    \"contact_form\": true,
    \"hero_type\": 2,
    \"hero_bg\": \"/analiz/hero_bg_image2.jpg\",
    \"feature\": \"технология / оборудование\",
    \"feature_lines\": [
        {
            \"icon\": \"/analiz/go_cabinet_icon.svg\",
            \"text\": \"технология / оборудование\"
        }
    ],
    \"process\": {
        \"type\": 2,
        \"title\": \"Как проходит исследование\",
        \"description\": \"Мы позаботились о том, чтобы лечение было максимально комфортным и не нарушало привычный ритм жизни.\",
        \"slides\": [
            {
                \"icon\": \"/analiz/process2_1.svg\",
                \"title\": \"Длительность\",
                \"text\": \"Текст о длительности процедуры.\"
            }
        ]
    },
    \"title\": \"Лазерная коррекция стрессового недержания мочи\",
    \"meta_description\": \"Лазерная коррекция стрессового недержания мочи в клинике Hormone Life в Москве. Современные методики, опытные специалисты.\"
}', '<span class=\"analiz-heading--accent\">Лазерная коррекция</span> стрессового недержания мочи', 'Восстановление тонуса тканей и возвращение физиологического контроля над мочеиспусканием без операций, швов и долгой реабилитации.', '[]', NULL, 'Результаты процедуры', '[{\"icon\":\"\",\"color\":\"#FFFFFF\",\"number\":\"01\",\"title\":\"\\u041f\\u043e\\u043b\\u043d\\u043e\\u0435 \\u0443\\u0441\\u0442\\u0440\\u0430\\u043d\\u0435\\u043d\\u0438\\u0435 \\u0441\\u0438\\u043c\\u043f\\u0442\\u043e\\u043c\\u043e\\u0432\",\"text\":\"\\u0418\\u0441\\u0447\\u0435\\u0437\\u043d\\u043e\\u0432\\u0435\\u043d\\u0438\\u0435 \\u043f\\u043e\\u0434\\u0442\\u0435\\u043a\\u0430\\u043d\\u0438\\u044f \\u043c\\u043e\\u0447\\u0438 \\u043f\\u0440\\u0438 \\u043a\\u0430\\u0448\\u043b\\u0435, \\u0441\\u043c\\u0435\\u0445\\u0435, \\u0447\\u0438\\u0445\\u0430\\u043d\\u0438\\u0438 \\u0438\\u043b\\u0438 \\u0437\\u0430\\u043d\\u044f\\u0442\\u0438\\u044f\\u0445 \\u0441\\u043f\\u043e\\u0440\\u0442\\u043e\\u043c.\"},{\"icon\":\"\",\"color\":\"#FFFFFF\",\"number\":\"02\",\"title\":\"\\u0423\\u043a\\u0440\\u0435\\u043f\\u043b\\u0435\\u043d\\u0438\\u0435 \\u0442\\u043a\\u0430\\u043d\\u0435\\u0439\",\"text\":\"\\u041b\\u0430\\u0437\\u0435\\u0440 \\u0441\\u0442\\u0438\\u043c\\u0443\\u043b\\u0438\\u0440\\u0443\\u0435\\u0442 \\u0432\\u044b\\u0440\\u0430\\u0431\\u043e\\u0442\\u043a\\u0443 \\u043a\\u043e\\u043b\\u043b\\u0430\\u0433\\u0435\\u043d\\u0430 \\u0438 \\u0432\\u043e\\u0437\\u0432\\u0440\\u0430\\u0449\\u0430\\u0435\\u0442 \\u0443\\u043f\\u0440\\u0443\\u0433\\u043e\\u0441\\u0442\\u044c \\u0442\\u043a\\u0430\\u043d\\u0435\\u0439.\"},{\"icon\":\"\",\"color\":\"#FFFFFF\",\"number\":\"03\",\"title\":\"\\u0423\\u043b\\u0443\\u0447\\u0448\\u0435\\u043d\\u0438\\u0435 \\u043a\\u0430\\u0447\\u0435\\u0441\\u0442\\u0432\\u0430 \\u0436\\u0438\\u0437\\u043d\\u0438\",\"text\":\"\\u0421\\u0432\\u043e\\u0431\\u043e\\u0434\\u0430 \\u043e\\u0442 \\u043f\\u043e\\u0441\\u0442\\u043e\\u044f\\u043d\\u043d\\u043e\\u0433\\u043e \\u0438\\u0441\\u043f\\u043e\\u043b\\u044c\\u0437\\u043e\\u0432\\u0430\\u043d\\u0438\\u044f \\u0433\\u0438\\u0433\\u0438\\u0435\\u043d\\u0438\\u0447\\u0435\\u0441\\u043a\\u0438\\u0445 \\u0441\\u0440\\u0435\\u0434\\u0441\\u0442\\u0432.\"},{\"icon\":\"\",\"color\":\"#FFFFFF\",\"number\":\"04\",\"title\":\"\\u042d\\u0441\\u0442\\u0435\\u0442\\u0438\\u0447\\u0435\\u0441\\u043a\\u043e\\u0435 \\u043e\\u043c\\u043e\\u043b\\u043e\\u0436\\u0435\\u043d\\u0438\\u0435\",\"text\":\"\\u0423\\u043b\\u0443\\u0447\\u0448\\u0435\\u043d\\u0438\\u0435 \\u043c\\u0438\\u043a\\u0440\\u043e\\u0446\\u0438\\u0440\\u043a\\u0443\\u043b\\u044f\\u0446\\u0438\\u0438 \\u0438 \\u0442\\u043e\\u043d\\u0443\\u0441\\u0430 \\u0441\\u043b\\u0438\\u0437\\u0438\\u0441\\u0442\\u043e\\u0439.\"}]', 'Как проходит исследование', 'Мы позаботились о том, чтобы лечение было максимально комфортным и не нарушало ваш привычный ритм жизни.', '[]', '[{\"icon\":\"\\/analiz\\/process2_1.svg\",\"color\":\"#1C2258\",\"title\":\"\\u0414\\u043b\\u0438\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0441\\u0442\\u044c\",\"text\":\"\\u0421\\u0430\\u043c\\u0430 \\u043c\\u0430\\u043d\\u0438\\u043f\\u0443\\u043b\\u044f\\u0446\\u0438\\u044f \\u0437\\u0430\\u043d\\u0438\\u043c\\u0430\\u0435\\u0442 <strong>\\u043e\\u0442 15 \\u0434\\u043e 30 \\u043c\\u0438\\u043d\\u0443\\u0442<\\/strong>.<br> \\u0412\\u044b \\u043c\\u043e\\u0436\\u0435\\u0442\\u0435 \\u043f\\u0440\\u0438\\u0435\\u0445\\u0430\\u0442\\u044c \\u0432 \\u043a\\u043b\\u0438\\u043d\\u0438\\u043a\\u0443 \\u0434\\u0430\\u0436\\u0435<br> \\u0432 \\u043e\\u0431\\u0435\\u0434\\u0435\\u043d\\u043d\\u044b\\u0439 \\u043f\\u0435\\u0440\\u0435\\u0440\\u044b\\u0432.\"},{\"icon\":\"\\/analiz\\/process2_2.svg\",\"color\":\"#1C2258\",\"title\":\"\\u041e\\u0449\\u0443\\u0449\\u0435\\u043d\\u0438\\u044f\",\"text\":\"\\u041f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u0430 \\u043f\\u0440\\u0430\\u043a\\u0442\\u0438\\u0447\\u0435\\u0441\\u043a\\u0438 \\u0431\\u0435\\u0437\\u0431\\u043e\\u043b\\u0435\\u0437\\u043d\\u0435\\u043d\\u043d\\u0430. \\u041f\\u0430\\u0446\\u0438\\u0435\\u043d\\u0442\\u043a\\u0438 \\u043e\\u043f\\u0438\\u0441\\u044b\\u0432\\u0430\\u044e\\u0442 \\u043e\\u0449\\u0443\\u0449\\u0435\\u043d\\u0438\\u044f \\u043a\\u0430\\u043a \\u00ab\\u043b\\u0435\\u0433\\u043a\\u043e\\u0435 \\u0442\\u0435\\u043f\\u043b\\u043e\\u00bb \\u0438\\u043b\\u0438 \\u00ab\\u043d\\u0435\\u0437\\u043d\\u0430\\u0447\\u0438\\u0442\\u0435\\u043b\\u044c\\u043d\\u0443\\u044e \\u0432\\u0438\\u0431\\u0440\\u0430\\u0446\\u0438\\u044e\\u00bb. \\u0410\\u043d\\u0435\\u0441\\u0442\\u0435\\u0437\\u0438\\u044f \\u043d\\u0435 \\u0442\\u0440\\u0435\\u0431\\u0443\\u0435\\u0442\\u0441\\u044f.\"},{\"icon\":\"\\/analiz\\/process2_3.svg\",\"color\":\"#1C2258\",\"title\":\"\\u041a\\u0443\\u0440\\u0441\",\"text\":\"\\u0414\\u043b\\u044f \\u0434\\u043e\\u0441\\u0442\\u0438\\u0436\\u0435\\u043d\\u0438\\u044f \\u0441\\u0442\\u043e\\u0439\\u043a\\u043e\\u0433\\u043e \\u0440\\u0435\\u0437\\u0443\\u043b\\u044c\\u0442\\u0430\\u0442\\u0430 \\u043e\\u0431\\u044b\\u0447\\u043d\\u043e \\u0442\\u0440\\u0435\\u0431\\u0443\\u0435\\u0442\\u0441\\u044f <strong>\\u043e\\u0442 2 \\u0434\\u043e 4 \\u0441\\u0435\\u0430\\u043d\\u0441\\u043e\\u0432<\\/strong> \\u0441 \\u0438\\u043d\\u0442\\u0435\\u0440\\u0432\\u0430\\u043b\\u043e\\u043c \\u0432 \\u043e\\u0434\\u0438\\u043d \\u043c\\u0435\\u0441\\u044f\\u0446. \\u042d\\u0444\\u0444\\u0435\\u043a\\u0442 \\u0437\\u0430\\u043c\\u0435\\u0442\\u0435\\u043d \\u0443\\u0436\\u0435 \\u043f\\u043e\\u0441\\u043b\\u0435 \\u043f\\u0435\\u0440\\u0432\\u043e\\u0439 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b.\"},{\"icon\":\"\\/analiz\\/process2_4.svg\",\"color\":\"#1C2258\",\"title\":\"\\u0420\\u0435\\u0430\\u0431\\u0438\\u043b\\u0438\\u0442\\u0430\\u0446\\u0438\\u044f\",\"text\":\"\\u0414\\u043b\\u044f \\u0434\\u043e\\u0441\\u0442\\u0438\\u0436\\u0435\\u043d\\u0438\\u044f \\u0441\\u0442\\u043e\\u0439\\u043a\\u043e\\u0433\\u043e \\u0440\\u0435\\u0437\\u0443\\u043b\\u044c\\u0442\\u0430\\u0442\\u0430 \\u043e\\u0431\\u044b\\u0447\\u043d\\u043e \\u0442\\u0440\\u0435\\u0431\\u0443\\u0435\\u0442\\u0441\\u044f <strong>\\u043e\\u0442 2 \\u0434\\u043e 4 \\u0441\\u0435\\u0430\\u043d\\u0441\\u043e\\u0432<\\/strong> \\u0441 \\u0438\\u043d\\u0442\\u0435\\u0440\\u0432\\u0430\\u043b\\u043e\\u043c \\u0432 \\u043e\\u0434\\u0438\\u043d \\u043c\\u0435\\u0441\\u044f\\u0446. \\u042d\\u0444\\u0444\\u0435\\u043a\\u0442 \\u0437\\u0430\\u043c\\u0435\\u0442\\u0435\\u043d \\u0443\\u0436\\u0435 \\u043f\\u043e\\u0441\\u043b\\u0435 \\u043f\\u0435\\u0440\\u0432\\u043e\\u0439 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b.\"}]', '/analiz/manager.png', '/services/service2.png', NULL, 'По запросу', '[\"\\u0411\\u0435\\u0437\\u043e\\u043f\\u0435\\u0440\\u0430\\u0446\\u0438\\u043e\\u043d\\u043d\\u043e\\u0435 \\u043b\\u0435\\u0447\\u0435\\u043d\\u0438\\u0435 \\u0441\\u0442\\u0440\\u0435\\u0441\\u0441\\u043e\\u0432\\u043e\\u0433\\u043e \\u043d\\u0435\\u0434\\u0435\\u0440\\u0436\\u0430\\u043d\\u0438\\u044f\",\"\\u041a\\u043e\\u043c\\u0444\\u043e\\u0440\\u0442\\u043d\\u0430\\u044f \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u0430 15-30 \\u043c\\u0438\\u043d\\u0443\\u0442\",\"\\u041c\\u0438\\u043d\\u0438\\u043c\\u0430\\u043b\\u044c\\u043d\\u044b\\u0439 \\u043f\\u0435\\u0440\\u0438\\u043e\\u0434 \\u0432\\u043e\\u0441\\u0441\\u0442\\u0430\\u043d\\u043e\\u0432\\u043b\\u0435\\u043d\\u0438\\u044f\"]', 1, 20, 3);

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

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

"COMMIT"

"COMMIT";