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

[
  "super ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'super ass' 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
  515892
  519212
  500245
  567779
  677974
  752700
  468012
  565162
  451175
  435207
  533538
  509808
  536616
  542975
  571029
  588411
  448847
  407156
  509702
  523815
  522604
  470829
  537670
  641090
  469017
  510463
  422550
  464596
  560442
  542965
  564001
  668137
  640732
  428409
  450721
  464185
  532343
  535369
  512533
  536657
  526540
  650419
  557163
  522870
  534625
  416351
  500458
  532737
  560664
  559942
  423400
  463873
  447452
  534312
  680182
  704205
  589107
  516885
  536538
  523654
  474095
  518768
  689006
  593193
  604523
  556485
  519842
  536910
  618525
  543772
  545300
  648560
  461303
  593425
  523139
  601677
  634187
  601537
  584873
  523822
  612455
  513207
]

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 (515892, 519212, 500245, 567779, 677974, 752700, 468012, 565162, 451175, 435207, 533538, 509808, 536616, 542975, 571029, 588411, 448847, 407156, 509702, 523815, 522604, 470829, 537670, 641090, 469017, 510463, 422550, 464596, 560442, 542965, 564001, 668137, 640732, 428409, 450721, 464185, 532343, 535369, 512533, 536657, 526540, 650419, 557163, 522870, 534625, 416351, 500458, 532737, 560664, 559942, 423400, 463873, 447452, 534312, 680182, 704205, 589107, 516885, 536538, 523654, 474095, 518768, 689006, 593193, 604523, 556485, 519842, 536910, 618525, 543772, 545300, 648560, 461303, 593425, 523139, 601677, 634187, 601537, 584873, 523822, 612455, 513207);

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
  407156
  416351
  422550
  423400
  428409
  435207
  447452
  448847
  450721
  451175
  461303
  463873
  464185
  464596
  468012
  469017
  470829
  474095
  500245
  500458
  509702
  509808
  510463
  512533
  513207
  515892
  516885
  518768
  519212
  519842
  522604
  522870
  523139
  523654
  523815
  523822
  526540
  532343
  532737
  533538
  534312
  534625
  535369
  536538
  536616
  536657
  536910
  537670
  542965
  542975
  543772
  545300
  556485
  557163
  559942
  560442
  560664
  564001
  565162
  567779
  571029
  584873
  588411
  589107
  593193
  593425
  601537
  601677
  604523
  612455
  618525
  634187
  640732
  641090
  648560
  650419
  668137
  677974
  680182
  689006
  704205
  752700
]

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 (407156, 416351, 422550, 423400, 428409, 435207, 447452, 448847, 450721, 451175, 461303, 463873, 464185, 464596, 468012, 469017, 470829, 474095, 500245, 500458, 509702, 509808, 510463, 512533, 513207, 515892, 516885, 518768, 519212, 519842, 522604, 522870, 523139, 523654, 523815, 523822, 526540, 532343, 532737, 533538, 534312, 534625, 535369, 536538, 536616, 536657, 536910, 537670, 542965, 542975, 543772, 545300, 556485, 557163, 559942, 560442, 560664, 564001, 565162, 567779, 571029, 584873, 588411, 589107, 593193, 593425, 601537, 601677, 604523, 612455, 618525, 634187, 640732, 641090, 648560, 650419, 668137, 677974, 680182, 689006, 704205, 752700);

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
  407156
  416351
  422550
  423400
  428409
  435207
  447452
  448847
  450721
  451175
  461303
  463873
  464185
  464596
  468012
  469017
  470829
  474095
  500245
  500458
  509702
  509808
  510463
  512533
  513207
  515892
  516885
  518768
  519212
  519842
  522604
  522870
  523139
  523654
  523815
  523822
  526540
  532343
  532737
  533538
  534312
  534625
  535369
  536538
  536616
  536657
  536910
  537670
  542965
  542975
  543772
  545300
  556485
  557163
  559942
  560442
  560664
  564001
  565162
  567779
  571029
  584873
  588411
  589107
  593193
  593425
  601537
  601677
  604523
  612455
  618525
  634187
  640732
  641090
  648560
  650419
  668137
  677974
  680182
  689006
  704205
  752700
]

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 (407156, 416351, 422550, 423400, 428409, 435207, 447452, 448847, 450721, 451175, 461303, 463873, 464185, 464596, 468012, 469017, 470829, 474095, 500245, 500458, 509702, 509808, 510463, 512533, 513207, 515892, 516885, 518768, 519212, 519842, 522604, 522870, 523139, 523654, 523815, 523822, 526540, 532343, 532737, 533538, 534312, 534625, 535369, 536538, 536616, 536657, 536910, 537670, 542965, 542975, 543772, 545300, 556485, 557163, 559942, 560442, 560664, 564001, 565162, 567779, 571029, 584873, 588411, 589107, 593193, 593425, 601537, 601677, 604523, 612455, 618525, 634187, 640732, 641090, 648560, 650419, 668137, 677974, 680182, 689006, 704205, 752700);

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

[
  "super жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'super жоп';

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

[
  "super жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'super жоп';