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

[
  "dirty vagina"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dirty vagina' 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
  574566
  569194
  575472
  607227
  643112
  447917
  414973
  518818
  523862
  515160
  666819
  597736
  508860
  540339
  682531
  507533
  492169
  569065
  606049
  591197
  501119
  482624
  525378
  569132
  569548
  575853
  567848
  675435
  688656
  590425
  608787
  595315
  604919
  598574
  622331
  425959
  510301
  510898
  572164
  614743
  614308
  621980
  486871
  495400
  639739
  608560
  597112
  495198
  689702
  595756
  398877
  589544
  621735
  519278
  551165
  584631
  597480
  599463
  525504
  503866
  492682
  576095
  696606
  619007
  599326
  605746
  518599
  545480
  669188
  627725
  601985
  483355
]

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 (574566, 569194, 575472, 607227, 643112, 447917, 414973, 518818, 523862, 515160, 666819, 597736, 508860, 540339, 682531, 507533, 492169, 569065, 606049, 591197, 501119, 482624, 525378, 569132, 569548, 575853, 567848, 675435, 688656, 590425, 608787, 595315, 604919, 598574, 622331, 425959, 510301, 510898, 572164, 614743, 614308, 621980, 486871, 495400, 639739, 608560, 597112, 495198, 689702, 595756, 398877, 589544, 621735, 519278, 551165, 584631, 597480, 599463, 525504, 503866, 492682, 576095, 696606, 619007, 599326, 605746, 518599, 545480, 669188, 627725, 601985, 483355);

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
  398877
  414973
  425959
  447917
  482624
  483355
  486871
  492169
  492682
  495198
  495400
  501119
  503866
  507533
  508860
  510301
  510898
  515160
  518599
  518818
  519278
  523862
  525378
  525504
  540339
  545480
  551165
  567848
  569065
  569132
  569194
  569548
  572164
  574566
  575472
  575853
  576095
  584631
  589544
  590425
  591197
  595315
  595756
  597112
  597480
  597736
  598574
  599326
  599463
  601985
  604919
  605746
  606049
  607227
  608560
  608787
  614308
  614743
  619007
  621735
  621980
  622331
  627725
  639739
  643112
  666819
  669188
  675435
  682531
  688656
  689702
  696606
]

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 (398877, 414973, 425959, 447917, 482624, 483355, 486871, 492169, 492682, 495198, 495400, 501119, 503866, 507533, 508860, 510301, 510898, 515160, 518599, 518818, 519278, 523862, 525378, 525504, 540339, 545480, 551165, 567848, 569065, 569132, 569194, 569548, 572164, 574566, 575472, 575853, 576095, 584631, 589544, 590425, 591197, 595315, 595756, 597112, 597480, 597736, 598574, 599326, 599463, 601985, 604919, 605746, 606049, 607227, 608560, 608787, 614308, 614743, 619007, 621735, 621980, 622331, 627725, 639739, 643112, 666819, 669188, 675435, 682531, 688656, 689702, 696606);

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
  398877
  414973
  425959
  447917
  482624
  483355
  486871
  492169
  492682
  495198
  495400
  501119
  503866
  507533
  508860
  510301
  510898
  515160
  518599
  518818
  519278
  523862
  525378
  525504
  540339
  545480
  551165
  567848
  569065
  569132
  569194
  569548
  572164
  574566
  575472
  575853
  576095
  584631
  589544
  590425
  591197
  595315
  595756
  597112
  597480
  597736
  598574
  599326
  599463
  601985
  604919
  605746
  606049
  607227
  608560
  608787
  614308
  614743
  619007
  621735
  621980
  622331
  627725
  639739
  643112
  666819
  669188
  675435
  682531
  688656
  689702
  696606
]

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 (398877, 414973, 425959, 447917, 482624, 483355, 486871, 492169, 492682, 495198, 495400, 501119, 503866, 507533, 508860, 510301, 510898, 515160, 518599, 518818, 519278, 523862, 525378, 525504, 540339, 545480, 551165, 567848, 569065, 569132, 569194, 569548, 572164, 574566, 575472, 575853, 576095, 584631, 589544, 590425, 591197, 595315, 595756, 597112, 597480, 597736, 598574, 599326, 599463, 601985, 604919, 605746, 606049, 607227, 608560, 608787, 614308, 614743, 619007, 621735, 621980, 622331, 627725, 639739, 643112, 666819, 669188, 675435, 682531, 688656, 689702, 696606);

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

[
  "dirty вагин"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'dirty вагин';

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

[
  "dirty вагин"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dirty вагин';

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 ?

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