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

[
  "негр кончает в бабу"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'негр кончает в бабу' 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
  451983
  429775
  432115
  452109
  564078
  417897
  414075
  451970
  465698
  464651
  401842
  465608
  405061
  520405
  421289
  460328
  457078
  461714
  494621
  589060
  429768
  425118
  416975
  449933
  552643
  406308
  307940
  497452
  429088
  430504
  411681
  500551
  412189
  447884
  448823
  382355
  512453
  524193
  613836
  415936
  572027
  620493
  524208
  598026
  446167
  443099
  451620
  558626
  552253
  523816
  535631
  495217
  479709
  499111
  414651
  414357
  420192
  457165
  605374
  612256
  506143
  495273
  467611
  554392
  496033
  492064
  609922
  417801
  541833
]

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 (451983, 429775, 432115, 452109, 564078, 417897, 414075, 451970, 465698, 464651, 401842, 465608, 405061, 520405, 421289, 460328, 457078, 461714, 494621, 589060, 429768, 425118, 416975, 449933, 552643, 406308, 307940, 497452, 429088, 430504, 411681, 500551, 412189, 447884, 448823, 382355, 512453, 524193, 613836, 415936, 572027, 620493, 524208, 598026, 446167, 443099, 451620, 558626, 552253, 523816, 535631, 495217, 479709, 499111, 414651, 414357, 420192, 457165, 605374, 612256, 506143, 495273, 467611, 554392, 496033, 492064, 609922, 417801, 541833);

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
  307940
  382355
  401842
  405061
  406308
  411681
  412189
  414075
  414357
  414651
  415936
  416975
  417801
  417897
  420192
  421289
  425118
  429088
  429768
  429775
  430504
  432115
  443099
  446167
  447884
  448823
  449933
  451620
  451970
  451983
  452109
  457078
  457165
  460328
  461714
  464651
  465608
  465698
  467611
  479709
  492064
  494621
  495217
  495273
  496033
  497452
  499111
  500551
  506143
  512453
  520405
  523816
  524193
  524208
  535631
  541833
  552253
  552643
  554392
  558626
  564078
  572027
  589060
  598026
  605374
  609922
  612256
  613836
  620493
]

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 (307940, 382355, 401842, 405061, 406308, 411681, 412189, 414075, 414357, 414651, 415936, 416975, 417801, 417897, 420192, 421289, 425118, 429088, 429768, 429775, 430504, 432115, 443099, 446167, 447884, 448823, 449933, 451620, 451970, 451983, 452109, 457078, 457165, 460328, 461714, 464651, 465608, 465698, 467611, 479709, 492064, 494621, 495217, 495273, 496033, 497452, 499111, 500551, 506143, 512453, 520405, 523816, 524193, 524208, 535631, 541833, 552253, 552643, 554392, 558626, 564078, 572027, 589060, 598026, 605374, 609922, 612256, 613836, 620493);

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
  307940
  382355
  401842
  405061
  406308
  411681
  412189
  414075
  414357
  414651
  415936
  416975
  417801
  417897
  420192
  421289
  425118
  429088
  429768
  429775
  430504
  432115
  443099
  446167
  447884
  448823
  449933
  451620
  451970
  451983
  452109
  457078
  457165
  460328
  461714
  464651
  465608
  465698
  467611
  479709
  492064
  494621
  495217
  495273
  496033
  497452
  499111
  500551
  506143
  512453
  520405
  523816
  524193
  524208
  535631
  541833
  552253
  552643
  554392
  558626
  564078
  572027
  589060
  598026
  605374
  609922
  612256
  613836
  620493
]

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 (307940, 382355, 401842, 405061, 406308, 411681, 412189, 414075, 414357, 414651, 415936, 416975, 417801, 417897, 420192, 421289, 425118, 429088, 429768, 429775, 430504, 432115, 443099, 446167, 447884, 448823, 449933, 451620, 451970, 451983, 452109, 457078, 457165, 460328, 461714, 464651, 465608, 465698, 467611, 479709, 492064, 494621, 495217, 495273, 496033, 497452, 499111, 500551, 506143, 512453, 520405, 523816, 524193, 524208, 535631, 541833, 552253, 552643, 554392, 558626, 564078, 572027, 589060, 598026, 605374, 609922, 612256, 613836, 620493);

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

[
  "чернокожий сперм в женскийрод"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'чернокожий сперм в женскийрод';

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

[
  "чернокожий сперм в женскийрод"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'чернокожий сперм в женскийрод';

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 ?

[
  "негр кончает в бабу"
  "негр кончает в бабу"
  "негр кончает в бабу"
  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 ('негр кончает в бабу') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('негр кончает в бабу')
              AND `query` <> 'негр кончает в бабу'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;