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

[
  "pov ffm milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pov ffm milf' 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
  465103
  492331
  590869
  457034
  590865
  432819
  426653
  485633
  513113
  527006
  557161
  433211
  442318
  584739
  449635
  448672
  430623
  520826
  534968
  580326
  775809
  472829
  452513
  430633
  424864
  510360
  553949
  430661
  430625
  442332
  473102
  527000
  617195
  527656
  654671
  596168
  434553
  480270
  442335
  492534
  473923
  512891
  452178
  473948
  477890
  519034
  531431
  531513
  442829
  430601
  523154
  587901
  460673
  506467
  421839
  527008
  431749
  509345
  573800
  512384
  551736
  438278
  530513
  576256
  512451
  522556
  513604
  420635
  504927
  608376
  610588
  442363
  556535
  430635
  531413
  486540
  573393
  477873
  442281
  548870
  590723
  622668
  527967
  484870
]

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 (465103, 492331, 590869, 457034, 590865, 432819, 426653, 485633, 513113, 527006, 557161, 433211, 442318, 584739, 449635, 448672, 430623, 520826, 534968, 580326, 775809, 472829, 452513, 430633, 424864, 510360, 553949, 430661, 430625, 442332, 473102, 527000, 617195, 527656, 654671, 596168, 434553, 480270, 442335, 492534, 473923, 512891, 452178, 473948, 477890, 519034, 531431, 531513, 442829, 430601, 523154, 587901, 460673, 506467, 421839, 527008, 431749, 509345, 573800, 512384, 551736, 438278, 530513, 576256, 512451, 522556, 513604, 420635, 504927, 608376, 610588, 442363, 556535, 430635, 531413, 486540, 573393, 477873, 442281, 548870, 590723, 622668, 527967, 484870);

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
  420635
  421839
  424864
  426653
  430601
  430623
  430625
  430633
  430635
  430661
  431749
  432819
  433211
  434553
  438278
  442281
  442318
  442332
  442335
  442363
  442829
  448672
  449635
  452178
  452513
  457034
  460673
  465103
  472829
  473102
  473923
  473948
  477873
  477890
  480270
  484870
  485633
  486540
  492331
  492534
  504927
  506467
  509345
  510360
  512384
  512451
  512891
  513113
  513604
  519034
  520826
  522556
  523154
  527000
  527006
  527008
  527656
  527967
  530513
  531413
  531431
  531513
  534968
  548870
  551736
  553949
  556535
  557161
  573393
  573800
  576256
  580326
  584739
  587901
  590723
  590865
  590869
  596168
  608376
  610588
  617195
  622668
  654671
  775809
]

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 (420635, 421839, 424864, 426653, 430601, 430623, 430625, 430633, 430635, 430661, 431749, 432819, 433211, 434553, 438278, 442281, 442318, 442332, 442335, 442363, 442829, 448672, 449635, 452178, 452513, 457034, 460673, 465103, 472829, 473102, 473923, 473948, 477873, 477890, 480270, 484870, 485633, 486540, 492331, 492534, 504927, 506467, 509345, 510360, 512384, 512451, 512891, 513113, 513604, 519034, 520826, 522556, 523154, 527000, 527006, 527008, 527656, 527967, 530513, 531413, 531431, 531513, 534968, 548870, 551736, 553949, 556535, 557161, 573393, 573800, 576256, 580326, 584739, 587901, 590723, 590865, 590869, 596168, 608376, 610588, 617195, 622668, 654671, 775809);

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
  420635
  421839
  424864
  426653
  430601
  430623
  430625
  430633
  430635
  430661
  431749
  432819
  433211
  434553
  438278
  442281
  442318
  442332
  442335
  442363
  442829
  448672
  449635
  452178
  452513
  457034
  460673
  465103
  472829
  473102
  473923
  473948
  477873
  477890
  480270
  484870
  485633
  486540
  492331
  492534
  504927
  506467
  509345
  510360
  512384
  512451
  512891
  513113
  513604
  519034
  520826
  522556
  523154
  527000
  527006
  527008
  527656
  527967
  530513
  531413
  531431
  531513
  534968
  548870
  551736
  553949
  556535
  557161
  573393
  573800
  576256
  580326
  584739
  587901
  590723
  590865
  590869
  596168
  608376
  610588
  617195
  622668
  654671
  775809
]

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 (420635, 421839, 424864, 426653, 430601, 430623, 430625, 430633, 430635, 430661, 431749, 432819, 433211, 434553, 438278, 442281, 442318, 442332, 442335, 442363, 442829, 448672, 449635, 452178, 452513, 457034, 460673, 465103, 472829, 473102, 473923, 473948, 477873, 477890, 480270, 484870, 485633, 486540, 492331, 492534, 504927, 506467, 509345, 510360, 512384, 512451, 512891, 513113, 513604, 519034, 520826, 522556, 523154, 527000, 527006, 527008, 527656, 527967, 530513, 531413, 531431, 531513, 534968, 548870, 551736, 553949, 556535, 557161, 573393, 573800, 576256, 580326, 584739, 587901, 590723, 590865, 590869, 596168, 608376, 610588, 617195, 622668, 654671, 775809);

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

[
  "пов жмж секс втро milf"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'пов жмж секс втро milf';

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

[
  "пов жмж секс втро milf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пов жмж секс втро milf';