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

[
  "asian mmf"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'asian mmf' 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
  565471
  475915
  606674
  483581
  550781
  482824
  469520
  529855
  609991
  662197
  97688
  584008
  647311
  16883
  809459
  748528
  464943
  606910
  742484
  405174
  541337
  809157
  545602
  559921
  421520
  528149
  510589
  468536
  490785
  543420
  572735
  722776
  456629
  606375
  810840
  517749
  776206
  812795
  619439
  789011
  510576
  586886
  425435
  551989
  632084
  423267
  556421
  616328
  636286
  566908
  790754
  765604
  604191
  619446
  536681
  511336
  468666
  383391
  720056
  541885
  583936
  648937
  650380
  424876
  544281
  609121
  492215
  597239
  628117
  446505
  522977
  595761
  525244
  541774
  515131
  429425
  553280
]

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 (565471, 475915, 606674, 483581, 550781, 482824, 469520, 529855, 609991, 662197, 97688, 584008, 647311, 16883, 809459, 748528, 464943, 606910, 742484, 405174, 541337, 809157, 545602, 559921, 421520, 528149, 510589, 468536, 490785, 543420, 572735, 722776, 456629, 606375, 810840, 517749, 776206, 812795, 619439, 789011, 510576, 586886, 425435, 551989, 632084, 423267, 556421, 616328, 636286, 566908, 790754, 765604, 604191, 619446, 536681, 511336, 468666, 383391, 720056, 541885, 583936, 648937, 650380, 424876, 544281, 609121, 492215, 597239, 628117, 446505, 522977, 595761, 525244, 541774, 515131, 429425, 553280);

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
  16883
  97688
  383391
  405174
  421520
  423267
  424876
  425435
  429425
  446505
  456629
  464943
  468536
  468666
  469520
  475915
  482824
  483581
  490785
  492215
  510576
  510589
  511336
  515131
  517749
  522977
  525244
  528149
  529855
  536681
  541337
  541774
  541885
  543420
  544281
  545602
  550781
  551989
  553280
  556421
  559921
  565471
  566908
  572735
  583936
  584008
  586886
  595761
  597239
  604191
  606375
  606674
  606910
  609121
  609991
  616328
  619439
  619446
  628117
  632084
  636286
  647311
  648937
  650380
  662197
  720056
  722776
  742484
  748528
  765604
  776206
  789011
  790754
  809157
  809459
  810840
  812795
]

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 (16883, 97688, 383391, 405174, 421520, 423267, 424876, 425435, 429425, 446505, 456629, 464943, 468536, 468666, 469520, 475915, 482824, 483581, 490785, 492215, 510576, 510589, 511336, 515131, 517749, 522977, 525244, 528149, 529855, 536681, 541337, 541774, 541885, 543420, 544281, 545602, 550781, 551989, 553280, 556421, 559921, 565471, 566908, 572735, 583936, 584008, 586886, 595761, 597239, 604191, 606375, 606674, 606910, 609121, 609991, 616328, 619439, 619446, 628117, 632084, 636286, 647311, 648937, 650380, 662197, 720056, 722776, 742484, 748528, 765604, 776206, 789011, 790754, 809157, 809459, 810840, 812795);

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
  16883
  97688
  383391
  405174
  421520
  423267
  424876
  425435
  429425
  446505
  456629
  464943
  468536
  468666
  469520
  475915
  482824
  483581
  490785
  492215
  510576
  510589
  511336
  515131
  517749
  522977
  525244
  528149
  529855
  536681
  541337
  541774
  541885
  543420
  544281
  545602
  550781
  551989
  553280
  556421
  559921
  565471
  566908
  572735
  583936
  584008
  586886
  595761
  597239
  604191
  606375
  606674
  606910
  609121
  609991
  616328
  619439
  619446
  628117
  632084
  636286
  647311
  648937
  650380
  662197
  720056
  722776
  742484
  748528
  765604
  776206
  789011
  790754
  809157
  809459
  810840
  812795
]

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 (16883, 97688, 383391, 405174, 421520, 423267, 424876, 425435, 429425, 446505, 456629, 464943, 468536, 468666, 469520, 475915, 482824, 483581, 490785, 492215, 510576, 510589, 511336, 515131, 517749, 522977, 525244, 528149, 529855, 536681, 541337, 541774, 541885, 543420, 544281, 545602, 550781, 551989, 553280, 556421, 559921, 565471, 566908, 572735, 583936, 584008, 586886, 595761, 597239, 604191, 606375, 606674, 606910, 609121, 609991, 616328, 619439, 619446, 628117, 632084, 636286, 647311, 648937, 650380, 662197, 720056, 722776, 742484, 748528, 765604, 776206, 789011, 790754, 809157, 809459, 810840, 812795);

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` = 'азиатк мжм секс втро';