Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.nume AS nume_1,
  m0_.prenume AS prenume_2,
  m0_.titlul AS titlul_3,
  m0_.grad_profesional AS grad_profesional_4,
  m0_.stiinte_medicale AS stiinte_medicale_5,
  m0_.competente AS competente_6,
  m0_.cod_parafa AS cod_parafa_7,
  m0_.oras AS oras_8,
  m0_.judet AS judet_9,
  m0_.telefon AS telefon_10,
  m0_.consultatii_pentru AS consultatii_pentru_11,
  m0_.descriere AS descriere_12,
  m0_.slug AS slug_13,
  m0_.fotografie AS fotografie_14,
  m0_.fotografie_size AS fotografie_size_15,
  m0_.created_at AS created_at_16,
  m0_.updated_at AS updated_at_17,
  m0_.cmr AS cmr_18,
  m0_.asigurare_malpraxis AS asigurare_malpraxis_19,
  m0_.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_20,
  m0_.aviz_practica AS aviz_practica_21,
  m0_.aviz_practica_expirare AS aviz_practica_expirare_22,
  m0_.loc_munca AS loc_munca_23,
  m0_.medic_top AS medic_top_24,
  m0_.medic_top_expira AS medic_top_expira_25,
  m0_.prefix_telefon AS prefix_telefon_26,
  m0_.profil_completat AS profil_completat_27,
  m0_.status AS status_28,
  m0_.contract_semnat AS contract_semnat_29,
  m0_.specialitate_id AS specialitate_id_30,
  m0_.utilizator_id AS utilizator_id_31,
  m0_.clinica_id AS clinica_id_32,
  m0_.colaborare_id AS colaborare_id_33
FROM
  medic m0_
WHERE
  m0_.medic_top = 1
  AND m0_.medic_top_expira >= ?
  AND m0_.slug IS NOT NULL
  AND m0_.slug <> ?
  AND m0_.status = ?
ORDER BY
  m0_.medic_top_expira DESC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.nume AS nume_1, m0_.prenume AS prenume_2, m0_.titlul AS titlul_3, m0_.grad_profesional AS grad_profesional_4, m0_.stiinte_medicale AS stiinte_medicale_5, m0_.competente AS competente_6, m0_.cod_parafa AS cod_parafa_7, m0_.oras AS oras_8, m0_.judet AS judet_9, m0_.telefon AS telefon_10, m0_.consultatii_pentru AS consultatii_pentru_11, m0_.descriere AS descriere_12, m0_.slug AS slug_13, m0_.fotografie AS fotografie_14, m0_.fotografie_size AS fotografie_size_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.cmr AS cmr_18, m0_.asigurare_malpraxis AS asigurare_malpraxis_19, m0_.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_20, m0_.aviz_practica AS aviz_practica_21, m0_.aviz_practica_expirare AS aviz_practica_expirare_22, m0_.loc_munca AS loc_munca_23, m0_.medic_top AS medic_top_24, m0_.medic_top_expira AS medic_top_expira_25, m0_.prefix_telefon AS prefix_telefon_26, m0_.profil_completat AS profil_completat_27, m0_.status AS status_28, m0_.contract_semnat AS contract_semnat_29, m0_.specialitate_id AS specialitate_id_30, m0_.utilizator_id AS utilizator_id_31, m0_.clinica_id AS clinica_id_32, m0_.colaborare_id AS colaborare_id_33 FROM medic m0_ WHERE m0_.medic_top = 1 AND m0_.medic_top_expira >= '2026-08-11 06:21:25' AND m0_.slug IS NOT NULL AND m0_.slug <> '' AND m0_.status = 'STATUS_APROBAT' ORDER BY m0_.medic_top_expira DESC LIMIT 10;

SELECT
  m0_.id AS id_0,
  m0_.nume AS nume_1,
  m0_.prenume AS prenume_2,
  m0_.titlul AS titlul_3,
  m0_.grad_profesional AS grad_profesional_4,
  m0_.stiinte_medicale AS stiinte_medicale_5,
  m0_.competente AS competente_6,
  m0_.cod_parafa AS cod_parafa_7,
  m0_.oras AS oras_8,
  m0_.judet AS judet_9,
  m0_.telefon AS telefon_10,
  m0_.consultatii_pentru AS consultatii_pentru_11,
  m0_.descriere AS descriere_12,
  m0_.slug AS slug_13,
  m0_.fotografie AS fotografie_14,
  m0_.fotografie_size AS fotografie_size_15,
  m0_.created_at AS created_at_16,
  m0_.updated_at AS updated_at_17,
  m0_.cmr AS cmr_18,
  m0_.asigurare_malpraxis AS asigurare_malpraxis_19,
  m0_.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_20,
  m0_.aviz_practica AS aviz_practica_21,
  m0_.aviz_practica_expirare AS aviz_practica_expirare_22,
  m0_.loc_munca AS loc_munca_23,
  m0_.medic_top AS medic_top_24,
  m0_.medic_top_expira AS medic_top_expira_25,
  m0_.prefix_telefon AS prefix_telefon_26,
  m0_.profil_completat AS profil_completat_27,
  m0_.status AS status_28,
  m0_.contract_semnat AS contract_semnat_29,
  m0_.specialitate_id AS specialitate_id_30,
  m0_.utilizator_id AS utilizator_id_31,
  m0_.clinica_id AS clinica_id_32,
  m0_.colaborare_id AS colaborare_id_33
