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

[
  "looking up"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'looking up' 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
  828614
  752855
  692625
  579410
  539111
  563155
  812040
  828300
  658301
  675347
  781542
  772349
  826541
  826647
  657375
  670463
  671801
  786659
  786664
  584578
  576945
  802000
  734120
  740648
  547130
  594803
  797359
  803953
  726213
  761968
  763912
  748360
  398135
  668698
  628458
  735808
  510323
  654659
  734175
  813989
  539425
  628668
  720714
  791766
  527820
  383433
  717880
  662429
  584579
  584607
  806830
  747064
  388858
  814968
  556329
  717902
  645255
  776614
  425269
  558386
  396286
  423491
  548232
  611365
  784922
  521334
  505984
  571824
  789694
  505425
  507873
  517654
  479279
]

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 (828614, 752855, 692625, 579410, 539111, 563155, 812040, 828300, 658301, 675347, 781542, 772349, 826541, 826647, 657375, 670463, 671801, 786659, 786664, 584578, 576945, 802000, 734120, 740648, 547130, 594803, 797359, 803953, 726213, 761968, 763912, 748360, 398135, 668698, 628458, 735808, 510323, 654659, 734175, 813989, 539425, 628668, 720714, 791766, 527820, 383433, 717880, 662429, 584579, 584607, 806830, 747064, 388858, 814968, 556329, 717902, 645255, 776614, 425269, 558386, 396286, 423491, 548232, 611365, 784922, 521334, 505984, 571824, 789694, 505425, 507873, 517654, 479279);

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
  383433
  388858
  396286
  398135
  423491
  425269
  479279
  505425
  505984
  507873
  510323
  517654
  521334
  527820
  539111
  539425
  547130
  548232
  556329
  558386
  563155
  571824
  576945
  579410
  584578
  584579
  584607
  594803
  611365
  628458
  628668
  645255
  654659
  657375
  658301
  662429
  668698
  670463
  671801
  675347
  692625
  717880
  717902
  720714
  726213
  734120
  734175
  735808
  740648
  747064
  748360
  752855
  761968
  763912
  772349
  776614
  781542
  784922
  786659
  786664
  789694
  791766
  797359
  802000
  803953
  806830
  812040
  813989
  814968
  826541
  826647
  828614
]

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 (383433, 388858, 396286, 398135, 423491, 425269, 479279, 505425, 505984, 507873, 510323, 517654, 521334, 527820, 539111, 539425, 547130, 548232, 556329, 558386, 563155, 571824, 576945, 579410, 584578, 584579, 584607, 594803, 611365, 628458, 628668, 645255, 654659, 657375, 658301, 662429, 668698, 670463, 671801, 675347, 692625, 717880, 717902, 720714, 726213, 734120, 734175, 735808, 740648, 747064, 748360, 752855, 761968, 763912, 772349, 776614, 781542, 784922, 786659, 786664, 789694, 791766, 797359, 802000, 803953, 806830, 812040, 813989, 814968, 826541, 826647, 828614);

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
  383433
  388858
  396286
  398135
  423491
  425269
  479279
  505425
  505984
  507873
  510323
  517654
  521334
  527820
  539111
  539425
  547130
  548232
  556329
  558386
  563155
  571824
  576945
  579410
  584578
  584579
  584607
  594803
  611365
  628458
  628668
  645255
  654659
  657375
  658301
  662429
  668698
  670463
  671801
  675347
  692625
  717880
  717902
  720714
  726213
  734120
  734175
  735808
  740648
  747064
  748360
  752855
  761968
  763912
  772349
  776614
  781542
  784922
  786659
  786664
  789694
  791766
  797359
  802000
  803953
  806830
  812040
  813989
  814968
  826541
  826647
  828614
]

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 (383433, 388858, 396286, 398135, 423491, 425269, 479279, 505425, 505984, 507873, 510323, 517654, 521334, 527820, 539111, 539425, 547130, 548232, 556329, 558386, 563155, 571824, 576945, 579410, 584578, 584579, 584607, 594803, 611365, 628458, 628668, 645255, 654659, 657375, 658301, 662429, 668698, 670463, 671801, 675347, 692625, 717880, 717902, 720714, 726213, 734120, 734175, 735808, 740648, 747064, 748360, 752855, 761968, 763912, 772349, 776614, 781542, 784922, 786659, 786664, 789694, 791766, 797359, 802000, 803953, 806830, 812040, 813989, 814968, 826541, 826647, 828614);

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

[
  "looking up"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'looking up';

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

[
  "looking up"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'looking up';

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 ?

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