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

[
  "public naked skirt"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'public naked skirt' 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
  397464
  580866
  621112
  462320
  571889
  581987
  596894
  603378
  517574
  690333
  446170
  568293
  477503
  439291
  482914
  528465
  496054
  520567
  523995
  551913
  597575
  497666
  465663
  570359
  530637
  434601
  564456
  425667
  559740
  662046
  467541
  484417
  382199
  401233
  404555
  411664
  470468
  451801
  598294
  452687
  468679
  594231
  523242
  618825
  599761
  542187
  642662
  548565
  599883
  426762
  502280
  521885
  529065
  466185
  471481
  523428
  533973
  510557
  571696
  472169
  529312
  509454
  514600
  625524
  569257
  407418
  394198
  491989
  449734
  472230
  468884
  671104
  563418
  571847
  584484
  597542
  548708
  670951
  565740
  618797
  453409
  540153
  657775
  556405
  486400
  624779
]

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 (397464, 580866, 621112, 462320, 571889, 581987, 596894, 603378, 517574, 690333, 446170, 568293, 477503, 439291, 482914, 528465, 496054, 520567, 523995, 551913, 597575, 497666, 465663, 570359, 530637, 434601, 564456, 425667, 559740, 662046, 467541, 484417, 382199, 401233, 404555, 411664, 470468, 451801, 598294, 452687, 468679, 594231, 523242, 618825, 599761, 542187, 642662, 548565, 599883, 426762, 502280, 521885, 529065, 466185, 471481, 523428, 533973, 510557, 571696, 472169, 529312, 509454, 514600, 625524, 569257, 407418, 394198, 491989, 449734, 472230, 468884, 671104, 563418, 571847, 584484, 597542, 548708, 670951, 565740, 618797, 453409, 540153, 657775, 556405, 486400, 624779);

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
  382199
  394198
  397464
  401233
  404555
  407418
  411664
  425667
  426762
  434601
  439291
  446170
  449734
  451801
  452687
  453409
  462320
  465663
  466185
  467541
  468679
  468884
  470468
  471481
  472169
  472230
  477503
  482914
  484417
  486400
  491989
  496054
  497666
  502280
  509454
  510557
  514600
  517574
  520567
  521885
  523242
  523428
  523995
  528465
  529065
  529312
  530637
  533973
  540153
  542187
  548565
  548708
  551913
  556405
  559740
  563418
  564456
  565740
  568293
  569257
  570359
  571696
  571847
  571889
  580866
  581987
  584484
  594231
  596894
  597542
  597575
  598294
  599761
  599883
  603378
  618797
  618825
  621112
  624779
  625524
  642662
  657775
  662046
  670951
  671104
  690333
]

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 (382199, 394198, 397464, 401233, 404555, 407418, 411664, 425667, 426762, 434601, 439291, 446170, 449734, 451801, 452687, 453409, 462320, 465663, 466185, 467541, 468679, 468884, 470468, 471481, 472169, 472230, 477503, 482914, 484417, 486400, 491989, 496054, 497666, 502280, 509454, 510557, 514600, 517574, 520567, 521885, 523242, 523428, 523995, 528465, 529065, 529312, 530637, 533973, 540153, 542187, 548565, 548708, 551913, 556405, 559740, 563418, 564456, 565740, 568293, 569257, 570359, 571696, 571847, 571889, 580866, 581987, 584484, 594231, 596894, 597542, 597575, 598294, 599761, 599883, 603378, 618797, 618825, 621112, 624779, 625524, 642662, 657775, 662046, 670951, 671104, 690333);

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
  382199
  394198
  397464
  401233
  404555
  407418
  411664
  425667
  426762
  434601
  439291
  446170
  449734
  451801
  452687
  453409
  462320
  465663
  466185
  467541
  468679
  468884
  470468
  471481
  472169
  472230
  477503
  482914
  484417
  486400
  491989
  496054
  497666
  502280
  509454
  510557
  514600
  517574
  520567
  521885
  523242
  523428
  523995
  528465
  529065
  529312
  530637
  533973
  540153
  542187
  548565
  548708
  551913
  556405
  559740
  563418
  564456
  565740
  568293
  569257
  570359
  571696
  571847
  571889
  580866
  581987
  584484
  594231
  596894
  597542
  597575
  598294
  599761
  599883
  603378
  618797
  618825
  621112
  624779
  625524
  642662
  657775
  662046
  670951
  671104
  690333
]

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 (382199, 394198, 397464, 401233, 404555, 407418, 411664, 425667, 426762, 434601, 439291, 446170, 449734, 451801, 452687, 453409, 462320, 465663, 466185, 467541, 468679, 468884, 470468, 471481, 472169, 472230, 477503, 482914, 484417, 486400, 491989, 496054, 497666, 502280, 509454, 510557, 514600, 517574, 520567, 521885, 523242, 523428, 523995, 528465, 529065, 529312, 530637, 533973, 540153, 542187, 548565, 548708, 551913, 556405, 559740, 563418, 564456, 565740, 568293, 569257, 570359, 571696, 571847, 571889, 580866, 581987, 584484, 594231, 596894, 597542, 597575, 598294, 599761, 599883, 603378, 618797, 618825, 621112, 624779, 625524, 642662, 657775, 662046, 670951, 671104, 690333);

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` = 'на улиц голые юбк';