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

[
  "curvy anal curvy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curvy anal curvy' 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
  401270
  505394
  95837
  188117
  814971
  716765
  756405
  400847
  819920
  452189
  802379
  810229
  812911
  641965
  702453
  813101
  401137
  520217
  533643
  577402
  430818
  509590
  798872
  480645
  447911
  527863
  502792
  535423
  598376
  600453
  621426
  453686
  448084
  464704
  813532
  788260
  415761
  476117
  431341
  481584
  667975
  633521
  510107
  404585
  537937
  478037
  569133
  668668
  569544
  510856
  495660
  617428
  473439
  448954
  480412
  674986
  756469
  644047
  634885
  630866
  483555
  486868
  415883
  427543
  698124
  397481
  610588
  540573
  624247
  533013
  605318
  527908
  521575
]

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 (401270, 505394, 95837, 188117, 814971, 716765, 756405, 400847, 819920, 452189, 802379, 810229, 812911, 641965, 702453, 813101, 401137, 520217, 533643, 577402, 430818, 509590, 798872, 480645, 447911, 527863, 502792, 535423, 598376, 600453, 621426, 453686, 448084, 464704, 813532, 788260, 415761, 476117, 431341, 481584, 667975, 633521, 510107, 404585, 537937, 478037, 569133, 668668, 569544, 510856, 495660, 617428, 473439, 448954, 480412, 674986, 756469, 644047, 634885, 630866, 483555, 486868, 415883, 427543, 698124, 397481, 610588, 540573, 624247, 533013, 605318, 527908, 521575);

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
  95837
  188117
  397481
  400847
  401137
  401270
  404585
  415761
  415883
  427543
  430818
  431341
  447911
  448084
  448954
  452189
  453686
  464704
  473439
  476117
  478037
  480412
  480645
  481584
  483555
  486868
  495660
  502792
  505394
  509590
  510107
  510856
  520217
  521575
  527863
  527908
  533013
  533643
  535423
  537937
  540573
  569133
  569544
  577402
  598376
  600453
  605318
  610588
  617428
  621426
  624247
  630866
  633521
  634885
  641965
  644047
  667975
  668668
  674986
  698124
  702453
  716765
  756405
  756469
  788260
  798872
  802379
  810229
  812911
  813101
  813532
  814971
  819920
]

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 (95837, 188117, 397481, 400847, 401137, 401270, 404585, 415761, 415883, 427543, 430818, 431341, 447911, 448084, 448954, 452189, 453686, 464704, 473439, 476117, 478037, 480412, 480645, 481584, 483555, 486868, 495660, 502792, 505394, 509590, 510107, 510856, 520217, 521575, 527863, 527908, 533013, 533643, 535423, 537937, 540573, 569133, 569544, 577402, 598376, 600453, 605318, 610588, 617428, 621426, 624247, 630866, 633521, 634885, 641965, 644047, 667975, 668668, 674986, 698124, 702453, 716765, 756405, 756469, 788260, 798872, 802379, 810229, 812911, 813101, 813532, 814971, 819920);

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
  95837
  188117
  397481
  400847
  401137
  401270
  404585
  415761
  415883
  427543
  430818
  431341
  447911
  448084
  448954
  452189
  453686
  464704
  473439
  476117
  478037
  480412
  480645
  481584
  483555
  486868
  495660
  502792
  505394
  509590
  510107
  510856
  520217
  521575
  527863
  527908
  533013
  533643
  535423
  537937
  540573
  569133
  569544
  577402
  598376
  600453
  605318
  610588
  617428
  621426
  624247
  630866
  633521
  634885
  641965
  644047
  667975
  668668
  674986
  698124
  702453
  716765
  756405
  756469
  788260
  798872
  802379
  810229
  812911
  813101
  813532
  814971
  819920
]

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 (95837, 188117, 397481, 400847, 401137, 401270, 404585, 415761, 415883, 427543, 430818, 431341, 447911, 448084, 448954, 452189, 453686, 464704, 473439, 476117, 478037, 480412, 480645, 481584, 483555, 486868, 495660, 502792, 505394, 509590, 510107, 510856, 520217, 521575, 527863, 527908, 533013, 533643, 535423, 537937, 540573, 569133, 569544, 577402, 598376, 600453, 605318, 610588, 617428, 621426, 624247, 630866, 633521, 634885, 641965, 644047, 667975, 668668, 674986, 698124, 702453, 716765, 756405, 756469, 788260, 798872, 802379, 810229, 812911, 813101, 813532, 814971, 819920);

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

[
  "curvy анал curvy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'curvy анал curvy';

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

[
  "curvy анал curvy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curvy анал curvy';

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 ?

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