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

[
  "секс-с-овощами-"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс-с-овощами-' 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
  520566
  484876
  531384
  569469
  790224
  439292
  452814
  455087
  529205
  713885
  752802
  770263
  458820
  441080
  499288
  513672
  471194
  529191
  732104
  799163
  439369
  455082
  464053
  487428
  441089
  557126
  530636
  417196
  654597
  452645
  515764
  453582
  471660
  489689
  492165
  423934
  444918
  501015
  495138
  547237
  544052
  513461
  455610
  451816
  554235
  577620
  513621
  428944
  556875
  439609
  569654
  722380
  537292
  508682
  503673
  522101
  550680
  518671
  439521
  500734
  528447
  605745
  470458
  443218
  453408
  16971
  591004
  519317
  581997
  601748
  452895
  533727
  580123
  448845
  518468
  610575
  528435
  586576
]

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 (520566, 484876, 531384, 569469, 790224, 439292, 452814, 455087, 529205, 713885, 752802, 770263, 458820, 441080, 499288, 513672, 471194, 529191, 732104, 799163, 439369, 455082, 464053, 487428, 441089, 557126, 530636, 417196, 654597, 452645, 515764, 453582, 471660, 489689, 492165, 423934, 444918, 501015, 495138, 547237, 544052, 513461, 455610, 451816, 554235, 577620, 513621, 428944, 556875, 439609, 569654, 722380, 537292, 508682, 503673, 522101, 550680, 518671, 439521, 500734, 528447, 605745, 470458, 443218, 453408, 16971, 591004, 519317, 581997, 601748, 452895, 533727, 580123, 448845, 518468, 610575, 528435, 586576);

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
  16971
  417196
  423934
  428944
  439292
  439369
  439521
  439609
  441080
  441089
  443218
  444918
  448845
  451816
  452645
  452814
  452895
  453408
  453582
  455082
  455087
  455610
  458820
  464053
  470458
  471194
  471660
  484876
  487428
  489689
  492165
  495138
  499288
  500734
  501015
  503673
  508682
  513461
  513621
  513672
  515764
  518468
  518671
  519317
  520566
  522101
  528435
  528447
  529191
  529205
  530636
  531384
  533727
  537292
  544052
  547237
  550680
  554235
  556875
  557126
  569469
  569654
  577620
  580123
  581997
  586576
  591004
  601748
  605745
  610575
  654597
  713885
  722380
  732104
  752802
  770263
  790224
  799163
]

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 (16971, 417196, 423934, 428944, 439292, 439369, 439521, 439609, 441080, 441089, 443218, 444918, 448845, 451816, 452645, 452814, 452895, 453408, 453582, 455082, 455087, 455610, 458820, 464053, 470458, 471194, 471660, 484876, 487428, 489689, 492165, 495138, 499288, 500734, 501015, 503673, 508682, 513461, 513621, 513672, 515764, 518468, 518671, 519317, 520566, 522101, 528435, 528447, 529191, 529205, 530636, 531384, 533727, 537292, 544052, 547237, 550680, 554235, 556875, 557126, 569469, 569654, 577620, 580123, 581997, 586576, 591004, 601748, 605745, 610575, 654597, 713885, 722380, 732104, 752802, 770263, 790224, 799163);

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
  16971
  417196
  423934
  428944
  439292
  439369
  439521
  439609
  441080
  441089
  443218
  444918
  448845
  451816
  452645
  452814
  452895
  453408
  453582
  455082
  455087
  455610
  458820
  464053
  470458
  471194
  471660
  484876
  487428
  489689
  492165
  495138
  499288
  500734
  501015
  503673
  508682
  513461
  513621
  513672
  515764
  518468
  518671
  519317
  520566
  522101
  528435
  528447
  529191
  529205
  530636
  531384
  533727
  537292
  544052
  547237
  550680
  554235
  556875
  557126
  569469
  569654
  577620
  580123
  581997
  586576
  591004
  601748
  605745
  610575
  654597
  713885
  722380
  732104
  752802
  770263
  790224
  799163
]

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 (16971, 417196, 423934, 428944, 439292, 439369, 439521, 439609, 441080, 441089, 443218, 444918, 448845, 451816, 452645, 452814, 452895, 453408, 453582, 455082, 455087, 455610, 458820, 464053, 470458, 471194, 471660, 484876, 487428, 489689, 492165, 495138, 499288, 500734, 501015, 503673, 508682, 513461, 513621, 513672, 515764, 518468, 518671, 519317, 520566, 522101, 528435, 528447, 529191, 529205, 530636, 531384, 533727, 537292, 544052, 547237, 550680, 554235, 556875, 557126, 569469, 569654, 577620, 580123, 581997, 586576, 591004, 601748, 605745, 610575, 654597, 713885, 722380, 732104, 752802, 770263, 790224, 799163);

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` = 'секс овощ';