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
  744130
  720697
  630473
  400488
  735485
  75762
  598495
  485540
  760926
  542423
  743170
  555701
  526463
  412690
  449287
  590348
  496196
  392517
  572889
  482165
  418658
  468881
  558692
  582090
  547886
  576054
  596982
  508607
  463493
  493985
  563839
  550601
  573719
  552216
  593659
  522743
  559526
  553100
  563803
  467364
  469622
  476021
  574727
  569451
  422409
  448876
  520215
  495158
  601827
  659306
  613279
  479219
  523549
  521783
  572120
  562487
  643895
  609842
  498036
  654753
  607230
  622773
  566272
  653249
  604247
  550829
  541924
  653266
  609280
  485464
  614080
  620205
  532766
]

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 (744130, 720697, 630473, 400488, 735485, 75762, 598495, 485540, 760926, 542423, 743170, 555701, 526463, 412690, 449287, 590348, 496196, 392517, 572889, 482165, 418658, 468881, 558692, 582090, 547886, 576054, 596982, 508607, 463493, 493985, 563839, 550601, 573719, 552216, 593659, 522743, 559526, 553100, 563803, 467364, 469622, 476021, 574727, 569451, 422409, 448876, 520215, 495158, 601827, 659306, 613279, 479219, 523549, 521783, 572120, 562487, 643895, 609842, 498036, 654753, 607230, 622773, 566272, 653249, 604247, 550829, 541924, 653266, 609280, 485464, 614080, 620205, 532766);

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
  75762
  392517
  400488
  412690
  418658
  422409
  448876
  449287
  463493
  467364
  468881
  469622
  476021
  479219
  482165
  485464
  485540
  493985
  495158
  496196
  498036
  508607
  520215
  521783
  522743
  523549
  526463
  532766
  541924
  542423
  547886
  550601
  550829
  552216
  553100
  555701
  558692
  559526
  562487
  563803
  563839
  566272
  569451
  572120
  572889
  573719
  574727
  576054
  582090
  590348
  593659
  596982
  598495
  601827
  604247
  607230
  609280
  609842
  613279
  614080
  620205
  622773
  630473
  643895
  653249
  653266
  654753
  659306
  720697
  735485
  743170
  744130
  760926
]

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 (75762, 392517, 400488, 412690, 418658, 422409, 448876, 449287, 463493, 467364, 468881, 469622, 476021, 479219, 482165, 485464, 485540, 493985, 495158, 496196, 498036, 508607, 520215, 521783, 522743, 523549, 526463, 532766, 541924, 542423, 547886, 550601, 550829, 552216, 553100, 555701, 558692, 559526, 562487, 563803, 563839, 566272, 569451, 572120, 572889, 573719, 574727, 576054, 582090, 590348, 593659, 596982, 598495, 601827, 604247, 607230, 609280, 609842, 613279, 614080, 620205, 622773, 630473, 643895, 653249, 653266, 654753, 659306, 720697, 735485, 743170, 744130, 760926);

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
  75762
  392517
  400488
  412690
  418658
  422409
  448876
  449287
  463493
  467364
  468881
  469622
  476021
  479219
  482165
  485464
  485540
  493985
  495158
  496196
  498036
  508607
  520215
  521783
  522743
  523549
  526463
  532766
  541924
  542423
  547886
  550601
  550829
  552216
  553100
  555701
  558692
  559526
  562487
  563803
  563839
  566272
  569451
  572120
  572889
  573719
  574727
  576054
  582090
  590348
  593659
  596982
  598495
  601827
  604247
  607230
  609280
  609842
  613279
  614080
  620205
  622773
  630473
  643895
  653249
  653266
  654753
  659306
  720697
  735485
  743170
  744130
  760926
]

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 (75762, 392517, 400488, 412690, 418658, 422409, 448876, 449287, 463493, 467364, 468881, 469622, 476021, 479219, 482165, 485464, 485540, 493985, 495158, 496196, 498036, 508607, 520215, 521783, 522743, 523549, 526463, 532766, 541924, 542423, 547886, 550601, 550829, 552216, 553100, 555701, 558692, 559526, 562487, 563803, 563839, 566272, 569451, 572120, 572889, 573719, 574727, 576054, 582090, 590348, 593659, 596982, 598495, 601827, 604247, 607230, 609280, 609842, 613279, 614080, 620205, 622773, 630473, 643895, 653249, 653266, 654753, 659306, 720697, 735485, 743170, 744130, 760926);

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
        ;