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

[
  "hand job porn"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hand job porn' 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
  472765
  531129
  678052
  492392
  533653
  693361
  818504
  529048
  573070
  583716
  637044
  465824
  576113
  601891
  559719
  659025
  637094
  478098
  536559
  566020
  557213
  623085
  613823
  449158
  459512
  416880
  449450
  529949
  428826
  581401
  444955
  413703
  426680
  621201
  565687
  591219
  443311
  534984
  645918
  538267
  620252
  509100
  503935
  577355
  520264
  459191
  584465
  799360
  622833
  542550
  622335
  478517
  518111
  605503
  536657
  515749
  590667
  577371
  677108
  514115
  521740
  623817
  417787
  485061
  524951
  513575
  434601
  621698
  636519
  597480
  602397
  621691
  519345
  526373
  538290
  609880
  576080
]

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 (472765, 531129, 678052, 492392, 533653, 693361, 818504, 529048, 573070, 583716, 637044, 465824, 576113, 601891, 559719, 659025, 637094, 478098, 536559, 566020, 557213, 623085, 613823, 449158, 459512, 416880, 449450, 529949, 428826, 581401, 444955, 413703, 426680, 621201, 565687, 591219, 443311, 534984, 645918, 538267, 620252, 509100, 503935, 577355, 520264, 459191, 584465, 799360, 622833, 542550, 622335, 478517, 518111, 605503, 536657, 515749, 590667, 577371, 677108, 514115, 521740, 623817, 417787, 485061, 524951, 513575, 434601, 621698, 636519, 597480, 602397, 621691, 519345, 526373, 538290, 609880, 576080);

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
  413703
  416880
  417787
  426680
  428826
  434601
  443311
  444955
  449158
  449450
  459191
  459512
  465824
  472765
  478098
  478517
  485061
  492392
  503935
  509100
  513575
  514115
  515749
  518111
  519345
  520264
  521740
  524951
  526373
  529048
  529949
  531129
  533653
  534984
  536559
  536657
  538267
  538290
  542550
  557213
  559719
  565687
  566020
  573070
  576080
  576113
  577355
  577371
  581401
  583716
  584465
  590667
  591219
  597480
  601891
  602397
  605503
  609880
  613823
  620252
  621201
  621691
  621698
  622335
  622833
  623085
  623817
  636519
  637044
  637094
  645918
  659025
  677108
  678052
  693361
  799360
  818504
]

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 (413703, 416880, 417787, 426680, 428826, 434601, 443311, 444955, 449158, 449450, 459191, 459512, 465824, 472765, 478098, 478517, 485061, 492392, 503935, 509100, 513575, 514115, 515749, 518111, 519345, 520264, 521740, 524951, 526373, 529048, 529949, 531129, 533653, 534984, 536559, 536657, 538267, 538290, 542550, 557213, 559719, 565687, 566020, 573070, 576080, 576113, 577355, 577371, 581401, 583716, 584465, 590667, 591219, 597480, 601891, 602397, 605503, 609880, 613823, 620252, 621201, 621691, 621698, 622335, 622833, 623085, 623817, 636519, 637044, 637094, 645918, 659025, 677108, 678052, 693361, 799360, 818504);

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
  413703
  416880
  417787
  426680
  428826
  434601
  443311
  444955
  449158
  449450
  459191
  459512
  465824
  472765
  478098
  478517
  485061
  492392
  503935
  509100
  513575
  514115
  515749
  518111
  519345
  520264
  521740
  524951
  526373
  529048
  529949
  531129
  533653
  534984
  536559
  536657
  538267
  538290
  542550
  557213
  559719
  565687
  566020
  573070
  576080
  576113
  577355
  577371
  581401
  583716
  584465
  590667
  591219
  597480
  601891
  602397
  605503
  609880
  613823
  620252
  621201
  621691
  621698
  622335
  622833
  623085
  623817
  636519
  637044
  637094
  645918
  659025
  677108
  678052
  693361
  799360
  818504
]

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 (413703, 416880, 417787, 426680, 428826, 434601, 443311, 444955, 449158, 449450, 459191, 459512, 465824, 472765, 478098, 478517, 485061, 492392, 503935, 509100, 513575, 514115, 515749, 518111, 519345, 520264, 521740, 524951, 526373, 529048, 529949, 531129, 533653, 534984, 536559, 536657, 538267, 538290, 542550, 557213, 559719, 565687, 566020, 573070, 576080, 576113, 577355, 577371, 581401, 583716, 584465, 590667, 591219, 597480, 601891, 602397, 605503, 609880, 613823, 620252, 621201, 621691, 621698, 622335, 622833, 623085, 623817, 636519, 637044, 637094, 645918, 659025, 677108, 678052, 693361, 799360, 818504);

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

[
  "дрочк член porn"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'дрочк член porn';

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

[
  "дрочк член porn"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'дрочк член porn';