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

[
  "college teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'college 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
  122925
  396372
  404753
  813873
  493143
  538543
  518083
  468379
  562223
  569140
  578376
  654914
  693945
  562005
  594019
  632356
  586520
  730893
  393659
  427819
  395267
  395756
  403249
  473986
  396744
  454837
  521353
  486422
  501048
  520786
  486391
  494075
  497338
  497590
  598745
  396035
  459805
  451267
  516693
  551870
  556051
  557544
  443010
  474013
  396249
  406525
  405709
  428631
  426197
  540910
  661510
  596437
  439301
  475971
  486434
  507646
  468010
  586024
  395648
  439845
  521866
  561092
  591368
  589107
  457793
  609906
  489280
  560197
  617023
  591439
  562258
  507177
  483788
]

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 (122925, 396372, 404753, 813873, 493143, 538543, 518083, 468379, 562223, 569140, 578376, 654914, 693945, 562005, 594019, 632356, 586520, 730893, 393659, 427819, 395267, 395756, 403249, 473986, 396744, 454837, 521353, 486422, 501048, 520786, 486391, 494075, 497338, 497590, 598745, 396035, 459805, 451267, 516693, 551870, 556051, 557544, 443010, 474013, 396249, 406525, 405709, 428631, 426197, 540910, 661510, 596437, 439301, 475971, 486434, 507646, 468010, 586024, 395648, 439845, 521866, 561092, 591368, 589107, 457793, 609906, 489280, 560197, 617023, 591439, 562258, 507177, 483788);

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
  122925
  393659
  395267
  395648
  395756
  396035
  396249
  396372
  396744
  403249
  404753
  405709
  406525
  426197
  427819
  428631
  439301
  439845
  443010
  451267
  454837
  457793
  459805
  468010
  468379
  473986
  474013
  475971
  483788
  486391
  486422
  486434
  489280
  493143
  494075
  497338
  497590
  501048
  507177
  507646
  516693
  518083
  520786
  521353
  521866
  538543
  540910
  551870
  556051
  557544
  560197
  561092
  562005
  562223
  562258
  569140
  578376
  586024
  586520
  589107
  591368
  591439
  594019
  596437
  598745
  609906
  617023
  632356
  654914
  661510
  693945
  730893
  813873
]

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 (122925, 393659, 395267, 395648, 395756, 396035, 396249, 396372, 396744, 403249, 404753, 405709, 406525, 426197, 427819, 428631, 439301, 439845, 443010, 451267, 454837, 457793, 459805, 468010, 468379, 473986, 474013, 475971, 483788, 486391, 486422, 486434, 489280, 493143, 494075, 497338, 497590, 501048, 507177, 507646, 516693, 518083, 520786, 521353, 521866, 538543, 540910, 551870, 556051, 557544, 560197, 561092, 562005, 562223, 562258, 569140, 578376, 586024, 586520, 589107, 591368, 591439, 594019, 596437, 598745, 609906, 617023, 632356, 654914, 661510, 693945, 730893, 813873);

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
  122925
  393659
  395267
  395648
  395756
  396035
  396249
  396372
  396744
  403249
  404753
  405709
  406525
  426197
  427819
  428631
  439301
  439845
  443010
  451267
  454837
  457793
  459805
  468010
  468379
  473986
  474013
  475971
  483788
  486391
  486422
  486434
  489280
  493143
  494075
  497338
  497590
  501048
  507177
  507646
  516693
  518083
  520786
  521353
  521866
  538543
  540910
  551870
  556051
  557544
  560197
  561092
  562005
  562223
  562258
  569140
  578376
  586024
  586520
  589107
  591368
  591439
  594019
  596437
  598745
  609906
  617023
  632356
  654914
  661510
  693945
  730893
  813873
]

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 (122925, 393659, 395267, 395648, 395756, 396035, 396249, 396372, 396744, 403249, 404753, 405709, 406525, 426197, 427819, 428631, 439301, 439845, 443010, 451267, 454837, 457793, 459805, 468010, 468379, 473986, 474013, 475971, 483788, 486391, 486422, 486434, 489280, 493143, 494075, 497338, 497590, 501048, 507177, 507646, 516693, 518083, 520786, 521353, 521866, 538543, 540910, 551870, 556051, 557544, 560197, 561092, 562005, 562223, 562258, 569140, 578376, 586024, 586520, 589107, 591368, 591439, 594019, 596437, 598745, 609906, 617023, 632356, 654914, 661510, 693945, 730893, 813873);

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

[
  "college teen"
]

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

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

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

[
  "college teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'college 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 ?

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