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

[
  "bbw in panties"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw in panties' 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
  517689
  531547
  470432
  574678
  566351
  592985
  594207
  750907
  465571
  420178
  466992
  476619
  517690
  464359
  695163
  810606
  472943
  517697
  454227
  462818
  599638
  485690
  662896
  460758
  644849
  445607
  515350
  527418
  532630
  494289
  563732
  577211
  591942
  391921
  603205
  824356
  555055
  458761
  494282
  571102
  599631
  617659
  464985
  446964
  400826
  468165
  615978
  580744
  427543
  453203
  524895
  564244
  589290
  580921
  560123
  389860
  387423
  454171
  578169
  611259
  438587
  459469
  463982
  398972
  698124
  578395
  666784
  428108
  415753
  459637
  446865
  487575
  525500
  520186
  523622
  560828
  577037
  600502
  454560
  603672
  555007
  444913
  459476
  529355
  464336
  542724
  496554
  650806
]

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 (517689, 531547, 470432, 574678, 566351, 592985, 594207, 750907, 465571, 420178, 466992, 476619, 517690, 464359, 695163, 810606, 472943, 517697, 454227, 462818, 599638, 485690, 662896, 460758, 644849, 445607, 515350, 527418, 532630, 494289, 563732, 577211, 591942, 391921, 603205, 824356, 555055, 458761, 494282, 571102, 599631, 617659, 464985, 446964, 400826, 468165, 615978, 580744, 427543, 453203, 524895, 564244, 589290, 580921, 560123, 389860, 387423, 454171, 578169, 611259, 438587, 459469, 463982, 398972, 698124, 578395, 666784, 428108, 415753, 459637, 446865, 487575, 525500, 520186, 523622, 560828, 577037, 600502, 454560, 603672, 555007, 444913, 459476, 529355, 464336, 542724, 496554, 650806);

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
  387423
  389860
  391921
  398972
  400826
  415753
  420178
  427543
  428108
  438587
  444913
  445607
  446865
  446964
  453203
  454171
  454227
  454560
  458761
  459469
  459476
  459637
  460758
  462818
  463982
  464336
  464359
  464985
  465571
  466992
  468165
  470432
  472943
  476619
  485690
  487575
  494282
  494289
  496554
  515350
  517689
  517690
  517697
  520186
  523622
  524895
  525500
  527418
  529355
  531547
  532630
  542724
  555007
  555055
  560123
  560828
  563732
  564244
  566351
  571102
  574678
  577037
  577211
  578169
  578395
  580744
  580921
  589290
  591942
  592985
  594207
  599631
  599638
  600502
  603205
  603672
  611259
  615978
  617659
  644849
  650806
  662896
  666784
  695163
  698124
  750907
  810606
  824356
]

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 (387423, 389860, 391921, 398972, 400826, 415753, 420178, 427543, 428108, 438587, 444913, 445607, 446865, 446964, 453203, 454171, 454227, 454560, 458761, 459469, 459476, 459637, 460758, 462818, 463982, 464336, 464359, 464985, 465571, 466992, 468165, 470432, 472943, 476619, 485690, 487575, 494282, 494289, 496554, 515350, 517689, 517690, 517697, 520186, 523622, 524895, 525500, 527418, 529355, 531547, 532630, 542724, 555007, 555055, 560123, 560828, 563732, 564244, 566351, 571102, 574678, 577037, 577211, 578169, 578395, 580744, 580921, 589290, 591942, 592985, 594207, 599631, 599638, 600502, 603205, 603672, 611259, 615978, 617659, 644849, 650806, 662896, 666784, 695163, 698124, 750907, 810606, 824356);

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
  387423
  389860
  391921
  398972
  400826
  415753
  420178
  427543
  428108
  438587
  444913
  445607
  446865
  446964
  453203
  454171
  454227
  454560
  458761
  459469
  459476
  459637
  460758
  462818
  463982
  464336
  464359
  464985
  465571
  466992
  468165
  470432
  472943
  476619
  485690
  487575
  494282
  494289
  496554
  515350
  517689
  517690
  517697
  520186
  523622
  524895
  525500
  527418
  529355
  531547
  532630
  542724
  555007
  555055
  560123
  560828
  563732
  564244
  566351
  571102
  574678
  577037
  577211
  578169
  578395
  580744
  580921
  589290
  591942
  592985
  594207
  599631
  599638
  600502
  603205
  603672
  611259
  615978
  617659
  644849
  650806
  662896
  666784
  695163
  698124
  750907
  810606
  824356
]

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 (387423, 389860, 391921, 398972, 400826, 415753, 420178, 427543, 428108, 438587, 444913, 445607, 446865, 446964, 453203, 454171, 454227, 454560, 458761, 459469, 459476, 459637, 460758, 462818, 463982, 464336, 464359, 464985, 465571, 466992, 468165, 470432, 472943, 476619, 485690, 487575, 494282, 494289, 496554, 515350, 517689, 517690, 517697, 520186, 523622, 524895, 525500, 527418, 529355, 531547, 532630, 542724, 555007, 555055, 560123, 560828, 563732, 564244, 566351, 571102, 574678, 577037, 577211, 578169, 578395, 580744, 580921, 589290, 591942, 592985, 594207, 599631, 599638, 600502, 603205, 603672, 611259, 615978, 617659, 644849, 650806, 662896, 666784, 695163, 698124, 750907, 810606, 824356);

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

[
  "bbw трусик нижн бел"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbw трусик нижн бел';

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

[
  "bbw трусик нижн бел"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw трусик нижн бел';