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

[
  "cash"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cash' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01”-(>~q\x01­ü%:',Èc"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01942D283E7E7101ADFC253A272CC863 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
  578121
  589786
  623446
  594868
  614696
  612039
  612050
  504136
  512329
  504644
  511745
  487146
  491706
  513873
  520249
  508818
  468445
  485675
  475056
  482665
  516709
  494058
  525644
  506529
  519989
  467137
  575211
  576056
  560620
  564719
  575775
  601244
  589767
  594920
  594960
  612699
  432822
  396249
  434779
  446601
  511744
  486387
  508493
  422599
  482668
  532264
  523041
  576118
  574792
  576074
  632055
  453126
  491647
  575778
  584642
  649908
  605318
  617784
  601900
  630265
  638303
  395648
  611819
  584631
  618924
  587886
  576396
  580334
  663888
  611739
  589721
  594830
  426654
  517665
  526546
  564456
]

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 (578121, 589786, 623446, 594868, 614696, 612039, 612050, 504136, 512329, 504644, 511745, 487146, 491706, 513873, 520249, 508818, 468445, 485675, 475056, 482665, 516709, 494058, 525644, 506529, 519989, 467137, 575211, 576056, 560620, 564719, 575775, 601244, 589767, 594920, 594960, 612699, 432822, 396249, 434779, 446601, 511744, 486387, 508493, 422599, 482668, 532264, 523041, 576118, 574792, 576074, 632055, 453126, 491647, 575778, 584642, 649908, 605318, 617784, 601900, 630265, 638303, 395648, 611819, 584631, 618924, 587886, 576396, 580334, 663888, 611739, 589721, 594830, 426654, 517665, 526546, 564456);

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
  395648
  396249
  422599
  426654
  432822
  434779
  446601
  453126
  467137
  468445
  475056
  482665
  482668
  485675
  486387
  487146
  491647
  491706
  494058
  504136
  504644
  506529
  508493
  508818
  511744
  511745
  512329
  513873
  516709
  517665
  519989
  520249
  523041
  525644
  526546
  532264
  560620
  564456
  564719
  574792
  575211
  575775
  575778
  576056
  576074
  576118
  576396
  578121
  580334
  584631
  584642
  587886
  589721
  589767
  589786
  594830
  594868
  594920
  594960
  601244
  601900
  605318
  611739
  611819
  612039
  612050
  612699
  614696
  617784
  618924
  623446
  630265
  632055
  638303
  649908
  663888
]

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 (395648, 396249, 422599, 426654, 432822, 434779, 446601, 453126, 467137, 468445, 475056, 482665, 482668, 485675, 486387, 487146, 491647, 491706, 494058, 504136, 504644, 506529, 508493, 508818, 511744, 511745, 512329, 513873, 516709, 517665, 519989, 520249, 523041, 525644, 526546, 532264, 560620, 564456, 564719, 574792, 575211, 575775, 575778, 576056, 576074, 576118, 576396, 578121, 580334, 584631, 584642, 587886, 589721, 589767, 589786, 594830, 594868, 594920, 594960, 601244, 601900, 605318, 611739, 611819, 612039, 612050, 612699, 614696, 617784, 618924, 623446, 630265, 632055, 638303, 649908, 663888);

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
  395648
  396249
  422599
  426654
  432822
  434779
  446601
  453126
  467137
  468445
  475056
  482665
  482668
  485675
  486387
  487146
  491647
  491706
  494058
  504136
  504644
  506529
  508493
  508818
  511744
  511745
  512329
  513873
  516709
  517665
  519989
  520249
  523041
  525644
  526546
  532264
  560620
  564456
  564719
  574792
  575211
  575775
  575778
  576056
  576074
  576118
  576396
  578121
  580334
  584631
  584642
  587886
  589721
  589767
  589786
  594830
  594868
  594920
  594960
  601244
  601900
  605318
  611739
  611819
  612039
  612050
  612699
  614696
  617784
  618924
  623446
  630265
  632055
  638303
  649908
  663888
]

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 (395648, 396249, 422599, 426654, 432822, 434779, 446601, 453126, 467137, 468445, 475056, 482665, 482668, 485675, 486387, 487146, 491647, 491706, 494058, 504136, 504644, 506529, 508493, 508818, 511744, 511745, 512329, 513873, 516709, 517665, 519989, 520249, 523041, 525644, 526546, 532264, 560620, 564456, 564719, 574792, 575211, 575775, 575778, 576056, 576074, 576118, 576396, 578121, 580334, 584631, 584642, 587886, 589721, 589767, 589786, 594830, 594868, 594920, 594960, 601244, 601900, 605318, 611739, 611819, 612039, 612050, 612699, 614696, 617784, 618924, 623446, 630265, 632055, 638303, 649908, 663888);

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

[
  "cash"
]

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

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

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

[
  "cash"
]

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

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