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

[
  "tattooed teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tattooed teen' 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
  776953
  790538
  754448
  390646
  588811
  653888
  458856
  649571
  515870
  428403
  559961
  721325
  595897
  521425
  773519
  809639
  580688
  588439
  769143
  447519
  823041
  783968
  750727
  815650
  821511
  822619
  773707
  736818
  800539
  800558
  692505
  773388
  747460
  762187
  820890
  820410
  767023
  762241
  770433
  806788
  456929
  574372
  574561
  675049
  662080
  604670
  756012
  769866
  417220
  433284
  422503
  814210
  453208
  575062
  670307
  677342
  600111
  777058
  776054
  522923
  406689
  513656
  696951
  443031
  480209
  447562
  429608
  524317
  595471
  716902
  677783
  676638
  561853
]

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 (776953, 790538, 754448, 390646, 588811, 653888, 458856, 649571, 515870, 428403, 559961, 721325, 595897, 521425, 773519, 809639, 580688, 588439, 769143, 447519, 823041, 783968, 750727, 815650, 821511, 822619, 773707, 736818, 800539, 800558, 692505, 773388, 747460, 762187, 820890, 820410, 767023, 762241, 770433, 806788, 456929, 574372, 574561, 675049, 662080, 604670, 756012, 769866, 417220, 433284, 422503, 814210, 453208, 575062, 670307, 677342, 600111, 777058, 776054, 522923, 406689, 513656, 696951, 443031, 480209, 447562, 429608, 524317, 595471, 716902, 677783, 676638, 561853);

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
  390646
  406689
  417220
  422503
  428403
  429608
  433284
  443031
  447519
  447562
  453208
  456929
  458856
  480209
  513656
  515870
  521425
  522923
  524317
  559961
  561853
  574372
  574561
  575062
  580688
  588439
  588811
  595471
  595897
  600111
  604670
  649571
  653888
  662080
  670307
  675049
  676638
  677342
  677783
  692505
  696951
  716902
  721325
  736818
  747460
  750727
  754448
  756012
  762187
  762241
  767023
  769143
  769866
  770433
  773388
  773519
  773707
  776054
  776953
  777058
  783968
  790538
  800539
  800558
  806788
  809639
  814210
  815650
  820410
  820890
  821511
  822619
  823041
]

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 (390646, 406689, 417220, 422503, 428403, 429608, 433284, 443031, 447519, 447562, 453208, 456929, 458856, 480209, 513656, 515870, 521425, 522923, 524317, 559961, 561853, 574372, 574561, 575062, 580688, 588439, 588811, 595471, 595897, 600111, 604670, 649571, 653888, 662080, 670307, 675049, 676638, 677342, 677783, 692505, 696951, 716902, 721325, 736818, 747460, 750727, 754448, 756012, 762187, 762241, 767023, 769143, 769866, 770433, 773388, 773519, 773707, 776054, 776953, 777058, 783968, 790538, 800539, 800558, 806788, 809639, 814210, 815650, 820410, 820890, 821511, 822619, 823041);

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
  390646
  406689
  417220
  422503
  428403
  429608
  433284
  443031
  447519
  447562
  453208
  456929
  458856
  480209
  513656
  515870
  521425
  522923
  524317
  559961
  561853
  574372
  574561
  575062
  580688
  588439
  588811
  595471
  595897
  600111
  604670
  649571
  653888
  662080
  670307
  675049
  676638
  677342
  677783
  692505
  696951
  716902
  721325
  736818
  747460
  750727
  754448
  756012
  762187
  762241
  767023
  769143
  769866
  770433
  773388
  773519
  773707
  776054
  776953
  777058
  783968
  790538
  800539
  800558
  806788
  809639
  814210
  815650
  820410
  820890
  821511
  822619
  823041
]

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 (390646, 406689, 417220, 422503, 428403, 429608, 433284, 443031, 447519, 447562, 453208, 456929, 458856, 480209, 513656, 515870, 521425, 522923, 524317, 559961, 561853, 574372, 574561, 575062, 580688, 588439, 588811, 595471, 595897, 600111, 604670, 649571, 653888, 662080, 670307, 675049, 676638, 677342, 677783, 692505, 696951, 716902, 721325, 736818, 747460, 750727, 754448, 756012, 762187, 762241, 767023, 769143, 769866, 770433, 773388, 773519, 773707, 776054, 776953, 777058, 783968, 790538, 800539, 800558, 806788, 809639, 814210, 815650, 820410, 820890, 821511, 822619, 823041);

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

[
  "tattooed teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'tattooed teen';

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

[
  "tattooed teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tattooed teen';

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 ?

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