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

[
  "my wife crying"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'my wife crying' 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
  814457
  720284
  693369
  780361
  795687
  800404
  796153
  459686
  803722
  496616
  492495
  735195
  581064
  777742
  796165
  523226
  455897
  574643
  740871
  500955
  482769
  509123
  503271
  542886
  695900
  611348
  623968
  796168
  761048
  720132
  435177
  489271
  445340
  602371
  417841
  432690
  447007
  463810
  465267
  547865
  563082
  554552
  556445
  576516
  589278
  471300
  464811
  513552
  426101
  560844
  482768
  601423
  604046
  542127
  550337
  580418
  610661
  446307
  524506
  510553
  547556
  624375
  430374
  462610
  452228
  505614
  428756
  621352
  507733
  637243
  619965
  601976
  511837
]

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 (814457, 720284, 693369, 780361, 795687, 800404, 796153, 459686, 803722, 496616, 492495, 735195, 581064, 777742, 796165, 523226, 455897, 574643, 740871, 500955, 482769, 509123, 503271, 542886, 695900, 611348, 623968, 796168, 761048, 720132, 435177, 489271, 445340, 602371, 417841, 432690, 447007, 463810, 465267, 547865, 563082, 554552, 556445, 576516, 589278, 471300, 464811, 513552, 426101, 560844, 482768, 601423, 604046, 542127, 550337, 580418, 610661, 446307, 524506, 510553, 547556, 624375, 430374, 462610, 452228, 505614, 428756, 621352, 507733, 637243, 619965, 601976, 511837);

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
  417841
  426101
  428756
  430374
  432690
  435177
  445340
  446307
  447007
  452228
  455897
  459686
  462610
  463810
  464811
  465267
  471300
  482768
  482769
  489271
  492495
  496616
  500955
  503271
  505614
  507733
  509123
  510553
  511837
  513552
  523226
  524506
  542127
  542886
  547556
  547865
  550337
  554552
  556445
  560844
  563082
  574643
  576516
  580418
  581064
  589278
  601423
  601976
  602371
  604046
  610661
  611348
  619965
  621352
  623968
  624375
  637243
  693369
  695900
  720132
  720284
  735195
  740871
  761048
  777742
  780361
  795687
  796153
  796165
  796168
  800404
  803722
  814457
]

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 (417841, 426101, 428756, 430374, 432690, 435177, 445340, 446307, 447007, 452228, 455897, 459686, 462610, 463810, 464811, 465267, 471300, 482768, 482769, 489271, 492495, 496616, 500955, 503271, 505614, 507733, 509123, 510553, 511837, 513552, 523226, 524506, 542127, 542886, 547556, 547865, 550337, 554552, 556445, 560844, 563082, 574643, 576516, 580418, 581064, 589278, 601423, 601976, 602371, 604046, 610661, 611348, 619965, 621352, 623968, 624375, 637243, 693369, 695900, 720132, 720284, 735195, 740871, 761048, 777742, 780361, 795687, 796153, 796165, 796168, 800404, 803722, 814457);

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
  417841
  426101
  428756
  430374
  432690
  435177
  445340
  446307
  447007
  452228
  455897
  459686
  462610
  463810
  464811
  465267
  471300
  482768
  482769
  489271
  492495
  496616
  500955
  503271
  505614
  507733
  509123
  510553
  511837
  513552
  523226
  524506
  542127
  542886
  547556
  547865
  550337
  554552
  556445
  560844
  563082
  574643
  576516
  580418
  581064
  589278
  601423
  601976
  602371
  604046
  610661
  611348
  619965
  621352
  623968
  624375
  637243
  693369
  695900
  720132
  720284
  735195
  740871
  761048
  777742
  780361
  795687
  796153
  796165
  796168
  800404
  803722
  814457
]

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 (417841, 426101, 428756, 430374, 432690, 435177, 445340, 446307, 447007, 452228, 455897, 459686, 462610, 463810, 464811, 465267, 471300, 482768, 482769, 489271, 492495, 496616, 500955, 503271, 505614, 507733, 509123, 510553, 511837, 513552, 523226, 524506, 542127, 542886, 547556, 547865, 550337, 554552, 556445, 560844, 563082, 574643, 576516, 580418, 581064, 589278, 601423, 601976, 602371, 604046, 610661, 611348, 619965, 621352, 623968, 624375, 637243, 693369, 695900, 720132, 720284, 735195, 740871, 761048, 777742, 780361, 795687, 796153, 796165, 796168, 800404, 803722, 814457);

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

[
  "my жен крича вперв"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'my жен крича вперв';

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

[
  "my жен крича вперв"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'my жен крича вперв';

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 ?

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