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
  418478
  402256
  415265
  443453
  453550
  557942
  467558
  413818
  432927
  463909
  513412
  395602
  416191
  404059
  445052
  443648
  469915
  471978
  444000
  429945
  404366
  419855
  524797
  453671
  483039
  488957
  508185
  470483
  390533
  403789
  454997
  566578
  421146
  396600
  451476
  471908
  453918
  475103
  517833
  385377
  422565
  574184
  429162
  408257
  466987
  424484
  454212
  545000
  404678
  410936
  487713
  426417
  470385
  492121
  500931
  446394
  418416
  488515
  456609
  504231
  575459
  516029
  471612
  452032
  495273
  549233
  559155
  446431
  547612
  555182
]

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 (418478, 402256, 415265, 443453, 453550, 557942, 467558, 413818, 432927, 463909, 513412, 395602, 416191, 404059, 445052, 443648, 469915, 471978, 444000, 429945, 404366, 419855, 524797, 453671, 483039, 488957, 508185, 470483, 390533, 403789, 454997, 566578, 421146, 396600, 451476, 471908, 453918, 475103, 517833, 385377, 422565, 574184, 429162, 408257, 466987, 424484, 454212, 545000, 404678, 410936, 487713, 426417, 470385, 492121, 500931, 446394, 418416, 488515, 456609, 504231, 575459, 516029, 471612, 452032, 495273, 549233, 559155, 446431, 547612, 555182);

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
  385377
  390533
  395602
  396600
  402256
  403789
  404059
  404366
  404678
  408257
  410936
  413818
  415265
  416191
  418416
  418478
  419855
  421146
  422565
  424484
  426417
  429162
  429945
  432927
  443453
  443648
  444000
  445052
  446394
  446431
  451476
  452032
  453550
  453671
  453918
  454212
  454997
  456609
  463909
  466987
  467558
  469915
  470385
  470483
  471612
  471908
  471978
  475103
  483039
  487713
  488515
  488957
  492121
  495273
  500931
  504231
  508185
  513412
  516029
  517833
  524797
  545000
  547612
  549233
  555182
  557942
  559155
  566578
  574184
  575459
]

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 (385377, 390533, 395602, 396600, 402256, 403789, 404059, 404366, 404678, 408257, 410936, 413818, 415265, 416191, 418416, 418478, 419855, 421146, 422565, 424484, 426417, 429162, 429945, 432927, 443453, 443648, 444000, 445052, 446394, 446431, 451476, 452032, 453550, 453671, 453918, 454212, 454997, 456609, 463909, 466987, 467558, 469915, 470385, 470483, 471612, 471908, 471978, 475103, 483039, 487713, 488515, 488957, 492121, 495273, 500931, 504231, 508185, 513412, 516029, 517833, 524797, 545000, 547612, 549233, 555182, 557942, 559155, 566578, 574184, 575459);

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
  385377
  390533
  395602
  396600
  402256
  403789
  404059
  404366
  404678
  408257
  410936
  413818
  415265
  416191
  418416
  418478
  419855
  421146
  422565
  424484
  426417
  429162
  429945
  432927
  443453
  443648
  444000
  445052
  446394
  446431
  451476
  452032
  453550
  453671
  453918
  454212
  454997
  456609
  463909
  466987
  467558
  469915
  470385
  470483
  471612
  471908
  471978
  475103
  483039
  487713
  488515
  488957
  492121
  495273
  500931
  504231
  508185
  513412
  516029
  517833
  524797
  545000
  547612
  549233
  555182
  557942
  559155
  566578
  574184
  575459
]

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 (385377, 390533, 395602, 396600, 402256, 403789, 404059, 404366, 404678, 408257, 410936, 413818, 415265, 416191, 418416, 418478, 419855, 421146, 422565, 424484, 426417, 429162, 429945, 432927, 443453, 443648, 444000, 445052, 446394, 446431, 451476, 452032, 453550, 453671, 453918, 454212, 454997, 456609, 463909, 466987, 467558, 469915, 470385, 470483, 471612, 471908, 471978, 475103, 483039, 487713, 488515, 488957, 492121, 495273, 500931, 504231, 508185, 513412, 516029, 517833, 524797, 545000, 547612, 549233, 555182, 557942, 559155, 566578, 574184, 575459);

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
        ;