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

[
  "latina anal pov"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'latina anal pov' 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
  527091
  517528
  589074
  813191
  421691
  823818
  481878
  467995
  514214
  659060
  446811
  575890
  589200
  790844
  444835
  464006
  474756
  454099
  418591
  420351
  796668
  425523
  776222
  498424
  441616
  479788
  767275
  767601
  446964
  647897
  507503
  628654
  521132
  448756
  445649
  479791
  627817
  492534
  787379
  588144
  467088
  450297
  515005
  810052
  735271
  796981
  416032
  496771
  424367
  464910
  654914
  459559
  774129
  473145
  500876
  433038
  441619
  475258
  424347
  472781
  418828
  525045
  441356
  559938
  596551
  424377
  424364
  544663
  589105
  425966
  410561
  424328
]

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 (527091, 517528, 589074, 813191, 421691, 823818, 481878, 467995, 514214, 659060, 446811, 575890, 589200, 790844, 444835, 464006, 474756, 454099, 418591, 420351, 796668, 425523, 776222, 498424, 441616, 479788, 767275, 767601, 446964, 647897, 507503, 628654, 521132, 448756, 445649, 479791, 627817, 492534, 787379, 588144, 467088, 450297, 515005, 810052, 735271, 796981, 416032, 496771, 424367, 464910, 654914, 459559, 774129, 473145, 500876, 433038, 441619, 475258, 424347, 472781, 418828, 525045, 441356, 559938, 596551, 424377, 424364, 544663, 589105, 425966, 410561, 424328);

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
  410561
  416032
  418591
  418828
  420351
  421691
  424328
  424347
  424364
  424367
  424377
  425523
  425966
  433038
  441356
  441616
  441619
  444835
  445649
  446811
  446964
  448756
  450297
  454099
  459559
  464006
  464910
  467088
  467995
  472781
  473145
  474756
  475258
  479788
  479791
  481878
  492534
  496771
  498424
  500876
  507503
  514214
  515005
  517528
  521132
  525045
  527091
  544663
  559938
  575890
  588144
  589074
  589105
  589200
  596551
  627817
  628654
  647897
  654914
  659060
  735271
  767275
  767601
  774129
  776222
  787379
  790844
  796668
  796981
  810052
  813191
  823818
]

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 (410561, 416032, 418591, 418828, 420351, 421691, 424328, 424347, 424364, 424367, 424377, 425523, 425966, 433038, 441356, 441616, 441619, 444835, 445649, 446811, 446964, 448756, 450297, 454099, 459559, 464006, 464910, 467088, 467995, 472781, 473145, 474756, 475258, 479788, 479791, 481878, 492534, 496771, 498424, 500876, 507503, 514214, 515005, 517528, 521132, 525045, 527091, 544663, 559938, 575890, 588144, 589074, 589105, 589200, 596551, 627817, 628654, 647897, 654914, 659060, 735271, 767275, 767601, 774129, 776222, 787379, 790844, 796668, 796981, 810052, 813191, 823818);

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
  410561
  416032
  418591
  418828
  420351
  421691
  424328
  424347
  424364
  424367
  424377
  425523
  425966
  433038
  441356
  441616
  441619
  444835
  445649
  446811
  446964
  448756
  450297
  454099
  459559
  464006
  464910
  467088
  467995
  472781
  473145
  474756
  475258
  479788
  479791
  481878
  492534
  496771
  498424
  500876
  507503
  514214
  515005
  517528
  521132
  525045
  527091
  544663
  559938
  575890
  588144
  589074
  589105
  589200
  596551
  627817
  628654
  647897
  654914
  659060
  735271
  767275
  767601
  774129
  776222
  787379
  790844
  796668
  796981
  810052
  813191
  823818
]

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 (410561, 416032, 418591, 418828, 420351, 421691, 424328, 424347, 424364, 424367, 424377, 425523, 425966, 433038, 441356, 441616, 441619, 444835, 445649, 446811, 446964, 448756, 450297, 454099, 459559, 464006, 464910, 467088, 467995, 472781, 473145, 474756, 475258, 479788, 479791, 481878, 492534, 496771, 498424, 500876, 507503, 514214, 515005, 517528, 521132, 525045, 527091, 544663, 559938, 575890, 588144, 589074, 589105, 589200, 596551, 627817, 628654, 647897, 654914, 659060, 735271, 767275, 767601, 774129, 776222, 787379, 790844, 796668, 796981, 810052, 813191, 823818);

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 ?

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