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

[
  "teacher or student"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teacher or student' 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
  525879
  485950
  489396
  500594
  526222
  563871
  569793
  561354
  564696
  645920
  654914
  552976
  623623
  627660
  756506
  627095
  415342
  437579
  439721
  458311
  462995
  466755
  469014
  515592
  503770
  511303
  515736
  524597
  486892
  442678
  467504
  459805
  467551
  570899
  555141
  590545
  609133
  455515
  465823
  467414
  470988
  467503
  442867
  467405
  503579
  516748
  491321
  503914
  442835
  460588
  503584
  511528
  582024
  432531
  455923
  473180
  444165
  462999
  519940
  528217
  486581
  492322
  535022
  602747
  478978
  470442
  486963
  465524
  530513
  478981
  512222
  610613
  623365
  624109
]

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 (525879, 485950, 489396, 500594, 526222, 563871, 569793, 561354, 564696, 645920, 654914, 552976, 623623, 627660, 756506, 627095, 415342, 437579, 439721, 458311, 462995, 466755, 469014, 515592, 503770, 511303, 515736, 524597, 486892, 442678, 467504, 459805, 467551, 570899, 555141, 590545, 609133, 455515, 465823, 467414, 470988, 467503, 442867, 467405, 503579, 516748, 491321, 503914, 442835, 460588, 503584, 511528, 582024, 432531, 455923, 473180, 444165, 462999, 519940, 528217, 486581, 492322, 535022, 602747, 478978, 470442, 486963, 465524, 530513, 478981, 512222, 610613, 623365, 624109);

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
  415342
  432531
  437579
  439721
  442678
  442835
  442867
  444165
  455515
  455923
  458311
  459805
  460588
  462995
  462999
  465524
  465823
  466755
  467405
  467414
  467503
  467504
  467551
  469014
  470442
  470988
  473180
  478978
  478981
  485950
  486581
  486892
  486963
  489396
  491321
  492322
  500594
  503579
  503584
  503770
  503914
  511303
  511528
  512222
  515592
  515736
  516748
  519940
  524597
  525879
  526222
  528217
  530513
  535022
  552976
  555141
  561354
  563871
  564696
  569793
  570899
  582024
  590545
  602747
  609133
  610613
  623365
  623623
  624109
  627095
  627660
  645920
  654914
  756506
]

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 (415342, 432531, 437579, 439721, 442678, 442835, 442867, 444165, 455515, 455923, 458311, 459805, 460588, 462995, 462999, 465524, 465823, 466755, 467405, 467414, 467503, 467504, 467551, 469014, 470442, 470988, 473180, 478978, 478981, 485950, 486581, 486892, 486963, 489396, 491321, 492322, 500594, 503579, 503584, 503770, 503914, 511303, 511528, 512222, 515592, 515736, 516748, 519940, 524597, 525879, 526222, 528217, 530513, 535022, 552976, 555141, 561354, 563871, 564696, 569793, 570899, 582024, 590545, 602747, 609133, 610613, 623365, 623623, 624109, 627095, 627660, 645920, 654914, 756506);

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
  415342
  432531
  437579
  439721
  442678
  442835
  442867
  444165
  455515
  455923
  458311
  459805
  460588
  462995
  462999
  465524
  465823
  466755
  467405
  467414
  467503
  467504
  467551
  469014
  470442
  470988
  473180
  478978
  478981
  485950
  486581
  486892
  486963
  489396
  491321
  492322
  500594
  503579
  503584
  503770
  503914
  511303
  511528
  512222
  515592
  515736
  516748
  519940
  524597
  525879
  526222
  528217
  530513
  535022
  552976
  555141
  561354
  563871
  564696
  569793
  570899
  582024
  590545
  602747
  609133
  610613
  623365
  623623
  624109
  627095
  627660
  645920
  654914
  756506
]

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 (415342, 432531, 437579, 439721, 442678, 442835, 442867, 444165, 455515, 455923, 458311, 459805, 460588, 462995, 462999, 465524, 465823, 466755, 467405, 467414, 467503, 467504, 467551, 469014, 470442, 470988, 473180, 478978, 478981, 485950, 486581, 486892, 486963, 489396, 491321, 492322, 500594, 503579, 503584, 503770, 503914, 511303, 511528, 512222, 515592, 515736, 516748, 519940, 524597, 525879, 526222, 528217, 530513, 535022, 552976, 555141, 561354, 563871, 564696, 569793, 570899, 582024, 590545, 602747, 609133, 610613, 623365, 623623, 624109, 627095, 627660, 645920, 654914, 756506);

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

[
  "teacher student"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teacher student';

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

[
  "teacher student"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teacher student';