Symfony Profiler

SELECT
  t0.domain AS domain_1,
  t0.alias AS alias_2,
  t0.domain_css AS domain_css_3,
  t0.domain_js AS domain_js_4,
  t0.homepage_title AS homepage_title_5,
  t0.logo_font_size AS logo_font_size_6,
  t0.header_background_color AS header_background_color_7,
  t0.logo_font_id AS logo_font_id_8
FROM
  domain t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.domain AS domain_1, t0.alias AS alias_2, t0.domain_css AS domain_css_3, t0.domain_js AS domain_js_4, t0.homepage_title AS homepage_title_5, t0.logo_font_size AS logo_font_size_6, t0.header_background_color AS header_background_color_7, t0.logo_font_id AS logo_font_id_8 FROM domain t0 WHERE t0.domain = 'xxxplace.net' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.partner_link_template AS partner_link_template_2,
  t0.partner_link_offline_template AS partner_link_offline_template_3,
  t0.partner_f_link_title AS partner_f_link_title_4,
  t0.partner_f_link_template AS partner_f_link_template_5,
  t0.partner_f_link_offline_template AS partner_f_link_offline_template_6,
  t0.partner_m_link_title AS partner_m_link_title_7,
  t0.partner_m_link_template AS partner_m_link_template_8,
  t0.partner_m_link_offline_template AS partner_m_link_offline_template_9,
  t0.partner_c_link_title AS partner_c_link_title_10,
  t0.partner_c_link_template AS partner_c_link_template_11,
  t0.partner_c_link_offline_template AS partner_c_link_offline_template_12,
  t0.partner_t_link_title AS partner_t_link_title_13,
  t0.partner_t_link_template AS partner_t_link_template_14,
  t0.partner_t_link_offline_template AS partner_t_link_offline_template_15,
  t0.domain AS domain_16,
  t0.partner_id AS partner_id_17
FROM
  domain_partner t0
