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
  493047
  489665
  483094
  519542
  751554
  678973
  667975
  452594
  504684
  533461
  492609
  507682
  775539
  493059
  448582
  602747
  604289
  530003
  512761
  483126
  490496
  602914
  621516
  586962
  513782
  448289
  513540
  554742
  618948
  597810
  461316
  593574
  458810
  526263
  527713
  443491
  505278
  523130
  511631
  505279
  544507
  564366
  621880
  617045
  599302
  617047
  463693
  513640
  520483
  485797
  477695
  554255
  608464
  476921
  626448
  444784
  615482
  619097
  568519
  543399
  548904
  589968
  644047
  493892
  621259
  623413
  489113
  580596
  441168
  519853
  653560
  520132
  603776
  604743
  591415
]

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 (493047, 489665, 483094, 519542, 751554, 678973, 667975, 452594, 504684, 533461, 492609, 507682, 775539, 493059, 448582, 602747, 604289, 530003, 512761, 483126, 490496, 602914, 621516, 586962, 513782, 448289, 513540, 554742, 618948, 597810, 461316, 593574, 458810, 526263, 527713, 443491, 505278, 523130, 511631, 505279, 544507, 564366, 621880, 617045, 599302, 617047, 463693, 513640, 520483, 485797, 477695, 554255, 608464, 476921, 626448, 444784, 615482, 619097, 568519, 543399, 548904, 589968, 644047, 493892, 621259, 623413, 489113, 580596, 441168, 519853, 653560, 520132, 603776, 604743, 591415);

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
  441168
  443491
  444784
  448289
  448582
  452594
  458810
  461316
  463693
  476921
  477695
  483094
  483126
  485797
  489113
  489665
  490496
  492609
  493047
  493059
  493892
  504684
  505278
  505279
  507682
  511631
  512761
  513540
  513640
  513782
  519542
  519853
  520132
  520483
  523130
  526263
  527713
  530003
  533461
  543399
  544507
  548904
  554255
  554742
  564366
  568519
  580596
  586962
  589968
  591415
  593574
  597810
  599302
  602747
  602914
  603776
  604289
  604743
  608464
  615482
  617045
  617047
  618948
  619097
  621259
  621516
  621880
  623413
  626448
  644047
  653560
  667975
  678973
  751554
  775539
]

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 (441168, 443491, 444784, 448289, 448582, 452594, 458810, 461316, 463693, 476921, 477695, 483094, 483126, 485797, 489113, 489665, 490496, 492609, 493047, 493059, 493892, 504684, 505278, 505279, 507682, 511631, 512761, 513540, 513640, 513782, 519542, 519853, 520132, 520483, 523130, 526263, 527713, 530003, 533461, 543399, 544507, 548904, 554255, 554742, 564366, 568519, 580596, 586962, 589968, 591415, 593574, 597810, 599302, 602747, 602914, 603776, 604289, 604743, 608464, 615482, 617045, 617047, 618948, 619097, 621259, 621516, 621880, 623413, 626448, 644047, 653560, 667975, 678973, 751554, 775539);

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
  441168
  443491
  444784
  448289
  448582
  452594
  458810
  461316
  463693
  476921
  477695
  483094
  483126
  485797
  489113
  489665
  490496
  492609
  493047
  493059
  493892
  504684
  505278
  505279
  507682
  511631
  512761
  513540
  513640
  513782
  519542
  519853
  520132
  520483
  523130
  526263
  527713
  530003
  533461
  543399
  544507
  548904
  554255
  554742
  564366
  568519
  580596
  586962
  589968
  591415
  593574
  597810
  599302
  602747
  602914
  603776
  604289
  604743
  608464
  615482
  617045
  617047
  618948
  619097
  621259
  621516
  621880
  623413
  626448
  644047
  653560
  667975
  678973
  751554
  775539
]

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 (441168, 443491, 444784, 448289, 448582, 452594, 458810, 461316, 463693, 476921, 477695, 483094, 483126, 485797, 489113, 489665, 490496, 492609, 493047, 493059, 493892, 504684, 505278, 505279, 507682, 511631, 512761, 513540, 513640, 513782, 519542, 519853, 520132, 520483, 523130, 526263, 527713, 530003, 533461, 543399, 544507, 548904, 554255, 554742, 564366, 568519, 580596, 586962, 589968, 591415, 593574, 597810, 599302, 602747, 602914, 603776, 604289, 604743, 608464, 615482, 617045, 617047, 618948, 619097, 621259, 621516, 621880, 623413, 626448, 644047, 653560, 667975, 678973, 751554, 775539);

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