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

[
  "rough deepthroat bdsm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rough deepthroat bdsm' 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
  530765
  550085
  447759
  536787
  669574
  775848
  457130
  453364
  592602
  472149
  567758
  647995
  459488
  603482
  459534
  430081
  545262
  670239
  712540
  496086
  439854
  444169
  520734
  500180
  527576
  445367
  523996
  475927
  536586
  514071
  486316
  491273
  520728
  426062
  509660
  533760
  524149
  503406
  496270
  467613
  501329
  427454
  593863
  469193
  647877
  583670
  533738
  540338
  603132
  536233
  521381
  545621
  447952
  509879
  537584
  530030
  647936
  431448
  631202
  579379
  530703
  543652
  637413
  421164
  599835
  451866
  602655
  520737
  522382
  464953
  526203
]

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 (530765, 550085, 447759, 536787, 669574, 775848, 457130, 453364, 592602, 472149, 567758, 647995, 459488, 603482, 459534, 430081, 545262, 670239, 712540, 496086, 439854, 444169, 520734, 500180, 527576, 445367, 523996, 475927, 536586, 514071, 486316, 491273, 520728, 426062, 509660, 533760, 524149, 503406, 496270, 467613, 501329, 427454, 593863, 469193, 647877, 583670, 533738, 540338, 603132, 536233, 521381, 545621, 447952, 509879, 537584, 530030, 647936, 431448, 631202, 579379, 530703, 543652, 637413, 421164, 599835, 451866, 602655, 520737, 522382, 464953, 526203);

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
  421164
  426062
  427454
  430081
  431448
  439854
  444169
  445367
  447759
  447952
  451866
  453364
  457130
  459488
  459534
  464953
  467613
  469193
  472149
  475927
  486316
  491273
  496086
  496270
  500180
  501329
  503406
  509660
  509879
  514071
  520728
  520734
  520737
  521381
  522382
  523996
  524149
  526203
  527576
  530030
  530703
  530765
  533738
  533760
  536233
  536586
  536787
  537584
  540338
  543652
  545262
  545621
  550085
  567758
  579379
  583670
  592602
  593863
  599835
  602655
  603132
  603482
  631202
  637413
  647877
  647936
  647995
  669574
  670239
  712540
  775848
]

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 (421164, 426062, 427454, 430081, 431448, 439854, 444169, 445367, 447759, 447952, 451866, 453364, 457130, 459488, 459534, 464953, 467613, 469193, 472149, 475927, 486316, 491273, 496086, 496270, 500180, 501329, 503406, 509660, 509879, 514071, 520728, 520734, 520737, 521381, 522382, 523996, 524149, 526203, 527576, 530030, 530703, 530765, 533738, 533760, 536233, 536586, 536787, 537584, 540338, 543652, 545262, 545621, 550085, 567758, 579379, 583670, 592602, 593863, 599835, 602655, 603132, 603482, 631202, 637413, 647877, 647936, 647995, 669574, 670239, 712540, 775848);

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
  421164
  426062
  427454
  430081
  431448
  439854
  444169
  445367
  447759
  447952
  451866
  453364
  457130
  459488
  459534
  464953
  467613
  469193
  472149
  475927
  486316
  491273
  496086
  496270
  500180
  501329
  503406
  509660
  509879
  514071
  520728
  520734
  520737
  521381
  522382
  523996
  524149
  526203
  527576
  530030
  530703
  530765
  533738
  533760
  536233
  536586
  536787
  537584
  540338
  543652
  545262
  545621
  550085
  567758
  579379
  583670
  592602
  593863
  599835
  602655
  603132
  603482
  631202
  637413
  647877
  647936
  647995
  669574
  670239
  712540
  775848
]

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 (421164, 426062, 427454, 430081, 431448, 439854, 444169, 445367, 447759, 447952, 451866, 453364, 457130, 459488, 459534, 464953, 467613, 469193, 472149, 475927, 486316, 491273, 496086, 496270, 500180, 501329, 503406, 509660, 509879, 514071, 520728, 520734, 520737, 521381, 522382, 523996, 524149, 526203, 527576, 530030, 530703, 530765, 533738, 533760, 536233, 536586, 536787, 537584, 540338, 543652, 545262, 545621, 550085, 567758, 579379, 583670, 592602, 593863, 599835, 602655, 603132, 603482, 631202, 637413, 647877, 647936, 647995, 669574, 670239, 712540, 775848);

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

[
  "rough глубокийминет минет оральн секс бдсм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'rough глубокийминет минет оральн секс бдсм';

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

[
  "rough глубокийминет минет оральн секс бдсм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rough глубокийминет минет оральн секс бдсм';

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 ?

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