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

[
  "bimbo girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bimbo girl' 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
  571729
  788908
  651676
  713456
  597548
  561039
  802972
  807121
  724223
  382318
  348358
  465629
  721423
  675230
  381949
  696529
  396676
  465612
  725934
  819086
  596625
  670896
  559889
  465638
  556294
  785349
  399174
  788915
  459511
  551251
  609877
  591730
  600050
  465685
  465673
  573515
  591531
  798622
  419725
  480210
  540019
  677352
  783999
  401614
  383162
  400425
  385077
  402259
  474581
  529186
  677342
  598536
  599457
  472337
  807219
  427929
  422933
  597472
  422710
  498555
  537481
  550634
  465665
  468153
  583608
  502923
  475183
  579633
  456441
  597516
  542533
  432936
  494492
]

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 (571729, 788908, 651676, 713456, 597548, 561039, 802972, 807121, 724223, 382318, 348358, 465629, 721423, 675230, 381949, 696529, 396676, 465612, 725934, 819086, 596625, 670896, 559889, 465638, 556294, 785349, 399174, 788915, 459511, 551251, 609877, 591730, 600050, 465685, 465673, 573515, 591531, 798622, 419725, 480210, 540019, 677352, 783999, 401614, 383162, 400425, 385077, 402259, 474581, 529186, 677342, 598536, 599457, 472337, 807219, 427929, 422933, 597472, 422710, 498555, 537481, 550634, 465665, 468153, 583608, 502923, 475183, 579633, 456441, 597516, 542533, 432936, 494492);

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
  348358
  381949
  382318
  383162
  385077
  396676
  399174
  400425
  401614
  402259
  419725
  422710
  422933
  427929
  432936
  456441
  459511
  465612
  465629
  465638
  465665
  465673
  465685
  468153
  472337
  474581
  475183
  480210
  494492
  498555
  502923
  529186
  537481
  540019
  542533
  550634
  551251
  556294
  559889
  561039
  571729
  573515
  579633
  583608
  591531
  591730
  596625
  597472
  597516
  597548
  598536
  599457
  600050
  609877
  651676
  670896
  675230
  677342
  677352
  696529
  713456
  721423
  724223
  725934
  783999
  785349
  788908
  788915
  798622
  802972
  807121
  807219
  819086
]

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 (348358, 381949, 382318, 383162, 385077, 396676, 399174, 400425, 401614, 402259, 419725, 422710, 422933, 427929, 432936, 456441, 459511, 465612, 465629, 465638, 465665, 465673, 465685, 468153, 472337, 474581, 475183, 480210, 494492, 498555, 502923, 529186, 537481, 540019, 542533, 550634, 551251, 556294, 559889, 561039, 571729, 573515, 579633, 583608, 591531, 591730, 596625, 597472, 597516, 597548, 598536, 599457, 600050, 609877, 651676, 670896, 675230, 677342, 677352, 696529, 713456, 721423, 724223, 725934, 783999, 785349, 788908, 788915, 798622, 802972, 807121, 807219, 819086);

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
  348358
  381949
  382318
  383162
  385077
  396676
  399174
  400425
  401614
  402259
  419725
  422710
  422933
  427929
  432936
  456441
  459511
  465612
  465629
  465638
  465665
  465673
  465685
  468153
  472337
  474581
  475183
  480210
  494492
  498555
  502923
  529186
  537481
  540019
  542533
  550634
  551251
  556294
  559889
  561039
  571729
  573515
  579633
  583608
  591531
  591730
  596625
  597472
  597516
  597548
  598536
  599457
  600050
  609877
  651676
  670896
  675230
  677342
  677352
  696529
  713456
  721423
  724223
  725934
  783999
  785349
  788908
  788915
  798622
  802972
  807121
  807219
  819086
]

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 (348358, 381949, 382318, 383162, 385077, 396676, 399174, 400425, 401614, 402259, 419725, 422710, 422933, 427929, 432936, 456441, 459511, 465612, 465629, 465638, 465665, 465673, 465685, 468153, 472337, 474581, 475183, 480210, 494492, 498555, 502923, 529186, 537481, 540019, 542533, 550634, 551251, 556294, 559889, 561039, 571729, 573515, 579633, 583608, 591531, 591730, 596625, 597472, 597516, 597548, 598536, 599457, 600050, 609877, 651676, 670896, 675230, 677342, 677352, 696529, 713456, 721423, 724223, 725934, 783999, 785349, 788908, 788915, 798622, 802972, 807121, 807219, 819086);

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

[
  "bimbo девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bimbo девушк';

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

[
  "bimbo девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bimbo девушк';

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 ?

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