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

[
  "dark hair anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dark hair anal' 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
  748964
  773577
  566791
  786771
  751900
  773609
  711960
  571024
  635225
  565266
  642053
  531115
  631195
  696579
  631965
  571028
  635220
  599966
  812362
  770937
  537204
  633446
  778878
  811946
  545611
  696606
  747100
  800225
  817371
  818607
  812715
  74135
  802845
  511027
  720336
  651749
  670442
  677028
  801396
  810905
  545480
  702627
  574910
  465650
  787448
  464211
  512442
  720033
  808668
  678942
  644271
  596412
  418478
  433202
  451064
  639044
  428827
  496032
  448813
  480370
  647895
  429808
  541872
  467613
  601040
  593863
  565154
  508795
  447810
  653189
  495217
]

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 (748964, 773577, 566791, 786771, 751900, 773609, 711960, 571024, 635225, 565266, 642053, 531115, 631195, 696579, 631965, 571028, 635220, 599966, 812362, 770937, 537204, 633446, 778878, 811946, 545611, 696606, 747100, 800225, 817371, 818607, 812715, 74135, 802845, 511027, 720336, 651749, 670442, 677028, 801396, 810905, 545480, 702627, 574910, 465650, 787448, 464211, 512442, 720033, 808668, 678942, 644271, 596412, 418478, 433202, 451064, 639044, 428827, 496032, 448813, 480370, 647895, 429808, 541872, 467613, 601040, 593863, 565154, 508795, 447810, 653189, 495217);

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
  74135
  418478
  428827
  429808
  433202
  447810
  448813
  451064
  464211
  465650
  467613
  480370
  495217
  496032
  508795
  511027
  512442
  531115
  537204
  541872
  545480
  545611
  565154
  565266
  566791
  571024
  571028
  574910
  593863
  596412
  599966
  601040
  631195
  631965
  633446
  635220
  635225
  639044
  642053
  644271
  647895
  651749
  653189
  670442
  677028
  678942
  696579
  696606
  702627
  711960
  720033
  720336
  747100
  748964
  751900
  770937
  773577
  773609
  778878
  786771
  787448
  800225
  801396
  802845
  808668
  810905
  811946
  812362
  812715
  817371
  818607
]

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 (74135, 418478, 428827, 429808, 433202, 447810, 448813, 451064, 464211, 465650, 467613, 480370, 495217, 496032, 508795, 511027, 512442, 531115, 537204, 541872, 545480, 545611, 565154, 565266, 566791, 571024, 571028, 574910, 593863, 596412, 599966, 601040, 631195, 631965, 633446, 635220, 635225, 639044, 642053, 644271, 647895, 651749, 653189, 670442, 677028, 678942, 696579, 696606, 702627, 711960, 720033, 720336, 747100, 748964, 751900, 770937, 773577, 773609, 778878, 786771, 787448, 800225, 801396, 802845, 808668, 810905, 811946, 812362, 812715, 817371, 818607);

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
  74135
  418478
  428827
  429808
  433202
  447810
  448813
  451064
  464211
  465650
  467613
  480370
  495217
  496032
  508795
  511027
  512442
  531115
  537204
  541872
  545480
  545611
  565154
  565266
  566791
  571024
  571028
  574910
  593863
  596412
  599966
  601040
  631195
  631965
  633446
  635220
  635225
  639044
  642053
  644271
  647895
  651749
  653189
  670442
  677028
  678942
  696579
  696606
  702627
  711960
  720033
  720336
  747100
  748964
  751900
  770937
  773577
  773609
  778878
  786771
  787448
  800225
  801396
  802845
  808668
  810905
  811946
  812362
  812715
  817371
  818607
]

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 (74135, 418478, 428827, 429808, 433202, 447810, 448813, 451064, 464211, 465650, 467613, 480370, 495217, 496032, 508795, 511027, 512442, 531115, 537204, 541872, 545480, 545611, 565154, 565266, 566791, 571024, 571028, 574910, 593863, 596412, 599966, 601040, 631195, 631965, 633446, 635220, 635225, 639044, 642053, 644271, 647895, 651749, 653189, 670442, 677028, 678942, 696579, 696606, 702627, 711960, 720033, 720336, 747100, 748964, 751900, 770937, 773577, 773609, 778878, 786771, 787448, 800225, 801396, 802845, 808668, 810905, 811946, 812362, 812715, 817371, 818607);

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

[
  "dark hair анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'dark hair анал';

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

[
  "dark hair анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dark hair анал';

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 ?

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