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

[
  "hairy anal compilation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy anal compilation' 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
  426294
  475684
  522914
  433295
  473722
  518594
  519246
  464935
  551991
  452404
  460289
  511816
  824362
  494233
  469198
  824164
  422049
  443090
  468955
  541884
  448811
  496086
  493163
  614023
  607355
  433669
  476244
  449425
  417801
  428103
  445641
  422926
  476123
  477744
  576704
  576713
  491209
  504399
  483544
  535282
  559453
  545801
  430314
  605521
  420291
  497888
  525393
  583913
  788776
  556535
  415109
  466982
  558788
  639824
  541651
  448863
  555317
  541633
  513025
  440625
  650380
  576710
  541643
  413461
  450274
  560086
  541667
  466989
  405921
  601324
  541671
  541588
  457963
  413454
  410959
  403141
]

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 (426294, 475684, 522914, 433295, 473722, 518594, 519246, 464935, 551991, 452404, 460289, 511816, 824362, 494233, 469198, 824164, 422049, 443090, 468955, 541884, 448811, 496086, 493163, 614023, 607355, 433669, 476244, 449425, 417801, 428103, 445641, 422926, 476123, 477744, 576704, 576713, 491209, 504399, 483544, 535282, 559453, 545801, 430314, 605521, 420291, 497888, 525393, 583913, 788776, 556535, 415109, 466982, 558788, 639824, 541651, 448863, 555317, 541633, 513025, 440625, 650380, 576710, 541643, 413461, 450274, 560086, 541667, 466989, 405921, 601324, 541671, 541588, 457963, 413454, 410959, 403141);

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
  403141
  405921
  410959
  413454
  413461
  415109
  417801
  420291
  422049
  422926
  426294
  428103
  430314
  433295
  433669
  440625
  443090
  445641
  448811
  448863
  449425
  450274
  452404
  457963
  460289
  464935
  466982
  466989
  468955
  469198
  473722
  475684
  476123
  476244
  477744
  483544
  491209
  493163
  494233
  496086
  497888
  504399
  511816
  513025
  518594
  519246
  522914
  525393
  535282
  541588
  541633
  541643
  541651
  541667
  541671
  541884
  545801
  551991
  555317
  556535
  558788
  559453
  560086
  576704
  576710
  576713
  583913
  601324
  605521
  607355
  614023
  639824
  650380
  788776
  824164
  824362
]

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 (403141, 405921, 410959, 413454, 413461, 415109, 417801, 420291, 422049, 422926, 426294, 428103, 430314, 433295, 433669, 440625, 443090, 445641, 448811, 448863, 449425, 450274, 452404, 457963, 460289, 464935, 466982, 466989, 468955, 469198, 473722, 475684, 476123, 476244, 477744, 483544, 491209, 493163, 494233, 496086, 497888, 504399, 511816, 513025, 518594, 519246, 522914, 525393, 535282, 541588, 541633, 541643, 541651, 541667, 541671, 541884, 545801, 551991, 555317, 556535, 558788, 559453, 560086, 576704, 576710, 576713, 583913, 601324, 605521, 607355, 614023, 639824, 650380, 788776, 824164, 824362);

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
  403141
  405921
  410959
  413454
  413461
  415109
  417801
  420291
  422049
  422926
  426294
  428103
  430314
  433295
  433669
  440625
  443090
  445641
  448811
  448863
  449425
  450274
  452404
  457963
  460289
  464935
  466982
  466989
  468955
  469198
  473722
  475684
  476123
  476244
  477744
  483544
  491209
  493163
  494233
  496086
  497888
  504399
  511816
  513025
  518594
  519246
  522914
  525393
  535282
  541588
  541633
  541643
  541651
  541667
  541671
  541884
  545801
  551991
  555317
  556535
  558788
  559453
  560086
  576704
  576710
  576713
  583913
  601324
  605521
  607355
  614023
  639824
  650380
  788776
  824164
  824362
]

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 (403141, 405921, 410959, 413454, 413461, 415109, 417801, 420291, 422049, 422926, 426294, 428103, 430314, 433295, 433669, 440625, 443090, 445641, 448811, 448863, 449425, 450274, 452404, 457963, 460289, 464935, 466982, 466989, 468955, 469198, 473722, 475684, 476123, 476244, 477744, 483544, 491209, 493163, 494233, 496086, 497888, 504399, 511816, 513025, 518594, 519246, 522914, 525393, 535282, 541588, 541633, 541643, 541651, 541667, 541671, 541884, 545801, 551991, 555317, 556535, 558788, 559453, 560086, 576704, 576710, 576713, 583913, 601324, 605521, 607355, 614023, 639824, 650380, 788776, 824164, 824362);

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` = 'волосатая анал подборк';