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

[
  "see-through"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'see-through' 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
  547299
  550583
  392486
  824556
  625679
  535397
  540131
  704626
  801486
  812563
  754432
  533422
  540771
  647725
  678602
  709649
  662571
  808033
  707499
  812226
  539321
  533526
  645495
  579692
  770128
  778652
  814157
  539767
  574646
  685496
  642201
  811189
  800763
  541075
  553773
  550575
  550591
  597660
  605930
  641462
  788778
  35136
  532416
  608740
  810750
  730691
  751327
  559825
  796629
  811071
  751009
  490475
  514936
  460534
  577007
  701231
  587214
  751362
  455967
  455813
  582019
  709449
  810782
  402632
  420308
  526396
  441920
  798795
  213819
  785972
  493175
  563078
  516263
]

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 (547299, 550583, 392486, 824556, 625679, 535397, 540131, 704626, 801486, 812563, 754432, 533422, 540771, 647725, 678602, 709649, 662571, 808033, 707499, 812226, 539321, 533526, 645495, 579692, 770128, 778652, 814157, 539767, 574646, 685496, 642201, 811189, 800763, 541075, 553773, 550575, 550591, 597660, 605930, 641462, 788778, 35136, 532416, 608740, 810750, 730691, 751327, 559825, 796629, 811071, 751009, 490475, 514936, 460534, 577007, 701231, 587214, 751362, 455967, 455813, 582019, 709449, 810782, 402632, 420308, 526396, 441920, 798795, 213819, 785972, 493175, 563078, 516263);

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
  35136
  213819
  392486
  402632
  420308
  441920
  455813
  455967
  460534
  490475
  493175
  514936
  516263
  526396
  532416
  533422
  533526
  535397
  539321
  539767
  540131
  540771
  541075
  547299
  550575
  550583
  550591
  553773
  559825
  563078
  574646
  577007
  579692
  582019
  587214
  597660
  605930
  608740
  625679
  641462
  642201
  645495
  647725
  662571
  678602
  685496
  701231
  704626
  707499
  709449
  709649
  730691
  751009
  751327
  751362
  754432
  770128
  778652
  785972
  788778
  796629
  798795
  800763
  801486
  808033
  810750
  810782
  811071
  811189
  812226
  812563
  814157
  824556
]

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 (35136, 213819, 392486, 402632, 420308, 441920, 455813, 455967, 460534, 490475, 493175, 514936, 516263, 526396, 532416, 533422, 533526, 535397, 539321, 539767, 540131, 540771, 541075, 547299, 550575, 550583, 550591, 553773, 559825, 563078, 574646, 577007, 579692, 582019, 587214, 597660, 605930, 608740, 625679, 641462, 642201, 645495, 647725, 662571, 678602, 685496, 701231, 704626, 707499, 709449, 709649, 730691, 751009, 751327, 751362, 754432, 770128, 778652, 785972, 788778, 796629, 798795, 800763, 801486, 808033, 810750, 810782, 811071, 811189, 812226, 812563, 814157, 824556);

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
  35136
  213819
  392486
  402632
  420308
  441920
  455813
  455967
  460534
  490475
  493175
  514936
  516263
  526396
  532416
  533422
  533526
  535397
  539321
  539767
  540131
  540771
  541075
  547299
  550575
  550583
  550591
  553773
  559825
  563078
  574646
  577007
  579692
  582019
  587214
  597660
  605930
  608740
  625679
  641462
  642201
  645495
  647725
  662571
  678602
  685496
  701231
  704626
  707499
  709449
  709649
  730691
  751009
  751327
  751362
  754432
  770128
  778652
  785972
  788778
  796629
  798795
  800763
  801486
  808033
  810750
  810782
  811071
  811189
  812226
  812563
  814157
  824556
]

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 (35136, 213819, 392486, 402632, 420308, 441920, 455813, 455967, 460534, 490475, 493175, 514936, 516263, 526396, 532416, 533422, 533526, 535397, 539321, 539767, 540131, 540771, 541075, 547299, 550575, 550583, 550591, 553773, 559825, 563078, 574646, 577007, 579692, 582019, 587214, 597660, 605930, 608740, 625679, 641462, 642201, 645495, 647725, 662571, 678602, 685496, 701231, 704626, 707499, 709449, 709649, 730691, 751009, 751327, 751362, 754432, 770128, 778652, 785972, 788778, 796629, 798795, 800763, 801486, 808033, 810750, 810782, 811071, 811189, 812226, 812563, 814157, 824556);

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

[
  "see through"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'see through';

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

[
  "see through"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'see through';

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 ?

[
  "see-through"
  "see-through"
  "see-through"
  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 ('see-through') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('see-through')
              AND `query` <> 'see-through'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;