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

[
  "amateur sharing"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur sharing' 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
  458791
  506862
  546771
  542053
  566187
  572214
  755170
  743906
  469118
  510572
  429782
  454365
  471979
  488821
  510220
  516215
  528597
  582459
  580771
  564263
  799941
  477373
  498205
  484944
  604700
  635490
  630915
  452418
  543392
  587251
  458182
  496650
  466493
  472496
  515956
  561892
  676354
  492921
  516635
  488822
  636579
  423568
  519346
  463625
  750704
  437686
  531278
  502453
  510157
  542056
  649240
  628654
  514659
  437488
  682303
  524235
  492688
  523793
  584703
  514808
  521852
  521495
  564254
  560783
  497865
  490068
  478108
  509666
  511802
  584688
  529290
  651937
  567148
]

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 (458791, 506862, 546771, 542053, 566187, 572214, 755170, 743906, 469118, 510572, 429782, 454365, 471979, 488821, 510220, 516215, 528597, 582459, 580771, 564263, 799941, 477373, 498205, 484944, 604700, 635490, 630915, 452418, 543392, 587251, 458182, 496650, 466493, 472496, 515956, 561892, 676354, 492921, 516635, 488822, 636579, 423568, 519346, 463625, 750704, 437686, 531278, 502453, 510157, 542056, 649240, 628654, 514659, 437488, 682303, 524235, 492688, 523793, 584703, 514808, 521852, 521495, 564254, 560783, 497865, 490068, 478108, 509666, 511802, 584688, 529290, 651937, 567148);

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
  423568
  429782
  437488
  437686
  452418
  454365
  458182
  458791
  463625
  466493
  469118
  471979
  472496
  477373
  478108
  484944
  488821
  488822
  490068
  492688
  492921
  496650
  497865
  498205
  502453
  506862
  509666
  510157
  510220
  510572
  511802
  514659
  514808
  515956
  516215
  516635
  519346
  521495
  521852
  523793
  524235
  528597
  529290
  531278
  542053
  542056
  543392
  546771
  560783
  561892
  564254
  564263
  566187
  567148
  572214
  580771
  582459
  584688
  584703
  587251
  604700
  628654
  630915
  635490
  636579
  649240
  651937
  676354
  682303
  743906
  750704
  755170
  799941
]

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 (423568, 429782, 437488, 437686, 452418, 454365, 458182, 458791, 463625, 466493, 469118, 471979, 472496, 477373, 478108, 484944, 488821, 488822, 490068, 492688, 492921, 496650, 497865, 498205, 502453, 506862, 509666, 510157, 510220, 510572, 511802, 514659, 514808, 515956, 516215, 516635, 519346, 521495, 521852, 523793, 524235, 528597, 529290, 531278, 542053, 542056, 543392, 546771, 560783, 561892, 564254, 564263, 566187, 567148, 572214, 580771, 582459, 584688, 584703, 587251, 604700, 628654, 630915, 635490, 636579, 649240, 651937, 676354, 682303, 743906, 750704, 755170, 799941);

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
  423568
  429782
  437488
  437686
  452418
  454365
  458182
  458791
  463625
  466493
  469118
  471979
  472496
  477373
  478108
  484944
  488821
  488822
  490068
  492688
  492921
  496650
  497865
  498205
  502453
  506862
  509666
  510157
  510220
  510572
  511802
  514659
  514808
  515956
  516215
  516635
  519346
  521495
  521852
  523793
  524235
  528597
  529290
  531278
  542053
  542056
  543392
  546771
  560783
  561892
  564254
  564263
  566187
  567148
  572214
  580771
  582459
  584688
  584703
  587251
  604700
  628654
  630915
  635490
  636579
  649240
  651937
  676354
  682303
  743906
  750704
  755170
  799941
]

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 (423568, 429782, 437488, 437686, 452418, 454365, 458182, 458791, 463625, 466493, 469118, 471979, 472496, 477373, 478108, 484944, 488821, 488822, 490068, 492688, 492921, 496650, 497865, 498205, 502453, 506862, 509666, 510157, 510220, 510572, 511802, 514659, 514808, 515956, 516215, 516635, 519346, 521495, 521852, 523793, 524235, 528597, 529290, 531278, 542053, 542056, 543392, 546771, 560783, 561892, 564254, 564263, 566187, 567148, 572214, 580771, 582459, 584688, 584703, 587251, 604700, 628654, 630915, 635490, 636579, 649240, 651937, 676354, 682303, 743906, 750704, 755170, 799941);

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

[
  "любительск sharing"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск sharing';

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

[
  "любительск sharing"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск sharing';

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 ?

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