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

[
  "foot fetish russian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'foot fetish russian' 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
  714609
  455546
  432572
  439552
  417949
  556434
  794518
  556432
  426912
  760633
  739573
  753343
  605981
  432427
  548887
  432395
  590227
  433366
  812494
  384215
  426631
  426736
  435567
  438314
  681963
  777242
  778970
  792932
  788904
  740623
  771554
  777264
  426731
  470816
  426909
  426730
  433435
  470925
  548892
  693398
  426836
  426628
  426734
  426737
  751577
  480318
  518719
  548886
  590425
  624166
  578356
  432559
  509288
  498198
  692271
  725570
  721721
  785761
  552346
  581220
  619520
  504389
  479007
  824303
  513202
  447180
  432399
  457141
  441806
  492054
  426816
  432404
  418522
]

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 (714609, 455546, 432572, 439552, 417949, 556434, 794518, 556432, 426912, 760633, 739573, 753343, 605981, 432427, 548887, 432395, 590227, 433366, 812494, 384215, 426631, 426736, 435567, 438314, 681963, 777242, 778970, 792932, 788904, 740623, 771554, 777264, 426731, 470816, 426909, 426730, 433435, 470925, 548892, 693398, 426836, 426628, 426734, 426737, 751577, 480318, 518719, 548886, 590425, 624166, 578356, 432559, 509288, 498198, 692271, 725570, 721721, 785761, 552346, 581220, 619520, 504389, 479007, 824303, 513202, 447180, 432399, 457141, 441806, 492054, 426816, 432404, 418522);

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
  384215
  417949
  418522
  426628
  426631
  426730
  426731
  426734
  426736
  426737
  426816
  426836
  426909
  426912
  432395
  432399
  432404
  432427
  432559
  432572
  433366
  433435
  435567
  438314
  439552
  441806
  447180
  455546
  457141
  470816
  470925
  479007
  480318
  492054
  498198
  504389
  509288
  513202
  518719
  548886
  548887
  548892
  552346
  556432
  556434
  578356
  581220
  590227
  590425
  605981
  619520
  624166
  681963
  692271
  693398
  714609
  721721
  725570
  739573
  740623
  751577
  753343
  760633
  771554
  777242
  777264
  778970
  785761
  788904
  792932
  794518
  812494
  824303
]

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 (384215, 417949, 418522, 426628, 426631, 426730, 426731, 426734, 426736, 426737, 426816, 426836, 426909, 426912, 432395, 432399, 432404, 432427, 432559, 432572, 433366, 433435, 435567, 438314, 439552, 441806, 447180, 455546, 457141, 470816, 470925, 479007, 480318, 492054, 498198, 504389, 509288, 513202, 518719, 548886, 548887, 548892, 552346, 556432, 556434, 578356, 581220, 590227, 590425, 605981, 619520, 624166, 681963, 692271, 693398, 714609, 721721, 725570, 739573, 740623, 751577, 753343, 760633, 771554, 777242, 777264, 778970, 785761, 788904, 792932, 794518, 812494, 824303);

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
  384215
  417949
  418522
  426628
  426631
  426730
  426731
  426734
  426736
  426737
  426816
  426836
  426909
  426912
  432395
  432399
  432404
  432427
  432559
  432572
  433366
  433435
  435567
  438314
  439552
  441806
  447180
  455546
  457141
  470816
  470925
  479007
  480318
  492054
  498198
  504389
  509288
  513202
  518719
  548886
  548887
  548892
  552346
  556432
  556434
  578356
  581220
  590227
  590425
  605981
  619520
  624166
  681963
  692271
  693398
  714609
  721721
  725570
  739573
  740623
  751577
  753343
  760633
  771554
  777242
  777264
  778970
  785761
  788904
  792932
  794518
  812494
  824303
]

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 (384215, 417949, 418522, 426628, 426631, 426730, 426731, 426734, 426736, 426737, 426816, 426836, 426909, 426912, 432395, 432399, 432404, 432427, 432559, 432572, 433366, 433435, 435567, 438314, 439552, 441806, 447180, 455546, 457141, 470816, 470925, 479007, 480318, 492054, 498198, 504389, 509288, 513202, 518719, 548886, 548887, 548892, 552346, 556432, 556434, 578356, 581220, 590227, 590425, 605981, 619520, 624166, 681963, 692271, 693398, 714609, 721721, 725570, 739573, 740623, 751577, 753343, 760633, 771554, 777242, 777264, 778970, 785761, 788904, 792932, 794518, 812494, 824303);

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

[
  "foot фетиш русск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'foot фетиш русск';

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

[
  "foot фетиш русск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'foot фетиш русск';

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 ?

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