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

[
  "she wants"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'she wants' 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
  732538
  802345
  450014
  456077
  659218
  678334
  809175
  738094
  742632
  724378
  780330
  305201
  823562
  579342
  601199
  807890
  767764
  772165
  616293
  815877
  469415
  511720
  467179
  572845
  701608
  580876
  588372
  586784
  777750
  779247
  800864
  748337
  793617
  504119
  483277
  606799
  570999
  457462
  464317
  558630
  714452
  616038
  644054
  809075
  790469
  522793
  527687
  520252
  522684
  525996
  814790
  814889
  451788
  572337
  666823
  551872
  595097
  788252
  779012
  400440
  814808
  464476
  525428
  588094
  615851
  620419
  601338
  626603
  799146
  520203
  490436
  577378
  529332
  565710
  716147
  578442
  491646
  623817
  589634
  625167
]

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 (732538, 802345, 450014, 456077, 659218, 678334, 809175, 738094, 742632, 724378, 780330, 305201, 823562, 579342, 601199, 807890, 767764, 772165, 616293, 815877, 469415, 511720, 467179, 572845, 701608, 580876, 588372, 586784, 777750, 779247, 800864, 748337, 793617, 504119, 483277, 606799, 570999, 457462, 464317, 558630, 714452, 616038, 644054, 809075, 790469, 522793, 527687, 520252, 522684, 525996, 814790, 814889, 451788, 572337, 666823, 551872, 595097, 788252, 779012, 400440, 814808, 464476, 525428, 588094, 615851, 620419, 601338, 626603, 799146, 520203, 490436, 577378, 529332, 565710, 716147, 578442, 491646, 623817, 589634, 625167);

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
  305201
  400440
  450014
  451788
  456077
  457462
  464317
  464476
  467179
  469415
  483277
  490436
  491646
  504119
  511720
  520203
  520252
  522684
  522793
  525428
  525996
  527687
  529332
  551872
  558630
  565710
  570999
  572337
  572845
  577378
  578442
  579342
  580876
  586784
  588094
  588372
  589634
  595097
  601199
  601338
  606799
  615851
  616038
  616293
  620419
  623817
  625167
  626603
  644054
  659218
  666823
  678334
  701608
  714452
  716147
  724378
  732538
  738094
  742632
  748337
  767764
  772165
  777750
  779012
  779247
  780330
  788252
  790469
  793617
  799146
  800864
  802345
  807890
  809075
  809175
  814790
  814808
  814889
  815877
  823562
]

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 (305201, 400440, 450014, 451788, 456077, 457462, 464317, 464476, 467179, 469415, 483277, 490436, 491646, 504119, 511720, 520203, 520252, 522684, 522793, 525428, 525996, 527687, 529332, 551872, 558630, 565710, 570999, 572337, 572845, 577378, 578442, 579342, 580876, 586784, 588094, 588372, 589634, 595097, 601199, 601338, 606799, 615851, 616038, 616293, 620419, 623817, 625167, 626603, 644054, 659218, 666823, 678334, 701608, 714452, 716147, 724378, 732538, 738094, 742632, 748337, 767764, 772165, 777750, 779012, 779247, 780330, 788252, 790469, 793617, 799146, 800864, 802345, 807890, 809075, 809175, 814790, 814808, 814889, 815877, 823562);

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
  305201
  400440
  450014
  451788
  456077
  457462
  464317
  464476
  467179
  469415
  483277
  490436
  491646
  504119
  511720
  520203
  520252
  522684
  522793
  525428
  525996
  527687
  529332
  551872
  558630
  565710
  570999
  572337
  572845
  577378
  578442
  579342
  580876
  586784
  588094
  588372
  589634
  595097
  601199
  601338
  606799
  615851
  616038
  616293
  620419
  623817
  625167
  626603
  644054
  659218
  666823
  678334
  701608
  714452
  716147
  724378
  732538
  738094
  742632
  748337
  767764
  772165
  777750
  779012
  779247
  780330
  788252
  790469
  793617
  799146
  800864
  802345
  807890
  809075
  809175
  814790
  814808
  814889
  815877
  823562
]

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 (305201, 400440, 450014, 451788, 456077, 457462, 464317, 464476, 467179, 469415, 483277, 490436, 491646, 504119, 511720, 520203, 520252, 522684, 522793, 525428, 525996, 527687, 529332, 551872, 558630, 565710, 570999, 572337, 572845, 577378, 578442, 579342, 580876, 586784, 588094, 588372, 589634, 595097, 601199, 601338, 606799, 615851, 616038, 616293, 620419, 623817, 625167, 626603, 644054, 659218, 666823, 678334, 701608, 714452, 716147, 724378, 732538, 738094, 742632, 748337, 767764, 772165, 777750, 779012, 779247, 780330, 788252, 790469, 793617, 799146, 800864, 802345, 807890, 809075, 809175, 814790, 814808, 814889, 815877, 823562);

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

[
  "she wants"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'she wants';

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

[
  "she wants"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'she wants';