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

[
  "wife hard cheating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'wife hard cheating' 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
  825168
  540067
  628143
  651001
  796786
  547172
  551886
  823611
  729012
  689529
  796749
  782130
  702373
  637299
  786761
  724076
  788592
  539235
  530441
  605587
  627768
  748441
  808215
  517573
  628903
  756639
  728686
  712374
  801316
  474242
  642572
  720163
  604464
  594544
  802003
  735486
  726282
  641596
  511332
  794672
  742714
  457003
  677921
  740860
  443627
  475196
  485259
  578771
  651269
  591881
  763810
  433547
  565007
  809937
  516670
  591926
  523421
  605487
  746489
  808946
  551649
  444288
  626399
  593625
  585746
  528719
  605661
  548747
  578774
  578804
  496518
  522759
  513506
]

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 (825168, 540067, 628143, 651001, 796786, 547172, 551886, 823611, 729012, 689529, 796749, 782130, 702373, 637299, 786761, 724076, 788592, 539235, 530441, 605587, 627768, 748441, 808215, 517573, 628903, 756639, 728686, 712374, 801316, 474242, 642572, 720163, 604464, 594544, 802003, 735486, 726282, 641596, 511332, 794672, 742714, 457003, 677921, 740860, 443627, 475196, 485259, 578771, 651269, 591881, 763810, 433547, 565007, 809937, 516670, 591926, 523421, 605487, 746489, 808946, 551649, 444288, 626399, 593625, 585746, 528719, 605661, 548747, 578774, 578804, 496518, 522759, 513506);

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
  433547
  443627
  444288
  457003
  474242
  475196
  485259
  496518
  511332
  513506
  516670
  517573
  522759
  523421
  528719
  530441
  539235
  540067
  547172
  548747
  551649
  551886
  565007
  578771
  578774
  578804
  585746
  591881
  591926
  593625
  594544
  604464
  605487
  605587
  605661
  626399
  627768
  628143
  628903
  637299
  641596
  642572
  651001
  651269
  677921
  689529
  702373
  712374
  720163
  724076
  726282
  728686
  729012
  735486
  740860
  742714
  746489
  748441
  756639
  763810
  782130
  786761
  788592
  794672
  796749
  796786
  801316
  802003
  808215
  808946
  809937
  823611
  825168
]

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 (433547, 443627, 444288, 457003, 474242, 475196, 485259, 496518, 511332, 513506, 516670, 517573, 522759, 523421, 528719, 530441, 539235, 540067, 547172, 548747, 551649, 551886, 565007, 578771, 578774, 578804, 585746, 591881, 591926, 593625, 594544, 604464, 605487, 605587, 605661, 626399, 627768, 628143, 628903, 637299, 641596, 642572, 651001, 651269, 677921, 689529, 702373, 712374, 720163, 724076, 726282, 728686, 729012, 735486, 740860, 742714, 746489, 748441, 756639, 763810, 782130, 786761, 788592, 794672, 796749, 796786, 801316, 802003, 808215, 808946, 809937, 823611, 825168);

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
  433547
  443627
  444288
  457003
  474242
  475196
  485259
  496518
  511332
  513506
  516670
  517573
  522759
  523421
  528719
  530441
  539235
  540067
  547172
  548747
  551649
  551886
  565007
  578771
  578774
  578804
  585746
  591881
  591926
  593625
  594544
  604464
  605487
  605587
  605661
  626399
  627768
  628143
  628903
  637299
  641596
  642572
  651001
  651269
  677921
  689529
  702373
  712374
  720163
  724076
  726282
  728686
  729012
  735486
  740860
  742714
  746489
  748441
  756639
  763810
  782130
  786761
  788592
  794672
  796749
  796786
  801316
  802003
  808215
  808946
  809937
  823611
  825168
]

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 (433547, 443627, 444288, 457003, 474242, 475196, 485259, 496518, 511332, 513506, 516670, 517573, 522759, 523421, 528719, 530441, 539235, 540067, 547172, 548747, 551649, 551886, 565007, 578771, 578774, 578804, 585746, 591881, 591926, 593625, 594544, 604464, 605487, 605587, 605661, 626399, 627768, 628143, 628903, 637299, 641596, 642572, 651001, 651269, 677921, 689529, 702373, 712374, 720163, 724076, 726282, 728686, 729012, 735486, 740860, 742714, 746489, 748441, 756639, 763810, 782130, 786761, 788592, 794672, 796749, 796786, 801316, 802003, 808215, 808946, 809937, 823611, 825168);

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

[
  "жен hard cheating"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жен hard cheating';

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

[
  "жен hard cheating"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жен hard cheating';

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 ?

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