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

[
  "old young outdoor"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'old young outdoor' 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
  515198
  773620
  561734
  805847
  780702
  814299
  813599
  770917
  527513
  707347
  613465
  667897
  677934
  559292
  404552
  595765
  619417
  745999
  527557
  481154
  392678
  16808
  691899
  601596
  465180
  509025
  413476
  495035
  624790
  518826
  696218
  714473
  746006
  484162
  467054
  667317
  606595
  743811
  805221
  527578
  471442
  663288
  400760
  482490
  430377
  487929
  456182
  558425
  455852
  450312
  633155
  419947
  594879
  569156
  584709
  606798
  566694
  599227
  619486
  522610
  499774
  577350
  464956
  484165
  464301
  545943
  401933
  506467
  528075
  512339
  416886
]

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 (515198, 773620, 561734, 805847, 780702, 814299, 813599, 770917, 527513, 707347, 613465, 667897, 677934, 559292, 404552, 595765, 619417, 745999, 527557, 481154, 392678, 16808, 691899, 601596, 465180, 509025, 413476, 495035, 624790, 518826, 696218, 714473, 746006, 484162, 467054, 667317, 606595, 743811, 805221, 527578, 471442, 663288, 400760, 482490, 430377, 487929, 456182, 558425, 455852, 450312, 633155, 419947, 594879, 569156, 584709, 606798, 566694, 599227, 619486, 522610, 499774, 577350, 464956, 484165, 464301, 545943, 401933, 506467, 528075, 512339, 416886);

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
  16808
  392678
  400760
  401933
  404552
  413476
  416886
  419947
  430377
  450312
  455852
  456182
  464301
  464956
  465180
  467054
  471442
  481154
  482490
  484162
  484165
  487929
  495035
  499774
  506467
  509025
  512339
  515198
  518826
  522610
  527513
  527578
  528075
  545943
  558425
  559292
  561734
  566694
  569156
  577350
  584709
  594879
  595765
  599227
  601596
  606595
  606798
  613465
  619417
  619486
  624790
  633155
  663288
  667317
  667897
  677934
  691899
  696218
  707347
  714473
  743811
  745999
  746006
  770917
  773620
  780702
  805221
  805847
  813599
  814299
]

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 (16808, 392678, 400760, 401933, 404552, 413476, 416886, 419947, 430377, 450312, 455852, 456182, 464301, 464956, 465180, 467054, 471442, 481154, 482490, 484162, 484165, 487929, 495035, 499774, 506467, 509025, 512339, 515198, 518826, 522610, 527513, 527578, 528075, 545943, 558425, 559292, 561734, 566694, 569156, 577350, 584709, 594879, 595765, 599227, 601596, 606595, 606798, 613465, 619417, 619486, 624790, 633155, 663288, 667317, 667897, 677934, 691899, 696218, 707347, 714473, 743811, 745999, 746006, 770917, 773620, 780702, 805221, 805847, 813599, 814299);

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
  16808
  392678
  400760
  401933
  404552
  413476
  416886
  419947
  430377
  450312
  455852
  456182
  464301
  464956
  465180
  467054
  471442
  481154
  482490
  484162
  484165
  487929
  495035
  499774
  506467
  509025
  512339
  515198
  518826
  522610
  527513
  527578
  528075
  545943
  558425
  559292
  561734
  566694
  569156
  577350
  584709
  594879
  595765
  599227
  601596
  606595
  606798
  613465
  619417
  619486
  624790
  633155
  663288
  667317
  667897
  677934
  691899
  696218
  707347
  714473
  743811
  745999
  746006
  770917
  773620
  780702
  805221
  805847
  813599
  814299
]

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 (16808, 392678, 400760, 401933, 404552, 413476, 416886, 419947, 430377, 450312, 455852, 456182, 464301, 464956, 465180, 467054, 471442, 481154, 482490, 484162, 484165, 487929, 495035, 499774, 506467, 509025, 512339, 515198, 518826, 522610, 527513, 527578, 528075, 545943, 558425, 559292, 561734, 566694, 569156, 577350, 584709, 594879, 595765, 599227, 601596, 606595, 606798, 613465, 619417, 619486, 624790, 633155, 663288, 667317, 667897, 677934, 691899, 696218, 707347, 714473, 743811, 745999, 746006, 770917, 773620, 780702, 805221, 805847, 813599, 814299);

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

[
  "old young outdoor"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'old young outdoor';

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

[
  "old young outdoor"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'old young outdoor';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "old young outdoor"
  "old young outdoor"
  "old young outdoor"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('old young outdoor') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('old young outdoor')
              AND `query` <> 'old young outdoor'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;