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

[
  "bbc russian anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc russian anal' 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
  565413
  420182
  551223
  536290
  535595
  531172
  537988
  659283
  616617
  637741
  424523
  497885
  484673
  478006
  572042
  556051
  596643
  390831
  341675
  439993
  503838
  533697
  535620
  436042
  535631
  488726
  621612
  590411
  586596
  658082
  37350
  598471
  558126
  731665
  451572
  602647
  517869
  533477
  755082
  510109
  552266
  532954
  543731
  470291
  388690
  572022
  561995
  489373
  656792
  598042
  596616
  436032
  558601
  555789
  617097
  659258
  472340
  577980
  478930
  597028
  620641
  648871
  631193
  452018
  463693
  462372
  512508
  474643
  523948
  541084
  598133
  490684
  527273
]

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 (565413, 420182, 551223, 536290, 535595, 531172, 537988, 659283, 616617, 637741, 424523, 497885, 484673, 478006, 572042, 556051, 596643, 390831, 341675, 439993, 503838, 533697, 535620, 436042, 535631, 488726, 621612, 590411, 586596, 658082, 37350, 598471, 558126, 731665, 451572, 602647, 517869, 533477, 755082, 510109, 552266, 532954, 543731, 470291, 388690, 572022, 561995, 489373, 656792, 598042, 596616, 436032, 558601, 555789, 617097, 659258, 472340, 577980, 478930, 597028, 620641, 648871, 631193, 452018, 463693, 462372, 512508, 474643, 523948, 541084, 598133, 490684, 527273);

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
  37350
  341675
  388690
  390831
  420182
  424523
  436032
  436042
  439993
  451572
  452018
  462372
  463693
  470291
  472340
  474643
  478006
  478930
  484673
  488726
  489373
  490684
  497885
  503838
  510109
  512508
  517869
  523948
  527273
  531172
  532954
  533477
  533697
  535595
  535620
  535631
  536290
  537988
  541084
  543731
  551223
  552266
  555789
  556051
  558126
  558601
  561995
  565413
  572022
  572042
  577980
  586596
  590411
  596616
  596643
  597028
  598042
  598133
  598471
  602647
  616617
  617097
  620641
  621612
  631193
  637741
  648871
  656792
  658082
  659258
  659283
  731665
  755082
]

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 (37350, 341675, 388690, 390831, 420182, 424523, 436032, 436042, 439993, 451572, 452018, 462372, 463693, 470291, 472340, 474643, 478006, 478930, 484673, 488726, 489373, 490684, 497885, 503838, 510109, 512508, 517869, 523948, 527273, 531172, 532954, 533477, 533697, 535595, 535620, 535631, 536290, 537988, 541084, 543731, 551223, 552266, 555789, 556051, 558126, 558601, 561995, 565413, 572022, 572042, 577980, 586596, 590411, 596616, 596643, 597028, 598042, 598133, 598471, 602647, 616617, 617097, 620641, 621612, 631193, 637741, 648871, 656792, 658082, 659258, 659283, 731665, 755082);

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
  37350
  341675
  388690
  390831
  420182
  424523
  436032
  436042
  439993
  451572
  452018
  462372
  463693
  470291
  472340
  474643
  478006
  478930
  484673
  488726
  489373
  490684
  497885
  503838
  510109
  512508
  517869
  523948
  527273
  531172
  532954
  533477
  533697
  535595
  535620
  535631
  536290
  537988
  541084
  543731
  551223
  552266
  555789
  556051
  558126
  558601
  561995
  565413
  572022
  572042
  577980
  586596
  590411
  596616
  596643
  597028
  598042
  598133
  598471
  602647
  616617
  617097
  620641
  621612
  631193
  637741
  648871
  656792
  658082
  659258
  659283
  731665
  755082
]

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 (37350, 341675, 388690, 390831, 420182, 424523, 436032, 436042, 439993, 451572, 452018, 462372, 463693, 470291, 472340, 474643, 478006, 478930, 484673, 488726, 489373, 490684, 497885, 503838, 510109, 512508, 517869, 523948, 527273, 531172, 532954, 533477, 533697, 535595, 535620, 535631, 536290, 537988, 541084, 543731, 551223, 552266, 555789, 556051, 558126, 558601, 561995, 565413, 572022, 572042, 577980, 586596, 590411, 596616, 596643, 597028, 598042, 598133, 598471, 602647, 616617, 617097, 620641, 621612, 631193, 637741, 648871, 656792, 658082, 659258, 659283, 731665, 755082);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "bbc русск анал"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbc русск анал';

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

[
  "bbc русск анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc русск анал';

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 ?

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