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

[
  "julie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'julie' 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
  734493
  628030
  549913
  775955
  712446
  623690
  764363
  623670
  770518
  482526
  587449
  549066
  742188
  623677
  594821
  518228
  533867
  533856
  623683
  447771
  584353
  708468
  594896
  645010
  533855
  533854
  540553
  653972
  715869
  720840
  645006
  550201
  531405
  518219
  530376
  618708
  587167
  825008
  767096
  822193
  599814
  642281
  785042
  815162
  644700
  676465
  56810
  447306
  343369
  409008
  815444
  44998
  458557
  458549
  803941
  407902
  821586
  703432
  385549
  154374
  744246
  501772
  429592
  486447
  459844
  479800
  181043
  464018
  486442
  430469
  421253
  482665
  822673
  482668
  521307
]

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 (734493, 628030, 549913, 775955, 712446, 623690, 764363, 623670, 770518, 482526, 587449, 549066, 742188, 623677, 594821, 518228, 533867, 533856, 623683, 447771, 584353, 708468, 594896, 645010, 533855, 533854, 540553, 653972, 715869, 720840, 645006, 550201, 531405, 518219, 530376, 618708, 587167, 825008, 767096, 822193, 599814, 642281, 785042, 815162, 644700, 676465, 56810, 447306, 343369, 409008, 815444, 44998, 458557, 458549, 803941, 407902, 821586, 703432, 385549, 154374, 744246, 501772, 429592, 486447, 459844, 479800, 181043, 464018, 486442, 430469, 421253, 482665, 822673, 482668, 521307);

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
  44998
  56810
  154374
  181043
  343369
  385549
  407902
  409008
  421253
  429592
  430469
  447306
  447771
  458549
  458557
  459844
  464018
  479800
  482526
  482665
  482668
  486442
  486447
  501772
  518219
  518228
  521307
  530376
  531405
  533854
  533855
  533856
  533867
  540553
  549066
  549913
  550201
  584353
  587167
  587449
  594821
  594896
  599814
  618708
  623670
  623677
  623683
  623690
  628030
  642281
  644700
  645006
  645010
  653972
  676465
  703432
  708468
  712446
  715869
  720840
  734493
  742188
  744246
  764363
  767096
  770518
  775955
  785042
  803941
  815162
  815444
  821586
  822193
  822673
  825008
]

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 (44998, 56810, 154374, 181043, 343369, 385549, 407902, 409008, 421253, 429592, 430469, 447306, 447771, 458549, 458557, 459844, 464018, 479800, 482526, 482665, 482668, 486442, 486447, 501772, 518219, 518228, 521307, 530376, 531405, 533854, 533855, 533856, 533867, 540553, 549066, 549913, 550201, 584353, 587167, 587449, 594821, 594896, 599814, 618708, 623670, 623677, 623683, 623690, 628030, 642281, 644700, 645006, 645010, 653972, 676465, 703432, 708468, 712446, 715869, 720840, 734493, 742188, 744246, 764363, 767096, 770518, 775955, 785042, 803941, 815162, 815444, 821586, 822193, 822673, 825008);

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
  44998
  56810
  154374
  181043
  343369
  385549
  407902
  409008
  421253
  429592
  430469
  447306
  447771
  458549
  458557
  459844
  464018
  479800
  482526
  482665
  482668
  486442
  486447
  501772
  518219
  518228
  521307
  530376
  531405
  533854
  533855
  533856
  533867
  540553
  549066
  549913
  550201
  584353
  587167
  587449
  594821
  594896
  599814
  618708
  623670
  623677
  623683
  623690
  628030
  642281
  644700
  645006
  645010
  653972
  676465
  703432
  708468
  712446
  715869
  720840
  734493
  742188
  744246
  764363
  767096
  770518
  775955
  785042
  803941
  815162
  815444
  821586
  822193
  822673
  825008
]

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 (44998, 56810, 154374, 181043, 343369, 385549, 407902, 409008, 421253, 429592, 430469, 447306, 447771, 458549, 458557, 459844, 464018, 479800, 482526, 482665, 482668, 486442, 486447, 501772, 518219, 518228, 521307, 530376, 531405, 533854, 533855, 533856, 533867, 540553, 549066, 549913, 550201, 584353, 587167, 587449, 594821, 594896, 599814, 618708, 623670, 623677, 623683, 623690, 628030, 642281, 644700, 645006, 645010, 653972, 676465, 703432, 708468, 712446, 715869, 720840, 734493, 742188, 744246, 764363, 767096, 770518, 775955, 785042, 803941, 815162, 815444, 821586, 822193, 822673, 825008);

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

[
  "julie"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'julie';

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

[
  "julie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'julie';

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 ?

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