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

[
  "interracial retro film"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'interracial retro film' 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
  668153
  687132
  547875
  668150
  668156
  628325
  681363
  696268
  571837
  690823
  699689
  608040
  670110
  544291
  572603
  562844
  550322
  549302
  560083
  687130
  669566
  577353
  562846
  716323
  489462
  542198
  583851
  651630
  669567
  592445
  541753
  716405
  541594
  541895
  541602
  592456
  511393
  556525
  541661
  541634
  543471
  541808
  541683
  541644
  576721
  541651
  551916
  541606
  541643
  541671
  581370
  542500
  541614
  541667
  541769
  581281
  549371
  542191
  542195
  541588
  541924
  541833
  542961
  576723
  576698
  644005
  621305
  592437
  544472
  576720
]

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 (668153, 687132, 547875, 668150, 668156, 628325, 681363, 696268, 571837, 690823, 699689, 608040, 670110, 544291, 572603, 562844, 550322, 549302, 560083, 687130, 669566, 577353, 562846, 716323, 489462, 542198, 583851, 651630, 669567, 592445, 541753, 716405, 541594, 541895, 541602, 592456, 511393, 556525, 541661, 541634, 543471, 541808, 541683, 541644, 576721, 541651, 551916, 541606, 541643, 541671, 581370, 542500, 541614, 541667, 541769, 581281, 549371, 542191, 542195, 541588, 541924, 541833, 542961, 576723, 576698, 644005, 621305, 592437, 544472, 576720);

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
  489462
  511393
  541588
  541594
  541602
  541606
  541614
  541634
  541643
  541644
  541651
  541661
  541667
  541671
  541683
  541753
  541769
  541808
  541833
  541895
  541924
  542191
  542195
  542198
  542500
  542961
  543471
  544291
  544472
  547875
  549302
  549371
  550322
  551916
  556525
  560083
  562844
  562846
  571837
  572603
  576698
  576720
  576721
  576723
  577353
  581281
  581370
  583851
  592437
  592445
  592456
  608040
  621305
  628325
  644005
  651630
  668150
  668153
  668156
  669566
  669567
  670110
  681363
  687130
  687132
  690823
  696268
  699689
  716323
  716405
]

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 (489462, 511393, 541588, 541594, 541602, 541606, 541614, 541634, 541643, 541644, 541651, 541661, 541667, 541671, 541683, 541753, 541769, 541808, 541833, 541895, 541924, 542191, 542195, 542198, 542500, 542961, 543471, 544291, 544472, 547875, 549302, 549371, 550322, 551916, 556525, 560083, 562844, 562846, 571837, 572603, 576698, 576720, 576721, 576723, 577353, 581281, 581370, 583851, 592437, 592445, 592456, 608040, 621305, 628325, 644005, 651630, 668150, 668153, 668156, 669566, 669567, 670110, 681363, 687130, 687132, 690823, 696268, 699689, 716323, 716405);

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
  489462
  511393
  541588
  541594
  541602
  541606
  541614
  541634
  541643
  541644
  541651
  541661
  541667
  541671
  541683
  541753
  541769
  541808
  541833
  541895
  541924
  542191
  542195
  542198
  542500
  542961
  543471
  544291
  544472
  547875
  549302
  549371
  550322
  551916
  556525
  560083
  562844
  562846
  571837
  572603
  576698
  576720
  576721
  576723
  577353
  581281
  581370
  583851
  592437
  592445
  592456
  608040
  621305
  628325
  644005
  651630
  668150
  668153
  668156
  669566
  669567
  670110
  681363
  687130
  687132
  690823
  696268
  699689
  716323
  716405
]

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 (489462, 511393, 541588, 541594, 541602, 541606, 541614, 541634, 541643, 541644, 541651, 541661, 541667, 541671, 541683, 541753, 541769, 541808, 541833, 541895, 541924, 542191, 542195, 542198, 542500, 542961, 543471, 544291, 544472, 547875, 549302, 549371, 550322, 551916, 556525, 560083, 562844, 562846, 571837, 572603, 576698, 576720, 576721, 576723, 577353, 581281, 581370, 583851, 592437, 592445, 592456, 608040, 621305, 628325, 644005, 651630, 668150, 668153, 668156, 669566, 669567, 670110, 681363, 687130, 687132, 690823, 696268, 699689, 716323, 716405);

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

[
  "межрасов ретр фильм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'межрасов ретр фильм';

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

[
  "межрасов ретр фильм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'межрасов ретр фильм';

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 ?

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