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

[
  "russian nylon"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian nylon' 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
  817133
  791717
  794729
  820195
  382183
  386583
  828566
  433822
  725469
  767670
  758317
  453397
  813963
  657831
  663182
  758531
  764175
  563207
  432545
  800569
  730741
  390257
  526880
  424007
  432516
  466042
  518797
  515710
  539318
  824303
  599323
  725484
  760637
  804883
  811100
  433415
  513202
  433620
  402904
  448013
  480641
  512714
  788867
  761823
  428823
  706801
  623821
  402931
  423790
  432546
  508070
  433049
  590057
  433064
  493106
  523310
  542987
  569572
  779506
  432533
  432515
  432419
  434093
  468304
  485349
  574768
  530444
  546970
  423830
  465902
  509247
  490874
  622719
]

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 (817133, 791717, 794729, 820195, 382183, 386583, 828566, 433822, 725469, 767670, 758317, 453397, 813963, 657831, 663182, 758531, 764175, 563207, 432545, 800569, 730741, 390257, 526880, 424007, 432516, 466042, 518797, 515710, 539318, 824303, 599323, 725484, 760637, 804883, 811100, 433415, 513202, 433620, 402904, 448013, 480641, 512714, 788867, 761823, 428823, 706801, 623821, 402931, 423790, 432546, 508070, 433049, 590057, 433064, 493106, 523310, 542987, 569572, 779506, 432533, 432515, 432419, 434093, 468304, 485349, 574768, 530444, 546970, 423830, 465902, 509247, 490874, 622719);

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
  382183
  386583
  390257
  402904
  402931
  423790
  423830
  424007
  428823
  432419
  432515
  432516
  432533
  432545
  432546
  433049
  433064
  433415
  433620
  433822
  434093
  448013
  453397
  465902
  466042
  468304
  480641
  485349
  490874
  493106
  508070
  509247
  512714
  513202
  515710
  518797
  523310
  526880
  530444
  539318
  542987
  546970
  563207
  569572
  574768
  590057
  599323
  622719
  623821
  657831
  663182
  706801
  725469
  725484
  730741
  758317
  758531
  760637
  761823
  764175
  767670
  779506
  788867
  791717
  794729
  800569
  804883
  811100
  813963
  817133
  820195
  824303
  828566
]

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 (382183, 386583, 390257, 402904, 402931, 423790, 423830, 424007, 428823, 432419, 432515, 432516, 432533, 432545, 432546, 433049, 433064, 433415, 433620, 433822, 434093, 448013, 453397, 465902, 466042, 468304, 480641, 485349, 490874, 493106, 508070, 509247, 512714, 513202, 515710, 518797, 523310, 526880, 530444, 539318, 542987, 546970, 563207, 569572, 574768, 590057, 599323, 622719, 623821, 657831, 663182, 706801, 725469, 725484, 730741, 758317, 758531, 760637, 761823, 764175, 767670, 779506, 788867, 791717, 794729, 800569, 804883, 811100, 813963, 817133, 820195, 824303, 828566);

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
  382183
  386583
  390257
  402904
  402931
  423790
  423830
  424007
  428823
  432419
  432515
  432516
  432533
  432545
  432546
  433049
  433064
  433415
  433620
  433822
  434093
  448013
  453397
  465902
  466042
  468304
  480641
  485349
  490874
  493106
  508070
  509247
  512714
  513202
  515710
  518797
  523310
  526880
  530444
  539318
  542987
  546970
  563207
  569572
  574768
  590057
  599323
  622719
  623821
  657831
  663182
  706801
  725469
  725484
  730741
  758317
  758531
  760637
  761823
  764175
  767670
  779506
  788867
  791717
  794729
  800569
  804883
  811100
  813963
  817133
  820195
  824303
  828566
]

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 (382183, 386583, 390257, 402904, 402931, 423790, 423830, 424007, 428823, 432419, 432515, 432516, 432533, 432545, 432546, 433049, 433064, 433415, 433620, 433822, 434093, 448013, 453397, 465902, 466042, 468304, 480641, 485349, 490874, 493106, 508070, 509247, 512714, 513202, 515710, 518797, 523310, 526880, 530444, 539318, 542987, 546970, 563207, 569572, 574768, 590057, 599323, 622719, 623821, 657831, 663182, 706801, 725469, 725484, 730741, 758317, 758531, 760637, 761823, 764175, 767670, 779506, 788867, 791717, 794729, 800569, 804883, 811100, 813963, 817133, 820195, 824303, 828566);

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

[
  "русск nylon"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск nylon';

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

[
  "русск nylon"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск nylon';

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 ?

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