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
  449180
  414183
  474249
  438311
  423978
  426705
  388005
  667456
  631020
  494684
  400677
  430313
  459935
  495499
  30680
  456027
  459626
  405146
  499706
  636623
  455623
  500475
  480902
  514111
  469783
  391528
  397025
  475282
  751470
  405811
  462815
  502214
  398209
  510675
  373048
  517494
  505390
  739151
  383432
  487747
  489296
  401559
  583797
  673328
  336704
  446548
  546320
  497775
  601031
  773217
  390389
  477050
  433968
  458330
  603257
  479355
  504854
  478505
  413529
  32904
  451589
  489183
  428158
  624843
  516313
  427832
  509151
  448313
  453321
  475181
]

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 (449180, 414183, 474249, 438311, 423978, 426705, 388005, 667456, 631020, 494684, 400677, 430313, 459935, 495499, 30680, 456027, 459626, 405146, 499706, 636623, 455623, 500475, 480902, 514111, 469783, 391528, 397025, 475282, 751470, 405811, 462815, 502214, 398209, 510675, 373048, 517494, 505390, 739151, 383432, 487747, 489296, 401559, 583797, 673328, 336704, 446548, 546320, 497775, 601031, 773217, 390389, 477050, 433968, 458330, 603257, 479355, 504854, 478505, 413529, 32904, 451589, 489183, 428158, 624843, 516313, 427832, 509151, 448313, 453321, 475181);

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
  30680
  32904
  336704
  373048
  383432
  388005
  390389
  391528
  397025
  398209
  400677
  401559
  405146
  405811
  413529
  414183
  423978
  426705
  427832
  428158
  430313
  433968
  438311
  446548
  448313
  449180
  451589
  453321
  455623
  456027
  458330
  459626
  459935
  462815
  469783
  474249
  475181
  475282
  477050
  478505
  479355
  480902
  487747
  489183
  489296
  494684
  495499
  497775
  499706
  500475
  502214
  504854
  505390
  509151
  510675
  514111
  516313
  517494
  546320
  583797
  601031
  603257
  624843
  631020
  636623
  667456
  673328
  739151
  751470
  773217
]

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 (30680, 32904, 336704, 373048, 383432, 388005, 390389, 391528, 397025, 398209, 400677, 401559, 405146, 405811, 413529, 414183, 423978, 426705, 427832, 428158, 430313, 433968, 438311, 446548, 448313, 449180, 451589, 453321, 455623, 456027, 458330, 459626, 459935, 462815, 469783, 474249, 475181, 475282, 477050, 478505, 479355, 480902, 487747, 489183, 489296, 494684, 495499, 497775, 499706, 500475, 502214, 504854, 505390, 509151, 510675, 514111, 516313, 517494, 546320, 583797, 601031, 603257, 624843, 631020, 636623, 667456, 673328, 739151, 751470, 773217);

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
  30680
  32904
  336704
  373048
  383432
  388005
  390389
  391528
  397025
  398209
  400677
  401559
  405146
  405811
  413529
  414183
  423978
  426705
  427832
  428158
  430313
  433968
  438311
  446548
  448313
  449180
  451589
  453321
  455623
  456027
  458330
  459626
  459935
  462815
  469783
  474249
  475181
  475282
  477050
  478505
  479355
  480902
  487747
  489183
  489296
  494684
  495499
  497775
  499706
  500475
  502214
  504854
  505390
  509151
  510675
  514111
  516313
  517494
  546320
  583797
  601031
  603257
  624843
  631020
  636623
  667456
  673328
  739151
  751470
  773217
]

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 (30680, 32904, 336704, 373048, 383432, 388005, 390389, 391528, 397025, 398209, 400677, 401559, 405146, 405811, 413529, 414183, 423978, 426705, 427832, 428158, 430313, 433968, 438311, 446548, 448313, 449180, 451589, 453321, 455623, 456027, 458330, 459626, 459935, 462815, 469783, 474249, 475181, 475282, 477050, 478505, 479355, 480902, 487747, 489183, 489296, 494684, 495499, 497775, 499706, 500475, 502214, 504854, 505390, 509151, 510675, 514111, 516313, 517494, 546320, 583797, 601031, 603257, 624843, 631020, 636623, 667456, 673328, 739151, 751470, 773217);

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
        ;