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

[
  "мама brianna beach"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'мама brianna beach' 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
  807475
  807470
  807483
  727205
  807477
  476904
  475035
  433965
  450759
  807499
  507884
  807442
  780675
  736634
  773681
  807485
  581723
  600965
  520683
  450767
  482300
  498342
  548844
  557892
  498431
  576267
  382662
  424982
  411038
  827833
  417846
  428452
  430247
  827857
  429584
  428468
  525354
  450821
  464559
  450773
  384298
  466711
  450816
  450761
  429528
  417018
  450764
  465561
  450771
  450801
  481945
  413097
  417990
  827903
  452986
  460182
  433958
  450813
  450811
  482305
  428803
  489325
  446114
  482303
  450760
  499896
  450770
  464335
  449243
  450786
  450766
]

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 (807475, 807470, 807483, 727205, 807477, 476904, 475035, 433965, 450759, 807499, 507884, 807442, 780675, 736634, 773681, 807485, 581723, 600965, 520683, 450767, 482300, 498342, 548844, 557892, 498431, 576267, 382662, 424982, 411038, 827833, 417846, 428452, 430247, 827857, 429584, 428468, 525354, 450821, 464559, 450773, 384298, 466711, 450816, 450761, 429528, 417018, 450764, 465561, 450771, 450801, 481945, 413097, 417990, 827903, 452986, 460182, 433958, 450813, 450811, 482305, 428803, 489325, 446114, 482303, 450760, 499896, 450770, 464335, 449243, 450786, 450766);

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
  382662
  384298
  411038
  413097
  417018
  417846
  417990
  424982
  428452
  428468
  428803
  429528
  429584
  430247
  433958
  433965
  446114
  449243
  450759
  450760
  450761
  450764
  450766
  450767
  450770
  450771
  450773
  450786
  450801
  450811
  450813
  450816
  450821
  452986
  460182
  464335
  464559
  465561
  466711
  475035
  476904
  481945
  482300
  482303
  482305
  489325
  498342
  498431
  499896
  507884
  520683
  525354
  548844
  557892
  576267
  581723
  600965
  727205
  736634
  773681
  780675
  807442
  807470
  807475
  807477
  807483
  807485
  807499
  827833
  827857
  827903
]

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 (382662, 384298, 411038, 413097, 417018, 417846, 417990, 424982, 428452, 428468, 428803, 429528, 429584, 430247, 433958, 433965, 446114, 449243, 450759, 450760, 450761, 450764, 450766, 450767, 450770, 450771, 450773, 450786, 450801, 450811, 450813, 450816, 450821, 452986, 460182, 464335, 464559, 465561, 466711, 475035, 476904, 481945, 482300, 482303, 482305, 489325, 498342, 498431, 499896, 507884, 520683, 525354, 548844, 557892, 576267, 581723, 600965, 727205, 736634, 773681, 780675, 807442, 807470, 807475, 807477, 807483, 807485, 807499, 827833, 827857, 827903);

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
  382662
  384298
  411038
  413097
  417018
  417846
  417990
  424982
  428452
  428468
  428803
  429528
  429584
  430247
  433958
  433965
  446114
  449243
  450759
  450760
  450761
  450764
  450766
  450767
  450770
  450771
  450773
  450786
  450801
  450811
  450813
  450816
  450821
  452986
  460182
  464335
  464559
  465561
  466711
  475035
  476904
  481945
  482300
  482303
  482305
  489325
  498342
  498431
  499896
  507884
  520683
  525354
  548844
  557892
  576267
  581723
  600965
  727205
  736634
  773681
  780675
  807442
  807470
  807475
  807477
  807483
  807485
  807499
  827833
  827857
  827903
]

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 (382662, 384298, 411038, 413097, 417018, 417846, 417990, 424982, 428452, 428468, 428803, 429528, 429584, 430247, 433958, 433965, 446114, 449243, 450759, 450760, 450761, 450764, 450766, 450767, 450770, 450771, 450773, 450786, 450801, 450811, 450813, 450816, 450821, 452986, 460182, 464335, 464559, 465561, 466711, 475035, 476904, 481945, 482300, 482303, 482305, 489325, 498342, 498431, 499896, 507884, 520683, 525354, 548844, 557892, 576267, 581723, 600965, 727205, 736634, 773681, 780675, 807442, 807470, 807475, 807477, 807483, 807485, 807499, 827833, 827857, 827903);

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

[
  "мам женщин briannabeach"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'мам женщин briannabeach';

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

[
  "мам женщин briannabeach"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'мам женщин briannabeach';

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 ?

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