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

[
  "beach solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beach solo' 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
  633206
  798841
  797312
  791492
  804272
  457049
  576317
  631395
  439250
  592938
  614865
  614797
  420009
  517407
  661008
  621342
  747098
  527564
  424007
  506789
  816816
  816862
  823861
  555999
  427517
  465706
  527546
  558111
  549521
  816855
  472805
  680962
  561613
  472811
  420006
  512474
  819124
  543679
  563109
  428799
  435818
  384519
  482940
  552505
  585342
  471699
  541910
  601854
  388274
  571122
  420011
  470015
  530743
  578499
  648295
  476475
  495473
  484923
  490612
  548637
  456887
  442527
  467101
  534663
  529358
  615831
  427395
  435324
  471080
  454509
  435078
  501258
  571228
]

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 (633206, 798841, 797312, 791492, 804272, 457049, 576317, 631395, 439250, 592938, 614865, 614797, 420009, 517407, 661008, 621342, 747098, 527564, 424007, 506789, 816816, 816862, 823861, 555999, 427517, 465706, 527546, 558111, 549521, 816855, 472805, 680962, 561613, 472811, 420006, 512474, 819124, 543679, 563109, 428799, 435818, 384519, 482940, 552505, 585342, 471699, 541910, 601854, 388274, 571122, 420011, 470015, 530743, 578499, 648295, 476475, 495473, 484923, 490612, 548637, 456887, 442527, 467101, 534663, 529358, 615831, 427395, 435324, 471080, 454509, 435078, 501258, 571228);

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
  384519
  388274
  420006
  420009
  420011
  424007
  427395
  427517
  428799
  435078
  435324
  435818
  439250
  442527
  454509
  456887
  457049
  465706
  467101
  470015
  471080
  471699
  472805
  472811
  476475
  482940
  484923
  490612
  495473
  501258
  506789
  512474
  517407
  527546
  527564
  529358
  530743
  534663
  541910
  543679
  548637
  549521
  552505
  555999
  558111
  561613
  563109
  571122
  571228
  576317
  578499
  585342
  592938
  601854
  614797
  614865
  615831
  621342
  631395
  633206
  648295
  661008
  680962
  747098
  791492
  797312
  798841
  804272
  816816
  816855
  816862
  819124
  823861
]

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 (384519, 388274, 420006, 420009, 420011, 424007, 427395, 427517, 428799, 435078, 435324, 435818, 439250, 442527, 454509, 456887, 457049, 465706, 467101, 470015, 471080, 471699, 472805, 472811, 476475, 482940, 484923, 490612, 495473, 501258, 506789, 512474, 517407, 527546, 527564, 529358, 530743, 534663, 541910, 543679, 548637, 549521, 552505, 555999, 558111, 561613, 563109, 571122, 571228, 576317, 578499, 585342, 592938, 601854, 614797, 614865, 615831, 621342, 631395, 633206, 648295, 661008, 680962, 747098, 791492, 797312, 798841, 804272, 816816, 816855, 816862, 819124, 823861);

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
  384519
  388274
  420006
  420009
  420011
  424007
  427395
  427517
  428799
  435078
  435324
  435818
  439250
  442527
  454509
  456887
  457049
  465706
  467101
  470015
  471080
  471699
  472805
  472811
  476475
  482940
  484923
  490612
  495473
  501258
  506789
  512474
  517407
  527546
  527564
  529358
  530743
  534663
  541910
  543679
  548637
  549521
  552505
  555999
  558111
  561613
  563109
  571122
  571228
  576317
  578499
  585342
  592938
  601854
  614797
  614865
  615831
  621342
  631395
  633206
  648295
  661008
  680962
  747098
  791492
  797312
  798841
  804272
  816816
  816855
  816862
  819124
  823861
]

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 (384519, 388274, 420006, 420009, 420011, 424007, 427395, 427517, 428799, 435078, 435324, 435818, 439250, 442527, 454509, 456887, 457049, 465706, 467101, 470015, 471080, 471699, 472805, 472811, 476475, 482940, 484923, 490612, 495473, 501258, 506789, 512474, 517407, 527546, 527564, 529358, 530743, 534663, 541910, 543679, 548637, 549521, 552505, 555999, 558111, 561613, 563109, 571122, 571228, 576317, 578499, 585342, 592938, 601854, 614797, 614865, 615831, 621342, 631395, 633206, 648295, 661008, 680962, 747098, 791492, 797312, 798841, 804272, 816816, 816855, 816862, 819124, 823861);

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

[
  "пляж природ соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'пляж природ соло';

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

[
  "пляж природ соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пляж природ соло';