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

[
  "voyeur public sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'voyeur public 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
  533992
  541091
  683300
  446264
  471174
  484246
  469238
  459161
  457767
  510717
  469233
  581020
  509544
  477364
  446553
  457668
  469227
  464295
  739701
  335472
  518156
  553205
  627846
  534363
  519818
  519811
  543575
  581599
  472656
  519812
  518151
  704533
  446550
  456844
  469242
  482923
  555979
  384491
  486820
  452578
  495035
  474782
  584019
  571828
  557978
  555983
  569561
  535960
  579419
  561125
  511492
  516723
  581203
  457770
  474783
  603636
  477353
  491637
  475330
  483473
  482778
  571199
  537815
  518160
  562423
  619398
  516819
  488585
  459171
  551053
  477355
  585079
  447096
]

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 (533992, 541091, 683300, 446264, 471174, 484246, 469238, 459161, 457767, 510717, 469233, 581020, 509544, 477364, 446553, 457668, 469227, 464295, 739701, 335472, 518156, 553205, 627846, 534363, 519818, 519811, 543575, 581599, 472656, 519812, 518151, 704533, 446550, 456844, 469242, 482923, 555979, 384491, 486820, 452578, 495035, 474782, 584019, 571828, 557978, 555983, 569561, 535960, 579419, 561125, 511492, 516723, 581203, 457770, 474783, 603636, 477353, 491637, 475330, 483473, 482778, 571199, 537815, 518160, 562423, 619398, 516819, 488585, 459171, 551053, 477355, 585079, 447096);

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
  335472
  384491
  446264
  446550
  446553
  447096
  452578
  456844
  457668
  457767
  457770
  459161
  459171
  464295
  469227
  469233
  469238
  469242
  471174
  472656
  474782
  474783
  475330
  477353
  477355
  477364
  482778
  482923
  483473
  484246
  486820
  488585
  491637
  495035
  509544
  510717
  511492
  516723
  516819
  518151
  518156
  518160
  519811
  519812
  519818
  533992
  534363
  535960
  537815
  541091
  543575
  551053
  553205
  555979
  555983
  557978
  561125
  562423
  569561
  571199
  571828
  579419
  581020
  581203
  581599
  584019
  585079
  603636
  619398
  627846
  683300
  704533
  739701
]

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 (335472, 384491, 446264, 446550, 446553, 447096, 452578, 456844, 457668, 457767, 457770, 459161, 459171, 464295, 469227, 469233, 469238, 469242, 471174, 472656, 474782, 474783, 475330, 477353, 477355, 477364, 482778, 482923, 483473, 484246, 486820, 488585, 491637, 495035, 509544, 510717, 511492, 516723, 516819, 518151, 518156, 518160, 519811, 519812, 519818, 533992, 534363, 535960, 537815, 541091, 543575, 551053, 553205, 555979, 555983, 557978, 561125, 562423, 569561, 571199, 571828, 579419, 581020, 581203, 581599, 584019, 585079, 603636, 619398, 627846, 683300, 704533, 739701);

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
  335472
  384491
  446264
  446550
  446553
  447096
  452578
  456844
  457668
  457767
  457770
  459161
  459171
  464295
  469227
  469233
  469238
  469242
  471174
  472656
  474782
  474783
  475330
  477353
  477355
  477364
  482778
  482923
  483473
  484246
  486820
  488585
  491637
  495035
  509544
  510717
  511492
  516723
  516819
  518151
  518156
  518160
  519811
  519812
  519818
  533992
  534363
  535960
  537815
  541091
  543575
  551053
  553205
  555979
  555983
  557978
  561125
  562423
  569561
  571199
  571828
  579419
  581020
  581203
  581599
  584019
  585079
  603636
  619398
  627846
  683300
  704533
  739701
]

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 (335472, 384491, 446264, 446550, 446553, 447096, 452578, 456844, 457668, 457767, 457770, 459161, 459171, 464295, 469227, 469233, 469238, 469242, 471174, 472656, 474782, 474783, 475330, 477353, 477355, 477364, 482778, 482923, 483473, 484246, 486820, 488585, 491637, 495035, 509544, 510717, 511492, 516723, 516819, 518151, 518156, 518160, 519811, 519812, 519818, 533992, 534363, 535960, 537815, 541091, 543575, 551053, 553205, 555979, 555983, 557978, 561125, 562423, 569561, 571199, 571828, 579419, 581020, 581203, 581599, 584019, 585079, 603636, 619398, 627846, 683300, 704533, 739701);

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

[
  "voyeur на улиц секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'voyeur на улиц секс';

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

[
  "voyeur на улиц секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'voyeur на улиц секс';

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 ?

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