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 = 'cumwebcam.net' LIMIT 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.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 = 'cumwebcam.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 = ?
          )
          INNER JOIN performer_tag p3_ ON (
            p3_.performer_id = p0_.id
            AND p3_.tag = ?
          )
          INNER JOIN performer_tag p4_ ON (
            p4_.performer_id = p0_.id
            AND p4_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
          AND p0_.category_id = ?
        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 21:46:35' 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 = 'Games') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'French') INNER JOIN performer_tag p3_ ON (p3_.performer_id = p0_.id AND p3_.tag = 'camshow') INNER JOIN performer_tag p4_ ON (p4_.performer_id = p0_.id AND p4_.tag = 'chatting') WHERE p0_.partner_id IN (1, 13, 6, 14, 15, 7, 11) AND p0_.category_id = '2' 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,
          p3_.id AS id_11,
          p3_.tag AS tag_12,
          p4_.id AS id_13,
          p4_.tag AS tag_14
        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 = ?
          )
          INNER JOIN performer_tag p3_ ON (
            p3_.performer_id = p0_.id
            AND p3_.tag = ?
          )
          INNER JOIN performer_tag p4_ ON (
            p4_.performer_id = p0_.id
            AND p4_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
          AND p0_.category_id = ?
      ) 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 21:46:35' 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, p3_.id AS id_11, p3_.tag AS tag_12, p4_.id AS id_13, p4_.tag AS tag_14 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'Games') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'French') INNER JOIN performer_tag p3_ ON (p3_.performer_id = p0_.id AND p3_.tag = 'camshow') INNER JOIN performer_tag p4_ ON (p4_.performer_id = p0_.id AND p4_.tag = 'chatting') WHERE p0_.partner_id IN (1, 13, 6, 14, 15, 7, 11) AND p0_.category_id = '2') 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 = ?
  )
  INNER JOIN performer_tag p3_ ON (
    p3_.performer_id = p0_.id
    AND p3_.tag = ?
  )
  INNER JOIN performer_tag p4_ ON (
    p4_.performer_id = p0_.id
    AND p4_.tag = ?
  )
WHERE
  p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?)
  AND p0_.category_id = ?
  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 21:46:35' 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 = 'Games') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'French') INNER JOIN performer_tag p3_ ON (p3_.performer_id = p0_.id AND p3_.tag = 'camshow') INNER JOIN performer_tag p4_ ON (p4_.performer_id = p0_.id AND p4_.tag = 'chatting') WHERE p0_.partner_id IN (1, 13, 6, 14, 15, 7, 11) AND p0_.category_id = '2' AND p0_.id IN (170237, 555349, 551121, 538662, 500772, 458625, 386760, 319561, 305513, 280493, 254226, 252611, 231169, 217244, 213706, 211447, 210227, 187451, 175558, 174956) 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 (170237, 555349, 551121, 538662, 500772, 458625, 386760, 319561, 305513, 280493, 254226, 252611, 231169, 217244, 213706, 211447, 210227, 187451, 175558, 174956);

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 (170237, 555349, 551121, 538662, 500772, 458625, 386760, 319561, 305513, 280493, 254226, 252611, 231169, 217244, 213706, 211447, 210227, 187451, 175558, 174956);

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 ('daryastars', 'franckouzz', 'twinsexgirl', 'xbogdyx', 'bbwarb24', 'jupimo', 'biijulia', 'joao-erik', 'oda69dako', 'hotstuf-1', 'sexapoly', 'cataleya-uzziel', 'rachel-sharps', 'selenaston', 'londonbliss', 'tattoo-couple', 'mike-maite', 'munishpunish', 'latino-slavic-couple', 'aiiina') AND p0_.partner_id IN (1, 13, 6, 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 (14051, 114469, 186218);

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 (14051, 114469, 186218);

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

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

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