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 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ôk_ö\x15rÍ┐ÞjU«ì¡╗"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01936B5F941572D6BFE86A55AE8DADBB 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
  747228
  747231
  458474
  423396
  421488
  497907
  517609
  526475
  528840
  517732
  526370
  567758
  556421
  561097
  619747
  592602
  597427
  610668
  586023
  586889
  589015
  807533
  747236
  463909
  514149
  517063
  486349
  644998
  490520
  509454
  542862
  554420
  577473
  561142
  649545
  575437
  610084
  617418
  599852
  807492
  609783
  624511
  407895
  427083
  511251
  644914
  482851
  507511
  528695
  541572
  565423
  579205
  614867
  812354
  451563
  427447
  536466
  526906
  559142
  564563
  690093
  556436
  637243
  382190
  526373
  530763
  486871
  519576
  543840
  543844
  581684
  546794
  571388
  567416
  610046
  623337
]

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 (747228, 747231, 458474, 423396, 421488, 497907, 517609, 526475, 528840, 517732, 526370, 567758, 556421, 561097, 619747, 592602, 597427, 610668, 586023, 586889, 589015, 807533, 747236, 463909, 514149, 517063, 486349, 644998, 490520, 509454, 542862, 554420, 577473, 561142, 649545, 575437, 610084, 617418, 599852, 807492, 609783, 624511, 407895, 427083, 511251, 644914, 482851, 507511, 528695, 541572, 565423, 579205, 614867, 812354, 451563, 427447, 536466, 526906, 559142, 564563, 690093, 556436, 637243, 382190, 526373, 530763, 486871, 519576, 543840, 543844, 581684, 546794, 571388, 567416, 610046, 623337);

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
  382190
  407895
  421488
  423396
  427083
  427447
  451563
  458474
  463909
  482851
  486349
  486871
  490520
  497907
  507511
  509454
  511251
  514149
  517063
  517609
  517732
  519576
  526370
  526373
  526475
  526906
  528695
  528840
  530763
  536466
  541572
  542862
  543840
  543844
  546794
  554420
  556421
  556436
  559142
  561097
  561142
  564563
  565423
  567416
  567758
  571388
  575437
  577473
  579205
  581684
  586023
  586889
  589015
  592602
  597427
  599852
  609783
  610046
  610084
  610668
  614867
  617418
  619747
  623337
  624511
  637243
  644914
  644998
  649545
  690093
  747228
  747231
  747236
  807492
  807533
  812354
]

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 (382190, 407895, 421488, 423396, 427083, 427447, 451563, 458474, 463909, 482851, 486349, 486871, 490520, 497907, 507511, 509454, 511251, 514149, 517063, 517609, 517732, 519576, 526370, 526373, 526475, 526906, 528695, 528840, 530763, 536466, 541572, 542862, 543840, 543844, 546794, 554420, 556421, 556436, 559142, 561097, 561142, 564563, 565423, 567416, 567758, 571388, 575437, 577473, 579205, 581684, 586023, 586889, 589015, 592602, 597427, 599852, 609783, 610046, 610084, 610668, 614867, 617418, 619747, 623337, 624511, 637243, 644914, 644998, 649545, 690093, 747228, 747231, 747236, 807492, 807533, 812354);

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
  382190
  407895
  421488
  423396
  427083
  427447
  451563
  458474
  463909
  482851
  486349
  486871
  490520
  497907
  507511
  509454
  511251
  514149
  517063
  517609
  517732
  519576
  526370
  526373
  526475
  526906
  528695
  528840
  530763
  536466
  541572
  542862
  543840
  543844
  546794
  554420
  556421
  556436
  559142
  561097
  561142
  564563
  565423
  567416
  567758
  571388
  575437
  577473
  579205
  581684
  586023
  586889
  589015
  592602
  597427
  599852
  609783
  610046
  610084
  610668
  614867
  617418
  619747
  623337
  624511
  637243
  644914
  644998
  649545
  690093
  747228
  747231
  747236
  807492
  807533
  812354
]

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 (382190, 407895, 421488, 423396, 427083, 427447, 451563, 458474, 463909, 482851, 486349, 486871, 490520, 497907, 507511, 509454, 511251, 514149, 517063, 517609, 517732, 519576, 526370, 526373, 526475, 526906, 528695, 528840, 530763, 536466, 541572, 542862, 543840, 543844, 546794, 554420, 556421, 556436, 559142, 561097, 561142, 564563, 565423, 567416, 567758, 571388, 575437, 577473, 579205, 581684, 586023, 586889, 589015, 592602, 597427, 599852, 609783, 610046, 610084, 610668, 614867, 617418, 619747, 623337, 624511, 637243, 644914, 644998, 649545, 690093, 747228, 747231, 747236, 807492, 807533, 812354);

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` = 'покорн';