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 = ?
          )
        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 20:07:56' 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 = 'twink') 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
        FROM
          performer p0_
          INNER JOIN performer_tag p1_ ON (
            p1_.performer_id = p0_.id
            AND p1_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      sclr_6 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  30
OFFSET
  2520

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 20:07:56' THEN 1 ELSE 0 END) AS sclr_6, p1_.id AS id_7, p1_.tag AS tag_8 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'twink') 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 OFFSET 2520;

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 = ?
  )
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 20:07:56' 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 = 'twink') WHERE p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11) AND p0_.id IN (52390, 47156, 47046, 46183, 42717, 42267, 31988, 29501, 24306, 22683, 22570, 20602, 19947, 19404, 19210, 19197, 18585, 17889, 15327, 15311, 13540, 12533, 12136, 12097, 11954, 11833) 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 (52390, 47156, 47046, 46183, 42717, 42267, 31988, 29501, 24306, 22683, 22570, 20602, 19947, 19404, 19210, 19197, 18585, 17889, 15327, 15311, 13540, 12533, 12136, 12097, 11954, 11833);

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 (52390, 47156, 47046, 46183, 42717, 42267, 31988, 29501, 24306, 22683, 22570, 20602, 19947, 19404, 19210, 19197, 18585, 17889, 15327, 15311, 13540, 12533, 12136, 12097, 11954, 11833);

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 ('miah_connor', 'dominic_nick', 'giorgia_carter', 'daphne_rossi', 'desiree___desire', 'varya_ferreira', 'bella_cute2', 'femboy_20', 'peach_tyron', 'dyrinda', 'nahomi_williamss', 'charlotte_xc', 'leslieanddrako', 'emily_greif', 'sam_aaron', 'angel_shinne', 'jack_x_rosse2', 'camila_rous_', 'ambarr_rosse_', '0alicee', 'pamelaa_mature', 'scarlet_tommy', 'littlepinkcat', 'dallas_twiing', 'sophia_daker', 'lumars_') 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 (4780, 7666, 7839, 8537, 8867, 9915, 21788, 25391, 43040, 47318, 47390, 53046, 274963);

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 (4780, 7666, 7839, 8537, 8867, 9915, 21788, 25391, 43040, 47318, 47390, 53046, 274963);

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;