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

[
  "public sex german"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'public sex german' 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
  549083
  520390
  593868
  554391
  583527
  521828
  494261
  478463
  466910
  420525
  484870
  456721
  594406
  606600
  443167
  482086
  506805
  469352
  588343
  619480
  625798
  587833
  599659
  569520
  600503
  526130
  459381
  415615
  432299
  455961
  457985
  554465
  461141
  478459
  605318
  606624
  453650
  383943
  443163
  603002
  419503
  509103
  587542
  428520
  594431
  520945
  482686
  630405
  512539
  526104
  606287
  473203
  522191
  416886
  551913
  387905
  480772
  523706
  466927
  509321
  624084
  428533
  401064
  483802
  491782
  395666
  428531
  584063
  583981
  518858
  486055
  603592
  529162
  618177
  504085
  521159
  528788
]

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 (549083, 520390, 593868, 554391, 583527, 521828, 494261, 478463, 466910, 420525, 484870, 456721, 594406, 606600, 443167, 482086, 506805, 469352, 588343, 619480, 625798, 587833, 599659, 569520, 600503, 526130, 459381, 415615, 432299, 455961, 457985, 554465, 461141, 478459, 605318, 606624, 453650, 383943, 443163, 603002, 419503, 509103, 587542, 428520, 594431, 520945, 482686, 630405, 512539, 526104, 606287, 473203, 522191, 416886, 551913, 387905, 480772, 523706, 466927, 509321, 624084, 428533, 401064, 483802, 491782, 395666, 428531, 584063, 583981, 518858, 486055, 603592, 529162, 618177, 504085, 521159, 528788);

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
  383943
  387905
  395666
  401064
  415615
  416886
  419503
  420525
  428520
  428531
  428533
  432299
  443163
  443167
  453650
  455961
  456721
  457985
  459381
  461141
  466910
  466927
  469352
  473203
  478459
  478463
  480772
  482086
  482686
  483802
  484870
  486055
  491782
  494261
  504085
  506805
  509103
  509321
  512539
  518858
  520390
  520945
  521159
  521828
  522191
  523706
  526104
  526130
  528788
  529162
  549083
  551913
  554391
  554465
  569520
  583527
  583981
  584063
  587542
  587833
  588343
  593868
  594406
  594431
  599659
  600503
  603002
  603592
  605318
  606287
  606600
  606624
  618177
  619480
  624084
  625798
  630405
]

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 (383943, 387905, 395666, 401064, 415615, 416886, 419503, 420525, 428520, 428531, 428533, 432299, 443163, 443167, 453650, 455961, 456721, 457985, 459381, 461141, 466910, 466927, 469352, 473203, 478459, 478463, 480772, 482086, 482686, 483802, 484870, 486055, 491782, 494261, 504085, 506805, 509103, 509321, 512539, 518858, 520390, 520945, 521159, 521828, 522191, 523706, 526104, 526130, 528788, 529162, 549083, 551913, 554391, 554465, 569520, 583527, 583981, 584063, 587542, 587833, 588343, 593868, 594406, 594431, 599659, 600503, 603002, 603592, 605318, 606287, 606600, 606624, 618177, 619480, 624084, 625798, 630405);

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
  383943
  387905
  395666
  401064
  415615
  416886
  419503
  420525
  428520
  428531
  428533
  432299
  443163
  443167
  453650
  455961
  456721
  457985
  459381
  461141
  466910
  466927
  469352
  473203
  478459
  478463
  480772
  482086
  482686
  483802
  484870
  486055
  491782
  494261
  504085
  506805
  509103
  509321
  512539
  518858
  520390
  520945
  521159
  521828
  522191
  523706
  526104
  526130
  528788
  529162
  549083
  551913
  554391
  554465
  569520
  583527
  583981
  584063
  587542
  587833
  588343
  593868
  594406
  594431
  599659
  600503
  603002
  603592
  605318
  606287
  606600
  606624
  618177
  619480
  624084
  625798
  630405
]

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 (383943, 387905, 395666, 401064, 415615, 416886, 419503, 420525, 428520, 428531, 428533, 432299, 443163, 443167, 453650, 455961, 456721, 457985, 459381, 461141, 466910, 466927, 469352, 473203, 478459, 478463, 480772, 482086, 482686, 483802, 484870, 486055, 491782, 494261, 504085, 506805, 509103, 509321, 512539, 518858, 520390, 520945, 521159, 521828, 522191, 523706, 526104, 526130, 528788, 529162, 549083, 551913, 554391, 554465, 569520, 583527, 583981, 584063, 587542, 587833, 588343, 593868, 594406, 594431, 599659, 600503, 603002, 603592, 605318, 606287, 606600, 606624, 618177, 619480, 624084, 625798, 630405);

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

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

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

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

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

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

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

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