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

[
  "amateur xhamster"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur xhamster' 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
  388708
  386695
  391324
  390947
  387424
  389295
  387886
  390827
  388962
  3727
  389883
  387455
  388036
  386774
  390454
  389234
  752319
  738148
  810857
  742688
  740687
  634912
  629637
  740770
  736427
  726293
  812166
  738160
  726246
  814283
  740755
  584017
  736189
  753118
  733560
  800047
  733228
  391356
  461860
  716965
  628632
  761094
  282465
  387722
  813751
  390928
  390730
  388031
  392117
  390949
  387868
  390838
  670960
  9938
  387346
  391115
  386731
  387347
  389541
  389935
  583575
  461873
  460714
  599536
  389757
  390497
  390956
  391150
  465173
  391455
  482825
  387682
]

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 (388708, 386695, 391324, 390947, 387424, 389295, 387886, 390827, 388962, 3727, 389883, 387455, 388036, 386774, 390454, 389234, 752319, 738148, 810857, 742688, 740687, 634912, 629637, 740770, 736427, 726293, 812166, 738160, 726246, 814283, 740755, 584017, 736189, 753118, 733560, 800047, 733228, 391356, 461860, 716965, 628632, 761094, 282465, 387722, 813751, 390928, 390730, 388031, 392117, 390949, 387868, 390838, 670960, 9938, 387346, 391115, 386731, 387347, 389541, 389935, 583575, 461873, 460714, 599536, 389757, 390497, 390956, 391150, 465173, 391455, 482825, 387682);

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
  9938
  282465
  386695
  386731
  386774
  387346
  387347
  387424
  387455
  387682
  387722
  387868
  387886
  388031
  388036
  388708
  388962
  389234
  389295
  389541
  389757
  389883
  389935
  390454
  390497
  390730
  390827
  390838
  390928
  390947
  390949
  390956
  391115
  391150
  391324
  391356
  391455
  392117
  460714
  461860
  461873
  465173
  482825
  583575
  584017
  599536
  628632
  629637
  634912
  670960
  716965
  726246
  726293
  733228
  733560
  736189
  736427
  738148
  738160
  740687
  740755
  740770
  742688
  752319
  753118
  761094
  800047
  810857
  812166
  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, 9938, 282465, 386695, 386731, 386774, 387346, 387347, 387424, 387455, 387682, 387722, 387868, 387886, 388031, 388036, 388708, 388962, 389234, 389295, 389541, 389757, 389883, 389935, 390454, 390497, 390730, 390827, 390838, 390928, 390947, 390949, 390956, 391115, 391150, 391324, 391356, 391455, 392117, 460714, 461860, 461873, 465173, 482825, 583575, 584017, 599536, 628632, 629637, 634912, 670960, 716965, 726246, 726293, 733228, 733560, 736189, 736427, 738148, 738160, 740687, 740755, 740770, 742688, 752319, 753118, 761094, 800047, 810857, 812166, 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
  9938
  282465
  386695
  386731
  386774
  387346
  387347
  387424
  387455
  387682
  387722
  387868
  387886
  388031
  388036
  388708
  388962
  389234
  389295
  389541
  389757
  389883
  389935
  390454
  390497
  390730
  390827
  390838
  390928
  390947
  390949
  390956
  391115
  391150
  391324
  391356
  391455
  392117
  460714
  461860
  461873
  465173
  482825
  583575
  584017
  599536
  628632
  629637
  634912
  670960
  716965
  726246
  726293
  733228
  733560
  736189
  736427
  738148
  738160
  740687
  740755
  740770
  742688
  752319
  753118
  761094
  800047
  810857
  812166
  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, 9938, 282465, 386695, 386731, 386774, 387346, 387347, 387424, 387455, 387682, 387722, 387868, 387886, 388031, 388036, 388708, 388962, 389234, 389295, 389541, 389757, 389883, 389935, 390454, 390497, 390730, 390827, 390838, 390928, 390947, 390949, 390956, 391115, 391150, 391324, 391356, 391455, 392117, 460714, 461860, 461873, 465173, 482825, 583575, 584017, 599536, 628632, 629637, 634912, 670960, 716965, 726246, 726293, 733228, 733560, 736189, 736427, 738148, 738160, 740687, 740755, 740770, 742688, 752319, 753118, 761094, 800047, 810857, 812166, 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 ?

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