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

[
  "русский частный мжм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русский частный мжм' 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
  502538
  427182
  474639
  470074
  486332
  447401
  484713
  511875
  470385
  517841
  484465
  522215
  484748
  476022
  462321
  429449
  552266
  481149
  602506
  504189
  500622
  484622
  543536
  470604
  484628
  512583
  485702
  556422
  424060
  475807
  484708
  492050
  513606
  513710
  484485
  524527
  667985
  527900
  491380
  482506
  446894
  454984
  456690
  505048
  517117
  517567
  512538
  509810
  506056
  556436
  466112
  419550
  454521
  494036
  529457
  513607
  518521
  516090
  443822
  545015
  484818
  522662
  466090
  641732
  634230
  583723
  637002
  460733
  518012
  611649
  521832
  543551
  657670
  603933
  628426
  492111
  547997
  661565
  796444
  624984
  560486
]

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 (502538, 427182, 474639, 470074, 486332, 447401, 484713, 511875, 470385, 517841, 484465, 522215, 484748, 476022, 462321, 429449, 552266, 481149, 602506, 504189, 500622, 484622, 543536, 470604, 484628, 512583, 485702, 556422, 424060, 475807, 484708, 492050, 513606, 513710, 484485, 524527, 667985, 527900, 491380, 482506, 446894, 454984, 456690, 505048, 517117, 517567, 512538, 509810, 506056, 556436, 466112, 419550, 454521, 494036, 529457, 513607, 518521, 516090, 443822, 545015, 484818, 522662, 466090, 641732, 634230, 583723, 637002, 460733, 518012, 611649, 521832, 543551, 657670, 603933, 628426, 492111, 547997, 661565, 796444, 624984, 560486);

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
  419550
  424060
  427182
  429449
  443822
  446894
  447401
  454521
  454984
  456690
  460733
  462321
  466090
  466112
  470074
  470385
  470604
  474639
  475807
  476022
  481149
  482506
  484465
  484485
  484622
  484628
  484708
  484713
  484748
  484818
  485702
  486332
  491380
  492050
  492111
  494036
  500622
  502538
  504189
  505048
  506056
  509810
  511875
  512538
  512583
  513606
  513607
  513710
  516090
  517117
  517567
  517841
  518012
  518521
  521832
  522215
  522662
  524527
  527900
  529457
  543536
  543551
  545015
  547997
  552266
  556422
  556436
  560486
  583723
  602506
  603933
  611649
  624984
  628426
  634230
  637002
  641732
  657670
  661565
  667985
  796444
]

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 (419550, 424060, 427182, 429449, 443822, 446894, 447401, 454521, 454984, 456690, 460733, 462321, 466090, 466112, 470074, 470385, 470604, 474639, 475807, 476022, 481149, 482506, 484465, 484485, 484622, 484628, 484708, 484713, 484748, 484818, 485702, 486332, 491380, 492050, 492111, 494036, 500622, 502538, 504189, 505048, 506056, 509810, 511875, 512538, 512583, 513606, 513607, 513710, 516090, 517117, 517567, 517841, 518012, 518521, 521832, 522215, 522662, 524527, 527900, 529457, 543536, 543551, 545015, 547997, 552266, 556422, 556436, 560486, 583723, 602506, 603933, 611649, 624984, 628426, 634230, 637002, 641732, 657670, 661565, 667985, 796444);

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
  419550
  424060
  427182
  429449
  443822
  446894
  447401
  454521
  454984
  456690
  460733
  462321
  466090
  466112
  470074
  470385
  470604
  474639
  475807
  476022
  481149
  482506
  484465
  484485
  484622
  484628
  484708
  484713
  484748
  484818
  485702
  486332
  491380
  492050
  492111
  494036
  500622
  502538
  504189
  505048
  506056
  509810
  511875
  512538
  512583
  513606
  513607
  513710
  516090
  517117
  517567
  517841
  518012
  518521
  521832
  522215
  522662
  524527
  527900
  529457
  543536
  543551
  545015
  547997
  552266
  556422
  556436
  560486
  583723
  602506
  603933
  611649
  624984
  628426
  634230
  637002
  641732
  657670
  661565
  667985
  796444
]

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 (419550, 424060, 427182, 429449, 443822, 446894, 447401, 454521, 454984, 456690, 460733, 462321, 466090, 466112, 470074, 470385, 470604, 474639, 475807, 476022, 481149, 482506, 484465, 484485, 484622, 484628, 484708, 484713, 484748, 484818, 485702, 486332, 491380, 492050, 492111, 494036, 500622, 502538, 504189, 505048, 506056, 509810, 511875, 512538, 512583, 513606, 513607, 513710, 516090, 517117, 517567, 517841, 518012, 518521, 521832, 522215, 522662, 524527, 527900, 529457, 543536, 543551, 545015, 547997, 552266, 556422, 556436, 560486, 583723, 602506, 603933, 611649, 624984, 628426, 634230, 637002, 641732, 657670, 661565, 667985, 796444);

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` = 'русск любительск мжм секс втро';