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

[
  "mature slave blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature slave blowjob' 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
  439575
  501474
  532357
  412583
  524948
  541848
  426368
  516972
  425622
  483627
  530808
  545427
  510695
  457189
  500430
  543652
  637036
  533915
  447706
  634178
  506081
  524142
  532813
  530495
  524029
  508565
  559183
  477339
  521738
  524018
  530377
  514070
  535084
  540437
  532655
  541752
  632642
  599835
  541604
  522871
  512447
  531425
  517033
  616711
  555789
  451866
  467867
  444588
  563441
  478981
  548552
  649596
  536403
  564563
  599976
  554392
  510396
  521372
  447810
  652544
  429999
  463105
  646448
  534994
  499112
  492607
  543881
  530659
  486665
  522013
  541721
  567416
  609958
  506500
  528011
  523924
  559233
  665328
  599940
  524276
  543848
  545480
]

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 (439575, 501474, 532357, 412583, 524948, 541848, 426368, 516972, 425622, 483627, 530808, 545427, 510695, 457189, 500430, 543652, 637036, 533915, 447706, 634178, 506081, 524142, 532813, 530495, 524029, 508565, 559183, 477339, 521738, 524018, 530377, 514070, 535084, 540437, 532655, 541752, 632642, 599835, 541604, 522871, 512447, 531425, 517033, 616711, 555789, 451866, 467867, 444588, 563441, 478981, 548552, 649596, 536403, 564563, 599976, 554392, 510396, 521372, 447810, 652544, 429999, 463105, 646448, 534994, 499112, 492607, 543881, 530659, 486665, 522013, 541721, 567416, 609958, 506500, 528011, 523924, 559233, 665328, 599940, 524276, 543848, 545480);

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
  412583
  425622
  426368
  429999
  439575
  444588
  447706
  447810
  451866
  457189
  463105
  467867
  477339
  478981
  483627
  486665
  492607
  499112
  500430
  501474
  506081
  506500
  508565
  510396
  510695
  512447
  514070
  516972
  517033
  521372
  521738
  522013
  522871
  523924
  524018
  524029
  524142
  524276
  524948
  528011
  530377
  530495
  530659
  530808
  531425
  532357
  532655
  532813
  533915
  534994
  535084
  536403
  540437
  541604
  541721
  541752
  541848
  543652
  543848
  543881
  545427
  545480
  548552
  554392
  555789
  559183
  559233
  563441
  564563
  567416
  599835
  599940
  599976
  609958
  616711
  632642
  634178
  637036
  646448
  649596
  652544
  665328
]

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 (412583, 425622, 426368, 429999, 439575, 444588, 447706, 447810, 451866, 457189, 463105, 467867, 477339, 478981, 483627, 486665, 492607, 499112, 500430, 501474, 506081, 506500, 508565, 510396, 510695, 512447, 514070, 516972, 517033, 521372, 521738, 522013, 522871, 523924, 524018, 524029, 524142, 524276, 524948, 528011, 530377, 530495, 530659, 530808, 531425, 532357, 532655, 532813, 533915, 534994, 535084, 536403, 540437, 541604, 541721, 541752, 541848, 543652, 543848, 543881, 545427, 545480, 548552, 554392, 555789, 559183, 559233, 563441, 564563, 567416, 599835, 599940, 599976, 609958, 616711, 632642, 634178, 637036, 646448, 649596, 652544, 665328);

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
  412583
  425622
  426368
  429999
  439575
  444588
  447706
  447810
  451866
  457189
  463105
  467867
  477339
  478981
  483627
  486665
  492607
  499112
  500430
  501474
  506081
  506500
  508565
  510396
  510695
  512447
  514070
  516972
  517033
  521372
  521738
  522013
  522871
  523924
  524018
  524029
  524142
  524276
  524948
  528011
  530377
  530495
  530659
  530808
  531425
  532357
  532655
  532813
  533915
  534994
  535084
  536403
  540437
  541604
  541721
  541752
  541848
  543652
  543848
  543881
  545427
  545480
  548552
  554392
  555789
  559183
  559233
  563441
  564563
  567416
  599835
  599940
  599976
  609958
  616711
  632642
  634178
  637036
  646448
  649596
  652544
  665328
]

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 (412583, 425622, 426368, 429999, 439575, 444588, 447706, 447810, 451866, 457189, 463105, 467867, 477339, 478981, 483627, 486665, 492607, 499112, 500430, 501474, 506081, 506500, 508565, 510396, 510695, 512447, 514070, 516972, 517033, 521372, 521738, 522013, 522871, 523924, 524018, 524029, 524142, 524276, 524948, 528011, 530377, 530495, 530659, 530808, 531425, 532357, 532655, 532813, 533915, 534994, 535084, 536403, 540437, 541604, 541721, 541752, 541848, 543652, 543848, 543881, 545427, 545480, 548552, 554392, 555789, 559183, 559233, 563441, 564563, 567416, 599835, 599940, 599976, 609958, 616711, 632642, 634178, 637036, 646448, 649596, 652544, 665328);

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

[
  "mature доминирован минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature доминирован минет оральн секс';

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

[
  "mature доминирован минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature доминирован минет оральн секс';