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

[
  "молодёжь сисястая агент"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'молодёжь сисястая агент' 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
  598646
  594868
  556022
  452221
  482138
  497915
  471716
  533799
  485675
  456633
  500767
  513087
  527568
  478533
  432775
  495606
  473056
  497368
  473218
  580589
  559719
  609874
  546864
  576399
  474553
  522197
  450775
  425720
  457419
  577601
  601084
  425706
  605105
  596658
  550343
  443320
  620882
  618442
  577326
  486018
  561699
  601327
  543616
  564675
  604541
  618525
  518996
  621407
  580766
  609880
  457159
  585181
  520632
  474744
  595500
  595381
  556036
  526361
  581117
  525026
  507177
  519842
  504376
  506338
  620205
  620546
  487703
  589041
  524542
  598263
  515793
  654109
  661926
  600535
  486934
  465234
  560564
  415419
  614080
  602972
]

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 (598646, 594868, 556022, 452221, 482138, 497915, 471716, 533799, 485675, 456633, 500767, 513087, 527568, 478533, 432775, 495606, 473056, 497368, 473218, 580589, 559719, 609874, 546864, 576399, 474553, 522197, 450775, 425720, 457419, 577601, 601084, 425706, 605105, 596658, 550343, 443320, 620882, 618442, 577326, 486018, 561699, 601327, 543616, 564675, 604541, 618525, 518996, 621407, 580766, 609880, 457159, 585181, 520632, 474744, 595500, 595381, 556036, 526361, 581117, 525026, 507177, 519842, 504376, 506338, 620205, 620546, 487703, 589041, 524542, 598263, 515793, 654109, 661926, 600535, 486934, 465234, 560564, 415419, 614080, 602972);

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
  415419
  425706
  425720
  432775
  443320
  450775
  452221
  456633
  457159
  457419
  465234
  471716
  473056
  473218
  474553
  474744
  478533
  482138
  485675
  486018
  486934
  487703
  495606
  497368
  497915
  500767
  504376
  506338
  507177
  513087
  515793
  518996
  519842
  520632
  522197
  524542
  525026
  526361
  527568
  533799
  543616
  546864
  550343
  556022
  556036
  559719
  560564
  561699
  564675
  576399
  577326
  577601
  580589
  580766
  581117
  585181
  589041
  594868
  595381
  595500
  596658
  598263
  598646
  600535
  601084
  601327
  602972
  604541
  605105
  609874
  609880
  614080
  618442
  618525
  620205
  620546
  620882
  621407
  654109
  661926
]

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 (415419, 425706, 425720, 432775, 443320, 450775, 452221, 456633, 457159, 457419, 465234, 471716, 473056, 473218, 474553, 474744, 478533, 482138, 485675, 486018, 486934, 487703, 495606, 497368, 497915, 500767, 504376, 506338, 507177, 513087, 515793, 518996, 519842, 520632, 522197, 524542, 525026, 526361, 527568, 533799, 543616, 546864, 550343, 556022, 556036, 559719, 560564, 561699, 564675, 576399, 577326, 577601, 580589, 580766, 581117, 585181, 589041, 594868, 595381, 595500, 596658, 598263, 598646, 600535, 601084, 601327, 602972, 604541, 605105, 609874, 609880, 614080, 618442, 618525, 620205, 620546, 620882, 621407, 654109, 661926);

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
  415419
  425706
  425720
  432775
  443320
  450775
  452221
  456633
  457159
  457419
  465234
  471716
  473056
  473218
  474553
  474744
  478533
  482138
  485675
  486018
  486934
  487703
  495606
  497368
  497915
  500767
  504376
  506338
  507177
  513087
  515793
  518996
  519842
  520632
  522197
  524542
  525026
  526361
  527568
  533799
  543616
  546864
  550343
  556022
  556036
  559719
  560564
  561699
  564675
  576399
  577326
  577601
  580589
  580766
  581117
  585181
  589041
  594868
  595381
  595500
  596658
  598263
  598646
  600535
  601084
  601327
  602972
  604541
  605105
  609874
  609880
  614080
  618442
  618525
  620205
  620546
  620882
  621407
  654109
  661926
]

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 (415419, 425706, 425720, 432775, 443320, 450775, 452221, 456633, 457159, 457419, 465234, 471716, 473056, 473218, 474553, 474744, 478533, 482138, 485675, 486018, 486934, 487703, 495606, 497368, 497915, 500767, 504376, 506338, 507177, 513087, 515793, 518996, 519842, 520632, 522197, 524542, 525026, 526361, 527568, 533799, 543616, 546864, 550343, 556022, 556036, 559719, 560564, 561699, 564675, 576399, 577326, 577601, 580589, 580766, 581117, 585181, 589041, 594868, 595381, 595500, 596658, 598263, 598646, 600535, 601084, 601327, 602972, 604541, 605105, 609874, 609880, 614080, 618442, 618525, 620205, 620546, 620882, 621407, 654109, 661926);

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` = 'молодые молодая девушк молодой большие сиськ агент';