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

[
  "rus office"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rus office' 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
  493015
  825684
  547751
  542027
  566765
  574867
  546763
  456653
  479993
  450529
  455307
  512341
  519464
  484368
  499120
  512737
  515635
  502645
  484257
  531581
  545481
  556574
  553657
  556534
  591172
  447055
  460647
  470498
  411108
  493847
  519364
  520411
  524641
  519439
  502586
  528165
  411863
  528195
  437591
  444095
  467450
  469641
  478087
  503146
  528221
  483323
  522294
  515705
  475873
  576051
  546594
  564443
  542086
  421398
  428771
  469764
  528010
  527442
  486093
  654466
  597474
  561814
  513566
  523262
  590221
  625439
  590135
  511366
  622778
  476604
  599177
  625440
  621272
]

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 (493015, 825684, 547751, 542027, 566765, 574867, 546763, 456653, 479993, 450529, 455307, 512341, 519464, 484368, 499120, 512737, 515635, 502645, 484257, 531581, 545481, 556574, 553657, 556534, 591172, 447055, 460647, 470498, 411108, 493847, 519364, 520411, 524641, 519439, 502586, 528165, 411863, 528195, 437591, 444095, 467450, 469641, 478087, 503146, 528221, 483323, 522294, 515705, 475873, 576051, 546594, 564443, 542086, 421398, 428771, 469764, 528010, 527442, 486093, 654466, 597474, 561814, 513566, 523262, 590221, 625439, 590135, 511366, 622778, 476604, 599177, 625440, 621272);

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
  411108
  411863
  421398
  428771
  437591
  444095
  447055
  450529
  455307
  456653
  460647
  467450
  469641
  469764
  470498
  475873
  476604
  478087
  479993
  483323
  484257
  484368
  486093
  493015
  493847
  499120
  502586
  502645
  503146
  511366
  512341
  512737
  513566
  515635
  515705
  519364
  519439
  519464
  520411
  522294
  523262
  524641
  527442
  528010
  528165
  528195
  528221
  531581
  542027
  542086
  545481
  546594
  546763
  547751
  553657
  556534
  556574
  561814
  564443
  566765
  574867
  576051
  590135
  590221
  591172
  597474
  599177
  621272
  622778
  625439
  625440
  654466
  825684
]

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 (411108, 411863, 421398, 428771, 437591, 444095, 447055, 450529, 455307, 456653, 460647, 467450, 469641, 469764, 470498, 475873, 476604, 478087, 479993, 483323, 484257, 484368, 486093, 493015, 493847, 499120, 502586, 502645, 503146, 511366, 512341, 512737, 513566, 515635, 515705, 519364, 519439, 519464, 520411, 522294, 523262, 524641, 527442, 528010, 528165, 528195, 528221, 531581, 542027, 542086, 545481, 546594, 546763, 547751, 553657, 556534, 556574, 561814, 564443, 566765, 574867, 576051, 590135, 590221, 591172, 597474, 599177, 621272, 622778, 625439, 625440, 654466, 825684);

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
  411108
  411863
  421398
  428771
  437591
  444095
  447055
  450529
  455307
  456653
  460647
  467450
  469641
  469764
  470498
  475873
  476604
  478087
  479993
  483323
  484257
  484368
  486093
  493015
  493847
  499120
  502586
  502645
  503146
  511366
  512341
  512737
  513566
  515635
  515705
  519364
  519439
  519464
  520411
  522294
  523262
  524641
  527442
  528010
  528165
  528195
  528221
  531581
  542027
  542086
  545481
  546594
  546763
  547751
  553657
  556534
  556574
  561814
  564443
  566765
  574867
  576051
  590135
  590221
  591172
  597474
  599177
  621272
  622778
  625439
  625440
  654466
  825684
]

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 (411108, 411863, 421398, 428771, 437591, 444095, 447055, 450529, 455307, 456653, 460647, 467450, 469641, 469764, 470498, 475873, 476604, 478087, 479993, 483323, 484257, 484368, 486093, 493015, 493847, 499120, 502586, 502645, 503146, 511366, 512341, 512737, 513566, 515635, 515705, 519364, 519439, 519464, 520411, 522294, 523262, 524641, 527442, 528010, 528165, 528195, 528221, 531581, 542027, 542086, 545481, 546594, 546763, 547751, 553657, 556534, 556574, 561814, 564443, 566765, 574867, 576051, 590135, 590221, 591172, 597474, 599177, 621272, 622778, 625439, 625440, 654466, 825684);

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 ?

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