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
  6892
  31218
  396909
  462541
  478078
  385174
  445332
  467639
  524128
  517475
  486951
  504964
  447099
  209335
  518880
  130506
  387234
  454039
  500625
  491742
  474674
  427251
  474656
  437416
  474821
  469913
  446794
  419035
  96527
  486758
  480941
  557074
  511291
  459292
  478457
  400941
  452095
  122925
  552480
  386460
  388353
  421200
  473787
  420769
  599197
  342206
  512578
  456448
  478473
  436032
  454521
  517567
  494036
  387905
  420427
  559050
  522351
  653524
  584644
  659347
  561997
  558127
  562367
  477230
  617423
  497171
  513949
  605122
  625991
  619407
  591272
  588286
  483355
  553280
]

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 (6892, 31218, 396909, 462541, 478078, 385174, 445332, 467639, 524128, 517475, 486951, 504964, 447099, 209335, 518880, 130506, 387234, 454039, 500625, 491742, 474674, 427251, 474656, 437416, 474821, 469913, 446794, 419035, 96527, 486758, 480941, 557074, 511291, 459292, 478457, 400941, 452095, 122925, 552480, 386460, 388353, 421200, 473787, 420769, 599197, 342206, 512578, 456448, 478473, 436032, 454521, 517567, 494036, 387905, 420427, 559050, 522351, 653524, 584644, 659347, 561997, 558127, 562367, 477230, 617423, 497171, 513949, 605122, 625991, 619407, 591272, 588286, 483355, 553280);

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
  6892
  31218
  96527
  122925
  130506
  209335
  342206
  385174
  386460
  387234
  387905
  388353
  396909
  400941
  419035
  420427
  420769
  421200
  427251
  436032
  437416
  445332
  446794
  447099
  452095
  454039
  454521
  456448
  459292
  462541
  467639
  469913
  473787
  474656
  474674
  474821
  477230
  478078
  478457
  478473
  480941
  483355
  486758
  486951
  491742
  494036
  497171
  500625
  504964
  511291
  512578
  513949
  517475
  517567
  518880
  522351
  524128
  552480
  553280
  557074
  558127
  559050
  561997
  562367
  584644
  588286
  591272
  599197
  605122
  617423
  619407
  625991
  653524
  659347
]

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 (6892, 31218, 96527, 122925, 130506, 209335, 342206, 385174, 386460, 387234, 387905, 388353, 396909, 400941, 419035, 420427, 420769, 421200, 427251, 436032, 437416, 445332, 446794, 447099, 452095, 454039, 454521, 456448, 459292, 462541, 467639, 469913, 473787, 474656, 474674, 474821, 477230, 478078, 478457, 478473, 480941, 483355, 486758, 486951, 491742, 494036, 497171, 500625, 504964, 511291, 512578, 513949, 517475, 517567, 518880, 522351, 524128, 552480, 553280, 557074, 558127, 559050, 561997, 562367, 584644, 588286, 591272, 599197, 605122, 617423, 619407, 625991, 653524, 659347);

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
  6892
  31218
  96527
  122925
  130506
  209335
  342206
  385174
  386460
  387234
  387905
  388353
  396909
  400941
  419035
  420427
  420769
  421200
  427251
  436032
  437416
  445332
  446794
  447099
  452095
  454039
  454521
  456448
  459292
  462541
  467639
  469913
  473787
  474656
  474674
  474821
  477230
  478078
  478457
  478473
  480941
  483355
  486758
  486951
  491742
  494036
  497171
  500625
  504964
  511291
  512578
  513949
  517475
  517567
  518880
  522351
  524128
  552480
  553280
  557074
  558127
  559050
  561997
  562367
  584644
  588286
  591272
  599197
  605122
  617423
  619407
  625991
  653524
  659347
]

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 (6892, 31218, 96527, 122925, 130506, 209335, 342206, 385174, 386460, 387234, 387905, 388353, 396909, 400941, 419035, 420427, 420769, 421200, 427251, 436032, 437416, 445332, 446794, 447099, 452095, 454039, 454521, 456448, 459292, 462541, 467639, 469913, 473787, 474656, 474674, 474821, 477230, 478078, 478457, 478473, 480941, 483355, 486758, 486951, 491742, 494036, 497171, 500625, 504964, 511291, 512578, 513949, 517475, 517567, 518880, 522351, 524128, 552480, 553280, 557074, 558127, 559050, 561997, 562367, 584644, 588286, 591272, 599197, 605122, 617423, 619407, 625991, 653524, 659347);

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
        ;