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

[
  "homemade booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade booty' 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
  457512
  471652
  452399
  448289
  515052
  438013
  403555
  601721
  452194
  398655
  390360
  528322
  503189
  446601
  457950
  501603
  503742
  526494
  442081
  516063
  548837
  576805
  465256
  524687
  519309
  507643
  620330
  468908
  464008
  479846
  462685
  507640
  503274
  539292
  467019
  583478
  591689
  474988
  422805
  426592
  447068
  512991
  515350
  448084
  580223
  619109
  809272
  463280
  507785
  615443
  448954
  465040
  444456
  459513
  460024
  528171
  520911
  453408
  440247
  473391
  483569
  698124
  558560
  558200
  394698
  525441
  591249
  427543
  526951
  471848
  598870
  404629
  522414
  553992
  591176
  527908
  518633
]

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 (457512, 471652, 452399, 448289, 515052, 438013, 403555, 601721, 452194, 398655, 390360, 528322, 503189, 446601, 457950, 501603, 503742, 526494, 442081, 516063, 548837, 576805, 465256, 524687, 519309, 507643, 620330, 468908, 464008, 479846, 462685, 507640, 503274, 539292, 467019, 583478, 591689, 474988, 422805, 426592, 447068, 512991, 515350, 448084, 580223, 619109, 809272, 463280, 507785, 615443, 448954, 465040, 444456, 459513, 460024, 528171, 520911, 453408, 440247, 473391, 483569, 698124, 558560, 558200, 394698, 525441, 591249, 427543, 526951, 471848, 598870, 404629, 522414, 553992, 591176, 527908, 518633);

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
  390360
  394698
  398655
  403555
  404629
  422805
  426592
  427543
  438013
  440247
  442081
  444456
  446601
  447068
  448084
  448289
  448954
  452194
  452399
  453408
  457512
  457950
  459513
  460024
  462685
  463280
  464008
  465040
  465256
  467019
  468908
  471652
  471848
  473391
  474988
  479846
  483569
  501603
  503189
  503274
  503742
  507640
  507643
  507785
  512991
  515052
  515350
  516063
  518633
  519309
  520911
  522414
  524687
  525441
  526494
  526951
  527908
  528171
  528322
  539292
  548837
  553992
  558200
  558560
  576805
  580223
  583478
  591176
  591249
  591689
  598870
  601721
  615443
  619109
  620330
  698124
  809272
]

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 (390360, 394698, 398655, 403555, 404629, 422805, 426592, 427543, 438013, 440247, 442081, 444456, 446601, 447068, 448084, 448289, 448954, 452194, 452399, 453408, 457512, 457950, 459513, 460024, 462685, 463280, 464008, 465040, 465256, 467019, 468908, 471652, 471848, 473391, 474988, 479846, 483569, 501603, 503189, 503274, 503742, 507640, 507643, 507785, 512991, 515052, 515350, 516063, 518633, 519309, 520911, 522414, 524687, 525441, 526494, 526951, 527908, 528171, 528322, 539292, 548837, 553992, 558200, 558560, 576805, 580223, 583478, 591176, 591249, 591689, 598870, 601721, 615443, 619109, 620330, 698124, 809272);

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
  390360
  394698
  398655
  403555
  404629
  422805
  426592
  427543
  438013
  440247
  442081
  444456
  446601
  447068
  448084
  448289
  448954
  452194
  452399
  453408
  457512
  457950
  459513
  460024
  462685
  463280
  464008
  465040
  465256
  467019
  468908
  471652
  471848
  473391
  474988
  479846
  483569
  501603
  503189
  503274
  503742
  507640
  507643
  507785
  512991
  515052
  515350
  516063
  518633
  519309
  520911
  522414
  524687
  525441
  526494
  526951
  527908
  528171
  528322
  539292
  548837
  553992
  558200
  558560
  576805
  580223
  583478
  591176
  591249
  591689
  598870
  601721
  615443
  619109
  620330
  698124
  809272
]

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 (390360, 394698, 398655, 403555, 404629, 422805, 426592, 427543, 438013, 440247, 442081, 444456, 446601, 447068, 448084, 448289, 448954, 452194, 452399, 453408, 457512, 457950, 459513, 460024, 462685, 463280, 464008, 465040, 465256, 467019, 468908, 471652, 471848, 473391, 474988, 479846, 483569, 501603, 503189, 503274, 503742, 507640, 507643, 507785, 512991, 515052, 515350, 516063, 518633, 519309, 520911, 522414, 524687, 525441, 526494, 526951, 527908, 528171, 528322, 539292, 548837, 553992, 558200, 558560, 576805, 580223, 583478, 591176, 591249, 591689, 598870, 601721, 615443, 619109, 620330, 698124, 809272);

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

[
  "домашн любительск booty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'домашн любительск booty';

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

[
  "домашн любительск booty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'домашн любительск booty';