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

[
  "curvy blowjob pov"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curvy blowjob pov' 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
  828088
  822246
  766769
  403539
  823410
  808508
  773225
  795545
  779584
  795103
  802671
  607557
  607579
  800470
  723189
  821405
  776557
  795754
  799568
  585111
  730819
  715445
  698128
  774294
  784961
  784794
  800875
  802445
  804800
  805737
  579430
  784788
  619647
  784828
  795522
  813431
  800016
  755348
  634416
  821195
  765403
  756589
  761244
  784494
  809281
  607454
  593469
  457569
  544019
  528021
  696128
  804178
  473060
  493470
  462392
  468837
  423433
  572843
  453705
  416169
  522628
  792812
  586520
  503556
  552983
  456607
  448084
  569153
  556854
  520694
  475247
  603705
  495579
  457832
  486868
  587901
  459512
  526373
  610588
  427543
]

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 (828088, 822246, 766769, 403539, 823410, 808508, 773225, 795545, 779584, 795103, 802671, 607557, 607579, 800470, 723189, 821405, 776557, 795754, 799568, 585111, 730819, 715445, 698128, 774294, 784961, 784794, 800875, 802445, 804800, 805737, 579430, 784788, 619647, 784828, 795522, 813431, 800016, 755348, 634416, 821195, 765403, 756589, 761244, 784494, 809281, 607454, 593469, 457569, 544019, 528021, 696128, 804178, 473060, 493470, 462392, 468837, 423433, 572843, 453705, 416169, 522628, 792812, 586520, 503556, 552983, 456607, 448084, 569153, 556854, 520694, 475247, 603705, 495579, 457832, 486868, 587901, 459512, 526373, 610588, 427543);

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
  403539
  416169
  423433
  427543
  448084
  453705
  456607
  457569
  457832
  459512
  462392
  468837
  473060
  475247
  486868
  493470
  495579
  503556
  520694
  522628
  526373
  528021
  544019
  552983
  556854
  569153
  572843
  579430
  585111
  586520
  587901
  593469
  603705
  607454
  607557
  607579
  610588
  619647
  634416
  696128
  698128
  715445
  723189
  730819
  755348
  756589
  761244
  765403
  766769
  773225
  774294
  776557
  779584
  784494
  784788
  784794
  784961
  792812
  795103
  795522
  795545
  795754
  799568
  800016
  800470
  800875
  802445
  802671
  804178
  804800
  805737
  808508
  809281
  813431
  821195
  821405
  822246
  823410
  828088
]

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 (403539, 416169, 423433, 427543, 448084, 453705, 456607, 457569, 457832, 459512, 462392, 468837, 473060, 475247, 486868, 493470, 495579, 503556, 520694, 522628, 526373, 528021, 544019, 552983, 556854, 569153, 572843, 579430, 585111, 586520, 587901, 593469, 603705, 607454, 607557, 607579, 610588, 619647, 634416, 696128, 698128, 715445, 723189, 730819, 755348, 756589, 761244, 765403, 766769, 773225, 774294, 776557, 779584, 784494, 784788, 784794, 784961, 792812, 795103, 795522, 795545, 795754, 799568, 800016, 800470, 800875, 802445, 802671, 804178, 804800, 805737, 808508, 809281, 813431, 821195, 821405, 822246, 823410, 828088);

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
  403539
  416169
  423433
  427543
  448084
  453705
  456607
  457569
  457832
  459512
  462392
  468837
  473060
  475247
  486868
  493470
  495579
  503556
  520694
  522628
  526373
  528021
  544019
  552983
  556854
  569153
  572843
  579430
  585111
  586520
  587901
  593469
  603705
  607454
  607557
  607579
  610588
  619647
  634416
  696128
  698128
  715445
  723189
  730819
  755348
  756589
  761244
  765403
  766769
  773225
  774294
  776557
  779584
  784494
  784788
  784794
  784961
  792812
  795103
  795522
  795545
  795754
  799568
  800016
  800470
  800875
  802445
  802671
  804178
  804800
  805737
  808508
  809281
  813431
  821195
  821405
  822246
  823410
  828088
]

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 (403539, 416169, 423433, 427543, 448084, 453705, 456607, 457569, 457832, 459512, 462392, 468837, 473060, 475247, 486868, 493470, 495579, 503556, 520694, 522628, 526373, 528021, 544019, 552983, 556854, 569153, 572843, 579430, 585111, 586520, 587901, 593469, 603705, 607454, 607557, 607579, 610588, 619647, 634416, 696128, 698128, 715445, 723189, 730819, 755348, 756589, 761244, 765403, 766769, 773225, 774294, 776557, 779584, 784494, 784788, 784794, 784961, 792812, 795103, 795522, 795545, 795754, 799568, 800016, 800470, 800875, 802445, 802671, 804178, 804800, 805737, 808508, 809281, 813431, 821195, 821405, 822246, 823410, 828088);

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

[
  "curvy минет оральн секс пов"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'curvy минет оральн секс пов';

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

[
  "curvy минет оральн секс пов"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curvy минет оральн секс пов';