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

[
  "latina squirt"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latina squirt' 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
  693944
  722380
  602259
  813221
  415004
  606346
  437810
  413649
  638044
  765559
  425820
  814777
  541919
  553061
  637416
  415388
  428494
  748997
  561479
  569818
  753772
  503840
  478492
  399591
  814031
  815017
  455217
  527405
  531129
  545441
  668534
  666883
  418597
  418596
  579769
  667974
  556825
  608574
  768862
  713440
  795398
  815268
  448821
  534312
  544680
  521581
  528077
  768871
  649546
  494081
  820190
  560949
  795018
  430700
  502043
  468019
  537640
  666734
  742865
  797443
  742100
  742817
  787867
  795812
  801068
  435916
  530671
  806931
  779840
  813101
  418595
  787506
  432637
  447004
  666714
  787556
  546804
  524320
  632095
  418601
]

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 (693944, 722380, 602259, 813221, 415004, 606346, 437810, 413649, 638044, 765559, 425820, 814777, 541919, 553061, 637416, 415388, 428494, 748997, 561479, 569818, 753772, 503840, 478492, 399591, 814031, 815017, 455217, 527405, 531129, 545441, 668534, 666883, 418597, 418596, 579769, 667974, 556825, 608574, 768862, 713440, 795398, 815268, 448821, 534312, 544680, 521581, 528077, 768871, 649546, 494081, 820190, 560949, 795018, 430700, 502043, 468019, 537640, 666734, 742865, 797443, 742100, 742817, 787867, 795812, 801068, 435916, 530671, 806931, 779840, 813101, 418595, 787506, 432637, 447004, 666714, 787556, 546804, 524320, 632095, 418601);

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
  399591
  413649
  415004
  415388
  418595
  418596
  418597
  418601
  425820
  428494
  430700
  432637
  435916
  437810
  447004
  448821
  455217
  468019
  478492
  494081
  502043
  503840
  521581
  524320
  527405
  528077
  530671
  531129
  534312
  537640
  541919
  544680
  545441
  546804
  553061
  556825
  560949
  561479
  569818
  579769
  602259
  606346
  608574
  632095
  637416
  638044
  649546
  666714
  666734
  666883
  667974
  668534
  693944
  713440
  722380
  742100
  742817
  742865
  748997
  753772
  765559
  768862
  768871
  779840
  787506
  787556
  787867
  795018
  795398
  795812
  797443
  801068
  806931
  813101
  813221
  814031
  814777
  815017
  815268
  820190
]

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 (399591, 413649, 415004, 415388, 418595, 418596, 418597, 418601, 425820, 428494, 430700, 432637, 435916, 437810, 447004, 448821, 455217, 468019, 478492, 494081, 502043, 503840, 521581, 524320, 527405, 528077, 530671, 531129, 534312, 537640, 541919, 544680, 545441, 546804, 553061, 556825, 560949, 561479, 569818, 579769, 602259, 606346, 608574, 632095, 637416, 638044, 649546, 666714, 666734, 666883, 667974, 668534, 693944, 713440, 722380, 742100, 742817, 742865, 748997, 753772, 765559, 768862, 768871, 779840, 787506, 787556, 787867, 795018, 795398, 795812, 797443, 801068, 806931, 813101, 813221, 814031, 814777, 815017, 815268, 820190);

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
  399591
  413649
  415004
  415388
  418595
  418596
  418597
  418601
  425820
  428494
  430700
  432637
  435916
  437810
  447004
  448821
  455217
  468019
  478492
  494081
  502043
  503840
  521581
  524320
  527405
  528077
  530671
  531129
  534312
  537640
  541919
  544680
  545441
  546804
  553061
  556825
  560949
  561479
  569818
  579769
  602259
  606346
  608574
  632095
  637416
  638044
  649546
  666714
  666734
  666883
  667974
  668534
  693944
  713440
  722380
  742100
  742817
  742865
  748997
  753772
  765559
  768862
  768871
  779840
  787506
  787556
  787867
  795018
  795398
  795812
  797443
  801068
  806931
  813101
  813221
  814031
  814777
  815017
  815268
  820190
]

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 (399591, 413649, 415004, 415388, 418595, 418596, 418597, 418601, 425820, 428494, 430700, 432637, 435916, 437810, 447004, 448821, 455217, 468019, 478492, 494081, 502043, 503840, 521581, 524320, 527405, 528077, 530671, 531129, 534312, 537640, 541919, 544680, 545441, 546804, 553061, 556825, 560949, 561479, 569818, 579769, 602259, 606346, 608574, 632095, 637416, 638044, 649546, 666714, 666734, 666883, 667974, 668534, 693944, 713440, 722380, 742100, 742817, 742865, 748997, 753772, 765559, 768862, 768871, 779840, 787506, 787556, 787867, 795018, 795398, 795812, 797443, 801068, 806931, 813101, 813221, 814031, 814777, 815017, 815268, 820190);

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

[
  "латинская сквирт оргазм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'латинская сквирт оргазм';

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

[
  "латинская сквирт оргазм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'латинская сквирт оргазм';