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

[
  "великолепная толстушка мастурбирует"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'великолепная толстушка мастурбирует' 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
  102334
  725517
  410201
  440016
  503508
  468518
  824293
  744810
  589680
  382215
  686851
  385955
  518770
  437385
  754607
  410129
  705424
  714502
  514875
  740257
  735948
  452757
  526499
  466226
  488559
  619901
  118900
  640306
  429899
  389964
  714386
  715420
  774703
  433746
  466779
  814190
  599528
  768280
  452250
  582437
  605846
  755022
  726968
  444918
  811736
  615693
  429862
  427364
  500914
  746126
  796877
  441858
  518598
  587272
  443246
  472188
  507640
  558172
  617115
  456516
  421832
  473391
  605492
  444018
  507643
  468927
  622693
  624165
]

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 (102334, 725517, 410201, 440016, 503508, 468518, 824293, 744810, 589680, 382215, 686851, 385955, 518770, 437385, 754607, 410129, 705424, 714502, 514875, 740257, 735948, 452757, 526499, 466226, 488559, 619901, 118900, 640306, 429899, 389964, 714386, 715420, 774703, 433746, 466779, 814190, 599528, 768280, 452250, 582437, 605846, 755022, 726968, 444918, 811736, 615693, 429862, 427364, 500914, 746126, 796877, 441858, 518598, 587272, 443246, 472188, 507640, 558172, 617115, 456516, 421832, 473391, 605492, 444018, 507643, 468927, 622693, 624165);

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
  102334
  118900
  382215
  385955
  389964
  410129
  410201
  421832
  427364
  429862
  429899
  433746
  437385
  440016
  441858
  443246
  444018
  444918
  452250
  452757
  456516
  466226
  466779
  468518
  468927
  472188
  473391
  488559
  500914
  503508
  507640
  507643
  514875
  518598
  518770
  526499
  558172
  582437
  587272
  589680
  599528
  605492
  605846
  615693
  617115
  619901
  622693
  624165
  640306
  686851
  705424
  714386
  714502
  715420
  725517
  726968
  735948
  740257
  744810
  746126
  754607
  755022
  768280
  774703
  796877
  811736
  814190
  824293
]

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 (102334, 118900, 382215, 385955, 389964, 410129, 410201, 421832, 427364, 429862, 429899, 433746, 437385, 440016, 441858, 443246, 444018, 444918, 452250, 452757, 456516, 466226, 466779, 468518, 468927, 472188, 473391, 488559, 500914, 503508, 507640, 507643, 514875, 518598, 518770, 526499, 558172, 582437, 587272, 589680, 599528, 605492, 605846, 615693, 617115, 619901, 622693, 624165, 640306, 686851, 705424, 714386, 714502, 715420, 725517, 726968, 735948, 740257, 744810, 746126, 754607, 755022, 768280, 774703, 796877, 811736, 814190, 824293);

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
  102334
  118900
  382215
  385955
  389964
  410129
  410201
  421832
  427364
  429862
  429899
  433746
  437385
  440016
  441858
  443246
  444018
  444918
  452250
  452757
  456516
  466226
  466779
  468518
  468927
  472188
  473391
  488559
  500914
  503508
  507640
  507643
  514875
  518598
  518770
  526499
  558172
  582437
  587272
  589680
  599528
  605492
  605846
  615693
  617115
  619901
  622693
  624165
  640306
  686851
  705424
  714386
  714502
  715420
  725517
  726968
  735948
  740257
  744810
  746126
  754607
  755022
  768280
  774703
  796877
  811736
  814190
  824293
]

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 (102334, 118900, 382215, 385955, 389964, 410129, 410201, 421832, 427364, 429862, 429899, 433746, 437385, 440016, 441858, 443246, 444018, 444918, 452250, 452757, 456516, 466226, 466779, 468518, 468927, 472188, 473391, 488559, 500914, 503508, 507640, 507643, 514875, 518598, 518770, 526499, 558172, 582437, 587272, 589680, 599528, 605492, 605846, 615693, 617115, 619901, 622693, 624165, 640306, 686851, 705424, 714386, 714502, 715420, 725517, 726968, 735948, 740257, 744810, 746126, 754607, 755022, 768280, 774703, 796877, 811736, 814190, 824293);

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 ?

[
  "великолепная толстушка мастурбирует"
  "великолепная толстушка мастурбирует"
  "великолепная толстушка мастурбирует"
  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 ('великолепная толстушка мастурбирует') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('великолепная толстушка мастурбирует')
              AND `query` <> 'великолепная толстушка мастурбирует'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;