Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "teen blowjob slave"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen blowjob slave' LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  496080
  651089
  540437
  545437
  599835
  572763
  413827
  521089
  524628
  530024
  642766
  497921
  534149
  451866
  495400
  564646
  532745
  680186
  548257
  627730
  527611
  497422
  531231
  559120
  540326
  463757
  545480
  647975
  491963
  484069
  521372
  521579
  566993
  420291
  508437
  652544
  486871
  648257
  646448
  531201
  494081
  534645
  530637
  515972
  462381
  521126
  514800
  515122
  605349
  520737
  648575
  533957
  591235
  538270
  532680
  519617
  522382
  567416
  506500
  530369
  533915
  610605
  598105
  427174
  415160
  576080
  665328
  527915
  600011
  526203
  523924
  559233
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (496080, 651089, 540437, 545437, 599835, 572763, 413827, 521089, 524628, 530024, 642766, 497921, 534149, 451866, 495400, 564646, 532745, 680186, 548257, 627730, 527611, 497422, 531231, 559120, 540326, 463757, 545480, 647975, 491963, 484069, 521372, 521579, 566993, 420291, 508437, 652544, 486871, 648257, 646448, 531201, 494081, 534645, 530637, 515972, 462381, 521126, 514800, 515122, 605349, 520737, 648575, 533957, 591235, 538270, 532680, 519617, 522382, 567416, 506500, 530369, 533915, 610605, 598105, 427174, 415160, 576080, 665328, 527915, 600011, 526203, 523924, 559233);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  413827
  415160
  420291
  427174
  451866
  462381
  463757
  484069
  486871
  491963
  494081
  495400
  496080
  497422
  497921
  506500
  508437
  514800
  515122
  515972
  519617
  520737
  521089
  521126
  521372
  521579
  522382
  523924
  524628
  526203
  527611
  527915
  530024
  530369
  530637
  531201
  531231
  532680
  532745
  533915
  533957
  534149
  534645
  538270
  540326
  540437
  545437
  545480
  548257
  559120
  559233
  564646
  566993
  567416
  572763
  576080
  591235
  598105
  599835
  600011
  605349
  610605
  627730
  642766
  646448
  647975
  648257
  648575
  651089
  652544
  665328
  680186
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (413827, 415160, 420291, 427174, 451866, 462381, 463757, 484069, 486871, 491963, 494081, 495400, 496080, 497422, 497921, 506500, 508437, 514800, 515122, 515972, 519617, 520737, 521089, 521126, 521372, 521579, 522382, 523924, 524628, 526203, 527611, 527915, 530024, 530369, 530637, 531201, 531231, 532680, 532745, 533915, 533957, 534149, 534645, 538270, 540326, 540437, 545437, 545480, 548257, 559120, 559233, 564646, 566993, 567416, 572763, 576080, 591235, 598105, 599835, 600011, 605349, 610605, 627730, 642766, 646448, 647975, 648257, 648575, 651089, 652544, 665328, 680186);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  413827
  415160
  420291
  427174
  451866
  462381
  463757
  484069
  486871
  491963
  494081
  495400
  496080
  497422
  497921
  506500
  508437
  514800
  515122
  515972
  519617
  520737
  521089
  521126
  521372
  521579
  522382
  523924
  524628
  526203
  527611
  527915
  530024
  530369
  530637
  531201
  531231
  532680
  532745
  533915
  533957
  534149
  534645
  538270
  540326
  540437
  545437
  545480
  548257
  559120
  559233
  564646
  566993
  567416
  572763
  576080
  591235
  598105
  599835
  600011
  605349
  610605
  627730
  642766
  646448
  647975
  648257
  648575
  651089
  652544
  665328
  680186
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (413827, 415160, 420291, 427174, 451866, 462381, 463757, 484069, 486871, 491963, 494081, 495400, 496080, 497422, 497921, 506500, 508437, 514800, 515122, 515972, 519617, 520737, 521089, 521126, 521372, 521579, 522382, 523924, 524628, 526203, 527611, 527915, 530024, 530369, 530637, 531201, 531231, 532680, 532745, 533915, 533957, 534149, 534645, 538270, 540326, 540437, 545437, 545480, 548257, 559120, 559233, 564646, 566993, 567416, 572763, 576080, 591235, 598105, 599835, 600011, 605349, 610605, 627730, 642766, 646448, 647975, 648257, 648575, 651089, 652544, 665328, 680186);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "teen минет оральн секс доминирован"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen минет оральн секс доминирован';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "teen минет оральн секс доминирован"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen минет оральн секс доминирован';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "teen blowjob slave"
  "teen blowjob slave"
  "teen blowjob slave"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('teen blowjob slave') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('teen blowjob slave')
              AND `query` <> 'teen blowjob slave'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;