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

[
  "busty blowjob amateur"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'busty blowjob amateur' 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
  435942
  569100
  491784
  595595
  604865
  484283
  486302
  527942
  492374
  444884
  519904
  477239
  428157
  623202
  801471
  587209
  502743
  474483
  479343
  594228
  447959
  595041
  521063
  413806
  526367
  408262
  728288
  568848
  548311
  486877
  407571
  519914
  585181
  420391
  486871
  506619
  424360
  520954
  519345
  623622
  414771
  501641
  526811
  593292
  519909
  561328
  623618
  471446
  528181
  620499
  409001
  572344
  543881
  530777
  507658
  551087
  598604
  571428
  584634
  527087
  457103
  565153
  494492
  601356
  618442
  578326
  611558
  549736
  561478
  621764
  587248
  488398
  621330
  476907
  559233
]

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 (435942, 569100, 491784, 595595, 604865, 484283, 486302, 527942, 492374, 444884, 519904, 477239, 428157, 623202, 801471, 587209, 502743, 474483, 479343, 594228, 447959, 595041, 521063, 413806, 526367, 408262, 728288, 568848, 548311, 486877, 407571, 519914, 585181, 420391, 486871, 506619, 424360, 520954, 519345, 623622, 414771, 501641, 526811, 593292, 519909, 561328, 623618, 471446, 528181, 620499, 409001, 572344, 543881, 530777, 507658, 551087, 598604, 571428, 584634, 527087, 457103, 565153, 494492, 601356, 618442, 578326, 611558, 549736, 561478, 621764, 587248, 488398, 621330, 476907, 559233);

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
  407571
  408262
  409001
  413806
  414771
  420391
  424360
  428157
  435942
  444884
  447959
  457103
  471446
  474483
  476907
  477239
  479343
  484283
  486302
  486871
  486877
  488398
  491784
  492374
  494492
  501641
  502743
  506619
  507658
  519345
  519904
  519909
  519914
  520954
  521063
  526367
  526811
  527087
  527942
  528181
  530777
  543881
  548311
  549736
  551087
  559233
  561328
  561478
  565153
  568848
  569100
  571428
  572344
  578326
  584634
  585181
  587209
  587248
  593292
  594228
  595041
  595595
  598604
  601356
  604865
  611558
  618442
  620499
  621330
  621764
  623202
  623618
  623622
  728288
  801471
]

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 (407571, 408262, 409001, 413806, 414771, 420391, 424360, 428157, 435942, 444884, 447959, 457103, 471446, 474483, 476907, 477239, 479343, 484283, 486302, 486871, 486877, 488398, 491784, 492374, 494492, 501641, 502743, 506619, 507658, 519345, 519904, 519909, 519914, 520954, 521063, 526367, 526811, 527087, 527942, 528181, 530777, 543881, 548311, 549736, 551087, 559233, 561328, 561478, 565153, 568848, 569100, 571428, 572344, 578326, 584634, 585181, 587209, 587248, 593292, 594228, 595041, 595595, 598604, 601356, 604865, 611558, 618442, 620499, 621330, 621764, 623202, 623618, 623622, 728288, 801471);

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
  407571
  408262
  409001
  413806
  414771
  420391
  424360
  428157
  435942
  444884
  447959
  457103
  471446
  474483
  476907
  477239
  479343
  484283
  486302
  486871
  486877
  488398
  491784
  492374
  494492
  501641
  502743
  506619
  507658
  519345
  519904
  519909
  519914
  520954
  521063
  526367
  526811
  527087
  527942
  528181
  530777
  543881
  548311
  549736
  551087
  559233
  561328
  561478
  565153
  568848
  569100
  571428
  572344
  578326
  584634
  585181
  587209
  587248
  593292
  594228
  595041
  595595
  598604
  601356
  604865
  611558
  618442
  620499
  621330
  621764
  623202
  623618
  623622
  728288
  801471
]

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 (407571, 408262, 409001, 413806, 414771, 420391, 424360, 428157, 435942, 444884, 447959, 457103, 471446, 474483, 476907, 477239, 479343, 484283, 486302, 486871, 486877, 488398, 491784, 492374, 494492, 501641, 502743, 506619, 507658, 519345, 519904, 519909, 519914, 520954, 521063, 526367, 526811, 527087, 527942, 528181, 530777, 543881, 548311, 549736, 551087, 559233, 561328, 561478, 565153, 568848, 569100, 571428, 572344, 578326, 584634, 585181, 587209, 587248, 593292, 594228, 595041, 595595, 598604, 601356, 604865, 611558, 618442, 620499, 621330, 621764, 623202, 623618, 623622, 728288, 801471);

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

[
  "busty минет оральн секс любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'busty минет оральн секс любительск';

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

[
  "busty минет оральн секс любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'busty минет оральн секс любительск';