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

[
  "anal dildo sexmachine"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal dildo sexmachine' 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
  766825
  752453
  642219
  433001
  560902
  545390
  452826
  720287
  615022
  513221
  432296
  652223
  517710
  494492
  513223
  432936
  450357
  413406
  532940
  651062
  576125
  806384
  724264
  788776
  765668
  432268
  806413
  499922
  549538
  420116
  415859
  438464
  433002
  540348
  550672
  738503
  434371
  443246
  532739
  413398
  476176
  700685
  606549
  783486
  640948
  405683
  526167
  602614
  541839
  434337
  480475
  464959
  744939
  418126
  475414
  785267
  458770
  549514
  381830
  530387
  534381
  434374
  434364
  486763
  511376
  454009
  595165
  599852
  410683
  501958
  494006
  499789
  542904
  617418
  716394
  469198
  535084
  509800
  625660
  466443
  576219
  456705
  591217
  421366
  542549
  444924
  455901
  514404
]

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 (766825, 752453, 642219, 433001, 560902, 545390, 452826, 720287, 615022, 513221, 432296, 652223, 517710, 494492, 513223, 432936, 450357, 413406, 532940, 651062, 576125, 806384, 724264, 788776, 765668, 432268, 806413, 499922, 549538, 420116, 415859, 438464, 433002, 540348, 550672, 738503, 434371, 443246, 532739, 413398, 476176, 700685, 606549, 783486, 640948, 405683, 526167, 602614, 541839, 434337, 480475, 464959, 744939, 418126, 475414, 785267, 458770, 549514, 381830, 530387, 534381, 434374, 434364, 486763, 511376, 454009, 595165, 599852, 410683, 501958, 494006, 499789, 542904, 617418, 716394, 469198, 535084, 509800, 625660, 466443, 576219, 456705, 591217, 421366, 542549, 444924, 455901, 514404);

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
  381830
  405683
  410683
  413398
  413406
  415859
  418126
  420116
  421366
  432268
  432296
  432936
  433001
  433002
  434337
  434364
  434371
  434374
  438464
  443246
  444924
  450357
  452826
  454009
  455901
  456705
  458770
  464959
  466443
  469198
  475414
  476176
  480475
  486763
  494006
  494492
  499789
  499922
  501958
  509800
  511376
  513221
  513223
  514404
  517710
  526167
  530387
  532739
  532940
  534381
  535084
  540348
  541839
  542549
  542904
  545390
  549514
  549538
  550672
  560902
  576125
  576219
  591217
  595165
  599852
  602614
  606549
  615022
  617418
  625660
  640948
  642219
  651062
  652223
  700685
  716394
  720287
  724264
  738503
  744939
  752453
  765668
  766825
  783486
  785267
  788776
  806384
  806413
]

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 (381830, 405683, 410683, 413398, 413406, 415859, 418126, 420116, 421366, 432268, 432296, 432936, 433001, 433002, 434337, 434364, 434371, 434374, 438464, 443246, 444924, 450357, 452826, 454009, 455901, 456705, 458770, 464959, 466443, 469198, 475414, 476176, 480475, 486763, 494006, 494492, 499789, 499922, 501958, 509800, 511376, 513221, 513223, 514404, 517710, 526167, 530387, 532739, 532940, 534381, 535084, 540348, 541839, 542549, 542904, 545390, 549514, 549538, 550672, 560902, 576125, 576219, 591217, 595165, 599852, 602614, 606549, 615022, 617418, 625660, 640948, 642219, 651062, 652223, 700685, 716394, 720287, 724264, 738503, 744939, 752453, 765668, 766825, 783486, 785267, 788776, 806384, 806413);

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
  381830
  405683
  410683
  413398
  413406
  415859
  418126
  420116
  421366
  432268
  432296
  432936
  433001
  433002
  434337
  434364
  434371
  434374
  438464
  443246
  444924
  450357
  452826
  454009
  455901
  456705
  458770
  464959
  466443
  469198
  475414
  476176
  480475
  486763
  494006
  494492
  499789
  499922
  501958
  509800
  511376
  513221
  513223
  514404
  517710
  526167
  530387
  532739
  532940
  534381
  535084
  540348
  541839
  542549
  542904
  545390
  549514
  549538
  550672
  560902
  576125
  576219
  591217
  595165
  599852
  602614
  606549
  615022
  617418
  625660
  640948
  642219
  651062
  652223
  700685
  716394
  720287
  724264
  738503
  744939
  752453
  765668
  766825
  783486
  785267
  788776
  806384
  806413
]

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 (381830, 405683, 410683, 413398, 413406, 415859, 418126, 420116, 421366, 432268, 432296, 432936, 433001, 433002, 434337, 434364, 434371, 434374, 438464, 443246, 444924, 450357, 452826, 454009, 455901, 456705, 458770, 464959, 466443, 469198, 475414, 476176, 480475, 486763, 494006, 494492, 499789, 499922, 501958, 509800, 511376, 513221, 513223, 514404, 517710, 526167, 530387, 532739, 532940, 534381, 535084, 540348, 541839, 542549, 542904, 545390, 549514, 549538, 550672, 560902, 576125, 576219, 591217, 595165, 599852, 602614, 606549, 615022, 617418, 625660, 640948, 642219, 651062, 652223, 700685, 716394, 720287, 724264, 738503, 744939, 752453, 765668, 766825, 783486, 785267, 788776, 806384, 806413);

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` = 'анал дилд сексмашин';