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
  534577
  714535
  737057
  785176
  804044
  716551
  384411
  814999
  485238
  753281
  807245
  542144
  809999
  576305
  668084
  544912
  786478
  557376
  707928
  811147
  513887
  614607
  708078
  775717
  784250
  785584
  757158
  623544
  555131
  520643
  719193
  680616
  684594
  705702
  750546
  631299
  574889
  564531
  480933
  547811
  552913
  797462
  531823
  612867
  792789
  741545
  742290
  810643
  537457
  566832
  580588
  562049
  626851
  810032
  527315
  720193
  553096
  493493
  569110
  498483
  580769
  422958
  598233
  530218
  486162
  474264
  513558
  787427
  446934
  522946
  470251
  580714
  552623
]

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 (534577, 714535, 737057, 785176, 804044, 716551, 384411, 814999, 485238, 753281, 807245, 542144, 809999, 576305, 668084, 544912, 786478, 557376, 707928, 811147, 513887, 614607, 708078, 775717, 784250, 785584, 757158, 623544, 555131, 520643, 719193, 680616, 684594, 705702, 750546, 631299, 574889, 564531, 480933, 547811, 552913, 797462, 531823, 612867, 792789, 741545, 742290, 810643, 537457, 566832, 580588, 562049, 626851, 810032, 527315, 720193, 553096, 493493, 569110, 498483, 580769, 422958, 598233, 530218, 486162, 474264, 513558, 787427, 446934, 522946, 470251, 580714, 552623);

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
  384411
  422958
  446934
  470251
  474264
  480933
  485238
  486162
  493493
  498483
  513558
  513887
  520643
  522946
  527315
  530218
  531823
  534577
  537457
  542144
  544912
  547811
  552623
  552913
  553096
  555131
  557376
  562049
  564531
  566832
  569110
  574889
  576305
  580588
  580714
  580769
  598233
  612867
  614607
  623544
  631299
  668084
  680616
  684594
  705702
  707928
  708078
  714535
  716551
  719193
  720193
  737057
  741545
  742290
  750546
  753281
  757158
  775717
  784250
  785176
  785584
  786478
  787427
  792789
  797462
  804044
  807245
  809999
  810032
  810643
  811147
  814999
]

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 (384411, 422958, 446934, 470251, 474264, 480933, 485238, 486162, 493493, 498483, 513558, 513887, 520643, 522946, 527315, 530218, 531823, 534577, 537457, 542144, 544912, 547811, 552623, 552913, 553096, 555131, 557376, 562049, 564531, 566832, 569110, 574889, 576305, 580588, 580714, 580769, 598233, 612867, 614607, 623544, 631299, 668084, 680616, 684594, 705702, 707928, 708078, 714535, 716551, 719193, 720193, 737057, 741545, 742290, 750546, 753281, 757158, 775717, 784250, 785176, 785584, 786478, 787427, 792789, 797462, 804044, 807245, 809999, 810032, 810643, 811147, 814999);

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
  384411
  422958
  446934
  470251
  474264
  480933
  485238
  486162
  493493
  498483
  513558
  513887
  520643
  522946
  527315
  530218
  531823
  534577
  537457
  542144
  544912
  547811
  552623
  552913
  553096
  555131
  557376
  562049
  564531
  566832
  569110
  574889
  576305
  580588
  580714
  580769
  598233
  612867
  614607
  623544
  631299
  668084
  680616
  684594
  705702
  707928
  708078
  714535
  716551
  719193
  720193
  737057
  741545
  742290
  750546
  753281
  757158
  775717
  784250
  785176
  785584
  786478
  787427
  792789
  797462
  804044
  807245
  809999
  810032
  810643
  811147
  814999
]

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 (384411, 422958, 446934, 470251, 474264, 480933, 485238, 486162, 493493, 498483, 513558, 513887, 520643, 522946, 527315, 530218, 531823, 534577, 537457, 542144, 544912, 547811, 552623, 552913, 553096, 555131, 557376, 562049, 564531, 566832, 569110, 574889, 576305, 580588, 580714, 580769, 598233, 612867, 614607, 623544, 631299, 668084, 680616, 684594, 705702, 707928, 708078, 714535, 716551, 719193, 720193, 737057, 741545, 742290, 750546, 753281, 757158, 775717, 784250, 785176, 785584, 786478, 787427, 792789, 797462, 804044, 807245, 809999, 810032, 810643, 811147, 814999);

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
        ;