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
  61168
  450213
  388552
  388995
  96636
  388887
  385344
  420060
  415081
  448552
  394608
  418848
  443635
  455898
  391596
  462822
  563400
  419061
  413643
  485488
  96946
  737500
  388903
  390437
  21255
  395919
  383387
  486756
  388569
  388558
  566688
  661565
  409861
  249926
  427202
  388940
  429873
  404829
  509808
  560462
  447861
  449123
  467572
  583819
  451588
  557981
  466369
  474661
  510398
  545015
  490061
  96029
  404778
  420760
  425129
  477483
  590542
  475776
  406059
  425351
  474289
  416166
  417212
  395696
  447810
  451893
  624846
  605122
  649185
  445617
  541866
]

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 (61168, 450213, 388552, 388995, 96636, 388887, 385344, 420060, 415081, 448552, 394608, 418848, 443635, 455898, 391596, 462822, 563400, 419061, 413643, 485488, 96946, 737500, 388903, 390437, 21255, 395919, 383387, 486756, 388569, 388558, 566688, 661565, 409861, 249926, 427202, 388940, 429873, 404829, 509808, 560462, 447861, 449123, 467572, 583819, 451588, 557981, 466369, 474661, 510398, 545015, 490061, 96029, 404778, 420760, 425129, 477483, 590542, 475776, 406059, 425351, 474289, 416166, 417212, 395696, 447810, 451893, 624846, 605122, 649185, 445617, 541866);

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
  21255
  61168
  96029
  96636
  96946
  249926
  383387
  385344
  388552
  388558
  388569
  388887
  388903
  388940
  388995
  390437
  391596
  394608
  395696
  395919
  404778
  404829
  406059
  409861
  413643
  415081
  416166
  417212
  418848
  419061
  420060
  420760
  425129
  425351
  427202
  429873
  443635
  445617
  447810
  447861
  448552
  449123
  450213
  451588
  451893
  455898
  462822
  466369
  467572
  474289
  474661
  475776
  477483
  485488
  486756
  490061
  509808
  510398
  541866
  545015
  557981
  560462
  563400
  566688
  583819
  590542
  605122
  624846
  649185
  661565
  737500
]

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 (21255, 61168, 96029, 96636, 96946, 249926, 383387, 385344, 388552, 388558, 388569, 388887, 388903, 388940, 388995, 390437, 391596, 394608, 395696, 395919, 404778, 404829, 406059, 409861, 413643, 415081, 416166, 417212, 418848, 419061, 420060, 420760, 425129, 425351, 427202, 429873, 443635, 445617, 447810, 447861, 448552, 449123, 450213, 451588, 451893, 455898, 462822, 466369, 467572, 474289, 474661, 475776, 477483, 485488, 486756, 490061, 509808, 510398, 541866, 545015, 557981, 560462, 563400, 566688, 583819, 590542, 605122, 624846, 649185, 661565, 737500);

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
  21255
  61168
  96029
  96636
  96946
  249926
  383387
  385344
  388552
  388558
  388569
  388887
  388903
  388940
  388995
  390437
  391596
  394608
  395696
  395919
  404778
  404829
  406059
  409861
  413643
  415081
  416166
  417212
  418848
  419061
  420060
  420760
  425129
  425351
  427202
  429873
  443635
  445617
  447810
  447861
  448552
  449123
  450213
  451588
  451893
  455898
  462822
  466369
  467572
  474289
  474661
  475776
  477483
  485488
  486756
  490061
  509808
  510398
  541866
  545015
  557981
  560462
  563400
  566688
  583819
  590542
  605122
  624846
  649185
  661565
  737500
]

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 (21255, 61168, 96029, 96636, 96946, 249926, 383387, 385344, 388552, 388558, 388569, 388887, 388903, 388940, 388995, 390437, 391596, 394608, 395696, 395919, 404778, 404829, 406059, 409861, 413643, 415081, 416166, 417212, 418848, 419061, 420060, 420760, 425129, 425351, 427202, 429873, 443635, 445617, 447810, 447861, 448552, 449123, 450213, 451588, 451893, 455898, 462822, 466369, 467572, 474289, 474661, 475776, 477483, 485488, 486756, 490061, 509808, 510398, 541866, 545015, 557981, 560462, 563400, 566688, 583819, 590542, 605122, 624846, 649185, 661565, 737500);

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
        ;