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

[
  "russian bbw"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian bbw' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ô7§tçp\x04ïÅÿéeR\x1E""
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019337F5748770048B8F988265521E22 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
  411693
  528512
  483885
  466992
  562418
  444913
  444918
  391287
  423966
  454177
  458000
  443105
  485689
  492462
  513581
  560828
  641807
  609071
  781924
  796829
  757724
  464031
  383985
  459472
  401657
  391703
  456312
  495040
  499472
  509643
  527842
  484367
  485766
  477717
  464023
  467029
  474629
  454224
  511086
  485698
  454499
  525307
  541078
  555055
  567063
  550220
  562423
  592985
  599354
  476619
  459476
  460294
  483448
  513583
  525468
  617659
  507640
  542724
  563732
  590418
  400826
  458974
  400849
  444915
  398559
  398949
  488439
  509842
  510425
  491164
  527424
  489721
  460758
  463973
  474923
  507643
  678764
  761039
  476015
  453408
  504864
  491436
]

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 (411693, 528512, 483885, 466992, 562418, 444913, 444918, 391287, 423966, 454177, 458000, 443105, 485689, 492462, 513581, 560828, 641807, 609071, 781924, 796829, 757724, 464031, 383985, 459472, 401657, 391703, 456312, 495040, 499472, 509643, 527842, 484367, 485766, 477717, 464023, 467029, 474629, 454224, 511086, 485698, 454499, 525307, 541078, 555055, 567063, 550220, 562423, 592985, 599354, 476619, 459476, 460294, 483448, 513583, 525468, 617659, 507640, 542724, 563732, 590418, 400826, 458974, 400849, 444915, 398559, 398949, 488439, 509842, 510425, 491164, 527424, 489721, 460758, 463973, 474923, 507643, 678764, 761039, 476015, 453408, 504864, 491436);

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
  383985
  391287
  391703
  398559
  398949
  400826
  400849
  401657
  411693
  423966
  443105
  444913
  444915
  444918
  453408
  454177
  454224
  454499
  456312
  458000
  458974
  459472
  459476
  460294
  460758
  463973
  464023
  464031
  466992
  467029
  474629
  474923
  476015
  476619
  477717
  483448
  483885
  484367
  485689
  485698
  485766
  488439
  489721
  491164
  491436
  492462
  495040
  499472
  504864
  507640
  507643
  509643
  509842
  510425
  511086
  513581
  513583
  525307
  525468
  527424
  527842
  528512
  541078
  542724
  550220
  555055
  560828
  562418
  562423
  563732
  567063
  590418
  592985
  599354
  609071
  617659
  641807
  678764
  757724
  761039
  781924
  796829
]

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 (383985, 391287, 391703, 398559, 398949, 400826, 400849, 401657, 411693, 423966, 443105, 444913, 444915, 444918, 453408, 454177, 454224, 454499, 456312, 458000, 458974, 459472, 459476, 460294, 460758, 463973, 464023, 464031, 466992, 467029, 474629, 474923, 476015, 476619, 477717, 483448, 483885, 484367, 485689, 485698, 485766, 488439, 489721, 491164, 491436, 492462, 495040, 499472, 504864, 507640, 507643, 509643, 509842, 510425, 511086, 513581, 513583, 525307, 525468, 527424, 527842, 528512, 541078, 542724, 550220, 555055, 560828, 562418, 562423, 563732, 567063, 590418, 592985, 599354, 609071, 617659, 641807, 678764, 757724, 761039, 781924, 796829);

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
  383985
  391287
  391703
  398559
  398949
  400826
  400849
  401657
  411693
  423966
  443105
  444913
  444915
  444918
  453408
  454177
  454224
  454499
  456312
  458000
  458974
  459472
  459476
  460294
  460758
  463973
  464023
  464031
  466992
  467029
  474629
  474923
  476015
  476619
  477717
  483448
  483885
  484367
  485689
  485698
  485766
  488439
  489721
  491164
  491436
  492462
  495040
  499472
  504864
  507640
  507643
  509643
  509842
  510425
  511086
  513581
  513583
  525307
  525468
  527424
  527842
  528512
  541078
  542724
  550220
  555055
  560828
  562418
  562423
  563732
  567063
  590418
  592985
  599354
  609071
  617659
  641807
  678764
  757724
  761039
  781924
  796829
]

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 (383985, 391287, 391703, 398559, 398949, 400826, 400849, 401657, 411693, 423966, 443105, 444913, 444915, 444918, 453408, 454177, 454224, 454499, 456312, 458000, 458974, 459472, 459476, 460294, 460758, 463973, 464023, 464031, 466992, 467029, 474629, 474923, 476015, 476619, 477717, 483448, 483885, 484367, 485689, 485698, 485766, 488439, 489721, 491164, 491436, 492462, 495040, 499472, 504864, 507640, 507643, 509643, 509842, 510425, 511086, 513581, 513583, 525307, 525468, 527424, 527842, 528512, 541078, 542724, 550220, 555055, 560828, 562418, 562423, 563732, 567063, 590418, 592985, 599354, 609071, 617659, 641807, 678764, 757724, 761039, 781924, 796829);

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';