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 masturbate"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian masturbate' 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
  555057
  558323
  564988
  614612
  588767
  643488
  617045
  806271
  801560
  412688
  439378
  428249
  444839
  477619
  478785
  435734
  515448
  514407
  522040
  524307
  525471
  527707
  494204
  435398
  777006
  424255
  517124
  545680
  543340
  554756
  689036
  689978
  560034
  567272
  615835
  609982
  424219
  427497
  458866
  421579
  424001
  463976
  438333
  509430
  520040
  515736
  522689
  485297
  502579
  520134
  599616
  426084
  455719
  555972
  561919
  625436
  470207
  475379
  417427
  452300
  464528
  476492
  525842
  502216
  520203
  623108
  422171
  417396
  434322
  560385
  593129
  453394
  520201
  522314
  517088
  518227
  577823
  604298
  621259
]

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 (555057, 558323, 564988, 614612, 588767, 643488, 617045, 806271, 801560, 412688, 439378, 428249, 444839, 477619, 478785, 435734, 515448, 514407, 522040, 524307, 525471, 527707, 494204, 435398, 777006, 424255, 517124, 545680, 543340, 554756, 689036, 689978, 560034, 567272, 615835, 609982, 424219, 427497, 458866, 421579, 424001, 463976, 438333, 509430, 520040, 515736, 522689, 485297, 502579, 520134, 599616, 426084, 455719, 555972, 561919, 625436, 470207, 475379, 417427, 452300, 464528, 476492, 525842, 502216, 520203, 623108, 422171, 417396, 434322, 560385, 593129, 453394, 520201, 522314, 517088, 518227, 577823, 604298, 621259);

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
  412688
  417396
  417427
  421579
  422171
  424001
  424219
  424255
  426084
  427497
  428249
  434322
  435398
  435734
  438333
  439378
  444839
  452300
  453394
  455719
  458866
  463976
  464528
  470207
  475379
  476492
  477619
  478785
  485297
  494204
  502216
  502579
  509430
  514407
  515448
  515736
  517088
  517124
  518227
  520040
  520134
  520201
  520203
  522040
  522314
  522689
  524307
  525471
  525842
  527707
  543340
  545680
  554756
  555057
  555972
  558323
  560034
  560385
  561919
  564988
  567272
  577823
  588767
  593129
  599616
  604298
  614612
  615835
  617045
  621259
  623108
  625436
  643488
  689036
  689978
  777006
  801560
  806271
]

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 (412688, 417396, 417427, 421579, 422171, 424001, 424219, 424255, 426084, 427497, 428249, 434322, 435398, 435734, 438333, 439378, 444839, 452300, 453394, 455719, 458866, 463976, 464528, 470207, 475379, 476492, 477619, 478785, 485297, 494204, 502216, 502579, 509430, 514407, 515448, 515736, 517088, 517124, 518227, 520040, 520134, 520201, 520203, 522040, 522314, 522689, 524307, 525471, 525842, 527707, 543340, 545680, 554756, 555057, 555972, 558323, 560034, 560385, 561919, 564988, 567272, 577823, 588767, 593129, 599616, 604298, 614612, 615835, 617045, 621259, 623108, 625436, 643488, 689036, 689978, 777006, 801560, 806271);

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
  412688
  417396
  417427
  421579
  422171
  424001
  424219
  424255
  426084
  427497
  428249
  434322
  435398
  435734
  438333
  439378
  444839
  452300
  453394
  455719
  458866
  463976
  464528
  470207
  475379
  476492
  477619
  478785
  485297
  494204
  502216
  502579
  509430
  514407
  515448
  515736
  517088
  517124
  518227
  520040
  520134
  520201
  520203
  522040
  522314
  522689
  524307
  525471
  525842
  527707
  543340
  545680
  554756
  555057
  555972
  558323
  560034
  560385
  561919
  564988
  567272
  577823
  588767
  593129
  599616
  604298
  614612
  615835
  617045
  621259
  623108
  625436
  643488
  689036
  689978
  777006
  801560
  806271
]

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 (412688, 417396, 417427, 421579, 422171, 424001, 424219, 424255, 426084, 427497, 428249, 434322, 435398, 435734, 438333, 439378, 444839, 452300, 453394, 455719, 458866, 463976, 464528, 470207, 475379, 476492, 477619, 478785, 485297, 494204, 502216, 502579, 509430, 514407, 515448, 515736, 517088, 517124, 518227, 520040, 520134, 520201, 520203, 522040, 522314, 522689, 524307, 525471, 525842, 527707, 543340, 545680, 554756, 555057, 555972, 558323, 560034, 560385, 561919, 564988, 567272, 577823, 588767, 593129, 599616, 604298, 614612, 615835, 617045, 621259, 623108, 625436, 643488, 689036, 689978, 777006, 801560, 806271);

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

[
  "русск masturbate"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск masturbate';

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

[
  "русск masturbate"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск masturbate';