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

[
  "sex in hostel"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex in hostel' 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
  496117
  399568
  399192
  752155
  511828
  518901
  533061
  615428
  759329
  492312
  438715
  513872
  560204
  399587
  462824
  494339
  459389
  472230
  487067
  560198
  557544
  461211
  497362
  511159
  559953
  568039
  512088
  569926
  567521
  520814
  341675
  534385
  475304
  498033
  565539
  475045
  620612
  487518
  495694
  522016
  513901
  560211
  475033
  564564
  399209
  558414
  518108
  399591
  560212
  581095
  525622
  524388
  560202
  446977
  492279
  518768
  565542
  420659
  559950
  493420
  421214
  437810
  552198
  534296
  458327
  637729
  581112
  625167
  445672
  589107
  487072
  492267
  440625
  462415
  528788
  572886
  589048
  483223
  560205
  503840
  603954
]

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 (496117, 399568, 399192, 752155, 511828, 518901, 533061, 615428, 759329, 492312, 438715, 513872, 560204, 399587, 462824, 494339, 459389, 472230, 487067, 560198, 557544, 461211, 497362, 511159, 559953, 568039, 512088, 569926, 567521, 520814, 341675, 534385, 475304, 498033, 565539, 475045, 620612, 487518, 495694, 522016, 513901, 560211, 475033, 564564, 399209, 558414, 518108, 399591, 560212, 581095, 525622, 524388, 560202, 446977, 492279, 518768, 565542, 420659, 559950, 493420, 421214, 437810, 552198, 534296, 458327, 637729, 581112, 625167, 445672, 589107, 487072, 492267, 440625, 462415, 528788, 572886, 589048, 483223, 560205, 503840, 603954);

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
  341675
  399192
  399209
  399568
  399587
  399591
  420659
  421214
  437810
  438715
  440625
  445672
  446977
  458327
  459389
  461211
  462415
  462824
  472230
  475033
  475045
  475304
  483223
  487067
  487072
  487518
  492267
  492279
  492312
  493420
  494339
  495694
  496117
  497362
  498033
  503840
  511159
  511828
  512088
  513872
  513901
  518108
  518768
  518901
  520814
  522016
  524388
  525622
  528788
  533061
  534296
  534385
  552198
  557544
  558414
  559950
  559953
  560198
  560202
  560204
  560205
  560211
  560212
  564564
  565539
  565542
  567521
  568039
  569926
  572886
  581095
  581112
  589048
  589107
  603954
  615428
  620612
  625167
  637729
  752155
  759329
]

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 (341675, 399192, 399209, 399568, 399587, 399591, 420659, 421214, 437810, 438715, 440625, 445672, 446977, 458327, 459389, 461211, 462415, 462824, 472230, 475033, 475045, 475304, 483223, 487067, 487072, 487518, 492267, 492279, 492312, 493420, 494339, 495694, 496117, 497362, 498033, 503840, 511159, 511828, 512088, 513872, 513901, 518108, 518768, 518901, 520814, 522016, 524388, 525622, 528788, 533061, 534296, 534385, 552198, 557544, 558414, 559950, 559953, 560198, 560202, 560204, 560205, 560211, 560212, 564564, 565539, 565542, 567521, 568039, 569926, 572886, 581095, 581112, 589048, 589107, 603954, 615428, 620612, 625167, 637729, 752155, 759329);

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
  341675
  399192
  399209
  399568
  399587
  399591
  420659
  421214
  437810
  438715
  440625
  445672
  446977
  458327
  459389
  461211
  462415
  462824
  472230
  475033
  475045
  475304
  483223
  487067
  487072
  487518
  492267
  492279
  492312
  493420
  494339
  495694
  496117
  497362
  498033
  503840
  511159
  511828
  512088
  513872
  513901
  518108
  518768
  518901
  520814
  522016
  524388
  525622
  528788
  533061
  534296
  534385
  552198
  557544
  558414
  559950
  559953
  560198
  560202
  560204
  560205
  560211
  560212
  564564
  565539
  565542
  567521
  568039
  569926
  572886
  581095
  581112
  589048
  589107
  603954
  615428
  620612
  625167
  637729
  752155
  759329
]

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 (341675, 399192, 399209, 399568, 399587, 399591, 420659, 421214, 437810, 438715, 440625, 445672, 446977, 458327, 459389, 461211, 462415, 462824, 472230, 475033, 475045, 475304, 483223, 487067, 487072, 487518, 492267, 492279, 492312, 493420, 494339, 495694, 496117, 497362, 498033, 503840, 511159, 511828, 512088, 513872, 513901, 518108, 518768, 518901, 520814, 522016, 524388, 525622, 528788, 533061, 534296, 534385, 552198, 557544, 558414, 559950, 559953, 560198, 560202, 560204, 560205, 560211, 560212, 564564, 565539, 565542, 567521, 568039, 569926, 572886, 581095, 581112, 589048, 589107, 603954, 615428, 620612, 625167, 637729, 752155, 759329);

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

[
  "секс hostel"
]

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

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

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

[
  "секс hostel"
]

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

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