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

[
  "mature woman lesbian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature woman lesbian' 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
  599207
  385653
  495877
  571809
  611285
  591283
  698959
  647599
  560043
  664828
  762513
  802128
  706294
  605376
  592970
  620755
  576689
  668549
  814811
  576658
  650847
  581266
  784304
  475249
  408435
  811930
  531260
  357513
  623262
  641127
  118472
  735543
  780668
  577076
  801907
  404052
  606086
  644266
  388891
  649905
  600007
  399083
  398966
  191602
  649216
  444916
  750064
  815737
  504414
  419654
  815076
  503498
  532893
  601077
  464534
  815886
  538915
  643090
  433295
  647960
  517464
  524792
  383202
  396422
  524682
  477873
  513025
  556025
  574200
  504927
  487703
  597240
]

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 (599207, 385653, 495877, 571809, 611285, 591283, 698959, 647599, 560043, 664828, 762513, 802128, 706294, 605376, 592970, 620755, 576689, 668549, 814811, 576658, 650847, 581266, 784304, 475249, 408435, 811930, 531260, 357513, 623262, 641127, 118472, 735543, 780668, 577076, 801907, 404052, 606086, 644266, 388891, 649905, 600007, 399083, 398966, 191602, 649216, 444916, 750064, 815737, 504414, 419654, 815076, 503498, 532893, 601077, 464534, 815886, 538915, 643090, 433295, 647960, 517464, 524792, 383202, 396422, 524682, 477873, 513025, 556025, 574200, 504927, 487703, 597240);

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
  118472
  191602
  357513
  383202
  385653
  388891
  396422
  398966
  399083
  404052
  408435
  419654
  433295
  444916
  464534
  475249
  477873
  487703
  495877
  503498
  504414
  504927
  513025
  517464
  524682
  524792
  531260
  532893
  538915
  556025
  560043
  571809
  574200
  576658
  576689
  577076
  581266
  591283
  592970
  597240
  599207
  600007
  601077
  605376
  606086
  611285
  620755
  623262
  641127
  643090
  644266
  647599
  647960
  649216
  649905
  650847
  664828
  668549
  698959
  706294
  735543
  750064
  762513
  780668
  784304
  801907
  802128
  811930
  814811
  815076
  815737
  815886
]

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 (118472, 191602, 357513, 383202, 385653, 388891, 396422, 398966, 399083, 404052, 408435, 419654, 433295, 444916, 464534, 475249, 477873, 487703, 495877, 503498, 504414, 504927, 513025, 517464, 524682, 524792, 531260, 532893, 538915, 556025, 560043, 571809, 574200, 576658, 576689, 577076, 581266, 591283, 592970, 597240, 599207, 600007, 601077, 605376, 606086, 611285, 620755, 623262, 641127, 643090, 644266, 647599, 647960, 649216, 649905, 650847, 664828, 668549, 698959, 706294, 735543, 750064, 762513, 780668, 784304, 801907, 802128, 811930, 814811, 815076, 815737, 815886);

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
  118472
  191602
  357513
  383202
  385653
  388891
  396422
  398966
  399083
  404052
  408435
  419654
  433295
  444916
  464534
  475249
  477873
  487703
  495877
  503498
  504414
  504927
  513025
  517464
  524682
  524792
  531260
  532893
  538915
  556025
  560043
  571809
  574200
  576658
  576689
  577076
  581266
  591283
  592970
  597240
  599207
  600007
  601077
  605376
  606086
  611285
  620755
  623262
  641127
  643090
  644266
  647599
  647960
  649216
  649905
  650847
  664828
  668549
  698959
  706294
  735543
  750064
  762513
  780668
  784304
  801907
  802128
  811930
  814811
  815076
  815737
  815886
]

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 (118472, 191602, 357513, 383202, 385653, 388891, 396422, 398966, 399083, 404052, 408435, 419654, 433295, 444916, 464534, 475249, 477873, 487703, 495877, 503498, 504414, 504927, 513025, 517464, 524682, 524792, 531260, 532893, 538915, 556025, 560043, 571809, 574200, 576658, 576689, 577076, 581266, 591283, 592970, 597240, 599207, 600007, 601077, 605376, 606086, 611285, 620755, 623262, 641127, 643090, 644266, 647599, 647960, 649216, 649905, 650847, 664828, 668549, 698959, 706294, 735543, 750064, 762513, 780668, 784304, 801907, 802128, 811930, 814811, 815076, 815737, 815886);

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 ?

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