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

[
  "friends"
]

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

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

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

[
  b"\x01“´œ\x0FÛq\x1C±•ulW€~<"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193B49C0FDB711CB195756C57807E3C 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
  577392
  649106
  593835
  606778
  620265
  615714
  635188
  603147
  718695
  456688
  470106
  465449
  467619
  420726
  460731
  474632
  474681
  506820
  520701
  510908
  520422
  525211
  529434
  427530
  434000
  454308
  463511
  485155
  505460
  526833
  543425
  543334
  676911
  733204
  481688
  432149
  418597
  454527
  435479
  472567
  411201
  446080
  524527
  484144
  504213
  480719
  501209
  519632
  682531
  546669
  577323
  640136
  456618
  468965
  474633
  474639
  454521
  466094
  517567
  581433
  536665
  550667
  572711
  607372
  604960
  620295
  446894
  484463
  518593
  567088
  682530
  583723
  601976
  615703
  534994
  567148
  603906
  464566
  562108
  483788
]

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 (577392, 649106, 593835, 606778, 620265, 615714, 635188, 603147, 718695, 456688, 470106, 465449, 467619, 420726, 460731, 474632, 474681, 506820, 520701, 510908, 520422, 525211, 529434, 427530, 434000, 454308, 463511, 485155, 505460, 526833, 543425, 543334, 676911, 733204, 481688, 432149, 418597, 454527, 435479, 472567, 411201, 446080, 524527, 484144, 504213, 480719, 501209, 519632, 682531, 546669, 577323, 640136, 456618, 468965, 474633, 474639, 454521, 466094, 517567, 581433, 536665, 550667, 572711, 607372, 604960, 620295, 446894, 484463, 518593, 567088, 682530, 583723, 601976, 615703, 534994, 567148, 603906, 464566, 562108, 483788);

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
  411201
  418597
  420726
  427530
  432149
  434000
  435479
  446080
  446894
  454308
  454521
  454527
  456618
  456688
  460731
  463511
  464566
  465449
  466094
  467619
  468965
  470106
  472567
  474632
  474633
  474639
  474681
  480719
  481688
  483788
  484144
  484463
  485155
  501209
  504213
  505460
  506820
  510908
  517567
  518593
  519632
  520422
  520701
  524527
  525211
  526833
  529434
  534994
  536665
  543334
  543425
  546669
  550667
  562108
  567088
  567148
  572711
  577323
  577392
  581433
  583723
  593835
  601976
  603147
  603906
  604960
  606778
  607372
  615703
  615714
  620265
  620295
  635188
  640136
  649106
  676911
  682530
  682531
  718695
  733204
]

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 (411201, 418597, 420726, 427530, 432149, 434000, 435479, 446080, 446894, 454308, 454521, 454527, 456618, 456688, 460731, 463511, 464566, 465449, 466094, 467619, 468965, 470106, 472567, 474632, 474633, 474639, 474681, 480719, 481688, 483788, 484144, 484463, 485155, 501209, 504213, 505460, 506820, 510908, 517567, 518593, 519632, 520422, 520701, 524527, 525211, 526833, 529434, 534994, 536665, 543334, 543425, 546669, 550667, 562108, 567088, 567148, 572711, 577323, 577392, 581433, 583723, 593835, 601976, 603147, 603906, 604960, 606778, 607372, 615703, 615714, 620265, 620295, 635188, 640136, 649106, 676911, 682530, 682531, 718695, 733204);

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
  411201
  418597
  420726
  427530
  432149
  434000
  435479
  446080
  446894
  454308
  454521
  454527
  456618
  456688
  460731
  463511
  464566
  465449
  466094
  467619
  468965
  470106
  472567
  474632
  474633
  474639
  474681
  480719
  481688
  483788
  484144
  484463
  485155
  501209
  504213
  505460
  506820
  510908
  517567
  518593
  519632
  520422
  520701
  524527
  525211
  526833
  529434
  534994
  536665
  543334
  543425
  546669
  550667
  562108
  567088
  567148
  572711
  577323
  577392
  581433
  583723
  593835
  601976
  603147
  603906
  604960
  606778
  607372
  615703
  615714
  620265
  620295
  635188
  640136
  649106
  676911
  682530
  682531
  718695
  733204
]

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 (411201, 418597, 420726, 427530, 432149, 434000, 435479, 446080, 446894, 454308, 454521, 454527, 456618, 456688, 460731, 463511, 464566, 465449, 466094, 467619, 468965, 470106, 472567, 474632, 474633, 474639, 474681, 480719, 481688, 483788, 484144, 484463, 485155, 501209, 504213, 505460, 506820, 510908, 517567, 518593, 519632, 520422, 520701, 524527, 525211, 526833, 529434, 534994, 536665, 543334, 543425, 546669, 550667, 562108, 567088, 567148, 572711, 577323, 577392, 581433, 583723, 593835, 601976, 603147, 603906, 604960, 606778, 607372, 615703, 615714, 620265, 620295, 635188, 640136, 649106, 676911, 682530, 682531, 718695, 733204);

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

[
  "friends"
]

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

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

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

[
  "friends"
]

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

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