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

[
  "interracial blacked"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'interracial blacked' 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
  423708
  423339
  482793
  448864
  466340
  460799
  604595
  636593
  732574
  399388
  445514
  463262
  402092
  471723
  395406
  395446
  391541
  398154
  399355
  399414
  416069
  445321
  464146
  500431
  488623
  485110
  498594
  527452
  399395
  387766
  437526
  419854
  429729
  435624
  421557
  463073
  563992
  562128
  573304
  582012
  569457
  605557
  429424
  420345
  417390
  517849
  528831
  510270
  413944
  417889
  532779
  530789
  396742
  480439
  495734
  518493
  532343
  506143
  557526
  614621
  586651
  460706
  434001
  417482
  399300
  418363
  399717
  495752
  525864
  603258
  620203
  580280
  518438
  609922
  604478
  605521
  562108
]

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 (423708, 423339, 482793, 448864, 466340, 460799, 604595, 636593, 732574, 399388, 445514, 463262, 402092, 471723, 395406, 395446, 391541, 398154, 399355, 399414, 416069, 445321, 464146, 500431, 488623, 485110, 498594, 527452, 399395, 387766, 437526, 419854, 429729, 435624, 421557, 463073, 563992, 562128, 573304, 582012, 569457, 605557, 429424, 420345, 417390, 517849, 528831, 510270, 413944, 417889, 532779, 530789, 396742, 480439, 495734, 518493, 532343, 506143, 557526, 614621, 586651, 460706, 434001, 417482, 399300, 418363, 399717, 495752, 525864, 603258, 620203, 580280, 518438, 609922, 604478, 605521, 562108);

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
  387766
  391541
  395406
  395446
  396742
  398154
  399300
  399355
  399388
  399395
  399414
  399717
  402092
  413944
  416069
  417390
  417482
  417889
  418363
  419854
  420345
  421557
  423339
  423708
  429424
  429729
  434001
  435624
  437526
  445321
  445514
  448864
  460706
  460799
  463073
  463262
  464146
  466340
  471723
  480439
  482793
  485110
  488623
  495734
  495752
  498594
  500431
  506143
  510270
  517849
  518438
  518493
  525864
  527452
  528831
  530789
  532343
  532779
  557526
  562108
  562128
  563992
  569457
  573304
  580280
  582012
  586651
  603258
  604478
  604595
  605521
  605557
  609922
  614621
  620203
  636593
  732574
]

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 (387766, 391541, 395406, 395446, 396742, 398154, 399300, 399355, 399388, 399395, 399414, 399717, 402092, 413944, 416069, 417390, 417482, 417889, 418363, 419854, 420345, 421557, 423339, 423708, 429424, 429729, 434001, 435624, 437526, 445321, 445514, 448864, 460706, 460799, 463073, 463262, 464146, 466340, 471723, 480439, 482793, 485110, 488623, 495734, 495752, 498594, 500431, 506143, 510270, 517849, 518438, 518493, 525864, 527452, 528831, 530789, 532343, 532779, 557526, 562108, 562128, 563992, 569457, 573304, 580280, 582012, 586651, 603258, 604478, 604595, 605521, 605557, 609922, 614621, 620203, 636593, 732574);

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
  387766
  391541
  395406
  395446
  396742
  398154
  399300
  399355
  399388
  399395
  399414
  399717
  402092
  413944
  416069
  417390
  417482
  417889
  418363
  419854
  420345
  421557
  423339
  423708
  429424
  429729
  434001
  435624
  437526
  445321
  445514
  448864
  460706
  460799
  463073
  463262
  464146
  466340
  471723
  480439
  482793
  485110
  488623
  495734
  495752
  498594
  500431
  506143
  510270
  517849
  518438
  518493
  525864
  527452
  528831
  530789
  532343
  532779
  557526
  562108
  562128
  563992
  569457
  573304
  580280
  582012
  586651
  603258
  604478
  604595
  605521
  605557
  609922
  614621
  620203
  636593
  732574
]

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 (387766, 391541, 395406, 395446, 396742, 398154, 399300, 399355, 399388, 399395, 399414, 399717, 402092, 413944, 416069, 417390, 417482, 417889, 418363, 419854, 420345, 421557, 423339, 423708, 429424, 429729, 434001, 435624, 437526, 445321, 445514, 448864, 460706, 460799, 463073, 463262, 464146, 466340, 471723, 480439, 482793, 485110, 488623, 495734, 495752, 498594, 500431, 506143, 510270, 517849, 518438, 518493, 525864, 527452, 528831, 530789, 532343, 532779, 557526, 562108, 562128, 563992, 569457, 573304, 580280, 582012, 586651, 603258, 604478, 604595, 605521, 605557, 609922, 614621, 620203, 636593, 732574);

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

[
  "межрасов blacked"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'межрасов blacked';

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

[
  "межрасов blacked"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'межрасов blacked';