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

[
  "russian oral sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian oral sex' 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
  421652
  476007
  494459
  516245
  475972
  466282
  522209
  522799
  455610
  452657
  447253
  470504
  486134
  502975
  570214
  469196
  572389
  415811
  572373
  504174
  518053
  422170
  414960
  437783
  449393
  390923
  444080
  451510
  502639
  517866
  562314
  546626
  421609
  476460
  488282
  497904
  449222
  497179
  624876
  503314
  524408
  452305
  492670
  519859
  557983
  525994
  434789
  446396
  437772
  427490
  598133
  552355
  541084
  477358
  484365
  476423
  452563
  551268
  448693
  481912
  436047
  679347
  520657
  616800
  456451
  428958
  590460
  595504
  513960
  598666
  451132
  570212
  670818
  597208
  570612
  586386
  559017
  586118
  486336
]

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 (421652, 476007, 494459, 516245, 475972, 466282, 522209, 522799, 455610, 452657, 447253, 470504, 486134, 502975, 570214, 469196, 572389, 415811, 572373, 504174, 518053, 422170, 414960, 437783, 449393, 390923, 444080, 451510, 502639, 517866, 562314, 546626, 421609, 476460, 488282, 497904, 449222, 497179, 624876, 503314, 524408, 452305, 492670, 519859, 557983, 525994, 434789, 446396, 437772, 427490, 598133, 552355, 541084, 477358, 484365, 476423, 452563, 551268, 448693, 481912, 436047, 679347, 520657, 616800, 456451, 428958, 590460, 595504, 513960, 598666, 451132, 570212, 670818, 597208, 570612, 586386, 559017, 586118, 486336);

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
  390923
  414960
  415811
  421609
  421652
  422170
  427490
  428958
  434789
  436047
  437772
  437783
  444080
  446396
  447253
  448693
  449222
  449393
  451132
  451510
  452305
  452563
  452657
  455610
  456451
  466282
  469196
  470504
  475972
  476007
  476423
  476460
  477358
  481912
  484365
  486134
  486336
  488282
  492670
  494459
  497179
  497904
  502639
  502975
  503314
  504174
  513960
  516245
  517866
  518053
  519859
  520657
  522209
  522799
  524408
  525994
  541084
  546626
  551268
  552355
  557983
  559017
  562314
  570212
  570214
  570612
  572373
  572389
  586118
  586386
  590460
  595504
  597208
  598133
  598666
  616800
  624876
  670818
  679347
]

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 (390923, 414960, 415811, 421609, 421652, 422170, 427490, 428958, 434789, 436047, 437772, 437783, 444080, 446396, 447253, 448693, 449222, 449393, 451132, 451510, 452305, 452563, 452657, 455610, 456451, 466282, 469196, 470504, 475972, 476007, 476423, 476460, 477358, 481912, 484365, 486134, 486336, 488282, 492670, 494459, 497179, 497904, 502639, 502975, 503314, 504174, 513960, 516245, 517866, 518053, 519859, 520657, 522209, 522799, 524408, 525994, 541084, 546626, 551268, 552355, 557983, 559017, 562314, 570212, 570214, 570612, 572373, 572389, 586118, 586386, 590460, 595504, 597208, 598133, 598666, 616800, 624876, 670818, 679347);

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
  390923
  414960
  415811
  421609
  421652
  422170
  427490
  428958
  434789
  436047
  437772
  437783
  444080
  446396
  447253
  448693
  449222
  449393
  451132
  451510
  452305
  452563
  452657
  455610
  456451
  466282
  469196
  470504
  475972
  476007
  476423
  476460
  477358
  481912
  484365
  486134
  486336
  488282
  492670
  494459
  497179
  497904
  502639
  502975
  503314
  504174
  513960
  516245
  517866
  518053
  519859
  520657
  522209
  522799
  524408
  525994
  541084
  546626
  551268
  552355
  557983
  559017
  562314
  570212
  570214
  570612
  572373
  572389
  586118
  586386
  590460
  595504
  597208
  598133
  598666
  616800
  624876
  670818
  679347
]

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 (390923, 414960, 415811, 421609, 421652, 422170, 427490, 428958, 434789, 436047, 437772, 437783, 444080, 446396, 447253, 448693, 449222, 449393, 451132, 451510, 452305, 452563, 452657, 455610, 456451, 466282, 469196, 470504, 475972, 476007, 476423, 476460, 477358, 481912, 484365, 486134, 486336, 488282, 492670, 494459, 497179, 497904, 502639, 502975, 503314, 504174, 513960, 516245, 517866, 518053, 519859, 520657, 522209, 522799, 524408, 525994, 541084, 546626, 551268, 552355, 557983, 559017, 562314, 570212, 570214, 570612, 572373, 572389, 586118, 586386, 590460, 595504, 597208, 598133, 598666, 616800, 624876, 670818, 679347);

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

[
  "русск oral секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск oral секс';

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

[
  "русск oral секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск oral секс';