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

[
  "fist teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fist teen' 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
  387394
  490625
  686615
  603522
  636293
  778230
  656932
  461704
  487422
  540685
  588798
  799786
  512930
  722393
  416689
  657478
  710709
  118920
  541755
  656921
  658787
  605326
  740689
  721949
  650187
  466991
  660047
  710096
  780713
  749243
  412779
  466563
  447159
  455083
  519312
  576444
  722548
  633731
  780650
  751428
  750148
  445413
  495467
  512081
  497474
  568518
  598668
  639787
  640538
  755756
  456236
  416683
  450599
  512931
  490741
  497689
  508885
  530627
  497030
  536413
  519697
  439059
  483739
  639809
  749924
  610577
  428276
  650180
  628402
  639783
  642706
  666894
  610694
  639732
  639741
  647893
]

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 (387394, 490625, 686615, 603522, 636293, 778230, 656932, 461704, 487422, 540685, 588798, 799786, 512930, 722393, 416689, 657478, 710709, 118920, 541755, 656921, 658787, 605326, 740689, 721949, 650187, 466991, 660047, 710096, 780713, 749243, 412779, 466563, 447159, 455083, 519312, 576444, 722548, 633731, 780650, 751428, 750148, 445413, 495467, 512081, 497474, 568518, 598668, 639787, 640538, 755756, 456236, 416683, 450599, 512931, 490741, 497689, 508885, 530627, 497030, 536413, 519697, 439059, 483739, 639809, 749924, 610577, 428276, 650180, 628402, 639783, 642706, 666894, 610694, 639732, 639741, 647893);

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
  118920
  387394
  412779
  416683
  416689
  428276
  439059
  445413
  447159
  450599
  455083
  456236
  461704
  466563
  466991
  483739
  487422
  490625
  490741
  495467
  497030
  497474
  508885
  512081
  512931
  519312
  519697
  530627
  536413
  540685
  541755
  568518
  576444
  588798
  598668
  603522
  605326
  610577
  610694
  628402
  633731
  636293
  639732
  639741
  639783
  639787
  639809
  640538
  642706
  647893
  650180
  650187
  656921
  656932
  657478
  658787
  660047
  666894
  686615
  710096
  710709
  721949
  722393
  722548
  740689
  749243
  749924
  750148
  751428
  755756
  778230
  780650
  780713
  799786
]

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 (118920, 387394, 412779, 416683, 416689, 428276, 439059, 445413, 447159, 450599, 455083, 456236, 461704, 466563, 466991, 483739, 487422, 490625, 490741, 495467, 497030, 497474, 508885, 512081, 512931, 519312, 519697, 530627, 536413, 540685, 541755, 568518, 576444, 588798, 598668, 603522, 605326, 610577, 610694, 628402, 633731, 636293, 639732, 639741, 639783, 639787, 639809, 640538, 642706, 647893, 650180, 650187, 656921, 656932, 657478, 658787, 660047, 666894, 686615, 710096, 710709, 721949, 722393, 722548, 740689, 749243, 749924, 750148, 751428, 755756, 778230, 780650, 780713, 799786);

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
  118920
  387394
  412779
  416683
  416689
  428276
  439059
  445413
  447159
  450599
  455083
  456236
  461704
  466563
  466991
  483739
  487422
  490625
  490741
  495467
  497030
  497474
  508885
  512081
  512931
  519312
  519697
  530627
  536413
  540685
  541755
  568518
  576444
  588798
  598668
  603522
  605326
  610577
  610694
  628402
  633731
  636293
  639732
  639741
  639783
  639787
  639809
  640538
  642706
  647893
  650180
  650187
  656921
  656932
  657478
  658787
  660047
  666894
  686615
  710096
  710709
  721949
  722393
  722548
  740689
  749243
  749924
  750148
  751428
  755756
  778230
  780650
  780713
  799786
]

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 (118920, 387394, 412779, 416683, 416689, 428276, 439059, 445413, 447159, 450599, 455083, 456236, 461704, 466563, 466991, 483739, 487422, 490625, 490741, 495467, 497030, 497474, 508885, 512081, 512931, 519312, 519697, 530627, 536413, 540685, 541755, 568518, 576444, 588798, 598668, 603522, 605326, 610577, 610694, 628402, 633731, 636293, 639732, 639741, 639783, 639787, 639809, 640538, 642706, 647893, 650180, 650187, 656921, 656932, 657478, 658787, 660047, 666894, 686615, 710096, 710709, 721949, 722393, 722548, 740689, 749243, 749924, 750148, 751428, 755756, 778230, 780650, 780713, 799786);

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

[
  "fist teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'fist teen';

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

[
  "fist teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fist teen';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "fist teen"
  "fist teen"
  "fist teen"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('fist teen') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('fist teen')
              AND `query` <> 'fist teen'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;