FROM
  medic m0_
WHERE
  m0_.slug IS NOT NULL
  AND m0_.slug <> ?
  AND (
    m0_.medic_top IS NULL
    OR m0_.medic_top = 0
    OR m0_.medic_top_expira < ?
  )
  AND m0_.status = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.nume AS nume_1, m0_.prenume AS prenume_2, m0_.titlul AS titlul_3, m0_.grad_profesional AS grad_profesional_4, m0_.stiinte_medicale AS stiinte_medicale_5, m0_.competente AS competente_6, m0_.cod_parafa AS cod_parafa_7, m0_.oras AS oras_8, m0_.judet AS judet_9, m0_.telefon AS telefon_10, m0_.consultatii_pentru AS consultatii_pentru_11, m0_.descriere AS descriere_12, m0_.slug AS slug_13, m0_.fotografie AS fotografie_14, m0_.fotografie_size AS fotografie_size_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.cmr AS cmr_18, m0_.asigurare_malpraxis AS asigurare_malpraxis_19, m0_.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_20, m0_.aviz_practica AS aviz_practica_21, m0_.aviz_practica_expirare AS aviz_practica_expirare_22, m0_.loc_munca AS loc_munca_23, m0_.medic_top AS medic_top_24, m0_.medic_top_expira AS medic_top_expira_25, m0_.prefix_telefon AS prefix_telefon_26, m0_.profil_completat AS profil_completat_27, m0_.status AS status_28, m0_.contract_semnat AS contract_semnat_29, m0_.specialitate_id AS specialitate_id_30, m0_.utilizator_id AS utilizator_id_31, m0_.clinica_id AS clinica_id_32, m0_.colaborare_id AS colaborare_id_33 FROM medic m0_ WHERE m0_.slug IS NOT NULL AND m0_.slug <> '' AND (m0_.medic_top IS NULL OR m0_.medic_top = 0 OR m0_.medic_top_expira < '2026-08-11 06:21:25') AND m0_.status = 'STATUS_APROBAT' ORDER BY RAND() ASC LIMIT 10;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 9;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 12;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 4;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 11;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 7;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 15;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 14;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 8;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 6;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 5;

SELECT
  c0_.id AS id_0,
  c0_.denumire AS denumire_1,
  c0_.slug AS slug_2,
  c0_.sigla_size AS sigla_size_3,
  c0_.sigla AS sigla_4,
  c0_.cui AS cui_5,
  c0_.nr_reg_comert AS nr_reg_comert_6,
  c0_.adresa AS adresa_7,
  c0_.oras AS oras_8,
  c0_.judet AS judet_9,
  c0_.telefon AS telefon_10,
  c0_.descriere AS descriere_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c0_.clinica_top AS clinica_top_14,
  c0_.clinica_top_expira AS clinica_top_expira_15,
  c0_.slogan AS slogan_16,
  c0_.approved AS approved_17,
  c0_.nume_societate AS nume_societate_18,
  c0_.reprezentant AS reprezentant_19,
  c0_.prefix_telefon AS prefix_telefon_20,
  c0_.cui_firma AS cui_firma_21,
  c0_.status AS status_22,
  c0_.contract_semnat AS contract_semnat_23,
  c0_.utilizator_id AS utilizator_id_24
FROM
  clinica c0_
WHERE
  c0_.clinica_top = 1
  AND c0_.clinica_top_expira >= ?
  AND c0_.slug IS NOT NULL
  AND c0_.slug <> ?
