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

[
  "only girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'only girl' 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
  516826
  565066
  700307
  620419
  610466
  519695
  530759
  530025
  647850
  591190
  590731
  533461
  651147
  552550
  460321
  632673
  628073
  509982
  815883
  474025
  586864
  612548
  442439
  463673
  467441
  448695
  469686
  525407
  534985
  640763
  562373
  581095
  429764
  556762
  637145
  643112
  623420
  529846
  533471
  556017
  614058
  632979
  633114
  537208
  556014
  637004
  680183
  671642
  680170
  567051
  637421
  610821
  530005
  567066
  421592
  570708
  680159
  623933
  634193
  640739
  512490
  633780
  497311
  532747
  622398
  630635
  564136
  624173
  639810
  580669
  624095
  624779
  537210
  651601
  671403
  603765
  530762
  527124
  519933
  642746
  523360
]

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 (516826, 565066, 700307, 620419, 610466, 519695, 530759, 530025, 647850, 591190, 590731, 533461, 651147, 552550, 460321, 632673, 628073, 509982, 815883, 474025, 586864, 612548, 442439, 463673, 467441, 448695, 469686, 525407, 534985, 640763, 562373, 581095, 429764, 556762, 637145, 643112, 623420, 529846, 533471, 556017, 614058, 632979, 633114, 537208, 556014, 637004, 680183, 671642, 680170, 567051, 637421, 610821, 530005, 567066, 421592, 570708, 680159, 623933, 634193, 640739, 512490, 633780, 497311, 532747, 622398, 630635, 564136, 624173, 639810, 580669, 624095, 624779, 537210, 651601, 671403, 603765, 530762, 527124, 519933, 642746, 523360);

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
  421592
  429764
  442439
  448695
  460321
  463673
  467441
  469686
  474025
  497311
  509982
  512490
  516826
  519695
  519933
  523360
  525407
  527124
  529846
  530005
  530025
  530759
  530762
  532747
  533461
  533471
  534985
  537208
  537210
  552550
  556014
  556017
  556762
  562373
  564136
  565066
  567051
  567066
  570708
  580669
  581095
  586864
  590731
  591190
  603765
  610466
  610821
  612548
  614058
  620419
  622398
  623420
  623933
  624095
  624173
  624779
  628073
  630635
  632673
  632979
  633114
  633780
  634193
  637004
  637145
  637421
  639810
  640739
  640763
  642746
  643112
  647850
  651147
  651601
  671403
  671642
  680159
  680170
  680183
  700307
  815883
]

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 (421592, 429764, 442439, 448695, 460321, 463673, 467441, 469686, 474025, 497311, 509982, 512490, 516826, 519695, 519933, 523360, 525407, 527124, 529846, 530005, 530025, 530759, 530762, 532747, 533461, 533471, 534985, 537208, 537210, 552550, 556014, 556017, 556762, 562373, 564136, 565066, 567051, 567066, 570708, 580669, 581095, 586864, 590731, 591190, 603765, 610466, 610821, 612548, 614058, 620419, 622398, 623420, 623933, 624095, 624173, 624779, 628073, 630635, 632673, 632979, 633114, 633780, 634193, 637004, 637145, 637421, 639810, 640739, 640763, 642746, 643112, 647850, 651147, 651601, 671403, 671642, 680159, 680170, 680183, 700307, 815883);

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
  421592
  429764
  442439
  448695
  460321
  463673
  467441
  469686
  474025
  497311
  509982
  512490
  516826
  519695
  519933
  523360
  525407
  527124
  529846
  530005
  530025
  530759
  530762
  532747
  533461
  533471
  534985
  537208
  537210
  552550
  556014
  556017
  556762
  562373
  564136
  565066
  567051
  567066
  570708
  580669
  581095
  586864
  590731
  591190
  603765
  610466
  610821
  612548
  614058
  620419
  622398
  623420
  623933
  624095
  624173
  624779
  628073
  630635
  632673
  632979
  633114
  633780
  634193
  637004
  637145
  637421
  639810
  640739
  640763
  642746
  643112
  647850
  651147
  651601
  671403
  671642
  680159
  680170
  680183
  700307
  815883
]

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 (421592, 429764, 442439, 448695, 460321, 463673, 467441, 469686, 474025, 497311, 509982, 512490, 516826, 519695, 519933, 523360, 525407, 527124, 529846, 530005, 530025, 530759, 530762, 532747, 533461, 533471, 534985, 537208, 537210, 552550, 556014, 556017, 556762, 562373, 564136, 565066, 567051, 567066, 570708, 580669, 581095, 586864, 590731, 591190, 603765, 610466, 610821, 612548, 614058, 620419, 622398, 623420, 623933, 624095, 624173, 624779, 628073, 630635, 632673, 632979, 633114, 633780, 634193, 637004, 637145, 637421, 639810, 640739, 640763, 642746, 643112, 647850, 651147, 651601, 671403, 671642, 680159, 680170, 680183, 700307, 815883);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "only девушк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'only девушк';

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

[
  "only девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'only девушк';