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
  447045
  494231
  649893
  486198
  543860
  490533
  537208
  495647
  529846
  533471
  545382
  545615
  562373
  577409
  680183
  556014
  593373
  634212
  630193
  633114
  466021
  468586
  505504
  420541
  565153
  578782
  507944
  482953
  445802
  523860
  546201
  400995
  400808
  446059
  510887
  511404
  484558
  494962
  489950
  653870
  557021
  457160
  526853
  530832
  565172
  613463
  586713
  528096
  468010
  632006
  612751
  579188
  532747
  541661
  622398
  602939
  547612
  677784
  564136
  612434
  520672
  601324
  513882
  519171
  537210
  530024
  531187
  530382
  543844
  555789
  580669
  628126
  618793
  469595
  550315
  633423
  515544
  596054
  649080
  678522
  642766
  530762
  533557
  632563
]

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 (447045, 494231, 649893, 486198, 543860, 490533, 537208, 495647, 529846, 533471, 545382, 545615, 562373, 577409, 680183, 556014, 593373, 634212, 630193, 633114, 466021, 468586, 505504, 420541, 565153, 578782, 507944, 482953, 445802, 523860, 546201, 400995, 400808, 446059, 510887, 511404, 484558, 494962, 489950, 653870, 557021, 457160, 526853, 530832, 565172, 613463, 586713, 528096, 468010, 632006, 612751, 579188, 532747, 541661, 622398, 602939, 547612, 677784, 564136, 612434, 520672, 601324, 513882, 519171, 537210, 530024, 531187, 530382, 543844, 555789, 580669, 628126, 618793, 469595, 550315, 633423, 515544, 596054, 649080, 678522, 642766, 530762, 533557, 632563);

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
  400808
  400995
  420541
  445802
  446059
  447045
  457160
  466021
  468010
  468586
  469595
  482953
  484558
  486198
  489950
  490533
  494231
  494962
  495647
  505504
  507944
  510887
  511404
  513882
  515544
  519171
  520672
  523860
  526853
  528096
  529846
  530024
  530382
  530762
  530832
  531187
  532747
  533471
  533557
  537208
  537210
  541661
  543844
  543860
  545382
  545615
  546201
  547612
  550315
  555789
  556014
  557021
  562373
  564136
  565153
  565172
  577409
  578782
  579188
  580669
  586713
  593373
  596054
  601324
  602939
  612434
  612751
  613463
  618793
  622398
  628126
  630193
  632006
  632563
  633114
  633423
  634212
  642766
  649080
  649893
  653870
  677784
  678522
  680183
]

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 (400808, 400995, 420541, 445802, 446059, 447045, 457160, 466021, 468010, 468586, 469595, 482953, 484558, 486198, 489950, 490533, 494231, 494962, 495647, 505504, 507944, 510887, 511404, 513882, 515544, 519171, 520672, 523860, 526853, 528096, 529846, 530024, 530382, 530762, 530832, 531187, 532747, 533471, 533557, 537208, 537210, 541661, 543844, 543860, 545382, 545615, 546201, 547612, 550315, 555789, 556014, 557021, 562373, 564136, 565153, 565172, 577409, 578782, 579188, 580669, 586713, 593373, 596054, 601324, 602939, 612434, 612751, 613463, 618793, 622398, 628126, 630193, 632006, 632563, 633114, 633423, 634212, 642766, 649080, 649893, 653870, 677784, 678522, 680183);

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
  400808
  400995
  420541
  445802
  446059
  447045
  457160
  466021
  468010
  468586
  469595
  482953
  484558
  486198
  489950
  490533
  494231
  494962
  495647
  505504
  507944
  510887
  511404
  513882
  515544
  519171
  520672
  523860
  526853
  528096
  529846
  530024
  530382
  530762
  530832
  531187
  532747
  533471
  533557
  537208
  537210
  541661
  543844
  543860
  545382
  545615
  546201
  547612
  550315
  555789
  556014
  557021
  562373
  564136
  565153
  565172
  577409
  578782
  579188
  580669
  586713
  593373
  596054
  601324
  602939
  612434
  612751
  613463
  618793
  622398
  628126
  630193
  632006
  632563
  633114
  633423
  634212
  642766
  649080
  649893
  653870
  677784
  678522
  680183
]

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 (400808, 400995, 420541, 445802, 446059, 447045, 457160, 466021, 468010, 468586, 469595, 482953, 484558, 486198, 489950, 490533, 494231, 494962, 495647, 505504, 507944, 510887, 511404, 513882, 515544, 519171, 520672, 523860, 526853, 528096, 529846, 530024, 530382, 530762, 530832, 531187, 532747, 533471, 533557, 537208, 537210, 541661, 543844, 543860, 545382, 545615, 546201, 547612, 550315, 555789, 556014, 557021, 562373, 564136, 565153, 565172, 577409, 578782, 579188, 580669, 586713, 593373, 596054, 601324, 602939, 612434, 612751, 613463, 618793, 622398, 628126, 630193, 632006, 632563, 633114, 633423, 634212, 642766, 649080, 649893, 653870, 677784, 678522, 680183);

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` = 'вес сиськ';