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

[
  "blacked anal sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blacked anal sex' 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
  399738
  457751
  810705
  722527
  560184
  788570
  528886
  399747
  399418
  397232
  403255
  397505
  15162
  399737
  399378
  386271
  399722
  373741
  560639
  404418
  396565
  395489
  397293
  398317
  384373
  399354
  399401
  500431
  448864
  429729
  399414
  396368
  395446
  732574
  419854
  463073
  423708
  395406
  390024
  582012
  437526
  435624
  421557
  563992
  429424
  604417
  420345
  417889
  510270
  395269
  396742
  413944
  532779
  414621
  518493
  530789
  396746
  460706
  418363
  506143
  417482
  468655
  399263
  434001
  532343
  495752
  525864
  603258
  518438
  605521
  604478
  609922
]

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 (399738, 457751, 810705, 722527, 560184, 788570, 528886, 399747, 399418, 397232, 403255, 397505, 15162, 399737, 399378, 386271, 399722, 373741, 560639, 404418, 396565, 395489, 397293, 398317, 384373, 399354, 399401, 500431, 448864, 429729, 399414, 396368, 395446, 732574, 419854, 463073, 423708, 395406, 390024, 582012, 437526, 435624, 421557, 563992, 429424, 604417, 420345, 417889, 510270, 395269, 396742, 413944, 532779, 414621, 518493, 530789, 396746, 460706, 418363, 506143, 417482, 468655, 399263, 434001, 532343, 495752, 525864, 603258, 518438, 605521, 604478, 609922);

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
  15162
  373741
  384373
  386271
  390024
  395269
  395406
  395446
  395489
  396368
  396565
  396742
  396746
  397232
  397293
  397505
  398317
  399263
  399354
  399378
  399401
  399414
  399418
  399722
  399737
  399738
  399747
  403255
  404418
  413944
  414621
  417482
  417889
  418363
  419854
  420345
  421557
  423708
  429424
  429729
  434001
  435624
  437526
  448864
  457751
  460706
  463073
  468655
  495752
  500431
  506143
  510270
  518438
  518493
  525864
  528886
  530789
  532343
  532779
  560184
  560639
  563992
  582012
  603258
  604417
  604478
  605521
  609922
  722527
  732574
  788570
  810705
]

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 (15162, 373741, 384373, 386271, 390024, 395269, 395406, 395446, 395489, 396368, 396565, 396742, 396746, 397232, 397293, 397505, 398317, 399263, 399354, 399378, 399401, 399414, 399418, 399722, 399737, 399738, 399747, 403255, 404418, 413944, 414621, 417482, 417889, 418363, 419854, 420345, 421557, 423708, 429424, 429729, 434001, 435624, 437526, 448864, 457751, 460706, 463073, 468655, 495752, 500431, 506143, 510270, 518438, 518493, 525864, 528886, 530789, 532343, 532779, 560184, 560639, 563992, 582012, 603258, 604417, 604478, 605521, 609922, 722527, 732574, 788570, 810705);

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
  15162
  373741
  384373
  386271
  390024
  395269
  395406
  395446
  395489
  396368
  396565
  396742
  396746
  397232
  397293
  397505
  398317
  399263
  399354
  399378
  399401
  399414
  399418
  399722
  399737
  399738
  399747
  403255
  404418
  413944
  414621
  417482
  417889
  418363
  419854
  420345
  421557
  423708
  429424
  429729
  434001
  435624
  437526
  448864
  457751
  460706
  463073
  468655
  495752
  500431
  506143
  510270
  518438
  518493
  525864
  528886
  530789
  532343
  532779
  560184
  560639
  563992
  582012
  603258
  604417
  604478
  605521
  609922
  722527
  732574
  788570
  810705
]

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 (15162, 373741, 384373, 386271, 390024, 395269, 395406, 395446, 395489, 396368, 396565, 396742, 396746, 397232, 397293, 397505, 398317, 399263, 399354, 399378, 399401, 399414, 399418, 399722, 399737, 399738, 399747, 403255, 404418, 413944, 414621, 417482, 417889, 418363, 419854, 420345, 421557, 423708, 429424, 429729, 434001, 435624, 437526, 448864, 457751, 460706, 463073, 468655, 495752, 500431, 506143, 510270, 518438, 518493, 525864, 528886, 530789, 532343, 532779, 560184, 560639, 563992, 582012, 603258, 604417, 604478, 605521, 609922, 722527, 732574, 788570, 810705);

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

[
  "blacked анал секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'blacked анал секс';

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

[
  "blacked анал секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blacked анал секс';

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 ?

[
  "blacked anal sex"
  "blacked anal sex"
  "blacked anal sex"
  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 ('blacked anal sex') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('blacked anal sex')
              AND `query` <> 'blacked anal sex'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;