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

[
  "sleeping cum girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sleeping cum 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
  497818
  444439
  461065
  524040
  525085
  509570
  563890
  578733
  601988
  447487
  485179
  516850
  447807
  715442
  509330
  524688
  511358
  583786
  560690
  665325
  709618
  562938
  726936
  426535
  515497
  545072
  588510
  475404
  447390
  478948
  486536
  451380
  499657
  508168
  619849
  451664
  520198
  567147
  448280
  553650
  571976
  612507
  453725
  445707
  624127
  623618
  510341
  548254
  527905
  677128
  511242
  513189
  558338
  625556
  590599
  426932
  597491
  553031
  824810
  608737
  611416
  460686
  457204
  459342
  560511
  567148
  528176
  624846
  624847
  465771
  514782
  559242
  416880
  408644
  481343
  585101
  620085
]

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 (497818, 444439, 461065, 524040, 525085, 509570, 563890, 578733, 601988, 447487, 485179, 516850, 447807, 715442, 509330, 524688, 511358, 583786, 560690, 665325, 709618, 562938, 726936, 426535, 515497, 545072, 588510, 475404, 447390, 478948, 486536, 451380, 499657, 508168, 619849, 451664, 520198, 567147, 448280, 553650, 571976, 612507, 453725, 445707, 624127, 623618, 510341, 548254, 527905, 677128, 511242, 513189, 558338, 625556, 590599, 426932, 597491, 553031, 824810, 608737, 611416, 460686, 457204, 459342, 560511, 567148, 528176, 624846, 624847, 465771, 514782, 559242, 416880, 408644, 481343, 585101, 620085);

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
  408644
  416880
  426535
  426932
  444439
  445707
  447390
  447487
  447807
  448280
  451380
  451664
  453725
  457204
  459342
  460686
  461065
  465771
  475404
  478948
  481343
  485179
  486536
  497818
  499657
  508168
  509330
  509570
  510341
  511242
  511358
  513189
  514782
  515497
  516850
  520198
  524040
  524688
  525085
  527905
  528176
  545072
  548254
  553031
  553650
  558338
  559242
  560511
  560690
  562938
  563890
  567147
  567148
  571976
  578733
  583786
  585101
  588510
  590599
  597491
  601988
  608737
  611416
  612507
  619849
  620085
  623618
  624127
  624846
  624847
  625556
  665325
  677128
  709618
  715442
  726936
  824810
]

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 (408644, 416880, 426535, 426932, 444439, 445707, 447390, 447487, 447807, 448280, 451380, 451664, 453725, 457204, 459342, 460686, 461065, 465771, 475404, 478948, 481343, 485179, 486536, 497818, 499657, 508168, 509330, 509570, 510341, 511242, 511358, 513189, 514782, 515497, 516850, 520198, 524040, 524688, 525085, 527905, 528176, 545072, 548254, 553031, 553650, 558338, 559242, 560511, 560690, 562938, 563890, 567147, 567148, 571976, 578733, 583786, 585101, 588510, 590599, 597491, 601988, 608737, 611416, 612507, 619849, 620085, 623618, 624127, 624846, 624847, 625556, 665325, 677128, 709618, 715442, 726936, 824810);

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
  408644
  416880
  426535
  426932
  444439
  445707
  447390
  447487
  447807
  448280
  451380
  451664
  453725
  457204
  459342
  460686
  461065
  465771
  475404
  478948
  481343
  485179
  486536
  497818
  499657
  508168
  509330
  509570
  510341
  511242
  511358
  513189
  514782
  515497
  516850
  520198
  524040
  524688
  525085
  527905
  528176
  545072
  548254
  553031
  553650
  558338
  559242
  560511
  560690
  562938
  563890
  567147
  567148
  571976
  578733
  583786
  585101
  588510
  590599
  597491
  601988
  608737
  611416
  612507
  619849
  620085
  623618
  624127
  624846
  624847
  625556
  665325
  677128
  709618
  715442
  726936
  824810
]

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 (408644, 416880, 426535, 426932, 444439, 445707, 447390, 447487, 447807, 448280, 451380, 451664, 453725, 457204, 459342, 460686, 461065, 465771, 475404, 478948, 481343, 485179, 486536, 497818, 499657, 508168, 509330, 509570, 510341, 511242, 511358, 513189, 514782, 515497, 516850, 520198, 524040, 524688, 525085, 527905, 528176, 545072, 548254, 553031, 553650, 558338, 559242, 560511, 560690, 562938, 563890, 567147, 567148, 571976, 578733, 583786, 585101, 588510, 590599, 597491, 601988, 608737, 611416, 612507, 619849, 620085, 623618, 624127, 624846, 624847, 625556, 665325, 677128, 709618, 715442, 726936, 824810);

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

[
  "спящ cum девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'спящ cum девушк';

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

[
  "спящ cum девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'спящ cum девушк';