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

[
  "blowjob facefuck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'blowjob facefuck' 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
  456207
  581989
  495046
  753211
  505782
  443203
  793844
  782940
  426069
  697008
  503770
  545725
  561004
  604413
  438398
  511364
  422402
  419931
  451673
  480644
  555071
  559617
  447785
  533570
  562499
  436115
  529530
  480425
  434671
  506452
  825762
  625860
  421609
  508521
  620230
  456408
  488051
  497014
  602480
  452557
  805143
  520493
  479600
  520082
  471959
  445026
  531581
  505545
  555090
  475365
  459534
  577778
  572318
  520957
  464204
  515371
  600004
  637145
  520961
  462931
  558820
  426062
  633796
  448632
  497230
  533950
  523819
  486829
  634153
  459535
  435792
]

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 (456207, 581989, 495046, 753211, 505782, 443203, 793844, 782940, 426069, 697008, 503770, 545725, 561004, 604413, 438398, 511364, 422402, 419931, 451673, 480644, 555071, 559617, 447785, 533570, 562499, 436115, 529530, 480425, 434671, 506452, 825762, 625860, 421609, 508521, 620230, 456408, 488051, 497014, 602480, 452557, 805143, 520493, 479600, 520082, 471959, 445026, 531581, 505545, 555090, 475365, 459534, 577778, 572318, 520957, 464204, 515371, 600004, 637145, 520961, 462931, 558820, 426062, 633796, 448632, 497230, 533950, 523819, 486829, 634153, 459535, 435792);

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
  419931
  421609
  422402
  426062
  426069
  434671
  435792
  436115
  438398
  443203
  445026
  447785
  448632
  451673
  452557
  456207
  456408
  459534
  459535
  462931
  464204
  471959
  475365
  479600
  480425
  480644
  486829
  488051
  495046
  497014
  497230
  503770
  505545
  505782
  506452
  508521
  511364
  515371
  520082
  520493
  520957
  520961
  523819
  529530
  531581
  533570
  533950
  545725
  555071
  555090
  558820
  559617
  561004
  562499
  572318
  577778
  581989
  600004
  602480
  604413
  620230
  625860
  633796
  634153
  637145
  697008
  753211
  782940
  793844
  805143
  825762
]

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 (419931, 421609, 422402, 426062, 426069, 434671, 435792, 436115, 438398, 443203, 445026, 447785, 448632, 451673, 452557, 456207, 456408, 459534, 459535, 462931, 464204, 471959, 475365, 479600, 480425, 480644, 486829, 488051, 495046, 497014, 497230, 503770, 505545, 505782, 506452, 508521, 511364, 515371, 520082, 520493, 520957, 520961, 523819, 529530, 531581, 533570, 533950, 545725, 555071, 555090, 558820, 559617, 561004, 562499, 572318, 577778, 581989, 600004, 602480, 604413, 620230, 625860, 633796, 634153, 637145, 697008, 753211, 782940, 793844, 805143, 825762);

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
  419931
  421609
  422402
  426062
  426069
  434671
  435792
  436115
  438398
  443203
  445026
  447785
  448632
  451673
  452557
  456207
  456408
  459534
  459535
  462931
  464204
  471959
  475365
  479600
  480425
  480644
  486829
  488051
  495046
  497014
  497230
  503770
  505545
  505782
  506452
  508521
  511364
  515371
  520082
  520493
  520957
  520961
  523819
  529530
  531581
  533570
  533950
  545725
  555071
  555090
  558820
  559617
  561004
  562499
  572318
  577778
  581989
  600004
  602480
  604413
  620230
  625860
  633796
  634153
  637145
  697008
  753211
  782940
  793844
  805143
  825762
]

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 (419931, 421609, 422402, 426062, 426069, 434671, 435792, 436115, 438398, 443203, 445026, 447785, 448632, 451673, 452557, 456207, 456408, 459534, 459535, 462931, 464204, 471959, 475365, 479600, 480425, 480644, 486829, 488051, 495046, 497014, 497230, 503770, 505545, 505782, 506452, 508521, 511364, 515371, 520082, 520493, 520957, 520961, 523819, 529530, 531581, 533570, 533950, 545725, 555071, 555090, 558820, 559617, 561004, 562499, 572318, 577778, 581989, 600004, 602480, 604413, 620230, 625860, 633796, 634153, 637145, 697008, 753211, 782940, 793844, 805143, 825762);

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

[
  "минет оральн секс facefuck"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'минет оральн секс facefuck';

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

[
  "минет оральн секс facefuck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'минет оральн секс facefuck';

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 ?

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