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

[
  "anal milf mommy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal milf mommy' 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
  387448
  750135
  731100
  197736
  767279
  815941
  699743
  426003
  666398
  743748
  397871
  815529
  816405
  694089
  446274
  791803
  358481
  592955
  815723
  825811
  530893
  692806
  544524
  503444
  472611
  421838
  476323
  466238
  448084
  761756
  604290
  530538
  466279
  466173
  466199
  513201
  605708
  472276
  428883
  466195
  466256
  466209
  471073
  466018
  484646
  528355
  412262
  470459
  474703
  478596
  484739
  457420
  428837
  474695
  631616
  470286
  467619
  465963
  474681
  485269
  456614
  463158
  484644
  412261
  466208
  466215
  468076
  474696
  428126
  466239
  456618
  484681
  472161
  474663
  561515
]

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 (387448, 750135, 731100, 197736, 767279, 815941, 699743, 426003, 666398, 743748, 397871, 815529, 816405, 694089, 446274, 791803, 358481, 592955, 815723, 825811, 530893, 692806, 544524, 503444, 472611, 421838, 476323, 466238, 448084, 761756, 604290, 530538, 466279, 466173, 466199, 513201, 605708, 472276, 428883, 466195, 466256, 466209, 471073, 466018, 484646, 528355, 412262, 470459, 474703, 478596, 484739, 457420, 428837, 474695, 631616, 470286, 467619, 465963, 474681, 485269, 456614, 463158, 484644, 412261, 466208, 466215, 468076, 474696, 428126, 466239, 456618, 484681, 472161, 474663, 561515);

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
  197736
  358481
  387448
  397871
  412261
  412262
  421838
  426003
  428126
  428837
  428883
  446274
  448084
  456614
  456618
  457420
  463158
  465963
  466018
  466173
  466195
  466199
  466208
  466209
  466215
  466238
  466239
  466256
  466279
  467619
  468076
  470286
  470459
  471073
  472161
  472276
  472611
  474663
  474681
  474695
  474696
  474703
  476323
  478596
  484644
  484646
  484681
  484739
  485269
  503444
  513201
  528355
  530538
  530893
  544524
  561515
  592955
  604290
  605708
  631616
  666398
  692806
  694089
  699743
  731100
  743748
  750135
  761756
  767279
  791803
  815529
  815723
  815941
  816405
  825811
]

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 (197736, 358481, 387448, 397871, 412261, 412262, 421838, 426003, 428126, 428837, 428883, 446274, 448084, 456614, 456618, 457420, 463158, 465963, 466018, 466173, 466195, 466199, 466208, 466209, 466215, 466238, 466239, 466256, 466279, 467619, 468076, 470286, 470459, 471073, 472161, 472276, 472611, 474663, 474681, 474695, 474696, 474703, 476323, 478596, 484644, 484646, 484681, 484739, 485269, 503444, 513201, 528355, 530538, 530893, 544524, 561515, 592955, 604290, 605708, 631616, 666398, 692806, 694089, 699743, 731100, 743748, 750135, 761756, 767279, 791803, 815529, 815723, 815941, 816405, 825811);

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
  197736
  358481
  387448
  397871
  412261
  412262
  421838
  426003
  428126
  428837
  428883
  446274
  448084
  456614
  456618
  457420
  463158
  465963
  466018
  466173
  466195
  466199
  466208
  466209
  466215
  466238
  466239
  466256
  466279
  467619
  468076
  470286
  470459
  471073
  472161
  472276
  472611
  474663
  474681
  474695
  474696
  474703
  476323
  478596
  484644
  484646
  484681
  484739
  485269
  503444
  513201
  528355
  530538
  530893
  544524
  561515
  592955
  604290
  605708
  631616
  666398
  692806
  694089
  699743
  731100
  743748
  750135
  761756
  767279
  791803
  815529
  815723
  815941
  816405
  825811
]

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 (197736, 358481, 387448, 397871, 412261, 412262, 421838, 426003, 428126, 428837, 428883, 446274, 448084, 456614, 456618, 457420, 463158, 465963, 466018, 466173, 466195, 466199, 466208, 466209, 466215, 466238, 466239, 466256, 466279, 467619, 468076, 470286, 470459, 471073, 472161, 472276, 472611, 474663, 474681, 474695, 474696, 474703, 476323, 478596, 484644, 484646, 484681, 484739, 485269, 503444, 513201, 528355, 530538, 530893, 544524, 561515, 592955, 604290, 605708, 631616, 666398, 692806, 694089, 699743, 731100, 743748, 750135, 761756, 767279, 791803, 815529, 815723, 815941, 816405, 825811);

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

[
  "анал milf mommy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал milf mommy';

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

[
  "анал milf mommy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал milf mommy';