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

[
  "hair redhead solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hair redhead solo' 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
  666859
  646872
  666355
  614549
  615835
  585358
  602317
  599485
  608491
  614532
  598083
  602999
  604286
  623333
  810772
  750121
  769150
  772573
  764359
  603251
  620731
  636643
  802734
  444913
  476318
  480231
  418714
  527360
  503712
  601137
  608334
  441027
  606154
  614673
  489338
  476314
  497696
  512440
  513972
  513808
  567248
  541440
  541442
  542902
  556593
  578680
  608153
  616315
  613356
  627147
  639584
  590102
  604781
  614968
  616237
  463689
  452436
  453583
  525727
  579677
  544937
  605661
  589400
  523885
  618762
  417674
  492221
  647330
  575556
  603286
  611500
  470064
]

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 (666859, 646872, 666355, 614549, 615835, 585358, 602317, 599485, 608491, 614532, 598083, 602999, 604286, 623333, 810772, 750121, 769150, 772573, 764359, 603251, 620731, 636643, 802734, 444913, 476318, 480231, 418714, 527360, 503712, 601137, 608334, 441027, 606154, 614673, 489338, 476314, 497696, 512440, 513972, 513808, 567248, 541440, 541442, 542902, 556593, 578680, 608153, 616315, 613356, 627147, 639584, 590102, 604781, 614968, 616237, 463689, 452436, 453583, 525727, 579677, 544937, 605661, 589400, 523885, 618762, 417674, 492221, 647330, 575556, 603286, 611500, 470064);

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
  417674
  418714
  441027
  444913
  452436
  453583
  463689
  470064
  476314
  476318
  480231
  489338
  492221
  497696
  503712
  512440
  513808
  513972
  523885
  525727
  527360
  541440
  541442
  542902
  544937
  556593
  567248
  575556
  578680
  579677
  585358
  589400
  590102
  598083
  599485
  601137
  602317
  602999
  603251
  603286
  604286
  604781
  605661
  606154
  608153
  608334
  608491
  611500
  613356
  614532
  614549
  614673
  614968
  615835
  616237
  616315
  618762
  620731
  623333
  627147
  636643
  639584
  646872
  647330
  666355
  666859
  750121
  764359
  769150
  772573
  802734
  810772
]

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 (417674, 418714, 441027, 444913, 452436, 453583, 463689, 470064, 476314, 476318, 480231, 489338, 492221, 497696, 503712, 512440, 513808, 513972, 523885, 525727, 527360, 541440, 541442, 542902, 544937, 556593, 567248, 575556, 578680, 579677, 585358, 589400, 590102, 598083, 599485, 601137, 602317, 602999, 603251, 603286, 604286, 604781, 605661, 606154, 608153, 608334, 608491, 611500, 613356, 614532, 614549, 614673, 614968, 615835, 616237, 616315, 618762, 620731, 623333, 627147, 636643, 639584, 646872, 647330, 666355, 666859, 750121, 764359, 769150, 772573, 802734, 810772);

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
  417674
  418714
  441027
  444913
  452436
  453583
  463689
  470064
  476314
  476318
  480231
  489338
  492221
  497696
  503712
  512440
  513808
  513972
  523885
  525727
  527360
  541440
  541442
  542902
  544937
  556593
  567248
  575556
  578680
  579677
  585358
  589400
  590102
  598083
  599485
  601137
  602317
  602999
  603251
  603286
  604286
  604781
  605661
  606154
  608153
  608334
  608491
  611500
  613356
  614532
  614549
  614673
  614968
  615835
  616237
  616315
  618762
  620731
  623333
  627147
  636643
  639584
  646872
  647330
  666355
  666859
  750121
  764359
  769150
  772573
  802734
  810772
]

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 (417674, 418714, 441027, 444913, 452436, 453583, 463689, 470064, 476314, 476318, 480231, 489338, 492221, 497696, 503712, 512440, 513808, 513972, 523885, 525727, 527360, 541440, 541442, 542902, 544937, 556593, 567248, 575556, 578680, 579677, 585358, 589400, 590102, 598083, 599485, 601137, 602317, 602999, 603251, 603286, 604286, 604781, 605661, 606154, 608153, 608334, 608491, 611500, 613356, 614532, 614549, 614673, 614968, 615835, 616237, 616315, 618762, 620731, 623333, 627147, 636643, 639584, 646872, 647330, 666355, 666859, 750121, 764359, 769150, 772573, 802734, 810772);

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

[
  "hair рыжая соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'hair рыжая соло';

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

[
  "hair рыжая соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hair рыжая соло';