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
  628271
  625140
  586494
  492336
  500825
  409001
  484801
  509296
  521504
  526545
  521507
  565617
  582790
  563026
  617175
  618230
  450935
  454672
  575289
  576248
  591158
  521508
  521526
  556865
  585744
  503272
  526979
  590974
  601229
  631538
  492712
  557985
  610686
  508217
  500084
  525757
  507092
  513405
  525753
  547593
  551795
  544001
  556396
  568333
  618097
  589335
  597872
  628273
  514480
  528379
  550481
  560679
  677238
  556155
  580549
  504889
  555868
  624109
  458438
  492329
  539295
  594560
  595204
  626082
  423908
  520930
  563042
  559223
  573736
  784493
  611559
  512071
  467611
  614515
]

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 (628271, 625140, 586494, 492336, 500825, 409001, 484801, 509296, 521504, 526545, 521507, 565617, 582790, 563026, 617175, 618230, 450935, 454672, 575289, 576248, 591158, 521508, 521526, 556865, 585744, 503272, 526979, 590974, 601229, 631538, 492712, 557985, 610686, 508217, 500084, 525757, 507092, 513405, 525753, 547593, 551795, 544001, 556396, 568333, 618097, 589335, 597872, 628273, 514480, 528379, 550481, 560679, 677238, 556155, 580549, 504889, 555868, 624109, 458438, 492329, 539295, 594560, 595204, 626082, 423908, 520930, 563042, 559223, 573736, 784493, 611559, 512071, 467611, 614515);

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
  409001
  423908
  450935
  454672
  458438
  467611
  484801
  492329
  492336
  492712
  500084
  500825
  503272
  504889
  507092
  508217
  509296
  512071
  513405
  514480
  520930
  521504
  521507
  521508
  521526
  525753
  525757
  526545
  526979
  528379
  539295
  544001
  547593
  550481
  551795
  555868
  556155
  556396
  556865
  557985
  559223
  560679
  563026
  563042
  565617
  568333
  573736
  575289
  576248
  580549
  582790
  585744
  586494
  589335
  590974
  591158
  594560
  597872
  601229
  610686
  611559
  614515
  617175
  618097
  618230
  624109
  625140
  626082
  628271
  628273
  631538
  677238
  784493
]

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 (409001, 423908, 450935, 454672, 458438, 467611, 484801, 492329, 492336, 492712, 500084, 500825, 503272, 504889, 507092, 508217, 509296, 512071, 513405, 514480, 520930, 521504, 521507, 521508, 521526, 525753, 525757, 526545, 526979, 528379, 539295, 544001, 547593, 550481, 551795, 555868, 556155, 556396, 556865, 557985, 559223, 560679, 563026, 563042, 565617, 568333, 573736, 575289, 576248, 580549, 582790, 585744, 586494, 589335, 590974, 591158, 594560, 597872, 601229, 610686, 611559, 614515, 617175, 618097, 618230, 624109, 625140, 626082, 628271, 628273, 631538, 677238, 784493);

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
  409001
  423908
  450935
  454672
  458438
  467611
  484801
  492329
  492336
  492712
  500084
  500825
  503272
  504889
  507092
  508217
  509296
  512071
  513405
  514480
  520930
  521504
  521507
  521508
  521526
  525753
  525757
  526545
  526979
  528379
  539295
  544001
  547593
  550481
  551795
  555868
  556155
  556396
  556865
  557985
  559223
  560679
  563026
  563042
  565617
  568333
  573736
  575289
  576248
  580549
  582790
  585744
  586494
  589335
  590974
  591158
  594560
  597872
  601229
  610686
  611559
  614515
  617175
  618097
  618230
  624109
  625140
  626082
  628271
  628273
  631538
  677238
  784493
]

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 (409001, 423908, 450935, 454672, 458438, 467611, 484801, 492329, 492336, 492712, 500084, 500825, 503272, 504889, 507092, 508217, 509296, 512071, 513405, 514480, 520930, 521504, 521507, 521508, 521526, 525753, 525757, 526545, 526979, 528379, 539295, 544001, 547593, 550481, 551795, 555868, 556155, 556396, 556865, 557985, 559223, 560679, 563026, 563042, 565617, 568333, 573736, 575289, 576248, 580549, 582790, 585744, 586494, 589335, 590974, 591158, 594560, 597872, 601229, 610686, 611559, 614515, 617175, 618097, 618230, 624109, 625140, 626082, 628271, 628273, 631538, 677238, 784493);

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
        ;