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

[
  "very hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very hot' 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
  534857
  556592
  562228
  713728
  589577
  793600
  791736
  755935
  731243
  797087
  566459
  496343
  547566
  693284
  807881
  740848
  736741
  742632
  709217
  778915
  428033
  692448
  675389
  693675
  562226
  727420
  752822
  449001
  477098
  402965
  474913
  457113
  513836
  572391
  696480
  562235
  608720
  624011
  743345
  784280
  748337
  765379
  643960
  778841
  479248
  502756
  453032
  453218
  523298
  559216
  678929
  624391
  811994
  464096
  525389
  399162
  525915
  541393
  562463
  659460
  693945
  571926
  627498
  608715
  437751
  428972
  529478
  508530
  522442
  477114
  519331
  528146
  610661
  630771
  523882
  488811
  572344
]

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 (534857, 556592, 562228, 713728, 589577, 793600, 791736, 755935, 731243, 797087, 566459, 496343, 547566, 693284, 807881, 740848, 736741, 742632, 709217, 778915, 428033, 692448, 675389, 693675, 562226, 727420, 752822, 449001, 477098, 402965, 474913, 457113, 513836, 572391, 696480, 562235, 608720, 624011, 743345, 784280, 748337, 765379, 643960, 778841, 479248, 502756, 453032, 453218, 523298, 559216, 678929, 624391, 811994, 464096, 525389, 399162, 525915, 541393, 562463, 659460, 693945, 571926, 627498, 608715, 437751, 428972, 529478, 508530, 522442, 477114, 519331, 528146, 610661, 630771, 523882, 488811, 572344);

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
  399162
  402965
  428033
  428972
  437751
  449001
  453032
  453218
  457113
  464096
  474913
  477098
  477114
  479248
  488811
  496343
  502756
  508530
  513836
  519331
  522442
  523298
  523882
  525389
  525915
  528146
  529478
  534857
  541393
  547566
  556592
  559216
  562226
  562228
  562235
  562463
  566459
  571926
  572344
  572391
  589577
  608715
  608720
  610661
  624011
  624391
  627498
  630771
  643960
  659460
  675389
  678929
  692448
  693284
  693675
  693945
  696480
  709217
  713728
  727420
  731243
  736741
  740848
  742632
  743345
  748337
  752822
  755935
  765379
  778841
  778915
  784280
  791736
  793600
  797087
  807881
  811994
]

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 (399162, 402965, 428033, 428972, 437751, 449001, 453032, 453218, 457113, 464096, 474913, 477098, 477114, 479248, 488811, 496343, 502756, 508530, 513836, 519331, 522442, 523298, 523882, 525389, 525915, 528146, 529478, 534857, 541393, 547566, 556592, 559216, 562226, 562228, 562235, 562463, 566459, 571926, 572344, 572391, 589577, 608715, 608720, 610661, 624011, 624391, 627498, 630771, 643960, 659460, 675389, 678929, 692448, 693284, 693675, 693945, 696480, 709217, 713728, 727420, 731243, 736741, 740848, 742632, 743345, 748337, 752822, 755935, 765379, 778841, 778915, 784280, 791736, 793600, 797087, 807881, 811994);

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
  399162
  402965
  428033
  428972
  437751
  449001
  453032
  453218
  457113
  464096
  474913
  477098
  477114
  479248
  488811
  496343
  502756
  508530
  513836
  519331
  522442
  523298
  523882
  525389
  525915
  528146
  529478
  534857
  541393
  547566
  556592
  559216
  562226
  562228
  562235
  562463
  566459
  571926
  572344
  572391
  589577
  608715
  608720
  610661
  624011
  624391
  627498
  630771
  643960
  659460
  675389
  678929
  692448
  693284
  693675
  693945
  696480
  709217
  713728
  727420
  731243
  736741
  740848
  742632
  743345
  748337
  752822
  755935
  765379
  778841
  778915
  784280
  791736
  793600
  797087
  807881
  811994
]

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 (399162, 402965, 428033, 428972, 437751, 449001, 453032, 453218, 457113, 464096, 474913, 477098, 477114, 479248, 488811, 496343, 502756, 508530, 513836, 519331, 522442, 523298, 523882, 525389, 525915, 528146, 529478, 534857, 541393, 547566, 556592, 559216, 562226, 562228, 562235, 562463, 566459, 571926, 572344, 572391, 589577, 608715, 608720, 610661, 624011, 624391, 627498, 630771, 643960, 659460, 675389, 678929, 692448, 693284, 693675, 693945, 696480, 709217, 713728, 727420, 731243, 736741, 740848, 742632, 743345, 748337, 752822, 755935, 765379, 778841, 778915, 784280, 791736, 793600, 797087, 807881, 811994);

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

[
  "very hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'very hot';

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

[
  "very hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'very hot';