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

[
  "beautiful pornstar"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beautiful pornstar' 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
  454605
  531181
  534990
  551676
  580243
  672372
  587850
  622249
  799714
  774287
  787427
  411841
  519256
  528606
  488816
  527995
  500391
  446141
  515686
  522827
  501551
  519093
  384381
  324288
  390098
  399652
  415708
  486403
  483513
  570148
  677287
  556812
  775831
  762221
  800556
  759329
  762234
  409106
  420357
  429305
  497715
  501866
  586631
  427232
  448333
  454610
  566144
  592318
  790397
  791489
  447499
  470339
  472489
  524664
  488772
  488813
  500854
  520015
  677279
  616097
  704222
  423349
  814934
  476767
  530791
  515681
  601356
  478049
  468835
  624215
  528435
  556987
]

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 (454605, 531181, 534990, 551676, 580243, 672372, 587850, 622249, 799714, 774287, 787427, 411841, 519256, 528606, 488816, 527995, 500391, 446141, 515686, 522827, 501551, 519093, 384381, 324288, 390098, 399652, 415708, 486403, 483513, 570148, 677287, 556812, 775831, 762221, 800556, 759329, 762234, 409106, 420357, 429305, 497715, 501866, 586631, 427232, 448333, 454610, 566144, 592318, 790397, 791489, 447499, 470339, 472489, 524664, 488772, 488813, 500854, 520015, 677279, 616097, 704222, 423349, 814934, 476767, 530791, 515681, 601356, 478049, 468835, 624215, 528435, 556987);

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
  324288
  384381
  390098
  399652
  409106
  411841
  415708
  420357
  423349
  427232
  429305
  446141
  447499
  448333
  454605
  454610
  468835
  470339
  472489
  476767
  478049
  483513
  486403
  488772
  488813
  488816
  497715
  500391
  500854
  501551
  501866
  515681
  515686
  519093
  519256
  520015
  522827
  524664
  527995
  528435
  528606
  530791
  531181
  534990
  551676
  556812
  556987
  566144
  570148
  580243
  586631
  587850
  592318
  601356
  616097
  622249
  624215
  672372
  677279
  677287
  704222
  759329
  762221
  762234
  774287
  775831
  787427
  790397
  791489
  799714
  800556
  814934
]

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 (324288, 384381, 390098, 399652, 409106, 411841, 415708, 420357, 423349, 427232, 429305, 446141, 447499, 448333, 454605, 454610, 468835, 470339, 472489, 476767, 478049, 483513, 486403, 488772, 488813, 488816, 497715, 500391, 500854, 501551, 501866, 515681, 515686, 519093, 519256, 520015, 522827, 524664, 527995, 528435, 528606, 530791, 531181, 534990, 551676, 556812, 556987, 566144, 570148, 580243, 586631, 587850, 592318, 601356, 616097, 622249, 624215, 672372, 677279, 677287, 704222, 759329, 762221, 762234, 774287, 775831, 787427, 790397, 791489, 799714, 800556, 814934);

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
  324288
  384381
  390098
  399652
  409106
  411841
  415708
  420357
  423349
  427232
  429305
  446141
  447499
  448333
  454605
  454610
  468835
  470339
  472489
  476767
  478049
  483513
  486403
  488772
  488813
  488816
  497715
  500391
  500854
  501551
  501866
  515681
  515686
  519093
  519256
  520015
  522827
  524664
  527995
  528435
  528606
  530791
  531181
  534990
  551676
  556812
  556987
  566144
  570148
  580243
  586631
  587850
  592318
  601356
  616097
  622249
  624215
  672372
  677279
  677287
  704222
  759329
  762221
  762234
  774287
  775831
  787427
  790397
  791489
  799714
  800556
  814934
]

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 (324288, 384381, 390098, 399652, 409106, 411841, 415708, 420357, 423349, 427232, 429305, 446141, 447499, 448333, 454605, 454610, 468835, 470339, 472489, 476767, 478049, 483513, 486403, 488772, 488813, 488816, 497715, 500391, 500854, 501551, 501866, 515681, 515686, 519093, 519256, 520015, 522827, 524664, 527995, 528435, 528606, 530791, 531181, 534990, 551676, 556812, 556987, 566144, 570148, 580243, 586631, 587850, 592318, 601356, 616097, 622249, 624215, 672372, 677279, 677287, 704222, 759329, 762221, 762234, 774287, 775831, 787427, 790397, 791489, 799714, 800556, 814934);

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

[
  "красивая pornstar"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'красивая pornstar';

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

[
  "красивая pornstar"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'красивая pornstar';

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 ?

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