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

[
  "fuck like crazy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fuck like crazy' 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
  688500
  796108
  726617
  413946
  586980
  825709
  571751
  421214
  419623
  625167
  685728
  571339
  586000
  705289
  716576
  697610
  556447
  759418
  669685
  564364
  554106
  693684
  817950
  519202
  625401
  756528
  812983
  806861
  721805
  648670
  717542
  598533
  707955
  625855
  615637
  672275
  81656
  393188
  637544
  545471
  419312
  415988
  492242
  457858
  501295
  555396
  749732
  458328
  535305
  500240
  554410
  572696
  791504
  564367
  770253
  560402
  724466
  556041
  454296
  473616
  564832
  443524
  564859
  675427
  592621
  523749
  587066
  495706
  535537
  537250
  560192
  523167
  524198
  525306
]

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 (688500, 796108, 726617, 413946, 586980, 825709, 571751, 421214, 419623, 625167, 685728, 571339, 586000, 705289, 716576, 697610, 556447, 759418, 669685, 564364, 554106, 693684, 817950, 519202, 625401, 756528, 812983, 806861, 721805, 648670, 717542, 598533, 707955, 625855, 615637, 672275, 81656, 393188, 637544, 545471, 419312, 415988, 492242, 457858, 501295, 555396, 749732, 458328, 535305, 500240, 554410, 572696, 791504, 564367, 770253, 560402, 724466, 556041, 454296, 473616, 564832, 443524, 564859, 675427, 592621, 523749, 587066, 495706, 535537, 537250, 560192, 523167, 524198, 525306);

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
  81656
  393188
  413946
  415988
  419312
  419623
  421214
  443524
  454296
  457858
  458328
  473616
  492242
  495706
  500240
  501295
  519202
  523167
  523749
  524198
  525306
  535305
  535537
  537250
  545471
  554106
  554410
  555396
  556041
  556447
  560192
  560402
  564364
  564367
  564832
  564859
  571339
  571751
  572696
  586000
  586980
  587066
  592621
  598533
  615637
  625167
  625401
  625855
  637544
  648670
  669685
  672275
  675427
  685728
  688500
  693684
  697610
  705289
  707955
  716576
  717542
  721805
  724466
  726617
  749732
  756528
  759418
  770253
  791504
  796108
  806861
  812983
  817950
]

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 (81656, 393188, 413946, 415988, 419312, 419623, 421214, 443524, 454296, 457858, 458328, 473616, 492242, 495706, 500240, 501295, 519202, 523167, 523749, 524198, 525306, 535305, 535537, 537250, 545471, 554106, 554410, 555396, 556041, 556447, 560192, 560402, 564364, 564367, 564832, 564859, 571339, 571751, 572696, 586000, 586980, 587066, 592621, 598533, 615637, 625167, 625401, 625855, 637544, 648670, 669685, 672275, 675427, 685728, 688500, 693684, 697610, 705289, 707955, 716576, 717542, 721805, 724466, 726617, 749732, 756528, 759418, 770253, 791504, 796108, 806861, 812983, 817950);

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
  81656
  393188
  413946
  415988
  419312
  419623
  421214
  443524
  454296
  457858
  458328
  473616
  492242
  495706
  500240
  501295
  519202
  523167
  523749
  524198
  525306
  535305
  535537
  537250
  545471
  554106
  554410
  555396
  556041
  556447
  560192
  560402
  564364
  564367
  564832
  564859
  571339
  571751
  572696
  586000
  586980
  587066
  592621
  598533
  615637
  625167
  625401
  625855
  637544
  648670
  669685
  672275
  675427
  685728
  688500
  693684
  697610
  705289
  707955
  716576
  717542
  721805
  724466
  726617
  749732
  756528
  759418
  770253
  791504
  796108
  806861
  812983
  817950
]

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 (81656, 393188, 413946, 415988, 419312, 419623, 421214, 443524, 454296, 457858, 458328, 473616, 492242, 495706, 500240, 501295, 519202, 523167, 523749, 524198, 525306, 535305, 535537, 537250, 545471, 554106, 554410, 555396, 556041, 556447, 560192, 560402, 564364, 564367, 564832, 564859, 571339, 571751, 572696, 586000, 586980, 587066, 592621, 598533, 615637, 625167, 625401, 625855, 637544, 648670, 669685, 672275, 675427, 685728, 688500, 693684, 697610, 705289, 707955, 716576, 717542, 721805, 724466, 726617, 749732, 756528, 759418, 770253, 791504, 796108, 806861, 812983, 817950);

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

[
  "секс like crazy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс like crazy';

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

[
  "секс like crazy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс like crazy';

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 ?

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