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

[
  "bull fuck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bull fuck' 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
  515379
  488385
  595965
  507102
  577142
  500524
  497684
  605670
  785148
  787896
  430379
  536463
  606725
  633992
  636904
  595333
  508986
  756845
  725411
  653630
  785145
  728720
  465189
  652708
  641481
  456742
  484946
  426455
  630292
  605562
  455015
  523114
  650882
  578757
  585752
  519105
  500479
  691724
  556880
  580449
  785161
  444087
  761047
  448483
  732553
  585756
  578204
  648924
  648634
  758216
  481672
  500536
  539372
  575601
  604545
  632724
  545076
  525358
  516270
  500497
  496527
  605557
  525152
  500489
  495269
  449933
  603623
  814266
  603642
  677142
  574460
  542148
  577108
]

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 (515379, 488385, 595965, 507102, 577142, 500524, 497684, 605670, 785148, 787896, 430379, 536463, 606725, 633992, 636904, 595333, 508986, 756845, 725411, 653630, 785145, 728720, 465189, 652708, 641481, 456742, 484946, 426455, 630292, 605562, 455015, 523114, 650882, 578757, 585752, 519105, 500479, 691724, 556880, 580449, 785161, 444087, 761047, 448483, 732553, 585756, 578204, 648924, 648634, 758216, 481672, 500536, 539372, 575601, 604545, 632724, 545076, 525358, 516270, 500497, 496527, 605557, 525152, 500489, 495269, 449933, 603623, 814266, 603642, 677142, 574460, 542148, 577108);

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
  426455
  430379
  444087
  448483
  449933
  455015
  456742
  465189
  481672
  484946
  488385
  495269
  496527
  497684
  500479
  500489
  500497
  500524
  500536
  507102
  508986
  515379
  516270
  519105
  523114
  525152
  525358
  536463
  539372
  542148
  545076
  556880
  574460
  575601
  577108
  577142
  578204
  578757
  580449
  585752
  585756
  595333
  595965
  603623
  603642
  604545
  605557
  605562
  605670
  606725
  630292
  632724
  633992
  636904
  641481
  648634
  648924
  650882
  652708
  653630
  677142
  691724
  725411
  728720
  732553
  756845
  758216
  761047
  785145
  785148
  785161
  787896
  814266
]

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 (426455, 430379, 444087, 448483, 449933, 455015, 456742, 465189, 481672, 484946, 488385, 495269, 496527, 497684, 500479, 500489, 500497, 500524, 500536, 507102, 508986, 515379, 516270, 519105, 523114, 525152, 525358, 536463, 539372, 542148, 545076, 556880, 574460, 575601, 577108, 577142, 578204, 578757, 580449, 585752, 585756, 595333, 595965, 603623, 603642, 604545, 605557, 605562, 605670, 606725, 630292, 632724, 633992, 636904, 641481, 648634, 648924, 650882, 652708, 653630, 677142, 691724, 725411, 728720, 732553, 756845, 758216, 761047, 785145, 785148, 785161, 787896, 814266);

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
  426455
  430379
  444087
  448483
  449933
  455015
  456742
  465189
  481672
  484946
  488385
  495269
  496527
  497684
  500479
  500489
  500497
  500524
  500536
  507102
  508986
  515379
  516270
  519105
  523114
  525152
  525358
  536463
  539372
  542148
  545076
  556880
  574460
  575601
  577108
  577142
  578204
  578757
  580449
  585752
  585756
  595333
  595965
  603623
  603642
  604545
  605557
  605562
  605670
  606725
  630292
  632724
  633992
  636904
  641481
  648634
  648924
  650882
  652708
  653630
  677142
  691724
  725411
  728720
  732553
  756845
  758216
  761047
  785145
  785148
  785161
  787896
  814266
]

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 (426455, 430379, 444087, 448483, 449933, 455015, 456742, 465189, 481672, 484946, 488385, 495269, 496527, 497684, 500479, 500489, 500497, 500524, 500536, 507102, 508986, 515379, 516270, 519105, 523114, 525152, 525358, 536463, 539372, 542148, 545076, 556880, 574460, 575601, 577108, 577142, 578204, 578757, 580449, 585752, 585756, 595333, 595965, 603623, 603642, 604545, 605557, 605562, 605670, 606725, 630292, 632724, 633992, 636904, 641481, 648634, 648924, 650882, 652708, 653630, 677142, 691724, 725411, 728720, 732553, 756845, 758216, 761047, 785145, 785148, 785161, 787896, 814266);

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

[
  "bull секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bull секс';

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

[
  "bull секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bull секс';

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 ?

[
  "bull fuck"
  "bull fuck"
  "bull fuck"
  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 ('bull fuck') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('bull fuck')
              AND `query` <> 'bull fuck'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;