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

[
  "granny anal blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'granny anal blowjob' 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
  515086
  439813
  677974
  678805
  474629
  506846
  795084
  515089
  486483
  453100
  678795
  604574
  513785
  824935
  522619
  678791
  476239
  451504
  531534
  742849
  485711
  810775
  522596
  564292
  382971
  678778
  678782
  624468
  610083
  381752
  567424
  530729
  409408
  465299
  483152
  678790
  500467
  387905
  514436
  411737
  413454
  482320
  411998
  578823
  522592
  524882
  480290
  475294
  504481
  487343
  474836
  484624
  678804
  480757
  549233
  489831
  678779
  466979
  518858
  466982
  516744
  746162
  506801
  413461
  484656
  474125
  454277
  521131
  522616
  549225
  521123
  515723
  525511
  580340
  385163
  478672
  574384
  483355
  485374
  550434
  549239
  559132
]

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 (515086, 439813, 677974, 678805, 474629, 506846, 795084, 515089, 486483, 453100, 678795, 604574, 513785, 824935, 522619, 678791, 476239, 451504, 531534, 742849, 485711, 810775, 522596, 564292, 382971, 678778, 678782, 624468, 610083, 381752, 567424, 530729, 409408, 465299, 483152, 678790, 500467, 387905, 514436, 411737, 413454, 482320, 411998, 578823, 522592, 524882, 480290, 475294, 504481, 487343, 474836, 484624, 678804, 480757, 549233, 489831, 678779, 466979, 518858, 466982, 516744, 746162, 506801, 413461, 484656, 474125, 454277, 521131, 522616, 549225, 521123, 515723, 525511, 580340, 385163, 478672, 574384, 483355, 485374, 550434, 549239, 559132);

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
  381752
  382971
  385163
  387905
  409408
  411737
  411998
  413454
  413461
  439813
  451504
  453100
  454277
  465299
  466979
  466982
  474125
  474629
  474836
  475294
  476239
  478672
  480290
  480757
  482320
  483152
  483355
  484624
  484656
  485374
  485711
  486483
  487343
  489831
  500467
  504481
  506801
  506846
  513785
  514436
  515086
  515089
  515723
  516744
  518858
  521123
  521131
  522592
  522596
  522616
  522619
  524882
  525511
  530729
  531534
  549225
  549233
  549239
  550434
  559132
  564292
  567424
  574384
  578823
  580340
  604574
  610083
  624468
  677974
  678778
  678779
  678782
  678790
  678791
  678795
  678804
  678805
  742849
  746162
  795084
  810775
  824935
]

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 (381752, 382971, 385163, 387905, 409408, 411737, 411998, 413454, 413461, 439813, 451504, 453100, 454277, 465299, 466979, 466982, 474125, 474629, 474836, 475294, 476239, 478672, 480290, 480757, 482320, 483152, 483355, 484624, 484656, 485374, 485711, 486483, 487343, 489831, 500467, 504481, 506801, 506846, 513785, 514436, 515086, 515089, 515723, 516744, 518858, 521123, 521131, 522592, 522596, 522616, 522619, 524882, 525511, 530729, 531534, 549225, 549233, 549239, 550434, 559132, 564292, 567424, 574384, 578823, 580340, 604574, 610083, 624468, 677974, 678778, 678779, 678782, 678790, 678791, 678795, 678804, 678805, 742849, 746162, 795084, 810775, 824935);

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
  381752
  382971
  385163
  387905
  409408
  411737
  411998
  413454
  413461
  439813
  451504
  453100
  454277
  465299
  466979
  466982
  474125
  474629
  474836
  475294
  476239
  478672
  480290
  480757
  482320
  483152
  483355
  484624
  484656
  485374
  485711
  486483
  487343
  489831
  500467
  504481
  506801
  506846
  513785
  514436
  515086
  515089
  515723
  516744
  518858
  521123
  521131
  522592
  522596
  522616
  522619
  524882
  525511
  530729
  531534
  549225
  549233
  549239
  550434
  559132
  564292
  567424
  574384
  578823
  580340
  604574
  610083
  624468
  677974
  678778
  678779
  678782
  678790
  678791
  678795
  678804
  678805
  742849
  746162
  795084
  810775
  824935
]

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 (381752, 382971, 385163, 387905, 409408, 411737, 411998, 413454, 413461, 439813, 451504, 453100, 454277, 465299, 466979, 466982, 474125, 474629, 474836, 475294, 476239, 478672, 480290, 480757, 482320, 483152, 483355, 484624, 484656, 485374, 485711, 486483, 487343, 489831, 500467, 504481, 506801, 506846, 513785, 514436, 515086, 515089, 515723, 516744, 518858, 521123, 521131, 522592, 522596, 522616, 522619, 524882, 525511, 530729, 531534, 549225, 549233, 549239, 550434, 559132, 564292, 567424, 574384, 578823, 580340, 604574, 610083, 624468, 677974, 678778, 678779, 678782, 678790, 678791, 678795, 678804, 678805, 742849, 746162, 795084, 810775, 824935);

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

[
  "granny анал минет оральн секс"
]

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

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

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

[
  "granny анал минет оральн секс"
]

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

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