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

[
  "chinese boy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'chinese boy' 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
  383096
  477409
  459524
  424729
  416294
  431664
  499878
  424713
  391976
  431603
  423134
  449580
  423132
  418717
  427268
  393129
  428358
  20907
  469800
  469803
  425366
  462288
  428849
  468719
  410259
  480511
  389231
  443523
  460051
  477407
  422747
  456400
  420027
  422769
  552899
  457759
  529436
  491512
  499036
  412122
  485578
  422543
  595252
  452442
  418844
  523916
  528066
  586635
  458617
  556365
  397128
  394376
  461899
  424726
  458623
  423280
  429386
  813787
  418323
  557209
  558578
  482824
  531083
  589769
  590859
  554425
  510266
  614603
  437828
  581185
  425435
  447273
  562149
]

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 (383096, 477409, 459524, 424729, 416294, 431664, 499878, 424713, 391976, 431603, 423134, 449580, 423132, 418717, 427268, 393129, 428358, 20907, 469800, 469803, 425366, 462288, 428849, 468719, 410259, 480511, 389231, 443523, 460051, 477407, 422747, 456400, 420027, 422769, 552899, 457759, 529436, 491512, 499036, 412122, 485578, 422543, 595252, 452442, 418844, 523916, 528066, 586635, 458617, 556365, 397128, 394376, 461899, 424726, 458623, 423280, 429386, 813787, 418323, 557209, 558578, 482824, 531083, 589769, 590859, 554425, 510266, 614603, 437828, 581185, 425435, 447273, 562149);

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
  20907
  383096
  389231
  391976
  393129
  394376
  397128
  410259
  412122
  416294
  418323
  418717
  418844
  420027
  422543
  422747
  422769
  423132
  423134
  423280
  424713
  424726
  424729
  425366
  425435
  427268
  428358
  428849
  429386
  431603
  431664
  437828
  443523
  447273
  449580
  452442
  456400
  457759
  458617
  458623
  459524
  460051
  461899
  462288
  468719
  469800
  469803
  477407
  477409
  480511
  482824
  485578
  491512
  499036
  499878
  510266
  523916
  528066
  529436
  531083
  552899
  554425
  556365
  557209
  558578
  562149
  581185
  586635
  589769
  590859
  595252
  614603
  813787
]

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 (20907, 383096, 389231, 391976, 393129, 394376, 397128, 410259, 412122, 416294, 418323, 418717, 418844, 420027, 422543, 422747, 422769, 423132, 423134, 423280, 424713, 424726, 424729, 425366, 425435, 427268, 428358, 428849, 429386, 431603, 431664, 437828, 443523, 447273, 449580, 452442, 456400, 457759, 458617, 458623, 459524, 460051, 461899, 462288, 468719, 469800, 469803, 477407, 477409, 480511, 482824, 485578, 491512, 499036, 499878, 510266, 523916, 528066, 529436, 531083, 552899, 554425, 556365, 557209, 558578, 562149, 581185, 586635, 589769, 590859, 595252, 614603, 813787);

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
  20907
  383096
  389231
  391976
  393129
  394376
  397128
  410259
  412122
  416294
  418323
  418717
  418844
  420027
  422543
  422747
  422769
  423132
  423134
  423280
  424713
  424726
  424729
  425366
  425435
  427268
  428358
  428849
  429386
  431603
  431664
  437828
  443523
  447273
  449580
  452442
  456400
  457759
  458617
  458623
  459524
  460051
  461899
  462288
  468719
  469800
  469803
  477407
  477409
  480511
  482824
  485578
  491512
  499036
  499878
  510266
  523916
  528066
  529436
  531083
  552899
  554425
  556365
  557209
  558578
  562149
  581185
  586635
  589769
  590859
  595252
  614603
  813787
]

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 (20907, 383096, 389231, 391976, 393129, 394376, 397128, 410259, 412122, 416294, 418323, 418717, 418844, 420027, 422543, 422747, 422769, 423132, 423134, 423280, 424713, 424726, 424729, 425366, 425435, 427268, 428358, 428849, 429386, 431603, 431664, 437828, 443523, 447273, 449580, 452442, 456400, 457759, 458617, 458623, 459524, 460051, 461899, 462288, 468719, 469800, 469803, 477407, 477409, 480511, 482824, 485578, 491512, 499036, 499878, 510266, 523916, 528066, 529436, 531083, 552899, 554425, 556365, 557209, 558578, 562149, 581185, 586635, 589769, 590859, 595252, 614603, 813787);

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

[
  "китаянк азиатк парен"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'китаянк азиатк парен';

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

[
  "китаянк азиатк парен"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'китаянк азиатк парен';

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 ?

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