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

[
  "slim teen anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'slim teen 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
  597600
  758970
  400957
  777041
  761482
  771134
  721851
  722834
  721329
  755419
  765076
  398801
  810416
  690618
  610555
  684376
  715125
  769907
  748685
  397953
  800175
  740931
  603400
  443120
  718983
  576291
  766348
  770391
  699626
  722261
  750213
  474281
  403289
  385701
  458487
  510402
  511966
  416242
  530803
  415256
  513655
  733890
  423033
  490893
  418133
  496448
  518067
  455936
  787075
  480209
  487202
  576987
  520542
  470536
  422519
  471978
  478457
  646875
  741109
  397335
  401936
  422936
  537905
  565476
  477441
  505023
  558601
  491354
  505086
  811826
  599532
  642700
]

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 (597600, 758970, 400957, 777041, 761482, 771134, 721851, 722834, 721329, 755419, 765076, 398801, 810416, 690618, 610555, 684376, 715125, 769907, 748685, 397953, 800175, 740931, 603400, 443120, 718983, 576291, 766348, 770391, 699626, 722261, 750213, 474281, 403289, 385701, 458487, 510402, 511966, 416242, 530803, 415256, 513655, 733890, 423033, 490893, 418133, 496448, 518067, 455936, 787075, 480209, 487202, 576987, 520542, 470536, 422519, 471978, 478457, 646875, 741109, 397335, 401936, 422936, 537905, 565476, 477441, 505023, 558601, 491354, 505086, 811826, 599532, 642700);

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
  385701
  397335
  397953
  398801
  400957
  401936
  403289
  415256
  416242
  418133
  422519
  422936
  423033
  443120
  455936
  458487
  470536
  471978
  474281
  477441
  478457
  480209
  487202
  490893
  491354
  496448
  505023
  505086
  510402
  511966
  513655
  518067
  520542
  530803
  537905
  558601
  565476
  576291
  576987
  597600
  599532
  603400
  610555
  642700
  646875
  684376
  690618
  699626
  715125
  718983
  721329
  721851
  722261
  722834
  733890
  740931
  741109
  748685
  750213
  755419
  758970
  761482
  765076
  766348
  769907
  770391
  771134
  777041
  787075
  800175
  810416
  811826
]

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 (385701, 397335, 397953, 398801, 400957, 401936, 403289, 415256, 416242, 418133, 422519, 422936, 423033, 443120, 455936, 458487, 470536, 471978, 474281, 477441, 478457, 480209, 487202, 490893, 491354, 496448, 505023, 505086, 510402, 511966, 513655, 518067, 520542, 530803, 537905, 558601, 565476, 576291, 576987, 597600, 599532, 603400, 610555, 642700, 646875, 684376, 690618, 699626, 715125, 718983, 721329, 721851, 722261, 722834, 733890, 740931, 741109, 748685, 750213, 755419, 758970, 761482, 765076, 766348, 769907, 770391, 771134, 777041, 787075, 800175, 810416, 811826);

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
  385701
  397335
  397953
  398801
  400957
  401936
  403289
  415256
  416242
  418133
  422519
  422936
  423033
  443120
  455936
  458487
  470536
  471978
  474281
  477441
  478457
  480209
  487202
  490893
  491354
  496448
  505023
  505086
  510402
  511966
  513655
  518067
  520542
  530803
  537905
  558601
  565476
  576291
  576987
  597600
  599532
  603400
  610555
  642700
  646875
  684376
  690618
  699626
  715125
  718983
  721329
  721851
  722261
  722834
  733890
  740931
  741109
  748685
  750213
  755419
  758970
  761482
  765076
  766348
  769907
  770391
  771134
  777041
  787075
  800175
  810416
  811826
]

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 (385701, 397335, 397953, 398801, 400957, 401936, 403289, 415256, 416242, 418133, 422519, 422936, 423033, 443120, 455936, 458487, 470536, 471978, 474281, 477441, 478457, 480209, 487202, 490893, 491354, 496448, 505023, 505086, 510402, 511966, 513655, 518067, 520542, 530803, 537905, 558601, 565476, 576291, 576987, 597600, 599532, 603400, 610555, 642700, 646875, 684376, 690618, 699626, 715125, 718983, 721329, 721851, 722261, 722834, 733890, 740931, 741109, 748685, 750213, 755419, 758970, 761482, 765076, 766348, 769907, 770391, 771134, 777041, 787075, 800175, 810416, 811826);

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 ?

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