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

[
  "russian redhead porn"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian redhead porn' 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
  389630
  516394
  799808
  446118
  689886
  758082
  525232
  491705
  597195
  781061
  538232
  528660
  735347
  528061
  423804
  569788
  558999
  526865
  819851
  574911
  673513
  400474
  575092
  700452
  825623
  645838
  766075
  491716
  568973
  485150
  785507
  763883
  532617
  705691
  610832
  613217
  762065
  698009
  542951
  603761
  613261
  723900
  803526
  553505
  740157
  788416
  513292
  527851
  575059
  558846
  653545
  574585
  739900
  491723
  492977
  743380
  513696
  575792
  722277
  780517
  538205
  491724
  613356
  559771
  693269
  608153
  528802
  559754
  522056
  525704
  579647
]

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 (389630, 516394, 799808, 446118, 689886, 758082, 525232, 491705, 597195, 781061, 538232, 528660, 735347, 528061, 423804, 569788, 558999, 526865, 819851, 574911, 673513, 400474, 575092, 700452, 825623, 645838, 766075, 491716, 568973, 485150, 785507, 763883, 532617, 705691, 610832, 613217, 762065, 698009, 542951, 603761, 613261, 723900, 803526, 553505, 740157, 788416, 513292, 527851, 575059, 558846, 653545, 574585, 739900, 491723, 492977, 743380, 513696, 575792, 722277, 780517, 538205, 491724, 613356, 559771, 693269, 608153, 528802, 559754, 522056, 525704, 579647);

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
  389630
  400474
  423804
  446118
  485150
  491705
  491716
  491723
  491724
  492977
  513292
  513696
  516394
  522056
  525232
  525704
  526865
  527851
  528061
  528660
  528802
  532617
  538205
  538232
  542951
  553505
  558846
  558999
  559754
  559771
  568973
  569788
  574585
  574911
  575059
  575092
  575792
  579647
  597195
  603761
  608153
  610832
  613217
  613261
  613356
  645838
  653545
  673513
  689886
  693269
  698009
  700452
  705691
  722277
  723900
  735347
  739900
  740157
  743380
  758082
  762065
  763883
  766075
  780517
  781061
  785507
  788416
  799808
  803526
  819851
  825623
]

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 (389630, 400474, 423804, 446118, 485150, 491705, 491716, 491723, 491724, 492977, 513292, 513696, 516394, 522056, 525232, 525704, 526865, 527851, 528061, 528660, 528802, 532617, 538205, 538232, 542951, 553505, 558846, 558999, 559754, 559771, 568973, 569788, 574585, 574911, 575059, 575092, 575792, 579647, 597195, 603761, 608153, 610832, 613217, 613261, 613356, 645838, 653545, 673513, 689886, 693269, 698009, 700452, 705691, 722277, 723900, 735347, 739900, 740157, 743380, 758082, 762065, 763883, 766075, 780517, 781061, 785507, 788416, 799808, 803526, 819851, 825623);

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
  389630
  400474
  423804
  446118
  485150
  491705
  491716
  491723
  491724
  492977
  513292
  513696
  516394
  522056
  525232
  525704
  526865
  527851
  528061
  528660
  528802
  532617
  538205
  538232
  542951
  553505
  558846
  558999
  559754
  559771
  568973
  569788
  574585
  574911
  575059
  575092
  575792
  579647
  597195
  603761
  608153
  610832
  613217
  613261
  613356
  645838
  653545
  673513
  689886
  693269
  698009
  700452
  705691
  722277
  723900
  735347
  739900
  740157
  743380
  758082
  762065
  763883
  766075
  780517
  781061
  785507
  788416
  799808
  803526
  819851
  825623
]

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 (389630, 400474, 423804, 446118, 485150, 491705, 491716, 491723, 491724, 492977, 513292, 513696, 516394, 522056, 525232, 525704, 526865, 527851, 528061, 528660, 528802, 532617, 538205, 538232, 542951, 553505, 558846, 558999, 559754, 559771, 568973, 569788, 574585, 574911, 575059, 575092, 575792, 579647, 597195, 603761, 608153, 610832, 613217, 613261, 613356, 645838, 653545, 673513, 689886, 693269, 698009, 700452, 705691, 722277, 723900, 735347, 739900, 740157, 743380, 758082, 762065, 763883, 766075, 780517, 781061, 785507, 788416, 799808, 803526, 819851, 825623);

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

[
  "русск рыжая porn"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск рыжая porn';

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

[
  "русск рыжая porn"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск рыжая porn';

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 ?

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