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

[
  "very very small"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very very small' 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
  535008
  536606
  462379
  464281
  562463
  570959
  547805
  573056
  699586
  623499
  597864
  801952
  786815
  489583
  568371
  696203
  565914
  446657
  475508
  430397
  509979
  527203
  567091
  600806
  520085
  570708
  434319
  513135
  568835
  566459
  617026
  642359
  405700
  443973
  447337
  507647
  508185
  513954
  511724
  516336
  556017
  660964
  593975
  419192
  462504
  518917
  518289
  553648
  456452
  439854
  492535
  643028
  469648
  492482
  525399
  476223
  648560
  492273
  614058
  443971
  603384
  608688
  378046
  573920
  429805
  662997
  672710
  407168
  513539
  630536
  632632
  546124
  608203
]

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 (535008, 536606, 462379, 464281, 562463, 570959, 547805, 573056, 699586, 623499, 597864, 801952, 786815, 489583, 568371, 696203, 565914, 446657, 475508, 430397, 509979, 527203, 567091, 600806, 520085, 570708, 434319, 513135, 568835, 566459, 617026, 642359, 405700, 443973, 447337, 507647, 508185, 513954, 511724, 516336, 556017, 660964, 593975, 419192, 462504, 518917, 518289, 553648, 456452, 439854, 492535, 643028, 469648, 492482, 525399, 476223, 648560, 492273, 614058, 443971, 603384, 608688, 378046, 573920, 429805, 662997, 672710, 407168, 513539, 630536, 632632, 546124, 608203);

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
  378046
  405700
  407168
  419192
  429805
  430397
  434319
  439854
  443971
  443973
  446657
  447337
  456452
  462379
  462504
  464281
  469648
  475508
  476223
  489583
  492273
  492482
  492535
  507647
  508185
  509979
  511724
  513135
  513539
  513954
  516336
  518289
  518917
  520085
  525399
  527203
  535008
  536606
  546124
  547805
  553648
  556017
  562463
  565914
  566459
  567091
  568371
  568835
  570708
  570959
  573056
  573920
  593975
  597864
  600806
  603384
  608203
  608688
  614058
  617026
  623499
  630536
  632632
  642359
  643028
  648560
  660964
  662997
  672710
  696203
  699586
  786815
  801952
]

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 (378046, 405700, 407168, 419192, 429805, 430397, 434319, 439854, 443971, 443973, 446657, 447337, 456452, 462379, 462504, 464281, 469648, 475508, 476223, 489583, 492273, 492482, 492535, 507647, 508185, 509979, 511724, 513135, 513539, 513954, 516336, 518289, 518917, 520085, 525399, 527203, 535008, 536606, 546124, 547805, 553648, 556017, 562463, 565914, 566459, 567091, 568371, 568835, 570708, 570959, 573056, 573920, 593975, 597864, 600806, 603384, 608203, 608688, 614058, 617026, 623499, 630536, 632632, 642359, 643028, 648560, 660964, 662997, 672710, 696203, 699586, 786815, 801952);

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
  378046
  405700
  407168
  419192
  429805
  430397
  434319
  439854
  443971
  443973
  446657
  447337
  456452
  462379
  462504
  464281
  469648
  475508
  476223
  489583
  492273
  492482
  492535
  507647
  508185
  509979
  511724
  513135
  513539
  513954
  516336
  518289
  518917
  520085
  525399
  527203
  535008
  536606
  546124
  547805
  553648
  556017
  562463
  565914
  566459
  567091
  568371
  568835
  570708
  570959
  573056
  573920
  593975
  597864
  600806
  603384
  608203
  608688
  614058
  617026
  623499
  630536
  632632
  642359
  643028
  648560
  660964
  662997
  672710
  696203
  699586
  786815
  801952
]

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 (378046, 405700, 407168, 419192, 429805, 430397, 434319, 439854, 443971, 443973, 446657, 447337, 456452, 462379, 462504, 464281, 469648, 475508, 476223, 489583, 492273, 492482, 492535, 507647, 508185, 509979, 511724, 513135, 513539, 513954, 516336, 518289, 518917, 520085, 525399, 527203, 535008, 536606, 546124, 547805, 553648, 556017, 562463, 565914, 566459, 567091, 568371, 568835, 570708, 570959, 573056, 573920, 593975, 597864, 600806, 603384, 608203, 608688, 614058, 617026, 623499, 630536, 632632, 642359, 643028, 648560, 660964, 662997, 672710, 696203, 699586, 786815, 801952);

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

[
  "very very маленькая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'very very маленькая';

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

[
  "very very маленькая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very very маленькая';

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 ?

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