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
  734892
  597833
  446237
  542406
  457580
  512576
  597561
  462142
  470080
  514370
  573280
  557899
  466356
  439838
  508372
  441378
  437901
  556537
  564908
  589007
  574744
  493275
  602037
  491334
  465980
  446239
  653227
  425287
  428924
  424608
  601472
  564656
  427132
  515542
  571963
  598612
  462826
  592319
  625880
  615658
  529424
  437789
  501397
  456075
  497280
  475824
  576199
  522463
  525994
  545649
  449393
  446566
  612799
  571327
  678973
  544937
  578351
  552415
  586333
  600330
  529497
  561241
  599141
  597007
  613313
  569357
  444606
  610869
  502328
]

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 (734892, 597833, 446237, 542406, 457580, 512576, 597561, 462142, 470080, 514370, 573280, 557899, 466356, 439838, 508372, 441378, 437901, 556537, 564908, 589007, 574744, 493275, 602037, 491334, 465980, 446239, 653227, 425287, 428924, 424608, 601472, 564656, 427132, 515542, 571963, 598612, 462826, 592319, 625880, 615658, 529424, 437789, 501397, 456075, 497280, 475824, 576199, 522463, 525994, 545649, 449393, 446566, 612799, 571327, 678973, 544937, 578351, 552415, 586333, 600330, 529497, 561241, 599141, 597007, 613313, 569357, 444606, 610869, 502328);

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
  424608
  425287
  427132
  428924
  437789
  437901
  439838
  441378
  444606
  446237
  446239
  446566
  449393
  456075
  457580
  462142
  462826
  465980
  466356
  470080
  475824
  491334
  493275
  497280
  501397
  502328
  508372
  512576
  514370
  515542
  522463
  525994
  529424
  529497
  542406
  544937
  545649
  552415
  556537
  557899
  561241
  564656
  564908
  569357
  571327
  571963
  573280
  574744
  576199
  578351
  586333
  589007
  592319
  597007
  597561
  597833
  598612
  599141
  600330
  601472
  602037
  610869
  612799
  613313
  615658
  625880
  653227
  678973
  734892
]

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 (424608, 425287, 427132, 428924, 437789, 437901, 439838, 441378, 444606, 446237, 446239, 446566, 449393, 456075, 457580, 462142, 462826, 465980, 466356, 470080, 475824, 491334, 493275, 497280, 501397, 502328, 508372, 512576, 514370, 515542, 522463, 525994, 529424, 529497, 542406, 544937, 545649, 552415, 556537, 557899, 561241, 564656, 564908, 569357, 571327, 571963, 573280, 574744, 576199, 578351, 586333, 589007, 592319, 597007, 597561, 597833, 598612, 599141, 600330, 601472, 602037, 610869, 612799, 613313, 615658, 625880, 653227, 678973, 734892);

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
  424608
  425287
  427132
  428924
  437789
  437901
  439838
  441378
  444606
  446237
  446239
  446566
  449393
  456075
  457580
  462142
  462826
  465980
  466356
  470080
  475824
  491334
  493275
  497280
  501397
  502328
  508372
  512576
  514370
  515542
  522463
  525994
  529424
  529497
  542406
  544937
  545649
  552415
  556537
  557899
  561241
  564656
  564908
  569357
  571327
  571963
  573280
  574744
  576199
  578351
  586333
  589007
  592319
  597007
  597561
  597833
  598612
  599141
  600330
  601472
  602037
  610869
  612799
  613313
  615658
  625880
  653227
  678973
  734892
]

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 (424608, 425287, 427132, 428924, 437789, 437901, 439838, 441378, 444606, 446237, 446239, 446566, 449393, 456075, 457580, 462142, 462826, 465980, 466356, 470080, 475824, 491334, 493275, 497280, 501397, 502328, 508372, 512576, 514370, 515542, 522463, 525994, 529424, 529497, 542406, 544937, 545649, 552415, 556537, 557899, 561241, 564656, 564908, 569357, 571327, 571963, 573280, 574744, 576199, 578351, 586333, 589007, 592319, 597007, 597561, 597833, 598612, 599141, 600330, 601472, 602037, 610869, 612799, 613313, 615658, 625880, 653227, 678973, 734892);

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
        ;