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

[
  "bdsm asian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bdsm asian' 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
  422957
  420069
  423040
  529855
  486885
  514985
  512174
  546805
  596803
  799394
  423212
  497425
  497392
  478032
  560198
  499481
  423291
  458287
  524038
  540195
  717630
  614804
  810829
  755377
  748660
  801273
  421520
  422512
  458100
  530670
  422688
  511809
  554420
  423400
  527121
  528713
  475938
  547569
  419840
  438878
  814778
  497962
  527116
  532483
  485074
  513230
  519903
  498119
  490785
  546654
  422567
  525079
  528356
  413044
  606493
  559886
  588220
  382834
  427851
  526168
  423267
  428293
  412583
  559183
  815275
  533538
  536340
  529184
  790754
  519908
  595923
  427278
  497422
  537199
  825781
  541848
  421249
  435711
  650380
  460969
  427174
  412964
]

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 (422957, 420069, 423040, 529855, 486885, 514985, 512174, 546805, 596803, 799394, 423212, 497425, 497392, 478032, 560198, 499481, 423291, 458287, 524038, 540195, 717630, 614804, 810829, 755377, 748660, 801273, 421520, 422512, 458100, 530670, 422688, 511809, 554420, 423400, 527121, 528713, 475938, 547569, 419840, 438878, 814778, 497962, 527116, 532483, 485074, 513230, 519903, 498119, 490785, 546654, 422567, 525079, 528356, 413044, 606493, 559886, 588220, 382834, 427851, 526168, 423267, 428293, 412583, 559183, 815275, 533538, 536340, 529184, 790754, 519908, 595923, 427278, 497422, 537199, 825781, 541848, 421249, 435711, 650380, 460969, 427174, 412964);

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
  382834
  412583
  412964
  413044
  419840
  420069
  421249
  421520
  422512
  422567
  422688
  422957
  423040
  423212
  423267
  423291
  423400
  427174
  427278
  427851
  428293
  435711
  438878
  458100
  458287
  460969
  475938
  478032
  485074
  486885
  490785
  497392
  497422
  497425
  497962
  498119
  499481
  511809
  512174
  513230
  514985
  519903
  519908
  524038
  525079
  526168
  527116
  527121
  528356
  528713
  529184
  529855
  530670
  532483
  533538
  536340
  537199
  540195
  541848
  546654
  546805
  547569
  554420
  559183
  559886
  560198
  588220
  595923
  606493
  614804
  650380
  717630
  748660
  755377
  790754
  799394
  801273
  810829
  814778
  815275
  825781
]

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 (382834, 412583, 412964, 413044, 419840, 420069, 421249, 421520, 422512, 422567, 422688, 422957, 423040, 423212, 423267, 423291, 423400, 427174, 427278, 427851, 428293, 435711, 438878, 458100, 458287, 460969, 475938, 478032, 485074, 486885, 490785, 497392, 497422, 497425, 497962, 498119, 499481, 511809, 512174, 513230, 514985, 519903, 519908, 524038, 525079, 526168, 527116, 527121, 528356, 528713, 529184, 529855, 530670, 532483, 533538, 536340, 537199, 540195, 541848, 546654, 546805, 547569, 554420, 559183, 559886, 560198, 588220, 595923, 606493, 614804, 650380, 717630, 748660, 755377, 790754, 799394, 801273, 810829, 814778, 815275, 825781);

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
  382834
  412583
  412964
  413044
  419840
  420069
  421249
  421520
  422512
  422567
  422688
  422957
  423040
  423212
  423267
  423291
  423400
  427174
  427278
  427851
  428293
  435711
  438878
  458100
  458287
  460969
  475938
  478032
  485074
  486885
  490785
  497392
  497422
  497425
  497962
  498119
  499481
  511809
  512174
  513230
  514985
  519903
  519908
  524038
  525079
  526168
  527116
  527121
  528356
  528713
  529184
  529855
  530670
  532483
  533538
  536340
  537199
  540195
  541848
  546654
  546805
  547569
  554420
  559183
  559886
  560198
  588220
  595923
  606493
  614804
  650380
  717630
  748660
  755377
  790754
  799394
  801273
  810829
  814778
  815275
  825781
]

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 (382834, 412583, 412964, 413044, 419840, 420069, 421249, 421520, 422512, 422567, 422688, 422957, 423040, 423212, 423267, 423291, 423400, 427174, 427278, 427851, 428293, 435711, 438878, 458100, 458287, 460969, 475938, 478032, 485074, 486885, 490785, 497392, 497422, 497425, 497962, 498119, 499481, 511809, 512174, 513230, 514985, 519903, 519908, 524038, 525079, 526168, 527116, 527121, 528356, 528713, 529184, 529855, 530670, 532483, 533538, 536340, 537199, 540195, 541848, 546654, 546805, 547569, 554420, 559183, 559886, 560198, 588220, 595923, 606493, 614804, 650380, 717630, 748660, 755377, 790754, 799394, 801273, 810829, 814778, 815275, 825781);

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` = 'бдсм азиатк';