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

[
  "bounce ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bounce ass' 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
  606524
  822679
  398632
  823242
  781937
  532783
  532989
  532408
  810270
  580407
  693036
  547189
  530300
  717202
  826237
  532306
  640667
  756528
  595638
  821543
  530409
  595147
  634702
  736571
  815447
  419308
  697440
  651373
  728939
  396374
  598117
  575870
  21323
  397621
  439098
  559074
  711982
  789468
  813386
  735392
  480191
  695146
  431794
  478812
  501702
  760409
  766402
  256218
  812704
  746774
  433278
  534313
  560180
  560174
  517182
  599412
  503056
  444820
  416118
  695184
  596063
  516601
  580286
  401880
  414218
  462488
  499802
  581720
  486870
  646450
  529958
  447952
  604517
  613014
]

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 (606524, 822679, 398632, 823242, 781937, 532783, 532989, 532408, 810270, 580407, 693036, 547189, 530300, 717202, 826237, 532306, 640667, 756528, 595638, 821543, 530409, 595147, 634702, 736571, 815447, 419308, 697440, 651373, 728939, 396374, 598117, 575870, 21323, 397621, 439098, 559074, 711982, 789468, 813386, 735392, 480191, 695146, 431794, 478812, 501702, 760409, 766402, 256218, 812704, 746774, 433278, 534313, 560180, 560174, 517182, 599412, 503056, 444820, 416118, 695184, 596063, 516601, 580286, 401880, 414218, 462488, 499802, 581720, 486870, 646450, 529958, 447952, 604517, 613014);

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
  21323
  256218
  396374
  397621
  398632
  401880
  414218
  416118
  419308
  431794
  433278
  439098
  444820
  447952
  462488
  478812
  480191
  486870
  499802
  501702
  503056
  516601
  517182
  529958
  530300
  530409
  532306
  532408
  532783
  532989
  534313
  547189
  559074
  560174
  560180
  575870
  580286
  580407
  581720
  595147
  595638
  596063
  598117
  599412
  604517
  606524
  613014
  634702
  640667
  646450
  651373
  693036
  695146
  695184
  697440
  711982
  717202
  728939
  735392
  736571
  746774
  756528
  760409
  766402
  781937
  789468
  810270
  812704
  813386
  815447
  821543
  822679
  823242
  826237
]

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 (21323, 256218, 396374, 397621, 398632, 401880, 414218, 416118, 419308, 431794, 433278, 439098, 444820, 447952, 462488, 478812, 480191, 486870, 499802, 501702, 503056, 516601, 517182, 529958, 530300, 530409, 532306, 532408, 532783, 532989, 534313, 547189, 559074, 560174, 560180, 575870, 580286, 580407, 581720, 595147, 595638, 596063, 598117, 599412, 604517, 606524, 613014, 634702, 640667, 646450, 651373, 693036, 695146, 695184, 697440, 711982, 717202, 728939, 735392, 736571, 746774, 756528, 760409, 766402, 781937, 789468, 810270, 812704, 813386, 815447, 821543, 822679, 823242, 826237);

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
  21323
  256218
  396374
  397621
  398632
  401880
  414218
  416118
  419308
  431794
  433278
  439098
  444820
  447952
  462488
  478812
  480191
  486870
  499802
  501702
  503056
  516601
  517182
  529958
  530300
  530409
  532306
  532408
  532783
  532989
  534313
  547189
  559074
  560174
  560180
  575870
  580286
  580407
  581720
  595147
  595638
  596063
  598117
  599412
  604517
  606524
  613014
  634702
  640667
  646450
  651373
  693036
  695146
  695184
  697440
  711982
  717202
  728939
  735392
  736571
  746774
  756528
  760409
  766402
  781937
  789468
  810270
  812704
  813386
  815447
  821543
  822679
  823242
  826237
]

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 (21323, 256218, 396374, 397621, 398632, 401880, 414218, 416118, 419308, 431794, 433278, 439098, 444820, 447952, 462488, 478812, 480191, 486870, 499802, 501702, 503056, 516601, 517182, 529958, 530300, 530409, 532306, 532408, 532783, 532989, 534313, 547189, 559074, 560174, 560180, 575870, 580286, 580407, 581720, 595147, 595638, 596063, 598117, 599412, 604517, 606524, 613014, 634702, 640667, 646450, 651373, 693036, 695146, 695184, 697440, 711982, 717202, 728939, 735392, 736571, 746774, 756528, 760409, 766402, 781937, 789468, 810270, 812704, 813386, 815447, 821543, 822679, 823242, 826237);

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

[
  "bounce жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bounce жоп';

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

[
  "bounce жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bounce жоп';

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 ?

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