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 car"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latina car' 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
  673150
  679441
  603156
  636562
  777064
  785519
  787007
  800864
  788811
  770520
  627877
  777065
  531776
  413524
  451990
  444482
  491673
  475267
  465449
  449425
  520409
  521811
  537600
  506775
  486730
  679453
  679457
  559586
  601204
  598861
  592345
  638360
  780574
  780595
  759658
  630909
  777078
  383366
  446402
  418860
  506596
  523082
  530774
  523758
  528714
  558536
  679420
  689622
  589718
  632356
  605941
  756212
  437857
  410712
  518726
  517283
  538854
  597142
  638326
  633175
  455808
  719563
  638967
  484299
  504610
  518265
  526188
  689634
  747033
  457645
  679465
  649908
  560179
  514095
  821345
  822024
  822296
  406841
  532357
  632020
  821620
  461624
  445641
  512797
  814916
  541567
  573940
  564157
  488198
  540476
]

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 (673150, 679441, 603156, 636562, 777064, 785519, 787007, 800864, 788811, 770520, 627877, 777065, 531776, 413524, 451990, 444482, 491673, 475267, 465449, 449425, 520409, 521811, 537600, 506775, 486730, 679453, 679457, 559586, 601204, 598861, 592345, 638360, 780574, 780595, 759658, 630909, 777078, 383366, 446402, 418860, 506596, 523082, 530774, 523758, 528714, 558536, 679420, 689622, 589718, 632356, 605941, 756212, 437857, 410712, 518726, 517283, 538854, 597142, 638326, 633175, 455808, 719563, 638967, 484299, 504610, 518265, 526188, 689634, 747033, 457645, 679465, 649908, 560179, 514095, 821345, 822024, 822296, 406841, 532357, 632020, 821620, 461624, 445641, 512797, 814916, 541567, 573940, 564157, 488198, 540476);

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
  383366
  406841
  410712
  413524
  418860
  437857
  444482
  445641
  446402
  449425
  451990
  455808
  457645
  461624
  465449
  475267
  484299
  486730
  488198
  491673
  504610
  506596
  506775
  512797
  514095
  517283
  518265
  518726
  520409
  521811
  523082
  523758
  526188
  528714
  530774
  531776
  532357
  537600
  538854
  540476
  541567
  558536
  559586
  560179
  564157
  573940
  589718
  592345
  597142
  598861
  601204
  603156
  605941
  627877
  630909
  632020
  632356
  633175
  636562
  638326
  638360
  638967
  649908
  673150
  679420
  679441
  679453
  679457
  679465
  689622
  689634
  719563
  747033
  756212
  759658
  770520
  777064
  777065
  777078
  780574
  780595
  785519
  787007
  788811
  800864
  814916
  821345
  821620
  822024
  822296
]

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 (383366, 406841, 410712, 413524, 418860, 437857, 444482, 445641, 446402, 449425, 451990, 455808, 457645, 461624, 465449, 475267, 484299, 486730, 488198, 491673, 504610, 506596, 506775, 512797, 514095, 517283, 518265, 518726, 520409, 521811, 523082, 523758, 526188, 528714, 530774, 531776, 532357, 537600, 538854, 540476, 541567, 558536, 559586, 560179, 564157, 573940, 589718, 592345, 597142, 598861, 601204, 603156, 605941, 627877, 630909, 632020, 632356, 633175, 636562, 638326, 638360, 638967, 649908, 673150, 679420, 679441, 679453, 679457, 679465, 689622, 689634, 719563, 747033, 756212, 759658, 770520, 777064, 777065, 777078, 780574, 780595, 785519, 787007, 788811, 800864, 814916, 821345, 821620, 822024, 822296);

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
  383366
  406841
  410712
  413524
  418860
  437857
  444482
  445641
  446402
  449425
  451990
  455808
  457645
  461624
  465449
  475267
  484299
  486730
  488198
  491673
  504610
  506596
  506775
  512797
  514095
  517283
  518265
  518726
  520409
  521811
  523082
  523758
  526188
  528714
  530774
  531776
  532357
  537600
  538854
  540476
  541567
  558536
  559586
  560179
  564157
  573940
  589718
  592345
  597142
  598861
  601204
  603156
  605941
  627877
  630909
  632020
  632356
  633175
  636562
  638326
  638360
  638967
  649908
  673150
  679420
  679441
  679453
  679457
  679465
  689622
  689634
  719563
  747033
  756212
  759658
  770520
  777064
  777065
  777078
  780574
  780595
  785519
  787007
  788811
  800864
  814916
  821345
  821620
  822024
  822296
]

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 (383366, 406841, 410712, 413524, 418860, 437857, 444482, 445641, 446402, 449425, 451990, 455808, 457645, 461624, 465449, 475267, 484299, 486730, 488198, 491673, 504610, 506596, 506775, 512797, 514095, 517283, 518265, 518726, 520409, 521811, 523082, 523758, 526188, 528714, 530774, 531776, 532357, 537600, 538854, 540476, 541567, 558536, 559586, 560179, 564157, 573940, 589718, 592345, 597142, 598861, 601204, 603156, 605941, 627877, 630909, 632020, 632356, 633175, 636562, 638326, 638360, 638967, 649908, 673150, 679420, 679441, 679453, 679457, 679465, 689622, 689634, 719563, 747033, 756212, 759658, 770520, 777064, 777065, 777078, 780574, 780595, 785519, 787007, 788811, 800864, 814916, 821345, 821620, 822024, 822296);

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` = 'латинская вмашин';