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

[
  "threesome friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'threesome friends' 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
  463074
  523712
  471722
  484092
  507961
  649604
  474635
  455507
  430336
  504689
  684283
  426117
  473952
  470561
  498357
  445742
  568309
  578017
  477463
  579317
  645898
  420398
  515361
  593853
  606778
  507296
  593835
  470546
  509707
  649106
  444692
  426408
  431965
  484739
  542753
  635188
  718695
  470106
  525211
  432771
  434000
  432149
  454527
  411201
  446080
  454308
  485155
  733204
  543425
  676911
  524527
  501209
  682531
  454521
  519632
  474633
  546669
  474639
  517567
  480719
  446894
  604960
  581433
  550667
  536665
  607372
  518593
  583723
  567148
  483788
  640136
  562108
  507182
]

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 (463074, 523712, 471722, 484092, 507961, 649604, 474635, 455507, 430336, 504689, 684283, 426117, 473952, 470561, 498357, 445742, 568309, 578017, 477463, 579317, 645898, 420398, 515361, 593853, 606778, 507296, 593835, 470546, 509707, 649106, 444692, 426408, 431965, 484739, 542753, 635188, 718695, 470106, 525211, 432771, 434000, 432149, 454527, 411201, 446080, 454308, 485155, 733204, 543425, 676911, 524527, 501209, 682531, 454521, 519632, 474633, 546669, 474639, 517567, 480719, 446894, 604960, 581433, 550667, 536665, 607372, 518593, 583723, 567148, 483788, 640136, 562108, 507182);

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
  411201
  420398
  426117
  426408
  430336
  431965
  432149
  432771
  434000
  444692
  445742
  446080
  446894
  454308
  454521
  454527
  455507
  463074
  470106
  470546
  470561
  471722
  473952
  474633
  474635
  474639
  477463
  480719
  483788
  484092
  484739
  485155
  498357
  501209
  504689
  507182
  507296
  507961
  509707
  515361
  517567
  518593
  519632
  523712
  524527
  525211
  536665
  542753
  543425
  546669
  550667
  562108
  567148
  568309
  578017
  579317
  581433
  583723
  593835
  593853
  604960
  606778
  607372
  635188
  640136
  645898
  649106
  649604
  676911
  682531
  684283
  718695
  733204
]

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 (411201, 420398, 426117, 426408, 430336, 431965, 432149, 432771, 434000, 444692, 445742, 446080, 446894, 454308, 454521, 454527, 455507, 463074, 470106, 470546, 470561, 471722, 473952, 474633, 474635, 474639, 477463, 480719, 483788, 484092, 484739, 485155, 498357, 501209, 504689, 507182, 507296, 507961, 509707, 515361, 517567, 518593, 519632, 523712, 524527, 525211, 536665, 542753, 543425, 546669, 550667, 562108, 567148, 568309, 578017, 579317, 581433, 583723, 593835, 593853, 604960, 606778, 607372, 635188, 640136, 645898, 649106, 649604, 676911, 682531, 684283, 718695, 733204);

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
  411201
  420398
  426117
  426408
  430336
  431965
  432149
  432771
  434000
  444692
  445742
  446080
  446894
  454308
  454521
  454527
  455507
  463074
  470106
  470546
  470561
  471722
  473952
  474633
  474635
  474639
  477463
  480719
  483788
  484092
  484739
  485155
  498357
  501209
  504689
  507182
  507296
  507961
  509707
  515361
  517567
  518593
  519632
  523712
  524527
  525211
  536665
  542753
  543425
  546669
  550667
  562108
  567148
  568309
  578017
  579317
  581433
  583723
  593835
  593853
  604960
  606778
  607372
  635188
  640136
  645898
  649106
  649604
  676911
  682531
  684283
  718695
  733204
]

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 (411201, 420398, 426117, 426408, 430336, 431965, 432149, 432771, 434000, 444692, 445742, 446080, 446894, 454308, 454521, 454527, 455507, 463074, 470106, 470546, 470561, 471722, 473952, 474633, 474635, 474639, 477463, 480719, 483788, 484092, 484739, 485155, 498357, 501209, 504689, 507182, 507296, 507961, 509707, 515361, 517567, 518593, 519632, 523712, 524527, 525211, 536665, 542753, 543425, 546669, 550667, 562108, 567148, 568309, 578017, 579317, 581433, 583723, 593835, 593853, 604960, 606778, 607372, 635188, 640136, 645898, 649106, 649604, 676911, 682531, 684283, 718695, 733204);

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

[
  "секс втро friends"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс втро friends';

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

[
  "секс втро friends"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс втро friends';

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 ?

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