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 interracial anal"
]

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

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

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

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