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

[
  "fresh girls"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fresh girls' 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
  389089
  393737
  661943
  618680
  577358
  580739
  469620
  523648
  597014
  648218
  607002
  790843
  439062
  777345
  654936
  597568
  758024
  388202
  583985
  548392
  564361
  585316
  560427
  566297
  428241
  566521
  550441
  576024
  464678
  491629
  524596
  549813
  569994
  588647
  611006
  502500
  577351
  574579
  501831
  492380
  468536
  491556
  422519
  567670
  569660
  495269
  522395
  690932
  623494
  623613
  461359
  463965
  524064
  466481
  466779
  491354
  464330
  576701
  523307
  567605
  519638
  519010
  516744
  598592
  504854
  504481
  597975
  620995
  506801
  576286
  576717
  507177
]

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 (389089, 393737, 661943, 618680, 577358, 580739, 469620, 523648, 597014, 648218, 607002, 790843, 439062, 777345, 654936, 597568, 758024, 388202, 583985, 548392, 564361, 585316, 560427, 566297, 428241, 566521, 550441, 576024, 464678, 491629, 524596, 549813, 569994, 588647, 611006, 502500, 577351, 574579, 501831, 492380, 468536, 491556, 422519, 567670, 569660, 495269, 522395, 690932, 623494, 623613, 461359, 463965, 524064, 466481, 466779, 491354, 464330, 576701, 523307, 567605, 519638, 519010, 516744, 598592, 504854, 504481, 597975, 620995, 506801, 576286, 576717, 507177);

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
  388202
  389089
  393737
  422519
  428241
  439062
  461359
  463965
  464330
  464678
  466481
  466779
  468536
  469620
  491354
  491556
  491629
  492380
  495269
  501831
  502500
  504481
  504854
  506801
  507177
  516744
  519010
  519638
  522395
  523307
  523648
  524064
  524596
  548392
  549813
  550441
  560427
  564361
  566297
  566521
  567605
  567670
  569660
  569994
  574579
  576024
  576286
  576701
  576717
  577351
  577358
  580739
  583985
  585316
  588647
  597014
  597568
  597975
  598592
  607002
  611006
  618680
  620995
  623494
  623613
  648218
  654936
  661943
  690932
  758024
  777345
  790843
]

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 (388202, 389089, 393737, 422519, 428241, 439062, 461359, 463965, 464330, 464678, 466481, 466779, 468536, 469620, 491354, 491556, 491629, 492380, 495269, 501831, 502500, 504481, 504854, 506801, 507177, 516744, 519010, 519638, 522395, 523307, 523648, 524064, 524596, 548392, 549813, 550441, 560427, 564361, 566297, 566521, 567605, 567670, 569660, 569994, 574579, 576024, 576286, 576701, 576717, 577351, 577358, 580739, 583985, 585316, 588647, 597014, 597568, 597975, 598592, 607002, 611006, 618680, 620995, 623494, 623613, 648218, 654936, 661943, 690932, 758024, 777345, 790843);

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
  388202
  389089
  393737
  422519
  428241
  439062
  461359
  463965
  464330
  464678
  466481
  466779
  468536
  469620
  491354
  491556
  491629
  492380
  495269
  501831
  502500
  504481
  504854
  506801
  507177
  516744
  519010
  519638
  522395
  523307
  523648
  524064
  524596
  548392
  549813
  550441
  560427
  564361
  566297
  566521
  567605
  567670
  569660
  569994
  574579
  576024
  576286
  576701
  576717
  577351
  577358
  580739
  583985
  585316
  588647
  597014
  597568
  597975
  598592
  607002
  611006
  618680
  620995
  623494
  623613
  648218
  654936
  661943
  690932
  758024
  777345
  790843
]

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 (388202, 389089, 393737, 422519, 428241, 439062, 461359, 463965, 464330, 464678, 466481, 466779, 468536, 469620, 491354, 491556, 491629, 492380, 495269, 501831, 502500, 504481, 504854, 506801, 507177, 516744, 519010, 519638, 522395, 523307, 523648, 524064, 524596, 548392, 549813, 550441, 560427, 564361, 566297, 566521, 567605, 567670, 569660, 569994, 574579, 576024, 576286, 576701, 576717, 577351, 577358, 580739, 583985, 585316, 588647, 597014, 597568, 597975, 598592, 607002, 611006, 618680, 620995, 623494, 623613, 648218, 654936, 661943, 690932, 758024, 777345, 790843);

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

[
  "fresh девушк"
]

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

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

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

[
  "fresh девушк"
]

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

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

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 ?

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