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

[
  "vip4k com"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'vip4k com' 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
  603970
  596227
  744912
  561369
  556320
  601707
  586378
  601284
  624111
  828283
  789297
  819592
  789332
  819550
  505935
  789252
  417163
  789278
  789316
  525228
  548052
  789321
  467209
  467218
  520000
  467223
  550453
  467160
  467169
  467200
  466694
  505494
  505501
  467208
  467296
  524017
  558307
  560525
  584890
  590224
  789310
  467285
  467173
  501442
  467166
  465092
  467214
  504552
  558273
  574756
  561354
  662390
  597583
  502562
  528000
  569832
  547823
  549575
  562891
  599252
  501198
  467163
  567329
  587133
  601478
  550452
  467162
  601273
  611984
  607387
  605586
  611900
  624428
]

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 (603970, 596227, 744912, 561369, 556320, 601707, 586378, 601284, 624111, 828283, 789297, 819592, 789332, 819550, 505935, 789252, 417163, 789278, 789316, 525228, 548052, 789321, 467209, 467218, 520000, 467223, 550453, 467160, 467169, 467200, 466694, 505494, 505501, 467208, 467296, 524017, 558307, 560525, 584890, 590224, 789310, 467285, 467173, 501442, 467166, 465092, 467214, 504552, 558273, 574756, 561354, 662390, 597583, 502562, 528000, 569832, 547823, 549575, 562891, 599252, 501198, 467163, 567329, 587133, 601478, 550452, 467162, 601273, 611984, 607387, 605586, 611900, 624428);

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
  417163
  465092
  466694
  467160
  467162
  467163
  467166
  467169
  467173
  467200
  467208
  467209
  467214
  467218
  467223
  467285
  467296
  501198
  501442
  502562
  504552
  505494
  505501
  505935
  520000
  524017
  525228
  528000
  547823
  548052
  549575
  550452
  550453
  556320
  558273
  558307
  560525
  561354
  561369
  562891
  567329
  569832
  574756
  584890
  586378
  587133
  590224
  596227
  597583
  599252
  601273
  601284
  601478
  601707
  603970
  605586
  607387
  611900
  611984
  624111
  624428
  662390
  744912
  789252
  789278
  789297
  789310
  789316
  789321
  789332
  819550
  819592
  828283
]

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 (417163, 465092, 466694, 467160, 467162, 467163, 467166, 467169, 467173, 467200, 467208, 467209, 467214, 467218, 467223, 467285, 467296, 501198, 501442, 502562, 504552, 505494, 505501, 505935, 520000, 524017, 525228, 528000, 547823, 548052, 549575, 550452, 550453, 556320, 558273, 558307, 560525, 561354, 561369, 562891, 567329, 569832, 574756, 584890, 586378, 587133, 590224, 596227, 597583, 599252, 601273, 601284, 601478, 601707, 603970, 605586, 607387, 611900, 611984, 624111, 624428, 662390, 744912, 789252, 789278, 789297, 789310, 789316, 789321, 789332, 819550, 819592, 828283);

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
  417163
  465092
  466694
  467160
  467162
  467163
  467166
  467169
  467173
  467200
  467208
  467209
  467214
  467218
  467223
  467285
  467296
  501198
  501442
  502562
  504552
  505494
  505501
  505935
  520000
  524017
  525228
  528000
  547823
  548052
  549575
  550452
  550453
  556320
  558273
  558307
  560525
  561354
  561369
  562891
  567329
  569832
  574756
  584890
  586378
  587133
  590224
  596227
  597583
  599252
  601273
  601284
  601478
  601707
  603970
  605586
  607387
  611900
  611984
  624111
  624428
  662390
  744912
  789252
  789278
  789297
  789310
  789316
  789321
  789332
  819550
  819592
  828283
]

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 (417163, 465092, 466694, 467160, 467162, 467163, 467166, 467169, 467173, 467200, 467208, 467209, 467214, 467218, 467223, 467285, 467296, 501198, 501442, 502562, 504552, 505494, 505501, 505935, 520000, 524017, 525228, 528000, 547823, 548052, 549575, 550452, 550453, 556320, 558273, 558307, 560525, 561354, 561369, 562891, 567329, 569832, 574756, 584890, 586378, 587133, 590224, 596227, 597583, 599252, 601273, 601284, 601478, 601707, 603970, 605586, 607387, 611900, 611984, 624111, 624428, 662390, 744912, 789252, 789278, 789297, 789310, 789316, 789321, 789332, 819550, 819592, 828283);

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

[
  "vip4k"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'vip4k';

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

[
  "vip4k"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'vip4k';

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 ?

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