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

[
  "extreme facesitting"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'extreme facesitting' 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
  538242
  475900
  557949
  570426
  568041
  649498
  650783
  683262
  565251
  587254
  809466
  479191
  543848
  390519
  420416
  453161
  465307
  475304
  528635
  481789
  575806
  683438
  564205
  624502
  606387
  634765
  644669
  775958
  453650
  419860
  470344
  515136
  511733
  609929
  428657
  454191
  476123
  484129
  485086
  520327
  510225
  558904
  647877
  428958
  501226
  491200
  677921
  503840
  437810
  541889
  716220
  578300
  605298
  739535
  468652
  484130
  485147
  723127
  447810
  576089
  557985
  560227
  647975
  673661
  632020
  477359
  421164
  515122
  695123
  647837
  607442
  497921
  579367
]

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 (538242, 475900, 557949, 570426, 568041, 649498, 650783, 683262, 565251, 587254, 809466, 479191, 543848, 390519, 420416, 453161, 465307, 475304, 528635, 481789, 575806, 683438, 564205, 624502, 606387, 634765, 644669, 775958, 453650, 419860, 470344, 515136, 511733, 609929, 428657, 454191, 476123, 484129, 485086, 520327, 510225, 558904, 647877, 428958, 501226, 491200, 677921, 503840, 437810, 541889, 716220, 578300, 605298, 739535, 468652, 484130, 485147, 723127, 447810, 576089, 557985, 560227, 647975, 673661, 632020, 477359, 421164, 515122, 695123, 647837, 607442, 497921, 579367);

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
  390519
  419860
  420416
  421164
  428657
  428958
  437810
  447810
  453161
  453650
  454191
  465307
  468652
  470344
  475304
  475900
  476123
  477359
  479191
  481789
  484129
  484130
  485086
  485147
  491200
  497921
  501226
  503840
  510225
  511733
  515122
  515136
  520327
  528635
  538242
  541889
  543848
  557949
  557985
  558904
  560227
  564205
  565251
  568041
  570426
  575806
  576089
  578300
  579367
  587254
  605298
  606387
  607442
  609929
  624502
  632020
  634765
  644669
  647837
  647877
  647975
  649498
  650783
  673661
  677921
  683262
  683438
  695123
  716220
  723127
  739535
  775958
  809466
]

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 (390519, 419860, 420416, 421164, 428657, 428958, 437810, 447810, 453161, 453650, 454191, 465307, 468652, 470344, 475304, 475900, 476123, 477359, 479191, 481789, 484129, 484130, 485086, 485147, 491200, 497921, 501226, 503840, 510225, 511733, 515122, 515136, 520327, 528635, 538242, 541889, 543848, 557949, 557985, 558904, 560227, 564205, 565251, 568041, 570426, 575806, 576089, 578300, 579367, 587254, 605298, 606387, 607442, 609929, 624502, 632020, 634765, 644669, 647837, 647877, 647975, 649498, 650783, 673661, 677921, 683262, 683438, 695123, 716220, 723127, 739535, 775958, 809466);

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
  390519
  419860
  420416
  421164
  428657
  428958
  437810
  447810
  453161
  453650
  454191
  465307
  468652
  470344
  475304
  475900
  476123
  477359
  479191
  481789
  484129
  484130
  485086
  485147
  491200
  497921
  501226
  503840
  510225
  511733
  515122
  515136
  520327
  528635
  538242
  541889
  543848
  557949
  557985
  558904
  560227
  564205
  565251
  568041
  570426
  575806
  576089
  578300
  579367
  587254
  605298
  606387
  607442
  609929
  624502
  632020
  634765
  644669
  647837
  647877
  647975
  649498
  650783
  673661
  677921
  683262
  683438
  695123
  716220
  723127
  739535
  775958
  809466
]

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 (390519, 419860, 420416, 421164, 428657, 428958, 437810, 447810, 453161, 453650, 454191, 465307, 468652, 470344, 475304, 475900, 476123, 477359, 479191, 481789, 484129, 484130, 485086, 485147, 491200, 497921, 501226, 503840, 510225, 511733, 515122, 515136, 520327, 528635, 538242, 541889, 543848, 557949, 557985, 558904, 560227, 564205, 565251, 568041, 570426, 575806, 576089, 578300, 579367, 587254, 605298, 606387, 607442, 609929, 624502, 632020, 634765, 644669, 647837, 647877, 647975, 649498, 650783, 673661, 677921, 683262, 683438, 695123, 716220, 723127, 739535, 775958, 809466);

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` = 'хардкор фейсситтинг';