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

[
  "model sex hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'model sex hot' 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
  800688
  540934
  805452
  724991
  432480
  817478
  782111
  796234
  722540
  767878
  777385
  707819
  517419
  810670
  96445
  727884
  784609
  791752
  779066
  787148
  702522
  813040
  677265
  624067
  640617
  694810
  617330
  780133
  810875
  766419
  413735
  779565
  527661
  683330
  625501
  54085
  788589
  468155
  681371
  794844
  775101
  792817
  467339
  676825
  432785
  529149
  456091
  581770
  477530
  504621
  790469
  511368
  532958
  402012
  429272
  670183
  456837
  450533
  405093
  466824
  487852
  586639
  496740
  521326
  395687
  624221
  495631
  522089
  605418
  476767
  534984
  623235
  661926
]

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 (800688, 540934, 805452, 724991, 432480, 817478, 782111, 796234, 722540, 767878, 777385, 707819, 517419, 810670, 96445, 727884, 784609, 791752, 779066, 787148, 702522, 813040, 677265, 624067, 640617, 694810, 617330, 780133, 810875, 766419, 413735, 779565, 527661, 683330, 625501, 54085, 788589, 468155, 681371, 794844, 775101, 792817, 467339, 676825, 432785, 529149, 456091, 581770, 477530, 504621, 790469, 511368, 532958, 402012, 429272, 670183, 456837, 450533, 405093, 466824, 487852, 586639, 496740, 521326, 395687, 624221, 495631, 522089, 605418, 476767, 534984, 623235, 661926);

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
  54085
  96445
  395687
  402012
  405093
  413735
  429272
  432480
  432785
  450533
  456091
  456837
  466824
  467339
  468155
  476767
  477530
  487852
  495631
  496740
  504621
  511368
  517419
  521326
  522089
  527661
  529149
  532958
  534984
  540934
  581770
  586639
  605418
  617330
  623235
  624067
  624221
  625501
  640617
  661926
  670183
  676825
  677265
  681371
  683330
  694810
  702522
  707819
  722540
  724991
  727884
  766419
  767878
  775101
  777385
  779066
  779565
  780133
  782111
  784609
  787148
  788589
  790469
  791752
  792817
  794844
  796234
  800688
  805452
  810670
  810875
  813040
  817478
]

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 (54085, 96445, 395687, 402012, 405093, 413735, 429272, 432480, 432785, 450533, 456091, 456837, 466824, 467339, 468155, 476767, 477530, 487852, 495631, 496740, 504621, 511368, 517419, 521326, 522089, 527661, 529149, 532958, 534984, 540934, 581770, 586639, 605418, 617330, 623235, 624067, 624221, 625501, 640617, 661926, 670183, 676825, 677265, 681371, 683330, 694810, 702522, 707819, 722540, 724991, 727884, 766419, 767878, 775101, 777385, 779066, 779565, 780133, 782111, 784609, 787148, 788589, 790469, 791752, 792817, 794844, 796234, 800688, 805452, 810670, 810875, 813040, 817478);

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
  54085
  96445
  395687
  402012
  405093
  413735
  429272
  432480
  432785
  450533
  456091
  456837
  466824
  467339
  468155
  476767
  477530
  487852
  495631
  496740
  504621
  511368
  517419
  521326
  522089
  527661
  529149
  532958
  534984
  540934
  581770
  586639
  605418
  617330
  623235
  624067
  624221
  625501
  640617
  661926
  670183
  676825
  677265
  681371
  683330
  694810
  702522
  707819
  722540
  724991
  727884
  766419
  767878
  775101
  777385
  779066
  779565
  780133
  782111
  784609
  787148
  788589
  790469
  791752
  792817
  794844
  796234
  800688
  805452
  810670
  810875
  813040
  817478
]

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 (54085, 96445, 395687, 402012, 405093, 413735, 429272, 432480, 432785, 450533, 456091, 456837, 466824, 467339, 468155, 476767, 477530, 487852, 495631, 496740, 504621, 511368, 517419, 521326, 522089, 527661, 529149, 532958, 534984, 540934, 581770, 586639, 605418, 617330, 623235, 624067, 624221, 625501, 640617, 661926, 670183, 676825, 677265, 681371, 683330, 694810, 702522, 707819, 722540, 724991, 727884, 766419, 767878, 775101, 777385, 779066, 779565, 780133, 782111, 784609, 787148, 788589, 790469, 791752, 792817, 794844, 796234, 800688, 805452, 810670, 810875, 813040, 817478);

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

[
  "model секс hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'model секс hot';

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

[
  "model секс hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'model секс hot';

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 ?

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