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

[
  "tiny big ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tiny big ass' 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
  495016
  504919
  494699
  510797
  465307
  429338
  464058
  571007
  694058
  485325
  526467
  502634
  524089
  615608
  416609
  475405
  511254
  479277
  542802
  704715
  600623
  791368
  557530
  451175
  490956
  407505
  530633
  662048
  602532
  526564
  414651
  556480
  556406
  428569
  416669
  600498
  597518
  597141
  729829
  428972
  448816
  526188
  714497
  589232
  404318
  526003
  565481
  456120
  548046
  640806
  434374
  489082
  637123
  413274
  543919
  530694
  555154
  475508
  446529
  558138
  568556
  632580
  574371
  503658
  651647
  555789
  581736
  645997
  633446
  480768
  416635
  561307
]

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 (495016, 504919, 494699, 510797, 465307, 429338, 464058, 571007, 694058, 485325, 526467, 502634, 524089, 615608, 416609, 475405, 511254, 479277, 542802, 704715, 600623, 791368, 557530, 451175, 490956, 407505, 530633, 662048, 602532, 526564, 414651, 556480, 556406, 428569, 416669, 600498, 597518, 597141, 729829, 428972, 448816, 526188, 714497, 589232, 404318, 526003, 565481, 456120, 548046, 640806, 434374, 489082, 637123, 413274, 543919, 530694, 555154, 475508, 446529, 558138, 568556, 632580, 574371, 503658, 651647, 555789, 581736, 645997, 633446, 480768, 416635, 561307);

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
  404318
  407505
  413274
  414651
  416609
  416635
  416669
  428569
  428972
  429338
  434374
  446529
  448816
  451175
  456120
  464058
  465307
  475405
  475508
  479277
  480768
  485325
  489082
  490956
  494699
  495016
  502634
  503658
  504919
  510797
  511254
  524089
  526003
  526188
  526467
  526564
  530633
  530694
  542802
  543919
  548046
  555154
  555789
  556406
  556480
  557530
  558138
  561307
  565481
  568556
  571007
  574371
  581736
  589232
  597141
  597518
  600498
  600623
  602532
  615608
  632580
  633446
  637123
  640806
  645997
  651647
  662048
  694058
  704715
  714497
  729829
  791368
]

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 (404318, 407505, 413274, 414651, 416609, 416635, 416669, 428569, 428972, 429338, 434374, 446529, 448816, 451175, 456120, 464058, 465307, 475405, 475508, 479277, 480768, 485325, 489082, 490956, 494699, 495016, 502634, 503658, 504919, 510797, 511254, 524089, 526003, 526188, 526467, 526564, 530633, 530694, 542802, 543919, 548046, 555154, 555789, 556406, 556480, 557530, 558138, 561307, 565481, 568556, 571007, 574371, 581736, 589232, 597141, 597518, 600498, 600623, 602532, 615608, 632580, 633446, 637123, 640806, 645997, 651647, 662048, 694058, 704715, 714497, 729829, 791368);

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
  404318
  407505
  413274
  414651
  416609
  416635
  416669
  428569
  428972
  429338
  434374
  446529
  448816
  451175
  456120
  464058
  465307
  475405
  475508
  479277
  480768
  485325
  489082
  490956
  494699
  495016
  502634
  503658
  504919
  510797
  511254
  524089
  526003
  526188
  526467
  526564
  530633
  530694
  542802
  543919
  548046
  555154
  555789
  556406
  556480
  557530
  558138
  561307
  565481
  568556
  571007
  574371
  581736
  589232
  597141
  597518
  600498
  600623
  602532
  615608
  632580
  633446
  637123
  640806
  645997
  651647
  662048
  694058
  704715
  714497
  729829
  791368
]

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 (404318, 407505, 413274, 414651, 416609, 416635, 416669, 428569, 428972, 429338, 434374, 446529, 448816, 451175, 456120, 464058, 465307, 475405, 475508, 479277, 480768, 485325, 489082, 490956, 494699, 495016, 502634, 503658, 504919, 510797, 511254, 524089, 526003, 526188, 526467, 526564, 530633, 530694, 542802, 543919, 548046, 555154, 555789, 556406, 556480, 557530, 558138, 561307, 565481, 568556, 571007, 574371, 581736, 589232, 597141, 597518, 600498, 600623, 602532, 615608, 632580, 633446, 637123, 640806, 645997, 651647, 662048, 694058, 704715, 714497, 729829, 791368);

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

[
  "tiny большая большие жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'tiny большая большие жоп';

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

[
  "tiny большая большие жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tiny большая большие жоп';

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 ?

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