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

[
  "girl play pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girl play pussy' 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
  781857
  424524
  570062
  619221
  483583
  526100
  559521
  588876
  452756
  463496
  551902
  644186
  610666
  454981
  545965
  714508
  418720
  423844
  464725
  583209
  642504
  448289
  521244
  493851
  506142
  525727
  532893
  602578
  586686
  460540
  489971
  500365
  624281
  514309
  581320
  456661
  492515
  559779
  679121
  464703
  425903
  606935
  446796
  456665
  568404
  428174
  531519
  507787
  554775
  415745
  588943
  418213
  603403
  814175
  537455
  557207
  443138
  518179
  619747
  431365
  527377
  464960
  602063
  519208
  507670
  513901
  726543
  471951
  519771
  581873
  626616
  567771
  582531
  524535
  578179
  480707
  592988
  436178
  510433
  565541
]

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 (781857, 424524, 570062, 619221, 483583, 526100, 559521, 588876, 452756, 463496, 551902, 644186, 610666, 454981, 545965, 714508, 418720, 423844, 464725, 583209, 642504, 448289, 521244, 493851, 506142, 525727, 532893, 602578, 586686, 460540, 489971, 500365, 624281, 514309, 581320, 456661, 492515, 559779, 679121, 464703, 425903, 606935, 446796, 456665, 568404, 428174, 531519, 507787, 554775, 415745, 588943, 418213, 603403, 814175, 537455, 557207, 443138, 518179, 619747, 431365, 527377, 464960, 602063, 519208, 507670, 513901, 726543, 471951, 519771, 581873, 626616, 567771, 582531, 524535, 578179, 480707, 592988, 436178, 510433, 565541);

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
  415745
  418213
  418720
  423844
  424524
  425903
  428174
  431365
  436178
  443138
  446796
  448289
  452756
  454981
  456661
  456665
  460540
  463496
  464703
  464725
  464960
  471951
  480707
  483583
  489971
  492515
  493851
  500365
  506142
  507670
  507787
  510433
  513901
  514309
  518179
  519208
  519771
  521244
  524535
  525727
  526100
  527377
  531519
  532893
  537455
  545965
  551902
  554775
  557207
  559521
  559779
  565541
  567771
  568404
  570062
  578179
  581320
  581873
  582531
  583209
  586686
  588876
  588943
  592988
  602063
  602578
  603403
  606935
  610666
  619221
  619747
  624281
  626616
  642504
  644186
  679121
  714508
  726543
  781857
  814175
]

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 (415745, 418213, 418720, 423844, 424524, 425903, 428174, 431365, 436178, 443138, 446796, 448289, 452756, 454981, 456661, 456665, 460540, 463496, 464703, 464725, 464960, 471951, 480707, 483583, 489971, 492515, 493851, 500365, 506142, 507670, 507787, 510433, 513901, 514309, 518179, 519208, 519771, 521244, 524535, 525727, 526100, 527377, 531519, 532893, 537455, 545965, 551902, 554775, 557207, 559521, 559779, 565541, 567771, 568404, 570062, 578179, 581320, 581873, 582531, 583209, 586686, 588876, 588943, 592988, 602063, 602578, 603403, 606935, 610666, 619221, 619747, 624281, 626616, 642504, 644186, 679121, 714508, 726543, 781857, 814175);

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
  415745
  418213
  418720
  423844
  424524
  425903
  428174
  431365
  436178
  443138
  446796
  448289
  452756
  454981
  456661
  456665
  460540
  463496
  464703
  464725
  464960
  471951
  480707
  483583
  489971
  492515
  493851
  500365
  506142
  507670
  507787
  510433
  513901
  514309
  518179
  519208
  519771
  521244
  524535
  525727
  526100
  527377
  531519
  532893
  537455
  545965
  551902
  554775
  557207
  559521
  559779
  565541
  567771
  568404
  570062
  578179
  581320
  581873
  582531
  583209
  586686
  588876
  588943
  592988
  602063
  602578
  603403
  606935
  610666
  619221
  619747
  624281
  626616
  642504
  644186
  679121
  714508
  726543
  781857
  814175
]

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 (415745, 418213, 418720, 423844, 424524, 425903, 428174, 431365, 436178, 443138, 446796, 448289, 452756, 454981, 456661, 456665, 460540, 463496, 464703, 464725, 464960, 471951, 480707, 483583, 489971, 492515, 493851, 500365, 506142, 507670, 507787, 510433, 513901, 514309, 518179, 519208, 519771, 521244, 524535, 525727, 526100, 527377, 531519, 532893, 537455, 545965, 551902, 554775, 557207, 559521, 559779, 565541, 567771, 568404, 570062, 578179, 581320, 581873, 582531, 583209, 586686, 588876, 588943, 592988, 602063, 602578, 603403, 606935, 610666, 619221, 619747, 624281, 626616, 642504, 644186, 679121, 714508, 726543, 781857, 814175);

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

[
  "девушк play pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'девушк play pussy';

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

[
  "девушк play pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'девушк play pussy';