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

[
  "washing sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'washing sex' 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
  727064
  455183
  465997
  470578
  451713
  460518
  473375
  570996
  504743
  542085
  499441
  535580
  582503
  764909
  504731
  647876
  554161
  799960
  487007
  521470
  555556
  756803
  459342
  520560
  521232
  570990
  651627
  552249
  584564
  665929
  456543
  457568
  510334
  506329
  521656
  476443
  463021
  570980
  602803
  615933
  421898
  494867
  570966
  596370
  426944
  522324
  588755
  496851
  570978
  455485
  535578
  505232
  560879
  669215
  421868
  443017
  511072
  549840
  521424
  447828
  447844
  455312
  535436
  415804
  605639
  504723
  476438
  554922
  561863
  596933
  586431
  624340
  557570
]

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 (727064, 455183, 465997, 470578, 451713, 460518, 473375, 570996, 504743, 542085, 499441, 535580, 582503, 764909, 504731, 647876, 554161, 799960, 487007, 521470, 555556, 756803, 459342, 520560, 521232, 570990, 651627, 552249, 584564, 665929, 456543, 457568, 510334, 506329, 521656, 476443, 463021, 570980, 602803, 615933, 421898, 494867, 570966, 596370, 426944, 522324, 588755, 496851, 570978, 455485, 535578, 505232, 560879, 669215, 421868, 443017, 511072, 549840, 521424, 447828, 447844, 455312, 535436, 415804, 605639, 504723, 476438, 554922, 561863, 596933, 586431, 624340, 557570);

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
  415804
  421868
  421898
  426944
  443017
  447828
  447844
  451713
  455183
  455312
  455485
  456543
  457568
  459342
  460518
  463021
  465997
  470578
  473375
  476438
  476443
  487007
  494867
  496851
  499441
  504723
  504731
  504743
  505232
  506329
  510334
  511072
  520560
  521232
  521424
  521470
  521656
  522324
  535436
  535578
  535580
  542085
  549840
  552249
  554161
  554922
  555556
  557570
  560879
  561863
  570966
  570978
  570980
  570990
  570996
  582503
  584564
  586431
  588755
  596370
  596933
  602803
  605639
  615933
  624340
  647876
  651627
  665929
  669215
  727064
  756803
  764909
  799960
]

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 (415804, 421868, 421898, 426944, 443017, 447828, 447844, 451713, 455183, 455312, 455485, 456543, 457568, 459342, 460518, 463021, 465997, 470578, 473375, 476438, 476443, 487007, 494867, 496851, 499441, 504723, 504731, 504743, 505232, 506329, 510334, 511072, 520560, 521232, 521424, 521470, 521656, 522324, 535436, 535578, 535580, 542085, 549840, 552249, 554161, 554922, 555556, 557570, 560879, 561863, 570966, 570978, 570980, 570990, 570996, 582503, 584564, 586431, 588755, 596370, 596933, 602803, 605639, 615933, 624340, 647876, 651627, 665929, 669215, 727064, 756803, 764909, 799960);

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
  415804
  421868
  421898
  426944
  443017
  447828
  447844
  451713
  455183
  455312
  455485
  456543
  457568
  459342
  460518
  463021
  465997
  470578
  473375
  476438
  476443
  487007
  494867
  496851
  499441
  504723
  504731
  504743
  505232
  506329
  510334
  511072
  520560
  521232
  521424
  521470
  521656
  522324
  535436
  535578
  535580
  542085
  549840
  552249
  554161
  554922
  555556
  557570
  560879
  561863
  570966
  570978
  570980
  570990
  570996
  582503
  584564
  586431
  588755
  596370
  596933
  602803
  605639
  615933
  624340
  647876
  651627
  665929
  669215
  727064
  756803
  764909
  799960
]

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 (415804, 421868, 421898, 426944, 443017, 447828, 447844, 451713, 455183, 455312, 455485, 456543, 457568, 459342, 460518, 463021, 465997, 470578, 473375, 476438, 476443, 487007, 494867, 496851, 499441, 504723, 504731, 504743, 505232, 506329, 510334, 511072, 520560, 521232, 521424, 521470, 521656, 522324, 535436, 535578, 535580, 542085, 549840, 552249, 554161, 554922, 555556, 557570, 560879, 561863, 570966, 570978, 570980, 570990, 570996, 582503, 584564, 586431, 588755, 596370, 596933, 602803, 605639, 615933, 624340, 647876, 651627, 665929, 669215, 727064, 756803, 764909, 799960);

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

[
  "washing секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'washing секс';

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

[
  "washing секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'washing секс';

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 ?

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