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

[
  "real homemade girlfriend"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real homemade girlfriend' 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
  715434
  797378
  825101
  786380
  681745
  682841
  631059
  726327
  757315
  824997
  740763
  715435
  819870
  646052
  612154
  626688
  627690
  560182
  785229
  825201
  784267
  819874
  765084
  460857
  605422
  639882
  675930
  791301
  689145
  676850
  819938
  589102
  807325
  673860
  723622
  800028
  660048
  772763
  535626
  723904
  673836
  421412
  443871
  475826
  525787
  713208
  565032
  447359
  602620
  427544
  489293
  521679
  454652
  687964
  571711
  517832
  473582
  576966
  488772
  514977
  448097
  466573
  463072
  427246
  728946
  459565
  502537
  502518
  623089
  589450
  446894
]

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 (715434, 797378, 825101, 786380, 681745, 682841, 631059, 726327, 757315, 824997, 740763, 715435, 819870, 646052, 612154, 626688, 627690, 560182, 785229, 825201, 784267, 819874, 765084, 460857, 605422, 639882, 675930, 791301, 689145, 676850, 819938, 589102, 807325, 673860, 723622, 800028, 660048, 772763, 535626, 723904, 673836, 421412, 443871, 475826, 525787, 713208, 565032, 447359, 602620, 427544, 489293, 521679, 454652, 687964, 571711, 517832, 473582, 576966, 488772, 514977, 448097, 466573, 463072, 427246, 728946, 459565, 502537, 502518, 623089, 589450, 446894);

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
  421412
  427246
  427544
  443871
  446894
  447359
  448097
  454652
  459565
  460857
  463072
  466573
  473582
  475826
  488772
  489293
  502518
  502537
  514977
  517832
  521679
  525787
  535626
  560182
  565032
  571711
  576966
  589102
  589450
  602620
  605422
  612154
  623089
  626688
  627690
  631059
  639882
  646052
  660048
  673836
  673860
  675930
  676850
  681745
  682841
  687964
  689145
  713208
  715434
  715435
  723622
  723904
  726327
  728946
  740763
  757315
  765084
  772763
  784267
  785229
  786380
  791301
  797378
  800028
  807325
  819870
  819874
  819938
  824997
  825101
  825201
]

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 (421412, 427246, 427544, 443871, 446894, 447359, 448097, 454652, 459565, 460857, 463072, 466573, 473582, 475826, 488772, 489293, 502518, 502537, 514977, 517832, 521679, 525787, 535626, 560182, 565032, 571711, 576966, 589102, 589450, 602620, 605422, 612154, 623089, 626688, 627690, 631059, 639882, 646052, 660048, 673836, 673860, 675930, 676850, 681745, 682841, 687964, 689145, 713208, 715434, 715435, 723622, 723904, 726327, 728946, 740763, 757315, 765084, 772763, 784267, 785229, 786380, 791301, 797378, 800028, 807325, 819870, 819874, 819938, 824997, 825101, 825201);

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
  421412
  427246
  427544
  443871
  446894
  447359
  448097
  454652
  459565
  460857
  463072
  466573
  473582
  475826
  488772
  489293
  502518
  502537
  514977
  517832
  521679
  525787
  535626
  560182
  565032
  571711
  576966
  589102
  589450
  602620
  605422
  612154
  623089
  626688
  627690
  631059
  639882
  646052
  660048
  673836
  673860
  675930
  676850
  681745
  682841
  687964
  689145
  713208
  715434
  715435
  723622
  723904
  726327
  728946
  740763
  757315
  765084
  772763
  784267
  785229
  786380
  791301
  797378
  800028
  807325
  819870
  819874
  819938
  824997
  825101
  825201
]

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 (421412, 427246, 427544, 443871, 446894, 447359, 448097, 454652, 459565, 460857, 463072, 466573, 473582, 475826, 488772, 489293, 502518, 502537, 514977, 517832, 521679, 525787, 535626, 560182, 565032, 571711, 576966, 589102, 589450, 602620, 605422, 612154, 623089, 626688, 627690, 631059, 639882, 646052, 660048, 673836, 673860, 675930, 676850, 681745, 682841, 687964, 689145, 713208, 715434, 715435, 723622, 723904, 726327, 728946, 740763, 757315, 765084, 772763, 784267, 785229, 786380, 791301, 797378, 800028, 807325, 819870, 819874, 819938, 824997, 825101, 825201);

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

[
  "real домашн любительск girlfriend"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'real домашн любительск girlfriend';

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

[
  "real домашн любительск girlfriend"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real домашн любительск girlfriend';

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 ?

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