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

[
  "crazy girls"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'crazy girls' 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
  688050
  600281
  600458
  457497
  442137
  821053
  536532
  569995
  649174
  586980
  468833
  488477
  503172
  533450
  545610
  439845
  446026
  514699
  528502
  587066
  637032
  446038
  501258
  560192
  477762
  545376
  565665
  628419
  530269
  582821
  428958
  495647
  651089
  525243
  528067
  484227
  521831
  535684
  537292
  650476
  581816
  462322
  441099
  541076
  516078
  617633
  523167
  651148
  597573
  524198
  531202
  453721
  514973
  421214
  539288
  431986
  527011
  473923
  536359
  526351
  510815
  609892
  599938
  525306
  608203
  601162
  625167
  637001
  621265
  504718
  647893
  508150
]

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 (688050, 600281, 600458, 457497, 442137, 821053, 536532, 569995, 649174, 586980, 468833, 488477, 503172, 533450, 545610, 439845, 446026, 514699, 528502, 587066, 637032, 446038, 501258, 560192, 477762, 545376, 565665, 628419, 530269, 582821, 428958, 495647, 651089, 525243, 528067, 484227, 521831, 535684, 537292, 650476, 581816, 462322, 441099, 541076, 516078, 617633, 523167, 651148, 597573, 524198, 531202, 453721, 514973, 421214, 539288, 431986, 527011, 473923, 536359, 526351, 510815, 609892, 599938, 525306, 608203, 601162, 625167, 637001, 621265, 504718, 647893, 508150);

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
  421214
  428958
  431986
  439845
  441099
  442137
  446026
  446038
  453721
  457497
  462322
  468833
  473923
  477762
  484227
  488477
  495647
  501258
  503172
  504718
  508150
  510815
  514699
  514973
  516078
  521831
  523167
  524198
  525243
  525306
  526351
  527011
  528067
  528502
  530269
  531202
  533450
  535684
  536359
  536532
  537292
  539288
  541076
  545376
  545610
  560192
  565665
  569995
  581816
  582821
  586980
  587066
  597573
  599938
  600281
  600458
  601162
  608203
  609892
  617633
  621265
  625167
  628419
  637001
  637032
  647893
  649174
  650476
  651089
  651148
  688050
  821053
]

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 (421214, 428958, 431986, 439845, 441099, 442137, 446026, 446038, 453721, 457497, 462322, 468833, 473923, 477762, 484227, 488477, 495647, 501258, 503172, 504718, 508150, 510815, 514699, 514973, 516078, 521831, 523167, 524198, 525243, 525306, 526351, 527011, 528067, 528502, 530269, 531202, 533450, 535684, 536359, 536532, 537292, 539288, 541076, 545376, 545610, 560192, 565665, 569995, 581816, 582821, 586980, 587066, 597573, 599938, 600281, 600458, 601162, 608203, 609892, 617633, 621265, 625167, 628419, 637001, 637032, 647893, 649174, 650476, 651089, 651148, 688050, 821053);

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
  421214
  428958
  431986
  439845
  441099
  442137
  446026
  446038
  453721
  457497
  462322
  468833
  473923
  477762
  484227
  488477
  495647
  501258
  503172
  504718
  508150
  510815
  514699
  514973
  516078
  521831
  523167
  524198
  525243
  525306
  526351
  527011
  528067
  528502
  530269
  531202
  533450
  535684
  536359
  536532
  537292
  539288
  541076
  545376
  545610
  560192
  565665
  569995
  581816
  582821
  586980
  587066
  597573
  599938
  600281
  600458
  601162
  608203
  609892
  617633
  621265
  625167
  628419
  637001
  637032
  647893
  649174
  650476
  651089
  651148
  688050
  821053
]

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 (421214, 428958, 431986, 439845, 441099, 442137, 446026, 446038, 453721, 457497, 462322, 468833, 473923, 477762, 484227, 488477, 495647, 501258, 503172, 504718, 508150, 510815, 514699, 514973, 516078, 521831, 523167, 524198, 525243, 525306, 526351, 527011, 528067, 528502, 530269, 531202, 533450, 535684, 536359, 536532, 537292, 539288, 541076, 545376, 545610, 560192, 565665, 569995, 581816, 582821, 586980, 587066, 597573, 599938, 600281, 600458, 601162, 608203, 609892, 617633, 621265, 625167, 628419, 637001, 637032, 647893, 649174, 650476, 651089, 651148, 688050, 821053);

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

[
  "crazy девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'crazy девушк';

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

[
  "crazy девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'crazy девушк';

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 ?

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