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

[
  "cute russian teens"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cute russian teens' 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
  512022
  523430
  524131
  482916
  492571
  512971
  513346
  526452
  527983
  492670
  501650
  505279
  521483
  493047
  502503
  524060
  396740
  594029
  565405
  659562
  597146
  420472
  420559
  560834
  565201
  655762
  658307
  560841
  571691
  598718
  615608
  456452
  432775
  448083
  473781
  513324
  513500
  514768
  521971
  540996
  655471
  584772
  601491
  631600
  593975
  569249
  529229
  542218
  584863
  608279
  518206
  611645
  655714
  598172
  604743
  434319
  525686
  659842
  603888
  633732
  611289
  590403
  595871
  600084
  602715
  603102
  636869
  600330
  599450
  614609
  561704
  620100
  621643
  596168
  606002
  597946
  462372
  487713
  654740
  673661
  596677
  649185
]

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 (512022, 523430, 524131, 482916, 492571, 512971, 513346, 526452, 527983, 492670, 501650, 505279, 521483, 493047, 502503, 524060, 396740, 594029, 565405, 659562, 597146, 420472, 420559, 560834, 565201, 655762, 658307, 560841, 571691, 598718, 615608, 456452, 432775, 448083, 473781, 513324, 513500, 514768, 521971, 540996, 655471, 584772, 601491, 631600, 593975, 569249, 529229, 542218, 584863, 608279, 518206, 611645, 655714, 598172, 604743, 434319, 525686, 659842, 603888, 633732, 611289, 590403, 595871, 600084, 602715, 603102, 636869, 600330, 599450, 614609, 561704, 620100, 621643, 596168, 606002, 597946, 462372, 487713, 654740, 673661, 596677, 649185);

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
  396740
  420472
  420559
  432775
  434319
  448083
  456452
  462372
  473781
  482916
  487713
  492571
  492670
  493047
  501650
  502503
  505279
  512022
  512971
  513324
  513346
  513500
  514768
  518206
  521483
  521971
  523430
  524060
  524131
  525686
  526452
  527983
  529229
  540996
  542218
  560834
  560841
  561704
  565201
  565405
  569249
  571691
  584772
  584863
  590403
  593975
  594029
  595871
  596168
  596677
  597146
  597946
  598172
  598718
  599450
  600084
  600330
  601491
  602715
  603102
  603888
  604743
  606002
  608279
  611289
  611645
  614609
  615608
  620100
  621643
  631600
  633732
  636869
  649185
  654740
  655471
  655714
  655762
  658307
  659562
  659842
  673661
]

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 (396740, 420472, 420559, 432775, 434319, 448083, 456452, 462372, 473781, 482916, 487713, 492571, 492670, 493047, 501650, 502503, 505279, 512022, 512971, 513324, 513346, 513500, 514768, 518206, 521483, 521971, 523430, 524060, 524131, 525686, 526452, 527983, 529229, 540996, 542218, 560834, 560841, 561704, 565201, 565405, 569249, 571691, 584772, 584863, 590403, 593975, 594029, 595871, 596168, 596677, 597146, 597946, 598172, 598718, 599450, 600084, 600330, 601491, 602715, 603102, 603888, 604743, 606002, 608279, 611289, 611645, 614609, 615608, 620100, 621643, 631600, 633732, 636869, 649185, 654740, 655471, 655714, 655762, 658307, 659562, 659842, 673661);

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
  396740
  420472
  420559
  432775
  434319
  448083
  456452
  462372
  473781
  482916
  487713
  492571
  492670
  493047
  501650
  502503
  505279
  512022
  512971
  513324
  513346
  513500
  514768
  518206
  521483
  521971
  523430
  524060
  524131
  525686
  526452
  527983
  529229
  540996
  542218
  560834
  560841
  561704
  565201
  565405
  569249
  571691
  584772
  584863
  590403
  593975
  594029
  595871
  596168
  596677
  597146
  597946
  598172
  598718
  599450
  600084
  600330
  601491
  602715
  603102
  603888
  604743
  606002
  608279
  611289
  611645
  614609
  615608
  620100
  621643
  631600
  633732
  636869
  649185
  654740
  655471
  655714
  655762
  658307
  659562
  659842
  673661
]

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 (396740, 420472, 420559, 432775, 434319, 448083, 456452, 462372, 473781, 482916, 487713, 492571, 492670, 493047, 501650, 502503, 505279, 512022, 512971, 513324, 513346, 513500, 514768, 518206, 521483, 521971, 523430, 524060, 524131, 525686, 526452, 527983, 529229, 540996, 542218, 560834, 560841, 561704, 565201, 565405, 569249, 571691, 584772, 584863, 590403, 593975, 594029, 595871, 596168, 596677, 597146, 597946, 598172, 598718, 599450, 600084, 600330, 601491, 602715, 603102, 603888, 604743, 606002, 608279, 611289, 611645, 614609, 615608, 620100, 621643, 631600, 633732, 636869, 649185, 654740, 655471, 655714, 655762, 658307, 659562, 659842, 673661);

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

[
  "cute русск teens"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cute русск teens';

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

[
  "cute русск teens"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cute русск teens';