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
  420201
  493624
  446790
  457551
  485452
  560749
  578386
  588813
  425737
  439809
  466024
  385466
  446245
  513490
  487820
  589450
  480126
  500914
  510403
  556341
  556213
  469167
  461822
  450382
  466912
  472192
  516246
  507887
  515542
  517079
  486259
  506360
  545665
  470638
  440815
  514243
  506976
  598698
  548340
  567053
  623421
  530064
  7446
  443871
  555043
  597116
  486875
  485061
  578703
  671075
  593180
  482308
  461954
  532251
  524836
  613515
  482737
  571244
  611028
  499863
  524512
  522825
  597193
  624776
  425775
  457103
  464062
  598654
  603493
  617004
  529078
  616024
  472486
  521843
]

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 (420201, 493624, 446790, 457551, 485452, 560749, 578386, 588813, 425737, 439809, 466024, 385466, 446245, 513490, 487820, 589450, 480126, 500914, 510403, 556341, 556213, 469167, 461822, 450382, 466912, 472192, 516246, 507887, 515542, 517079, 486259, 506360, 545665, 470638, 440815, 514243, 506976, 598698, 548340, 567053, 623421, 530064, 7446, 443871, 555043, 597116, 486875, 485061, 578703, 671075, 593180, 482308, 461954, 532251, 524836, 613515, 482737, 571244, 611028, 499863, 524512, 522825, 597193, 624776, 425775, 457103, 464062, 598654, 603493, 617004, 529078, 616024, 472486, 521843);

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
  7446
  385466
  420201
  425737
  425775
  439809
  440815
  443871
  446245
  446790
  450382
  457103
  457551
  461822
  461954
  464062
  466024
  466912
  469167
  470638
  472192
  472486
  480126
  482308
  482737
  485061
  485452
  486259
  486875
  487820
  493624
  499863
  500914
  506360
  506976
  507887
  510403
  513490
  514243
  515542
  516246
  517079
  521843
  522825
  524512
  524836
  529078
  530064
  532251
  545665
  548340
  555043
  556213
  556341
  560749
  567053
  571244
  578386
  578703
  588813
  589450
  593180
  597116
  597193
  598654
  598698
  603493
  611028
  613515
  616024
  617004
  623421
  624776
  671075
]

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 (7446, 385466, 420201, 425737, 425775, 439809, 440815, 443871, 446245, 446790, 450382, 457103, 457551, 461822, 461954, 464062, 466024, 466912, 469167, 470638, 472192, 472486, 480126, 482308, 482737, 485061, 485452, 486259, 486875, 487820, 493624, 499863, 500914, 506360, 506976, 507887, 510403, 513490, 514243, 515542, 516246, 517079, 521843, 522825, 524512, 524836, 529078, 530064, 532251, 545665, 548340, 555043, 556213, 556341, 560749, 567053, 571244, 578386, 578703, 588813, 589450, 593180, 597116, 597193, 598654, 598698, 603493, 611028, 613515, 616024, 617004, 623421, 624776, 671075);

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
  7446
  385466
  420201
  425737
  425775
  439809
  440815
  443871
  446245
  446790
  450382
  457103
  457551
  461822
  461954
  464062
  466024
  466912
  469167
  470638
  472192
  472486
  480126
  482308
  482737
  485061
  485452
  486259
  486875
  487820
  493624
  499863
  500914
  506360
  506976
  507887
  510403
  513490
  514243
  515542
  516246
  517079
  521843
  522825
  524512
  524836
  529078
  530064
  532251
  545665
  548340
  555043
  556213
  556341
  560749
  567053
  571244
  578386
  578703
  588813
  589450
  593180
  597116
  597193
  598654
  598698
  603493
  611028
  613515
  616024
  617004
  623421
  624776
  671075
]

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 (7446, 385466, 420201, 425737, 425775, 439809, 440815, 443871, 446245, 446790, 450382, 457103, 457551, 461822, 461954, 464062, 466024, 466912, 469167, 470638, 472192, 472486, 480126, 482308, 482737, 485061, 485452, 486259, 486875, 487820, 493624, 499863, 500914, 506360, 506976, 507887, 510403, 513490, 514243, 515542, 516246, 517079, 521843, 522825, 524512, 524836, 529078, 530064, 532251, 545665, 548340, 555043, 556213, 556341, 560749, 567053, 571244, 578386, 578703, 588813, 589450, 593180, 597116, 597193, 598654, 598698, 603493, 611028, 613515, 616024, 617004, 623421, 624776, 671075);

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
        ;