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

[
  "big ass latinos"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big ass latinos' 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
  485468
  732326
  673003
  602470
  641308
  595549
  635184
  730244
  632121
  589436
  814515
  567606
  595939
  605101
  623643
  640431
  617441
  810249
  755759
  813227
  471397
  771874
  561345
  805439
  514928
  533425
  676886
  679653
  588673
  589612
  805945
  809368
  809291
  445742
  561309
  511777
  564690
  478935
  516020
  654914
  579331
  588626
  623879
  625808
  760952
  612418
  513833
  483571
  636007
  620990
  643376
  481943
  564737
  588644
  644762
  793425
  429775
  666717
  579149
  677279
  624502
  612008
  523049
  493281
  504757
  548848
  590720
  564741
  471403
  699610
  612335
  716892
  626136
  519930
]

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 (485468, 732326, 673003, 602470, 641308, 595549, 635184, 730244, 632121, 589436, 814515, 567606, 595939, 605101, 623643, 640431, 617441, 810249, 755759, 813227, 471397, 771874, 561345, 805439, 514928, 533425, 676886, 679653, 588673, 589612, 805945, 809368, 809291, 445742, 561309, 511777, 564690, 478935, 516020, 654914, 579331, 588626, 623879, 625808, 760952, 612418, 513833, 483571, 636007, 620990, 643376, 481943, 564737, 588644, 644762, 793425, 429775, 666717, 579149, 677279, 624502, 612008, 523049, 493281, 504757, 548848, 590720, 564741, 471403, 699610, 612335, 716892, 626136, 519930);

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
  429775
  445742
  471397
  471403
  478935
  481943
  483571
  485468
  493281
  504757
  511777
  513833
  514928
  516020
  519930
  523049
  533425
  548848
  561309
  561345
  564690
  564737
  564741
  567606
  579149
  579331
  588626
  588644
  588673
  589436
  589612
  590720
  595549
  595939
  602470
  605101
  612008
  612335
  612418
  617441
  620990
  623643
  623879
  624502
  625808
  626136
  632121
  635184
  636007
  640431
  641308
  643376
  644762
  654914
  666717
  673003
  676886
  677279
  679653
  699610
  716892
  730244
  732326
  755759
  760952
  771874
  793425
  805439
  805945
  809291
  809368
  810249
  813227
  814515
]

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 (429775, 445742, 471397, 471403, 478935, 481943, 483571, 485468, 493281, 504757, 511777, 513833, 514928, 516020, 519930, 523049, 533425, 548848, 561309, 561345, 564690, 564737, 564741, 567606, 579149, 579331, 588626, 588644, 588673, 589436, 589612, 590720, 595549, 595939, 602470, 605101, 612008, 612335, 612418, 617441, 620990, 623643, 623879, 624502, 625808, 626136, 632121, 635184, 636007, 640431, 641308, 643376, 644762, 654914, 666717, 673003, 676886, 677279, 679653, 699610, 716892, 730244, 732326, 755759, 760952, 771874, 793425, 805439, 805945, 809291, 809368, 810249, 813227, 814515);

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
  429775
  445742
  471397
  471403
  478935
  481943
  483571
  485468
  493281
  504757
  511777
  513833
  514928
  516020
  519930
  523049
  533425
  548848
  561309
  561345
  564690
  564737
  564741
  567606
  579149
  579331
  588626
  588644
  588673
  589436
  589612
  590720
  595549
  595939
  602470
  605101
  612008
  612335
  612418
  617441
  620990
  623643
  623879
  624502
  625808
  626136
  632121
  635184
  636007
  640431
  641308
  643376
  644762
  654914
  666717
  673003
  676886
  677279
  679653
  699610
  716892
  730244
  732326
  755759
  760952
  771874
  793425
  805439
  805945
  809291
  809368
  810249
  813227
  814515
]

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 (429775, 445742, 471397, 471403, 478935, 481943, 483571, 485468, 493281, 504757, 511777, 513833, 514928, 516020, 519930, 523049, 533425, 548848, 561309, 561345, 564690, 564737, 564741, 567606, 579149, 579331, 588626, 588644, 588673, 589436, 589612, 590720, 595549, 595939, 602470, 605101, 612008, 612335, 612418, 617441, 620990, 623643, 623879, 624502, 625808, 626136, 632121, 635184, 636007, 640431, 641308, 643376, 644762, 654914, 666717, 673003, 676886, 677279, 679653, 699610, 716892, 730244, 732326, 755759, 760952, 771874, 793425, 805439, 805945, 809291, 809368, 810249, 813227, 814515);

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` = 'большая большие жоп латинский';