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

[
  "girl fisting boy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girl fisting boy' 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
  590908
  515972
  474539
  530912
  492064
  597963
  454210
  420866
  436178
  503310
  521438
  418132
  496033
  452014
  518468
  532680
  533563
  649953
  561682
  524794
  391372
  577959
  471668
  487362
  455898
  575740
  746594
  613488
  542954
  634140
  637148
  533746
  466404
  483550
  471959
  461393
  509821
  510816
  570535
  509684
  494826
  516686
  521544
  559378
  533915
  498811
  448077
  590526
  532666
  617420
  576088
  467910
  447751
  499009
  527915
  441644
  590057
  192968
  439521
  523924
  491232
  467705
  480972
  502575
  420182
  491665
  439623
  450901
  480905
  497300
  480743
  441858
  533557
  546680
  524162
  446172
  427263
  521074
  596431
  593125
  617165
  623684
  477873
]

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 (590908, 515972, 474539, 530912, 492064, 597963, 454210, 420866, 436178, 503310, 521438, 418132, 496033, 452014, 518468, 532680, 533563, 649953, 561682, 524794, 391372, 577959, 471668, 487362, 455898, 575740, 746594, 613488, 542954, 634140, 637148, 533746, 466404, 483550, 471959, 461393, 509821, 510816, 570535, 509684, 494826, 516686, 521544, 559378, 533915, 498811, 448077, 590526, 532666, 617420, 576088, 467910, 447751, 499009, 527915, 441644, 590057, 192968, 439521, 523924, 491232, 467705, 480972, 502575, 420182, 491665, 439623, 450901, 480905, 497300, 480743, 441858, 533557, 546680, 524162, 446172, 427263, 521074, 596431, 593125, 617165, 623684, 477873);

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
  192968
  391372
  418132
  420182
  420866
  427263
  436178
  439521
  439623
  441644
  441858
  446172
  447751
  448077
  450901
  452014
  454210
  455898
  461393
  466404
  467705
  467910
  471668
  471959
  474539
  477873
  480743
  480905
  480972
  483550
  487362
  491232
  491665
  492064
  494826
  496033
  497300
  498811
  499009
  502575
  503310
  509684
  509821
  510816
  515972
  516686
  518468
  521074
  521438
  521544
  523924
  524162
  524794
  527915
  530912
  532666
  532680
  533557
  533563
  533746
  533915
  542954
  546680
  559378
  561682
  570535
  575740
  576088
  577959
  590057
  590526
  590908
  593125
  596431
  597963
  613488
  617165
  617420
  623684
  634140
  637148
  649953
  746594
]

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 (192968, 391372, 418132, 420182, 420866, 427263, 436178, 439521, 439623, 441644, 441858, 446172, 447751, 448077, 450901, 452014, 454210, 455898, 461393, 466404, 467705, 467910, 471668, 471959, 474539, 477873, 480743, 480905, 480972, 483550, 487362, 491232, 491665, 492064, 494826, 496033, 497300, 498811, 499009, 502575, 503310, 509684, 509821, 510816, 515972, 516686, 518468, 521074, 521438, 521544, 523924, 524162, 524794, 527915, 530912, 532666, 532680, 533557, 533563, 533746, 533915, 542954, 546680, 559378, 561682, 570535, 575740, 576088, 577959, 590057, 590526, 590908, 593125, 596431, 597963, 613488, 617165, 617420, 623684, 634140, 637148, 649953, 746594);

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
  192968
  391372
  418132
  420182
  420866
  427263
  436178
  439521
  439623
  441644
  441858
  446172
  447751
  448077
  450901
  452014
  454210
  455898
  461393
  466404
  467705
  467910
  471668
  471959
  474539
  477873
  480743
  480905
  480972
  483550
  487362
  491232
  491665
  492064
  494826
  496033
  497300
  498811
  499009
  502575
  503310
  509684
  509821
  510816
  515972
  516686
  518468
  521074
  521438
  521544
  523924
  524162
  524794
  527915
  530912
  532666
  532680
  533557
  533563
  533746
  533915
  542954
  546680
  559378
  561682
  570535
  575740
  576088
  577959
  590057
  590526
  590908
  593125
  596431
  597963
  613488
  617165
  617420
  623684
  634140
  637148
  649953
  746594
]

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 (192968, 391372, 418132, 420182, 420866, 427263, 436178, 439521, 439623, 441644, 441858, 446172, 447751, 448077, 450901, 452014, 454210, 455898, 461393, 466404, 467705, 467910, 471668, 471959, 474539, 477873, 480743, 480905, 480972, 483550, 487362, 491232, 491665, 492064, 494826, 496033, 497300, 498811, 499009, 502575, 503310, 509684, 509821, 510816, 515972, 516686, 518468, 521074, 521438, 521544, 523924, 524162, 524794, 527915, 530912, 532666, 532680, 533557, 533563, 533746, 533915, 542954, 546680, 559378, 561682, 570535, 575740, 576088, 577959, 590057, 590526, 590908, 593125, 596431, 597963, 613488, 617165, 617420, 623684, 634140, 637148, 649953, 746594);

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` = 'девушк фистинг парен';