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

[
  "skinny lia"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny lia' 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
  574636
  583666
  541879
  530670
  533065
  529854
  539938
  741634
  810691
  755832
  747937
  627735
  778141
  789887
  756206
  757142
  651620
  558032
  646246
  800227
  801644
  540574
  537201
  545607
  567776
  569202
  630529
  810995
  745663
  530663
  536681
  540608
  530709
  597263
  530661
  529855
  539210
  529849
  566789
  540333
  643415
  805020
  536695
  530017
  529129
  559942
  606704
  545610
  764764
  540339
  537199
  545604
  643411
  545600
  540601
  452220
  821858
  787717
  603813
  489678
  792750
  762718
  470073
  491529
  477197
  501767
  537206
  585142
  559945
  637689
  489679
  584085
  601828
  577409
  680189
]

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 (574636, 583666, 541879, 530670, 533065, 529854, 539938, 741634, 810691, 755832, 747937, 627735, 778141, 789887, 756206, 757142, 651620, 558032, 646246, 800227, 801644, 540574, 537201, 545607, 567776, 569202, 630529, 810995, 745663, 530663, 536681, 540608, 530709, 597263, 530661, 529855, 539210, 529849, 566789, 540333, 643415, 805020, 536695, 530017, 529129, 559942, 606704, 545610, 764764, 540339, 537199, 545604, 643411, 545600, 540601, 452220, 821858, 787717, 603813, 489678, 792750, 762718, 470073, 491529, 477197, 501767, 537206, 585142, 559945, 637689, 489679, 584085, 601828, 577409, 680189);

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
  452220
  470073
  477197
  489678
  489679
  491529
  501767
  529129
  529849
  529854
  529855
  530017
  530661
  530663
  530670
  530709
  533065
  536681
  536695
  537199
  537201
  537206
  539210
  539938
  540333
  540339
  540574
  540601
  540608
  541879
  545600
  545604
  545607
  545610
  558032
  559942
  559945
  566789
  567776
  569202
  574636
  577409
  583666
  584085
  585142
  597263
  601828
  603813
  606704
  630529
  637689
  643411
  643415
  646246
  651620
  680189
  741634
  745663
  747937
  755832
  756206
  757142
  762718
  764764
  778141
  787717
  789887
  792750
  800227
  801644
  805020
  810691
  810995
  821858
]

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 (452220, 470073, 477197, 489678, 489679, 491529, 501767, 529129, 529849, 529854, 529855, 530017, 530661, 530663, 530670, 530709, 533065, 536681, 536695, 537199, 537201, 537206, 539210, 539938, 540333, 540339, 540574, 540601, 540608, 541879, 545600, 545604, 545607, 545610, 558032, 559942, 559945, 566789, 567776, 569202, 574636, 577409, 583666, 584085, 585142, 597263, 601828, 603813, 606704, 630529, 637689, 643411, 643415, 646246, 651620, 680189, 741634, 745663, 747937, 755832, 756206, 757142, 762718, 764764, 778141, 787717, 789887, 792750, 800227, 801644, 805020, 810691, 810995, 821858);

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
  452220
  470073
  477197
  489678
  489679
  491529
  501767
  529129
  529849
  529854
  529855
  530017
  530661
  530663
  530670
  530709
  533065
  536681
  536695
  537199
  537201
  537206
  539210
  539938
  540333
  540339
  540574
  540601
  540608
  541879
  545600
  545604
  545607
  545610
  558032
  559942
  559945
  566789
  567776
  569202
  574636
  577409
  583666
  584085
  585142
  597263
  601828
  603813
  606704
  630529
  637689
  643411
  643415
  646246
  651620
  680189
  741634
  745663
  747937
  755832
  756206
  757142
  762718
  764764
  778141
  787717
  789887
  792750
  800227
  801644
  805020
  810691
  810995
  821858
]

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 (452220, 470073, 477197, 489678, 489679, 491529, 501767, 529129, 529849, 529854, 529855, 530017, 530661, 530663, 530670, 530709, 533065, 536681, 536695, 537199, 537201, 537206, 539210, 539938, 540333, 540339, 540574, 540601, 540608, 541879, 545600, 545604, 545607, 545610, 558032, 559942, 559945, 566789, 567776, 569202, 574636, 577409, 583666, 584085, 585142, 597263, 601828, 603813, 606704, 630529, 637689, 643411, 643415, 646246, 651620, 680189, 741634, 745663, 747937, 755832, 756206, 757142, 762718, 764764, 778141, 787717, 789887, 792750, 800227, 801644, 805020, 810691, 810995, 821858);

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

[
  "худые lia"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые lia';

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

[
  "худые lia"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые lia';

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 ?

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