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

[
  "hairy dildo solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy dildo solo' 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
  752653
  743634
  787336
  472835
  508378
  516574
  182206
  555565
  434309
  444322
  427364
  435562
  499388
  502559
  429899
  429862
  583774
  512491
  528452
  588411
  439171
  443171
  473533
  455979
  527476
  464959
  776864
  447025
  592975
  825324
  827143
  827724
  473055
  391473
  509983
  427480
  445787
  429879
  427112
  459761
  513615
  467923
  426295
  558132
  705424
  502467
  471012
  629799
  469198
  506057
  432350
  457577
  439428
  460015
  431234
  508807
  446038
  516718
  527624
  471976
  472706
  441876
  476932
  510905
  553441
  584118
  604918
  639338
  426399
  606762
  542987
  776212
  493022
  510425
  598649
  458008
  473391
  452797
  429890
  407442
  558176
]

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 (752653, 743634, 787336, 472835, 508378, 516574, 182206, 555565, 434309, 444322, 427364, 435562, 499388, 502559, 429899, 429862, 583774, 512491, 528452, 588411, 439171, 443171, 473533, 455979, 527476, 464959, 776864, 447025, 592975, 825324, 827143, 827724, 473055, 391473, 509983, 427480, 445787, 429879, 427112, 459761, 513615, 467923, 426295, 558132, 705424, 502467, 471012, 629799, 469198, 506057, 432350, 457577, 439428, 460015, 431234, 508807, 446038, 516718, 527624, 471976, 472706, 441876, 476932, 510905, 553441, 584118, 604918, 639338, 426399, 606762, 542987, 776212, 493022, 510425, 598649, 458008, 473391, 452797, 429890, 407442, 558176);

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
  182206
  391473
  407442
  426295
  426399
  427112
  427364
  427480
  429862
  429879
  429890
  429899
  431234
  432350
  434309
  435562
  439171
  439428
  441876
  443171
  444322
  445787
  446038
  447025
  452797
  455979
  457577
  458008
  459761
  460015
  464959
  467923
  469198
  471012
  471976
  472706
  472835
  473055
  473391
  473533
  476932
  493022
  499388
  502467
  502559
  506057
  508378
  508807
  509983
  510425
  510905
  512491
  513615
  516574
  516718
  527476
  527624
  528452
  542987
  553441
  555565
  558132
  558176
  583774
  584118
  588411
  592975
  598649
  604918
  606762
  629799
  639338
  705424
  743634
  752653
  776212
  776864
  787336
  825324
  827143
  827724
]

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 (182206, 391473, 407442, 426295, 426399, 427112, 427364, 427480, 429862, 429879, 429890, 429899, 431234, 432350, 434309, 435562, 439171, 439428, 441876, 443171, 444322, 445787, 446038, 447025, 452797, 455979, 457577, 458008, 459761, 460015, 464959, 467923, 469198, 471012, 471976, 472706, 472835, 473055, 473391, 473533, 476932, 493022, 499388, 502467, 502559, 506057, 508378, 508807, 509983, 510425, 510905, 512491, 513615, 516574, 516718, 527476, 527624, 528452, 542987, 553441, 555565, 558132, 558176, 583774, 584118, 588411, 592975, 598649, 604918, 606762, 629799, 639338, 705424, 743634, 752653, 776212, 776864, 787336, 825324, 827143, 827724);

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
  182206
  391473
  407442
  426295
  426399
  427112
  427364
  427480
  429862
  429879
  429890
  429899
  431234
  432350
  434309
  435562
  439171
  439428
  441876
  443171
  444322
  445787
  446038
  447025
  452797
  455979
  457577
  458008
  459761
  460015
  464959
  467923
  469198
  471012
  471976
  472706
  472835
  473055
  473391
  473533
  476932
  493022
  499388
  502467
  502559
  506057
  508378
  508807
  509983
  510425
  510905
  512491
  513615
  516574
  516718
  527476
  527624
  528452
  542987
  553441
  555565
  558132
  558176
  583774
  584118
  588411
  592975
  598649
  604918
  606762
  629799
  639338
  705424
  743634
  752653
  776212
  776864
  787336
  825324
  827143
  827724
]

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 (182206, 391473, 407442, 426295, 426399, 427112, 427364, 427480, 429862, 429879, 429890, 429899, 431234, 432350, 434309, 435562, 439171, 439428, 441876, 443171, 444322, 445787, 446038, 447025, 452797, 455979, 457577, 458008, 459761, 460015, 464959, 467923, 469198, 471012, 471976, 472706, 472835, 473055, 473391, 473533, 476932, 493022, 499388, 502467, 502559, 506057, 508378, 508807, 509983, 510425, 510905, 512491, 513615, 516574, 516718, 527476, 527624, 528452, 542987, 553441, 555565, 558132, 558176, 583774, 584118, 588411, 592975, 598649, 604918, 606762, 629799, 639338, 705424, 743634, 752653, 776212, 776864, 787336, 825324, 827143, 827724);

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` = 'волосатая дилд соло';