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

[
  "beauty step mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty step mom' 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
  557558
  649179
  724823
  400249
  402985
  421071
  460370
  523356
  519037
  519038
  501338
  522748
  557185
  565061
  569232
  647901
  702621
  565677
  591296
  616978
  400191
  407379
  401620
  513776
  504772
  492269
  519034
  533541
  427346
  421000
  427614
  477327
  534168
  491021
  413904
  560396
  584752
  606036
  597874
  610660
  789690
  485037
  502995
  534377
  572264
  606782
  601028
  430836
  492267
  460673
  532129
  509666
  510286
  499791
  650806
  593150
  606687
  602981
  525116
  513141
  543868
  566110
  807191
  431352
  560511
  531920
  479629
  502695
  512952
  524848
  583457
  550571
  588992
  609933
  486944
  578326
  599803
  605496
  614906
  610588
  431269
  597240
  519023
  517000
  569955
  559233
]

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 (557558, 649179, 724823, 400249, 402985, 421071, 460370, 523356, 519037, 519038, 501338, 522748, 557185, 565061, 569232, 647901, 702621, 565677, 591296, 616978, 400191, 407379, 401620, 513776, 504772, 492269, 519034, 533541, 427346, 421000, 427614, 477327, 534168, 491021, 413904, 560396, 584752, 606036, 597874, 610660, 789690, 485037, 502995, 534377, 572264, 606782, 601028, 430836, 492267, 460673, 532129, 509666, 510286, 499791, 650806, 593150, 606687, 602981, 525116, 513141, 543868, 566110, 807191, 431352, 560511, 531920, 479629, 502695, 512952, 524848, 583457, 550571, 588992, 609933, 486944, 578326, 599803, 605496, 614906, 610588, 431269, 597240, 519023, 517000, 569955, 559233);

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
  400191
  400249
  401620
  402985
  407379
  413904
  421000
  421071
  427346
  427614
  430836
  431269
  431352
  460370
  460673
  477327
  479629
  485037
  486944
  491021
  492267
  492269
  499791
  501338
  502695
  502995
  504772
  509666
  510286
  512952
  513141
  513776
  517000
  519023
  519034
  519037
  519038
  522748
  523356
  524848
  525116
  531920
  532129
  533541
  534168
  534377
  543868
  550571
  557185
  557558
  559233
  560396
  560511
  565061
  565677
  566110
  569232
  569955
  572264
  578326
  583457
  584752
  588992
  591296
  593150
  597240
  597874
  599803
  601028
  602981
  605496
  606036
  606687
  606782
  609933
  610588
  610660
  614906
  616978
  647901
  649179
  650806
  702621
  724823
  789690
  807191
]

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 (400191, 400249, 401620, 402985, 407379, 413904, 421000, 421071, 427346, 427614, 430836, 431269, 431352, 460370, 460673, 477327, 479629, 485037, 486944, 491021, 492267, 492269, 499791, 501338, 502695, 502995, 504772, 509666, 510286, 512952, 513141, 513776, 517000, 519023, 519034, 519037, 519038, 522748, 523356, 524848, 525116, 531920, 532129, 533541, 534168, 534377, 543868, 550571, 557185, 557558, 559233, 560396, 560511, 565061, 565677, 566110, 569232, 569955, 572264, 578326, 583457, 584752, 588992, 591296, 593150, 597240, 597874, 599803, 601028, 602981, 605496, 606036, 606687, 606782, 609933, 610588, 610660, 614906, 616978, 647901, 649179, 650806, 702621, 724823, 789690, 807191);

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
  400191
  400249
  401620
  402985
  407379
  413904
  421000
  421071
  427346
  427614
  430836
  431269
  431352
  460370
  460673
  477327
  479629
  485037
  486944
  491021
  492267
  492269
  499791
  501338
  502695
  502995
  504772
  509666
  510286
  512952
  513141
  513776
  517000
  519023
  519034
  519037
  519038
  522748
  523356
  524848
  525116
  531920
  532129
  533541
  534168
  534377
  543868
  550571
  557185
  557558
  559233
  560396
  560511
  565061
  565677
  566110
  569232
  569955
  572264
  578326
  583457
  584752
  588992
  591296
  593150
  597240
  597874
  599803
  601028
  602981
  605496
  606036
  606687
  606782
  609933
  610588
  610660
  614906
  616978
  647901
  649179
  650806
  702621
  724823
  789690
  807191
]

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 (400191, 400249, 401620, 402985, 407379, 413904, 421000, 421071, 427346, 427614, 430836, 431269, 431352, 460370, 460673, 477327, 479629, 485037, 486944, 491021, 492267, 492269, 499791, 501338, 502695, 502995, 504772, 509666, 510286, 512952, 513141, 513776, 517000, 519023, 519034, 519037, 519038, 522748, 523356, 524848, 525116, 531920, 532129, 533541, 534168, 534377, 543868, 550571, 557185, 557558, 559233, 560396, 560511, 565061, 565677, 566110, 569232, 569955, 572264, 578326, 583457, 584752, 588992, 591296, 593150, 597240, 597874, 599803, 601028, 602981, 605496, 606036, 606687, 606782, 609933, 610588, 610660, 614906, 616978, 647901, 649179, 650806, 702621, 724823, 789690, 807191);

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

[
  "beauty step mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'beauty step mom';

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

[
  "beauty step mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beauty step mom';