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

[
  "holes anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'holes anal' 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
  436932
  526752
  569132
  668526
  678135
  637116
  607321
  806580
  633799
  635220
  636309
  701337
  716892
  396087
  424401
  424682
  522913
  387363
  484970
  501480
  564563
  681554
  566782
  597902
  607398
  468035
  474639
  517567
  515896
  519563
  583706
  629950
  516373
  743514
  90718
  604375
  565259
  583508
  670951
  678143
  716901
  584515
  633736
  635900
  627808
  633446
  634856
  474633
  520775
  581433
  519592
  586933
  492525
  524628
  584887
  625437
  603102
  564366
  541832
  421570
  571834
  623413
  613169
  521453
  452263
  565276
  583723
  624247
  488559
  530637
  622778
  617423
  525608
  669409
  502884
  527915
  613515
  649185
  522878
  550633
  577392
  419609
  470100
]

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 (436932, 526752, 569132, 668526, 678135, 637116, 607321, 806580, 633799, 635220, 636309, 701337, 716892, 396087, 424401, 424682, 522913, 387363, 484970, 501480, 564563, 681554, 566782, 597902, 607398, 468035, 474639, 517567, 515896, 519563, 583706, 629950, 516373, 743514, 90718, 604375, 565259, 583508, 670951, 678143, 716901, 584515, 633736, 635900, 627808, 633446, 634856, 474633, 520775, 581433, 519592, 586933, 492525, 524628, 584887, 625437, 603102, 564366, 541832, 421570, 571834, 623413, 613169, 521453, 452263, 565276, 583723, 624247, 488559, 530637, 622778, 617423, 525608, 669409, 502884, 527915, 613515, 649185, 522878, 550633, 577392, 419609, 470100);

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
  90718
  387363
  396087
  419609
  421570
  424401
  424682
  436932
  452263
  468035
  470100
  474633
  474639
  484970
  488559
  492525
  501480
  502884
  515896
  516373
  517567
  519563
  519592
  520775
  521453
  522878
  522913
  524628
  525608
  526752
  527915
  530637
  541832
  550633
  564366
  564563
  565259
  565276
  566782
  569132
  571834
  577392
  581433
  583508
  583706
  583723
  584515
  584887
  586933
  597902
  603102
  604375
  607321
  607398
  613169
  613515
  617423
  622778
  623413
  624247
  625437
  627808
  629950
  633446
  633736
  633799
  634856
  635220
  635900
  636309
  637116
  649185
  668526
  669409
  670951
  678135
  678143
  681554
  701337
  716892
  716901
  743514
  806580
]

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 (90718, 387363, 396087, 419609, 421570, 424401, 424682, 436932, 452263, 468035, 470100, 474633, 474639, 484970, 488559, 492525, 501480, 502884, 515896, 516373, 517567, 519563, 519592, 520775, 521453, 522878, 522913, 524628, 525608, 526752, 527915, 530637, 541832, 550633, 564366, 564563, 565259, 565276, 566782, 569132, 571834, 577392, 581433, 583508, 583706, 583723, 584515, 584887, 586933, 597902, 603102, 604375, 607321, 607398, 613169, 613515, 617423, 622778, 623413, 624247, 625437, 627808, 629950, 633446, 633736, 633799, 634856, 635220, 635900, 636309, 637116, 649185, 668526, 669409, 670951, 678135, 678143, 681554, 701337, 716892, 716901, 743514, 806580);

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
  90718
  387363
  396087
  419609
  421570
  424401
  424682
  436932
  452263
  468035
  470100
  474633
  474639
  484970
  488559
  492525
  501480
  502884
  515896
  516373
  517567
  519563
  519592
  520775
  521453
  522878
  522913
  524628
  525608
  526752
  527915
  530637
  541832
  550633
  564366
  564563
  565259
  565276
  566782
  569132
  571834
  577392
  581433
  583508
  583706
  583723
  584515
  584887
  586933
  597902
  603102
  604375
  607321
  607398
  613169
  613515
  617423
  622778
  623413
  624247
  625437
  627808
  629950
  633446
  633736
  633799
  634856
  635220
  635900
  636309
  637116
  649185
  668526
  669409
  670951
  678135
  678143
  681554
  701337
  716892
  716901
  743514
  806580
]

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 (90718, 387363, 396087, 419609, 421570, 424401, 424682, 436932, 452263, 468035, 470100, 474633, 474639, 484970, 488559, 492525, 501480, 502884, 515896, 516373, 517567, 519563, 519592, 520775, 521453, 522878, 522913, 524628, 525608, 526752, 527915, 530637, 541832, 550633, 564366, 564563, 565259, 565276, 566782, 569132, 571834, 577392, 581433, 583508, 583706, 583723, 584515, 584887, 586933, 597902, 603102, 604375, 607321, 607398, 613169, 613515, 617423, 622778, 623413, 624247, 625437, 627808, 629950, 633446, 633736, 633799, 634856, 635220, 635900, 636309, 637116, 649185, 668526, 669409, 670951, 678135, 678143, 681554, 701337, 716892, 716901, 743514, 806580);

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

[
  "holes анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'holes анал';

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

[
  "holes анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'holes анал';