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

[
  "cheats"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cheats' 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
  526216
  547864
  576718
  553292
  566057
  663854
  578816
  599720
  624139
  606731
  621779
  622785
  638561
  616559
  808603
  455483
  440707
  455534
  481665
  437547
  485967
  501938
  524148
  509309
  527643
  532068
  512381
  423433
  439516
  617350
  503557
  525632
  511897
  562598
  567211
  579843
  563062
  573304
  565931
  566813
  606759
  604467
  628956
  594920
  613908
  626405
  768663
  634725
  431476
  421030
  472665
  502530
  507740
  513485
  518798
  416165
  481157
  498110
  480801
  560941
  638576
  477239
  450990
  485002
  513095
  504779
  513953
  527355
  543777
  615560
  487156
  522525
  452199
  494199
  475951
  528931
  606929
  606009
  622778
  623834
]

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 (526216, 547864, 576718, 553292, 566057, 663854, 578816, 599720, 624139, 606731, 621779, 622785, 638561, 616559, 808603, 455483, 440707, 455534, 481665, 437547, 485967, 501938, 524148, 509309, 527643, 532068, 512381, 423433, 439516, 617350, 503557, 525632, 511897, 562598, 567211, 579843, 563062, 573304, 565931, 566813, 606759, 604467, 628956, 594920, 613908, 626405, 768663, 634725, 431476, 421030, 472665, 502530, 507740, 513485, 518798, 416165, 481157, 498110, 480801, 560941, 638576, 477239, 450990, 485002, 513095, 504779, 513953, 527355, 543777, 615560, 487156, 522525, 452199, 494199, 475951, 528931, 606929, 606009, 622778, 623834);

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
  416165
  421030
  423433
  431476
  437547
  439516
  440707
  450990
  452199
  455483
  455534
  472665
  475951
  477239
  480801
  481157
  481665
  485002
  485967
  487156
  494199
  498110
  501938
  502530
  503557
  504779
  507740
  509309
  511897
  512381
  513095
  513485
  513953
  518798
  522525
  524148
  525632
  526216
  527355
  527643
  528931
  532068
  543777
  547864
  553292
  560941
  562598
  563062
  565931
  566057
  566813
  567211
  573304
  576718
  578816
  579843
  594920
  599720
  604467
  606009
  606731
  606759
  606929
  613908
  615560
  616559
  617350
  621779
  622778
  622785
  623834
  624139
  626405
  628956
  634725
  638561
  638576
  663854
  768663
  808603
]

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 (416165, 421030, 423433, 431476, 437547, 439516, 440707, 450990, 452199, 455483, 455534, 472665, 475951, 477239, 480801, 481157, 481665, 485002, 485967, 487156, 494199, 498110, 501938, 502530, 503557, 504779, 507740, 509309, 511897, 512381, 513095, 513485, 513953, 518798, 522525, 524148, 525632, 526216, 527355, 527643, 528931, 532068, 543777, 547864, 553292, 560941, 562598, 563062, 565931, 566057, 566813, 567211, 573304, 576718, 578816, 579843, 594920, 599720, 604467, 606009, 606731, 606759, 606929, 613908, 615560, 616559, 617350, 621779, 622778, 622785, 623834, 624139, 626405, 628956, 634725, 638561, 638576, 663854, 768663, 808603);

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
  416165
  421030
  423433
  431476
  437547
  439516
  440707
  450990
  452199
  455483
  455534
  472665
  475951
  477239
  480801
  481157
  481665
  485002
  485967
  487156
  494199
  498110
  501938
  502530
  503557
  504779
  507740
  509309
  511897
  512381
  513095
  513485
  513953
  518798
  522525
  524148
  525632
  526216
  527355
  527643
  528931
  532068
  543777
  547864
  553292
  560941
  562598
  563062
  565931
  566057
  566813
  567211
  573304
  576718
  578816
  579843
  594920
  599720
  604467
  606009
  606731
  606759
  606929
  613908
  615560
  616559
  617350
  621779
  622778
  622785
  623834
  624139
  626405
  628956
  634725
  638561
  638576
  663854
  768663
  808603
]

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 (416165, 421030, 423433, 431476, 437547, 439516, 440707, 450990, 452199, 455483, 455534, 472665, 475951, 477239, 480801, 481157, 481665, 485002, 485967, 487156, 494199, 498110, 501938, 502530, 503557, 504779, 507740, 509309, 511897, 512381, 513095, 513485, 513953, 518798, 522525, 524148, 525632, 526216, 527355, 527643, 528931, 532068, 543777, 547864, 553292, 560941, 562598, 563062, 565931, 566057, 566813, 567211, 573304, 576718, 578816, 579843, 594920, 599720, 604467, 606009, 606731, 606759, 606929, 613908, 615560, 616559, 617350, 621779, 622778, 622785, 623834, 624139, 626405, 628956, 634725, 638561, 638576, 663854, 768663, 808603);

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

[
  "cheats"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cheats';

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

[
  "cheats"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cheats';