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

[
  "korean girl sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'korean girl sex' 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
  628054
  397152
  529603
  389959
  537552
  706399
  566497
  758655
  642814
  585228
  806808
  606551
  632803
  416016
  384013
  800138
  588122
  642805
  425420
  757846
  642796
  398018
  403187
  762380
  420071
  596519
  539930
  603625
  405911
  612994
  484363
  435509
  686997
  396602
  423068
  634413
  431474
  604137
  610813
  382744
  576499
  762324
  173107
  672211
  588619
  432161
  454741
  431455
  425757
  425408
  709704
  549080
  618540
  575286
  458911
  540775
  647302
  506387
  685758
  483159
  593506
  448487
  528307
  532483
  418098
  423464
  434067
  425804
  556975
  425452
  687006
  486885
]

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 (628054, 397152, 529603, 389959, 537552, 706399, 566497, 758655, 642814, 585228, 806808, 606551, 632803, 416016, 384013, 800138, 588122, 642805, 425420, 757846, 642796, 398018, 403187, 762380, 420071, 596519, 539930, 603625, 405911, 612994, 484363, 435509, 686997, 396602, 423068, 634413, 431474, 604137, 610813, 382744, 576499, 762324, 173107, 672211, 588619, 432161, 454741, 431455, 425757, 425408, 709704, 549080, 618540, 575286, 458911, 540775, 647302, 506387, 685758, 483159, 593506, 448487, 528307, 532483, 418098, 423464, 434067, 425804, 556975, 425452, 687006, 486885);

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
  173107
  382744
  384013
  389959
  396602
  397152
  398018
  403187
  405911
  416016
  418098
  420071
  423068
  423464
  425408
  425420
  425452
  425757
  425804
  431455
  431474
  432161
  434067
  435509
  448487
  454741
  458911
  483159
  484363
  486885
  506387
  528307
  529603
  532483
  537552
  539930
  540775
  549080
  556975
  566497
  575286
  576499
  585228
  588122
  588619
  593506
  596519
  603625
  604137
  606551
  610813
  612994
  618540
  628054
  632803
  634413
  642796
  642805
  642814
  647302
  672211
  685758
  686997
  687006
  706399
  709704
  757846
  758655
  762324
  762380
  800138
  806808
]

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 (173107, 382744, 384013, 389959, 396602, 397152, 398018, 403187, 405911, 416016, 418098, 420071, 423068, 423464, 425408, 425420, 425452, 425757, 425804, 431455, 431474, 432161, 434067, 435509, 448487, 454741, 458911, 483159, 484363, 486885, 506387, 528307, 529603, 532483, 537552, 539930, 540775, 549080, 556975, 566497, 575286, 576499, 585228, 588122, 588619, 593506, 596519, 603625, 604137, 606551, 610813, 612994, 618540, 628054, 632803, 634413, 642796, 642805, 642814, 647302, 672211, 685758, 686997, 687006, 706399, 709704, 757846, 758655, 762324, 762380, 800138, 806808);

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
  173107
  382744
  384013
  389959
  396602
  397152
  398018
  403187
  405911
  416016
  418098
  420071
  423068
  423464
  425408
  425420
  425452
  425757
  425804
  431455
  431474
  432161
  434067
  435509
  448487
  454741
  458911
  483159
  484363
  486885
  506387
  528307
  529603
  532483
  537552
  539930
  540775
  549080
  556975
  566497
  575286
  576499
  585228
  588122
  588619
  593506
  596519
  603625
  604137
  606551
  610813
  612994
  618540
  628054
  632803
  634413
  642796
  642805
  642814
  647302
  672211
  685758
  686997
  687006
  706399
  709704
  757846
  758655
  762324
  762380
  800138
  806808
]

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 (173107, 382744, 384013, 389959, 396602, 397152, 398018, 403187, 405911, 416016, 418098, 420071, 423068, 423464, 425408, 425420, 425452, 425757, 425804, 431455, 431474, 432161, 434067, 435509, 448487, 454741, 458911, 483159, 484363, 486885, 506387, 528307, 529603, 532483, 537552, 539930, 540775, 549080, 556975, 566497, 575286, 576499, 585228, 588122, 588619, 593506, 596519, 603625, 604137, 606551, 610813, 612994, 618540, 628054, 632803, 634413, 642796, 642805, 642814, 647302, 672211, 685758, 686997, 687006, 706399, 709704, 757846, 758655, 762324, 762380, 800138, 806808);

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

[
  "korean девушк секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'korean девушк секс';

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

[
  "korean девушк секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'korean девушк секс';

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 ?

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