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

[
  "секс в кустах"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс в кустах' 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
  543766
  410264
  528139
  465905
  562262
  573291
  506538
  570491
  480705
  565395
  666709
  470233
  427244
  462286
  484076
  555580
  423928
  508828
  454296
  422499
  484482
  442626
  467735
  491706
  594622
  476603
  563332
  479549
  496327
  496354
  471516
  500996
  461903
  478084
  478319
  429279
  564112
  540694
  513541
  557491
  500574
  578129
  626824
  510933
  545202
  481154
  443114
  473647
  477555
  472342
  451999
  478707
  580863
  556401
  415807
  471307
  563289
  562269
  557595
  444994
  677973
  546380
  452114
  559120
  459901
  562303
  457770
  569901
  598439
  607388
  531481
  488033
  521818
  575197
]

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 (543766, 410264, 528139, 465905, 562262, 573291, 506538, 570491, 480705, 565395, 666709, 470233, 427244, 462286, 484076, 555580, 423928, 508828, 454296, 422499, 484482, 442626, 467735, 491706, 594622, 476603, 563332, 479549, 496327, 496354, 471516, 500996, 461903, 478084, 478319, 429279, 564112, 540694, 513541, 557491, 500574, 578129, 626824, 510933, 545202, 481154, 443114, 473647, 477555, 472342, 451999, 478707, 580863, 556401, 415807, 471307, 563289, 562269, 557595, 444994, 677973, 546380, 452114, 559120, 459901, 562303, 457770, 569901, 598439, 607388, 531481, 488033, 521818, 575197);

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
  410264
  415807
  422499
  423928
  427244
  429279
  442626
  443114
  444994
  451999
  452114
  454296
  457770
  459901
  461903
  462286
  465905
  467735
  470233
  471307
  471516
  472342
  473647
  476603
  477555
  478084
  478319
  478707
  479549
  480705
  481154
  484076
  484482
  488033
  491706
  496327
  496354
  500574
  500996
  506538
  508828
  510933
  513541
  521818
  528139
  531481
  540694
  543766
  545202
  546380
  555580
  556401
  557491
  557595
  559120
  562262
  562269
  562303
  563289
  563332
  564112
  565395
  569901
  570491
  573291
  575197
  578129
  580863
  594622
  598439
  607388
  626824
  666709
  677973
]

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 (410264, 415807, 422499, 423928, 427244, 429279, 442626, 443114, 444994, 451999, 452114, 454296, 457770, 459901, 461903, 462286, 465905, 467735, 470233, 471307, 471516, 472342, 473647, 476603, 477555, 478084, 478319, 478707, 479549, 480705, 481154, 484076, 484482, 488033, 491706, 496327, 496354, 500574, 500996, 506538, 508828, 510933, 513541, 521818, 528139, 531481, 540694, 543766, 545202, 546380, 555580, 556401, 557491, 557595, 559120, 562262, 562269, 562303, 563289, 563332, 564112, 565395, 569901, 570491, 573291, 575197, 578129, 580863, 594622, 598439, 607388, 626824, 666709, 677973);

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
  410264
  415807
  422499
  423928
  427244
  429279
  442626
  443114
  444994
  451999
  452114
  454296
  457770
  459901
  461903
  462286
  465905
  467735
  470233
  471307
  471516
  472342
  473647
  476603
  477555
  478084
  478319
  478707
  479549
  480705
  481154
  484076
  484482
  488033
  491706
  496327
  496354
  500574
  500996
  506538
  508828
  510933
  513541
  521818
  528139
  531481
  540694
  543766
  545202
  546380
  555580
  556401
  557491
  557595
  559120
  562262
  562269
  562303
  563289
  563332
  564112
  565395
  569901
  570491
  573291
  575197
  578129
  580863
  594622
  598439
  607388
  626824
  666709
  677973
]

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 (410264, 415807, 422499, 423928, 427244, 429279, 442626, 443114, 444994, 451999, 452114, 454296, 457770, 459901, 461903, 462286, 465905, 467735, 470233, 471307, 471516, 472342, 473647, 476603, 477555, 478084, 478319, 478707, 479549, 480705, 481154, 484076, 484482, 488033, 491706, 496327, 496354, 500574, 500996, 506538, 508828, 510933, 513541, 521818, 528139, 531481, 540694, 543766, 545202, 546380, 555580, 556401, 557491, 557595, 559120, 562262, 562269, 562303, 563289, 563332, 564112, 565395, 569901, 570491, 573291, 575197, 578129, 580863, 594622, 598439, 607388, 626824, 666709, 677973);

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` = 'секс в куст';

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 ?

[
  "секс в кустах"
  "секс в кустах"
  "секс в кустах"
  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 ('секс в кустах') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('секс в кустах')
              AND `query` <> 'секс в кустах'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;