WHERE
  t0.domain = ?

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.domain = 'xxxplace.net';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.performer_code AS performer_code_1,
          p0_.last_online AS last_online_2,
          p0_.description AS description_3,
          p0_.chat_room_url AS chat_room_url_4,
          p0_.picture_url AS picture_url_5,
          (
            CASE WHEN p0_.last_online > ? THEN
              1
            ELSE
              0
            END
          ) AS sclr_6
        FROM
          performer p0_
          INNER JOIN performer_tag p1_ ON (
            p1_.performer_id = p0_.id
            AND p1_.tag = ?
          )
          INNER JOIN performer_tag p2_ ON (
            p2_.performer_id = p0_.id
            AND p2_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
        ORDER BY
          sclr_6 DESC,
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 19:29:22' THEN 1 ELSE 0 END) AS sclr_6 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'squirt') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'ride') WHERE p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11) ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_6
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.performer_code AS performer_code_1,
          p0_.last_online AS last_online_2,
          p0_.description AS description_3,
          p0_.chat_room_url AS chat_room_url_4,
          p0_.picture_url AS picture_url_5,
          (
            CASE WHEN p0_.last_online > ? THEN
              1
            ELSE
              0
            END
          ) AS sclr_6,
          p1_.id AS id_7,
          p1_.tag AS tag_8,
          p2_.id AS id_9,
          p2_.tag AS tag_10
        FROM
          performer p0_
          INNER JOIN performer_tag p1_ ON (
            p1_.performer_id = p0_.id
            AND p1_.tag = ?
          )
          INNER JOIN performer_tag p2_ ON (
            p2_.performer_id = p0_.id
            AND p2_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      sclr_6 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_6 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 19:29:22' THEN 1 ELSE 0 END) AS sclr_6, p1_.id AS id_7, p1_.tag AS tag_8, p2_.id AS id_9, p2_.tag AS tag_10 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'squirt') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'ride') WHERE p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11)) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30;

SELECT
  p0_.id AS id_0,
  p0_.performer_code AS performer_code_1,
  p0_.last_online AS last_online_2,
  p0_.description AS description_3,
  p0_.chat_room_url AS chat_room_url_4,
  p0_.picture_url AS picture_url_5,
  (
    CASE WHEN p0_.last_online > ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_6,
  p0_.partner_id AS partner_id_7,
  p0_.category_id AS category_id_8
FROM
  performer p0_
  INNER JOIN performer_tag p1_ ON (
    p1_.performer_id = p0_.id
    AND p1_.tag = ?
  )
  INNER JOIN performer_tag p2_ ON (
    p2_.performer_id = p0_.id
    AND p2_.tag = ?
  )
WHERE
  p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  sclr_6 DESC,
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 19:29:22' THEN 1 ELSE 0 END) AS sclr_6, p0_.partner_id AS partner_id_7, p0_.category_id AS category_id_8 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'squirt') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'ride') WHERE p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11) AND p0_.id IN (80679, 12546, 417130, 314870, 271099, 221522, 146906, 133575, 127646, 123484, 104128, 89831, 82773, 79052, 76887, 74670, 74236, 61349, 56778, 39133, 34994, 25211, 19224, 16453, 15493) ORDER BY sclr_6 DESC, p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.performer_id AS performer_id_3
FROM
  performer_tag t0
WHERE
  t0.performer_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (80679, 12546, 417130, 314870, 271099, 221522, 146906, 133575, 127646, 123484, 104128, 89831, 82773, 79052, 76887, 74670, 74236, 61349, 56778, 39133, 34994, 25211, 19224, 16453, 15493);

SELECT
  t0.id AS id_1,
  t0._key AS _key_2,
  t0._value AS _value_3,
  t0.performer_id AS performer_id_4
FROM
  performer_info t0
WHERE
  t0.performer_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (80679, 12546, 417130, 314870, 271099, 221522, 146906, 133575, 127646, 123484, 104128, 89831, 82773, 79052, 76887, 74670, 74236, 61349, 56778, 39133, 34994, 25211, 19224, 16453, 15493);

SELECT
  p0_.id AS id_0,
  p0_.performer_code AS performer_code_1,
  p0_.last_online AS last_online_2,
  p0_.description AS description_3,
  p0_.chat_room_url AS chat_room_url_4,
  p0_.picture_url AS picture_url_5,
  p0_.partner_id AS partner_id_6,
  p0_.category_id AS category_id_7
FROM
  performer p0_
WHERE
  LOWER(p0_.performer_code) IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, p0_.partner_id AS partner_id_6, p0_.category_id AS category_id_7 FROM performer p0_ WHERE LOWER(p0_.performer_code) IN ('alice_candace', 'saramartins01', 'mrscookieboo', 'angel_ree', 'lucyjackson', 'ambaran', 'kendalljoy', 'solanyivera', 'leeawinston', 'connieowen', 'paulinasotoydanidemon', 'eveeevian', 'bubblebum4you', 'lucero_castro', 'eva_bigboobs_', 'sabrinajadex', 'alana_madison', 'layla_snowflake', 'yummi_kim', 'channel_kox', 'boobsgoddes', 'miss_charlize__', 'loise_gomez', 'lea_gray', 'sander_mila') AND p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11);

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.performer_id AS performer_id_3
FROM
  performer_tag t0
WHERE
  t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (4291, 6733, 61472, 81596, 133452, 249128, 493399, 507963);

SELECT
  t0.id AS id_1,
  t0._key AS _key_2,
  t0._value AS _value_3,
  t0.performer_id AS performer_id_4
FROM
  performer_info t0
WHERE
  t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (4291, 6733, 61472, 81596, 133452, 249128, 493399, 507963);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.css AS css_3,
  t0.family AS family_4
FROM
  font t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.css AS css_3, t0.family AS family_4 FROM font t0 WHERE t0.id = 53;

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.partner_name AS partner_name_2
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.partner_link_template AS partner_link_template_2,
  t0.partner_link_offline_template AS partner_link_offline_template_3,
  t0.partner_f_link_title AS partner_f_link_title_4,
  t0.partner_f_link_template AS partner_f_link_template_5,
  t0.partner_f_link_offline_template AS partner_f_link_offline_template_6,
  t0.partner_m_link_title AS partner_m_link_title_7,
  t0.partner_m_link_template AS partner_m_link_template_8,
  t0.partner_m_link_offline_template AS partner_m_link_offline_template_9,
  t0.partner_c_link_title AS partner_c_link_title_10,
  t0.partner_c_link_template AS partner_c_link_template_11,
  t0.partner_c_link_offline_template AS partner_c_link_offline_template_12,
  t0.partner_t_link_title AS partner_t_link_title_13,
  t0.partner_t_link_template AS partner_t_link_template_14,
  t0.partner_t_link_offline_template AS partner_t_link_offline_template_15,
  t0.domain AS domain_16,
  t0.partner_id AS partner_id_17
FROM
  domain_partner t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = 1;

SELECT
  t0.id AS id_1,
  t0.partner_name AS partner_name_2
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.partner_link_template AS partner_link_template_2,
  t0.partner_link_offline_template AS partner_link_offline_template_3,
  t0.partner_f_link_title AS partner_f_link_title_4,
  t0.partner_f_link_template AS partner_f_link_template_5,
  t0.partner_f_link_offline_template AS partner_f_link_offline_template_6,
  t0.partner_m_link_title AS partner_m_link_title_7,
  t0.partner_m_link_template AS partner_m_link_template_8,
  t0.partner_m_link_offline_template AS partner_m_link_offline_template_9,
  t0.partner_c_link_title AS partner_c_link_title_10,
  t0.partner_c_link_template AS partner_c_link_template_11,
  t0.partner_c_link_offline_template AS partner_c_link_offline_template_12,
  t0.partner_t_link_title AS partner_t_link_title_13,
  t0.partner_t_link_template AS partner_t_link_template_14,
  t0.partner_t_link_offline_template AS partner_t_link_offline_template_15,
  t0.domain AS domain_16,
  t0.partner_id AS partner_id_17
FROM
  domain_partner t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = 2;

SELECT
  t0.id AS id_1,
  t0.partner_name AS partner_name_2
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = 15;