ORDER BY
  c0_.clinica_top_expira DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.denumire AS denumire_1, c0_.slug AS slug_2, c0_.sigla_size AS sigla_size_3, c0_.sigla AS sigla_4, c0_.cui AS cui_5, c0_.nr_reg_comert AS nr_reg_comert_6, c0_.adresa AS adresa_7, c0_.oras AS oras_8, c0_.judet AS judet_9, c0_.telefon AS telefon_10, c0_.descriere AS descriere_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.clinica_top AS clinica_top_14, c0_.clinica_top_expira AS clinica_top_expira_15, c0_.slogan AS slogan_16, c0_.approved AS approved_17, c0_.nume_societate AS nume_societate_18, c0_.reprezentant AS reprezentant_19, c0_.prefix_telefon AS prefix_telefon_20, c0_.cui_firma AS cui_firma_21, c0_.status AS status_22, c0_.contract_semnat AS contract_semnat_23, c0_.utilizator_id AS utilizator_id_24 FROM clinica c0_ WHERE c0_.clinica_top = 1 AND c0_.clinica_top_expira >= '2026-08-11 06:21:25' AND c0_.slug IS NOT NULL AND c0_.slug <> '' ORDER BY c0_.clinica_top_expira DESC LIMIT 10;

SELECT
  c0_.id AS id_0,
  c0_.denumire AS denumire_1,
  c0_.slug AS slug_2,
  c0_.sigla_size AS sigla_size_3,
  c0_.sigla AS sigla_4,
  c0_.cui AS cui_5,
  c0_.nr_reg_comert AS nr_reg_comert_6,
  c0_.adresa AS adresa_7,
  c0_.oras AS oras_8,
  c0_.judet AS judet_9,
  c0_.telefon AS telefon_10,
  c0_.descriere AS descriere_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c0_.clinica_top AS clinica_top_14,
  c0_.clinica_top_expira AS clinica_top_expira_15,
  c0_.slogan AS slogan_16,
  c0_.approved AS approved_17,
  c0_.nume_societate AS nume_societate_18,
  c0_.reprezentant AS reprezentant_19,
  c0_.prefix_telefon AS prefix_telefon_20,
  c0_.cui_firma AS cui_firma_21,
  c0_.status AS status_22,
  c0_.contract_semnat AS contract_semnat_23,
  c0_.utilizator_id AS utilizator_id_24
FROM
  clinica c0_
WHERE
  c0_.slug IS NOT NULL
  AND c0_.slug <> ?
  AND (
    c0_.clinica_top IS NULL
    OR c0_.clinica_top = 0
    OR c0_.clinica_top_expira < ?
  )
  AND c0_.status = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.denumire AS denumire_1, c0_.slug AS slug_2, c0_.sigla_size AS sigla_size_3, c0_.sigla AS sigla_4, c0_.cui AS cui_5, c0_.nr_reg_comert AS nr_reg_comert_6, c0_.adresa AS adresa_7, c0_.oras AS oras_8, c0_.judet AS judet_9, c0_.telefon AS telefon_10, c0_.descriere AS descriere_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.clinica_top AS clinica_top_14, c0_.clinica_top_expira AS clinica_top_expira_15, c0_.slogan AS slogan_16, c0_.approved AS approved_17, c0_.nume_societate AS nume_societate_18, c0_.reprezentant AS reprezentant_19, c0_.prefix_telefon AS prefix_telefon_20, c0_.cui_firma AS cui_firma_21, c0_.status AS status_22, c0_.contract_semnat AS contract_semnat_23, c0_.utilizator_id AS utilizator_id_24 FROM clinica c0_ WHERE c0_.slug IS NOT NULL AND c0_.slug <> '' AND (c0_.clinica_top IS NULL OR c0_.clinica_top = 0 OR c0_.clinica_top_expira < '2026-08-11 06:21:25') AND c0_.status = 'STATUS_APROBAT' ORDER BY RAND() ASC LIMIT 10;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  clinica c1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
  INNER JOIN medic m3_ ON c2_.medic_id = m3_.id
WHERE
  m3_.clinica_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM clinica c1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id INNER JOIN medic m3_ ON c2_.medic_id = m3_.id WHERE m3_.clinica_id = 2;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  clinica c1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
  INNER JOIN medic m3_ ON c2_.medic_id = m3_.id
WHERE
  m3_.clinica_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM clinica c1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id INNER JOIN medic m3_ ON c2_.medic_id = m3_.id WHERE m3_.clinica_id = 1;

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  clinica c1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
  INNER JOIN medic m3_ ON c2_.medic_id = m3_.id
WHERE
  m3_.clinica_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM clinica c1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id INNER JOIN medic m3_ ON c2_.medic_id = m3_.id WHERE m3_.clinica_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.page AS page_3
FROM
  slider t0
WHERE
  t0.page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.page AS page_3 FROM slider t0 WHERE t0.page = 'app_home' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.mobile_image AS mobile_image_3,
  t0.content AS content_4,
  t0.button_url AS button_url_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.new_tab AS new_tab_8,
  t0.slider_id AS slider_id_9
FROM
  slide t0
WHERE
  t0.slider_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.mobile_image AS mobile_image_3, t0.content AS content_4, t0.button_url AS button_url_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.new_tab AS new_tab_8, t0.slider_id AS slider_id_9 FROM slide t0 WHERE t0.slider_id = 1;