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

[
  "big tits masturbating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big tits masturbating' 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
  546884
  601893
  809899
  415779
  571193
  435813
  467233
  478186
  506113
  566955
  518870
  569309
  525179
  486875
  434608
  599257
  515952
  538530
  423760
  714380
  497225
  588899
  810962
  714927
  503506
  516281
  383436
  61399
  517950
  669665
  585300
  598840
  594434
  643005
  793845
  418069
  563443
  588200
  426550
  429861
  450281
  591432
  447839
  519510
  507669
  573339
  572358
  526727
  487742
  484702
  516332
  549800
  597781
  626436
  437605
  523458
  419198
  512377
  593054
  414767
  594125
  504626
  599644
  603286
  626576
  466204
  444309
  593018
  454215
  511159
  672769
  565752
  805139
  531090
  449073
  496977
  563362
  526718
  446988
  513480
  591368
  589642
  618326
  571033
  598870
]

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 (546884, 601893, 809899, 415779, 571193, 435813, 467233, 478186, 506113, 566955, 518870, 569309, 525179, 486875, 434608, 599257, 515952, 538530, 423760, 714380, 497225, 588899, 810962, 714927, 503506, 516281, 383436, 61399, 517950, 669665, 585300, 598840, 594434, 643005, 793845, 418069, 563443, 588200, 426550, 429861, 450281, 591432, 447839, 519510, 507669, 573339, 572358, 526727, 487742, 484702, 516332, 549800, 597781, 626436, 437605, 523458, 419198, 512377, 593054, 414767, 594125, 504626, 599644, 603286, 626576, 466204, 444309, 593018, 454215, 511159, 672769, 565752, 805139, 531090, 449073, 496977, 563362, 526718, 446988, 513480, 591368, 589642, 618326, 571033, 598870);

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
  61399
  383436
  414767
  415779
  418069
  419198
  423760
  426550
  429861
  434608
  435813
  437605
  444309
  446988
  447839
  449073
  450281
  454215
  466204
  467233
  478186
  484702
  486875
  487742
  496977
  497225
  503506
  504626
  506113
  507669
  511159
  512377
  513480
  515952
  516281
  516332
  517950
  518870
  519510
  523458
  525179
  526718
  526727
  531090
  538530
  546884
  549800
  563362
  563443
  565752
  566955
  569309
  571033
  571193
  572358
  573339
  585300
  588200
  588899
  589642
  591368
  591432
  593018
  593054
  594125
  594434
  597781
  598840
  598870
  599257
  599644
  601893
  603286
  618326
  626436
  626576
  643005
  669665
  672769
  714380
  714927
  793845
  805139
  809899
  810962
]

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 (61399, 383436, 414767, 415779, 418069, 419198, 423760, 426550, 429861, 434608, 435813, 437605, 444309, 446988, 447839, 449073, 450281, 454215, 466204, 467233, 478186, 484702, 486875, 487742, 496977, 497225, 503506, 504626, 506113, 507669, 511159, 512377, 513480, 515952, 516281, 516332, 517950, 518870, 519510, 523458, 525179, 526718, 526727, 531090, 538530, 546884, 549800, 563362, 563443, 565752, 566955, 569309, 571033, 571193, 572358, 573339, 585300, 588200, 588899, 589642, 591368, 591432, 593018, 593054, 594125, 594434, 597781, 598840, 598870, 599257, 599644, 601893, 603286, 618326, 626436, 626576, 643005, 669665, 672769, 714380, 714927, 793845, 805139, 809899, 810962);

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
  61399
  383436
  414767
  415779
  418069
  419198
  423760
  426550
  429861
  434608
  435813
  437605
  444309
  446988
  447839
  449073
  450281
  454215
  466204
  467233
  478186
  484702
  486875
  487742
  496977
  497225
  503506
  504626
  506113
  507669
  511159
  512377
  513480
  515952
  516281
  516332
  517950
  518870
  519510
  523458
  525179
  526718
  526727
  531090
  538530
  546884
  549800
  563362
  563443
  565752
  566955
  569309
  571033
  571193
  572358
  573339
  585300
  588200
  588899
  589642
  591368
  591432
  593018
  593054
  594125
  594434
  597781
  598840
  598870
  599257
  599644
  601893
  603286
  618326
  626436
  626576
  643005
  669665
  672769
  714380
  714927
  793845
  805139
  809899
  810962
]

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 (61399, 383436, 414767, 415779, 418069, 419198, 423760, 426550, 429861, 434608, 435813, 437605, 444309, 446988, 447839, 449073, 450281, 454215, 466204, 467233, 478186, 484702, 486875, 487742, 496977, 497225, 503506, 504626, 506113, 507669, 511159, 512377, 513480, 515952, 516281, 516332, 517950, 518870, 519510, 523458, 525179, 526718, 526727, 531090, 538530, 546884, 549800, 563362, 563443, 565752, 566955, 569309, 571033, 571193, 572358, 573339, 585300, 588200, 588899, 589642, 591368, 591432, 593018, 593054, 594125, 594434, 597781, 598840, 598870, 599257, 599644, 601893, 603286, 618326, 626436, 626576, 643005, 669665, 672769, 714380, 714927, 793845, 805139, 809899, 810962);

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

[
  "большие сиськ masturbating"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие сиськ masturbating';

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

[
  "большие сиськ masturbating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие сиськ masturbating';