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

[
  "светит киской"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'светит киской' 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
  549646
  567135
  574768
  570073
  625677
  461840
  470638
  457214
  516605
  525842
  527382
  528937
  535526
  522284
  443871
  608681
  602647
  427878
  440538
  671075
  467316
  524836
  590598
  499863
  492401
  465883
  479527
  470481
  482737
  567242
  664435
  593180
  433200
  444996
  547534
  653472
  597193
  425775
  516861
  530064
  530948
  613515
  7446
  524635
  486875
  499597
  562740
  561699
  567053
  679567
  605182
  591439
  459171
  589450
  606004
  514648
  524512
  548340
  624776
  623421
  464062
  451893
  614609
  598654
  603493
  605492
  617004
  481994
  472486
  529078
  616024
  521843
  550599
]

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, 549646, 567135, 574768, 570073, 625677, 461840, 470638, 457214, 516605, 525842, 527382, 528937, 535526, 522284, 443871, 608681, 602647, 427878, 440538, 671075, 467316, 524836, 590598, 499863, 492401, 465883, 479527, 470481, 482737, 567242, 664435, 593180, 433200, 444996, 547534, 653472, 597193, 425775, 516861, 530064, 530948, 613515, 7446, 524635, 486875, 499597, 562740, 561699, 567053, 679567, 605182, 591439, 459171, 589450, 606004, 514648, 524512, 548340, 624776, 623421, 464062, 451893, 614609, 598654, 603493, 605492, 617004, 481994, 472486, 529078, 616024, 521843, 550599);

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
  7446
  425775
  427878
  433200
  440538
  443871
  444996
  451893
  457214
  459171
  461840
  464062
  465883
  467316
  470481
  470638
  472486
  479527
  481994
  482737
  486875
  492401
  499597
  499863
  514648
  516605
  516861
  521843
  522284
  524512
  524635
  524836
  525842
  527091
  527382
  528937
  529078
  530064
  530948
  535526
  547534
  548340
  549646
  550599
  561699
  562740
  567053
  567135
  567242
  570073
  574768
  589450
  590598
  591439
  593180
  597193
  598654
  602647
  603493
  605182
  605492
  606004
  608681
  613515
  614609
  616024
  617004
  623421
  624776
  625677
  653472
  664435
  671075
  679567
]

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 (7446, 425775, 427878, 433200, 440538, 443871, 444996, 451893, 457214, 459171, 461840, 464062, 465883, 467316, 470481, 470638, 472486, 479527, 481994, 482737, 486875, 492401, 499597, 499863, 514648, 516605, 516861, 521843, 522284, 524512, 524635, 524836, 525842, 527091, 527382, 528937, 529078, 530064, 530948, 535526, 547534, 548340, 549646, 550599, 561699, 562740, 567053, 567135, 567242, 570073, 574768, 589450, 590598, 591439, 593180, 597193, 598654, 602647, 603493, 605182, 605492, 606004, 608681, 613515, 614609, 616024, 617004, 623421, 624776, 625677, 653472, 664435, 671075, 679567);

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
  7446
  425775
  427878
  433200
  440538
  443871
  444996
  451893
  457214
  459171
  461840
  464062
  465883
  467316
  470481
  470638
  472486
  479527
  481994
  482737
  486875
  492401
  499597
  499863
  514648
  516605
  516861
  521843
  522284
  524512
  524635
  524836
  525842
  527091
  527382
  528937
  529078
  530064
  530948
  535526
  547534
  548340
  549646
  550599
  561699
  562740
  567053
  567135
  567242
  570073
  574768
  589450
  590598
  591439
  593180
  597193
  598654
  602647
  603493
  605182
  605492
  606004
  608681
  613515
  614609
  616024
  617004
  623421
  624776
  625677
  653472
  664435
  671075
  679567
]

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 (7446, 425775, 427878, 433200, 440538, 443871, 444996, 451893, 457214, 459171, 461840, 464062, 465883, 467316, 470481, 470638, 472486, 479527, 481994, 482737, 486875, 492401, 499597, 499863, 514648, 516605, 516861, 521843, 522284, 524512, 524635, 524836, 525842, 527091, 527382, 528937, 529078, 530064, 530948, 535526, 547534, 548340, 549646, 550599, 561699, 562740, 567053, 567135, 567242, 570073, 574768, 589450, 590598, 591439, 593180, 597193, 598654, 602647, 603493, 605182, 605492, 606004, 608681, 613515, 614609, 616024, 617004, 623421, 624776, 625677, 653472, 664435, 671075, 679567);

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 ?

[
  "светит киской"
  "светит киской"
  "светит киской"
  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 ('светит киской') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('светит киской')
              AND `query` <> 'светит киской'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;