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

[
  "short hair redhead"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'short hair redhead' 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
  466331
  476360
  467248
  479499
  420758
  424648
  437960
  470657
  439500
  504864
  486887
  508735
  513329
  518617
  485697
  485777
  490192
  466989
  493192
  615862
  431046
  482516
  469738
  527470
  470037
  482536
  554409
  576673
  549245
  610096
  467034
  474941
  467476
  469774
  484650
  488382
  519942
  492221
  510951
  522972
  444003
  531174
  518430
  547620
  597573
  603286
  637427
  631209
  419550
  466097
  500857
  484419
  644916
  600006
  632642
  527447
  528456
  546774
  419546
  470939
  516053
  484727
  524882
  460733
  549233
  578823
  603964
  470596
  506047
  484372
  487911
  469534
  620757
  617219
  616996
  508150
]

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 (466331, 476360, 467248, 479499, 420758, 424648, 437960, 470657, 439500, 504864, 486887, 508735, 513329, 518617, 485697, 485777, 490192, 466989, 493192, 615862, 431046, 482516, 469738, 527470, 470037, 482536, 554409, 576673, 549245, 610096, 467034, 474941, 467476, 469774, 484650, 488382, 519942, 492221, 510951, 522972, 444003, 531174, 518430, 547620, 597573, 603286, 637427, 631209, 419550, 466097, 500857, 484419, 644916, 600006, 632642, 527447, 528456, 546774, 419546, 470939, 516053, 484727, 524882, 460733, 549233, 578823, 603964, 470596, 506047, 484372, 487911, 469534, 620757, 617219, 616996, 508150);

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
  419546
  419550
  420758
  424648
  431046
  437960
  439500
  444003
  460733
  466097
  466331
  466989
  467034
  467248
  467476
  469534
  469738
  469774
  470037
  470596
  470657
  470939
  474941
  476360
  479499
  482516
  482536
  484372
  484419
  484650
  484727
  485697
  485777
  486887
  487911
  488382
  490192
  492221
  493192
  500857
  504864
  506047
  508150
  508735
  510951
  513329
  516053
  518430
  518617
  519942
  522972
  524882
  527447
  527470
  528456
  531174
  546774
  547620
  549233
  549245
  554409
  576673
  578823
  597573
  600006
  603286
  603964
  610096
  615862
  616996
  617219
  620757
  631209
  632642
  637427
  644916
]

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 (419546, 419550, 420758, 424648, 431046, 437960, 439500, 444003, 460733, 466097, 466331, 466989, 467034, 467248, 467476, 469534, 469738, 469774, 470037, 470596, 470657, 470939, 474941, 476360, 479499, 482516, 482536, 484372, 484419, 484650, 484727, 485697, 485777, 486887, 487911, 488382, 490192, 492221, 493192, 500857, 504864, 506047, 508150, 508735, 510951, 513329, 516053, 518430, 518617, 519942, 522972, 524882, 527447, 527470, 528456, 531174, 546774, 547620, 549233, 549245, 554409, 576673, 578823, 597573, 600006, 603286, 603964, 610096, 615862, 616996, 617219, 620757, 631209, 632642, 637427, 644916);

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
  419546
  419550
  420758
  424648
  431046
  437960
  439500
  444003
  460733
  466097
  466331
  466989
  467034
  467248
  467476
  469534
  469738
  469774
  470037
  470596
  470657
  470939
  474941
  476360
  479499
  482516
  482536
  484372
  484419
  484650
  484727
  485697
  485777
  486887
  487911
  488382
  490192
  492221
  493192
  500857
  504864
  506047
  508150
  508735
  510951
  513329
  516053
  518430
  518617
  519942
  522972
  524882
  527447
  527470
  528456
  531174
  546774
  547620
  549233
  549245
  554409
  576673
  578823
  597573
  600006
  603286
  603964
  610096
  615862
  616996
  617219
  620757
  631209
  632642
  637427
  644916
]

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 (419546, 419550, 420758, 424648, 431046, 437960, 439500, 444003, 460733, 466097, 466331, 466989, 467034, 467248, 467476, 469534, 469738, 469774, 470037, 470596, 470657, 470939, 474941, 476360, 479499, 482516, 482536, 484372, 484419, 484650, 484727, 485697, 485777, 486887, 487911, 488382, 490192, 492221, 493192, 500857, 504864, 506047, 508150, 508735, 510951, 513329, 516053, 518430, 518617, 519942, 522972, 524882, 527447, 527470, 528456, 531174, 546774, 547620, 549233, 549245, 554409, 576673, 578823, 597573, 600006, 603286, 603964, 610096, 615862, 616996, 617219, 620757, 631209, 632642, 637427, 644916);

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

[
  "short hair рыжая"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'short hair рыжая';

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

[
  "short hair рыжая"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'short hair рыжая';