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

[
  "gaping vagina"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gaping vagina' 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
  560666
  385745
  421220
  433493
  448464
  510803
  585994
  447879
  463759
  418148
  447549
  414125
  429889
  406685
  491266
  510425
  497675
  416677
  605725
  410573
  432034
  524389
  601604
  599538
  786461
  458281
  470414
  602092
  429899
  491436
  603612
  395970
  433209
  433295
  422723
  416529
  445781
  591345
  604426
  419452
  454274
  432288
  446874
  509660
  503411
  528299
  421207
  501641
  396670
  446501
  427959
  475830
  523549
  573748
  617437
  524213
  449115
  597476
  419594
  454927
  626297
  445409
  494233
  494231
  542524
  556480
  496270
  502043
  426551
  642407
  605746
  622693
  527915
]

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 (560666, 385745, 421220, 433493, 448464, 510803, 585994, 447879, 463759, 418148, 447549, 414125, 429889, 406685, 491266, 510425, 497675, 416677, 605725, 410573, 432034, 524389, 601604, 599538, 786461, 458281, 470414, 602092, 429899, 491436, 603612, 395970, 433209, 433295, 422723, 416529, 445781, 591345, 604426, 419452, 454274, 432288, 446874, 509660, 503411, 528299, 421207, 501641, 396670, 446501, 427959, 475830, 523549, 573748, 617437, 524213, 449115, 597476, 419594, 454927, 626297, 445409, 494233, 494231, 542524, 556480, 496270, 502043, 426551, 642407, 605746, 622693, 527915);

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
  385745
  395970
  396670
  406685
  410573
  414125
  416529
  416677
  418148
  419452
  419594
  421207
  421220
  422723
  426551
  427959
  429889
  429899
  432034
  432288
  433209
  433295
  433493
  445409
  445781
  446501
  446874
  447549
  447879
  448464
  449115
  454274
  454927
  458281
  463759
  470414
  475830
  491266
  491436
  494231
  494233
  496270
  497675
  501641
  502043
  503411
  509660
  510425
  510803
  523549
  524213
  524389
  527915
  528299
  542524
  556480
  560666
  573748
  585994
  591345
  597476
  599538
  601604
  602092
  603612
  604426
  605725
  605746
  617437
  622693
  626297
  642407
  786461
]

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 (385745, 395970, 396670, 406685, 410573, 414125, 416529, 416677, 418148, 419452, 419594, 421207, 421220, 422723, 426551, 427959, 429889, 429899, 432034, 432288, 433209, 433295, 433493, 445409, 445781, 446501, 446874, 447549, 447879, 448464, 449115, 454274, 454927, 458281, 463759, 470414, 475830, 491266, 491436, 494231, 494233, 496270, 497675, 501641, 502043, 503411, 509660, 510425, 510803, 523549, 524213, 524389, 527915, 528299, 542524, 556480, 560666, 573748, 585994, 591345, 597476, 599538, 601604, 602092, 603612, 604426, 605725, 605746, 617437, 622693, 626297, 642407, 786461);

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
  385745
  395970
  396670
  406685
  410573
  414125
  416529
  416677
  418148
  419452
  419594
  421207
  421220
  422723
  426551
  427959
  429889
  429899
  432034
  432288
  433209
  433295
  433493
  445409
  445781
  446501
  446874
  447549
  447879
  448464
  449115
  454274
  454927
  458281
  463759
  470414
  475830
  491266
  491436
  494231
  494233
  496270
  497675
  501641
  502043
  503411
  509660
  510425
  510803
  523549
  524213
  524389
  527915
  528299
  542524
  556480
  560666
  573748
  585994
  591345
  597476
  599538
  601604
  602092
  603612
  604426
  605725
  605746
  617437
  622693
  626297
  642407
  786461
]

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 (385745, 395970, 396670, 406685, 410573, 414125, 416529, 416677, 418148, 419452, 419594, 421207, 421220, 422723, 426551, 427959, 429889, 429899, 432034, 432288, 433209, 433295, 433493, 445409, 445781, 446501, 446874, 447549, 447879, 448464, 449115, 454274, 454927, 458281, 463759, 470414, 475830, 491266, 491436, 494231, 494233, 496270, 497675, 501641, 502043, 503411, 509660, 510425, 510803, 523549, 524213, 524389, 527915, 528299, 542524, 556480, 560666, 573748, 585994, 591345, 597476, 599538, 601604, 602092, 603612, 604426, 605725, 605746, 617437, 622693, 626297, 642407, 786461);

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

[
  "gaping вагин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'gaping вагин';

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

[
  "gaping вагин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gaping вагин';

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 ?

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