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

[
  "real orgasm masturbation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real orgasm masturbation' 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
  776141
  799957
  795262
  728652
  467895
  461022
  421389
  513908
  518105
  448497
  436756
  479311
  578185
  584812
  595114
  490592
  741796
  423338
  522963
  464800
  560252
  583739
  540915
  653503
  666886
  681220
  656670
  552234
  555591
  585788
  739500
  478985
  444027
  498355
  478991
  501015
  582377
  464721
  493816
  462071
  476707
  494546
  525439
  505548
  547527
  560301
  692743
  593513
  627498
  417800
  446181
  434335
  468912
  556496
  434307
  528377
  485057
  485064
  566788
  542042
  571257
  598644
  631878
  609057
  460535
  506677
  521545
  424332
  504450
  424375
  437960
  585079
  519679
  639810
  428761
  486875
]

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 (776141, 799957, 795262, 728652, 467895, 461022, 421389, 513908, 518105, 448497, 436756, 479311, 578185, 584812, 595114, 490592, 741796, 423338, 522963, 464800, 560252, 583739, 540915, 653503, 666886, 681220, 656670, 552234, 555591, 585788, 739500, 478985, 444027, 498355, 478991, 501015, 582377, 464721, 493816, 462071, 476707, 494546, 525439, 505548, 547527, 560301, 692743, 593513, 627498, 417800, 446181, 434335, 468912, 556496, 434307, 528377, 485057, 485064, 566788, 542042, 571257, 598644, 631878, 609057, 460535, 506677, 521545, 424332, 504450, 424375, 437960, 585079, 519679, 639810, 428761, 486875);

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
  417800
  421389
  423338
  424332
  424375
  428761
  434307
  434335
  436756
  437960
  444027
  446181
  448497
  460535
  461022
  462071
  464721
  464800
  467895
  468912
  476707
  478985
  478991
  479311
  485057
  485064
  486875
  490592
  493816
  494546
  498355
  501015
  504450
  505548
  506677
  513908
  518105
  519679
  521545
  522963
  525439
  528377
  540915
  542042
  547527
  552234
  555591
  556496
  560252
  560301
  566788
  571257
  578185
  582377
  583739
  584812
  585079
  585788
  593513
  595114
  598644
  609057
  627498
  631878
  639810
  653503
  656670
  666886
  681220
  692743
  728652
  739500
  741796
  776141
  795262
  799957
]

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 (417800, 421389, 423338, 424332, 424375, 428761, 434307, 434335, 436756, 437960, 444027, 446181, 448497, 460535, 461022, 462071, 464721, 464800, 467895, 468912, 476707, 478985, 478991, 479311, 485057, 485064, 486875, 490592, 493816, 494546, 498355, 501015, 504450, 505548, 506677, 513908, 518105, 519679, 521545, 522963, 525439, 528377, 540915, 542042, 547527, 552234, 555591, 556496, 560252, 560301, 566788, 571257, 578185, 582377, 583739, 584812, 585079, 585788, 593513, 595114, 598644, 609057, 627498, 631878, 639810, 653503, 656670, 666886, 681220, 692743, 728652, 739500, 741796, 776141, 795262, 799957);

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
  417800
  421389
  423338
  424332
  424375
  428761
  434307
  434335
  436756
  437960
  444027
  446181
  448497
  460535
  461022
  462071
  464721
  464800
  467895
  468912
  476707
  478985
  478991
  479311
  485057
  485064
  486875
  490592
  493816
  494546
  498355
  501015
  504450
  505548
  506677
  513908
  518105
  519679
  521545
  522963
  525439
  528377
  540915
  542042
  547527
  552234
  555591
  556496
  560252
  560301
  566788
  571257
  578185
  582377
  583739
  584812
  585079
  585788
  593513
  595114
  598644
  609057
  627498
  631878
  639810
  653503
  656670
  666886
  681220
  692743
  728652
  739500
  741796
  776141
  795262
  799957
]

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 (417800, 421389, 423338, 424332, 424375, 428761, 434307, 434335, 436756, 437960, 444027, 446181, 448497, 460535, 461022, 462071, 464721, 464800, 467895, 468912, 476707, 478985, 478991, 479311, 485057, 485064, 486875, 490592, 493816, 494546, 498355, 501015, 504450, 505548, 506677, 513908, 518105, 519679, 521545, 522963, 525439, 528377, 540915, 542042, 547527, 552234, 555591, 556496, 560252, 560301, 566788, 571257, 578185, 582377, 583739, 584812, 585079, 585788, 593513, 595114, 598644, 609057, 627498, 631878, 639810, 653503, 656670, 666886, 681220, 692743, 728652, 739500, 741796, 776141, 795262, 799957);

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

[
  "real orgasm мастурбац"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'real orgasm мастурбац';

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

[
  "real orgasm мастурбац"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'real orgasm мастурбац';