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

[
  "young young touch"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young young touch' 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
  474678
  475807
  519713
  501641
  484457
  485735
  535015
  498019
  507813
  524951
  519632
  535346
  493102
  554519
  564826
  682153
  682522
  565740
  566288
  581806
  589634
  594964
  631902
  597007
  626343
  466088
  484644
  484748
  498047
  529300
  516714
  546932
  564453
  584739
  516612
  532129
  562906
  578326
  558003
  558016
  590966
  611525
  619065
  610588
  597134
  609248
  464917
  477465
  482321
  510767
  484554
  517651
  485454
  530762
  574527
  584708
  549246
  560391
  561480
  593499
  589642
  614479
  620098
  613413
  521710
  525499
  569955
  610695
  478672
  520759
  519023
  590878
  499882
]

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 (474678, 475807, 519713, 501641, 484457, 485735, 535015, 498019, 507813, 524951, 519632, 535346, 493102, 554519, 564826, 682153, 682522, 565740, 566288, 581806, 589634, 594964, 631902, 597007, 626343, 466088, 484644, 484748, 498047, 529300, 516714, 546932, 564453, 584739, 516612, 532129, 562906, 578326, 558003, 558016, 590966, 611525, 619065, 610588, 597134, 609248, 464917, 477465, 482321, 510767, 484554, 517651, 485454, 530762, 574527, 584708, 549246, 560391, 561480, 593499, 589642, 614479, 620098, 613413, 521710, 525499, 569955, 610695, 478672, 520759, 519023, 590878, 499882);

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
  464917
  466088
  474678
  475807
  477465
  478672
  482321
  484457
  484554
  484644
  484748
  485454
  485735
  493102
  498019
  498047
  499882
  501641
  507813
  510767
  516612
  516714
  517651
  519023
  519632
  519713
  520759
  521710
  524951
  525499
  529300
  530762
  532129
  535015
  535346
  546932
  549246
  554519
  558003
  558016
  560391
  561480
  562906
  564453
  564826
  565740
  566288
  569955
  574527
  578326
  581806
  584708
  584739
  589634
  589642
  590878
  590966
  593499
  594964
  597007
  597134
  609248
  610588
  610695
  611525
  613413
  614479
  619065
  620098
  626343
  631902
  682153
  682522
]

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 (464917, 466088, 474678, 475807, 477465, 478672, 482321, 484457, 484554, 484644, 484748, 485454, 485735, 493102, 498019, 498047, 499882, 501641, 507813, 510767, 516612, 516714, 517651, 519023, 519632, 519713, 520759, 521710, 524951, 525499, 529300, 530762, 532129, 535015, 535346, 546932, 549246, 554519, 558003, 558016, 560391, 561480, 562906, 564453, 564826, 565740, 566288, 569955, 574527, 578326, 581806, 584708, 584739, 589634, 589642, 590878, 590966, 593499, 594964, 597007, 597134, 609248, 610588, 610695, 611525, 613413, 614479, 619065, 620098, 626343, 631902, 682153, 682522);

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
  464917
  466088
  474678
  475807
  477465
  478672
  482321
  484457
  484554
  484644
  484748
  485454
  485735
  493102
  498019
  498047
  499882
  501641
  507813
  510767
  516612
  516714
  517651
  519023
  519632
  519713
  520759
  521710
  524951
  525499
  529300
  530762
  532129
  535015
  535346
  546932
  549246
  554519
  558003
  558016
  560391
  561480
  562906
  564453
  564826
  565740
  566288
  569955
  574527
  578326
  581806
  584708
  584739
  589634
  589642
  590878
  590966
  593499
  594964
  597007
  597134
  609248
  610588
  610695
  611525
  613413
  614479
  619065
  620098
  626343
  631902
  682153
  682522
]

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 (464917, 466088, 474678, 475807, 477465, 478672, 482321, 484457, 484554, 484644, 484748, 485454, 485735, 493102, 498019, 498047, 499882, 501641, 507813, 510767, 516612, 516714, 517651, 519023, 519632, 519713, 520759, 521710, 524951, 525499, 529300, 530762, 532129, 535015, 535346, 546932, 549246, 554519, 558003, 558016, 560391, 561480, 562906, 564453, 564826, 565740, 566288, 569955, 574527, 578326, 581806, 584708, 584739, 589634, 589642, 590878, 590966, 593499, 594964, 597007, 597134, 609248, 610588, 610695, 611525, 613413, 614479, 619065, 620098, 626343, 631902, 682153, 682522);

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

[
  "young young трога"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'young young трога';

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

[
  "young young трога"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young young трога';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "young young touch"
  "young young touch"
  "young young touch"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('young young touch') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('young young touch')
              AND `query` <> 'young young touch'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;