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

[
  "teen dildo young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen dildo young' 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
  397643
  570074
  532680
  539203
  531123
  532745
  649953
  751565
  484692
  541874
  542864
  647960
  702163
  623196
  561970
  445608
  454509
  435398
  757906
  631957
  566786
  628126
  516686
  533746
  396664
  532984
  663495
  424648
  405531
  461086
  527412
  665107
  545480
  421164
  406171
  631597
  491270
  542192
  538669
  532666
  530369
  404693
  548258
  643109
  410573
  525102
  422512
  454215
  540339
  532738
  534229
  531231
  512059
  536691
  416700
  620198
  534215
  454709
  466065
  476797
  425168
  584492
  663458
  536584
  650155
  647837
  401318
  413901
  677698
  454638
  572003
  435449
  494037
  534645
  518511
  647893
]

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 (397643, 570074, 532680, 539203, 531123, 532745, 649953, 751565, 484692, 541874, 542864, 647960, 702163, 623196, 561970, 445608, 454509, 435398, 757906, 631957, 566786, 628126, 516686, 533746, 396664, 532984, 663495, 424648, 405531, 461086, 527412, 665107, 545480, 421164, 406171, 631597, 491270, 542192, 538669, 532666, 530369, 404693, 548258, 643109, 410573, 525102, 422512, 454215, 540339, 532738, 534229, 531231, 512059, 536691, 416700, 620198, 534215, 454709, 466065, 476797, 425168, 584492, 663458, 536584, 650155, 647837, 401318, 413901, 677698, 454638, 572003, 435449, 494037, 534645, 518511, 647893);

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
  396664
  397643
  401318
  404693
  405531
  406171
  410573
  413901
  416700
  421164
  422512
  424648
  425168
  435398
  435449
  445608
  454215
  454509
  454638
  454709
  461086
  466065
  476797
  484692
  491270
  494037
  512059
  516686
  518511
  525102
  527412
  530369
  531123
  531231
  532666
  532680
  532738
  532745
  532984
  533746
  534215
  534229
  534645
  536584
  536691
  538669
  539203
  540339
  541874
  542192
  542864
  545480
  548258
  561970
  566786
  570074
  572003
  584492
  620198
  623196
  628126
  631597
  631957
  643109
  647837
  647893
  647960
  649953
  650155
  663458
  663495
  665107
  677698
  702163
  751565
  757906
]

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 (396664, 397643, 401318, 404693, 405531, 406171, 410573, 413901, 416700, 421164, 422512, 424648, 425168, 435398, 435449, 445608, 454215, 454509, 454638, 454709, 461086, 466065, 476797, 484692, 491270, 494037, 512059, 516686, 518511, 525102, 527412, 530369, 531123, 531231, 532666, 532680, 532738, 532745, 532984, 533746, 534215, 534229, 534645, 536584, 536691, 538669, 539203, 540339, 541874, 542192, 542864, 545480, 548258, 561970, 566786, 570074, 572003, 584492, 620198, 623196, 628126, 631597, 631957, 643109, 647837, 647893, 647960, 649953, 650155, 663458, 663495, 665107, 677698, 702163, 751565, 757906);

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
  396664
  397643
  401318
  404693
  405531
  406171
  410573
  413901
  416700
  421164
  422512
  424648
  425168
  435398
  435449
  445608
  454215
  454509
  454638
  454709
  461086
  466065
  476797
  484692
  491270
  494037
  512059
  516686
  518511
  525102
  527412
  530369
  531123
  531231
  532666
  532680
  532738
  532745
  532984
  533746
  534215
  534229
  534645
  536584
  536691
  538669
  539203
  540339
  541874
  542192
  542864
  545480
  548258
  561970
  566786
  570074
  572003
  584492
  620198
  623196
  628126
  631597
  631957
  643109
  647837
  647893
  647960
  649953
  650155
  663458
  663495
  665107
  677698
  702163
  751565
  757906
]

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 (396664, 397643, 401318, 404693, 405531, 406171, 410573, 413901, 416700, 421164, 422512, 424648, 425168, 435398, 435449, 445608, 454215, 454509, 454638, 454709, 461086, 466065, 476797, 484692, 491270, 494037, 512059, 516686, 518511, 525102, 527412, 530369, 531123, 531231, 532666, 532680, 532738, 532745, 532984, 533746, 534215, 534229, 534645, 536584, 536691, 538669, 539203, 540339, 541874, 542192, 542864, 545480, 548258, 561970, 566786, 570074, 572003, 584492, 620198, 623196, 628126, 631597, 631957, 643109, 647837, 647893, 647960, 649953, 650155, 663458, 663495, 665107, 677698, 702163, 751565, 757906);

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

[
  "teen дилд young"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen дилд young';

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

[
  "teen дилд young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen дилд young';