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

[
  "beautiful full"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beautiful full' 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
  541673
  584461
  620995
  451928
  430621
  495218
  531481
  452028
  452131
  459734
  447182
  472237
  492322
  534274
  534334
  531148
  475923
  555798
  541690
  560195
  713564
  557526
  633166
  600410
  633458
  451935
  452813
  452965
  522975
  527000
  522906
  492565
  527007
  452895
  452113
  534288
  530726
  542194
  559950
  604160
  628398
  452061
  430204
  512938
  541651
  542192
  621858
  448840
  452034
  452048
  532499
  541886
  541661
  565277
  541821
  524324
  486938
  541635
  452014
  528420
  533426
  541638
  541630
  541833
  541740
  630869
  427550
  430630
  542199
  541646
  556987
  542189
  522035
  497452
  642746
]

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 (541673, 584461, 620995, 451928, 430621, 495218, 531481, 452028, 452131, 459734, 447182, 472237, 492322, 534274, 534334, 531148, 475923, 555798, 541690, 560195, 713564, 557526, 633166, 600410, 633458, 451935, 452813, 452965, 522975, 527000, 522906, 492565, 527007, 452895, 452113, 534288, 530726, 542194, 559950, 604160, 628398, 452061, 430204, 512938, 541651, 542192, 621858, 448840, 452034, 452048, 532499, 541886, 541661, 565277, 541821, 524324, 486938, 541635, 452014, 528420, 533426, 541638, 541630, 541833, 541740, 630869, 427550, 430630, 542199, 541646, 556987, 542189, 522035, 497452, 642746);

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
  427550
  430204
  430621
  430630
  447182
  448840
  451928
  451935
  452014
  452028
  452034
  452048
  452061
  452113
  452131
  452813
  452895
  452965
  459734
  472237
  475923
  486938
  492322
  492565
  495218
  497452
  512938
  522035
  522906
  522975
  524324
  527000
  527007
  528420
  530726
  531148
  531481
  532499
  533426
  534274
  534288
  534334
  541630
  541635
  541638
  541646
  541651
  541661
  541673
  541690
  541740
  541821
  541833
  541886
  542189
  542192
  542194
  542199
  555798
  556987
  557526
  559950
  560195
  565277
  584461
  600410
  604160
  620995
  621858
  628398
  630869
  633166
  633458
  642746
  713564
]

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 (427550, 430204, 430621, 430630, 447182, 448840, 451928, 451935, 452014, 452028, 452034, 452048, 452061, 452113, 452131, 452813, 452895, 452965, 459734, 472237, 475923, 486938, 492322, 492565, 495218, 497452, 512938, 522035, 522906, 522975, 524324, 527000, 527007, 528420, 530726, 531148, 531481, 532499, 533426, 534274, 534288, 534334, 541630, 541635, 541638, 541646, 541651, 541661, 541673, 541690, 541740, 541821, 541833, 541886, 542189, 542192, 542194, 542199, 555798, 556987, 557526, 559950, 560195, 565277, 584461, 600410, 604160, 620995, 621858, 628398, 630869, 633166, 633458, 642746, 713564);

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
  427550
  430204
  430621
  430630
  447182
  448840
  451928
  451935
  452014
  452028
  452034
  452048
  452061
  452113
  452131
  452813
  452895
  452965
  459734
  472237
  475923
  486938
  492322
  492565
  495218
  497452
  512938
  522035
  522906
  522975
  524324
  527000
  527007
  528420
  530726
  531148
  531481
  532499
  533426
  534274
  534288
  534334
  541630
  541635
  541638
  541646
  541651
  541661
  541673
  541690
  541740
  541821
  541833
  541886
  542189
  542192
  542194
  542199
  555798
  556987
  557526
  559950
  560195
  565277
  584461
  600410
  604160
  620995
  621858
  628398
  630869
  633166
  633458
  642746
  713564
]

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 (427550, 430204, 430621, 430630, 447182, 448840, 451928, 451935, 452014, 452028, 452034, 452048, 452061, 452113, 452131, 452813, 452895, 452965, 459734, 472237, 475923, 486938, 492322, 492565, 495218, 497452, 512938, 522035, 522906, 522975, 524324, 527000, 527007, 528420, 530726, 531148, 531481, 532499, 533426, 534274, 534288, 534334, 541630, 541635, 541638, 541646, 541651, 541661, 541673, 541690, 541740, 541821, 541833, 541886, 542189, 542192, 542194, 542199, 555798, 556987, 557526, 559950, 560195, 565277, 584461, 600410, 604160, 620995, 621858, 628398, 630869, 633166, 633458, 642746, 713564);

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

[
  "красивая full"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'красивая full';

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

[
  "красивая full"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'красивая full';