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

[
  "natural boobs milky"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'natural boobs milky' 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
  824285
  824874
  714409
  794021
  824735
  797144
  824732
  824967
  824530
  824533
  824633
  824733
  629239
  793913
  751507
  409577
  819346
  824531
  824837
  812723
  725243
  752732
  173905
  824528
  461663
  535106
  674125
  742056
  742288
  737877
  751517
  556550
  508212
  807313
  725203
  752719
  742640
  758483
  769438
  629821
  796797
  624405
  20948
  528683
  666044
  666080
  696124
  728605
  769394
  742757
  751513
  757232
  407782
  479032
  721080
  605653
  796829
  735871
  726875
  731378
  528714
  629213
  796804
  726864
  632083
  290304
  605661
  606665
  601040
  605492
]

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 (824285, 824874, 714409, 794021, 824735, 797144, 824732, 824967, 824530, 824533, 824633, 824733, 629239, 793913, 751507, 409577, 819346, 824531, 824837, 812723, 725243, 752732, 173905, 824528, 461663, 535106, 674125, 742056, 742288, 737877, 751517, 556550, 508212, 807313, 725203, 752719, 742640, 758483, 769438, 629821, 796797, 624405, 20948, 528683, 666044, 666080, 696124, 728605, 769394, 742757, 751513, 757232, 407782, 479032, 721080, 605653, 796829, 735871, 726875, 731378, 528714, 629213, 796804, 726864, 632083, 290304, 605661, 606665, 601040, 605492);

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
  20948
  173905
  290304
  407782
  409577
  461663
  479032
  508212
  528683
  528714
  535106
  556550
  601040
  605492
  605653
  605661
  606665
  624405
  629213
  629239
  629821
  632083
  666044
  666080
  674125
  696124
  714409
  721080
  725203
  725243
  726864
  726875
  728605
  731378
  735871
  737877
  742056
  742288
  742640
  742757
  751507
  751513
  751517
  752719
  752732
  757232
  758483
  769394
  769438
  793913
  794021
  796797
  796804
  796829
  797144
  807313
  812723
  819346
  824285
  824528
  824530
  824531
  824533
  824633
  824732
  824733
  824735
  824837
  824874
  824967
]

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 (20948, 173905, 290304, 407782, 409577, 461663, 479032, 508212, 528683, 528714, 535106, 556550, 601040, 605492, 605653, 605661, 606665, 624405, 629213, 629239, 629821, 632083, 666044, 666080, 674125, 696124, 714409, 721080, 725203, 725243, 726864, 726875, 728605, 731378, 735871, 737877, 742056, 742288, 742640, 742757, 751507, 751513, 751517, 752719, 752732, 757232, 758483, 769394, 769438, 793913, 794021, 796797, 796804, 796829, 797144, 807313, 812723, 819346, 824285, 824528, 824530, 824531, 824533, 824633, 824732, 824733, 824735, 824837, 824874, 824967);

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
  20948
  173905
  290304
  407782
  409577
  461663
  479032
  508212
  528683
  528714
  535106
  556550
  601040
  605492
  605653
  605661
  606665
  624405
  629213
  629239
  629821
  632083
  666044
  666080
  674125
  696124
  714409
  721080
  725203
  725243
  726864
  726875
  728605
  731378
  735871
  737877
  742056
  742288
  742640
  742757
  751507
  751513
  751517
  752719
  752732
  757232
  758483
  769394
  769438
  793913
  794021
  796797
  796804
  796829
  797144
  807313
  812723
  819346
  824285
  824528
  824530
  824531
  824533
  824633
  824732
  824733
  824735
  824837
  824874
  824967
]

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 (20948, 173905, 290304, 407782, 409577, 461663, 479032, 508212, 528683, 528714, 535106, 556550, 601040, 605492, 605653, 605661, 606665, 624405, 629213, 629239, 629821, 632083, 666044, 666080, 674125, 696124, 714409, 721080, 725203, 725243, 726864, 726875, 728605, 731378, 735871, 737877, 742056, 742288, 742640, 742757, 751507, 751513, 751517, 752719, 752732, 757232, 758483, 769394, 769438, 793913, 794021, 796797, 796804, 796829, 797144, 807313, 812723, 819346, 824285, 824528, 824530, 824531, 824533, 824633, 824732, 824733, 824735, 824837, 824874, 824967);

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

[
  "натуральная натуральные boobs milky"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'натуральная натуральные boobs milky';

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

[
  "натуральная натуральные boobs milky"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'натуральная натуральные boobs milky';

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 ?

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