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ô{®lÉpÊ¥b­Þ\x1A\x1EÈh"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01937BA96C9070D2BE62F0E81A1ED468 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
  452587
  525248
  564859
  578685
  599882
  600825
  449384
  503831
  541410
  571822
  589116
  517001
  526719
  486355
  491966
  507797
  515733
  561079
  578661
  580650
  423178
  397400
  419590
  480297
  428520
  514102
  477404
  596900
  465654
  559162
  558128
  515603
  528789
  511366
  519962
  569829
  452594
  559161
  501643
  535014
  582782
  526221
  464011
  570725
  491392
  596904
  553300
  619451
  688007
  508269
  576629
  595256
  509432
  625172
  475980
  522930
  583482
  515579
  548596
  542193
  514294
  600837
  601273
  548012
  578467
  589544
  615621
  570765
  469453
  520881
  528807
  542914
  624428
  621272
  418686
]

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 (452587, 525248, 564859, 578685, 599882, 600825, 449384, 503831, 541410, 571822, 589116, 517001, 526719, 486355, 491966, 507797, 515733, 561079, 578661, 580650, 423178, 397400, 419590, 480297, 428520, 514102, 477404, 596900, 465654, 559162, 558128, 515603, 528789, 511366, 519962, 569829, 452594, 559161, 501643, 535014, 582782, 526221, 464011, 570725, 491392, 596904, 553300, 619451, 688007, 508269, 576629, 595256, 509432, 625172, 475980, 522930, 583482, 515579, 548596, 542193, 514294, 600837, 601273, 548012, 578467, 589544, 615621, 570765, 469453, 520881, 528807, 542914, 624428, 621272, 418686);

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
  397400
  418686
  419590
  423178
  428520
  449384
  452587
  452594
  464011
  465654
  469453
  475980
  477404
  480297
  486355
  491392
  491966
  501643
  503831
  507797
  508269
  509432
  511366
  514102
  514294
  515579
  515603
  515733
  517001
  519962
  520881
  522930
  525248
  526221
  526719
  528789
  528807
  535014
  541410
  542193
  542914
  548012
  548596
  553300
  558128
  559161
  559162
  561079
  564859
  569829
  570725
  570765
  571822
  576629
  578467
  578661
  578685
  580650
  582782
  583482
  589116
  589544
  595256
  596900
  596904
  599882
  600825
  600837
  601273
  615621
  619451
  621272
  624428
  625172
  688007
]

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 (397400, 418686, 419590, 423178, 428520, 449384, 452587, 452594, 464011, 465654, 469453, 475980, 477404, 480297, 486355, 491392, 491966, 501643, 503831, 507797, 508269, 509432, 511366, 514102, 514294, 515579, 515603, 515733, 517001, 519962, 520881, 522930, 525248, 526221, 526719, 528789, 528807, 535014, 541410, 542193, 542914, 548012, 548596, 553300, 558128, 559161, 559162, 561079, 564859, 569829, 570725, 570765, 571822, 576629, 578467, 578661, 578685, 580650, 582782, 583482, 589116, 589544, 595256, 596900, 596904, 599882, 600825, 600837, 601273, 615621, 619451, 621272, 624428, 625172, 688007);

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
  397400
  418686
  419590
  423178
  428520
  449384
  452587
  452594
  464011
  465654
  469453
  475980
  477404
  480297
  486355
  491392
  491966
  501643
  503831
  507797
  508269
  509432
  511366
  514102
  514294
  515579
  515603
  515733
  517001
  519962
  520881
  522930
  525248
  526221
  526719
  528789
  528807
  535014
  541410
  542193
  542914
  548012
  548596
  553300
  558128
  559161
  559162
  561079
  564859
  569829
  570725
  570765
  571822
  576629
  578467
  578661
  578685
  580650
  582782
  583482
  589116
  589544
  595256
  596900
  596904
  599882
  600825
  600837
  601273
  615621
  619451
  621272
  624428
  625172
  688007
]

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 (397400, 418686, 419590, 423178, 428520, 449384, 452587, 452594, 464011, 465654, 469453, 475980, 477404, 480297, 486355, 491392, 491966, 501643, 503831, 507797, 508269, 509432, 511366, 514102, 514294, 515579, 515603, 515733, 517001, 519962, 520881, 522930, 525248, 526221, 526719, 528789, 528807, 535014, 541410, 542193, 542914, 548012, 548596, 553300, 558128, 559161, 559162, 561079, 564859, 569829, 570725, 570765, 571822, 576629, 578467, 578661, 578685, 580650, 582782, 583482, 589116, 589544, 595256, 596900, 596904, 599882, 600825, 600837, 601273, 615621, 619451, 621272, 624428, 625172, 688007);

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` = 'минет оральн секс босс';