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

[
  "kelsi"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kelsi' 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
  201531
  533210
  530040
  532431
  806158
  644985
  520985
  678483
  609924
  685638
  720770
  806197
  806201
  760915
  533079
  533930
  503586
  540943
  384423
  394808
  486730
  647666
  803343
  453379
  503577
  396654
  401742
  421530
  486702
  417476
  530836
  503587
  486701
  401500
  822803
  815342
  642686
  821471
  387445
  486726
  393479
  454648
  364027
  820797
  821583
  712695
  399627
  384748
  394739
  820980
  821610
  821068
  445536
  448796
  486288
  486710
  387228
  391364
  448677
  475277
  504997
  542379
  401780
  486725
  395555
  445553
  452507
  464614
  525396
  395941
  405024
  685643
  723994
  448842
  282010
]

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 (201531, 533210, 530040, 532431, 806158, 644985, 520985, 678483, 609924, 685638, 720770, 806197, 806201, 760915, 533079, 533930, 503586, 540943, 384423, 394808, 486730, 647666, 803343, 453379, 503577, 396654, 401742, 421530, 486702, 417476, 530836, 503587, 486701, 401500, 822803, 815342, 642686, 821471, 387445, 486726, 393479, 454648, 364027, 820797, 821583, 712695, 399627, 384748, 394739, 820980, 821610, 821068, 445536, 448796, 486288, 486710, 387228, 391364, 448677, 475277, 504997, 542379, 401780, 486725, 395555, 445553, 452507, 464614, 525396, 395941, 405024, 685643, 723994, 448842, 282010);

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
  201531
  282010
  364027
  384423
  384748
  387228
  387445
  391364
  393479
  394739
  394808
  395555
  395941
  396654
  399627
  401500
  401742
  401780
  405024
  417476
  421530
  445536
  445553
  448677
  448796
  448842
  452507
  453379
  454648
  464614
  475277
  486288
  486701
  486702
  486710
  486725
  486726
  486730
  503577
  503586
  503587
  504997
  520985
  525396
  530040
  530836
  532431
  533079
  533210
  533930
  540943
  542379
  609924
  642686
  644985
  647666
  678483
  685638
  685643
  712695
  720770
  723994
  760915
  803343
  806158
  806197
  806201
  815342
  820797
  820980
  821068
  821471
  821583
  821610
]

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 (201531, 282010, 364027, 384423, 384748, 387228, 387445, 391364, 393479, 394739, 394808, 395555, 395941, 396654, 399627, 401500, 401742, 401780, 405024, 417476, 421530, 445536, 445553, 448677, 448796, 448842, 452507, 453379, 454648, 464614, 475277, 486288, 486701, 486702, 486710, 486725, 486726, 486730, 503577, 503586, 503587, 504997, 520985, 525396, 530040, 530836, 532431, 533079, 533210, 533930, 540943, 542379, 609924, 642686, 644985, 647666, 678483, 685638, 685643, 712695, 720770, 723994, 760915, 803343, 806158, 806197, 806201, 815342, 820797, 820980, 821068, 821471, 821583, 821610);

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
  201531
  282010
  364027
  384423
  384748
  387228
  387445
  391364
  393479
  394739
  394808
  395555
  395941
  396654
  399627
  401500
  401742
  401780
  405024
  417476
  421530
  445536
  445553
  448677
  448796
  448842
  452507
  453379
  454648
  464614
  475277
  486288
  486701
  486702
  486710
  486725
  486726
  486730
  503577
  503586
  503587
  504997
  520985
  525396
  530040
  530836
  532431
  533079
  533210
  533930
  540943
  542379
  609924
  642686
  644985
  647666
  678483
  685638
  685643
  712695
  720770
  723994
  760915
  803343
  806158
  806197
  806201
  815342
  820797
  820980
  821068
  821471
  821583
  821610
]

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 (201531, 282010, 364027, 384423, 384748, 387228, 387445, 391364, 393479, 394739, 394808, 395555, 395941, 396654, 399627, 401500, 401742, 401780, 405024, 417476, 421530, 445536, 445553, 448677, 448796, 448842, 452507, 453379, 454648, 464614, 475277, 486288, 486701, 486702, 486710, 486725, 486726, 486730, 503577, 503586, 503587, 504997, 520985, 525396, 530040, 530836, 532431, 533079, 533210, 533930, 540943, 542379, 609924, 642686, 644985, 647666, 678483, 685638, 685643, 712695, 720770, 723994, 760915, 803343, 806158, 806197, 806201, 815342, 820797, 820980, 821068, 821471, 821583, 821610);

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

[
  "kelsi"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'kelsi';

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

[
  "kelsi"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kelsi';

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 ?

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