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

[
  "anal tushy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal tushy' 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
  395547
  395620
  395968
  401305
  428631
  554780
  760958
  475410
  395687
  395984
  408283
  428494
  519549
  509940
  396035
  401127
  395727
  396670
  181304
  760936
  395632
  395826
  396253
  419888
  561412
  395812
  396005
  463873
  395674
  477859
  395913
  524530
  401091
  523396
  459804
  395751
  558119
  395648
  402008
  519560
  519553
  395719
  459807
  395552
  395622
  395981
  395856
  396012
  419880
  468612
  396020
  411201
  490143
  527996
  393076
  415658
  419867
  565163
  463298
  395818
  419872
  512094
  527416
  565156
  598657
  602966
  395824
  395718
  565169
  605521
  395696
  418686
  514070
  624226
]

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 (395547, 395620, 395968, 401305, 428631, 554780, 760958, 475410, 395687, 395984, 408283, 428494, 519549, 509940, 396035, 401127, 395727, 396670, 181304, 760936, 395632, 395826, 396253, 419888, 561412, 395812, 396005, 463873, 395674, 477859, 395913, 524530, 401091, 523396, 459804, 395751, 558119, 395648, 402008, 519560, 519553, 395719, 459807, 395552, 395622, 395981, 395856, 396012, 419880, 468612, 396020, 411201, 490143, 527996, 393076, 415658, 419867, 565163, 463298, 395818, 419872, 512094, 527416, 565156, 598657, 602966, 395824, 395718, 565169, 605521, 395696, 418686, 514070, 624226);

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
  181304
  393076
  395547
  395552
  395620
  395622
  395632
  395648
  395674
  395687
  395696
  395718
  395719
  395727
  395751
  395812
  395818
  395824
  395826
  395856
  395913
  395968
  395981
  395984
  396005
  396012
  396020
  396035
  396253
  396670
  401091
  401127
  401305
  402008
  408283
  411201
  415658
  418686
  419867
  419872
  419880
  419888
  428494
  428631
  459804
  459807
  463298
  463873
  468612
  475410
  477859
  490143
  509940
  512094
  514070
  519549
  519553
  519560
  523396
  524530
  527416
  527996
  554780
  558119
  561412
  565156
  565163
  565169
  598657
  602966
  605521
  624226
  760936
  760958
]

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 (181304, 393076, 395547, 395552, 395620, 395622, 395632, 395648, 395674, 395687, 395696, 395718, 395719, 395727, 395751, 395812, 395818, 395824, 395826, 395856, 395913, 395968, 395981, 395984, 396005, 396012, 396020, 396035, 396253, 396670, 401091, 401127, 401305, 402008, 408283, 411201, 415658, 418686, 419867, 419872, 419880, 419888, 428494, 428631, 459804, 459807, 463298, 463873, 468612, 475410, 477859, 490143, 509940, 512094, 514070, 519549, 519553, 519560, 523396, 524530, 527416, 527996, 554780, 558119, 561412, 565156, 565163, 565169, 598657, 602966, 605521, 624226, 760936, 760958);

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
  181304
  393076
  395547
  395552
  395620
  395622
  395632
  395648
  395674
  395687
  395696
  395718
  395719
  395727
  395751
  395812
  395818
  395824
  395826
  395856
  395913
  395968
  395981
  395984
  396005
  396012
  396020
  396035
  396253
  396670
  401091
  401127
  401305
  402008
  408283
  411201
  415658
  418686
  419867
  419872
  419880
  419888
  428494
  428631
  459804
  459807
  463298
  463873
  468612
  475410
  477859
  490143
  509940
  512094
  514070
  519549
  519553
  519560
  523396
  524530
  527416
  527996
  554780
  558119
  561412
  565156
  565163
  565169
  598657
  602966
  605521
  624226
  760936
  760958
]

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 (181304, 393076, 395547, 395552, 395620, 395622, 395632, 395648, 395674, 395687, 395696, 395718, 395719, 395727, 395751, 395812, 395818, 395824, 395826, 395856, 395913, 395968, 395981, 395984, 396005, 396012, 396020, 396035, 396253, 396670, 401091, 401127, 401305, 402008, 408283, 411201, 415658, 418686, 419867, 419872, 419880, 419888, 428494, 428631, 459804, 459807, 463298, 463873, 468612, 475410, 477859, 490143, 509940, 512094, 514070, 519549, 519553, 519560, 523396, 524530, 527416, 527996, 554780, 558119, 561412, 565156, 565163, 565169, 598657, 602966, 605521, 624226, 760936, 760958);

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

[
  "анал tushy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал tushy';

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

[
  "анал tushy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал tushy';

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 ?

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