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

[
  "rus oral sperm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rus oral sperm' 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
  466282
  442844
  495255
  467667
  479967
  426496
  521887
  446678
  437789
  485511
  529495
  538497
  712549
  425323
  522209
  494459
  468558
  518053
  616816
  475972
  416300
  459607
  425302
  476007
  516245
  426663
  448461
  437440
  462935
  765112
  469196
  434655
  422170
  624876
  476460
  504174
  434789
  455610
  452657
  447253
  502975
  546626
  414960
  421609
  449393
  449222
  415811
  502639
  497179
  517866
  486134
  488282
  485984
  452305
  525994
  557983
  552355
  446396
  437772
  477358
  524408
  503314
  436047
  590460
  484365
  452563
  598666
  428958
  597208
  451132
  586386
  486336
  586118
]

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 (466282, 442844, 495255, 467667, 479967, 426496, 521887, 446678, 437789, 485511, 529495, 538497, 712549, 425323, 522209, 494459, 468558, 518053, 616816, 475972, 416300, 459607, 425302, 476007, 516245, 426663, 448461, 437440, 462935, 765112, 469196, 434655, 422170, 624876, 476460, 504174, 434789, 455610, 452657, 447253, 502975, 546626, 414960, 421609, 449393, 449222, 415811, 502639, 497179, 517866, 486134, 488282, 485984, 452305, 525994, 557983, 552355, 446396, 437772, 477358, 524408, 503314, 436047, 590460, 484365, 452563, 598666, 428958, 597208, 451132, 586386, 486336, 586118);

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
  414960
  415811
  416300
  421609
  422170
  425302
  425323
  426496
  426663
  428958
  434655
  434789
  436047
  437440
  437772
  437789
  442844
  446396
  446678
  447253
  448461
  449222
  449393
  451132
  452305
  452563
  452657
  455610
  459607
  462935
  466282
  467667
  468558
  469196
  475972
  476007
  476460
  477358
  479967
  484365
  485511
  485984
  486134
  486336
  488282
  494459
  495255
  497179
  502639
  502975
  503314
  504174
  516245
  517866
  518053
  521887
  522209
  524408
  525994
  529495
  538497
  546626
  552355
  557983
  586118
  586386
  590460
  597208
  598666
  616816
  624876
  712549
  765112
]

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 (414960, 415811, 416300, 421609, 422170, 425302, 425323, 426496, 426663, 428958, 434655, 434789, 436047, 437440, 437772, 437789, 442844, 446396, 446678, 447253, 448461, 449222, 449393, 451132, 452305, 452563, 452657, 455610, 459607, 462935, 466282, 467667, 468558, 469196, 475972, 476007, 476460, 477358, 479967, 484365, 485511, 485984, 486134, 486336, 488282, 494459, 495255, 497179, 502639, 502975, 503314, 504174, 516245, 517866, 518053, 521887, 522209, 524408, 525994, 529495, 538497, 546626, 552355, 557983, 586118, 586386, 590460, 597208, 598666, 616816, 624876, 712549, 765112);

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
  414960
  415811
  416300
  421609
  422170
  425302
  425323
  426496
  426663
  428958
  434655
  434789
  436047
  437440
  437772
  437789
  442844
  446396
  446678
  447253
  448461
  449222
  449393
  451132
  452305
  452563
  452657
  455610
  459607
  462935
  466282
  467667
  468558
  469196
  475972
  476007
  476460
  477358
  479967
  484365
  485511
  485984
  486134
  486336
  488282
  494459
  495255
  497179
  502639
  502975
  503314
  504174
  516245
  517866
  518053
  521887
  522209
  524408
  525994
  529495
  538497
  546626
  552355
  557983
  586118
  586386
  590460
  597208
  598666
  616816
  624876
  712549
  765112
]

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 (414960, 415811, 416300, 421609, 422170, 425302, 425323, 426496, 426663, 428958, 434655, 434789, 436047, 437440, 437772, 437789, 442844, 446396, 446678, 447253, 448461, 449222, 449393, 451132, 452305, 452563, 452657, 455610, 459607, 462935, 466282, 467667, 468558, 469196, 475972, 476007, 476460, 477358, 479967, 484365, 485511, 485984, 486134, 486336, 488282, 494459, 495255, 497179, 502639, 502975, 503314, 504174, 516245, 517866, 518053, 521887, 522209, 524408, 525994, 529495, 538497, 546626, 552355, 557983, 586118, 586386, 590460, 597208, 598666, 616816, 624876, 712549, 765112);

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

[
  "русск oral сперм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск oral сперм';

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

[
  "русск oral сперм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск oral сперм';

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 ?

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