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

[
  "teen try"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen try' 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
  792059
  764875
  751307
  790870
  812025
  509872
  523891
  485919
  510512
  404370
  446289
  452202
  451878
  474572
  497697
  475467
  541099
  542818
  651068
  708468
  595849
  634565
  788903
  451283
  518731
  512901
  523743
  641983
  441366
  410913
  428594
  451875
  452727
  455816
  449484
  458404
  524676
  523357
  490174
  575811
  559687
  590802
  599081
  624578
  776153
  748349
  612039
  445831
  467194
  481807
  397982
  448012
  421488
  441631
  506996
  490685
  558159
  680498
  561023
  614693
  602948
  624915
  479866
  526818
  535526
  489109
  395915
  469852
  448314
  558886
  601674
  720708
  395738
  564705
  597488
  476828
  490608
  618561
  477097
  519563
  617039
  615818
]

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 (792059, 764875, 751307, 790870, 812025, 509872, 523891, 485919, 510512, 404370, 446289, 452202, 451878, 474572, 497697, 475467, 541099, 542818, 651068, 708468, 595849, 634565, 788903, 451283, 518731, 512901, 523743, 641983, 441366, 410913, 428594, 451875, 452727, 455816, 449484, 458404, 524676, 523357, 490174, 575811, 559687, 590802, 599081, 624578, 776153, 748349, 612039, 445831, 467194, 481807, 397982, 448012, 421488, 441631, 506996, 490685, 558159, 680498, 561023, 614693, 602948, 624915, 479866, 526818, 535526, 489109, 395915, 469852, 448314, 558886, 601674, 720708, 395738, 564705, 597488, 476828, 490608, 618561, 477097, 519563, 617039, 615818);

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
  395738
  395915
  397982
  404370
  410913
  421488
  428594
  441366
  441631
  445831
  446289
  448012
  448314
  449484
  451283
  451875
  451878
  452202
  452727
  455816
  458404
  467194
  469852
  474572
  475467
  476828
  477097
  479866
  481807
  485919
  489109
  490174
  490608
  490685
  497697
  506996
  509872
  510512
  512901
  518731
  519563
  523357
  523743
  523891
  524676
  526818
  535526
  541099
  542818
  558159
  558886
  559687
  561023
  564705
  575811
  590802
  595849
  597488
  599081
  601674
  602948
  612039
  614693
  615818
  617039
  618561
  624578
  624915
  634565
  641983
  651068
  680498
  708468
  720708
  748349
  751307
  764875
  776153
  788903
  790870
  792059
  812025
]

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 (395738, 395915, 397982, 404370, 410913, 421488, 428594, 441366, 441631, 445831, 446289, 448012, 448314, 449484, 451283, 451875, 451878, 452202, 452727, 455816, 458404, 467194, 469852, 474572, 475467, 476828, 477097, 479866, 481807, 485919, 489109, 490174, 490608, 490685, 497697, 506996, 509872, 510512, 512901, 518731, 519563, 523357, 523743, 523891, 524676, 526818, 535526, 541099, 542818, 558159, 558886, 559687, 561023, 564705, 575811, 590802, 595849, 597488, 599081, 601674, 602948, 612039, 614693, 615818, 617039, 618561, 624578, 624915, 634565, 641983, 651068, 680498, 708468, 720708, 748349, 751307, 764875, 776153, 788903, 790870, 792059, 812025);

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
  395738
  395915
  397982
  404370
  410913
  421488
  428594
  441366
  441631
  445831
  446289
  448012
  448314
  449484
  451283
  451875
  451878
  452202
  452727
  455816
  458404
  467194
  469852
  474572
  475467
  476828
  477097
  479866
  481807
  485919
  489109
  490174
  490608
  490685
  497697
  506996
  509872
  510512
  512901
  518731
  519563
  523357
  523743
  523891
  524676
  526818
  535526
  541099
  542818
  558159
  558886
  559687
  561023
  564705
  575811
  590802
  595849
  597488
  599081
  601674
  602948
  612039
  614693
  615818
  617039
  618561
  624578
  624915
  634565
  641983
  651068
  680498
  708468
  720708
  748349
  751307
  764875
  776153
  788903
  790870
  792059
  812025
]

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 (395738, 395915, 397982, 404370, 410913, 421488, 428594, 441366, 441631, 445831, 446289, 448012, 448314, 449484, 451283, 451875, 451878, 452202, 452727, 455816, 458404, 467194, 469852, 474572, 475467, 476828, 477097, 479866, 481807, 485919, 489109, 490174, 490608, 490685, 497697, 506996, 509872, 510512, 512901, 518731, 519563, 523357, 523743, 523891, 524676, 526818, 535526, 541099, 542818, 558159, 558886, 559687, 561023, 564705, 575811, 590802, 595849, 597488, 599081, 601674, 602948, 612039, 614693, 615818, 617039, 618561, 624578, 624915, 634565, 641983, 651068, 680498, 708468, 720708, 748349, 751307, 764875, 776153, 788903, 790870, 792059, 812025);

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

[
  "teen try"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen try';

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

[
  "teen try"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen try';