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

[
  "with neighbour"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'with neighbour' 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
  676709
  709549
  710263
  636951
  804991
  787408
  807379
  762327
  766923
  721883
  780085
  506809
  585104
  483446
  477891
  485255
  510854
  664097
  707678
  631810
  634727
  628935
  597700
  641679
  779617
  786312
  799542
  779984
  796207
  765352
  787066
  423971
  453707
  460624
  459688
  488512
  495087
  388365
  391001
  418772
  467068
  451312
  460617
  465095
  458787
  683428
  572237
  622406
  586516
  619872
  591095
  784583
  728933
  526253
  513441
  469442
  461129
  572211
  545729
  676176
  677744
  688993
  572241
  621122
  437597
  536861
  503845
  528607
  528661
  512957
  511171
  574667
  713639
  642399
  435157
  434779
  517074
  578729
  747140
  470742
  395757
  577378
]

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 (676709, 709549, 710263, 636951, 804991, 787408, 807379, 762327, 766923, 721883, 780085, 506809, 585104, 483446, 477891, 485255, 510854, 664097, 707678, 631810, 634727, 628935, 597700, 641679, 779617, 786312, 799542, 779984, 796207, 765352, 787066, 423971, 453707, 460624, 459688, 488512, 495087, 388365, 391001, 418772, 467068, 451312, 460617, 465095, 458787, 683428, 572237, 622406, 586516, 619872, 591095, 784583, 728933, 526253, 513441, 469442, 461129, 572211, 545729, 676176, 677744, 688993, 572241, 621122, 437597, 536861, 503845, 528607, 528661, 512957, 511171, 574667, 713639, 642399, 435157, 434779, 517074, 578729, 747140, 470742, 395757, 577378);

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
  388365
  391001
  395757
  418772
  423971
  434779
  435157
  437597
  451312
  453707
  458787
  459688
  460617
  460624
  461129
  465095
  467068
  469442
  470742
  477891
  483446
  485255
  488512
  495087
  503845
  506809
  510854
  511171
  512957
  513441
  517074
  526253
  528607
  528661
  536861
  545729
  572211
  572237
  572241
  574667
  577378
  578729
  585104
  586516
  591095
  597700
  619872
  621122
  622406
  631810
  634727
  636951
  641679
  642399
  664097
  676176
  676709
  677744
  683428
  688993
  707678
  709549
  710263
  713639
  721883
  728933
  747140
  762327
  765352
  766923
  779617
  779984
  780085
  784583
  786312
  787066
  787408
  796207
  799542
  804991
  807379
]

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 (388365, 391001, 395757, 418772, 423971, 434779, 435157, 437597, 451312, 453707, 458787, 459688, 460617, 460624, 461129, 465095, 467068, 469442, 470742, 477891, 483446, 485255, 488512, 495087, 503845, 506809, 510854, 511171, 512957, 513441, 517074, 526253, 528607, 528661, 536861, 545729, 572211, 572237, 572241, 574667, 577378, 578729, 585104, 586516, 591095, 597700, 619872, 621122, 622406, 631810, 634727, 636951, 641679, 642399, 664097, 676176, 676709, 677744, 683428, 688993, 707678, 709549, 710263, 713639, 721883, 728933, 747140, 762327, 765352, 766923, 779617, 779984, 780085, 784583, 786312, 787066, 787408, 796207, 799542, 804991, 807379);

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
  388365
  391001
  395757
  418772
  423971
  434779
  435157
  437597
  451312
  453707
  458787
  459688
  460617
  460624
  461129
  465095
  467068
  469442
  470742
  477891
  483446
  485255
  488512
  495087
  503845
  506809
  510854
  511171
  512957
  513441
  517074
  526253
  528607
  528661
  536861
  545729
  572211
  572237
  572241
  574667
  577378
  578729
  585104
  586516
  591095
  597700
  619872
  621122
  622406
  631810
  634727
  636951
  641679
  642399
  664097
  676176
  676709
  677744
  683428
  688993
  707678
  709549
  710263
  713639
  721883
  728933
  747140
  762327
  765352
  766923
  779617
  779984
  780085
  784583
  786312
  787066
  787408
  796207
  799542
  804991
  807379
]

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 (388365, 391001, 395757, 418772, 423971, 434779, 435157, 437597, 451312, 453707, 458787, 459688, 460617, 460624, 461129, 465095, 467068, 469442, 470742, 477891, 483446, 485255, 488512, 495087, 503845, 506809, 510854, 511171, 512957, 513441, 517074, 526253, 528607, 528661, 536861, 545729, 572211, 572237, 572241, 574667, 577378, 578729, 585104, 586516, 591095, 597700, 619872, 621122, 622406, 631810, 634727, 636951, 641679, 642399, 664097, 676176, 676709, 677744, 683428, 688993, 707678, 709549, 710263, 713639, 721883, 728933, 747140, 762327, 765352, 766923, 779617, 779984, 780085, 784583, 786312, 787066, 787408, 796207, 799542, 804991, 807379);

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

[
  "neighbour"
]

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

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

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

[
  "neighbour"
]

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

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