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

[
  "name"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'name' 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
  428267
  817267
  454767
  490830
  506403
  536565
  548507
  566856
  571188
  586948
  619158
  619159
  789612
  798872
  413268
  464676
  477919
  477987
  465647
  447326
  512640
  521144
  490791
  485321
  425497
  485129
  450637
  457501
  475940
  517262
  534047
  539942
  587386
  598466
  613310
  470756
  470883
  456872
  465831
  469780
  489612
  484744
  506408
  522831
  396320
  423270
  443694
  475939
  467575
  478555
  532589
  543189
  551133
  619466
  381946
  425481
  518937
  510068
  484586
  500749
  477404
  525861
  538242
  518568
  581165
  460745
  526956
  466221
  510886
  559187
  573909
  460887
  466133
  477125
  543616
]

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 (428267, 817267, 454767, 490830, 506403, 536565, 548507, 566856, 571188, 586948, 619158, 619159, 789612, 798872, 413268, 464676, 477919, 477987, 465647, 447326, 512640, 521144, 490791, 485321, 425497, 485129, 450637, 457501, 475940, 517262, 534047, 539942, 587386, 598466, 613310, 470756, 470883, 456872, 465831, 469780, 489612, 484744, 506408, 522831, 396320, 423270, 443694, 475939, 467575, 478555, 532589, 543189, 551133, 619466, 381946, 425481, 518937, 510068, 484586, 500749, 477404, 525861, 538242, 518568, 581165, 460745, 526956, 466221, 510886, 559187, 573909, 460887, 466133, 477125, 543616);

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
  381946
  396320
  413268
  423270
  425481
  425497
  428267
  443694
  447326
  450637
  454767
  456872
  457501
  460745
  460887
  464676
  465647
  465831
  466133
  466221
  467575
  469780
  470756
  470883
  475939
  475940
  477125
  477404
  477919
  477987
  478555
  484586
  484744
  485129
  485321
  489612
  490791
  490830
  500749
  506403
  506408
  510068
  510886
  512640
  517262
  518568
  518937
  521144
  522831
  525861
  526956
  532589
  534047
  536565
  538242
  539942
  543189
  543616
  548507
  551133
  559187
  566856
  571188
  573909
  581165
  586948
  587386
  598466
  613310
  619158
  619159
  619466
  789612
  798872
  817267
]

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 (381946, 396320, 413268, 423270, 425481, 425497, 428267, 443694, 447326, 450637, 454767, 456872, 457501, 460745, 460887, 464676, 465647, 465831, 466133, 466221, 467575, 469780, 470756, 470883, 475939, 475940, 477125, 477404, 477919, 477987, 478555, 484586, 484744, 485129, 485321, 489612, 490791, 490830, 500749, 506403, 506408, 510068, 510886, 512640, 517262, 518568, 518937, 521144, 522831, 525861, 526956, 532589, 534047, 536565, 538242, 539942, 543189, 543616, 548507, 551133, 559187, 566856, 571188, 573909, 581165, 586948, 587386, 598466, 613310, 619158, 619159, 619466, 789612, 798872, 817267);

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
  381946
  396320
  413268
  423270
  425481
  425497
  428267
  443694
  447326
  450637
  454767
  456872
  457501
  460745
  460887
  464676
  465647
  465831
  466133
  466221
  467575
  469780
  470756
  470883
  475939
  475940
  477125
  477404
  477919
  477987
  478555
  484586
  484744
  485129
  485321
  489612
  490791
  490830
  500749
  506403
  506408
  510068
  510886
  512640
  517262
  518568
  518937
  521144
  522831
  525861
  526956
  532589
  534047
  536565
  538242
  539942
  543189
  543616
  548507
  551133
  559187
  566856
  571188
  573909
  581165
  586948
  587386
  598466
  613310
  619158
  619159
  619466
  789612
  798872
  817267
]

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 (381946, 396320, 413268, 423270, 425481, 425497, 428267, 443694, 447326, 450637, 454767, 456872, 457501, 460745, 460887, 464676, 465647, 465831, 466133, 466221, 467575, 469780, 470756, 470883, 475939, 475940, 477125, 477404, 477919, 477987, 478555, 484586, 484744, 485129, 485321, 489612, 490791, 490830, 500749, 506403, 506408, 510068, 510886, 512640, 517262, 518568, 518937, 521144, 522831, 525861, 526956, 532589, 534047, 536565, 538242, 539942, 543189, 543616, 548507, 551133, 559187, 566856, 571188, 573909, 581165, 586948, 587386, 598466, 613310, 619158, 619159, 619466, 789612, 798872, 817267);

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

[
  "name"
]

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

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

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

[
  "name"
]

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

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

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 ?

[
  "name"
  "name"
  "name"
  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 ('name') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('name')
              AND `query` <> 'name'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;