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

[
  "need sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'need sex' 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
  395496
  534568
  461854
  493203
  670676
  687542
  520373
  581532
  618982
  527678
  428583
  436510
  447878
  475925
  537834
  569784
  595616
  187349
  445988
  491294
  451226
  514676
  524756
  542503
  561071
  567623
  594863
  425481
  526245
  437594
  488240
  450495
  673594
  596864
  464721
  407721
  559103
  660013
  588052
  614768
  419804
  820482
  413818
  490864
  578463
  482070
  426065
  593485
  490915
  508429
  587751
  717606
  623472
  616760
  473798
  571464
  603657
  489310
  502480
  536417
  444316
  486441
  484618
  508474
  562626
  457435
  499159
  475092
  570068
  535084
  475275
  554770
  465824
  600337
  478049
  426565
  431749
  510254
  616933
  524848
  623468
]

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 (395496, 534568, 461854, 493203, 670676, 687542, 520373, 581532, 618982, 527678, 428583, 436510, 447878, 475925, 537834, 569784, 595616, 187349, 445988, 491294, 451226, 514676, 524756, 542503, 561071, 567623, 594863, 425481, 526245, 437594, 488240, 450495, 673594, 596864, 464721, 407721, 559103, 660013, 588052, 614768, 419804, 820482, 413818, 490864, 578463, 482070, 426065, 593485, 490915, 508429, 587751, 717606, 623472, 616760, 473798, 571464, 603657, 489310, 502480, 536417, 444316, 486441, 484618, 508474, 562626, 457435, 499159, 475092, 570068, 535084, 475275, 554770, 465824, 600337, 478049, 426565, 431749, 510254, 616933, 524848, 623468);

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
  187349
  395496
  407721
  413818
  419804
  425481
  426065
  426565
  428583
  431749
  436510
  437594
  444316
  445988
  447878
  450495
  451226
  457435
  461854
  464721
  465824
  473798
  475092
  475275
  475925
  478049
  482070
  484618
  486441
  488240
  489310
  490864
  490915
  491294
  493203
  499159
  502480
  508429
  508474
  510254
  514676
  520373
  524756
  524848
  526245
  527678
  534568
  535084
  536417
  537834
  542503
  554770
  559103
  561071
  562626
  567623
  569784
  570068
  571464
  578463
  581532
  587751
  588052
  593485
  594863
  595616
  596864
  600337
  603657
  614768
  616760
  616933
  618982
  623468
  623472
  660013
  670676
  673594
  687542
  717606
  820482
]

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 (187349, 395496, 407721, 413818, 419804, 425481, 426065, 426565, 428583, 431749, 436510, 437594, 444316, 445988, 447878, 450495, 451226, 457435, 461854, 464721, 465824, 473798, 475092, 475275, 475925, 478049, 482070, 484618, 486441, 488240, 489310, 490864, 490915, 491294, 493203, 499159, 502480, 508429, 508474, 510254, 514676, 520373, 524756, 524848, 526245, 527678, 534568, 535084, 536417, 537834, 542503, 554770, 559103, 561071, 562626, 567623, 569784, 570068, 571464, 578463, 581532, 587751, 588052, 593485, 594863, 595616, 596864, 600337, 603657, 614768, 616760, 616933, 618982, 623468, 623472, 660013, 670676, 673594, 687542, 717606, 820482);

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
  187349
  395496
  407721
  413818
  419804
  425481
  426065
  426565
  428583
  431749
  436510
  437594
  444316
  445988
  447878
  450495
  451226
  457435
  461854
  464721
  465824
  473798
  475092
  475275
  475925
  478049
  482070
  484618
  486441
  488240
  489310
  490864
  490915
  491294
  493203
  499159
  502480
  508429
  508474
  510254
  514676
  520373
  524756
  524848
  526245
  527678
  534568
  535084
  536417
  537834
  542503
  554770
  559103
  561071
  562626
  567623
  569784
  570068
  571464
  578463
  581532
  587751
  588052
  593485
  594863
  595616
  596864
  600337
  603657
  614768
  616760
  616933
  618982
  623468
  623472
  660013
  670676
  673594
  687542
  717606
  820482
]

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 (187349, 395496, 407721, 413818, 419804, 425481, 426065, 426565, 428583, 431749, 436510, 437594, 444316, 445988, 447878, 450495, 451226, 457435, 461854, 464721, 465824, 473798, 475092, 475275, 475925, 478049, 482070, 484618, 486441, 488240, 489310, 490864, 490915, 491294, 493203, 499159, 502480, 508429, 508474, 510254, 514676, 520373, 524756, 524848, 526245, 527678, 534568, 535084, 536417, 537834, 542503, 554770, 559103, 561071, 562626, 567623, 569784, 570068, 571464, 578463, 581532, 587751, 588052, 593485, 594863, 595616, 596864, 600337, 603657, 614768, 616760, 616933, 618982, 623468, 623472, 660013, 670676, 673594, 687542, 717606, 820482);

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

[
  "need секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'need секс';

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

[
  "need секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'need секс';