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

[
  "xhamster sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'xhamster sex' 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
  753118
  387346
  738783
  738148
  740687
  634912
  726293
  740770
  814283
  726246
  584017
  390947
  740755
  736189
  733560
  733228
  391356
  800047
  461860
  716965
  628632
  761094
  386695
  387722
  386774
  282465
  391324
  813751
  388031
  392117
  387424
  389585
  389295
  390838
  390827
  387868
  387773
  387823
  670960
  386731
  388962
  454970
  389541
  390941
  391115
  3727
  390487
  388333
  387350
  388066
  389391
  387380
  387455
  389234
  391224
  390454
  583575
  390497
  391455
  388036
  390956
  391448
  389757
  465173
  389987
  386929
  387682
  388713
  482825
  390924
  390929
  391450
  386913
]

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 (753118, 387346, 738783, 738148, 740687, 634912, 726293, 740770, 814283, 726246, 584017, 390947, 740755, 736189, 733560, 733228, 391356, 800047, 461860, 716965, 628632, 761094, 386695, 387722, 386774, 282465, 391324, 813751, 388031, 392117, 387424, 389585, 389295, 390838, 390827, 387868, 387773, 387823, 670960, 386731, 388962, 454970, 389541, 390941, 391115, 3727, 390487, 388333, 387350, 388066, 389391, 387380, 387455, 389234, 391224, 390454, 583575, 390497, 391455, 388036, 390956, 391448, 389757, 465173, 389987, 386929, 387682, 388713, 482825, 390924, 390929, 391450, 386913);

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
  3727
  282465
  386695
  386731
  386774
  386913
  386929
  387346
  387350
  387380
  387424
  387455
  387682
  387722
  387773
  387823
  387868
  388031
  388036
  388066
  388333
  388713
  388962
  389234
  389295
  389391
  389541
  389585
  389757
  389987
  390454
  390487
  390497
  390827
  390838
  390924
  390929
  390941
  390947
  390956
  391115
  391224
  391324
  391356
  391448
  391450
  391455
  392117
  454970
  461860
  465173
  482825
  583575
  584017
  628632
  634912
  670960
  716965
  726246
  726293
  733228
  733560
  736189
  738148
  738783
  740687
  740755
  740770
  753118
  761094
  800047
  813751
  814283
]

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 (3727, 282465, 386695, 386731, 386774, 386913, 386929, 387346, 387350, 387380, 387424, 387455, 387682, 387722, 387773, 387823, 387868, 388031, 388036, 388066, 388333, 388713, 388962, 389234, 389295, 389391, 389541, 389585, 389757, 389987, 390454, 390487, 390497, 390827, 390838, 390924, 390929, 390941, 390947, 390956, 391115, 391224, 391324, 391356, 391448, 391450, 391455, 392117, 454970, 461860, 465173, 482825, 583575, 584017, 628632, 634912, 670960, 716965, 726246, 726293, 733228, 733560, 736189, 738148, 738783, 740687, 740755, 740770, 753118, 761094, 800047, 813751, 814283);

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
  3727
  282465
  386695
  386731
  386774
  386913
  386929
  387346
  387350
  387380
  387424
  387455
  387682
  387722
  387773
  387823
  387868
  388031
  388036
  388066
  388333
  388713
  388962
  389234
  389295
  389391
  389541
  389585
  389757
  389987
  390454
  390487
  390497
  390827
  390838
  390924
  390929
  390941
  390947
  390956
  391115
  391224
  391324
  391356
  391448
  391450
  391455
  392117
  454970
  461860
  465173
  482825
  583575
  584017
  628632
  634912
  670960
  716965
  726246
  726293
  733228
  733560
  736189
  738148
  738783
  740687
  740755
  740770
  753118
  761094
  800047
  813751
  814283
]

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 (3727, 282465, 386695, 386731, 386774, 386913, 386929, 387346, 387350, 387380, 387424, 387455, 387682, 387722, 387773, 387823, 387868, 388031, 388036, 388066, 388333, 388713, 388962, 389234, 389295, 389391, 389541, 389585, 389757, 389987, 390454, 390487, 390497, 390827, 390838, 390924, 390929, 390941, 390947, 390956, 391115, 391224, 391324, 391356, 391448, 391450, 391455, 392117, 454970, 461860, 465173, 482825, 583575, 584017, 628632, 634912, 670960, 716965, 726246, 726293, 733228, 733560, 736189, 738148, 738783, 740687, 740755, 740770, 753118, 761094, 800047, 813751, 814283);

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

[
  "xhamster секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'xhamster секс';

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

[
  "xhamster секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'xhamster секс';

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 ?

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