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

[
  "rus oral"
]

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

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