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

[
  "german old man"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'german old man' 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
  794517
  744309
  407220
  626752
  235834
  720009
  803342
  743365
  817861
  819510
  714666
  761076
  753256
  508818
  415906
  509025
  396971
  824090
  826800
  677699
  804964
  803345
  776015
  386024
  741998
  761592
  813904
  577407
  603650
  775988
  753257
  729256
  759570
  618005
  402027
  486055
  479688
  518287
  558068
  644668
  599791
  766687
  810760
  384745
  495148
  564597
  744265
  750876
  742199
  780690
  417738
  471512
  453338
  534178
  559120
  528788
  522847
  564602
  610607
  625798
  528906
  559124
  614017
  518031
  478459
  600503
  523706
  594431
  395666
  491782
  551913
  416886
  521159
]

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 (794517, 744309, 407220, 626752, 235834, 720009, 803342, 743365, 817861, 819510, 714666, 761076, 753256, 508818, 415906, 509025, 396971, 824090, 826800, 677699, 804964, 803345, 776015, 386024, 741998, 761592, 813904, 577407, 603650, 775988, 753257, 729256, 759570, 618005, 402027, 486055, 479688, 518287, 558068, 644668, 599791, 766687, 810760, 384745, 495148, 564597, 744265, 750876, 742199, 780690, 417738, 471512, 453338, 534178, 559120, 528788, 522847, 564602, 610607, 625798, 528906, 559124, 614017, 518031, 478459, 600503, 523706, 594431, 395666, 491782, 551913, 416886, 521159);

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
  235834
  384745
  386024
  395666
  396971
  402027
  407220
  415906
  416886
  417738
  453338
  471512
  478459
  479688
  486055
  491782
  495148
  508818
  509025
  518031
  518287
  521159
  522847
  523706
  528788
  528906
  534178
  551913
  558068
  559120
  559124
  564597
  564602
  577407
  594431
  599791
  600503
  603650
  610607
  614017
  618005
  625798
  626752
  644668
  677699
  714666
  720009
  729256
  741998
  742199
  743365
  744265
  744309
  750876
  753256
  753257
  759570
  761076
  761592
  766687
  775988
  776015
  780690
  794517
  803342
  803345
  804964
  810760
  813904
  817861
  819510
  824090
  826800
]

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 (235834, 384745, 386024, 395666, 396971, 402027, 407220, 415906, 416886, 417738, 453338, 471512, 478459, 479688, 486055, 491782, 495148, 508818, 509025, 518031, 518287, 521159, 522847, 523706, 528788, 528906, 534178, 551913, 558068, 559120, 559124, 564597, 564602, 577407, 594431, 599791, 600503, 603650, 610607, 614017, 618005, 625798, 626752, 644668, 677699, 714666, 720009, 729256, 741998, 742199, 743365, 744265, 744309, 750876, 753256, 753257, 759570, 761076, 761592, 766687, 775988, 776015, 780690, 794517, 803342, 803345, 804964, 810760, 813904, 817861, 819510, 824090, 826800);

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
  235834
  384745
  386024
  395666
  396971
  402027
  407220
  415906
  416886
  417738
  453338
  471512
  478459
  479688
  486055
  491782
  495148
  508818
  509025
  518031
  518287
  521159
  522847
  523706
  528788
  528906
  534178
  551913
  558068
  559120
  559124
  564597
  564602
  577407
  594431
  599791
  600503
  603650
  610607
  614017
  618005
  625798
  626752
  644668
  677699
  714666
  720009
  729256
  741998
  742199
  743365
  744265
  744309
  750876
  753256
  753257
  759570
  761076
  761592
  766687
  775988
  776015
  780690
  794517
  803342
  803345
  804964
  810760
  813904
  817861
  819510
  824090
  826800
]

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 (235834, 384745, 386024, 395666, 396971, 402027, 407220, 415906, 416886, 417738, 453338, 471512, 478459, 479688, 486055, 491782, 495148, 508818, 509025, 518031, 518287, 521159, 522847, 523706, 528788, 528906, 534178, 551913, 558068, 559120, 559124, 564597, 564602, 577407, 594431, 599791, 600503, 603650, 610607, 614017, 618005, 625798, 626752, 644668, 677699, 714666, 720009, 729256, 741998, 742199, 743365, 744265, 744309, 750876, 753256, 753257, 759570, 761076, 761592, 766687, 775988, 776015, 780690, 794517, 803342, 803345, 804964, 810760, 813904, 817861, 819510, 824090, 826800);

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

[
  "german old мужчин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'german old мужчин';

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

[
  "german old мужчин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'german old мужчин';

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 ?

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